Available in Sage 50 Quantum Accounting.

Notification Rules Fields

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

Filename: NOTRULES.DAT

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

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

Indexes and Their Uses

This file has the following keys:

0 = By Record Number

1 = By GUID

2 = By Active, then AlertType, then Condition

Fields

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

Field Name

Type

Size

Comment

RecordNumber

Integer

This (internal) notification rules 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.

Description

ZString

100

Description of the rule

AlertType

Integer

Transaction type selected for the rule

Condition

Integer

The condition selected for the rule.

0=None

1=IsAssignedTo

2=HasStatusOf

3=AssigneeOrStatusChanges

IsInactive

Integer

Indicates if the rule is inactive or not

0=False

1=True

LastUpdateCounter

Integer

This increases incrementally when the rule is changed.

AdditionalMsgKey

Integer

Internal key used for linking to the Additional Message for the rule

LastModifiedDateTime

Date

Last date and time the rule was changed.