Retrieve Contract Line Items Document metadata.

View-Specific Information

Select

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

The line item document's ID can be found in the user interface.

• Id supports the '=' comparison operator.
• ContractId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM LineItemDocumentProperties WHERE Id = 'Doc27061'

SELECT * FROM LineItemDocumentProperties WHERE ContractId = 'CW0001'

Columns

Name	Type	References	Description
Id [KEY]	String	Terms.DocumentId	Specifies the document id of the CLID.
ContractId [KEY]	String	Workspaces.ContractId	Specify the ID of the contract workspace from where you want to search the metadata of the associated CLID. This is a required parameter. Try it out on Sandbox with: CW3150.
ParentFolderId	String		Specifies the contract workspace ID associated with the document ID of the CLID.
ProjectId	String		Specifies the contract workspace ID associated with the document ID of the CLID.
Version	Decimal		Specifies the current version of the CLID.
OtherVersion	String		Lists all the versions of the CLID.
Name	String		Specifies the document id of the CLID.
Owner	String		Specifies the name of the author of the CLID.
Size	Decimal		Specifies the size of the CLID.
Active	Bool		Specifies whether the CLID is active.
Status	String		Specifies the current status of the CLID.
Description	String		Provides a short description of the CLID.
Permissions	String		Specifies the access control values selected in the CLID.
DocumentType	String		Specifies the document type of the CLID.
BaseLanguage	String		Specifies the base language of the CLID.
ContentType	String		Specifies the content type of the CLID.
PublishRequiresApproval	Bool		Specifies whether an approval is required before publishing the CLID.
AllowAdvancedPricingConditions	Bool		Specifies whether the CLID is configured to allow advanced pricing conditions.
IsPublishRequired	Bool		Specifies whether the CLID must be published.
LastModifiedDate	String		Specifies the date when the CLID was last modified.
CreationDate	String		Specifies the date when the CLID was created.
ParticipantName	String		This is participant of the CLID. Specifies the name of the participant.
ParticipantUniqueName	String		This is participant of the CLID. Specifies the unique name of the participant.
ParticipantType	String		This is participant of the CLID. Specifies the type of the participant.
ParticipantPasswordAdapter	String		This is participant of the CLID. Specifies the mode of authentication used by the participant to login.