Tableau Connector for Workday

Build 20.0.7740

PurchaseItems_Item_Inventory_Attributes_Data

Added Patient Chargeable flag to Inventory Site Options

Columns

Name Type References Description
PurchaseItem_Purchase_Item_Reference_WID String

PurchaseItems.Purchase_Item_Reference_WID

The unique identifier type. Each
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.
Preferred_Picking_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Preferred_Picking_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Use_Reservations Bool Item level Reservation Flag. Can only be changed if reservations are enabled for the site. Can be used to disable reservations for an item belonging to a site which uses reservations.
Site_Default_Stocking_Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Site_Default_Stocking_Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Site_Default_Stocking_Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Valid_Issue_Units_of_Measure_Reference String References a list of valid issue units of measure
Site_Default_Issue_Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Site_Default_Issue_Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Site_Default_Issue_Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Default_Stocking_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Stocking_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Fulfillment_Lead_Time Decimal Lead time for the Site/Item combination.
Replenishment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Replenishment_Type_Reference_Replenishment_Type_ID String Contains a unique identifier for an instance of an object.
Average_Daily_Usage Decimal Inventory Average Daily Usage for item
Preferred_Supplier_Lead_Time Decimal Preferred Supplier Lead Time for the specified site for the purchase item.
Reorder_Point_Quantity Decimal Reorder point in base UOM.
Maximum_Quantity Decimal Maximum quantity in base UOM - only applicable if the replenishment policy is min-max.
Replenishment_Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Replenishment_Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Replenishment_Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Economic_Order_Quantity Decimal Economic Order Quantity value in the UOM specified by Replenishment Unit of Measure - only applicable if the replenishment policy is Fixed Reorder Quantity.
Fixed_Reorder_Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Fixed_Reorder_Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Fixed_Reorder_Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Inventory_ABC_Classification_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_ABC_Classification_Reference_Inventory_ABC_Classification_ID String Contains a unique identifier for an instance of an object.
Include_in_Count Bool The option of including Count
Patient_Chargeable_Reference_WID String Contains a unique identifier for an instance of an object.
Patient_Chargeable_Reference_Patient_Charge_ID String Contains a unique identifier for an instance of an object.
Replenishment_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Replenishment_Option_Reference_Replenishment_Option_ID String Contains a unique identifier for an instance of an object.
Source_Site_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Site_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Source_Requisition_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Requisition_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Source_Requisition_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Consigned_Reorder_Option_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Consigned_Reorder_Option_Type_Reference_Consigned_Reorder_Type_ID String Contains a unique identifier for an instance of an object.
Default_Consigned_Stocking_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Consigned_Stocking_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.

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