rlm Table: Lease Meter
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rlm Table: Lease Meter

Indexes

Name Segment 1 Segment 2
rlm_idx0 lse_s meter_id_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
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
Line of credit start date
  Date the line of credit was created.
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')
datetime yes
d_last_s
Date of last update
datetime yes
t_last_s
Time of last update
char(6) 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
bill_frq_l
Billing frequency
integer yes