ARPB_TX_CLASS_HX

Description:

Classification history for Professional Billing Transactions. Indicates when the transaction has moved between Active AR, External AR, and Bad Debt.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique ID of the transaction.
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	CLASS_HX_INST	DATETIME (Local)	No
	The instant when the transaction's classification changed.
4	CLASS_HX_CHANGE_C_NAME	VARCHAR	No
	The classification change category number of the transaction. May contain organization-specific values: No Category Entries: Active External Bad Debt External W/O Bad Debt W/O
5	CLASS_HX_AMOUNT	NUMERIC	No
	The amount of the transaction that is associated with the classification change of the transaction in dollars.
6	CLASS_HX_USER_ID	VARCHAR	No
	The unique ID associated with the user who made the classification change. This column is frequently used to link to the CLARITY_EMP table.
7	CLASS_HX_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	CLASS_HX_LN	INTEGER	No
	The line associated with the matching transactions group that this classification change corresponds to. Used to easily link the classification change to the distribution/undistribution history of the transaction.