InvoiceApprovalRequests
List approval requests for invoices.
View-Specific Information
Select
The provider 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 [InvoiceApprovalRequests]
SELECT * FROM [InvoiceApprovalRequests] WHERE [ApprovableId] = 'Val1'
The provider processes other filters client-side within the provider.
Columns
| Name | Type | References | Description |
| ApprovableId | String |
Invoices.ApprovableId | Unique identifier of the parent invoice document. |
| Approver | String | Approvers assigned to this approval request. | |
| ApprovedByUniqueName | String | System identifier of the user who took action on this request. | |
| ApprovedByPasswordAdapter | String | The authentication adapter type used by the user who took action on this request. | |
| CreatorUniqueName | String | The system identifier of the user who created or initiated this approval request. | |
| CreatorPasswordAdapter | String | The authentication adapter type used by the creator. | |
| State | String | The current status of this approval request. | |
| RuleName | String | The name of the specific approval rule that triggered this request. | |
| Reason | String | The system or user-provided reason for this specific approval routing step. | |
| ReportingReason | String | A standardized reason code used for reporting purposes. | |
| ApproverComment | String | Comments entered by the approver during the approval process. | |
| ExtendEscalationReasonCode | String | System code representing the reason for extending the escalation period. | |
| ExtendEscalationUserComments | String | Comments provided by a user when extending the escalation period. | |
| ReportingExtendEscalationReason | String | Standardized reason code for why the escalation period was extended. | |
| ManuallyAdded | Bool | Indicates if this approver was manually added to the flow by a user. | |
| ApprovalRequired | Bool | Indicates whether this specific request mandates a mandatory approval. | |
| IsEscalatedToList | Bool | Indicates if the approval request has been escalated to a secondary list. | |
| IsEscalationExtended | Bool | Indicates if the standard escalation period has been extended. | |
| AllowEscalationPeriodExtension | Bool | Indicates if the time allowed before escalation can be extended. | |
| ActivationDate | Datetime | The timestamp when this approval request became active and actionable. | |
| LastModified | Datetime | The timestamp when this approval record was last updated. |