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
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.