itemexport 20080310 1944.sql

this is sample for traders

 ('HUK-DOTDL3','0920070000492',0,0,'HUK-','DOT HUKI DELUX/SILICONE L','NONE',0,0.00,101.00,137.00,0.00,0.00,238.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-DOTST1','0920070000494',0,0,'HUK-','DOT HUKI STANDART/LATEX S','NONE',0,0.00,61.00,30.00,3000.00,0.00,91.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-DOTST2','0920070000495',0,0,'HUK-','DOT HUKI STANDART/LATEX M','NONE',0,0.00,54.00,43.00,3000.00,2.00,95.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-DOTST3','0920070000496',0,0,'HUK-','DOT HUKI STANDART/LATEX L','NONE',0,0.00,21.00,93.00,3000.00,0.00,114.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-EMPDLX','0920070000497',0,0,'HUK-','EMPENG HUKI DELUX/SILICONE','NONE',0,0.00,43.00,38.00,0.00,0.00,81.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-EMPSSS','0920070000498',0,0,'HUK-','EMPENG SOFT SHIELD SOTHER','NONE',0,0.00,0.00,26.00,11550.00,0.00,26.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-EMPSTD','0920070000499',0,0,'HUK-','EMPENG HUKI STANDART/LATEX','NONE',0,0.00,44.00,21.00,0.00,1.00,64.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-HUKIB1','0920070000502',0,0,'HUK-','BOTOL HUKI 120 ML PERSEGI','NONE',0,0.00,96.00,65.00,0.00,1.00,160.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-HUKIB2','0920070000503',0,0,'HUK-','BOTOL HUKI 240 ML PERSEGI','NONE',0,0.00,132.00,8.00,5500.00,0.00,140.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-ROUND1','0920070000507',0,0,'HUK-','BOTOL HUKI ROUND/BULAT 4OZ','NONE',0,0.00,41.00,11.00,0.00,0.00,52.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('HUK-ROUND2','0920070000508',0,0,'HUK-','BOTOL HUKI ROUND/BULAT 8OZ','NONE',0,0.00,26.00,8.00,12500.00,0.00,34.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-ALK','0920070000516',0,0,'IKA-','ALKOHOL 70 % 100 ML. IKA.','NONE',0,0.00,175.00,387.00,0.00,6.00,556.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-BROMI','0920070000517',0,0,'IKA-','BROMIKA SYRUP 60ML','NONE',0,0.00,26.00,3.00,11000.00,0.00,29.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-FLUG','0920070000518',0,0,'IKA-','FLUGESIC TABLET 1 BOX=\'25','NONE',0,0.00,2.00,1.00,29000.00,0.00,3.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-GOND','0920070000519',0,0,'IKA-','MINYAK GANDAPURA 30 IKA','NONE',0,0.00,104.00,136.00,0.00,0.00,240.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-GOND1','0920070000520',0,0,'IKA-','MINYAK GANDAPURA 60ML IKA','NONE',0,0.00,32.00,161.00,5511.00,0.00,193.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-GOND2','0920070000521',0,0,'IKA-','MINYAK GANDAPURA 100M IKA','NONE',0,0.00,109.00,104.00,0.00,0.00,213.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-IKA01','0920070000522',0,0,'IKA-','IKADRIL SYRUP 60 ML APEL','NONE',0,0.00,198.00,97.00,0.00,0.00,295.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-IKA02','0920070000523',0,0,'IKA-','IKADRIL SYRUP 100 ML APEL','NONE',0,0.00,183.00,19.00,0.00,0.00,202.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-KAMB12','0920070000526',0,0,'IKA-','KAMULVIT B12 SYR 120 ML','NONE',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-PERMEN','0920070000530',0,0,'IKA-','PERMEN STARMINT 60\'S','NONE',0,0.00,0.00,2.00,51000.00,0.00,2.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-SAL','0920070000531',0,0,'IKA-','SALICYL TALK IKA 80GR/ORANGE','NONE',0,0.00,238.00,277.00,0.00,3.00,512.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IKA-SALM','0920070000532',0,0,'IKA-','SALICYL IKA MENTHOL 80GR/HIJAU','NONE',0,0.00,84.00,72.00,0.00,0.00,156.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-ASMA','0920070000535',0,0,'IND-','INDO OBAT ASMA','NONE',0,0.00,10.00,0.00,20000.00,0.00,10.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-BTK','0920070000536',0,0,'IND-','INDO OBAT BATUK BERDAHAK','NONE',0,0.00,38.00,0.00,20000.00,0.00,38.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-CACING','0920070000537',0,0,'IND-','INDO OBAT CACING ANAK','NONE',0,0.00,12.00,0.00,30000.00,0.00,12.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-FLU','0920070000538',0,0,'IND-','INDO OBAT FLU','NONE',0,0.00,59.00,1.00,20000.00,0.00,60.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-OBC','0920070000539',0,0,'IND-','INDO OBAT BATUK CAIR','NONE',0,0.00,46.00,0.00,10000.00,0.00,46.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-OM','0920070000540',0,0,'IND-','INDO OBAT MAAG','NONE',0,0.00,7.00,3.00,20000.00,0.00,10.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-OSK','0920070000541',0,0,'IND-','INDO OBAT SAKIT KEPALA','NONE',0,0.00,8.00,0.00,20000.00,0.00,8.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-OTD','0920070000542',0,0,'IND-','INDO OBAT TAMBAH DARAH','NONE',0,0.00,11.00,1.00,20000.00,0.00,12.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-PP','0920070000543',0,0,'IND-','INDO OBAT PENURUN PANAS','NONE',0,0.00,29.00,0.00,20000.00,0.00,29.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IND-PPA','0920070000544',0,0,'IND-','INDO OBAT PENURUN PANAS ANAK','NONE',0,0.00,27.00,1.00,10000.00,0.00,28.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IPI-VITA1','0920070000545',0,0,'IPI-','VITAMIN A. IPI','NONE',0,0.00,33.00,506.00,2182.50,4.00,535.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IPI-VITB1','0920070000546',0,0,'IPI-','VITAMIN B1. IPI','NONE',0,0.00,112.00,1064.00,2182.50,3.00,1173.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IPI-VITB12','0920070000547',0,0,'IPI-','VITAMIN B.12 IPI','NONE',0,0.00,55.00,471.00,2376.50,4.00,522.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IPI-VITBC','0920070000548',0,0,'IPI-','VITAMIN B.COMPLEX IPI','NONE',0,0.00,25.00,1197.00,2376.50,15.00,1207.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('IPI-VITC','0920070000549',0,0,'IPI-','VITAMIN C. IPI','NONE',0,0.00,378.00,3555.00,2376.50,64.00,3869.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-ANASY','0920070000551',0,0,'ITR-','ANATON SYRUP 60 ML','NONE',0,0.00,50.00,65.00,3200.00,3.00,112.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-GUANI','1220070002515',0,0,'ITR-','GUANISTREP SYRUP 60 ML','NONE',0,0.00,139.00,621.00,2625.00,9.00,751.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-ITRABA','0920070000553',0,0,'ITR-','ITRABAT SYRUP 100 ML','NONE',0,0.00,193.00,272.00,3542.00,4.00,461.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-ITRASY','0920070000554',0,0,'ITR-','ITRAMOL SYRUP 60 ML','NONE',0,0.00,369.00,441.00,1482.00,0.00,810.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-OBH','1220070002396',0,0,'ITR-','OBAT BATUK HITAM ITR.100ML','NONE',0,0.00,231.00,431.00,1525.00,0.00,662.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ITR-OBP','0920070000555',0,0,'ITR-','OBAT BATUK PUTIH ITR.100ML','NONE',0,0.00,230.00,382.00,1650.00,11.00,601.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO01','0920070000567',0,0,'JJS-','JOHN. BABY POWDER 50 GR.','NONE',0,0.00,93.00,130.00,1956.49,0.00,223.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO02','0920070000568',0,0,'JJS-','JOHN. BABY POWDER 100 GR.','NONE',0,0.00,45.00,83.00,3706.90,3.00,125.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO03','0920070000569',0,0,'JJS-','JOHN. BABY POWDER 200 GR.','NONE',0,0.00,29.00,36.00,6392.00,0.00,65.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO04','0920070000570',0,0,'JJS-','JOHN. BABY POWDER 300 GR.','NONE',0,0.00,10.00,11.00,7958.00,0.00,21.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO05','1220070002517',0,0,'JJS-','JOHN. POWDER WITH MILK 300 GR','NONE',0,0.00,3.00,3.00,9660.00,0.00,6.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-BAPO06','0920070000571',0,0,'JJS-','JOHN. POWDER WITH MILK 100 GR','NONE',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-CREAM1','0920070000573',0,0,'JJS-','JOHN. BABY CREAM 50 GR.','NONE',0,0.00,34.00,134.00,9798.94,0.00,168.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-CREAM2','0920070000574',0,0,'JJS-','JOHN. BABY CREAM 100 GR.','NONE',0,0.00,26.00,34.00,19144.00,3.00,57.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-JBC01','0920070000576',0,0,'JJS-','JOHN.COLONGE 50 ML','NONE',0,0.00,20.00,7.00,6635.00,0.00,27.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-JBCO2','0920070000577',0,0,'JJS-','JOHN.COLOGNE 100 ML','NONE',0,0.00,14.00,6.00,11612.00,0.00,20.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-OIL01','0920070000580',0,0,'JJS-','JOHN. BABY OIL 50 ML.','NONE',0,0.00,0.00,36.00,6244.00,0.00,36.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-OIL02','0920070000581',0,0,'JJS-','JOHN. BABY OIL 125 ML.','NONE',0,0.00,41.00,49.00,11772.89,0.00,90.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-OIL03','0920070000582',0,0,'JJS-','JOHN. BABY OIL 200 ML.','NONE',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SAMP05','0120080001225',0,0,'JJS-','JOHN BABY SHAMPO GOLD 50ML','NONE',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SAMPO1','0920070000587',0,0,'JJS-','JOHN.BABY SHAMPHO 50 ML.','NONE',0,0.00,86.00,29.00,3092.00,0.00,115.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SAMPO2','0920070000588',0,0,'JJS-','JOHN.BABY SHAMPHO 125 ML.','NONE',0,0.00,62.00,18.00,7567.00,3.00,77.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SAMPO3','0920070000589',0,0,'JJS-','JOHN.BABY SHAMPHO 200 ML.','NONE',0,0.00,0.00,2.00,11016.00,0.00,2.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SAMPO4','0920070000590',0,0,'JJS-','JOHN.BABY SHAMPOO GOLD 100 ML.','NONE',0,0.00,15.00,9.00,6050.00,0.00,24.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SOAP01','1220070002518',0,0,'JJS-','JOHN.SOAP WITH MILK 80 GR.','NONE',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SOAP02','0920070000591',0,0,'JJS-','JOHN. BABY SOAP 80 GR.','NONE',0,0.00,5.00,75.00,1686.25,0.00,80.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SOAP03','0920070000592',0,0,'JJS-','JOHN. BABY SOAP 100 GR.','NONE',0,0.00,49.00,41.00,1950.00,0.00,90.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SOAP04','0120080001224',0,0,'JJS-','JOHN SOAP OIL 100GR','NONE',0,0.00,5.00,7.00,2033.00,0.00,12.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('JJS-SOAP05','0220080001255',0,0,'JJS-','JHONSON SOAP BLOSSOM 70GR','NONE',0,0.00,48.00,0.00,2125.27,0.00,48.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-CER','0920070000617',0,0,'KAL-','CEREBROVIT GINKO /STRIP','NONE',0,0.00,16.00,63.00,9765.52,1.00,78.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-CER01','0920070000618',0,0,'KAL-','CEREBROFORT AA-DHA SYRUP 100ML','NONE',0,0.00,82.00,94.00,12790.00,0.00,176.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-CER02','0920070000619',0,0,'KAL-','CEREBROFORT GOLD 200ML','NONE',0,0.00,48.00,86.00,27250.00,0.00,134.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-CERA','0920070000620',0,0,'KAL-','CEREBROVIT ACTIVE 10 CAPS','NONE',0,0.00,37.00,27.00,12540.00,0.00,64.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-CEREXL','0920070000622',0,0,'KAL-','CEREBROVIT XCEL 10 CAPS','NONE',0,0.00,33.00,118.00,9975.00,1.00,150.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-KAL','0920070000626',0,0,'KAL-','KALPANAK CAIR 10 ML','NONE',0,0.00,1419.00,930.00,1455.00,15.00,2334.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-KALKRI','0920070000627',0,0,'KAL-','KALPANAX KRIM 5GR','NONE',0,0.00,104.00,800.00,3638.00,7.00,897.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-NEOENT','0920070000631',0,0,'KAL-','ENTEROSTOP TABLET 1 BX=12','NONE',0,0.00,12.16,42.84,37248.00,1.00,54.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-NEURAL','0920070000632',0,0,'KAL-','NEURALGIN 24*6 KAPLET','NONE',0,0.00,12.00,72.00,43100.00,0.00,84.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-PROC','0920070000635',0,0,'KAL-','PROCOLD KAPLET 24*6KAPLET','NONE',0,0.00,8.00,35.50,36672.00,0.50,43.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-PROM','0920070000637',0,0,'KAL-','PROMAG TABLET1 BOX=\'12','NONE',0,0.00,242.25,286.25,36305.28,13.00,515.50,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-PROMA','1220070002397',0,0,'KAL-','PROMAG DOUBLE ACTION 2X6TAB','NONE',0,0.00,285.00,99.00,16500.00,1.00,383.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KAL-XON-CE','0920070000638',0,0,'KAL-','XON-CE TABLET','NONE',0,0.00,11.00,25.00,32300.00,2.00,34.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KEM-BER','0920070000639',0,0,'KEM-','KEMBANGBULAN BERSIH DARAH','NONE',0,0.00,47.00,3041.00,4887.50,84.00,3004.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-ABATE','1220070002398',0,0,'KIF-','ABATE 50 SACH BASF','NONE',0,0.00,5.00,6.00,69250.00,1.00,10.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-ASIFIT','1220070002399',0,0,'KIF-','ASIFIT 30 \' KAP','NONE',0,0.00,8.00,85.00,20900.00,0.00,93.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-BATU','0920070000640',0,0,'KIF-','BATUGIN ELIXIR SYRUP 300 ML','NONE',0,0.00,109.00,109.00,13686.30,2.00,216.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-CAL','0920070000641',0,0,'KIF-','CALCIDOL B 12.SYRUP 120 ML.','NONE',0,0.00,69.00,12.00,10480.25,0.00,81.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-CALC','0920070000642',0,0,'KIF-','CALCIDOL B 12 SYRUP 60ML','NONE',0,0.00,32.00,14.00,7128.00,1.00,45.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-ENKA','0920070000643',0,0,'KIF-','ENKASARI SYRUP 100 ML','NONE',0,0.00,266.00,788.00,6328.85,4.00,1050.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-FITUNO','1220070002400',0,0,'KIF-','FITUNO 30 \' KAP','NONE',0,0.00,5.00,3.00,49500.00,0.00,8.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-JOOD','0920070000650',0,0,'KIF-','JOODKALI PIL / TUBE 20\'S.','NONE',0,0.00,31.00,77.00,2223.00,0.00,108.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-KINA','1220070002401',0,0,'KIF-','KINA TABLET 12 \' S','NONE',0,0.00,37.00,75.00,4235.00,0.00,112.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-MAGA','1220070002402',0,0,'KIF-','MAGASIDA 100 TABLET','NONE',0,0.00,4.00,5.00,37530.00,0.00,9.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-MAGA1','1220070002403',0,0,'KIF-','MAGASIDA SYRUP 150 ML','NONE',0,0.00,8.00,11.00,17470.00,2.00,17.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-MAR01','0920070000651',0,0,'KIF-','MARCK PUTIH 40 GR','NONE',0,0.00,446.00,423.00,4162.50,0.00,869.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('KIF-MAR02','0920070000652',0,0,'KIF-','MARCK CREME 40 GR',