Tableau Connector for Workday

Build 20.0.7740

SupplierContracts

Wrapper element for Supplier Contract Reference and Supplier Contract Data

Columns

Name Type References Description
Supplier_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_ID String Supplier Contract Reference ID
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Order_From_Connection_Reference_WID String Contains a unique identifier for an instance of an object.
Order_From_Connection_Reference_Order_From_Supplier_Connection_ID String Contains a unique identifier for an instance of an object.
Contract_Specialist_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Specialist_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Contract_Specialist_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Buyer_Reference_WID String Contains a unique identifier for an instance of an object.
Buyer_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Buyer_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Contract_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Type_Reference_Supplier_Contract_Type_ID String Contains a unique identifier for an instance of an object.
Contract_Name String Contract Name
Contract_Reference String Supplier Reference Number
GPO_Contract_Reference String Group Purchasing Organization (GPO) Contract Reference
Contract_Document_Link String Link to the external document captured on the contract.
Contract_Start_Date Date Contract Start Date
Contract_Signed_Date Date Contract Signed Date
Contract_End_Date Date Contract End Date
Total_Contract_Amount Decimal Total Contract Amount
Original_Contract_Amount Decimal Original Supplier Contract Amount. This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
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.
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.
Override_Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Override_Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Credit_Card_Reference_WID String Contains a unique identifier for an instance of an object.
Credit_Card_Reference_Expense_Credit_Card_ID String Contains a unique identifier for an instance of an object.
Credit_Card_Reference_Expense_Credit_Card_Token String Contains a unique identifier for an instance of an object.
Automatically_Renew Bool Automatically Renew
Send_Expiration_Notification Bool Send Expiration Notification
Notice_Period Decimal Notice Period
Notice_Period_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Notice_Period_Frequency_Reference_Procurement_Unit_of_Time_ID String Contains a unique identifier for an instance of an object.
Renewal_Term Decimal Renewal Term
Renewal_Term_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Renewal_Term_Frequency_Reference_Procurement_Unit_of_Time_ID String Contains a unique identifier for an instance of an object.
Locked_in_Workday Bool Set to True to disable editing of supplier contract inside the Workday application. Supplier contract can only be updated from the web service.
Catalog_Reference String Catalog Reference
Catalog_Discount_Percent Decimal Catalog Discount Percent
Company_for_Supplier_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Company_for_Supplier_Invoice_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_for_Supplier_Invoice_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_for_Supplier_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_for_Supplier_Invoice_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_for_Supplier_Invoice_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_for_Supplier_Invoice_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Scheduled_Invoice_Override_Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Scheduled_Invoice_Override_Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Reference_Number String Supplier Invoice Reference Number
Company_for_Purchase_Order_Reference_WID String Contains a unique identifier for an instance of an object.
Company_for_Purchase_Order_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_for_Purchase_Order_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Purchase_Order_Issue_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Issue_Option_Reference_Purchase_Order_Issue_Option_ID String Contains a unique identifier for an instance of an object.
Purchase_Order_Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Bill_To_Contact_Detail String Bill-To Contact
Bill_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Ship_To_Contact_Detail String Ship-To Contact
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.
On_Hold Bool On Hold Flag
Percent_to_Retain Decimal Percent to Retain for Supplier Contract.
Estimated_Retention_Release_Date Date Estimated Retention Release Date for Supplier Contract.
XMLNAME_3rd_Party_Retention Bool 3rd Party Retention for Supplier Contract.
Retention_Memo String Retention memo for Supplier Contract.
Lease_Term Decimal Lease Term. This field is to be returned for Get Supplier Contracts and not entered for Submit Supplier Contract. Value will not be persisted if entered.
Compound_Period_Reference_WID String Contains a unique identifier for an instance of an object.
Compound_Period_Reference_Frequency_Behavior_ID String Contains a unique identifier for an instance of an object.
Payment_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Frequency_Reference_Frequency_Behavior_ID String Contains a unique identifier for an instance of an object.
First_Payment_Installment_Date Date First Payment Installment Date. Input the first payment installment date, including rent free installment periods, which are not prepaid lease payments made prior to the contract start date.
Additional_Payment Bool When you select the Additional Payment checkbox, we include additional installment to the payment information grid
Interest_Rate Decimal Interest Rate (%)
Fixed_Payment_Amount Decimal Fixed Payment Amount to apply to each installment of the Lease Contract.
Lessor_Incentive Decimal Initial Incentive for the Lessor under this contract, if any.
Initial_Direct_Cost Decimal Initial Direct Cost for the Lessor under this contract, if any.
Accounting_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Accounting_Method_Reference_Accounting_Method_ID String Contains a unique identifier for an instance of an object.
Automatically_Generate_Supplier_Invoice_Schedule_And_Installments Bool Automatically Generate Supplier Invoice Schedule And Installments
Automatically_Generate_Expense_Recognition_Schedule_And_Installments Bool Automatically Generate Expense Recognition Schedule And Installments
Expense_Recognition_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Recognition_Method_Reference_Schedule_Distribution_Method_Reference_ID String Contains a unique identifier for an instance of an object.
Prepaid_Lease_Payment Bool Indicates whether the Lease Contract has been prepaid and whether the prepaid amount should be included as part of the ROU Asset value.
Prepaid_Lease_Payment_Date Date The prepaid lease payment date is required for prepaid leases with fixed payment type. The prepaid date must be before the lease contract start date and no earlier than 1 year before the lease contract start date.
Number_of_Payments Decimal Number of Payments. This field is to be returned for Get Supplier Contracts and not entered for Submit Supplier Contract. Value will not be persisted if entered.
Total_Interest Decimal Total Interest. This field is to be returned for Get Supplier Contracts and not entered for Submit Supplier Contract. Value will not be persisted if entered.
Lease_Liability_Read_Only Decimal Workday automatically calculates the Lease Liability value based on the information provided and entered data in this field will be ignored.
ROU_Asset_Read_Only Decimal Workday automatically calculates the ROU Asset Value based on the information provided and entered data in this field will be ignored.
Total_Lease_Payments_Read_Only Decimal Workday automatically calculates the value of Total Lease Payments based on information you provide and entered data in this field will be ignored.
Submit Bool Submit

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