Order Line Export
Export of these records is included as a Standard CSV Export.
Order Line
Field Name | Description | Field Type | Required/Unique | Possible Values |
type | Indicates record type | No/No | ||
accounting-total | Accounting Total for Line | decimal(32,4) | No/No | |
accounting-total-currency | Currency used for Accounting Total | No/No | ||
created-at | Line Created At Date | datetime | No/No | |
description | Line Item Description | string(255) | Yes/No | |
id | Coupa Internal Line ID | integer | No/No | |
invoiced | Amount Invoiced | decimal(32,6) | No/No | |
active-invoiced-amount | Active Invoiced Amount which includes Pending Approval and Approved Invoices | No/No | ||
line-number | Line Number | string(255) | No/Yes | |
need-by-date | Line Need By Date | string | No/No | |
order-header-id | PO Number / Coupa Internal ID | integer | No/No | |
price | Unit Price | decimal(30,6) | Yes/No | |
quantity | Quantity Ordered | decimal(30,6) | No/No | |
received | Quantity/Amount Received | integer | No/No | |
source-part-num | Part 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 Number | string(255) | No/No | |
status | Line Status | string(50) | No/No | |
sub-line-num | <Reserved for future use> | integer | No/No | |
supp-aux-part-num | Supplier Auxiliary Part Number (Punch Out) | text | No/No | |
total | Total Amount | decimal(32,4) | No/No | |
currency | Currency used for PO | No/No | ||
line-type | Line Type | string(100) | No/No | |
updated-at | Date Line Last Updated | datetime | No/No | |
version | Line Version/Revision # | integer | No/No | |
account-code | Account Code (combined segments) | No/No | ||
segment-1 | Account Code Segment 1 | No/No | ||
segment-2 | Account Code Segment 2 | No/No | ||
segment-3 | Account Code Segment 3 | No/No | ||
segment-4 | Account Code Segment 4 | No/No | ||
segment-5 | Account Code Segment 5 | No/No | ||
segment-6 | Account Code Segment 6 | No/No | ||
segment-7 | Account Code Segment 7 | No/No | ||
segment-8 | Account Code Segment 8 | No/No | ||
segment-9 | Account Code Segment 9 | No/No | ||
segment-10 | Account Code Segment 10 | No/No | ||
segment-11 | Account Code Segment 11 | No/No | ||
segment-12 | Account Code Segment 12 | No/No | ||
segment-13 | Account Code Segment 13 | No/No | ||
segment-14 | Account Code Segment 14 | No/No | ||
segment-15 | Account Code Segment 15 | No/No | ||
segment-16 | Account Code Segment 16 | No/No | ||
segment-17 | Account Code Segment 17 | No/No | ||
segment-18 | Account Code Segment 18 | No/No | ||
segment-19 | Account Code Segment 19 | No/No | ||
segment-20 | Account Code Segment 20 | No/No | ||
account-name | Account Name | No/No | ||
account-type | Chart of Accounts | No/No | ||
contract-id | Coupa Contract Internal ID | integer | No/No | |
contract-name | Contract Name | No/No | ||
department | Department Name | No/No | ||
created-by-email | Email of User who created order line | No/No | ||
created-by-employee-number | Employee Number of User who created order line | No/No | ||
created-by-firstname | First name of User who created order line | No/No | ||
created-by-id | Coupa ID of User who created order line | integer | No/No | |
created-by-lastname | Last name of User who created order line | No/No | ||
created-by-login | Login name of User who created order line | No/No | ||
supplier-id | Supplier Coupa internal ID number | integer | No/No | |
supplier-name | Supplier Name | No/No | ||
supplier-number | Supplier Number | No/No | ||
uom | Unit of Measure | No/No | ||
updated-by-email | Email of User last updated by | No/No | ||
updated-by-employee-number | Employee Number of User last updated by | No/No | ||
updated-by-firstname | First name of User last updated by | No/No | ||
updated-by-id | Coupa ID of User last updated by | integer | No/No | |
updated-by-lastname | Last name of User last updated by | No/No | ||
updated-by-login | Login name of User last updated by | No/No | ||
commodity | commodity | No/No |
Order Line Allocation
Field Name | Description | Field Type | Required/Unique | Possible Values |
type | Indicates record type | No/No | ||
order-header-id | PO Number / Coupa Internal ID | integer | No/No | |
order-line-id | Coupa Purchase Order Line ID | integer | No/No | |
order-line-num | Coupa Purchase Order Line Number | No/No | ||
account-allocation-id | Unique allocation id (only used if split line accounting is in use for the given Line record) | integer | No/No | |
account-allocation-sequence | Unique allocation sequential counter (only used if split line accounting is in use for the given Line record) | No/No | ||
account-allocation-amount | Dollar 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-percent | Amount allocation percent (only used if split line accounting is in use for the given Line record) | decimal(16,10) | Yes/No | |
account-code | Account code from Coupa (only used if split line accounting is in use for the given Line record) | No/No | ||
account-active | Account active flag | No/No | ||
segment-1 | Account Segment-1 | No/No | ||
segment-2 | Account Segment-2 | No/No | ||
segment-3 | Account Segment-3 | No/No | ||
segment-4 | Account Segment-4 | No/No | ||
segment-5 | Account Segment-5 | No/No | ||
segment-6 | Account Segment-6 | No/No | ||
segment-7 | Account Segment-7 | No/No | ||
segment-8 | Account Ssegment-8 | No/No | ||
segment-9 | Account Segment-9 | No/No | ||
segment-10 | Account Segment-10 | No/No | ||
segment-11 | Account Segment-11 | No/No | ||
segment-12 | Account Segment-12 | No/No | ||
segment-13 | Account Segment-13 | No/No | ||
segment-14 | Account Segment-14 | No/No | ||
segment-15 | Account Ssegment-15 | No/No | ||
segment-16 | Account Segment-16 | No/No | ||
segment-17 | Account Segment-17 | No/No | ||
segment-18 | Account Segment-18 | No/No | ||
segment-19 | Account Segment-19 | No/No | ||
segment-20 | Account Segment-20 | No/No | ||
account-name | Account name from Coupa | No/No | ||
account-type | Chart of Accounts Name from Coupa | No/No |
Order Line Confirmation
Field Name | Description | Field Type | Required/Unique | Possible Values |
type | Indicates record type | No/No | ||
id | Coupa's internal ID | integer | No/No | |
status | PO Line Confirmation Status | string(255) | No/No | |
confirm-by-hrs | Confirm By Hours | decimal(10,0) | No/No | |
quantity | Quantity | decimal(30,6) | No/No | |
price | Price | decimal(30,6) | No/No | |
currency-id | Currency | integer | No/No | |
order-line-id | Coupa's internal ID | integer | No/No | |
order-line-version-id | Coupa's internal ID | integer | No/No | |
Promised Date | Promised Date | datetime | No/No | |
order_header_confirmation_id | Coupa's internal ID | integer | No/No | |
can-fulfill | Is supplier can fulfill the order? | integer | No/No | |
proposed_by | Proposed by | string(255) | No/No | |
created-at | Created Date | datetime | No/No | |
updated-at | Last Updated at Date | datetime | No/No | |
description | Line Item Description | string(255) | No/No | |
uom | Unit of Measure | No/No | ||
supplier-part-number | Supplier Part Number | string(255) | No/No | |
supplier-auxiliary-part-number | Supplier Auxiliary Part Number | string(255) | No/No | |
manufacturer-name | Manufacturer Name | string(255) | No/No | |
manufacturer-part-number | Manufacturer Part Number | string(255) | No/No | |
item-record-match-found | Item Record Match Found | No/No | ||
item-change | Item Change | boolean | No/No | |
acted-on-behalf-of-supplier | Acted On Behalf Of Supplier | boolean | No/No | |
tags | Tags | Tag | No/No |