· 9 years ago · May 15, 2017, 05:06 AM
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
22DROP TABLE IF EXISTS `tbl_acc_groups`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE 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
40LOCK TABLES `tbl_acc_groups` WRITE;
41/*!40000 ALTER TABLE `tbl_acc_groups` DISABLE KEYS */;
42INSERT 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 */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `tbl_acc_master`
48--
49
50DROP TABLE IF EXISTS `tbl_acc_master`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE 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
65LOCK TABLES `tbl_acc_master` WRITE;
66/*!40000 ALTER TABLE `tbl_acc_master` DISABLE KEYS */;
67INSERT INTO `tbl_acc_master` VALUES (1,'Asset'),(2,'Liability'),(3,'Income'),(4,'Expense');
68/*!40000 ALTER TABLE `tbl_acc_master` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `tbl_bank_transactions`
73--
74
75DROP TABLE IF EXISTS `tbl_bank_transactions`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE 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
102LOCK TABLES `tbl_bank_transactions` WRITE;
103/*!40000 ALTER TABLE `tbl_bank_transactions` DISABLE KEYS */;
104INSERT 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 */;
106UNLOCK TABLES;
107
108--
109-- Table structure for table `tbl_company_info`
110--
111
112DROP TABLE IF EXISTS `tbl_company_info`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!40101 SET character_set_client = utf8 */;
115CREATE 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
132LOCK TABLES `tbl_company_info` WRITE;
133/*!40000 ALTER TABLE `tbl_company_info` DISABLE KEYS */;
134INSERT 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 */;
136UNLOCK TABLES;
137
138--
139-- Table structure for table `tbl_country`
140--
141
142DROP TABLE IF EXISTS `tbl_country`;
143/*!40101 SET @saved_cs_client = @@character_set_client */;
144/*!40101 SET character_set_client = utf8 */;
145CREATE 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
156LOCK TABLES `tbl_country` WRITE;
157/*!40000 ALTER TABLE `tbl_country` DISABLE KEYS */;
158INSERT INTO `tbl_country` VALUES (1,'INDIA'),(2,'UAE'),(3,'KSA');
159/*!40000 ALTER TABLE `tbl_country` ENABLE KEYS */;
160UNLOCK TABLES;
161
162--
163-- Table structure for table `tbl_dup_transactions`
164--
165
166DROP TABLE IF EXISTS `tbl_dup_transactions`;
167/*!40101 SET @saved_cs_client = @@character_set_client */;
168/*!40101 SET character_set_client = utf8 */;
169CREATE 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
192LOCK TABLES `tbl_dup_transactions` WRITE;
193/*!40000 ALTER TABLE `tbl_dup_transactions` DISABLE KEYS */;
194/*!40000 ALTER TABLE `tbl_dup_transactions` ENABLE KEYS */;
195UNLOCK TABLES;
196
197--
198-- Table structure for table `tbl_financial_year`
199--
200
201DROP TABLE IF EXISTS `tbl_financial_year`;
202/*!40101 SET @saved_cs_client = @@character_set_client */;
203/*!40101 SET character_set_client = utf8 */;
204CREATE 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
216LOCK TABLES `tbl_financial_year` WRITE;
217/*!40000 ALTER TABLE `tbl_financial_year` DISABLE KEYS */;
218INSERT 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 */;
220UNLOCK TABLES;
221
222--
223-- Table structure for table `tbl_inv_category`
224--
225
226DROP TABLE IF EXISTS `tbl_inv_category`;
227/*!40101 SET @saved_cs_client = @@character_set_client */;
228/*!40101 SET character_set_client = utf8 */;
229CREATE 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
241LOCK TABLES `tbl_inv_category` WRITE;
242/*!40000 ALTER TABLE `tbl_inv_category` DISABLE KEYS */;
243INSERT 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 */;
245UNLOCK TABLES;
246
247--
248-- Table structure for table `tbl_inv_cost_master`
249--
250
251DROP TABLE IF EXISTS `tbl_inv_cost_master`;
252/*!40101 SET @saved_cs_client = @@character_set_client */;
253/*!40101 SET character_set_client = utf8 */;
254CREATE 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
266LOCK 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 */;
269UNLOCK TABLES;
270
271--
272-- Table structure for table `tbl_inv_cost_master_items`
273--
274
275DROP TABLE IF EXISTS `tbl_inv_cost_master_items`;
276/*!40101 SET @saved_cs_client = @@character_set_client */;
277/*!40101 SET character_set_client = utf8 */;
278CREATE 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
291LOCK 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 */;
294UNLOCK TABLES;
295
296--
297-- Table structure for table `tbl_inv_customer`
298--
299
300DROP TABLE IF EXISTS `tbl_inv_customer`;
301/*!40101 SET @saved_cs_client = @@character_set_client */;
302/*!40101 SET character_set_client = utf8 */;
303CREATE 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
322LOCK TABLES `tbl_inv_customer` WRITE;
323/*!40000 ALTER TABLE `tbl_inv_customer` DISABLE KEYS */;
324INSERT 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 */;
326UNLOCK TABLES;
327
328--
329-- Table structure for table `tbl_inv_item_master`
330--
331
332DROP TABLE IF EXISTS `tbl_inv_item_master`;
333/*!40101 SET @saved_cs_client = @@character_set_client */;
334/*!40101 SET character_set_client = utf8 */;
335CREATE 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
349LOCK TABLES `tbl_inv_item_master` WRITE;
350/*!40000 ALTER TABLE `tbl_inv_item_master` DISABLE KEYS */;
351INSERT 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 */;
353UNLOCK TABLES;
354
355--
356-- Table structure for table `tbl_inv_mini_stock`
357--
358
359DROP TABLE IF EXISTS `tbl_inv_mini_stock`;
360/*!40101 SET @saved_cs_client = @@character_set_client */;
361/*!40101 SET character_set_client = utf8 */;
362CREATE 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
379LOCK TABLES `tbl_inv_mini_stock` WRITE;
380/*!40000 ALTER TABLE `tbl_inv_mini_stock` DISABLE KEYS */;
381INSERT 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 */;
383UNLOCK TABLES;
384
385--
386-- Table structure for table `tbl_inv_mini_stock_location`
387--
388
389DROP TABLE IF EXISTS `tbl_inv_mini_stock_location`;
390/*!40101 SET @saved_cs_client = @@character_set_client */;
391/*!40101 SET character_set_client = utf8 */;
392CREATE 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
404LOCK TABLES `tbl_inv_mini_stock_location` WRITE;
405/*!40000 ALTER TABLE `tbl_inv_mini_stock_location` DISABLE KEYS */;
406INSERT 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 */;
408UNLOCK TABLES;
409
410--
411-- Table structure for table `tbl_inv_packed_stock`
412--
413
414DROP TABLE IF EXISTS `tbl_inv_packed_stock`;
415/*!40101 SET @saved_cs_client = @@character_set_client */;
416/*!40101 SET character_set_client = utf8 */;
417CREATE 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
431LOCK TABLES `tbl_inv_packed_stock` WRITE;
432/*!40000 ALTER TABLE `tbl_inv_packed_stock` DISABLE KEYS */;
433INSERT 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 */;
435UNLOCK TABLES;
436
437--
438-- Table structure for table `tbl_inv_packet_master`
439--
440
441DROP TABLE IF EXISTS `tbl_inv_packet_master`;
442/*!40101 SET @saved_cs_client = @@character_set_client */;
443/*!40101 SET character_set_client = utf8 */;
444CREATE 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
461LOCK TABLES `tbl_inv_packet_master` WRITE;
462/*!40000 ALTER TABLE `tbl_inv_packet_master` DISABLE KEYS */;
463INSERT 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 */;
465UNLOCK TABLES;
466
467--
468-- Table structure for table `tbl_inv_packet_raw_materials`
469--
470
471DROP TABLE IF EXISTS `tbl_inv_packet_raw_materials`;
472/*!40101 SET @saved_cs_client = @@character_set_client */;
473/*!40101 SET character_set_client = utf8 */;
474CREATE 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
487LOCK 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 */;
490UNLOCK TABLES;
491
492--
493-- Table structure for table `tbl_inv_product`
494--
495
496DROP TABLE IF EXISTS `tbl_inv_product`;
497/*!40101 SET @saved_cs_client = @@character_set_client */;
498/*!40101 SET character_set_client = utf8 */;
499CREATE 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
514LOCK TABLES `tbl_inv_product` WRITE;
515/*!40000 ALTER TABLE `tbl_inv_product` DISABLE KEYS */;
516INSERT 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 */;
518UNLOCK TABLES;
519
520--
521-- Table structure for table `tbl_inv_product_price_master`
522--
523
524DROP TABLE IF EXISTS `tbl_inv_product_price_master`;
525/*!40101 SET @saved_cs_client = @@character_set_client */;
526/*!40101 SET character_set_client = utf8 */;
527CREATE 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
538LOCK TABLES `tbl_inv_product_price_master` WRITE;
539/*!40000 ALTER TABLE `tbl_inv_product_price_master` DISABLE KEYS */;
540INSERT 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 */;
542UNLOCK TABLES;
543
544--
545-- Table structure for table `tbl_inv_product_price_master_items`
546--
547
548DROP 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 */;
551CREATE 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
564LOCK TABLES `tbl_inv_product_price_master_items` WRITE;
565/*!40000 ALTER TABLE `tbl_inv_product_price_master_items` DISABLE KEYS */;
566INSERT 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 */;
568UNLOCK TABLES;
569
570--
571-- Table structure for table `tbl_inv_product_pricing`
572--
573
574DROP TABLE IF EXISTS `tbl_inv_product_pricing`;
575/*!40101 SET @saved_cs_client = @@character_set_client */;
576/*!40101 SET character_set_client = utf8 */;
577CREATE 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
590LOCK 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 */;
593UNLOCK TABLES;
594
595--
596-- Table structure for table `tbl_inv_production`
597--
598
599DROP TABLE IF EXISTS `tbl_inv_production`;
600/*!40101 SET @saved_cs_client = @@character_set_client */;
601/*!40101 SET character_set_client = utf8 */;
602CREATE 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
616LOCK TABLES `tbl_inv_production` WRITE;
617/*!40000 ALTER TABLE `tbl_inv_production` DISABLE KEYS */;
618INSERT 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 */;
620UNLOCK TABLES;
621
622--
623-- Table structure for table `tbl_inv_production_items`
624--
625
626DROP TABLE IF EXISTS `tbl_inv_production_items`;
627/*!40101 SET @saved_cs_client = @@character_set_client */;
628/*!40101 SET character_set_client = utf8 */;
629CREATE 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
642LOCK TABLES `tbl_inv_production_items` WRITE;
643/*!40000 ALTER TABLE `tbl_inv_production_items` DISABLE KEYS */;
644INSERT 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 */;
646UNLOCK TABLES;
647
648--
649-- Table structure for table `tbl_inv_production_stock`
650--
651
652DROP TABLE IF EXISTS `tbl_inv_production_stock`;
653/*!40101 SET @saved_cs_client = @@character_set_client */;
654/*!40101 SET character_set_client = utf8 */;
655CREATE 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
668LOCK TABLES `tbl_inv_production_stock` WRITE;
669/*!40000 ALTER TABLE `tbl_inv_production_stock` DISABLE KEYS */;
670INSERT 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 */;
672UNLOCK TABLES;
673
674--
675-- Table structure for table `tbl_inv_purchase_invoice`
676--
677
678DROP TABLE IF EXISTS `tbl_inv_purchase_invoice`;
679/*!40101 SET @saved_cs_client = @@character_set_client */;
680/*!40101 SET character_set_client = utf8 */;
681CREATE 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
697LOCK TABLES `tbl_inv_purchase_invoice` WRITE;
698/*!40000 ALTER TABLE `tbl_inv_purchase_invoice` DISABLE KEYS */;
699INSERT 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 */;
701UNLOCK TABLES;
702
703--
704-- Table structure for table `tbl_inv_purchase_invoice_item`
705--
706
707DROP TABLE IF EXISTS `tbl_inv_purchase_invoice_item`;
708/*!40101 SET @saved_cs_client = @@character_set_client */;
709/*!40101 SET character_set_client = utf8 */;
710CREATE 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
725LOCK TABLES `tbl_inv_purchase_invoice_item` WRITE;
726/*!40000 ALTER TABLE `tbl_inv_purchase_invoice_item` DISABLE KEYS */;
727INSERT 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 */;
729UNLOCK TABLES;
730
731--
732-- Table structure for table `tbl_inv_purchase_order`
733--
734
735DROP TABLE IF EXISTS `tbl_inv_purchase_order`;
736/*!40101 SET @saved_cs_client = @@character_set_client */;
737/*!40101 SET character_set_client = utf8 */;
738CREATE 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
752LOCK TABLES `tbl_inv_purchase_order` WRITE;
753/*!40000 ALTER TABLE `tbl_inv_purchase_order` DISABLE KEYS */;
754INSERT 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 */;
756UNLOCK TABLES;
757
758--
759-- Table structure for table `tbl_inv_purchase_order_item`
760--
761
762DROP TABLE IF EXISTS `tbl_inv_purchase_order_item`;
763/*!40101 SET @saved_cs_client = @@character_set_client */;
764/*!40101 SET character_set_client = utf8 */;
765CREATE 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
780LOCK TABLES `tbl_inv_purchase_order_item` WRITE;
781/*!40000 ALTER TABLE `tbl_inv_purchase_order_item` DISABLE KEYS */;
782INSERT 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 */;
784UNLOCK TABLES;
785
786--
787-- Table structure for table `tbl_inv_route`
788--
789
790DROP TABLE IF EXISTS `tbl_inv_route`;
791/*!40101 SET @saved_cs_client = @@character_set_client */;
792/*!40101 SET character_set_client = utf8 */;
793CREATE 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
806LOCK TABLES `tbl_inv_route` WRITE;
807/*!40000 ALTER TABLE `tbl_inv_route` DISABLE KEYS */;
808INSERT 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 */;
810UNLOCK TABLES;
811
812--
813-- Table structure for table `tbl_inv_sales_invoice`
814--
815
816DROP TABLE IF EXISTS `tbl_inv_sales_invoice`;
817/*!40101 SET @saved_cs_client = @@character_set_client */;
818/*!40101 SET character_set_client = utf8 */;
819CREATE 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
840LOCK 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 */;
843UNLOCK TABLES;
844
845--
846-- Table structure for table `tbl_inv_sales_invoice_item`
847--
848
849DROP TABLE IF EXISTS `tbl_inv_sales_invoice_item`;
850/*!40101 SET @saved_cs_client = @@character_set_client */;
851/*!40101 SET character_set_client = utf8 */;
852CREATE 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
866LOCK 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 */;
869UNLOCK TABLES;
870
871--
872-- Table structure for table `tbl_inv_sales_order`
873--
874
875DROP TABLE IF EXISTS `tbl_inv_sales_order`;
876/*!40101 SET @saved_cs_client = @@character_set_client */;
877/*!40101 SET character_set_client = utf8 */;
878CREATE 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
893LOCK TABLES `tbl_inv_sales_order` WRITE;
894/*!40000 ALTER TABLE `tbl_inv_sales_order` DISABLE KEYS */;
895INSERT 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 */;
897UNLOCK TABLES;
898
899--
900-- Table structure for table `tbl_inv_sales_order_items`
901--
902
903DROP TABLE IF EXISTS `tbl_inv_sales_order_items`;
904/*!40101 SET @saved_cs_client = @@character_set_client */;
905/*!40101 SET character_set_client = utf8 */;
906CREATE 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
920LOCK TABLES `tbl_inv_sales_order_items` WRITE;
921/*!40000 ALTER TABLE `tbl_inv_sales_order_items` DISABLE KEYS */;
922INSERT INTO `tbl_inv_sales_order_items` VALUES (1,1,8,1,'N');
923/*!40000 ALTER TABLE `tbl_inv_sales_order_items` ENABLE KEYS */;
924UNLOCK TABLES;
925
926--
927-- Table structure for table `tbl_inv_sales_return`
928--
929
930DROP TABLE IF EXISTS `tbl_inv_sales_return`;
931/*!40101 SET @saved_cs_client = @@character_set_client */;
932/*!40101 SET character_set_client = utf8 */;
933CREATE 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
948LOCK 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 */;
951UNLOCK TABLES;
952
953--
954-- Table structure for table `tbl_inv_sales_return_items`
955--
956
957DROP TABLE IF EXISTS `tbl_inv_sales_return_items`;
958/*!40101 SET @saved_cs_client = @@character_set_client */;
959/*!40101 SET character_set_client = utf8 */;
960CREATE 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
974LOCK 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 */;
977UNLOCK TABLES;
978
979--
980-- Table structure for table `tbl_inv_salesman`
981--
982
983DROP TABLE IF EXISTS `tbl_inv_salesman`;
984/*!40101 SET @saved_cs_client = @@character_set_client */;
985/*!40101 SET character_set_client = utf8 */;
986CREATE 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
1006LOCK TABLES `tbl_inv_salesman` WRITE;
1007/*!40000 ALTER TABLE `tbl_inv_salesman` DISABLE KEYS */;
1008INSERT 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 */;
1010UNLOCK TABLES;
1011
1012--
1013-- Table structure for table `tbl_inv_supplier`
1014--
1015
1016DROP TABLE IF EXISTS `tbl_inv_supplier`;
1017/*!40101 SET @saved_cs_client = @@character_set_client */;
1018/*!40101 SET character_set_client = utf8 */;
1019CREATE 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
1035LOCK TABLES `tbl_inv_supplier` WRITE;
1036/*!40000 ALTER TABLE `tbl_inv_supplier` DISABLE KEYS */;
1037INSERT 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 */;
1039UNLOCK TABLES;
1040
1041--
1042-- Table structure for table `tbl_inv_units`
1043--
1044
1045DROP TABLE IF EXISTS `tbl_inv_units`;
1046/*!40101 SET @saved_cs_client = @@character_set_client */;
1047/*!40101 SET character_set_client = utf8 */;
1048CREATE 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
1059LOCK TABLES `tbl_inv_units` WRITE;
1060/*!40000 ALTER TABLE `tbl_inv_units` DISABLE KEYS */;
1061INSERT INTO `tbl_inv_units` VALUES (1,'KG'),(2,'MG'),(3,'LTRE'),(4,'PACKETS'),(5,'Nos');
1062/*!40000 ALTER TABLE `tbl_inv_units` ENABLE KEYS */;
1063UNLOCK TABLES;
1064
1065--
1066-- Table structure for table `tbl_menu`
1067--
1068
1069DROP TABLE IF EXISTS `tbl_menu`;
1070/*!40101 SET @saved_cs_client = @@character_set_client */;
1071/*!40101 SET character_set_client = utf8 */;
1072CREATE 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
1101LOCK TABLES `tbl_menu` WRITE;
1102/*!40000 ALTER TABLE `tbl_menu` DISABLE KEYS */;
1103INSERT 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 */;
1105UNLOCK TABLES;
1106
1107--
1108-- Table structure for table `tbl_menu_user`
1109--
1110
1111DROP TABLE IF EXISTS `tbl_menu_user`;
1112/*!40101 SET @saved_cs_client = @@character_set_client */;
1113/*!40101 SET character_set_client = utf8 */;
1114CREATE 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
1130LOCK TABLES `tbl_menu_user` WRITE;
1131/*!40000 ALTER TABLE `tbl_menu_user` DISABLE KEYS */;
1132INSERT 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 */;
1134UNLOCK TABLES;
1135
1136--
1137-- Table structure for table `tbl_mini_expense`
1138--
1139
1140DROP TABLE IF EXISTS `tbl_mini_expense`;
1141/*!40101 SET @saved_cs_client = @@character_set_client */;
1142/*!40101 SET character_set_client = utf8 */;
1143CREATE 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
1160LOCK TABLES `tbl_mini_expense` WRITE;
1161/*!40000 ALTER TABLE `tbl_mini_expense` DISABLE KEYS */;
1162INSERT 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 */;
1164UNLOCK TABLES;
1165
1166--
1167-- Table structure for table `tbl_mini_expense_master`
1168--
1169
1170DROP TABLE IF EXISTS `tbl_mini_expense_master`;
1171/*!40101 SET @saved_cs_client = @@character_set_client */;
1172/*!40101 SET character_set_client = utf8 */;
1173CREATE 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
1184LOCK 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 */;
1187UNLOCK TABLES;
1188
1189--
1190-- Table structure for table `tbl_mini_invoice_items`
1191--
1192
1193DROP TABLE IF EXISTS `tbl_mini_invoice_items`;
1194/*!40101 SET @saved_cs_client = @@character_set_client */;
1195/*!40101 SET character_set_client = utf8 */;
1196CREATE 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
1211LOCK TABLES `tbl_mini_invoice_items` WRITE;
1212/*!40000 ALTER TABLE `tbl_mini_invoice_items` DISABLE KEYS */;
1213INSERT 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 */;
1215UNLOCK TABLES;
1216
1217--
1218-- Table structure for table `tbl_mini_invoice_master`
1219--
1220
1221DROP TABLE IF EXISTS `tbl_mini_invoice_master`;
1222/*!40101 SET @saved_cs_client = @@character_set_client */;
1223/*!40101 SET character_set_client = utf8 */;
1224CREATE 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
1242LOCK TABLES `tbl_mini_invoice_master` WRITE;
1243/*!40000 ALTER TABLE `tbl_mini_invoice_master` DISABLE KEYS */;
1244INSERT 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 */;
1246UNLOCK TABLES;
1247
1248--
1249-- Table structure for table `tbl_mini_menu_master`
1250--
1251
1252DROP TABLE IF EXISTS `tbl_mini_menu_master`;
1253/*!40101 SET @saved_cs_client = @@character_set_client */;
1254/*!40101 SET character_set_client = utf8 */;
1255CREATE 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
1268LOCK TABLES `tbl_mini_menu_master` WRITE;
1269/*!40000 ALTER TABLE `tbl_mini_menu_master` DISABLE KEYS */;
1270INSERT 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 */;
1272UNLOCK TABLES;
1273
1274--
1275-- Table structure for table `tbl_mini_menu_user`
1276--
1277
1278DROP TABLE IF EXISTS `tbl_mini_menu_user`;
1279/*!40101 SET @saved_cs_client = @@character_set_client */;
1280/*!40101 SET character_set_client = utf8 */;
1281CREATE 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
1293LOCK TABLES `tbl_mini_menu_user` WRITE;
1294/*!40000 ALTER TABLE `tbl_mini_menu_user` DISABLE KEYS */;
1295INSERT 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 */;
1297UNLOCK TABLES;
1298
1299--
1300-- Table structure for table `tbl_mini_order_items`
1301--
1302
1303DROP TABLE IF EXISTS `tbl_mini_order_items`;
1304/*!40101 SET @saved_cs_client = @@character_set_client */;
1305/*!40101 SET character_set_client = utf8 */;
1306CREATE 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
1321LOCK TABLES `tbl_mini_order_items` WRITE;
1322/*!40000 ALTER TABLE `tbl_mini_order_items` DISABLE KEYS */;
1323INSERT 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 */;
1325UNLOCK TABLES;
1326
1327--
1328-- Table structure for table `tbl_mini_order_master`
1329--
1330
1331DROP TABLE IF EXISTS `tbl_mini_order_master`;
1332/*!40101 SET @saved_cs_client = @@character_set_client */;
1333/*!40101 SET character_set_client = utf8 */;
1334CREATE 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
1349LOCK TABLES `tbl_mini_order_master` WRITE;
1350/*!40000 ALTER TABLE `tbl_mini_order_master` DISABLE KEYS */;
1351INSERT 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 */;
1353UNLOCK TABLES;
1354
1355--
1356-- Table structure for table `tbl_mini_return_items`
1357--
1358
1359DROP TABLE IF EXISTS `tbl_mini_return_items`;
1360/*!40101 SET @saved_cs_client = @@character_set_client */;
1361/*!40101 SET character_set_client = utf8 */;
1362CREATE 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
1377LOCK TABLES `tbl_mini_return_items` WRITE;
1378/*!40000 ALTER TABLE `tbl_mini_return_items` DISABLE KEYS */;
1379INSERT 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 */;
1381UNLOCK TABLES;
1382
1383--
1384-- Table structure for table `tbl_mini_return_master`
1385--
1386
1387DROP TABLE IF EXISTS `tbl_mini_return_master`;
1388/*!40101 SET @saved_cs_client = @@character_set_client */;
1389/*!40101 SET character_set_client = utf8 */;
1390CREATE 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
1404LOCK TABLES `tbl_mini_return_master` WRITE;
1405/*!40000 ALTER TABLE `tbl_mini_return_master` DISABLE KEYS */;
1406INSERT 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 */;
1408UNLOCK TABLES;
1409
1410--
1411-- Table structure for table `tbl_mini_salesman_route`
1412--
1413
1414DROP TABLE IF EXISTS `tbl_mini_salesman_route`;
1415/*!40101 SET @saved_cs_client = @@character_set_client */;
1416/*!40101 SET character_set_client = utf8 */;
1417CREATE 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
1429LOCK TABLES `tbl_mini_salesman_route` WRITE;
1430/*!40000 ALTER TABLE `tbl_mini_salesman_route` DISABLE KEYS */;
1431INSERT 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 */;
1433UNLOCK TABLES;
1434
1435--
1436-- Table structure for table `tbl_opening_balance`
1437--
1438
1439DROP TABLE IF EXISTS `tbl_opening_balance`;
1440/*!40101 SET @saved_cs_client = @@character_set_client */;
1441/*!40101 SET character_set_client = utf8 */;
1442CREATE 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
1454LOCK TABLES `tbl_opening_balance` WRITE;
1455/*!40000 ALTER TABLE `tbl_opening_balance` DISABLE KEYS */;
1456INSERT INTO `tbl_opening_balance` VALUES (1,91,0),(2,253,0);
1457/*!40000 ALTER TABLE `tbl_opening_balance` ENABLE KEYS */;
1458UNLOCK TABLES;
1459
1460--
1461-- Table structure for table `tbl_transactions`
1462--
1463
1464DROP TABLE IF EXISTS `tbl_transactions`;
1465/*!40101 SET @saved_cs_client = @@character_set_client */;
1466/*!40101 SET character_set_client = utf8 */;
1467CREATE 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
1490LOCK TABLES `tbl_transactions` WRITE;
1491/*!40000 ALTER TABLE `tbl_transactions` DISABLE KEYS */;
1492INSERT 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 */;
1494UNLOCK TABLES;
1495
1496--
1497-- Table structure for table `tbl_user`
1498--
1499
1500DROP TABLE IF EXISTS `tbl_user`;
1501/*!40101 SET @saved_cs_client = @@character_set_client */;
1502/*!40101 SET character_set_client = utf8 */;
1503CREATE 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
1517LOCK TABLES `tbl_user` WRITE;
1518/*!40000 ALTER TABLE `tbl_user` DISABLE KEYS */;
1519INSERT 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 */;
1521UNLOCK 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 = '' */ ;
1539DELIMITER ;;
1540CREATE 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
1543begin
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);
1560end ;;
1561DELIMITER ;
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 = '' */ ;
1575DELIMITER ;;
1576CREATE 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
1579BEGIN
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
1584END ;;
1585DELIMITER ;
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 = '' */ ;
1599DELIMITER ;;
1600CREATE 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
1603begin
1604
1605DECLARE DEBIT_TOTAL DOUBLE;
1606DECLARE CREDIT_TOTAL DOUBLE;
1607DECLARE OPENING_TOTAL DOUBLE;
1608DECLARE BALANCE DOUBLE;
1609
1610SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
1611FROM tbl_opening_balance
1612WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;
1613
1614SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
1615FROM tbl_transactions
1616WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;
1617
1618SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
1619FROM tbl_transactions
1620WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;
1621
1622
1623IF(OPENING_TOTAL > 0) THEN
1624 SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
1625ELSE
1626 SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
1627END IF;
1628
1629SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
1630RETURN BALANCE;
1631
1632
1633end ;;
1634DELIMITER ;
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 = '' */ ;
1648DELIMITER ;;
1649CREATE 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
1652BEGIN
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;
1656END ;;
1657DELIMITER ;
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 = '' */ ;
1671DELIMITER ;;
1672CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_INVOICE_NUMBER`(`SALES_MAN_ID` INTEGER) RETURNS varchar(255) CHARSET latin1
1673BEGIN
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
1690END ;;
1691DELIMITER ;
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 = '' */ ;
1705DELIMITER ;;
1706CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCTION_STOCK`(`I_PRODUCT_ID` INTEGER) RETURNS double
1707 READS SQL DATA
1708 DETERMINISTIC
1709BEGIN
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;
1731END ;;
1732DELIMITER ;
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 = '' */ ;
1746DELIMITER ;;
1747CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCT_STOCK`(`PRODUCT_ID` INTEGER, `PRODUCTION_DT` DATE) RETURNS double
1748BEGIN
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
1771END ;;
1772DELIMITER ;
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 = '' */ ;
1786DELIMITER ;;
1787CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_AT_STORE`(`STORE_ID` INT, `PACKING_MASTER_ID` INT) RETURNS int(11)
1788BEGIN
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
1827END ;;
1828DELIMITER ;
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 = '' */ ;
1842DELIMITER ;;
1843CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_BET_INV_AND_MINI`(`PACKET_MASTER_ID` INT) RETURNS int(11)
1844BEGIN
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
1869END ;;
1870DELIMITER ;
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 = '' */ ;
1884DELIMITER ;;
1885CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRAIL_BALANCE_BY_GROUPS`(`CURRENT_YEAR_START` DATE, `CURRENT_YEAR_END` DATE)
1886 NO SQL
1887begin
1888
1889
1890SELECT
1891tbl_acc_groups.*,
1892 F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
1893F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
1894FROM tbl_acc_groups WHERE `TYPE`<>'H';
1895
1896
1897end ;;
1898DELIMITER ;
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 = '' */ ;
1912DELIMITER ;;
1913CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BALANCE`(`CURRENT_YEAR_ID` INTEGER(11))
1914 READS SQL DATA
1915 DETERMINISTIC
1916begin
1917
1918DECLARE CURRENT_YEAR_START DATE;
1919DECLARE CURRENT_YEAR_END DATE;
1920DECLARE TOTAL_EXPENSE_PREV DOUBLE;
1921DECLARE TOTAL_EXPENSE_CUR DOUBLE;
1922DECLARE TOTAL_INCOME_PREV DOUBLE;
1923DECLARE TOTAL_INCOME_CUR DOUBLE;
1924DECLARE P_L_PREV DOUBLE;
1925DECLARE P_L_CURRENT DOUBLE;
1926
1927SELECT YEAR_START,YEAR_END
1928INTO CURRENT_YEAR_START,CURRENT_YEAR_END
1929FROM tbl_financial_year
1930WHERE ID = CURRENT_YEAR_ID;
1931
1932SELECT
1933IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
1934IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
1935INTO TOTAL_INCOME_PREV,TOTAL_INCOME_CUR
1936FROM
1937tbl_acc_groups
1938WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 3);
1939
1940
1941SELECT
1942IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
1943IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
1944INTO TOTAL_EXPENSE_PREV,TOTAL_EXPENSE_CUR
1945FROM
1946tbl_acc_groups
1947WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 4);
1948
1949SET P_L_PREV = TOTAL_EXPENSE_PREV - TOTAL_INCOME_PREV;
1950SET P_L_CURRENT = TOTAL_INCOME_CUR - TOTAL_EXPENSE_CUR;
1951
1952
1953
1954SELECT
1955tbl_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,
1957F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
1958FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 1 UNION ALL
1959SELECT
1960tbl_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,
1962F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
1963FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 2 UNION ALL
1964SELECT '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
1965SELECT
1966tbl_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,
1968F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
1969FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 3 UNION ALL
1970SELECT
1971tbl_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,
1973F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
1974FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 4;
1975
1976
1977
1978
1979end ;;
1980DELIMITER ;
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 = '' */ ;
1994DELIMITER ;;
1995CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BAL_FOR_GROUP`(`CURRENT_YEAR_ID` INTEGER(11), `GROUP_ID` INTEGER(11))
1996BEGIN
1997DECLARE CURRENT_YEAR_START DATE;
1998DECLARE CURRENT_YEAR_END DATE;
1999
2000
2001SELECT YEAR_START,YEAR_END
2002INTO CURRENT_YEAR_START,CURRENT_YEAR_END
2003FROM tbl_financial_year
2004WHERE ID = CURRENT_YEAR_ID;
2005
2006SELECT
2007tbl_acc_groups.*,
2008F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
2009F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
2010FROM
2011tbl_acc_groups
2012WHERE `TYPE` = 'H' AND CHILD_OF = GROUP_ID;
2013
2014END ;;
2015DELIMITER ;
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 = '' */ ;
2029DELIMITER ;;
2030CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE`(IN `ACC_ID` INT(11), IN `UNTIL_DATE` DATE)
2031 NO SQL
2032 DETERMINISTIC
2033begin
2034
2035
2036DECLARE DEBIT_TOTAL DOUBLE;
2037DECLARE CREDIT_TOTAL DOUBLE;
2038DECLARE OPENING_TOTAL DOUBLE;
2039DECLARE BALANCE DOUBLE;
2040
2041SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
2042FROM tbl_opening_balance
2043WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;
2044
2045SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
2046FROM tbl_transactions
2047WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;
2048
2049SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
2050FROM tbl_transactions
2051WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;
2052
2053IF(OPENING_TOTAL > 0) THEN
2054 SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
2055ELSE
2056 SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
2057END IF;
2058
2059SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
2060
2061IF(BALANCE < 0) THEN
2062 SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
2063ELSE
2064 SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;
2065END IF;
2066
2067end ;;
2068DELIMITER ;
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 = '' */ ;
2082DELIMITER ;;
2083CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_BETWEEN`(`ACC_ID` INTEGER, `FROM_DATE` DATE, `TO_DATE` DATE)
2084 READS SQL DATA
2085begin
2086
2087
2088DECLARE DEBIT_TOTAL DOUBLE;
2089DECLARE CREDIT_TOTAL DOUBLE;
2090DECLARE BALANCE DOUBLE;
2091
2092SELECT SUM(AMOUNT) INTO DEBIT_TOTAL
2093FROM tbl_transactions
2094WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND DEBIT_ACC_ID = ACC_ID;
2095
2096SELECT SUM(AMOUNT) INTO CREDIT_TOTAL
2097FROM tbl_transactions
2098WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND CREDIT_ACC_ID = ACC_ID;
2099
2100SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
2101
2102IF(BALANCE < 0) THEN
2103 SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
2104ELSE
2105 SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;
2106END IF;
2107
2108end ;;
2109DELIMITER ;
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 = '' */ ;
2123DELIMITER ;;
2124CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_UNTIL_BY_GROUPS`(`UNTIL_DATE` DATE)
2125BEGIN
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';
2127END ;;
2128DELIMITER ;
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 = '' */ ;
2142DELIMITER ;;
2143CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_AVAIALBE_ITEM_STOCK`(IN `I_STOCK_DATE` DATE, IN `I_ITEM_ID` INT)
2144BEGIN
2145
2146DECLARE TOTAL_ITEM_STOCK DOUBLE;
2147DECLARE TOTAL_OUT_STOCK DOUBLE;
2148DECLARE TOTAL_BALANCE_STOCK DOUBLE;
2149
2150IF I_ITEM_ID = 0 THEN
2151
2152SELECT 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)
2154FROM tbl_inv_purchase_invoice_item,tbl_inv_purchase_invoice
2155WHERE tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID AND
2156tbl_inv_purchase_invoice.INV_DATE <= I_STOCK_DATE AND
2157tbl_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)
2159FROM tbl_inv_production_items,tbl_inv_production
2160WHERE
2161tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID AND
2162tbl_inv_production.PRODU_DATE <= I_STOCK_DATE AND
2163tbl_inv_production_items.P_ITEM_MASTR_ID = tbl_inv_item_master.ITEM_ID) AS TOTAL_BALANCE_STOCK
2164FROM
2165tbl_inv_item_master,tbl_inv_units
2166WHERE
2167tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID;
2168
2169ELSE
2170
2171SELECT
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
2197WHERE tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID
2198AND tbl_inv_item_master.ITEM_ID = I_ITEM_ID;
2199
2200
2201END IF;
2202
2203END ;;
2204DELIMITER ;
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 = '' */ ;
2218DELIMITER ;;
2219CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_HOME_DATA`(IN `SALESMAN_ID` INT, IN `I_DATE` DATE)
2220BEGIN
2221
2222DECLARE SALES_INVOICE_TOTAL DOUBLE;
2223DECLARE SALES_INVOICE_COUNT INTEGER;
2224DECLARE BALACE_STOCK_PACKET_COUNT INTEGER;
2225DECLARE BALACE_STOCK_CATEGORY_COUNT INTEGER;
2226DECLARE RETURN_TOTAL DOUBLE;
2227DECLARE RETURN_ITEM_PACKET_COUNT INTEGER;
2228DECLARE ORDER_COUNT INTEGER;
2229DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
2230DECLARE STOCK_AT_STORE INTEGER;
2231DECLARE STOCK_AT_VAN INTEGER;
2232
2233SELECT
2234 MINIL_ID
2235INTO
2236 CURRENT_STOCK_LOCATION_ID
2237FROM
2238 tbl_inv_mini_stock_location
2239WHERE MINIL_SALESMAN_ID = SALESMAN_ID;
2240
2241SELECT IFNULL(SUM(MINI_INV_TOTAL),0) INTO SALES_INVOICE_TOTAL FROM tbl_mini_invoice_items,tbl_mini_invoice_master WHERE
2242tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
2243date(MINI_INV_DATE) = I_DATE AND
2244 MINI_INV_SALES_MAN_ID = SALESMAN_ID;
2245
2246SELECT
2247 COUNT(*) INTO SALES_INVOICE_COUNT
2248FROM
2249 tbl_mini_invoice_master
2250WHERE
2251 date(MINI_INV_DATE) = I_DATE AND
2252 MINI_INV_SALES_MAN_ID = SALESMAN_ID;
2253
2254SELECT
2255 IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
2256FROM
2257 tbl_inv_mini_stock
2258WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID;
2259
2260SELECT
2261 IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN
2262FROM
2263 tbl_mini_invoice_items,
2264 tbl_mini_invoice_master
2265WHERE
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
2269SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;
2270
2271SELECT 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
2284SELECT
2285 COUNT(*) INTO ORDER_COUNT
2286FROM
2287 tbl_mini_order_master
2288WHERE
2289 MINI_ORD_SALESMAN_ID = SALESMAN_ID AND
2290 date(MINI_ORD_DATE) = I_DATE AND
2291 MINI_ORD_STATUS = 'N';
2292SELECT
2293 IFNULL(SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY),0) INTO RETURN_ITEM_PACKET_COUNT
2294FROM
2295 tbl_mini_return_items,tbl_mini_return_master
2296where
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
2302SELECT IFNULL(SUM(MINI_RET_TOTAL),0) INTO RETURN_TOTAL FROM tbl_mini_return_items,tbl_mini_return_master WHERE
2303tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
2304date(MINI_RET_DATE) = I_DATE AND
2305 MINI_RET_SALES_MAN_ID = SALESMAN_ID;
2306
2307
2308SET SALES_INVOICE_TOTAL = SALES_INVOICE_TOTAL - RETURN_TOTAL;
2309SET BALACE_STOCK_PACKET_COUNT = BALACE_STOCK_PACKET_COUNT + RETURN_ITEM_PACKET_COUNT;
2310
2311SELECT
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
2322END ;;
2323DELIMITER ;
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 = '' */ ;
2337DELIMITER ;;
2338CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_INVOICE_ITEMS_INV_ID`(IN `I_INV_ID` INT)
2339BEGIN
2340
2341SELECT
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
2348FROM tbl_inv_purchase_invoice_item,
2349 tbl_inv_item_master,
2350 tbl_inv_category,tbl_inv_units
2351WHERE
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
2355GROUP BY
2356 tbl_inv_purchase_invoice_item.INV_ITEM_ID;
2357END ;;
2358DELIMITER ;
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 = '' */ ;
2372DELIMITER ;;
2373CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ITEM_MASTER_DETAILED`()
2374BEGIN
2375SELECT
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
2381FROM
2382 tbl_inv_item_master,
2383 tbl_inv_category,tbl_inv_units
2384WHERE
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;
2387END ;;
2388DELIMITER ;
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 = '' */ ;
2402DELIMITER ;;
2403CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_PRODUCT_STOCK`(IN `SALESMAN_ID` INT)
2404BEGIN
2405
2406DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
2407SELECT
2408 MINIL_ID
2409INTO
2410 CURRENT_STOCK_LOCATION_ID
2411FROM
2412 tbl_inv_mini_stock_location
2413WHERE MINIL_SALESMAN_ID = SALESMAN_ID;
2414
2415SELECT CONCAT(tbl_inv_product.PROD_NAME," - ",tbl_inv_packet_master.PACKET_NAME) AS PACKET_NAME,(SELECT
2416 IFNULL(SUM(MINI_QTY),0)
2417FROM
2418 tbl_inv_mini_stock
2419WHERE 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)
2423FROM
2424 tbl_mini_invoice_items,
2425 tbl_mini_invoice_master
2426WHERE
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
2433END ;;
2434DELIMITER ;
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 = '' */ ;
2448DELIMITER ;;
2449CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_RETURNABLE_QTY`(IN `CUSTOMER_ID` INT, IN `PACKET_ID` INT)
2450BEGIN
2451
2452SELECT IFNULL((SELECT
2453SUM(tbl_mini_invoice_items.MINI_INV_ITEM_QTY)
2454FROM
2455tbl_mini_invoice_items,
2456tbl_mini_invoice_master
2457WHERE
2458tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
2459tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PACKET_ID AND
2460tbl_mini_invoice_master.MINI_INV_CUSTOMER_ID = CUSTOMER_ID),0) - IFNULL((SELECT
2461SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY)
2462FROM
2463tbl_mini_return_items,
2464tbl_mini_return_master
2465WHERE
2466tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
2467tbl_mini_return_items.MINI_RET_ITEM_PACKET_ID = PACKET_ID AND
2468tbl_mini_return_master.MINI_RET_CUSTOMER_ID = CUSTOMER_ID),0) AS MAX_RETURN_QTY;
2469
2470END ;;
2471DELIMITER ;
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 = '' */ ;
2485DELIMITER ;;
2486CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_ORDER_NUM`()
2487BEGIN
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;
2495END ;;
2496DELIMITER ;
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 = '' */ ;
2510DELIMITER ;;
2511CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_SALES_ORDER_NUM`()
2512BEGIN
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;
2520END ;;
2521DELIMITER ;
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 = '' */ ;
2535DELIMITER ;;
2536CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_VOUCHER_NUMBER`(IN `P_TYPE` VARCHAR(2))
2537 NO SQL
2538 DETERMINISTIC
2539begin
2540
2541DECLARE VOUCHER_TEMP INTEGER;
2542
2543SET 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
2582end ;;
2583DELIMITER ;
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 = '' */ ;
2597DELIMITER ;;
2598CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ORDER_ITEMS_BY_OID`(IN `I_ORDER_ID` INT)
2599BEGIN
2600SELECT
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
2607FROM tbl_inv_purchase_order_item,
2608 tbl_inv_item_master,
2609 tbl_inv_category,tbl_inv_units
2610WHERE
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
2614GROUP BY
2615 tbl_inv_purchase_order_item.ITEM_O_ID;
2616END ;;
2617DELIMITER ;
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 = '' */ ;
2631DELIMITER ;;
2632CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_PRODUCT_STOCK_AT_STORE`(STORE_ID INTEGER,PRODUCT_ID INTEGER)
2633BEGIN
2634
2635DECLARE STOCK_AT_STORE DOUBLE;
2636DECLARE STOCK_AT_VAN DOUBLE;
2637DECLARE BALACE_STOCK_PACKET_COUNT DOUBLE;
2638
2639SELECT
2640 IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
2641FROM
2642 tbl_inv_mini_stock
2643WHERE MINI_LOCATION_ID = STORE_ID AND MINI_PACKET_MASTER_ID = PRODUCT_ID;
2644
2645SELECT
2646 IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN
2647FROM
2648 tbl_mini_invoice_items,
2649 tbl_mini_invoice_master
2650WHERE
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
2655SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;
2656SELECT BALACE_STOCK_PACKET_COUNT;
2657
2658END ;;
2659DELIMITER ;
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 = '' */ ;
2673DELIMITER ;;
2674CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_STOCK_LEDGER`(`I_ITEM_ID` INTEGER, `FROM_DT` DATE, `TO_DT` DATE)
2675BEGIN
2676
2677
2678
2679SELECT
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
2686FROM
2687 tbl_inv_purchase_invoice_item,
2688 tbl_inv_purchase_invoice,
2689 tbl_inv_supplier
2690WHERE
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
2696UNION ALL
2697
2698SELECT
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
2706FROM
2707 tbl_inv_production_items,
2708 tbl_inv_production,
2709 tbl_inv_product
2710WHERE
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
2717END ;;
2718DELIMITER ;
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 = '' */ ;
2732DELIMITER ;;
2733CREATE DEFINER=`root`@`localhost` PROCEDURE `P_UPDATE_SALES_INVOICE_NUMBER`(`I_SALES_MAN_ID` INTEGER, `I_INVOICE_ID` INTEGER)
2734BEGIN
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;
2737END ;;
2738DELIMITER ;
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