|
Name |
Type |
Discontinued? |
|
| 1 |
TRANSACTION_ID |
VARCHAR |
No |
|
|
|
| The unique identifier (.1 item) for the detail 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_INSTANT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant the transaction was matched on. |
|
|
| 4 |
MTCH_TRANSACTION_ID |
VARCHAR |
No |
|
|
|
| The transaction ID that was matched to. Will never be cleared. |
|
|
| 5 |
MTCH_USER_ID |
VARCHAR |
No |
|
|
|
| The user that caused the transaction to match. |
|
|
| 6 |
MTCH_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 7 |
MTCH_WORKFLOW_C_NAME |
VARCHAR |
No |
|
|
|
| The workflow that caused the transaction to match |
| May contain organization-specific values: No |
| Category Entries: |
| Billing |
| Payment |
| Write Off |
| Retro Billing |
| Manual |
| Refund |
| Reversal |
| Presumed Payment |
|
|
| 8 |
UNMTCH_INSTANT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant the transaction was unmatched with the matched transaction. |
|
|
| 9 |
UNMTCH_USER_ID |
VARCHAR |
No |
|
|
|
| The user that caused the transaction to unmatch |
|
|
| 10 |
UNMTCH_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 11 |
UNMTCH_WORKFLOW_C_NAME |
VARCHAR |
No |
|
|
|
| The workflow that caused the transaction to unmatch. |
| The category values for this column were already listed for column: MTCH_WORKFLOW_C_NAME |
|
|
| 12 |
MTCH_CURRENT_TRANSACTION_ID |
VARCHAR |
No |
|
|
|
| The transaction that is currently matched. This is only populated if the transaction has not been unmatched. It is to quickly keep track of and find the transactions that are linked. |
|
|
