Tableau Connector for Workday

Build 20.0.7740

PurchaseOrderChangeOrders

Element containing Purchase Order Change Order Data and Lines on the Change Order

Columns

Name Type References Description
Purchase_Order_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Reference_Document_Number String Contains a unique identifier for an instance of an object.
Purchase_Order_Reference_External_PO_Number String Contains a unique identifier for an instance of an object.
Purchase_Order_Reference_Purchase_Order_Reference_ID String Contains a unique identifier for an instance of an object.
Change_Order_Reference_ID String Purchase Order Change Order ID. This is the Purchase Order Change Order unique identifier.
Document_Number String A unique Workday system generated Purchase Order Number
Order_Version Decimal Change Order Version
Change_Order_Status String Change Order Status
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
Tax_Amount Decimal Tax Amount
Freight_Amount Decimal Freight Amount
Other_Charges Decimal Other Charges
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.
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.
Due_Date Date The anticipated date by which the Purchase Order should be fulfilled.
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 Shipping Instruction Data on Purchase Order Change Order
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.
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.
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 for 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
Document_Link String Document Link for Purchase Order Change 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.
Percent_to_Retain Decimal Percent to Retain for Purchase Order.
Estimated_Retention_Release_Date Date Estimated Retention Release Date for Purchase Order.
Third_Party_Retention Bool 3rd Party Retention for Purchase Order.
Retention_Memo String Retention Memo for Purchase Order.
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.
Requisition_Type_Reference String Reference to the Requisition Type of Requisitions included in Change 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. Specify only lines that need to be changed / added.
Service_Line_Data String Element containing Service Purchase Order Line data. Specify only lines that need to be changed / added.
Tax_Code_Data String Encapsulating element containing Tax Details data
Attachment_Data String Encapsulating element containing all Business Document Attachment data.

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