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.