Skip to main content

 

 

Coupa Success Portal

Advance Ship Notice Import

ASN Header Columns

Column Name Description Req'd Unique Type Allowable Values
ASN Header* Describes the type of row FALSE FALSE - 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) any
Ship Method Ship Method FALSE FALSE string(255) any
Shipper Note Shipper Note FALSE FALSE string(255) any
Carrier Carrier FALSE FALSE string(255) any
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 - 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
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
  • Was this article helpful?