rqtr Table: CCA Class Effective Rate
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rqtr Table: CCA Class Effective Rate

Parent Table

Name Description
rqt CCA Class

Indexes

Name Segment 1 Segment 2
rqtr_idx0 cca_cls_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
cca_cls_s
CCA class
CHAR(4) no
unique_l
Record number (possible values are 1 to 10)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
d_rate_eff_s
Rate effective date
DATE yes
p_rate_d
Effective rate used to calculate CCA
NUMBER(15,5) yes