ARPB_TX_VOID

Description:

This table contains information on transactions that were either: * Transferred * Voided * Reversed * Retroadjudicated.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	OLD_ETR_ID	NUMERIC	No
	This item holds a pointer for a transaction that was reposted retroactively to the original transaction.
3	REPOSTED_ETR_ID	NUMERIC	No
	This item stores a pointer to the old transaction in the case of charge correction or repost.
4	REPOST_TYPE_C_NAME	VARCHAR	No
	This indicates the type of repost on the source transaction. This is either set to repost or correction. May contain organization-specific values: No Category Entries: Repost Correction
5	IS_RETRO_TX	VARCHAR	No
	This item serves as a flag to determine if this transaction was voided as a result of retroadjudication.
6	TRANS_TX_ID	NUMERIC	No
	This item stores a pointer to the transaction ID that this transaction was transferred from. This item is only populated if a transaction was transferred from another transaction.
7	TRANS_FROM_C_NAME	VARCHAR	No
	This item stores the void status of the transferred from transaction for this transaction. This item is only populated if this transaction was transferred from a different account. May contain organization-specific values: No Category Entries: VOID-SAME BATCH VOID-DIFFERENT BATCH REVERSED
8	RETRO_CHARGE_ID	NUMERIC	No
	This item stores the transaction ID for the reposted transaction caused by the retroadjudication of this transaction.
9	DEL_REVERSE_DATE	DATETIME	No
	This is the date that the transaction was voided or reversed.
10	DEL_CHARGE_USER_ID	VARCHAR	No
	This item stores the user who voided this transaction.
11	DEL_CHARGE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	DEL_CHARGE_INSTANT	DATETIME (Local)	No
	This item stores the instant that a transaction was voided.
13	IS_REVERSED_C_NAME	VARCHAR	No
	This flag determines if a transaction has been reversed. May contain organization-specific values: No Category Entries: YES
14	VOIDED_BY_MSG_YN	VARCHAR	No
	This flag is set if the charge was voided as a result of a Charge Router message. May contain organization-specific values: No Category Entries: No Yes
15	VOID_REASON_C_NAME	VARCHAR	No
	The reason for voiding/reversing category ID for the transaction May contain organization-specific values: Yes No Entries Defined
16	VOIDED_BY_CGR_C_NAME	VARCHAR	No
	Indicates that a charge is voided by charge router. The category values for this column were already listed for column: IS_REVERSED_C_NAME