Description | Column | Datatype |
---|---|---|
Key flag
1 - Collection agency 3 - Credit bureau 4 - Legal firm 8 - Remittance address 9 - Regional code |
rna_flg_c | char (1) |
Non lease code | rna_code_s | char (4) |
Sybase timestamp | timestamp | timestamp |
Name | nam_s | char (36) |
Address 1 | long_add1_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) |
Index name | Piece 1 | Piece 2 |
---|---|---|
rna_idx0 | rna_flg_c | rna_code_s |