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 five 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
  • Order Line PO Number and Order Line Number
Column Name Description Req'd Unique Type Allowable Values
ID This is the unique identifier (database ID) Coupa assigns when a new record is created. It can’t be modified, but can be used to update the record. 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 TRUE FALSE string(255) InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal
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 accommodate the ERP Id. See note below. FALSE FALSE string(255) any
Transaction Reference ID of original transaction FALSE FALSE integer any
Reason Insight Reason Insight Code FALSE FALSE any

*One of the following five sets of columns are required:

  • ID
  • Order Line ID
  • Order Line ID and Order Line PO Number
  • Order Line Number and Order Line PO ID
  • Order Line Number and Order Line PO Number
  • Order Line PO Number and Order Line Number

Note: For Receipts created through ERP, the External_ID (the unique ERP number per transaction) should be populated in Coupa, If the same receipt is required to be voided using integration, the same External_ID field should be passed to Coupa for voiding the externally integrated transaction.