LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rfl Table: Group

Description Column Datatype
Customer number cus_s char (9)
Group number grp_s char (3)
Oracle row stamp stamp_l number (10)
Last payment date d_pay_s date
Financial statement date d_fin_s date
Accrual type acc_typ_s char (4)
Delinquency watch code del_s char (4)
Credit status code crd_s char (4)
Bankruptcy filed (Y/N) bnkr_c char (1)
Group payment due day pmt_s char (2)
First lease in group first_grp_lse_s char (10)
Last lease in group last_grp_lse_s char (10)
Total number of leases (as of previous EOD) totl_lse_l number (10)

rfl Indexes:

Index name Piece 1 Piece 2
rfl_idx0 cus_s grp_s


HomeTableIndexes