rhl Table: Historical Lessee
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rhl Table: Historical Lessee

Indexes

Name Segment 1 Segment 2
rhl_idx0 les_s  
rhl_idx1 cus_s les_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
les_s
Lessee number
CHAR(9) no
stamp_l
Record modification stamp
NUMBER(10) no
cus_s
Customer number
CHAR(9) no
d_arc_s
Date archived
DATE yes
nam_long_s
Long name
VARCHAR2(125) yes
bus_phn_s
Business phone
CHAR(10) yes
hom_phn_s
Home phone
CHAR(10) yes
add_s
Address
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
cty_s
City
VARCHAR2(25) yes
st_s
State code (RST.ST_S code)
CHAR(2) yes
zip_s
Zip code
CHAR(9) yes