JDBC Driver for Workday

Build 24.0.9062

SupplierContracts

Retrieves all supplier contracts.

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
AllowAllSuppliers Bool Supported for: SELECT. True if the Allow All Suppliers option is enabled for a multisupplier type contract.
AutomaticallyRenew Bool Supported for: SELECT. Returns true if the supplier contract is automatically renewed.
BillToAddress_Descriptor String Supported for: SELECT. A description of the instance
BillToAddress_Href String Supported for: SELECT. A link to the instance
BillToAddress_Id String Supported for: SELECT. wid / id / reference id
BillToContactDetail String Supported for: SELECT. The bill-to contact that populates on purchase orders for installments of this supplier contract.
Buyer_Descriptor String Supported for: SELECT. A description of the instance
Buyer_Href String Supported for: SELECT. A link to the instance
Buyer_Id String Supported for: SELECT. wid / id / reference id
CatalogDiscountPercent Decimal Supported for: SELECT. Catalog Discount Percent applied to all Catalog Items on the Supplier Contract. The discounted Unit Cost will not be used if there is a Contract Line for the Item, since the Unit Cost on the Contract Line will be used.
CompanyOrHierarchy_Descriptor String Supported for: SELECT. A preview of the instance
CompanyOrHierarchy_Id String Supported for: SELECT. Id of the instance
ContractReferenceNumber String Supported for: SELECT. The reference number that identifies the supplier contract.
ContractSpecialist_Descriptor String Supported for: SELECT. A description of the instance
ContractSpecialist_Href String Supported for: SELECT. A link to the instance
ContractSpecialist_Id String Supported for: SELECT. wid / id / reference id
ContractType_Descriptor String Supported for: SELECT. A preview of the instance
ContractType_Id String Supported for: SELECT. Id of the instance
Currency_Descriptor String Supported for: SELECT. A description of the instance
Currency_Href String Supported for: SELECT. A link to the instance
Currency_Id String Supported for: SELECT. wid / id / reference id
DefaultOrderFromConnection_Descriptor String Supported for: SELECT. A description of the instance
DefaultOrderFromConnection_Href String Supported for: SELECT. A link to the instance
DefaultOrderFromConnection_Id String Supported for: SELECT. wid / id / reference id
Descriptor String Supported for: SELECT. A preview of the instance
DocumentLink String Supported for: SELECT. The link to the external document that the supplier contract refers to. The supplier contract may stem from an external system and this link allows to access the contract to that external system.
EndDate Datetime Supported for: SELECT. The end date of the supplier contract.
ExternalReferenceID String Supported for: SELECT. The external identifier that's associated with a Workday requisition, supplier, supplier contract, or supplier invoice.
ExternalSystemReference_Descriptor String Supported for: SELECT. A description of the instance
ExternalSystemReference_Href String Supported for: SELECT. A link to the instance
ExternalSystemReference_Id String Supported for: SELECT. wid / id / reference id
FromSupplierList Bool Supported for: SELECT. Returns true if Supplier List option is enabled for a Multi-Supplier Contract.
GpoReference String Supported for: SELECT. The Group Purchase Organization (GPO) contract reference of the supplier contract.
InvoicedPOAmount_Currency String Supported for: SELECT. The Total Amount from Supplier Invoices attached to Purchase Orders. Invoices that are canceled or denied are not included. Will return zero if the amount is negative. The currency is the currency of the Supplier Contract. (Currency name)
InvoicedPOAmount_Value Decimal Supported for: SELECT. The Total Amount from Supplier Invoices attached to Purchase Orders. Invoices that are canceled or denied are not included. Will return zero if the amount is negative. The currency is the currency of the Supplier Contract. (Value)
MarkupPercent Decimal Supported for: SELECT. The markup percent applied to the unit cost of supplier items associated to the supplier contract.
Name String Supported for: SELECT. The contract name for the supplier contract.
NonPOInvoiceAmount_Currency String Supported for: SELECT. The total amount on invoices that aren't associated to purchase orders, in the currency of the supplier contract. Workday doesn't include canceled invoices, denied invoices, and lease-type contract invoice installments marked as Accounted. This report field returns zero when the total amount is negative. (Currency name)
NonPOInvoiceAmount_Value Decimal Supported for: SELECT. The total amount on invoices that aren't associated to purchase orders, in the currency of the supplier contract. Workday doesn't include canceled invoices, denied invoices, and lease-type contract invoice installments marked as Accounted. This report field returns zero when the total amount is negative. (Value)
NoticePeriod Decimal Supported for: SELECT. The number of days/months prior to supplier contract expiration that a notice is delivered.
NoticePeriodFrequency_Descriptor String Supported for: SELECT. A description of the instance
NoticePeriodFrequency_Href String Supported for: SELECT. A link to the instance
NoticePeriodFrequency_Id String Supported for: SELECT. wid / id / reference id
Number String Supported for: SELECT. The automatically generated supplier contract number.
OnHold Bool Supported for: SELECT. True if the transaction document is on hold. You can put customer contracts, supplier invoices, inventory pick lists and other types of documents on hold.
OriginalTotalAmount_Currency String Supported for: SELECT. The original total contract amount in the currency of the supplier contract. (Currency name)
OriginalTotalAmount_Value Decimal Supported for: SELECT. The original total contract amount in the currency of the supplier contract. (Value)
OverridePaymentType_Descriptor String Supported for: SELECT. A description of the instance
OverridePaymentType_Href String Supported for: SELECT. A link to the instance
OverridePaymentType_Id String Supported for: SELECT. wid / id / reference id
Overview String Supported for: SELECT. The description or overview of the supplier contract.
PaymentTerms_Descriptor String Supported for: SELECT. A description of the instance
PaymentTerms_Href String Supported for: SELECT. A link to the instance
PaymentTerms_Id String Supported for: SELECT. wid / id / reference id
PaymentType_Descriptor String Supported for: SELECT. A description of the instance
PaymentType_Href String Supported for: SELECT. A link to the instance
PaymentType_Id String Supported for: SELECT. wid / id / reference id
PurchaseOrderAmount_Currency String Supported for: SELECT. The Total Amount from Purchase Orders associated with the contract, either by contract line or header level reference. Orders that are canceled or denied are not included. The currency is the currency of the Supplier Contract. Landed costs are included. (Currency name)
PurchaseOrderAmount_Value Decimal Supported for: SELECT. The Total Amount from Purchase Orders associated with the contract, either by contract line or header level reference. Orders that are canceled or denied are not included. The currency is the currency of the Supplier Contract. Landed costs are included. (Value)
PurchaseOrderDefaultCompany_Descriptor String Supported for: SELECT. A preview of the instance
PurchaseOrderDefaultCompany_Id String Supported for: SELECT. Id of the instance
PurchaseOrderIssueOption_Descriptor String Supported for: SELECT. A description of the instance
PurchaseOrderIssueOption_Href String Supported for: SELECT. A link to the instance
PurchaseOrderIssueOption_Id String Supported for: SELECT. wid / id / reference id
ReceiptAmount_Currency String Supported for: SELECT. The total received amount for the supplier contract in the contract currency. Workday excludes draft and in progress receipts when the option is selected for the company’s procurement options. Receipts from Purchase Orders are not included, nor are canceled or denied Receipts. (Currency name)
ReceiptAmount_Value Decimal Supported for: SELECT. The total received amount for the supplier contract in the contract currency. Workday excludes draft and in progress receipts when the option is selected for the company’s procurement options. Receipts from Purchase Orders are not included, nor are canceled or denied Receipts. (Value)
RenewalTerm Decimal Supported for: SELECT. The number of days/months/years the supplier contract is renewed for.
RenewalTermFrequency_Descriptor String Supported for: SELECT. A description of the instance
RenewalTermFrequency_Href String Supported for: SELECT. A link to the instance
RenewalTermFrequency_Id String Supported for: SELECT. wid / id / reference id
SendExpiryNotification Bool Supported for: SELECT. Returns true if the supplier contract is included in expiry supplier contract notifications
ShipToAddress_Descriptor String Supported for: SELECT. A description of the instance
ShipToAddress_Href String Supported for: SELECT. A link to the instance
ShipToAddress_Id String Supported for: SELECT. wid / id / reference id
ShipToContactDetail String Supported for: SELECT. The ship-to contact that populates on purchase orders for installments of this supplier contract.
SignedDate Datetime Supported for: SELECT. The date the supplier contract was signed. This date is optional and doesn't affect the execution of the supplier contract.
StartDate Datetime Supported for: SELECT. The date the supplier contract begins and is executable. The contract is valid and executable when the start date is on or before the date of the spend transaction. Example: When the purchase order date predates the contract start date, the contracted price of an item isn't applicable and the spend amount won't be recorded against the contract.
Status_Descriptor String Supported for: SELECT. A description of the instance
Status_Href String Supported for: SELECT. A link to the instance
Status_Id String Supported for: SELECT. wid / id / reference id
SupplierForSupplierInvoice_Descriptor String Supported for: SELECT. A description of the instance
SupplierForSupplierInvoice_Href String Supported for: SELECT. A link to the instance
SupplierForSupplierInvoice_Id String Supported for: SELECT. wid / id / reference id
SupplierInvoiceDefaultCompany_Descriptor String Supported for: SELECT. A preview of the instance
SupplierInvoiceDefaultCompany_Id String Supported for: SELECT. Id of the instance
SupplierInvoiceReferenceNumber String Supported for: SELECT. The supplier invoice reference number on the supplier contract.
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
TotalAmount_Currency String Supported for: SELECT. The total contract amount of a supplier contract. This must be equal to, or greater than, the line extended amount. (Currency name)
TotalAmount_Value Decimal Supported for: SELECT. The total contract amount of a supplier contract. This must be equal to, or greater than, the line extended amount. (Value)
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 Bool 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 24.0.9062