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/Receipts. Once the files are successfully placed into the sFTP folder the inventory transactions will be marked/flagged as exported. Export of these records is included as a Standard CSV Export.

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

For languages that use spaces as a currency delimiter, the CSV export interprets the space as “&nbsp.

Inventory Transaction

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeDescribes the type of row. Possible value is Inventory Transaction.No/No
IDCoupa's Internal Inventory Transaction IDintegerNo/No
BarcodeBarcode Valuestring(255)No/No
Created atTime of Inventory Transaction CreationdatetimeNo/No
Created-By emailEmail of user who created transaction recordNo/No
Created-By employee numberEmployee Number of user who created transaction recordNo/No
Created-By idInternal Coupa User ID for user who created transactionNo/No
Created-By loginLogin of user who created transaction recordNo/No
Created-By Lastname, FirstnameEmployee Name who created transaction recordNo/No
PriceItem Pricedecimal(30,6)No/No
QuantityReceipt QuantityNo/No
RFID TagRFID Tag Valuestring(255)Yes/No
TotalReceipt Totaldecimal(30,6)No/No
TypeInventory Transaction Typestring(255)Yes/No
StatusInventory Transaction Statusstring(255)No/No
Updated-AtTime of Inventory Transaction UpdationdatetimeNo/No
Updated-By emailEmail of user who updated transaction recordNo/No
Updated-By employee numberEmployee Number of user who updated transaction recordNo/No
Updated-By idInternal Coupa User ID for user who updated transactionNo/No
Updated-By loginLogin of user who updated transaction recordNo/No
Updated-By Lastname, FirstnameEmployee Name who updated transaction recordNo/No
ExportedHas the transaction been exported?No/No
Account CodeReceipt Account CodeNo/No
Chart of AccountsChart of Accounts NameNo/No
From Warehouse Location IDCoupa's Internal To-Warehouse-Location IDNo/No
From Warehouse AisleWarehouse Aisle LocationNo/No
From Warehouse BinWarehouse Bin LocationNo/No
From Warehouse LevelWarehouse Level LocationNo/No
From Warehouse - Warehouse IDWarehouse IDNo/No
From Warehouse - Warehouse DescriptionWarehouse DescriptionNo/No
From Warehouse - Warehouse NameWarehouse NameNo/No
From Warehouse Type IDCoupa's Internal Warehouse Type IDNo/No
From Warehouse Type NameWarehouse Type NameNo/No
From Warehouse Type DescriptionWarehouse Type DescriptionNo/No
Order Line IDCoupa Internal ID of line received againstNo/No
Order Line Accounting-TotalTotal Line value in Accounting CurrencyNo/No
Order Line Created-AtDate Line was CreatedNo/No
Order Line DescriptionOrder Line DescriptionNo/No
Order Line Qty InvoicedOrder Line Quantity InvoicedNo/No
Order Line NumberLine Number on OrderNo/No
Order Line Need By DateDate Line was UpdatedNo/No
Order Line PO IDCoupa's Internal PO Header IDNo/No
Order Line PriceOrder Line Unit PriceNo/No
Order Line QuantityQuantity Ordered on Order LineNo/No
Order Line ReceivedQuantity Received against order lineNo/No
Order Line Source Part NumberSource Part Number for Order LineNo/No
Order Line StatusStatus for Order LineNo/No
Order Line Sub-line-numReserved for future useNo/No
Order Line Supp-Aux-Part-NumSupplier Auxiliary Part Number for Order LineNo/No
Order Line TotalTotal for Order LineNo/No
Order Line TypeType of Order Line (Quanity or Service)No/No
Order Line Updated-AtDate Order Line was last updatedNo/No
Order Line VersionOrder Line version NumberNo/No
Order Line Account CodeAccount Code on PO LineNo/No
Order Line Chart of AccountsChart of Accounts Name on PO LineNo/No
Order Line Accounting Total CurrencyAccounting Currency Code for Order LineNo/No
Order Line CurrencyCurrency Code for Order Line amountsNo/No
Order Line Commodity NameCommodity Name for Item on Order LineNo/No
Order Line Department NameDepartment Name for Item on Order LineNo/No
Order Line Item IDCoupa's Internal Item ID for Item on Order LineNo/No
Order Line Item NumberItem NumberNo/No
Order Line Item NameItem NameNo/No
Order Line Supplier NameSupplier NameNo/No
Order Line Item Supplier NumberSupplier NumberNo/No
To Warehouse Location IDCoupa's Internal To-Warehouse-Location IDNo/No
To Warehouse AisleWarehouse Aisle LocationNo/No
To Warehouse BinWarehouse Bin LocationNo/No
To Warehouse LevelWarehouse Level LocationNo/No
To Warehouse - Warehouse IDWarehouse IDNo/No
To Warehouse - Warehouse DescriptionWarehouse DescriptionNo/No
To Warehouse - Warehouse NameWarehouse NameNo/No
To Warehouse Type IDCoupa's Internal Warehouse Type IDNo/No
To Warehouse Type NameWarehouse Type NameNo/No
To Warehouse Type DescriptionWarehouse Type DescriptionNo/No
UOM CodeUnit of Measure CodeNo/No
Inspection CodeInspection CodeNo/No
Inspection Code IDCoupa's Internal Inspection Code IDNo/No
Inspection Code DescriptionInspection Code DescriptionNo/No
Inspection Code Created-By emailemail of user who created inspection code recordNo/No
Inspection Code Created-By employee numberEmployee Number of user who created inspection code recordNo/No
Inspection Code Created-By idInternal Coupa User ID for user who created inspection codeNo/No
Inspection Code Created-By loginLogin of user who created inspection code recordNo/No
Inspection Code Created-By Lastname, FirstnameEmployee Name who created inspection code recordNo/No
Inspection Code Created-AtDate Inspection Code was created.No/No
Inspection Code Updated-By emailemail of user who updated inspection code recordNo/No
Inspection Code Updated-By employee numberEmployee Number of user who updated inspection code recordNo/No
Inspection Code Updated-By idInternal Coupa User ID for user who updated inspection codeNo/No
Inspection Code Updated-By loginLogin of user who updated inspection code recordNo/No
Inspection Code Updated-By Lastname, FirstnameEmployee Name who updated inspection code recordNo/No
Inspection Code Updated-AtDate Inspection Code was Updated.No/No
Asset TagSemi Colon seperated list of Asset Tag IdentifiersNo/No
Asset Tag Serial NumberSemi Colon seperated list of Asset Serial NumberNo/No
Asset Tag OwnerSemi Colon seperated list of Asset OwnerNo/No
Asset Tag NoteSemi Colon seperated list of Additional NotesNo/No
Transaction ReasonInventory Code NameNo/No
Transaction CodeInventory CodeNo/No
Received WeightReceived Weightdecimal(30,6)No/No
Match ReferenceThree-way match attribute to connect with Receipt and Invoice Headerstring(255)No/No
Transaction ReferenceID of original transactionintegerNo/No
Reason InsightReason Insight CodeNo/No
Inventory Request NumberInventory Request NumberNo/No
Inventory Request RMAInventory Request RMANo/No
Inventory Request Address Location CodeInventory Request Address Location CodeNo/No
Inventory Request Address AttentionInventory Request Address AttentionNo/No
Inventory Request Address NameInventory Request Address NameNo/No
Inventory Request Address Street1Inventory Request Address Street1No/No
Inventory Request Address Street2Inventory Request Address Street2No/No
Inventory Request Address CityInventory Request Address CityNo/No
Inventory Request Address StateInventory Request Address StateNo/No
Inventory Request Address Postal CodeInventory Request Address Postal CodeNo/No
Inventory Request Address Country CodeInventory Request Address Country CodeNo/No

