rlh Table: Asset License History
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rlh Table: Asset License History

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rlh_idx0 lic_s st_s d_eff_s t_eff_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lic_s
License (auto)
CHAR(9) no
st_s
License state
CHAR(2) no
d_eff_s
Effective date
DATE no
t_eff_s
Effective time
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
unit_s
Asset
CHAR(10) yes
opr_s
Operator initials
CHAR(3) yes