Advance Ship Notices Export
Coupa's purchase order flat file integration object contains header columns, and line columns.
Export of these records is included as a Standard CSV Export.
ASN header columns
ASN line columns
| Position | 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 |