CData Python Connector for Workday

Build 24.0.9175

SupplierContractsServiceLines

Reads /serviceLines entries from the SupplierContracts table.

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

Aggregate Fields

The 本製品 represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

ChargeControls_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
  maximumAmount: Currency /* The \~maximum charge control amount\~ of the charge control rule for the source transaction or transaction line.  The amount can be used in condition rules to control spending on target transactions or transaction lines. */
  minimumAmount: Currency /* The \~minimum charge control amount\~ of the charge control rule for the source transaction or transaction line. The amount can be used in condition rules to control spending on target transactions or transaction lines. */
}]

TaxRecoverabilities_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
  percentRecoverable: Numeric /* The tax recoverable percentage for tax recoverability. */
}]

Worktags_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
  worktagType: { /* The worktag type. */
      descriptor: Text /* A description of the instance */
      href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
}]

Columns

Name Type Description
Id [KEY] String Id of the instance
SupplierContracts_Id [KEY] String The Workday ID of the SupplierContracts that contains this.
ChargeControls_Aggregate String The charge control rules applied to the transaction or transaction line.
CompanyForInvoice_Descriptor String A preview of the instance
CompanyForInvoice_Id String Id of the instance
Descriptor String A preview of the instance
DoNotAutoRenew Bool True if the supplier contract line is marked as Do Not Auto Renew. The line checkbox is only editable when the supplier contract type allows Renewal Terms.
ExtendedAmount_Currency String The extended amount for the document line. Excludes Extended Amounts on Tax Only Invoices.
ExtendedAmount_Value Decimal The extended amount for the document line. Excludes Extended Amounts on Tax Only Invoices.
Item_Descriptor String A description of the instance
Item_Href String A link to the instance
Item_Id String wid / id / reference id
LineDescription String The line item description for the document line.
LineEndDate Datetime The end date of this Supplier Contract Line.
LineIsCanceled Bool True if this Supplier Contract Line is canceled. Canceled contract lines can't be ordered, received, or invoiced.
LineNumber String The line number of this Supplier Contract Line.
LineOnHold Bool True if the supplier contract line is On Hold. You can't add On Hold lines to purchase orders, supplier invoices, receipts, or installments. Lines already associated with downstream documents can't be marked as On Hold.
LineStartDate Datetime The start date of the Supplier Contract Line.
Location_Descriptor String A description of the instance
Location_Href String A link to the instance
Location_Id String wid / id / reference id
Memo String The memo on the document line.
RenewalAmount_Currency String The amount to be renewed for this Supplier Contract Line. When supplier contracts are auto-renewed, the renewal amount automatically persists on the renewed supplier contract line.
RenewalAmount_Value Decimal The amount to be renewed for this Supplier Contract Line. When supplier contracts are auto-renewed, the renewal amount automatically persists on the renewed supplier contract line.
Retention Bool Returns true if the Retention check box is selected on the line.
ShipToAddress_Descriptor String A description of the instance
ShipToAddress_Href String A link to the instance
ShipToAddress_Id String wid / id / reference id
ShipToContact_Descriptor String A description of the instance
ShipToContact_Href String A link to the instance
ShipToContact_Id String wid / id / reference id
SpendCategory_Descriptor String A description of the instance
SpendCategory_Href String A link to the instance
SpendCategory_Id String wid / id / reference id
TaxApplicability_Descriptor String A description of the instance
TaxApplicability_Href String A link to the instance
TaxApplicability_Id String wid / id / reference id
TaxCode_Descriptor String A description of the instance
TaxCode_Href String A link to the instance
TaxCode_Id String wid / id / reference id
TaxRecoverabilities_Aggregate String Tax Recoverabilities on a Taxable Document Line.
Worktags_Aggregate String All worktags for the related business object.
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