CREATE TABLE dbo.main_gr (
    iGr                            smallint                                not  null 
  , Name                           varchar                        ( 100 )    not  null 
  , s_Kod                          varchar                        ( 10 )      null 
  , stored                          char                            ( 1 )       null 
  , hlev                           smallint                                 null 
  , is_filial                       char                            ( 1 )       null 
  , is_ru                           char                            ( 1 )       null 
  , is_nbu                          char                            ( 1 )       null 
  , Bizn                           smallint                                 null 
  , Bizn_iGr_Par                   smallint                                 null 
  , bizn_ns                         char                            ( 1 )       null 
  , gr                              char                            ( 2 )       null 
  , ru                              char                            ( 1 )       null 
  , Is_Otd                          char                            ( 1 )       null 
  , Is_TOBO                         char                            ( 1 )       null 
  , is_ukr                          char                            ( 1 )       null 
  , ibank                          smallint                                not  null 
  , BBN_BNMN                        char                            ( 2 )      not  null 
  , BFL_CNA                         char                            ( 2 )      not  null 
  )

 package  test_app;

 public   class  Main_gr {

     private  Integer iGr;
     private  Integer hlev;
     private  String s_kod;
     private  String Name;

     public  Main_gr() {
    }


      public  Integer getiGr() {
         return  iGr;
    }
     public   void  setiGr(Integer iGr) {
            this .iGr=iGr;
       }

     public  Integer gethlev() {
          return  hlev;
     }

     public   void  sethlev(Integer hlev) {
                this .hlev=hlev;
       }

     public  String gets_kod() {
         return  s_kod;
    }

     public   void  sets_kod(String s_kod) {
                    this .s_kod=s_kod;
       }

     public  String getName() {
        return  Name;
   }

    public   void  setName(String Name) {
                      this .Name=Name;
       }

     public  String toString() {
         return  "iGr=" + iGr + ", s_kod=" +s_kod + ", hlev=" + hlev+ ", name=" + Name;
    }
}