ram Table: Asset Meter
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

ram Table: Asset Meter

Indexes

Name Segment 1 Segment 2
ram_idx0 unit_s meter_id_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
char(10) no
meter_id_s
Meter ID
char(4) no
timestamp
Record modification stamp
timestamp yes
desc_s
Meter description
char(36) yes
d_start_s
Meter start date
datetime yes
d_last_s
Date of last update
datetime yes
orig_read_d
Original meter read
double precision yes
curr_read_d
Current meter read
double precision yes
curr_credit_l
Current credit
integer yes
base_allow_l
Base allowance
integer yes
end_range1_l
End range [1]
integer yes
end_range2_l
End range [2]
integer yes
end_range3_l
End range [3]
integer yes
end_range4_l
End range [4]
integer yes
end_range5_l
End range [5]
integer yes
end_range6_l
End range [6]
integer yes
end_range7_l
End range [7]
integer yes
end_range8_l
End range [8]
integer yes
end_range9_l
End range [9]
integer yes
end_range10_l
End range [10]
integer yes
p_cpu_rate1_d
Cost per use rate [1]
double precision yes
p_cpu_rate2_d
Cost per use rate [2]
double precision yes
p_cpu_rate3_d
Cost per use rate [3]
double precision yes
p_cpu_rate4_d
Cost per use rate [4]
double precision yes
p_cpu_rate5_d
Cost per use rate [5]
double precision yes
p_cpu_rate6_d
Cost per use rate [6]
double precision yes
p_cpu_rate7_d
Cost per use rate [7]
double precision yes
p_cpu_rate8_d
Cost per use rate [8]
double precision yes
p_cpu_rate9_d
Cost per use rate [9]
double precision yes
p_cpu_rate10_d
Cost per use rate [10]
double precision yes