Inventory Txn Allocation

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeDescribes the type of row. Possible value is Line Split.No/No
Inventory Transaction IdCoupa's Inventory Transaction ID.integerNo/No
PO NumberCoupa's Order Header Number.No/No
Order Line IdCoupa's Order Line ID.No/No
Order Line NumberCoupa's Order Line Number.No/No
IdAccount Allocation IDintegerNo/No
Allocation NumberPosition in the Account Allocation SequenceNo/No
AmountAmount allocated to the accountdecimal(32,4)No/No
PercentPercentage allocated to the accountdecimal(16,10)Yes/No
CurrencyCurrencyNo/No
Account CodeAccount CodeNo/No
Account ActiveAccount ActiveNo/No
Account Segment 1Account Segment 1No/No
Account Segment 2Account Segment 2No/No
Account Segment 3Account Segment 3No/No
Account Segment 4Account Segment 4No/No
Account Segment 5Account Segment 5No/No
Account Segment 6Account Segment 6No/No
Account Segment 7Account Segment 7No/No
Account Segment 8Account Segment 8No/No
Account Segment 9Account Segment 9No/No
Account Segment 10Account Segment 10No/No
Account Segment 11Account Segment 11No/No
Account Segment 12Account Segment 12No/No
Account Segment 13Account Segment 13No/No
Account Segment 14Account Segment 14No/No
Account Segment 15Account Segment 15No/No
Account Segment 16Account Segment 16No/No
Account Segment 17Account Segment 17No/No
Account Segment 18Account Segment 18No/No
Account Segment 19Account Segment 19No/No
Account Segment 20Account Segment 20No/No
Account NameAccount NameNo/No
Account TypeAccount TypeNo/No

Inventory Transaction Valuation

Field NameDescriptionField TypeRequired/UniquePossible Values
Record TypeDescribes the type of row. Possible value is Line Split.No/No
Inventory Transaction IdCoupa's Inventory Transaction ID.integerNo/No
QuantityQuantity of Valuationdecimal(30,6)Yes/No
Uom CodeUom Code from CoupaNo/No
CurrencyThe currency code of the valuation.No/No
PricePrice of Valuationdecimal(30,6)No/No

Valid Transaction Type List

InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption, ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal, InventoryTransferOut, InventoryAdjustment