mjc Table: Client Notebook
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mjc Table: Client Notebook

Indexes

Name Segment 1 Segment 2
mjc_idx0 client_id_s dt_ent_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
client_id_s
Client
char(9) 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
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