rbm Table: Batch Meter
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rbm Table: Batch Meter

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7 Segment 8
rbm_idx0 por_s com_s reg_s off_s lse_s d_run_s t_run_s unique_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
char(2) no
com_s
Company
char(2) no
reg_s
Region
char(2) no
off_s
Office
char(3) no
lse_s
Lease
char(10) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
unique_s
Unique portion for key
char(5) no
timestamp
Record modification stamp
timestamp yes
unit_s
Asset
char(10) yes
meter_id_s
Meter ID
char(4) yes
trn_typ_c
Transaction type (A/R)
  A - Assess
  R - Reverse
char(1) yes
d_usage_end_s
Usage period end date
datetime yes
new_credit_l
New credit
integer yes
new_read_d
New meter read
double precision yes
cpu_level_c
Cost per use level (L/A)
   L - Lease level
   A - Asset level
char(1) yes