EDI Order Status Export Format

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)