rrf Table: Reference

Name	Segment 1	Segment 2	Segment 3
rrf_idx0	ref_num_s
rrf_idx1	regarding_cln_s	ref_cd_s	ref_num_s

Columns
Name	Description	Datatype ¿?	Allow Null
ref_num_s	Reference number
	Record modification stamp
regarding_cln_s	Regarding client (lessee, co-lessee, guarantor)
ref_cd_s	Reference code BANK - Bank reference PERS - Personal reference PROF - Professional reference TRAD - Trade reference
d_acc_opened_s	Account opened date (BANK)
d_ref_stat_s	Reference status date
d_lst_mod_s	Last modification date
ref_stat_s	Reference status
acct_s	Account type (BANK, TRAD)
acc_stat_s	Account status (BANK)
trd_trm_s	Payment term code (TRAD)
pmt_his_s	Payment history code (TRAD)
sec_c	Secured (Y/N/U) (BANK) U - Unknown
gur_c	Personally guaranteed (Y/N/U) (BANK) U - Unknown
good_stand_c	Good standing (Y/N) (PROF)
nam_s	Name
add_s	Address
add2_s	Address 2
cty_s	City
st_s	State code (RST.ST_S code)
zip_s	Zip code
phn_s	Phone number
short_cont_nam_s	Contact name
cont_title_s	Contact title
bank_acc_s	Account number (BANK, TRAD)
p_rel_s	Relationship (PERS)
profession_s	Profession (PROF)
lst_mod_init_s	Last modification initials
loan_trm_l	Loan term
trd_yr_l	Years doing business (TRAD)
good_stand_yr_l	In good standing since year (PROF)
out_bal_d	Outstanding balance (BANK, TRAD)
avg_bal_d	Average balance (BANK)
low_bal_d	Lowest balance (BANK)
high_bal_d	Highest balance (BANK, TRAD)