| Description | Column | Datatype |
|---|---|---|
| Client | client_id_s | char (9) |
| Date and time the note was entered | dt_ent_s | datetime |
| Follow-up date and time | dt_fol_s | datetime |
| Note type
For unprocessed notes, note type must start with: A - Application M - Maturing Lease C - Collection K - Collateral S - Customer Service |
note_type_s | char (4) |
| Processed switch (Y/N) | prcs_c | char (1) |
| Priority flag (1/2/3/4)
1 - Lowest priority 4 - Highest priority |
prio_c | char (1) |
| From initials | from_s | char (3) |
| To initials | to_s | char (3) |
| Title of the note | note_title_s | char (41) |
| Text, extended | info_s | text |
| Sybase timestamp | timestamp | timestamp |
| Security check (Y/N) | private_c | char (1) |
| Text [1] | info1_s | char (250) |
| Text [2] | info2_s | char (250) |
| Text [3] | info3_s | char (250) |
| Text [4] | info4_s | char (250) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| mjc_idx0 | client_id_s | dt_ent_s |