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:
0 = None

1 = User
2 = Role
3 = Custom

LastUpdateCounter

Integer

This increases incrementally when the tracking status is changed.