Tableau Connector for Workday

Build 20.0.7740

AlternateCustomerContracts_Customer_Contract_Line_Replacement_Data

Customer Contract Line Data Element

Columns

Name Type References Description
AlternateCustomerContract_Alternate_Customer_Contract_Reference_WID String

AlternateCustomerContracts.Alternate_Customer_Contract_Reference_WID

The unique identifier type. Each
ID_Receivable_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Receivable_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
ID_Receivable_Contract_Line_Reference_Student_Sponsor_Contract_Line_ID String Contains a unique identifier for an instance of an object.
Receivable_Contract_Line_Reference_ID String The Receivable Contract Line Reference ID. This is the Receivable Contract Line unique identifier.
Line_Number Decimal Contract Line Number
Line_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Line_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Line_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Bundled_Revenue_Only_Contract_Line_Reference String Revenue Only Customer Contract Lines that are associated to this Billing only Customer Contract Line.
Billing_Only_Customer_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Billing_Only_Customer_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Bundle_Line_Number Decimal References the Billing Only Customer Contract Line this bundled line belongs to.
Sales_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Catalog_Item_ID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Catalog_Load_Item_ID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Expense_Item_ID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Purchase_Item_ID 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_Reference_Supplier_Item_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Customer_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Petty_Cash_Account_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Receivable_Writeoff_Reason_ID 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.
Revenue_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Supplier_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Tax_Category_ID String Contains a unique identifier for an instance of an object.
Contract_Line_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Line_Type_Reference_Contract_Line_Type_ID String Contains a unique identifier for an instance of an object.
Alternate_Customer_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Alternate_Customer_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Original_Customer_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Original_Customer_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Billable_Project_Reference_WID String Contains a unique identifier for an instance of an object.
Billable_Project_Reference_Project_ID String Contains a unique identifier for an instance of an object.
Billable_Project_Reference_Workday_Project_ID String Contains a unique identifier for an instance of an object.
Project_Transaction_Source_Reference String Project Transaction Source Reference. Project Transaction Source of Expense and or Time is required for project contract line types.
Use_Standard_Rate_Sheet Bool Customer Contract Line uses Standard Rate Sheet.
Contract_Rate_Sheet_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Rate_Sheet_Reference_Contract_Rate_Sheet_ID String Contains a unique identifier for an instance of an object.
Usage_Billing_Rate_Reference_WID String Contains a unique identifier for an instance of an object.
Usage_Billing_Rate_Reference_Usage_Billing_Rate_ID String Contains a unique identifier for an instance of an object.
Contract_Line_Fee_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Line_Fee_Reference_Contract_Line_Fee_ID String Contains a unique identifier for an instance of an object.
Customer_Contract_Line_Start_Date Date Customer Contract Line Start Date
Customer_Contract_Line_End_Date Date Customer Contract Line End Date
Contract_Line_Description String Contract Line Description
Quantity Decimal Quantity for Contract Line
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.
Quantity_2 Decimal Second Quantity for Contract Line, corresponding to the secondary Unit of Measure.
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.
Unit_Cost Decimal Unit Cost for Contract Line.
Number_of_Installments Decimal Customer Contract Line Number of Installments
Regular_Installment_Amount Decimal Customer Contract Line Regular Installment Amount
First_Installment_Amount Decimal Customer Contract Line First Installment Amount
Last_Installment_Amount Decimal Customer Contract Line Last Installment Amount
Frequency_Behavior_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_Behavior_Reference_Frequency_Behavior_ID String Contains a unique identifier for an instance of an object.
Extended_Amount Decimal Extended Amount for Contract Line.
Discounts_and_Premiums_Applied_Reference String Discounts And Premiums Applied on Customer Contract Line
Discount_Premium_With_Additional_Discount_Reference String Ad Hoc Discount and Premium applied for a contract line.
Recalculate_FV_Unit_Price Bool Re-Calculate FV Unit Price
Fair_Value_Unit_Price Decimal FV Unit Price is the value used to calculate the revenue allocation for Multi-Element arrangement contract.
Fair_Value_Extended_Amount Decimal FV Extended Amount is FV Unit Price multiplied by the Quantity
List_Unit_Price Decimal List Unit Price
List_Extended_Amount Decimal List Extended Amount
Exclude_From_Calculation Bool This option may be set in order to exclude the contract line from the Revenue allocation calculation
Lower_Range_Percentage Decimal Line Level Lower Range Percentage
Upper_Range_Percentage Decimal Line Level Upper Range Percentage
Revenue_Allocation_Calculation_Basis_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Allocation_Calculation_Basis_Reference_Revenue_Allocation_Calculation_Basis String Contains a unique identifier for an instance of an object.
Range_Low Decimal Range Low is the lower range value calculated for the Revenue Allocation
Range_High Decimal Range High is the Higher range value calculated for the Revenue Allocation
MidRange Decimal Mid Range is the median value calculated for the Revenue Allocation
Relative_Selling_Price_Allocation Decimal Relative Selling Price Allocation calculated based on Range Low,Range High and Mid Range values
Renewable Bool Customer Contract Line Renewable
New_Business Bool Customer Contract Line New Business
Deferred_Revenue Bool Customer Contract Line Deferred Revenue
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.
Customer_Contract_Line_Revenue_Override_Amount Decimal Customer Contract Line Entered Revenue Amount
Zero_Revenue Bool Customer Contract Line Zero Revenue Indicator
Allocation_Percentage Decimal Percentage Allocation for Revenue Line when part of Bundle.
Default_Worktags_Reference String Customer Contract Line Default Worktags Reference
Line_Item_Description_Override String Customer Contract Line Item Description Override
Line_Invoice_Memo String Memo for the Invoice line. This is free form text.
Line_Invoice_Memo_Override String Customer Contract Line Invoice Memo Override
Ship_To_Customer_Reference String The ship to customer for the contract line. This field will default from header if left blank.
Ship_To_Address_Reference String The ship to address reference for the contract line. If there is a ship to customer on the line and this field is left blank, it will default to the ship to connection's default address.
Ship_To_Address_Data String The exact address specified in the address reference stored on the contract.
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.
Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Withholding_Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Withholding_Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Withholding_Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Billable_Transaction_Tax Bool When this flag is checked, Recoverable Tax is not billed to the customer.
Billing_Schedule_From_Date Date Billing Schedule Template From Date.
Billing_Schedule_To_Date Date Billing Schedule Template To Date.
Line_Billing_Notes String Customer Contract Line Billing Notes
Revenue_Recognition_Line_Notes String Customer Contract Line Revenue Recognition Line Notes
Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Document_Status_Reference_Document_Status_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