Advance Ship Notice Import

Overview

The Advance Ship Notice import process read files from ./Incoming/AdvanceShipNotice/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/AdvanceShipNotice/ before being processed in alphanumeric order.

Possible values

Carrier
fedex, usps, ups, dhl, ontrac, asendia, apc, firstmile, newgistics, globegistics, rr_donnelley, purolator_ca

Asn-Header

Field Name Required Field Unique? Field Type Field Description Possible Values
ASN Header* Yes No Record type - ASN Header
ASN Number* Yes Yes string(40) ASN Header Number
Supplier* Yes No Supplier Name
Ship To Name No No Ship To Name
Ship To Street 1 No No Ship To Street 1
Ship To Street 2 No No Ship To Street 2
Ship To Street 3 No No Ship To Street 3
Ship To Street 4 No No Ship To Street 4
Ship To City No No Ship To City
Ship To State No No Ship To State
Ship To Postal Code No No Ship To Postal Code
Ship To Country Code No No Ship To Country Code
Ship To Country Name No No Ship To Country Name
Ship To Location Code No No Ship To Location Code
Ship to Email No No Ship to Email
Ship To Warehouse No No Ship To Warehouse
Ship Date* Yes No datetime Date of Shipment
Delivery Date No No datetime Expected Delivery Date
Gross weight No No decimal(30,6) Gross weight
UOM No No string(255) UOM of Gross weight
Ship To Attention No No Ship To Attention
Ship Method No No string(255) Ship Method
Shipper Note No No string(255) Shipper Note
Carrier No No string(255) Carrier for the shipment
Tracking Number No No string(255) Tracking Number
Standard Carrier Alpha Code No No string(255) Unique two-to-four-letter code used to identify transportation companies
Container No No string(255) Container or LPN for the shipped material
Trailer No No string(255) Trailer number for the shipment
Bill Of Lading No No string(255) Document issued by a carrier to acknowledge receipt of cargo for shipment
Packing Slip No No string(255) Delivery list
ASN Line* Yes No Record type - ASN Line
Line Number* Yes No ASN Line Number
Status No No string(50) ASN Line Current Status
Item Name No No ASN Line Item Name
Quantity No No Quantity
PO Number* Yes No Purchase Order Number
PO Line Number* Yes No Purchase Order Line Number
Invoice Line Number No No Invoice Line Number
Invoice Number No No Invoice Number
Match Reference No No Three-way match attribute to connect with Receipt and Invoice Header
Comments No No ASN Line Comments
Supplier Part Number No No Supplier Part Number
Supplier Aux Part Number No No Supplier Aux Part Number
Lot No No Lot
Lot Number No No Lot Number
Expiration Date No No Lot Expiration Date

ASN Line Columns

Column Name Description Req'd Unique Type Allowable Values
ASN Line* Describes the type of row FALSE FALSE - ASN Line
Line Number* ASN Line Number FALSE FALSE string(255) any
Status ASN Line Current Status FALSE FALSE string(255) any
Item Name ASN Line Item Name FALSE FALSE string(255) any
Quantity* ASN Line Shipped Quantity FALSE FALSE decimal(30,6) any
PO Number* Purchase Order Number FALSE FALSE string(20) any
PO Line Number* Purchase Order Line Number FALSE FALSE string(255) any
Invoice Line Number Invoice Line Number FALSE FALSE string(255) any
Match Reference Three-way match attribute to connect with Receipt and Invoice Header FALSE FALSE string(255) any
Invoice Number Invoice Number FALSE FALSE string(255) any
Comments ASN Line Comments FALSE FALSE string(255) any
Supplier Part Number Supplier Part Number FALSE FALSE string(255) any
Supplier Aux Part Number Supplier Aux Part Number FALSE FALSE string(255) any