-- http://www.phpmyadmin.net
--




--
-- Database: `iaccountdb`
--

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

--
-- Table structure for table `_sys_menu`
--

CREATE TABLE IF NOT EXISTS `_sys_menu` (
  `fldid` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(8) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `parents` varchar(8) DEFAULT '0',
  `module` varchar(8) DEFAULT '0',
  `submenu` smallint(1) DEFAULT '0',
  `urls` varchar(100) DEFAULT '0',
  `urls2` varchar(100) DEFAULT '0',
  `access` varchar(100) DEFAULT NULL,
  `seq` int(11) NOT NULL,
  `display` smallint(1) DEFAULT '1',
  `icons` varchar(32) DEFAULT 'i-film',
  `language` varchar(3) DEFAULT 'EN',
  PRIMARY KEY (`fldid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT AUTO_INCREMENT=332 ;

--
-- Dumping data for table `_sys_menu`
--

INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES
(1, 'DB', 'Dashboard', '0', '0', 0, 'home', 'home', 'ALL', 1, 1, 'icondashboard.png', 'EN'),
(5, 'STP', 'GeneralSetup', '0', '10', 1, '#', '0', 'ALL', 90, 1, 'iconsetup.png', 'EN'),
(6, 'UM', 'UserMaster', '12', '9', 0, 'admin/usermaster', '0', 'ALL', 1, 1, 'iconuser.png', 'EN'),
(7, 'UML', 'UserMasterList', '12', '9', 0, 'admin/usermasterlist', '0', 'ALL', 2, 1, 'iconuser.png', 'EN'),
(12, 'ADM', 'Admin', '0', '9', 1, '#', '0', 'ADMIN', 99, 1, 'iconadmin.png', 'EN'),
(14, 'MUL', 'MenuList', '12', '9', 0, 'admin/menumasterlist', '0', 'ALL', 4, 1, 'iconuser.png', 'EN'),
(39, 'MSCL', 'CountryMasterList', '5', '10', 0, 'setting/countrylist', '0', 'ALL', 81, 0, 'iconcompanysetup.png', 'EN'),
(40, 'MSSL', 'StateList', '5', '10', 0, 'setting/statelist', '0', 'ALL', 80, 0, 'iconcompanysetup.png', 'EN'),
(41, 'MSLM', 'LocationMaster', '91', '4', 0, 'setting/locationlist', '0', 'ALL', 70, 1, 'iconsetupsub.png', 'EN'),
(45, 'GLM', 'GeneralLedger', '0', '1', 1, '#', '0', 'ALL', 2, 1, 'icongeneralledger.png', 'EN'),
(46, 'GLSETUP', 'Setup', '45', '1', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(50, 'PUR', 'Purchasing', '0', '8', 1, '#', '0', 'ALL', 30, 1, 'iconpurchasing.png', 'EN'),
(51, 'PURSETUP', 'Setup', '50', '5', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(52, 'PURRPT', 'Reports', '50', '5', 1, '#', '0', 'ALL', 70, 1, 'iconreport.png', 'EN'),
(54, 'PURSTSPL', 'Supplierslist', '51', '5', 0, 'supplier/supplierList', '0', 'ALL', 51, 1, 'iconsetupsub.png', 'EN'),
(67, 'PURSTUM', 'uom', '51', '5', 0, 'purchasesetting/unitmeasurelist', '0', 'ALL', 55, 1, 'iconsetupsub.png', 'EN'),
(68, 'PURSTUMC', 'UMConversionList', '51', '5', 0, 'purchasesetting/umconversionlist', '0', 'ALL', 56, 1, 'iconsetupsub.png', 'EN'),
(80, 'ARDASHB', 'AccountReceivables', '0', '2', 1, '#', '0', 'ALL', 5, 1, 'iconaccountreceivables.png', 'EN'),
(81, 'APDASHB', 'AccountPayables', '0', '3', 1, '#', '0', 'ALL', 10, 1, 'iconaccountpayables.png', 'EN'),
(82, 'SALES', 'SalesOrders', '0', '5', 1, '#', '0', 'ALL', 70, 1, 'iconsalesorder.png', 'EN'),
(83, 'GST', 'GST', '0', '6', 1, '#', '0', 'ALL', 30, 1, 'icongoodserviestax.png', 'EN'),
(84, 'ZAKAT', 'Zakat', '0', '7', 1, '#', '0', 'ALL', 80, 1, 'iconzakatwakaf.png', 'EN'),
(85, 'APSETUP', 'Setup', '81', '3', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(86, 'ARSETUP', 'Setup', '80', '2', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(87, 'APRPT', 'Reports', '81', '3', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(88, 'GLRPT', 'Reports', '45', '1', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(89, 'ARRPT', 'Reports', '80', '2', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(90, 'INVCTRL', 'InventoryControl', '0', '4', 1, '#', '0', 'ALL', 25, 1, 'iconinventorycontrol.png', 'EN'),
(91, 'ICSETUP', 'Setup', '90', '4', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(92, 'ICRPT', 'Reports', '90', '4', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(93, 'MSTRCOMP', 'CompanySetup', '5', '10', 1, 'company/setup', '0', 'ALL', 5, 1, 'iconcompanysetup.png', 'EN'),
(94, 'GLMCAL', 'Fycalendar', '46', '1', 0, 'glsetting/createCalendar', '0', 'ALL', 10, 1, 'iconsetupsub.png', 'EN'),
(95, 'GLHOME', 'Home', '45', '1', 0, 'GeneralLedger/Home', '0', 'ALL', 1, 1, 'icongeneralledgerSUB.png', 'EN'),
(96, 'ARHOME', 'Home', '80', '2', 0, 'AccountReceivables', '0', 'ALL', 1, 1, 'iconaccountreceivablesSUB.png', 'EN'),
(97, 'APHOME', 'Home', '81', '3', 0, '#', '0', 'ALL', 1, 1, 'iconaccountpayablesSUB.png', 'EN'),
(98, 'ICHOME', 'Home', '90', '4', 0, '#', '0', 'ALL', 1, 1, 'iconinventorycontrolSUB.png', 'EN'),
(99, 'PURHOME', 'Home', '50', '5', 0, '#', '0', 'ALL', 1, 1, 'iconpurchasingSUB.png', 'EN'),
(100, 'GSTHOME', 'Home', '83', '6', 0, '#', '0', 'ALL', 1, 1, 'icongoodserviestaxSUB.png', 'EN'),
(102, 'GSTSETUP', 'Setup', '83', '6', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(103, 'GSTRPT', 'Reports', '83', '6', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(104, 'SOHOME', 'Home', '82', '5', 0, 'SalesOrder', '0', 'ALL', 1, 1, 'iconsalesorderSUB.png', 'EN'),
(105, 'SOSETUP', 'Setup', '82', '5', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(106, 'SORPT', 'Reports', '82', '5', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(107, 'ZKTHOME', 'Home', '84', '7', 0, '#', '0', 'ALL', 1, 1, 'iconzakatwakafSUB.png', 'EN'),
(108, 'ZKTSETUP', 'Setup', '84', '7', 1, '#', '0', 'ALL', 90, 1, 'iconsetupsub.png', 'EN'),
(109, 'ZKTRPT', 'Reports', '84', '7', 1, '#', '0', 'ALL', 80, 1, 'iconreport.png', 'EN'),
(110, 'MSTRCOML', 'List', '93', '10', 0, 'setting/companyList', '0', 'ALL', 5, 1, 'iconcompanysetup.png', 'EN'),
(114, 'MSTRSUPP', 'SupplierSetup', '85', '3', 0, 'supplier/supplierList', '0', 'ALL', 11, 1, 'iconsetupsub.png', 'EN'),
(124, 'APTRANS', 'Transaction', '81', '3', 1, '#', '0', 'ALL', 10, 1, 'icon-transaction.png', 'EN'),
(129, 'APSUPPAY', 'SupplierPayment', '124', '3', 0, 'aptransaction/payment', '0', 'ALL', 50, 1, 'icon-transaction.png', 'EN'),
(130, 'ARSETCUS', 'CustomerSetup', '86', '2', 0, 'customerSetup/customerList', '0', 'ALL', 5, 1, 'iconsetupsub.png', 'EN'),
(131, 'ARTRANS', 'Transaction', '80', '2', 1, '#', '0', 'ALL', 10, 1, 'icon-transaction.png', 'EN'),
(141, 'APPURDN', 'PurchaseDebitNote', '124', '3', 0, 'aptransaction/newDebitNote', '0', 'ALL', 23, 1, 'icon-transaction.png', 'EN'),
(142, 'APPURCN', 'PurchaseCreditNote', '124', '3', 0, 'aptransaction/newCreditNote', '0', 'ALL', 25, 1, 'icon-transaction.png', 'EN'),
(143, 'ITEMCAT', 'ItemCategory', '91', '4', 0, 'icsetting/itemCategoryList', '0', 'ALL', 5, 1, 'iconsetupsub.png', 'EN'),
(144, 'ITEMTYP', 'ItemType', '91', '4', 0, 'icsetting/itemTypeList', '0', 'ALL', 10, 1, 'iconsetupsub.png', 'EN'),
(145, 'ITEMSET', 'ItemSetup', '91', '4', 0, 'icsetting/itemList', '0', 'ALL', 25, 1, 'iconsetupsub.png', 'EN'),
(147, 'PURTRANS', 'Transaction', '50', '5', 1, '#', '0', 'ALL', 5, 1, 'icon-transaction.png', 'EN'),
(148, 'ICTRANS', 'Transaction', '90', '4', 1, '#', '0', 'ALL', 5, 1, 'icon-transaction.png', 'EN'),
(150, 'GLTRANS', 'Transaction', '45', '1', 1, '#', '0', 'ALL', 5, 1, 'icon-transaction.png', 'EN'),
(151, 'GSTTRANS', 'Transaction', '83', '6', 1, '#', '0', 'ALL', 5, 1, 'icon-transaction.png', 'EN'),
(152, 'SOTRANS', 'Transaction', '82', '5', 1, '#', '0', 'ALL', 5, 1, 'icon-transaction.png', 'EN'),
(153, 'SOQUOT', 'SalesQuotation', '152', '5', 0, 'sotransaction/SalesQuotationList', '0', 'ALL', 1, 1, 'icon-transaction.png', 'EN'),
(154, 'GLTRJRNL', 'JlEntry', '150', '1', 0, 'gltransaction/journal', '0', '', 5, 1, 'icon-transaction.png', 'EN'),
(155, 'GLMCALL', 'Fycalendarlist', '46', '1', 0, 'glsetting/financialCalendarList', '0', 'ALL', 10, 1, 'iconsetupsub.png', 'EN'),
(156, 'PROJECT', 'ProjectList', '5', '0', 0, 'project/projectlist', '0', 'ALL', 50, 1, 'iconcompanysetup.png', 'EN'),
(157, 'TERM', 'Terms', '5', '0', 0, 'term/termlist', '0', 'ALL', 60, 1, 'iconcompanysetup.png', 'EN'),
(158, 'GSTMSTR', 'Gsttable', '102', '6', 0, 'tax/taxtableList', '0', 'ALL', 1, 1, 'iconsetupsub.png', 'EN'),
(159, 'GSTTYPE', 'taxclass', '102', '6', 0, 'tax/classList', '0', 'ALL', 30, 1, 'iconsetupsub.png', 'EN'),
(160, 'GSTGROUP', 'taxgroup', '102', '6', 0, 'tax/groupList', '0', 'ALL', 31, 1, 'iconsetupsub.png', 'EN'),
(161, 'GSTTYPE', 'taxtype', '102', '6', 0, 'tax/typeList', '0', 'ALL', 32, 1, 'iconsetupsub.png', 'EN'),
(162, 'INVUM', 'uom', '91', '4', 0, 'icsetting/unitmeasurelist', '0', 'ALL', 70, 1, 'iconsetupsub.png', 'EN'),
(163, 'INVUMCOV', 'UMConversion', '91', '4', 0, 'icsetting/umconversion', '0', '', 71, 0, 'iconsetupsub.png', 'EN'),
(164, 'INUMCVLS', 'uocvlist', '91', '4', 0, 'icsetting/umconversionlist', '0', '', 72, 1, 'iconsetupsub.png', 'EN'),
(166, 'GLRPBS', 'Financialposition', '88', '1', 0, 'glreports/financialposition', '0', '', 20, 1, 'iconreport.png', 'EN'),
(167, 'GLRPTB', 'Trialbalance', '88', '1', 0, 'glreports/trialBalance', '0', 'ALL', 5, 1, 'iconreport.png', 'EN'),
(168, 'GLSTCOA', 'ChartOfAccount', '46', '1', 0, 'glsetting/chartOfAcctList', '0', 'ALL', 60, 1, 'iconsetupsub.png', 'EN'),
(169, 'MSMTRCD', 'Mastercode', '5', '1', 0, 'setting/masterCodeSetupList', '0', '', 40, 1, 'iconcompanysetup.png', 'EN'),
(171, 'GLTRJlCY', 'JlCopy', '150', '1', 0, 'Gltransaction/journalCopy', '0', '', 20, 1, 'icon-transaction.png', 'EN'),
(172, 'GLTRJlRV', 'JlReverse', '150', '1', 0, 'Gltransaction/reverse', '0', '', 30, 1, 'icon-transaction.png', 'EN'),
(173, 'GLTRPOST', 'Posting', '150', '1', 0, 'Gltransaction/posting', '0', '', 40, 1, 'icon-transaction.png', 'EN'),
(174, 'GLRPJLPS', 'Jlpost', '88', '1', 0, 'glreports/postedjournal', '0', '', 40, 1, 'iconreport.png', 'EN'),
(175, 'GLRPJLUP', 'Jlunposted', '88', '1', 0, 'glreports/unpostedjournal', '0', '', 35, 1, 'iconreport.png', 'EN'),
(176, 'GLRPTBFC', 'Trialbalancefc', '88', '1', 0, 'glreports/trialbalanceFiscalyear', '0', '', 7, 1, 'iconreport.png', 'EN'),
(178, 'GLRPABSM', 'Accountbalancesummary', '88', '1', 0, 'glreports/accountBalanceSummary', '0', '', 2, 1, 'iconreport.png', 'EN'),
(179, 'EMP', 'employeeSetup', '5', '0', 0, 'employeeSetup/employeeList', '0', '', 7, 1, 'iconcompanysetup.png', 'EN'),
(180, 'APPURDNL', 'PurchaseDebitNoteList', '87', '3', 0, 'apreports/debitnoteList', '0', '', 26, 1, 'iconreport.png', 'EN'),
(181, 'APPURDNC', 'PurchaseDebitNoteConfirm', '124', '3', 0, 'aptransaction/debitnotePost', '0', '', 24, 1, 'icon-transaction.png', 'EN'),
(184, 'APPURCNL', 'PurchaseCreditNoteList', '87', '3', 0, 'apreports/creditnoteList', '0', '', 27, 1, 'iconreport.png', 'EN'),
(185, 'APPURCNC', 'PurchaseCreditNoteConfirm', '124', '3', 0, 'aptransaction/creditnotePost', '0', '', 27, 1, 'icon-transaction.png', 'EN'),
(186, 'APPAYCFM', 'SupplierPaymentConfirm', '124', '3', 0, 'aptransaction/supplierpaymentList', '0', '', 51, 1, 'icon-transaction.png', 'EN'),
(187, 'APSUPPAY', 'SupplierPaymentList', '87', '3', 0, 'apreports/supplierpaymentlist', '0', '', 52, 1, 'iconreport.png', 'EN'),
(189, 'GLRPPNLM', 'Profitnloss', '88', '1', 0, 'glreports/profitNloss', '0', '', 30, 1, 'iconreport.png', 'EN'),
(190, 'FORMSTP', 'formSetup', '93', '10', 0, 'companySetup/formSetup', '0', '', 30, 1, 'i-pen ', 'EN'),
(191, 'GLSTBDGT', 'Budget', '46', '1', 0, 'glsetting/budgetEntry', '0', '', 20, 1, 'iconsetupsub.png', 'EN'),
(192, 'APOPWI', 'NewOtherPaymentWithItem', '124', '3', 0, 'othersPayment/newPayWithItem', '0', '', 54, 1, 'i-pen ', 'EN'),
(193, 'APPAYICM', 'NewOtherPaymentWithItemConfirm', '124', '3', 0, 'aptransaction/otherpaywithItemPost', '0', '', 55, 1, 'icon-transaction.png', 'EN'),
(194, 'APOPWOI', 'NewOtherPaymentWithoutItem', '150', '3', 0, 'othersPayment/newPayWithoutItem', '0', '', 56, 1, 'i-pen ', 'EN'),
(196, 'APRPTOPW', 'OtherPaymentWithItemList', '87', '3', 0, 'othersPayment/otherpaywithList', '0', '', 58, 1, 'iconreport.png', 'EN'),
(197, 'APRPTOPW', 'OtherPaymentWithoutItemList', '88', '3', 0, 'othersPayment/otherpaywithoutList', '0', '', 59, 1, 'iconreport.png', 'EN'),
(198, 'GLRPBGLT', 'Budgetlist', '88', '1', 0, 'glreports/budgetList', '0', '', 70, 1, 'iconreport.png', 'EN'),
(200, 'SOTRNWSO', 'SalesOrder', '152', '5', 0, 'sotransaction/salesOrderList', '0', '', 10, 1, 'icon-transaction.png', 'EN'),
(201, 'INVLOCTR', 'LocationTransfer', '148', '4', 0, 'locationtransfer/add', '0', '', 6, 1, 'i-film', 'EN'),
(202, 'INVSALEP', 'SalesPricing', '91', '5', 0, 'soreport/SalesPriceList', '0', '', 12, 1, 'iconreport.png', 'EN'),
(203, 'INVPURPR', 'PurchasePricing', '91', '4', 0, 'purchasepricing', '0', '', 10, 1, 'i-pen ', 'EN'),
(204, 'INVITEMC', 'ItemCountAdjust', '148', '4', 0, 'itemcountadjust', '0', '', 8, 1, 'i-pen ', 'EN'),
(207, 'CSSYSGEN', 'SystemGeneral', '93', '0', 0, 'systemgeneral/generalSetup', '0', '', 31, 1, 'i-pen ', 'EN'),
(208, 'APRPTSTL', 'SupplierStatementList', '87', '3', 0, 'supplierStatement/supplierList', '0', '', 53, 1, 'iconreport.png', 'EN'),
(209, 'SOTRQOLT', 'Salesquotelist', '106', '5', 0, 'soreport/SalesQuotationList', '0', 'ALL', 17, 1, 'iconreport.png', 'EN'),
(210, 'SOSTSLPC', 'Salesprice', '105', '5', 0, 'soreport/SalesPriceList', '0', '', 10, 1, 'iconsetupsub.png', 'EN'),
(211, 'SORPPCLT', 'Salesprice', '106', '5', 0, 'soreport/SalesPrice', '0', '', 10, 1, 'iconreport.png', 'EN'),
(212, 'CHAOFACC', 'ChartOfAccountSetup', '93', '1', 0, 'setting/chartOfAccountsSetup', '0', '', 29, 1, 'i-film', 'EN'),
(216, 'SOTRDOLT', 'DeliveryOrderList', '106', '5', 0, 'sotransaction/SalesDOList', '0', 'ALL', 19, 1, 'iconreport.png', 'EN'),
(217, 'SOTRDO', 'DeliveryOrder', '152', '5', 0, 'sotransaction/SalesDO', '0', 'ALL', 40, 1, 'icon-transaction.png', 'EN'),
(218, 'PURORDER', 'PurchaseOrder', '147', '5', 0, 'PO_Transaction/newPO', '0', '', 6, 1, 'icon-transaction.png', 'EN'),
(219, 'PURORLST', 'PurchaseOrderList', '52', '5', 0, 'purchaseReports/poList', '0', '', 7, 1, 'iconreport.png', 'EN'),
(220, 'PURRCV', 'PurchaseReceive', '147', '5', 0, 'receiveItems/newITemReceived', '0', '', 9, 1, 'i-pen ', 'EN'),
(224, 'APPURINV', 'PurchaseInvoice', '124', '3', 0, 'aptransaction/purchaseinvoice', '0', '', 19, 1, 'i-pen ', 'EN'),
(225, 'APDIRINV', 'DirectPurchaseInvoice', '124', '3', 0, 'purchasetransaction/invoices', '0', '', 20, 1, 'icon-transaction.png', 'EN'),
(226, 'APDRINVC', 'DirectPurchaseInvoiceConfirm', '124', '3', 0, 'purchasetransaction/invoicesConfirm', '0', '', 22, 1, 'icon-transaction.png', 'EN'),
(227, 'ARSALINV', 'SalesInvoice', '131', '2', 0, 'artransaction/salesinvoice', '0', '', 10, 1, 'icon-transaction.png', 'EN'),
(229, 'ARSDBN', 'SalesDebitNote', '131', '2', 0, 'artransaction/newSaleDebitNote', '0', '', 19, 1, 'icon-transaction.png', 'EN'),
(230, 'ARDBNC', 'SalesDebitNoteConfirm', '131', '2', 0, 'artransaction/salesdebitnotePost', '0', '', 20, 1, 'i-pen ', 'EN'),
(231, 'ARSCN', 'SalesCreditNote', '131', '2', 0, 'artransaction/newSaleCreditNote', '0', '', 21, 1, 'i-pen ', 'EN'),
(232, 'ARSCNC', 'SalesCreditNoteConfirm', '131', '2', 0, 'artransaction/salescreditnotePost', '0', '', 22, 1, 'icon-transaction.png', 'EN'),
(233, 'ARRCVP', 'ReceivePayment', '131', '2', 0, 'artransaction/newReceivePayment', '0', '', 23, 1, 'icon-transaction.png', 'EN'),
(234, 'ARRCVPC', 'ReceivePaymentConfirm', '131', '2', 0, 'artransaction/receivedPaymentPost', '0', '', 24, 1, 'icon-transaction.png', 'EN'),
(235, 'ARINVLST', 'DirectSalesInvoiceList', '89', '2', 0, 'salesInvoice/salesInvoiceList', '0', '', 18, 1, 'iconreport.png', 'EN'),
(236, 'ARDBNLST', 'SalesDebitNoteList', '89', '2', 0, 'salesInvoice/salesdebitnotelist', '0', '', 26, 1, 'iconreport.png', 'EN'),
(237, 'ARCDNLST', 'SalesCreditNoteList', '89', '2', 0, 'salesInvoice/salescreditnoteList', '0', '', 27, 1, 'iconreport.png', 'EN'),
(238, 'ARRCVPLS', 'ReceivePaymentList', '89', '2', 0, 'companySetup/compRecPaymentList/rpt', '0', '', 28, 1, 'iconreport.png', 'EN'),
(239, 'ARDSLINV', 'NewDirectSaleInvoice', '131', '2', 0, 'arTransaction/newDirectSaleInvoice', '0', '', 13, 1, 'icon-transaction.png', 'EN'),
(240, 'AGENTSTP', 'AgentSetup', '5', '0', 0, 'saleagentSetup/agentList', '0', '', 32, 1, 'iconcompanysetup.png', 'EN'),
(241, 'SOTRSOLT', 'Saleslist', '106', '5', 0, 'soreport/SalesOrderList', '0', 'ALL', 18, 1, 'iconreport.png', 'EN'),
(243, 'INVPLNRP', 'InventoryPlanningReport', '92', '4', 0, 'inventory/rptstatus', '0', '', 81, 1, 'iconreport.png', 'EN'),
(244, 'INVVALRP', 'InventoryValuationReport', '92', '4', 0, '#', '0', '', 82, 1, 'iconreport.png', 'EN'),
(245, 'INVSTORP', 'StockCheckReport', '92', '4', 0, 'inventory/stocklist', '0', '', 84, 1, 'iconreport.png', 'EN'),
(248, 'INVOUTRP', 'OutstandingGRNReport', '92', '4', 0, 'inventory/rptgrnvaluation', '0', '', 87, 1, 'iconreport.png', 'EN'),
(249, 'INVMOVRP', 'InventoryMovementReport', '92', '4', 0, 'inventory/rptmovement', '0', '', 88, 1, 'iconreport.png', 'EN'),
(250, 'INVLSTRP', 'InventoryList', '92', '4', 0, 'inventory/rptbylocation', '0', '', 89, 1, 'iconreport.png', 'EN'),
(251, 'PURORDCF', 'PurchaseOrderConfirm', '147', '5', 0, 'po_transaction/poList/post', '0', '', 8, 1, 'icon-transaction.png', 'EN'),
(252, 'PURRCVC', 'PurchaseReceiveConfirm', '147', '5', 0, 'purchasetransaction/receiveItemPosting', '0', '', 10, 1, 'icon-transaction.png', 'EN'),
(253, 'PURRCVLS', 'PurchaseReceiveList', '52', '5', 0, 'receiveItems/receiveItemList2', '0', '', 8, 1, 'iconreport.png', 'EN'),
(255, 'GLSTCURC', 'Currencyconversion', '46', '1', 0, 'glsetting/currencyConvertion', '0', '', 50, 1, 'iconsetupsub.png', 'EN'),
(256, 'ARDRSINV', 'SaleInvoiceConfirm', '131', '2', 0, 'artransaction/directsalesinvPost', '0', '', 15, 1, 'icon-transaction.png', 'EN'),
(257, 'TXTRPROC', 'GAFFiles', '151', '0', 0, 'taxTransaction/processGAF', '0', '', 10, 1, 'icon-transaction.png', 'EN'),
(258, 'APPURINV', 'PurchaseInvoiceList', '87', '3', 0, 'purchasetransaction/purchaseinvoicelist', '0', '', 25, 1, 'iconreport.png', 'EN'),
(259, 'SORPSOCU', 'Salesbycustomer', '106', '5', 0, 'soreport/SalesByCustomer', '0', '', 20, 1, 'iconreport.png', 'EN'),
(260, 'DELCNFRM', 'DeliveryOrderConfirm', '152', '0', 0, 'sotransaction/salesDOPost', '0', '', 42, 1, 'icon-transaction.png', 'EN'),
(261, 'SORPYRSL', 'SalesbycustomerYears', '106', '5', 0, 'soreport/SalesByCustomerYears', '0', '', 25, 1, 'iconreport.png', 'EN'),
(263, 'SORPSLIT', 'Salesbyitem', '106', '5', 0, 'soreport/SalesByItem', '0', '', 26, 1, 'iconreport.png', 'EN'),
(264, 'INVLOCTC', 'LocationTransferConfirm', '148', '4', 0, 'locationtransfer/locationtransfer', '0', '', 7, 1, 'i-film', 'EN'),
(265, 'INVITCC', 'ItemCountAdjustConfirm', '148', '4', 0, 'itemcountadjust/confirm', '0', '', 9, 1, 'i-film', 'EN'),
(266, 'INVSALC', 'SalesPricingConfirm', '148', '4', 0, '#', '0', '', 13, 0, 'i-film', 'EN'),
(267, 'INVPURCC', 'PurchasePricingConfirm', '148', '4', 0, '#', '0', '', 11, 0, 'i-film', 'EN'),
(268, 'IVSTCKCS', 'StockCountSheet', '92', '4', 0, 'countsheet', '0', '', 83, 1, 'iconreport.png', 'EN'),
(269, 'LTL', 'LocationTransferList', '92', '4', 0, 'locationtransfer/report', '0', '', 10, 1, 'iconreport.png', 'EN'),
(270, 'ICAA', 'ItemCountAndAdjustmentList', '92', '4', 0, 'itemcountadjust/report', '0', '', 20, 1, 'iconreport.png', 'EN'),
(272, 'BNKSETUP', 'BankSetup', '5', '10', 0, 'bankSetup/bankList', '0', '', 78, 1, 'iconcompanysetup.png', 'EN'),
(274, 'ZKTSTGRP', 'Zakatgroup', '108', '7', 0, 'zakatsetup/Group', '0', '', 30, 1, 'iconsetupsub.png', 'EN'),
(275, 'ZKTSTNSB', 'nisab', '108', '7', 0, 'zakatsetup/nisab', '0', NULL, 20, 1, 'iconsetupsub.png', 'EN'),
(276, 'ZKTRGPLT', 'Zakatgrouplist', '109', '7', 0, 'zakatreport/groupList', '0', '', 20, 1, 'iconreport.png', 'EN'),
(277, 'ZKTSTNSD', 'Nisabdetails', '108', '7', 0, 'zakatsetup/NisabDetails', '0', '', 10, 1, 'iconsetupsub.png', 'EN'),
(278, 'ZKTTRANS', 'Transaction', '84', '7', 1, '#', '0', '', 20, 1, 'icon-transaction.png', 'EN'),
(279, 'ZKTTRCAL', 'Zakatcalculate', '278', '7', 0, 'zakatTransaction/Calculation', '0', '', 10, 1, 'icon-transaction.png', 'EN'),
(280, 'ZKSTCNTR', 'Zakatcenter', '108', '7', 0, 'zakatsetup/Center', '0', '', 55, 1, 'iconsetupsub.png', 'EN'),
(281, 'ZKRPCTRL', 'Zakatcenter', '109', '7', 0, 'zakatreport/centerList', '0', '', 10, 1, 'iconreport.png', 'EN'),
(282, 'ZKRPNBLT', 'Zakatnisab', '109', '7', 0, 'zakatreport/nisabList', '0', '', 5, 1, 'iconreport.png', 'EN'),
(283, 'ZKRPSMLT', 'Zakatsummary', '109', '7', 0, 'zakatreport/zakatSummaryList', '0', '', 80, 1, 'iconreport.png', 'EN'),
(284, 'PUROUTGR', 'OutstandingGRNReport', '52', '5', 0, 'inventory/rptgrnvaluation', '0', '', 9, 1, 'iconreport.png', 'EN'),
(285, 'WKSTMSTR', 'Wakafsetup', '108', '7', 0, 'wakafsetup/wakaf_acrual_list', '0', '', 60, 1, 'iconsetupsub.png', 'EN'),
(286, 'ARCUSTST', 'CustomerStatement', '89', '2', 0, 'customerStatement/customerList', '0', '', 29, 1, 'iconreport.png', 'EN'),
(287, 'ARCPYSI', 'copySalesInvoice', '131', '2', 0, 'arinvoiceclone', '0', '', 14, 1, 'i-film', 'EN'),
(288, 'APCPYPI', 'copyPurchaseInvoice', '124', '3', 0, 'apinvoiceclone', '0', '', 21, 1, 'i-film', 'EN'),
(289, 'SORPORCT', 'Salesorderbycustomer', '106', '5', 0, 'soreport/SalesOrderByCustomer', '0', '', 60, 1, 'iconreport.png', 'EN'),
(290, 'SORPSOIT', 'Salesorderbyitem', '106', '5', 0, 'soreport/SalesOrderByItem', '0', '', 65, 1, 'iconreport.png', 'EN'),
(292, 'SORPOROT', 'Salesorderoutstandingbyitem', '106', '5', 0, 'soreport/SalesOrderOutstandingByItem', '0', '', 75, 1, 'iconreport.png', 'EN'),
(294, 'APBANKRE', 'BankReconciliation', '88', '3', 0, 'BankReconciliation', '0', '', 57, 1, 'i-film', 'EN'),
(295, 'WCQCNTR', 'WaqafCenter', '108', '0', 0, 'waqafsetup/waqaflist', '0', '', 61, 1, 'iconsetupsub.png', 'EN'),
(297, 'WKFCAL', 'wakafCalculation', '278', '0', 0, 'wakafSetup/newwakaf', '0', '', 11, 1, 'i-film', 'EN'),
(298, 'WKFLST', 'wakafList', '109', '0', 0, 'wakafSetup/wakafList', '0', '', 81, 1, 'iconreport.png', 'EN'),
(299, 'APDRNOTE', 'PurchaseDebitNoteEdit', '124', '3', 0, 'aptransaction/editDebitNote', '0', '', 100, 0, 'icon-transaction.png', 'EN'),
(302, 'GLTRYECL', 'YearEndClose', '150', '1', 0, 'Gltransaction/YearEndClose', '0', '0', 90, 1, 'icon-transaction.png', 'EN'),
(304, 'LOGRPT', 'LogReport', '12', '9', 0, 'logreport', '0', '0', 5, 1, 'iconreport.png', 'EN'),
(305, 'USRGD', 'UserGuide', '0', '0', 0, 'userguide', '0', '0', 1000, 1, 'i-film', 'EN'),
(306, 'APTRETCR', 'EditCreditNote', '124', '3', 0, 'aptransaction/editCreditNote/19', '0', '0', 55, 0, 'i-film', 'EN'),
(307, 'APTRPYIE', 'EditOtherPaymentWithItem', '124', '3', 0, 'othersPayment/editpaywithitem', '0', '0', 70, 0, 'i-film', 'EN'),
(308, 'APTRPYOE', 'EditOtherPaymentWithoutItem', '124', '3', 0, 'othersPayment/editpaywithoutitem', '0', '0', 71, 0, 'i-film', 'EN'),
(309, 'UMACCSS', 'Useraccess', '12', '9', 0, 'admin/user_access', '0', '0', 3, 0, 'i-film', 'EN'),
(310, 'ADMMENU', 'Menumaster', '12', '9', 0, 'admin/menumaster', '0', '0', 30, 0, 'i-film', 'EN'),
(311, 'ARTRINED', 'EditDirectSaleInvoice', '131', '2', 0, 'artransaction/editDirectSaleInvoice', '0', '0', 20, 0, 'i-film', 'EN'),
(312, 'AREDSLDR', 'EditSalesDebitNote', '131', '2', 0, 'artransaction/editSaleDebitNote', '0', '0', 50, 0, 'i-film', 'EN'),
(313, 'AREDCR', 'EditSalesCreditNote', '131', '2', 0, 'artransaction/editSaleCreditNote', '0', '0', 50, 0, 'i-film', 'EN'),
(314, 'ARPAYEDT', 'EditPayment', '131', '2', 0, 'artransaction/editReceivePayment', '0', '0', 70, 0, 'i-film', 'EN'),
(315, 'ADMBNKMS', 'BankMaster', '5', '8', 0, 'bankSetup/BankNew', '0', '0', 80, 0, 'i-film', 'EN'),
(316, 'ARNWCUST', 'NewCustomer', '86', '2', 0, 'customerSetup/CustomerNew', '0', '0', 70, 0, 'i-film', 'EN'),
(317, 'ARSHIP2L', 'ShiptoList', '86', '2', 0, 'customerSetup/shiptolist', '0', '0', 40, 0, 'i-film', 'EN'),
(318, 'ARSHIP2N', 'NewShipto', '86', '2', 0, 'CustomerSetup/shiptoNew', '0', '0', 42, 0, 'i-film', 'EN'),
(319, 'INEDITEM', 'EditItem', '91', '4', 0, 'icsetting/item_id', '0', '0', 40, 0, 'i-film', 'EN'),
(320, 'INNWITEM', 'NewItem', '91', '4', 0, 'icsetting/itemNew', '0', '0', 40, 0, 'i-film', 'EN'),
(321, 'GST03', 'gst03', '103', '6', 0, 'gst03', '0', '0', 82, 1, 'i-film', 'EN'),
(322, 'ARCUSTAG', 'CustomerAging', '89', '2', 0, 'arreports/customerAging', '0', '0', 30, 1, 'i-film', 'EN'),
(323, 'gstrpt', 'gstReport', '103', '6', 0, 'gstReport', '0', '0', 81, 1, 'i-film', 'EN'),
(324, 'GSPRJNW', 'ProjectSetup', '5', '10', 0, 'project/ProjectSetup', '0', '0', 30, 0, 'i-film', 'EN'),
(325, 'APNEWSUP', 'NewSupplier', '85', '3', 0, 'supplier/SupplierNew', '0', '0', 50, 0, 'i-film', 'EN'),
(326, 'APNWSHP2', 'SupplierShipto', '85', '3', 0, 'supplier/shiptoNew', '0', '0', 53, 0, 'i-film', 'EN'),
(327, 'ItemDetR', 'Itemdetails', '92', '4', 0, 'icsetting/ItemDetails', '0', '0', 6, 1, 'i-film', 'EN'),
(328, 'UMCONVNW', 'UMConversion', '51', '8', 0, 'purchasesetting/umconversion', '0', '0', 70, 0, 'i-film', 'EN'),
(329, 'WCQCTRNW', 'NewWakafCenter', '108', '7', 0, 'waqafSetup/WaqafNew', '0', '0', 30, 0, 'i-film', 'EN'),
(330, 'PUPRRPT', 'purchasePricingReport', '52', '5', 0, 'purchasepricing/report', '0', NULL, 5, 1, 'i-film', 'EN'),
(331, 'TERMNEW', 'TermNew', '5', '10', 0, 'term/TermSetup', '0', '0', 40, 0, 'i-film', 'EN');

DELIMITER $$
--
-- Events
--
CREATE DEFINER=`root`@`localhost` EVENT `countSupplierBalance` ON SCHEDULE EVERY 1 MONTH STARTS '2014-06-25 16:43:47' ON COMPLETION PRESERVE ENABLE DO insert into comp_supplier_closing (companyID, supplierID, yearMonth,openBalance,totalDr,totalCr,balance)
	select c.companyID, c.ID as supplierID, date_format(now(),"%Y%m") as yearMonth, 
	coalesce(b.openBalance,0) as openBalance, coalesce(sum(a.dr),0) as totalDr, 
	coalesce(sum(a.cr),0) as totalCr, 
	coalesce(b.openBalance,0) - coalesce(sum(a.dr),0) - coalesce(sum(a.cr),0) as balance
	from (supplier c left outer join view_supplier_statement a on c.ID = a.supplierID 
	and date_format(a.transDate,"%Y%m") = date_format(now(),"%Y%m")) 
	left outer join comp_supplier_closing b on a.supplierID = b.supplierID
	and a.companyID = b.companyID 
	and b.yearMonth = date_format(a.transDate - interval 1 month,"%Y%m")
	
	group by c.id, a.companyID$$

CREATE DEFINER=`root`@`localhost` EVENT `countSupplierBalanceDaily` ON SCHEDULE EVERY 1 DAY STARTS '2014-06-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO insert into comp_supplier_closing_daily (companyID, supplierID, transDate,openBalance,totalDr,totalCr,balance)
	select c.companyID, c.ID as supplierID,  date_format(now(),"%Y%m%d") as transDate, 
	coalesce(b.openBalance,0) as openBanlance, coalesce(sum(a.dr),0) as totalDr, 
	coalesce(sum(a.cr),0) as totalCr, 
	coalesce(b.openBalance,0) - coalesce(sum(a.dr),0) - coalesce(sum(a.cr),0) as balance 
	from (supplier c left outer join view_supplier_statement a on c.ID = a.supplierID 
		and date_format(a.transDate,"%Y%m%d") = date_format(now(),"%Y%m%d")) 
		left outer join comp_supplier_closing_daily b on a.supplierID = b.supplierID and a.companyID = b.companyID 
		and b.transDate = a.transDate - interval 1 day 
	group by c.id, a.companyID$$

DELIMITER ;

