Tableau Connector for Workday

Build 20.0.7740

InventoryTransactions

Inventory Transaction Data payload

Columns

Name Type References Description
Inventory_Transaction_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Transaction_Type_Reference_Inventory_Transaction_Type_ID String Contains a unique identifier for an instance of an object.
Transaction_Date_Time Datetime Transaction Date Time
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Inventory_Site_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Site_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Created_By_Reference_WID String Contains a unique identifier for an instance of an object.
Created_By_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Created_By_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Consigned Bool Consigned transaction indicator
Location_Reference_WID String Contains a unique identifier for an instance of an object.
Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
To_From_Inventory_Site_Reference String To / From Inventory Site Reference
Requester_Reference_WID String Contains a unique identifier for an instance of an object.
Requester_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Requester_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Item_Lot_Reference_WID String Contains a unique identifier for an instance of an object.
Item_Lot_Reference_Item_Lot_ID String Contains a unique identifier for an instance of an object.
Serial_Number_Reference String Reference of the serial numbers of the Inventory Item being issued
Transaction_Stocking_Quantity Decimal Transaction Stocking Quantity
Unit_of_Measure_CF_Reference_IID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_CF_Reference_WID String Contains a unique identifier for an instance of an object.
Total_Base_Quantity_On_Hand Decimal Total Base Quantity On Hand
Transaction_Unit_Cost Decimal Transaction Unit Cost
Inventory_Transaction_Cost_Markup Decimal Inventory Transaction Cost Markup
Base_Unit_Cost Decimal Base Unit Cost
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Transaction_Base_Currency_Conversion_Rate Decimal Transaction Base Currency Conversion Rate
Prior_Average_Cost Decimal Prior Average Cost
Average_Cost_In_Base_Currency Decimal Average Cost In Base Currency
Accounting_Date_for_Inventory_Transaction Date Accounting Date for Inventory Transaction
Inventory_Transaction_Line_Split_Data String Worktags
External_ID String Contains the Unique External ID. This field allows WS users to uniquely identify every WS call with a unique ID.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740