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.
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. |