Tableau Connector for Workday

Build 20.0.7740

PurchaseItems

Purchase Item

Columns

Name Type References Description
Purchase_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_Catalog_Item_ID 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.
Purchase_Item_Reference_Supplier_Item_ID String Contains a unique identifier for an instance of an object.
Purchase_Item_ID String Purchase Item ID. This is the Purchase Item unique identifier
Item_Name String Free form text field for meaningful Purchase Item Name
Resource_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Resource_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Last_Updated Datetime The exact moment in time this purchase item was last functionally updated - Cannot be updated
Item_Description String Free form text for Purchase Item Description
Item_Identifier String Free form test for Item Identifier. This is not the Item Reference ID, but a non-unique field for providing addition Item identification data.
Item_URL String Purchase Item URL
Item_Tag_Reference String Item tags for the Purchase Item.
Packaging_String String Packaging String for the Purchase Item.
Item_Unit_Price Decimal Currency field for Item Unit Price
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.
Tax_Applicability_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Applicability_Reference_Tax_Applicability_ID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_WID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_Accounting_Treatment_ID String Contains a unique identifier for an instance of an object.
Default_as_Service_Request Bool Create as a Service Request Line on the Requisition if adding the Purchase Item via Search Catalog or Add to Cart button. If the flag is false, it will create as a Goods Request Line.
Purchase_Item_Group_Reference String Reference to an existing Purchase Item Group. Assign purchase items to item groups to make it easier to search for and select items. Purchase items can belong to multiple groups.
Unit_of_Measure_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Set_Reference_Unit_of_Measure_Set_ID String Contains a unique identifier for an instance of an object.
Base_Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Base_Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Base_Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Lot_Control Bool Boolean to indicate if a Purchase Item is Lot Control.
Serial_Control_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Serial_Control_Method_Reference_Serial_Control_Method_ID String Contains a unique identifier for an instance of an object.
Is_Manufacturer_Required Bool Boolean to indicate if Manufacturer is required on the Lot for the Purchase Item
Use_Item_Manufacturers_Only Bool Boolean to indicate if the Item Lot can have only Item Manufacturers.
Is_Expiration_Date_Required Bool Boolean to indicate if Expiration Date is required for an item lot.
Inbound_Alert_Period_in_Days Decimal Numeric Field to define Tolerance Periods for Purchase Items on Inbound tasks.
Outbound_Alert_Period_in_Days Decimal Numeric field to define alert period in days for purchase items on outbound tasks.
Requisition_Fulfillment_Source_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Fulfillment_Source_Reference_Requisition_Fulfillment_Source_ID String Contains a unique identifier for an instance of an object.
Ordering_Start_Date Date Start Date of Item Substitution for Ordering.
Ordering_End_Date Date End Date of Item Substitution for Ordering.
Image_Reference_WID String Contains a unique identifier for an instance of an object.
Image_Reference_File_ID String Contains a unique identifier for an instance of an object.
Image_Reference_Image_ID String Contains a unique identifier for an instance of an object.
Filename String Filename of Image
File String File associated with Image
Maps_To_Sales_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Maps_To_Sales_Item_Reference_Sales_Item_ID String Contains a unique identifier for an instance of an object.
Inactive Bool Boolean to indicate a Purchase Item that is Inactive.

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