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.