QAD 2017 Enterprise Edition > User Guides > Lean Manufacturing > Using External Applications > Supermarket Workbench > Exporting Supermarket Workbench Data
  
Exporting Supermarket Workbench Data
Use Supermarket Workbench Export (17.2.18) to generate a data file containing records that you can use with an external application to analyze the projected performance of a kanban supermarket based on future demand data.

Supermarket Workbench Export (17.2.18)
The user interface is similar to Kanban Workbench Export. See Exporting Kanban Workbench Data.
Additional fields include the following:
Pacemakers Only
Enter Yes to limit the data export to processes that have Process Function set to PACE in Kanban Process Maintenance. Otherwise, all processes meeting the other criteria are selected.
Start Date
Enter the first date on which the system selects future demand data for export.
Planning Horizon
Enter the number of days in the future that the system will consider in selecting demand records for export.
The default is 30.
Supermarket Workbench Export File Definition shows the structure of the file created by Supermarket Workbench Export. The values in the fields are the same as those the system loads into Supermarket Workbench.
The file includes two different record types:
• H: A header record
• D: Records to hold date, demand, and level schedule information (both Current and Preliminary level schedule)
The record type is in the first position of each record.

Supermarket Workbench Export File Definition
 
Field Name
Format
Description
RECORD TYPE “H”
 
 
knb_primary_key
decimal
Kanban Loop ID: Internal keyid of knb_mstr record
part
character
Item
step
character
Step
description
character
Item description
pitch_um
character
Pitch unit of measure
source_site
character
Source site
source
character
Source ID of the process, supermarket, or supplier
source_type_literal
character
Source type: Process, Supermarket, or Supplier
supermarket_site
character
Supermarket site
supermarket
character
Supermarket
start_date
date
Start date
horizon
integer
Horizon days
buffer_maximum
decimal
Buffer maximum
order_point
decimal
Order point
order_qty
decimal
Order quantity
safety_stock
decimal
Safety stock
safety_time
decimal
Safety days (in decimal days)
replenish_lead_time
integer
Replenishment time (in seconds)
kanban_qty
decimal
Kanban quantity
active_card_count
integer
Active card count
pitch_quantity
decimal
Pitch quantity
pitch_interval
decimal
Pitch interval
takt_time
integer
Takt time (in seconds)
epe_interval
decimal
EPEI
epei_display
character
EPEI display: Hours, Days, Weeks, or Months
current_inventory
decimal
Current inventory quantity (in pitch UM)
pacemaker
Yes/No
Pacemaker process indicator
warning_limit
decimal
Warning limit quantity
critical_limit
decimal
Critical limit quantity
cycle_time
integer
Takt Time/Cycle Time (in seconds)
• Pacemakers = Takt Time
• Non-Pacemakers = Cycle Time
• Non-Processes = 1
first_scheduled_date
date
First scheduled date
epei_in_secs
integer
EPEI in seconds
RECORD TYPE “D”
 
knb_primary_key
decimal
Kanban Loop ID: Internal keyid of knb_mstr record
calculated_date
date
Date being scheduled
available_time
integer
Available time (in seconds)
total_demand
decimal
Total independent and dependent demand
level_schedule
decimal
Calculated level schedule
prelim_level_schedule
decimal
Calculated preliminary level schedule