ubdethl
The ubdethl table is part of the family of billing tables that include ubdeth, ubdet, ubdeths and ubdeth_tax. They can be linked together by the history_sequence_id along with Hist_Sum.
Notes:
For information about interpreting EDIFICE Tables, see Understanding EDIFICE Tables.
To view other EDIFICE Tables, see the EDIFICE Database Overview.
ubdethl |
||
Field |
||
Location_ID |
||
Row_Index |
||
Company_Number |
||
Transaction_ID |
||
Customer_ID |
||
Connection_ID |
||
Detail_ID |
||
Rate_Class |
||
Service_Code |
||
Prorate |
||
Meter_Type |
||
Reading_Type |
||
Pressure_Zone |
||
Tran_Code |
||
Prior_Read |
||
Present_Read |
||
Usage_Value |
||
Charges |
||
Taxes |
||
Discount |
||
Edit_Flag |
||
Debit_Credit |
||
Post_Flag |
||
Reference_Type |
||
Reference_Code |
||
Actual_Usage |
||
Prior_Reading_Date |
||
Present_Reading_Date |
||
Reversal |
||
Billing_Transaction_Type |
||
AgeUpdate_Code |
||
Usage_Reversal |
||
User |
||
Usage_Type |
||
Basis |
||
Journal_Printed |
||
Statement_Printed |
||
KWH_Read |
||
KQH_Read |
||
Power_Factor |
||
Kvarh_Read |
||
Minimum_Usage |
||
Billed_Usage |
||
Quantity |
||
Reason_Code_ID |
||
History_Sequence |
||
KWH_Usage |
||
KQH_Usage |
||
Kvarh_Usage |
||
Reference_Size |
||
Reference_Serial_ID |
||