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 |