EDI Sales Order Creation

The following logic should be used when creating sales orders in StreamII or StreamV based on EDI information supplied by the customer.  The customer information should be loaded into the fields listed below by any standard or custom EDI programs being used to create sales orders on the system.

 

EDI Information

Defined Type/Size

Field Name

File/Field#

Customer PO#

ASCII 30

SOHEAD.PO_NO

60:28

Customer Fulfillment PO

ASCII 30

SOHEAD.FULFILLMENT_PO

60:109

Customer PO Date

Date field

SOHEAD.PO_DATE

60:84

Customer PO#

ASCII 30

SOLINE.PO_NO

61:121

Customer PO Line

Numeric 14.4

SOLINE.PO_LINE_NO

61:113

Customer PO Price

Numeric 14.4

SOLINE.PO_PRICE

61:114

Customer Item Number

ASCII 30

SOLINE.PO_ITEM_NO

61:122