rlc Table: Lease Meter Charge

Database Reference Sybase DBMS

rlc Table: Lease Meter Charge

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5
rlc_idx0	lse_s	meter_id_s	d_run_s	t_run_s
rlc_idx1	invo_s	lse_s	meter_id_s	d_run_s	t_run_s

Columns
Name	Description	Datatype ¿?	Allow Null
lse_s	Lease	char(10)	no
meter_id_s	Meter ID	char(4)	no
d_run_s	Run date	datetime	no
t_run_s	Run time	char(6)	no
timestamp	Record modification stamp	timestamp	yes
invo_s	Invoice number	char(8)	no
opr_s	Operator initials	char(3)	yes
opr_r_s	Reversal operator initials	char(3)	yes
d_rev_s	Reversal date	datetime	yes
t_rev_s	Reversal time	char(6)	yes
d_usage_beg_s	Usage period begin date	datetime	yes
d_usage_end_s	Usage period end date	datetime	yes
base_allow_l	Base allowance	integer	yes
prev_credit_l	Previous credit	integer	yes
new_credit_l	New credit	integer	yes
credit_applied_l	Credit applied	integer	yes
billed1_l	Number of billed items [1]	integer	yes
billed2_l	Number of billed items [2]	integer	yes
billed3_l	Number of billed items [3]	integer	yes
billed4_l	Number of billed items [4]	integer	yes
billed5_l	Number of billed items [5]	integer	yes
billed6_l	Number of billed items [6]	integer	yes
billed7_l	Number of billed items [7]	integer	yes
billed8_l	Number of billed items [8]	integer	yes
billed9_l	Number of billed items [9]	integer	yes
billed10_l	Number of billed items [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
charged_d	Amount charged	double precision	yes
tot_read_d	Total meter read	double precision	yes