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

View-Specific Information

Select

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

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