The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
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.
BDDETAIL.DAT has two keys, as follows:
0 = By Budget GUID, by Account GUID
1 = By Account GUID
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 |