Field

Field Name

Type

Length

Description

1

Company  

Character

2

First 2 characters of the EntityCompany 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