API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 19th, 2019
156
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 39.56 KB | None | 0 0
raw download clone embed print report
  1. --liquibase formatted sql
  2. --changeset cmarc:19-8Sprint3cmarc failOnError:true
  3.  
  4. -- insert in config master
  5. INSERT INTO OMXCONFIG.CONFIG_MASTER
  6.    (CATEGORY, CONFIGURATION, DESCRIPTION, CONFIG_TYPE, MASK,
  7.     ADDTS, ADDWHO, EDITTS, EDITWHO)
  8.  VALUES
  9.    ('ORDER', 'BILLTOKEY_PRINTTYPE', 'List of PRINTTYPE based on BILLTOKEY', 'CTCL', 'M',
  10.     SYSTIMESTAMP, 'cmarc', SYSTIMESTAMP, 'cmarc');
  11.  
  12. --generic config metadata
  13. INSERT INTO OMXCONFIG.GENERIC_CONFIG_METADATA
  14.    (CATEGORY, CONFIGURATION, COLUMN_TYPE, COLUMN_NUMBER, DISPLAY_LABEL,
  15.     DATA_TYPE, REQUIRED, FORMAT, ADDTS, ADDWHO,
  16.     EDITTS, EDITWHO)
  17.  VALUES
  18.    ('ORDER', 'BILLTOKEY_PRINTTYPE', 'KEY', 1, 'BILLTOKEY',
  19.     'STRING', 'Y', 'STRING', SYSTIMESTAMP, 'cmarc',
  20.     SYSTIMESTAMP, 'cmarc');
  21.  
  22. INSERT INTO OMXCONFIG.GENERIC_CONFIG_METADATA
  23.    (CATEGORY, CONFIGURATION, COLUMN_TYPE, COLUMN_NUMBER, DISPLAY_LABEL,
  24.     DATA_TYPE, REQUIRED, FORMAT, ADDTS, ADDWHO,
  25.     EDITTS, EDITWHO)
  26.  VALUES
  27.    ('ORDER', 'BILLTOKEY_PRINTTYPE', 'VALUE', 1, 'PRINTTYPE',
  28.     'STRING', 'Y', 'STRING', SYSTIMESTAMP, 'cmarc',
  29.     SYSTIMESTAMP, 'cmarc');
  30.  
  31. --generic congfig context  billToKey printType
  32. INSERT INTO OMXCONFIG.GENERIC_CONFIG_CONTEXT
  33.    (CATEGORY, CONFIGURATION, COLUMN_TYPE, COLUMN_NUMBER, REFDOCNAME,
  34.     VALUE_EXPRESSION, KEY_WEIGHT, ADDTS, ADDWHO, EDITTS,
  35.     EDITWHO)
  36.  VALUES
  37.    ('ORDER', 'BILLTOKEY_PRINTTYPE', 'KEY', 1, 'Order',
  38.     'billToKey', 1, SYSTIMESTAMP, 'cmarc', SYSTIMESTAMP,
  39.     'cmarc');
  40.  
  41. INSERT INTO OMXCONFIG.GENERIC_CONFIG_CONTEXT
  42.    (CATEGORY, CONFIGURATION, COLUMN_TYPE, COLUMN_NUMBER, REFDOCNAME,
  43.     VALUE_EXPRESSION, KEY_WEIGHT, ADDTS, ADDWHO, EDITTS,
  44.     EDITWHO)
  45.  VALUES
  46.    ('ORDER', 'BILLTOKEY_PRINTTYPE', 'VALUE', 1, 'Order',
  47.     'printType', 1, SYSTIMESTAMP, 'cmarc', SYSTIMESTAMP,
  48.     'cmarc');
  49.  
  50.  
  51. --insert in generic client config
  52. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  53.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  54.     KEY3, KEY4, KEY5, SECURED_FLAG, ADDTS,
  55.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  56.  VALUES
  57.    ('ORDER', 'MAPPING_LIST', '1184', 'ORDER', 'BILLTOKEY_PRINTTYPE',
  58.     '*', '*', '*', 'N', SYSTIMESTAMP,
  59.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  60.  
  61. --valorile specifice
  62.  
  63. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  64.  (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  65.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  66.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  67.  VALUES
  68.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'ARMY30', '*',
  69.     '*', '*', '*','AAFES' 'N', SYSTIMESTAMP,
  70.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  71.  
  72.  
  73. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  74.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  75.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  76.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  77.  VALUES
  78.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'AMAZ10', '*',
  79.     '*', '*', '*','AMAZON' 'N', SYSTIMESTAMP,
  80.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  81.  
  82.  
  83. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  84.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  85.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  86.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  87.  VALUES
  88.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BEDB11', '*',
  89.     '*', '*', '*','BBB' 'N', SYSTIMESTAMP,
  90.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  91.  
  92.  
  93. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  94.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  95.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  96.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  97.  VALUES
  98.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BEDB31', '*',
  99.     '*', '*', '*','BBB' 'N', SYSTIMESTAMP,
  100.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  101.  
  102.  
  103. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  104.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  105.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  106.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  107.  VALUES
  108.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BEAL10', '*',
  109.     '*', '*', '*','BEALLS' 'N', SYSTIMESTAMP,
  110.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  111.  
  112.  
  113. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  114.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  115.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  116.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  117.  VALUES
  118.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BEAL20', '*',
  119.     '*', '*', '*','BEALLS' 'N', SYSTIMESTAMP,
  120.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  121.  
  122.  
  123. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  124.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  125.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  126.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  127.  VALUES
  128.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BELK10', '*',
  129.     '*', '*', '*','BELK' 'N', SYSTIMESTAMP,
  130.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  131.  
  132.  
  133. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  134.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  135.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  136.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  137.  VALUES
  138.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BLUB10', '*',
  139.     '*', '*', '*','BLUESTEM' 'N', SYSTIMESTAMP,
  140.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  141.  
  142.  
  143. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  144.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  145.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  146.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  147.  VALUES
  148.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BURL10', '*',
  149.     '*', '*', '*','BURLINGTON' 'N', SYSTIMESTAMP,
  150.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  151.  
  152.  
  153. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  154.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  155.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  156.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  157.  VALUES
  158.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'CENT10', '*',
  159.     '*', '*', '*','CENTURY21' 'N', SYSTIMESTAMP,
  160.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  161.  
  162.  
  163. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  164.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  165.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  166.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  167.  VALUES
  168.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COAC02', '*',
  169.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  170.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  171.  
  172.  
  173. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  174.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  175.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  176.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  177.  VALUES
  178.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COAC09', '*',
  179.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  180.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  181.  
  182.  
  183. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  184.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  185.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  186.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  187.  VALUES
  188.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COAC73', '*',
  189.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  190.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  191.  
  192.  
  193. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  194.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  195.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  196.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  197.  VALUES
  198.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COAC74', '*',
  199.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  200.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  201.  
  202.  
  203. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  204.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  205.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  206.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  207.  VALUES
  208.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COAC76', '*',
  209.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  210.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  211.  
  212.  
  213. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  214.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  215.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  216.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  217.  VALUES
  218.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE04', '*',
  219.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  220.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  221.  
  222.  
  223. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  224.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  225.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  226.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  227.  VALUES
  228.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE13', '*',
  229.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  230.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  231.  
  232.  
  233. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  234.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  235.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  236.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  237.  VALUES
  238.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE14', '*',
  239.     '*', '*', '*','COACH' 'N', SYSTIMESTAMP,
  240.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  241.  
  242.  
  243. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  244.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  245.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  246.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  247.  VALUES
  248.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE01', '*',
  249.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  250.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  251.  
  252.  
  253. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  254.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  255.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  256.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  257.  VALUES
  258.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE02', '*',
  259.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  260.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  261.  
  262.  
  263. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  264.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  265.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  266.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  267.  VALUES
  268.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE03', '*',
  269.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  270.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  271.  
  272.  
  273. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  274.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  275.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  276.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  277.  VALUES
  278.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE05', '*',
  279.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  280.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  281.  
  282.  
  283. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  284.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  285.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  286.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  287.  VALUES
  288.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE06', '*',
  289.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  290.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  291.  
  292.  
  293. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  294.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  295.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  296.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  297.  VALUES
  298.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'COLE07', '*',
  299.     '*', '*', '*','COLEHAAN' 'N', SYSTIMESTAMP,
  300.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  301.  
  302.  
  303. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  304.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  305.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  306.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  307.  VALUES
  308.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'DILL10', '*',
  309.     '*', '*', '*','DILLARDS' 'N', SYSTIMESTAMP,
  310.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  311.  
  312.  
  313. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  314.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  315.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  316.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  317.  VALUES
  318.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'DILL20', '*',
  319.     '*', '*', '*','DILLARDS' 'N', SYSTIMESTAMP,
  320.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  321.  
  322.  
  323. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  324.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  325.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  326.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  327.  VALUES
  328.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'DSWS10', '*',
  329.     '*', '*', '*','DSW' 'N', SYSTIMESTAMP,
  330.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  331.  
  332.  
  333. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  334.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  335.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  336.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  337.  VALUES
  338.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MARM10', '*',
  339.     '*', '*', '*','FINISHLINE' 'N', SYSTIMESTAMP,
  340.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  341.  
  342.  
  343. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  344.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  345.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  346.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  347.  VALUES
  348.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'FOOT15', '*',
  349.     '*', '*', '*','FOOTLOCKER' 'N', SYSTIMESTAMP,
  350.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  351.  
  352.  
  353. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  354.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  355.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  356.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  357.  VALUES
  358.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'FOOT29', '*',
  359.     '*', '*', '*','FOOTLOCKER' 'N', SYSTIMESTAMP,
  360.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  361.  
  362.  
  363. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  364.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  365.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  366.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  367.  VALUES
  368.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'GREA20', '*',
  369.     '*', '*', '*','GREATAMERICAN' 'N', SYSTIMESTAMP,
  370.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  371.  
  372.  
  373. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  374.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  375.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  376.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  377.  VALUES
  378.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'GBYG10', '*',
  379.     '*', '*', '*','GUESS' 'N', SYSTIMESTAMP,
  380.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  381.  
  382.  
  383. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  384.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  385.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  386.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  387.  VALUES
  388.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'GBYG11', '*',
  389.     '*', '*', '*','GUESS' 'N', SYSTIMESTAMP,
  390.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  391.  
  392.  
  393. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  394.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  395.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  396.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  397.  VALUES
  398.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'GUES40', '*',
  399.     '*', '*', '*','GUESS' 'N', SYSTIMESTAMP,
  400.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  401.  
  402.  
  403. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  404.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  405.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  406.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  407.  VALUES
  408.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'GUES50', '*',
  409.     '*', '*', '*','GUESS' 'N', SYSTIMESTAMP,
  410.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  411.  
  412.  
  413. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  414.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  415.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  416.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  417.  VALUES
  418.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'HUDS83', '*',
  419.     '*', '*', '*','HBC' 'N', SYSTIMESTAMP,
  420.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  421.  
  422.  
  423. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  424.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  425.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  426.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  427.  VALUES
  428.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'HIBB10', '*',
  429.     '*', '*', '*','HIBBITT' 'N', SYSTIMESTAMP,
  430.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  431.  
  432.  
  433. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  434.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  435.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  436.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  437.  VALUES
  438.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'HOME10', '*',
  439.     '*', '*', '*','HOMESHOPPING' 'N', SYSTIMESTAMP,
  440.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  441.  
  442.  
  443. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  444.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  445.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  446.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  447.  VALUES
  448.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'JCPE10', '*',
  449.     '*', '*', '*','JCPCATALOG' 'N', SYSTIMESTAMP,
  450.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  451.  
  452.  
  453. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  454.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  455.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  456.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  457.  VALUES
  458.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'JCPE20', '*',
  459.     '*', '*', '*','JCPRETAIL' 'N', SYSTIMESTAMP,
  460.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  461.  
  462.  
  463. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  464.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  465.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  466.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  467.  VALUES
  468.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'JOUR10', '*',
  469.     '*', '*', '*','JOURNEY' 'N', SYSTIMESTAMP,
  470.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  471.  
  472.  
  473. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  474.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  475.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  476.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  477.  VALUES
  478.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KGST10', '*',
  479.     '*', '*', '*','KG' 'N', SYSTIMESTAMP,
  480.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  481.  
  482.  
  483. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  484.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  485.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  486.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  487.  VALUES
  488.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE01', '*',
  489.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  490.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  491.  
  492.  
  493. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  494.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  495.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  496.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  497.  VALUES
  498.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE02', '*',
  499.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  500.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  501.  
  502.  
  503. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  504.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  505.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  506.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  507.  VALUES
  508.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE03', '*',
  509.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  510.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  511.  
  512.  
  513. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  514.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  515.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  516.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  517.  VALUES
  518.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE05', '*',
  519.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  520.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  521.  
  522.  
  523. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  524.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  525.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  526.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  527.  VALUES
  528.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE06', '*',
  529.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  530.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  531.  
  532.  
  533. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  534.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  535.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  536.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  537.  VALUES
  538.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE07', '*',
  539.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  540.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  541.  
  542.  
  543. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  544.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  545.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  546.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  547.  VALUES
  548.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE12', '*',
  549.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  550.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  551.  
  552.  
  553. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  554.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  555.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  556.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  557.  VALUES
  558.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE15', '*',
  559.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  560.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  561.  
  562.  
  563. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  564.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  565.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  566.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  567.  VALUES
  568.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE16', '*',
  569.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  570.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  571.  
  572.  
  573. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  574.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  575.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  576.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  577.  VALUES
  578.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KATE22', '*',
  579.     '*', '*', '*','KATESPADE' 'N', SYSTIMESTAMP,
  580.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  581.  
  582.  
  583. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  584.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  585.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  586.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  587.  VALUES
  588.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KENN10', '*',
  589.     '*', '*', '*','KENNETHCOLE' 'N', SYSTIMESTAMP,
  590.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  591.  
  592.  
  593. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  594.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  595.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  596.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  597.  VALUES
  598.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KENN20', '*',
  599.     '*', '*', '*','KENNETHCOLE' 'N', SYSTIMESTAMP,
  600.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  601.  
  602.  
  603. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  604.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  605.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  606.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  607.  VALUES
  608.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KOHL10', '*',
  609.     '*', '*', '*','KOHLS' 'N', SYSTIMESTAMP,
  610.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  611.  
  612.  
  613. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  614.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  615.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  616.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  617.  VALUES
  618.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'KOHL20', '*',
  619.     '*', '*', '*','KOHLSP' 'N', SYSTIMESTAMP,
  620.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  621.  
  622.  
  623. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  624.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  625.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  626.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  627.  VALUES
  628.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'LORD10', '*',
  629.     '*', '*', '*','LORDTAYLOR' 'N', SYSTIMESTAMP,
  630.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  631.  
  632.  
  633. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  634.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  635.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  636.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  637.  VALUES
  638.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BLOO10', '*',
  639.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  640.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  641.  
  642.  
  643. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  644.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  645.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  646.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  647.  VALUES
  648.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BLOO11', '*',
  649.     '*', '*', '*','MACYP' 'N', SYSTIMESTAMP,
  650.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  651.  
  652.  
  653. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  654.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  655.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  656.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  657.  VALUES
  658.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BLOO25', '*',
  659.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  660.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  661.  
  662.  
  663. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  664.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  665.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  666.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  667.  VALUES
  668.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'BLOO40', '*',
  669.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  670.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  671.  
  672.  
  673. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  674.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  675.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  676.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  677.  VALUES
  678.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY02', '*',
  679.     '*', '*', '*','MACYP' 'N', SYSTIMESTAMP,
  680.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  681.  
  682.  
  683. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  684.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  685.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  686.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  687.  VALUES
  688.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY10', '*',
  689.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  690.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  691.  
  692.  
  693. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  694.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  695.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  696.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  697.  VALUES
  698.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY40', '*',
  699.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  700.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  701.  
  702.  
  703. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  704.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  705.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  706.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  707.  VALUES
  708.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY56', '*',
  709.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  710.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  711.  
  712.  
  713. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  714.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  715.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  716.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  717.  VALUES
  718.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY60', '*',
  719.     '*', '*', '*','MACY' 'N', SYSTIMESTAMP,
  720.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  721.  
  722.  
  723. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  724.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  725.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  726.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  727.  VALUES
  728.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MACY75', '*',
  729.     '*', '*', '*','MACYBACKSTAGE' 'N', SYSTIMESTAMP,
  730.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  731.  
  732.  
  733. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  734.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  735.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  736.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  737.  VALUES
  738.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MARI30', '*',
  739.     '*', '*', '*','MARINE' 'N', SYSTIMESTAMP,
  740.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  741.  
  742.  
  743. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  744.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  745.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  746.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  747.  VALUES
  748.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MICH11', '*',
  749.     '*', '*', '*','MICHAELKORS' 'N', SYSTIMESTAMP,
  750.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  751.  
  752.  
  753. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  754.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  755.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  756.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  757.  VALUES
  758.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MICH20', '*',
  759.     '*', '*', '*','MICHAELKORS' 'N', SYSTIMESTAMP,
  760.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  761.  
  762.  
  763. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  764.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  765.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  766.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  767.  VALUES
  768.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MICH30', '*',
  769.     '*', '*', '*','MICHAELKORS' 'N', SYSTIMESTAMP,
  770.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  771.  
  772.  
  773. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  774.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  775.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  776.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  777.  VALUES
  778.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MICH31', '*',
  779.     '*', '*', '*','MICHAELKORS' 'N', SYSTIMESTAMP,
  780.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  781.  
  782.  
  783. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  784.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  785.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  786.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  787.  VALUES
  788.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MICH70', '*',
  789.     '*', '*', '*','MICHAELKORS' 'N', SYSTIMESTAMP,
  790.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  791.  
  792.  
  793. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  794.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  795.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  796.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  797.  VALUES
  798.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MODE10', '*',
  799.     '*', '*', '*','MODELLS' 'N', SYSTIMESTAMP,
  800.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  801.  
  802.  
  803. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  804.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  805.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  806.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  807.  VALUES
  808.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NEIM40', '*',
  809.     '*', '*', '*','NEIMANMARCUSP' 'N', SYSTIMESTAMP,
  810.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  811.  
  812.  
  813. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  814.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  815.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  816.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  817.  VALUES
  818.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NEXC10', '*',
  819.     '*', '*', '*','NEXCOM' 'N', SYSTIMESTAMP,
  820.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  821.  
  822.  
  823. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  824.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  825.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  826.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  827.  VALUES
  828.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'HAUT10', '*',
  829.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  830.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  831.  
  832.  
  833. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  834.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  835.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  836.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  837.  VALUES
  838.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD10', '*',
  839.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  840.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  841.  
  842.  
  843. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  844.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  845.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  846.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  847.  VALUES
  848.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD20', '*',
  849.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  850.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  851.  
  852.  
  853. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  854.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  855.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  856.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  857.  VALUES
  858.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD30', '*',
  859.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  860.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  861.  
  862.  
  863. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  864.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  865.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  866.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  867.  VALUES
  868.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD40', '*',
  869.     '*', '*', '*','NORDSTROMP' 'N', SYSTIMESTAMP,
  870.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  871.  
  872.  
  873. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  874.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  875.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  876.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  877.  VALUES
  878.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD55', '*',
  879.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  880.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  881.  
  882.  
  883. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  884.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  885.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  886.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  887.  VALUES
  888.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'NORD75', '*',
  889.     '*', '*', '*','NORDSTROM' 'N', SYSTIMESTAMP,
  890.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  891.  
  892.  
  893. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  894.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  895.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  896.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  897.  VALUES
  898.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'ARVI02', '*',
  899.     '*', '*', '*','PVH' 'N', SYSTIMESTAMP,
  900.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  901.  
  902.  
  903. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  904.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  905.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  906.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  907.  VALUES
  908.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'CALV10', '*',
  909.     '*', '*', '*','PVH' 'N', SYSTIMESTAMP,
  910.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  911.  
  912.  
  913. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  914.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  915.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  916.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  917.  VALUES
  918.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'PHIL40', '*',
  919.     '*', '*', '*','PVH' 'N', SYSTIMESTAMP,
  920.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  921.  
  922.  
  923. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  924.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  925.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  926.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  927.  VALUES
  928.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'DDSD10', '*',
  929.     '*', '*', '*','ROSS' 'N', SYSTIMESTAMP,
  930.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  931.  
  932.  
  933. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  934.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  935.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  936.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  937.  VALUES
  938.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'ROSS10', '*',
  939.     '*', '*', '*','ROSS' 'N', SYSTIMESTAMP,
  940.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  941.  
  942.  
  943. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  944.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  945.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  946.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  947.  VALUES
  948.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'SAKS20', '*',
  949.     '*', '*', '*','SAKS' 'N', SYSTIMESTAMP,
  950.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  951.  
  952.  
  953. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  954.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  955.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  956.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  957.  VALUES
  958.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'SAKS30', '*',
  959.     '*', '*', '*','SAKS' 'N', SYSTIMESTAMP,
  960.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  961.  
  962.  
  963. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  964.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  965.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  966.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  967.  VALUES
  968.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'SHOE86', '*',
  969.     '*', '*', '*','SHOESENSATION' 'N', SYSTIMESTAMP,
  970.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  971.  
  972.  
  973. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  974.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  975.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  976.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  977.  VALUES
  978.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'SPEC11', '*',
  979.     '*', '*', '*','STAGE' 'N', SYSTIMESTAMP,
  980.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  981.  
  982.  
  983. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  984.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  985.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  986.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  987.  VALUES
  988.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'STEI10', '*',
  989.     '*', '*', '*','STEINMART' 'N', SYSTIMESTAMP,
  990.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  991.  
  992.  
  993. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  994.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  995.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  996.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  997.  VALUES
  998.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'TIMB01', '*',
  999.     '*', '*', '*','TIMBERLAND' 'N', SYSTIMESTAMP,
  1000.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1001.  
  1002.  
  1003. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1004.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1005.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1006.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1007.  VALUES
  1008.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'HOME80', '*',
  1009.     '*', '*', '*','TJX' 'N', SYSTIMESTAMP,
  1010.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1011.  
  1012.  
  1013. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1014.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1015.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1016.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1017.  VALUES
  1018.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'MARS10', '*',
  1019.     '*', '*', '*','TJX' 'N', SYSTIMESTAMP,
  1020.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1021.  
  1022.  
  1023. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1024.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1025.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1026.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1027.  VALUES
  1028.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'SOUR10', '*',
  1029.     '*', '*', '*','TJX' 'N', SYSTIMESTAMP,
  1030.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1031.  
  1032.  
  1033. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1034.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1035.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1036.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1037.  VALUES
  1038.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'TJUK10', '*',
  1039.     '*', '*', '*','TJX' 'N', SYSTIMESTAMP,
  1040.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1041.  
  1042.  
  1043. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1044.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1045.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1046.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1047.  VALUES
  1048.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'WINN10', '*',
  1049.     '*', '*', '*','TJX' 'N', SYSTIMESTAMP,
  1050.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1051.  
  1052.  
  1053. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1054.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1055.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1056.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1057.  VALUES
  1058.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'VONM10', '*',
  1059.     '*', '*', '*','VONMAUR' 'N', SYSTIMESTAMP,
  1060.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1061.  
  1062.  
  1063. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1064.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1065.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1066.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1067.  VALUES
  1068.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'WALM10', '*',
  1069.     '*', '*', '*','WALMART' 'N', SYSTIMESTAMP,
  1070.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1071.  
  1072.  
  1073. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1074.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1075.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1076.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1077.  VALUES
  1078.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'WALM30', '*',
  1079.     '*', '*', '*','WALMARTCOM' 'N', SYSTIMESTAMP,
  1080.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1081.  
  1082.  
  1083. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1084.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1085.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1086.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1087.  VALUES
  1088.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', 'ZAPP10', '*',
  1089.     '*', '*', '*','ZAPPOS' 'N', SYSTIMESTAMP,
  1090.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
  1091.  
  1092.  
  1093. INSERT INTO OMXCONFIG.GENERIC_CLIENT_CONFIG
  1094.    (CATEGORY, CONFIGURATION, CLIENT_ID, KEY1, KEY2,
  1095.     KEY3, KEY4, KEY5,VALUE1, SECURED_FLAG, ADDTS,
  1096.     ADDWHO, EDITTS, EDITWHO, RANK, APP_MERGED_FLAG)
  1097.  VALUES
  1098.    ('ORDER', 'BILLTOKEY_PRINTTYPE', '1184', '*', '*',
  1099.     '*', '*', '*','STD' 'N', SYSTIMESTAMP,
  1100.     'cmarc',SYSTIMESTAMP, 'cmarc', 0, 'N');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!