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