ARPB_TX_MATCH_HX
Description:
Matching History Transaction Related Items. A line is added to this related group whenever two transactions are matched together.

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 MTCH_TX_HX_DT DATETIME No
This item stores the date that a transaction was matched to this transaction.
4 MTCH_TX_HX_ID NUMERIC No
This item stores the transaction that this transaction was matched to. If the MTCH_TX_HX_UN_DT is null, then the transaction is still currently matched to this transaction.
5 MTCH_TX_HX_AMT NUMERIC No
This item stores the (insurance+self-pay) amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
6 MTCH_TX_HX_INS_AMT NUMERIC No
This item stores the insurance amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
7 MTCH_TX_HX_PAT_AMT NUMERIC No
This item stores the self-pay amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
8 MTCH_TX_HX_COMMENT VARCHAR No
This item holds the comment for the matching of this transaction to the transaction in column MTCH_TX_HX_ID. This item is typically only populated by the system and not user entered comments.
9 MTCH_TX_HX_UN_DT DATETIME No
This item holds the date that the transaction was unmatched from the transaction in column MTCH_TX_HX_ID.
10 MTCH_TX_HX_D_CVG_ID NUMERIC No
This item stores the coverage ID at the time that the transaction was matched to the transaction in column MTCH_TX_HX_ID.
11 MTCH_TX_HX_DSUSR_ID VARCHAR No
This item stores the users who matched this transaction to the transaction from column MTCH_TX_HX_ID.
12 MTCH_TX_HX_DSUSR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 MTCH_TX_HX_UDUSR_ID VARCHAR No
This item stores the user that unmatched this transaction from the transaction in the MTCH_TX_HX_ID column.
14 MTCH_TX_HX_UDUSR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 MTCH_TX_HX_INV_NUM VARCHAR No
This item stores the invoice associated with the debit transaction in the matching group.
16 MTCH_TX_HX_UN_COM VARCHAR No
This item stores the comment entered when the transaction is undistributed.
17 MTCH_TX_HX_UN_CV_ID NUMERIC No
This is the coverage of the debit transaction at the time of unmatch.
18 MTCH_TX_HX_LINE INTEGER No
This item stores the corresponding line from the matched transaction.
19 MTCH_TX_HX_DTTM DATETIME (UTC) No
The UTC date and time the transaction was matched.
20 MTCH_TX_HX_UN_DTTM DATETIME (UTC) No
The UTC date and time the transaction was unmatched.