Note: in these queries, we're using "c:\micros" as the base export path, but you may want or need a different one depending on your setup. Feel free to change that part; the filename on the other hand should not be altered.

-- ------------------

-- MENU_ITEMS

-- ------------------

SELECT mi_seq,

obj_num,

name_1,

name_2,

maj_grp_seq,

fam_grp_seq,

price_grp_seq,

cond_grp_mem_seq,

cond_req,

cond_allowed,

Mi_type_seq

FROM micros.mi_def;

OUTPUT TO 'c:\micros\mi_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- MENU_ITEM_PRICES

-- ------------------

SELECT mi_seq,

mi_price_seq,

''||preset_amt_1||'',

''||preset_amt_2||'',

''||preset_amt_3||'',

''||preset_amt_4||'',

''||preset_amt_5||'',

''||preset_amt_6||'',

''||preset_amt_7||'',

''||preset_amt_8||'',

''||preset_amt_9||'',

''||preset_amt_10||''

FROM (

SELECT

mi_seq,

mi_price_seq,

preset_amt_1,

preset_amt_2,

preset_amt_3,

preset_amt_4,

preset_amt_5,

preset_amt_6,

preset_amt_7,

preset_amt_8,

preset_amt_9,

preset_amt_10,

ROW_NUMBER() OVER (PARTITION BY mi_seq ORDER BY effective_from DESC) AS row_num

FROM micros.mi_price_def

) AS price_data

WHERE row_num = 1;

OUTPUT TO 'c:\micros\mi_price_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- *

-- ------------------

SELECT mi_type_seq,

name,

tax_class_seq

FROM micros.mi_type_class_def;

OUTPUT TO 'c:\micros\mi_type_class_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- GROUP_FAMILIES

-- ------------------

SELECT fam_grp_seq,

obj_num,

name

FROM micros.fam_grp_def;

OUTPUT TO 'c:\micros\fam_grp_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- TAX_RATES

-- ------------------

SELECT tax_rate_seq,

name,

percentage

FROM micros.tax_rate_def;

OUTPUT TO 'c:\micros\tax_rate_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- TAX_CLASSES

-- ------------------

SELECT tax_class_seq,

obj_num,

name,

ob_tax_1_active,

ob_tax_2_active,

ob_tax_3_active,

ob_tax_4_active,

ob_tax_5_active,

ob_tax_6_active,

ob_tax_7_active,

ob_tax_8_active

FROM micros.tax_class_def;

OUTPUT TO 'c:\micros\tax_class_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- CONDIMENT_GROUPS

-- ------------------

SELECT cond_grp_seq,

name

FROM micros.cond_grp_def;

OUTPUT TO 'c:\micros\cond_grp_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- CONDIMENT_GROUPS_MEMBER

-- ------------------

SELECT cond_grp_mem_seq,

obj_num,

name

FROM micros.cond_grp_mem_def;

OUTPUT TO 'c:\micros\cond_grp_mem_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- *

-- ------------------

SELECT cond_grp_sel_seq,

obj_num

FROM micros.cond_grp_sel_def;

OUTPUT TO 'c:\micros\cond_grp_sel_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- CONDIMENT_GROUP_SELECTION_EXT

-- ------------------

SELECT cond_grp_sel_seq,

cond_grp_seq,

min_val,

max_val

FROM micros.cond_grp_sel_ext_def;

OUTPUT TO 'c:\micros\cond_grp_sel_ext_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- COMBO_ITEMS

-- ------------------

SELECT combo_seq,

combo_grp_seq,

mi_seq,

obj_num,

name,

priority,

ob_rsvd01,

ob_rsvd02,

ob_rsvd03,

ob_rsvd04,

ob_rsvd05,

ob_rsvd06,

ob_rsvd07,

ob_rsvd08,

ob_ac_size,

ob_allow_prev_rnd_acr,

override_level,

mlvl_mask,

scan_placeholder_immed,

ob_force_default_item_confirm,

ob_allow_uncombo

FROM micros.combo_def;

OUTPUT TO 'c:\micros\combo_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- COMBO_MENU_ITEM

-- ------------------

SELECT combo_menu_item_seq,

combo_grp_seq,

mi_seq,

quantity,

ob_default,

preset_amt_1,

preset_amt_2,

preset_amt_3,

preset_amt_4,

preset_amt_5,

preset_amt_6,

preset_amt_7,

preset_amt_8,

preset_amt_9,

preset_amt_10,

vat_txbl_1,

vat_txbl_2,

vat_txbl_3,

vat_txbl_4,

vat_txbl_5,

vat_txbl_6,

vat_txbl_7,

vat_txbl_8,

vat_txbl_9,

vat_txbl_10,

ob_ot01_default,

ob_ot02_default,

ob_ot03_default,

ob_ot04_default,

ob_ot05_default,

ob_ot06_default,

ob_rsvd01,

ob_rsvd02,

ob_rsvd03,

ob_rsvd04,

ob_rsvd05,

ob_rsvd06,

ob_rsvd07,

effective_from,

effective_to,

size_1,

size_2,

size_3,

size_4,

size_1_price_lvl,

size_2_price_lvl,

size_3_price_lvl,

size_4_price_lvl,

print_class_seq,

ob_ot07_default,

ob_ot08_default,

ob_ot09_default,

ob_ot10_default,

ob_ot11_default,

ob_ot12_default

FROM micros.combo_menu_item_def;

OUTPUT TO 'c:\micros\combo_menu_item_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- COMBO_GROUP

-- ------------------

SELECT combo_grp_seq,

ts_style_seq,

name,

obj_num,

hht_ts_style_seq,

ob_combo_dsc_override,

default_color,

com_ts_style_seq,

com_hht_ts_style_seq,

combo_grp_ext_seq

FROM micros.combo_grp_def;

OUTPUT TO 'c:\micros\combo_grp_def.txt' FORMAT ASCII DELIMITED BY ',';

​

-- ------------------

-- COMBO_SIDE

-- ------------------

SELECT combo_side_seq,

combo_grp_seq,

combo_seq,

side_num,

override_level,

mlvl_mask

FROM micros.combo_side_def;

OUTPUT TO 'c:\micros\combo_side_def.txt' FORMAT ASCII DELIMITED BY ',';

For legacy customers who have used Deliverect's manual v1 combo builder, contact us when you are importing your POS combos for the first time. We will be on hand to review your combos in Deliverect, as you will need to remove the old manually attached combo groups to operate completely with the POS versions.