RequisitionComments
Comments on the requisition.
View-Specific Information
Select
The driver uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ApprovableId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [RequisitionComments]
SELECT * FROM [RequisitionComments] WHERE [ApprovableId] = 'Val1'
The driver processes other filters client-side within the driver.
Columns
| Name | Type | References | Description |
| ApprovableId | String |
Requisitions.ApprovableId | The unique identifier of the approvable requisition. |
| Id [KEY] | String | The unique identifier for the comment. | |
| RequisitionId | String | The identifier of the parent requisition. | |
| Text | String | The text content of the comment. | |
| AttachedToLine | Int | The line item number the comment is attached to. | |
| Date | Datetime | The date when the comment was added. | |
| UserUniqueName | String | The unique system identifier for the commenting user. | |
| UserName | String | The full human-readable name of the commenting user. | |
| UserEmailAddress | String | The email address of the commenting user. | |
| UserPhone | String | The phone number of the commenting user. | |
| UserPasswordAdapter | String | The password adapter mechanism of the commenting user. | |
| UserRealm | String | The realm of the commenting user. |