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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp yes
d_pay_s
Last payment date
datetime yes
d_fin_s
Financial statement date
datetime 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)
integer yes
pmt_hier_s
Payment hierarchy
char(4) yes