Available in Sage 50 Premium Accounting and higher.

Job Cost Codes Fields

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

Filename: COST.DAT

The Cost.DAT file contains job cost codes. Most of this information is entered or displayed in Sage 50's Maintain Cost Codes window.

  • To add Sage 50 cost code fields to your Crystal reports, select COST.DAT.

Indexes and Their Uses

COST.DAT has seven indexes, as follows:

0 = By Cost ID. This will be the most useful index.

1 = By Cost RecordNumber

2 = By Description

3 = By Inactive and then by Cost ID

4 = By Inactive and then by Description

5 = By Description

6 = By GUID

Fields

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

Field Name

Type

Size

Comment

CostCodeID

ZString

20

Cost Code ID entered in the Maintain Cost Codes window.

CostRecordNumber

Integer

This (internal) cost code field is used for linking purposes to other Sage 50 data files. For more information, see Indexes and Their Uses above.

CostDescription

ZString

30

Cost code description entered in the Maintain Cost Codes window.

CostType

ZString

30

Cost type selected for the cost code in the Maintain Cost Codes window.

Valid entries are blank, Labor, Materials, Equipment, Subcontractor, and Other.

CostIsInactive

Logical

The Inactive check box in the Maintain Cost Codes window. Valid choices include:

True = if the cost code record is inactive.

False = if the cost code record is active.

GUID

UBinary

GUID (Globally Unique Identifier) used for linking the Cost Codes table.

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

What do you want to do next?