Tableau Connector for Workday

Build 20.0.7740

Requisitions_Requisition_data

Element containing all Requisition data. A Requisition may have multiple goods and deliverable Requisition lines. A Requisition also supports service lines v24.0 onwards.

Columns

Name Type References Description
Requisition_Requisition_Reference_WID String

Requisitions.Requisition_Reference_WID

The unique identifier type. Each
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
Requisition_Number String Requisition Number
Requisition_Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Requisition_Date Date Requisition Date
Requisition_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Requisition_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Requisition_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Type_Reference_Requisition_Type_Reference_ID String Contains a unique identifier for an instance of an object.
Par_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Par_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Requisition_Sourcing_Buyer_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Sourcing_Buyer_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Requisition_Sourcing_Buyer_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Requesting_Inventory_Site_Reference_WID String Contains a unique identifier for an instance of an object.
Requesting_Inventory_Site_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Origin String Origin for the Requisition
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.
Deliver_To_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Deliver_To_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
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
Requester_Reference_WID String Contains a unique identifier for an instance of an object.
Requester_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Requester_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Memo_to_Suppliers String An optional Memo for the Requisition
Document_Link String Document Link for Requisition
Internal_Memo String An optional internal memo for the Requisition.
Freight_Amount Decimal An optional addition of Freight Amount for the Requisition.
Other_Charges Decimal An optional addition of Other Charges for the Requisition.
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.
High_Priority Bool Is Requisition High Priority?
Consolidate_Requisition_on_PO Bool Contains consolidation option of purchase orders for requisition
Exclude_Ship_To_Address_When_Consolidating_Requisition_Lines Bool Dictates whether Requisition Lines will be not consolidated by Ship-To Address when creating a Purchase Order during the sourcing process. If set to true, the result will be a Purchase Order with different line Ship-To Addresses.
Procedure_Date Date Procedure Date.
Procedure String Procedure.
Procedure_Number String Procedure Number.
Patient_ID String Patient ID
Medical_Record_Number String Medical Record Number
Physician_ID String Physician ID
Verified_By String Verified By
Supplier_Representative String Supplier Representative
Item_Request_Line_Data String Element containing all Goods Requisition Line data. A Requisition may have multiple goods requisition lines.
Service_Request_Line_Data String Element containing Service Requisition Line data. A Requisition may have multiple service requisition lines.
Deliverables_Line_Data String Element containing Project-Based Requisition Line data. A Requisition may have multiple Project-Based requisition lines.
Attachment_Data String Refers to a requisition attachment. Multiple attachments are allowed.
Ad_Hoc_Address_Replacement_Data String Element containing Ad Hoc Address information. Including address information will delete any existing address from the requisition and create a new address instance. If updating a requisition that currently contains an ad hoc address, omitting the ad hoc address element will leave the existing ad hoc address unaffected, which is likely the desired behavior. Only include the ad hoc address information when updating the requisition if the desired affect is to replace the current address with a new address instance.

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