JDBC Driver for Workday

Build 23.0.8839

SupplierContractsMultiParticipants

Reads multiParticipants entries from the SupplierContracts table

Workday Resource Information

Retrieves a supplier contract with the specified ID.

Secured by: Process: Supplier Contract - View, View: Organization Supplier Contract

Scope: Procurement, Supplier Contracts

Columns

Name Type Description
Id [KEY] String Id of the instance
SupplierContracts_Id [KEY] String The Wordkay ID of the SupplierContracts that contains this
Company_Descriptor String Supported for: SELECT. A preview of the instance
Company_Id String Supported for: SELECT. Id of the instance
Descriptor String Supported for: SELECT. A preview of the instance
Inactive Bool Supported for: SELECT. True if the entry on Participant List for a Multi-Participant Contract is inactive.
CompanyOrHierarchy_Prompt String Accepts multiple inputs. Filters the contracts by company or company hierarchy. Specify the Workday ID of the company or company hierarchy.
ContractSpecialist_Prompt String Filters the contracts by the supplier contract specialist. Specify the Workday ID or reference ID of the specialist on the contract.
ContractType_Prompt String Accepts multiple inputs. Filters the contracts by type. Specify the Workday ID of the contract type.
EndDateOnOrAfter_Prompt Date Filters the contracts with an end date on or after the specified date. Use the yyyy-mm-dd format.
EndDateOnOrBefore_Prompt Date Filters the contracts with an end date on or before the specified date. Use the yyyy-mm-dd format.
ExternalSystemReference_Prompt String Accepts multiple inputs. Filters the contracts with the external system reference ID.
OnHold_Prompt Boolean Filters the contracts that are on hold.
StartDateOnOrAfter_Prompt Date Filters the contracts with a start date on or after the specified date. Use the yyyy-mm-dd format.
StartDateOnOrBefore_Prompt Date Filters the contracts with a start date on or before the specified date. Use the yyyy-mm-dd format.
Status_Prompt String Accepts multiple inputs. Filters the contracts by status. Specify the Workday ID of the status.
Supplier_Prompt String Accepts multiple inputs. Filters the contracts by the supplier. Specify the Workday ID of the supplier.

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