Budgets File Format BUDGETS.BCL1

This data transfer imports budgets from the general ledger. This format is provided for interfacing with legacy systems.

Note

The Budgets.BCL file format is used for Account Export and Budget Import.

BUDGETS.BCL Version 1

The first line of the file is VERSION 1 to identify it. The basic file format is fixed length (SDF).

Field	Field Name	Type	Length	Description
1	Company	Character	2	First 2 characters of the Entity ID.
2	Project	Character	3	Characters 3, 4, and 5 of the EntityCompany ID.
3	Account #	Character	15	Account number
4	Jan Budget	Numeric	9	Period 1 budget
5	Feb Budget	Numeric	9	Period 2 budget
6	Mar Budget	Numeric	9	Period 3 budget
7	Apr Budget	Numeric	9	Period 4 budget
8	May Budget	Numeric	9	Period 5 budget
9	Jun Budget	Numeric	9	Period 6 budget
10	Jul Budget	Numeric	9	Period 7 budget
11	Aug Budget	Numeric	9	Period 8 budget
12	Sep Budget	Numeric	9	Period 9 budget
13	Oct Budget	Numeric	9	Period 10 budget
14	Nov Budget	Numeric	9	Period 11 budget
15	Dec Budget	Numeric	9	Period 12 budget
16	Calc Method	Numeric	1	0
17	Calc/Year	Numeric	10	0000000000
18	Calc/Month	Numeric	10	0000000000
19	Calc/%GPI	Numeric	10	000000.000
20	Calc/Unit	Numeric	10	0000000000
21	Calc/SqFt	Numeric	10	0000000000