rlsv Table: Lease Subvention
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rlsv Table: Lease Subvention

Parent Table

Name Description
rls Lease

Indexes

Name Segment 1 Segment 2
rlsv_idx0 lse_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
unique_l
Record number (possible values are 1 to 5)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
subv_type_s
Subvention type (SUBV.TYP code)
CHAR(4) yes
subv_prog_id_1_s
Program ID #1
CHAR(15) yes
subv_prog_id_2_s
Program ID #2
CHAR(15) yes
p_subv_buy_rate_d
Buy rate
NUMBER(15,5) yes
p_subv_rate_d
Subvention rate
NUMBER(15,5) yes
subv_d
Subvention amount
NUMBER(15,2) yes
subv_ue_d
Unearned subvention
NUMBER(15,2) yes
subv_cur_d
Current subvention
NUMBER(15,2) yes
subv_ytd_d
Y-T-D subvention
NUMBER(15,2) yes
subv_red_d
Reduction subvention
NUMBER(15,2) yes
subv_susp_d
Suspended subvention
NUMBER(15,2) yes