Inventory Transactions (Receipts) Export
Coupa's inventory transactions flat file integration object contains only a single set of header columns.
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.
| Position | Column Name | Description | Req'd/Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| 1 | Record Type | Describes the type of row. Possible value is Inventory Transaction. | No/No | - | Inventory Transaction |
| 2 | ID | Coupa's Internal Inventory Transaction ID | No/No | integer | any |
| 3 | Barcode | Barcode Value | No/No | string(255) | any |
| 4 | Created at | Time of Inventory Transaction Creation | No/No | datetime | any |
| 5 | Created-By email | Email of user who created transaction record | No/No | string(255) | any |
| 6 | Created-By employee number | Employee Number of user who created transaction record | No/No | string(255) | any |
| 7 | Created-By id | Internal Coupa User ID for user who created transaction | No/No | int(11) | any |
| 8 | Created-By login | Login of user who created transaction record | No/No | string(255) | any |
| 9 | Created-By Lastname, Firstname | Employee Name who created transaction record | No/No | string(255) | any |
| 10 | Price | Item Price | No/No | decimal(30,6) | any |
| 11 | Quantity | Receipt Quantity | No/No | decimal(30,6) | any |
| 12 | RFID Tag | RFID Tag Value | Yes/No | string(255) | any |
| 13 | Total | Receipt Total | No/No | decimal(30,6) | any |
| 14 | Type | Inventory Transaction Type | Yes/No | string(255) | InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal |
| 15 | Status | Inventory Transaction Status. Default is Created | No/No | string(255) | any |
| 16 | Updated-At | Time of Inventory Transaction Updation | No/No | datetime | any |
| 17 | Updated-By email | Email of user who updated transaction record | No/No | string(255) | any |
| 18 | Updated-By employee number | Employee Number of user who updated transaction record | No/No | string(255) | any |
| 19 | Updated-By id | Internal Coupa User ID for user who updated transaction | No/No | int(11) | any |
| 20 | Updated-By login | Login of user who updated transaction record | No/No | string(255) | any |
| 21 | Updated-By Lastname, Firstname | Employee Name who updated transaction record | No/No | string(255) | any |
| 22 | Exported | Has the transaction been exported? | No/No | boolean | any |
| 23 | Account Code | Receipt Account Code | No/No | string(1024) | any |
| 24 | Chart of Accounts | Chart of Accounts Name | No/No | Int(11) | any |
| 25 | From Warehouse Location ID | Coupa's Internal To-Warehouse-Location ID | No/No | int(11) | any |
| 26 | From Warehouse Aisle | Warehouse Aisle Location | No/No | string(255) | any |
| 27 | From Warehouse Bin | Warehouse Bin Location | No/No | string(255) | any |
| 28 | From Warehouse Level | Warehouse Level Location | No/No | string(255) | any |
| 29 | From Warehouse - Warehouse ID | Warehouse ID | No/No | int(11) | any |
| 30 | From Warehouse - Warehouse Description | Warehouse Description | No/No | string(255) | any |
| 31 | From Warehouse - Warehouse Name | Warehouse Name | No/No | string(255) | any |
| 32 | From Warehouse Type ID | Coupa's Internal Warehouse Type ID | No/No | int(11) | any |
| 33 | From Warehouse Type Name | Warehouse Type Name | No/No | string(255) | any |
| 34 | From Warehouse Type Description | Warehouse Type Description | No/No | string(255) | any |
| 35 | Order Line ID | Coupa Internal ID of line received against | No/No | int(11) | any |
| 36 | Order Line Accounting-Total | Total Line value in Accounting Currency | No/No | decimal(32,4) | any |
| 37 | Order Line Created-At | Date Line was Created | No/No | datetime | any |
| 38 | Order Line Description | Order Line Description | No/No | string(255) | any |
| 39 | Order Line Qty Invoiced | Order Line Quantity Invoiced | No/No | decimal(30,6) | any |
| 40 | Order Line Number | Line Number on Order | No/No | string(255) | any |
| 41 | Order Line Need By Date | Date Line was Updated | No/No | datetime | any |
| 42 | Order Line PO ID | Coupa's Internal PO Header ID | No/No | int(11) | any |
| 43 | Order Line Price |
Order Line Unit Price Note
For languages that use spaces as a currency delimiter, the CSV export interprets the space as: |
No/No | decimal(30,6) | any |
| 44 | Order Line Quantity | Quantity Ordered on Order Line | No/No | decimal(30,6) | any |
| 45 | Order Line Received | Quantity Received against order line | No/No | decimal(32,4) | any |
| 46 | Order Line Source Part Number | Source Part Number for Order Line | No/No | string(255) | any |
| 47 | Order Line Status | Status for Order Line | No/No | string(50) | any |
| 48 | Order Line Sub-line-num | Reserved for future use | No/No | int(11) | any |
| 49 | Order Line Supp-Aux-Part-Num | Supplier Auxiliary Part Number for Order Line | No/No | string(255) | any |
| 50 | Order Line Total | Total for Order Line | No/No | decimal(32,4) | any |
| 51 | Order Line Type | Type of Order Line (Quanity or Service) | No/No | string(100) | any |
| 52 | Order Line Updated-At | Date Order Line was last updated | No/No | datetime | any |
| 53 | Order Line Version | Order Line version Number | No/No | int(11) | any |
| 54 | Order Line Account Code | Account Code on PO Line | No/No | string(1024) | any |
| 55 | Order Line Chart of Accounts | Chart of Accounts Name on PO Line | No/No | string(50) | any |
| 56 | Order Line Accounting Total Currency | Accounting Currency Code for Order Line | No/No | string(6) | any |
| 57 | Order Line Currency | Currency Code for Order Line amounts | No/No | string(6) | any |
| 58 | Order Line Commodity Name | Commodity Name for Item on Order Line | No/No | string(255) | any |
| 59 | Order Line Department Name | Department Name for Item on Order Line | No/No | string(255) | any |
| 60 | Order Line Item ID | Coupa's Internal Item ID for Item on Order Line | No/No | int(11) | any |
| 61 | Order Line Item Number | Item Number | No/No | string(255) | any |
| 62 | Order Line Item Name | Item Name | No/No | string(255) | any |
| 63 | Order Line Supplier Name | Supplier Name | No/No | string(100) | any |
| 64 | Order Line Item Supplier Number | Supplier Number | No/No | string(255) | any |
| 65 | To Warehouse Location ID | Coupa's Internal To-Warehouse-Location ID | No/No | int(11) | any |
| 66 | To Warehouse Aisle | Warehouse Aisle Location | No/No | string(255) | any |
| 67 | To Warehouse Bin | Warehouse Bin Location | No/No | string(255) | any |
| 68 | To Warehouse Level | Warehouse Level Location | No/No | string(255) | any |
| 69 | To Warehouse - Warehouse ID | Warehouse ID | No/No | int(11) | any |
| 70 | To Warehouse - Warehouse Description | Warehouse Description | No/No | string(255) | any |
| 71 | To Warehouse - Warehouse Name | Warehouse Name | No/No | string(255) | any |
| 72 | To Warehouse Type ID | Coupa's Internal Warehouse Type ID | No/No | int(11) | any |
| 73 | To Warehouse Type Name | Warehouse Type Name | No/No | string(255) | any |
| 74 | To Warehouse Type Description | Warehouse Type Description | No/No | string(255) | any |
| 75 | UOM Code | Unit of Measure Code | No/No | string(6) | any |
| 76 | Inspection Code | Inspection Code | No/No | string(255) | any |
| 77 | Inspection Code ID | Coupa's Internal Inspection Code ID | No/No | int(11) | any |
| 78 | Inspection Code Description | Inspection Code Description | No/No | string(255) | any |
| 79 | Inspection Code Created-By email | email of user who created inspection code record | No/No | string(255) | any |
| 80 | Inspection Code Created-By employee number | Employee Number of user who created inspection code record | No/No | string(255) | any |
| 81 | Inspection Code Created-By id | Internal Coupa User ID for user who created inspection code | No/No | int(11) | any |
| 82 | Inspection Code Created-By login | Login of user who created inspection code record | No/No | string(255) | any |
| 83 | Inspection Code Created-By Lastname, Firstname | Employee Name who created inspection code record | No/No | string(255) | any |
| 84 | Inspection Code Created-At | Date Inspection Code was created. | No/No | datetime | any |
| 85 | Inspection Code Updated-By email | email of user who updated inspection code record | No/No | string(255) | any |
| 86 | Inspection Code Updated-By employee number | Employee Number of user who updated inspection code record | No/No | string(255) | any |
| 87 | Inspection Code Updated-By id | Internal Coupa User ID for user who updated inspection code | No/No | int(11) | any |
| 88 | Inspection Code Updated-By login | Login of user who updated inspection code record | No/No | string(255) | any |
| 89 | Inspection Code Updated-By Lastname, Firstname | Employee Name who updated inspection code record | No/No | string(255) | any |
| 90 | Inspection Code Updated-At | Date Inspection Code was Updated. | No/No | datetime | any |
| 91 | Asset Tag | Semi Colon seperated list of Asset Tag Identifiers | No/No | int(11) | any |
| 92 | Asset Tag Serial Number | Semi Colon seperated list of Asset Serial Number | No/No | string(255) | any |
| 93 | Asset Tag Owner | Semi Colon seperated list of Asset Owner | No/No | string(255) | any |
| 94 | Asset Tag Note | Semi Colon seperated list of Additional Notes | No/No | text(2^16) | any |
| 95 | Transaction Reason | Inventory Code Name | No/No | string(255) | any |
| 96 | Transaction Code | Inventory Code | No/No | string(255) | any |
| 97 | Received Weight | Received Weight | No/No | decimal(30,6) | any |
| 98 | Match Reference | Three-way match attribute to connect with Receipt and Invoice Header. | No/No | string(255) | any |
| 99 | custom-field-1 | Integration Custom Field 1 | No/No | string(255) | any |
| 100 | custom-field-2 | Integration Custom Field 2 | No/No | string(255) | any |
| 101 | custom-field-3 | Integration Custom Field 3 | No/No | string(255) | any |
| 102 | custom-field-4 | Integration Custom Field 4 | No/No | string(255) | any |
| 103 | custom-field-5 | Integration Custom Field 5 | No/No | string(255) | any |
| 104 | custom-field-6 | Integration Custom Field 6 | No/No | string(255) | any |
| 105 | custom-field-7 | Integration Custom Field 7 | No/No | string(255) | any |
| 106 | custom-field-8 | Integration Custom Field 8 | No/No | string(255) | any |
| 107 | custom-field-9 | Integration Custom Field 9 | No/No | string(255) | any |
| 108 | custom-field-10 | Integration Custom Field 10 | No/No | string(255) | any |
| 109 | Transaction Reference | ID of original transaction | No/No | integer | any |
| 110 | Reason Insight | Reason Insight Code | No/No | any | |
| 111 | Inventory Request Number | Inventory Request Number | No/No | any | |
| 112 | Inventory Request RMA | Inventory Request RMA | No/No | any | |
| 113 | Inventory Request Address Location Code | Inventory Request Address Location Code | No/No | any | |
| 114 | Inventory Request Address Attention | Inventory Request Address Attention | No/No | any | |
| 115 | Inventory Request Address Name | Inventory Request Address Name | No/No | any | |
| 116 | Inventory Request Address Street1 | Inventory Request Address Street1 | No/No | any | |
| 117 | Inventory Request Address Street2 | Inventory Request Address Street2 | No/No | any | |
| 118 | Inventory Request Address City | Inventory Request Address City | No/No | any | |
| 119 | Inventory Request Address State | Inventory Request Address State | No/No | any | |
| 120 | Inventory Request Address Postal Code | Inventory Request Address Postal Code | No/No | any | |
| 121 | Inventory Request Address Country Code | Inventory Request Address Country Code | No/No | any |
Inventory transaction allocation (line split) columns
| Position | Column Name | Description | Req'd/Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| 1 | Record Type | Describes the type of row. Possible value is Line Split. | No/No | - | Line Split |
| 2 | Inventory Transaction Id | Coupa's Inventory Transaction ID. | No/No | integer(11) | |
| 3 | PO Number | Coupa's Order Header Number. | No/No | string(20) | |
| 4 | Order Line Id | Coupa's Order Line ID. | No/No | integer(11) | |
| 5 | Order Line Number | Coupa's Order Line Number. | No/No | string(255) | |
| 6 | Id | Account Allocation ID | No/No | integer(11) | |
| 7 | Allocation Number | Position in the Account Allocation Sequence | No/No | integer(11) | |
| 8 | Amount | Amount allocated to the account | No/No | decimal(32,4) | |
| 9 | Percent | Percentage allocated to the account | Yes/No | decimal(16,10) | |
| 10 | Currency | Currency Code | No/No | string(6) | |
| 11 | Account Code | Account Code | No/No | string(1024) | |
| 12 | Account Active | Account Active | No/No | boolean | |
| 13 | Account Segment 1 | Account Segment 1 | No/No | string(100) | |
| 14 | Account Segment 2 | Account Segment 2 | No/No | string(100) | |
| 15 | Account Segment 3 | Account Segment 3 | No/No | string(100) | |
| 16 | Account Segment 4 | Account Segment 4 | No/No | string(100) | |
| 17 | Account Segment 5 | Account Segment 5 | No/No | string(100) | |
| 18 | Account Segment 6 | Account Segment 6 | No/No | string(100) | |
| 19 | Account Segment 7 | Account Segment 7 | No/No | string(100) | |
| 20 | Account Segment 8 | Account Segment 8 | No/No | string(100) | |
| 21 | Account Segment 9 | Account Segment 9 | No/No | string(100) | |
| 22 | Account Segment 10 | Account Segment 10 | No/No | string(100) | |
| 23 | Account Segment 11 | Account Segment 11 | No/No | string(100) | |
| 24 | Account Segment 12 | Account Segment 12 | No/No | string(100) | |
| 25 | Account Segment 13 | Account Segment 13 | No/No | string(100) | |
| 26 | Account Segment 14 | Account Segment 14 | No/No | string(100) | |
| 27 | Account Segment 15 | Account Segment 15 | No/No | string(100) | |
| 28 | Account Segment 16 | Account Segment 16 | No/No | string(100) | |
| 29 | Account Segment 17 | Account Segment 17 | No/No | string(100) | |
| 30 | Account Segment 18 | Account Segment 18 | No/No | string(100) | |
| 31 | Account Segment 19 | Account Segment 19 | No/No | string(100) | |
| 32 | Account Segment 20 | Account Segment 20 | No/No | string(100) | |
| 33 | Account Name | Account Name | No/No | string(1024) | |
| 34 | Account Type | Account Type | No/No | string(50) |
| Position | Column Name | Description | Req'd/Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| 1 | Type | Describes the type of row. Possible values are Payment, Payment Details or Payment Detail Allocation | No/No | any | |
| 2 | Payment Detail Allocation ID | The ID of the payment detail allocation | No/No | integer | any |
| 3 | Payment ID | The ID of the payment the payment detail belongs to | No/No | any | |
| 4 | Payment Detail ID | The ID of the payment detail the allocation belongs to | No/No | any | |
| 5 | Source Transaction From ID | The ID of the transaction that emitted the allocation | No/No | any | |
| 6 | Source Transaction From Type | The type of the transaction that emitted the allocation. Possible values are InvoiceHeader. | No/No | any | |
| 7 | Source Transaction From Number | The reference ID of the transaction that emitted the allocation | No/No | any | |
| 8 | Source Transaction From Amount | The amount sent by the transaction that emitted the allocation | No/No | any | |
| 9 | Source Transaction From Currency | The currency for the amount sent by the transaction that emitted the allocation | No/No | any | |
| 10 | Source Transaction To ID | The ID of the receiving transaction | No/No | any | |
| 11 | Source Transaction To Type | The type of the receiving transaction. Possible values are InvoiceHeader. | No/No | any | |
| 12 | Source Transaction To Number | The reference ID of the receiving transaction | No/No | any | |
| 13 | Source Transaction To Amount | The amount sent to the receiving transaction | No/No | any | |
| 14 | Source Transaction To Currency | The currency for the amount sent to the receiving transaction | No/No | any | |
| 15 | Source | The source of this allocation. Possible values are coupa_pay. | No/No | string(255) | coupa_pay, erp |
| 16 | custom-field-1 | Integration Custom Field 1 | No/No | any | |
| 17 | custom-field-2 | Integration Custom Field 2 | No/No | any | |
| 18 | custom-field-3 | Integration Custom Field 3 | No/No | any | |
| 19 | custom-field-4 | Integration Custom Field 4 | No/No | any | |
| 20 | custom-field-5 | Integration Custom Field 5 | No/No | any | |
| 21 | custom-field-6 | Integration Custom Field 6 | No/No | any | |
| 22 | custom-field-7 | Integration Custom Field 7 | No/No | any | |
| 23 | custom-field-8 | Integration Custom Field 8 | No/No | any | |
| 24 | custom-field-9 | Integration Custom Field 9 | No/No | any | |
| 25 | custom-field-10 | Integration Custom Field 10 | No/No | any |
Valid Transaction Type List
InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption, ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal, InventoryTransferOut, InventoryAdjustment