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