Updateable Columns List

The underlying Oracle web service allows update to the following fields:

Current Columns

Header Lines

Supplier *
Supplier Site *
Supplier Contact
Descriptive Flexfields
Attachments*
Description
Required Acknowledgement & Ack. within Days
Communication Method, Email, Fax
Default Ship-to Location
Bill-to Location
Buyer
Currency
Conversion Rate Type, Conversion Rate Date & Conversion Rate
Pay On Receipt
Payment Terms
Freight Terms
FOB
Carrier, Mode of Transport & Service Level
Note to Receiver
Note to Suppler
Supplier Order
Confirming Order

Item
Line Description
Quantity
Price
Amount
Supplier Item
Base Price
Negotiated Flag
Descriptive Flexfields
Attachments*
Note to Supplier
Line Number
Category
UOM

*Not applicable for Open orders. Open status includes Closed, Closed for Receiving, Closed for Invoicing and On Hold

Schedules Distributions

Promised Delivery Date
Promised Ship Date
Requested Delivery Date
Requested Ship Date
Descriptive Flexfields
Attachments*
Note to Receiver
Ship-to Location
Schedule Number
Receipt Routing
Allow Substitute Receipts Flag
Accrue At Receipt Flag
Invoice Close Tolerance Percent
Receipt Close Tolerance Percent
Invoice Match Option
Match Approval Level
Supplier Order Line Number
Carrier, Mode of Transport & Service Level
Early Receipt Tolerance in Days, and
Late Receipt Tolerance in Days
Over Receipt Tolerance & Over Receipt Action
Receipt Date Exception Action, and
Ship To Exception Action

Destination Charge Account
Project Flexfields
Budget Date
Descriptive Flexfields
Requester
Deliver-to Location
Distribution Number

*Not applicable for Open orders. Open status includes Closed, Closed for Receiving, Closed for Invoicing and On Hold

Not all the columns listed are currently available in our integrator. This is a list of all possible updates the REST web service will support. We plan to expand our columns over time and meet customer requirements.
Ship-to location updates that don’t involve updating the ship to organization are supported. Ship to organization updates are not allowed once a schedule is saved and that’s true both for the UI as well as any REST API.
If you need to update any other values, the purchase order will need to be cancelled and re-created with new values.

To cancel purchase orders using Excel refer to Cancel Purchase Orders Integrator.

Future Updatable Columns List

The underlying Oracle web service allows update to the following fields, which will be added to our integrator in the future:

Header Lines

Requires Signature
Master Contract
Overriding Approver
U.S. Federal attributes
Override B2B Communication Flag
Additional contact email
Cc & Bcc
Buyer Email

Pricing UOM
Discount
Discount Type
Reason
Source Agreement Procurement BU
Agreement
Agreement Line
Maximum Retainage Amount
UN Number
Hazard Class
Schedules Distributions

Retainage Rate
Country of Origin

Purchase Order Charge Account
Conversion Rate
Conversion Rate Date