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