Tableau Connector for Workday

Build 20.0.7740

SupplierContracts_Goods_Lines_Replacement_Data

Goods Lines 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_Point_Date_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Point_Date_Type_Reference_Tax_Point_Date_Type_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.
Percentage Decimal Percentage for supplier contract line. Used to calculate the extended amount on the supplier contract line. Only used for Finance Lease and Operating Lease Contract Types.
Packaging_String String Packaging String associated with the Item specified on the Line.
Quantity Decimal Quantity
Consigned_Quantity Decimal Consigned quantity represents the maximum quantity available to be on hand at a given moment for the consigned product.
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.
Conversion_Factor Decimal Conversion Factor from Ordering Unit of Measure to Purchase Item's Base Unit of Measure.
Unit_Residual_Value Decimal Residual Value of the item selected per unit
Unit_Cost Decimal Unit Cost
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.
Interest_Line Bool Indicates that there is an interest line on the supplier contract. You can use the Get web service to retrieve interest lines, but you can't use the Submit web service to select them.

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