-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 15, 2017 at 11:03 AM
-- Server version: 5.5.54-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `orcaminddb`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRAIL_BALANCE_BY_GROUPS`(`CURRENT_YEAR_START` DATE, `CURRENT_YEAR_END` DATE)
    NO SQL
begin


SELECT
tbl_acc_groups.*,
 F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM tbl_acc_groups WHERE `TYPE`<>'H';


end$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BALANCE`(`CURRENT_YEAR_ID` INTEGER(11))
    READS SQL DATA
    DETERMINISTIC
begin

DECLARE CURRENT_YEAR_START DATE;
DECLARE CURRENT_YEAR_END DATE;
DECLARE TOTAL_EXPENSE_PREV DOUBLE;
DECLARE TOTAL_EXPENSE_CUR DOUBLE;
DECLARE TOTAL_INCOME_PREV DOUBLE;
DECLARE TOTAL_INCOME_CUR DOUBLE;
DECLARE P_L_PREV DOUBLE;
DECLARE P_L_CURRENT DOUBLE;

SELECT YEAR_START,YEAR_END
INTO CURRENT_YEAR_START,CURRENT_YEAR_END
FROM tbl_financial_year
WHERE ID = CURRENT_YEAR_ID;

SELECT
IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
INTO TOTAL_INCOME_PREV,TOTAL_INCOME_CUR
FROM
tbl_acc_groups
WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 3);


SELECT
IFNULL(SUM(abs(F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START))),0),
IFNULL(SUM(abs(F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END))),0)
INTO TOTAL_EXPENSE_PREV,TOTAL_EXPENSE_CUR
FROM
tbl_acc_groups
WHERE `TYPE` = 'H' AND CHILD_OF IN (SELECT ID FROM tbl_acc_groups WHERE TYPE = 'G' AND CHILD_OF = 4);

SET P_L_PREV = TOTAL_EXPENSE_PREV - TOTAL_INCOME_PREV;
SET P_L_CURRENT = TOTAL_INCOME_CUR - TOTAL_EXPENSE_CUR;



SELECT
tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
 F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 1 UNION ALL
SELECT
tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
 F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 2 UNION ALL
SELECT '0' AS ID,'PROFIT AND LOSS A/C' AS G_H_NAME,'G' AS TYPE,0 AS CHILD_OF,P_L_PREV,0 UNION ALL
SELECT
tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
 F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 3 UNION ALL
SELECT
tbl_acc_groups.ID,tbl_acc_groups.G_H_NAME,tbl_acc_groups.TYPE,tbl_acc_groups.CHILD_OF,
 F_GET_ACC_BALANCE_UNTIL_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN_BY_GROUP(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM tbl_acc_groups WHERE `TYPE` = 'G' AND CHILD_OF = 4;




end$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GENERATE_TRIAL_BAL_FOR_GROUP`(`CURRENT_YEAR_ID` INTEGER(11), `GROUP_ID` INTEGER(11))
BEGIN
DECLARE CURRENT_YEAR_START DATE;
DECLARE CURRENT_YEAR_END DATE;


SELECT YEAR_START,YEAR_END
INTO CURRENT_YEAR_START,CURRENT_YEAR_END
FROM tbl_financial_year
WHERE ID = CURRENT_YEAR_ID;

SELECT
tbl_acc_groups.*,
F_GET_ACC_BALANCE_UNTIL(tbl_acc_groups.ID,CURRENT_YEAR_START) AS BALANCE_PREV_YEAR,
F_GET_ACC_BALANCE_BETWEEN(tbl_acc_groups.ID,CURRENT_YEAR_START,CURRENT_YEAR_END) AS BALANCE_CURRENT_YEAR
FROM
tbl_acc_groups
WHERE `TYPE` = 'H' AND CHILD_OF = GROUP_ID;

END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE`(IN `ACC_ID` INT(11), IN `UNTIL_DATE` DATE)
    NO SQL
    DETERMINISTIC
begin


DECLARE DEBIT_TOTAL DOUBLE;
DECLARE CREDIT_TOTAL DOUBLE;
DECLARE OPENING_TOTAL DOUBLE;
DECLARE BALANCE DOUBLE;

SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
FROM tbl_opening_balance
WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;

SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
FROM tbl_transactions
WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;

SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
FROM tbl_transactions
WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;

IF(OPENING_TOTAL > 0) THEN
	SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
ELSE
	SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
END IF;

SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;

IF(BALANCE < 0) THEN
       SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
ELSE
       SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;
END IF;

end$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_BETWEEN`(`ACC_ID` INTEGER, `FROM_DATE` DATE, `TO_DATE` DATE)
    READS SQL DATA
begin


DECLARE DEBIT_TOTAL DOUBLE;
DECLARE CREDIT_TOTAL DOUBLE;
DECLARE BALANCE DOUBLE;

SELECT SUM(AMOUNT) INTO DEBIT_TOTAL
FROM tbl_transactions
WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND DEBIT_ACC_ID = ACC_ID;

SELECT SUM(AMOUNT) INTO CREDIT_TOTAL
FROM tbl_transactions
WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND CREDIT_ACC_ID = ACC_ID;

SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;

IF(BALANCE < 0) THEN
       SELECT IFNULL(abs(BALANCE),0) AS ACC_BALANCE,'C' AS T_TYPE;
ELSE
       SELECT IFNULL(BALANCE,0) AS ACC_BALANCE,'D' AS T_TYPE;
END IF;

end$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ACC_BALANCE_UNTIL_BY_GROUPS`(`UNTIL_DATE` DATE)
BEGIN
	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';
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_AVAIALBE_ITEM_STOCK`(IN `I_STOCK_DATE` DATE, IN `I_ITEM_ID` INT)
BEGIN

DECLARE TOTAL_ITEM_STOCK DOUBLE;
DECLARE TOTAL_OUT_STOCK DOUBLE;
DECLARE TOTAL_BALANCE_STOCK DOUBLE;

IF I_ITEM_ID = 0 THEN

SELECT tbl_inv_item_master.ITEM_ID,tbl_inv_item_master.ITEM_NAME,tbl_inv_units.UNIT_NAME,
(SELECT IFNULL(SUM(tbl_inv_purchase_invoice_item.INV_ITEM_QTY),0)
FROM tbl_inv_purchase_invoice_item,tbl_inv_purchase_invoice
WHERE tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID AND
tbl_inv_purchase_invoice.INV_DATE <= I_STOCK_DATE AND
tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID) -
(SELECT IFNULL(SUM(tbl_inv_production_items.P_ITEM_QTY),0)
FROM tbl_inv_production_items,tbl_inv_production
WHERE
tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID AND
tbl_inv_production.PRODU_DATE <= I_STOCK_DATE AND
tbl_inv_production_items.P_ITEM_MASTR_ID = tbl_inv_item_master.ITEM_ID) AS TOTAL_BALANCE_STOCK
FROM
tbl_inv_item_master,tbl_inv_units
WHERE
tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID;

ELSE

SELECT
  tbl_inv_item_master.ITEM_NAME,
  tbl_inv_units.UNIT_NAME,
  ((SELECT
    IFNULL(SUM(tbl_inv_purchase_invoice_item.INV_ITEM_QTY),0)
  FROM tbl_inv_purchase_invoice_item,
       tbl_inv_purchase_invoice,
       tbl_inv_item_master
  WHERE tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID
  AND tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID
  AND tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = I_ITEM_ID
  AND tbl_inv_purchase_invoice.INV_DATE <= I_STOCK_DATE
  )
  - (SELECT
    IFNULL(SUM(tbl_inv_production_items.P_ITEM_QTY),0)
  FROM tbl_inv_production_items,
       tbl_inv_production,
       tbl_inv_item_master
  WHERE tbl_inv_production_items.P_ITEM_MASTR_ID = tbl_inv_item_master.ITEM_ID
  AND tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID
  AND tbl_inv_production_items.P_ITEM_MASTR_ID = I_ITEM_ID
  AND tbl_inv_production.PRODU_DATE <= I_STOCK_DATE
  )
  ) AS TOTAL_BALANCE_STOCK FROM
  tbl_inv_item_master,
  tbl_inv_units
WHERE tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID
AND tbl_inv_item_master.ITEM_ID = I_ITEM_ID;


END IF;

END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_HOME_DATA`(IN `SALESMAN_ID` INT, IN `I_DATE` DATE)
BEGIN

DECLARE SALES_INVOICE_TOTAL DOUBLE;
DECLARE SALES_INVOICE_COUNT INTEGER;
DECLARE BALACE_STOCK_PACKET_COUNT INTEGER;
DECLARE BALACE_STOCK_CATEGORY_COUNT INTEGER;
DECLARE RETURN_TOTAL DOUBLE;
DECLARE RETURN_ITEM_PACKET_COUNT INTEGER;
DECLARE ORDER_COUNT INTEGER;
DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
DECLARE STOCK_AT_STORE INTEGER;
DECLARE STOCK_AT_VAN INTEGER;

SELECT
    MINIL_ID
INTO
    CURRENT_STOCK_LOCATION_ID
FROM
    tbl_inv_mini_stock_location
WHERE MINIL_SALESMAN_ID = SALESMAN_ID;

SELECT IFNULL(SUM(MINI_INV_TOTAL),0) INTO SALES_INVOICE_TOTAL FROM tbl_mini_invoice_items,tbl_mini_invoice_master WHERE
tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
date(MINI_INV_DATE) = I_DATE AND
    MINI_INV_SALES_MAN_ID = SALESMAN_ID;

SELECT
    COUNT(*) INTO SALES_INVOICE_COUNT
FROM
    tbl_mini_invoice_master
WHERE
    date(MINI_INV_DATE) = I_DATE AND
    MINI_INV_SALES_MAN_ID = SALESMAN_ID;

SELECT
    IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
FROM
    tbl_inv_mini_stock
WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID;

SELECT
    IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN
FROM
    tbl_mini_invoice_items,
    tbl_mini_invoice_master
WHERE
    tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
    tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID;

SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;

SELECT COUNT(*) INTO BALACE_STOCK_CATEGORY_COUNT FROM
  (SELECT MINI_PACKET_MASTER_ID,SUM(MINI_QTY) - IFNULL(
     (SELECT SUM(MINI_INV_ITEM_QTY)
      FROM tbl_mini_invoice_items,tbl_mini_invoice_master
      WHERE tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID
        AND tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID
        AND MINI_INV_ITEM_PACKET_ID = MINI_PACKET_MASTER_ID
      GROUP BY MINI_INV_ITEM_PACKET_ID),0) AS QTY
   FROM tbl_inv_mini_stock
   WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID
   GROUP BY MINI_PACKET_MASTER_ID
   HAVING QTY<> 0) AS tbl_temp_qty;

SELECT
    COUNT(*) INTO ORDER_COUNT
FROM
    tbl_mini_order_master
WHERE
    MINI_ORD_SALESMAN_ID = SALESMAN_ID AND
    date(MINI_ORD_DATE) = I_DATE AND
    MINI_ORD_STATUS = 'N';
SELECT
    IFNULL(SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY),0) INTO RETURN_ITEM_PACKET_COUNT
FROM
    tbl_mini_return_items,tbl_mini_return_master
where
    tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
    tbl_mini_return_master.MINI_RET_SALES_MAN_ID = SALESMAN_ID AND
    date(MINI_RET_DATE) = I_DATE;


SELECT IFNULL(SUM(MINI_RET_TOTAL),0) INTO RETURN_TOTAL FROM tbl_mini_return_items,tbl_mini_return_master WHERE
tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
date(MINI_RET_DATE) = I_DATE AND
    MINI_RET_SALES_MAN_ID = SALESMAN_ID;


SET SALES_INVOICE_TOTAL = SALES_INVOICE_TOTAL - RETURN_TOTAL;
SET BALACE_STOCK_PACKET_COUNT = BALACE_STOCK_PACKET_COUNT + RETURN_ITEM_PACKET_COUNT;

SELECT

    RETURN_ITEM_PACKET_COUNT,
    RETURN_TOTAL,
    ORDER_COUNT,
    SALES_INVOICE_TOTAL,
    SALES_INVOICE_COUNT,
    BALACE_STOCK_PACKET_COUNT,
    BALACE_STOCK_CATEGORY_COUNT;


END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_INVOICE_ITEMS_INV_ID`(IN `I_INV_ID` INT)
BEGIN

SELECT
	tbl_inv_purchase_invoice_item.*,
	tbl_inv_item_master.ITEM_ID,
    tbl_inv_item_master.ITEM_NAME,
	tbl_inv_item_master.ITEM_HEAD_ID,
    tbl_inv_units.UNIT_NAME

FROM tbl_inv_purchase_invoice_item,
	tbl_inv_item_master,
    tbl_inv_category,tbl_inv_units
WHERE
	tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = tbl_inv_item_master.ITEM_ID AND
	tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID AND
    tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = I_INV_ID
GROUP BY
	tbl_inv_purchase_invoice_item.INV_ITEM_ID;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ITEM_MASTER_DETAILED`()
BEGIN
SELECT
	tbl_inv_item_master.ITEM_ID,
    tbl_inv_item_master.ITEM_NAME,
    tbl_inv_category.CATEGORY_NAME,
    tbl_inv_units.UNIT_NAME

FROM
	tbl_inv_item_master,
    tbl_inv_category,tbl_inv_units
WHERE
	tbl_inv_item_master.ITEM_CATEGORY_ID = tbl_inv_category.CATEGORY_ID AND
    tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_PRODUCT_STOCK`(IN `SALESMAN_ID` INT)
BEGIN

DECLARE CURRENT_STOCK_LOCATION_ID INTEGER;
SELECT
    MINIL_ID
INTO
    CURRENT_STOCK_LOCATION_ID
FROM
    tbl_inv_mini_stock_location
WHERE MINIL_SALESMAN_ID = SALESMAN_ID;

SELECT CONCAT(tbl_inv_product.PROD_NAME," - ",tbl_inv_packet_master.PACKET_NAME) AS PACKET_NAME,(SELECT
    IFNULL(SUM(MINI_QTY),0)
FROM
    tbl_inv_mini_stock
WHERE MINI_LOCATION_ID = CURRENT_STOCK_LOCATION_ID AND MINI_PACKET_MASTER_ID = PACKET_ID) -

(SELECT
    IFNULL(SUM(MINI_INV_ITEM_QTY),0)
FROM
    tbl_mini_invoice_items,
    tbl_mini_invoice_master
WHERE
    tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
    tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = CURRENT_STOCK_LOCATION_ID AND
    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
    FROM tbl_inv_packet_master,tbl_inv_product WHERE tbl_inv_packet_master.PACKET_PRODUCT_ID = tbl_inv_product.PROD_ID HAVING STOCK>0;


END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_MINI_RETURNABLE_QTY`(IN `CUSTOMER_ID` INT, IN `PACKET_ID` INT)
BEGIN

SELECT IFNULL((SELECT
SUM(tbl_mini_invoice_items.MINI_INV_ITEM_QTY)
FROM
tbl_mini_invoice_items,
tbl_mini_invoice_master
WHERE
tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PACKET_ID AND
tbl_mini_invoice_master.MINI_INV_CUSTOMER_ID = CUSTOMER_ID),0) - IFNULL((SELECT
SUM(tbl_mini_return_items.MINI_RET_ITEM_QTY)
FROM
tbl_mini_return_items,
tbl_mini_return_master
WHERE
tbl_mini_return_items.MINI_RET_MASTER_ID = tbl_mini_return_master.MINI_RET_ID AND
tbl_mini_return_items.MINI_RET_ITEM_PACKET_ID = PACKET_ID AND
tbl_mini_return_master.MINI_RET_CUSTOMER_ID = CUSTOMER_ID),0) AS MAX_RETURN_QTY;

END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_ORDER_NUM`()
BEGIN
	DECLARE NORDER_ID INTEGER;
	START TRANSACTION;
    SELECT IFNULL(MAX(ORDER_ID),0) INTO NORDER_ID FROM tbl_inv_purchase_order;
    SET NORDER_ID = NORDER_ID+1;
	INSERT INTO tbl_inv_purchase_order VALUES(NORDER_ID,NULL,NULL,NULL,current_timestamp());
    SELECT NORDER_ID AS NEW_ORDER_NUM;
    COMMIT;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_INV_SALES_ORDER_NUM`()
BEGIN
	DECLARE NORDER_ID INTEGER;
	START TRANSACTION;
    SELECT IFNULL(MAX(SALES_ORDER_ID),0) INTO NORDER_ID FROM tbl_inv_sales_order;
    SET NORDER_ID = NORDER_ID+1;
	INSERT INTO tbl_inv_sales_order VALUES(NORDER_ID,NULL,NULL,NULL,NULL,current_timestamp());
    SELECT NORDER_ID AS NEW_ORDER_NUM;
    COMMIT;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_NEW_VOUCHER_NUMBER`(IN `P_TYPE` VARCHAR(2))
    NO SQL
    DETERMINISTIC
begin

DECLARE VOUCHER_TEMP INTEGER;

SET VOUCHER_TEMP = 1;
   case

     when P_TYPE = "CP" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CP";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("CP",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "BP" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "BP";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("BP",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "RC" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "RC";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("RC",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "RB" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "RB";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("RB",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "JV" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "JV";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("JV",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "CN" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CN";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("CN",VOUCHER_TEMP) AS V_CODE;
     when P_TYPE = "DN" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "DN";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("DN",VOUCHER_TEMP) AS V_CODE;
	 when P_TYPE = "CR" then
        SELECT IFNULL(MAX(CONVERT(SUBSTRING(VOUCHER_CODE,3),SIGNED INTEGER)),0) INTO VOUCHER_TEMP FROM tbl_transactions WHERE LEFT(VOUCHER_CODE,2) = "CR";
        SET VOUCHER_TEMP = VOUCHER_TEMP+1;
        SELECT CONCAT("CR",VOUCHER_TEMP) AS V_CODE;


   end case;

end$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_ORDER_ITEMS_BY_OID`(IN `I_ORDER_ID` INT)
BEGIN
SELECT
	tbl_inv_purchase_order_item.*,
	tbl_inv_item_master.ITEM_ID,
    tbl_inv_item_master.ITEM_NAME,
    tbl_inv_item_master.ITEM_HEAD_ID,
    tbl_inv_units.UNIT_NAME

FROM tbl_inv_purchase_order_item,
	tbl_inv_item_master,
    tbl_inv_category,tbl_inv_units
WHERE
	tbl_inv_purchase_order_item.ITEM_O_MASTER_ID = tbl_inv_item_master.ITEM_ID AND
	tbl_inv_item_master.ITEM_UNIT_ID = tbl_inv_units.UNIT_ID AND
    tbl_inv_purchase_order_item.ITEM_O_ORDER_ID = I_ORDER_ID
GROUP BY
    tbl_inv_purchase_order_item.ITEM_O_ID;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_PRODUCT_STOCK_AT_STORE`(STORE_ID INTEGER,PRODUCT_ID INTEGER)
BEGIN

DECLARE STOCK_AT_STORE DOUBLE;
DECLARE STOCK_AT_VAN DOUBLE;
DECLARE BALACE_STOCK_PACKET_COUNT DOUBLE;

SELECT
    IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
FROM
    tbl_inv_mini_stock
WHERE MINI_LOCATION_ID = STORE_ID AND MINI_PACKET_MASTER_ID = PRODUCT_ID;

SELECT
    IFNULL(SUM(MINI_INV_ITEM_QTY),0) INTO STOCK_AT_VAN
FROM
    tbl_mini_invoice_items,
    tbl_mini_invoice_master
WHERE
    tbl_mini_invoice_items.MINI_INV_MASTER_ID = tbl_mini_invoice_master.MINI_INV_ID AND
    tbl_mini_invoice_master.MINI_INV_LOCATION_MASTER_ID = STORE_ID AND
    tbl_mini_invoice_items.MINI_INV_ITEM_PACKET_ID = PRODUCT_ID;

SET BALACE_STOCK_PACKET_COUNT = STOCK_AT_STORE - STOCK_AT_VAN;
SELECT BALACE_STOCK_PACKET_COUNT;

END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_GET_STOCK_LEDGER`(`I_ITEM_ID` INTEGER, `FROM_DT` DATE, `TO_DT` DATE)
BEGIN



SELECT
 tbl_inv_purchase_invoice.INV_DATE AS LEDGER_DT,
 tbl_inv_purchase_invoice.INV_INV_NUMBER AS LEDGER_NUM,
 tbl_inv_supplier.SUPP_NAME AS LEDGER_SUP_PROD,
 tbl_inv_purchase_invoice_item.INV_ITEM_QTY AS LEDGER_QTY,
 ' ' AS LEDGER_STOCK_OUT

FROM
 tbl_inv_purchase_invoice_item,
 tbl_inv_purchase_invoice,
 tbl_inv_supplier
WHERE
 tbl_inv_purchase_invoice.INV_SUPPLIER_ID = tbl_inv_supplier.SUPP_ID AND
 tbl_inv_purchase_invoice_item.INV_ITEM_INV_ID = tbl_inv_purchase_invoice.INV_ID AND
 tbl_inv_purchase_invoice_item.INV_ITEM_MASTER_ID = I_ITEM_ID AND
 (tbl_inv_purchase_invoice.INV_DATE BETWEEN FROM_DT AND TO_DT)

