rns Table: Note Payable Status
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rns Table: Note Payable Status

Indexes

Name Segment 1 Segment 2 Segment 3
rns_idx0 note_s d_run_s t_run_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
note_s
Note attached to lease
CHAR(10) no
d_run_s
Note status date
DATE no
t_run_s
Note status time
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
d_act_s
Note activity status date
DATE yes
act_nt_s
Activity status
CHAR(4) 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
len_s
Lender
CHAR(9) yes
lse_s
Lease
CHAR(10) yes
unit_s
Asset
CHAR(10) yes
opr_s
Operator initials
CHAR(3) yes
org_unit_d
Original cost of attached assets
NUMBER(15,2) yes