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 Transaction Header Columns

# Column Name Description Type Req'd/Unique 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(32,4) any
14 Type Inventory Transaction Type No/No string(255) any
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(255) 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 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

Inventory Transaction Allocation (Line Split) Columns

# Column Name Description Type Req'd/Unique 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)  

Valid Transaction Type List

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

 

  • Was this article helpful?