ODBC Driver for SAP Ariba Source

Build 24.0.9062

Terms

Retrieve the contract terms document details and the associated compliance contract details.

View-Specific Information

Select

The 本製品 uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.

  • ContractId supports the '=' comparison operator.
For example, the following query is processed server side:
SELECT * FROM Terms WHERE ContractId = 'CW0001'

Columns

Name Type References Description
ContractId [KEY] String

Workspaces.ContractId

ID of the contract.
DocumentId [KEY] String ID of the contract terms document in the contract workspace.
Version String Version of the contract terms document in the contract workspace.
Title String Title of the contract terms document in the contract workspace.
Owner String Owner of the contract terms document in the contract workspace.
Status String Status of the contract terms document in the contract workspace.
SspContractId String Contract ID (CID) of the compliance contract associated with the contract terms document.
SspContractRequestId String The contract request ID (CRID) of the compliance contract request associated with the contract terms document.
SspContractStatus String The status of the compliance contract associated with the contract terms document.
SspContractRequestStatus String The status of the compliance contract request associated with the contract terms document.
CreationDate Datetime The creation date of the contract terms document in the contract workspace.
LastModifiedDate Datetime The last modified date of the contract terms document in the contract workspace.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062