Invoice milestone - X12
See the document types that map to the Invoice milestone, as well as which EDI documents are used to display UI information.
Document types
The Invoice milestone includes the following document types, consolidated
into one milestone:
- 810 – Invoice
- 880 – Grocery products invoice
Milestone summary information
Invoice
Invoice milestone summary information is taken from the following
locations in the invoice:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Invoice milestone status | Calculated | |
| Order number | BIG04 | Purchase Order Number |
| Ship number | BSN02 | Shipment Identification |
| Invoice number | BIG02 | Invoice Number |
| Invoice date | BIG01 | Date |
| Line count | Count of IT1 segment | Baseline item data (invoice detail) |
| Total item quantity | Sum of IT102 values | Quantity Invoice |
| Invoice total amount | TDS01 | Amount |
| Currency | CUR02 | Currency Code |
| Ship from name | N102 | SH or VN | Name |
| Ship from address | N301 | SH or VN | 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 |
| Trading partner EDI ID | ISA06 (sender) or ISA08 (receiver) | Sender, Receiver |
| Remit to |
Grocery products invoice
Invoice milestone summary information is taken from the following
locations in the grocery products invoice:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Order number | N902 [PO, VN] | G0104 | Purchase Order Number |
| Invoice number | G0102 | Invoice Number |
| Invoice date | G0101 | Date |
| Line count | Calculated | Baseline item data (invoice detail) |
| Total item quantity | G1701 | Total Quantity Invoiced |
| Invoice total amount | G3301 | Amount |
| Trading partner EDI ID | ISA06 (sender) or ISA08 (receiver) | Sender, Receiver |
Line item information
Invoice
Invoice milestone line item information is taken from the following
locations in the invoice:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| Item number | IT101 | Assigned Identification |
| UPC number / Part number | IT106-25 | U2, UA, UD, UI, UK, UP, MG, PI, SK, VC, VN, VP, BP, CB, IN | Product/Service ID Qualifier/Product/ Service ID |
| Item description | PID05 | Description |
| Quantity invoiced/ordered | IT102/PO102 | Quantity Invoiced/Quantity Ordered |
| UOM | IT103 | Unit of Measure Code |
| Unit price | CTP04 if CTP02 = INV, LPR, NET, IT104 | Unit Price |
| Order value | TDS01 | Amount |
Grocery products invoice
Invoice milestone line item information is taken from the following
locations in the grocery products invoice:
| UI field name | EDI field location | EDI field name |
|---|---|---|
| UPC number / Part number | G1705-08 | U2, UA, UD, UI, UK, UP, MG, PI, SK, VC, VN, VP, BP, CB, IN | Product/Service ID Qualifier/Product/ Service ID |
| Item description | G6901 | Description |
| Quantity invoiced/ordered | G1701 | Quantity Invoiced/Quantity Ordered |
| UOM | G1702 | Unit of Measure Code |
| Unit price | G1703 | Unit Price |
| Order value | G3301 | Amount |