JDBC Driver for Workday

Build 23.0.8839

SupplierContractsMultiSuppliers

Reads multiSuppliers 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
Descriptor String Supported for: SELECT. A preview of the instance
Inactive Bool Supported for: SELECT. Returns true if the entry on Supplier List for Multi-Supplier Contract is inactive.
MarkupPercent Decimal Supported for: SELECT. The markup percent applied to the unit cost of supplier items associated to the supplier.
Supplier_Descriptor String Supported for: SELECT. A description of the instance
Supplier_Href String Supported for: SELECT. A link to the instance
Supplier_Id String Supported for: SELECT. wid / id / reference id
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