Advance Ship Notice Import
The ASN loader has header columns and line columns.
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.
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
ASN Header* | Describes the type of row | FALSE | FALSE | - | ASN Header |
ASN Number* | Advance Ship Notice Number | FALSE | TRUE | string(40) | any |
Supplier* | Supplier Name | FALSE | FALSE | string(255) | any |
Ship To Name | Ship To Name | FALSE | FALSE | string(50) | any |
Ship To Attention | Ship To Attention | FALSE | FALSE | string(255) | any |
Ship To Street 1 | Ship To Street 1 | FALSE | FALSE | string(100) | any |
Ship To Street 2 | Ship To Street 2 | FALSE | FALSE | string(100) | any |
Ship To City | Ship To City | FALSE | FALSE | string(50) | any |
Ship To State | Ship To State | FALSE | FALSE | string(50) | any |
Ship To Postal Code | Ship To Postal Code | FALSE | FALSE | string(50) | any |
Ship To Country Code | Ship To Country Code | FALSE | FALSE | string(4) | any |
Ship To Country Name | Ship To Country Name | FALSE | FALSE | string(100) | any |
Ship To Location Code | Ship To Location Code | FALSE | FALSE | string(255) | any |
Ship to Email | Ship to Email | FALSE | FALSE | string(255) | any |
Ship To Warehouse | Ship To Warehouse | FALSE | FALSE | string(255) | any |
Gross weight | Gross weight | FALSE | FALSE | decimal(30,6) | any |
UOM | UOM of Gross weight | FALSE | FALSE | string(255) | Must exist in Coupa |
Ship Method | Ship Method | FALSE | FALSE | string(255) | any |
Shipper Note | Shipper Note | FALSE | FALSE | string(255) | any |
Carrier | Carrier | FALSE | FALSE | string(255) | fedex, usps, ups, dhl, ontrac, asendia, apc, firstmile, newgistics, globegistics, rr_donnelley, purolator_ca |
Tracking Number | Tracking Number | FALSE | FALSE | string(255) | any |
Standard Carrier Alpha Code | Standard Carrier Alpha Code | FALSE | FALSE | string(255) | any |
Container | Container | FALSE | FALSE | string(255) | any |
Ship Date* | Date of Shipment | FALSE | FALSE | datetime | any |
Delivery Date | Expected Delivery Date | FALSE | FALSE | datetime | any |
Trailer | Trailer | FALSE | FALSE | string(255) | any |
Bill Of Lading | Bill Of Lading | FALSE | FALSE | string(255) | any |
Packing Slip | Packing Slip | FALSE | FALSE | string(255) | any |
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 |