Purchase Order Change Import
The purchase order change integration loader uses only a single set of header columns.
Note
If using CSP, add the following columns at the header level after downloading the template:
- Column 1: Reason Code
- Allowable values:
- Cannot fulfill order quantity/amount
- The ordered item is no longer available
- Cannot fulfill orders by the Need-by-date
- Other
- Other reasons codes configured in reason insights
- Allowable values:
- Column 2: Reason comment
- This column is needed only if the Reason code is Other
- Acceptable values: Any text string
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Header | Header | No | No | ||
| Action | Action | Yes | No | text | submit, cancel, withdraw |
| Order Header ID | Order Header ID | No | No | integer | any |
| Currency Code | Currency Code | No | No | text | Code of one of the enabled currencies |
| Payment Method | Payment Method | No | No | string(255) | |
| Payment Term Code | Payment Term Code | No | No | string(255) | |
| PCard Name | PCard Name | No | No | string | Name of the Pcard |
| Hide Price | Hide Price | No | No | boolean | |
| Shipping Term Code | Shipping Term Code | No | No | string | One of the shipping terms on the Setup > Financial Setup > Shipping Terms page |
| Ship To Location Code | Ship To Location Code | No | No | string | |
| Ship To Attention | Ship To Attention | No | No | string(255) | |
| Ship To Email | Ship To Email | No | No | string | |
| Ship To Login | Ship To Login | No | No | string | |
| Supplier Name | Supplier Name | No | No | string | |
| Supplier Number | Supplier Number | No | No | string | |
| Supplier Site Code | Supplier Site Code | No | No | string | |
| Transmission Emails | Transmission Emails | No | No | text | |
| Transmission Method Override | Transmission Method Override | Yes | No | string(30) | supplier_default, email, do_not_transmit |
| Department Name | Department Name | No | No | ||
| Line | Line | No | No | ||
| Action | Intended change on the PO line | No | No | string | Create, Update, Delete. Leaving it blank creates or updates a line |
| Line Number | Line Number | No | No | integer | |
| Chart of Account Name | Chart of Account Name | No | No | string | |
| Account Code | Account Code | No | No | string | |
| Account Name | Account Name | No | No | string | |
| Account Segment 1 | Account Segment 1 | No | No | string | |
| Account Segment 2 | Account Segment 2 | No | No | string | |
| Account Segment 3 | Account Segment 3 | No | No | string | |
| Account Segment 4 | Account Segment 4 | No | No | string | |
| Account Segment 5 | Account Segment 5 | No | No | string | |
| Account Segment 6 | Account Segment 6 | No | No | string | |
| Account Segment 7 | Account Segment 7 | No | No | string | |
| Account Segment 8 | Account Segment 8 | No | No | string | |
| Account Segment 9 | Account Segment 9 | No | No | string | |
| Account Segment 10 | Account Segment 10 | No | No | string | |
| Account Segment 11 | Account Segment 11 | No | No | string | |
| Account Segment 12 | Account Segment 12 | No | No | string | |
| Account Segment 13 | Account Segment 13 | No | No | string | |
| Account Segment 14 | Account Segment 14 | No | No | string | |
| Account Segment 15 | Account Segment 15 | No | No | string | |
| Account Segment 16 | Account Segment 16 | No | No | string | |
| Account Segment 17 | Account Segment 17 | No | No | string | |
| Account Segment 18 | Account Segment 18 | No | No | string | |
| Account Segment 19 | Account Segment 19 | No | No | string | |
| Account Segment 20 | Account Segment 20 | No | No | string | |
| Budget Period Name | Budget Period Name | No | No | string | |
| Catalog Item Name | Catalog Item Name | No | No | string | |
| Catalog Item Number | Catalog Item Number | No | No | string | |
| Commodity Name | Commodity Name | No | No | string | |
| Contract Name | Contract Name | No | No | string | |
| Contract Number | Contract Number | No | No | string | |
| Manufacturer Name | Manufacturer Name | No | No | string | |
| Manufacturer Part Number | Manufacturer Part Number | No | No | string | |
| Need By Date | Need By Date | No | No | date | |
| Non Catalog Item Description | Non Catalog Item Description | No | No | string | |
| Price | Price | No | No | decimal | |
| Quantity | Quantity | No | No | decimal | |
| Savings Pct | Savings Pct | No | No | decimal | |
| Supplier Aux Part Number | Supplier Aux Part Number | No | No | ||
| Supplier Part Number | Supplier Part Number | No | No | string | |
| UOM Code | UOM Code | No | No | string | |
| Account Allocation | Account Allocation | No | No | ||
| Amount | Amount | No | No | decimal | |
| Percent | Percent | No | No | decimal | |
| Payment Agreement | Payment Agreement | No | No | ||
| Record Identifier | Record Identifier | No | No | ||
| Type | Type | No | No | string | |
| Recurring | Recurring | No | No | ||
| Amount Type | Amount Type | No | No | ||
| Description | Description | No | No | ||
| Due Date | Due Date | No | No | date | |
| Start Date | Start Date | No | No | date | |
| End Date | End Date | No | No | date | |
| Frequency | Frequency | No | No | ||
| Interval | Interval | No | No |
Note
The PO change CSV loader is available for only item lines at this time. Service lines are not currently supported.