SSIS Components for Workday

Build 24.0.9060

RequisitionsPurchaseOrders

Reads /purchaseOrders entries from the Requisitions table.

Workday Resource Information

Retrieves a requisition with the specified ID.

Secured by: Checkout (REST), Process: Requisition - Reporting, Process: Requisition - View, Self-Service: Requisition, Self-Service: Supplier Contact Tasks, View: Organization Requisition

Scope: Procurement

Columns

Name Type Description
Id [KEY] String Id of the instance
Requisitions_Id [KEY] String The Workday ID of the Requisitions that contains this.
Descriptor String Supported for: SELECT. A preview of the instance
DocumentStatus_Descriptor String Supported for: SELECT. A description of the instance
DocumentStatus_Href String Supported for: SELECT. A link to the instance
DocumentStatus_Id String Supported for: SELECT. wid / id / reference id
Href String Supported for: SELECT. A link to the instance
PoDocumentDate Datetime Supported for: SELECT. The date for the purchase order.
PoNumber String Supported for: SELECT. The document number for the purchase order.
ExternalSourceableId_Prompt String No description available.
ExternalSystemId_Prompt String No description available.
FromDate_Prompt Date Filters the requisitions with document date on or after the specified date. Use the yyyy-mm-dd format.
Requester_Prompt String Filters the requisitions by requester. Specify the Workday ID of the worker who requested the requisition.
RequisitionType_Prompt String Accepts multiple inputs. Filters the requisitions by type. Specify the Workday ID of the requisition type. You can specify multiple requisitionType query parameters.
SubmittedByPerson_Prompt String Filters the requisitions by the Person who submitted the requisition. Specify the Workday ID or the reference ID of the person.
SubmittedBySupplier_Prompt String Accepts multiple inputs. Filters the requisitions by the supplier who submitted the requisition. Specify the Workday ID or the reference ID of the supplier. You can specify multiple submittedBySupplier query parameters.
SubmittedBy_Prompt String Filters the requisitions by the Worker who submitted the requisition. Specify the Workday ID or the reference ID of the worker. You can use a returned id from GET /workers in the Staffing REST web service.
ToDate_Prompt Date Filters the requisitions with document date on or before the specified date. Use the yyyy-mm-dd format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060