DELIMITER $$

DROP PROCEDURE IF EXISTS `echodubai_acc2018`.`Procedure_FetchLedger` $$
CREATE DEFINER=`root`@`%` PROCEDURE `Procedure_FetchLedger`(

/*  Basic */
In  inp_encodingmode        varchar(100) ,        /*  utf8  utf-8 etc... */
In  inp_useraccount         varchar(200) ,        /*  $_SESSION['useraccount']*/
In  inp_dblabel             varchar(200) ,        /*      $_SESSION['dbLabel'].".ledgerstk  */

/*Ledger Include */


in  inp_ledgerInclude       varchar(1)   ,        /*      Ledger Include   y  / n                                  */


/*Belong To Group */
In   inp_ledgerbelongtoground   varchar(1) ,       /* Belong To Group */


/*is Grp Det */
In   inp_isgrpdet   varchar(1) ,       /* grp det  0 for 0 1 for 1 empty for boh */


/* Ledger Type */
In   inp_ledgerype varchar(50) ,     /* ledger type ex All , Clients  , suppliers , salesmen , student , other





/*  Fields */
IN inp_tag                 varchar(25),    /* Tag 'primarykey' or 'description'*/
IN inp_term                varchar(500),   /* Term related to tag*/
IN inp_otherterm           varchar(500)   /* Other Term related to second term */









)
BEGIN


SELECT Ledger.* from Ledger;


END $$

DELIMITER ;