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.
Advance ship notice columns
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 |