Budget Details Fields

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

Filename: BDDETAIL.DAT

BDDETAIL.DAT is the budget details file. It stores the user-defined details for each entry in the Budget (BUDGET.DAT) table. 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 BDDETAIL.DAT.

Indexes and Their Uses

BDDETAIL.DAT has two keys, as follows:

0 = By Budget GUID, by Account GUID

1 = By Account GUID

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 Details table to the Budget table.

AccountGUID

UBinary

GUID (Globally Unique Identifier) used for linking Budget Details table to the Chart of Accounts table.

Period0

Float

Total amount in the account budgeted for each period.

Period1...Period55 (55 periods)

Float

What do you want to do next?