LineItemDocumentProperties
Retrieve Contract Line Items Document metadata.
View-Specific Information
Select
The component uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.
The line item document's ID can be found in the user interface.
- Id supports the '=' comparison operator.
- ContractId supports the '=' comparison operator.
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. |