mjl Table: Lease Notebook
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mjl Table: Lease Notebook

Indexes

Name Segment 1 Segment 2
mjl_idx0 app_lse_s dt_ent_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
app_lse_s
Lease or application
char(10) no
dt_ent_s
Date and time the note was entered
datetime no
dt_fol_s
Follow-up date and time
datetime yes
note_type_s
Note type
  For unprocessed notes, note type must start with:
  A - Application
  M - Maturing Lease
  C - Collection
  K - Collateral
  S - Customer Service
char(4) no
prcs_c
Processed switch (Y/N)
char(1) no
prio_c
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
char(1) no
from_s
From initials
char(3) no
to_s
To initials
char(3) no
note_title_s
Title of the note
char(41) no
info_s
Text, extended
text yes
timestamp
Record modification stamp
timestamp yes
private_c
Private note (Y/N)
char(1) yes
lse_acc_c
Lease access type
char(1) yes
col_stat_s
Collection status
char(4) yes
info1_s
Text [1]
char(250) yes
info2_s
Text [2]
char(250) yes
info3_s
Text [3]
char(250) yes
info4_s
Text [4]
char(250) yes
ntbk_rsn_s
Notebook reason code
char(4) yes