Skip to main content

 

 

Coupa Success Portal

Advance Ship Notices Export

ASN Header Columns

# Column Name Description Type Req'd/Unique Allowable Values
1 Record Type Indicates record type - No/No Header
2 Id Coupa's internal ID integer(11) No/No  
3 ASN Number ASN Number string(40) Yes/Yes  
4 Status ASN Header Status string(50) No/No  
5 Ship to date Ship to date datetime Yes/No  
6 Delivery date Delivery date datetime No/No  
7 Supplier id Supplier Coupa internal ID number integer(11) No/No  
8 Supplier name Supplier Name string(100) No/No  
9 Supplier number Supplier Number string(255) No/No  
10 Created by employee number Employee Number of User who created ASN string(255) No/No  
11 Created by id Coupa ID of User who created ASN integer(11) No/No  
12 Created by login Login name of User who created ASN string(255) No/No  
13 Created at Date record was created in Coupa. datetime No/No  
14 Updated by employee number Employee Number of User last updated by string(255) No/No  
15 Updated by id Coupa ID of User last updated by integer(11) No/No  
16 Updated by login Login name of User last updated by string(255) No/No  
17 Updated at Last Updated at Date datetime No/No  
18 Ship to user employee number Employee Number of Ship To User string(255) No/No  
19 Ship to user id Coupa ID of Ship To User integer(11) No/No  
20 Ship to user login Login name of Ship To User string(255) No/No  
21 ASN Lines Count ASN Lines Count integer(11) No/No  
22 Gross weight Gross weight decimal(30,6) No/No  
23 Carrier Carrier for the shipment string(255) No/No  
24 Tracking Number Tracking Number string(255) No/No  
25 Standard carrier alpha code Unique two-to-four-letter code used to identify transportation companies string(255) No/No  
26 Container Container or LPN for the shipped material string(255) No/No  
27 Version Version integer(11) No/No  
28 Channel Channel string(255) No/No  
29 Trailer Trailer number for the shipment string(255) No/No  
30 Bill of lading Document issued by a carrier to acknowledge receipt of cargo for shipment string(255) No/No  
31 Packing slip Delivery list string(255) No/No  
32 Ship to attention Ship to attention string(255) No/No  
33 Ship method Ship method string(255) No/No  
34 Ship note Ship note string(255) No/No  
35 Uom code Uom code string(255) No/No  

ASN Line Columns

# Column Name Description Type Req'd/Unique Allowable Values
1 Record Type Indicates record type - No/No Line
2 Id Coupa's internal ID integer(11) No/No  
3 Line num Line num string(255) Yes/Yes  
4 Status ASN Line Status string(255) No/No  
5 Description Description string(255) No/No  
6 Quantity Quantity decimal(30,6) Yes/No  
7 Uom code Uom code string(6) No/No  
8 Asn Header Id Asn Header Id integer(11) No/No  
9 Asn Header Number Asn Header Number string(40) No/No  
10 Order Line Id Order Line Id integer(11) No/No  
11 Description Description string(255) No/No  
12 Created by Employee Number Employee Number of User who created ASN string(255) No/No  
13 Created By Id Coupa ID of User who created ASN integer(11) No/No  
14 Created By Login Login name of User who created ASN string(255) No/No  
15 Created At Date record was created in Coupa. datetime No/No  
16 Updated_by Employee Number Employee Number of User last updated by string(255) No/No  
17 Updated By Id Coupa ID of User last updated by integer(11) No/No  
18 Updated By Login Login name of User last updated by string(255) No/No  
19 Updated At Last Updated at Date datetime No/No  
20 Received Qty Received Qty decimal(30,6) Yes/No  
21 Item Id Item Id integer(11) No/No  
22 Item Name Item Name string(255) No/No  
23 Item Number Item Number string(255) No/No  
24 Invoice Header Id Invoice Header Id integer(11) No/No  
25 Invoice Line Id Invoice Line Id integer(11) No/No  
26 Invoice Line Num Invoice Line Num string(255) No/No  
27 Invoice Number Invoice Number string(255) No/No  
28 Version ASN Version Number integer(11) No/No  
29 Container Container or LPN for the shipped material string(255) No/No  
30 Supplier Part Num Supplier Part Num string(255) No/No  
31 Supplier Aux Part Num Supplier Aux Part Num string(255) No/No  
32 Comments Comments string(255) No/No  
33 Order Quantity Order Quantity decimal(30,6) No/No  
34 Match Reference Three-way match attribute to connect with Receipt and Invoice Header string(255) No/No  

 

  • Was this article helpful?