LineItemDocumentProperties
Retrieve Contract Line Items Document metadata.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
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. |