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 |