rapv Table: Application Subvention
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rapv Table: Application Subvention

Parent Table

Name Description
rap Application

Indexes

Name Segment 1 Segment 2
rapv_idx0 app_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
app_s
Application
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