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.