You are here: Reference Guide > Table Structures > Contacts > CN_Notes

CN_Notes

Purpose       

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

Path    

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.