Skip to main content

 

 

Coupa Success Portal

Inventory Transactions (Receipts) Export

Overview

The inventory transaction export process from Coupa queries for all inventory transactions that have not been exported. The frequency of the integration run is once every hour.

The generated files will be placed into ./Outgoing/Inventory_Transactions . Once the files are successfully placed into the sFTP folder the inventory transactions will be marked/flagged as exported.

Voided Inventory Transactions can also be exported and will be placed into ./Outgoing/Inventory_Transactions/. Currently this is the only change to an Inventory Transaction that is captured in the integration.

Inventory Transactions Columns

Column Name Description Req'd Unique Type Allowable Values
Record Type Describes the type of row. Possible value is Inventory Transaction. FALSE FALSE - Inventory Transaction
ID Coupa's Internal Inventory Transaction ID FALSE FALSE integer any
Barcode Barcode Value FALSE FALSE string(255) any
Created at Time of Inventory Transaction Creation FALSE FALSE datetime any
Created-By email Email of user who created transaction record FALSE FALSE string(255) any
Created-By employee number Employee Number of user who created transaction record FALSE FALSE string(255) any
Created-By id Internal Coupa User ID for user who created transaction FALSE FALSE int(11) any
Created-By login Login of user who created transaction record FALSE FALSE string(255) any
Created-By Lastname, Firstname Employee Name who created transaction record FALSE FALSE string(255) any
Price Item Price FALSE FALSE decimal(30,6) any
Quantity Receipt Quantity FALSE FALSE decimal(30,6) any
RFID Tag RFID Tag Value TRUE FALSE string(255) any
Total Receipt Total FALSE FALSE decimal(32,4) any
Type Inventory Transaction Type FALSE FALSE string(255) any
Status Inventory Transaction Status. Default is Created FALSE FALSE string(255) any
Updated-At Time of Inventory Transaction Updation FALSE FALSE datetime any
Updated-By email Email of user who updated transaction record FALSE FALSE string(255) any
Updated-By employee number Employee Number of user who updated transaction record FALSE FALSE string(255) any
Updated-By id Internal Coupa User ID for user who updated transaction FALSE FALSE int(11) any
Updated-By login Login of user who updated transaction record FALSE FALSE string(255) any
Updated-By Lastname, Firstname Employee Name who updated transaction record FALSE FALSE string(255) any
Exported Has the transaction been exported? FALSE FALSE boolean any
Account Code Receipt Account Code FALSE FALSE string(255) any
Chart of Accounts Chart of Accounts Name FALSE FALSE Int(11) any
From Warehouse Location ID Coupa's Internal To-Warehouse-Location ID FALSE FALSE int(11) any
From Warehouse Aisle Warehouse Aisle Location FALSE FALSE string(255) any
From Warehouse Bin Warehouse Bin Location FALSE FALSE string(255) any
From Warehouse Level Warehouse Level Location FALSE FALSE string(255) any
From Warehouse - Warehouse ID Warehouse ID FALSE FALSE int(11) any
From Warehouse - Warehouse Description Warehouse Description FALSE FALSE string(255) any
From Warehouse - Warehouse Name Warehouse Name FALSE FALSE string(255) any
From Warehouse Type ID Coupa's Internal Warehouse Type ID FALSE FALSE int(11) any
From Warehouse Type Name Warehouse Type Name FALSE FALSE string(255) any
From Warehouse Type Description Warehouse Type Description FALSE FALSE string(255) any
Order Line ID Coupa Internal ID of line received against FALSE FALSE int(11) any
Order Line Accounting-Total Total Line value in Accounting Currency FALSE FALSE decimal(32,4) any
Order Line Created-At Date Line was Created FALSE FALSE datetime any
Order Line Description Order Line Description FALSE FALSE string(255) any
Order Line Qty Invoiced Order Line Quantity Invoiced FALSE FALSE decimal(30,6) any
Order Line Number Line Number on Order FALSE FALSE string(255) any
Order Line Need By Date Date Line was Updated FALSE FALSE datetime any
Order Line PO ID Coupa's Internal PO Header ID FALSE FALSE int(11) any
Order Line Price Order Line Unit Price FALSE FALSE decimal(30,6) any
Order Line Quantity Quantity Ordered on Order Line FALSE FALSE decimal(30,6) any
Order Line Received Quantity Received against order line FALSE FALSE decimal(32,4) any
Order Line Source Part Number Source Part Number for Order Line FALSE FALSE string(255) any
Order Line Status Status for Order Line FALSE FALSE string(50) any
Order Line Sub-line-num Reserved for future use FALSE FALSE int(11) any
Order Line Supp-Aux-Part-Num Supplier Auxiliary Part Number for Order Line FALSE FALSE string(255) any
Order Line Total Total for Order Line FALSE FALSE decimal(32,4) any
Order Line Type Type of Order Line (Quanity or Service) FALSE FALSE string(100) any
Order Line Updated-At Date Order Line was last updated FALSE FALSE datetime any
Order Line Version Order Line version Number FALSE FALSE int(11) any
Order Line Account Code Account Code on PO Line FALSE FALSE string(1024) any
Order Line Chart of Accounts Chart of Accounts Name on PO Line FALSE FALSE string(50) any
Order Line Accounting Total Currency Accounting Currency Code for Order Line FALSE FALSE string(6) any
Order Line Currency Currency Code for Order Line amounts FALSE FALSE string(6) any
Order Line Commodity Name Commodity Name for Item on Order Line FALSE FALSE string(255) any
Order Line Department Name Department Name for Item on Order Line FALSE FALSE string(255) any
Order Line Item ID Coupa's Internal Item ID for Item on Order Line FALSE FALSE int(11) any
Order Line Item Number Item Number FALSE FALSE string(255) any
Order Line Item Name Item Name FALSE FALSE string(255) any
Order Line Supplier Name Supplier Name FALSE FALSE string(100) any
Order Line Item Supplier Number Supplier Number FALSE FALSE string(255) any
To Warehouse Location ID Coupa's Internal To-Warehouse-Location ID FALSE FALSE int(11) any
To Warehouse Aisle Warehouse Aisle Location FALSE FALSE string(255) any
To Warehouse Bin Warehouse Bin Location FALSE FALSE string(255) any
To Warehouse Level Warehouse Level Location FALSE FALSE string(255) any
To Warehouse - Warehouse ID Warehouse ID FALSE FALSE int(11) any
To Warehouse - Warehouse Description Warehouse Description FALSE FALSE string(255) any
To Warehouse - Warehouse Name Warehouse Name FALSE FALSE string(255) any
To Warehouse Type ID Coupa's Internal Warehouse Type ID FALSE FALSE int(11) any
To Warehouse Type Name Warehouse Type Name FALSE FALSE string(255) any
To Warehouse Type Description Warehouse Type Description FALSE FALSE string(255) any
UOM Code Unit of Measure Code FALSE FALSE string(6) any
Inspection Code Inspection Code FALSE FALSE string(255) any
Inspection Code ID Coupa's Internal Inspection Code ID FALSE FALSE int(11) any
Inspection Code Description Inspection Code Description FALSE FALSE string(255) any
Inspection Code Created-By email email of user who created inspection code record FALSE FALSE string(255) any
Inspection Code Created-By employee number Employee Number of user who created inspection code record FALSE FALSE string(255) any
Inspection Code Created-By id Internal Coupa User ID for user who created inspection code FALSE FALSE int(11) any
Inspection Code Created-By login Login of user who created inspection code record FALSE FALSE string(255) any
Inspection Code Created-By Lastname, Firstname Employee Name who created inspection code record FALSE FALSE string(255) any
Inspection Code Created-At Date Inspection Code was created. FALSE FALSE datetime any
Inspection Code Updated-By email email of user who updated inspection code record FALSE FALSE string(255) any
Inspection Code Updated-By employee number Employee Number of user who updated inspection code record FALSE FALSE string(255) any
Inspection Code Updated-By id Internal Coupa User ID for user who updated inspection code FALSE FALSE int(11) any
Inspection Code Updated-By login Login of user who updated inspection code record FALSE FALSE string(255) any
Inspection Code Updated-By Lastname, Firstname Employee Name who updated inspection code record FALSE FALSE string(255) any
Inspection Code Updated-At Date Inspection Code was Updated. FALSE FALSE datetime any
Asset Tag Semi Colon seperated list of Asset Tag Identifiers FALSE FALSE int(11) any
Asset Tag Serial Number Semi Colon seperated list of Asset Serial Number FALSE FALSE string(255) any
Asset Tag Owner Semi Colon seperated list of Asset Owner FALSE FALSE string(255) any
Asset Tag Note Semi Colon seperated list of Additional Notes FALSE FALSE text(2^16) any
Transaction Reason Inventory Code Name FALSE FALSE string(255) any
Transaction Code Inventory Code FALSE FALSE string(255) any
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any
  • Was this article helpful?