| 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 |
|
