Requisitions Export

Overview

The requisition export process from Coupa queries for all approved requisitions that have NOT been exported. The frequency of the integration run is once every hour. The generated files will be placed into ./Outgoing/Requisitions. Once the files are successfully placed into the sFTP folder the requisitions will be marked as exported.

Export of these records is included as a Standard CSV Export.

For languages that use spaces as a currency delimiter, the CSV export interprets the space as: “&nbsp

Requisition

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeIndicates record typeNo/No
Requisition IdCoupa Internal Requisition IDintegerNo/No
Submitted At DateDate the Requisition was SubmitteddatetimeNo/No
StatusRequisition Statusstring(50)Yes/No
Buyer NoteBuyer NotetextNo/No
JustificationJustification for requisitiontextNo/No
Reject Reasonrejection reasonNo/No
TotalTotal Amount for RequestdecimalNo/No
Currency Code3 digit Currency Code for TotalNo/No
Requested By Employee NumberEmployee Number of user who requisition is on behalf of cart/requisitionNo/No
Requested by LoginLogin of user who requisition is on behalf of cart/requisitionNo/No
Requested by EmailEmail of user who requisition is on behalf of cart/requisitionNo/No
DepartmentName of the Department for the requisitionNo/No
Ship To Address Street 1Ship To Address Street Line 1No/No
Ship To Address Street 2Ship To Address Street Line 2No/No
Ship To Address CityShip To Address CityNo/No
Ship To Address StateShip To Address State/ProvienceNo/No
Ship To Address Postal CodeShip To Address Postal CodeNo/No
Ship To Address Country CodeShip To Address Country CodeNo/No
Ship To Address AttentionShip To Address Attention FieldNo/No
Ship To Address IdShip To Address Internal Address IDintegerNo/No
Ship To Address NameShip To Address NameNo/No
Ship To Address Location CodeShip To Address Location CodeNo/No
DepartmentName of the Department for the requisitionNo/No
Created At DateDate the shopping cart/requisition was first createddatetimeNo/No
Updated At DateDate the requisition was last updateddatetimeNo/No
Approved By Employee NumberApproved By Employee NumbersNo/No
Approved by LoginApproved by LoginsNo/No
Approved by EmailApproved by EmailsNo/No
Created By Employee NumberEmployee Number of user who created cart/requisitionNo/No
Created by LoginLogin of user who created cart/requisitionNo/No
Created by EmailEmail of user who created cart/requisitionNo/No
Updated By Employee NumberEmployee Number of person who last updated the requisitionNo/No
Updated by LoginLogin of person who last updated the requisitionNo/No
Updated by EmailEmail of person who last updated the requisitionNo/No

Requisition Line

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeIndicates record typeNo/No
Requisition Header IdRequisition Header IdNo/No
Line NumberLine NumberintegerNo/No
DescriptionLine Descriptionstring(255)Yes/No
Item NameItem NameNo/No
Item NumberItem NumberNo/No
Supplier Auxiliary Part NumberSupplier Auxiliary Part NumbertextNo/No
Source Part NumberSource Part Numberstring(255)No/No
Need By DateNeed By DatedatetimeNo/No
PriceUnit Price of ItemdecimalNo/No
Total QuantityTotal Quantity Ordereddecimal(30,6)No/No
Line TotalLine Total Amountdecimal(32,4)No/No
Request TypeRequest TypestringNo/No
Currency CodeCurrency CodeNo/No
Supplier NumberSupplier NumberNo/No
Supplier NameSupplier NameNo/No
Payment TermsPayment Term CodeNo/No
Shipping TermsShipping Term CodeNo/No
Unit of MeasureUnit of MeasureNo/No
Assets TagsAssets TagsstringNo/No
Commodity NameCommodity NameNo/No
Chart of Account NameChart of Account NameNo/No
Account CodeAccount CodeNo/No
Account NameAccount NameNo/No
Segment 1Account Segment 1No/No
Segment 2Account Segment 2No/No
Segment 3Account Segment 3No/No
Segment 4Account Segment 4No/No
Segment 5Account Segment 5No/No
Segment 6Account Segment 6No/No
Segment 7Account Segment 7No/No
Segment 8Account Segment 8No/No
Segment 9Account Segment 9No/No
Segment 10Account Segment 10No/No
Segment 11Account Segment 11No/No
Segment 12Account Segment 12No/No
Segment 13Account Segment 13No/No
Segment 14Account Segment 14No/No
Segment 15Account Segment 15No/No
Segment 16Account Segment 16No/No
Segment 17Account Segment 17No/No
Segment 18Account Segment 18No/No
Segment 19Account Segment 19No/No
Segment 20Account Segment 20No/No
Created AtDate line was createddatetimeNo/No
Updated AtDate line was last updateddatetimeNo/No
Created By Employee NumberEmployee Number of user who created lineNo/No
Created by LoginLogin of user who created lineNo/No
Created by EmailEmail of user who created lineNo/No
Updated By Employee NumberEmployee Number of user who last updated lineNo/No
Updated by LoginLogin of user who last updated lineNo/No
Updated by Emailemail of user who last updated lineNo/No

Req Line Allocation

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeDescribes the type of row. Possible values are Header, Line, or Line Split.No/No
Requisition Header IDCoupa's Requisition Report IDintegerNo/No
Requsition Line IDCoupa's Requisition Report Line IDintegerNo/No
Requisition Line NumberRequisition Line NumberNo/No
Purchase Order Header NumberIf a PO was created, Coupa's Order Header NumberNo/No
Purchase Order Line IDIf a PO was created, Coupa's Order Line IDNo/No
Purchase Order Line NumberIf a PO was created, Coupa's Order Line NumberNo/No
Account Allocation IDAccount Allocation IDintegerNo/No
Allocation NumberPosition in the Account Allocation SequenceNo/No
Allocation AmountAmount allocated to the accountNo/No
Allocation PercentPercentage allocated to the accountNo/No
Account CodeThe whole account code of the accountNo/No
Account ActiveFlag indicating if the account is active. True or False.No/No
Account Segment 1Account Segment 1No/No
Account Segment 2Account Segment 2No/No
Account Segment 3Account Segment 3No/No
Account Segment 4Account Segment 4No/No
Account Segment 5Account Segment 5No/No
Account Segment 6Account Segment 6No/No
Account Segment 7Account Segment 7No/No
Account Segment 8Account Segment 8No/No
Account Segment 9Account Segment 9No/No
Account Segment 10Account Segment 10No/No
Account Segment 11Account Segment 11No/No
Account Segment 12Account Segment 12No/No
Account Segment 13Account Segment 13No/No
Account Segment 14Account Segment 14No/No
Account Segment 15Account Segment 15No/No
Account Segment 16Account Segment 16No/No
Account Segment 17Account Segment 17No/No
Account Segment 18Account Segment 18No/No
Account Segment 19Account Segment 19No/No
Account Segment 20Account Segment 20No/No
Account NameNickname for the accountNo/No
Currency CodeCurrency CodeNo/No

Requisition Event History

Field NameDescriptionField TypeRequired/UniquePossible Values