Available in Sage 50 Quantum Accounting.
Tracking Status Note Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: STATNOTE.DAT
STATNOTE.DAT is the tracking status history file. Most of the information below is displayed in the note field of Sage 50's Track It panel located on transaction windows.
- To add Sage 50 raise history fields to your Crystal reports, select STATNOTE.DAT.
Indexes and Their Uses
This file has the following keys:
0 = By Record Number
1 = By Transaction Post Order
2 = By Assignee and AssigneeType
3 = By StatusNoteKey
Fields
The following table shows the fields available in the STATCODE.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
RecordNumber |
Integer |
This (internal) status note 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. |
|
|
StatusNoteKey |
UBinary |
16 |
Internal key used for linking to the tracking status note. |
|
PostOrder |
Integer |
Foreign key into the JRNLHDR table. Links to the journal entry recording the posting of the transaction. |
|
|
StatusId |
Integer |
Links to the status code table |
|
|
Assignee |
ZString |
64 |
User the transaction is assigned to |
|
AssigneeType |
Integer |
Do not use |
|
|
CreationDate |
Date |
Date a change was made |
|
|
CreatedBy |
ZString |
16 |
User who made the change |
|
Notes |
ZString |
2000 |
Note text |