The following table lists the format for exporting in EDI Order Status Export.
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
SOS_HEADER |
x |
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
PO Number |
Po_Num |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
Order Number |
Order_num |
oe-header.order-num |
Character |
X(12) |
|
|
|
Vendor Number |
Vendor_Num |
oe-header.edi-internal-vendor |
Character |
X(20) |
|
|
|
Department Number |
Dept_Num |
oe-header.dept-num |
Character |
X(30) |
|
|
|
Store ID |
store_id |
oe-address.edi-address-code |
Character |
X(30) |
|
|
|
Status |
STATUS_Type |
N/A |
Character |
X(2) |
From a list of accepted EDI status codes for the 870 |
|
|
Order Status |
order_status |
oe-header.order-status |
Character |
X(20) |
|
|
|
EDI Spare 1 |
edi_spare_1 |
oe-header.edi-spare-1 |
Character |
X(8) |
|
|
|
EDI Spare 2 |
edi_spare_2 |
oe-header.edi-spare-2 |
Character |
X(8) |
|
|
|
EDI Spare 3 |
edi_spare_3 |
oe-header.edi-spare-3 |
Character |
X(8) |
|
|
|
EDI Spare 4 |
edi_spare_4 |
oe-header.edi-spare-4 |
Character |
X(8) |
|
|
|
EDI Spare 5 |
edi_spare_5 |
oe-header.edi-spare-5 |
Character |
X(8) |
|
|
|
Misc. Field 1 |
misc_fld_1 |
oe-header.misc-data-1 |
Character |
X(60) |
|
|
|
Misc. Field 2 |
misc_fld_2 |
oe-header.misc-data-2 |
Character |
X(60) |
|
|
|
Inquiry Reference Number |
inq_ref_num |
edi-870-header.inq-ref-num |
Character |
X(12) |
|
|
|
Partial Order |
partial_order |
edi-870-header.partial-order |
Logical |
Yes/No |
|
|
|
User Defined Field 1 |
user_def_1 |
oe-header.user-defined-01 |
Character |
X(400) |
|
|
|
User Defined Field 2 |
user_def_2 |
oe-header.user-defined-02 |
Character |
X(400) |
|
|
|
User Defined Field 3 |
user_def_3 |
oe-header.user-defined-03 |
Character |
X(400) |
|
|
|
User Defined Field 4 |
user_def_4 |
oe-header.user-defined-04 |
Character |
X(400) |
|
|
|
User Defined Field 5 |
user_def_5 |
oe-header.user-defined-05 |
Character |
X(400) |
|
|
|
User Defined Field 6 |
user_def_6 |
oe-header.user-defined-06 |
Character |
X(400) |
|
|
|
User Defined Field 7 |
user_def_7 |
oe-header.user-defined-07 |
Character |
X(400) |
|
|
|
User Defined Field 8 |
user_def_8 |
oe-header.user-defined-08 |
Character |
X(400) |
|
|
|
User Defined Field 9 |
user_def_9 |
oe-header.user-defined-09 |
Character |
X(400) |
|
|
|
User Defined Field 10 |
user_def_10 |
oe-header.user-defined-10 |
Character |
X(400) |
|
|
|
User Defined Field 11 |
user_def_11 |
oe-header.user-defined-11 |
Character |
X(400) |
|
|
|
User Defined Field 12 |
user_def_12 |
oe-header.user-defined-12 |
Character |
X(400) |
|
|
|
User Defined Field 13 |
user_def_13 |
oe-header.user-defined-13 |
Character |
X(400) |
|
|
|
User Defined Field 14 |
user_def_14 |
oe-header.user-defined-14 |
Character |
X(400) |
|
|
|
User Defined Field 15 |
user_def_15 |
oe-header.user-defined-15 |
Character |
X(400) |
|
|
|
User Defined Field 16 |
user_def_16 |
oe-header.user-defined-16 |
Character |
X(400) |
|
|
|
User Defined Field 17 |
user_def_17 |
oe-header.user-defined-17 |
Character |
X(400) |
|
|
|
User Defined Field 18 |
user_def_18 |
oe-header.user-defined-18 |
Character |
X(400) |
|
|
|
User Defined Field 19 |
user_def_19 |
oe-header.user-defined-19 |
Character |
X(400) |
|
|
|
User Defined Field 20 |
user_def_20 |
oe-header.user-defined-20 |
Character |
X(400) |
|
|
|
Order Class |
order_class |
oe-header.order-class |
Character |
X(10) |
|
|
|
|
|
|
|
|
|
SOS_DETAIL |
|
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
PO Number |
Po_Num |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
Order Number |
Order_num |
oe-header.order-num |
Character |
X(12) |
|
|
|
Line Number |
LINE_Num |
oe-trailer.line-num |
Integer |
>>>9 |
|
|
|
HL Level |
HL_code |
N/A |
Character |
X(1) |
Character for "O" order level or "I" detail level |
|
|
Status |
STATUS_Type |
N/A |
Character |
X(2) |
Standard list of EDI status codes from the 870 spec |
|
|
Order Date |
Org_Date |
oe-header.order-date |
Date |
99/99/9999 |
|
|
|
Scheduled Ship Date |
cur_Sch_Date |
oe-trailer.required-date |
Date |
99/99/9999 |
|
|
|
Re-Scheduled Ship Date |
Resch_Date |
oe-trailer.promise-date |
Date |
99/99/9999 |
|
|
|
PO Line Number |
PO_Line_Num |
oe-trailer.line-num |
Integer |
>>>9 |
|
|
|
Qty Ordered |
Qty_Ord |
oe-trailer.qty-ordered |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
Unit of Measure Xref |
UM |
edi-code |
Character |
X(8) |
|
|
|
Unit Price |
Unit_Price |
oe-trailer.unit-price |
Decimal |
->,>>>,>>9.9999 |
|
|
|
Customer Item Number |
Cust_Prod_Code |
oe-cust-prod.customer-product-id |
Character |
X(40) |
|
|
|
Product Code |
Prod_Code |
product.product-code |
Character |
X(40) |
|
|
|
UPC Code |
UPC_Code |
N/A |
|
|
Not mapped to |
|
|
Customer UPC Code |
Cust_UPC_Code |
oe-cust-prod.cust-upc-code |
Character |
X(20) |
|
|
|
Product UPC Code |
Prod_UPC_Code |
oe-cust-prod.cust-upc-code |
Character |
X(20) |
Will default to product-um.upc or product.upc code if no value is found |
|
|
Qty Shipped |
Qty_Ship |
oe-trailer.qty-picked-to-date |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
SCAC Code |
SCAC_Code |
shipper.scac-code |
|
|
|
|
|
Shipper |
shipper |
shipper.shipper-id |
|
|
|
|
|
Tracking Number |
Track_Num |
oe-pick-ticket-pkg.tracking-num |
Character |
X(30) |
If HL_code is O, then this is the tracking number for the first package on the first pick demand associated with the order. If HL_code is I, then this is the tracking number for the first package that has the product on the first pick demand associated with the order. |
|
|
Backordered |
backordered |
oe-trailer.on-backorder |
Logical |
Yes/No |
|
|
|
Cancelled |
cancelled |
oe-trailer.cancelled |
Logical |
Yes/No |
|
|
|
Misc. Field 1 |
misc_fld_1 |
oe-trailer.misc-data-1 |
Character |
X(60) |
|
|
|
Misc. Field 2 |
misc_fld_2 |
oe-trailer.misc-data-2 |
Character |
X(60) |
|
|
|
EDI Spare 1 |
edi_spare_1 |
oe-trailer.edi-spare-1 |
Character |
X(12) |
|
|
|
EDI Spare 2 |
edi_spare_2 |
oe-trailer.edi-spare-2 |
Character |
X(12) |
|
|
|
EDI Spare 3 |
edi_spare_3 |
oe-trailer.edi-spare-3 |
Character |
X(12) |
|
|
|
EDI Spare 4 |
edi_spare_4 |
oe-trailer.edi-spare-4 |
Character |
X(12) |
|
|
|
EDI Spare 5 |
edi_spare_5 |
oe-trailer.edi-spare-5 |
Character |
X(12) |
|
|
|
Country of Origin |
country_of_origin |
product.country-of-origin |
Character |
X(10) |
|
|
|
EDI Order Line Number |
edi_order_line_num |
oe-trailer.line-num |
Integer |
>>>9 |
|
|
|
Required Date |
required_date |
oe-trailer.required-date |
Date |
99/99/9999 |
|
|
|
Cancel after Date |
cancel_after_date |
oe-trailer.cancel-after-date |
Date |
99/99/9999 |
|
|
|
Earliest Ship Date |
earliest_ship_date |
oe-header.earliest-ship-date |
Date |
99/99/9999 |
Can come from trailer |
|
|
Latest Ship Date |
latest_ship_date |
oe-header.latest-ship-date |
Date |
99/99/9999 |
Can come from trailer |
|
|
User Date 1 |
user_date_1 |
oe-header.user-date-1 |
Date |
99/99/9999 |
|
|
|
User Date 2 |
user_date_2 |
oe-header.user-date-2 |
Date |
99/99/9999 |
|
|
|
User Date 3 |
user_date_3 |
oe-header.user-date-3 |
Date |
99/99/9999 |
|
|
|
User Date 4 |
user_date_4 |
oe-header.user-date-4 |
Date |
99/99/9999 |
|
|
|
User Date 5 |
user_date_5 |
oe-header.user-date-5 |
Date |
99/99/9999 |
|
|
|
User Date 6 |
user_date_6 |
oe-header.user-date-6 |
Date |
99/99/9999 |
|
|
|
User Date 7 |
user_date_7 |
oe-header.user-date-7 |
Date |
99/99/9999 |
|
|
|
User Date 8 |
user_date_8 |
oe-header.user-date-8 |
Date |
99/99/9999 |
|
|
|
User Date 9 |
user_date_9 |
oe-header.user-date-9 |
Date |
99/99/9999 |
|
|
|
User Date 10 |
user_date_10 |
oe-header.user-date-10 |
Date |
99/99/9999 |
|
|
|
Qty Backordered |
qty_backordered |
Calculated field |
Decimal |
>,>>>,>>9.9999 |
oe-trailer.qty-ordered - oe-trailer.qalloc - oe-trailer.qty-picked - oe-trailer.qfuture |
|
|
HL Child |
HL_child |
Calculated field |
Integer |
|
total-hl is incremented for each detail record belonging to the header. This value goes into hl-child. This functions as a sequence number. |
|
|
BOL Number |
bol_number |
oe-pick-ticket-pkg.bol-num or bol-pre-def.bol-num |
Character |
X(17) |
If HL_code is O, then this is the first bill of lading for the order. If HL_code is I, then this is the first bill of lading for the product. |
|
|
User Defined Field 1 |
user_def_1 |
oe-trailer.user-defined-01 |
Character |
X(400) |
|
|
|
User Defined Field 2 |
user_def_2 |
oe-trailer.user-defined-02 |
Character |
X(400) |
|
|
|
User Defined Field 3 |
user_def_3 |
oe-trailer.user-defined-03 |
Character |
X(400) |
|
|
|
User Defined Field 4 |
user_def_4 |
oe-trailer.user-defined-04 |
Character |
X(400) |
|
|
|
User Defined Field 5 |
user_def_5 |
oe-trailer.user-defined-05 |
Character |
X(400) |
|
|
|
User Defined Field 6 |
user_def_6 |
oe-trailer.user-defined-06 |
Character |
X(400) |
|
|
|
User Defined Field 7 |
user_def_7 |
oe-trailer.user-defined-07 |
Character |
X(400) |
|
|
|
User Defined Field 8 |
user_def_8 |
oe-trailer.user-defined-08 |
Character |
X(400) |
|
|
|
User Defined Field 9 |
user_def_9 |
oe-trailer.user-defined-09 |
Character |
X(400) |
|
|
|
User Defined Field 10 |
user_def_10 |
oe-trailer.user-defined-10 |
Character |
X(400) |
|
|
|
User Defined Field 11 |
user_def_11 |
oe-trailer.user-defined-11 |
Character |
X(400) |
|
|
|
User Defined Field 12 |
user_def_12 |
oe-trailer.user-defined-12 |
Character |
X(400) |
|
|
|
User Defined Field 13 |
user_def_13 |
oe-trailer.user-defined-13 |
Character |
X(400) |
|
|
|
User Defined Field 14 |
user_def_14 |
oe-trailer.user-defined-14 |
Character |
X(400) |
|
|
|
User Defined Field 15 |
user_def_15 |
oe-trailer.user-defined-15 |
Character |
X(400) |
|
|
|
User Defined Field 16 |
user_def_16 |
oe-trailer.user-defined-16 |
Character |
X(400) |
|
|
|
User Defined Field 17 |
user_def_17 |
oe-trailer.user-defined-17 |
Character |
X(400) |
|
|
|
User Defined Field 18 |
user_def_18 |
oe-trailer.user-defined-18 |
Character |
X(400) |
|
|
|
User Defined Field 19 |
user_def_19 |
oe-trailer.user-defined-19 |
Character |
X(400) |
|
|
|
User Defined Field 20 |
user_def_20 |
oe-trailer.user-defined-20 |
Character |
X(400) |
|
|
|
Unit of Measure |
UOM_code |
um.um-code |
Character |
X(8) |
|
|
|
Container |
Container |
po-container.container-num |
Character |
X(30) |
|
|
|
Quantity Allocated |
qty_allocated |
oe-trailer.qalloc |
Decimal |
->>>,>>9.99<< |
|
|
|
Cancel Backorder |
cancel_backorder |
oe-trailer.cancel-backorder |
Logical |
Yes/No |
|
|
|
Backorder Cancelled |
backorder_cancelled |
oe-trailer.backorder-cancelled |
Logical |
Yes/No |
|
|
|
|
|
|
|
|
|
SOS_SUMMARY |
|
Summary Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total HL Levels |
total_hl_levels |
Calculated field |
Integer |
|
This is the total number of detail records for the 870. |
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
Order Number |
Order_num |
oe-header.order-num |
Character |
X(12) |
|