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. |