Skip to main content

 

 

Coupa Success Portal

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) See 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

* 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

  • Was this article helpful?