Difference between revisions of "Budget Import"
From sbv.wiki
m |
|||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
The budget import adds budget items maintained in the [[Budget Configuration]]. | The budget import adds budget items maintained in the [[Budget Configuration]]. | ||
| + | |||
| + | An budget import is identified by the sheet name or file name containing the word "Budget". | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 11: | Line 13: | ||
| Day Of Week | | Day Of Week | ||
| Day Of Week | | Day Of Week | ||
| − | | All Days, | + | | All Days, Week Days, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday |
| Yes | | Yes | ||
Latest revision as of 20:48, 27 April 2022
The budget import adds budget items maintained in the Budget Configuration.
An budget import is identified by the sheet name or file name containing the word "Budget".
| Column Type | Identifiers | Notes | Required |
|---|---|---|---|
| Day Of Week | Day Of Week | All Days, Week Days, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday | Yes |
| Budget Labor Levels | The ID or name of your budget based labor levels | The labor level ID, labor level description or the scheduler ID. You must provide all the labor levels designated as Budget labor levels. | Yes |
| Shift | Shift | The shift ID or scheduler ID | Yes |
| Shift Count | Shift Count | The number of shifts | Yes |
| Sub Shift | Sub Shift | If you want to enforce budgetary levels to a particular schedule within a shift, then you must specify the Sub Shift ID. | No |
| Hours | Hours | The number of hours this budget item represents | No |
| Build Date | Build Date | The starting date for building schedules that use this budget item. | No |
| Shift Count Overage | Shift Count Overage | The shift count overage allowance | No |
| Scheduler Based | Scheduler or Scheduler Budget | If this budget item is to be used for building schedules then enter Y, Yes, T or True. | No |