Purchase Orders Export
Coupa's purchase order flat file integration object contains header columns, line columns, and line allocation columns.
Overview
The Purchase Order Export process from Coupa uses the Coupa API to query for all Purchase Orders that are issued and have not been exported. The frequency of the integration run is once every hour. The generated files will be placed into ./Outgoing/PurchaseOrders. Once the files are successfully placed into the sFTP folder the purchase orders will be marked as exported.
Purchase Order Revisions can also be exported and will be placed into ./Outgoing/PurchaseOrders/. Export of these records is included as a Standard CSV Export.
Coupa generally recommends that customers send POs to suppliers from the Coupa system, rather than issuing POs to suppliers from their ERP system. PO exports from Coupa are therefore generally done for purposes of reporting and analytics.
Purchase order line columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| type | Indicates record type | FALSE | FALSE | string | Line |
| accounting-total | Accounting Total for Line | FALSE | FALSE | decimal(32,4) | any |
| accounting-total-currency | Currency used for Accounting Total | FALSE | FALSE | string(6) | any |
| created-at | Line Created At Date | FALSE | FALSE | datetime | any |
| description | Line Item Description | TRUE | FALSE | string(255) | any |
| id | Coupa Internal Line ID | FALSE | FALSE | integer | any |
| invoiced | Amount Invoiced | FALSE | FALSE | decimal(30,6) | any |
| active-invoiced-amount | Active Invoiced Amount which includes Pending Approval and Approved Invoices | FALSE | FALSE | decimal(32,4) | any |
| line-number | Line Number | FALSE | TRUE | string(255) | any |
| need-by-date | Line Need By Date | FALSE | FALSE | datetime | any |
| order-header-id | PO Number / Coupa Internal ID | FALSE | FALSE | integer | any |
| price |
Unit Price Note
For languages that use spaces as a currency delimiter, the CSV export interprets the space as: |
TRUE | FALSE | decimal(30,6) | any |
| quantity | Quantity Ordered | FALSE | FALSE | decimal(30,6) | any |
| received | Quantity/Amount Received | FALSE | FALSE | decimal(32,4) | any |
| 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 | FALSE | FALSE | string(255) | any |
| status | Line Status | FALSE | FALSE | string(50) | any |
| sub-line-num | <Reserved for future use> | FALSE | FALSE | integer | any |
| supp-aux-part-num | Supplier Auxiliary Part Number (Punch Out) | FALSE | FALSE | string(255) | any |
| total | Total Amount | FALSE | FALSE | decimal(32,4) | any |
| currency | Currency used for PO | FALSE | FALSE | string(6) | any |
| type | Line Type | FALSE | FALSE | string(100) | any |
| updated-at | Date Line Last Updated | FALSE | FALSE | datetime | any |
| version | Line Version/Revision # | FALSE | FALSE | int(11) | any |
| account-code | Account Code (combined segments) | FALSE | FALSE | string(1024) | any |
| segment-1 | Account Code Segment 1 | FALSE | FALSE | string(100) | any |
| segment-2 | Account Code Segment 2 | FALSE | FALSE | string(100) | any |
| segment-3 | Account Code Segment 3 | FALSE | FALSE | string(100) | any |
| segment-4 | Account Code Segment 4 | FALSE | FALSE | string(100) | any |
| segment-5 | Account Code Segment 5 | FALSE | FALSE | string(100) | any |
| segment-6 | Account Code Segment 6 | FALSE | FALSE | string(100) | any |
| segment-7 | Account Code Segment 7 | FALSE | FALSE | string(100) | any |
| segment-8 | Account Code Segment 8 | FALSE | FALSE | string(100) | any |
| segment-9 | Account Code Segment 9 | FALSE | FALSE | string(100) | any |
| segment-10 | Account Code Segment 10 | FALSE | FALSE | string(100) | any |
| segment-11 | Account Code Segment 11 | FALSE | FALSE | string(100) | any |
| segment-12 | Account Code Segment 12 | FALSE | FALSE | string(100) | any |
| segment-13 | Account Code Segment 13 | FALSE | FALSE | string(100) | any |
| segment-14 | Account Code Segment 14 | FALSE | FALSE | string(100) | any |
| segment-15 | Account Code Segment 15 | FALSE | FALSE | string(100) | any |
| segment-16 | Account Code Segment 16 | FALSE | FALSE | string(100) | any |
| segment-17 | Account Code Segment 17 | FALSE | FALSE | string(100) | any |
| segment-18 | Account Code Segment 18 | FALSE | FALSE | string(100) | any |
| segment-19 | Account Code Segment 19 | FALSE | FALSE | string(100) | any |
| segment-20 | Account Code Segment 20 | FALSE | FALSE | string(100) | any |
| account-name | Account Name | FALSE | FALSE | string(1024) | any |
| account-type | Chart of Accounts | FALSE | FALSE | string(50) | any |
| contract-id | Coupa Contract Internal ID | FALSE | FALSE | integer | any |
| contract-name | Contract Name | FALSE | FALSE | string(100) | any |
| department | Department Name | FALSE | FALSE | string(255) | any |
| created-by-email | Email of User who created PO | FALSE | FALSE | string(255) | any |
| created-by-employee-number | Employee Number of User who created PO | FALSE | FALSE | string(255) | any |
| created-by-firstname | First name of User who created PO | FALSE | FALSE | string(40) | any |
| created-by-id | Coupa ID of User who created PO | FALSE | FALSE | int(11) | any |
| created-by-lastname | Last name of User who created PO | FALSE | FALSE | string(40) | any |
| created-by-login | Login name of User who created PO | FALSE | FALSE | string(255) | any |
| supplier-id | Supplier Coupa internal ID number | FALSE | FALSE | integer | any |
| supplier-name | Supplier Name | FALSE | FALSE | string(100) | any |
| supplier-number | Supplier Number | FALSE | FALSE | string(255) | any |
| uom | Unit of Measure | FALSE | FALSE | string(6) | any |
| updated-by-email | Email of User last updated by | FALSE | FALSE | string(255) | any |
| updated-by-employee-number | Employee Number of User last updated by | FALSE | FALSE | string(255) | any |
| updated-by-firstname | First name of User last updated by | FALSE | FALSE | string(40) | any |
| updated-by-id | Coupa ID of User last updated by | FALSE | FALSE | Int(11) | any |
| updated-by-lastname | Last name of User last updated by | FALSE | FALSE | string(40) | any |
| updated-by-login | Login name of User last updated by | FALSE | FALSE | string(255) | any |
| commodity | commodity | FALSE | FALSE | string(255) | any |
| requisition-line | Requisition Line ID | FALSE | FALSE | RequisitionLine | any |
| custom-field-1 | Integration Custom Field 1 | FALSE | FALSE | string(255) | any |
| custom-field-2 | Integration Custom Field 2 | FALSE | FALSE | string(255) | any |
| custom-field-3 | Integration Custom Field 3 | FALSE | FALSE | string(255) | any |
| custom-field-4 | Integration Custom Field 4 | FALSE | FALSE | string(255) | any |
| custom-field-5 | Integration Custom Field 5 | FALSE | FALSE | string(255) | any |
| custom-field-6 | Integration Custom Field 6 | FALSE | FALSE | string(255) | any |
| custom-field-7 | Integration Custom Field 7 | FALSE | FALSE | string(255) | any |
| custom-field-8 | Integration Custom Field 8 | FALSE | FALSE | string(255) | any |
| custom-field-9 | Integration Custom Field 9 | FALSE | FALSE | string(255) | any |
| custom-field-10 | Integration Custom Field 10 | FALSE | FALSE | string(255) | any |
Purchase order line allocation columns
| Column Name | Description | Req | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| type | Indicates record type | FALSE | FALSE | any | |
| order-header-id | PO Number / Coupa Internal ID | FALSE | FALSE | integer(11) | any |
| order-line-id | Coupa Purchase Order Line ID | FALSE | FALSE | integer(11) | any |
| order-line-num | Coupa Purchase Order Line Number | FALSE | FALSE | string(255) | any |
| account-allocation-id | Unique allocation id (only used if split line accounting is in use for the given Line record) | FALSE | FALSE | integer(11) | any |
| account-allocation-sequence | Unique allocation sequential counter (only used if split line accounting is in use for the given Line record) | FALSE | FALSE | integer(11) | any |
| account-allocation-amount | Dollar amount for this allocation (only used if split line accounting is in use for the given Line record) | FALSE | FALSE | decimal(32,4) | any |
| account-allocation-percent | Amount allocation percent (only used if split line accounting is in use for the given Line record) | TRUE | FALSE | decimal(16,10) | any |
| account-code | Account code from Coupa (only used if split line accounting is in use for the given Line record) | FALSE | FALSE | string(1024) | any |
| account-active | Account active flag | FALSE | FALSE | integer(1) | any |
| segment-1 | Account Segment-1 | FALSE | FALSE | string(100) | any |
| segment-2 | Account Segment-2 | FALSE | FALSE | string(100) | any |
| segment-3 | Account Segment-3 | FALSE | FALSE | string(100) | any |
| segment-4 | Account Segment-4 | FALSE | FALSE | string(100) | any |
| segment-5 | Account Segment-5 | FALSE | FALSE | string(100) | any |
| segment-6 | Account Segment-6 | FALSE | FALSE | string(100) | any |
| segment-7 | Account Segment-7 | FALSE | FALSE | string(100) | any |
| segment-8 | Account Ssegment-8 | FALSE | FALSE | string(100) | any |
| segment-9 | Account Segment-9 | FALSE | FALSE | string(100) | any |
| segment-10 | Account Segment-10 | FALSE | FALSE | string(100) | any |
| segment-11 | Account Segment-11 | FALSE | FALSE | string(100) | any |
| segment-12 | Account Segment-12 | FALSE | FALSE | string(100) | any |
| segment-13 | Account Segment-13 | FALSE | FALSE | string(100) | any |
| segment-14 | Account Segment-14 | FALSE | FALSE | string(100) | any |
| segment-15 | Account Ssegment-15 | FALSE | FALSE | string(100) | any |
| segment-16 | Account Segment-16 | FALSE | FALSE | string(100) | any |
| segment-17 | Account Segment-17 | FALSE | FALSE | string(100) | any |
| segment-18 | Account Segment-18 | FALSE | FALSE | string(100) | any |
| segment-19 | Account Segment-19 | FALSE | FALSE | string(100) | any |
| segment-20 | Account Segment-20 | FALSE | FALSE | string(100) | any |
| account-name | Account name from Coupa | FALSE | FALSE | string(1024) | any |
| account-type | Chart of Accounts Name from Coupa | FALSE | FALSE | string(50) | any |
| custom-field-1 | Integration Custom Field 1 | FALSE | FALSE | string(255) | any |
| custom-field-2 | Integration Custom Field 2 | FALSE | FALSE | string(255) | any |
| custom-field-3 | Integration Custom Field 3 | FALSE | FALSE | string(255) | any |
| custom-field-4 | Integration Custom Field 4 | FALSE | FALSE | string(255) | any |
| custom-field-5 | Integration Custom Field 5 | FALSE | FALSE | string(255) | any |
| custom-field-6 | Integration Custom Field 6 | FALSE | FALSE | string(255) | any |
| custom-field-7 | Integration Custom Field 7 | FALSE | FALSE | string(255) | any |
| custom-field-8 | Integration Custom Field 8 | FALSE | FALSE | string(255) | any |
| custom-field-9 | Integration Custom Field 9 | FALSE | FALSE | string(255) | any |
| custom-field-10 | Integration Custom Field 10 | FALSE | FALSE | string(255) | any |