POS Interface Task

The Interface Task loads data imported from the Import Task into the SO_RESULTS_DETAIL table in LFSO. The Interface Task should be scheduled to run after the Import Task is completed. This ensures the required data has been imported at the time when the Interface Task runs.

A single record in the SO_RESULTS_DETAIL table contains the volume number for a driver during a single interval. This volume may represent revenue, sales, transactions, traffic, or any other volume type.

Each record in the SO_RESULTS_DETAIL table includes this information:

Column Value/Description
SKDGRP_ID The ID of the driver that the POS data is collected under
RESDET_DATE The date of the interval
RESDET_TIME The start time of the interval
RESDET_VOLUME The total volume recorded during the interval
INVTYP_ID

The ID of one of these interval types, which indicate how frequently the data is collected:

  • 1: 15-minute interval
  • 2: 30-minute interval
  • 3: 60-minute interval
  • 4: 24-hour interval
  • 5: 7-day interval
VOLTYP_ID This column is blank for drivers.
Note: Records in the SO_RESULTS_DETAIL table can be used to store payroll cost data that is required when using the Labor Budgeting module. If you are using the Labor Budgeting module, see "Preparing actuals for plan generation" in the Infor Workforce Management Budget Creation and Management Guide for more details.