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 |