Advance Ship Notices Export
Export of these records is included as a Standard CSV Export.
Asn-Header
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Indicates record type | No/No | ||
| Id | Coupa's internal ID | integer | No/No | |
| ASN Number | ASN Number | string(40) | Yes/Yes | |
| Status | ASN Header Status | string(50) | No/No | |
| Ship to date | Ship to date | datetime | Yes/No | |
| Delivery date | Delivery date | datetime | No/No | |
| Supplier id | Supplier Coupa internal ID number | integer | No/No | |
| Supplier name | Supplier Name | No/No | ||
| Supplier number | Supplier Number | No/No | ||
| Created by employee number | Employee Number of User who created ASN | No/No | ||
| Created by id | Coupa ID of User who created ASN | integer | No/No | |
| Created by login | Login name of User who created ASN | No/No | ||
| Created at | Date record was created in Coupa. | datetime | No/No | |
| Updated by employee number | Employee Number of User last updated by | No/No | ||
| Updated by id | Coupa ID of User last updated by | integer | No/No | |
| Updated by login | Login name of User last updated by | No/No | ||
| Updated at | Last Updated at Date | datetime | No/No | |
| Ship to user employee number | Employee Number of Ship To User | No/No | ||
| Ship to user id | Coupa ID of Ship To User | integer | No/No | |
| Ship to user login | Login name of Ship To User | No/No | ||
| ASN Lines Count | ASN Lines Count | integer | No/No | |
| Gross weight | Gross weight | decimal(30,6) | No/No | |
| Carrier | Carrier for the shipment | string(255) | No/No | |
| Tracking Number | Tracking Number | string(255) | No/No | |
| Standard carrier alpha code | Unique two-to-four-letter code used to identify transportation companies | string(255) | No/No | |
| Container | Container or LPN for the shipped material | string(255) | No/No | |
| Version | Version | integer | No/No | |
| Channel | Channel | string(255) | No/No | |
| Trailer | Trailer number for the shipment | string(255) | No/No | |
| Bill of lading | Document issued by a carrier to acknowledge receipt of cargo for shipment | string(255) | No/No | |
| Packing slip | Delivery list | string(255) | No/No | |
| Ship to attention | Ship to attention | string(255) | No/No | |
| Ship method | Ship method | string(255) | No/No | |
| Ship note | Ship note | string(255) | No/No | |
| Uom code | Uom code | No/No |
Asn-Line
| Field Name | Description | Field Type | Required/Unique | Possible Values |
| Record Type | Indicates record type | No/No | ||
| Id | Coupa's internal ID | integer | No/No | |
| Line num | Line num | string(255) | Yes/Yes | |
| Status | ASN Line Status | string(255) | No/No | |
| Description | Description | string(255) | No/No | |
| Quantity | Quantity | decimal(30,6) | Yes/No | |
| Uom code | Uom code | No/No | ||
| Asn Header Id | Asn Header Id | integer | No/No | |
| Asn Header Number | Asn Header Number | No/No | ||
| Order Line Id | Order Line Id | integer | No/No | |
| Description | Description | string(255) | No/No | |
| Created by Employee Number | Employee Number of User who created ASN | No/No | ||
| Created By Id | Coupa ID of User who created ASN | integer | No/No | |
| Created By Login | Login name of User who created ASN | No/No | ||
| Created At | Date record was created in Coupa. | datetime | No/No | |
| Updated_by Employee Number | Employee Number of User last updated by | No/No | ||
| Updated By Id | Coupa ID of User last updated by | integer | No/No | |
| Updated By Login | Login name of User last updated by | No/No | ||
| Updated At | Last Updated at Date | datetime | No/No | |
| Received Qty | Received Qty | decimal(30,6) | Yes/No | |
| Item Id | Item Id | integer | No/No | |
| Item Name | Item Name | No/No | ||
| Item Number | Item Number | No/No | ||
| Invoice Header Id | Invoice Header Id | integer | No/No | |
| Invoice Line Id | Invoice Line Id | integer | No/No | |
| Invoice Line Num | Invoice Line Num | string(255) | No/No | |
| Invoice Number | Invoice Number | string(255) | No/No | |
| Version | ASN Version Number | integer | No/No | |
| Container | Container or LPN for the shipped material | string(255) | No/No | |
| Supplier Part Num | Supplier Part Num | string(255) | No/No | |
| Supplier Aux Part Num | Supplier Aux Part Num | text | No/No | |
| Comments | Comments | string(255) | No/No | |
| Order Quantity | Order Quantity | decimal(30,6) | No/No | |
| Match Reference | Three-way match attribute to connect with Receipt and Invoice Header | string(255) | No/No |