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