Available in Sage 50 Quantum Accounting.

Notifications Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: NOTIFICA.DAT

NOTIFICA.DAT is the notifications file. Most of the information below is entered in Sage 50's Notification Rules Settings window or displayed in Sage 50's My Notifications List. Notification Rules Settings can be accessed from Maintain>Workflow>Notification Rules. Go to Lists>Workflow Notifications>My Notifications to access the notifications sent to you.

To add Sage 50 raise history fields to your Crystal reports, select NOTIFICA.DAT.

Indexes and Their Uses

This file has the following keys:

0 = By Record Number

1 = By GUID

2 = By GuidUserKey, then AlertType

3 = By GuidUserKey, then Status

4 = By Post Order

Fields

The following table shows the fields available in the NOTIFICA.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
RecordNumber	Integer		This (internal) notifications field is used for linking purposes to other Sage 50 data tables. For more information, see Indexes and Their Uses above. This field is unique in the table and never changes.
GUID	UBinary		GUID (Globally Unique Identifier) used for linking Notification Rules table.
Status	Integer		Indicates whether the notification is new. 0 = old (read) 1 = new (unread)
AlertType	Integer		Transaction type that triggered notification
InsertDateTime	Date		Time stamp for the notification
ModifiedBy	ZString	16	User who made the change to the transaction that caused the notification to be triggered
ModifyDateTime	Date		The date and time the change was made that triggered the notification.
PostOrder	Integer		Foreign key into the JRNLHDR table. Links to the journal entry recording the posting of the transaction that triggered the notification.
MessageKey	Integer		Internal key used for linking to the Message for the notification
AdditionalMsgKey	Integer		Internal key used for linking to the Additional Message for the notification
RuleDescription	ZString	100	Description for the rule that triggered the notification