This table is used to store note details entered in the Notes tab form in the debtors, creditors and contacts records. Anything entered in the creditors or debtors appears in the contact record and vice versa. Details entered into the Notes field of the Credit tab in debtors are also stored in this table. This information is not shared by the contacts system and is not available in creditors
Debtors, Creditors or Contacts Notes Tab
Name |
Type |
Linked To/Supplied |
NotesID |
Text (20) |
|
ProspectID |
Text (20) |
CN_Main.ProspectID |
NotesType |
Yes/No |
0 = Notes tab details; 1 = Credit tab Notes field |
RefDate |
Date/Time |
|
RefUser |
Text (50) |
|
Notes |
Text (255) |
|
RefDueDate |
Date/Time |
|
StaffID |
Text (20) |
HR_Staff.StaffID |
LastSavedDateTime |
Date/Time |
|
Copyright © 2012 Jiwa Financials. All rights reserved.