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