USE lo_tracking;

INSERT INTO users(role_id,name,email,password_hash) VALUES (1,'System Administrator','admin@local.test','$2y$12$omCt/i8OXZGuxYWIrcDiSOAwze4.C7s3T9N1xAsI4WopGYrQMWFEy'),(2,'Procurement Officer','procurement@local.test','$2y$12$1D5Hgux3K4kn6lRWRwebquz5h5E9KNs0jVLwCbaTR80LpU0fmndme'),(3,'Store Officer','store@local.test','$2y$12$JT/9BPMAJA2rwH2qpUUOGeDMfQmdzv5UvA7Sou.00rrx/KOoBew6C'),(4,'Management User','management@local.test','$2y$12$xE/kk.mGwWyla5DQA1AwZuiMH7w0wvm4hSvfBoJP8NUCzHUQTiDrq');
INSERT IGNORE INTO branches(name) VALUES ('BAGAN SERAI'),('BATU GAJAH'),('BATU KURAU'),('BOTA'),('CHEMOR'),('GOPENG'),('IPOH'),('KAMPAR'),('KAMUNTING'),('KG GAJAH'),('KUALA KANGSAR'),('MAIPK CAWANGAN'),('PARIT'),('POKOK ASSAM'),('SEMANGGOL'),('SERI ISKANDAR'),('SUNGKAI'),('TAIPING'),('TG TUALANG'),('ULU KINTA'),('ULU SEPETANG');
INSERT IGNORE INTO vendors(name) VALUES ('20DB HEARING SDN BHD'),('3D GENS SDN BHD'),('A R MEDICOM (M) SDN.BHD'),('AA PHARMACY'),('ABBOT LABORATORIES  SDN BHD'),('ABBOT LABORATORIES SDN BHD'),('ACURAMED SDN BHD'),('ADVENTA HEALTHCARE SDN BHD'),('AIN MEDICARE SDN BHD'),('AL-AMR (IOC MARKETING)'),('ALAM MEDIK'),('ALPHA TECH BAY SDN BHD'),('ALPHATECH BAY SDN BHD'),('ALPRO ALLIANCE PERAK SDN BHD'),('ALPRO PHARMACY'),('ALPRO PHARMACY SDN BHD'),('AMBANG SIHAT SDN BHD'),('AMIENS RESOURCES SDN BHD'),('ANLENE OS (SHOPEE)'),('APEX PHARMA'),('ASHFA RESOURCES'),('AUDIOLAB SOUND HEARING SOLUTION SDN BHD'),('AUREUMAEX MARKETING SDN BHD'),('AUREUMAEX MEDICARE MARKETING (M) SDN BHD'),('AUREUMAEX MEDICARE MARKETING SDN BHD'),('AVRO MEDICAL SDN. BHD.'),('BE INTERNATIONAL MARKETING SDN BHD'),('BERGAMOT SDN BHD'),('BIG PHARMACY (SHOPEE)'),('BIG PHARMACY SDN BHD'),('BIGEAST MARKETING SDN BHD'),('BMS MEDICAL SDN BHD'),('CARING ESTORE SDN BHD'),('CARING ESTRORE SDN BHD'),('COLOPLAST MALAYSIA SDN BHD'),('CONVATEC MALAYSIA SDN BHD'),('CONVATEC SDN BHD'),('DEMANT MALAYSIA SDN BHD'),('DKSH MALAYSIA SDN BHD'),('DKSH SDN BHD'),('FACULTY OF SPECIALISTS HOSPITAL (IPOH) SDN BHD'),('FAIDZAM DINAMIK SDN BHD'),('FAMILY PHARMACY (SHOPEE)'),('FINNMED SDN BHD'),('FUJI PHARMACEUTICAL SDN BHD'),('GLOBAL PRECISION SALES & SERVICES SDN BHD'),('H-POINT PHARMACY'),('H-POINT PHARMACY SDN BHD'),('HARMONI JAYA'),('HONG SOON CHAN HUP KEE SDN BHD'),('HTM PHARMACY'),('HUMEDICAL SDN BHD'),('INSAN BAKTI SDN BHD'),('INSAN BAKTI SDN. BHD.'),('INTAN NIAGA SDN BHD (SHOPEE)'),('KEN WEN ENTERPRISE'),('LOTUS MEDICAL SUPPLIES'),('MEDI CHEM SDN BHD'),('MEDI-CHEM SYSTEMS SDN BHD'),('MEDIK MAJU SDN BHD'),('MEDSYN SDN BHD'),('METRO JENDELA SDN BHD'),('MIKROMEDIK SILVER SDN BHD'),('MLS MED SERVICES DN BHD'),('MLS MED SERVICES SDN BHD'),('MONT EBONY'),('MONT EBONY SDN BHD'),('MULTICARE PHARMACY SDN BHD'),('NIBONG TEBAL ENTEPRISE SDN BHD'),('NIBONG TEBAL ENTERPRISE SDN BHD'),('NOVA LABORATORIES SDN BHD'),('NUTRIXGOLD SDN BHD'),('ONE SOLUTION INDUSTRY TRADING SDN BHD'),('OXYENERGY'),('PHARMSELATAN'),('PRIMABUMI SDN BHD'),('PRO LIFE MEDICAL SUPPLIES SDN BHD'),('PROLIFE MEDICAL SUPPLIES SDN BHD'),('PURE SOUND TECH ENTERPRISE'),('RIDGE BIOMED SDN BHD'),('S.L. CHAN OPTOMETRIST SDN BHD'),('SBL HEALTHCARE SDN BHD'),('SCHMIDT BIOMEDTECH SDN BHD'),('SHOPEE'),('SHOPEE SUPERMARKET'),('SHOPPEE'),('SMY PHARMACY'),('SUNWAY MULTICARE PHARMACY'),('SUNWAY MULTICARE PHARMACY, TASEK'),('SYS HEALTHCARE SDN BHD'),('TERAJU FARMA SDN BHD'),('TERAS NADI MEDIC SDN BHD'),('TOTAL MEDICAL SUPPLIES SDN BHD'),('TRB CHEMEDICA MALAYSIA SDN BHD'),('UMMI SURGICAL SDN BHD'),('UNITED ITALIAN TRADING (M) SDN BHD'),('VOLTEN ASIAEMALL SDN BHD'),('WAIKOM ENTERPRISE'),('WAIKOM PHARMACY'),('WAREHOUSE PHARMACY'),('WIJA PHARMA SDN BHD'),('WINWA (SHOPEE)'),('WISE CARE MARKETING SDN BHD'),('ZUELLIG PHARMA SDN BHD');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('KHAIRUNIZAM BIN MOHAMED','750327-08-6647','NO 145','KG CIK ZAINAL TAMBAHAN 1',NULL,31200,'IPOH','011-5528409');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('SITI AISYAH BINTI ABDUL GHANI','020721-14-0846','BLOCK C28/C03','LENGKOK BERCHAM TIMUR 4',NULL,31400,'IPOH','017-3909251');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MOHAMAD NAZEREL BIN NAZARI','940250-08-5029','NO 48','DATARAN PERPADUAN 6',NULL,31150,'IPOH','011-21505298');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NUR AFIQAH BINTI MUSTAFA KAMAL','970926-08-5384','NO 9','JLN LAPANGAN SSI 5',NULL,31650,'IPOH','011-21848185');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('AARISH NAJMI BIN MAT RODI','110106-08-0035','NO 87A','SG PERIKAN',NULL,34400,'SEMANGGOL','019-5712414');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NUR DAHLIA ALYSSA BINTI MUHAMMAD ZAIM','231004-08-0924','NO 11','LALUAN TUALANG BARU 12, TMN TUALANG BARU',NULL,31800,'TG TUALANG','011-28864159');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NIK AHMAD ZUL HAKIM BIN AHMAD ZAIDI','991217-08-6301','NO 11','HALA TASEK TIMUR 21',NULL,31400,'IPOH','017-4865910');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMMAD ZULHILMI BIN MOHAMAD GHAZALI','690514-08-6202','E2','PERUMAHAN AWAM 3',NULL,31600,'GOPENG','011-37830039');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NOR AZLINDA BINTI AZIZAN','930730-07-5006',NULL,'KG CHANGKAT JERING, KUALA DIPANG',NULL,31850,'KAMPAR','017-4902919');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('JATIAH BINTI KADIR','530905-08-6236','NO 3090','FELDA GUNUNG BESOUT 3',NULL,35600,'SUNGKAI','013-5016317');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MAZLAN BIN YUSUF','670621-08-6189',NULL,'KG BUKIT CHAWI',NULL,36800,'KG GAJAH',NULL);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHMAMAD ADIF AZHAR BIN MOHAMAD HANES','230401-08-0659',NULL,'DEPAN SEKOLAH  KG PDG CHANGKAT',NULL,32600,'BOTA','011-36045009');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RABASIAH BINTI ABDUL','570310-08-6386','LOT 5688','KG TELOK PERANG',NULL,32800,'PARIT','011-19402936');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RANIA BATRISYIA BINTI AHMAD AZAHAR','221119-08-0140','NO 38','TINGKAT PERPADUAN 14',NULL,31150,'ULU KINTA','012-5284900');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('SITI HAJAR BINTI ARIP','420210-08-5884','NO 32','PERSIARAN BINTANG TMN SUNRISE',NULL,31400,'IPOH','016-7513116');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NIHAYATUL NABILAH BINTI SABRI','000217-08-1906','NO. 91','JALAN TAMAN JATI 3,TAMAN MERU',NULL,30020,'IPOH','017-5924061');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NORHAYATI BINTI JAMALUDIN','771021-08-5126','NO. 69','HALA PENGKALAN BARAT 30',NULL,31650,'IPOH','018-2323484');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMAD IKHWAN BIN MOHAMAD ZABERI','981010-14-5301','NO 58','JLN MERU IMPIAN B2',NULL,31400,'IPOH','011-69387054');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NOR HASLINDA BINTI KASIM','780404-10-5766','NO. 25','LALUAN SERI KUANG 21',NULL,31200,'CHEMOR','011-11187201');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NOR SYIFA BATRISYIA BINTI NORHILME','080423-08-0544','NO 21','TINGKAT SERI RAPAT 2',NULL,31350,'IPOH','017-5605125');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RAHMAH BINTI HASAN','450525-08-5288',323,'JLN CEMPAKA 2, FELCRA CHANGKAT LADA',NULL,36800,'KG GAJAH','018-9078411');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MOHD ZAMZURI BIN ARIFIN','690310-08-6753',NULL,'KG SG RANGGAM,KOTA SETIA',NULL,36800,'KG GAJAH','019-4242961');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NASIAH BINTI HAWARI','450525-08-5288','NO. 27','JLN MALINJA, FELCRA SEBERANG PERAK',NULL,36800,'KG GAJAH','019-6910568');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MOHD MUSTAKIM BIN MOHD NADZRI','240123-08-0462','NO. 54','KG MASJID, PULAU TIGA KIRI',NULL,36800,'KG GAJAH','017-5177480');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMAD AMIER DANIEL BIN ABDULLAH','090917-08-0519','PT 254977','JALAN PENGKALAN PERTAMA 10',NULL,36800,'KG GAJAH','018-3216783');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('HAMIZAH BINTI DIN','770820-08-5814','NO. 32','PERSIARAN PERPADUAN  5',NULL,31150,'KG GAJAH','011-58553460');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ZAINAB BIN AHMAD','450608-08-5320','NO. 15','DATARAN PENGKALAN BARAT 6',NULL,36800,'KG GAJAH','011-70028050');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NUR RAISYA BINTI MOHD RIZAL','180150-08-0408','NO 38','PENGKALAN BANDARAYA 16',NULL,31500,'IPOH','019-60555719');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ZIYAD FAHIM BIN ZAINAL ASROL','160830-10-0937','NO 416','LORONG DELIMA 3/3',NULL,31400,'IPOH','019-6055519');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('UWAIS AMMAR UBAIDILLAH BIN ERMEY','111214-14-0431','LOT 4617','KG LEMPOR MANONG',NULL,33800,'MANONG','011-11183284');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMMAD AMIRUL AFWAN BIN ABDUL RAHIM','010307-08-0113','NO 27','TMN PONGSU MELATI',NULL,34300,'BAGAN SERAI','011-20704350');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RAMLEE BIN AHMAD ILIAS','6311170-08-5951','NO 10','PERSIARAN LADA 11',NULL,36800,'KG GAJAH',NULL);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('FATIMAH BINTI HUSSIN','540403-08-5940','NO. 8','KG BUKIT FOREST',NULL,NULL,'TAIPING','014-3533313');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RAMLI BIN MOHAMED','651023-08-5801','NO. 4,','JLN KAMUNTING LAMA',NULL,34000,'TAIPING','013-3640059');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('HALIMAH BINTI ABDULLAH','480811-08-5550','NO139','LORONG 9 TMN BERKAT',NULL,34700,'TAIPING','017-4578550');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MOHD AZUAN BIN ABD RAHIM','830312-08-6695','NO 11','RUMAH MURAH JLN KG DEW',NULL,34700,'TAIPING',1111489352);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('JAFNI BIN JAMIL','910514-08-5965','NO 146','KG BATU MATANG',NULL,34700,'TAIPING','017-4867075');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMAD NORHAKIM BIN AMRY','030511-08-0557','NO. 29','JLN KOTA WIRA TMN KOTA WITA',NULL,34010,'TAIPING','014-6307029');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ZAINAP BINTI AHMAD','410805-08-5518','NO 27','KG SG PETAI SEBERANG',NULL,34030,'TAIPING','017-5958516');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NORZALINA BINTI MAT YAMAN','640105-08-7188','KB32','KG BECAH',NULL,34010,'BATU KURAU','019-5276854');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ALEXANDER SELVARATNAM @SALIM BIN ABDULLAH','400522-06-5067','NO 28','LORONG PARI BARU 3',NULL,30010,'IPOH','014-3642240');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NURHAYATI BINTI JAMALUDIN','771021-10-5126','NO 69','HALAPENGKALAN BARAT 30',NULL,31650,'IPOH','018-2323484');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('SARIFAH BINTI OSMAN','790619-08-6338','NO 36','PERSIARAN PINJI SELATAN 24',NULL,31500,'IPOH','019-5767627');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MOHD FAIZUL BIN ABDULLAH TAJUDIN','821120-07-5559','B-7-15','PANGSAPURI SRI KEPAYANG',NULL,31400,'IPOH','011-12467471');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('IBRAHIM BIN KASSIM','000217-08-1906','NO 91','JLN TAMAN JATI 3',NULL,30020,'IPOH','011-62264870');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NUR ALEEYA ALISYA BINTI MOHD NAZRI','080923-08-0436','NO.16','LALUAN PRISMA 13,TMN PENGKALAN PRISMA',NULL,30450,'IPOH','013-4442414');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('NORLIAH BINTI LUKMAN','650424-08-5912','NO 84','PERSIARAN ISKANDAR PERDANA 59',NULL,32610,'SERI ISKANDAR','013-5274430');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('KELSOM BI BINTI ALI','470105-02-5578','NO 229','JLN BELANJA PARIT',NULL,32800,'PARIT','018-3694683');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ROKIYAH BINTI HARON','500125-08-6110','NO 32','JLN BANDAR UNIVERSITI 13',NULL,32610,'SERI ISKANDAR','018-3616754');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('RAZALI BIN YEOP MOHAIDIN','600611-08-6325','BATU 25','BOTA KANAN',NULL,32600,'BOTA','011-36959');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ROKIAH BINTI SHAFIE','581019-08-5442',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('CHE MEE BIN ARIFFIN','580319-02-5431','NO 14','PARIT MAT BET',NULL,36800,'KG GAJAH',NULL);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ERAH BINTI KULOP YUNUS','360406-08-5104',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMAD QURDUAN BIN MOHD RAMLAN','901005-08-5014','NO 34','KG CHANGKAT NING BATU 8 JLN TRONG',NULL,34850,'CHANGKAT JERING','017-5015721');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ZULKIFLI BIN MUSTAFA','570920-02-6073','NO 83','LORONG KAMUNTING MUTIARA 3 ',NULL,34600,'KAMUNTING','010-6697539');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('BABY RESUD A/P ABDUL HUSSAIN','601201-08-5060','NO 64','KG BATU EMPAT KAMUNTING',NULL,34600,'KAMUNTING','012-4252147');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('ABDUL MAJID BIN HARI','451022-08-5379','NO 46','LORONG SIREH 2',NULL,34000,'TAIPING','011-19705745');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('SALINA BINTI YAACOB','810608-08-5984','BB9A','JLN HUSIN SALLEH, KG BUKIT BERTAM',NULL,34500,'BATU KURAU','019-5691435');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('MUHAMAD DANIEL BIN ABDULLAH','780404-10-5766','NO 25','LALUAN SERI KUANG 21',NULL,31200,'KG GAJAH','018-3216783');
INSERT INTO customers(name,ic_number,address1,address2,address3,postcode,city,phone) VALUES ('JULIANA BINTI KAMARUDIN','830514-08-6490','NO 45','JLN 1, TMN GOPENG BARU',NULL,'31600','KG GAJAH','011-20613882');
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TENA VALUE SIZE M 10''S','PACK',14.453,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TENA VALUE PANTS SIZE XL 8''S','PACK',17.6831,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES DISPOSABLE SYRINGE 60ML 25''S','BOX',39,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','CONNECX BASIC DRESSING SET 1''S','UNIT',1.1,'ADVENTA HEALTHCARE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES CREPE BANDAGE 7.5CMx4.5M 1''S','UNIT',1.04166,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','NIXODERM INTENSIVE MOISTURIZING LOTION 200ML','UNIT',12.31,'SHOPEE',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PG LAVENDER MASSAGE OIL 410ML','UNIT',10.5,'SMY PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES INSULIN PEN NEEDLE 4MM 100''S','BOX',25,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','GLUCO NAVII NFC TEST STRIP 50''S','BOX',59.9,'SHOPEE',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','CAVIDAGEL AG+ 30G','UNIT',37.4,'ALPHA TECH BAY SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','NESTLE NUTREN GLUCOBALANCE 800G','UNIT',99,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','INFUSOL 1000ML','UNIT',2.75,'AIN MEDICARE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','RINSCAP SODIUM CHLORIDE 0.9% IRRIGATION SOLUTION 1000ML','UNIT',4.5,'AIN MEDICARE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HICARE ADULT PANTS SIZE XXL 10''S','PACK',23,'AUREUMAEX MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','ABBOT GLUCERNA VANILLA 800G','UNIT',84.97,'DKSH SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HICARE ADULT DIAPERS SIZE L 10''S','UNIT',17,'AUREUMAEX MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DR P VALUE PANTS SIZE L 9''S','PACK',17.6831,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DR P VALUE PANTS SIZE XL 8''S','PACK',17.6831,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DIAPEX ADULT WIPES 50''S','PACK',5,'NIBONG TEBAL ENTEPRISE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HERO PREMIUM SOFT WIPES 40''S','PACK',3.8,'ALPHA TECH BAY SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S','PACK',8.5,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DIAPEX ADULT BASIC SIZE L 8''S','PACK',12.5,'NIBONG TEBAL ENTEPRISE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DR P VALUE SIZE L 9''S','PACK',14.453,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HOSPITECH UNDERPAD 75CMx75CM 10''S','PACK',6.666666666666667,'AUREUMAEX MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','ABBOT ENSURE GOLD VANILLA 800G','UNIT',84.1,'DKSH SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DR P VALUE PANTS SIZE M 10''S','PACK',17.6831,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','VALENS MYOTEIN POWDER 300G','UNIT',68,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DR P VALUE SIZE M 10''S','PACK',14.453,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','AVANOS GASTROSTOMY FEEDING TUBE SIZE 24FR','UNIT',220,'HARMONI JAYA',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','ABBOT PEDIASURE PETIGRO VANILLA 800G','UNIT',70.29,'DKSH SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES NON WOVEN GAUZE 7.5CM X 7.5CM 100''S','UNIT',2.5,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES NITRILE POWDER FREE GLOVES SIZE S 100''S','UNIT',13,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES NON WOVEN DRESSING ROLL 10CM','UNIT',16,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES ALCOHOL SWAB 100''S','UNIT',1.9,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HOSPITECH SUCTION CATHERER SIZE 10FR 1''S','UNIT',0.7,'AUREUMAEX MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','HYDROCYN AQUA WOUND CARE 100ML','UNIT',6.9,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','CANDID DUSTING PWD 30G','UNIT',14.3,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','ONE TOUCH ULTRA SOFT LANCETS 100''S BOX','UNIT',29.9,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','METABOLIC + JUNIOR 700G ','UNIT',98.33,'ALPRO PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Nutritional Products','ABBOT ENSURE GOLD VANILLA 400G','UNIT',42.29,'DKSH SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DRYPERS DRYPANTS SIZE XXL 36''S','PACK',28.9836,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DRYPERS WEE DRY TAPE SIZE XXL 40''S','PACK',28.0233,'BIGEAST MARKETING SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES GAUZE ROLL  36" X 100 YARD','UNIT',45,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','3M MICROPORE SURGICAL TAPE 1"(2.5CM X 9.2CM)','UNIT',2.6666666666666665,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','DIAPEX  ADULT BASIC PANTS SIZE M 10''S','PACK',15.5,'NIBONG TEBAL ENTEPRISE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','ONE TOUCH ULTRA TEST STRIP 50''S','BOX',65.23,'SHOPEE',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','ONE TOUCH ULTRA SOFT LANCET 100''S','BOX',29.9,'SUNWAY MULTICARE PHARMACY',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Durable Medical Equipment (DME) / Medical Devices','COBLATOR FOR TONSIL AND ADENOID ELECTROLYTIC (PLASMA WAND)','UNIT',1200,'SYS HEALTHCARE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','3M CAVILON DURABLE BARRIER CREAM 92G','UNIT',52.9,'BIG PHARMACY SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','MEPITEL ONE 10CM X 18CM 10''S','UNIT',227,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','MEPITEL LITE 15CM X 15CM 5''S','UNIT',130,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TUBIFAST YELLOW','UNIT',90,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TUBIFAST BLUE','UNIT',63,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TUBIFAST GREEN','UNIT',60,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','TUBIFAST RED','UNIT',52.5,'FAIDZAM DINAMIK SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES GAMGEE ROLL 500G 20CMx5.7M','UNIT',23,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES GAUZE SWAB 7.5CM X 7.5CM 100''S','PACK',4.4,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES NON-WOVEN SURGICAL TAPE WITH DISPENSER 1"','UNIT',1.8333333333333333,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES ELASTIC CREPE BANDAGE 15CM','UNIT',1.8333333333333333,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Durable Medical Equipment (DME) / Medical Devices','MOBILIS LIGHTWEIGHT WHEELCHAIR (MO-Q05LAJE)','UNIT',369,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','PRIMES INSULIN PEN NEEDLE 5MM 100''S','BOX',25,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Durable Medical Equipment (DME) / Medical Devices','MOBILIS STANDARD WHEELCHAIR (WPL-809E)','UNIT',210,'PRO LIFE MEDICAL SUPPLIES SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO items(item_code,category,name,uom,cost,supplier_name,reorder_level,reorder_qty,controlled_item,remark) VALUES (NULL,'Medical Supplies & Consumables','RINSCAP SODIUM CHLORIDE 0.9% IRRIGATION SOLUTION 500ML','UNIT',3.2,'AIN MEDICARE SDN BHD',0,0,0,NULL);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/000423','2026-03-17','2026-03-17','2026-03-17',(SELECT id FROM branches WHERE name='CHEMOR' LIMIT 1),22000,NULL,'QT/ZM-2601/045','KHAIRUNIZAM BIN MOHAMED',(SELECT id FROM customers WHERE name='KHAIRUNIZAM BIN MOHAMED' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'BONE MANAGEMENT SYSTEM',1,0 FROM los WHERE lo_number='LO2026/000423';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/000957','2026-06-08','2026-06-08','2026-06-08',(SELECT id FROM branches WHERE name='MAIPK CAWANGAN' LIMIT 1),2070,NULL,'QT/ZM-2603/002','SITI AISYAH BINTI ABDUL GHANI',(SELECT id FROM customers WHERE name='SITI AISYAH BINTI ABDUL GHANI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'MENICON ROSE',1,0 FROM los WHERE lo_number='LO2026/000957';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/000980','2026-06-08','2026-06-08','2026-06-08',(SELECT id FROM branches WHERE name='MAIPK CAWANGAN' LIMIT 1),9292,NULL,'QT/ZM-2605/05','MOHAMAD NAZEREL BIN NAZARI',(SELECT id FROM customers WHERE name='MOHAMAD NAZEREL BIN NAZARI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PEEK CRANIAL IMPLANT',1,0 FROM los WHERE lo_number='LO2026/000980';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001305','2026-07-15','2026-07-15','2026-07-15',(SELECT id FROM branches WHERE name='MAIPK CAWANGAN' LIMIT 1),9431,NULL,'QT/ZM-2606/0109','NUR AFIQAH BINTI MUSTAFA KAMAL',(SELECT id FROM customers WHERE name='NUR AFIQAH BINTI MUSTAFA KAMAL' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ENDOGIA',1,0 FROM los WHERE lo_number='LO2026/001305';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'VERSAONE',1,0 FROM los WHERE lo_number='LO2026/001305';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'SIGPSHELL SIGNIA',1,0 FROM los WHERE lo_number='LO2026/001305';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001277','2026-07-17','2026-07-17','2026-07-17',(SELECT id FROM branches WHERE name='SEMANGGOL' LIMIT 1),6200,NULL,'QT/ZM-2607/035','AARISH NAJMI BIN MAT RODI',(SELECT id FROM customers WHERE name='AARISH NAJMI BIN MAT RODI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'KAKI PALSU',1,0 FROM los WHERE lo_number='LO2026/001277';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001434','2026-07-29','2026-07-29','2026-07-29',(SELECT id FROM branches WHERE name='TG TUALANG' LIMIT 1),30000,NULL,'QT/ZM-2607/0104','NUR DAHLIA ALYSSA BINTI MUHAMMAD ZAIM',(SELECT id FROM customers WHERE name='NUR DAHLIA ALYSSA BINTI MUHAMMAD ZAIM' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'INJECTION',1,0 FROM los WHERE lo_number='LO2026/001434';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001377','2026-07-31','2026-07-31','2026-07-31',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),3500,NULL,'QT/ZM-2606/038','NIK AHMAD ZUL HAKIM BIN AHMAD ZAIDI',(SELECT id FROM customers WHERE name='NIK AHMAD ZUL HAKIM BIN AHMAD ZAIDI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'TAPAK FISTULA',1,0 FROM los WHERE lo_number='LO2026/001377';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/000763','2026-07-31','2026-07-31','2026-07-31',(SELECT id FROM branches WHERE name='GOPENG' LIMIT 1),17710,NULL,'QT/ZM-2605/023','MUHAMMAD ZULHILMI BIN MOHAMAD GHAZALI',(SELECT id FROM customers WHERE name='MUHAMMAD ZULHILMI BIN MOHAMAD GHAZALI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'TRILOK DISTAL',1,0 FROM los WHERE lo_number='LO2026/000763';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/000766','2026-07-31','2026-07-31','2026-07-31',(SELECT id FROM branches WHERE name='KAMPAR' LIMIT 1),'3,300.00',NULL,NULL,'NOR AZLINDA BINTI AZIZAN',(SELECT id FROM customers WHERE name='NOR AZLINDA BINTI AZIZAN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/000766';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX',1,0 FROM los WHERE lo_number='LO2026/000766';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/000766';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'WHEELCHAIR',1,0 FROM los WHERE lo_number='LO2026/000766';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'GRACE CARE',1,0 FROM los WHERE lo_number='LO2026/000766';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001399','2026-08-03','2026-08-03','2026-08-03',(SELECT id FROM branches WHERE name='SUNGKAI' LIMIT 1),5874,NULL,'QT/ZM-2605/021','JATIAH BINTI KADIR',(SELECT id FROM customers WHERE name='JATIAH BINTI KADIR' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PAKEJ OF LUMBAR',1,0 FROM los WHERE lo_number='LO2026/001399';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001453','2026-08-04','2026-08-04','2026-08-04',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2620,NULL,'QT/ZM-2609/044','MAZLAN BIN YUSUF',(SELECT id FROM customers WHERE name='MAZLAN BIN YUSUF' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PROSTHETIC EQUIPMENT',1,0 FROM los WHERE lo_number='LO2026/001453';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001529','2026-08-12','2026-08-12','2026-08-12',(SELECT id FROM branches WHERE name='BOTA' LIMIT 1),3992,NULL,'QT/ZM-2607/093','MUHMAMAD ADIF AZHAR BIN MOHAMAD HANES',(SELECT id FROM customers WHERE name='MUHMAMAD ADIF AZHAR BIN MOHAMAD HANES' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/001529';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001524','2026-08-17','2026-08-17','2026-08-17',(SELECT id FROM branches WHERE name='PARIT' LIMIT 1),4520,NULL,'QT/ZM-2607/016','RABASIAH BINTI ABDUL',(SELECT id FROM customers WHERE name='RABASIAH BINTI ABDUL' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/001524';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001535','2026-08-18','2026-08-18','2026-08-18',(SELECT id FROM branches WHERE name='ULU KINTA' LIMIT 1),1725.6,NULL,'QT/ZM-2605/085','RANIA BATRISYIA BINTI AHMAD AZAHAR',(SELECT id FROM customers WHERE name='RANIA BATRISYIA BINTI AHMAD AZAHAR' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT PEDIASURE',1,0 FROM los WHERE lo_number='LO2026/001535';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001611','2026-08-24','2026-08-24','2026-08-24',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2244,NULL,'QT/ZM-2606/018','SITI HAJAR BINTI ARIP',(SELECT id FROM customers WHERE name='SITI HAJAR BINTI ARIP' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001609','2026-08-24','2026-08-24','2026-08-24',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2900,NULL,'QT/ZM-2607/084','NIHAYATUL NABILAH BINTI SABRI',(SELECT id FROM customers WHERE name='NIHAYATUL NABILAH BINTI SABRI' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001606','2026-08-24','2026-08-24','2026-08-24',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2597,NULL,'QT/ZM-2602/019','NORHAYATI BINTI JAMALUDIN',(SELECT id FROM customers WHERE name='NORHAYATI BINTI JAMALUDIN' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001545','2026-08-24','2026-08-24','2026-08-24',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),18600,NULL,'QT/ZM-2604/054','MUHAMAD IKHWAN BIN MOHAMAD ZABERI',(SELECT id FROM customers WHERE name='MUHAMAD IKHWAN BIN MOHAMAD ZABERI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'UPADACITINIB TABLET',1,0 FROM los WHERE lo_number='LO2026/001545';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001615','2026-08-25','2026-08-25','2026-08-25',(SELECT id FROM branches WHERE name='CHEMOR' LIMIT 1),8262.6,NULL,'QT/ZM-2606/020','NOR HASLINDA BINTI KASIM',(SELECT id FROM customers WHERE name='NOR HASLINDA BINTI KASIM' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001627','2026-08-26','2026-08-26','2026-08-26',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),4998.7,NULL,'QT/ZM-2607040',NULL,(SELECT id FROM customers WHERE name=NULL LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001645','2026-08-28','2026-08-28','2026-08-28',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),4250,NULL,'QT/ZM-2607/095','NOR SYIFA BATRISYIA BINTI NORHILME',(SELECT id FROM customers WHERE name='NOR SYIFA BATRISYIA BINTI NORHILME' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PAKEJ MEDTRONIC XOMED',1,0 FROM los WHERE lo_number='LO2026/001645';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001661','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),6166,NULL,'QT/ZM-2602/036','RAHMAH BINTI HASAN',(SELECT id FROM customers WHERE name='RAHMAH BINTI HASAN' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001662','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),5292,NULL,'QT/ZM-2608/069','MOHD ZAMZURI BIN ARIFIN',(SELECT id FROM customers WHERE name='MOHD ZAMZURI BIN ARIFIN' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001660','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2865,NULL,'QT/ZM-2608/086','NASIAH BINTI HAWARI',(SELECT id FROM customers WHERE name='NASIAH BINTI HAWARI' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001655','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),862.8,NULL,'QT/ZM-2608/099','MOHD MUSTAKIM BIN MOHD NADZRI',(SELECT id FROM customers WHERE name='MOHD MUSTAKIM BIN MOHD NADZRI' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001610','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),9292,NULL,'QT/ZM-2607/0109','MUHAMAD AMIER DANIEL BIN ABDULLAH',(SELECT id FROM customers WHERE name='MUHAMAD AMIER DANIEL BIN ABDULLAH' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001616','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2914.5,NULL,'QT/ZM-2605/083','HAMIZAH BINTI DIN',(SELECT id FROM customers WHERE name='HAMIZAH BINTI DIN' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001617','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),6857.3,NULL,'QT/ZM-2605/017','ZAINAB BIN AHMAD',(SELECT id FROM customers WHERE name='ZAINAB BIN AHMAD' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001612','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),6000,NULL,'QT/ZM-2604/044','NUR RAISYA BINTI MOHD RIZAL',(SELECT id FROM customers WHERE name='NUR RAISYA BINTI MOHD RIZAL' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001598','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),3480,NULL,'QT/ZM2606/007','ZIYAD FAHIM BIN ZAINAL ASROL',(SELECT id FROM customers WHERE name='ZIYAD FAHIM BIN ZAINAL ASROL' LIMIT 1),1);
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001611','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2244,NULL,'QT/ZM-2606/018','SITI HAJAR BINTI ARIP',(SELECT id FROM customers WHERE name='SITI HAJAR BINTI ARIP' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001611';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'TRUELIFE WELLCARE',1,0 FROM los WHERE lo_number='LO2026/001611';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'LIFEWELL',1,0 FROM los WHERE lo_number='LO2026/001611';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001598','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),3480,NULL,'QT/ZM-2606/007','ZIYAD FAHIM BIN ZAINAL ASROL',(SELECT id FROM customers WHERE name='ZIYAD FAHIM BIN ZAINAL ASROL' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT PEDIASURE',1,0 FROM los WHERE lo_number='LO2026/001598';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001612','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),6000,NULL,'QT/ZM-2604/044','NUR RAISYA BINTI MOHD RIZAL',(SELECT id FROM customers WHERE name='NUR RAISYA BINTI MOHD RIZAL' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ALAT BANTUAN PENDENGARAN',1,0 FROM los WHERE lo_number='LO2026/001612';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001469','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='KUALA KANGSAR' LIMIT 1),'11,556.00',NULL,'QT/ZM-2609/011','UWAIS AMMAR UBAIDILLAH BIN ERMEY',(SELECT id FROM customers WHERE name='UWAIS AMMAR UBAIDILLAH BIN ERMEY' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'GAS OKSIGEN',1,0 FROM los WHERE lo_number='LO2026/001469';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001664','2026-09-02','2026-09-02','2026-09-02',(SELECT id FROM branches WHERE name='BAGAN SERAI' LIMIT 1),'9,794.00',NULL,'QT/ZM-2609/021','MUHAMMAD AMIRUL AFWAN BIN ABDUL RAHIM',(SELECT id FROM customers WHERE name='MUHAMMAD AMIRUL AFWAN BIN ABDUL RAHIM' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/001664';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001454','2026-09-04','2026-09-04','2026-09-04',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2224,NULL,'QT/ZM-2606/010','RAMLEE BIN AHMAD ILIAS',(SELECT id FROM customers WHERE name='RAMLEE BIN AHMAD ILIAS' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'WATER STANDOOF',1,0 FROM los WHERE lo_number='LO2026/001454';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001711','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2543.2,NULL,'QT/ZM-2607/034','FATIMAH BINTI HUSSIN',(SELECT id FROM customers WHERE name='FATIMAH BINTI HUSSIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001711';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'WHEELCHAIR',1,0 FROM los WHERE lo_number='LO2026/001711';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001706','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),12392.8,NULL,'QT/ZM-2607/087','RAMLI BIN MOHAMED',(SELECT id FROM customers WHERE name='RAMLI BIN MOHAMED' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001706';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX',1,0 FROM los WHERE lo_number='LO2026/001706';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PRIMES NITRILE',1,0 FROM los WHERE lo_number='LO2026/001706';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT GLUCERNA',1,0 FROM los WHERE lo_number='LO2026/001706';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001702','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),3104,NULL,'QT/ZM-2607/065','HALIMAH BINTI ABDULLAH',(SELECT id FROM customers WHERE name='HALIMAH BINTI ABDULLAH' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'COLOPLAST ALTERNA',1,0 FROM los WHERE lo_number='LO2026/001702';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001255','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),9250,NULL,'QT/ZM-2607/006','MOHD AZUAN BIN ABD RAHIM',(SELECT id FROM customers WHERE name='MOHD AZUAN BIN ABD RAHIM' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PEEK IMPLANT',1,0 FROM los WHERE lo_number='LO2026/001255';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/00104','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),5280,NULL,'QT/ZM-2606/011','JAFNI BIN JAMIL',(SELECT id FROM customers WHERE name='JAFNI BIN JAMIL' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'BONE GRAFT',1,0 FROM los WHERE lo_number='LO2026/00104';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'BLADE PLATES',1,0 FROM los WHERE lo_number='LO2026/00104';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001712','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),14431.4,NULL,'QT/ZM-2608/030','MUHAMAD NORHAKIM BIN AMRY',(SELECT id FROM customers WHERE name='MUHAMAD NORHAKIM BIN AMRY' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001712';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX',1,0 FROM los WHERE lo_number='LO2026/001712';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/001712';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'WHEELCHAIR',1,0 FROM los WHERE lo_number='LO2026/001712';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'GRACE CARE',1,0 FROM los WHERE lo_number='LO2026/001712';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001705','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),2106,NULL,'QT/ZM-2608/028','ZAINAP BINTI AHMAD',(SELECT id FROM customers WHERE name='ZAINAP BINTI AHMAD' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'HICARE PANTS',1,0 FROM los WHERE lo_number='LO2026/001705';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001703','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='TAIPING' LIMIT 1),2353.5,NULL,'QT/ZM-2607/066','NORZALINA BINTI MAT YAMAN',(SELECT id FROM customers WHERE name='NORZALINA BINTI MAT YAMAN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001703';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'WHEELCHAIR',1,0 FROM los WHERE lo_number='LO2026/001703';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001676','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),3000,NULL,'QT/ZM-2607/038','ALEXANDER SELVARATNAM @SALIM BIN ABDULLAH',(SELECT id FROM customers WHERE name='ALEXANDER SELVARATNAM @SALIM BIN ABDULLAH' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'HEARING AID',1,0 FROM los WHERE lo_number='LO2026/001676';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001606','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2597,NULL,'QT/ZM-2602/019','NURHAYATI BINTI JAMALUDIN',(SELECT id FROM customers WHERE name='NURHAYATI BINTI JAMALUDIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'FLANIL',1,0 FROM los WHERE lo_number='LO2026/001606';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DERMALCREAM',1,0 FROM los WHERE lo_number='LO2026/001606';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'MOBITHRON',1,0 FROM los WHERE lo_number='LO2026/001606';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001675','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),10200,NULL,'QT/ZM-2608/009','SARIFAH BINTI OSMAN',(SELECT id FROM customers WHERE name='SARIFAH BINTI OSMAN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'PAKEJ OF LUMBAR',1,0 FROM los WHERE lo_number='LO2026/001675';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001674','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),14280,NULL,'QT/ZM-2606/0111','MOHD FAIZUL BIN ABDULLAH TAJUDIN',(SELECT id FROM customers WHERE name='MOHD FAIZUL BIN ABDULLAH TAJUDIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'INJECTION',1,0 FROM los WHERE lo_number='LO2026/001674';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001677','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),2364.2,NULL,'QT/ZM-2607/063','IBRAHIM BIN KASSIM',(SELECT id FROM customers WHERE name='IBRAHIM BIN KASSIM' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'CONVATEC',1,0 FROM los WHERE lo_number='LO2026/001677';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'OSTOMY',1,0 FROM los WHERE lo_number='LO2026/001677';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ESTEEM',1,0 FROM los WHERE lo_number='LO2026/001677';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001058','2026-09-09','2026-09-09','2026-09-09',(SELECT id FROM branches WHERE name='BATU GAJAH' LIMIT 1),10210,NULL,'QT/ZM-2602/031','NUR ALEEYA ALISYA BINTI MOHD NAZRI',(SELECT id FROM customers WHERE name='NUR ALEEYA ALISYA BINTI MOHD NAZRI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'RIGHT TRANSHUMERAL',1,0 FROM los WHERE lo_number='LO2026/001058';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001752','2026-09-10','2026-09-10','2026-09-10',(SELECT id FROM branches WHERE name='SERI ISKANDAR' LIMIT 1),'6,554.4',NULL,'QT/ZM-2609/042','NORLIAH BINTI LUKMAN',(SELECT id FROM customers WHERE name='NORLIAH BINTI LUKMAN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT',1,0 FROM los WHERE lo_number='LO2026/001752';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001751','2026-09-10','2026-09-10','2026-09-10',(SELECT id FROM branches WHERE name='PARIT' LIMIT 1),2100,NULL,'QT/ZM-2606/069','KELSOM BI BINTI ALI',(SELECT id FROM customers WHERE name='KELSOM BI BINTI ALI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'KATIL',1,0 FROM los WHERE lo_number='LO2026/001751';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001753','2026-09-10','2026-09-10','2026-09-10',(SELECT id FROM branches WHERE name='SERI ISKANDAR' LIMIT 1),6743.2,NULL,'QT/ZM-2607/004','ROKIYAH BINTI HARON',(SELECT id FROM customers WHERE name='ROKIYAH BINTI HARON' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001753';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT ENSURE',1,0 FROM los WHERE lo_number='LO2026/001753';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001680','2026-09-10','2026-09-10','2026-09-10',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),7770,NULL,'QT/ZM-2608/0101','RAZALI BIN YEOP MOHAIDIN',(SELECT id FROM customers WHERE name='RAZALI BIN YEOP MOHAIDIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'BONE CRAFT',1,0 FROM los WHERE lo_number='LO2026/001680';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001743','2026-09-15','2026-09-15','2026-09-15',(SELECT id FROM branches WHERE name=NULL LIMIT 1),'2,360.00',NULL,'QT/ZM-2603/072','ROKIAH BINTI SHAFIE',(SELECT id FROM customers WHERE name='ROKIAH BINTI SHAFIE' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'CONVATEC',1,0 FROM los WHERE lo_number='LO2026/001743';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'OSTOMY',1,0 FROM los WHERE lo_number='LO2026/001743';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ESTEEM',1,0 FROM los WHERE lo_number='LO2026/001743';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001744','2026-09-15','2026-09-15','2026-09-15',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2982,NULL,'QT/ZM-2609/004','CHE MEE BIN ARIFFIN',(SELECT id FROM customers WHERE name='CHE MEE BIN ARIFFIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX',1,0 FROM los WHERE lo_number='LO2026/001744';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001773','2026-09-15','2026-09-15','2026-09-15',(SELECT id FROM branches WHERE name='KG GAJAH' LIMIT 1),2910.5,NULL,'QT/ZM-2607/0100','ERAH BINTI KULOP YUNUS',(SELECT id FROM customers WHERE name='ERAH BINTI KULOP YUNUS' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX',1,0 FROM los WHERE lo_number='LO2026/001773';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001793','2026-09-21','2026-09-21','2026-09-21',(SELECT id FROM branches WHERE name='ULU SEPETANG' LIMIT 1),'4,237.80',NULL,'QT/ZM-2608/0113','MUHAMAD QURDUAN BIN MOHD RAMLAN',(SELECT id FROM customers WHERE name='MUHAMAD QURDUAN BIN MOHD RAMLAN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT ENSURE',1,0 FROM los WHERE lo_number='LO2026/001793';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001793';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001790','2026-09-21','2026-09-21','2026-09-21',(SELECT id FROM branches WHERE name='KAMUNTING' LIMIT 1),'6,795.00',NULL,'QT/ZM-2608/015','ZULKIFLI BIN MUSTAFA',(SELECT id FROM customers WHERE name='ZULKIFLI BIN MUSTAFA' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001790';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ABBOT ENSURE',1,0 FROM los WHERE lo_number='LO2026/001790';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001795','2026-09-21','2026-09-21','2026-09-21',(SELECT id FROM branches WHERE name='KAMUNTING' LIMIT 1),'2,013.90',NULL,'QT/ZM-2606/080','BABY RESUD A/P ABDUL HUSSAIN',(SELECT id FROM customers WHERE name='BABY RESUD A/P ABDUL HUSSAIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001795';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DIAPEX BASIC',1,0 FROM los WHERE lo_number='LO2026/001795';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001792','2026-09-21','2026-09-21','2026-09-21',(SELECT id FROM branches WHERE name='POKOK ASSAM' LIMIT 1),'9,975.00',NULL,'QT/ZM-2609/019','ABDUL MAJID BIN HARI',(SELECT id FROM customers WHERE name='ABDUL MAJID BIN HARI' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'CONVATEC ESENTA',1,0 FROM los WHERE lo_number='LO2026/001792';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'FLAT DRAINABLE',1,0 FROM los WHERE lo_number='LO2026/001792';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001791','2026-09-21','2026-09-21','2026-09-21',(SELECT id FROM branches WHERE name='BATU KURAU' LIMIT 1),'4,511.00',NULL,'QT/ZM-2609/017','SALINA BINTI YAACOB',(SELECT id FROM customers WHERE name='SALINA BINTI YAACOB' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'DR P',1,0 FROM los WHERE lo_number='LO2026/001791';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'NOVA ACTIVMAX',1,0 FROM los WHERE lo_number='LO2026/001791';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES ('LO2026/001615','2026-09-01','2026-09-01','2026-09-01',(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),10210,NULL,'QT/ZM-2607/0109','MUHAMAD DANIEL BIN ABDULLAH',(SELECT id FROM customers WHERE name='MUHAMAD DANIEL BIN ABDULLAH' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'RIGHT TRANSHUMERAL',1,0 FROM los WHERE lo_number='LO2026/001615';
INSERT IGNORE INTO los(lo_number,lo_date,date_received,submitted_date,branch_id,amount,cost_amount,quotation_number,beneficiary_name,customer_id,created_by) VALUES (' LO2026/000761 ','2026-09-01','2026-09-01',NULL,(SELECT id FROM branches WHERE name='IPOH' LIMIT 1),' 10,010.00 ',NULL,NULL,'JULIANA BINTI KAMARUDIN',(SELECT id FROM customers WHERE name='JULIANA BINTI KAMARUDIN' LIMIT 1),1);
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'CONVATEC',1,0 FROM los WHERE lo_number=' LO2026/000761 ';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'OSTOMY',1,0 FROM los WHERE lo_number=' LO2026/000761 ';
INSERT INTO lo_items(lo_id,item_description,qty,estimated_unit_cost) SELECT id,'ESTEEM',1,0 FROM los WHERE lo_number=' LO2026/000761 ';
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',10,'2026-01-01','LEGACY',NULL,14.453,1 FROM items WHERE name='TENA VALUE SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',45,'2026-01-01','LEGACY',NULL,17.6831,1 FROM items WHERE name='TENA VALUE PANTS SIZE XL 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',15,'2026-01-01','LEGACY',NULL,39,1 FROM items WHERE name='PRIMES DISPOSABLE SYRINGE 60ML 25''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',5,'2026-01-01','LEGACY',NULL,1.1,1 FROM items WHERE name='CONNECX BASIC DRESSING SET 1''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-01-01','LEGACY',NULL,1.04166,1 FROM items WHERE name='PRIMES CREPE BANDAGE 7.5CMx4.5M 1''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-01-01','LEGACY',NULL,12.31,1 FROM items WHERE name='NIXODERM INTENSIVE MOISTURIZING LOTION 200ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-01-01','LEGACY',NULL,10.5,1 FROM items WHERE name='PG LAVENDER MASSAGE OIL 410ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',3,'2026-01-01','LEGACY',NULL,25,1 FROM items WHERE name='PRIMES INSULIN PEN NEEDLE 4MM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',3,'2026-01-01','LEGACY',NULL,59.9,1 FROM items WHERE name='GLUCO NAVII NFC TEST STRIP 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',15,'2026-01-01','LEGACY',NULL,37.4,1 FROM items WHERE name='CAVIDAGEL AG+ 30G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',33,'2026-01-01','LEGACY',NULL,99,1 FROM items WHERE name='NESTLE NUTREN GLUCOBALANCE 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',8,'2026-01-01','LEGACY',NULL,2.75,1 FROM items WHERE name='INFUSOL 1000ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-01-01','LEGACY',NULL,4.5,1 FROM items WHERE name='RINSCAP SODIUM CHLORIDE 0.9% IRRIGATION SOLUTION 1000ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',29,'2026-01-01','LEGACY',NULL,23,1 FROM items WHERE name='HICARE ADULT PANTS SIZE XXL 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',42,'2026-01-01','LEGACY',NULL,84.97,1 FROM items WHERE name='ABBOT GLUCERNA VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',4,'2026-01-01','LEGACY',NULL,3.8,1 FROM items WHERE name='HERO PREMIUM SOFT WIPES 40''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',56,'2026-01-29','LEGACY','ZM-2601/035',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',51,'2026-01-29','LEGACY','ZM-2602/033',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE XL 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',68,'2026-02-03','LEGACY','ZM-2601/034',17,1 FROM items WHERE name='HICARE ADULT DIAPERS SIZE L 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',48,'2026-02-04','LEGACY','ZM-2601/039',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',90,'2026-02-05','LEGACY','ZM-2602/004',8.5,1 FROM items WHERE name='PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',44,'2026-06-02','LEGACY','ZM-2602/002',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE XL 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',114,'2026-06-02','LEGACY','ZM-2602/001',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE L 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',30,'2026-06-02','LEGACY','ZM-2602/005',8.5,1 FROM items WHERE name='PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',60,'2026-07-02','LEGACY','ZM-2602/008',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',15,'2026-09-02','LEGACY','ZM-2601/024',6.666666666666667,1 FROM items WHERE name='HOSPITECH UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-09','LEGACY','ZM-2602/003',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',126,'2026-02-09','LEGACY','ZM-2602/019',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',45,'2026-02-09','LEGACY','ZM-2602/032',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',30,'2026-02-03','LEGACY','ZM-2602/032',6.666666666666667,1 FROM items WHERE name='HOSPITECH UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',45,'2026-02-03','LEGACY','ZM-2602/024',6.666666666666667,1 FROM items WHERE name='HOSPITECH UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',18,'2026-02-06','LEGACY','ZM-2602/00',84.97,1 FROM items WHERE name='ABBOT GLUCERNA VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-09','LEGACY','ZM-2601/036',68,1 FROM items WHERE name='VALENS MYOTEIN POWDER 300G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',180,'2026-02-10','LEGACY','ZM-2602/011',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',107,'2026-02-13','LEGACY','ZM-2602/010',14.453,1 FROM items WHERE name='DR P VALUE SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',107,'2026-02-13','LEGACY','ZM-2602/009',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',2,'2026-02-16','LEGACY','ZM-2602/021',220,1 FROM items WHERE name='AVANOS GASTROSTOMY FEEDING TUBE SIZE 24FR' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',42,'2026-02-20','LEGACY','ZM-2601/021',70.29,1 FROM items WHERE name='ABBOT PEDIASURE PETIGRO VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-02-20','LEGACY','ZM-2602/022',2.5,1 FROM items WHERE name='PRIMES NON WOVEN GAUZE 7.5CM X 7.5CM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-02-20','LEGACY','ZM-2602/022',0,1 FROM items WHERE name='PRIMES NITRILE POWDER FRE GLOVES SIZE S 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',3,'2026-02-20','LEGACY','ZM-2602/022',16,1 FROM items WHERE name='PRIMES NON WOVEN DRESSING ROLL 10CM' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',7,'2026-02-20','LEGACY','ZM-2602/022',25,1 FROM items WHERE name='PRIMES INSULIN PEN NEEDLE 4MM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-20','LEGACY','ZM-2602/022',1.9,1 FROM items WHERE name='PRIMES ALCOHOL SWAB 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',114,'2026-02-20','LEGACY','ZM-2602/017',42.29,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 400G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',45,'2026-02-24','LEGACY','ZM-2602/019',6.666666666666667,1 FROM items WHERE name='HOSPITECH UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',180,'2026-02-24','LEGACY','ZM-2602/019',0.7,1 FROM items WHERE name='HOSPITECH SUCTION CATHERER SIZE 10FR 1''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-25','LEGACY','ZM-2602/032',6.9,1 FROM items WHERE name='HYDROCYN AQUA WOUND CARE 100ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-02-25','LEGACY','ZM-2602/032',14.3,1 FROM items WHERE name='CANDID DUSTING PWD 30G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',10,'2026-02-25','LEGACY','ZM-2602/032',29.9,1 FROM items WHERE name='ONE TOUCH ULTRA SOFT LANCET 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',24,'2026-02-24','LEGACY','ZM-2602/018',98.33,1 FROM items WHERE name='METABOLIC + JUNIOR 700G ' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',72,'2026-02-26','LEGACY','ZM-2602/013',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',80,'2026-02-26','LEGACY','ZM-2602/015',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',72,'2026-02-26','LEGACY','ZM-2602/016',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',62,'2026-02-26','LEGACY','ZM-2602/030',28.9836,1 FROM items WHERE name='DRYPERS DRYPANTS SIZE XXL 36''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-26','LEGACY','ZM-2602/029',28.0233,1 FROM items WHERE name='DRYPERS WEE DRY TAPE SIZE XXL 40''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',95,'2026-02-26','LEGACY','ZM-2602/026',15.5,1 FROM items WHERE name='DIAPEX  ADULT BASIC PANTS SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',104,'2026-02-26','LEGACY','ZM-2602/025',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE L 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',24,'2026-02-26','LEGACY','ZM-2602/025',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-02-25','LEGACY','ZM-2602/014',1200,1 FROM items WHERE name='COBLATOR FOR TONSIL AND ADENOID ELECTROLYTIC (PLASMA WAND)' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-02-25','LEGACY',NULL,65.23,1 FROM items WHERE name='ONE TOUCH ULTRA TEST STRIP 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-02-27','LEGACY','ZM-2602/031',52.9,1 FROM items WHERE name='3M CAVILON DURABLE BARRIER CREAM 92G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',180,'2026-03-02','LEGACY','ZM-2602/035',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',4,'2026-03-02','LEGACY','ZM-2602/024',227,1 FROM items WHERE name='MEPITEL ONE 10CM X 18CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',25,'2026-03-02','LEGACY','ZM-2602/024',130,1 FROM items WHERE name='MEPITEL LITE 15CM X 15CM 5''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-03-02','LEGACY','ZM-2602/024',90,1 FROM items WHERE name='TUBIFAST YELLOW' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-03-02','LEGACY','ZM-2602/024',63,1 FROM items WHERE name='TUBIFAST BLUE' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-03-02','LEGACY','ZM-2602/024',60,1 FROM items WHERE name='TUBIFAST GREEN' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',12,'2026-03-02','LEGACY','ZM-2602/024',52.5,1 FROM items WHERE name='TUBIFAST RED' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',5,'2026-03-02','LEGACY','ZM-2602/041',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',5,'2026-03-02','LEGACY','ZM-2602/047',25,1 FROM items WHERE name='PRIMES INSULIN PEN NEEDLE 4MM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-03-02','LEGACY','ZM-2602/047',13,1 FROM items WHERE name='PRIMES NITRILE POWDER FREE GLOVES SIZE S 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',15,'2026-03-02','LEGACY','ZM-2602/047',23,1 FROM items WHERE name='PRIMES GAMGEE ROLL 500G 20CMx5.7M' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',24,'2026-03-02','LEGACY','ZM-2602/047',4.4,1 FROM items WHERE name='PRIMES GAUZE SWAB 7.5CM X 7.5CM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',2,'2026-03-02','LEGACY','ZM-2602/047',1.8333333333333333,1 FROM items WHERE name='PRIMES NON-WOVEN SURGICAL TAPE WITH DISPENSER 1"' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',13,'2026-03-02','LEGACY','ZM-2602/047',1.8333333333333333,1 FROM items WHERE name='PRIMES ELASTIC CREPE BANDAGE 15CM' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',3,'2026-03-02','LEGACY','ZM-2602/047',16,1 FROM items WHERE name='PRIMES NON WOVEN DRESSING ROLL 10CM' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-03-06','LEGACY','ZM-2603/012',369,1 FROM items WHERE name='MOBILIS LIGHTWEIGHT WHEELCHAIR (MO-Q05LAJE)' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-03-06','LEGACY','ZM-2603/012',25,1 FROM items WHERE name='PRIMES INSULIN PEN NEEDLE 5MM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',2,'2026-03-06','LEGACY','ZM-2603/012',210,1 FROM items WHERE name='MOBILIS STANDARD WHEELCHAIR (WPL-809E)' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-03-06','LEGACY','ZM-2603/012',13,1 FROM items WHERE name='PRIMES NITRILE POWDER FREE GLOVES SIZE S 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',20,'2026-03-03','LEGACY','ZM-2602/043',3.2,1 FROM items WHERE name='RINSCAP SODIUM CHLORIDE 0.9% IRRIGATION SOLUTION 500ML' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',54,'2026-03-10','LEGACY','ZM-2603/029',54,1 FROM items WHERE name='HICARE ADULT DIAPERS PREMIUM XXL' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',51,'2026-03-10','LEGACY','ZM-2603/040',21,1 FROM items WHERE name='HICARE ADULT DIAPERS PREMIUM XXL' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',168,'2026-03-12','LEGACY','ZM-2603/010',9,1 FROM items WHERE name='DIAPEX BASIC DISPOSABLE UNDERPAD SIZE L 60CM X 90CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',72,'2026-03-12','LEGACY','ZM-2603/010',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',132,'2026-03-12','LEGACY','ZM-2603/022',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',60,'2026-03-12','LEGACY','ZM-2603/022',9,1 FROM items WHERE name='DIAPEX BASIC DISPOSABLE UNDERPAD SIZE L 60CM X 90CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',48,'2026-03-12','LEGACY','ZM-2603/022',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE XL 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',24,'2026-03-12','LEGACY','ZM-2603/035',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',60,'2026-03-12','LEGACY','ZM-2603/035',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE L 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',31,'2026-03-12','LEGACY','ZM-2603/020',12,1 FROM items WHERE name='PRIMES ELASTIC CREPE BANDAGE 15CM' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',20,'2026-03-12','LEGACY','ZM-2603/020',5.8,1 FROM items WHERE name='PRIMES GAUZE SWAB 10CM X 710CM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',20,'2026-03-12','LEGACY','ZM-2603/020',24,1 FROM items WHERE name='PRIMES PARRAFIN GAUZE DRESSING WITH CHLORHEXIDINE' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',20,'2026-03-12','LEGACY','ZM-2603/020',2,1 FROM items WHERE name='COTTON BALL' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',7,'2026-03-12','LEGACY','ZM-2603/020',13,1 FROM items WHERE name='PRIMES NITRILE POWDER FREE GLOVES SIZE S 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',1,'2026-03-12','LEGACY','ZM-2603/020',65,1 FROM items WHERE name='MOBILIS ALUM ELBOW CRUTCHES ADULT' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'IN',6,'2026-03-12','LEGACY','ZM-2603/020',13,1 FROM items WHERE name='PRIMES NITRILE POWDER FREE GLOVES SIZE S 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',56,'2026-02-05','LEGACY',NULL,0,1 FROM items WHERE name='DR P VALUE PANTS SIZE L 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',10,'2026-02-05','LEGACY',NULL,99,1 FROM items WHERE name='NESTLE NUTREN GLUCOBALANCE 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',34,'2026-02-05','LEGACY',NULL,8.5,1 FROM items WHERE name='PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',68,'2026-02-05','LEGACY',NULL,17,1 FROM items WHERE name='HICARE ADULT DIAPERS SIZE L 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',34,'2026-02-05','LEGACY',NULL,8.5,1 FROM items WHERE name='PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-02-06','LEGACY',NULL,8.5,1 FROM items WHERE name='PRIMES HOSPITAL UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',40,'2026-02-09','LEGACY','ZM-2602/005',84.97,1 FROM items WHERE name='ABBOT GLUCERNA VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',60,'2026-02-09','LEGACY','ZM-2602/005',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-02-09','LEGACY','ZM-2602/005',6.666666666666667,1 FROM items WHERE name='HOSPITECH UNDERPAD 75CMx75CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',44,'2026-02-09','LEGACY','ZM-2602/006',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE XL 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',8,'2026-02-09','LEGACY','ZM-2602/006',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',114,'2026-02-09','LEGACY','ZM-2602/007',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE L 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',45,'2026-02-09','LEGACY','ZM-2602/008',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',75,'2026-02-09','LEGACY','ZM-2602/009',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',45,'2026-02-09','LEGACY','ZM-2602/010',84.1,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',180,'2026-02-09','LEGACY','ZM-2602/011',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',6,'2026-02-09','LEGACY','ZM-2602/011',84.97,1 FROM items WHERE name='ABBOT GLUCERNA VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-02-09','LEGACY','ZM-2602/011',68,1 FROM items WHERE name='VALENS MYOTEIN POWDER 300G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',24,'2026-02-09','LEGACY','ZM-2602/011',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',107,'2026-02-13','LEGACY','ZM-2602/012',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',42,'2026-02-20','LEGACY','ZM-2602/014',70.29,1 FROM items WHERE name='ABBOT PEDIASURE PETIGRO VANILLA 800G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',24,'2026-02-24','LEGACY','ZM-2602/015',98.33,1 FROM items WHERE name='METABOLIC + JUNIOR 700G ' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',80,'2026-02-27','LEGACY','ZM-2602/017',17.6831,1 FROM items WHERE name='DR P VALUE PANTS SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',72,'2026-02-26','LEGACY','ZM-2602/018',14.453,1 FROM items WHERE name='DR P VALUE SIZE L 9''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',104,'2026-02-27','LEGACY','ZM-2602/020',12.5,1 FROM items WHERE name='DIAPEX ADULT BASIC SIZE L 8''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',20,'2026-02-27','LEGACY','ZM-2602/020',5,1 FROM items WHERE name='DIAPEX ADULT WIPES 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',95,'2026-02-27','LEGACY','ZM-2602/021',15.5,1 FROM items WHERE name='DIAPEX  ADULT BASIC PANTS SIZE M 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-02-27','LEGACY','ZM-2602/022',65.23,1 FROM items WHERE name='ONE TOUCH ULTRA TEST STRIP 50''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',10,'2026-02-27','LEGACY','ZM-2602/022',29.9,1 FROM items WHERE name='ONE TOUCH ULTRA SOFT LANCET 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-02-27','LEGACY','ZM-2602/022',1.9,1 FROM items WHERE name='PRIMES ALCOHOL SWAB 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',10,'2026-02-27','LEGACY','ZM-2602/022',25,1 FROM items WHERE name='PRIMES INSULIN PEN NEEDLE 4MM 100''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',1,'2026-02-27','LEGACY','ZM-2602/023',1200,1 FROM items WHERE name='COBLATOR FOR TONSIL AND ADENOID ELECTROLYTIC (PLASMA WAND)' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',114,'2026-02-27','LEGACY','ZM-2602/018',42.29,1 FROM items WHERE name='ABBOT ENSURE GOLD VANILLA 400G' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',4,'2026-03-02','LEGACY','ZM-2603/001',227,1 FROM items WHERE name='MEPITEL ONE 10CM X 18CM 10''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',25,'2026-03-02','LEGACY','ZM-2603/001',130,1 FROM items WHERE name='MEPITEL LITE 15CM X 15CM 5''S' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-03-02','LEGACY','ZM-2603/001',90,1 FROM items WHERE name='TUBIFAST YELLOW' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-03-02','LEGACY','ZM-2603/001',63,1 FROM items WHERE name='TUBIFAST BLUE' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-03-02','LEGACY','ZM-2603/001',60,1 FROM items WHERE name='TUBIFAST GREEN' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-03-02','LEGACY','ZM-2603/001',52.5,1 FROM items WHERE name='TUBIFAST RED' LIMIT 1;
INSERT INTO stock_movements(item_id,movement_type,quantity,movement_date,reference_type,reference_no,unit_cost,created_by) SELECT id,'OUT',12,'2026-03-02','LEGACY','ZM-2603/003',84.97,1 FROM items WHERE name='ABBOT GLUCERNA VANILLA 800G' LIMIT 1;