620 - Import budget/planning figures

From Host

This transaction can be used for maintaining the budget/planning figures that are used in ProMark. It can be either employee cost, attendance hours or any other kind of figures, like statistical data. All figures can be viewed and maintained in both ProRoster and ProPlanning.

FieldDescriptionData TypeMandatoryComment
1Plan idTextX

This is the reference to an existing plan. It's not possible to import budget/figures without having a unique Plan ID.

2Budget typeIntegerX

Budget type can be:
0 = Cost
1 = Hours
3 = Other

3Budget idText(X)

The Budget ID is mandatory for identifying budget/figures of type Other (3).

4Budget descriptionText(X)

5Start date for budgetDate(X)

Start/End dates of budget periods are mandatory when:
- Creating/Deleting a budget period
- Updating Original budget value (Field 7) of an existing budget period.
If it's an adjustment of an old budget day, it's enough to have the Budget Date (Field 17).

6End date for budgetDate(X)

Start/End dates of budget periods are mandatory when:
- Creating/Deleting a budget period
- Updating Original budget value (Field 7) of an existing budget period.
If it's an adjustment of an old budget day, it's enough to have the Budget Date (Field 17).

7Original budget valueDecimal number(X)

This is the original budget value for the period, and it's used when generating the daily budget according to budget period and factor.

8Delete budget periodLogical

Flag for deleting a budget period. It's mandatory to supply also the budget period (Field 5 - 6).

9Day factor 1 (Monday)Integer(X)

Daily budget factor.

10Day factor 2 (Tuesday)Integer(X)

Daily budget factor.

11Day factor 3 (Wednesday)Integer(X)

Daily budget factor.

12Day factor 4 (Thursday)Integer(X)

Daily budget factor.

13Day factor 5 (Friday)Integer(X)

Daily budget factor.

14Day factor 6 (Saturday)Integer(X)

Daily budget factor.

15Day factor 7 (Sunday)Integer(X)

Daily budget factor.

16Allow overrideLogical

When YES, it will be possible to update overlapping budget periods (truncate/split of budget periods).

17Budget dateDate(X)

Budget date and actual budget value for a specific day. When trying to update a specific day, it's mandatory to have a budget with a period covering the date

18Date valueDecimal number(X)

Budget date and actual budget value for a specific day. When trying to update a specific day, it's mandatory to have a budget with a period covering the date