rat Table: Asset Meter Transaction

rat Table: Asset Meter Transaction

Database Reference

rat Table: Asset Meter Transaction

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5	Segment 6
rat_idx0	unit_s	meter_id_s	d_run_s	t_run_s	unique_s
rat_idx1	invo_s	unit_s	meter_id_s	d_run_s	t_run_s	unique_s

Columns
Name	Description	Datatype ¿?	Allow Null
unit_s	Asset
meter_id_s	Meter ID
d_run_s	Run date
t_run_s	Run time
unique_s	Unique portion for key
	Record modification stamp
invo_s	Invoice number
lse_s	Lease
opr_s	Operator initials
opr_r_s	Reversal operator initials
d_rev_s	Reversal date
t_rev_s	Reversal time
d_usage_beg_s	Usage period begin date
d_usage_end_s	Usage period end date
base_allow_l	Base allowance
prev_credit_l	Previous credit
new_credit_l	New credit
credit_applied_l	Credit applied
billed1_l	Number of billed items [1]
billed2_l	Number of billed items [2]
billed3_l	Number of billed items [3]
billed4_l	Number of billed items [4]
billed5_l	Number of billed items [5]
billed6_l	Number of billed items [6]
billed7_l	Number of billed items [7]
billed8_l	Number of billed items [8]
billed9_l	Number of billed items [9]
billed10_l	Number of billed items [10]
p_cpu_rate1_d	Cost per use rate [1]
p_cpu_rate2_d	Cost per use rate [2]
p_cpu_rate3_d	Cost per use rate [3]
p_cpu_rate4_d	Cost per use rate [4]
p_cpu_rate5_d	Cost per use rate [5]
p_cpu_rate6_d	Cost per use rate [6]
p_cpu_rate7_d	Cost per use rate [7]
p_cpu_rate8_d	Cost per use rate [8]
p_cpu_rate9_d	Cost per use rate [9]
p_cpu_rate10_d	Cost per use rate [10]
charged_d	Amount charged
prev_read_d	Previous meter read
new_read_d	New meter read

NETSOL Technologies

DBMS Platform Selector | Database Reference | LeasePak Database Objects | Data Model | Additional Information

© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.