INSERT INTO employee (emp_cd, distcent_cd, name, "password", dept_name) VALUES ('731807 ', 'D01 ', '田中 明雄', '@731807', '1'); INSERT INTO employee (emp_cd, distcent_cd, name, "password", dept_name) VALUES ('510566 ', 'D01 ', '岸元 猛', '@510566', '2'); INSERT INTO employee (emp_cd, distcent_cd, name, "password", dept_name) VALUES ('422110 ', 'D01 ', '内田 祥子', '@422110', '3'); INSERT INTO employee (emp_cd, distcent_cd, name, "password", dept_name) VALUES ('857012 ', 'D01 ', '山本 豊', '@857012', '4'); INSERT INTO employee (emp_cd, distcent_cd, name, "password", dept_name) VALUES ('226115 ', 'D01 ', '原 里美', '@226115', '5'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('SU00001 ', '(株)スカイマーケット', '146-0082 ', '東京都 大田区 池上1-34-8', '03-3751-8196 ', '山田 洋介'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('SU00002 ', '太平道物産(株)', '100-0004 ', '東京都 千代田区 大手町2-6', '03-3295-5159 ', '高嶋 優'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('SU00003 ', '(株)荒島商会', '260-0045 ', '千葉県 千葉市 中央区 弁天1-23-5', '043-227-6522 ', '中尾 純一'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00001 ', 'シチズン・ストア', '130-0001 ', '東京都 墨田区 吾妻橋692-1', '03-3612-4909 ', '羽賀 務'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00002 ', '(有)東堂商店', '146-0095 ', '東京都 大田区 多摩川1-6-22', '03-3758-2381 ', '東堂 新十郎'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00003 ', '(株)生活工房', '214-0038 ', '神奈川県 川崎市 中原区 新城1-4-72', '004-788-5876 ', '小野寺 誠'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00004 ', '白石食料品店', '131-0031 ', '東京都 墨田区 墨田2-35-1', '03-3614-9744 ', '白石 よしみ'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00005 ', '(有)下川屋', '135-0002 ', '東京都 江東区 北砂3-5-9', '03-3644-6117 ', '下川 晶'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00006 ', 'タウンショップ吉塚', '190-0003 ', '東京都 立川市 富士見町23-1', '042-524-6213 ', '吉塚 都美子'); INSERT INTO customer (cust_cd, cust_name, post_no, address, phone_no, pres_name) VALUES ('RE00007 ', 'オリエンタルフーズ(株)', '331-0852 ', '埼玉県 さいたま市 桜木町47-2', '048-647-4059 ', '吉田 鉄也'); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00001 ', '10kg 魚河産ナナヒカリ', 2500, '袋 ', 15); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00002 ', '1kg 業務用小麦粉(強力粉)', 500, '袋 ', 15); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00003 ', '2L アブラナ油', 1000, '缶 ', 5); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00004 ', '2kg 活性炭', 800, '袋 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00005 ', '100g コーヒー豆', 1000, '缶 ', 10); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('MA00006 ', '1kg 北海道産黒牛ロース肉', 2000, '箱 ', 5); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00001 ', '100g 干しシイタケ', 550, '袋 ', 10); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00002 ', '10個入 パック入りたこ焼き', 400, '袋 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00003 ', '200g レトルトビーフカレー', 400, '袋 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00004 ', '250g パック詰胡瓜キムチ', 800, '袋 ', 10); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00005 ', '200g 冷凍うどん玉', 500, '玉 ', 15); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00006 ', '1kg 十勝産ジャガイモ', 600, '袋 ', 10); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('FO00007 ', '1kg 青森産リンゴ', 500, '袋 ', 5); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00001 ', '300g 袋入り乾パン', 350, '袋 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00002 ', '100g 袋入り揚げポテト', 200, '袋 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00003 ', '200g 箱入りバタークッキー', 300, '箱 ', 15); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00004 ', '400g 生乳アイスクリーム', 500, '袋 ', 10); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00005 ', '100g 板状チョコレート', 200, '個 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00006 ', '10個入 アーモンドキャラメル', 400, '箱 ', 20); INSERT INTO item (item_cd, item_name, unit_mony, unit_name, stock_num) VALUES ('CO00007 ', '200g パック入りワラビ餅', 300, '袋 ', 10); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301011237560001', 'SU00001 ', '731807 ', 'D01 ', '2003-01-01', '12:37:56', '2003-01-08', 10, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301021237560001', 'SU00002 ', '510566 ', 'D01 ', '2003-01-02', '12:37:56', '2003-01-09', 10, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301031237560001', 'SU00003 ', '422110 ', 'D01 ', '2003-01-03', '12:37:56', '2003-01-10', 10, 2); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301041237560001', 'RE00001 ', '857012 ', 'D01 ', '2003-01-04', '12:37:56', '2003-01-11', 20, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301051237560001', 'RE00002 ', '226115 ', 'D01 ', '2003-01-05', '12:37:56', '2003-01-12', 30, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301061237560001', 'RE00003 ', '731807 ', 'D01 ', '2003-01-06', '12:37:56', '2003-01-13', 40, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301071237560001', 'RE00004 ', '510566 ', 'D01 ', '2003-01-07', '12:37:56', '2003-01-14', 50, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301081237560001', 'RE00005 ', '422110 ', 'D01 ', '2003-01-08', '12:37:56', '2003-01-15', 60, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301091237560001', 'RE00006 ', '857012 ', 'D01 ', '2003-01-09', '12:37:56', '2003-01-16', 70, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301101237560001', 'RE00007 ', '226115 ', 'D01 ', '2003-01-10', '12:37:56', '2003-01-17', 85, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301111237560001', 'SU00001 ', '731807 ', 'D01 ', '2003-01-11', '12:37:56', '2003-01-18', 85, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301121237560001', 'SU00002 ', '510566 ', 'D01 ', '2003-01-12', '12:37:56', '2003-01-19', 85, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301131237560001', 'SU00003 ', '422110 ', 'D01 ', '2003-01-13', '12:37:56', '2003-01-20', 85, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301141237560001', 'RE00001 ', '857012 ', 'D01 ', '2003-01-14', '12:37:56', '2003-01-21', 95, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301151237560001', 'RE00002 ', '226115 ', 'D01 ', '2003-01-15', '12:37:56', '2003-01-22', 105, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301161237560001', 'RE00003 ', '731807 ', 'D01 ', '2003-01-16', '12:37:56', '2003-01-23', 115, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301171237560001', 'RE00004 ', '510566 ', 'D01 ', '2003-01-17', '12:37:56', '2003-01-24', 125, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301181237560001', 'RE00010 ', '422110 ', 'D01 ', '2003-01-18', '12:37:56', '2003-01-25', 135, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301191237560001', 'RE00006 ', '857012 ', 'D01 ', '2003-01-19', '12:37:56', '2003-01-26', 145, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301201237560001', 'RE00007 ', '226115 ', 'D01 ', '2003-01-20', '12:37:56', '2003-01-27', 160, 2); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301211237560001', 'SU00001 ', '731807 ', 'D01 ', '2003-01-21', '12:37:56', '2003-01-28', 160, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301221237560001', 'SU00002 ', '510566 ', 'D01 ', '2003-01-22', '12:37:56', '2003-01-29', 160, 2); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301231237560001', 'SU00003 ', '422110 ', 'D01 ', '2003-01-23', '12:37:56', '2003-01-30', 160, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301241237560001', 'RE00001 ', '857012 ', 'D01 ', '2003-01-24', '12:37:56', '2003-01-31', 170, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301251237560001', 'RE00002 ', '226115 ', 'D01 ', '2003-01-25', '12:37:56', '2003-02-01', 180, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301261237560001', 'RE00003 ', '731807 ', 'D01 ', '2003-01-26', '12:37:56', '2003-02-02', 190, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301271237560001', 'RE00004 ', '510566 ', 'D01 ', '2003-01-27', '12:37:56', '2003-02-03', 200, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301281237560001', 'RE00005 ', '422110 ', 'D01 ', '2003-01-28', '12:37:56', '2003-02-04', 210, 0); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301291237560001', 'RE00006 ', '857012 ', 'D01 ', '2003-01-29', '12:37:56', '2003-02-05', 220, 1); INSERT INTO salesorder (order_no, cust_cd, emp_cd, distcent_cd, ent_date, ent_time, supp_date, sum, order_stat) VALUES ('200301301237560001', 'RE00007 ', '226115 ', 'D01 ', '2003-01-30', '12:37:56', '2003-02-06', 235, 1); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00001 ', 3, 4, 7500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00002 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00003 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00005 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'MA00006 ', 8, 9, 16000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00001 ', 9, 10, 4950); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00002 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00003 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00005 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00006 ', 4, 5, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'FO00007 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00001 ', 6, 7, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00002 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00003 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00004 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00005 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00006 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301031237560001', 'CO00007 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00001 ', 7, 8, 17500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00002 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00003 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00005 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'MA00006 ', 2, 3, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00001 ', 3, 4, 1650); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00002 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00003 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00005 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00006 ', 8, 9, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'FO00007 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00001 ', 10, 11, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00002 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00003 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00004 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00005 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00006 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301071237560001', 'CO00007 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00001 ', 10, 11, 25000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00002 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00003 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00005 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'MA00006 ', 5, 6, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00001 ', 6, 7, 3300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00002 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00003 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00005 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00006 ', 1, 2, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'FO00007 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00001 ', 3, 4, 1050); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00002 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00003 ', 5, 6, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00004 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00005 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00006 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301101237560001', 'CO00007 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00001 ', 4, 5, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00002 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00003 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00005 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'MA00006 ', 9, 10, 18000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00001 ', 10, 11, 5500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00002 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00003 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00005 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00006 ', 5, 6, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'FO00007 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00001 ', 7, 8, 2450); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00002 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00003 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00004 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00005 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00006 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301141237560001', 'CO00007 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00001 ', 8, 9, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00002 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00003 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00005 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'MA00006 ', 3, 4, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00001 ', 4, 5, 2200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00002 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00003 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00005 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00006 ', 9, 10, 5400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'FO00007 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00001 ', 1, 2, 350); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00002 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00003 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00004 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00005 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00006 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301181237560001', 'CO00007 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00001 ', 1, 2, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00002 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00003 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00005 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'MA00006 ', 6, 7, 12000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00001 ', 7, 8, 3850); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00002 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00003 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00005 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00006 ', 2, 3, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'FO00007 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00001 ', 4, 5, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00002 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00003 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00004 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00005 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00006 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301211237560001', 'CO00007 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00001 ', 5, 6, 12500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00002 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00003 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00005 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'MA00006 ', 10, 11, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00001 ', 1, 2, 550); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00002 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00003 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00005 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00006 ', 6, 7, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'FO00007 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00001 ', 8, 9, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00002 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00003 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00004 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00005 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00006 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301251237560001', 'CO00007 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00001 ', 9, 10, 22500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00002 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00003 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00005 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'MA00006 ', 4, 5, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00001 ', 5, 6, 2750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00002 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00003 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00005 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00006 ', 10, 11, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'FO00007 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00001 ', 2, 3, 700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00002 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00003 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00004 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00005 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00006 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301291237560001', 'CO00007 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00001 ', 6, 7, 15000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00002 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00003 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00005 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'MA00006 ', 1, 2, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00001 ', 2, 3, 1100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00002 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00003 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00005 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00006 ', 7, 8, 4200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'FO00007 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00001 ', 9, 10, 3150); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00002 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00003 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00004 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00005 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00006 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301061237560001', 'CO00007 ', 5, 6, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'aa ', 3, 4, 7500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'MA00002 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'MA00003 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'MA00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'MA00005 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'MA00006 ', 8, 9, 16000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00001 ', 9, 10, 4950); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00002 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00003 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00005 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00006 ', 4, 5, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'FO00007 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00001 ', 6, 7, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00002 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00003 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00004 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00005 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00006 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301131237560001', 'CO00007 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00001 ', 5, 6, 12500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00002 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00003 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00005 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'MA00006 ', 10, 11, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00001 ', 1, 2, 550); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00002 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00003 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00005 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00006 ', 6, 7, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'FO00007 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00001 ', 8, 9, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00002 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00003 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00004 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00005 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00006 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301151237560001', 'CO00007 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00001 ', 9, 10, 22500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00002 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00003 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00005 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'MA00006 ', 4, 5, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00001 ', 5, 6, 2750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00002 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00003 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00005 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00006 ', 10, 11, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'FO00007 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00001 ', 2, 3, 700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00002 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00003 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00004 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00005 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00006 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301191237560001', 'CO00007 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00001 ', 2, 3, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00002 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00003 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00005 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'MA00006 ', 7, 8, 14000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00001 ', 8, 9, 4400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00002 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00003 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00005 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00006 ', 3, 4, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'FO00007 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00001 ', 5, 6, 1750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00002 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00003 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00004 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00005 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00006 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301221237560001', 'CO00007 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00001 ', 4, 5, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00002 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00003 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00005 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'MA00006 ', 9, 10, 18000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00001 ', 10, 11, 5500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00002 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00003 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00005 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00006 ', 5, 6, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'FO00007 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00001 ', 7, 8, 2450); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00002 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00003 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00004 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00005 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00006 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301241237560001', 'CO00007 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00001 ', 8, 9, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00002 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00003 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00005 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'MA00006 ', 3, 4, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00001 ', 4, 5, 2200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00002 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00003 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00005 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00006 ', 9, 10, 5400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'FO00007 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00001 ', 1, 2, 350); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00002 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00003 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00004 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00005 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00006 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301281237560001', 'CO00007 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'MA00001 ', 1, 2, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'aa ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'MA00003 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'MA00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'MA00005 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'MA00006 ', 6, 7, 12000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00001 ', 7, 8, 3850); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00002 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00003 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00005 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00006 ', 2, 3, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'FO00007 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00001 ', 4, 5, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00002 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00003 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00004 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00005 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00006 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301011237560001', 'CO00007 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'aa ', 5, 6, 12500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'MA00002 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'MA00003 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'MA00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'MA00005 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'MA00006 ', 10, 11, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00001 ', 1, 2, 550); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00002 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00003 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00005 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00006 ', 6, 7, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'FO00007 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00001 ', 8, 9, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00002 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00003 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00004 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00005 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00006 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301051237560001', 'CO00007 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00001 ', 9, 10, 22500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00002 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00003 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00005 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'MA00006 ', 4, 5, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00001 ', 5, 6, 2750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00002 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00003 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00004 ', 8, 9, 6400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00005 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00006 ', 10, 11, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'FO00007 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00001 ', 2, 3, 700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00002 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00003 ', 4, 5, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00004 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00005 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00006 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301091237560001', 'CO00007 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00001 ', 2, 3, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00002 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00003 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00005 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'MA00006 ', 7, 8, 14000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00001 ', 8, 9, 4400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00002 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00003 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00005 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00006 ', 3, 4, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'FO00007 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00001 ', 5, 6, 1750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00002 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00003 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00004 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00005 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00006 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301121237560001', 'CO00007 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00001 ', 6, 7, 15000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00002 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00003 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00005 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'MA00006 ', 1, 2, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00001 ', 2, 3, 1100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00002 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00003 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00005 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00006 ', 7, 8, 4200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'FO00007 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00001 ', 9, 10, 3150); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00002 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00003 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00004 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00005 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00006 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301161237560001', 'CO00007 ', 5, 6, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00001 ', 3, 4, 7500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00002 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00003 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00005 ', 7, 8, 7000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'MA00006 ', 8, 9, 16000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00001 ', 9, 10, 4950); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00002 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00003 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00004 ', 2, 3, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00005 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00006 ', 4, 5, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'FO00007 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00001 ', 6, 7, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00002 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00003 ', 8, 9, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00004 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00005 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00006 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301231237560001', 'CO00007 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00001 ', 7, 8, 17500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00002 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00003 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00005 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'MA00006 ', 2, 3, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00001 ', 3, 4, 1650); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00002 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00003 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00005 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00006 ', 8, 9, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'FO00007 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00001 ', 10, 11, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00002 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00003 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00004 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00005 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00006 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301271237560001', 'CO00007 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00001 ', 10, 11, 25000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00002 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00003 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00005 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'MA00006 ', 5, 6, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00001 ', 6, 7, 3300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00002 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00003 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00005 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00006 ', 1, 2, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'FO00007 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00001 ', 3, 4, 1050); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00002 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00003 ', 5, 6, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00004 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00005 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00006 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301301237560001', 'CO00007 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'MA00001 ', 2, 3, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'aa ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'MA00003 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'MA00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'MA00005 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'MA00006 ', 7, 8, 14000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00001 ', 8, 9, 4400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00002 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00003 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00005 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00006 ', 3, 4, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'FO00007 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00001 ', 5, 6, 1750); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00002 ', 6, 7, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00003 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00004 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00005 ', 9, 10, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00006 ', 10, 11, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301021237560001', 'CO00007 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00001 ', 4, 5, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00002 ', 5, 6, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00003 ', 6, 7, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00005 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'MA00006 ', 9, 10, 18000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00001 ', 10, 11, 5500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00002 ', 1, 2, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00003 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00005 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00006 ', 5, 6, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'FO00007 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00001 ', 7, 8, 2450); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00002 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00003 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00004 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00005 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00006 ', 2, 3, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301041237560001', 'CO00007 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00001 ', 8, 9, 20000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00002 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00003 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00004 ', 1, 2, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00005 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'MA00006 ', 3, 4, 6000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00001 ', 4, 5, 2200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00002 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00003 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00004 ', 7, 8, 5600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00005 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00006 ', 9, 10, 5400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'FO00007 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00001 ', 1, 2, 350); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00002 ', 2, 3, 400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00003 ', 3, 4, 900); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00004 ', 4, 5, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00005 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00006 ', 6, 7, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301081237560001', 'CO00007 ', 7, 8, 2100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00001 ', 1, 2, 2500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00002 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00003 ', 3, 4, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00004 ', 4, 5, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00005 ', 5, 6, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'MA00006 ', 6, 7, 12000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00001 ', 7, 8, 3850); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00002 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00003 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00005 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00006 ', 2, 3, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'FO00007 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00001 ', 4, 5, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00002 ', 5, 6, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00003 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00004 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00005 ', 8, 9, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00006 ', 9, 10, 3600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301111237560001', 'CO00007 ', 10, 11, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00001 ', 7, 8, 17500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00002 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00003 ', 9, 10, 9000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00004 ', 10, 11, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00005 ', 1, 2, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'MA00006 ', 2, 3, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00001 ', 3, 4, 1650); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00002 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00003 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00004 ', 6, 7, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00005 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00006 ', 8, 9, 4800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'FO00007 ', 9, 10, 4500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00001 ', 10, 11, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00002 ', 1, 2, 200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00003 ', 2, 3, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00004 ', 3, 4, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00005 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00006 ', 5, 6, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301171237560001', 'CO00007 ', 6, 7, 1800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00001 ', 10, 11, 25000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00002 ', 1, 2, 500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00003 ', 2, 3, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00004 ', 3, 4, 2400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00005 ', 4, 5, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'MA00006 ', 5, 6, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00001 ', 6, 7, 3300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00002 ', 7, 8, 2800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00003 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00005 ', 10, 11, 5000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00006 ', 1, 2, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'FO00007 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00001 ', 3, 4, 1050); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00002 ', 4, 5, 800); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00003 ', 5, 6, 1500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00004 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00005 ', 7, 8, 1400); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00006 ', 8, 9, 3200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301201237560001', 'CO00007 ', 9, 10, 2700); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00001 ', 6, 7, 15000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00002 ', 7, 8, 3500); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00003 ', 8, 9, 8000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00004 ', 9, 10, 7200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00005 ', 10, 11, 10000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'MA00006 ', 1, 2, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00001 ', 2, 3, 1100); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00002 ', 3, 4, 1200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00003 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00004 ', 5, 6, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00005 ', 6, 7, 3000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00006 ', 7, 8, 4200); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'FO00007 ', 8, 9, 4000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00001 ', 9, 10, 3150); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00002 ', 10, 11, 2000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00003 ', 1, 2, 300); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00004 ', 2, 3, 1000); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00005 ', 3, 4, 600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00006 ', 4, 5, 1600); INSERT INTO salesordertail (order_no, item_cd, pack_num, sepa_num, sum) VALUES ('200301261237560001', 'CO00007 ', 5, 6, 1500);