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 Street 3 | Ship To Street 3 | FALSE | FALSE | string(100) | any |
| Ship To Street 4 | Ship To Street 4 | 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 |