Tableau Connector for Workday

Build 20.0.7740

CustomerContracts

Element content containing Customer Contract Document Element

Columns

Name Type References Description
Customer_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Contract_Reference_Customer_Contract_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Contract_ID String Customer Contract ID. This is the Customer Contract Unique Identifier.
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
Locked_in_Workday Bool Set to True to disable editing and canceling the invoice inside the Workday application. Invoice can only be updated from the web service.
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.
Multiple_Element_Revenue_Allocation Bool Multi Element Allocation flag to denote that revenue allocation is required
Revenue_Allocated Bool Revenue Allocated flag
No_Allocation_Threshold Bool No Allocation Threshold is checked when the Upper and lower range percentage for a company is not set
Lower_Range_Percentage Decimal Lower Range Percentage for Company
Upper_Range_Percentage Decimal Upper Range Percentage for Company
Sales_Item_Fair_Value_Price_List_Reference_WID String Contains a unique identifier for an instance of an object.
Sales_Item_Fair_Value_Price_List_Reference_Abstract_Sales_Item_Price_List_ID String Contains a unique identifier for an instance of an object.
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.
Sold_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Ship_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Ship_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Customer_Contract_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Contract_Type_Reference_Contract_Type_ID String Contains a unique identifier for an instance of an object.
Contract_Name String Customer Contract Name
Version Decimal Customer Contract Version
Customer_Contract_Number String Customer Contract Number
Contract_Description String Customer Contract Description
Bill_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Default_Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Default_Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Related_Customer_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Related_Customer_Contract_Reference_Customer_Contract_Reference_ID String Contains a unique identifier for an instance of an object.
Linked_Customer_Contracts_Reference String Other customer contracts that are linked to this contract.
Master_Customer_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Master_Customer_Contract_Reference_Customer_Contract_Reference_ID String Contains a unique identifier for an instance of an object.
Original_Customer_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Original_Customer_Contract_Reference_Customer_Contract_Reference_ID String Contains a unique identifier for an instance of an object.
Alternate_Customer_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Alternate_Customer_Contract_Reference_Customer_Contract_Alternate_Reference_ID String Contains a unique identifier for an instance of an object.
On_Hold Bool Customer Contract is On Hold
Customer_Contract_Effective_Date Date Customer Contract Effective Date
Contract_Signed_Date Date Contract Signed Date
PO_Number String Purchase Order for Customer Contract
Salesperson_Reference_WID String Contains a unique identifier for an instance of an object.
Salesperson_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Salesperson_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Default_Worktags_Reference String Customer Contract Default Worktags Reference
Current_Contract_Amount Decimal Current Contract Amount
Discounts_and_Premiums_Applied_Reference String Customer Contract Discounts And Premiums
Transaction_Billing_Schedule_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Transaction_Billing_Schedule_Template_Reference_Billing_Schedule_Template_ID String Contains a unique identifier for an instance of an object.
Installment_Billing_Schedule_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Installment_Billing_Schedule_Template_Reference_Billing_Schedule_Template_ID String Contains a unique identifier for an instance of an object.
Billing_Schedule_From_Date Date Billing Schedule Template From Date.
Billing_Schedule_To_Date Date Billing Schedule Template To Date.

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