Available in Sage 50 Quantum Accounting.
Status Codes Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: STATCODE.DAT
STATCODE.DAT is the status code file. Most of the information below is entered or displayed in the Tracking Status Settings window (for tracking statuses) and the Job Defaults window (for job statuses) The Tracking Status Settings window is accessed from the Track It panel on transaction screens or from Maintain>Workflow>Tracking Status Settings.
- To add Sage 50 raise history fields to your Crystal reports, select STATCODE.DAT.
Indexes and Their Uses
This file has the following keys:
0 = By Record Number
1 = By StatusTypeSeq (StatusType, Sequence)
2 = By StatusCodeKey (StatusKey)
3 = By DefStatusType (DefaultSelection, StatusType)
4 = By StatusTypeName (StatusType, StatusName)
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 code 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. |
|
|
StatusKey |
UBinary |
16 |
Internal key used for linking to the status. |
|
StatusName |
ZString |
32 |
Name of the status |
|
StatusType |
Integer |
Indicates which type of record/transaction the status code can be applied to. 0 = None 1 = Credit Memos 2 = Payments 3 = Purchase Orders 4 = Purchase Invoices 5 = Quotes 6 = Receipts 7 = Sales Invoices 8 = Sales Orders 9 = Proposals 10 = Vendor Credit Memos 11 = Write Checks 12 = Jobs |
|
|
Sequence |
Integer |
Order of status in the status list on the Tracking Status Settings screen or the Job Defaults screen |
|
|
DefaultSelection |
Integer |
Indicates whether or not the status is set as the default status |
|
|
ARGBColor |
Integer |
Stores the numeric ARGB color value if a color icon is associated with the status |
|
|
Instructions |
ZString |
512 |
Next steps for the tracking status |
|
DefaultAssignee |
ZString |
64 |
User a transaction should be assigned to by default when assigned this status |
|
DfltAssigneeType |
Integer |
Type of user transactions with this status should be assigned to by default: 1 = User |
|
|
LastUpdateCounter |
Integer |
This increases incrementally when the tracking status is changed. |