UNION ALL

SELECT
  tbl_inv_production.PRODU_DATE AS LEDGER_DT,
  tbl_inv_production.PRODU_PRODUCT_ID AS LEDGER_NUM,
  tbl_inv_product.PROD_NAME AS LEDGER_SUP_PROD,
  ' ' AS LEDGER_QTY,
  tbl_inv_production_items.P_ITEM_QTY AS LEDGER_STOCK_OUT


FROM
  tbl_inv_production_items,
  tbl_inv_production,
  tbl_inv_product
WHERE
 tbl_inv_production_items.P_PRODUCTION_ID = tbl_inv_production.PRODU_ID AND
 tbl_inv_production.PRODU_PRODUCT_ID = tbl_inv_product.PROD_ID AND
 (tbl_inv_production.PRODU_DATE BETWEEN FROM_DT AND TO_DT) AND
 tbl_inv_production_items.P_ITEM_MASTR_ID = I_ITEM_ID ORDER BY LEDGER_DT;


END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `P_UPDATE_SALES_INVOICE_NUMBER`(`I_SALES_MAN_ID` INTEGER, `I_INVOICE_ID` INTEGER)
BEGIN
	UPDATE tbl_inv_sales_invoice SET SALES_INVOICE_NUM =
    F_GET_INVOICE_NUMBER(I_SALES_MAN_ID) WHERE SALES_INVOICE_ID = I_INVOICE_ID;
END$$

--
-- Functions
--
CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_BETWEEN`(`ACC_ID` INTEGER(11), `FROM_DATE` DATE, `TO_DATE` DATE) RETURNS double
    READS SQL DATA
    DETERMINISTIC
begin

    DECLARE DEBIT_TOTAL DOUBLE;
    DECLARE CREDIT_TOTAL DOUBLE;
    DECLARE BALANCE DOUBLE;

    SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
    FROM tbl_transactions
    WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND DEBIT_ACC_ID = ACC_ID;

    SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
    FROM tbl_transactions
    WHERE (TRASACTION_DATE BETWEEN FROM_DATE AND TO_DATE) AND CREDIT_ACC_ID = ACC_ID;

   SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;

   RETURN IFNULL(BALANCE,0);
end$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_BETWEEN_BY_GROUP`(`ACC_GROUP_ID` INT, `FROM_DATE` DATE, `TO_DATE` DATE) RETURNS double
    READS SQL DATA
    DETERMINISTIC
BEGIN
	DECLARE TOTAL_BALANCE DOUBLE;
	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';
	RETURN TOTAL_BALANCE;

END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_UNTIL`(`ACC_ID` INT(11), `UNTIL_DATE` DATE) RETURNS decimal(10,0)
    READS SQL DATA
    DETERMINISTIC
begin

DECLARE DEBIT_TOTAL DOUBLE;
DECLARE CREDIT_TOTAL DOUBLE;
DECLARE OPENING_TOTAL DOUBLE;
DECLARE BALANCE DOUBLE;

SELECT IFNULL(SUM(OP_BNCE_AMOUNT),0) INTO OPENING_TOTAL
FROM tbl_opening_balance
WHERE OP_BNCE_ACCOUNT_ID = ACC_ID;

SELECT IFNULL(SUM(AMOUNT),0) INTO DEBIT_TOTAL
FROM tbl_transactions
WHERE TRASACTION_DATE < UNTIL_DATE AND DEBIT_ACC_ID = ACC_ID;

SELECT IFNULL(SUM(AMOUNT),0) INTO CREDIT_TOTAL
FROM tbl_transactions
WHERE TRASACTION_DATE < UNTIL_DATE AND CREDIT_ACC_ID = ACC_ID;


IF(OPENING_TOTAL > 0) THEN
	SET DEBIT_TOTAL = DEBIT_TOTAL + OPENING_TOTAL;
ELSE
	SET CREDIT_TOTAL = CREDIT_TOTAL + abs(OPENING_TOTAL);
END IF;

SET BALANCE = DEBIT_TOTAL - CREDIT_TOTAL;
RETURN BALANCE;


end$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_ACC_BALANCE_UNTIL_BY_GROUP`(`GROUP_ACC_ID` INT(11), `UNTIL_DATE` DATE) RETURNS double
    READS SQL DATA
    DETERMINISTIC
BEGIN
	DECLARE TOTAL_BALANCE DOUBLE;
	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';
	RETURN TOTAL_BALANCE;
END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_INVOICE_NUMBER`(`SALES_MAN_ID` INTEGER) RETURNS varchar(255) CHARSET latin1
BEGIN
	DECLARE SALES_MAN_PREFIX VARCHAR(3);
    DECLARE HEIGHEST_INVOICE_NUM INTEGER;
    DECLARE RETURN_NUMBER VARCHAR(255);
    SELECT MAN_PREFIX INTO SALES_MAN_PREFIX FROM tbl_inv_salesman WHERE MAN_ID = SALES_MAN_ID;

    SELECT  IFNULL(MAX(SUBSTRING(SALES_INVOICE_NUM,3)),0)
     INTO HEIGHEST_INVOICE_NUM FROM tbl_inv_sales_invoice
    WHERE LEFT(SALES_INVOICE_NUM,2) = SALES_MAN_PREFIX;

    SET RETURN_NUMBER = CONCAT(SALES_MAN_PREFIX,HEIGHEST_INVOICE_NUM+1);
    RETURN RETURN_NUMBER;





END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCTION_STOCK`(`I_PRODUCT_ID` INTEGER) RETURNS double
    READS SQL DATA
    DETERMINISTIC
BEGIN
	DECLARE TOTAL_PRODUCTION_QTY DOUBLE;
    DECLARE TOTAL_SALES_QTY DOUBLE;
    DECLARE TOTAL_AVAILABLE_STOCK DOUBLE;

    SELECT
		IFNULL(SUM(STOCK_QTY),0) INTO TOTAL_PRODUCTION_QTY
    FROM
		tbl_inv_production_stock
	WHERE
		tbl_inv_production_stock.STOCK_PRODUCT_ID = I_PRODUCT_ID;

    SELECT
		IFNULL(SUM(SALES_QTY),0) INTO TOTAL_SALES_QTY
	FROM
		tbl_inv_sales_invoice_item
	WHERE
		SALES_PRODUCT_ID = I_PRODUCT_ID;

    SET TOTAL_AVAILABLE_STOCK = TOTAL_PRODUCTION_QTY - TOTAL_SALES_QTY;

	RETURN TOTAL_AVAILABLE_STOCK;
END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_PRODUCT_STOCK`(`PRODUCT_ID` INTEGER, `PRODUCTION_DT` DATE) RETURNS double
BEGIN

	DECLARE PRODUCTION_STOCK_QTY DOUBLE;
    DECLARE TOTAL_STOCK_QTY DOUBLE;

    SELECT IFNULL(sum(STOCK_QTY),0) INTO PRODUCTION_STOCK_QTY
    FROM
    tbl_inv_production_stock,
    tbl_inv_production
    WHERE
    tbl_inv_production_stock.STOCK_PRODUCTION_ID = PRODU_ID AND
    tbl_inv_production_stock.STOCK_PRODUCT_ID = PRODUCT_ID AND
    tbl_inv_production.PRODU_DATE <= PRODUCTION_DT;

    SELECT IFNULL(sum((tbl_inv_packed_stock.PACK_QTY * tbl_inv_packet_master.PACKET_QTY)),0) INTO TOTAL_STOCK_QTY
	FROM tbl_inv_packed_stock,tbl_inv_packet_master where
    tbl_inv_packed_stock.PACK_MASTER_ID = tbl_inv_packet_master.PACKET_ID AND
    tbl_inv_packet_master.PACKET_PRODUCT_ID = PRODUCT_ID AND
    tbl_inv_packed_stock.PACK_DATE <= PRODUCTION_DT;


	RETURN PRODUCTION_STOCK_QTY - TOTAL_STOCK_QTY;

END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_AT_STORE`(`STORE_ID` INT, `PACKING_MASTER_ID` INT) RETURNS int(11)
BEGIN
    DECLARE STOCK_AT_STORE INTEGER;
    DECLARE STOCK_SOLD INTEGER;
    DECLARE STOCK_RETURN INTEGER;
    DECLARE BALANCE_STOCK INTEGER;

    SELECT
        IFNULL(SUM(MINI_QTY),0) INTO STOCK_AT_STORE
    FROM
        tbl_inv_mini_stock
    WHERE
        MINI_LOCATION_ID = STORE_ID AND
        MINI_PACKET_MASTER_ID = PACKING_MASTER_ID;

    SELECT
        IFNULL(SUM(SALES_QTY),0) INTO STOCK_SOLD
    FROM
        tbl_inv_sales_invoice_item,
        tbl_inv_sales_invoice
    WHERE
        tbl_inv_sales_invoice_item.SALES_INVOICE_ID = tbl_inv_sales_invoice.SALES_INVOICE_ID AND
        tbl_inv_sales_invoice.SALES_MINI_STORE_LOCATION_ID = STORE_ID AND
        tbl_inv_sales_invoice_item.SALES_PRODUCT_ID = PACKING_MASTER_ID AND
        tbl_inv_sales_invoice.SALES_TYPE = 'S';

    SELECT
        IFNULL(SUM(SALES_QTY),0) INTO STOCK_RETURN
    FROM
        tbl_inv_sales_invoice_item,
        tbl_inv_sales_invoice
    WHERE
        tbl_inv_sales_invoice_item.SALES_INVOICE_ID = tbl_inv_sales_invoice.SALES_INVOICE_ID AND
        tbl_inv_sales_invoice.SALES_MINI_STORE_LOCATION_ID = STORE_ID AND
        tbl_inv_sales_invoice_item.SALES_PRODUCT_ID = PACKING_MASTER_ID AND
        tbl_inv_sales_invoice.SALES_TYPE = 'R';

    SET BALANCE_STOCK = (STOCK_AT_STORE + STOCK_RETURN) - STOCK_SOLD;
    return BALANCE_STOCK;

END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `F_GET_STOCK_BET_INV_AND_MINI`(`PACKET_MASTER_ID` INT) RETURNS int(11)
BEGIN


    DECLARE TOTAL_MINI_STOCK INTEGER;
    DECLARE TOTAL_PACKED_STOCK INTEGER;

    SELECT
		IFNULL(SUM(MINI_QTY),0) INTO TOTAL_MINI_STOCK
	FROM
		tbl_inv_mini_stock
    WHERE
		MINI_PACKET_MASTER_ID = PACKET_MASTER_ID;

    SELECT
		IFNULL(SUM(PACK_QTY),0) INTO TOTAL_PACKED_STOCK
	FROM
		tbl_inv_packed_stock
	WHERE
		tbl_inv_packed_stock.PACK_MASTER_ID = PACKET_MASTER_ID;

    RETURN TOTAL_PACKED_STOCK - TOTAL_MINI_STOCK;




END$$

DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_acc_groups`
--

CREATE TABLE IF NOT EXISTS `tbl_acc_groups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `G_H_NAME` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `TYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CHILD_OF` int(11) DEFAULT NULL,
  `REF_ACC_ID` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=333 ;

--
-- Dumping data for table `tbl_acc_groups`
--

