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.