Acctivate can export sales shipment notifications to your customers via EDI as the 856. The Standard Pack (SOIP) file structure contains the Shipment, Item, Lot/Serial, and Pack rows.
One common format for the Acctivate EDI Advance Ship Notice is "Standard Pack". Standard Pack ASNs are appropriate when each carton in a shipment contains a single SKU. Please read our EDI Advance Ship Notice article for an introduction to ASNs.
File Structure (SOIP sequence):
- The Shipment Row (Row Type "S") is the first row in an Advance Ship Notice. The shipment row contains the shipment address, carrier, service, total weight and other shipment summary information.
- Sales Order Rows (Row Type "O") are created for each sales order contained in the shipment. Typically, there is one sales order contained in the shipment, but Acctivate does support consolidated, multi-order shipments.
- Item Rows (Row Type "I") are included for each item in the shipment. Multiple product identifiers are included, along with the quantity and item dimensions.
- Lot/Serial Rows (Row Type "L") for the selected lot or serial numbers are included in the shipment. All lot/serial numbers for an item will appear under a single Item Row.
- Pack Rows (Row Type "P") will appear for each carton for the item within the shipment. The Package ID (SSCC-18) is included in the Pack Row, along with the pack quantities, store number, tracking number and weight.
| Shipment Row (One per transaction) | |||
| Position | Data | Data Type | Value |
| 1 | Row Type | String | "S" |
| 2 | Transaction Type | String | "856SOIP" |
| 3 | Shipment ID | String | Acctivate Shipment Number |
| 4 | SCAC | String | SCAC from Carrier (Config Mgr) |
| 5 | Carrier Pro # | String | Carrier Reference from Shipment |
| 6 | Bill of Lading | String | BOL from Shipment or first Carrier Reference from first Carton |
| 7 | Scheduled Delivery | Date | CCYYMMDD format |
| 8 | Ship Date | Date | CCYYMMDD format |
| 9 | Ship To Name | String | Address line 1 from Shipment |
| 10 | Ship To Address - Line One | String | Address line 2 from Shipment |
| 11 | Ship To Address - Line Two | String | Address line 3 from Shipment |
| 12 | Ship To City | String | City from Shipment |
| 13 | Ship To State | String | State from Shipment |
| 14 | Ship To Zip | String | Postal / Zip from Shipment |
| 15 | Ship To Address Code | String | NOT SUPPORTED |
| 16 | Routing | String | Routing from Shipment |
| 17 | Ship To Type | String | NOT SUPPORTED |
| 18 | Packaging Type | String | "Carton" |
| 19 | Gross Weight | Decimal | Gross Weight from Shipment |
| 20 | Gross Weight UOM | String | Gross Weight Unit from Shipment |
| 21 | # of Cartons Shipped | Integer | Number of Cartons/Packs in Shipment |
| 22 | Carrier Trailer # | String | NOT SUPPORTED |
| 23 | Trailer Initial | String | NOT SUPPORTED |
| 24 | Ship From Name | String | Company Name from Config Mgr (Company Info) |
| 25 | Ship From Address - Line One | String | First address line from Config Mgr (Company Info) |
| 26 | Ship From Address - Line Two | String | Second address line from Config Mgr (Company Info) |
| 27 | Ship From City | String | City from Config Mgr (Company Info) |
| 28 | Ship From State | String | State from Config Mgr (Company Info) |
| 29 | Ship From Zip | String | Postal / Zip from from Config Mgr (Company Info) |
| 30 | Ship From Address Code | String | NOT SUPPORTED |
| 31 | Vendor # | String | EDI Identifier for your company, configurable per Trading Partner (e.g., Duns #, UCC EDI #, Phone) |
| 32 | Distributor Address Code | String | NOT SUPPORTED |
| 33 | Transportation Method | List | <blank>,A=Air,C=Consolidation,M=Motor (Common Carrier),P=Private Carrier,U=Private Parcel Service |
| 34 | Buyers Address Code | String | NOT SUPPORTED |
| 35 | Product Group | String | NOT SUPPORTED |
| 36 | Ship To Code | NOT SUPPORTED | |
| 37 | Ship To Location ID | Ship To Location ID From Shipment | |
| 38 | Status | String | NOT SUPPORTED |
| 39 | Routing Sequence Code | String | "B" |
| 40 | Time Shipped | Time | Time from Shipment Date (HH:MM) |
| 41 | ASN Creation Date | Date | Shipment Date (CCYYMMDD) |
| 42 | Carrier | String | Sales Order Carrier |
| 43 | CarrierService | String | Sales Order Carrier Service |
| Order Row (Repeated within Shipment Row) | |||
| Position | Data | Data Type | Value |
| 1 | Row Type | String | "O" |
| 2 | Accounting ID | String | Acctivate Trading Partner ID for Customer |
| 3 | PO Number | String | Customer PO Number from Sales Order |
| 4 | PO Date | Date | CCYYMMDD |
| 5 | Invoice Number | String | |
| 6 | Order Weight | Real | Total weight of cartons (or items for Pick/Pack) for this order in the shipment |
| 7 | Store Address Code | String | Store Location from first carton for this Sales Order in Shipment |
| 8 | Buyer Name | String | NOT SUPPORTED |
| 9 | Order Lading Quantity | Real | NOT SUPPORTED |
| 10 | Department # | String | Department Number from original EDI Purchase Order |
| 11 | Destination Address Code | String | NOT SUPPORTED |
| 12 | Packaging Type | List | Packaging Type/Code from first carton for this Sales Order in Shipment |
| 13 | Lading Quantity | Real | Number of Cartons for this Sales Order in Shipment |
| 14 | Store Name | String | NOT SUPPORTED |
| 15 | Store Number | String | Store Location from first carton for this Sales Order in Shipment |
| 16 | Buyer Address Code | String | NOT SUPPORTED |
| 17 | Vendor Order # | String | Acctivate Sales Order Number |
| 18 | Merchandise Type Code | String | Merchandise Type Code from original EDI Purchase Order |
| 19 | Product Group | String | Product Group from original EDI Purchase Order |
| 20 | Reference | String | Reference from Acctivate Sales Order |
| 21 | Reference 2 | String | Reference 2 from Acctivate Sales Order |
| 22 | Job Reference | String | Job Reference from Acctivate Sales Order |
| Item Row (Repeated within Order Row) | |||
| Position | Data | Data Type | Value |
| 1 | Row Type | String | "I" |
| 2 | User Item ID | String | Product ID from Acctivate Product record |
| 3 | Trading Partner Item ID | String | Buyer Product ID from original EDI Purchase Order |
| 4 | UPC # | String | UPC from Acctivate Product record |
| 5 | Item Description | String | Description from Acctivate Sales Order line |
| 6 | Quantity | Decimal | Total Quantity for this Item from all cartons/packs |
| 7 | UOM | String | Stocking Unit of Measure from Product |
| 8 | Shipped Quantity | Decimal | Same as above "Quantity" |
| 9 | Pack Size | String | NOT SUPPORTED |
| 10 | Pack UOM | String | NOT SUPPORTED |
| 11 | Inner Packs per Outer Pack | Decimal | Outer Pack Qty from Product Specs tab |
| 12 | Line # | String | Line Number from original EDI Purchase Order or Acctivate Sales Order if no PO line was provided |
| 13 | Buyer's Catalog # | String | NOT SUPPORTED |
| 14 | Volume | Decimal | Volume from Product Specs tab |
| 15 | Volume UOM | String | NOT SUPPORTED |
| 16 | Weight | Decimal | NOT SUPPORTED |
| 17 | Today's Date | Date | Timestamp in CCYYMMDD format |
| 18 | Reserved | String | NOT SUPPORTED |
| 19 | Unit Price | Decimal | Price from Sales Order line in stocking unit |
| 20 | Reference | String | Reference from Sales Order line |
| 21 | Length | Decimal | Length from Product Specs tab |
| 22 | Height | Decimal | Height from Product Specs tab |
| 23 | Width | Decimal | Width from Product Specs tab |
| Lot/Serial Number Row (optional, repeated within Item Row) | |||
| Position | Data | Data Type | Value |
| 1 | Row Type | String | "L" |
| 2 | Lot Number | String | Lot or Serial Number |
| 3 | Quantity | Decimal | Quantity for Lot or Serial Number |
| 4 | Expiration Date | Date | CCYYMMDD |
| 5 | Reference | String | Reference for Lot / Serial Number |
| 6 | Specification | String | Specification for Lot / Serial Number |
| 7 | Weight | Decimal | Weight from Lot / Serial Number |
| 8 | Length | Decimal | Length from Lot / Serial Number |
| Pack Row (Repeated within Item Row) | |||
| Position | Data | Data Type | Value |
| 1 | Row Type | String | "P" |
| 2 | UCC-128 | String | Package ID (option to include "00" prefix) |
| 3 | Pack Size | Decimal | NOT SUPPORTED |
| 4 | Inner Packs per Outer Pack | Decimal | Outer Pack Qty from Carton / Pack |
| 5 | Pack Height | Decimal | NOT SUPPORTED |
| 6 | Pack Length | Decimal | NOT SUPPORTED |
| 7 | Pack Width | Decimal | NOT SUPPORTED |
| 8 | Pack Weight | Decimal | Weight of Carton / Pack |
| 9 | Qty of UPCs within Pack | Decimal | Inner Pack Qty from Carton / Pack |
| 10 | UOM of UPCs | List | "Each" |
| 11 | Pack Size UOM | List | NOT SUPPORTED |
| 12 | Store Name | String | NOT SUPPORTED |
| 13 | Store Number | String | Ship To Location ID from Carton / Pack |
| 14 | Tracking # | String | Carrier Package ID from Carton / Pack |
| 15 | Gross Volume | Decimal | Volume from Product Specs tab X Shipped Qty in Carton |
| 16 | Gross Volume UOM | List | NOT SUPPORTED |