UNIV_CHG_LN_MSG_HX

Description:

This table contains update history for the Universal Charge Line (UCL) masterfile. This table can be used to link to Universal Charge Messages (UCM) to actually find the update details.

Primary Key

Column Name	Ordinal Position
UCL_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	UCL_ID	VARCHAR	No
	The unique ID assigned to the UCL record (UCL .1).
2	LINE	INTEGER	No
	Each charge line (UCL) can have multiple messages (UCM) associated with it. The combination of UCL_ID and LINE make up a unique identifier for this message.
3	MESSAGE_ID	NUMERIC	No
	A history of Universal Charge Messages (UCM) that have updated this charge.