Importing Catering Budgets

When the Budget Forecast OPERA Control is active. you can import catering budgets. For more information, see Budget Forecast Entry.

At least one of the following data elements must be populated for each budget record imported: BUDGET_REVENUE, BUDGET_COVERS, FORECAST_REVENUE,FORECAST_COVERS.

Table 24-7 Catering Budget

Column	Description	Max Data Length	Sample Data	Mandatory
BUDGET_DATE	The Budget Date. The format must be 'YYYYMMDD.'	DATE	Ex: (20240121)
CODE_TYPE	The Code Type for the Budget being imported.  The valid values for this column are: VECN - Event Type, Catering Only N VECY - Event Type, Catering Only Y VGCN - Market, Catering Only N VGCY - Market, Catering Only Y VMCN - Meal Period, Catering Only N (Available when the Catering Meal Periods OPERA Control is active ) VMCY - Meal Period, Catering Only Y (Available when the Catering Meal Periods OPERA Control is active ) VRCN - Revenue Type, Catering Only N VRCY - Revenue Type, Catering Only Y	20	Ex: VRCY
CODE	The Code for the corresponding Budget that will be loaded.	50	Ex: (FOOD)
BUDGET_REVENUE	The monthly Budget Revenue for the selected Code.  One for the following fields must be populated: BUDGET_REVENUE, BUDGET_COVERS,FORECAST_REVENUE,FORECAST_COVERS.	38	Ex: (100000)
BUDGET_COVERS	The monthly Budget Covers for the selected Code.  One for the following fields must be populated: BUDGET_REVENUE, BUDGET_COVERS,FORECAST_REVENUE,FORECAST_COVERS.	38	Ex: (5000)
FORECAST_REVENUE	The monthly Forecast Revenue for the selected Code.  One for the following fields must be populated: BUDGET_REVENUE, BUDGET_COVERS,FORECAST_REVENUE,FORECAST_COVERS.	38	Ex: (100000)
FORECAST_COVERS	The monthly Forecast Covers for the selected Code.  One for the following fields must be populated: BUDGET_REVENUE, BUDGET_COVERS,FORECAST_REVENUE,FORECAST_COVERS.	38	Ex: (5000)