API tools faq
paste
Guest User

Untitled

a guest
May 15th, 2017
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 161.30 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.13  Distrib 5.7.18, for Linux (x86_64)
  2. --
  3. -- Host: localhost    Database: orcanew
  4. -- ------------------------------------------------------
  5. -- Server version   5.7.18-0ubuntu0.17.04.1
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `tbl_acc_groups`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `tbl_acc_groups`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `tbl_acc_groups` (
  26.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  27.   `G_H_NAME` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  28.   `TYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  29.   `CHILD_OF` int(11) DEFAULT NULL,
  30.   `REF_ACC_ID` int(11) DEFAULT '0',
  31.   PRIMARY KEY (`ID`),
  32.   UNIQUE KEY `ID` (`ID`)
  33. ) ENGINE=InnoDB AUTO_INCREMENT=333 DEFAULT CHARSET=latin1;
  34. /*!40101 SET character_set_client = @saved_cs_client */;
  35.  
  36. --
  37. -- Dumping data for table `tbl_acc_groups`
  38. --
  39.  
  40. LOCK TABLES `tbl_acc_groups` WRITE;
  41. /*!40000 ALTER TABLE `tbl_acc_groups` DISABLE KEYS */;
  42. INSERT INTO `tbl_acc_groups` VALUES (1,'CASH ACCOUNT','G',1,0),(2,'BANK ACCOUNT','G',1,0),(3,'PURCHASE ACCOUNT','G',1,0),(4,'SALES ACCOUNT','G',3,0),(5,'SUPPLIERS ACCOUNT','G',2,0),(6,'CUSTOMERS ACCOUNT','G',1,0),(91,'Cash In Hand','H',1,0),(92,'NBD','H',2,0),(93,'ROW MATERIAL PURCHASE A/C','H',3,0),(96,'PRODUCT SALES','H',4,0),(97,'K M T','H',6,1),(100,'CAPITAL ACCOUNT','G',2,0),(101,'ABC CAPITAL','H',100,0),(102,'Rice items purchase','H',3,0),(103,'ADMIN EXP','G',4,0),(104,'SALARY EXP','H',103,0),(118,'lulu hyper mkt nahda shj','H',6,4),(119,'bin zaid flour mills','H',5,1),(120,'al bayader international ','H',5,2),(121,'Noor Al Qusais Super Market - Dubai','H',6,5),(122,'PASONS AL MADINAH SUPER MARKET - KARAMA DUBAI','H',6,6),(123,' PASONS AL MADINAH SUPER MARKET - AL NAHDAH','H',6,7),(124,'PASONS AL MADINAH SUPER MARKET - INT CITY DUBAI','H',6,8),(125,'AL BERWAZ PLASTIC FACTORY','H',5,3),(126,'AL HASNAA FOODSTUFF TRD.','H',5,4),(127,'AL HILAL Cleaning Materials Trading','H',5,5),(128,'AL LEWAA FLOUR MILL & FOOD STUFF TRD.','H',5,6),(129,'AL MAILEE DISTRIBUTION','H',5,7),(130,'AL MAWAKEB NUTS L.L.C','H',5,8),(131,'Best Bakery LLC','H',5,9),(132,'BROTHERS GAS','H',5,10),(133,'CITY PAK','H',5,11),(134,'Falcon Pack','H',5,12),(135,'FreeTrade International FZE','H',5,13),(136,'GHULAMI General Trading LLC Dubai','H',5,14),(137,'GREAT EMIRATES FOOD STUFF CATERING L.L.C','H',5,15),(138,'GRIPPO GROUP- RAK','H',5,16),(139,'Haroon Labels Industries L. L.C','H',5,17),(140,'IFFCO DISTRIBUTION SERVICE-DUBAI','H',5,18),(141,'MODERN GEN.TRD CO.','H',5,19),(142,'MUDRA GEN. TRD.','H',5,20),(143,'RAG FOOD STUFF TRD.L.L.C','H',5,21),(144,'SAFCO (Sanwhey Food Stuff Trd)','H',5,22),(145,'AJMAN & AL MANAMA SUPER MKT(BR.2-AL WAHDA-SHARJAH)','H',6,9),(146,'AL MANAMA(AL NAHDA-II DUBAI)','H',6,10),(147,'AL MANAMA CENTRE BR.1 ATLAS MALL','H',6,11),(148,'AL MANAMA CENTRE (MYSALOON-SHJ)','H',6,12),(149,'AL MANAMA CENTRE (NUAIMIYAH-AJMAN)','H',6,13),(150,'AL Manama Cneter Br-2 - AbuShagara- SHJ','H',6,14),(151,'AL MANAMA HYPER(AL QOUS-DUBAI)','H',6,15),(152,'AL MANAMA HYPER MARKET(RAK)','H',6,16),(153,'Al Manama Hyper Market - Umm Al Quwain','H',6,17),(154,'AL MANAMA HYPER MKT(KARAMA-DUBAI)','H',6,18),(155,'AL MANAMA HYPR (AL FAHEDI-DUBAI)','H',6,19),(156,'AL MANAMA HYPR-MALL(AJMAN)','H',6,20),(157,'AL MANAMA SM (JURAF- AJMAN)','H',6,21),(158,'AL MANAMA SPR MKT (DANA- PLAZA AJMAN)','H',6,22),(159,'AL MANAMA SUPER MARKET( ROLLA-SHARJAH)','H',6,23),(160,'AL SAIF AL DHAHABI SPR MKT-RAK','H',6,24),(161,'AL SAIF AL DHAHABI SPR [RAK CERAMIC]','H',6,25),(162,'AL WAFA CENTRE GEN. TRD. (AL WAHDAH-SHARJAH)','H',6,26),(163,'AL WAFA CENTRE(ROLLA-SHARJAH)','H',6,27),(164,'EVERFINE SPR MKT(DEIRA-DUBAI)','H',6,28),(165,'NESTO Caravan SM (DUBAI)','H',6,29),(166,'NESTO CENTRE-AJMAN','H',6,30),(167,'NESTO CENTRE L.L.C(RAK)','H',6,31),(168,'NESTO Hyper Market Br-1 Mushrif-Ajman','H',6,32),(169,'NESTO HYPER MARKET (JEBEL ALI-DUBAI)','H',6,33),(170,'NESTO Hyper Market - JURAF AJMAN','H',6,34),(171,'NESTO HYPER MKT-AJMAN','H',6,35),(172,'NESTO HYPER MKT (BUTHAINA -SHJ)','H',6,36),(173,'NESTO HYPER MKT SHJ BR.1','H',6,37),(174,'NESTO SUPR MKT CORNICHE-AJMAN','H',6,38),(175,'NEW NESTO CENTRE L.L.C(SHARJAH)','H',6,39),(176,'FATHIMA HYPER MARKET-RAK','H',6,40),(177,'FATHIMA SUPER MARKET-AJMAN','H',6,41),(178,'Grand Mart - Ajman','H',6,42),(179,'GRAND MART - RAK','H',6,43),(180,'J-MART (AL QUOZ-DUBAI)','H',6,44),(181,'J-MART (CLOCK TOWER-SHJ)','H',6,45),(182,'J-MART(MOROCCO INTERNATIONAL CITY-DUBAI)','H',6,46),(183,'J-MART(MUTEENA)','H',6,47),(184,'KM HYPER MARKET - BUR DUBAI','H',6,48),(185,'K. M. HYPER MARKET(INDUSTRL. AREA SHARJAH)','H',6,49),(186,'K.M TRADING SHOPPING CENTRE(ABU SHAGARA-SHJ)','H',6,50),(187,'K M TRADING SHOPPING CENTRE(DUBAI)','H',6,51),(188,'Al Falah Plaza- Abu Dhabi','H',6,52),(189,'EMKE Super Market Madiant Zayed- Abu Dhabi','H',6,53),(190,'LULU Center - Abu Dhabi','H',6,54),(191,'LULU HM Bain Al Jesrain CO. OP. Society - Abu Dhab','H',6,55),(192,'LULU Hyper Market Al Wahda Mall - Abu Dhabi','H',6,56),(193,'LULU Hyper Market Baniyas - Abu Dhabi','H',6,57),(194,'LULU Hyper Market Capital Mall - Abu Dhabi','H',6,58),(195,'LULU Hyper Market Khalidiya Mall-Abu Dhabi','H',6,59),(196,'LULU Hyper Market Madinat Zayed - Abu Dhabi','H',6,60),(197,'LULU HYPER MARKET Mushrif Mall - Abu Dhabi','H',6,61),(198,'LULU Hyper Market Ruwais - Abu Dhabi','H',6,62),(199,'LULU XPRESS-Adnoc Housing Complex (Ruwaisa-AH)','H',6,63),(200,'LULU Xpress Al Raha Mall - Abu Dhabi','H',6,64),(201,'LULU Xpress Electra Street - Abu Dhabi','H',6,65),(202,'LULU Xpress Fresh Market City Center Mall-Abu Dhab','H',6,66),(203,'LULU Xpress Fresh Market Hamdan- Abu Dhabi','H',6,67),(204,'LULU Xpress Gayathi , Ruwais -Abu Dhabi','H',6,68),(205,'Lulu Xpress Mazyad Mall, Musaffah - Abu Dhabi','H',6,69),(206,'LULU Xpress Mureeer Road- Abu Dhabi','H',6,70),(207,'LULU XPRESS Shawamekh - Abu Dhabi','H',6,71),(208,'LULU HYPER MKT-AJMAN','H',6,72),(209,'AL FALAH PLAZA- AL AIN','H',6,73),(210,'  Lulu Center - Al Ain','H',6,74),(211,'Lulu Hyper Market Alfoah Br - Al Ain','H',6,75),(212,'LULU Hyper Market Barari Outlet Mall- Al Ain','H',6,76),(213,'LULU HYPER MARKET - HILL MALL, AL AIN','H',6,77),(214,'LULU Hyper Market - Kuwaital Br- AL AIN','H',6,78),(215,'LULU Hyper Market Sanaiya - Al Ain','H',6,79),(216,'LULU CENTRE (MUHAISNAH DUBAI)','H',6,80),(217,'LULU HYPER ARABIAN CENTRE(DUBAI)','H',6,81),(218,'LULU HYPER MARKET(AL BARSHA-DUBAI)','H',6,82),(219,'LULU HYPER MARKET(AL QUSAIS-DUBAI)','H',6,83),(220,'LULU HYPER MARKET (KARAMA-DUBAI)','H',6,84),(221,'LULU SUPER MARKET(KARAMA-DUBAI)','H',6,85),(222,'LULU XPRESS(AL QUOZ-DUBAI)','H',6,86),(223,'LULU XPRESS INTERNATIONAL CITY(DUBAI)','H',6,87),(224,'LULU HYPER MKT(DIBBA-FUJAIRA)','H',6,88),(225,'LULU HYPER MKT-Fujairah','H',6,89),(226,'LULU HYPER MARKET(RAK)','H',6,90),(227,'LULU HYPER MARKET SHARJAH','H',6,91),(228,'LULU HYPER MARKET UM AL QUWAIN','H',6,92),(229,'Ramla Hyper Market Al- Nahdah Dubai','H',6,93),(230,'Ramla Hyper Market (DIP - Dubai)','H',6,94),(231,'RAMLA HYPER MARKET -RAK','H',6,95),(232,'Ramla Super Market -Musaffah Adu Dhabi','H',6,96),(233,'2002- CAFETERIA-AJMAN','H',6,97),(234,'ABU SHABANA GROCERY- ABU DHABI','H',6,98),(235,'AHLAN SUPER MARKET -RAK','H',6,99),(236,'AIN AL MADINA HYPR MKT-AJMAN','H',6,100),(237,'AJMAL SUPER MARKET - RAK','H',6,101),(238,'AL AALIYA RESTURANT - RAK','H',6,102),(239,'AL ALFIYA SPR MKT-AJMAN','H',6,103),(240,'Al Bakhoor Grocery - Abu Dhabi','H',6,104),(241,'AL Ekhwan Grocery-RAK(RAMS)','H',6,105),(242,'AL FAWAHAR SPR MKT-AJMAN','H',6,106),(243,'Al Ghabat City SM - Mussaffah Abu Dhabi','H',6,107),(244,'AL GHAFRI GROCERY - ABU DHABI','H',6,108),(245,'Al Ghanem Super Market - RAK','H',6,109),(246,'AL JABIRI SPR MKT-AJMAN','H',6,110),(247,'AL JAZEERA SPR MKT-RAK','H',6,111),(248,'Al Khatm Grocery- Abu Dhabi','H',6,112),(249,'AL MAWAL SUPERMARKET  NP SHARJAH','H',6,113),(250,'Al Muhrami Grocery- Abu Dhabi','H',6,114),(251,'AL NASRIYA SPR MKT-AJMAN','H',6,115),(252,'Al Nokhbah Super Market -RAK','H',6,116),(253,'Al Qareeb Grocery- Abu Dhabi','H',6,117),(254,'Al Qraiwan Grosery Rak','H',6,118),(255,'AL SAMARY SUPER MARKET','H',6,119),(256,'Al Sandian Resturant - Al Ain','H',6,120),(257,'AL SHARAM SPR MKT-RAK','H',6,121),(258,'AL USTHAD SPR MKT-AJMAN','H',6,122),(259,'ASEMA SPR MKT- AJMAN','H',6,123),(260,'Aswaq Grocery- Abu Dhabi','H',6,124),(261,'ATIQ FOOD STUFF(AJMAN)','H',6,125),(262,'AYA SPR MKT(AJMAN)','H',6,126),(263,'BAQALA AL SAHER - ABU DHABI','H',6,127),(264,'BARANA AL MADINAH SM','H',6,128),(265,'BINTH JUNAIL SPR MKT(AJMAN)','H',6,129),(266,'BURJ MALABAR  SUPERMARKET AJMAN','H',6,130),(267,'BUTTER FLY SPR MKT-AJMAN','H',6,131),(268,'DANAT AL KHALEEJ- AJMAN','H',6,132),(269,'Dar Ul Haman Grocery - RAK','H',6,133),(270,'E CITY SUPER MARKET (RUSSIA V22_ - DUBAI','H',6,134),(271,'FAHIDA SUPER MARKET-AJMAN','H',6,135),(272,'Families Super Market - RAK','H',6,136),(273,'FOUR STAR FOOD STUFF( AJMAN)','H',6,137),(274,'GOLDEN BUTTERFLY SPR MKT-AJMAN','H',6,138),(275,'Happy Land SM (Mateena Deira -Dubai)','H',6,139),(276,'HAPPY LAND SPR MKT-AJMAN','H',6,140),(277,'HARAM AL MADINA SUPERMARKET AJMAN','H',6,141),(278,'Hilal Al Madinah Super Market - SHJ','H',6,142),(279,'IBAN - Supermarket -RAK','H',6,143),(280,'JAWAHAR SUPER MKT-AJMAN','H',6,144),(281,'JAZARATH AL MADINA SPR-ALGAIL-RAK','H',6,145),(282,'KMK SUPER MARKET','H',6,146),(283,'MADINATH AL SAHAB SPR MKT-AJMAN','H',6,147),(284,'MAKKAH SPR MKT-AJMAN','H',6,148),(285,'Metro Grocery- Abu Dhabi','H',6,149),(286,'MIDAD GROCERY - ABU DHABI','H',6,150),(287,'Mina Al Arab Super Market','H',6,151),(288,'MUHAMMAD IQBAL GROCERY- ABU DHABI','H',6,152),(289,'NAIL SPR MKT-AJMAN','H',6,153),(290,'NAJAM AL DANUBE SM - AJMAN','H',6,154),(291,'NOOR AL AHLAM GROCERY- AL AIN','H',6,155),(292,'Noor Al Madina Spr Mkt-Ajman','H',6,156),(293,'PANDA SUPER MKT-RAK','H',6,157),(294,'Parco Hyper Market LLC','H',6,158),(295,'Royal Al Madinah SM- Abu Dhabi','H',6,159),(296,'SAHAR AL MADINA SPR -AJMAN','H',6,160),(297,'Sahem Al Madina Supermarket Ajman UAE','H',6,161),(298,'Seah Al Madeena Grocery Rak','H',6,162),(299,'Seeh Al Ghail Grocery & Resturent','H',6,163),(300,'SEVEN ELEVEN SPR MKT-RAK','H',6,164),(301,'SHABAB AL WADI FOODSTUFF TRADING AJMAN KARAMA','H',6,165),(302,'Sky Light Grocery  - Abu Dhabi','H',6,166),(303,'SNABAL KHAIR BAQALA - ABU DHABI','H',6,167),(304,'SNOE WHITE GROCCERY- ABU DHABI','H',6,168),(305,'Souq Al Madinah Super Market - RAK','H',6,169),(306,'SOUQ AL MADINA SPR MKT-AL GAIL-RAK','H',6,170),(307,'Spike of Prosperity SM - Abu Dhabi','H',6,171),(308,'Sring SM Satwa -Dubai','H',6,172),(309,'SUN CITY HYPER MKT-AJMAN','H',6,173),(310,'Super Star Grocery - Abu Dhabi','H',6,174),(311,'TAIBA SUPER MARKET-AJMAN','H',6,175),(312,'TRANS GROCERY - ABU DHABI','H',6,176),(313,'Vally Corner Grocery - Abu Dhabi','H',6,177),(314,'Wafa Al Madinah Sm Dubai','H',6,178),(315,'ZAHART BAGHDAD SM-AJMAN','H',6,179),(316,'Zeeba SM - Abu Dhabi','H',6,180),(317,'SUPER BONANZA HYPER MARKET - DUBAI','H',6,181),(318,'SUPER BONANZA HYPER MARKET - SHARJAH','H',6,182),(319,'Al Ghail Super Market LLC -RAK','H',6,183),(320,'AL MADINAH Hyper Market -Ras Al Khaor -Duabi','H',6,184),(321,'Church- Ras Al Khaimah','H',6,185),(322,'GULF EXPRESS SUPER MARKET - RAK','H',6,186),(323,'GULF HYPER MARKET-RAK','H',6,187),(324,'IBAN SUPERMARKET - RAK (Credit Sale)','H',6,188),(325,'INDIAN SCHOOL','H',6,189),(326,'KENZ Hyper Market -Ajman','H',6,190),(327,'KERALA SUPER MARKET','H',6,191),(328,'PACKING MATERIALS','H',3,0),(329,'111','H',1,0),(331,'Items for Re-sale','H',3,0),(332,'Al khair vegitable & fruits trading','H',5,23);
  43. /*!40000 ALTER TABLE `tbl_acc_groups` ENABLE KEYS */;
  44. UNLOCK TABLES;
  45.  
  46. --
  47. -- Table structure for table `tbl_acc_master`
  48. --
  49.  
  50. DROP TABLE IF EXISTS `tbl_acc_master`;
  51. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  52. /*!40101 SET character_set_client = utf8 */;
  53. CREATE TABLE `tbl_acc_master` (
  54.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  55.   `GROUP_NAME` varchar(50) NOT NULL DEFAULT '',
  56.   PRIMARY KEY (`ID`),
  57.   UNIQUE KEY `ID` (`ID`)
  58. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  59. /*!40101 SET character_set_client = @saved_cs_client */;
  60.  
  61. --
  62. -- Dumping data for table `tbl_acc_master`
  63. --
  64.  
  65. LOCK TABLES `tbl_acc_master` WRITE;
  66. /*!40000 ALTER TABLE `tbl_acc_master` DISABLE KEYS */;
  67. INSERT INTO `tbl_acc_master` VALUES (1,'Asset'),(2,'Liability'),(3,'Income'),(4,'Expense');
  68. /*!40000 ALTER TABLE `tbl_acc_master` ENABLE KEYS */;
  69. UNLOCK TABLES;
  70.  
  71. --
  72. -- Table structure for table `tbl_bank_transactions`
  73. --
  74.  
  75. DROP TABLE IF EXISTS `tbl_bank_transactions`;
  76. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  77. /*!40101 SET character_set_client = utf8 */;
  78. CREATE TABLE `tbl_bank_transactions` (
  79.   `BTN_ID` int(11) NOT NULL AUTO_INCREMENT,
  80.   `BTN_VOUCHER_CODE` varchar(255) NOT NULL,
  81.   `BTN_DEBIT_ACC_ID` int(11) DEFAULT NULL,
  82.   `BTN_CREDIT_ACC_ID` int(11) DEFAULT NULL,
  83.   `BTN_AMOUNT` double DEFAULT NULL,
  84.   `BTN_TRASACTION_DATE` date DEFAULT NULL,
  85.   `BTN_SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  86.   `BTN_CHQUE_NUM` varchar(255) DEFAULT NULL,
  87.   `BTN_CHQUE_DATE` date DEFAULT NULL,
  88.   `BTN_USER_ID` int(11) NOT NULL,
  89.   `BTN_NARRATION` varchar(350) DEFAULT NULL,
  90.   `BTN_TYPE` int(11) NOT NULL COMMENT '1-cheque,2-bank',
  91.   `BTN_STATUS` varchar(11) NOT NULL DEFAULT 'D' COMMENT 'R_Realised,B-Bounced,D-Deposited',
  92.   `BTN_STATUS_DATE` date DEFAULT NULL,
  93.   `BTN_UPDATED_VOUCHER_CODE` varchar(255) NOT NULL DEFAULT '0',
  94.   PRIMARY KEY (`BTN_ID`)
  95. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  96. /*!40101 SET character_set_client = @saved_cs_client */;
  97.  
  98. --
  99. -- Dumping data for table `tbl_bank_transactions`
  100. --
  101.  
  102. LOCK TABLES `tbl_bank_transactions` WRITE;
  103. /*!40000 ALTER TABLE `tbl_bank_transactions` DISABLE KEYS */;
  104. INSERT INTO `tbl_bank_transactions` VALUES (1,'CP1',104,91,25000,'2017-03-01','2017-04-01 20:00:39',NULL,NULL,0,'                    ',0,'D',NULL,'0'),(2,'RC1',91,96,22222,'2017-03-01','2017-04-01 20:01:20',NULL,NULL,0,'\r\n                  ',0,'D',NULL,'0'),(3,'BP1',331,92,522,'2017-03-30','2017-04-01 20:35:58','022222','2017-04-28',0,'                    ',1,'D',NULL,'0'),(4,'RB1',92,102,5000,'2017-03-31','2017-04-01 20:45:52','001','2017-03-31',0,'\r\n                  ',1,'D',NULL,'0'),(5,'RB2',92,328,200,'1969-12-31','2017-04-01 20:46:21','002','2017-04-14',0,'\r\n                  ',1,'D',NULL,'0'),(6,'BP2',331,92,6000,'2017-03-31','2017-04-01 20:47:12','0003','2017-04-14',0,'                    ',1,'D',NULL,'0');
  105. /*!40000 ALTER TABLE `tbl_bank_transactions` ENABLE KEYS */;
  106. UNLOCK TABLES;
  107.  
  108. --
  109. -- Table structure for table `tbl_company_info`
  110. --
  111.  
  112. DROP TABLE IF EXISTS `tbl_company_info`;
  113. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  114. /*!40101 SET character_set_client = utf8 */;
  115. CREATE TABLE `tbl_company_info` (
  116.   `COMPANY_ID` int(11) NOT NULL AUTO_INCREMENT,
  117.   `COMPANY_NAME` varchar(45) DEFAULT NULL,
  118.   `COMPANY_ADDRESS` varchar(45) DEFAULT NULL,
  119.   `COMPANY_MOBILE` varchar(45) DEFAULT NULL,
  120.   `COMPANY_FAX` varchar(45) DEFAULT NULL,
  121.   `COMPANY_EMAIL` varchar(45) DEFAULT NULL,
  122.   `COMPANY_LOGO` varchar(45) DEFAULT NULL,
  123.   `COMPANY_CURRENCY` varchar(3) NOT NULL,
  124.   PRIMARY KEY (`COMPANY_ID`)
  125. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  126. /*!40101 SET character_set_client = @saved_cs_client */;
  127.  
  128. --
  129. -- Dumping data for table `tbl_company_info`
  130. --
  131.  
  132. LOCK TABLES `tbl_company_info` WRITE;
  133. /*!40000 ALTER TABLE `tbl_company_info` DISABLE KEYS */;
  134. INSERT INTO `tbl_company_info` VALUES (1,'ABC BAKERY AND SWEETS ','P.O Box: 28857, Ras Al Khaimah- U.A.E','01-8877570',NULL,'info@abcbakeryuae.com','logo.png','AED');
  135. /*!40000 ALTER TABLE `tbl_company_info` ENABLE KEYS */;
  136. UNLOCK TABLES;
  137.  
  138. --
  139. -- Table structure for table `tbl_country`
  140. --
  141.  
  142. DROP TABLE IF EXISTS `tbl_country`;
  143. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  144. /*!40101 SET character_set_client = utf8 */;
  145. CREATE TABLE `tbl_country` (
  146.   `COUNTRY_ID` int(11) NOT NULL AUTO_INCREMENT,
  147.   `COUNTRY_NAME` varchar(45) DEFAULT NULL,
  148.   PRIMARY KEY (`COUNTRY_ID`)
  149. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  150. /*!40101 SET character_set_client = @saved_cs_client */;
  151.  
  152. --
  153. -- Dumping data for table `tbl_country`
  154. --
  155.  
  156. LOCK TABLES `tbl_country` WRITE;
  157. /*!40000 ALTER TABLE `tbl_country` DISABLE KEYS */;
  158. INSERT INTO `tbl_country` VALUES (1,'INDIA'),(2,'UAE'),(3,'KSA');
  159. /*!40000 ALTER TABLE `tbl_country` ENABLE KEYS */;
  160. UNLOCK TABLES;
  161.  
  162. --
  163. -- Table structure for table `tbl_dup_transactions`
  164. --
  165.  
  166. DROP TABLE IF EXISTS `tbl_dup_transactions`;
  167. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  168. /*!40101 SET character_set_client = utf8 */;
  169. CREATE TABLE `tbl_dup_transactions` (
  170.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  171.   `VOUCHER_CODE` varchar(255) NOT NULL,
  172.   `DEBIT_ACC_ID` int(11) DEFAULT NULL,
  173.   `CREDIT_ACC_ID` int(11) DEFAULT NULL,
  174.   `AMOUNT` double DEFAULT NULL,
  175.   `TRASACTION_DATE` date DEFAULT NULL,
  176.   `SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  177.   `CHQUE_NUM` varchar(255) DEFAULT NULL,
  178.   `CHQUE_DATE` date DEFAULT NULL,
  179.   `ADDRESS` varchar(300) DEFAULT NULL,
  180.   `USER_ID` int(11) DEFAULT NULL,
  181.   `NARRATION` varchar(350) DEFAULT NULL,
  182.   `DELETED_USER` int(11) DEFAULT NULL,
  183.   `INVOICE_NUMBER` varchar(45) NOT NULL,
  184.   PRIMARY KEY (`ID`)
  185. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  186. /*!40101 SET character_set_client = @saved_cs_client */;
  187.  
  188. --
  189. -- Dumping data for table `tbl_dup_transactions`
  190. --
  191.  
  192. LOCK TABLES `tbl_dup_transactions` WRITE;
  193. /*!40000 ALTER TABLE `tbl_dup_transactions` DISABLE KEYS */;
  194. /*!40000 ALTER TABLE `tbl_dup_transactions` ENABLE KEYS */;
  195. UNLOCK TABLES;
  196.  
  197. --
  198. -- Table structure for table `tbl_financial_year`
  199. --
  200.  
  201. DROP TABLE IF EXISTS `tbl_financial_year`;
  202. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  203. /*!40101 SET character_set_client = utf8 */;
  204. CREATE TABLE `tbl_financial_year` (
  205.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  206.   `YEAR_START` date DEFAULT NULL,
  207.   `YEAR_END` date DEFAULT NULL,
  208.   PRIMARY KEY (`ID`)
  209. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  210. /*!40101 SET character_set_client = @saved_cs_client */;
  211.  
  212. --
  213. -- Dumping data for table `tbl_financial_year`
  214. --
  215.  
  216. LOCK TABLES `tbl_financial_year` WRITE;
  217. /*!40000 ALTER TABLE `tbl_financial_year` DISABLE KEYS */;
  218. INSERT INTO `tbl_financial_year` VALUES (2,'2016-04-01','2017-03-31'),(3,'2017-04-01','2018-03-31');
  219. /*!40000 ALTER TABLE `tbl_financial_year` ENABLE KEYS */;
  220. UNLOCK TABLES;
  221.  
  222. --
  223. -- Table structure for table `tbl_inv_category`
  224. --
  225.  
  226. DROP TABLE IF EXISTS `tbl_inv_category`;
  227. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  228. /*!40101 SET character_set_client = utf8 */;
  229. CREATE TABLE `tbl_inv_category` (
  230.   `CATEGORY_ID` int(11) NOT NULL AUTO_INCREMENT,
  231.   `CATEGORY_NAME` varchar(45) DEFAULT NULL,
  232.   `CATEGORY_DATE_ADDED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  233.   PRIMARY KEY (`CATEGORY_ID`)
  234. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  235. /*!40101 SET character_set_client = @saved_cs_client */;
  236.  
  237. --
  238. -- Dumping data for table `tbl_inv_category`
  239. --
  240.  
  241. LOCK TABLES `tbl_inv_category` WRITE;
  242. /*!40000 ALTER TABLE `tbl_inv_category` DISABLE KEYS */;
  243. INSERT INTO `tbl_inv_category` VALUES (1,'RICE ITEMS','2017-02-23 20:28:00'),(2,'OIL ITEMS','2017-03-01 01:19:12'),(3,'COLOURS','2017-03-01 01:19:23'),(4,'GENERAL','2017-03-01 01:20:16'),(5,'PACKING MATERIALS','2017-03-08 22:23:37'),(6,'Items for re-sale','2017-03-20 18:01:00');
  244. /*!40000 ALTER TABLE `tbl_inv_category` ENABLE KEYS */;
  245. UNLOCK TABLES;
  246.  
  247. --
  248. -- Table structure for table `tbl_inv_cost_master`
  249. --
  250.  
  251. DROP TABLE IF EXISTS `tbl_inv_cost_master`;
  252. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  253. /*!40101 SET character_set_client = utf8 */;
  254. CREATE TABLE `tbl_inv_cost_master` (
  255.   `COST_ID` int(11) NOT NULL AUTO_INCREMENT,
  256.   `COST_PRODUCT_ID` int(11) DEFAULT NULL,
  257.   `COST_QTY` double DEFAULT NULL,
  258.   PRIMARY KEY (`COST_ID`)
  259. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  260. /*!40101 SET character_set_client = @saved_cs_client */;
  261.  
  262. --
  263. -- Dumping data for table `tbl_inv_cost_master`
  264. --
  265.  
  266. LOCK TABLES `tbl_inv_cost_master` WRITE;
  267. /*!40000 ALTER TABLE `tbl_inv_cost_master` DISABLE KEYS */;
  268. /*!40000 ALTER TABLE `tbl_inv_cost_master` ENABLE KEYS */;
  269. UNLOCK TABLES;
  270.  
  271. --
  272. -- Table structure for table `tbl_inv_cost_master_items`
  273. --
  274.  
  275. DROP TABLE IF EXISTS `tbl_inv_cost_master_items`;
  276. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  277. /*!40101 SET character_set_client = utf8 */;
  278. CREATE TABLE `tbl_inv_cost_master_items` (
  279.   `C_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  280.   `C_ITEM_MASTER_ID` int(11) DEFAULT NULL,
  281.   `C_ITEM_QTY` double DEFAULT NULL,
  282.   `C_COST_MASTER_ID` int(11) DEFAULT NULL,
  283.   PRIMARY KEY (`C_ITEM_ID`)
  284. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  285. /*!40101 SET character_set_client = @saved_cs_client */;
  286.  
  287. --
  288. -- Dumping data for table `tbl_inv_cost_master_items`
  289. --
  290.  
  291. LOCK TABLES `tbl_inv_cost_master_items` WRITE;
  292. /*!40000 ALTER TABLE `tbl_inv_cost_master_items` DISABLE KEYS */;
  293. /*!40000 ALTER TABLE `tbl_inv_cost_master_items` ENABLE KEYS */;
  294. UNLOCK TABLES;
  295.  
  296. --
  297. -- Table structure for table `tbl_inv_customer`
  298. --
  299.  
  300. DROP TABLE IF EXISTS `tbl_inv_customer`;
  301. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  302. /*!40101 SET character_set_client = utf8 */;
  303. CREATE TABLE `tbl_inv_customer` (
  304.   `CUSTOMER_ID` int(11) NOT NULL AUTO_INCREMENT,
  305.   `CUSTOMER_NAME` varchar(45) DEFAULT NULL,
  306.   `CUSTOMER_ADDRESS` varchar(45) DEFAULT NULL,
  307.   `CUSTOMER_PHONE` varchar(45) DEFAULT NULL,
  308.   `CUSTOMER_LOCATION` varchar(45) DEFAULT NULL,
  309.   `CUSTOMER_EMAIL_ID` varchar(45) DEFAULT NULL,
  310.   `CUSTOMER_COUNTRY_ID` int(11) DEFAULT NULL,
  311.   `CUSTOMER_PRICELIST_ID` int(11) DEFAULT NULL,
  312.   `CUSTOMER_ROUTE_ID` int(11) DEFAULT NULL,
  313.   `CUSTOMER_TIN_NUMBER` varchar(45) DEFAULT NULL,
  314.   PRIMARY KEY (`CUSTOMER_ID`)
  315. ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
  316. /*!40101 SET character_set_client = @saved_cs_client */;
  317.  
  318. --
  319. -- Dumping data for table `tbl_inv_customer`
  320. --
  321.  
  322. LOCK TABLES `tbl_inv_customer` WRITE;
  323. /*!40000 ALTER TABLE `tbl_inv_customer` DISABLE KEYS */;
  324. INSERT INTO `tbl_inv_customer` VALUES (5,'Noor Al Qusais Super Market - Dubai','WAREHOUSE NOS 11, 233 0','9809694748','shj','S.MOHSIN@LIVE.COM',1,2,1,NULL),(6,'PASONS AL MADINAH SUPER MARKET - KARAMA DUBAI','\r\n','22125125','akjsn','nkjdsbdk@k.com',1,2,1,NULL),(7,' PASONS AL MADINAH SUPER MARKET - AL NAHDAH','jk','2555245245','bjbvhjn','nkjbahsb@nscnmkl.cmim',1,2,1,NULL),(8,'PASONS AL MADINAH SUPER MARKET - INT CITY DUB','hhjhnjkn','2542545588','sdvhj','sdl@gmail.com',1,2,1,NULL),(9,'AJMAN & AL MANAMA SUPER MKT(BR.2-AL WAHDA-SHA',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL),(10,'AL MANAMA(AL NAHDA-II DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'AL MANAMA CENTRE BR.1 ATLAS MALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'AL MANAMA CENTRE (MYSALOON-SHJ)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'AL MANAMA CENTRE (NUAIMIYAH-AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'AL Manama Cneter Br-2 - AbuShagara- SHJ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'AL MANAMA HYPER(AL QOUS-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'AL MANAMA HYPER MARKET(RAK)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Al Manama Hyper Market - Umm Al Quwain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'AL MANAMA HYPER MKT(KARAMA-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'AL MANAMA HYPR (AL FAHEDI-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'AL MANAMA HYPR-MALL(AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'AL MANAMA SM (JURAF- AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'AL MANAMA SPR MKT (DANA- PLAZA AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'AL MANAMA SUPER MARKET( ROLLA-SHARJAH)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'AL SAIF AL DHAHABI SPR MKT-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'AL SAIF AL DHAHABI SPR [RAK CERAMIC]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'AL WAFA CENTRE GEN. TRD. (AL WAHDAH-SHARJAH)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'AL WAFA CENTRE(ROLLA-SHARJAH)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'EVERFINE SPR MKT(DEIRA-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'NESTO Caravan SM (DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'NESTO CENTRE-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'NESTO CENTRE L.L.C(RAK)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'NESTO Hyper Market Br-1 Mushrif-Ajman',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'NESTO HYPER MARKET (JEBEL ALI-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'NESTO Hyper Market - JURAF AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'NESTO HYPER MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'NESTO HYPER MKT (BUTHAINA -SHJ)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'NESTO HYPER MKT SHJ BR.1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'NESTO SUPR MKT CORNICHE-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'NEW NESTO CENTRE L.L.C(SHARJAH)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'FATHIMA HYPER MARKET-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'FATHIMA SUPER MARKET-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'Grand Mart - Ajman',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'GRAND MART - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'J-MART (AL QUOZ-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'J-MART (CLOCK TOWER-SHJ)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'J-MART(MOROCCO INTERNATIONAL CITY-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'J-MART(MUTEENA)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'KM HYPER MARKET - BUR DUBAI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'K. M. HYPER MARKET(INDUSTRL. AREA SHARJAH)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'K.M TRADING SHOPPING CENTRE(ABU SHAGARA-SHJ)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'K M TRADING SHOPPING CENTRE(DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'Al Falah Plaza- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'EMKE Super Market Madiant Zayed- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'LULU Center - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'LULU HM Bain Al Jesrain CO. OP. Society - Abu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'LULU Hyper Market Al Wahda Mall - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'LULU Hyper Market Baniyas - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'LULU Hyper Market Capital Mall - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'LULU Hyper Market Khalidiya Mall-Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'LULU Hyper Market Madinat Zayed - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'LULU HYPER MARKET Mushrif Mall - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'LULU Hyper Market Ruwais - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'LULU XPRESS-Adnoc Housing Complex (Ruwaisa-AH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'LULU Xpress Al Raha Mall - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'LULU Xpress Electra Street - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'LULU Xpress Fresh Market City Center Mall-Abu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'LULU Xpress Fresh Market Hamdan- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'LULU Xpress Gayathi , Ruwais -Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'Lulu Xpress Mazyad Mall, Musaffah - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'LULU Xpress Mureeer Road- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'LULU XPRESS Shawamekh - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'LULU HYPER MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'AL FALAH PLAZA- AL AIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'Lulu Center - Al Ain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'Lulu Hyper Market Alfoah Br - Al Ain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'LULU Hyper Market Barari Outlet Mall- Al Ain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'LULU HYPER MARKET - HILL MALL, AL AIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'LULU Hyper Market - Kuwaital Br- AL AIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'LULU Hyper Market Sanaiya - Al Ain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'LULU CENTRE (MUHAISNAH DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'LULU HYPER ARABIAN CENTRE(DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'LULU HYPER MARKET(AL BARSHA-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'LULU HYPER MARKET(AL QUSAIS-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'LULU HYPER MARKET (KARAMA-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'LULU SUPER MARKET(KARAMA-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'LULU XPRESS(AL QUOZ-DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'LULU XPRESS INTERNATIONAL CITY(DUBAI)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'LULU HYPER MKT(DIBBA-FUJAIRA)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'LULU HYPER MKT-Fujairah',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'LULU HYPER MARKET(RAK)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'LULU HYPER MARKET SHARJAH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'LULU HYPER MARKET UM AL QUWAIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'Ramla Hyper Market Al- Nahdah Dubai',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'Ramla Hyper Market (DIP - Dubai)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'RAMLA HYPER MARKET -RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'Ramla Super Market -Musaffah Adu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'2002- CAFETERIA-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'ABU SHABANA GROCERY- ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'AHLAN SUPER MARKET -RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'AIN AL MADINA HYPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'AJMAL SUPER MARKET - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'AL AALIYA RESTURANT - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'AL ALFIYA SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'Al Bakhoor Grocery - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'AL Ekhwan Grocery-RAK(RAMS)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'AL FAWAHAR SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'Al Ghabat City SM - Mussaffah Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'AL GHAFRI GROCERY - ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'Al Ghanem Super Market - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'AL JABIRI SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'AL JAZEERA SPR MKT-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'Al Khatm Grocery- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'AL MAWAL SUPERMARKET  NP SHARJAH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'Al Muhrami Grocery- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'AL NASRIYA SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'Al Nokhbah Super Market -RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'Al Qareeb Grocery- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'Al Qraiwan Grosery Rak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'AL SAMARY SUPER MARKET',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'Al Sandian Resturant - Al Ain',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'AL SHARAM SPR MKT-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'AL USTHAD SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'ASEMA SPR MKT- AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'Aswaq Grocery- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'ATIQ FOOD STUFF(AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'AYA SPR MKT(AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'BAQALA AL SAHER - ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'BARANA AL MADINAH SM',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'BINTH JUNAIL SPR MKT(AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'BURJ MALABAR  SUPERMARKET AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'BUTTER FLY SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'DANAT AL KHALEEJ- AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'Dar Ul Haman Grocery - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'E CITY SUPER MARKET (RUSSIA V22_ - DUBAI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'FAHIDA SUPER MARKET-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'Families Super Market - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'FOUR STAR FOOD STUFF( AJMAN)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,'GOLDEN BUTTERFLY SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,'Happy Land SM (Mateena Deira -Dubai)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'HAPPY LAND SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'HARAM AL MADINA SUPERMARKET AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'Hilal Al Madinah Super Market - SHJ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,'IBAN - Supermarket -RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,'JAWAHAR SUPER MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,'JAZARATH AL MADINA SPR-ALGAIL-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,'KMK SUPER MARKET',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,'MADINATH AL SAHAB SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(148,'MAKKAH SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,'Metro Grocery- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(150,'MIDAD GROCERY - ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(151,'Mina Al Arab Super Market',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,'MUHAMMAD IQBAL GROCERY- ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,'NAIL SPR MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,'NAJAM AL DANUBE SM - AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,'NOOR AL AHLAM GROCERY- AL AIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,'Noor Al Madina Spr Mkt-Ajman',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(157,'PANDA SUPER MKT-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,'Parco Hyper Market LLC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,'Royal Al Madinah SM- Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,'SAHAR AL MADINA SPR -AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(161,'Sahem Al Madina Supermarket Ajman UAE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(162,'Seah Al Madeena Grocery Rak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(163,'Seeh Al Ghail Grocery & Resturent',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(164,'SEVEN ELEVEN SPR MKT-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(165,'SHABAB AL WADI FOODSTUFF TRADING AJMAN KARAMA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(166,'Sky Light Grocery  - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(167,'SNABAL KHAIR BAQALA - ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(168,'SNOE WHITE GROCCERY- ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(169,'Souq Al Madinah Super Market - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(170,'SOUQ AL MADINA SPR MKT-AL GAIL-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,'Spike of Prosperity SM - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,'Sring SM Satwa -Dubai',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,'SUN CITY HYPER MKT-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,'Super Star Grocery - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(175,'TAIBA SUPER MARKET-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(176,'TRANS GROCERY - ABU DHABI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(177,'Vally Corner Grocery - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(178,'Wafa Al Madinah Sm Dubai',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,'ZAHART BAGHDAD SM-AJMAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,'Zeeba SM - Abu Dhabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,'SUPER BONANZA HYPER MARKET - DUBAI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,'SUPER BONANZA HYPER MARKET - SHARJAH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,'Al Ghail Super Market LLC -RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,'AL MADINAH Hyper Market -Ras Al Khaor -Duabi',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(185,'Church- Ras Al Khaimah',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(186,'GULF EXPRESS SUPER MARKET - RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(187,'GULF HYPER MARKET-RAK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,'IBAN SUPERMARKET - RAK (Credit Sale)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(189,'INDIAN SCHOOL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(190,'KENZ Hyper Market -Ajman',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'KERALA SUPER MARKET',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'','','','',NULL,NULL,NULL,NULL,NULL),(193,'','','','',NULL,NULL,NULL,NULL,NULL),(194,'dsfdsf','','312312123123','',NULL,NULL,NULL,NULL,NULL),(195,'fjjdd','fjfhjf','877979','fjjddjjdj',NULL,NULL,NULL,6,'fddfjj'),(196,'kbhbuv','jbjvvh','58858','hccg',NULL,NULL,NULL,1,'yccyc'),(197,'bghng','fghfg','34434','fghfg',NULL,NULL,NULL,1,'fghfgfgh'),(198,'uvuv','ycyc','885858','hchHg',NULL,NULL,NULL,8,'hcgchc'),(199,'kjhkhj','kjhikjh','9996456','lkjhjikh',NULL,NULL,NULL,6,'5454'),(200,'dfg','dfg','334','dfg',NULL,NULL,NULL,0,'dfg');
  325. /*!40000 ALTER TABLE `tbl_inv_customer` ENABLE KEYS */;
  326. UNLOCK TABLES;
  327.  
  328. --
  329. -- Table structure for table `tbl_inv_item_master`
  330. --
  331.  
  332. DROP TABLE IF EXISTS `tbl_inv_item_master`;
  333. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  334. /*!40101 SET character_set_client = utf8 */;
  335. CREATE TABLE `tbl_inv_item_master` (
  336.   `ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  337.   `ITEM_NAME` varchar(45) DEFAULT NULL,
  338.   `ITEM_CATEGORY_ID` int(11) DEFAULT NULL,
  339.   `ITEM_UNIT_ID` int(11) DEFAULT NULL,
  340.   `ITEM_HEAD_ID` int(11) DEFAULT '0',
  341.   PRIMARY KEY (`ITEM_ID`)
  342. ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
  343. /*!40101 SET character_set_client = @saved_cs_client */;
  344.  
  345. --
  346. -- Dumping data for table `tbl_inv_item_master`
  347. --
  348.  
  349. LOCK TABLES `tbl_inv_item_master` WRITE;
  350. /*!40000 ALTER TABLE `tbl_inv_item_master` DISABLE KEYS */;
  351. INSERT INTO `tbl_inv_item_master` VALUES (1,'Maida',1,1,102),(2,'Rice powder achappam ',1,1,102),(3,'Sugar',4,1,93),(4,'white jeera',4,1,93),(5,'Black jeera',4,1,93),(6,'seasame black',3,3,93),(7,'Egg',4,5,93),(8,'salt',4,1,93),(9,'vegitable oil ',2,3,93),(10,'Coconut',4,1,93),(11,'Jagggri',4,1,93),(12,'Cardamon powder',4,1,93),(13,'Rice powder (rice ball)',1,1,102),(14,'Peanut',4,1,93),(15,'chocobrown colour ',3,3,93),(16,'Baking soda',4,1,93),(17,'Rawa     ',1,1,93),(18,'sugar powder',4,1,93),(19,'Yelllow colour',3,3,93),(20,'Double spoon gee',2,3,93),(21,'Basen',4,1,93),(22,'Kissmiss',4,1,93),(23,'Atta',1,1,93),(24,'Banana',4,1,93),(25,'Badam ',4,1,93),(26,'Rice powder neyyappam',4,1,102),(27,'laddu box ',5,4,328),(28,'RICE BALL BOX 1 x 9 black container 185x128x4',5,5,328),(29,'pvc cling film 30cmx1500',5,4,93),(30,'ZATAR CROISSANT - CROISSANT PLASTIC COVER',5,5,328),(31,' Cakes Form tray 216x152x20mm - white 031W13M',5,5,328),(32,'ACHAPPAM clear plastry box 180x90x70 05P10H65',5,5,328),(33,'KHAJA Form tray 167x129x25mm 031WPTI',5,5,328),(34,'RAWA CAKES - Cakes & muffins ',0,5,328),(35,'UNNIYAPPAM -  BOX 1 x 9 ',0,5,328),(36,'ACHAPPAM - Box 1 * 10',0,5,328),(37,'ASS. SLICED CAKES - CAKE -Pastric Clear confe',0,5,328),(38,'KHAJA - PVC Box 1 * 10',0,5,328),(39,'BISCUITS - Box ( 1 * 6 )',0,5,328),(40,'KHAJA - PVC BOX 1 X 6',0,5,328),(41,'RICE BALL - PVC BOX 1 X 6',0,5,328),(42,'GULAB JAMMU - PVC BOX-1X9',0,5,328),(43,'RAWA CAKES - PVC BOX 1 X 6',0,5,328),(44,'MILK BREAD - BOX 1 X 10',0,5,328),(45,'RICE BALL - BOX 219x90x43',0,5,328),(46,'RASAGULA',6,5,331),(47,'JILEBI',6,5,331),(48,'MYSORE PAAK',6,5,331),(49,'PEDA',6,5,331),(50,'MILK LADDU',6,5,331),(51,'LADDU (gms)',6,5,331),(52,'100 LBS L.P.G',4,5,93),(53,'JILEBI - BOX ( 1 * 6 ) ',0,5,328),(54,'RAWA CAKES - PASTRY BOX',0,5,328),(55,'Green Jam ',4,1,93),(56,'Red Jam ',4,5,93),(57,'kozhallappam ',6,5,331),(58,'Improver ',4,1,93),(59,'Tottyfruitty ',4,1,93),(60,'Pink colour',3,3,93),(61,'Instant Yeast',4,1,93),(62,'RASGULLAS - Rasagulla',0,5,331),(63,'RASGULLAS - BOX ( 1 * 10 )',0,5,102),(64,'ACHAPPAM - BOX ( 1 * 5 )',0,5,102),(65,'NEYYAPPAM - BOX ( 1 * 6 )',0,5,328),(66,'UNNIYAPPAM - BOX ( 1 * 8 )',0,5,102),(67,'BISCUITS - BOX ( 1 * 10 )',0,5,102),(68,'KHAJA - BOX ( 1 * 8 )',0,5,93),(69,'MILK BREAD - Small',0,5,328),(70,'MILK BREAD - Big',0,5,102),(71,'CUP CAKES - BOX ( 1 * 10 )',0,5,328);
  352. /*!40000 ALTER TABLE `tbl_inv_item_master` ENABLE KEYS */;
  353. UNLOCK TABLES;
  354.  
  355. --
  356. -- Table structure for table `tbl_inv_mini_stock`
  357. --
  358.  
  359. DROP TABLE IF EXISTS `tbl_inv_mini_stock`;
  360. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  361. /*!40101 SET character_set_client = utf8 */;
  362. CREATE TABLE `tbl_inv_mini_stock` (
  363.   `MINI_ID` int(11) NOT NULL AUTO_INCREMENT,
  364.   `MINI_DATE` date DEFAULT NULL,
  365.   `MINI_QTY` double DEFAULT NULL,
  366.   `MINI_LOCATION_ID` int(11) DEFAULT NULL,
  367.   `MINI_STATUS` varchar(1) DEFAULT 'Y',
  368.   `MINI_PACKET_MASTER_ID` int(11) DEFAULT NULL,
  369.   `MINI_MOVE_ID` int(11) DEFAULT '0',
  370.   `MINI_MOVE_TYPE` varchar(1) DEFAULT 'C',
  371.   PRIMARY KEY (`MINI_ID`)
  372. ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
  373. /*!40101 SET character_set_client = @saved_cs_client */;
  374.  
  375. --
  376. -- Dumping data for table `tbl_inv_mini_stock`
  377. --
  378.  
  379. LOCK TABLES `tbl_inv_mini_stock` WRITE;
  380. /*!40000 ALTER TABLE `tbl_inv_mini_stock` DISABLE KEYS */;
  381. INSERT INTO `tbl_inv_mini_stock` VALUES (1,'2017-04-03',100,1,'Y',1,0,'C'),(2,'2017-04-03',200,1,'Y',2,0,'C'),(3,'2017-04-03',150,1,'Y',3,0,'C'),(4,'2017-04-03',225,1,'Y',3,0,'C'),(5,'2017-04-03',225,1,'Y',5,0,'C'),(6,'2017-04-03',225,1,'Y',6,0,'C'),(7,'2017-04-20',55,1,'Y',1,0,'C'),(8,'2017-04-20',48,2,'Y',1,0,'C'),(9,'2017-04-20',-48,1,'Y',1,8,'M'),(10,'2017-04-22',23,2,'Y',2,0,'C'),(11,'2017-04-22',-23,1,'Y',2,10,'M'),(12,'2017-04-22',1654,1,'Y',1,0,'C'),(13,'2017-04-22',432,1,'Y',2,0,'C'),(14,'2017-04-22',674,1,'Y',3,0,'C'),(15,'2017-04-22',654,1,'Y',4,0,'C'),(16,'2017-04-22',795,1,'Y',6,0,'C'),(17,'2017-04-22',450,1,'Y',1,0,'C'),(18,'1969-12-31',250,2,'Y',3,0,'C'),(19,'1969-12-31',-250,1,'Y',3,18,'M'),(20,'2017-05-06',567,1,'Y',2,0,'C'),(21,'2017-05-06',10,2,'Y',3,0,'C'),(22,'2017-05-06',-10,1,'Y',3,21,'M');
  382. /*!40000 ALTER TABLE `tbl_inv_mini_stock` ENABLE KEYS */;
  383. UNLOCK TABLES;
  384.  
  385. --
  386. -- Table structure for table `tbl_inv_mini_stock_location`
  387. --
  388.  
  389. DROP TABLE IF EXISTS `tbl_inv_mini_stock_location`;
  390. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  391. /*!40101 SET character_set_client = utf8 */;
  392. CREATE TABLE `tbl_inv_mini_stock_location` (
  393.   `MINIL_ID` int(11) NOT NULL AUTO_INCREMENT,
  394.   `MINIL_NAME` varchar(45) DEFAULT NULL,
  395.   `MINIL_SALESMAN_ID` int(11) NOT NULL,
  396.   PRIMARY KEY (`MINIL_ID`)
  397. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  398. /*!40101 SET character_set_client = @saved_cs_client */;
  399.  
  400. --
  401. -- Dumping data for table `tbl_inv_mini_stock_location`
  402. --
  403.  
  404. LOCK TABLES `tbl_inv_mini_stock_location` WRITE;
  405. /*!40000 ALTER TABLE `tbl_inv_mini_stock_location` DISABLE KEYS */;
  406. INSERT INTO `tbl_inv_mini_stock_location` VALUES (1,'van 3',1),(2,'VAN 2',2),(3,'van 3',2),(4,'hvugh7',2),(5,'hvvhvhHh',2),(6,'GcgcfGfxfc',2),(7,'rssggdgggdfgfdf',18),(8,'VAN 2',8),(9,'gsgg',15),(10,'grf',6),(11,'hHhHv',6),(12,'gegdgddh',18),(13,'fg',15),(14,'dsg',6);
  407. /*!40000 ALTER TABLE `tbl_inv_mini_stock_location` ENABLE KEYS */;
  408. UNLOCK TABLES;
  409.  
  410. --
  411. -- Table structure for table `tbl_inv_packed_stock`
  412. --
  413.  
  414. DROP TABLE IF EXISTS `tbl_inv_packed_stock`;
  415. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  416. /*!40101 SET character_set_client = utf8 */;
  417. CREATE TABLE `tbl_inv_packed_stock` (
  418.   `PACK_ID` int(11) NOT NULL AUTO_INCREMENT,
  419.   `PACK_MASTER_ID` int(11) DEFAULT NULL,
  420.   `PACK_DATE` date DEFAULT NULL,
  421.   `PACK_QTY` double DEFAULT NULL,
  422.   `PACK_TYPE` char(1) NOT NULL DEFAULT 'P',
  423.   PRIMARY KEY (`PACK_ID`)
  424. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  425. /*!40101 SET character_set_client = @saved_cs_client */;
  426.  
  427. --
  428. -- Dumping data for table `tbl_inv_packed_stock`
  429. --
  430.  
  431. LOCK TABLES `tbl_inv_packed_stock` WRITE;
  432. /*!40000 ALTER TABLE `tbl_inv_packed_stock` DISABLE KEYS */;
  433. INSERT INTO `tbl_inv_packed_stock` VALUES (1,1,'2017-02-28',3,'P'),(2,7,'2017-02-28',1,'P'),(3,6,'2017-02-28',2,'P'),(4,1,'2017-02-28',1,'P'),(5,1,'2017-02-28',1,'P'),(6,0,'2017-04-03',10,'P');
  434. /*!40000 ALTER TABLE `tbl_inv_packed_stock` ENABLE KEYS */;
  435. UNLOCK TABLES;
  436.  
  437. --
  438. -- Table structure for table `tbl_inv_packet_master`
  439. --
  440.  
  441. DROP TABLE IF EXISTS `tbl_inv_packet_master`;
  442. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  443. /*!40101 SET character_set_client = utf8 */;
  444. CREATE TABLE `tbl_inv_packet_master` (
  445.   `PACKET_ID` int(11) NOT NULL AUTO_INCREMENT,
  446.   `PACKET_NAME` varchar(255) NOT NULL,
  447.   `PACKET_PRODUCT_ID` int(11) NOT NULL,
  448.   `PACKET_QTY` int(11) NOT NULL,
  449.   `PACKET_HEAD_ID` bigint(20) NOT NULL,
  450.   `PACKET_ITEM_NO` varchar(50) NOT NULL,
  451.   `PACKET_PRICE` double NOT NULL,
  452.   `PACKET_STATUS` char(1) NOT NULL DEFAULT 'N',
  453.   PRIMARY KEY (`PACKET_ID`)
  454. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  455. /*!40101 SET character_set_client = @saved_cs_client */;
  456.  
  457. --
  458. -- Dumping data for table `tbl_inv_packet_master`
  459. --
  460.  
  461. LOCK TABLES `tbl_inv_packet_master` WRITE;
  462. /*!40000 ALTER TABLE `tbl_inv_packet_master` DISABLE KEYS */;
  463. INSERT INTO `tbl_inv_packet_master` VALUES (1,'BOX ( 1 * 10 )',17,10,102,'63',1.5,'N'),(2,'BOX ( 1 * 5 )',1,5,102,'64',2,'N'),(3,'BOX ( 1 * 6 )',2,6,328,'65',2,'N'),(4,'BOX ( 1 * 8 )',3,8,102,'66',3,'N'),(5,'BOX ( 1 * 10 )',5,10,102,'67',3.5,'N'),(6,'BOX ( 1 * 8 )',4,8,93,'68',4,'N'),(7,'Small',15,15,328,'69',4.25,'N'),(8,'Big',15,30,102,'70',7,'N'),(9,'BOX ( 1 * 10 )',24,10,328,'71',12,'N'),(10,'free',31,0,0,'',4500,'N'),(11,'piece',33,0,0,'',250,'N'),(12,'box',1,0,0,'',13,'N'),(13,'uug',34,0,0,'',5,'N'),(14,'dsfdsf',1,0,0,'',34,'N'),(15,'dfg',1,0,0,'',23,'N');
  464. /*!40000 ALTER TABLE `tbl_inv_packet_master` ENABLE KEYS */;
  465. UNLOCK TABLES;
  466.  
  467. --
  468. -- Table structure for table `tbl_inv_packet_raw_materials`
  469. --
  470.  
  471. DROP TABLE IF EXISTS `tbl_inv_packet_raw_materials`;
  472. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  473. /*!40101 SET character_set_client = utf8 */;
  474. CREATE TABLE `tbl_inv_packet_raw_materials` (
  475.   `PRAW_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  476.   `PRAW_ITEM_ID` int(11) NOT NULL,
  477.   `PRAW_QTY` double NOT NULL,
  478.   `PRAW_PACKING_ID` int(11) NOT NULL,
  479.   PRIMARY KEY (`PRAW_ID`)
  480. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  481. /*!40101 SET character_set_client = @saved_cs_client */;
  482.  
  483. --
  484. -- Dumping data for table `tbl_inv_packet_raw_materials`
  485. --
  486.  
  487. LOCK TABLES `tbl_inv_packet_raw_materials` WRITE;
  488. /*!40000 ALTER TABLE `tbl_inv_packet_raw_materials` DISABLE KEYS */;
  489. /*!40000 ALTER TABLE `tbl_inv_packet_raw_materials` ENABLE KEYS */;
  490. UNLOCK TABLES;
  491.  
  492. --
  493. -- Table structure for table `tbl_inv_product`
  494. --
  495.  
  496. DROP TABLE IF EXISTS `tbl_inv_product`;
  497. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  498. /*!40101 SET character_set_client = utf8 */;
  499. CREATE TABLE `tbl_inv_product` (
  500.   `PROD_ID` int(11) NOT NULL AUTO_INCREMENT,
  501.   `PROD_NAME` varchar(255) NOT NULL,
  502.   `PROD_UNIT_ID` int(11) NOT NULL,
  503.   `PROD_PRICE` double NOT NULL,
  504.   `PROD_HEAD_ID` int(11) DEFAULT NULL,
  505.   `PROD_IMAGE` varchar(500) NOT NULL,
  506.   PRIMARY KEY (`PROD_ID`)
  507. ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
  508. /*!40101 SET character_set_client = @saved_cs_client */;
  509.  
  510. --
  511. -- Dumping data for table `tbl_inv_product`
  512. --
  513.  
  514. LOCK TABLES `tbl_inv_product` WRITE;
  515. /*!40000 ALTER TABLE `tbl_inv_product` DISABLE KEYS */;
  516. INSERT INTO `tbl_inv_product` VALUES (1,'ACHAPPAM',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/achappam.jpg'),(2,'NEYYAPPAM',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/neyyappam.jpg'),(3,'UNNIYAPPAM',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/unniyappam.jpg'),(4,'KHAJA',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/khaja.jpg'),(5,'BISCUITS',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/biscuits.jpg'),(6,'RAWA CAKES',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/rawacake.jpg'),(7,'KUZHALAPPAM',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/kuzhalappam.jpg'),(15,'MILK BREAD',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/bread.jpg'),(16,'GULAB JAMMU',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/gulab.jpg'),(17,'RASGULLAS',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/rasagulla.jpg'),(19,'JILEBI',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/jilebi.jpg'),(22,'MYSORE PAAK',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/mysorepack.jpg'),(23,'SWEET SAMOSA',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/samosa.jpg'),(24,'CUP CAKES',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/cupcake.jpg'),(30,'RICE BALL',5,1,96,'http://www.voywing.com/demo_erp/uploads/product/riceball.jpg'),(31,'Bosch chair',5,0,NULL,'a33ecbcd458de2042a5703febab88580.jpg'),(32,'fogg',5,0,NULL,'a74a47e2fbc7ea5923e4629f004b3551.jpg'),(33,'fogg marko',5,0,NULL,'4d263e4357eaacb6394b40a1f256a2c7.jpg'),(34,'fgg',5,0,NULL,''),(35,'ass',1,0,NULL,'8c70b94ce88e484a24c49c56b97665e2.jpg');
  517. /*!40000 ALTER TABLE `tbl_inv_product` ENABLE KEYS */;
  518. UNLOCK TABLES;
  519.  
  520. --
  521. -- Table structure for table `tbl_inv_product_price_master`
  522. --
  523.  
  524. DROP TABLE IF EXISTS `tbl_inv_product_price_master`;
  525. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  526. /*!40101 SET character_set_client = utf8 */;
  527. CREATE TABLE `tbl_inv_product_price_master` (
  528.   `PRICEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  529.   `PRICEM_NAME` varchar(45) DEFAULT NULL,
  530.   PRIMARY KEY (`PRICEM_ID`)
  531. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  532. /*!40101 SET character_set_client = @saved_cs_client */;
  533.  
  534. --
  535. -- Dumping data for table `tbl_inv_product_price_master`
  536. --
  537.  
  538. LOCK TABLES `tbl_inv_product_price_master` WRITE;
  539. /*!40000 ALTER TABLE `tbl_inv_product_price_master` DISABLE KEYS */;
  540. INSERT INTO `tbl_inv_product_price_master` VALUES (1,'lulu abu dhabi price list'),(2,'normal price list'),(3,'PRICE LIST 3');
  541. /*!40000 ALTER TABLE `tbl_inv_product_price_master` ENABLE KEYS */;
  542. UNLOCK TABLES;
  543.  
  544. --
  545. -- Table structure for table `tbl_inv_product_price_master_items`
  546. --
  547.  
  548. DROP TABLE IF EXISTS `tbl_inv_product_price_master_items`;
  549. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  550. /*!40101 SET character_set_client = utf8 */;
  551. CREATE TABLE `tbl_inv_product_price_master_items` (
  552.   `PRICEIT_ID` int(11) NOT NULL AUTO_INCREMENT,
  553.   `PRICEIT_PACKET_MASTER_ID` int(11) DEFAULT NULL,
  554.   `PRICEIT_PRICE` double DEFAULT NULL,
  555.   `PRICEIT_MASTER_ID` int(11) DEFAULT NULL,
  556.   PRIMARY KEY (`PRICEIT_ID`)
  557. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
  558. /*!40101 SET character_set_client = @saved_cs_client */;
  559.  
  560. --
  561. -- Dumping data for table `tbl_inv_product_price_master_items`
  562. --
  563.  
  564. LOCK TABLES `tbl_inv_product_price_master_items` WRITE;
  565. /*!40000 ALTER TABLE `tbl_inv_product_price_master_items` DISABLE KEYS */;
  566. INSERT INTO `tbl_inv_product_price_master_items` VALUES (10,1,4.5,3),(11,2,3.25,3),(12,3,3.25,3),(13,6,3.25,3),(24,1,4.25,2),(25,2,3,2),(26,3,3,2),(27,6,3,2),(28,4,3.25,1),(29,1,4,1),(30,7,4.5,1);
  567. /*!40000 ALTER TABLE `tbl_inv_product_price_master_items` ENABLE KEYS */;
  568. UNLOCK TABLES;
  569.  
  570. --
  571. -- Table structure for table `tbl_inv_product_pricing`
  572. --
  573.  
  574. DROP TABLE IF EXISTS `tbl_inv_product_pricing`;
  575. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  576. /*!40101 SET character_set_client = utf8 */;
  577. CREATE TABLE `tbl_inv_product_pricing` (
  578.   `PRICE_ID` int(11) NOT NULL AUTO_INCREMENT,
  579.   `PRICE_CUSTOMER_ID` int(11) DEFAULT NULL,
  580.   `PRICE_PRODUCT_ID` int(11) DEFAULT NULL,
  581.   `PRICE_AMOUNT` double DEFAULT NULL,
  582.   PRIMARY KEY (`PRICE_ID`)
  583. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  584. /*!40101 SET character_set_client = @saved_cs_client */;
  585.  
  586. --
  587. -- Dumping data for table `tbl_inv_product_pricing`
  588. --
  589.  
  590. LOCK TABLES `tbl_inv_product_pricing` WRITE;
  591. /*!40000 ALTER TABLE `tbl_inv_product_pricing` DISABLE KEYS */;
  592. /*!40000 ALTER TABLE `tbl_inv_product_pricing` ENABLE KEYS */;
  593. UNLOCK TABLES;
  594.  
  595. --
  596. -- Table structure for table `tbl_inv_production`
  597. --
  598.  
  599. DROP TABLE IF EXISTS `tbl_inv_production`;
  600. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  601. /*!40101 SET character_set_client = utf8 */;
  602. CREATE TABLE `tbl_inv_production` (
  603.   `PRODU_ID` int(11) NOT NULL AUTO_INCREMENT,
  604.   `PRODU_DATE` date DEFAULT NULL,
  605.   `PRODU_PRODUCT_ID` int(11) DEFAULT NULL,
  606.   `PRODU_QTY` double DEFAULT NULL,
  607.   `P_STATUS` varchar(1) DEFAULT 'U',
  608.   PRIMARY KEY (`PRODU_ID`)
  609. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  610. /*!40101 SET character_set_client = @saved_cs_client */;
  611.  
  612. --
  613. -- Dumping data for table `tbl_inv_production`
  614. --
  615.  
  616. LOCK TABLES `tbl_inv_production` WRITE;
  617. /*!40000 ALTER TABLE `tbl_inv_production` DISABLE KEYS */;
  618. INSERT INTO `tbl_inv_production` VALUES (1,'2017-04-03',17,125,'D'),(2,'2017-04-03',1,10,'D'),(3,'2017-04-03',3,450,'D'),(4,'2017-04-03',4,250,'D'),(5,'2017-04-03',5,300,'D'),(6,'2017-04-03',15,2500,'D');
  619. /*!40000 ALTER TABLE `tbl_inv_production` ENABLE KEYS */;
  620. UNLOCK TABLES;
  621.  
  622. --
  623. -- Table structure for table `tbl_inv_production_items`
  624. --
  625.  
  626. DROP TABLE IF EXISTS `tbl_inv_production_items`;
  627. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  628. /*!40101 SET character_set_client = utf8 */;
  629. CREATE TABLE `tbl_inv_production_items` (
  630.   `P_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  631.   `P_ITEM_QTY` double DEFAULT NULL,
  632.   `P_ITEM_MASTR_ID` int(11) DEFAULT NULL,
  633.   `P_PRODUCTION_ID` int(11) DEFAULT NULL,
  634.   PRIMARY KEY (`P_ITEM_ID`)
  635. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
  636. /*!40101 SET character_set_client = @saved_cs_client */;
  637.  
  638. --
  639. -- Dumping data for table `tbl_inv_production_items`
  640. --
  641.  
  642. LOCK TABLES `tbl_inv_production_items` WRITE;
  643. /*!40000 ALTER TABLE `tbl_inv_production_items` DISABLE KEYS */;
  644. INSERT INTO `tbl_inv_production_items` VALUES (1,3,4,1),(2,2,6,1),(3,1,5,1),(4,5,6,2),(5,45,6,3),(6,1,6,4),(7,100,3,5),(8,200,1,5),(9,1,5,6);
  645. /*!40000 ALTER TABLE `tbl_inv_production_items` ENABLE KEYS */;
  646. UNLOCK TABLES;
  647.  
  648. --
  649. -- Table structure for table `tbl_inv_production_stock`
  650. --
  651.  
  652. DROP TABLE IF EXISTS `tbl_inv_production_stock`;
  653. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  654. /*!40101 SET character_set_client = utf8 */;
  655. CREATE TABLE `tbl_inv_production_stock` (
  656.   `STOCK_ID` int(11) NOT NULL AUTO_INCREMENT,
  657.   `STOCK_PRODUCTION_ID` int(11) DEFAULT NULL,
  658.   `STOCK_PRODUCT_ID` int(11) DEFAULT NULL,
  659.   `STOCK_QTY` double DEFAULT NULL,
  660.   PRIMARY KEY (`STOCK_ID`)
  661. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  662. /*!40101 SET character_set_client = @saved_cs_client */;
  663.  
  664. --
  665. -- Dumping data for table `tbl_inv_production_stock`
  666. --
  667.  
  668. LOCK TABLES `tbl_inv_production_stock` WRITE;
  669. /*!40000 ALTER TABLE `tbl_inv_production_stock` DISABLE KEYS */;
  670. INSERT INTO `tbl_inv_production_stock` VALUES (1,1,17,125),(2,2,1,10),(3,3,3,450),(4,4,4,250),(5,5,5,300),(6,6,15,2500);
  671. /*!40000 ALTER TABLE `tbl_inv_production_stock` ENABLE KEYS */;
  672. UNLOCK TABLES;
  673.  
  674. --
  675. -- Table structure for table `tbl_inv_purchase_invoice`
  676. --
  677.  
  678. DROP TABLE IF EXISTS `tbl_inv_purchase_invoice`;
  679. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  680. /*!40101 SET character_set_client = utf8 */;
  681. CREATE TABLE `tbl_inv_purchase_invoice` (
  682.   `INV_ID` int(11) NOT NULL AUTO_INCREMENT,
  683.   `INV_ORDER_NUMBER` int(11) DEFAULT NULL,
  684.   `INV_DATE` date DEFAULT NULL,
  685.   `INV_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  686.   `INV_SUPPLIER_ID` int(11) DEFAULT NULL,
  687.   `INV_REMARKS` varchar(300) DEFAULT NULL,
  688.   `INV_INV_NUMBER` varchar(45) DEFAULT NULL,
  689.   PRIMARY KEY (`INV_ID`)
  690. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
  691. /*!40101 SET character_set_client = @saved_cs_client */;
  692.  
  693. --
  694. -- Dumping data for table `tbl_inv_purchase_invoice`
  695. --
  696.  
  697. LOCK TABLES `tbl_inv_purchase_invoice` WRITE;
  698. /*!40000 ALTER TABLE `tbl_inv_purchase_invoice` DISABLE KEYS */;
  699. INSERT INTO `tbl_inv_purchase_invoice` VALUES (2,1,'2017-03-01','2017-03-08 18:18:05',1,'','0214'),(3,3,'2017-03-01','2017-03-08 23:12:34',2,'','1417820'),(4,3,'2017-03-01','2017-03-19 19:56:29',2,'','1415291'),(5,4,'2017-03-02','2017-03-19 20:38:56',6,'discouond  0.35','09435'),(6,5,'2017-03-09','2017-03-20 17:52:30',6,'','09436'),(7,6,'2017-03-03','2017-03-20 18:57:48',15,'','1282'),(8,7,'2017-03-07','2017-03-20 18:58:30',15,'','1293'),(9,8,'2017-03-03','2017-03-20 19:03:51',15,'','1284'),(10,10,'2017-03-02','2017-03-20 19:10:11',15,'','1281'),(11,9,'2017-03-13','2017-03-20 19:11:02',15,'','1307'),(12,11,'2017-03-11','2017-03-21 18:43:38',18,'','6026121294'),(13,12,'2017-03-07','2017-03-21 18:44:16',18,'','6026120931'),(14,18,'2017-03-10','2017-03-21 19:32:59',10,'','54627'),(15,17,'2017-03-04','2017-03-21 19:33:40',10,'','54338'),(16,16,'2017-03-09','2017-03-21 19:34:25',10,'','54616'),(17,15,'2017-03-06','2017-03-21 19:35:07',10,'','54345'),(18,14,'2017-03-03','2017-03-21 19:35:40',10,'','54333'),(19,13,'2017-03-02','2017-03-21 19:36:17',10,'','54326'),(20,22,'2017-03-11','2017-03-21 20:41:29',2,'','1420091'),(21,21,'2017-03-12','2017-03-21 20:42:07',2,'TOTAL AMT -3900','1420600'),(22,20,'2017-03-08','2017-03-21 20:43:01',2,'','1418976/1'),(23,19,'2017-03-02','2017-03-21 20:43:54',2,'ITEM NO 4 AMOUNT 1500','1416010'),(24,25,'2017-03-13','2017-03-22 17:18:24',9,'','89866'),(25,24,'2017-03-05','2017-03-22 17:18:56',9,'','60959'),(26,26,'2017-03-01','2017-03-22 20:29:16',20,'total -2785','m/0868/17'),(27,27,'2017-03-01','2017-03-23 20:39:43',23,'total -215','18827'),(28,28,'2017-03-02','2017-03-23 20:40:38',23,'340\n','18837'),(29,29,'2017-03-01','2017-03-30 16:49:37',1,'NOT ACTUAL PURCHASE ....','222222'),(30,30,'2017-03-01','2017-03-30 20:09:58',1,'NOT ACTUAL PURCHASE','3333333');
  700. /*!40000 ALTER TABLE `tbl_inv_purchase_invoice` ENABLE KEYS */;
  701. UNLOCK TABLES;
  702.  
  703. --
  704. -- Table structure for table `tbl_inv_purchase_invoice_item`
  705. --
  706.  
  707. DROP TABLE IF EXISTS `tbl_inv_purchase_invoice_item`;
  708. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  709. /*!40101 SET character_set_client = utf8 */;
  710. CREATE TABLE `tbl_inv_purchase_invoice_item` (
  711.   `INV_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  712.   `INV_ITEM_INV_ID` int(11) DEFAULT NULL,
  713.   `INV_ITEM_UNIT_ID` int(11) DEFAULT NULL,
  714.   `INV_ITEM_QTY` double DEFAULT NULL,
  715.   `INV_ITEM_MASTER_ID` int(11) DEFAULT NULL,
  716.   `INV_ITEM_AMOUNT` double DEFAULT NULL,
  717.   PRIMARY KEY (`INV_ITEM_ID`)
  718. ) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;
  719. /*!40101 SET character_set_client = @saved_cs_client */;
  720.  
  721. --
  722. -- Dumping data for table `tbl_inv_purchase_invoice_item`
  723. --
  724.  
  725. LOCK TABLES `tbl_inv_purchase_invoice_item` WRITE;
  726. /*!40000 ALTER TABLE `tbl_inv_purchase_invoice_item` DISABLE KEYS */;
  727. INSERT INTO `tbl_inv_purchase_invoice_item` VALUES (1,2,NULL,80,23,2),(2,2,NULL,10,19,3.5),(3,3,NULL,5,27,110),(4,3,NULL,1,29,83),(5,4,NULL,30,27,130),(6,5,NULL,100,18,2.8),(7,5,NULL,245,2,2.43),(8,5,NULL,320,23,2),(9,5,NULL,50,21,1.88),(10,6,NULL,280,2,2.43),(11,6,NULL,400,23,2),(12,7,NULL,60,46,2),(13,8,NULL,100,46,2),(14,8,NULL,100,47,2),(15,8,NULL,100,48,2),(16,8,NULL,100,50,2),(17,8,NULL,100,49,2),(18,9,NULL,150,51,2),(19,9,NULL,150,46,2),(20,9,NULL,75,49,2),(21,9,NULL,50,50,2),(22,9,NULL,75,47,2),(23,9,NULL,75,48,2),(24,10,NULL,150,46,2),(25,10,NULL,100,47,2),(26,10,NULL,100,48,2),(27,10,NULL,75,49,2),(28,11,NULL,200,46,2),(29,11,NULL,100,47,2),(30,11,NULL,100,48,2),(31,11,NULL,100,49,2),(32,11,NULL,50,50,2),(33,12,NULL,900,9,3.2222),(34,13,NULL,900,9,3.222),(35,14,NULL,4,52,250),(36,15,NULL,3,52,250),(37,16,NULL,2,52,250),(38,17,NULL,2,52,250),(39,18,NULL,2,52,250),(40,19,NULL,3,52,250),(45,20,NULL,3,29,90),(46,21,NULL,10200,32,0.382),(47,22,NULL,500,39,0.54),(48,23,NULL,5000,31,0.08),(49,23,NULL,2500,38,0.062),(50,23,NULL,2000,28,0.42),(51,23,NULL,3500,54,0.428),(54,24,NULL,100,57,3),(55,25,NULL,100,57,3),(56,26,NULL,135,55,1.56),(57,26,NULL,135,56,1.56),(58,26,NULL,360,61,1.833),(59,26,NULL,225,16,3),(60,26,NULL,25,58,9),(61,26,NULL,96,59,2.6),(62,26,NULL,225,15,2.33),(63,26,NULL,1,60,30),(64,27,NULL,360,7,0.35),(65,27,NULL,24,24,3.75),(66,28,NULL,24,24,3.75),(67,28,NULL,720,7,0.348),(68,29,NULL,1000,1,1.6),(69,29,NULL,30,4,13),(70,29,NULL,500,3,2.6),(71,29,NULL,50,5,16),(72,29,NULL,15,8,0.5),(73,29,NULL,500,11,3.4),(74,29,NULL,35,12,2),(75,29,NULL,1000,13,2.25),(76,29,NULL,50,14,6.75),(77,29,NULL,500,17,2.75),(78,29,NULL,100,22,4),(79,29,NULL,100,25,39),(80,29,NULL,100,26,2.4),(81,29,NULL,200,6,19.5),(82,29,NULL,100,20,3.7),(83,30,NULL,500,10,8.8);
  728. /*!40000 ALTER TABLE `tbl_inv_purchase_invoice_item` ENABLE KEYS */;
  729. UNLOCK TABLES;
  730.  
  731. --
  732. -- Table structure for table `tbl_inv_purchase_order`
  733. --
  734.  
  735. DROP TABLE IF EXISTS `tbl_inv_purchase_order`;
  736. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  737. /*!40101 SET character_set_client = utf8 */;
  738. CREATE TABLE `tbl_inv_purchase_order` (
  739.   `ORDER_ID` int(11) NOT NULL AUTO_INCREMENT,
  740.   `ORDER_DATE` date DEFAULT NULL,
  741.   `ORDER_SUPPLIER_ID` int(11) DEFAULT NULL,
  742.   `ORDER_REMARKS` varchar(45) DEFAULT NULL,
  743.   `ORDER_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  744.   PRIMARY KEY (`ORDER_ID`)
  745. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
  746. /*!40101 SET character_set_client = @saved_cs_client */;
  747.  
  748. --
  749. -- Dumping data for table `tbl_inv_purchase_order`
  750. --
  751.  
  752. LOCK TABLES `tbl_inv_purchase_order` WRITE;
  753. /*!40000 ALTER TABLE `tbl_inv_purchase_order` DISABLE KEYS */;
  754. INSERT INTO `tbl_inv_purchase_order` VALUES (3,'2017-03-01',2,'','2017-03-08 23:11:02'),(4,'2017-03-01',6,'','2017-03-19 20:07:08'),(5,'2017-03-08',6,'','2017-03-19 20:29:28'),(6,'2017-03-06',15,'','2017-03-20 18:41:56'),(7,'2017-03-06',15,'','2017-03-20 18:55:16'),(8,'2017-03-03',15,'','2017-03-20 19:00:23'),(9,'2017-03-12',15,'','2017-03-20 19:04:13'),(10,'2017-03-01',15,'','2017-03-20 19:07:35'),(11,'2017-03-10',18,'','2017-03-21 18:38:30'),(12,'2017-03-06',18,'','2017-03-21 18:41:13'),(13,'2017-03-01',10,'','2017-03-21 18:58:17'),(14,'2017-03-02',10,'','2017-03-21 18:58:58'),(15,'2017-03-05',10,'','2017-03-21 18:59:33'),(16,'2017-03-09',10,'','2017-03-21 19:00:27'),(17,'2017-03-04',10,'','2017-03-21 19:01:19'),(18,'2017-03-09',10,'','2017-03-21 19:01:54'),(19,'2017-03-01',2,'ITEM NO 4 AMOUNT 1500','2017-03-21 20:28:59'),(20,'2017-03-01',2,'','2017-03-21 20:34:48'),(21,'2017-03-01',2,'TOTAL AMT -3900','2017-03-21 20:37:31'),(22,'2017-03-01',2,'','2017-03-21 20:39:46'),(24,'2017-03-13',9,'','2017-03-22 17:09:39'),(25,'2017-03-14',9,'','2017-03-22 17:11:03'),(26,'2017-03-01',20,'total -2785','2017-03-22 20:00:08'),(27,'2017-03-01',23,'total -215','2017-03-23 20:28:49'),(28,'2017-03-01',23,'340\n','2017-03-23 20:35:06'),(29,'2017-03-01',1,'NOT ACTUAL PURCHASE ....','2017-03-30 16:31:05'),(30,'2017-03-01',1,'NOT ACTUAL PURCHASE','2017-03-30 20:08:32'),(31,NULL,NULL,NULL,'2017-03-30 21:06:48');
  755. /*!40000 ALTER TABLE `tbl_inv_purchase_order` ENABLE KEYS */;
  756. UNLOCK TABLES;
  757.  
  758. --
  759. -- Table structure for table `tbl_inv_purchase_order_item`
  760. --
  761.  
  762. DROP TABLE IF EXISTS `tbl_inv_purchase_order_item`;
  763. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  764. /*!40101 SET character_set_client = utf8 */;
  765. CREATE TABLE `tbl_inv_purchase_order_item` (
  766.   `ITEM_O_ID` int(11) NOT NULL AUTO_INCREMENT,
  767.   `ITEM_O_ORDER_ID` int(11) NOT NULL,
  768.   `ITEM_O_QTY` double NOT NULL,
  769.   `ITEM_O_MASTER_ID` int(11) DEFAULT NULL,
  770.   `ITEM_O_UNIT_PRICE` double DEFAULT NULL,
  771.   `ITEM_O_STATUS` char(1) NOT NULL DEFAULT 'N',
  772.   PRIMARY KEY (`ITEM_O_ID`)
  773. ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1;
  774. /*!40101 SET character_set_client = @saved_cs_client */;
  775.  
  776. --
  777. -- Dumping data for table `tbl_inv_purchase_order_item`
  778. --
  779.  
  780. LOCK TABLES `tbl_inv_purchase_order_item` WRITE;
  781. /*!40000 ALTER TABLE `tbl_inv_purchase_order_item` DISABLE KEYS */;
  782. INSERT INTO `tbl_inv_purchase_order_item` VALUES (1,1,80,23,2,'N'),(2,1,10,19,3.5,'N'),(3,2,5,24,2,'N'),(4,3,5,27,110,'D'),(5,3,1,29,83,'N'),(6,4,100,18,2.8,'D'),(7,4,245,2,2.43,'D'),(8,4,320,23,2,'D'),(9,4,50,21,1.88,'D'),(10,5,280,2,2.43,'D'),(11,5,400,23,2,'D'),(12,6,100,46,2,'D'),(13,7,100,46,2,'D'),(14,7,100,47,2,'D'),(15,7,100,48,2,'D'),(16,7,100,50,2,'D'),(17,7,100,49,2,'D'),(18,8,150,51,2,'D'),(19,8,150,46,2,'D'),(20,8,75,49,2,'D'),(21,8,50,50,2,'D'),(22,8,75,47,2,'D'),(23,8,75,48,2,'D'),(24,9,200,46,2,'D'),(25,9,100,47,2,'D'),(26,9,100,48,2,'D'),(27,9,100,49,2,'D'),(28,9,50,50,2,'D'),(29,10,150,46,2,'D'),(30,10,100,47,2,'D'),(31,10,100,48,2,'D'),(32,10,75,49,2,'D'),(33,11,900,9,3.222222,'D'),(34,12,900,9,3.2222,'D'),(35,13,3,52,250,'D'),(36,14,2,52,250,'D'),(37,15,2,52,250,'D'),(38,16,2,52,250,'D'),(39,17,3,52,250,'D'),(40,18,4,52,250,'D'),(41,19,5000,31,0.08,'D'),(42,19,2500,38,0.062,'D'),(43,19,2000,28,0.42,'D'),(44,19,3500,54,0.428,'D'),(45,20,500,39,0.54,'D'),(46,21,10200,32,0.382,'D'),(47,22,3,29,90,'D'),(48,23,100,57,3,'N'),(49,24,100,57,3,'D'),(50,25,100,57,3,'D'),(51,26,135,55,1.56,'D'),(52,26,135,56,1.56,'D'),(53,26,360,61,1.833,'D'),(54,26,225,16,3,'D'),(55,26,25,58,9,'D'),(56,26,96,59,2.6,'D'),(57,26,225,15,2.33,'D'),(58,26,1,60,30,'D'),(59,27,360,7,0.35,'D'),(60,27,24,24,3.75,'D'),(61,28,24,24,3.75,'D'),(62,28,720,7,0.348,'D'),(63,29,1000,1,1.6,'D'),(64,29,30,4,13,'D'),(65,29,500,3,2.6,'D'),(66,29,50,5,16,'D'),(67,29,15,8,0.5,'D'),(68,29,500,11,3.4,'D'),(69,29,35,12,2,'D'),(70,29,1000,13,2.25,'D'),(71,29,50,14,6.75,'D'),(72,29,500,17,2.75,'D'),(73,29,100,22,4,'D'),(74,29,100,25,39,'D'),(75,29,100,26,2.4,'D'),(76,29,200,6,19.5,'D'),(77,29,100,20,3.7,'D'),(78,30,500,10,8.8,'D');
  783. /*!40000 ALTER TABLE `tbl_inv_purchase_order_item` ENABLE KEYS */;
  784. UNLOCK TABLES;
  785.  
  786. --
  787. -- Table structure for table `tbl_inv_route`
  788. --
  789.  
  790. DROP TABLE IF EXISTS `tbl_inv_route`;
  791. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  792. /*!40101 SET character_set_client = utf8 */;
  793. CREATE TABLE `tbl_inv_route` (
  794.   `ROUTE_ID` int(11) NOT NULL AUTO_INCREMENT,
  795.   `ROUTE_NAME` varchar(255) NOT NULL,
  796.   `ROUTE_LOCATION` varchar(400) NOT NULL,
  797.   `ROUTE_REMARKS` varchar(400) NOT NULL,
  798.   PRIMARY KEY (`ROUTE_ID`)
  799. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  800. /*!40101 SET character_set_client = @saved_cs_client */;
  801.  
  802. --
  803. -- Dumping data for table `tbl_inv_route`
  804. --
  805.  
  806. LOCK TABLES `tbl_inv_route` WRITE;
  807. /*!40000 ALTER TABLE `tbl_inv_route` DISABLE KEYS */;
  808. INSERT INTO `tbl_inv_route` VALUES (1,'Ras al Khaima- Rafi','Ras al Khaima','dfgdf'),(2,'Sharjha','sharjah','hfhrhhf'),(3,'Dubai - Abdul Rasheed','Dubai ',''),(4,'Abu Dhabi - Rizwan','Abu Dhabi',''),(5,'Abu Dhabi - Azhar','Abu Dhabi',''),(6,'Ras al Khaima- Jacob','Ras al Khaima',''),(7,'Dubai - Shareef','Dubai ',''),(8,'Ajman','Ajman',''),(9,'ikfjfk','jfjjfjd','cjfjf'),(10,'gxgcgc','ycgc','hchchc');
  809. /*!40000 ALTER TABLE `tbl_inv_route` ENABLE KEYS */;
  810. UNLOCK TABLES;
  811.  
  812. --
  813. -- Table structure for table `tbl_inv_sales_invoice`
  814. --
  815.  
  816. DROP TABLE IF EXISTS `tbl_inv_sales_invoice`;
  817. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  818. /*!40101 SET character_set_client = utf8 */;
  819. CREATE TABLE `tbl_inv_sales_invoice` (
  820.   `SALES_INVOICE_ID` int(11) NOT NULL AUTO_INCREMENT,
  821.   `SALES_DATE` date DEFAULT NULL,
  822.   `SALES_CUSTOMER_ID` int(11) DEFAULT NULL,
  823.   `SALES_MAN_ID` int(11) DEFAULT NULL,
  824.   `SALES_CREATED_ON` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  825.   `SALES_INVOICE_NUM` varchar(45) DEFAULT NULL,
  826.   `SALES_INVOICE_DATE` date DEFAULT NULL,
  827.   `SALES_ORDER_NUM` int(11) NOT NULL,
  828.   `SALES_TOTAL_AMOUNT` double DEFAULT '0',
  829.   `SALES_DISCOUNT` double DEFAULT '0',
  830.   `SALES_MINI_STORE_LOCATION_ID` int(11) DEFAULT '0',
  831.   `SALES_TYPE` char(1) NOT NULL DEFAULT 'S',
  832.   PRIMARY KEY (`SALES_INVOICE_ID`)
  833. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  834. /*!40101 SET character_set_client = @saved_cs_client */;
  835.  
  836. --
  837. -- Dumping data for table `tbl_inv_sales_invoice`
  838. --
  839.  
  840. LOCK TABLES `tbl_inv_sales_invoice` WRITE;
  841. /*!40000 ALTER TABLE `tbl_inv_sales_invoice` DISABLE KEYS */;
  842. /*!40000 ALTER TABLE `tbl_inv_sales_invoice` ENABLE KEYS */;
  843. UNLOCK TABLES;
  844.  
  845. --
  846. -- Table structure for table `tbl_inv_sales_invoice_item`
  847. --
  848.  
  849. DROP TABLE IF EXISTS `tbl_inv_sales_invoice_item`;
  850. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  851. /*!40101 SET character_set_client = utf8 */;
  852. CREATE TABLE `tbl_inv_sales_invoice_item` (
  853.   `SALES_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  854.   `SALES_PRODUCT_ID` int(11) DEFAULT NULL,
  855.   `SALES_QTY` double DEFAULT NULL,
  856.   `SALES_INVOICE_ID` int(11) DEFAULT NULL,
  857.   `SALES_AMOUNT` double DEFAULT NULL,
  858.   PRIMARY KEY (`SALES_ITEM_ID`)
  859. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  860. /*!40101 SET character_set_client = @saved_cs_client */;
  861.  
  862. --
  863. -- Dumping data for table `tbl_inv_sales_invoice_item`
  864. --
  865.  
  866. LOCK TABLES `tbl_inv_sales_invoice_item` WRITE;
  867. /*!40000 ALTER TABLE `tbl_inv_sales_invoice_item` DISABLE KEYS */;
  868. /*!40000 ALTER TABLE `tbl_inv_sales_invoice_item` ENABLE KEYS */;
  869. UNLOCK TABLES;
  870.  
  871. --
  872. -- Table structure for table `tbl_inv_sales_order`
  873. --
  874.  
  875. DROP TABLE IF EXISTS `tbl_inv_sales_order`;
  876. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  877. /*!40101 SET character_set_client = utf8 */;
  878. CREATE TABLE `tbl_inv_sales_order` (
  879.   `SALES_ORDER_ID` int(11) NOT NULL AUTO_INCREMENT,
  880.   `SALES_DATE` date DEFAULT NULL,
  881.   `SALES_CUSTOMER_ID` int(11) DEFAULT NULL,
  882.   `SALES_MAN_ID` int(11) DEFAULT NULL,
  883.   `SALES_ROUTE_ID` int(11) DEFAULT NULL,
  884.   `SALES_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  885.   PRIMARY KEY (`SALES_ORDER_ID`)
  886. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  887. /*!40101 SET character_set_client = @saved_cs_client */;
  888.  
  889. --
  890. -- Dumping data for table `tbl_inv_sales_order`
  891. --
  892.  
  893. LOCK TABLES `tbl_inv_sales_order` WRITE;
  894. /*!40000 ALTER TABLE `tbl_inv_sales_order` DISABLE KEYS */;
  895. INSERT INTO `tbl_inv_sales_order` VALUES (1,NULL,NULL,NULL,NULL,'2017-04-01 19:52:40');
  896. /*!40000 ALTER TABLE `tbl_inv_sales_order` ENABLE KEYS */;
  897. UNLOCK TABLES;
  898.  
  899. --
  900. -- Table structure for table `tbl_inv_sales_order_items`
  901. --
  902.  
  903. DROP TABLE IF EXISTS `tbl_inv_sales_order_items`;
  904. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  905. /*!40101 SET character_set_client = utf8 */;
  906. CREATE TABLE `tbl_inv_sales_order_items` (
  907.   `SL_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  908.   `SL_PACK_ID` int(11) NOT NULL,
  909.   `SL_QTY` double NOT NULL,
  910.   `SL_ORDER_ID` int(11) NOT NULL,
  911.   `SL_ORDER_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  912.   PRIMARY KEY (`SL_ITEM_ID`)
  913. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  914. /*!40101 SET character_set_client = @saved_cs_client */;
  915.  
  916. --
  917. -- Dumping data for table `tbl_inv_sales_order_items`
  918. --
  919.  
  920. LOCK TABLES `tbl_inv_sales_order_items` WRITE;
  921. /*!40000 ALTER TABLE `tbl_inv_sales_order_items` DISABLE KEYS */;
  922. INSERT INTO `tbl_inv_sales_order_items` VALUES (1,1,8,1,'N');
  923. /*!40000 ALTER TABLE `tbl_inv_sales_order_items` ENABLE KEYS */;
  924. UNLOCK TABLES;
  925.  
  926. --
  927. -- Table structure for table `tbl_inv_sales_return`
  928. --
  929.  
  930. DROP TABLE IF EXISTS `tbl_inv_sales_return`;
  931. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  932. /*!40101 SET character_set_client = utf8 */;
  933. CREATE TABLE `tbl_inv_sales_return` (
  934.   `RETURN_ID` int(11) NOT NULL AUTO_INCREMENT,
  935.   `RETURN_CUST_ID` int(11) DEFAULT NULL,
  936.   `RETURN_DATE` date DEFAULT NULL,
  937.   `RETURN_REMARKS` varchar(200) DEFAULT NULL,
  938.   `RETURN_SALES_MAN_ID` int(11) DEFAULT NULL,
  939.   `RETURN_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  940.   PRIMARY KEY (`RETURN_ID`)
  941. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  942. /*!40101 SET character_set_client = @saved_cs_client */;
  943.  
  944. --
  945. -- Dumping data for table `tbl_inv_sales_return`
  946. --
  947.  
  948. LOCK TABLES `tbl_inv_sales_return` WRITE;
  949. /*!40000 ALTER TABLE `tbl_inv_sales_return` DISABLE KEYS */;
  950. /*!40000 ALTER TABLE `tbl_inv_sales_return` ENABLE KEYS */;
  951. UNLOCK TABLES;
  952.  
  953. --
  954. -- Table structure for table `tbl_inv_sales_return_items`
  955. --
  956.  
  957. DROP TABLE IF EXISTS `tbl_inv_sales_return_items`;
  958. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  959. /*!40101 SET character_set_client = utf8 */;
  960. CREATE TABLE `tbl_inv_sales_return_items` (
  961.   `RETITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  962.   `RETITEM_PRODUCT_ID` int(11) DEFAULT NULL,
  963.   `RETITEM_QTY` double DEFAULT NULL,
  964.   `RETITEM_AMOUNT` double DEFAULT NULL,
  965.   `RETURN_F_ID` int(11) DEFAULT NULL,
  966.   PRIMARY KEY (`RETITEM_ID`)
  967. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  968. /*!40101 SET character_set_client = @saved_cs_client */;
  969.  
  970. --
  971. -- Dumping data for table `tbl_inv_sales_return_items`
  972. --
  973.  
  974. LOCK TABLES `tbl_inv_sales_return_items` WRITE;
  975. /*!40000 ALTER TABLE `tbl_inv_sales_return_items` DISABLE KEYS */;
  976. /*!40000 ALTER TABLE `tbl_inv_sales_return_items` ENABLE KEYS */;
  977. UNLOCK TABLES;
  978.  
  979. --
  980. -- Table structure for table `tbl_inv_salesman`
  981. --
  982.  
  983. DROP TABLE IF EXISTS `tbl_inv_salesman`;
  984. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  985. /*!40101 SET character_set_client = utf8 */;
  986. CREATE TABLE `tbl_inv_salesman` (
  987.   `MAN_ID` int(11) NOT NULL AUTO_INCREMENT,
  988.   `MAN_NAME` varchar(255) NOT NULL,
  989.   `MAN_ADDRESS` varchar(255) NOT NULL,
  990.   `MAN_PHONE` varchar(15) NOT NULL,
  991.   `MAN_MOBILE` varchar(15) NOT NULL,
  992.   `MAN_EMAIL` varchar(255) NOT NULL,
  993.   `MAN_ROUTE_ID` int(11) NOT NULL,
  994.   `MAN_ADDED_ON` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  995.   `MAN_PREFIX` varchar(3) DEFAULT NULL,
  996.   `MAN_IMAGE` varchar(400) DEFAULT 'user.png',
  997.   `MAN_DESIGNATION` varchar(45) DEFAULT NULL,
  998.   PRIMARY KEY (`MAN_ID`)
  999. ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
  1000. /*!40101 SET character_set_client = @saved_cs_client */;
  1001.  
  1002. --
  1003. -- Dumping data for table `tbl_inv_salesman`
  1004. --
  1005.  
  1006. LOCK TABLES `tbl_inv_salesman` WRITE;
  1007. /*!40000 ALTER TABLE `tbl_inv_salesman` DISABLE KEYS */;
  1008. INSERT INTO `tbl_inv_salesman` VALUES (1,'Mubashir ahmed','','','0551090667','mubashir@gmail.com',0,'2017-02-28 21:25:26',NULL,'5eeffc04af06978348f6ebea21559e3e.jpg','MARKETING EXECUTIVE'),(2,'Rafi',' ','','0529460893','Rafi@gmail.com',8,'2017-02-28 21:26:01',NULL,'f95dc03d5d0997c470674ea49ac7eaa8.jpg','MARKETING EXECUTIVE'),(3,'Shareef','','','0527421029','Shareef@gmail.com',7,'2017-02-28 21:29:50',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(4,'Rizwan','      ','','0528203415','Rizwan@gmail.com',4,'2017-03-06 22:22:36',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(5,'Jacob','','','0527419736','jacob@gmail.com',6,'2017-03-19 18:29:08',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(6,'Azhar','','','0561479750','azhar@gmail.com',5,'2017-03-19 18:32:54',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(7,'Shahzad','','','0556507417','SHAHAZAD@qmial.com',2,'2017-03-19 18:34:45',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(8,'Abdul Rasheed','','','0551090517','abdulrasheed@gmail.com',3,'2017-03-19 18:35:47',NULL,'2f119c17f3c4477d54ad82fc21f6e86d.jpg','MARKETING EXECUTIVE'),(35,'cjsjjd','','','fudififjf','fjdjjdjd',5,'2017-04-27 04:54:46',NULL,NULL,'fjfjjfjjfj'),(36,'gfribib','','','yfyf','7g6g',5,'2017-04-27 04:57:17',NULL,'0','biihuhu'),(37,'y33y43y','','','dhrrgrh','jdfhd',6,'2017-04-27 05:02:02',NULL,'user.png','tu4u4y3y3y'),(38,'fjdjcj','','','rjrjrjrj','gjfjjfjj',6,'2017-04-27 07:26:58',NULL,'user.png','vjfjffj'),(39,'dkddj','','','tjrjd','gfjdk',4,'2017-04-27 07:28:04',NULL,'user.png','fjjdjdjf'),(40,'chdjd','','','cjfj','fjfjdj',5,'2017-04-27 07:28:27',NULL,'user.png','rhrhfj'),(41,'fjfjj','','','fjfjfj','jfufii',5,'2017-04-27 07:32:26',NULL,'aaa26da1db2b04dc6898068268e3520c.jpg','djdjjj'),(42,'fjfhf','','','fjjfjf','fjfh',6,'2017-04-27 07:35:10',NULL,'504c867db290b56b59799424a651006f.jpg','jjrjf'),(43,'fjfjjf','','','fjfjfj','fjfjfj',6,'2017-04-27 07:35:22',NULL,'2619f72cd26af044fc9b76c8413d73b9.jpg','fnjfj'),(44,'grff','','','gfdf','hffgh',4,'2017-04-27 07:37:52',NULL,'2953d24cd23cc4f27985352ee617c84f.jpg','fddg'),(45,'yrgg','','','trrr','hrgg',6,'2017-04-27 07:38:07',NULL,'user.png','trrggg'),(46,'tet','','','frfgggg','grt',6,'2017-04-27 07:38:31',NULL,'user.png','grhhhhhhy'),(47,'yrr','','','yttt','hggg',7,'2017-04-27 07:39:00',NULL,'5a2bfbaa462198fddd88bd0039bbf401.jpg','trff'),(48,'h hcg','','','yfyc','hvvh',10,'2017-04-27 09:26:55',NULL,'459dbd3346b98e1ab490a3360c3b73c1.jpg','bgGvvy'),(49,'h hc','','','ycyc','hchc',9,'2017-04-27 09:27:08',NULL,'user.png','yfyfyf'),(50,'hcgcgcgc','','','bvhvvh','bchchv',2,'2017-04-28 05:10:51',NULL,'user.png','h gcch'),(53,'vuvuUu','','','uvhuU','uvuvub',5,'2017-04-28 05:54:27',NULL,'user.png','uvuub'),(55,'fjdj','','','fhdhj','cjdjjdj',8,'2017-04-28 05:55:02',NULL,'user.png','xxhhx'),(58,'fhdhdh','','','rhrhf','rhfhfh',7,'2017-04-28 05:58:18',NULL,'user.png','jhddj'),(59,'aqeeel','','','fjfjf','cjcjf',6,'2017-04-28 05:58:29',NULL,'user.png','dhddh'),(62,'cjdjxj','','','dhdhhd','fhdhdh',7,'2017-04-28 06:02:36',NULL,'user.png','fhfjfjf'),(64,'cbfbfbfb','','','xvdvdb','dbddb',7,'2017-04-28 06:04:14',NULL,'ad7e5dc05f1753e5a8d7174288cd2385.jpg','svddv'),(65,'saleeq','','','sall','saleeqvm',0,'2017-04-28 06:05:53',NULL,'828a1255b0e144cee2d2cff1d2d39689.jpg','djdjdj'),(66,'hchccg','','','hchyg','abc',9,'2017-04-28 06:35:49',NULL,'fa92fd3630ccc686faf1da21fbe68f0c.jpg','7ggyg'),(67,'fdjdj','','','fjffj','fjfjjf',0,'2017-05-03 05:48:20',NULL,'user.png','fjfj'),(68,'fghfg','','','fghfgh','fghfgh',0,'2017-05-06 09:07:35',NULL,'user.png','fghfgh');
  1009. /*!40000 ALTER TABLE `tbl_inv_salesman` ENABLE KEYS */;
  1010. UNLOCK TABLES;
  1011.  
  1012. --
  1013. -- Table structure for table `tbl_inv_supplier`
  1014. --
  1015.  
  1016. DROP TABLE IF EXISTS `tbl_inv_supplier`;
  1017. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1018. /*!40101 SET character_set_client = utf8 */;
  1019. CREATE TABLE `tbl_inv_supplier` (
  1020.   `SUPP_ID` int(11) NOT NULL AUTO_INCREMENT,
  1021.   `SUPP_NAME` varchar(45) DEFAULT NULL,
  1022.   `SUPP_ADDRESS` varchar(45) DEFAULT NULL,
  1023.   `SUPP_PHONE` varchar(45) DEFAULT NULL,
  1024.   `SUPP_EMAIL` varchar(45) DEFAULT NULL,
  1025.   `SUPP_LOCATION` varchar(45) DEFAULT NULL,
  1026.   `SUPP_COUNTRY_ID` int(11) DEFAULT NULL,
  1027.   PRIMARY KEY (`SUPP_ID`)
  1028. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
  1029. /*!40101 SET character_set_client = @saved_cs_client */;
  1030.  
  1031. --
  1032. -- Dumping data for table `tbl_inv_supplier`
  1033. --
  1034.  
  1035. LOCK TABLES `tbl_inv_supplier` WRITE;
  1036. /*!40000 ALTER TABLE `tbl_inv_supplier` DISABLE KEYS */;
  1037. INSERT INTO `tbl_inv_supplier` VALUES (1,'BIN ZAID FLOUR MILLS','bridge road','072334771','ggggg@gmil.in','rak',2),(2,'AL BAYADER INTERNATIONAL ','sharj\r\n','065340303','sharjah@gmsl.in','sharjh',2),(3,'AL BERWAZ PLASTIC FACTORY',NULL,NULL,NULL,NULL,2),(4,'AL HASNAA FOODSTUFF TRD.',NULL,NULL,NULL,NULL,2),(5,'AL HILAL CLEANING MATERIALS TRADING',NULL,NULL,NULL,NULL,2),(6,'AL LEWAA FLOUR MILL & FOOD STUFF TRD.',NULL,NULL,NULL,NULL,2),(7,'AL MAILEE DISTRIBUTION',NULL,NULL,NULL,NULL,2),(8,'AL MAWAKEB NUTS L.L.C',NULL,NULL,NULL,NULL,2),(9,'BEST BAKERY LLC',NULL,NULL,NULL,NULL,2),(10,'BROTHERS GAS',NULL,NULL,NULL,NULL,2),(11,'CITY PAK',NULL,NULL,NULL,NULL,2),(12,'FALCON PACK',NULL,NULL,NULL,NULL,2),(13,'FREETRADE INTERNATIONAL FZE',NULL,NULL,NULL,NULL,2),(14,'GHULAMI GENERAL TRADING LLC DUBAI',NULL,NULL,NULL,NULL,2),(15,'GREAT EMIRATES FOOD STUFF CATERING L.L.C',NULL,NULL,NULL,NULL,2),(16,'GRIPPO GROUP- RAK',NULL,NULL,NULL,NULL,2),(17,'HAROON LABELS INDUSTRIES L. L.C',NULL,NULL,NULL,NULL,2),(18,'IFFCO DISTRIBUTION SERVICE-DUBAI',NULL,NULL,NULL,NULL,2),(19,'MODERN GEN.TRD CO.',NULL,NULL,NULL,NULL,2),(20,'MUDRA GEN. TRD.',NULL,NULL,NULL,NULL,2),(21,'RAG FOOD STUFF TRD.L.L.C',NULL,NULL,NULL,NULL,2),(22,'SAFCO (SANWHEY FOOD STUFF TRD)',NULL,NULL,NULL,NULL,2),(23,'Al khair vegitable & fruits trading','al juwais rak','0552377356','','al juwais rak',2);
  1038. /*!40000 ALTER TABLE `tbl_inv_supplier` ENABLE KEYS */;
  1039. UNLOCK TABLES;
  1040.  
  1041. --
  1042. -- Table structure for table `tbl_inv_units`
  1043. --
  1044.  
  1045. DROP TABLE IF EXISTS `tbl_inv_units`;
  1046. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1047. /*!40101 SET character_set_client = utf8 */;
  1048. CREATE TABLE `tbl_inv_units` (
  1049.   `UNIT_ID` int(11) NOT NULL AUTO_INCREMENT,
  1050.   `UNIT_NAME` varchar(45) DEFAULT NULL,
  1051.   PRIMARY KEY (`UNIT_ID`)
  1052. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  1053. /*!40101 SET character_set_client = @saved_cs_client */;
  1054.  
  1055. --
  1056. -- Dumping data for table `tbl_inv_units`
  1057. --
  1058.  
  1059. LOCK TABLES `tbl_inv_units` WRITE;
  1060. /*!40000 ALTER TABLE `tbl_inv_units` DISABLE KEYS */;
  1061. INSERT INTO `tbl_inv_units` VALUES (1,'KG'),(2,'MG'),(3,'LTRE'),(4,'PACKETS'),(5,'Nos');
  1062. /*!40000 ALTER TABLE `tbl_inv_units` ENABLE KEYS */;
  1063. UNLOCK TABLES;
  1064.  
  1065. --
  1066. -- Table structure for table `tbl_menu`
  1067. --
  1068.  
  1069. DROP TABLE IF EXISTS `tbl_menu`;
  1070. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1071. /*!40101 SET character_set_client = utf8 */;
  1072. CREATE TABLE `tbl_menu` (
  1073.   `MENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  1074.   `MENU_PATH` varchar(400) DEFAULT NULL,
  1075.   `MENU_CONTROLLER_NAME` varchar(45) DEFAULT NULL,
  1076.   `MENU_ICON` varchar(45) DEFAULT NULL,
  1077.   `MENU_CHILD_OF` int(11) DEFAULT NULL,
  1078.   `MENU_ORDER_NUMBER` int(11) DEFAULT NULL,
  1079.   `MENU_ELEMENT_ID` varchar(45) DEFAULT NULL,
  1080.   `MENU_TYPE` varchar(1) DEFAULT 'C',
  1081.   `MENU_TEXT` varchar(45) DEFAULT NULL,
  1082.   `MENU_CSS_CLASSS` varchar(45) DEFAULT NULL,
  1083.   `MENU_HAS_ADD` int(11) NOT NULL,
  1084.   `MENU_HAS_EDIT` int(11) NOT NULL,
  1085.   `MENU_HAS_DELETE` int(11) NOT NULL,
  1086.   PRIMARY KEY (`MENU_ID`),
  1087.   KEY `MENU_PATH` (`MENU_PATH`),
  1088.   KEY `MENU_CONTROLLER_NAME` (`MENU_CONTROLLER_NAME`),
  1089.   KEY `MENU_CHILD_OF` (`MENU_CHILD_OF`),
  1090.   KEY `MENU_ORDER_NUMBER` (`MENU_ORDER_NUMBER`),
  1091.   KEY `MENU_HAS_ADD` (`MENU_HAS_ADD`),
  1092.   KEY `MENU_HAS_EDIT` (`MENU_HAS_EDIT`),
  1093.   KEY `MENU_HAS_DELETE` (`MENU_HAS_DELETE`)
  1094. ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
  1095. /*!40101 SET character_set_client = @saved_cs_client */;
  1096.  
  1097. --
  1098. -- Dumping data for table `tbl_menu`
  1099. --
  1100.  
  1101. LOCK TABLES `tbl_menu` WRITE;
  1102. /*!40000 ALTER TABLE `tbl_menu` DISABLE KEYS */;
  1103. INSERT INTO `tbl_menu` VALUES (1,NULL,NULL,NULL,0,NULL,NULL,'C','Accounts ','waves-effect',1,1,1),(2,NULL,NULL,NULL,1,NULL,NULL,'C','Master Files',NULL,0,0,0),(3,NULL,NULL,NULL,1,NULL,NULL,'C','Transactions',NULL,0,0,0),(4,NULL,NULL,NULL,1,NULL,NULL,'C','Reports',NULL,0,0,0),(5,NULL,NULL,NULL,2,NULL,'CREATE-ACC-HEAD','F','Account Head',NULL,1,0,0),(6,NULL,NULL,NULL,0,NULL,NULL,'C','Inventory',NULL,0,0,0),(7,NULL,NULL,NULL,0,NULL,NULL,'C','Production',NULL,0,0,0),(8,NULL,NULL,NULL,0,NULL,NULL,'C','Sales',NULL,0,0,0),(9,NULL,NULL,NULL,0,NULL,NULL,'C','Users',NULL,0,0,0),(10,NULL,NULL,NULL,6,NULL,NULL,'C','Master Files',NULL,0,0,0),(11,NULL,NULL,NULL,6,NULL,NULL,'C','Purchase',NULL,0,0,0),(12,NULL,NULL,NULL,6,NULL,NULL,'C','Reports',NULL,0,0,0),(13,NULL,NULL,NULL,10,NULL,'CAT-MASTER','F','Category',NULL,1,1,1),(14,NULL,NULL,NULL,3,NULL,'ACC-PAYMENTS','F','Payments',NULL,1,1,0),(15,NULL,NULL,NULL,3,NULL,'ACC-RECIEPTS','F','Receipts',NULL,1,1,0),(16,NULL,NULL,NULL,3,NULL,'ACC-JOUNRNAL','F','Journals',NULL,1,1,0),(17,NULL,NULL,NULL,3,NULL,'ACC-DEBIT-NOTE','F','Debit Note',NULL,1,1,0),(18,NULL,NULL,NULL,3,NULL,'ACC-CREDIT-NOTE','F','Credit Note',NULL,1,1,0),(19,NULL,NULL,NULL,3,NULL,'ACC-TRANSACTION-LIST','F','Transaction List',NULL,0,0,0),(20,NULL,NULL,NULL,3,NULL,'ACC-POST-ALL','F','Post Accounts',NULL,0,0,0),(21,NULL,NULL,NULL,4,NULL,'ACC-GENERAL-LEDGER','F','General Ledger',NULL,0,0,0),(22,NULL,NULL,NULL,4,NULL,'ACC-TRIAL-BALANCE','F','Trail Balance',NULL,0,0,0),(23,NULL,NULL,NULL,4,NULL,'ACC-GENERAL-BALANCE','F','View Account Balance',NULL,0,0,0),(24,NULL,NULL,NULL,4,NULL,'ACC-JOURNAL-REGISTER','F','Journal Register',NULL,0,0,0),(25,NULL,NULL,NULL,4,NULL,'ACC-CREDIT-REGISTER','F','Credit Note Register',NULL,0,0,0),(26,NULL,NULL,NULL,4,NULL,'ACC-DEBIT-REGISTER','F','Debit Note Register',NULL,0,0,0),(27,NULL,NULL,NULL,10,NULL,'ITEM-MASTER','F','Item',NULL,1,1,0),(28,NULL,NULL,NULL,10,NULL,'SUPP-MASTER','F','Supplier',NULL,1,1,0),(29,NULL,NULL,NULL,10,NULL,'CUST-MASTER','F','Customer',NULL,1,1,0),(30,NULL,NULL,NULL,10,NULL,'ROUTE-MSTER','F','Route',NULL,1,1,0),(31,NULL,NULL,NULL,10,NULL,'SLSMAN-MASTER','F','Salesman',NULL,1,1,0),(32,NULL,NULL,NULL,11,NULL,'INV-PURCHASE-ENTRY','F','Purchase Order',NULL,1,1,1),(33,NULL,NULL,NULL,11,NULL,'INV-PURCHSAE-INVOICE','F','Purchase Invoice',NULL,1,1,0),(34,NULL,NULL,NULL,12,NULL,'INV-PURCHASE-ORDER-VIEW','F','Purchase Order List',NULL,0,0,0),(35,NULL,NULL,NULL,12,NULL,'INV-PURCHSAE-INVOICE-VIEW','F','Purchase Invoice List',NULL,0,0,0),(36,NULL,NULL,NULL,12,NULL,'STOCK-LIST','F','Stock List',NULL,0,0,0),(37,NULL,NULL,NULL,12,NULL,'STOCK-LEDGER','F','Stock Ledger',NULL,0,0,0),(38,NULL,NULL,NULL,8,NULL,'INV-SALES-ORDER-LISTING','F','Sales Orders List',NULL,0,0,0),(39,NULL,NULL,NULL,8,NULL,'INV-SALES-ORDER','F','Sales Order',NULL,1,1,1),(40,NULL,NULL,NULL,8,NULL,'INV-SALES-INVOICE','F','Sales Invoice',NULL,1,1,1),(41,NULL,NULL,NULL,8,NULL,'ADD-SALES-INVOICE','F','Fresh Sales Invoice',NULL,1,1,1),(42,NULL,NULL,NULL,8,NULL,'INV-SALES-RETURN','F','Sales Return',NULL,1,1,1),(43,NULL,NULL,NULL,8,NULL,'','C','Reports',NULL,0,0,0),(44,NULL,NULL,NULL,43,NULL,'INV-SALES-VIEW-ORDER','F','Sales Order Report',NULL,0,0,0),(45,NULL,NULL,NULL,43,NULL,'VIEW-SALES-INVOICE','F','Sales Invoice Report',NULL,0,0,0),(46,NULL,NULL,NULL,43,NULL,'REP-SALES-RETURN','F','Sales Return Report',NULL,0,0,0),(47,NULL,NULL,NULL,9,NULL,'ACCESS-CONTROL','F','Access Control',NULL,0,0,0),(48,NULL,NULL,NULL,7,NULL,'','C','Master Files',NULL,0,0,0),(49,NULL,NULL,NULL,7,NULL,'','C','Operations',NULL,0,0,0),(50,NULL,NULL,NULL,7,NULL,'','C','Reports',NULL,0,0,0),(51,NULL,NULL,NULL,48,NULL,'PROD-MASTER','F','Product',NULL,1,1,0),(52,NULL,NULL,NULL,48,NULL,'COST-MASTER','F','Product Cost',NULL,1,1,0),(53,NULL,NULL,NULL,48,NULL,'STOCK-LOCATION','F','Stock Location',NULL,1,1,0),(54,NULL,NULL,NULL,48,NULL,'PACKING-MASTER','F','Packing',NULL,1,1,1),(55,NULL,NULL,NULL,48,NULL,'PRICELIST-MASTER','F','Price List',NULL,1,1,1),(56,NULL,NULL,NULL,49,NULL,'INV-CREATE-PODUCTION','F','Start New Production',NULL,1,1,1),(57,NULL,NULL,NULL,49,NULL,'INV-PRODUCTION-STOCK','F','Production List',NULL,0,0,0),(58,NULL,NULL,NULL,49,NULL,'CREATE-PRODUCT-PACK','F','Create Product Pack',NULL,1,1,1),(59,NULL,NULL,NULL,49,NULL,'MINI-STOCK','F','Move Stock to Mini Store',NULL,1,1,1),(60,NULL,NULL,NULL,49,NULL,'MINI-TO-STOCK','F','Move Mini Store to Stock',NULL,1,1,1),(61,NULL,NULL,NULL,50,NULL,'REP-PRODUCTION','F','Production Report',NULL,0,0,0),(62,NULL,NULL,NULL,50,NULL,'FINISHED-STOCK','F','Product Stock List',NULL,0,0,0),(63,NULL,NULL,NULL,50,NULL,'LOCATION-WISE-STOCK','F','Location Wise Stock List',NULL,0,0,0),(64,NULL,NULL,NULL,3,NULL,'PAYMENT-SUPPLIER','F','Payment to Supplier',NULL,1,1,1),(65,NULL,NULL,NULL,3,0,'RECEIPT-CUSTOMER','F','Receipts to Customer',NULL,1,1,1),(66,NULL,NULL,NULL,3,1,'ACC-OPENING-BALANCE','F','Opening Balance',NULL,1,1,0),(67,NULL,NULL,NULL,3,5,'CHEQUE-UPDATIONS','F','Cheque Updation',NULL,1,0,0),(68,NULL,NULL,NULL,4,5,'BANK-RECONCILIATION','F','Bank Reconciliation',NULL,1,0,0);
  1104. /*!40000 ALTER TABLE `tbl_menu` ENABLE KEYS */;
  1105. UNLOCK TABLES;
  1106.  
  1107. --
  1108. -- Table structure for table `tbl_menu_user`
  1109. --
  1110.  
  1111. DROP TABLE IF EXISTS `tbl_menu_user`;
  1112. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1113. /*!40101 SET character_set_client = utf8 */;
  1114. CREATE TABLE `tbl_menu_user` (
  1115.   `MENU_USER_ID` int(11) NOT NULL AUTO_INCREMENT,
  1116.   `MENU_USER_MASTER_ID` int(11) DEFAULT NULL,
  1117.   `MENU_MASTER_ID` int(11) DEFAULT NULL,
  1118.   `MENU_VIEW` varchar(1) DEFAULT NULL,
  1119.   `MENU_ADD` varchar(1) DEFAULT NULL,
  1120.   `MENU_EDIT` varchar(1) DEFAULT NULL,
  1121.   `MENU_DELETE` varchar(1) DEFAULT NULL,
  1122.   PRIMARY KEY (`MENU_USER_ID`)
  1123. ) ENGINE=InnoDB AUTO_INCREMENT=257 DEFAULT CHARSET=latin1;
  1124. /*!40101 SET character_set_client = @saved_cs_client */;
  1125.  
  1126. --
  1127. -- Dumping data for table `tbl_menu_user`
  1128. --
  1129.  
  1130. LOCK TABLES `tbl_menu_user` WRITE;
  1131. /*!40000 ALTER TABLE `tbl_menu_user` DISABLE KEYS */;
  1132. INSERT INTO `tbl_menu_user` VALUES (204,1,5,'1','1',NULL,NULL),(205,1,14,'1','1','1',NULL),(206,1,15,'1','1','1',NULL),(207,1,16,'1','1','1',NULL),(208,1,17,'1','1','1',NULL),(209,1,18,'1','1','1',NULL),(210,1,19,'1',NULL,NULL,NULL),(211,1,20,'1',NULL,NULL,NULL),(212,1,64,'1','1','1','1'),(213,1,65,'1','1','1','1'),(214,1,66,'1','1','1',NULL),(215,1,67,'1','1',NULL,NULL),(216,1,21,'1',NULL,NULL,NULL),(217,1,22,'1',NULL,NULL,NULL),(218,1,23,'1',NULL,NULL,NULL),(219,1,24,'1',NULL,NULL,NULL),(220,1,25,'1',NULL,NULL,NULL),(221,1,26,'1',NULL,NULL,NULL),(222,1,68,'1','1',NULL,NULL),(223,1,13,'1','1','1','1'),(224,1,27,'1','1','1',NULL),(225,1,28,'1','1','1',NULL),(226,1,29,'1','1','1',NULL),(227,1,30,'1','1','1',NULL),(228,1,31,'1','1','1',NULL),(229,1,32,'1','1','1','1'),(230,1,33,'1','1','1',NULL),(231,1,34,'1',NULL,NULL,NULL),(232,1,35,'1',NULL,NULL,NULL),(233,1,36,'1',NULL,NULL,NULL),(234,1,37,'1',NULL,NULL,NULL),(235,1,51,'1','1','1',NULL),(236,1,52,'1','1','1',NULL),(237,1,53,'1','1','1',NULL),(238,1,54,'1','1','1','1'),(239,1,55,'1','1','1','1'),(240,1,56,'1','1','1','1'),(241,1,57,'1',NULL,NULL,NULL),(242,1,58,'1','1','1','1'),(243,1,59,'1','1','1','1'),(244,1,60,'1','1','1','1'),(245,1,61,'1',NULL,NULL,NULL),(246,1,62,'1',NULL,NULL,NULL),(247,1,63,'1',NULL,NULL,NULL),(248,1,38,'1',NULL,NULL,NULL),(249,1,39,'1',NULL,NULL,NULL),(250,1,40,'1',NULL,NULL,NULL),(251,1,41,'1',NULL,NULL,NULL),(252,1,42,'1',NULL,NULL,NULL),(253,1,44,'1',NULL,NULL,NULL),(254,1,45,'1',NULL,NULL,NULL),(255,1,46,'1',NULL,NULL,NULL),(256,1,47,'1',NULL,NULL,NULL);
  1133. /*!40000 ALTER TABLE `tbl_menu_user` ENABLE KEYS */;
  1134. UNLOCK TABLES;
  1135.  
  1136. --
  1137. -- Table structure for table `tbl_mini_expense`
  1138. --
  1139.  
  1140. DROP TABLE IF EXISTS `tbl_mini_expense`;
  1141. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1142. /*!40101 SET character_set_client = utf8 */;
  1143. CREATE TABLE `tbl_mini_expense` (
  1144.   `MEXP_ID` int(11) NOT NULL AUTO_INCREMENT,
  1145.   `MEXP_MASTER_ID` int(11) NOT NULL,
  1146.   `MEXP_AMOUNT` double NOT NULL,
  1147.   `MEXP_SALES_MAN_ID` int(11) NOT NULL,
  1148.   `MEXP_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1149.   `MEXP_DESCRIPTION` varchar(300) NOT NULL,
  1150.   `MEXP_ATTACHMENT` varchar(300) NOT NULL,
  1151.   `MEXP_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  1152.   PRIMARY KEY (`MEXP_ID`)
  1153. ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
  1154. /*!40101 SET character_set_client = @saved_cs_client */;
  1155.  
  1156. --
  1157. -- Dumping data for table `tbl_mini_expense`
  1158. --
  1159.  
  1160. LOCK TABLES `tbl_mini_expense` WRITE;
  1161. /*!40000 ALTER TABLE `tbl_mini_expense` DISABLE KEYS */;
  1162. INSERT INTO `tbl_mini_expense` VALUES (21,104,144545,1,'2017-04-04 07:00:00','ruufu djjjffudu hdudu ruuudu ddiiei rurururhdh ruhfuchfu rrjuufufhfj rejfjfj rjrjfhfh','','N'),(22,104,12,1,'2017-04-04 07:00:00','gjdjjcjdfjfj urururj rijjrjjej rririddi rjrjdj. jjdjdjjdj ddidijdjd ddjdjdjdj duufuf','823d7de2f37f2c4399a0b8ae6389af70.jpg','N'),(23,104,955,1,'2017-04-10 07:00:00','ggsgd','','N'),(24,104,254,1,'2017-04-13 07:00:00','petrol\n','','N'),(25,104,250,1,'2017-04-21 07:00:00','','','N'),(26,104,120,1,'2017-04-23 07:00:00','','','N'),(27,104,100,1,'2017-05-03 18:30:00','vcbcvbfcg','a851eb11627ad587169b8045229e83c1.jpg','N');
  1163. /*!40000 ALTER TABLE `tbl_mini_expense` ENABLE KEYS */;
  1164. UNLOCK TABLES;
  1165.  
  1166. --
  1167. -- Table structure for table `tbl_mini_expense_master`
  1168. --
  1169.  
  1170. DROP TABLE IF EXISTS `tbl_mini_expense_master`;
  1171. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1172. /*!40101 SET character_set_client = utf8 */;
  1173. CREATE TABLE `tbl_mini_expense_master` (
  1174.   `EXP_ID` int(11) NOT NULL AUTO_INCREMENT,
  1175.   `EXP_NAME` varchar(255) NOT NULL,
  1176.   PRIMARY KEY (`EXP_ID`)
  1177. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1178. /*!40101 SET character_set_client = @saved_cs_client */;
  1179.  
  1180. --
  1181. -- Dumping data for table `tbl_mini_expense_master`
  1182. --
  1183.  
  1184. LOCK TABLES `tbl_mini_expense_master` WRITE;
  1185. /*!40000 ALTER TABLE `tbl_mini_expense_master` DISABLE KEYS */;
  1186. /*!40000 ALTER TABLE `tbl_mini_expense_master` ENABLE KEYS */;
  1187. UNLOCK TABLES;
  1188.  
  1189. --
  1190. -- Table structure for table `tbl_mini_invoice_items`
  1191. --
  1192.  
  1193. DROP TABLE IF EXISTS `tbl_mini_invoice_items`;
  1194. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1195. /*!40101 SET character_set_client = utf8 */;
  1196. CREATE TABLE `tbl_mini_invoice_items` (
  1197.   `MINI_INV_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  1198.   `MINI_INV_ITEM_PACKET_ID` int(11) NOT NULL,
  1199.   `MINI_INV_ITEM_QTY` double NOT NULL,
  1200.   `MINI_INV_MASTER_ID` int(11) NOT NULL,
  1201.   `MINI_INV_PRICE` double NOT NULL,
  1202.   `MINI_INV_TOTAL` double NOT NULL,
  1203.   PRIMARY KEY (`MINI_INV_ITEM_ID`)
  1204. ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
  1205. /*!40101 SET character_set_client = @saved_cs_client */;
  1206.  
  1207. --
  1208. -- Dumping data for table `tbl_mini_invoice_items`
  1209. --
  1210.  
  1211. LOCK TABLES `tbl_mini_invoice_items` WRITE;
  1212. /*!40000 ALTER TABLE `tbl_mini_invoice_items` DISABLE KEYS */;
  1213. INSERT INTO `tbl_mini_invoice_items` VALUES (1,4,5,1,3,15),(2,2,5,1,2,10),(3,6,2,1,4,8),(4,1,65,2,1.5,97.5),(5,5,3,2,3.5,10.5),(6,3,25,2,2,50),(7,1,1,3,1.5,1.5),(8,2,25,4,2,50),(9,4,14,4,3,42),(10,5,25,4,3.5,87.5),(11,2,251,5,2,502),(12,2,25,6,2,50),(13,4,12,6,3,36),(14,5,25,6,3.5,87.5),(15,2,25,7,2,50),(16,3,12,7,2,24),(17,6,25,7,4,100),(18,3,12,8,2,24),(19,5,57,8,3.5,199.5),(20,6,45,8,4,180),(21,2,12,9,2,24),(22,4,12,9,3,36),(23,5,15,9,3.5,52.5),(24,1,3,10,1.5,4.5),(25,2,1,10,2,2),(26,3,1,10,2,2),(27,1,1,11,1.5,1.5),(28,2,1,11,2,2),(29,3,1,11,2,2),(30,4,1,11,3,3),(31,5,1,11,3.5,3.5),(32,6,1,11,4,4),(33,1,1,12,1.5,1.5),(34,2,1,12,2,2),(35,3,1,12,2,2),(36,4,1,13,3,3),(37,2,1,13,2,2),(38,3,1,13,2,2),(39,1,1,14,1.5,1.5),(40,4,2,15,3,6),(41,2,1,15,2,2),(42,6,1,15,4,4),(43,1,2,16,1.5,3),(44,2,1,16,2,2),(45,3,1,16,2,2),(46,1,1,17,1.5,1.5),(47,1,1,18,1.5,1.5),(48,2,1,18,2,2),(49,3,1,18,2,2),(50,4,1,18,3,3),(51,1,1,19,1.5,1.5);
  1214. /*!40000 ALTER TABLE `tbl_mini_invoice_items` ENABLE KEYS */;
  1215. UNLOCK TABLES;
  1216.  
  1217. --
  1218. -- Table structure for table `tbl_mini_invoice_master`
  1219. --
  1220.  
  1221. DROP TABLE IF EXISTS `tbl_mini_invoice_master`;
  1222. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1223. /*!40101 SET character_set_client = utf8 */;
  1224. CREATE TABLE `tbl_mini_invoice_master` (
  1225.   `MINI_INV_ID` int(11) NOT NULL AUTO_INCREMENT,
  1226.   `MINI_INV_CUSTOMER_ID` int(11) NOT NULL,
  1227.   `MINI_INV_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1228.   `MINI_INV_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  1229.   `MINI_INV_SALES_MAN_ID` int(11) NOT NULL,
  1230.   `MINI_INV_LOCATION_MASTER_ID` int(11) NOT NULL,
  1231.   `MINI_INV_INVOICE_NO` varchar(255) DEFAULT NULL,
  1232.   `MINI_INV_ORDER_ID` int(11) NOT NULL DEFAULT '0',
  1233.   `MINI_INV_PAYMODE` int(11) NOT NULL DEFAULT '0',
  1234.   PRIMARY KEY (`MINI_INV_ID`)
  1235. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
  1236. /*!40101 SET character_set_client = @saved_cs_client */;
  1237.  
  1238. --
  1239. -- Dumping data for table `tbl_mini_invoice_master`
  1240. --
  1241.  
  1242. LOCK TABLES `tbl_mini_invoice_master` WRITE;
  1243. /*!40000 ALTER TABLE `tbl_mini_invoice_master` DISABLE KEYS */;
  1244. INSERT INTO `tbl_mini_invoice_master` VALUES (1,7,'2017-04-22 07:00:00','N',1,1,'INV1',0,1),(2,8,'2017-04-22 07:00:00','N',1,1,'INV2',10,0),(3,20,'2017-04-22 07:00:00','N',1,1,'INV3',9,1),(4,9,'2017-04-22 08:12:41','N',1,1,'INV4',0,1),(5,5,'2017-04-22 08:13:18','N',1,1,'INV5',0,1),(6,7,'2017-04-23 10:51:04','N',1,1,'INV6',0,1),(7,8,'2017-04-23 11:04:28','N',1,1,'INV7',0,0),(8,7,'2017-04-24 07:00:00','N',1,1,'INV8',11,1),(9,7,'2017-04-24 07:00:00','N',1,1,'INV9',0,1),(10,5,'2017-04-23 18:30:00','N',1,1,'INV10',0,1),(11,5,'2017-04-26 18:30:00','N',1,1,'INV11',0,1),(12,5,'2017-04-26 18:30:00','N',1,1,'INV12',0,1),(13,48,'2017-04-26 18:30:00','N',1,1,'INV13',0,1),(14,5,'2017-04-27 18:30:00','N',1,1,'INV14',0,1),(15,7,'2017-05-01 18:30:00','N',1,1,'INV15',0,1),(16,5,'2017-05-01 18:30:00','N',1,1,'INV16',13,1),(17,5,'2017-05-03 18:30:00','N',1,1,'INV17',0,1),(18,198,'2017-05-03 18:30:00','N',1,1,'INV18',0,1),(19,6,'2017-05-05 18:30:00','N',1,1,'INV19',0,1);
  1245. /*!40000 ALTER TABLE `tbl_mini_invoice_master` ENABLE KEYS */;
  1246. UNLOCK TABLES;
  1247.  
  1248. --
  1249. -- Table structure for table `tbl_mini_menu_master`
  1250. --
  1251.  
  1252. DROP TABLE IF EXISTS `tbl_mini_menu_master`;
  1253. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1254. /*!40101 SET character_set_client = utf8 */;
  1255. CREATE TABLE `tbl_mini_menu_master` (
  1256.   `MENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  1257.   `MENU_TEXT` varchar(45) DEFAULT NULL,
  1258.   `MENU_ORDER_NO` int(11) DEFAULT NULL,
  1259.   `MENU_ANDROID_ID` varchar(45) DEFAULT NULL,
  1260.   PRIMARY KEY (`MENU_ID`)
  1261. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  1262. /*!40101 SET character_set_client = @saved_cs_client */;
  1263.  
  1264. --
  1265. -- Dumping data for table `tbl_mini_menu_master`
  1266. --
  1267.  
  1268. LOCK TABLES `tbl_mini_menu_master` WRITE;
  1269. /*!40000 ALTER TABLE `tbl_mini_menu_master` DISABLE KEYS */;
  1270. INSERT INTO `tbl_mini_menu_master` VALUES (1,'Home',1,'HOME'),(2,'Customers',2,'CUST'),(3,'Products',3,'PROD'),(4,'Expenses',4,'EXPE'),(5,'Orders',5,'ORDE'),(6,'Sales',6,'SALE'),(7,'Returns',7,'RETU'),(8,'Reporting',8,'REPO'),(9,'Stock Entry',9,'STEN'),(10,'Stock Movement',10,'STMV'),(11,'Logout',13,'LGOT'),(12,'Management',11,'MGMT'),(13,'Route Switch',12,'RTSW');
  1271. /*!40000 ALTER TABLE `tbl_mini_menu_master` ENABLE KEYS */;
  1272. UNLOCK TABLES;
  1273.  
  1274. --
  1275. -- Table structure for table `tbl_mini_menu_user`
  1276. --
  1277.  
  1278. DROP TABLE IF EXISTS `tbl_mini_menu_user`;
  1279. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1280. /*!40101 SET character_set_client = utf8 */;
  1281. CREATE TABLE `tbl_mini_menu_user` (
  1282.   `UMENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  1283.   `UMENU_MASTER_ID` int(11) DEFAULT NULL,
  1284.   `UMENU_USER_ID` int(11) DEFAULT NULL,
  1285.   PRIMARY KEY (`UMENU_ID`)
  1286. ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;
  1287. /*!40101 SET character_set_client = @saved_cs_client */;
  1288.  
  1289. --
  1290. -- Dumping data for table `tbl_mini_menu_user`
  1291. --
  1292.  
  1293. LOCK TABLES `tbl_mini_menu_user` WRITE;
  1294. /*!40000 ALTER TABLE `tbl_mini_menu_user` DISABLE KEYS */;
  1295. INSERT INTO `tbl_mini_menu_user` VALUES (54,2,65),(55,3,65),(56,4,65),(57,5,65),(58,6,65),(59,7,65),(60,8,65),(61,9,65),(62,10,65),(63,12,65),(86,2,1),(87,3,1),(88,4,1),(89,5,1),(90,6,1),(91,7,1),(92,8,1),(93,9,1),(94,12,1),(95,13,1);
  1296. /*!40000 ALTER TABLE `tbl_mini_menu_user` ENABLE KEYS */;
  1297. UNLOCK TABLES;
  1298.  
  1299. --
  1300. -- Table structure for table `tbl_mini_order_items`
  1301. --
  1302.  
  1303. DROP TABLE IF EXISTS `tbl_mini_order_items`;
  1304. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1305. /*!40101 SET character_set_client = utf8 */;
  1306. CREATE TABLE `tbl_mini_order_items` (
  1307.   `MINI_ORD_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  1308.   `MINI_ORD_ITEM_PACKET_ID` int(11) NOT NULL,
  1309.   `MINI_ORD_ITEM_QTY` double NOT NULL,
  1310.   `MINI_ORD_MASTER_ID` int(11) NOT NULL,
  1311.   `MINI_ORD_PRICE` double NOT NULL,
  1312.   `MINI_ORD_TOTAL` double NOT NULL,
  1313.   PRIMARY KEY (`MINI_ORD_ITEM_ID`)
  1314. ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;
  1315. /*!40101 SET character_set_client = @saved_cs_client */;
  1316.  
  1317. --
  1318. -- Dumping data for table `tbl_mini_order_items`
  1319. --
  1320.  
  1321. LOCK TABLES `tbl_mini_order_items` WRITE;
  1322. /*!40000 ALTER TABLE `tbl_mini_order_items` DISABLE KEYS */;
  1323. INSERT INTO `tbl_mini_order_items` VALUES (5,1,1,3,1.5,1.5),(6,2,1,3,2,2),(7,5,1,3,3.5,3.5),(11,1,1,5,1.5,1.5),(12,2,1,5,2,2),(19,1,1,4,1.5,1.5),(20,2,1,4,2,2),(21,5,1,4,3.5,3.5),(24,1,66,2,1.5,99),(25,5,25,2,3.5,87.5),(26,6,20,7,4,80),(27,8,25,7,7,175),(28,7,12,7,4.25,51),(29,1,1,6,1.5,1.5),(30,3,1,6,2,2),(31,4,1,6,3,3),(32,1,1,8,1.5,1.5),(33,1,1,9,1.5,1.5),(34,1,65,10,1.5,97.5),(35,5,3,10,3.5,10.5),(36,3,25,10,2,50),(37,3,12,11,2,24),(38,5,57,11,3.5,199.5),(39,6,45,11,4,180),(41,1,1,13,1.5,1.5),(42,2,1,13,2,2),(43,3,1,13,2,2),(44,1,1,14,1.5,1.5),(45,2,3,14,2,6),(46,1,1,15,1.5,1.5),(47,2,1,15,2,2);
  1324. /*!40000 ALTER TABLE `tbl_mini_order_items` ENABLE KEYS */;
  1325. UNLOCK TABLES;
  1326.  
  1327. --
  1328. -- Table structure for table `tbl_mini_order_master`
  1329. --
  1330.  
  1331. DROP TABLE IF EXISTS `tbl_mini_order_master`;
  1332. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1333. /*!40101 SET character_set_client = utf8 */;
  1334. CREATE TABLE `tbl_mini_order_master` (
  1335.   `MINI_ORD_ID` int(11) NOT NULL AUTO_INCREMENT,
  1336.   `MINI_ORD_CUSTOMER_ID` int(11) NOT NULL,
  1337.   `MINI_ORD_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1338.   `MINI_ORD_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  1339.   `MINI_ORD_SALESMAN_ID` int(11) NOT NULL,
  1340.   `MINI_ORD_NUM` varchar(255) NOT NULL,
  1341.   PRIMARY KEY (`MINI_ORD_ID`)
  1342. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  1343. /*!40101 SET character_set_client = @saved_cs_client */;
  1344.  
  1345. --
  1346. -- Dumping data for table `tbl_mini_order_master`
  1347. --
  1348.  
  1349. LOCK TABLES `tbl_mini_order_master` WRITE;
  1350. /*!40000 ALTER TABLE `tbl_mini_order_master` DISABLE KEYS */;
  1351. INSERT INTO `tbl_mini_order_master` VALUES (2,8,'2017-04-20 09:21:28','Y',1,'ORD1'),(3,5,'2017-04-20 09:51:02','Y',1,'ORD2'),(4,5,'2017-04-20 09:51:31','Y',1,'ORD3'),(5,5,'2017-04-20 09:53:26','Y',1,'ORD4'),(6,5,'2017-04-20 09:56:18','Y',1,'ORD5'),(7,7,'2017-04-21 13:02:50','Y',1,'ORD6'),(8,5,'2017-04-22 07:06:44','Y',1,'ORD7'),(9,20,'2017-04-22 07:07:49','Y',1,'ORD8'),(10,8,'2017-04-22 07:00:00','Y',1,'ORD9'),(11,7,'2017-04-24 07:00:00','Y',1,'ORD10'),(13,5,'2017-04-27 18:30:00','Y',1,'ORD12'),(14,199,'2017-05-03 18:30:00','N',1,'ORD13'),(15,5,'2017-05-05 18:30:00','N',1,'ORD14');
  1352. /*!40000 ALTER TABLE `tbl_mini_order_master` ENABLE KEYS */;
  1353. UNLOCK TABLES;
  1354.  
  1355. --
  1356. -- Table structure for table `tbl_mini_return_items`
  1357. --
  1358.  
  1359. DROP TABLE IF EXISTS `tbl_mini_return_items`;
  1360. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1361. /*!40101 SET character_set_client = utf8 */;
  1362. CREATE TABLE `tbl_mini_return_items` (
  1363.   `MINI_RET_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  1364.   `MINI_RET_ITEM_PACKET_ID` int(11) NOT NULL,
  1365.   `MINI_RET_ITEM_QTY` double NOT NULL,
  1366.   `MINI_RET_MASTER_ID` int(11) NOT NULL,
  1367.   `MINI_RET_PRICE` double NOT NULL,
  1368.   `MINI_RET_TOTAL` double NOT NULL,
  1369.   PRIMARY KEY (`MINI_RET_ITEM_ID`)
  1370. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  1371. /*!40101 SET character_set_client = @saved_cs_client */;
  1372.  
  1373. --
  1374. -- Dumping data for table `tbl_mini_return_items`
  1375. --
  1376.  
  1377. LOCK TABLES `tbl_mini_return_items` WRITE;
  1378. /*!40000 ALTER TABLE `tbl_mini_return_items` DISABLE KEYS */;
  1379. INSERT INTO `tbl_mini_return_items` VALUES (5,4,2,5,3,6),(6,1,1,6,1.5,1.5);
  1380. /*!40000 ALTER TABLE `tbl_mini_return_items` ENABLE KEYS */;
  1381. UNLOCK TABLES;
  1382.  
  1383. --
  1384. -- Table structure for table `tbl_mini_return_master`
  1385. --
  1386.  
  1387. DROP TABLE IF EXISTS `tbl_mini_return_master`;
  1388. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1389. /*!40101 SET character_set_client = utf8 */;
  1390. CREATE TABLE `tbl_mini_return_master` (
  1391.   `MINI_RET_ID` int(11) NOT NULL AUTO_INCREMENT,
  1392.   `MINI_RET_CUSTOMER_ID` int(11) NOT NULL,
  1393.   `MINI_RET_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1394.   `MINI_RET_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  1395.   `MINI_RET_SALES_MAN_ID` int(11) NOT NULL,
  1396.   PRIMARY KEY (`MINI_RET_ID`)
  1397. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  1398. /*!40101 SET character_set_client = @saved_cs_client */;
  1399.  
  1400. --
  1401. -- Dumping data for table `tbl_mini_return_master`
  1402. --
  1403.  
  1404. LOCK TABLES `tbl_mini_return_master` WRITE;
  1405. /*!40000 ALTER TABLE `tbl_mini_return_master` DISABLE KEYS */;
  1406. INSERT INTO `tbl_mini_return_master` VALUES (5,7,'2017-04-22 08:13:39','N',1),(6,5,'2017-05-05 18:30:00','N',1);
  1407. /*!40000 ALTER TABLE `tbl_mini_return_master` ENABLE KEYS */;
  1408. UNLOCK TABLES;
  1409.  
  1410. --
  1411. -- Table structure for table `tbl_mini_salesman_route`
  1412. --
  1413.  
  1414. DROP TABLE IF EXISTS `tbl_mini_salesman_route`;
  1415. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1416. /*!40101 SET character_set_client = utf8 */;
  1417. CREATE TABLE `tbl_mini_salesman_route` (
  1418.   `MINI_ROUTE_ID` int(11) NOT NULL AUTO_INCREMENT,
  1419.   `MINI_SALESMAN_ID` int(11) DEFAULT NULL,
  1420.   `MINI_ROUTE_MASTER_D` int(11) DEFAULT NULL,
  1421.   PRIMARY KEY (`MINI_ROUTE_ID`)
  1422. ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=latin1;
  1423. /*!40101 SET character_set_client = @saved_cs_client */;
  1424.  
  1425. --
  1426. -- Dumping data for table `tbl_mini_salesman_route`
  1427. --
  1428.  
  1429. LOCK TABLES `tbl_mini_salesman_route` WRITE;
  1430. /*!40000 ALTER TABLE `tbl_mini_salesman_route` DISABLE KEYS */;
  1431. INSERT INTO `tbl_mini_salesman_route` VALUES (1,67,5),(2,67,1),(3,67,2),(32,65,6),(33,65,2),(34,65,8),(67,68,7),(68,68,6),(69,68,4),(70,68,3),(71,1,8),(72,1,6),(73,1,1),(74,1,4),(75,1,3),(76,1,2);
  1432. /*!40000 ALTER TABLE `tbl_mini_salesman_route` ENABLE KEYS */;
  1433. UNLOCK TABLES;
  1434.  
  1435. --
  1436. -- Table structure for table `tbl_opening_balance`
  1437. --
  1438.  
  1439. DROP TABLE IF EXISTS `tbl_opening_balance`;
  1440. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1441. /*!40101 SET character_set_client = utf8 */;
  1442. CREATE TABLE `tbl_opening_balance` (
  1443.   `OP_BNCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  1444.   `OP_BNCE_ACCOUNT_ID` int(11) NOT NULL COMMENT 'foreign key-account',
  1445.   `OP_BNCE_AMOUNT` double DEFAULT NULL,
  1446.   PRIMARY KEY (`OP_BNCE_ID`)
  1447. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  1448. /*!40101 SET character_set_client = @saved_cs_client */;
  1449.  
  1450. --
  1451. -- Dumping data for table `tbl_opening_balance`
  1452. --
  1453.  
  1454. LOCK TABLES `tbl_opening_balance` WRITE;
  1455. /*!40000 ALTER TABLE `tbl_opening_balance` DISABLE KEYS */;
  1456. INSERT INTO `tbl_opening_balance` VALUES (1,91,0),(2,253,0);
  1457. /*!40000 ALTER TABLE `tbl_opening_balance` ENABLE KEYS */;
  1458. UNLOCK TABLES;
  1459.  
  1460. --
  1461. -- Table structure for table `tbl_transactions`
  1462. --
  1463.  
  1464. DROP TABLE IF EXISTS `tbl_transactions`;
  1465. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1466. /*!40101 SET character_set_client = utf8 */;
  1467. CREATE TABLE `tbl_transactions` (
  1468.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  1469.   `VOUCHER_CODE` varchar(255) NOT NULL,
  1470.   `DEBIT_ACC_ID` int(11) DEFAULT NULL,
  1471.   `CREDIT_ACC_ID` int(11) DEFAULT NULL,
  1472.   `AMOUNT` double DEFAULT NULL,
  1473.   `TRASACTION_DATE` date DEFAULT NULL,
  1474.   `SYSTEM_DATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  1475.   `CHQUE_NUM` varchar(255) DEFAULT NULL,
  1476.   `CHQUE_DATE` date DEFAULT NULL,
  1477.   `ADDRESS` varchar(300) DEFAULT NULL,
  1478.   `USER_ID` int(11) DEFAULT NULL,
  1479.   `NARRATION` varchar(350) DEFAULT NULL,
  1480.   `IS_POSTED` varchar(1) DEFAULT 'N',
  1481.   `INVOICE_NUMBER` varchar(45) NOT NULL,
  1482.   PRIMARY KEY (`ID`)
  1483. ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
  1484. /*!40101 SET character_set_client = @saved_cs_client */;
  1485.  
  1486. --
  1487. -- Dumping data for table `tbl_transactions`
  1488. --
  1489.  
  1490. LOCK TABLES `tbl_transactions` WRITE;
  1491. /*!40000 ALTER TABLE `tbl_transactions` DISABLE KEYS */;
  1492. INSERT INTO `tbl_transactions` VALUES (1,'CR1',91,95,1000,'2017-03-06','2017-03-06 21:52:58',NULL,NULL,'\r\n                  address',0,'\r\n          description        ','Y','0'),(2,'PC2',93,94,190,'2017-03-01','2017-03-08 18:18:05','0','2017-03-01','0',1,'','Y',''),(3,'PC3',0,95,550,'2017-03-01','2017-03-08 23:12:34','0','2017-03-01','0',1,'','Y',''),(4,'PC3',93,95,83,'2017-03-01','2017-03-08 23:12:34','0','2017-03-01','0',1,'','Y',''),(5,'PC4',328,120,3900,'2017-03-01','2017-03-19 19:56:29','0','2017-03-01','0',1,'','Y','4'),(6,'PC5',93,128,890,'2017-03-02','2017-03-19 20:38:56','0','2017-03-02','0',1,'discouond  0.35','Y','5'),(7,'PC5',102,128,490,'2017-03-02','2017-03-19 20:38:56','0','2017-03-02','0',1,'discouond  0.35','Y','5'),(8,'PC6',102,128,560,'2017-03-09','2017-03-20 17:52:30','0','2017-03-09','0',1,'','N','6'),(9,'PC6',93,128,800,'2017-03-09','2017-03-20 17:52:30','0','2017-03-09','0',1,'','N','6'),(10,'PC7',331,137,120,'2017-03-03','2017-03-20 18:57:48','0','2017-03-03','0',1,'','Y','7'),(11,'PC8',331,137,1000,'2017-03-07','2017-03-20 18:58:30','0','2017-03-07','0',1,'','N','8'),(12,'PC9',331,137,1150,'2017-03-03','2017-03-20 19:03:51','0','2017-03-03','0',1,'','Y','9'),(13,'PC10',331,137,850,'2017-03-02','2017-03-20 19:10:11','0','2017-03-02','0',1,'','Y','10'),(14,'PC10',331,137,1100,'2017-03-13','2017-03-20 19:11:02','0','2017-03-13','0',1,'','N','11'),(15,'PC10',93,140,2700,'2017-03-11','2017-03-21 18:43:38','0','2017-03-11','0',1,'','N','12'),(16,'PC10',93,140,2700,'2017-03-07','2017-03-21 18:44:16','0','2017-03-07','0',1,'','N','13'),(17,'PC10',93,132,1000,'2017-03-10','2017-03-21 19:32:59','0','2017-03-10','0',1,'','N','14'),(18,'PC10',93,132,750,'2017-03-04','2017-03-21 19:33:40','0','2017-03-04','0',1,'','N','15'),(19,'PC10',93,132,500,'2017-03-09','2017-03-21 19:34:25','0','2017-03-09','0',1,'','N','16'),(20,'PC10',93,132,500,'2017-03-06','2017-03-21 19:35:07','0','2017-03-06','0',1,'','N','17'),(21,'PC10',93,132,500,'2017-03-03','2017-03-21 19:35:40','0','2017-03-03','0',1,'','Y','18'),(22,'PC10',93,132,750,'2017-03-02','2017-03-21 19:36:17','0','2017-03-02','0',1,'','Y','19'),(23,'PC10',93,120,270,'2017-03-11','2017-03-21 20:41:29','0','2017-03-11','0',1,'','N','20'),(24,'PC10',328,120,0,'2017-03-12','2017-03-21 20:42:07','0','2017-03-12','0',1,'TOTAL AMT -3900','N','21'),(25,'PC10',328,120,0,'2017-03-08','2017-03-21 20:43:01','0','2017-03-08','0',1,'','N','22'),(26,'PC10',328,120,0,'2017-03-02','2017-03-21 20:43:54','0','2017-03-02','0',1,'ITEM NO 4 AMOUNT 1500','Y','23'),(27,'PC10',331,131,300,'2017-03-13','2017-03-22 17:18:24','0','2017-03-13','0',1,'','N','24'),(28,'PC10',331,131,300,'2017-03-05','2017-03-22 17:18:56','0','2017-03-05','0',1,'','N','25'),(29,'PC10',93,142,2202,'2017-03-01','2017-03-22 20:29:16','0','2017-03-01','0',1,'total -2785','Y','26'),(30,'PC10',93,332,72,'2017-03-01','2017-03-23 20:39:43','0','2017-03-01','0',1,'total -215','Y','27'),(31,'PC10',93,332,72,'2017-03-02','2017-03-23 20:40:38','0','2017-03-02','0',1,'340\n','Y','28'),(32,'PC10',102,119,3200,'2017-03-01','2017-03-30 16:49:37','0','2017-03-01','0',1,'NOT ACTUAL PURCHASE ....','Y','29'),(33,'PC10',93,119,13460,'2017-03-01','2017-03-30 16:49:37','0','2017-03-01','0',1,'NOT ACTUAL PURCHASE ....','Y','29'),(34,'PC10',93,119,4000,'2017-03-01','2017-03-30 20:09:58','0','2017-03-01','0',1,'NOT ACTUAL PURCHASE','Y','30'),(35,'CP1',104,91,25000,'2017-03-01','2017-04-01 20:00:39',NULL,NULL,'0',0,'                    ','N','0'),(36,'RC1',91,96,22222,'2017-03-01','2017-04-01 20:01:20',NULL,NULL,'\r\n                  ',0,'\r\n                  ','N','0'),(37,'JV1',91,92,50000,'2017-03-03','2017-04-01 20:01:54','0','2017-03-03','0',0,'\n                ','N',''),(38,'BP1',331,92,522,'2017-03-30','2017-04-01 20:35:58','022222','2017-04-28','0',0,'                    ','N','0'),(39,'RB1',92,102,5000,'2017-03-31','2017-04-01 20:45:52','001','2017-03-31','\r\n                  ',0,'\r\n                  ','N','0'),(40,'RB2',92,328,200,'1969-12-31','2017-04-01 20:46:21','002','2017-04-14','\r\n                  ',0,'\r\n                  ','N','0'),(41,'BP2',331,92,6000,'2017-03-31','2017-04-01 20:47:12','0003','2017-04-14','0',0,'                    ','N','0');
  1493. /*!40000 ALTER TABLE `tbl_transactions` ENABLE KEYS */;
  1494. UNLOCK TABLES;
  1495.  
  1496. --
  1497. -- Table structure for table `tbl_user`
  1498. --
  1499.  
  1500. DROP TABLE IF EXISTS `tbl_user`;
  1501. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  1502. /*!40101 SET character_set_client = utf8 */;
  1503. CREATE TABLE `tbl_user` (
  1504.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  1505.   `USER_NAME` varchar(255) DEFAULT NULL,
  1506.   `SALESMAN_ID` int(11) NOT NULL,
  1507.   `PASSWORD` varchar(255) DEFAULT '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',
  1508.   `TEMP_API_KEY` varchar(300) NOT NULL,
  1509.   PRIMARY KEY (`ID`)
  1510. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
  1511. /*!40101 SET character_set_client = @saved_cs_client */;
  1512.  
  1513. --
  1514. -- Dumping data for table `tbl_user`
  1515. --
  1516.  
  1517. LOCK TABLES `tbl_user` WRITE;
  1518. /*!40000 ALTER TABLE `tbl_user` DISABLE KEYS */;
  1519. INSERT INTO `tbl_user` VALUES (1,'admin',1,'d033e22ae348aeb5660fc2140aec35850c4da997','111afd3825cdde21f07db7709cfc02294627fab2'),(2,'demo',1,'cbdbe4936ce8be63184d9f2e13fc249234371b9a','98596cf402e3d681500454cb5a43a31f7af0865f'),(3,'bchchv',50,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(6,'uvuvub',53,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(8,'cjdjjdj',55,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(11,'rhfhfh',58,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(12,'cjcjf',59,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(15,'fhdhdh',62,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(17,'dbddb',64,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(18,'saleeqvm',65,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684','3dc096784d1e654e91c52cdbce33a0fe166abcc0'),(19,'abc',66,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684','49497ffc8640ea917eabbfe679fc473a2dfcd7a0'),(20,'fjfjjf',67,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',''),(21,'fghfgh',68,'9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684','');
  1520. /*!40000 ALTER TABLE `tbl_user` ENABLE KEYS */;
  1521. UNLOCK TABLES;
  1522.  
  1523. --
  1524. -- Dumping events for database 'orcanew'
  1525. --
  1526.  
  1527. --
  1528. -- Dumping routines for database 'orcanew'
  1529. --
  1530. /*!50003 DROP FUNCTION IF EXISTS `F_GET_ACC_BALANCE_BETWEEN` */;
  1531. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1532. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1533. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1534. /*!50003 SET character_set_client  = latin1 */ ;
  1535. /*!50003 SET character_set_results = latin1 */ ;
  1536. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1537. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1538. /*!50003 SET sql_mode              = '' */ ;
  1539. DELIMITER ;;
  1540. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_BETWEEN`(`ACC_ID` INTEGER(11), `FROM_DATE` DATE, `TO_DATE` DATE) RETURNS double
  1541.     READS SQL DATA
  1542.     DETERMINISTIC
  1543. begin
  1544.  
  1545.     DECLARE DEBIT_TOTAL DOUBLE;
  1546.     DECLARE CREDIT_TOTAL DOUBLE;
  1547.     DECLARE BALANCE DOUBLE;
  1548.  
  1549.     SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
  1550.     FROM tbl_transactions
  1551.     WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND DEBIT_ACC_ID = ACC_ID;
  1552.  
  1553.     SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
  1554.     FROM tbl_transactions
  1555.     WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND CREDIT_ACC_ID = ACC_ID;
  1556.  
  1557.    SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
  1558.  
  1559.    RETURN IFNULL(BALANCE,0);
  1560. end ;;
  1561. DELIMITER ;
  1562. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1563. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1564. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1565. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1566. /*!50003 DROP FUNCTION IF EXISTS `F_GET_ACC_BALANCE_BETWEEN_BY_GROUP` */;
  1567. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1568. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1569. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1570. /*!50003 SET character_set_client  = latin1 */ ;
  1571. /*!50003 SET character_set_results = latin1 */ ;
  1572. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1573. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1574. /*!50003 SET sql_mode              = '' */ ;
  1575. DELIMITER ;;
  1576. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_BETWEEN_BY_GROUP`(`ACC_GROUP_ID` INT, `FROM_DATE` DATE, `TO_DATE` DATE) RETURNS double
  1577.     READS SQL DATA
  1578.     DETERMINISTIC
  1579. BEGIN
  1580.     DECLARE TOTAL_BALANCE DOUBLE;
  1581.     SELECT IFNULL(SUM(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,FROM_DATE,TO_DATE)),0) INTO TOTAL_BALANCE FROM tbl_acc_groups WHERE tbl_acc_groups.CHILD_OF = ACC_GROUP_ID AND tbl_acc_groups.TYPE = 'H';
  1582.     RETURN TOTAL_BALANCE;
  1583.  
  1584. END ;;
  1585. DELIMITER ;
  1586. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1587. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1588. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1589. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1590. /*!50003 DROP FUNCTION IF EXISTS `F_GET_ACC_BALANCE_UNTIL` */;
  1591. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1592. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1593. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1594. /*!50003 SET character_set_client  = latin1 */ ;
  1595. /*!50003 SET character_set_results = latin1 */ ;
  1596. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1597. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1598. /*!50003 SET sql_mode              = '' */ ;
  1599. DELIMITER ;;
  1600. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_UNTIL`(`ACC_ID` INT(11), `UNTIL_DATE` DATE) RETURNS decimal(10,0)
  1601.     READS SQL DATA
  1602.     DETERMINISTIC
  1603. begin
  1604.  
  1605. DECLARE DEBIT_TOTAL DOUBLE;
  1606. DECLARE CREDIT_TOTAL DOUBLE;
  1607. DECLARE OPENING_TOTAL DOUBLE;
  1608. DECLARE BALANCE DOUBLE;
  1609.  
  1610. SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
  1611. FROM tbl_opening_balance
  1612. WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;
  1613.  
  1614. SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
  1615. FROM tbl_transactions
  1616. WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;
  1617.  
  1618. SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
  1619. FROM tbl_transactions
  1620. WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;
  1621.  
  1622.  
  1623. IF(OPENING_TOTAL > 0) THEN
  1624.     SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
  1625. ELSE
  1626.     SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
  1627. END IF;
  1628.  
  1629. SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
  1630. RETURN BALANCE;
  1631.  
  1632.    
  1633. end ;;
  1634. DELIMITER ;
  1635. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1636. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1637. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1638. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1639. /*!50003 DROP FUNCTION IF EXISTS `F_GET_ACC_BALANCE_UNTIL_BY_GROUP` */;
  1640. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1641. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1642. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1643. /*!50003 SET character_set_client  = latin1 */ ;
  1644. /*!50003 SET character_set_results = latin1 */ ;
  1645. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1646. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1647. /*!50003 SET sql_mode              = '' */ ;
  1648. DELIMITER ;;
  1649. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_UNTIL_BY_GROUP`(`GROUP_ACC_ID` INT(11), `UNTIL_DATE` DATE) RETURNS double
  1650.     READS SQL DATA
  1651.     DETERMINISTIC
  1652. BEGIN
  1653.     DECLARE TOTAL_BALANCE DOUBLE;
  1654.     SELECT IFNULL(SUM(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,UNTIL_DATE)),0) INTO TOTAL_BALANCE FROM tbl_acc_groups WHERE tbl_acc_groups.CHILD_OF = GROUP_ACC_ID AND tbl_acc_groups.TYPE = 'H';
  1655.     RETURN TOTAL_BALANCE;
  1656. END ;;
  1657. DELIMITER ;
  1658. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1659. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1660. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1661. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1662. /*!50003 DROP FUNCTION IF EXISTS `F_GET_INVOICE_NUMBER` */;
  1663. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1664. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1665. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1666. /*!50003 SET character_set_client  = latin1 */ ;
  1667. /*!50003 SET character_set_results = latin1 */ ;
  1668. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1669. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1670. /*!50003 SET sql_mode              = '' */ ;
  1671. DELIMITER ;;
  1672. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_INVOICE_NUMBER`(`SALES_MAN_ID` INTEGER) RETURNS varchar(255) CHARSET latin1
  1673. BEGIN
  1674.     DECLARE SALES_MAN_PREFIX VARCHAR(3);
  1675.     DECLARE HEIGHEST_INVOICE_NUM INTEGER;
  1676.     DECLARE RETURN_NUMBER VARCHAR(255);
  1677.     SELECT MAN_PREFIX INTO SALES_MAN_PREFIX FROM tbl_inv_salesman WHERE MAN_ID = SALES_MAN_ID;
  1678.    
  1679.     SELECT  IFNULL(MAX(SUBSTRING(SALES_INVOICE_NUM,3)),0)
  1680.      INTO HEIGHEST_INVOICE_NUM FROM tbl_inv_sales_invoice
  1681.     WHERE LEFT(SALES_INVOICE_NUM,2) = SALES_MAN_PREFIX;
  1682.    
  1683.     SET RETURN_NUMBER = CONCAT(SALES_MAN_PREFIX,HEIGHEST_INVOICE_NUM+1);
  1684.     RETURN RETURN_NUMBER;
  1685.    
  1686.    
  1687.    
  1688.    
  1689.  
  1690. END ;;
  1691. DELIMITER ;
  1692. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1693. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1694. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1695. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1696. /*!50003 DROP FUNCTION IF EXISTS `F_GET_PRODUCTION_STOCK` */;
  1697. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1698. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1699. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1700. /*!50003 SET character_set_client  = latin1 */ ;
  1701. /*!50003 SET character_set_results = latin1 */ ;
  1702. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1703. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1704. /*!50003 SET sql_mode              = '' */ ;
  1705. DELIMITER ;;
  1706. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCTION_STOCK`(`I_PRODUCT_ID` INTEGER) RETURNS double
  1707.     READS SQL DATA
  1708.     DETERMINISTIC
  1709. BEGIN
  1710.     DECLARE TOTAL_PRODUCTION_QTY DOUBLE;
  1711.     DECLARE TOTAL_SALES_QTY DOUBLE;
  1712.     DECLARE TOTAL_AVAILABLE_STOCK DOUBLE;
  1713.    
  1714.     SELECT
  1715.         IFNULL(SUM(STOCK_QTY),0) INTO TOTAL_PRODUCTION_QTY
  1716.     FROM
  1717.         tbl_inv_production_stock
  1718.     WHERE
  1719.         tbl_inv_production_stock.STOCK_PRODUCT_ID = I_PRODUCT_ID;
  1720.    
  1721.     SELECT
  1722.         IFNULL(SUM(SALES_QTY),0) INTO TOTAL_SALES_QTY
  1723.     FROM
  1724.         tbl_inv_sales_invoice_item
  1725.     WHERE
  1726.         SALES_PRODUCT_ID = I_PRODUCT_ID;
  1727.    
  1728.     SET TOTAL_AVAILABLE_STOCK = TOTAL_PRODUCTION_QTY - TOTAL_SALES_QTY;    
  1729.    
  1730.     RETURN TOTAL_AVAILABLE_STOCK;
  1731. END ;;
  1732. DELIMITER ;
  1733. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1734. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1735. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1736. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1737. /*!50003 DROP FUNCTION IF EXISTS `F_GET_PRODUCT_STOCK` */;
  1738. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1739. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1740. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1741. /*!50003 SET character_set_client  = latin1 */ ;
  1742. /*!50003 SET character_set_results = latin1 */ ;
  1743. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1744. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1745. /*!50003 SET sql_mode              = '' */ ;
  1746. DELIMITER ;;
  1747. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCT_STOCK`(`PRODUCT_ID` INTEGER, `PRODUCTION_DT` DATE) RETURNS double
  1748. BEGIN
  1749.  
  1750.     DECLARE PRODUCTION_STOCK_QTY DOUBLE;
  1751.     DECLARE TOTAL_STOCK_QTY DOUBLE;    
  1752.    
  1753.     SELECT IFNULL(sum(STOCK_QTY),0) INTO PRODUCTION_STOCK_QTY
  1754.     FROM
  1755.     tbl_inv_production_stock,
  1756.     tbl_inv_production
  1757.     WHERE
  1758.     tbl_inv_production_stock.STOCK_PRODUCTION_ID = PRODU_ID AND
  1759.     tbl_inv_production_stock.STOCK_PRODUCT_ID = PRODUCT_ID AND
  1760.     tbl_inv_production.PRODU_DATE <= PRODUCTION_DT;
  1761.    
  1762.     SELECT IFNULL(sum((tbl_inv_packed_stock.PACK_QTY * tbl_inv_packet_master.PACKET_QTY)),0) INTO TOTAL_STOCK_QTY
  1763.     FROM tbl_inv_packed_stock,tbl_inv_packet_master where
  1764.     tbl_inv_packed_stock.PACK_MASTER_ID = tbl_inv_packet_master.PACKET_ID AND
  1765.     tbl_inv_packet_master.PACKET_PRODUCT_ID = PRODUCT_ID AND
  1766.     tbl_inv_packed_stock.PACK_DATE <= PRODUCTION_DT;
  1767.    
  1768.    
  1769.     RETURN PRODUCTION_STOCK_QTY - TOTAL_STOCK_QTY;
  1770.    
  1771. END ;;
  1772. DELIMITER ;
  1773. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1774. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1775. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1776. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1777. /*!50003 DROP FUNCTION IF EXISTS `F_GET_STOCK_AT_STORE` */;
  1778. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1779. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1780. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1781. /*!50003 SET character_set_client  = latin1 */ ;
  1782. /*!50003 SET character_set_results = latin1 */ ;
  1783. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1784. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1785. /*!50003 SET sql_mode              = '' */ ;
  1786. DELIMITER ;;
  1787. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_AT_STORE`(`STORE_ID` INT, `PACKING_MASTER_ID` INT) RETURNS int(11)
  1788. BEGIN
  1789.     DECLARE STOCK_AT_STORE INTEGER;
  1790.     DECLARE STOCK_SOLD INTEGER;
  1791.     DECLARE STOCK_RETURN INTEGER;
  1792.     DECLARE BALANCE_STOCK INTEGER;
  1793.    
  1794.     SELECT
  1795.         IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
  1796.     FROM
  1797.         tbl_inv_mini_stock
  1798.     WHERE
  1799.         MINI_LOCATION_ID = STORE_ID AND
  1800.         MINI_PACKET_MASTER_ID = PACKING_MASTER_ID;
  1801.    
  1802.     SELECT
  1803.         IFNULL(SUM(SALES_QTY),0) INTO STOCK_SOLD
  1804.     FROM
  1805.         tbl_inv_sales_invoice_item,
  1806.         tbl_inv_sales_invoice
  1807.     WHERE
  1808.         tbl_inv_sales_invoice_item.SALES_INVOICE_ID = tbl_inv_sales_invoice.SALES_INVOICE_ID AND
  1809.         tbl_inv_sales_invoice.SALES_MINI_STORE_LOCATION_ID = STORE_ID AND
  1810.         tbl_inv_sales_invoice_item.SALES_PRODUCT_ID = PACKING_MASTER_ID AND
  1811.         tbl_inv_sales_invoice.SALES_TYPE = 'S';
  1812.  
  1813.     SELECT
  1814.         IFNULL(SUM(SALES_QTY),0) INTO STOCK_RETURN
  1815.     FROM
  1816.         tbl_inv_sales_invoice_item,
  1817.         tbl_inv_sales_invoice
  1818.     WHERE
  1819.         tbl_inv_sales_invoice_item.SALES_INVOICE_ID = tbl_inv_sales_invoice.SALES_INVOICE_ID AND
  1820.         tbl_inv_sales_invoice.SALES_MINI_STORE_LOCATION_ID = STORE_ID AND
  1821.         tbl_inv_sales_invoice_item.SALES_PRODUCT_ID = PACKING_MASTER_ID AND
  1822.         tbl_inv_sales_invoice.SALES_TYPE = 'R';
  1823.        
  1824.     SET BALANCE_STOCK = (STOCK_AT_STORE + STOCK_RETURN) - STOCK_SOLD;
  1825.     return BALANCE_STOCK;
  1826.      
  1827. END ;;
  1828. DELIMITER ;
  1829. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1830. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1831. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1832. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1833. /*!50003 DROP FUNCTION IF EXISTS `F_GET_STOCK_BET_INV_AND_MINI` */;
  1834. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1835. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1836. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1837. /*!50003 SET character_set_client  = latin1 */ ;
  1838. /*!50003 SET character_set_results = latin1 */ ;
  1839. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1840. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1841. /*!50003 SET sql_mode              = '' */ ;
  1842. DELIMITER ;;
  1843. CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_BET_INV_AND_MINI`(`PACKET_MASTER_ID` INT) RETURNS int(11)
  1844. BEGIN
  1845.  
  1846.  
  1847.     DECLARE TOTAL_MINI_STOCK INTEGER;
  1848.     DECLARE TOTAL_PACKED_STOCK INTEGER;
  1849.    
  1850.     SELECT
  1851.         IFNULL(SUM(MINI_QTY),0) INTO TOTAL_MINI_STOCK
  1852.     FROM
  1853.         tbl_inv_mini_stock
  1854.     WHERE
  1855.         MINI_PACKET_MASTER_ID = PACKET_MASTER_ID;
  1856.    
  1857.     SELECT
  1858.         IFNULL(SUM(PACK_QTY),0) INTO TOTAL_PACKED_STOCK
  1859.     FROM
  1860.         tbl_inv_packed_stock
  1861.     WHERE
  1862.         tbl_inv_packed_stock.PACK_MASTER_ID = PACKET_MASTER_ID;
  1863.    
  1864.     RETURN TOTAL_PACKED_STOCK - TOTAL_MINI_STOCK;  
  1865.    
  1866.    
  1867.  
  1868.  
  1869. END ;;
  1870. DELIMITER ;
  1871. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1872. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1873. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1874. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1875. /*!50003 DROP PROCEDURE IF EXISTS `P_GENERATE_TRAIL_BALANCE_BY_GROUPS` */;
  1876. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1877. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1878. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1879. /*!50003 SET character_set_client  = latin1 */ ;
  1880. /*!50003 SET character_set_results = latin1 */ ;
  1881. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1882. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1883. /*!50003 SET sql_mode              = '' */ ;
  1884. DELIMITER ;;
  1885. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRAIL_BALANCE_BY_GROUPS`(`CURRENT_YEAR_START` DATE, `CURRENT_YEAR_END` DATE)
  1886.     NO SQL
  1887. begin
  1888.  
  1889.  
  1890. SELECT
  1891. tbl_acc_groups.*,
  1892.  F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  1893. F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  1894. FROM tbl_acc_groups WHERE `TYPE`<>'H';
  1895.  
  1896.  
  1897. end ;;
  1898. DELIMITER ;
  1899. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1900. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1901. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1902. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1903. /*!50003 DROP PROCEDURE IF EXISTS `P_GENERATE_TRIAL_BALANCE` */;
  1904. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1905. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1906. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1907. /*!50003 SET character_set_client  = latin1 */ ;
  1908. /*!50003 SET character_set_results = latin1 */ ;
  1909. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1910. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1911. /*!50003 SET sql_mode              = '' */ ;
  1912. DELIMITER ;;
  1913. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BALANCE`(`CURRENT_YEAR_ID` INTEGER(11))
  1914.     READS SQL DATA
  1915.     DETERMINISTIC
  1916. begin
  1917.  
  1918. DECLARE CURRENT_YEAR_START DATE;
  1919. DECLARE CURRENT_YEAR_END DATE;
  1920. DECLARE TOTAL_EXPENSE_PREV DOUBLE;
  1921. DECLARE TOTAL_EXPENSE_CUR DOUBLE;
  1922. DECLARE TOTAL_INCOME_PREV DOUBLE;
  1923. DECLARE TOTAL_INCOME_CUR DOUBLE;
  1924. DECLARE P_L_PREV DOUBLE;
  1925. DECLARE P_L_CURRENT DOUBLE;
  1926.  
  1927. SELECT YEAR_START,YEAR_END
  1928. INTO CURRENT_YEAR_START,CURRENT_YEAR_END
  1929. FROM tbl_financial_year
  1930. WHERE ID = CURRENT_YEAR_ID;  
  1931.  
  1932. SELECT
  1933. IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
  1934. IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
  1935. INTO TOTAL_INCOME_PREV,TOTAL_INCOME_CUR
  1936. FROM
  1937. tbl_acc_groups
  1938. WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 3);
  1939.  
  1940.  
  1941. SELECT
  1942. IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
  1943. IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
  1944. INTO TOTAL_EXPENSE_PREV,TOTAL_EXPENSE_CUR
  1945. FROM
  1946. tbl_acc_groups
  1947. WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 4);
  1948.  
  1949. SET P_L_PREV = TOTAL_EXPENSE_PREV - TOTAL_INCOME_PREV;
  1950. SET P_L_CURRENT = TOTAL_INCOME_CUR - TOTAL_EXPENSE_CUR;
  1951.  
  1952.  
  1953.  
  1954. SELECT
  1955. tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
  1956.  F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  1957. F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  1958. FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 1 UNION ALL
  1959. SELECT
  1960. tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
  1961.  F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  1962. F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  1963. FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 2 UNION ALL
  1964. SELECT '0' AS ID,'PROFIT AND LOSS A/C' AS G_H_NAME,'G' AS TYPE,0 AS CHILD_OF,P_L_PREV,0 UNION ALL
  1965. SELECT
  1966. tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
  1967.  F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  1968. F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  1969. FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 3 UNION ALL
  1970. SELECT
  1971. tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
  1972.  F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  1973. F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  1974. FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 4;
  1975.  
  1976.  
  1977.  
  1978.  
  1979. end ;;
  1980. DELIMITER ;
  1981. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  1982. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  1983. /*!50003 SET character_set_results = @saved_cs_results */ ;
  1984. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  1985. /*!50003 DROP PROCEDURE IF EXISTS `P_GENERATE_TRIAL_BAL_FOR_GROUP` */;
  1986. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  1987. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  1988. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  1989. /*!50003 SET character_set_client  = latin1 */ ;
  1990. /*!50003 SET character_set_results = latin1 */ ;
  1991. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  1992. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  1993. /*!50003 SET sql_mode              = '' */ ;
  1994. DELIMITER ;;
  1995. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BAL_FOR_GROUP`(`CURRENT_YEAR_ID` INTEGER(11), `GROUP_ID` INTEGER(11))
  1996. BEGIN
  1997. DECLARE CURRENT_YEAR_START DATE;
  1998. DECLARE CURRENT_YEAR_END DATE;
  1999.  
  2000.  
  2001. SELECT YEAR_START,YEAR_END
  2002. INTO CURRENT_YEAR_START,CURRENT_YEAR_END
  2003. FROM tbl_financial_year
  2004. WHERE ID = CURRENT_YEAR_ID;  
  2005.  
  2006. SELECT
  2007. tbl_acc_groups.*,
  2008. F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
  2009. F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
  2010. FROM
  2011. tbl_acc_groups
  2012. WHERE `TYPE` = 'H' AND CHILD_OF = GROUP_ID;
  2013.  
  2014. END ;;
  2015. DELIMITER ;
  2016. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2017. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2018. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2019. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2020. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_ACC_BALANCE` */;
  2021. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2022. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2023. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2024. /*!50003 SET character_set_client  = latin1 */ ;
  2025. /*!50003 SET character_set_results = latin1 */ ;
  2026. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2027. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2028. /*!50003 SET sql_mode              = '' */ ;
  2029. DELIMITER ;;
  2030. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE`(IN `ACC_ID` INT(11), IN `UNTIL_DATE` DATE)
  2031.     NO SQL
  2032.     DETERMINISTIC
  2033. begin
  2034.  
  2035.  
  2036. DECLARE DEBIT_TOTAL DOUBLE;
  2037. DECLARE CREDIT_TOTAL DOUBLE;
  2038. DECLARE OPENING_TOTAL DOUBLE;
  2039. DECLARE BALANCE DOUBLE;
  2040.  
  2041. SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
  2042. FROM tbl_opening_balance
  2043. WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;
  2044.  
  2045. SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
  2046. FROM tbl_transactions
  2047. WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;
  2048.  
  2049. SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
  2050. FROM tbl_transactions
  2051. WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;
  2052.  
  2053. IF(OPENING_TOTAL > 0) THEN
  2054.     SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
  2055. ELSE
  2056.     SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
  2057. END IF;
  2058.  
  2059. SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
  2060.  
  2061. IF(BALANCE < 0) THEN
  2062.        SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
  2063. ELSE
  2064.        SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;    
  2065. END IF;  
  2066.    
  2067. end ;;
  2068. DELIMITER ;
  2069. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2070. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2071. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2072. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2073. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_ACC_BALANCE_BETWEEN` */;
  2074. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2075. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2076. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2077. /*!50003 SET character_set_client  = latin1 */ ;
  2078. /*!50003 SET character_set_results = latin1 */ ;
  2079. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2080. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2081. /*!50003 SET sql_mode              = '' */ ;
  2082. DELIMITER ;;
  2083. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_BETWEEN`(`ACC_ID` INTEGER, `FROM_DATE` DATE, `TO_DATE` DATE)
  2084.     READS SQL DATA
  2085. begin
  2086.  
  2087.  
  2088. DECLARE DEBIT_TOTAL DOUBLE;
  2089. DECLARE CREDIT_TOTAL DOUBLE;
  2090. DECLARE BALANCE DOUBLE;
  2091.  
  2092. SELECT SUM(AMOUNT) INTO DEBIT_TOTAL
  2093. FROM tbl_transactions
  2094. WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND DEBIT_ACC_ID = ACC_ID;
  2095.  
  2096. SELECT SUM(AMOUNT) INTO CREDIT_TOTAL
  2097. FROM tbl_transactions
  2098. WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND CREDIT_ACC_ID = ACC_ID;
  2099.  
  2100. SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
  2101.  
  2102. IF(BALANCE < 0) THEN
  2103.        SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
  2104. ELSE
  2105.        SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;    
  2106. END IF;  
  2107.  
  2108. end ;;
  2109. DELIMITER ;
  2110. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2111. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2112. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2113. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2114. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_ACC_BALANCE_UNTIL_BY_GROUPS` */;
  2115. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2116. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2117. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2118. /*!50003 SET character_set_client  = latin1 */ ;
  2119. /*!50003 SET character_set_results = latin1 */ ;
  2120. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2121. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2122. /*!50003 SET sql_mode              = '' */ ;
  2123. DELIMITER ;;
  2124. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_UNTIL_BY_GROUPS`(`UNTIL_DATE` DATE)
  2125. BEGIN
  2126.     SELECT tbl_acc_groups.*,F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,UNTIL_DATE) AS BALANCE_TOTAL FROM tbl_acc_groups WHERE tbl_acc_groups.TYPE = 'G';
  2127. END ;;
  2128. DELIMITER ;
  2129. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2130. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2131. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2132. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2133. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_AVAIALBE_ITEM_STOCK` */;
  2134. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2135. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2136. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2137. /*!50003 SET character_set_client  = latin1 */ ;
  2138. /*!50003 SET character_set_results = latin1 */ ;
  2139. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2140. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2141. /*!50003 SET sql_mode              = '' */ ;
  2142. DELIMITER ;;
  2143. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_AVAIALBE_ITEM_STOCK`(IN `I_STOCK_DATE` DATE, IN `I_ITEM_ID` INT)
  2144. BEGIN
  2145.  
  2146. DECLARE TOTAL_ITEM_STOCK DOUBLE;
  2147. DECLARE TOTAL_OUT_STOCK DOUBLE;
  2148. DECLARE TOTAL_BALANCE_STOCK DOUBLE;
  2149.  
  2150. IF I_ITEM_ID = 0 THEN
  2151.  
  2152. SELECT tbl_inv_item_master.ITEM_ID,tbl_inv_item_master.ITEM_NAME,tbl_inv_units.UNIT_NAME,
  2153. (SELECT IFNULL(SUM(tbl_inv_purchase_invoice_item.INV_ITEM_QTY),0)
  2154. FROM tbl_inv_purchase_invoice_item,tbl_inv_purchase_invoice
  2155. WHERE tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID AND
  2156. tbl_inv_purchase_invoice.INV_DATE <= I_STOCK_DATE AND
  2157. tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID) -
  2158. (SELECT IFNULL(SUM(tbl_inv_production_items.P_ITEM_QTY),0)
  2159. FROM tbl_inv_production_items,tbl_inv_production
  2160. WHERE
  2161. tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID AND
  2162. tbl_inv_production.PRODU_DATE <= I_STOCK_DATE AND
  2163. tbl_inv_production_items.P_ITEM_MASTR_ID = tbl_inv_item_master.ITEM_ID) AS TOTAL_BALANCE_STOCK
  2164. FROM
  2165. tbl_inv_item_master,tbl_inv_units
  2166. WHERE
  2167. tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID;
  2168.  
  2169. ELSE
  2170.  
  2171. SELECT
  2172.   tbl_inv_item_master.ITEM_NAME,
  2173.   tbl_inv_units.UNIT_NAME,
  2174.   ((SELECT
  2175.     IFNULL(SUM(tbl_inv_purchase_invoice_item.INV_ITEM_QTY),0)
  2176.   FROM tbl_inv_purchase_invoice_item,
  2177.        tbl_inv_purchase_invoice,
  2178.        tbl_inv_item_master
  2179.   WHERE tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID
  2180.   AND tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID
  2181.   AND tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = I_ITEM_ID
  2182.   AND tbl_inv_purchase_invoice.INV_DATE <= I_STOCK_DATE
  2183.   )
  2184.   - (SELECT
  2185.     IFNULL(SUM(tbl_inv_production_items.P_ITEM_QTY),0)
  2186.   FROM tbl_inv_production_items,
  2187.        tbl_inv_production,
  2188.        tbl_inv_item_master
  2189.   WHERE tbl_inv_production_items.P_ITEM_MASTR_ID = tbl_inv_item_master.ITEM_ID
  2190.   AND tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID
  2191.   AND tbl_inv_production_items.P_ITEM_MASTR_ID = I_ITEM_ID
  2192.   AND tbl_inv_production.PRODU_DATE <= I_STOCK_DATE
  2193.   )
  2194.   ) AS TOTAL_BALANCE_STOCK FROM
  2195.   tbl_inv_item_master,
  2196.   tbl_inv_units
  2197. WHERE tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID
  2198. AND tbl_inv_item_master.ITEM_ID = I_ITEM_ID;
  2199.  
  2200.  
  2201. END IF;
  2202.  
  2203. END ;;
  2204. DELIMITER ;
  2205. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2206. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2207. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2208. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2209. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_HOME_DATA` */;
  2210. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2211. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2212. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2213. /*!50003 SET character_set_client  = latin1 */ ;
  2214. /*!50003 SET character_set_results = latin1 */ ;
  2215. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2216. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2217. /*!50003 SET sql_mode              = '' */ ;
  2218. DELIMITER ;;
  2219. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_HOME_DATA`(IN `SALESMAN_ID` INT, IN `I_DATE` DATE)
  2220. BEGIN
  2221.  
  2222. DECLARE SALES_INVOICE_TOTAL DOUBLE;
  2223. DECLARE SALES_INVOICE_COUNT INTEGER;
  2224. DECLARE BALACE_STOCK_PACKET_COUNT INTEGER;
  2225. DECLARE BALACE_STOCK_CATEGORY_COUNT INTEGER;
  2226. DECLARE RETURN_TOTAL DOUBLE;
  2227. DECLARE RETURN_ITEM_PACKET_COUNT INTEGER;
  2228. DECLARE ORDER_COUNT INTEGER;  
  2229. DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
  2230. DECLARE STOCK_AT_STORE INTEGER;
  2231. DECLARE STOCK_AT_VAN INTEGER;  
  2232.  
  2233. SELECT  
  2234.     MINIL_ID  
  2235. INTO  
  2236.     CURRENT_STOCK_LOCATION_ID  
  2237. FROM  
  2238.     tbl_inv_mini_stock_location  
  2239. WHERE MINIL_SALESMAN_ID = SALESMAN_ID;
  2240.  
  2241. SELECT IFNULL(SUM(MINI_INV_TOTAL),0) INTO SALES_INVOICE_TOTAL FROM tbl_mini_invoice_items,tbl_mini_invoice_master WHERE
  2242. tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
  2243. date(MINI_INV_DATE) = I_DATE AND
  2244.     MINI_INV_SALES_MAN_ID = SALESMAN_ID;
  2245.      
  2246. SELECT  
  2247.     COUNT(*) INTO SALES_INVOICE_COUNT
  2248. FROM  
  2249.     tbl_mini_invoice_master  
  2250. WHERE  
  2251.     date(MINI_INV_DATE) = I_DATE AND
  2252.     MINI_INV_SALES_MAN_ID = SALESMAN_ID;
  2253.  
  2254. SELECT  
  2255.     IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
  2256. FROM  
  2257.     tbl_inv_mini_stock  
  2258. WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID;
  2259.  
  2260. SELECT  
  2261.     IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN  
  2262. FROM  
  2263.     tbl_mini_invoice_items,
  2264.     tbl_mini_invoice_master  
  2265. WHERE  
  2266.     tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND  
  2267.     tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID;
  2268.  
  2269. SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;
  2270.  
  2271. SELECT COUNT(*) INTO BALACE_STOCK_CATEGORY_COUNT FROM
  2272.   (SELECT MINI_PACKET_MASTER_ID,SUM(MINI_QTY) - IFNULL(
  2273.      (SELECT SUM(MINI_INV_ITEM_QTY)
  2274.       FROM tbl_mini_invoice_items,tbl_mini_invoice_master
  2275.       WHERE tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID
  2276.         AND tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID
  2277.         AND MINI_INV_ITEM_PACKET_ID = MINI_PACKET_MASTER_ID
  2278.       GROUP BY MINI_INV_ITEM_PACKET_ID),0) AS QTY
  2279.    FROM tbl_inv_mini_stock
  2280.    WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID
  2281.    GROUP BY MINI_PACKET_MASTER_ID
  2282.    HAVING QTY<> 0) AS tbl_temp_qty;
  2283.  
  2284. SELECT  
  2285.     COUNT(*) INTO ORDER_COUNT  
  2286. FROM  
  2287.     tbl_mini_order_master  
  2288. WHERE  
  2289.     MINI_ORD_SALESMAN_ID = SALESMAN_ID AND  
  2290.     date(MINI_ORD_DATE) = I_DATE AND
  2291.     MINI_ORD_STATUS = 'N';
  2292. SELECT  
  2293.     IFNULL(SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY),0) INTO RETURN_ITEM_PACKET_COUNT
  2294. FROM  
  2295.     tbl_mini_return_items,tbl_mini_return_master
  2296. where
  2297.     tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
  2298.     tbl_mini_return_master.MINI_RET_SALES_MAN_ID = SALESMAN_ID AND
  2299.     date(MINI_RET_DATE) = I_DATE;
  2300.  
  2301.  
  2302. SELECT IFNULL(SUM(MINI_RET_TOTAL),0) INTO RETURN_TOTAL FROM tbl_mini_return_items,tbl_mini_return_master WHERE
  2303. tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
  2304. date(MINI_RET_DATE) = I_DATE AND
  2305.     MINI_RET_SALES_MAN_ID = SALESMAN_ID;    
  2306.  
  2307.  
  2308. SET SALES_INVOICE_TOTAL = SALES_INVOICE_TOTAL - RETURN_TOTAL;
  2309. SET BALACE_STOCK_PACKET_COUNT = BALACE_STOCK_PACKET_COUNT + RETURN_ITEM_PACKET_COUNT;
  2310.    
  2311. SELECT
  2312.  
  2313.     RETURN_ITEM_PACKET_COUNT,
  2314.     RETURN_TOTAL,
  2315.     ORDER_COUNT,
  2316.     SALES_INVOICE_TOTAL,
  2317.     SALES_INVOICE_COUNT,
  2318.     BALACE_STOCK_PACKET_COUNT,
  2319.     BALACE_STOCK_CATEGORY_COUNT;
  2320.  
  2321.  
  2322. END ;;
  2323. DELIMITER ;
  2324. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2325. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2326. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2327. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2328. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_INVOICE_ITEMS_INV_ID` */;
  2329. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2330. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2331. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2332. /*!50003 SET character_set_client  = latin1 */ ;
  2333. /*!50003 SET character_set_results = latin1 */ ;
  2334. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2335. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2336. /*!50003 SET sql_mode              = '' */ ;
  2337. DELIMITER ;;
  2338. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_INVOICE_ITEMS_INV_ID`(IN `I_INV_ID` INT)
  2339. BEGIN
  2340.  
  2341. SELECT
  2342.     tbl_inv_purchase_invoice_item.*,   
  2343.     tbl_inv_item_master.ITEM_ID,
  2344.     tbl_inv_item_master.ITEM_NAME,
  2345.     tbl_inv_item_master.ITEM_HEAD_ID,
  2346.     tbl_inv_units.UNIT_NAME
  2347.  
  2348. FROM tbl_inv_purchase_invoice_item,
  2349.     tbl_inv_item_master,
  2350.     tbl_inv_category,tbl_inv_units
  2351. WHERE
  2352.     tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID AND
  2353.     tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID AND
  2354.     tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = I_INV_ID
  2355. GROUP BY
  2356.     tbl_inv_purchase_invoice_item.INV_ITEM_ID;
  2357. END ;;
  2358. DELIMITER ;
  2359. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2360. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2361. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2362. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2363. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_ITEM_MASTER_DETAILED` */;
  2364. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2365. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2366. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2367. /*!50003 SET character_set_client  = latin1 */ ;
  2368. /*!50003 SET character_set_results = latin1 */ ;
  2369. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2370. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2371. /*!50003 SET sql_mode              = '' */ ;
  2372. DELIMITER ;;
  2373. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ITEM_MASTER_DETAILED`()
  2374. BEGIN
  2375. SELECT
  2376.     tbl_inv_item_master.ITEM_ID,
  2377.     tbl_inv_item_master.ITEM_NAME,
  2378.     tbl_inv_category.CATEGORY_NAME,
  2379.     tbl_inv_units.UNIT_NAME
  2380.  
  2381. FROM
  2382.     tbl_inv_item_master,
  2383.     tbl_inv_category,tbl_inv_units
  2384. WHERE
  2385.     tbl_inv_item_master.ITEM_CATEGORY_ID = tbl_inv_category.CATEGORY_ID AND
  2386.     tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID;
  2387. END ;;
  2388. DELIMITER ;
  2389. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2390. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2391. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2392. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2393. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_MINI_PRODUCT_STOCK` */;
  2394. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2395. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2396. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2397. /*!50003 SET character_set_client  = latin1 */ ;
  2398. /*!50003 SET character_set_results = latin1 */ ;
  2399. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2400. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2401. /*!50003 SET sql_mode              = '' */ ;
  2402. DELIMITER ;;
  2403. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_PRODUCT_STOCK`(IN `SALESMAN_ID` INT)
  2404. BEGIN
  2405.  
  2406. DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
  2407. SELECT
  2408.     MINIL_ID
  2409. INTO
  2410.     CURRENT_STOCK_LOCATION_ID
  2411. FROM
  2412.     tbl_inv_mini_stock_location
  2413. WHERE MINIL_SALESMAN_ID = SALESMAN_ID;
  2414.  
  2415. SELECT CONCAT(tbl_inv_product.PROD_NAME," - ",tbl_inv_packet_master.PACKET_NAME) AS PACKET_NAME,(SELECT
  2416.     IFNULL(SUM(MINI_QTY),0)
  2417. FROM
  2418.     tbl_inv_mini_stock
  2419. WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID AND MINI_PACKET_MASTER_ID = PACKET_ID) -
  2420.  
  2421. (SELECT
  2422.     IFNULL(SUM(MINI_INV_ITEM_QTY),0)
  2423. FROM
  2424.     tbl_mini_invoice_items,
  2425.     tbl_mini_invoice_master
  2426. WHERE
  2427.     tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
  2428.     tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID AND
  2429.     tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PACKET_ID) + (SELECT IFNULL(SUM(MINI_RET_ITEM_QTY),0) FROM tbl_mini_return_items WHERE MINI_RET_ITEM_PACKET_ID = PACKET_ID) AS STOCK,tbl_inv_product.PROD_IMAGE
  2430.     FROM tbl_inv_packet_master,tbl_inv_product WHERE tbl_inv_packet_master.PACKET_PRODUCT_ID = tbl_inv_product.PROD_ID HAVING STOCK>0;
  2431.  
  2432.  
  2433. END ;;
  2434. DELIMITER ;
  2435. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2436. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2437. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2438. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2439. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_MINI_RETURNABLE_QTY` */;
  2440. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2441. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2442. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2443. /*!50003 SET character_set_client  = latin1 */ ;
  2444. /*!50003 SET character_set_results = latin1 */ ;
  2445. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2446. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2447. /*!50003 SET sql_mode              = '' */ ;
  2448. DELIMITER ;;
  2449. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_RETURNABLE_QTY`(IN `CUSTOMER_ID` INT, IN `PACKET_ID` INT)
  2450. BEGIN
  2451.  
  2452. SELECT IFNULL((SELECT  
  2453. SUM(tbl_mini_invoice_items.MINI_INV_ITEM_QTY)  
  2454. FROM  
  2455. tbl_mini_invoice_items,
  2456. tbl_mini_invoice_master  
  2457. WHERE  
  2458. tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
  2459. tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PACKET_ID AND
  2460. tbl_mini_invoice_master.MINI_INV_CUSTOMER_ID = CUSTOMER_ID),0) - IFNULL((SELECT  
  2461. SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY)  
  2462. FROM  
  2463. tbl_mini_return_items,
  2464. tbl_mini_return_master  
  2465. WHERE  
  2466. tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
  2467. tbl_mini_return_items.MINI_RET_ITEM_PACKET_ID = PACKET_ID AND
  2468. tbl_mini_return_master.MINI_RET_CUSTOMER_ID = CUSTOMER_ID),0) AS MAX_RETURN_QTY;
  2469.  
  2470. END ;;
  2471. DELIMITER ;
  2472. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2473. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2474. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2475. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2476. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_NEW_INV_ORDER_NUM` */;
  2477. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2478. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2479. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2480. /*!50003 SET character_set_client  = latin1 */ ;
  2481. /*!50003 SET character_set_results = latin1 */ ;
  2482. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2483. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2484. /*!50003 SET sql_mode              = '' */ ;
  2485. DELIMITER ;;
  2486. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_ORDER_NUM`()
  2487. BEGIN
  2488.     DECLARE NORDER_ID INTEGER;
  2489.     START TRANSACTION;
  2490.     SELECT IFNULL(MAX(ORDER_ID),0) INTO NORDER_ID FROM tbl_inv_purchase_order;
  2491.     SET NORDER_ID = NORDER_ID+1;
  2492.     INSERT INTO tbl_inv_purchase_order VALUES(NORDER_ID,NULL,NULL,NULL,current_timestamp());
  2493.     SELECT NORDER_ID AS NEW_ORDER_NUM;    
  2494.     COMMIT;
  2495. END ;;
  2496. DELIMITER ;
  2497. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2498. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2499. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2500. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2501. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_NEW_INV_SALES_ORDER_NUM` */;
  2502. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2503. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2504. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2505. /*!50003 SET character_set_client  = latin1 */ ;
  2506. /*!50003 SET character_set_results = latin1 */ ;
  2507. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2508. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2509. /*!50003 SET sql_mode              = '' */ ;
  2510. DELIMITER ;;
  2511. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_SALES_ORDER_NUM`()
  2512. BEGIN
  2513.     DECLARE NORDER_ID INTEGER;
  2514.     START TRANSACTION;
  2515.     SELECT IFNULL(MAX(SALES_ORDER_ID),0) INTO NORDER_ID FROM tbl_inv_sales_order;
  2516.     SET NORDER_ID = NORDER_ID+1;
  2517.     INSERT INTO tbl_inv_sales_order VALUES(NORDER_ID,NULL,NULL,NULL,NULL,current_timestamp());
  2518.     SELECT NORDER_ID AS NEW_ORDER_NUM;    
  2519.     COMMIT;
  2520. END ;;
  2521. DELIMITER ;
  2522. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2523. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2524. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2525. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2526. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_NEW_VOUCHER_NUMBER` */;
  2527. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2528. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2529. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2530. /*!50003 SET character_set_client  = latin1 */ ;
  2531. /*!50003 SET character_set_results = latin1 */ ;
  2532. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2533. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2534. /*!50003 SET sql_mode              = '' */ ;
  2535. DELIMITER ;;
  2536. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_VOUCHER_NUMBER`(IN `P_TYPE` VARCHAR(2))
  2537.     NO SQL
  2538.     DETERMINISTIC
  2539. begin
  2540.  
  2541. DECLARE VOUCHER_TEMP INTEGER;
  2542.  
  2543. SET VOUCHER_TEMP = 1;
  2544.    case
  2545.    
  2546.      when P_TYPE = "CP" then
  2547.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CP";  
  2548.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2549.         SELECT CONCAT("CP",VOUCHER_TEMP) AS V_CODE;
  2550.      when P_TYPE = "BP" then
  2551.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "BP";  
  2552.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2553.         SELECT CONCAT("BP",VOUCHER_TEMP) AS V_CODE;  
  2554.      when P_TYPE = "RC" then
  2555.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "RC";  
  2556.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2557.         SELECT CONCAT("RC",VOUCHER_TEMP) AS V_CODE;
  2558.      when P_TYPE = "RB" then
  2559.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "RB";  
  2560.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2561.         SELECT CONCAT("RB",VOUCHER_TEMP) AS V_CODE;  
  2562.      when P_TYPE = "JV" then
  2563.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "JV";  
  2564.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2565.         SELECT CONCAT("JV",VOUCHER_TEMP) AS V_CODE;
  2566.      when P_TYPE = "CN" then
  2567.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CN";  
  2568.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2569.         SELECT CONCAT("CN",VOUCHER_TEMP) AS V_CODE;
  2570.      when P_TYPE = "DN" then
  2571.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "DN";  
  2572.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2573.         SELECT CONCAT("DN",VOUCHER_TEMP) AS V_CODE;
  2574.      when P_TYPE = "CR" then
  2575.         SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CR";  
  2576.         SET VOUCHER_TEMP = VOUCHER_TEMP+1;  
  2577.         SELECT CONCAT("CR",VOUCHER_TEMP) AS V_CODE;
  2578.      
  2579.        
  2580.    end case;
  2581.        
  2582. end ;;
  2583. DELIMITER ;
  2584. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2585. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2586. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2587. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2588. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_ORDER_ITEMS_BY_OID` */;
  2589. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2590. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2591. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2592. /*!50003 SET character_set_client  = latin1 */ ;
  2593. /*!50003 SET character_set_results = latin1 */ ;
  2594. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2595. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2596. /*!50003 SET sql_mode              = '' */ ;
  2597. DELIMITER ;;
  2598. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ORDER_ITEMS_BY_OID`(IN `I_ORDER_ID` INT)
  2599. BEGIN
  2600. SELECT
  2601.     tbl_inv_purchase_order_item.*,
  2602.     tbl_inv_item_master.ITEM_ID,
  2603.     tbl_inv_item_master.ITEM_NAME,
  2604.     tbl_inv_item_master.ITEM_HEAD_ID,
  2605.     tbl_inv_units.UNIT_NAME
  2606.  
  2607. FROM tbl_inv_purchase_order_item,
  2608.     tbl_inv_item_master,
  2609.     tbl_inv_category,tbl_inv_units
  2610. WHERE
  2611.     tbl_inv_purchase_order_item.ITEM_O_MASTER_ID = tbl_inv_item_master.ITEM_ID AND
  2612.     tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID AND
  2613.     tbl_inv_purchase_order_item.ITEM_O_ORDER_ID = I_ORDER_ID
  2614. GROUP BY
  2615.     tbl_inv_purchase_order_item.ITEM_O_ID;
  2616. END ;;
  2617. DELIMITER ;
  2618. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2619. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2620. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2621. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2622. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_PRODUCT_STOCK_AT_STORE` */;
  2623. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2624. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2625. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2626. /*!50003 SET character_set_client  = latin1 */ ;
  2627. /*!50003 SET character_set_results = latin1 */ ;
  2628. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2629. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2630. /*!50003 SET sql_mode              = '' */ ;
  2631. DELIMITER ;;
  2632. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_PRODUCT_STOCK_AT_STORE`(STORE_ID INTEGER,PRODUCT_ID INTEGER)
  2633. BEGIN
  2634.  
  2635. DECLARE STOCK_AT_STORE DOUBLE;
  2636. DECLARE STOCK_AT_VAN DOUBLE;
  2637. DECLARE BALACE_STOCK_PACKET_COUNT DOUBLE;
  2638.  
  2639. SELECT
  2640.     IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
  2641. FROM
  2642.     tbl_inv_mini_stock
  2643. WHERE MINI_LOCATION_ID = STORE_ID AND MINI_PACKET_MASTER_ID = PRODUCT_ID;
  2644.  
  2645. SELECT
  2646.     IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN
  2647. FROM
  2648.     tbl_mini_invoice_items,
  2649.     tbl_mini_invoice_master
  2650. WHERE
  2651.     tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
  2652.     tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = STORE_ID AND
  2653.     tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PRODUCT_ID;
  2654.  
  2655. SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;
  2656. SELECT BALACE_STOCK_PACKET_COUNT;
  2657.  
  2658. END ;;
  2659. DELIMITER ;
  2660. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2661. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2662. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2663. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2664. /*!50003 DROP PROCEDURE IF EXISTS `P_GET_STOCK_LEDGER` */;
  2665. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2666. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2667. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2668. /*!50003 SET character_set_client  = latin1 */ ;
  2669. /*!50003 SET character_set_results = latin1 */ ;
  2670. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2671. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2672. /*!50003 SET sql_mode              = '' */ ;
  2673. DELIMITER ;;
  2674. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_STOCK_LEDGER`(`I_ITEM_ID` INTEGER, `FROM_DT` DATE, `TO_DT` DATE)
  2675. BEGIN
  2676.  
  2677.  
  2678.  
  2679. SELECT
  2680.  tbl_inv_purchase_invoice.INV_DATE AS LEDGER_DT,
  2681.  tbl_inv_purchase_invoice.INV_INV_NUMBER AS LEDGER_NUM,
  2682.  tbl_inv_supplier.SUPP_NAME AS LEDGER_SUP_PROD,
  2683.  tbl_inv_purchase_invoice_item.INV_ITEM_QTY AS LEDGER_QTY,
  2684.  ' ' AS LEDGER_STOCK_OUT
  2685.  
  2686. FROM
  2687.  tbl_inv_purchase_invoice_item,
  2688.  tbl_inv_purchase_invoice,
  2689.  tbl_inv_supplier
  2690. WHERE
  2691.  tbl_inv_purchase_invoice.INV_SUPPLIER_ID = tbl_inv_supplier.SUPP_ID AND
  2692.  tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID AND
  2693.  tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = I_ITEM_ID AND
  2694.  (tbl_inv_purchase_invoice.INV_DATE BETWEEN FROM_DT AND TO_DT)
  2695.  
  2696. UNION ALL
  2697.  
  2698. SELECT  
  2699.   tbl_inv_production.PRODU_DATE AS LEDGER_DT,
  2700.   tbl_inv_production.PRODU_PRODUCT_ID AS LEDGER_NUM,
  2701.   tbl_inv_product.PROD_NAME AS LEDGER_SUP_PROD,
  2702.   ' ' AS LEDGER_QTY,
  2703.   tbl_inv_production_items.P_ITEM_QTY AS LEDGER_STOCK_OUT
  2704.  
  2705.  
  2706. FROM
  2707.   tbl_inv_production_items,
  2708.   tbl_inv_production,
  2709.   tbl_inv_product
  2710. WHERE
  2711.  tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID AND
  2712.  tbl_inv_production.PRODU_PRODUCT_ID = tbl_inv_product.PROD_ID AND
  2713.  (tbl_inv_production.PRODU_DATE BETWEEN FROM_DT AND TO_DT) AND
  2714.  tbl_inv_production_items.P_ITEM_MASTR_ID = I_ITEM_ID ORDER BY LEDGER_DT;
  2715.  
  2716.  
  2717. END ;;
  2718. DELIMITER ;
  2719. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2720. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2721. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2722. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2723. /*!50003 DROP PROCEDURE IF EXISTS `P_UPDATE_SALES_INVOICE_NUMBER` */;
  2724. /*!50003 SET @saved_cs_client      = @@character_set_client */ ;
  2725. /*!50003 SET @saved_cs_results     = @@character_set_results */ ;
  2726. /*!50003 SET @saved_col_connection = @@collation_connection */ ;
  2727. /*!50003 SET character_set_client  = latin1 */ ;
  2728. /*!50003 SET character_set_results = latin1 */ ;
  2729. /*!50003 SET collation_connection  = latin1_swedish_ci */ ;
  2730. /*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
  2731. /*!50003 SET sql_mode              = '' */ ;
  2732. DELIMITER ;;
  2733. CREATE DEFINER=`root`@`localhost` PROCEDURE `P_UPDATE_SALES_INVOICE_NUMBER`(`I_SALES_MAN_ID` INTEGER, `I_INVOICE_ID` INTEGER)
  2734. BEGIN
  2735.     UPDATE tbl_inv_sales_invoice SET SALES_INVOICE_NUM =  
  2736.     F_GET_INVOICE_NUMBER(I_SALES_MAN_ID) WHERE SALES_INVOICE_ID = I_INVOICE_ID;
  2737. END ;;
  2738. DELIMITER ;
  2739. /*!50003 SET sql_mode              = @saved_sql_mode */ ;
  2740. /*!50003 SET character_set_client  = @saved_cs_client */ ;
  2741. /*!50003 SET character_set_results = @saved_cs_results */ ;
  2742. /*!50003 SET collation_connection  = @saved_col_connection */ ;
  2743. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  2744.  
  2745. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  2746. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  2747. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  2748. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  2749. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  2750. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  2751. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  2752.  
  2753. -- Dump completed on 2017-05-15 10:34:08
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!