| Name | Description | Type | Additional information |
|---|---|---|---|
| CustomerNoteId |
Sedona internal autonumber for the Customer Note record |
integer |
None. |
| CustomerId |
Foreign key from AR_Customer table |
integer |
None. |
| Notes |
The note |
string |
Required |
| UserName |
the user who initially added the note; defaults to UserCode value from config file if not set explicitly |
string |
String length: inclusive between 0 and 25 |
| NoteDate |
Date the note was created |
date |
None. |
| CustomerSiteId |
Foreign key from AR_Customer_Site table, provide if the message references a site record |
integer |
None. |
| CustomerSystemId |
Foreign key from AR_Customer_System table, provide if the message references a system record |
integer |
None. |
| AccessLevel |
Allowed values: 1 = viewed by all, including customers, 2 = viewed by office users, 3 = highest level of security; defaults to 2 if not supplied |
integer |
None. |
| EditUserCode |
the user making this change; defaults to UserCode value from config file if not set explicitly |
string |
String length: inclusive between 0 and 25 |
| EditDate |
Date the note was edited |
date |
None. |