rrf Table: Reference
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rrf Table: Reference

Indexes

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