Tableau Connector for Workday

Build 20.0.7740

Suppliers

Supplier wrapper element that contains the Supplier

Columns

Name Type References Description
ID_Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
ID_Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
ID_Supplier_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_ID String Supplier ID
Supplier_Reference_ID String Supplier Reference ID. The Supplier Reference ID can be used to uniquely identify a Supplier Unlike Supplier ID, Workday will not automatically generate a Supplier Reference ID if one is not received. The recommended use for Supplier Reference ID is where the Workday is not the source system of the Supplier
Supplier_Name String Supplier Name
Worktag_Only Bool Boolean to indicate if supplier is used as a worktag only and not a complete supplier instance
Restricted_To_Companies_Reference String Restrict To Companies
Approval_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Approval_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Submit Bool Submit for Approval is a boolean flag indicating if the Supplier is to be submitted or saved in draft mode. If this flag is set, the Supplier will be submitted, otherwise the Supplier is saved in draft. Default to 1 if the Submit flag does not exist in the request.
Tax_Authority_Form_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Authority_Form_Type_Reference_Tax_Authority_Form_Type String Contains a unique identifier for an instance of an object.
IRS_1099_Supplier Bool Supplier is 1099
Report_1099_with_Parent Bool Supplier 1099 derived from parent
Supplier_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Category_Reference_Supplier_Category_ID String Contains a unique identifier for an instance of an object.
Supplier_Group_Reference String Supplier Group Reference is a reference to a specific Supplier Group
Document_Link String The Document Link URL entered does not comply with URL restrictions set for this Field.
Tax_Document_Date Date This is the date the Tax Document (e.g. W-9, etc) was received.
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.
Default_Withholding_Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Withholding_Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Default_Withholding_Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
FATCA Bool For 1099-MISC Reporting
Certificate_of_Insurance_Date Date Date field for Certificate of Insurance Date
Customer_Account_Number String Free form text field for Customer Account Number. This is not a Workday Customer Account or ID number, but a free form text for a Supplier to enter their own Customer Number
DUNS_Number String DUNS Number that uniquely identifies the Supplier.
Invoice_Any_Supplier Bool Indicates that the supplier can create invoices for any other supplier
Edit_Portal_Taxes Bool Enable your supplier contacts to enter or change the tax information on supplier invoices created from a purchase order.
Enable_Global_Location_Number Bool Supplier enabled for GLN use
Disable_Change_Order Bool When Disable Change Order is True, a Change Order cannot be created from any Purchase Order for this Supplier
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.
Multi_Supplier_Supplier_Link_for_PO_Issue_Reference_WID String Contains a unique identifier for an instance of an object.
Multi_Supplier_Supplier_Link_for_PO_Issue_Reference_Supplier_Link_Name String Contains a unique identifier for an instance of an object.
Shipping_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Shipping_Terms_Reference_Shipping_Terms_ID String Contains a unique identifier for an instance of an object.
Shipping_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Shipping_Method_Reference_Shipping_Method_ID String Contains a unique identifier for an instance of an object.
Acknowledgement_Expected Bool Acknowledgement expected for this supplier
Supplier_Minimum_Order_Amount Decimal Enable Supplier to send Supplier Minimum Order Amount.
Minimum_Order_Amount_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Minimum_Order_Amount_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Minimum_Order_Amount_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Enable_ASN Bool Enable Supplier to send ASN
ASN_Due_In_Days Decimal The number of days the ASN is due.
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_Types_Accepted_Reference String Payment Types Accepted Reference is a reference to the accepted Payment Types by the Supplier.
Default_Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Default_Additional_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Additional_Type_Reference_Additional_Reference_Type_ID String Contains a unique identifier for an instance of an object.
Procurement_Credit_Card_Reference_WID String Contains a unique identifier for an instance of an object.
Procurement_Credit_Card_Reference_Expense_Credit_Card_ID String Contains a unique identifier for an instance of an object.
Procurement_Credit_Card_Reference_Expense_Credit_Card_Token String Contains a unique identifier for an instance of an object.
Included_Children_Reference String Reference to existing Suppliers to be added as children. A child Supplier can only belong to one parent and a parent can not be self-referencing.
Proposed_Children_Reference String Reference to existing Suppliers proposed Children of this supplier. if this field does not exist in the request, Included Children field will be used as the proposed ones.
Business_Entity_Name String Business Entity Name is the name for the business entity. Business entities can not be duplicated across different business entity types, ie: a Customer can not have the same name as a Financial Institution unless they share the Business Entity.
Business_Entity_Phonetic_Name String Business Entity Furigana
Business_Entity_Tax_ID String Business Entity Tax ID
External_Entity_ID String External Entity ID. The External Entity ID can be used as a non unique reference to the same Business Entity in an external system.
Filename String Text attribute identifying Filename of the Attachment.
Image String File content in binary format.
Do_not_pay_during_Bank_Account_updates Bool Flag to indicate not to pay while Settlement Bank Account changes are in progress. Exclude Supplier Invoices from Settlement.
Status_Reference_WID String Contains a unique identifier for an instance of an object.
Status_Reference_Business_Entity_Status_Value_ID String Contains a unique identifier for an instance of an object.
Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Reason_Reference_Reason_for_Supplier_Status_Change_ID String Contains a unique identifier for an instance of an object.
Reason_Description String Status Change Reason Description
Always_Separate_Payments Bool Always Separate Payments
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.
Accepted_Currencies_Reference String Accepted Currencies Reference. When no accepted currencies are passed in the web service, the bank account will accept all currencies.
Integration_System_Reference_WID String Contains a unique identifier for an instance of an object.
Integration_System_Reference_Integration_System_ID String Contains a unique identifier for an instance of an object.
Do_Not_Reimburse_Contingent_Worker_Expense_Reports Bool If true, do not reimburse contingent worker expense reports for contingent workers supplied by the supplier.
Supplier_Security_Segment_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Security_Segment_Reference_Supplier_Security_Segment_ID String Contains a unique identifier for an instance of an object.
Spend_Category_or_Hierarchy_Reference String Suppliers can be classified by a Spend Category or Hierarchy. This only represents the categories of goods and services they provide.
Default_Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Spend_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Supplier_and_Tax_Details Bool Indicate there are changes in Supplier and Tax Details
Payment_Details Bool Indicate there are changes in Payment Details
Supplier_Hierarchy Bool Indicate there are changes in Supplier Hierarchy
Contact_Information Bool Indicate there are changes in Contact Information
Settlement_Bank_Account Bool Indicate there are changes in Settlement Bank Account
Alternate_Names Bool Indicate there are changes in Alternate Names
Procurement_Options Bool Indicate there are changes in Procurement Options
Classifications Bool Indicate there are changes in Classifications
Contingent_Worker_Options Bool Indicate there are changes in Contingent Worker Options
Attachments Bool Indicate there are changes in Attachments
Related_Worktags Bool Indicate there are changes in Supplier Related Worktags

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