Tableau Connector for Workday

Build 20.0.7740

InventoryLocationAttributes_Inventory_Location_Attributes_Detail_Data

Inventory Location Attributes Data payload

Columns

Name Type References Description
InventoryLocationAttributesDetail_Inventory_Location_Attributes_Reference_WID String

InventoryLocationAttributes.Inventory_Location_Attributes_Reference_WID

The unique identifier type. Each
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.
Inventory_Location_Attributes_Reference_ID String Reference ID for Inventory Location Attributes
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.
Fulfillment_Procurement_Company_Reference String Procurement Company Reference
Time_Zone_Reference_WID String Contains a unique identifier for an instance of an object.
Time_Zone_Reference_Time_Zone_ID String Contains a unique identifier for an instance of an object.
Inventory_Site Bool Inventory Site
Is_Zone Bool Zone indicator for Inventory Location Attributes
Stocking_Location Bool Stocking Location
Inventory_Movement_On_Hold Bool Inventory Movement On Hold
Include_in_Count Bool Include in Count
Consigned_Reorder_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Consigned_Reorder_Type_Reference_Consigned_Reorder_Type_ID String Contains a unique identifier for an instance of an object.
Inventory_Location_Usage_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Location_Usage_Type_Reference_Inventory_Usage_Type String Contains a unique identifier for an instance of an object.
Worktags_Reference String Reference to existing worktags. Worktags are a way to mark tasks and business objects to make them easier to access and summarize. Each transaction can include one value for each worktag type and is subject to configurable validation when submitted for approval.
Fulfillment_Lead_Time Decimal Fulfillment Lead Time
Stocking_Location_Sort_Order String Stocking Location Sort Order
Goods_Ownership_Reference_WID String Contains a unique identifier for an instance of an object.
Goods_Ownership_Reference_Goods_Ownership_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_Inventory_Site_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Inventory_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.
Replenishment_Procurement_Company_Reference String Replenishment Procurement Company
Replenishment_On_Order_Document_Status_Option_Reference String Replenishment On-Order Document Status Option
Replenishment_Open_Demand_Document_Status_Option_Reference String Replenishment Open Demand Document Status Option
Blind_Counting Bool Blind Counting
Compare_Base_UOM_Quantity_Only Bool Compare Base UOM Quantity Only
Item_Substitutes_Allowed Bool Item Substitutes Allowed
Reserve_Inventory Bool Reserve Inventory
Reserve_Stock_Requests_Upon_Approval Bool Reserve Stock Requests Upon Approval
Inventory_Shortage_Fill_or_Kill_Option_for_NonPar_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Shortage_Fill_or_Kill_Option_for_NonPar_Reference_Inventory_Shortage_Fill_or_Kill_Option String Contains a unique identifier for an instance of an object.
Apply_Kill_or_Backorder_to_Entire_Stock_Request_for_NonPar Bool Boolean to indicate whether notications should be sent regarding short shipments for non-par stock requests
Inventory_Shortage_Fill_or_Kill_Option_for_Par_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Shortage_Fill_or_Kill_Option_for_Par_Reference_Inventory_Shortage_Fill_or_Kill_Option String Contains a unique identifier for an instance of an object.
Apply_Kill_or_Backorder_to_Entire_Stock_Request_for_Par Bool Boolean to indicate whether notications should be sent regarding short shipments for par stock requests
Hold_From_Fulfillment Bool Boolean to indicate whether an auto-created backorder line should have the Hold From Fulfillment flag set to True or False.
Default_Inventory_Adjustment_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Inventory_Adjustment_Reason_Reference_Inventory_Adjustment_Reason_ID String Contains a unique identifier for an instance of an object.
Assigned_To_Alert_Behavior_Reference_WID String Contains a unique identifier for an instance of an object.
Assigned_To_Alert_Behavior_Reference_Assigned_To_Alert_Behavior_Reference_ID String Contains a unique identifier for an instance of an object.
Create_Picking_List_Upon_Stock_Request_Approval Bool Boolean to indicate whether pick lists for a site should be automatically created when a stock requests are approved.
Use_Directed_Picking Bool Boolean to indicate whether directed picking will be used in the site.
Use_Zone_Picking Bool Enable Zone Picking on the Inventory Site. Can only use when Directed Picking is also enabled.
Inventory_Zone_Picking_Merge_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Inventory_Zone_Picking_Merge_Option_Reference_Inventory_Zone_Picking_Merge_Option_ID String Contains a unique identifier for an instance of an object.
Use_Smallest_Quantity_First Bool Boolean to indicate whether pickers are directed to pick from stocking locations to consume smallest inventory quantities first or directed to pick with a minimum number of stops to fill a stock request line.
Use_Substitutes_First Bool Boolean to indicate that substitutes of an item are to be used before the primary item when creating directed picking lists.
Apply_Shortage_Kill_or_Backorder_at_Directed_Picking_List_Creation Bool When Apply Shortage Kill or Backorder at Directed Picking List Creation is set to Yes, if the Fill/Kill Option is Backorder any unallocated quantity on the stock request lines will be backordered. If the shipment shortage options Apply Kill or Backorder to Entire Stock Request for Par or Non-Par flag is set to Yes, then the Kill or Backorder will be applied to any stock request lines which were not allocated due to stock-out.
Present_Picking_List_in_Location_Sort_Order Bool Boolean to indicate that directed pick list is presented using the sort order for stocking locations. Otherwise, pick lists are presented in order of stocking location name.
Allow_Quick_Pick_at_Line_Level Bool Boolean to indicate whether quantity to be picked will be defaulted on the directed pick lists for the site or whether quantity must always be entered manually.
Require_Item_Confirmation Bool Boolean to indicate that picker will need to scan the item before pick quantity may be entered when using directed picking.
Require_Location_Confirmation Bool Boolean to indicate that picker will need to scan the stocking location before pick quantity may be entered when using directed picking.
Fully_Pick Bool Boolean to allow Fully Pick functionality on desktop
Automatic_Unit_of_Measure_Conversion_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Automatic_Unit_of_Measure_Conversion_Option_Reference_Automatic_Unit_of_Measure_Conversion_Option_ID String Contains a unique identifier for an instance of an object.
Behavior_for_Expired_Lots_Reference_WID String Contains a unique identifier for an instance of an object.
Behavior_for_Expired_Lots_Reference_Lot_Expiration_Behavior_Reference_ID String Contains a unique identifier for an instance of an object.
Behavior_for_Expiring_Lots_Reference_WID String Contains a unique identifier for an instance of an object.
Behavior_for_Expiring_Lots_Reference_Lot_Expiration_Behavior_Reference_ID String Contains a unique identifier for an instance of an object.
Rounding_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Rounding_Option_Reference_Rounding_Option_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