rfl Table: Group
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rfl Table: Group

Indexes

Name Segment 1 Segment 2
rfl_idx0 cus_s grp_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
cus_s
Customer number
CHAR(9) no
grp_s
Group number
CHAR(3) no
stamp_l
Record modification stamp
NUMBER(10) no
d_pay_s
Last payment date
DATE yes
d_fin_s
Financial statement date
DATE yes
acc_typ_s
Accrual type
CHAR(4) yes
del_s
Delinquency watch code
CHAR(4) yes
crd_s
Credit status code
CHAR(4) yes
bnkr_c
Bankruptcy filed (Y/N)
CHAR(1) yes
pmt_s
Group payment due day
CHAR(2) yes
first_grp_lse_s
First lease in group
CHAR(10) yes
last_grp_lse_s
Last lease in group
CHAR(10) yes
totl_lse_l
Total number of leases (as of previous EOD)
NUMBER(10) yes
pmt_hier_s
Payment hierarchy
CHAR(4) yes