| Description | Column | Datatype |
|---|---|---|
| Client short name | client_s_name_s | char (25) |
| Sybase timestamp | timestamp | timestamp |
| Client | client_id_s | char (9) |
| Client relation
CUS - Customer LES - Lessee/Co-lessee HLS - Historical Lessee/Co-lessee INV - Investor BRK - Broker VND - Vendor GRT - Guarantor LEN - Lender |
client_rel_s | char (3) |
| Client DBA indicator (' '/'D') | client_dba_c | char (1) |
| SS/Bus ID | ss_s | char (20) |
| Compacted address1 | short_add_s | char (15) |
| Compacted City | short_cty_s | char (9) |
| State | st_s | char (2) |
| Business phone | bus_phn_s | char (10) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 |
|---|---|---|---|---|
| rcx_idx0 | client_s_name_s | client_id_s | client_rel_s | client_dba_c |
| rcx_idx1 | client_id_s | client_rel_s | client_dba_c | |
| rcx_idx2 | ss_s | client_id_s | client_rel_s | client_dba_c |