Inventory Transactions (Receipts) Import
Overview
The inventory transactions (receipts)import process read files from the ./Incoming/Receipts/ SFTP folder. These files will be moved to the archive folder located at ./Incoming/Archive/Receipts/ before being processed in alphanumeric order.
Unique Keys/Validations
One of the following four sets of columns are required:
- ID
- Order Line ID and Order Line PO Number
- Order Line Number and Order Line PO ID
- Order Line ID
Inventory Transaction Columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| ID | Coupa Unique Inventory Transaction ID | TRUE* | TRUE | int(11) | any |
| Barcode | Barcode | FALSE | FALSE | string(255) | any |
| Currency | Transaction Currency Code | FALSE | FALSE | string(100) | any |
| Price | Transaction Price | FALSE | FALSE | decimal(30,6) | any |
| Quantity | Quantity Received in UOM | FALSE | FALSE | decimal(30,6) | any |
| RFID Tag | RFID Tag | FALSE | TRUE | string(255) | any |
| Type | Transaction Type | FALSE | FALSE | string(255) | Valid Transaction Type List |
| Order Line Id | Order Line Coupa Id Number | TRUE* | FALSE | int(11) | any |
| Order Line Number | Order Line Number | TRUE* | FALSE | string(255) | any |
| Order Line PO Id | Order Line PO Coupa Id Number | TRUE* | FALSE | int(11) | any |
| ASN Line Id | ASN Line Coupa Id | FALSE | FALSE | int(11) | any |
| ASN Line Number | ASN Line Coupa Number | FALSE | FALSE | string(255) | any |
| ASN Header Id | ASN Header Coupa Id | FALSE | FALSE | int(11) | any |
| ASN Header Number | ASN Header Coupa Number | FALSE | FALSE | string(40) | any |
| UOM Code | Unit of Measure Code | FALSE | FALSE | string(6) | any |
| Status | The status of the transaction. Default is created. | FALSE | FALSE | string(255) | any |
| Match Reference | Three-way match attribute to connect with Receipt and Invoice Header | FALSE | FALSE | string(255) | any |
| External Id | This is a custom field that Coupa creates to accomodate the ERP Id | FALSE | FALSE | string(255) | any |
* One of the following four sets of columns are required:
- ID
- Order Line ID and Order Line PO Number
- Order Line Number and Order Line PO ID
- Order Line ID
Valid Transaction Type List
InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal