roa Table: Dead Application
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

roa Table: Dead Application

Indexes

Name Segment 1 Segment 2
roa_idx0 app_s  
roa_idx1 les_s app_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
app_s
Application
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
les_s
Lessee number
CHAR(9) no
d_ent_s
Application entry date
DATE yes
d_rem_s
Rejected/withdrawn date
DATE yes
lst_app_stat_s
Last application status
CHAR(4) yes
reason1_s
Rejection reason [1]
CHAR(4) yes
reason2_s
Rejection reason [2]
CHAR(4) yes
reason3_s
Rejection reason [3]
CHAR(4) yes
reason4_s
Rejection reason [4]
CHAR(4) yes
reason5_s
Rejection reason [5]
CHAR(4) yes
reason6_s
Rejection reason [6]
CHAR(4) yes
desc_s
Application description
VARCHAR2(36) yes
opr_s
Rejection/withdrawal operator initials
CHAR(3) yes
org_d
Original acquisition cost
NUMBER(15,2) yes
por_s
Portfolio
CHAR(2) yes
com_s
Company
CHAR(2) yes
reg_s
Region
CHAR(2) yes
off_s
Office
CHAR(3) yes
d_create_s
Date created
DATE yes