Order Line Export

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

Order Line

Field NameDescriptionField TypeRequired/UniquePossible Values
typeIndicates record typeNo/No
accounting-totalAccounting Total for Linedecimal(32,4)No/No
accounting-total-currencyCurrency used for Accounting TotalNo/No
created-atLine Created At DatedatetimeNo/No
descriptionLine Item Descriptionstring(255)Yes/No
idCoupa Internal Line IDintegerNo/No
invoicedAmount Invoiceddecimal(32,6)No/No
active-invoiced-amountActive Invoiced Amount which includes Pending Approval and Approved InvoicesNo/No
line-numberLine Numberstring(255)No/Yes
need-by-dateLine Need By DatestringNo/No
order-header-idPO Number / Coupa Internal IDintegerNo/No
priceUnit Pricedecimal(30,6)Yes/No
quantityQuantity Ordereddecimal(30,6)No/No
receivedQuantity/Amount ReceivedintegerNo/No
source-part-numPart Number - Determined by: For Catalog Items: Supplier Item Number For Catalog Item w/o Supplier Item Number: Item Number Non-Catalog Item: User Entered Item Numberstring(255)No/No
statusLine Statusstring(50)No/No
sub-line-num<Reserved for future use>integerNo/No
supp-aux-part-numSupplier Auxiliary Part Number (Punch Out)textNo/No
totalTotal Amountdecimal(32,4)No/No
currencyCurrency used for PONo/No
line-typeLine Typestring(100)No/No
updated-atDate Line Last UpdateddatetimeNo/No
versionLine Version/Revision #integerNo/No
account-codeAccount Code (combined segments)No/No
segment-1Account Code Segment 1No/No
segment-2Account Code Segment 2No/No
segment-3Account Code Segment 3No/No
segment-4Account Code Segment 4No/No
segment-5Account Code Segment 5No/No
segment-6Account Code Segment 6No/No
segment-7Account Code Segment 7No/No
segment-8Account Code Segment 8No/No
segment-9Account Code Segment 9No/No
segment-10Account Code Segment 10No/No
segment-11Account Code Segment 11No/No
segment-12Account Code Segment 12No/No
segment-13Account Code Segment 13No/No
segment-14Account Code Segment 14No/No
segment-15Account Code Segment 15No/No
segment-16Account Code Segment 16No/No
segment-17Account Code Segment 17No/No
segment-18Account Code Segment 18No/No
segment-19Account Code Segment 19No/No
segment-20Account Code Segment 20No/No
account-nameAccount NameNo/No
account-typeChart of AccountsNo/No
contract-idCoupa Contract Internal IDintegerNo/No
contract-nameContract NameNo/No
departmentDepartment NameNo/No
created-by-emailEmail of User who created order lineNo/No
created-by-employee-numberEmployee Number of User who created order lineNo/No
created-by-firstnameFirst name of User who created order lineNo/No
created-by-idCoupa ID of User who created order lineintegerNo/No
created-by-lastnameLast name of User who created order lineNo/No
created-by-loginLogin name of User who created order lineNo/No
supplier-idSupplier Coupa internal ID numberintegerNo/No
supplier-nameSupplier NameNo/No
supplier-numberSupplier NumberNo/No
uomUnit of MeasureNo/No
updated-by-emailEmail of User last updated byNo/No
updated-by-employee-numberEmployee Number of User last updated byNo/No
updated-by-firstnameFirst name of User last updated byNo/No
updated-by-idCoupa ID of User last updated byintegerNo/No
updated-by-lastnameLast name of User last updated byNo/No
updated-by-loginLogin name of User last updated byNo/No
commoditycommodityNo/No
asn-quantityASN Quantitydecimal(30,6)No/No

Order Line Allocation

Field NameDescriptionField TypeRequired/UniquePossible Values
typeIndicates record typeNo/No
order-header-idPO Number / Coupa Internal IDintegerNo/No
order-line-idCoupa Purchase Order Line IDintegerNo/No
order-line-numCoupa Purchase Order Line NumberNo/No
account-allocation-idUnique allocation id (only used if split line accounting is in use for the given Line record)integerNo/No
account-allocation-sequenceUnique allocation sequential counter (only used if split line accounting is in use for the given Line record)No/No
account-allocation-amountDollar amount for this allocation (only used if split line accounting is in use for the given Line record)decimal(32,4)No/No
account-allocation-percentAmount allocation percent (only used if split line accounting is in use for the given Line record)decimal(16,10)Yes/No
account-codeAccount code from Coupa (only used if split line accounting is in use for the given Line record)No/No
account-activeAccount active flagNo/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 Ssegment-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 Ssegment-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
account-nameAccount name from CoupaNo/No
account-typeChart of Accounts Name from CoupaNo/No

Order Line Confirmation

Field NameDescriptionField TypeRequired/UniquePossible Values
typeIndicates record typeNo/No
idCoupa's internal IDintegerNo/No
statusPO Line Confirmation Statusstring(255)No/No
confirm-by-hrsConfirm By Hoursdecimal(10,0)No/No
quantityQuantityNo/No
pricePriceNo/No
currency-idCurrencyNo/No
order-line-idCoupa's internal IDintegerNo/No
order-line-version-idCoupa's internal IDintegerNo/No
Promised DatePromised DateNo/No
order_header_confirmation_idCoupa's internal IDintegerNo/No
can-fulfillIs supplier can fulfill the order?integerNo/No
proposed_byProposed bystring(255)No/No
created-atCreated DatedatetimeNo/No
updated-atLast Updated at DatedatetimeNo/No
descriptionLine Item DescriptionNo/No
uomUnit of MeasureNo/No
supplier-part-numberSupplier Part NumberNo/No
supplier-auxiliary-part-numberSupplier Auxiliary Part NumberNo/No
manufacturer-nameManufacturer NameNo/No
manufacturer-part-numberManufacturer Part NumberNo/No
item-record-match-foundItem Record Match FoundNo/No
item-changeItem ChangeNo/No
acted-on-behalf-of-supplierActed On Behalf Of SupplierNo/No
tagsTagsTagNo/No
locked-for-integration-atLocked For Integration AtdatetimeNo/No
integration-versionIntegration VersionintegerNo/No
custom-field-1Custom Field 1No/No
custom-field-2Custom Field 2No/No
custom-field-3Custom Field 3No/No
custom-field-4Custom Field 4No/No
custom-field-5Custom Field 5No/No
custom-field-6Custom Field 6No/No
custom-field-7Custom Field 7No/No
custom-field-8Custom Field 8No/No
custom-field-9Custom Field 9No/No
custom-field-10Custom Field 10No/No
custom-field-11Custom Field 11No/No
custom-field-12Custom Field 12No/No
custom-field-13Custom Field 13No/No
custom-field-14Custom Field 14No/No
custom-field-15Custom Field 15No/No
custom-field-16Custom Field 16No/No
custom-field-17Custom Field 17No/No
custom-field-18Custom Field 18No/No
custom-field-19Custom Field 19No/No
custom-field-20Custom Field 20No/No