Tableau Connector for Workday

Build 20.0.7740

SupplierContracts_Service_Lines_Replacement_Data

Service Lines Replacement Data

Columns

Name Type References Description
SupplierContract_Supplier_Contract_Reference_WID String

SupplierContracts.Supplier_Contract_Reference_WID

The unique identifier type. Each
Line_Number String Line Number
Company_for_Invoices_Reference_WID String Contains a unique identifier for an instance of an object.
Company_for_Invoices_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_for_Invoices_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Line_On_Hold Bool Contract Line On Hold
Item_Reference_WID String Contains a unique identifier for an instance of an object.
Item_Reference_Catalog_Item_ID String Contains a unique identifier for an instance of an object.
Item_Reference_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Item_Reference_Supplier_Item_ID String Contains a unique identifier for an instance of an object.
Description String Item Description
Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_Spend_Category_ID 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.
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.
Tax_Rate_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Withholding_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_2_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_2_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_3_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_3_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_4_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_4_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_5_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_5_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_6_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_6_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Extended_Amount Decimal Extended Amount
Start_Date Date Start Date
End_Date Date End Date
Do_Not_Auto_Renew Bool Do Not Auto-Renew this line. Only applies to Contracts that support Renewal Terms and Schedules.
Renewal_Amount Decimal Renewal Amount. Only applies to Contracts that support Renewal Terms and Schedules and has a Contract Line End Date.
Renewal_Quantity Decimal Renewal Quantity. Only applies to Contracts that support Renewal Terms and Schedules.and has a Contract Line End Date.
Renews_Line_Number String Contract Line Number that this Contract Line renews. Only applies to Contracts that support Renewal Terms and Schedules and has a Contract Line End Date.
Renewed_By_Line_Number String Contract Line Number that renews this Contract Line. Only applies to Contracts that support Renewal Terms and Schedules and has a Contract Line End Date.
Retention Bool Retention flag at the Line level
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.
Ship_To_Contact_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Contact_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Ship_To_Contact_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Memo String Memo
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.
Worktag_Reference String Worktag Reference
Related_Document_Lines_Reference String Represents all the lines this contract line is related to. This field is used for view purposes only.

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