INSERT INTO `tbl_acc_groups` (`ID`, `G_H_NAME`, `TYPE`, `CHILD_OF`, `REF_ACC_ID`) VALUES
(1, 'CASH ACCOUNT', 'G', 1, 0),
(2, 'BANK ACCOUNT', 'G', 1, 0),
(3, 'PURCHASE ACCOUNT', 'G', 1, 0),
(4, 'SALES ACCOUNT', 'G', 3, 0),
(5, 'SUPPLIERS ACCOUNT', 'G', 2, 0),
(6, 'CUSTOMERS ACCOUNT', 'G', 1, 0),
(91, 'Cash In Hand', 'H', 1, 0),
(92, 'NBD', 'H', 2, 0),
(93, 'ROW MATERIAL PURCHASE A/C', 'H', 3, 0),
(96, 'PRODUCT SALES', 'H', 4, 0),
(97, 'K M T', 'H', 6, 1),
(100, 'CAPITAL ACCOUNT', 'G', 2, 0),
(101, 'ABC CAPITAL', 'H', 100, 0),
(102, 'Rice items purchase', 'H', 3, 0),
(103, 'ADMIN EXP', 'G', 4, 0),
(104, 'SALARY EXP', 'H', 103, 0),
(118, 'lulu hyper mkt nahda shj', 'H', 6, 4),
(119, 'bin zaid flour mills', 'H', 5, 1),
(120, 'al bayader international ', 'H', 5, 2),
(121, 'Noor Al Qusais Super Market - Dubai', 'H', 6, 5),
(122, 'PASONS AL MADINAH SUPER MARKET - KARAMA DUBAI', 'H', 6, 6),
(123, ' PASONS AL MADINAH SUPER MARKET - AL NAHDAH', 'H', 6, 7),
(124, 'PASONS AL MADINAH SUPER MARKET - INT CITY DUBAI', 'H', 6, 8),
(125, 'AL BERWAZ PLASTIC FACTORY', 'H', 5, 3),
(126, 'AL HASNAA FOODSTUFF TRD.', 'H', 5, 4),
(127, 'AL HILAL Cleaning Materials Trading', 'H', 5, 5),
(128, 'AL LEWAA FLOUR MILL & FOOD STUFF TRD.', 'H', 5, 6),
(129, 'AL MAILEE DISTRIBUTION', 'H', 5, 7),
(130, 'AL MAWAKEB NUTS L.L.C', 'H', 5, 8),
(131, 'Best Bakery LLC', 'H', 5, 9),
(132, 'BROTHERS GAS', 'H', 5, 10),
(133, 'CITY PAK', 'H', 5, 11),
(134, 'Falcon Pack', 'H', 5, 12),
(135, 'FreeTrade International FZE', 'H', 5, 13),
(136, 'GHULAMI General Trading LLC Dubai', 'H', 5, 14),
(137, 'GREAT EMIRATES FOOD STUFF CATERING L.L.C', 'H', 5, 15),
(138, 'GRIPPO GROUP- RAK', 'H', 5, 16),
(139, 'Haroon Labels Industries L. L.C', 'H', 5, 17),
(140, 'IFFCO DISTRIBUTION SERVICE-DUBAI', 'H', 5, 18),
(141, 'MODERN GEN.TRD CO.', 'H', 5, 19),
(142, 'MUDRA GEN. TRD.', 'H', 5, 20),
(143, 'RAG FOOD STUFF TRD.L.L.C', 'H', 5, 21),
(144, 'SAFCO (Sanwhey Food Stuff Trd)', 'H', 5, 22),
(145, 'AJMAN & AL MANAMA SUPER MKT(BR.2-AL WAHDA-SHARJAH)', 'H', 6, 9),
(146, 'AL MANAMA(AL NAHDA-II DUBAI)', 'H', 6, 10),
(147, 'AL MANAMA CENTRE BR.1 ATLAS MALL', 'H', 6, 11),
(148, 'AL MANAMA CENTRE (MYSALOON-SHJ)', 'H', 6, 12),
(149, 'AL MANAMA CENTRE (NUAIMIYAH-AJMAN)', 'H', 6, 13),
(150, 'AL Manama Cneter Br-2 - AbuShagara- SHJ', 'H', 6, 14),
(151, 'AL MANAMA HYPER(AL QOUS-DUBAI)', 'H', 6, 15),
(152, 'AL MANAMA HYPER MARKET(RAK)', 'H', 6, 16),
(153, 'Al Manama Hyper Market - Umm Al Quwain', 'H', 6, 17),
(154, 'AL MANAMA HYPER MKT(KARAMA-DUBAI)', 'H', 6, 18),
(155, 'AL MANAMA HYPR (AL FAHEDI-DUBAI)', 'H', 6, 19),
(156, 'AL MANAMA HYPR-MALL(AJMAN)', 'H', 6, 20),
(157, 'AL MANAMA SM (JURAF- AJMAN)', 'H', 6, 21),
(158, 'AL MANAMA SPR MKT (DANA- PLAZA AJMAN)', 'H', 6, 22),
(159, 'AL MANAMA SUPER MARKET( ROLLA-SHARJAH)', 'H', 6, 23),
(160, 'AL SAIF AL DHAHABI SPR MKT-RAK', 'H', 6, 24),
(161, 'AL SAIF AL DHAHABI SPR [RAK CERAMIC]', 'H', 6, 25),
(162, 'AL WAFA CENTRE GEN. TRD. (AL WAHDAH-SHARJAH)', 'H', 6, 26),
(163, 'AL WAFA CENTRE(ROLLA-SHARJAH)', 'H', 6, 27),
(164, 'EVERFINE SPR MKT(DEIRA-DUBAI)', 'H', 6, 28),
(165, 'NESTO Caravan SM (DUBAI)', 'H', 6, 29),
(166, 'NESTO CENTRE-AJMAN', 'H', 6, 30),
(167, 'NESTO CENTRE L.L.C(RAK)', 'H', 6, 31),
(168, 'NESTO Hyper Market Br-1 Mushrif-Ajman', 'H', 6, 32),
(169, 'NESTO HYPER MARKET (JEBEL ALI-DUBAI)', 'H', 6, 33),
(170, 'NESTO Hyper Market - JURAF AJMAN', 'H', 6, 34),
(171, 'NESTO HYPER MKT-AJMAN', 'H', 6, 35),
(172, 'NESTO HYPER MKT (BUTHAINA -SHJ)', 'H', 6, 36),
(173, 'NESTO HYPER MKT SHJ BR.1', 'H', 6, 37),
(174, 'NESTO SUPR MKT CORNICHE-AJMAN', 'H', 6, 38),
(175, 'NEW NESTO CENTRE L.L.C(SHARJAH)', 'H', 6, 39),
(176, 'FATHIMA HYPER MARKET-RAK', 'H', 6, 40),
(177, 'FATHIMA SUPER MARKET-AJMAN', 'H', 6, 41),
(178, 'Grand Mart - Ajman', 'H', 6, 42),
(179, 'GRAND MART - RAK', 'H', 6, 43),
(180, 'J-MART (AL QUOZ-DUBAI)', 'H', 6, 44),
(181, 'J-MART (CLOCK TOWER-SHJ)', 'H', 6, 45),
(182, 'J-MART(MOROCCO INTERNATIONAL CITY-DUBAI)', 'H', 6, 46),
(183, 'J-MART(MUTEENA)', 'H', 6, 47),
(184, 'KM HYPER MARKET - BUR DUBAI', 'H', 6, 48),
(185, 'K. M. HYPER MARKET(INDUSTRL. AREA SHARJAH)', 'H', 6, 49),
(186, 'K.M TRADING SHOPPING CENTRE(ABU SHAGARA-SHJ)', 'H', 6, 50),
(187, 'K M TRADING SHOPPING CENTRE(DUBAI)', 'H', 6, 51),
(188, 'Al Falah Plaza- Abu Dhabi', 'H', 6, 52),
(189, 'EMKE Super Market Madiant Zayed- Abu Dhabi', 'H', 6, 53),
(190, 'LULU Center - Abu Dhabi', 'H', 6, 54),
(191, 'LULU HM Bain Al Jesrain CO. OP. Society - Abu Dhab', 'H', 6, 55),
(192, 'LULU Hyper Market Al Wahda Mall - Abu Dhabi', 'H', 6, 56),
(193, 'LULU Hyper Market Baniyas - Abu Dhabi', 'H', 6, 57),
(194, 'LULU Hyper Market Capital Mall - Abu Dhabi', 'H', 6, 58),
(195, 'LULU Hyper Market Khalidiya Mall-Abu Dhabi', 'H', 6, 59),
(196, 'LULU Hyper Market Madinat Zayed - Abu Dhabi', 'H', 6, 60),
(197, 'LULU HYPER MARKET Mushrif Mall - Abu Dhabi', 'H', 6, 61),
(198, 'LULU Hyper Market Ruwais - Abu Dhabi', 'H', 6, 62),
(199, 'LULU XPRESS-Adnoc Housing Complex (Ruwaisa-AH)', 'H', 6, 63),
(200, 'LULU Xpress Al Raha Mall - Abu Dhabi', 'H', 6, 64),
(201, 'LULU Xpress Electra Street - Abu Dhabi', 'H', 6, 65),
(202, 'LULU Xpress Fresh Market City Center Mall-Abu Dhab', 'H', 6, 66),
(203, 'LULU Xpress Fresh Market Hamdan- Abu Dhabi', 'H', 6, 67),
(204, 'LULU Xpress Gayathi , Ruwais -Abu Dhabi', 'H', 6, 68),
(205, 'Lulu Xpress Mazyad Mall, Musaffah - Abu Dhabi', 'H', 6, 69),
(206, 'LULU Xpress Mureeer Road- Abu Dhabi', 'H', 6, 70),
(207, 'LULU XPRESS Shawamekh - Abu Dhabi', 'H', 6, 71),
(208, 'LULU HYPER MKT-AJMAN', 'H', 6, 72),
(209, 'AL FALAH PLAZA- AL AIN', 'H', 6, 73),
(210, '  Lulu Center - Al Ain', 'H', 6, 74),
(211, 'Lulu Hyper Market Alfoah Br - Al Ain', 'H', 6, 75),
(212, 'LULU Hyper Market Barari Outlet Mall- Al Ain', 'H', 6, 76),
(213, 'LULU HYPER MARKET - HILL MALL, AL AIN', 'H', 6, 77),
(214, 'LULU Hyper Market - Kuwaital Br- AL AIN', 'H', 6, 78),
(215, 'LULU Hyper Market Sanaiya - Al Ain', 'H', 6, 79),
(216, 'LULU CENTRE (MUHAISNAH DUBAI)', 'H', 6, 80),
(217, 'LULU HYPER ARABIAN CENTRE(DUBAI)', 'H', 6, 81),
(218, 'LULU HYPER MARKET(AL BARSHA-DUBAI)', 'H', 6, 82),
(219, 'LULU HYPER MARKET(AL QUSAIS-DUBAI)', 'H', 6, 83),
(220, 'LULU HYPER MARKET (KARAMA-DUBAI)', 'H', 6, 84),
(221, 'LULU SUPER MARKET(KARAMA-DUBAI)', 'H', 6, 85),
(222, 'LULU XPRESS(AL QUOZ-DUBAI)', 'H', 6, 86),
(223, 'LULU XPRESS INTERNATIONAL CITY(DUBAI)', 'H', 6, 87),
(224, 'LULU HYPER MKT(DIBBA-FUJAIRA)', 'H', 6, 88),
(225, 'LULU HYPER MKT-Fujairah', 'H', 6, 89),
(226, 'LULU HYPER MARKET(RAK)', 'H', 6, 90),
(227, 'LULU HYPER MARKET SHARJAH', 'H', 6, 91),
(228, 'LULU HYPER MARKET UM AL QUWAIN', 'H', 6, 92),
(229, 'Ramla Hyper Market Al- Nahdah Dubai', 'H', 6, 93),
(230, 'Ramla Hyper Market (DIP - Dubai)', 'H', 6, 94),
(231, 'RAMLA HYPER MARKET -RAK', 'H', 6, 95),
(232, 'Ramla Super Market -Musaffah Adu Dhabi', 'H', 6, 96),
(233, '2002- CAFETERIA-AJMAN', 'H', 6, 97),
(234, 'ABU SHABANA GROCERY- ABU DHABI', 'H', 6, 98),
(235, 'AHLAN SUPER MARKET -RAK', 'H', 6, 99),
(236, 'AIN AL MADINA HYPR MKT-AJMAN', 'H', 6, 100),
(237, 'AJMAL SUPER MARKET - RAK', 'H', 6, 101),
(238, 'AL AALIYA RESTURANT - RAK', 'H', 6, 102),
(239, 'AL ALFIYA SPR MKT-AJMAN', 'H', 6, 103),
(240, 'Al Bakhoor Grocery - Abu Dhabi', 'H', 6, 104),
(241, 'AL Ekhwan Grocery-RAK(RAMS)', 'H', 6, 105),
(242, 'AL FAWAHAR SPR MKT-AJMAN', 'H', 6, 106),
(243, 'Al Ghabat City SM - Mussaffah Abu Dhabi', 'H', 6, 107),
(244, 'AL GHAFRI GROCERY - ABU DHABI', 'H', 6, 108),
(245, 'Al Ghanem Super Market - RAK', 'H', 6, 109),
(246, 'AL JABIRI SPR MKT-AJMAN', 'H', 6, 110),
(247, 'AL JAZEERA SPR MKT-RAK', 'H', 6, 111),
(248, 'Al Khatm Grocery- Abu Dhabi', 'H', 6, 112),
(249, 'AL MAWAL SUPERMARKET  NP SHARJAH', 'H', 6, 113),
(250, 'Al Muhrami Grocery- Abu Dhabi', 'H', 6, 114),
(251, 'AL NASRIYA SPR MKT-AJMAN', 'H', 6, 115),
(252, 'Al Nokhbah Super Market -RAK', 'H', 6, 116),
(253, 'Al Qareeb Grocery- Abu Dhabi', 'H', 6, 117),
(254, 'Al Qraiwan Grosery Rak', 'H', 6, 118),
(255, 'AL SAMARY SUPER MARKET', 'H', 6, 119),
(256, 'Al Sandian Resturant - Al Ain', 'H', 6, 120),
(257, 'AL SHARAM SPR MKT-RAK', 'H', 6, 121),
(258, 'AL USTHAD SPR MKT-AJMAN', 'H', 6, 122),
(259, 'ASEMA SPR MKT- AJMAN', 'H', 6, 123),
(260, 'Aswaq Grocery- Abu Dhabi', 'H', 6, 124),
(261, 'ATIQ FOOD STUFF(AJMAN)', 'H', 6, 125),
(262, 'AYA SPR MKT(AJMAN)', 'H', 6, 126),
(263, 'BAQALA AL SAHER - ABU DHABI', 'H', 6, 127),
(264, 'BARANA AL MADINAH SM', 'H', 6, 128),
(265, 'BINTH JUNAIL SPR MKT(AJMAN)', 'H', 6, 129),
(266, 'BURJ MALABAR  SUPERMARKET AJMAN', 'H', 6, 130),
(267, 'BUTTER FLY SPR MKT-AJMAN', 'H', 6, 131),
(268, 'DANAT AL KHALEEJ- AJMAN', 'H', 6, 132),
(269, 'Dar Ul Haman Grocery - RAK', 'H', 6, 133),
(270, 'E CITY SUPER MARKET (RUSSIA V22_ - DUBAI', 'H', 6, 134),
(271, 'FAHIDA SUPER MARKET-AJMAN', 'H', 6, 135),
(272, 'Families Super Market - RAK', 'H', 6, 136),
(273, 'FOUR STAR FOOD STUFF( AJMAN)', 'H', 6, 137),
(274, 'GOLDEN BUTTERFLY SPR MKT-AJMAN', 'H', 6, 138),
(275, 'Happy Land SM (Mateena Deira -Dubai)', 'H', 6, 139),
(276, 'HAPPY LAND SPR MKT-AJMAN', 'H', 6, 140),
(277, 'HARAM AL MADINA SUPERMARKET AJMAN', 'H', 6, 141),
(278, 'Hilal Al Madinah Super Market - SHJ', 'H', 6, 142),
(279, 'IBAN - Supermarket -RAK', 'H', 6, 143),
(280, 'JAWAHAR SUPER MKT-AJMAN', 'H', 6, 144),
(281, 'JAZARATH AL MADINA SPR-ALGAIL-RAK', 'H', 6, 145),
(282, 'KMK SUPER MARKET', 'H', 6, 146),
(283, 'MADINATH AL SAHAB SPR MKT-AJMAN', 'H', 6, 147),
(284, 'MAKKAH SPR MKT-AJMAN', 'H', 6, 148),
(285, 'Metro Grocery- Abu Dhabi', 'H', 6, 149),
(286, 'MIDAD GROCERY - ABU DHABI', 'H', 6, 150),
(287, 'Mina Al Arab Super Market', 'H', 6, 151),
(288, 'MUHAMMAD IQBAL GROCERY- ABU DHABI', 'H', 6, 152),
(289, 'NAIL SPR MKT-AJMAN', 'H', 6, 153),
(290, 'NAJAM AL DANUBE SM - AJMAN', 'H', 6, 154),
(291, 'NOOR AL AHLAM GROCERY- AL AIN', 'H', 6, 155),
(292, 'Noor Al Madina Spr Mkt-Ajman', 'H', 6, 156),
(293, 'PANDA SUPER MKT-RAK', 'H', 6, 157),
(294, 'Parco Hyper Market LLC', 'H', 6, 158),
(295, 'Royal Al Madinah SM- Abu Dhabi', 'H', 6, 159),
(296, 'SAHAR AL MADINA SPR -AJMAN', 'H', 6, 160),
(297, 'Sahem Al Madina Supermarket Ajman UAE', 'H', 6, 161),
(298, 'Seah Al Madeena Grocery Rak', 'H', 6, 162),
(299, 'Seeh Al Ghail Grocery & Resturent', 'H', 6, 163),
(300, 'SEVEN ELEVEN SPR MKT-RAK', 'H', 6, 164),
(301, 'SHABAB AL WADI FOODSTUFF TRADING AJMAN KARAMA', 'H', 6, 165),
(302, 'Sky Light Grocery  - Abu Dhabi', 'H', 6, 166),
(303, 'SNABAL KHAIR BAQALA - ABU DHABI', 'H', 6, 167),
(304, 'SNOE WHITE GROCCERY- ABU DHABI', 'H', 6, 168),
(305, 'Souq Al Madinah Super Market - RAK', 'H', 6, 169),
(306, 'SOUQ AL MADINA SPR MKT-AL GAIL-RAK', 'H', 6, 170),
(307, 'Spike of Prosperity SM - Abu Dhabi', 'H', 6, 171),
(308, 'Sring SM Satwa -Dubai', 'H', 6, 172),
(309, 'SUN CITY HYPER MKT-AJMAN', 'H', 6, 173),
(310, 'Super Star Grocery - Abu Dhabi', 'H', 6, 174),
(311, 'TAIBA SUPER MARKET-AJMAN', 'H', 6, 175),
(312, 'TRANS GROCERY - ABU DHABI', 'H', 6, 176),
(313, 'Vally Corner Grocery - Abu Dhabi', 'H', 6, 177),
(314, 'Wafa Al Madinah Sm Dubai', 'H', 6, 178),
(315, 'ZAHART BAGHDAD SM-AJMAN', 'H', 6, 179),
(316, 'Zeeba SM - Abu Dhabi', 'H', 6, 180),
(317, 'SUPER BONANZA HYPER MARKET - DUBAI', 'H', 6, 181),
(318, 'SUPER BONANZA HYPER MARKET - SHARJAH', 'H', 6, 182),
(319, 'Al Ghail Super Market LLC -RAK', 'H', 6, 183),
(320, 'AL MADINAH Hyper Market -Ras Al Khaor -Duabi', 'H', 6, 184),
(321, 'Church- Ras Al Khaimah', 'H', 6, 185),
(322, 'GULF EXPRESS SUPER MARKET - RAK', 'H', 6, 186),
(323, 'GULF HYPER MARKET-RAK', 'H', 6, 187),
(324, 'IBAN SUPERMARKET - RAK (Credit Sale)', 'H', 6, 188),
(325, 'INDIAN SCHOOL', 'H', 6, 189),
(326, 'KENZ Hyper Market -Ajman', 'H', 6, 190),
(327, 'KERALA SUPER MARKET', 'H', 6, 191),
(328, 'PACKING MATERIALS', 'H', 3, 0),
(329, '111', 'H', 1, 0),
(331, 'Items for Re-sale', 'H', 3, 0),
(332, 'Al khair vegitable & fruits trading', 'H', 5, 23);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_acc_master`
--

CREATE TABLE IF NOT EXISTS `tbl_acc_master` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `GROUP_NAME` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_acc_master`
--

INSERT INTO `tbl_acc_master` (`ID`, `GROUP_NAME`) VALUES
(1, 'Asset'),
(2, 'Liability'),
(3, 'Income'),
(4, 'Expense');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_assets`
--

CREATE TABLE IF NOT EXISTS `tbl_assets` (
  `ASSET_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ASSET_NAME` varchar(255) NOT NULL,
  `ASSET_VOUCHER_CODE` varchar(255) NOT NULL,
  `ASSET_GROUP` int(11) NOT NULL,
  `ASSET_CATEGORY` int(11) NOT NULL,
  `ASSET_UNIT` int(11) NOT NULL,
  `ASSET_LOCATION` int(11) NOT NULL,
  `ASSET_ACCOUNT` int(11) NOT NULL,
  `ASSET_DEPRECIATION` int(11) NOT NULL,
  `ASSET_DISPOSAL` int(11) NOT NULL,
  `ASSET_SUPPLIER` int(11) NOT NULL,
  `ASSET_QTY` double NOT NULL,
  `ASSET_RATE` double NOT NULL,
  `ASSET_DISCOUNT` double NOT NULL,
  `ASSET_AMOUNT` double NOT NULL,
  `ASSET_USEFUL_LIFE` varchar(11) NOT NULL,
  `ASSET_DEPRE_TYPE` int(11) NOT NULL,
  `ASSET_DATE` date NOT NULL,
  `ASSET_SALVAGE_VALUE` varchar(11) NOT NULL,
  `ASSET_INVOICE_NUMBER` varchar(55) NOT NULL,
  `ASSET_SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ASSET_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_assets`
--

INSERT 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
(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'),
(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');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_asset_categories`
--

