| Description | Column | Datatype |
|---|---|---|
| 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) |
| Sybase timestamp | timestamp | timestamp |
| Activity status | stat_s | char (4) |
| Default portfolio | def_por_s | char (2) |
| Default company | def_com_s | char (2) |
| Default region | def_reg_s | char (2) |
| Default office | def_off_s | char (3) |
| 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 | cont_nam_s | char (36) |
| Contact title | cont_title_s | char (25) |
| Letter version code | lt_version_s | char (4) |
| Email address | email_s | char (50) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| ruc_idx0 | client_id_s | client_rel_s |