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?

See a list of Crystal Reports data (.DAT) files