| Description | Column | Datatype |
|---|---|---|
| Lease or application | app_lse_s | char (10) |
| 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) |
| Lease access type | lse_acc_c | char (1) |
| Collection status | col_stat_s | char (4) |
| Text [1] | info1_s | char (250) |
| Text [2] | info2_s | char (250) |
| Text [3] | info3_s | char (250) |
| Text [4] | info4_s | char (250) |
| Notebook reason code | ntbk_rsn_s | char (4) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| mjl_idx0 | app_lse_s | dt_ent_s |