Loading Payroll and Point-of-Sale Actuals

Infor Consulting Services configures an interface that loads actual payroll and point-of-sale data into the SO_RESULTS_DETAIL table in LFSO. This task is performed whenever there are new actuals, which generally happens before generating a new plan or updating an existing one.

The following data is required:

  • Payroll data, which originates in the Human Resources or Payroll department.
  • Point-of-sale data, such as revenue, which originates in a point-of-sale system.

Each record in the SO_RESULTS_DETAIL table includes the following information:

Column Value/Description
SKDGRP_ID

One of the following:

  • a driver, for point-of-sale data
  • a store, for top-down forecasts
  • a department, for bottom-up projections
RESDET_DATE The date for the interval for which the data is relevant.
RESDET_TIME This time for the interval for which the data is relevant.
RESDET_VOLUME The total AHR or POS data for this interval.
INVTYP_ID

The ID of one of the following intervals, which indicates how frequently the data is initially collected:

  • 1: 15-minute interval
  • 2: 30-minute interval
  • 3: 60-minute interval
  • 4: 24-hour interval
  • 5: 7-day interval
VOLTYP_ID

One of the following volume types:

  • Payroll.
  • For drivers, which are based on point-of-sale data, this column is blank.
Note: For point-of-sale data, the volume type in LFSO must match a column configured in a Labor Budgeting table so that it will be displayed on the Worksheet. The default volume type in LFSO that is configured within Labor Budgeting is REVENUE, which corresponds to the FCIT_SALES column in the FCIT_ITEM table in Labor Budgeting.