RequisitionRecords
Requisition modification records.
View-Specific Information
Select
The add-in 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 [RequisitionRecords]
SELECT * FROM [RequisitionRecords] WHERE [ApprovableId] = 'Val1'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | Description |
| ApprovableId | String |
Requisitions.ApprovableId | The unique identifier of the approvable requisition. |
| Id [KEY] | String | The unique identifier for the record entry. | |
| RequisitionId | String | The identifier of the parent requisition. | |
| Type | String | The type of the record entry. | |
| Action | String | The action type code for this record. | |
| Summary | String | The verbose human-readable description of the action taken. | |
| Comment | String | An optional comment attached to this record. | |
| RealUser | String | The actual user who performed the action. | |
| Date | Datetime | The timestamp in milliseconds when the record was created. | |
| UserUniqueName | String | The unique system identifier for the acting user. | |
| UserName | String | The full human-readable name of the acting user. | |
| UserEmailAddress | String | The email address of the acting user. | |
| UserPhone | String | The phone number of the acting user. | |
| UserPasswordAdapter | String | The password adapter mechanism of the acting user. | |
| UserRealm | String | The realm of the acting user. |