JDBC Driver for Workday

Build 23.0.8839

SupplierContractsChargeControls

Reads chargeControls 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
MaximumAmount_Currency String Supported for: SELECT. The maximum charge control amount of the charge control rule for the source transaction or transaction line. The amount can be used in condition rules to control spending on target transactions or transaction lines.
MaximumAmount_Value Decimal Supported for: SELECT. The maximum charge control amount of the charge control rule for the source transaction or transaction line. The amount can be used in condition rules to control spending on target transactions or transaction lines.
MinimumAmount_Currency String Supported for: SELECT. The minimum charge control amount of the charge control rule for the source transaction or transaction line. The amount can be used in condition rules to control spending on target transactions or transaction lines.
MinimumAmount_Value Decimal Supported for: SELECT. The minimum charge control amount of the charge control rule for the source transaction or transaction line. The amount can be used in condition rules to control spending on target transactions or transaction lines.
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