Purchase Order Change Import

Note:

If using CSP, add the following columns at the header level after downloading the template:

  1. 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
  2. Column 2: Reason comment
    • This column is needed only if the Reason code is Other
    • Acceptable values: Any text string

Possible values

Action
Create, Update, Delete. Leaving this field blank creates or updates a line.
Shipping Term Code
One of the shipping terms on the Setup > Financial Setup > Shipping Terms page

Purchase Order Change

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
HeaderNoNoHeader
ActionNoNoAction
Order Header IDNoNointegerOrder Header ID
Currency CodeNoNoCurrency Code
Payment MethodNoNostring(255)Payment Method
Payment Term CodeNoNoPayment Term Code
PCard NameNoNoPCard Name
Hide PriceNoNobooleanHide Price
Shipping Term CodeNoNoShipping Term Code
Ship To Location CodeNoNoShip To Location Code
Ship To AttentionNoNostring(255)Ship To Attention
Ship To EmailNoNoShip To Email
Ship To LoginNoNoShip To Login
Supplier NameNoNoSupplier Name
Supplier NumberNoNoSupplier Number
Supplier Site CodeNoNoSupplier Site Code
Transmission EmailsNoNotextTransmission Emails
Transmission Method OverrideNoYesstring(30)Transmission Method Overridesupplier_default, email, do_not_transmit
Department NameNoNoDepartment Name
LineNoNoLine
Line NumberNoNoLine Number
Chart of Account NameNoNoChart of Account Name
Account CodeNoNoAccount Code
Account NameNoNoAccount Name
Account Segment 1NoNoAccount Segment 1
Account Segment 2NoNoAccount Segment 2
Account Segment 3NoNoAccount Segment 3
Account Segment 4NoNoAccount Segment 4
Account Segment 5NoNoAccount Segment 5
Account Segment 6NoNoAccount Segment 6
Account Segment 7NoNoAccount Segment 7
Account Segment 8NoNoAccount Segment 8
Account Segment 9NoNoAccount Segment 9
Account Segment 10NoNoAccount Segment 10
Account Segment 11NoNoAccount Segment 11
Account Segment 12NoNoAccount Segment 12
Account Segment 13NoNoAccount Segment 13
Account Segment 14NoNoAccount Segment 14
Account Segment 15NoNoAccount Segment 15
Account Segment 16NoNoAccount Segment 16
Account Segment 17NoNoAccount Segment 17
Account Segment 18NoNoAccount Segment 18
Account Segment 19NoNoAccount Segment 19
Account Segment 20NoNoAccount Segment 20
Budget Period NameNoNoBudget Period Name
Catalog Item NameNoNoCatalog Item Name
Catalog Item NumberNoNoCatalog Item Number
Commodity NameNoNoCommodity Name
Contract NameNoNoContract Name
Contract NumberNoNoContract Number
Manufacturer NameNoNoManufacturer Name
Manufacturer Part NumberNoNoManufacturer Part Number
Need By DateNoNoNeed By Date
Non Catalog Item DescriptionNoNoNon Catalog Item Description
PriceNoNoPrice
QuantityNoNoQuantity
Savings PctNoNoSavings Pct
Supplier Aux Part NumberNoNoSupplier Aux Part Number
Supplier Part NumberNoNoSupplier Part Number
UOM CodeNoNoUOM Code
Account AllocationNoNoAccount Allocation
Estimated Tax AmountNoNoEstimated Tax Amount
PercentNoNoPercent
Payment AgreementNoNoPayment Agreement
Record IdentifierNoNoRecord Identifier
TypeNoNoType
Amount TypeNoNoAmount Type
DescriptionNoNoDescription
Due DateNoNoDue Date
Estimated Tax LineNoNoEstimated Tax Line
Tax Line NumberNoNoTax Line Number
Estimated Tax CodeNoNoEstimated Tax Code
Estimated Tax RateNoNoEstimated Tax Rate
Tax ReferenceNoNoTax Reference
Base AmountNoNoBase Amount
Product ClassificationNoNoProduct Classification
DeleteNoNoDelete
Note: The PO change CSV loader is available for only item lines at this time. Service lines are not currently supported.