ADO.NET Provider for Workday

Build 24.0.9175

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 True if the Allow All Suppliers option is enabled for a multisupplier type contract.
AutomaticallyRenew Bool Returns true if the supplier contract is automatically renewed.
BillToAddress_Descriptor String A description of the instance
BillToAddress_Href String A link to the instance
BillToAddress_Id String wid / id / reference id
BillToContactDetail String The bill-to contact that populates on purchase orders for installments of this supplier contract.
Buyer_Descriptor String A description of the instance
Buyer_Href String A link to the instance
Buyer_Id String wid / id / reference id
CatalogDiscountPercent Decimal 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 A preview of the instance
CompanyOrHierarchy_Id String Id of the instance
ContractReferenceNumber String The reference number that identifies the supplier contract.
ContractSpecialist_Descriptor String A description of the instance
ContractSpecialist_Href String A link to the instance
ContractSpecialist_Id String wid / id / reference id
ContractType_Descriptor String A preview of the instance
ContractType_Id String Id of the instance
Currency_Descriptor String A description of the instance
Currency_Href String A link to the instance
Currency_Id String wid / id / reference id
DefaultOrderFromConnection_Descriptor String A description of the instance
DefaultOrderFromConnection_Href String A link to the instance
DefaultOrderFromConnection_Id String wid / id / reference id
Descriptor String A preview of the instance
DocumentLink String 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 The end date of the supplier contract.
ExternalReferenceID String The external identifier that's associated with a Workday requisition, supplier, supplier contract, or supplier invoice.
ExternalSystemReference_Descriptor String A description of the instance
ExternalSystemReference_Href String A link to the instance
ExternalSystemReference_Id String wid / id / reference id
FromSupplierList Bool Returns true if Supplier List option is enabled for a Multi-Supplier Contract.
GpoReference String The Group Purchase Organization (GPO) contract reference of the supplier contract.
InvoicedPOAmount_Currency String 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.
InvoicedPOAmount_Value Decimal 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.
MarkupPercent Decimal The markup percent applied to the unit cost of supplier items associated to the supplier contract.
Name String The contract name for the supplier contract.
NonPOInvoiceAmount_Currency String 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.
NonPOInvoiceAmount_Value Decimal 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.
NoticePeriod Decimal The number of days/months prior to supplier contract expiration that a notice is delivered.
NoticePeriodFrequency_Descriptor String A description of the instance
NoticePeriodFrequency_Href String A link to the instance
NoticePeriodFrequency_Id String wid / id / reference id
Number String The automatically generated supplier contract number.
OnHold Bool 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 The original total contract amount in the currency of the supplier contract.
OriginalTotalAmount_Value Decimal The original total contract amount in the currency of the supplier contract.
OverridePaymentType_Descriptor String A description of the instance
OverridePaymentType_Href String A link to the instance
OverridePaymentType_Id String wid / id / reference id
Overview String The description or overview of the supplier contract.
PaymentTerms_Descriptor String A description of the instance
PaymentTerms_Href String A link to the instance
PaymentTerms_Id String wid / id / reference id
PaymentType_Descriptor String A description of the instance
PaymentType_Href String A link to the instance
PaymentType_Id String wid / id / reference id
PurchaseOrderAmount_Currency String 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.
PurchaseOrderAmount_Value Decimal 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.
PurchaseOrderDefaultCompany_Descriptor String A preview of the instance
PurchaseOrderDefaultCompany_Id String Id of the instance
PurchaseOrderIssueOption_Descriptor String A description of the instance
PurchaseOrderIssueOption_Href String A link to the instance
PurchaseOrderIssueOption_Id String wid / id / reference id
ReceiptAmount_Currency String 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.
ReceiptAmount_Value Decimal 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.
RenewalTerm Decimal The number of days/months/years the supplier contract is renewed for.
RenewalTermFrequency_Descriptor String A description of the instance
RenewalTermFrequency_Href String A link to the instance
RenewalTermFrequency_Id String wid / id / reference id
SendExpiryNotification Bool Returns true if the supplier contract is included in expiry supplier contract notifications
ShipToAddress_Descriptor String A description of the instance
ShipToAddress_Href String A link to the instance
ShipToAddress_Id String wid / id / reference id
ShipToContactDetail String The ship-to contact that populates on purchase orders for installments of this supplier contract.
SignedDate Datetime The date the supplier contract was signed. This date is optional and doesn't affect the execution of the supplier contract.
StartDate Datetime 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 A description of the instance
Status_Href String A link to the instance
Status_Id String wid / id / reference id
SupplierForSupplierInvoice_Descriptor String A description of the instance
SupplierForSupplierInvoice_Href String A link to the instance
SupplierForSupplierInvoice_Id String wid / id / reference id
SupplierInvoiceDefaultCompany_Descriptor String A preview of the instance
SupplierInvoiceDefaultCompany_Id String Id of the instance
SupplierInvoiceReferenceNumber String The supplier invoice reference number on the supplier contract.
Supplier_Descriptor String A description of the instance
Supplier_Href String A link to the instance
Supplier_Id String wid / id / reference id
TotalAmount_Currency String The total contract amount of a supplier contract. This must be equal to, or greater than, the line extended amount.
TotalAmount_Value Decimal The total contract amount of a supplier contract. This must be equal to, or greater than, the line extended amount.
CompanyOrHierarchy_Prompt String 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 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 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 Filters the contracts by status. Specify the Workday ID of the status.
Supplier_Prompt String Filters the contracts by the supplier. Specify the Workday ID of the supplier.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175