Tableau Connector for Workday

Build 20.0.7740

SalesItems

Sales Item

Columns

Name Type References Description
Sales_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Sales_Item_ID String Contains a unique identifier for an instance of an object.
Sales_Item_ID String Sales Item ID. This is the Sales Item unique identifier
Item_Name String Free form text for a meaningful Sales Item Name
Alternate_Name String Free form text to provide Alternate Name for Sales Item
Inactive Bool Boolean to indicate a Sales Item that is Inactive.
Worktag_Only Bool Boolean to indicate if the sales item is only used as a worktag value. If set to true, the sales item will not be available as a selection in sales item fields on financial transactions like Customer Invoices.
Revenue_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Revenue_Category_ID String Contains a unique identifier for an instance of an object.
Item_Description String Free form text providing a detailed Item Description
Item_Identifier String Free form text for an Item Identifier. This is not a Workday Reference ID
Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_2_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_2_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_2_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Enable_Bulk_Quantity_Pricing Bool Enable Bulk Pricing Flag.Possible Values Y/N.
Item_Unit_Price Decimal 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.
UOM_Priced_at_Quantities_of Decimal Bulk Quantity Divisor for Quantity
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.
Sales_Item_Group_Reference String Reference to an existing Sales Item Group
Project_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Template_Reference_Project_Template_ID String Contains a unique identifier for an instance of an object.
Revenue_Treatment_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Treatment_Reference_Revenue_Treatment_ID String Contains a unique identifier for an instance of an object.
Revenue_Recognition_Schedule_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Recognition_Schedule_Template_Reference_Revenue_Recognition_Schedule_Template_ID String Contains a unique identifier for an instance of an object.
Revenue_Recognition_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Recognition_Method_Reference_Schedule_Distribution_Method_Reference_ID String Contains a unique identifier for an instance of an object.
VSOE_Price Decimal The amount for VSOE Price for the Sales Item.
Third_Party_Evidence Decimal The amount for Third Party Evidence for the Sales Item.
Estimated_Selling_Price Decimal The amount for Esitmated Selling Price for the Sales Item.
Price_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Price_Type_Reference_Contract_Line_Type_ID String Contains a unique identifier for an instance of an object.
Maps_to_Purchase_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Maps_to_Purchase_Item_Reference_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Is_a_Bundle Bool Sales Item Bundle Flag
Sales_Item_To_Include_In_Bundle_Reference String Sales Item bundle
Sales_Item_Bundle_Reference String Bundled Sales Item
Fulfillment_Required Bool Fulfillment Required
Renewable Bool Sales Item Renewable

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