Tableau Connector for Workday

Build 20.0.7740

PurchaseOrders

Element containing Purchase Order Data and all Goods,Service and Project-Based Purchase Order Lines.

Columns

Name Type References Description
Purchase_Order_ID String Purchase Order ID. This is the Purchase Order unique identifier.
Locked_in_Workday Bool Set to True to disable editing the purchase order inside the Workday application.
Document_Number String A unique Workday system generated Purchase Order Number. This value cannot be updated, but it can be used to reference the instance of the Purchase Order.
Purchase_Order_Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
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.
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.
Purchase_Order_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Type_Reference_Order_Type_Reference_ID String Contains a unique identifier for an instance of an object.
External_PO_Number String Reference to an External Purchase Order Number.
Order_From_Supplier_Connection_Reference_WID String Contains a unique identifier for an instance of an object.
Order_From_Supplier_Connection_Reference_Order_From_Supplier_Connection_ID String Contains a unique identifier for an instance of an object.
Document_Date Date The date of the Purchase Order.
Acknowledgement_Expected Bool True if this Purchase Order is expecting a POA
Auto_Sourced Bool Defines whether the Purchase Order was created manually or Auto Sourced
Tax_Amount Decimal Tax Amount
Freight_Amount Decimal Freight charges incurred.
Other_Charges Decimal Other Charges
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.
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.
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.
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.
Shipping_Instruction String Gets Shipping Instruction data for Purchase Order WWS
Due_Date Date The anticipated date by which the Purchase Order should be fulfilled.
Supplier_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Alternate_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_Amendment_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_History_ID 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_Reference_Supplier_Invoice_Contract_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.
Default_Tax_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Tax_Option_Reference_Tax_Option_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.
Issue_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Issue_Option_Reference_Purchase_Order_Issue_Option_ID String Contains a unique identifier for an instance of an object.
Purchase_Order_Issue_Email_Data String Default PO Issue Email Data allows the user to select emails specified on Purchase Order Issue Email Data to be used as the default Issue Email address on all Purchase Orders.
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.
Bill_To_Contact_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Contact_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Bill_To_Contact_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Bill_To_Contact_Detail String Name of the Bill-To Contact. If value is not provided, Bill-To Contact will default to the name of the person submitting the purchase order.
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.
Ship_To_Contact_Detail String Name of the Ship-To Contact. If value is not provided, Ship-To Contact will default to the name of the person submitting the purchase order.
Ship_To_Address_Reference_IID 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.
Address_Reference String Address Reference ID
Ship_To_Global_Location_Number String Global Location Number (GLN) for Ship-to Address
Ship_To_Location_Identifier String Location Identifier for Ship-to Address
Document_Link String Document Link for the Purchase Order
Memo String Free form text describing the purpose of the Purchase Order
Internal_Memo String Memo for internal notes that cannot be viewed by the supplier.
Prepaid Bool Set the Prepaid value to true for Prepaid Purchase Order where all lines are Prepaid. If set, the lines cannot be also set to Prepaid individually
Prepayment_Release_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Prepayment_Release_Type_Reference_Prepayment_Release_Type_ID String Contains a unique identifier for an instance of an object.
Expected_Release_Date Date The Expected Amortization Date is used when the Prepaid Amortization Type is set to
Use_Prepaid_Posting_Rules_for_Receipt_Accruals Bool Use Prepaid Accounting Posting Rules for Receipt Accruals option.
Percent_to_Retain Decimal Percent to Retain for Purchase Order.
Estimated_Retention_Release_Date Date Estimated Retention Release Date for Purchase Order.
XMLNAME_3rd_Party_Retention Bool 3rd Party Retention for Purchase Order.
Retention_Memo String Retention Memo for Purchase Order.
Requisition_Type_Reference String Reference to the Requisition Type of Requisitions included in Purchase Order.
Procedure_Information_Data String Procedure Information related to the Bill Only Purchase Order.
Goods_Line_Data String Element containing Goods Purchase Order Line data. A Purchase Order may have multiple goods purchase order lines.
Deliverables_Line_Data String Element containing Project-Based Order Line data. A Purchase Order may have multiple Project-Based order lines.
Service_Line_Data String Element containing Simple Service Purchase Order Line data. A Purchase Order may have multiple simple service purchase order lines.
Contingent_Worker_Line_Data String Element containing Contingent Worker Order Line data. A Purchase Order may only have one contingent worker order line data.
Tax_Code_Data String Encapsulating element containing Tax Details data
Attachment_Data String Encapsulating element containing all Business Document Attachment data.
Prepaid_Spend_Amortization_Schedule String Prepaid Spend Amortization Schedule for Purchase Order

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