BILL_SCHED_PMT_PROCESS_HX

Description: |
This table contains the payment processing history from the Billing Scheduled Payment (BSP) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SCHED_PMT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SCHED_PMT_ID | NUMERIC | No |
This column stores the unique identifier for the scheduled payment 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 | PROCESS_HX_UTC_DTTM | DATETIME (UTC) | No |
Stores the instant of the processing history.
4 | PROCESS_HX_ACTION_C_NAME | VARCHAR | No |
Stores the action of the processing history.
May contain organization-specific values: No
Category Entries:
Scheduled
Unscheduled
Processed
Due Date Scheduled
5 | PROCESS_HX_ACTION_DATE | DATETIME | No |
Stores the date on which the corresponding action was performed.
6 | PROCESS_HX_PMT_AMT | NUMERIC | No |
Stores the history of the amount that was scheduled or processed.
7 | PROCESS_HX_USER_ID | VARCHAR | No |
This column stores the history of the user who performed the corresponding action.
8 | PROCESS_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | PROCESS_HX_CARD_HX_LINE | INTEGER | No |
This column stores the history line from the payment method record where the transaction history is stored.
10 | PROCESS_HX_TX_IDENT | VARCHAR | No |
This column stores the transaction identifier returned by the credit card engine.