tran_det

The tran_det table contains information for each billing transaction entered for a customer during Bill Entry.

Notes:

tran_det

Field

Transaction_ID

Row_Index

Company_Number

Customer_ID

Location_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

Statement_Print_Sequence

Exception_Type

KWH_Usage

KQH_Usage

Kvarh_Usage

Message_ID

Receipt_Number

Reference_Serial_ID