Available in Sage 50 Quantum Accounting.

Notification Condition Values Fields

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

Filename: NOTCDVAL.DAT

NOTCDVAL.DAT is the notification rules conditions 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 NOTCDVAL.DAT.

Indexes and Their Uses

This file has the following keys:

0 = By Record Number

1 = By GUID

2 = By RuleRecordNumber

Fields

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

Field Name	Type	Comment
RecordNumber	Integer	This (internal) notification condition values 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 Condition Values table.
RulesRecordNumber	Integer	This is used to link the condition to the rule.
ValueType	Integer	This indicates whether the condition is for a User, Role, or Status. 0=Status 1=User 2=Role
ValueGuidKey	UBinary	GUID used for linking to the User, Role, or Status for this condition
LastUpdateCounter	Integer	This increases incrementally when the rule is changed.