Order milestone - X12
See the document types that map to the Order milestone, as well as which EDI documents are used to display UI information.
Document types
The Order milestone includes the following document types, consolidated
into one milestone:
- 850 – Purchase order
- 860 – Purchase order change
- 875 – Grocery products purchase order
- 876 – Grocery products purchase order change
850, 860, 875, 876, and ORDERS documents are always mapped to the Order milestone, regardless of their purpose or timing.
Milestone summary information
Purchase orders
Order milestone summary information is taken from the following locations
in purchase order EDI documents:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Order milestone status | Calculated | |
| Order number | BEG03 | Purchase Order Number |
| Order date | BEG05 | Date |
| Line count | CTT01 | Number of Line Items |
| Total item quantity | CTT02 | Hash Total |
| Order total | AMT02 | Monetary Amount |
| Currency | CUR02 | Currency Code |
| Bill to name | N102 | BT | Name |
| Bill to address | N301 | BT | Address information |
| Bill to location | N401 | BT | City Name |
| Ship to name | N102 | ST | Name |
| Ship to address | N301 | ST | Address information |
| Ship to location | N401 | ST | City Name |
| Ship from name and address | N1 loop with SF qualifier | Shipper Name and address |
| Ship from location | N401 | SH or VN | City Name |
| Vendor name | N1 loop with VN qualifier | Name |
| Vendor ID | N1 loop with VN qualifier or REF02 when VR qualifier in REF01 or REF02 when IA qualifier in REF01 | ID |
| Department | N102 when N101 = DP, or REF02 when REF01 = DP | Department |
| Required by date and time | Date: DTM02 when DTM01 = 106 (required by) Time: DTM03 | Required by date/time |
| Requested ship date and time | ||
| Requested delivery date and time | ||
| Estimated delivery date and time | ||
| Freight terms | TD505 | Freight Terms |
| Trading partner EDI ID | ISA06 (sender) or ISA08 (receiver) | Sender, Receiver |
| SCAC Code | TD503 when TD502 = 2 | SCAC Code/Carrier |
Information from the following locations in purchase order EDI documents are provided in Order milestone summary or Order milestone line item information, depending on where they are in the EDI. If they are sent at the header level they are shown in the Summary pane. If they are sent at the line item level, they are shown for each line item.
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Requested delivery date and time | Date: DTM02 when DTM01 = 002 (delivery requested) Time: DTM03 | Requested delivery date/time |
| Requested ship date | Date: DTM02 when DTM01 = 010 (requested ship) Time: DTM03 | Requested ship date |
| Estimated delivery date and time | Date: DTM02 when DTM01 = 017 (estimated delivery) Time: DTM03 | Estimated Delivery Date/time |
| Charge category | TXI01 | Charge Category |
| Tax | TXI02 | Tax |
| Tax name | TXI05 | Tax Jurisdiction Code |
| Tax type description | Tax Type Description | |
| Tax percentage | TXI03 | Tax Percentage |
| Payment type | ITD14 | Payment Type |
| Payment type description | ITD14 | Payment Type Description |
| Terms description | ITD12 | Payment Terms Description |
Grocery documents
Order milestone summary information is taken from the following locations
in grocery EDI documents:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Order # | G5003 | Purchase Order Number |
| Order date | G6202 | Date |
| Line count | Calculated | Number of Line Items |
| Required by date/time | Date: G6202 when G6201 = BD (required by) Time: G6203 | Required by date/time |
| Total item quantity | G7601 | Hash Total |
| Order total | G7608 | Monetary Amount |
| Bill to name | N102 | BT | Name |
| Bill to address | N301 | BT | Address information |
| Bill to location | N401 | BT | City Name |
| Ship to name | N102 | ST | Name |
| Ship to address | N301 | ST | Address information |
| Ship to location | N401 | ST | City Name |
| Vendor name | N102 | SH or VN | Name |
| Vendor ID | N104 when qualifier in N101 is VN | ID |
| Vendor address | N301 | SH or VN | Address Information |
| Vendor location | N401 | SH or VN | City Name |
| Vendor Reference Id | REF02 when the qualifier in REF01 is VR or IA (ignored if N104 is populated) | Vendor Reference Id |
| Trading partner EDI ID | ISA06 (sender) or ISA08 (receiver) | Sender, Receiver |
| Department | N102 when N101 = DP, or REF02 when REF01 = DP | Department |
| Carrier | N902 when N901 = SCA | Carrier |
| Freight Terms | G6605 | Routing |
| Term Description | G2315 | Payment Terms Description |
Information from the following locations in purchase order EDI documents are provided in Order milestone summary or Order milestone line item information, depending on where they are in the EDI. If they are sent at the header level they are shown in the Summary pane. If they are sent at the line item level, they are shown for each line item.
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Requested delivery date and time | Date: G6202 when G6201 = 002 (delivery requested) Time: G6203 | Requested delivery date/time |
| Requested ship date | Date: G6202 when G6201 = 010 (requested ship) Time: G6203 | Requested ship date |
| Estimated delivery date and time | Date: G6202 when G6201 = 017 (estimated delivery) Time: DG6203 | Estimated Delivery Date/time |
Tip: If a line item contains items with multiple values for
Quantity, Unit of measure, Requested Ship
date and time, Estimated delivery date and time, or
Requested delivery date and time, expand the line item to display each item
or group of items that have the same values.
Line item information
Purchase orders
Order milestone line item information is taken from the following
locations in purchase order EDI documents:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Item # | PO101 | Assigned Identification |
| UPC # / Part # | PO106-PO125 | U2, UA, UD, UI, UK, UP, MG, PI, SK, VC, VN, VP, BP, CB, IN | Product/Service ID and Product/Service ID Qualifier |
| Item description | PID05 | Description |
| Quantity ordered | PO102 | Quantity Ordered |
| UOM | SCH01 | Unit of Measure |
| Unit price | SCH02 | Unit Price |
| Order value | AMT02 | Monetary Amount |
Grocery documents
Order milestone line item information is taken from the following
locations in grocery EDI documents:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| UPC # / Part # | G6804-G6808 | U2, UA, UD, UI, UK, UP, MG, PI, SK, VC, VN, VP, BP, CB, IN | Product/Service ID and Product/Service ID Qualifier |
| Item description | G6901 | Description |
| Quantity ordered | G6801 | Quantity Ordered |
| UOM | G6802 | Unit of Measure |
| Unit price | G6803 | Item List Cost |
| Order value | G7608 | Total Price |