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 |
