ARPB_ADJ_APPROVAL_HX

Description: |
This table extracts information about adjustments in PB Adjustment Review workqueues that have been approved or denied.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ADJ_APRV_DTTM | DATETIME (UTC) | No |
The instant the adjustment record was approved or declined.
4 | ADJ_APRV_STATUS_C_NAME | VARCHAR | No |
The category value indicating the adjustment record's approval status. The matching category title can be found in the table ZC_ADJ_APRV_STATUS.
May contain organization-specific values: Yes
Category Entries:
Approved
Declined
Requested
5 | ADJ_APRV_USER_ID | VARCHAR | No |
The unique ID of the user who approved the adjustment record.
6 | ADJ_APRV_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | ADJ_APRV_COMMENT | VARCHAR | No |
The comment left by the user who approved or declined the adjustment record.
8 | ADJ_DECLINE_RSN_C_NAME | VARCHAR | No |
The category value indicating the reason the adjustment record was declined. The matching category title can be found in the table ZC_ADJ_DECLINE_RSN.
May contain organization-specific values: Yes
Category Entries:
Other
Charge Voided
Charge has No Outstanding Balance
Payment Recouped