rld Table: Lease Deficiency
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rld Table: Lease Deficiency

Child Tables

Name Description
rldc Lease Deficiency Charge

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rld_idx0 lse_s        
rld_idx1 defic_por_s defic_com_s defic_reg_s defic_off_s lse_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
defic_por_s
Deficiency portfolio
CHAR(2) no
defic_com_s
Deficiency company
CHAR(2) no
defic_reg_s
Deficiency region
CHAR(2) no
defic_off_s
Deficiency office
CHAR(3) no
active_por_s
Active portfolio
CHAR(2) yes
active_com_s
Active company
CHAR(2) yes
active_reg_s
Active region
CHAR(2) yes
active_off_s
Active office
CHAR(3) yes
deficiency_c
Lease in deficiency portfolio (Y/N)
CHAR(1) yes
d_run_s
Run date
DATE yes
t_run_s
Run time
CHAR(6) yes