mja Table: Asset Notebook
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mja Table: Asset Notebook

Indexes

Name Segment 1 Segment 2
mja_idx0 unit_s dt_ent_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
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
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