CREATE TABLE IF NOT EXISTS `tbl_asset_categories` (
  `ASCAT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ASCAT_NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`ASCAT_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_asset_categories`
--

INSERT INTO `tbl_asset_categories` (`ASCAT_ID`, `ASCAT_NAME`) VALUES
(1, 'category3'),
(2, 'category4'),
(3, 'category7');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_asset_group`
--

CREATE TABLE IF NOT EXISTS `tbl_asset_group` (
  `ASGROUP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ASGROUP_NAME` varchar(255) NOT NULL,
  `ASGROUP_PERCENTAGE` varchar(11) NOT NULL,
  PRIMARY KEY (`ASGROUP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tbl_asset_group`
--

INSERT INTO `tbl_asset_group` (`ASGROUP_ID`, `ASGROUP_NAME`, `ASGROUP_PERCENTAGE`) VALUES
(1, 'group1', '11'),
(2, 'group2', '15'),
(3, 'groups3', '10.5'),
(4, 'groups4', '98'),
(5, 'group6', '111'),
(6, 'group5', '111'),
(7, 'group12', '12');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_asset_location`
--

CREATE TABLE IF NOT EXISTS `tbl_asset_location` (
  `ASLOC_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ASLOC_NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`ASLOC_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_asset_location`
--

INSERT INTO `tbl_asset_location` (`ASLOC_ID`, `ASLOC_NAME`) VALUES
(1, 'location3'),
(2, 'location12'),
(3, 'location5');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_bank_transactions`
--

CREATE TABLE IF NOT EXISTS `tbl_bank_transactions` (
  `BTN_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BTN_VOUCHER_CODE` varchar(255) NOT NULL,
  `BTN_DEBIT_ACC_ID` int(11) DEFAULT NULL,
  `BTN_CREDIT_ACC_ID` int(11) DEFAULT NULL,
  `BTN_AMOUNT` double DEFAULT NULL,
  `BTN_TRASACTION_DATE` date DEFAULT NULL,
  `BTN_SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `BTN_CHQUE_NUM` varchar(255) DEFAULT NULL,
  `BTN_CHQUE_DATE` date DEFAULT NULL,
  `BTN_USER_ID` int(11) NOT NULL,
  `BTN_NARRATION` varchar(350) DEFAULT NULL,
  `BTN_TYPE` int(11) NOT NULL COMMENT '1-cheque,2-bank',
  `BTN_STATUS` varchar(11) NOT NULL DEFAULT 'D' COMMENT 'R_Realised,B-Bounced,D-Deposited',
  `BTN_STATUS_DATE` date DEFAULT NULL,
  `BTN_UPDATED_VOUCHER_CODE` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`BTN_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_bank_transactions`
--

INSERT 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
(1, 'CP1', 104, 91, 25000, '2017-03-01', '2017-04-01 20:00:39', NULL, NULL, 0, '                    ', 0, 'D', NULL, '0'),
(2, 'RC1', 91, 96, 22222, '2017-03-01', '2017-04-01 20:01:20', NULL, NULL, 0, '\r\n                  ', 0, 'D', NULL, '0'),
(3, 'BP1', 331, 92, 522, '2017-03-30', '2017-04-01 20:35:58', '022222', '2017-04-28', 0, '                    ', 1, 'D', NULL, '0'),
(4, 'RB1', 92, 102, 5000, '2017-03-31', '2017-04-01 20:45:52', '001', '2017-03-31', 0, '\r\n                  ', 1, 'D', NULL, '0'),
(5, 'RB2', 92, 328, 200, '1969-12-31', '2017-04-01 20:46:21', '002', '2017-04-14', 0, '\r\n                  ', 1, 'D', NULL, '0'),
(6, 'BP2', 331, 92, 6000, '2017-03-31', '2017-04-01 20:47:12', '0003', '2017-04-14', 0, '                    ', 1, 'D', NULL, '0');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_company_info`
--

CREATE TABLE IF NOT EXISTS `tbl_company_info` (
  `COMPANY_ID` int(11) NOT NULL AUTO_INCREMENT,
  `COMPANY_NAME` varchar(45) DEFAULT NULL,
  `COMPANY_ADDRESS` varchar(45) DEFAULT NULL,
  `COMPANY_MOBILE` varchar(45) DEFAULT NULL,
  `COMPANY_FAX` varchar(45) DEFAULT NULL,
  `COMPANY_EMAIL` varchar(45) DEFAULT NULL,
  `COMPANY_LOGO` varchar(45) DEFAULT NULL,
  `COMPANY_CURRENCY` varchar(3) NOT NULL,
  PRIMARY KEY (`COMPANY_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_company_info`
--

INSERT INTO `tbl_company_info` (`COMPANY_ID`, `COMPANY_NAME`, `COMPANY_ADDRESS`, `COMPANY_MOBILE`, `COMPANY_FAX`, `COMPANY_EMAIL`, `COMPANY_LOGO`, `COMPANY_CURRENCY`) VALUES
(1, 'ABC BAKERY AND SWEETS ', 'P.O Box: 28857, Ras Al Khaimah- U.A.E', '01-8877570', NULL, 'info@abcbakeryuae.com', 'logo.png', 'AED');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `COUNTRY_ID` int(11) NOT NULL AUTO_INCREMENT,
  `COUNTRY_NAME` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`COUNTRY_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`COUNTRY_ID`, `COUNTRY_NAME`) VALUES
(1, 'INDIA'),
(2, 'UAE'),
(3, 'KSA');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_depreciation_type`
--

CREATE TABLE IF NOT EXISTS `tbl_depreciation_type` (
  `DEPR_ID` int(11) NOT NULL AUTO_INCREMENT,
  `DEPR_TYPE_NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`DEPR_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_depreciation_type`
--

INSERT INTO `tbl_depreciation_type` (`DEPR_ID`, `DEPR_TYPE_NAME`) VALUES
(1, 'deptype1'),
(2, 'deptype2');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_dup_transactions`
--

CREATE TABLE IF NOT EXISTS `tbl_dup_transactions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VOUCHER_CODE` varchar(255) NOT NULL,
  `DEBIT_ACC_ID` int(11) DEFAULT NULL,
  `CREDIT_ACC_ID` int(11) DEFAULT NULL,
  `AMOUNT` double DEFAULT NULL,
  `TRASACTION_DATE` date DEFAULT NULL,
  `SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CHQUE_NUM` varchar(255) DEFAULT NULL,
  `CHQUE_DATE` date DEFAULT NULL,
  `ADDRESS` varchar(300) DEFAULT NULL,
  `USER_ID` int(11) DEFAULT NULL,
  `NARRATION` varchar(350) DEFAULT NULL,
  `DELETED_USER` int(11) DEFAULT NULL,
  `INVOICE_NUMBER` varchar(45) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_financial_year`
--

CREATE TABLE IF NOT EXISTS `tbl_financial_year` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `YEAR_START` date DEFAULT NULL,
  `YEAR_END` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_financial_year`
--

INSERT INTO `tbl_financial_year` (`ID`, `YEAR_START`, `YEAR_END`) VALUES
(2, '2016-04-01', '2017-03-31'),
(3, '2017-04-01', '2018-03-31');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_category`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_category` (
  `CATEGORY_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CATEGORY_NAME` varchar(45) DEFAULT NULL,
  `CATEGORY_DATE_ADDED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`CATEGORY_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_inv_category`
--

INSERT INTO `tbl_inv_category` (`CATEGORY_ID`, `CATEGORY_NAME`, `CATEGORY_DATE_ADDED`) VALUES
(1, 'RICE ITEMS', '2017-02-23 20:28:00'),
(2, 'OIL ITEMS', '2017-03-01 01:19:12'),
(3, 'COLOURS', '2017-03-01 01:19:23'),
(4, 'GENERAL', '2017-03-01 01:20:16'),
(5, 'PACKING MATERIALS', '2017-03-08 22:23:37'),
(6, 'Items for re-sale', '2017-03-20 18:01:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_cost_master`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_cost_master` (
  `COST_ID` int(11) NOT NULL AUTO_INCREMENT,
  `COST_PRODUCT_ID` int(11) DEFAULT NULL,
  `COST_QTY` double DEFAULT NULL,
  PRIMARY KEY (`COST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_cost_master_items`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_cost_master_items` (
  `C_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `C_ITEM_MASTER_ID` int(11) DEFAULT NULL,
  `C_ITEM_QTY` double DEFAULT NULL,
  `C_COST_MASTER_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`C_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_customer`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_customer` (
  `CUSTOMER_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CUSTOMER_NAME` varchar(45) DEFAULT NULL,
  `CUSTOMER_ADDRESS` varchar(45) DEFAULT NULL,
  `CUSTOMER_PHONE` varchar(45) DEFAULT NULL,
  `CUSTOMER_LOCATION` varchar(45) DEFAULT NULL,
  `CUSTOMER_EMAIL_ID` varchar(45) DEFAULT NULL,
  `CUSTOMER_COUNTRY_ID` int(11) DEFAULT NULL,
  `CUSTOMER_PRICELIST_ID` int(11) DEFAULT NULL,
  `CUSTOMER_ROUTE_ID` int(11) DEFAULT NULL,
  `CUSTOMER_TIN_NUMBER` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`CUSTOMER_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=201 ;

--
-- Dumping data for table `tbl_inv_customer`
--

INSERT 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
(5, 'Noor Al Qusais Super Market - Dubai', 'WAREHOUSE NOS 11, 233 0', '9809694748', 'shj', 'S.MOHSIN@LIVE.COM', 1, 2, 1, NULL),
(6, 'PASONS AL MADINAH SUPER MARKET - KARAMA DUBAI', '\r\n', '22125125', 'akjsn', 'nkjdsbdk@k.com', 1, 2, 1, NULL),
(7, ' PASONS AL MADINAH SUPER MARKET - AL NAHDAH', 'jk', '2555245245', 'bjbvhjn', 'nkjbahsb@nscnmkl.cmim', 1, 2, 1, NULL),
(8, 'PASONS AL MADINAH SUPER MARKET - INT CITY DUB', 'hhjhnjkn', '2542545588', 'sdvhj', 'sdl@gmail.com', 1, 2, 1, NULL),
(9, 'AJMAN & AL MANAMA SUPER MKT(BR.2-AL WAHDA-SHA', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(10, 'AL MANAMA(AL NAHDA-II DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'AL MANAMA CENTRE BR.1 ATLAS MALL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 'AL MANAMA CENTRE (MYSALOON-SHJ)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 'AL MANAMA CENTRE (NUAIMIYAH-AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 'AL Manama Cneter Br-2 - AbuShagara- SHJ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 'AL MANAMA HYPER(AL QOUS-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'AL MANAMA HYPER MARKET(RAK)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, 'Al Manama Hyper Market - Umm Al Quwain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 'AL MANAMA HYPER MKT(KARAMA-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 'AL MANAMA HYPR (AL FAHEDI-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'AL MANAMA HYPR-MALL(AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 'AL MANAMA SM (JURAF- AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'AL MANAMA SPR MKT (DANA- PLAZA AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, 'AL MANAMA SUPER MARKET( ROLLA-SHARJAH)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 'AL SAIF AL DHAHABI SPR MKT-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 'AL SAIF AL DHAHABI SPR [RAK CERAMIC]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 'AL WAFA CENTRE GEN. TRD. (AL WAHDAH-SHARJAH)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 'AL WAFA CENTRE(ROLLA-SHARJAH)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 'EVERFINE SPR MKT(DEIRA-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 'NESTO Caravan SM (DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, 'NESTO CENTRE-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 'NESTO CENTRE L.L.C(RAK)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 'NESTO Hyper Market Br-1 Mushrif-Ajman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, 'NESTO HYPER MARKET (JEBEL ALI-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 'NESTO Hyper Market - JURAF AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 'NESTO HYPER MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, 'NESTO HYPER MKT (BUTHAINA -SHJ)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 'NESTO HYPER MKT SHJ BR.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 'NESTO SUPR MKT CORNICHE-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 'NEW NESTO CENTRE L.L.C(SHARJAH)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, 'FATHIMA HYPER MARKET-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, 'FATHIMA SUPER MARKET-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, 'Grand Mart - Ajman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, 'GRAND MART - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, 'J-MART (AL QUOZ-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, 'J-MART (CLOCK TOWER-SHJ)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, 'J-MART(MOROCCO INTERNATIONAL CITY-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, 'J-MART(MUTEENA)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, 'KM HYPER MARKET - BUR DUBAI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, 'K. M. HYPER MARKET(INDUSTRL. AREA SHARJAH)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, 'K.M TRADING SHOPPING CENTRE(ABU SHAGARA-SHJ)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 'K M TRADING SHOPPING CENTRE(DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, 'Al Falah Plaza- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 'EMKE Super Market Madiant Zayed- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 'LULU Center - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 'LULU HM Bain Al Jesrain CO. OP. Society - Abu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, 'LULU Hyper Market Al Wahda Mall - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, 'LULU Hyper Market Baniyas - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(58, 'LULU Hyper Market Capital Mall - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, 'LULU Hyper Market Khalidiya Mall-Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, 'LULU Hyper Market Madinat Zayed - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 'LULU HYPER MARKET Mushrif Mall - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 'LULU Hyper Market Ruwais - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 'LULU XPRESS-Adnoc Housing Complex (Ruwaisa-AH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, 'LULU Xpress Al Raha Mall - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, 'LULU Xpress Electra Street - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 'LULU Xpress Fresh Market City Center Mall-Abu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(67, 'LULU Xpress Fresh Market Hamdan- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 'LULU Xpress Gayathi , Ruwais -Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(69, 'Lulu Xpress Mazyad Mall, Musaffah - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 'LULU Xpress Mureeer Road- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, 'LULU XPRESS Shawamekh - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, 'LULU HYPER MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 'AL FALAH PLAZA- AL AIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, 'Lulu Center - Al Ain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(75, 'Lulu Hyper Market Alfoah Br - Al Ain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(76, 'LULU Hyper Market Barari Outlet Mall- Al Ain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(77, 'LULU HYPER MARKET - HILL MALL, AL AIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 'LULU Hyper Market - Kuwaital Br- AL AIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 'LULU Hyper Market Sanaiya - Al Ain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, 'LULU CENTRE (MUHAISNAH DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 'LULU HYPER ARABIAN CENTRE(DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 'LULU HYPER MARKET(AL BARSHA-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 'LULU HYPER MARKET(AL QUSAIS-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, 'LULU HYPER MARKET (KARAMA-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, 'LULU SUPER MARKET(KARAMA-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, 'LULU XPRESS(AL QUOZ-DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 'LULU XPRESS INTERNATIONAL CITY(DUBAI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, 'LULU HYPER MKT(DIBBA-FUJAIRA)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, 'LULU HYPER MKT-Fujairah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 'LULU HYPER MARKET(RAK)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 'LULU HYPER MARKET SHARJAH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(92, 'LULU HYPER MARKET UM AL QUWAIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(93, 'Ramla Hyper Market Al- Nahdah Dubai', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(94, 'Ramla Hyper Market (DIP - Dubai)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(95, 'RAMLA HYPER MARKET -RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(96, 'Ramla Super Market -Musaffah Adu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(97, '2002- CAFETERIA-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(98, 'ABU SHABANA GROCERY- ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, 'AHLAN SUPER MARKET -RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 'AIN AL MADINA HYPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 'AJMAL SUPER MARKET - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 'AL AALIYA RESTURANT - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(103, 'AL ALFIYA SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 'Al Bakhoor Grocery - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, 'AL Ekhwan Grocery-RAK(RAMS)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(106, 'AL FAWAHAR SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(107, 'Al Ghabat City SM - Mussaffah Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(108, 'AL GHAFRI GROCERY - ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(109, 'Al Ghanem Super Market - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(110, 'AL JABIRI SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(111, 'AL JAZEERA SPR MKT-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(112, 'Al Khatm Grocery- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(113, 'AL MAWAL SUPERMARKET  NP SHARJAH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(114, 'Al Muhrami Grocery- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(115, 'AL NASRIYA SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(116, 'Al Nokhbah Super Market -RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(117, 'Al Qareeb Grocery- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(118, 'Al Qraiwan Grosery Rak', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(119, 'AL SAMARY SUPER MARKET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(120, 'Al Sandian Resturant - Al Ain', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(121, 'AL SHARAM SPR MKT-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(122, 'AL USTHAD SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(123, 'ASEMA SPR MKT- AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(124, 'Aswaq Grocery- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(125, 'ATIQ FOOD STUFF(AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(126, 'AYA SPR MKT(AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(127, 'BAQALA AL SAHER - ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(128, 'BARANA AL MADINAH SM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(129, 'BINTH JUNAIL SPR MKT(AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(130, 'BURJ MALABAR  SUPERMARKET AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(131, 'BUTTER FLY SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(132, 'DANAT AL KHALEEJ- AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(133, 'Dar Ul Haman Grocery - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(134, 'E CITY SUPER MARKET (RUSSIA V22_ - DUBAI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(135, 'FAHIDA SUPER MARKET-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(136, 'Families Super Market - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(137, 'FOUR STAR FOOD STUFF( AJMAN)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(138, 'GOLDEN BUTTERFLY SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(139, 'Happy Land SM (Mateena Deira -Dubai)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(140, 'HAPPY LAND SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(141, 'HARAM AL MADINA SUPERMARKET AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(142, 'Hilal Al Madinah Super Market - SHJ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(143, 'IBAN - Supermarket -RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(144, 'JAWAHAR SUPER MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(145, 'JAZARATH AL MADINA SPR-ALGAIL-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(146, 'KMK SUPER MARKET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(147, 'MADINATH AL SAHAB SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(148, 'MAKKAH SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(149, 'Metro Grocery- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(150, 'MIDAD GROCERY - ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(151, 'Mina Al Arab Super Market', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(152, 'MUHAMMAD IQBAL GROCERY- ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(153, 'NAIL SPR MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(154, 'NAJAM AL DANUBE SM - AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(155, 'NOOR AL AHLAM GROCERY- AL AIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(156, 'Noor Al Madina Spr Mkt-Ajman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(157, 'PANDA SUPER MKT-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(158, 'Parco Hyper Market LLC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(159, 'Royal Al Madinah SM- Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(160, 'SAHAR AL MADINA SPR -AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(161, 'Sahem Al Madina Supermarket Ajman UAE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(162, 'Seah Al Madeena Grocery Rak', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(163, 'Seeh Al Ghail Grocery & Resturent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(164, 'SEVEN ELEVEN SPR MKT-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(165, 'SHABAB AL WADI FOODSTUFF TRADING AJMAN KARAMA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(166, 'Sky Light Grocery  - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(167, 'SNABAL KHAIR BAQALA - ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(168, 'SNOE WHITE GROCCERY- ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(169, 'Souq Al Madinah Super Market - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(170, 'SOUQ AL MADINA SPR MKT-AL GAIL-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(171, 'Spike of Prosperity SM - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(172, 'Sring SM Satwa -Dubai', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(173, 'SUN CITY HYPER MKT-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(174, 'Super Star Grocery - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(175, 'TAIBA SUPER MARKET-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(176, 'TRANS GROCERY - ABU DHABI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(177, 'Vally Corner Grocery - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(178, 'Wafa Al Madinah Sm Dubai', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(179, 'ZAHART BAGHDAD SM-AJMAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(180, 'Zeeba SM - Abu Dhabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(181, 'SUPER BONANZA HYPER MARKET - DUBAI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(182, 'SUPER BONANZA HYPER MARKET - SHARJAH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(183, 'Al Ghail Super Market LLC -RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(184, 'AL MADINAH Hyper Market -Ras Al Khaor -Duabi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(185, 'Church- Ras Al Khaimah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(186, 'GULF EXPRESS SUPER MARKET - RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(187, 'GULF HYPER MARKET-RAK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(188, 'IBAN SUPERMARKET - RAK (Credit Sale)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(189, 'INDIAN SCHOOL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(190, 'KENZ Hyper Market -Ajman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(191, 'KERALA SUPER MARKET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(192, '', '', '', '', NULL, NULL, NULL, NULL, NULL),
(193, '', '', '', '', NULL, NULL, NULL, NULL, NULL),
(194, 'dsfdsf', '', '312312123123', '', NULL, NULL, NULL, NULL, NULL),
(195, 'fjjdd', 'fjfhjf', '877979', 'fjjddjjdj', NULL, NULL, NULL, 6, 'fddfjj'),
(196, 'kbhbuv', 'jbjvvh', '58858', 'hccg', NULL, NULL, NULL, 1, 'yccyc'),
(197, 'bghng', 'fghfg', '34434', 'fghfg', NULL, NULL, NULL, 1, 'fghfgfgh'),
(198, 'uvuv', 'ycyc', '885858', 'hchHg', NULL, NULL, NULL, 8, 'hcgchc'),
(199, 'kjhkhj', 'kjhikjh', '9996456', 'lkjhjikh', NULL, NULL, NULL, 6, '5454'),
(200, 'dfg', 'dfg', '334', 'dfg', NULL, NULL, NULL, 0, 'dfg');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_item_master`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_item_master` (
  `ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ITEM_NAME` varchar(45) DEFAULT NULL,
  `ITEM_CATEGORY_ID` int(11) DEFAULT NULL,
  `ITEM_UNIT_ID` int(11) DEFAULT NULL,
  `ITEM_HEAD_ID` int(11) DEFAULT '0',
  PRIMARY KEY (`ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;

--
-- Dumping data for table `tbl_inv_item_master`
--

INSERT INTO `tbl_inv_item_master` (`ITEM_ID`, `ITEM_NAME`, `ITEM_CATEGORY_ID`, `ITEM_UNIT_ID`, `ITEM_HEAD_ID`) VALUES
(1, 'Maida', 1, 1, 102),
(2, 'Rice powder achappam ', 1, 1, 102),
(3, 'Sugar', 4, 1, 93),
(4, 'white jeera', 4, 1, 93),
(5, 'Black jeera', 4, 1, 93),
(6, 'seasame black', 3, 3, 93),
(7, 'Egg', 4, 5, 93),
(8, 'salt', 4, 1, 93),
(9, 'vegitable oil ', 2, 3, 93),
(10, 'Coconut', 4, 1, 93),
(11, 'Jagggri', 4, 1, 93),
(12, 'Cardamon powder', 4, 1, 93),
(13, 'Rice powder (rice ball)', 1, 1, 102),
(14, 'Peanut', 4, 1, 93),
(15, 'chocobrown colour ', 3, 3, 93),
(16, 'Baking soda', 4, 1, 93),
(17, 'Rawa     ', 1, 1, 93),
(18, 'sugar powder', 4, 1, 93),
(19, 'Yelllow colour', 3, 3, 93),
(20, 'Double spoon gee', 2, 3, 93),
(21, 'Basen', 4, 1, 93),
(22, 'Kissmiss', 4, 1, 93),
(23, 'Atta', 1, 1, 93),
(24, 'Banana', 4, 1, 93),
(25, 'Badam ', 4, 1, 93),
(26, 'Rice powder neyyappam', 4, 1, 102),
(27, 'laddu box ', 5, 4, 328),
(28, 'RICE BALL BOX 1 x 9 black container 185x128x4', 5, 5, 328),
(29, 'pvc cling film 30cmx1500', 5, 4, 93),
(30, 'ZATAR CROISSANT - CROISSANT PLASTIC COVER', 5, 5, 328),
(31, ' Cakes Form tray 216x152x20mm - white 031W13M', 5, 5, 328),
(32, 'ACHAPPAM clear plastry box 180x90x70 05P10H65', 5, 5, 328),
(33, 'KHAJA Form tray 167x129x25mm 031WPTI', 5, 5, 328),
(34, 'RAWA CAKES - Cakes & muffins ', 0, 5, 328),
(35, 'UNNIYAPPAM -  BOX 1 x 9 ', 0, 5, 328),
(36, 'ACHAPPAM - Box 1 * 10', 0, 5, 328),
(37, 'ASS. SLICED CAKES - CAKE -Pastric Clear confe', 0, 5, 328),
(38, 'KHAJA - PVC Box 1 * 10', 0, 5, 328),
(39, 'BISCUITS - Box ( 1 * 6 )', 0, 5, 328),
(40, 'KHAJA - PVC BOX	1 X 6', 0, 5, 328),
(41, 'RICE BALL - PVC BOX 1 X 6', 0, 5, 328),
(42, 'GULAB JAMMU - PVC BOX-1X9', 0, 5, 328),
(43, 'RAWA CAKES - PVC BOX 1 X 6', 0, 5, 328),
(44, 'MILK BREAD - BOX 1 X 10', 0, 5, 328),
(45, 'RICE BALL - BOX 219x90x43', 0, 5, 328),
(46, 'RASAGULA', 6, 5, 331),
(47, 'JILEBI', 6, 5, 331),
(48, 'MYSORE PAAK', 6, 5, 331),
(49, 'PEDA', 6, 5, 331),
(50, 'MILK LADDU', 6, 5, 331),
(51, 'LADDU (gms)', 6, 5, 331),
(52, '100 LBS L.P.G', 4, 5, 93),
(53, 'JILEBI - BOX ( 1 * 6 ) ', 0, 5, 328),
(54, 'RAWA CAKES - PASTRY BOX', 0, 5, 328),
(55, 'Green Jam ', 4, 1, 93),
(56, 'Red Jam ', 4, 5, 93),
(57, 'kozhallappam ', 6, 5, 331),
(58, 'Improver ', 4, 1, 93),
(59, 'Tottyfruitty ', 4, 1, 93),
(60, 'Pink colour', 3, 3, 93),
(61, 'Instant Yeast', 4, 1, 93),
(62, 'RASGULLAS - Rasagulla', 0, 5, 331),
(63, 'RASGULLAS - BOX ( 1 * 10 )', 0, 5, 102),
(64, 'ACHAPPAM - BOX ( 1 * 5 )', 0, 5, 102),
(65, 'NEYYAPPAM - BOX ( 1 * 6 )', 0, 5, 328),
(66, 'UNNIYAPPAM - BOX ( 1 * 8 )', 0, 5, 102),
(67, 'BISCUITS - BOX ( 1 * 10 )', 0, 5, 102),
(68, 'KHAJA - BOX ( 1 * 8 )', 0, 5, 93),
(69, 'MILK BREAD - Small', 0, 5, 328),
(70, 'MILK BREAD - Big', 0, 5, 102),
(71, 'CUP CAKES - BOX ( 1 * 10 )', 0, 5, 328);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_mini_stock`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_mini_stock` (
  `MINI_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_DATE` date DEFAULT NULL,
  `MINI_QTY` double DEFAULT NULL,
  `MINI_LOCATION_ID` int(11) DEFAULT NULL,
  `MINI_STATUS` varchar(1) DEFAULT 'Y',
  `MINI_PACKET_MASTER_ID` int(11) DEFAULT NULL,
  `MINI_MOVE_ID` int(11) DEFAULT '0',
  `MINI_MOVE_TYPE` varchar(1) DEFAULT 'C',
  PRIMARY KEY (`MINI_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `tbl_inv_mini_stock`
--

INSERT 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
(1, '2017-04-03', 100, 1, 'Y', 1, 0, 'C'),
(2, '2017-04-03', 200, 1, 'Y', 2, 0, 'C'),
(3, '2017-04-03', 150, 1, 'Y', 3, 0, 'C'),
(4, '2017-04-03', 225, 1, 'Y', 3, 0, 'C'),
(5, '2017-04-03', 225, 1, 'Y', 5, 0, 'C'),
(6, '2017-04-03', 225, 1, 'Y', 6, 0, 'C'),
(7, '2017-04-20', 55, 1, 'Y', 1, 0, 'C'),
(8, '2017-04-20', 48, 2, 'Y', 1, 0, 'C'),
(9, '2017-04-20', -48, 1, 'Y', 1, 8, 'M'),
(10, '2017-04-22', 23, 2, 'Y', 2, 0, 'C'),
(11, '2017-04-22', -23, 1, 'Y', 2, 10, 'M'),
(12, '2017-04-22', 1654, 1, 'Y', 1, 0, 'C'),
(13, '2017-04-22', 432, 1, 'Y', 2, 0, 'C'),
(14, '2017-04-22', 674, 1, 'Y', 3, 0, 'C'),
(15, '2017-04-22', 654, 1, 'Y', 4, 0, 'C'),
(16, '2017-04-22', 795, 1, 'Y', 6, 0, 'C'),
(17, '2017-04-22', 450, 1, 'Y', 1, 0, 'C'),
(18, '1969-12-31', 250, 2, 'Y', 3, 0, 'C'),
(19, '1969-12-31', -250, 1, 'Y', 3, 18, 'M'),
(20, '2017-05-06', 567, 1, 'Y', 2, 0, 'C'),
(21, '2017-05-06', 10, 2, 'Y', 3, 0, 'C'),
(22, '2017-05-06', -10, 1, 'Y', 3, 21, 'M');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_mini_stock_location`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_mini_stock_location` (
  `MINIL_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINIL_NAME` varchar(45) DEFAULT NULL,
  `MINIL_SALESMAN_ID` int(11) NOT NULL,
  PRIMARY KEY (`MINIL_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_inv_mini_stock_location`
--

INSERT INTO `tbl_inv_mini_stock_location` (`MINIL_ID`, `MINIL_NAME`, `MINIL_SALESMAN_ID`) VALUES
(1, 'van 3', 1),
(2, 'VAN 2', 2),
(3, 'van 3', 2),
(4, 'hvugh7', 2),
(5, 'hvvhvhHh', 2),
(6, 'GcgcfGfxfc', 2),
(7, 'rssggdgggdfgfdf', 18),
(8, 'VAN 2', 8),
(9, 'gsgg', 15),
(10, 'grf', 6),
(11, 'hHhHv', 6),
(12, 'gegdgddh', 18),
(13, 'fg', 15),
(14, 'dsg', 6);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_packed_stock`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_packed_stock` (
  `PACK_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PACK_MASTER_ID` int(11) DEFAULT NULL,
  `PACK_DATE` date DEFAULT NULL,
  `PACK_QTY` double DEFAULT NULL,
  `PACK_TYPE` char(1) NOT NULL DEFAULT 'P',
  PRIMARY KEY (`PACK_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_inv_packed_stock`
--

INSERT INTO `tbl_inv_packed_stock` (`PACK_ID`, `PACK_MASTER_ID`, `PACK_DATE`, `PACK_QTY`, `PACK_TYPE`) VALUES
(1, 1, '2017-02-28', 3, 'P'),
(2, 7, '2017-02-28', 1, 'P'),
(3, 6, '2017-02-28', 2, 'P'),
(4, 1, '2017-02-28', 1, 'P'),
(5, 1, '2017-02-28', 1, 'P'),
(6, 0, '2017-04-03', 10, 'P');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_packet_master`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_packet_master` (
  `PACKET_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PACKET_NAME` varchar(255) NOT NULL,
  `PACKET_PRODUCT_ID` int(11) NOT NULL,
  `PACKET_QTY` int(11) NOT NULL,
  `PACKET_HEAD_ID` bigint(20) NOT NULL,
  `PACKET_ITEM_NO` varchar(50) NOT NULL,
  `PACKET_PRICE` double NOT NULL,
  `PACKET_STATUS` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`PACKET_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `tbl_inv_packet_master`
--

INSERT 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
(1, 'BOX ( 1 * 10 )', 17, 10, 102, '63', 1.5, 'N'),
(2, 'BOX ( 1 * 5 )', 1, 5, 102, '64', 2, 'N'),
(3, 'BOX ( 1 * 6 )', 2, 6, 328, '65', 2, 'N'),
(4, 'BOX ( 1 * 8 )', 3, 8, 102, '66', 3, 'N'),
(5, 'BOX ( 1 * 10 )', 5, 10, 102, '67', 3.5, 'N'),
(6, 'BOX ( 1 * 8 )', 4, 8, 93, '68', 4, 'N'),
(7, 'Small', 15, 15, 328, '69', 4.25, 'N'),
(8, 'Big', 15, 30, 102, '70', 7, 'N'),
(9, 'BOX ( 1 * 10 )', 24, 10, 328, '71', 12, 'N'),
(10, 'free', 31, 0, 0, '', 4500, 'N'),
(11, 'piece', 33, 0, 0, '', 250, 'N'),
(12, 'box', 1, 0, 0, '', 13, 'N'),
(13, 'uug', 34, 0, 0, '', 5, 'N'),
(14, 'dsfdsf', 1, 0, 0, '', 34, 'N'),
(15, 'dfg', 1, 0, 0, '', 23, 'N');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_packet_raw_materials`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_packet_raw_materials` (
  `PRAW_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PRAW_ITEM_ID` int(11) NOT NULL,
  `PRAW_QTY` double NOT NULL,
  `PRAW_PACKING_ID` int(11) NOT NULL,
  PRIMARY KEY (`PRAW_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_product`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_product` (
  `PROD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROD_NAME` varchar(255) NOT NULL,
  `PROD_UNIT_ID` int(11) NOT NULL,
  `PROD_PRICE` double NOT NULL,
  `PROD_HEAD_ID` int(11) DEFAULT NULL,
  `PROD_IMAGE` varchar(500) NOT NULL,
  PRIMARY KEY (`PROD_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `tbl_inv_product`
--

INSERT INTO `tbl_inv_product` (`PROD_ID`, `PROD_NAME`, `PROD_UNIT_ID`, `PROD_PRICE`, `PROD_HEAD_ID`, `PROD_IMAGE`) VALUES
(1, 'ACHAPPAM', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/achappam.jpg'),
(2, 'NEYYAPPAM', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/neyyappam.jpg'),
(3, 'UNNIYAPPAM', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/unniyappam.jpg'),
(4, 'KHAJA', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/khaja.jpg'),
(5, 'BISCUITS', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/biscuits.jpg'),
(6, 'RAWA CAKES', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/rawacake.jpg'),
(7, 'KUZHALAPPAM', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/kuzhalappam.jpg'),
(15, 'MILK BREAD', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/bread.jpg'),
(16, 'GULAB JAMMU', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/gulab.jpg'),
(17, 'RASGULLAS', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/rasagulla.jpg'),
(19, 'JILEBI', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/jilebi.jpg'),
(22, 'MYSORE PAAK', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/mysorepack.jpg'),
(23, 'SWEET SAMOSA', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/samosa.jpg'),
(24, 'CUP CAKES', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/cupcake.jpg'),
(30, 'RICE BALL', 5, 1, 96, 'http://www.voywing.com/demo_erp/uploads/product/riceball.jpg'),
(31, 'Bosch chair', 5, 0, NULL, 'a33ecbcd458de2042a5703febab88580.jpg'),
(32, 'fogg', 5, 0, NULL, 'a74a47e2fbc7ea5923e4629f004b3551.jpg'),
(33, 'fogg marko', 5, 0, NULL, '4d263e4357eaacb6394b40a1f256a2c7.jpg'),
(34, 'fgg', 5, 0, NULL, ''),
(35, 'ass', 1, 0, NULL, '8c70b94ce88e484a24c49c56b97665e2.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_production`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_production` (
  `PRODU_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PRODU_DATE` date DEFAULT NULL,
  `PRODU_PRODUCT_ID` int(11) DEFAULT NULL,
  `PRODU_QTY` double DEFAULT NULL,
  `P_STATUS` varchar(1) DEFAULT 'U',
  PRIMARY KEY (`PRODU_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_inv_production`
--

INSERT INTO `tbl_inv_production` (`PRODU_ID`, `PRODU_DATE`, `PRODU_PRODUCT_ID`, `PRODU_QTY`, `P_STATUS`) VALUES
(1, '2017-04-03', 17, 125, 'D'),
(2, '2017-04-03', 1, 10, 'D'),
(3, '2017-04-03', 3, 450, 'D'),
(4, '2017-04-03', 4, 250, 'D'),
(5, '2017-04-03', 5, 300, 'D'),
(6, '2017-04-03', 15, 2500, 'D');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_production_items`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_production_items` (
  `P_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `P_ITEM_QTY` double DEFAULT NULL,
  `P_ITEM_MASTR_ID` int(11) DEFAULT NULL,
  `P_PRODUCTION_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`P_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `tbl_inv_production_items`
--

INSERT INTO `tbl_inv_production_items` (`P_ITEM_ID`, `P_ITEM_QTY`, `P_ITEM_MASTR_ID`, `P_PRODUCTION_ID`) VALUES
(1, 3, 4, 1),
(2, 2, 6, 1),
(3, 1, 5, 1),
(4, 5, 6, 2),
(5, 45, 6, 3),
(6, 1, 6, 4),
(7, 100, 3, 5),
(8, 200, 1, 5),
(9, 1, 5, 6);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_production_stock`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_production_stock` (
  `STOCK_ID` int(11) NOT NULL AUTO_INCREMENT,
  `STOCK_PRODUCTION_ID` int(11) DEFAULT NULL,
  `STOCK_PRODUCT_ID` int(11) DEFAULT NULL,
  `STOCK_QTY` double DEFAULT NULL,
  PRIMARY KEY (`STOCK_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_inv_production_stock`
--

INSERT INTO `tbl_inv_production_stock` (`STOCK_ID`, `STOCK_PRODUCTION_ID`, `STOCK_PRODUCT_ID`, `STOCK_QTY`) VALUES
(1, 1, 17, 125),
(2, 2, 1, 10),
(3, 3, 3, 450),
(4, 4, 4, 250),
(5, 5, 5, 300),
(6, 6, 15, 2500);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_product_price_master`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_product_price_master` (
  `PRICEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PRICEM_NAME` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`PRICEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_inv_product_price_master`
--

INSERT INTO `tbl_inv_product_price_master` (`PRICEM_ID`, `PRICEM_NAME`) VALUES
(1, 'lulu abu dhabi price list'),
(2, 'normal price list'),
(3, 'PRICE LIST 3');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_product_price_master_items`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_product_price_master_items` (
  `PRICEIT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PRICEIT_PACKET_MASTER_ID` int(11) DEFAULT NULL,
  `PRICEIT_PRICE` double DEFAULT NULL,
  `PRICEIT_MASTER_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`PRICEIT_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `tbl_inv_product_price_master_items`
--

INSERT INTO `tbl_inv_product_price_master_items` (`PRICEIT_ID`, `PRICEIT_PACKET_MASTER_ID`, `PRICEIT_PRICE`, `PRICEIT_MASTER_ID`) VALUES
(10, 1, 4.5, 3),
(11, 2, 3.25, 3),
(12, 3, 3.25, 3),
(13, 6, 3.25, 3),
(24, 1, 4.25, 2),
(25, 2, 3, 2),
(26, 3, 3, 2),
(27, 6, 3, 2),
(28, 4, 3.25, 1),
(29, 1, 4, 1),
(30, 7, 4.5, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_product_pricing`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_product_pricing` (
  `PRICE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PRICE_CUSTOMER_ID` int(11) DEFAULT NULL,
  `PRICE_PRODUCT_ID` int(11) DEFAULT NULL,
  `PRICE_AMOUNT` double DEFAULT NULL,
  PRIMARY KEY (`PRICE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_purchase_invoice`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_purchase_invoice` (
  `INV_ID` int(11) NOT NULL AUTO_INCREMENT,
  `INV_ORDER_NUMBER` int(11) DEFAULT NULL,
  `INV_DATE` date DEFAULT NULL,
  `INV_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `INV_SUPPLIER_ID` int(11) DEFAULT NULL,
  `INV_REMARKS` varchar(300) DEFAULT NULL,
  `INV_INV_NUMBER` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`INV_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `tbl_inv_purchase_invoice`
--

INSERT INTO `tbl_inv_purchase_invoice` (`INV_ID`, `INV_ORDER_NUMBER`, `INV_DATE`, `INV_CREATED`, `INV_SUPPLIER_ID`, `INV_REMARKS`, `INV_INV_NUMBER`) VALUES
(2, 1, '2017-03-01', '2017-03-08 18:18:05', 1, '', '0214'),
(3, 3, '2017-03-01', '2017-03-08 23:12:34', 2, '', '1417820'),
(4, 3, '2017-03-01', '2017-03-19 19:56:29', 2, '', '1415291'),
(5, 4, '2017-03-02', '2017-03-19 20:38:56', 6, 'discouond  0.35', '09435'),
(6, 5, '2017-03-09', '2017-03-20 17:52:30', 6, '', '09436'),
(7, 6, '2017-03-03', '2017-03-20 18:57:48', 15, '', '1282'),
(8, 7, '2017-03-07', '2017-03-20 18:58:30', 15, '', '1293'),
(9, 8, '2017-03-03', '2017-03-20 19:03:51', 15, '', '1284'),
(10, 10, '2017-03-02', '2017-03-20 19:10:11', 15, '', '1281'),
(11, 9, '2017-03-13', '2017-03-20 19:11:02', 15, '', '1307'),
(12, 11, '2017-03-11', '2017-03-21 18:43:38', 18, '', '6026121294'),
(13, 12, '2017-03-07', '2017-03-21 18:44:16', 18, '', '6026120931'),
(14, 18, '2017-03-10', '2017-03-21 19:32:59', 10, '', '54627'),
(15, 17, '2017-03-04', '2017-03-21 19:33:40', 10, '', '54338'),
(16, 16, '2017-03-09', '2017-03-21 19:34:25', 10, '', '54616'),
(17, 15, '2017-03-06', '2017-03-21 19:35:07', 10, '', '54345'),
(18, 14, '2017-03-03', '2017-03-21 19:35:40', 10, '', '54333'),
(19, 13, '2017-03-02', '2017-03-21 19:36:17', 10, '', '54326'),
(20, 22, '2017-03-11', '2017-03-21 20:41:29', 2, '', '1420091'),
(21, 21, '2017-03-12', '2017-03-21 20:42:07', 2, 'TOTAL AMT -3900', '1420600'),
(22, 20, '2017-03-08', '2017-03-21 20:43:01', 2, '', '1418976/1'),
(23, 19, '2017-03-02', '2017-03-21 20:43:54', 2, 'ITEM NO 4 AMOUNT 1500', '1416010'),
(24, 25, '2017-03-13', '2017-03-22 17:18:24', 9, '', '89866'),
(25, 24, '2017-03-05', '2017-03-22 17:18:56', 9, '', '60959'),
(26, 26, '2017-03-01', '2017-03-22 20:29:16', 20, 'total -2785', 'm/0868/17'),
(27, 27, '2017-03-01', '2017-03-23 20:39:43', 23, 'total -215', '18827'),
(28, 28, '2017-03-02', '2017-03-23 20:40:38', 23, '340\n', '18837'),
(29, 29, '2017-03-01', '2017-03-30 16:49:37', 1, 'NOT ACTUAL PURCHASE ....', '222222'),
(30, 30, '2017-03-01', '2017-03-30 20:09:58', 1, 'NOT ACTUAL PURCHASE', '3333333');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_purchase_invoice_item`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_purchase_invoice_item` (
  `INV_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `INV_ITEM_INV_ID` int(11) DEFAULT NULL,
  `INV_ITEM_UNIT_ID` int(11) DEFAULT NULL,
  `INV_ITEM_QTY` double DEFAULT NULL,
  `INV_ITEM_MASTER_ID` int(11) DEFAULT NULL,
  `INV_ITEM_AMOUNT` double DEFAULT NULL,
  PRIMARY KEY (`INV_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;

--
-- Dumping data for table `tbl_inv_purchase_invoice_item`
--

INSERT 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
(1, 2, NULL, 80, 23, 2),
(2, 2, NULL, 10, 19, 3.5),
(3, 3, NULL, 5, 27, 110),
(4, 3, NULL, 1, 29, 83),
(5, 4, NULL, 30, 27, 130),
(6, 5, NULL, 100, 18, 2.8),
(7, 5, NULL, 245, 2, 2.43),
(8, 5, NULL, 320, 23, 2),
(9, 5, NULL, 50, 21, 1.88),
(10, 6, NULL, 280, 2, 2.43),
(11, 6, NULL, 400, 23, 2),
(12, 7, NULL, 60, 46, 2),
(13, 8, NULL, 100, 46, 2),
(14, 8, NULL, 100, 47, 2),
(15, 8, NULL, 100, 48, 2),
(16, 8, NULL, 100, 50, 2),
(17, 8, NULL, 100, 49, 2),
(18, 9, NULL, 150, 51, 2),
(19, 9, NULL, 150, 46, 2),
(20, 9, NULL, 75, 49, 2),
(21, 9, NULL, 50, 50, 2),
(22, 9, NULL, 75, 47, 2),
(23, 9, NULL, 75, 48, 2),
(24, 10, NULL, 150, 46, 2),
(25, 10, NULL, 100, 47, 2),
(26, 10, NULL, 100, 48, 2),
(27, 10, NULL, 75, 49, 2),
(28, 11, NULL, 200, 46, 2),
(29, 11, NULL, 100, 47, 2),
(30, 11, NULL, 100, 48, 2),
(31, 11, NULL, 100, 49, 2),
(32, 11, NULL, 50, 50, 2),
(33, 12, NULL, 900, 9, 3.2222),
(34, 13, NULL, 900, 9, 3.222),
(35, 14, NULL, 4, 52, 250),
(36, 15, NULL, 3, 52, 250),
(37, 16, NULL, 2, 52, 250),
(38, 17, NULL, 2, 52, 250),
(39, 18, NULL, 2, 52, 250),
(40, 19, NULL, 3, 52, 250),
(45, 20, NULL, 3, 29, 90),
(46, 21, NULL, 10200, 32, 0.382),
(47, 22, NULL, 500, 39, 0.54),
(48, 23, NULL, 5000, 31, 0.08),
(49, 23, NULL, 2500, 38, 0.062),
(50, 23, NULL, 2000, 28, 0.42),
(51, 23, NULL, 3500, 54, 0.428),
(54, 24, NULL, 100, 57, 3),
(55, 25, NULL, 100, 57, 3),
(56, 26, NULL, 135, 55, 1.56),
(57, 26, NULL, 135, 56, 1.56),
(58, 26, NULL, 360, 61, 1.833),
(59, 26, NULL, 225, 16, 3),
(60, 26, NULL, 25, 58, 9),
(61, 26, NULL, 96, 59, 2.6),
(62, 26, NULL, 225, 15, 2.33),
(63, 26, NULL, 1, 60, 30),
(64, 27, NULL, 360, 7, 0.35),
(65, 27, NULL, 24, 24, 3.75),
(66, 28, NULL, 24, 24, 3.75),
(67, 28, NULL, 720, 7, 0.348),
(68, 29, NULL, 1000, 1, 1.6),
(69, 29, NULL, 30, 4, 13),
(70, 29, NULL, 500, 3, 2.6),
(71, 29, NULL, 50, 5, 16),
(72, 29, NULL, 15, 8, 0.5),
(73, 29, NULL, 500, 11, 3.4),
(74, 29, NULL, 35, 12, 2),
(75, 29, NULL, 1000, 13, 2.25),
(76, 29, NULL, 50, 14, 6.75),
(77, 29, NULL, 500, 17, 2.75),
(78, 29, NULL, 100, 22, 4),
(79, 29, NULL, 100, 25, 39),
(80, 29, NULL, 100, 26, 2.4),
(81, 29, NULL, 200, 6, 19.5),
(82, 29, NULL, 100, 20, 3.7),
(83, 30, NULL, 500, 10, 8.8);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_purchase_order`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_purchase_order` (
  `ORDER_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ORDER_DATE` date DEFAULT NULL,
  `ORDER_SUPPLIER_ID` int(11) DEFAULT NULL,
  `ORDER_REMARKS` varchar(45) DEFAULT NULL,
  `ORDER_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ORDER_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Dumping data for table `tbl_inv_purchase_order`
--

INSERT INTO `tbl_inv_purchase_order` (`ORDER_ID`, `ORDER_DATE`, `ORDER_SUPPLIER_ID`, `ORDER_REMARKS`, `ORDER_CREATED`) VALUES
(3, '2017-03-01', 2, '', '2017-03-08 23:11:02'),
(4, '2017-03-01', 6, '', '2017-03-19 20:07:08'),
(5, '2017-03-08', 6, '', '2017-03-19 20:29:28'),
(6, '2017-03-06', 15, '', '2017-03-20 18:41:56'),
(7, '2017-03-06', 15, '', '2017-03-20 18:55:16'),
(8, '2017-03-03', 15, '', '2017-03-20 19:00:23'),
(9, '2017-03-12', 15, '', '2017-03-20 19:04:13'),
(10, '2017-03-01', 15, '', '2017-03-20 19:07:35'),
(11, '2017-03-10', 18, '', '2017-03-21 18:38:30'),
(12, '2017-03-06', 18, '', '2017-03-21 18:41:13'),
(13, '2017-03-01', 10, '', '2017-03-21 18:58:17'),
(14, '2017-03-02', 10, '', '2017-03-21 18:58:58'),
(15, '2017-03-05', 10, '', '2017-03-21 18:59:33'),
(16, '2017-03-09', 10, '', '2017-03-21 19:00:27'),
(17, '2017-03-04', 10, '', '2017-03-21 19:01:19'),
(18, '2017-03-09', 10, '', '2017-03-21 19:01:54'),
(19, '2017-03-01', 2, 'ITEM NO 4 AMOUNT 1500', '2017-03-21 20:28:59'),
(20, '2017-03-01', 2, '', '2017-03-21 20:34:48'),
(21, '2017-03-01', 2, 'TOTAL AMT -3900', '2017-03-21 20:37:31'),
(22, '2017-03-01', 2, '', '2017-03-21 20:39:46'),
(24, '2017-03-13', 9, '', '2017-03-22 17:09:39'),
(25, '2017-03-14', 9, '', '2017-03-22 17:11:03'),
(26, '2017-03-01', 20, 'total -2785', '2017-03-22 20:00:08'),
(27, '2017-03-01', 23, 'total -215', '2017-03-23 20:28:49'),
(28, '2017-03-01', 23, '340\n', '2017-03-23 20:35:06'),
(29, '2017-03-01', 1, 'NOT ACTUAL PURCHASE ....', '2017-03-30 16:31:05'),
(30, '2017-03-01', 1, 'NOT ACTUAL PURCHASE', '2017-03-30 20:08:32'),
(31, NULL, NULL, NULL, '2017-03-30 21:06:48');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_purchase_order_item`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_purchase_order_item` (
  `ITEM_O_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ITEM_O_ORDER_ID` int(11) NOT NULL,
  `ITEM_O_QTY` double NOT NULL,
  `ITEM_O_MASTER_ID` int(11) DEFAULT NULL,
  `ITEM_O_UNIT_PRICE` double DEFAULT NULL,
  `ITEM_O_STATUS` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`ITEM_O_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;

--
-- Dumping data for table `tbl_inv_purchase_order_item`
--

INSERT 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
(1, 1, 80, 23, 2, 'N'),
(2, 1, 10, 19, 3.5, 'N'),
(3, 2, 5, 24, 2, 'N'),
(4, 3, 5, 27, 110, 'D'),
(5, 3, 1, 29, 83, 'N'),
(6, 4, 100, 18, 2.8, 'D'),
(7, 4, 245, 2, 2.43, 'D'),
(8, 4, 320, 23, 2, 'D'),
(9, 4, 50, 21, 1.88, 'D'),
(10, 5, 280, 2, 2.43, 'D'),
(11, 5, 400, 23, 2, 'D'),
(12, 6, 100, 46, 2, 'D'),
(13, 7, 100, 46, 2, 'D'),
(14, 7, 100, 47, 2, 'D'),
(15, 7, 100, 48, 2, 'D'),
(16, 7, 100, 50, 2, 'D'),
(17, 7, 100, 49, 2, 'D'),
(18, 8, 150, 51, 2, 'D'),
(19, 8, 150, 46, 2, 'D'),
(20, 8, 75, 49, 2, 'D'),
(21, 8, 50, 50, 2, 'D'),
(22, 8, 75, 47, 2, 'D'),
(23, 8, 75, 48, 2, 'D'),
(24, 9, 200, 46, 2, 'D'),
(25, 9, 100, 47, 2, 'D'),
(26, 9, 100, 48, 2, 'D'),
(27, 9, 100, 49, 2, 'D'),
(28, 9, 50, 50, 2, 'D'),
(29, 10, 150, 46, 2, 'D'),
(30, 10, 100, 47, 2, 'D'),
(31, 10, 100, 48, 2, 'D'),
(32, 10, 75, 49, 2, 'D'),
(33, 11, 900, 9, 3.222222, 'D'),
(34, 12, 900, 9, 3.2222, 'D'),
(35, 13, 3, 52, 250, 'D'),
(36, 14, 2, 52, 250, 'D'),
(37, 15, 2, 52, 250, 'D'),
(38, 16, 2, 52, 250, 'D'),
(39, 17, 3, 52, 250, 'D'),
(40, 18, 4, 52, 250, 'D'),
(41, 19, 5000, 31, 0.08, 'D'),
(42, 19, 2500, 38, 0.062, 'D'),
(43, 19, 2000, 28, 0.42, 'D'),
(44, 19, 3500, 54, 0.428, 'D'),
(45, 20, 500, 39, 0.54, 'D'),
(46, 21, 10200, 32, 0.382, 'D'),
(47, 22, 3, 29, 90, 'D'),
(48, 23, 100, 57, 3, 'N'),
(49, 24, 100, 57, 3, 'D'),
(50, 25, 100, 57, 3, 'D'),
(51, 26, 135, 55, 1.56, 'D'),
(52, 26, 135, 56, 1.56, 'D'),
(53, 26, 360, 61, 1.833, 'D'),
(54, 26, 225, 16, 3, 'D'),
(55, 26, 25, 58, 9, 'D'),
(56, 26, 96, 59, 2.6, 'D'),
(57, 26, 225, 15, 2.33, 'D'),
(58, 26, 1, 60, 30, 'D'),
(59, 27, 360, 7, 0.35, 'D'),
(60, 27, 24, 24, 3.75, 'D'),
(61, 28, 24, 24, 3.75, 'D'),
(62, 28, 720, 7, 0.348, 'D'),
(63, 29, 1000, 1, 1.6, 'D'),
(64, 29, 30, 4, 13, 'D'),
(65, 29, 500, 3, 2.6, 'D'),
(66, 29, 50, 5, 16, 'D'),
(67, 29, 15, 8, 0.5, 'D'),
(68, 29, 500, 11, 3.4, 'D'),
(69, 29, 35, 12, 2, 'D'),
(70, 29, 1000, 13, 2.25, 'D'),
(71, 29, 50, 14, 6.75, 'D'),
(72, 29, 500, 17, 2.75, 'D'),
(73, 29, 100, 22, 4, 'D'),
(74, 29, 100, 25, 39, 'D'),
(75, 29, 100, 26, 2.4, 'D'),
(76, 29, 200, 6, 19.5, 'D'),
(77, 29, 100, 20, 3.7, 'D'),
(78, 30, 500, 10, 8.8, 'D');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_route`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_route` (
  `ROUTE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ROUTE_NAME` varchar(255) NOT NULL,
  `ROUTE_LOCATION` varchar(400) NOT NULL,
  `ROUTE_REMARKS` varchar(400) NOT NULL,
  PRIMARY KEY (`ROUTE_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_inv_route`
--

INSERT INTO `tbl_inv_route` (`ROUTE_ID`, `ROUTE_NAME`, `ROUTE_LOCATION`, `ROUTE_REMARKS`) VALUES
(1, 'Ras al Khaima- Rafi', 'Ras al Khaima', 'dfgdf'),
(2, 'Sharjha', 'sharjah', 'hfhrhhf'),
(3, 'Dubai - Abdul Rasheed', 'Dubai ', ''),
(4, 'Abu Dhabi - Rizwan', 'Abu Dhabi', ''),
(5, 'Abu Dhabi - Azhar', 'Abu Dhabi', ''),
(6, 'Ras al Khaima- Jacob', 'Ras al Khaima', ''),
(7, 'Dubai - Shareef', 'Dubai ', ''),
(8, 'Ajman', 'Ajman', ''),
(9, 'ikfjfk', 'jfjjfjd', 'cjfjf'),
(10, 'gxgcgc', 'ycgc', 'hchchc');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_salesman`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_salesman` (
  `MAN_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MAN_NAME` varchar(255) NOT NULL,
  `MAN_ADDRESS` varchar(255) NOT NULL,
  `MAN_PHONE` varchar(15) NOT NULL,
  `MAN_MOBILE` varchar(15) NOT NULL,
  `MAN_EMAIL` varchar(255) NOT NULL,
  `MAN_ROUTE_ID` int(11) NOT NULL,
  `MAN_ADDED_ON` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MAN_PREFIX` varchar(3) DEFAULT NULL,
  `MAN_IMAGE` varchar(400) DEFAULT 'user.png',
  `MAN_DESIGNATION` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`MAN_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

--
-- Dumping data for table `tbl_inv_salesman`
--

INSERT 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
(1, 'Mubashir ahmed', '', '', '0551090667', 'mubashir@gmail.com', 0, '2017-02-28 21:25:26', NULL, '5eeffc04af06978348f6ebea21559e3e.jpg', 'MARKETING EXECUTIVE'),
(2, 'Rafi', ' ', '', '0529460893', 'Rafi@gmail.com', 8, '2017-02-28 21:26:01', NULL, 'f95dc03d5d0997c470674ea49ac7eaa8.jpg', 'MARKETING EXECUTIVE'),
(3, 'Shareef', '', '', '0527421029', 'Shareef@gmail.com', 7, '2017-02-28 21:29:50', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(4, 'Rizwan', '      ', '', '0528203415', 'Rizwan@gmail.com', 4, '2017-03-06 22:22:36', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(5, 'Jacob', '', '', '0527419736', 'jacob@gmail.com', 6, '2017-03-19 18:29:08', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(6, 'Azhar', '', '', '0561479750', 'azhar@gmail.com', 5, '2017-03-19 18:32:54', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(7, 'Shahzad', '', '', '0556507417', 'SHAHAZAD@qmial.com', 2, '2017-03-19 18:34:45', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(8, 'Abdul Rasheed', '', '', '0551090517', 'abdulrasheed@gmail.com', 3, '2017-03-19 18:35:47', NULL, '2f119c17f3c4477d54ad82fc21f6e86d.jpg', 'MARKETING EXECUTIVE'),
(35, 'cjsjjd', '', '', 'fudififjf', 'fjdjjdjd', 5, '2017-04-27 04:54:46', NULL, NULL, 'fjfjjfjjfj'),
(36, 'gfribib', '', '', 'yfyf', '7g6g', 5, '2017-04-27 04:57:17', NULL, '0', 'biihuhu'),
(37, 'y33y43y', '', '', 'dhrrgrh', 'jdfhd', 6, '2017-04-27 05:02:02', NULL, 'user.png', 'tu4u4y3y3y'),
(38, 'fjdjcj', '', '', 'rjrjrjrj', 'gjfjjfjj', 6, '2017-04-27 07:26:58', NULL, 'user.png', 'vjfjffj'),
(39, 'dkddj', '', '', 'tjrjd', 'gfjdk', 4, '2017-04-27 07:28:04', NULL, 'user.png', 'fjjdjdjf'),
(40, 'chdjd', '', '', 'cjfj', 'fjfjdj', 5, '2017-04-27 07:28:27', NULL, 'user.png', 'rhrhfj'),
(41, 'fjfjj', '', '', 'fjfjfj', 'jfufii', 5, '2017-04-27 07:32:26', NULL, 'aaa26da1db2b04dc6898068268e3520c.jpg', 'djdjjj'),
(42, 'fjfhf', '', '', 'fjjfjf', 'fjfh', 6, '2017-04-27 07:35:10', NULL, '504c867db290b56b59799424a651006f.jpg', 'jjrjf'),
(43, 'fjfjjf', '', '', 'fjfjfj', 'fjfjfj', 6, '2017-04-27 07:35:22', NULL, '2619f72cd26af044fc9b76c8413d73b9.jpg', 'fnjfj'),
(44, 'grff', '', '', 'gfdf', 'hffgh', 4, '2017-04-27 07:37:52', NULL, '2953d24cd23cc4f27985352ee617c84f.jpg', 'fddg'),
(45, 'yrgg', '', '', 'trrr', 'hrgg', 6, '2017-04-27 07:38:07', NULL, 'user.png', 'trrggg'),
(46, 'tet', '', '', 'frfgggg', 'grt', 6, '2017-04-27 07:38:31', NULL, 'user.png', 'grhhhhhhy'),
(47, 'yrr', '', '', 'yttt', 'hggg', 7, '2017-04-27 07:39:00', NULL, '5a2bfbaa462198fddd88bd0039bbf401.jpg', 'trff'),
(48, 'h hcg', '', '', 'yfyc', 'hvvh', 10, '2017-04-27 09:26:55', NULL, '459dbd3346b98e1ab490a3360c3b73c1.jpg', 'bgGvvy'),
(49, 'h hc', '', '', 'ycyc', 'hchc', 9, '2017-04-27 09:27:08', NULL, 'user.png', 'yfyfyf'),
(50, 'hcgcgcgc', '', '', 'bvhvvh', 'bchchv', 2, '2017-04-28 05:10:51', NULL, 'user.png', 'h gcch'),
(53, 'vuvuUu', '', '', 'uvhuU', 'uvuvub', 5, '2017-04-28 05:54:27', NULL, 'user.png', 'uvuub'),
(55, 'fjdj', '', '', 'fhdhj', 'cjdjjdj', 8, '2017-04-28 05:55:02', NULL, 'user.png', 'xxhhx'),
(58, 'fhdhdh', '', '', 'rhrhf', 'rhfhfh', 7, '2017-04-28 05:58:18', NULL, 'user.png', 'jhddj'),
(59, 'aqeeel', '', '', 'fjfjf', 'cjcjf', 6, '2017-04-28 05:58:29', NULL, 'user.png', 'dhddh'),
(62, 'cjdjxj', '', '', 'dhdhhd', 'fhdhdh', 7, '2017-04-28 06:02:36', NULL, 'user.png', 'fhfjfjf'),
(64, 'cbfbfbfb', '', '', 'xvdvdb', 'dbddb', 7, '2017-04-28 06:04:14', NULL, 'ad7e5dc05f1753e5a8d7174288cd2385.jpg', 'svddv'),
(65, 'saleeq', '', '', 'sall', 'saleeqvm', 0, '2017-04-28 06:05:53', NULL, '828a1255b0e144cee2d2cff1d2d39689.jpg', 'djdjdj'),
(66, 'hchccg', '', '', 'hchyg', 'abc', 9, '2017-04-28 06:35:49', NULL, 'fa92fd3630ccc686faf1da21fbe68f0c.jpg', '7ggyg'),
(67, 'fdjdj', '', '', 'fjffj', 'fjfjjf', 0, '2017-05-03 05:48:20', NULL, 'user.png', 'fjfj'),
(68, 'fghfg', '', '', 'fghfgh', 'fghfgh', 0, '2017-05-06 09:07:35', NULL, 'user.png', 'fghfgh');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_invoice`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_invoice` (
  `SALES_INVOICE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SALES_DATE` date DEFAULT NULL,
  `SALES_CUSTOMER_ID` int(11) DEFAULT NULL,
  `SALES_MAN_ID` int(11) DEFAULT NULL,
  `SALES_CREATED_ON` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `SALES_INVOICE_NUM` varchar(45) DEFAULT NULL,
  `SALES_INVOICE_DATE` date DEFAULT NULL,
  `SALES_ORDER_NUM` int(11) NOT NULL,
  `SALES_TOTAL_AMOUNT` double DEFAULT '0',
  `SALES_DISCOUNT` double DEFAULT '0',
  `SALES_MINI_STORE_LOCATION_ID` int(11) DEFAULT '0',
  `SALES_TYPE` char(1) NOT NULL DEFAULT 'S',
  PRIMARY KEY (`SALES_INVOICE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_invoice_item`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_invoice_item` (
  `SALES_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SALES_PRODUCT_ID` int(11) DEFAULT NULL,
  `SALES_QTY` double DEFAULT NULL,
  `SALES_INVOICE_ID` int(11) DEFAULT NULL,
  `SALES_AMOUNT` double DEFAULT NULL,
  PRIMARY KEY (`SALES_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_order`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_order` (
  `SALES_ORDER_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SALES_DATE` date DEFAULT NULL,
  `SALES_CUSTOMER_ID` int(11) DEFAULT NULL,
  `SALES_MAN_ID` int(11) DEFAULT NULL,
  `SALES_ROUTE_ID` int(11) DEFAULT NULL,
  `SALES_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`SALES_ORDER_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_inv_sales_order`
--

INSERT INTO `tbl_inv_sales_order` (`SALES_ORDER_ID`, `SALES_DATE`, `SALES_CUSTOMER_ID`, `SALES_MAN_ID`, `SALES_ROUTE_ID`, `SALES_CREATED`) VALUES
(1, NULL, NULL, NULL, NULL, '2017-04-01 19:52:40');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_order_items`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_order_items` (
  `SL_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SL_PACK_ID` int(11) NOT NULL,
  `SL_QTY` double NOT NULL,
  `SL_ORDER_ID` int(11) NOT NULL,
  `SL_ORDER_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`SL_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_inv_sales_order_items`
--

INSERT INTO `tbl_inv_sales_order_items` (`SL_ITEM_ID`, `SL_PACK_ID`, `SL_QTY`, `SL_ORDER_ID`, `SL_ORDER_STATUS`) VALUES
(1, 1, 8, 1, 'N');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_return`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_return` (
  `RETURN_ID` int(11) NOT NULL AUTO_INCREMENT,
  `RETURN_CUST_ID` int(11) DEFAULT NULL,
  `RETURN_DATE` date DEFAULT NULL,
  `RETURN_REMARKS` varchar(200) DEFAULT NULL,
  `RETURN_SALES_MAN_ID` int(11) DEFAULT NULL,
  `RETURN_CREATED` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`RETURN_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_sales_return_items`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_sales_return_items` (
  `RETITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `RETITEM_PRODUCT_ID` int(11) DEFAULT NULL,
  `RETITEM_QTY` double DEFAULT NULL,
  `RETITEM_AMOUNT` double DEFAULT NULL,
  `RETURN_F_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`RETITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_supplier`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_supplier` (
  `SUPP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SUPP_NAME` varchar(45) DEFAULT NULL,
  `SUPP_ADDRESS` varchar(45) DEFAULT NULL,
  `SUPP_PHONE` varchar(45) DEFAULT NULL,
  `SUPP_EMAIL` varchar(45) DEFAULT NULL,
  `SUPP_LOCATION` varchar(45) DEFAULT NULL,
  `SUPP_COUNTRY_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`SUPP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `tbl_inv_supplier`
--

INSERT INTO `tbl_inv_supplier` (`SUPP_ID`, `SUPP_NAME`, `SUPP_ADDRESS`, `SUPP_PHONE`, `SUPP_EMAIL`, `SUPP_LOCATION`, `SUPP_COUNTRY_ID`) VALUES
(1, 'BIN ZAID FLOUR MILLS', 'bridge road', '072334771', 'ggggg@gmil.in', 'rak', 2),
(2, 'AL BAYADER INTERNATIONAL ', 'sharj\r\n', '065340303', 'sharjah@gmsl.in', 'sharjh', 2),
(3, 'AL BERWAZ PLASTIC FACTORY', NULL, NULL, NULL, NULL, 2),
(4, 'AL HASNAA FOODSTUFF TRD.', NULL, NULL, NULL, NULL, 2),
(5, 'AL HILAL CLEANING MATERIALS TRADING', NULL, NULL, NULL, NULL, 2),
(6, 'AL LEWAA FLOUR MILL & FOOD STUFF TRD.', NULL, NULL, NULL, NULL, 2),
(7, 'AL MAILEE DISTRIBUTION', NULL, NULL, NULL, NULL, 2),
(8, 'AL MAWAKEB NUTS L.L.C', NULL, NULL, NULL, NULL, 2),
(9, 'BEST BAKERY LLC', NULL, NULL, NULL, NULL, 2),
(10, 'BROTHERS GAS', NULL, NULL, NULL, NULL, 2),
(11, 'CITY PAK', NULL, NULL, NULL, NULL, 2),
(12, 'FALCON PACK', NULL, NULL, NULL, NULL, 2),
(13, 'FREETRADE INTERNATIONAL FZE', NULL, NULL, NULL, NULL, 2),
(14, 'GHULAMI GENERAL TRADING LLC DUBAI', NULL, NULL, NULL, NULL, 2),
(15, 'GREAT EMIRATES FOOD STUFF CATERING L.L.C', NULL, NULL, NULL, NULL, 2),
(16, 'GRIPPO GROUP- RAK', NULL, NULL, NULL, NULL, 2),
(17, 'HAROON LABELS INDUSTRIES L. L.C', NULL, NULL, NULL, NULL, 2),
(18, 'IFFCO DISTRIBUTION SERVICE-DUBAI', NULL, NULL, NULL, NULL, 2),
(19, 'MODERN GEN.TRD CO.', NULL, NULL, NULL, NULL, 2),
(20, 'MUDRA GEN. TRD.', NULL, NULL, NULL, NULL, 2),
(21, 'RAG FOOD STUFF TRD.L.L.C', NULL, NULL, NULL, NULL, 2),
(22, 'SAFCO (SANWHEY FOOD STUFF TRD)', NULL, NULL, NULL, NULL, 2),
(23, 'Al khair vegitable & fruits trading', 'al juwais rak', '0552377356', '', 'al juwais rak', 2);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_inv_units`
--

CREATE TABLE IF NOT EXISTS `tbl_inv_units` (
  `UNIT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `UNIT_NAME` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`UNIT_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_inv_units`
--

INSERT INTO `tbl_inv_units` (`UNIT_ID`, `UNIT_NAME`) VALUES
(1, 'KG'),
(2, 'MG'),
(3, 'LTRE'),
(4, 'PACKETS'),
(5, 'Nos');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE IF NOT EXISTS `tbl_menu` (
  `MENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MENU_PATH` varchar(400) DEFAULT NULL,
  `MENU_CONTROLLER_NAME` varchar(45) DEFAULT NULL,
  `MENU_ICON` varchar(45) DEFAULT NULL,
  `MENU_CHILD_OF` int(11) DEFAULT NULL,
  `MENU_ORDER_NUMBER` int(11) DEFAULT NULL,
  `MENU_ELEMENT_ID` varchar(45) DEFAULT NULL,
  `MENU_TYPE` varchar(1) DEFAULT 'C',
  `MENU_TEXT` varchar(45) DEFAULT NULL,
  `MENU_CSS_CLASSS` varchar(45) DEFAULT NULL,
  `MENU_HAS_ADD` int(11) NOT NULL,
  `MENU_HAS_EDIT` int(11) NOT NULL,
  `MENU_HAS_DELETE` int(11) NOT NULL,
  PRIMARY KEY (`MENU_ID`),
  KEY `MENU_PATH` (`MENU_PATH`),
  KEY `MENU_CONTROLLER_NAME` (`MENU_CONTROLLER_NAME`),
  KEY `MENU_CHILD_OF` (`MENU_CHILD_OF`),
  KEY `MENU_ORDER_NUMBER` (`MENU_ORDER_NUMBER`),
  KEY `MENU_HAS_ADD` (`MENU_HAS_ADD`),
  KEY `MENU_HAS_EDIT` (`MENU_HAS_EDIT`),
  KEY `MENU_HAS_DELETE` (`MENU_HAS_DELETE`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

--
-- Dumping data for table `tbl_menu`
--

INSERT 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
(1, NULL, NULL, NULL, 0, NULL, NULL, 'C', 'Accounts ', 'waves-effect', 1, 1, 1),
(2, NULL, NULL, NULL, 1, NULL, NULL, 'C', 'Master Files', NULL, 0, 0, 0),
(3, NULL, NULL, NULL, 1, NULL, NULL, 'C', 'Transactions', NULL, 0, 0, 0),
(4, NULL, NULL, NULL, 1, NULL, NULL, 'C', 'Reports', NULL, 0, 0, 0),
(5, NULL, NULL, NULL, 2, NULL, 'CREATE-ACC-HEAD', 'F', 'Account Head', NULL, 1, 0, 0),
(6, NULL, NULL, NULL, 0, NULL, NULL, 'C', 'Inventory', NULL, 0, 0, 0),
(7, NULL, NULL, NULL, 0, NULL, NULL, 'C', 'Production', NULL, 0, 0, 0),
(8, NULL, NULL, NULL, 0, NULL, NULL, 'C', 'Sales', NULL, 0, 0, 0),
(9, NULL, NULL, NULL, 0, NULL, NULL, 'C', 'Users', NULL, 0, 0, 0),
(10, NULL, NULL, NULL, 6, NULL, NULL, 'C', 'Master Files', NULL, 0, 0, 0),
(11, NULL, NULL, NULL, 6, NULL, NULL, 'C', 'Purchase', NULL, 0, 0, 0),
(12, NULL, NULL, NULL, 6, NULL, NULL, 'C', 'Reports', NULL, 0, 0, 0),
(13, NULL, NULL, NULL, 10, NULL, 'CAT-MASTER', 'F', 'Category', NULL, 1, 1, 1),
(14, NULL, NULL, NULL, 3, NULL, 'ACC-PAYMENTS', 'F', 'Payments', NULL, 1, 1, 0),
(15, NULL, NULL, NULL, 3, NULL, 'ACC-RECIEPTS', 'F', 'Receipts', NULL, 1, 1, 0),
(16, NULL, NULL, NULL, 3, NULL, 'ACC-JOUNRNAL', 'F', 'Journals', NULL, 1, 1, 0),
(17, NULL, NULL, NULL, 3, NULL, 'ACC-DEBIT-NOTE', 'F', 'Debit Note', NULL, 1, 1, 0),
(18, NULL, NULL, NULL, 3, NULL, 'ACC-CREDIT-NOTE', 'F', 'Credit Note', NULL, 1, 1, 0),
(19, NULL, NULL, NULL, 3, NULL, 'ACC-TRANSACTION-LIST', 'F', 'Transaction List', NULL, 0, 0, 0),
(20, NULL, NULL, NULL, 3, NULL, 'ACC-POST-ALL', 'F', 'Post Accounts', NULL, 0, 0, 0),
(21, NULL, NULL, NULL, 4, NULL, 'ACC-GENERAL-LEDGER', 'F', 'General Ledger', NULL, 0, 0, 0),
(22, NULL, NULL, NULL, 4, NULL, 'ACC-TRIAL-BALANCE', 'F', 'Trail Balance', NULL, 0, 0, 0),
(23, NULL, NULL, NULL, 4, NULL, 'ACC-GENERAL-BALANCE', 'F', 'View Account Balance', NULL, 0, 0, 0),
(24, NULL, NULL, NULL, 4, NULL, 'ACC-JOURNAL-REGISTER', 'F', 'Journal Register', NULL, 0, 0, 0),
(25, NULL, NULL, NULL, 4, NULL, 'ACC-CREDIT-REGISTER', 'F', 'Credit Note Register', NULL, 0, 0, 0),
(26, NULL, NULL, NULL, 4, NULL, 'ACC-DEBIT-REGISTER', 'F', 'Debit Note Register', NULL, 0, 0, 0),
(27, NULL, NULL, NULL, 10, NULL, 'ITEM-MASTER', 'F', 'Item', NULL, 1, 1, 0),
(28, NULL, NULL, NULL, 10, NULL, 'SUPP-MASTER', 'F', 'Supplier', NULL, 1, 1, 0),
(29, NULL, NULL, NULL, 10, NULL, 'CUST-MASTER', 'F', 'Customer', NULL, 1, 1, 0),
(30, NULL, NULL, NULL, 10, NULL, 'ROUTE-MSTER', 'F', 'Route', NULL, 1, 1, 0),
(31, NULL, NULL, NULL, 10, NULL, 'SLSMAN-MASTER', 'F', 'Salesman', NULL, 1, 1, 0),
(32, NULL, NULL, NULL, 11, NULL, 'INV-PURCHASE-ENTRY', 'F', 'Purchase Order', NULL, 1, 1, 1),
(33, NULL, NULL, NULL, 11, NULL, 'INV-PURCHSAE-INVOICE', 'F', 'Purchase Invoice', NULL, 1, 1, 0),
(34, NULL, NULL, NULL, 12, NULL, 'INV-PURCHASE-ORDER-VIEW', 'F', 'Purchase Order List', NULL, 0, 0, 0),
(35, NULL, NULL, NULL, 12, NULL, 'INV-PURCHSAE-INVOICE-VIEW', 'F', 'Purchase Invoice List', NULL, 0, 0, 0),
(36, NULL, NULL, NULL, 12, NULL, 'STOCK-LIST', 'F', 'Stock List', NULL, 0, 0, 0),
(37, NULL, NULL, NULL, 12, NULL, 'STOCK-LEDGER', 'F', 'Stock Ledger', NULL, 0, 0, 0),
(38, NULL, NULL, NULL, 8, NULL, 'INV-SALES-ORDER-LISTING', 'F', 'Sales Orders List', NULL, 0, 0, 0),
(39, NULL, NULL, NULL, 8, NULL, 'INV-SALES-ORDER', 'F', 'Sales Order', NULL, 1, 1, 1),
(40, NULL, NULL, NULL, 8, NULL, 'INV-SALES-INVOICE', 'F', 'Sales Invoice', NULL, 1, 1, 1),
(41, NULL, NULL, NULL, 8, NULL, 'ADD-SALES-INVOICE', 'F', 'Fresh Sales Invoice', NULL, 1, 1, 1),
(42, NULL, NULL, NULL, 8, NULL, 'INV-SALES-RETURN', 'F', 'Sales Return', NULL, 1, 1, 1),
(43, NULL, NULL, NULL, 8, NULL, '', 'C', 'Reports', NULL, 0, 0, 0),
(44, NULL, NULL, NULL, 43, NULL, 'INV-SALES-VIEW-ORDER', 'F', 'Sales Order Report', NULL, 0, 0, 0),
(45, NULL, NULL, NULL, 43, NULL, 'VIEW-SALES-INVOICE', 'F', 'Sales Invoice Report', NULL, 0, 0, 0),
(46, NULL, NULL, NULL, 43, NULL, 'REP-SALES-RETURN', 'F', 'Sales Return Report', NULL, 0, 0, 0),
(47, NULL, NULL, NULL, 9, NULL, 'ACCESS-CONTROL', 'F', 'Access Control', NULL, 0, 0, 0),
(48, NULL, NULL, NULL, 7, NULL, '', 'C', 'Master Files', NULL, 0, 0, 0),
(49, NULL, NULL, NULL, 7, NULL, '', 'C', 'Operations', NULL, 0, 0, 0),
(50, NULL, NULL, NULL, 7, NULL, '', 'C', 'Reports', NULL, 0, 0, 0),
(51, NULL, NULL, NULL, 48, NULL, 'PROD-MASTER', 'F', 'Product', NULL, 1, 1, 0),
(52, NULL, NULL, NULL, 48, NULL, 'COST-MASTER', 'F', 'Product Cost', NULL, 1, 1, 0),
(53, NULL, NULL, NULL, 48, NULL, 'STOCK-LOCATION', 'F', 'Stock Location', NULL, 1, 1, 0),
(54, NULL, NULL, NULL, 48, NULL, 'PACKING-MASTER', 'F', 'Packing', NULL, 1, 1, 1),
(55, NULL, NULL, NULL, 48, NULL, 'PRICELIST-MASTER', 'F', 'Price List', NULL, 1, 1, 1),
(56, NULL, NULL, NULL, 49, NULL, 'INV-CREATE-PODUCTION', 'F', 'Start New Production', NULL, 1, 1, 1),
(57, NULL, NULL, NULL, 49, NULL, 'INV-PRODUCTION-STOCK', 'F', 'Production List', NULL, 0, 0, 0),
(58, NULL, NULL, NULL, 49, NULL, 'CREATE-PRODUCT-PACK', 'F', 'Create Product Pack', NULL, 1, 1, 1),
(59, NULL, NULL, NULL, 49, NULL, 'MINI-STOCK', 'F', 'Move Stock to Mini Store', NULL, 1, 1, 1),
(60, NULL, NULL, NULL, 49, NULL, 'MINI-TO-STOCK', 'F', 'Move Mini Store to Stock', NULL, 1, 1, 1),
(61, NULL, NULL, NULL, 50, NULL, 'REP-PRODUCTION', 'F', 'Production Report', NULL, 0, 0, 0),
(62, NULL, NULL, NULL, 50, NULL, 'FINISHED-STOCK', 'F', 'Product Stock List', NULL, 0, 0, 0),
(63, NULL, NULL, NULL, 50, NULL, 'LOCATION-WISE-STOCK', 'F', 'Location Wise Stock List', NULL, 0, 0, 0),
(64, NULL, NULL, NULL, 3, NULL, 'PAYMENT-SUPPLIER', 'F', 'Payment to Supplier', NULL, 1, 1, 1),
(65, NULL, NULL, NULL, 3, 0, 'RECEIPT-CUSTOMER', 'F', 'Receipts to Customer', NULL, 1, 1, 1),
(66, NULL, NULL, NULL, 3, 1, 'ACC-OPENING-BALANCE', 'F', 'Opening Balance', NULL, 1, 1, 0),
(67, NULL, NULL, NULL, 3, 5, 'CHEQUE-UPDATIONS', 'F', 'Cheque Updation', NULL, 1, 0, 0),
(68, NULL, NULL, NULL, 4, 5, 'BANK-RECONCILIATION', 'F', 'Bank Reconciliation', NULL, 1, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_menu_user`
--

CREATE TABLE IF NOT EXISTS `tbl_menu_user` (
  `MENU_USER_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MENU_USER_MASTER_ID` int(11) DEFAULT NULL,
  `MENU_MASTER_ID` int(11) DEFAULT NULL,
  `MENU_VIEW` varchar(1) DEFAULT NULL,
  `MENU_ADD` varchar(1) DEFAULT NULL,
  `MENU_EDIT` varchar(1) DEFAULT NULL,
  `MENU_DELETE` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`MENU_USER_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=257 ;

--
-- Dumping data for table `tbl_menu_user`
--

INSERT INTO `tbl_menu_user` (`MENU_USER_ID`, `MENU_USER_MASTER_ID`, `MENU_MASTER_ID`, `MENU_VIEW`, `MENU_ADD`, `MENU_EDIT`, `MENU_DELETE`) VALUES
(204, 1, 5, '1', '1', NULL, NULL),
(205, 1, 14, '1', '1', '1', NULL),
(206, 1, 15, '1', '1', '1', NULL),
(207, 1, 16, '1', '1', '1', NULL),
(208, 1, 17, '1', '1', '1', NULL),
(209, 1, 18, '1', '1', '1', NULL),
(210, 1, 19, '1', NULL, NULL, NULL),
(211, 1, 20, '1', NULL, NULL, NULL),
(212, 1, 64, '1', '1', '1', '1'),
(213, 1, 65, '1', '1', '1', '1'),
(214, 1, 66, '1', '1', '1', NULL),
(215, 1, 67, '1', '1', NULL, NULL),
(216, 1, 21, '1', NULL, NULL, NULL),
(217, 1, 22, '1', NULL, NULL, NULL),
(218, 1, 23, '1', NULL, NULL, NULL),
(219, 1, 24, '1', NULL, NULL, NULL),
(220, 1, 25, '1', NULL, NULL, NULL),
(221, 1, 26, '1', NULL, NULL, NULL),
(222, 1, 68, '1', '1', NULL, NULL),
(223, 1, 13, '1', '1', '1', '1'),
(224, 1, 27, '1', '1', '1', NULL),
(225, 1, 28, '1', '1', '1', NULL),
(226, 1, 29, '1', '1', '1', NULL),
(227, 1, 30, '1', '1', '1', NULL),
(228, 1, 31, '1', '1', '1', NULL),
(229, 1, 32, '1', '1', '1', '1'),
(230, 1, 33, '1', '1', '1', NULL),
(231, 1, 34, '1', NULL, NULL, NULL),
(232, 1, 35, '1', NULL, NULL, NULL),
(233, 1, 36, '1', NULL, NULL, NULL),
(234, 1, 37, '1', NULL, NULL, NULL),
(235, 1, 51, '1', '1', '1', NULL),
(236, 1, 52, '1', '1', '1', NULL),
(237, 1, 53, '1', '1', '1', NULL),
(238, 1, 54, '1', '1', '1', '1'),
(239, 1, 55, '1', '1', '1', '1'),
(240, 1, 56, '1', '1', '1', '1'),
(241, 1, 57, '1', NULL, NULL, NULL),
(242, 1, 58, '1', '1', '1', '1'),
(243, 1, 59, '1', '1', '1', '1'),
(244, 1, 60, '1', '1', '1', '1'),
(245, 1, 61, '1', NULL, NULL, NULL),
(246, 1, 62, '1', NULL, NULL, NULL),
(247, 1, 63, '1', NULL, NULL, NULL),
(248, 1, 38, '1', NULL, NULL, NULL),
(249, 1, 39, '1', NULL, NULL, NULL),
(250, 1, 40, '1', NULL, NULL, NULL),
(251, 1, 41, '1', NULL, NULL, NULL),
(252, 1, 42, '1', NULL, NULL, NULL),
(253, 1, 44, '1', NULL, NULL, NULL),
(254, 1, 45, '1', NULL, NULL, NULL),
(255, 1, 46, '1', NULL, NULL, NULL),
(256, 1, 47, '1', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_expense`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_expense` (
  `MEXP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MEXP_MASTER_ID` int(11) NOT NULL,
  `MEXP_AMOUNT` double NOT NULL,
  `MEXP_SALES_MAN_ID` int(11) NOT NULL,
  `MEXP_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MEXP_DESCRIPTION` varchar(300) NOT NULL,
  `MEXP_ATTACHMENT` varchar(300) NOT NULL,
  `MEXP_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`MEXP_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `tbl_mini_expense`
--

INSERT INTO `tbl_mini_expense` (`MEXP_ID`, `MEXP_MASTER_ID`, `MEXP_AMOUNT`, `MEXP_SALES_MAN_ID`, `MEXP_DATE`, `MEXP_DESCRIPTION`, `MEXP_ATTACHMENT`, `MEXP_STATUS`) VALUES
(21, 104, 144545, 1, '2017-04-04 07:00:00', 'ruufu djjjffudu hdudu ruuudu ddiiei rurururhdh ruhfuchfu rrjuufufhfj rejfjfj rjrjfhfh', '', 'N'),
(22, 104, 12, 1, '2017-04-04 07:00:00', 'gjdjjcjdfjfj urururj rijjrjjej rririddi rjrjdj. jjdjdjjdj ddidijdjd ddjdjdjdj duufuf', '823d7de2f37f2c4399a0b8ae6389af70.jpg', 'N'),
(23, 104, 955, 1, '2017-04-10 07:00:00', 'ggsgd', '', 'N'),
(24, 104, 254, 1, '2017-04-13 07:00:00', 'petrol\n', '', 'N'),
(25, 104, 250, 1, '2017-04-21 07:00:00', '', '', 'N'),
(26, 104, 120, 1, '2017-04-23 07:00:00', '', '', 'N'),
(27, 104, 100, 1, '2017-05-03 18:30:00', 'vcbcvbfcg', 'a851eb11627ad587169b8045229e83c1.jpg', 'N');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_expense_master`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_expense_master` (
  `EXP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `EXP_NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`EXP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_invoice_items`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_invoice_items` (
  `MINI_INV_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_INV_ITEM_PACKET_ID` int(11) NOT NULL,
  `MINI_INV_ITEM_QTY` double NOT NULL,
  `MINI_INV_MASTER_ID` int(11) NOT NULL,
  `MINI_INV_PRICE` double NOT NULL,
  `MINI_INV_TOTAL` double NOT NULL,
  PRIMARY KEY (`MINI_INV_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

--
-- Dumping data for table `tbl_mini_invoice_items`
--

INSERT 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
(1, 4, 5, 1, 3, 15),
(2, 2, 5, 1, 2, 10),
(3, 6, 2, 1, 4, 8),
(4, 1, 65, 2, 1.5, 97.5),
(5, 5, 3, 2, 3.5, 10.5),
(6, 3, 25, 2, 2, 50),
(7, 1, 1, 3, 1.5, 1.5),
(8, 2, 25, 4, 2, 50),
(9, 4, 14, 4, 3, 42),
(10, 5, 25, 4, 3.5, 87.5),
(11, 2, 251, 5, 2, 502),
(12, 2, 25, 6, 2, 50),
(13, 4, 12, 6, 3, 36),
(14, 5, 25, 6, 3.5, 87.5),
(15, 2, 25, 7, 2, 50),
(16, 3, 12, 7, 2, 24),
(17, 6, 25, 7, 4, 100),
(18, 3, 12, 8, 2, 24),
(19, 5, 57, 8, 3.5, 199.5),
(20, 6, 45, 8, 4, 180),
(21, 2, 12, 9, 2, 24),
(22, 4, 12, 9, 3, 36),
(23, 5, 15, 9, 3.5, 52.5),
(24, 1, 3, 10, 1.5, 4.5),
(25, 2, 1, 10, 2, 2),
(26, 3, 1, 10, 2, 2),
(27, 1, 1, 11, 1.5, 1.5),
(28, 2, 1, 11, 2, 2),
(29, 3, 1, 11, 2, 2),
(30, 4, 1, 11, 3, 3),
(31, 5, 1, 11, 3.5, 3.5),
(32, 6, 1, 11, 4, 4),
(33, 1, 1, 12, 1.5, 1.5),
(34, 2, 1, 12, 2, 2),
(35, 3, 1, 12, 2, 2),
(36, 4, 1, 13, 3, 3),
(37, 2, 1, 13, 2, 2),
(38, 3, 1, 13, 2, 2),
(39, 1, 1, 14, 1.5, 1.5),
(40, 4, 2, 15, 3, 6),
(41, 2, 1, 15, 2, 2),
(42, 6, 1, 15, 4, 4),
(43, 1, 2, 16, 1.5, 3),
(44, 2, 1, 16, 2, 2),
(45, 3, 1, 16, 2, 2),
(46, 1, 1, 17, 1.5, 1.5),
(47, 1, 1, 18, 1.5, 1.5),
(48, 2, 1, 18, 2, 2),
(49, 3, 1, 18, 2, 2),
(50, 4, 1, 18, 3, 3),
(51, 1, 1, 19, 1.5, 1.5);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_invoice_master`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_invoice_master` (
  `MINI_INV_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_INV_CUSTOMER_ID` int(11) NOT NULL,
  `MINI_INV_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MINI_INV_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  `MINI_INV_SALES_MAN_ID` int(11) NOT NULL,
  `MINI_INV_LOCATION_MASTER_ID` int(11) NOT NULL,
  `MINI_INV_INVOICE_NO` varchar(255) DEFAULT NULL,
  `MINI_INV_ORDER_ID` int(11) NOT NULL DEFAULT '0',
  `MINI_INV_PAYMODE` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`MINI_INV_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `tbl_mini_invoice_master`
--

INSERT 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
(1, 7, '2017-04-22 07:00:00', 'N', 1, 1, 'INV1', 0, 1),
(2, 8, '2017-04-22 07:00:00', 'N', 1, 1, 'INV2', 10, 0),
(3, 20, '2017-04-22 07:00:00', 'N', 1, 1, 'INV3', 9, 1),
(4, 9, '2017-04-22 08:12:41', 'N', 1, 1, 'INV4', 0, 1),
(5, 5, '2017-04-22 08:13:18', 'N', 1, 1, 'INV5', 0, 1),
(6, 7, '2017-04-23 10:51:04', 'N', 1, 1, 'INV6', 0, 1),
(7, 8, '2017-04-23 11:04:28', 'N', 1, 1, 'INV7', 0, 0),
(8, 7, '2017-04-24 07:00:00', 'N', 1, 1, 'INV8', 11, 1),
(9, 7, '2017-04-24 07:00:00', 'N', 1, 1, 'INV9', 0, 1),
(10, 5, '2017-04-23 18:30:00', 'N', 1, 1, 'INV10', 0, 1),
(11, 5, '2017-04-26 18:30:00', 'N', 1, 1, 'INV11', 0, 1),
(12, 5, '2017-04-26 18:30:00', 'N', 1, 1, 'INV12', 0, 1),
(13, 48, '2017-04-26 18:30:00', 'N', 1, 1, 'INV13', 0, 1),
(14, 5, '2017-04-27 18:30:00', 'N', 1, 1, 'INV14', 0, 1),
(15, 7, '2017-05-01 18:30:00', 'N', 1, 1, 'INV15', 0, 1),
(16, 5, '2017-05-01 18:30:00', 'N', 1, 1, 'INV16', 13, 1),
(17, 5, '2017-05-03 18:30:00', 'N', 1, 1, 'INV17', 0, 1),
(18, 198, '2017-05-03 18:30:00', 'N', 1, 1, 'INV18', 0, 1),
(19, 6, '2017-05-05 18:30:00', 'N', 1, 1, 'INV19', 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_menu_master`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_menu_master` (
  `MENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MENU_TEXT` varchar(45) DEFAULT NULL,
  `MENU_ORDER_NO` int(11) DEFAULT NULL,
  `MENU_ANDROID_ID` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_mini_menu_master`
--

INSERT INTO `tbl_mini_menu_master` (`MENU_ID`, `MENU_TEXT`, `MENU_ORDER_NO`, `MENU_ANDROID_ID`) VALUES
(1, 'Home', 1, 'HOME'),
(2, 'Customers', 2, 'CUST'),
(3, 'Products', 3, 'PROD'),
(4, 'Expenses', 4, 'EXPE'),
(5, 'Orders', 5, 'ORDE'),
(6, 'Sales', 6, 'SALE'),
(7, 'Returns', 7, 'RETU'),
(8, 'Reporting', 8, 'REPO'),
(9, 'Stock Entry', 9, 'STEN'),
(10, 'Stock Movement', 10, 'STMV'),
(11, 'Logout', 13, 'LGOT'),
(12, 'Management', 11, 'MGMT'),
(13, 'Route Switch', 12, 'RTSW');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_menu_user`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_menu_user` (
  `UMENU_ID` int(11) NOT NULL AUTO_INCREMENT,
  `UMENU_MASTER_ID` int(11) DEFAULT NULL,
  `UMENU_USER_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`UMENU_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;

--
-- Dumping data for table `tbl_mini_menu_user`
--

INSERT INTO `tbl_mini_menu_user` (`UMENU_ID`, `UMENU_MASTER_ID`, `UMENU_USER_ID`) VALUES
(54, 2, 65),
(55, 3, 65),
(56, 4, 65),
(57, 5, 65),
(58, 6, 65),
(59, 7, 65),
(60, 8, 65),
(61, 9, 65),
(62, 10, 65),
(63, 12, 65),
(86, 2, 1),
(87, 3, 1),
(88, 4, 1),
(89, 5, 1),
(90, 6, 1),
(91, 7, 1),
(92, 8, 1),
(93, 9, 1),
(94, 12, 1),
(95, 13, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_order_items`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_order_items` (
  `MINI_ORD_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_ORD_ITEM_PACKET_ID` int(11) NOT NULL,
  `MINI_ORD_ITEM_QTY` double NOT NULL,
  `MINI_ORD_MASTER_ID` int(11) NOT NULL,
  `MINI_ORD_PRICE` double NOT NULL,
  `MINI_ORD_TOTAL` double NOT NULL,
  PRIMARY KEY (`MINI_ORD_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `tbl_mini_order_items`
--

INSERT 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
(5, 1, 1, 3, 1.5, 1.5),
(6, 2, 1, 3, 2, 2),
(7, 5, 1, 3, 3.5, 3.5),
(11, 1, 1, 5, 1.5, 1.5),
(12, 2, 1, 5, 2, 2),
(19, 1, 1, 4, 1.5, 1.5),
(20, 2, 1, 4, 2, 2),
(21, 5, 1, 4, 3.5, 3.5),
(24, 1, 66, 2, 1.5, 99),
(25, 5, 25, 2, 3.5, 87.5),
(26, 6, 20, 7, 4, 80),
(27, 8, 25, 7, 7, 175),
(28, 7, 12, 7, 4.25, 51),
(29, 1, 1, 6, 1.5, 1.5),
(30, 3, 1, 6, 2, 2),
(31, 4, 1, 6, 3, 3),
(32, 1, 1, 8, 1.5, 1.5),
(33, 1, 1, 9, 1.5, 1.5),
(34, 1, 65, 10, 1.5, 97.5),
(35, 5, 3, 10, 3.5, 10.5),
(36, 3, 25, 10, 2, 50),
(37, 3, 12, 11, 2, 24),
(38, 5, 57, 11, 3.5, 199.5),
(39, 6, 45, 11, 4, 180),
(41, 1, 1, 13, 1.5, 1.5),
(42, 2, 1, 13, 2, 2),
(43, 3, 1, 13, 2, 2),
(44, 1, 1, 14, 1.5, 1.5),
(45, 2, 3, 14, 2, 6),
(46, 1, 1, 15, 1.5, 1.5),
(47, 2, 1, 15, 2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_order_master`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_order_master` (
  `MINI_ORD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_ORD_CUSTOMER_ID` int(11) NOT NULL,
  `MINI_ORD_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MINI_ORD_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  `MINI_ORD_SALESMAN_ID` int(11) NOT NULL,
  `MINI_ORD_NUM` varchar(255) NOT NULL,
  PRIMARY KEY (`MINI_ORD_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `tbl_mini_order_master`
--

INSERT 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
(2, 8, '2017-04-20 09:21:28', 'Y', 1, 'ORD1'),
(3, 5, '2017-04-20 09:51:02', 'Y', 1, 'ORD2'),
(4, 5, '2017-04-20 09:51:31', 'Y', 1, 'ORD3'),
(5, 5, '2017-04-20 09:53:26', 'Y', 1, 'ORD4'),
(6, 5, '2017-04-20 09:56:18', 'Y', 1, 'ORD5'),
(7, 7, '2017-04-21 13:02:50', 'Y', 1, 'ORD6'),
(8, 5, '2017-04-22 07:06:44', 'Y', 1, 'ORD7'),
(9, 20, '2017-04-22 07:07:49', 'Y', 1, 'ORD8'),
(10, 8, '2017-04-22 07:00:00', 'Y', 1, 'ORD9'),
(11, 7, '2017-04-24 07:00:00', 'Y', 1, 'ORD10'),
(13, 5, '2017-04-27 18:30:00', 'Y', 1, 'ORD12'),
(14, 199, '2017-05-03 18:30:00', 'N', 1, 'ORD13'),
(15, 5, '2017-05-05 18:30:00', 'N', 1, 'ORD14');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_return_items`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_return_items` (
  `MINI_RET_ITEM_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_RET_ITEM_PACKET_ID` int(11) NOT NULL,
  `MINI_RET_ITEM_QTY` double NOT NULL,
  `MINI_RET_MASTER_ID` int(11) NOT NULL,
  `MINI_RET_PRICE` double NOT NULL,
  `MINI_RET_TOTAL` double NOT NULL,
  PRIMARY KEY (`MINI_RET_ITEM_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_mini_return_items`
--

INSERT 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
(5, 4, 2, 5, 3, 6),
(6, 1, 1, 6, 1.5, 1.5);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_return_master`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_return_master` (
  `MINI_RET_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_RET_CUSTOMER_ID` int(11) NOT NULL,
  `MINI_RET_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MINI_RET_STATUS` varchar(1) NOT NULL DEFAULT 'N',
  `MINI_RET_SALES_MAN_ID` int(11) NOT NULL,
  PRIMARY KEY (`MINI_RET_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_mini_return_master`
--

INSERT INTO `tbl_mini_return_master` (`MINI_RET_ID`, `MINI_RET_CUSTOMER_ID`, `MINI_RET_DATE`, `MINI_RET_STATUS`, `MINI_RET_SALES_MAN_ID`) VALUES
(5, 7, '2017-04-22 08:13:39', 'N', 1),
(6, 5, '2017-05-05 18:30:00', 'N', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_mini_salesman_route`
--

CREATE TABLE IF NOT EXISTS `tbl_mini_salesman_route` (
  `MINI_ROUTE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MINI_SALESMAN_ID` int(11) DEFAULT NULL,
  `MINI_ROUTE_MASTER_D` int(11) DEFAULT NULL,
  PRIMARY KEY (`MINI_ROUTE_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

--
-- Dumping data for table `tbl_mini_salesman_route`
--

INSERT INTO `tbl_mini_salesman_route` (`MINI_ROUTE_ID`, `MINI_SALESMAN_ID`, `MINI_ROUTE_MASTER_D`) VALUES
(1, 67, 5),
(2, 67, 1),
(3, 67, 2),
(32, 65, 6),
(33, 65, 2),
(34, 65, 8),
(67, 68, 7),
(68, 68, 6),
(69, 68, 4),
(70, 68, 3),
(71, 1, 8),
(72, 1, 6),
(73, 1, 1),
(74, 1, 4),
(75, 1, 3),
(76, 1, 2);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_opening_balance`
--

CREATE TABLE IF NOT EXISTS `tbl_opening_balance` (
  `OP_BNCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `OP_BNCE_ACCOUNT_ID` int(11) NOT NULL COMMENT 'foreign key-account',
  `OP_BNCE_AMOUNT` double DEFAULT NULL,
  PRIMARY KEY (`OP_BNCE_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_opening_balance`
--

INSERT INTO `tbl_opening_balance` (`OP_BNCE_ID`, `OP_BNCE_ACCOUNT_ID`, `OP_BNCE_AMOUNT`) VALUES
(1, 91, 0),
(2, 253, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_transactions`
--

CREATE TABLE IF NOT EXISTS `tbl_transactions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VOUCHER_CODE` varchar(255) NOT NULL,
  `DEBIT_ACC_ID` int(11) DEFAULT NULL,
  `CREDIT_ACC_ID` int(11) DEFAULT NULL,
  `AMOUNT` double DEFAULT NULL,
  `TRASACTION_DATE` date DEFAULT NULL,
  `SYSTEM_DATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `CHQUE_NUM` varchar(255) DEFAULT NULL,
  `CHQUE_DATE` date DEFAULT NULL,
  `ADDRESS` varchar(300) DEFAULT NULL,
  `USER_ID` int(11) DEFAULT NULL,
  `NARRATION` varchar(350) DEFAULT NULL,
  `IS_POSTED` varchar(1) DEFAULT 'N',
  `INVOICE_NUMBER` varchar(45) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- Dumping data for table `tbl_transactions`
--

INSERT 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
(1, 'CR1', 91, 95, 1000, '2017-03-06', '2017-03-06 21:52:58', NULL, NULL, '\r\n                  address', 0, '\r\n          description        ', 'Y', '0'),
(2, 'PC2', 93, 94, 190, '2017-03-01', '2017-03-08 18:18:05', '0', '2017-03-01', '0', 1, '', 'Y', ''),
(3, 'PC3', 0, 95, 550, '2017-03-01', '2017-03-08 23:12:34', '0', '2017-03-01', '0', 1, '', 'Y', ''),
(4, 'PC3', 93, 95, 83, '2017-03-01', '2017-03-08 23:12:34', '0', '2017-03-01', '0', 1, '', 'Y', ''),
(5, 'PC4', 328, 120, 3900, '2017-03-01', '2017-03-19 19:56:29', '0', '2017-03-01', '0', 1, '', 'Y', '4'),
(6, 'PC5', 93, 128, 890, '2017-03-02', '2017-03-19 20:38:56', '0', '2017-03-02', '0', 1, 'discouond  0.35', 'Y', '5'),
(7, 'PC5', 102, 128, 490, '2017-03-02', '2017-03-19 20:38:56', '0', '2017-03-02', '0', 1, 'discouond  0.35', 'Y', '5'),
(8, 'PC6', 102, 128, 560, '2017-03-09', '2017-03-20 17:52:30', '0', '2017-03-09', '0', 1, '', 'N', '6'),
(9, 'PC6', 93, 128, 800, '2017-03-09', '2017-03-20 17:52:30', '0', '2017-03-09', '0', 1, '', 'N', '6'),
(10, 'PC7', 331, 137, 120, '2017-03-03', '2017-03-20 18:57:48', '0', '2017-03-03', '0', 1, '', 'Y', '7'),
(11, 'PC8', 331, 137, 1000, '2017-03-07', '2017-03-20 18:58:30', '0', '2017-03-07', '0', 1, '', 'N', '8'),
(12, 'PC9', 331, 137, 1150, '2017-03-03', '2017-03-20 19:03:51', '0', '2017-03-03', '0', 1, '', 'Y', '9'),
(13, 'PC10', 331, 137, 850, '2017-03-02', '2017-03-20 19:10:11', '0', '2017-03-02', '0', 1, '', 'Y', '10'),
(14, 'PC10', 331, 137, 1100, '2017-03-13', '2017-03-20 19:11:02', '0', '2017-03-13', '0', 1, '', 'N', '11'),
(15, 'PC10', 93, 140, 2700, '2017-03-11', '2017-03-21 18:43:38', '0', '2017-03-11', '0', 1, '', 'N', '12'),
(16, 'PC10', 93, 140, 2700, '2017-03-07', '2017-03-21 18:44:16', '0', '2017-03-07', '0', 1, '', 'N', '13'),
(17, 'PC10', 93, 132, 1000, '2017-03-10', '2017-03-21 19:32:59', '0', '2017-03-10', '0', 1, '', 'N', '14'),
(18, 'PC10', 93, 132, 750, '2017-03-04', '2017-03-21 19:33:40', '0', '2017-03-04', '0', 1, '', 'N', '15'),
(19, 'PC10', 93, 132, 500, '2017-03-09', '2017-03-21 19:34:25', '0', '2017-03-09', '0', 1, '', 'N', '16'),
(20, 'PC10', 93, 132, 500, '2017-03-06', '2017-03-21 19:35:07', '0', '2017-03-06', '0', 1, '', 'N', '17'),
(21, 'PC10', 93, 132, 500, '2017-03-03', '2017-03-21 19:35:40', '0', '2017-03-03', '0', 1, '', 'Y', '18'),
(22, 'PC10', 93, 132, 750, '2017-03-02', '2017-03-21 19:36:17', '0', '2017-03-02', '0', 1, '', 'Y', '19'),
(23, 'PC10', 93, 120, 270, '2017-03-11', '2017-03-21 20:41:29', '0', '2017-03-11', '0', 1, '', 'N', '20'),
(24, 'PC10', 328, 120, 0, '2017-03-12', '2017-03-21 20:42:07', '0', '2017-03-12', '0', 1, 'TOTAL AMT -3900', 'N', '21'),
(25, 'PC10', 328, 120, 0, '2017-03-08', '2017-03-21 20:43:01', '0', '2017-03-08', '0', 1, '', 'N', '22'),
(26, 'PC10', 328, 120, 0, '2017-03-02', '2017-03-21 20:43:54', '0', '2017-03-02', '0', 1, 'ITEM NO 4 AMOUNT 1500', 'Y', '23'),
(27, 'PC10', 331, 131, 300, '2017-03-13', '2017-03-22 17:18:24', '0', '2017-03-13', '0', 1, '', 'N', '24'),
(28, 'PC10', 331, 131, 300, '2017-03-05', '2017-03-22 17:18:56', '0', '2017-03-05', '0', 1, '', 'N', '25'),
(29, 'PC10', 93, 142, 2202, '2017-03-01', '2017-03-22 20:29:16', '0', '2017-03-01', '0', 1, 'total -2785', 'Y', '26'),
(30, 'PC10', 93, 332, 72, '2017-03-01', '2017-03-23 20:39:43', '0', '2017-03-01', '0', 1, 'total -215', 'Y', '27'),
(31, 'PC10', 93, 332, 72, '2017-03-02', '2017-03-23 20:40:38', '0', '2017-03-02', '0', 1, '340\n', 'Y', '28'),
(32, 'PC10', 102, 119, 3200, '2017-03-01', '2017-03-30 16:49:37', '0', '2017-03-01', '0', 1, 'NOT ACTUAL PURCHASE ....', 'Y', '29'),
(33, 'PC10', 93, 119, 13460, '2017-03-01', '2017-03-30 16:49:37', '0', '2017-03-01', '0', 1, 'NOT ACTUAL PURCHASE ....', 'Y', '29'),
(34, 'PC10', 93, 119, 4000, '2017-03-01', '2017-03-30 20:09:58', '0', '2017-03-01', '0', 1, 'NOT ACTUAL PURCHASE', 'Y', '30'),
(35, 'CP1', 104, 91, 25000, '2017-03-01', '2017-04-01 20:00:39', NULL, NULL, '0', 0, '                    ', 'N', '0'),
(36, 'RC1', 91, 96, 22222, '2017-03-01', '2017-04-01 20:01:20', NULL, NULL, '\r\n                  ', 0, '\r\n                  ', 'N', '0'),
(37, 'JV1', 91, 92, 50000, '2017-03-03', '2017-04-01 20:01:54', '0', '2017-03-03', '0', 0, '\n                ', 'N', ''),
(38, 'BP1', 331, 92, 522, '2017-03-30', '2017-04-01 20:35:58', '022222', '2017-04-28', '0', 0, '                    ', 'N', '0'),
(39, 'RB1', 92, 102, 5000, '2017-03-31', '2017-04-01 20:45:52', '001', '2017-03-31', '\r\n                  ', 0, '\r\n                  ', 'N', '0'),
(40, 'RB2', 92, 328, 200, '1969-12-31', '2017-04-01 20:46:21', '002', '2017-04-14', '\r\n                  ', 0, '\r\n                  ', 'N', '0'),
(41, 'BP2', 331, 92, 6000, '2017-03-31', '2017-04-01 20:47:12', '0003', '2017-04-14', '0', 0, '                    ', 'N', '0');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_transaction_bills`
--

CREATE TABLE IF NOT EXISTS `tbl_transaction_bills` (
  `TB_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TB_VOUCHER_CODE` varchar(255) NOT NULL,
  `TB_BILL_NO` varchar(255) NOT NULL,
  `TB_AMOUNT` double NOT NULL,
  `TB_CUSTOMER_ID` int(11) NOT NULL,
  `TB_DATE` date NOT NULL,
  `TB_SYSTEM_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `TB_TYPE` tinyint(1) DEFAULT NULL COMMENT '1-customer,2-salesman',
  PRIMARY KEY (`TB_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `tbl_transaction_bills`
--

INSERT 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
(3, 'CP7', '3', 2, 1, '2017-05-08', '2017-05-08 11:03:47', 2),
(4, 'CP7', '7', 1, 1, '2017-05-08', '2017-05-08 11:03:47', 2),
(19, 'RC8', '1002', 1, 2, '2017-05-08', '2017-05-08 11:30:54', 1),
(20, 'RC8', '1018', 0, 2, '2017-05-08', '2017-05-08 11:30:54', 1),
(30, 'CP8', '7', 5, 1, '2017-05-08', '2017-05-08 11:41:44', 2),
(33, 'RC10', '1002', 1, 2, '2017-05-08', '2017-05-08 11:46:01', 1),
(34, 'RC10', '1018', 0, 2, '2017-05-08', '2017-05-08 11:46:01', 1),
(35, 'RC9', '1015', 1, 1, '2017-05-08', '2017-05-08 11:47:36', 1),
(36, 'RC9', '1016', 1, 1, '2017-05-08', '2017-05-08 11:47:36', 1),
(37, 'RC9', '1017', 1, 1, '2017-05-08', '2017-05-08 11:47:36', 1),
(41, 'RB6', '1018', 1, 2, '2017-05-09', '2017-05-09 08:32:57', 1),
(42, 'RB6', '1002', 1, 2, '2017-05-09', '2017-05-09 08:32:57', 1),
(46, 'RC11', '1015', 1, 1, '2017-05-09', '2017-05-09 08:34:21', 1),
(47, 'RC11', '1017', 1, 1, '2017-05-09', '2017-05-09 08:34:21', 1),
(48, 'RC11', '1016', 1, 1, '2017-05-09', '2017-05-09 08:34:21', 1),
(49, 'CP9', '3', 2, 1, '2017-05-10', '2017-05-10 03:46:31', 2);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_NAME` varchar(255) DEFAULT NULL,
  `SALESMAN_ID` int(11) NOT NULL,
  `PASSWORD` varchar(255) DEFAULT '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684',
  `TEMP_API_KEY` varchar(300) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`ID`, `USER_NAME`, `SALESMAN_ID`, `PASSWORD`, `TEMP_API_KEY`) VALUES
(1, 'admin', 1, 'd033e22ae348aeb5660fc2140aec35850c4da997', '111afd3825cdde21f07db7709cfc02294627fab2'),
(2, 'demo', 1, 'cbdbe4936ce8be63184d9f2e13fc249234371b9a', '98596cf402e3d681500454cb5a43a31f7af0865f'),
(3, 'bchchv', 50, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(6, 'uvuvub', 53, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(8, 'cjdjjdj', 55, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(11, 'rhfhfh', 58, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(12, 'cjcjf', 59, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(15, 'fhdhdh', 62, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(17, 'dbddb', 64, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(18, 'saleeqvm', 65, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', '3dc096784d1e654e91c52cdbce33a0fe166abcc0'),
(19, 'abc', 66, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', '49497ffc8640ea917eabbfe679fc473a2dfcd7a0'),
(20, 'fjfjjf', 67, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', ''),
(21, 'fghfgh', 68, '9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;