Budget Fields

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

Filename: BUDGET.DAT

BUDGET.DAT is the budgets file. The user-defined values for this file are stored in the Budget Details (BDDETAIL.DAT) file. Budget information has been moved to these two files from the CHART.DAT (Chart of Accounts) file.

  • To add Sage 50 chart of account fields to your Crystal reports, select BUDGET.DAT.

Indexes and Their Uses

BUDGET.DAT has three keys, as follows:

0 = By GUID

1 = By Budget ID

2 = By Budget Description

Fields

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

Field Name

Type

Size

Comment

BudgetGUID

UBinary

GUID (Globally Unique Identifier) used for linking Budget table.

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

BudgetID

ZString

30

Identifier of the budget.

BudgetDescription

ZString

50

Description of the budget.

Notes

ZString

250

Notes attached to the budget.

What do you want to do next?