EDI Shipping 856SOPI Export
Format of the Data
This export allows you to export an 856SOPI Advanced Shipping Notice (ASN). It is compatible with True Commerce
or SPS Commerce (in conjunction with EDI Anywhere).
Only sales orders that have been shipped will be exported. If an order is selected that has not been shipped,
it will be skipped.
The file is tab delimited and contains 4 different types of rows: the Shipment Row, the Order Row,
the Pack Row, and the Item row or SOPI for short. A description of the fields for each row is
displayed below.
The following is a complete list of the fields that Fishbowl will export. The positions not specified will
contain blank data.
The Shipment Row
| Position |
Data |
Data Type |
Value |
| 1 |
Row Type |
String |
"S" |
| 2 |
Transaction Type |
String |
"856SOPI" |
| 3 |
Accounting ID |
String |
|
| 4 |
Shipment ID |
String |
|
| 5 |
SCAC |
String |
|
| 7 |
Bill of Lading |
String |
|
| 8 |
Scheduled Delivery |
Date |
CCYYMMDD |
| 9 |
Ship Date |
Date |
CCYYMMDD |
| 10 |
Ship To Name |
String |
|
| 11 |
Ship To Address - Line One |
String |
|
| 12 |
Ship To Address - Line Two |
String |
|
| 13 |
Ship To City |
String |
|
| 14 |
Ship To State |
String |
|
| 15 |
Ship To Zip |
String |
|
| 16 |
Ship To Address Code |
String |
|
| 20 |
Gross Weight |
Real |
|
| 21 |
Gross Weight UOM |
List |
"Pound" or "Kilogram" |
| 22 |
# of Cartons Shipped |
Integer |
|
| 25 |
Ship From Name |
String |
|
| 26 |
Ship From Address - Line One |
String |
|
| 27 |
Ship From Address - Line Two |
String |
|
| 28 |
Ship From City |
String |
|
| 29 |
Ship From State |
String |
|
| 30 |
Ship From Zip |
String |
|
| 39 |
Status |
List |
<blank>, CC=Shipment Complete, PR=Partial Shipment |
| 41 |
Time Shipped |
Time |
Time (HH:MM) |
| 42 |
Carrier Name |
String |
|
The Order Row
| Position |
Data |
Data Type |
Value |
| 1 |
Row Type |
String |
"O" |
| 2 |
PO # |
String |
|
| 3 |
PO Date |
Date |
CCYYMMDD |
| 5 |
Order Weight |
Real |
|
| 8 |
Order Lading Quantity |
Real |
|
The Pack Row
| Position |
Data |
Data Type |
Value |
| 1 |
Row Type |
String |
"P" |
| 2 |
SSCC/UCC-128 |
String |
|
| 3 |
Pack Size |
Integer |
|
| 13 |
Tracking Number |
String |
|
The Item Row
| Position |
Data |
Data Type |
Value |
| 1 |
Row Type |
String |
"I" |
| 2 |
User Item ID |
String |
|
| 4 |
UPC # |
String |
|
| 5 |
Item Description |
String |
|
| 6 |
Ordered Quantity |
Real |
|
| 7 |
UOM |
List |
|
| 8 |
Shipped Quantity |
Real |
|
| 12 |
Line # |
String |
|