---

[200.00 68000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020201002 ','48000.00','200.00','68000.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[300.00 132000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020201012 ','1800.00','300.00','132000.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[100.00 71800.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020501004 ','8000.00','100.00','71800.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[400.00 287200.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020201005 ','32000.00','400.00','287200.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[200.00 138000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020201007 ','7200.00','200.00','138000.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[300.00 215400.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020701003 ','24000.00','300.00','215400.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[100.00 47700.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020902001 ','2400.00','100.00','47700.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[500.00 95000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10011101001 ','12000.00','500.00','95000.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[500.00 95000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10011101002 ','6000.00','500.00','95000.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[200.00 92800.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','10020201013 ','1200.00','200.00','92800.00','96120017 ','C/S','S122 ','10019 ','CR')

---

[ -6000.00]

INSERT INTO transale (orderdate,orderno,itemno,qty_pcs,qty_ctn,amount,custno,zone,area,salecode,channel) value ('20160420','5904-1198 ','DIS ','1','1','6000','96120017 ','C/S','S122 ','10019 ','CR')