jurn_pos_sert2022.mrt 70 KB
{"ReportVersion":"2018.2.1","ReportGuid":"ee3d159f3f904e5a400fd42ff137bf4c","ReportName":"Report","ReportAlias":"Report","ReportFile":"jurn_pos_sert2022.mrt","ReportCreated":"/Date(1523997817000+0300)/","ReportChanged":"/Date(1523997817000+0300)/","EngineVersion":"EngineV2","CalculationMode":"Interpretation","ReportUnit":"Centimeters","Dictionary":{"Variables":{"0":{"Value":"IIF(Day(dp2_zajavka_obsteg.zajav_date)<10, \"0\"+Day(dp2_zajavka_obsteg.zajav_date), Day(dp2_zajavka_obsteg.zajav_date))","Name":"day_zajav_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"day_zajav_date","Type":"System.String","InitBy":"Expression"},"1":{"Value":"IIF(Month(dp2_zajavka_obsteg.zajav_date)<10, \"0\"+Month(dp2_zajavka_obsteg.zajav_date), Month(dp2_zajavka_obsteg.zajav_date))","Name":"month_zajav_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"month_zajav_date","Type":"System.String","InitBy":"Expression"},"2":{"Value":"IIF(Day(dp2_zajavka_obsteg.resh_cert_date)<10, \"0\"+Day(dp2_zajavka_obsteg.resh_cert_date), Day(dp2_zajavka_obsteg.resh_cert_date))","Name":"day_resh_cert_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"day_resh_cert_date","Type":"System.String","InitBy":"Expression"},"3":{"Value":"IIF(Month(dp2_zajavka_obsteg.resh_cert_date)<10, \"0\"+Month(dp2_zajavka_obsteg.resh_cert_date), Month(dp2_zajavka_obsteg.resh_cert_date))","Name":"month_resh_cert_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"month_resh_cert_date","Type":"System.String","InitBy":"Expression"}},"DataSources":{"0":{"Ident":"StiMySqlSource","Name":"k2firms","Alias":"k2firms","Columns":{"0":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"1":{"Name":"adress_firm","Index":-1,"NameInSource":"adress_firm","Alias":"adress_firm","Type":"System.String"},"2":{"Name":"bankname","Index":-1,"NameInSource":"bankname","Alias":"bankname","Type":"System.String"},"3":{"Name":"code1с","Index":-1,"NameInSource":"code1с","Alias":"code1с","Type":"System.String"},"4":{"Name":"codfil","Index":-1,"NameInSource":"codfil","Alias":"codfil","Type":"System.String"},"5":{"Name":"comment","Index":-1,"NameInSource":"comment","Alias":"comment","Type":"System.String"},"6":{"Name":"directorname","Index":-1,"NameInSource":"directorname","Alias":"directorname","Type":"System.String"},"7":{"Name":"directorname_r","Index":-1,"NameInSource":"directorname_r","Alias":"directorname_r","Type":"System.String"},"8":{"Name":"directorname_short","Index":-1,"NameInSource":"directorname_short","Alias":"directorname_short","Type":"System.String"},"9":{"Name":"docstatut","Index":-1,"NameInSource":"docstatut","Alias":"docstatut","Type":"System.String"},"10":{"Name":"dolgndir","Index":-1,"NameInSource":"dolgndir","Alias":"dolgndir","Type":"System.String"},"11":{"Name":"dolgndir_r","Index":-1,"NameInSource":"dolgndir_r","Alias":"dolgndir_r","Type":"System.String"},"12":{"Name":"edrpou","Index":-1,"NameInSource":"edrpou","Alias":"edrpou","Type":"System.String"},"13":{"Name":"email","Index":-1,"NameInSource":"email","Alias":"email","Type":"System.String"},"14":{"Name":"firmid","Index":-1,"NameInSource":"firmid","Alias":"firmid","Type":"System.String"},"15":{"Name":"ipn","Index":-1,"NameInSource":"ipn","Alias":"ipn","Type":"System.String"},"16":{"Name":"ismycompany","Index":-1,"NameInSource":"ismycompany","Alias":"ismycompany","Type":"System.Int16"},"17":{"Name":"ismycompany","Index":-1,"NameInSource":"ismycompany","Alias":"ismycompany","Type":"System.Int32"},"18":{"Name":"mfo","Index":-1,"NameInSource":"mfo","Alias":"mfo","Type":"System.String"},"19":{"Name":"name_firm","Index":-1,"NameInSource":"name_firm","Alias":"name_firm","Type":"System.String"},"20":{"Name":"phone_firm","Index":-1,"NameInSource":"phone_firm","Alias":"phone_firm","Type":"System.String"},"21":{"Name":"projid","Index":-1,"NameInSource":"projid","Alias":"projid","Type":"System.Int16"},"22":{"Name":"raschschet","Index":-1,"NameInSource":"raschschet","Alias":"raschschet","Type":"System.String"},"23":{"Name":"rayid","Index":-1,"NameInSource":"rayid","Alias":"rayid","Type":"System.String"},"24":{"Name":"siteid","Index":-1,"NameInSource":"siteid","Alias":"siteid","Type":"System.Int16"},"25":{"Name":"svidnum","Index":-1,"NameInSource":"svidnum","Alias":"svidnum","Type":"System.String"},"26":{"Name":"typefirmid","Index":-1,"NameInSource":"typefirmid","Alias":"typefirmid","Type":"System.Int16"},"27":{"Name":"typefirmid","Index":-1,"NameInSource":"typefirmid","Alias":"typefirmid","Type":"System.Int32"}},"NameInSource":"k2","SqlCommand":"select * from k2firms where firmid=\"{mainfirmid}\""},"1":{"Ident":"StiMySqlSource","Name":"dp2_zajavka_obsteg","Alias":"dp2_zajavka_obsteg","Columns":{"0":{"Name":"CodKult","Index":-1,"NameInSource":"CodKult","Alias":"CodKult","Type":"System.String"},"1":{"Name":"Kultura","Index":-1,"NameInSource":"Kultura","Alias":"Kultura","Type":"System.String"},"2":{"Name":"NameUA","Index":-1,"NameInSource":"NameUA","Alias":"NameUA","Type":"System.String"},"3":{"Name":"NameUA1","Index":-1,"NameInSource":"NameUA1","Alias":"NameUA1","Type":"System.String"},"4":{"Name":"NameUA2","Index":-1,"NameInSource":"NameUA2","Alias":"NameUA2","Type":"System.String"},"5":{"Name":"NameUA3","Index":-1,"NameInSource":"NameUA3","Alias":"NameUA3","Type":"System.String"},"6":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"7":{"Name":"OblastNameUA","Index":-1,"NameInSource":"OblastNameUA","Alias":"OblastNameUA","Type":"System.String"},"8":{"Name":"SortID","Index":-1,"NameInSource":"SortID","Alias":"SortID","Type":"System.String"},"9":{"Name":"SortID1","Index":-1,"NameInSource":"SortID1","Alias":"SortID1","Type":"System.String"},"10":{"Name":"SortID2","Index":-1,"NameInSource":"SortID2","Alias":"SortID2","Type":"System.String"},"11":{"Name":"SortID3","Index":-1,"NameInSource":"SortID3","Alias":"SortID3","Type":"System.String"},"12":{"Name":"VirobnikNameUA","Index":-1,"NameInSource":"VirobnikNameUA","Alias":"VirobnikNameUA","Type":"System.String"},"13":{"Name":"act_auditor_fio","Index":-1,"NameInSource":"act_auditor_fio","Alias":"act_auditor_fio","Type":"System.String"},"14":{"Name":"act_brak_fio","Index":-1,"NameInSource":"act_brak_fio","Alias":"act_brak_fio","Type":"System.String"},"15":{"Name":"act_date","Index":-1,"NameInSource":"act_date","Alias":"act_date","Type":"System.DateTime"},"16":{"Name":"act_n","Index":-1,"NameInSource":"act_n","Alias":"act_n","Type":"System.String"},"17":{"Name":"address_jur","Index":-1,"NameInSource":"address_jur","Alias":"address_jur","Type":"System.String"},"18":{"Name":"agr_aud_fio","Index":-1,"NameInSource":"agr_aud_fio","Alias":"agr_aud_fio","Type":"System.String"},"19":{"Name":"agronomid","Index":-1,"NameInSource":"agronomid","Alias":"agronomid","Type":"System.String"},"20":{"Name":"akt_brak_auditid","Index":-1,"NameInSource":"akt_brak_auditid","Alias":"akt_brak_auditid","Type":"System.String"},"21":{"Name":"akt_brak_date","Index":-1,"NameInSource":"akt_brak_date","Alias":"akt_brak_date","Type":"System.DateTime"},"22":{"Name":"akt_brak_n","Index":-1,"NameInSource":"akt_brak_n","Alias":"akt_brak_n","Type":"System.String"},"23":{"Name":"akt_pol_ocen_auditid","Index":-1,"NameInSource":"akt_pol_ocen_auditid","Alias":"akt_pol_ocen_auditid","Type":"System.String"},"24":{"Name":"akt_pol_ocen_date","Index":-1,"NameInSource":"akt_pol_ocen_date","Alias":"akt_pol_ocen_date","Type":"System.DateTime"},"25":{"Name":"akt_pol_ocen_n","Index":-1,"NameInSource":"akt_pol_ocen_n","Alias":"akt_pol_ocen_n","Type":"System.String"},"26":{"Name":"cat_name","Index":-1,"NameInSource":"cat_name","Alias":"cat_name","Type":"System.String"},"27":{"Name":"cat_name_use","Index":-1,"NameInSource":"cat_name_use","Alias":"cat_name_use","Type":"System.String"},"28":{"Name":"catid","Index":-1,"NameInSource":"catid","Alias":"catid","Type":"System.String"},"29":{"Name":"cert_date","Index":-1,"NameInSource":"cert_date","Alias":"cert_date","Type":"System.DateTime"},"30":{"Name":"cert_dateto","Index":-1,"NameInSource":"cert_dateto","Alias":"cert_dateto","Type":"System.DateTime"},"31":{"Name":"cert_n","Index":-1,"NameInSource":"cert_n","Alias":"cert_n","Type":"System.String"},"32":{"Name":"cert_podg","Index":-1,"NameInSource":"cert_podg","Alias":"cert_podg","Type":"System.String"},"33":{"Name":"cert_podg_aud_fio","Index":-1,"NameInSource":"cert_podg_aud_fio","Alias":"cert_podg_aud_fio","Type":"System.String"},"34":{"Name":"clone_name","Index":-1,"NameInSource":"clone_name","Alias":"clone_name","Type":"System.String"},"35":{"Name":"cpn_b","Index":-1,"NameInSource":"cpn_b","Alias":"cpn_b","Type":"System.String"},"36":{"Name":"cpn_k","Index":-1,"NameInSource":"cpn_k","Alias":"cpn_k","Type":"System.String"},"37":{"Name":"cpn_z","Index":-1,"NameInSource":"cpn_z","Alias":"cpn_z","Type":"System.String"},"38":{"Name":"datecreate","Index":-1,"NameInSource":"datecreate","Alias":"datecreate","Type":"System.DateTime"},"39":{"Name":"dateupdate","Index":-1,"NameInSource":"dateupdate","Alias":"dateupdate","Type":"System.DateTime"},"40":{"Name":"doc_mayna_date","Index":-1,"NameInSource":"doc_mayna_date","Alias":"doc_mayna_date","Type":"System.DateTime"},"41":{"Name":"doc_mayna_n","Index":-1,"NameInSource":"doc_mayna_n","Alias":"doc_mayna_n","Type":"System.String"},"42":{"Name":"doc_yakost_date","Index":-1,"NameInSource":"doc_yakost_date","Alias":"doc_yakost_date","Type":"System.DateTime"},"43":{"Name":"doc_yakost_num","Index":-1,"NameInSource":"doc_yakost_num","Alias":"doc_yakost_num","Type":"System.String"},"44":{"Name":"dolgnname","Index":-1,"NameInSource":"dolgnname","Alias":"dolgnname","Type":"System.String"},"45":{"Name":"dp_posad_name","Index":-1,"NameInSource":"dp_posad_name","Alias":"dp_posad_name","Type":"System.String"},"46":{"Name":"dstu_name","Index":-1,"NameInSource":"dstu_name","Alias":"dstu_name","Type":"System.String"},"47":{"Name":"dstuid","Index":-1,"NameInSource":"dstuid","Alias":"dstuid","Type":"System.String"},"48":{"Name":"fio","Index":-1,"NameInSource":"fio","Alias":"fio","Type":"System.String"},"49":{"Name":"firmid","Index":-1,"NameInSource":"firmid","Alias":"firmid","Type":"System.String"},"50":{"Name":"fullname","Index":-1,"NameInSource":"fullname","Alias":"fullname","Type":"System.String"},"51":{"Name":"generation_name","Index":-1,"NameInSource":"generation_name","Alias":"generation_name","Type":"System.String"},"52":{"Name":"generation_name_use","Index":-1,"NameInSource":"generation_name_use","Alias":"generation_name_use","Type":"System.String"},"53":{"Name":"generationid","Index":-1,"NameInSource":"generationid","Alias":"generationid","Type":"System.String"},"54":{"Name":"generationid_use","Index":-1,"NameInSource":"generationid_use","Alias":"generationid_use","Type":"System.String"},"55":{"Name":"is_cert","Index":-1,"NameInSource":"is_cert","Alias":"is_cert","Type":"System.Decimal"},"56":{"Name":"is_cond","Index":-1,"NameInSource":"is_cond","Alias":"is_cond","Type":"System.Decimal"},"57":{"Name":"k2firms_our","Index":-1,"NameInSource":"k2firms_our","Alias":"k2firms_our","Type":"System.String"},"58":{"Name":"kol_pack","Index":-1,"NameInSource":"kol_pack","Alias":"kol_pack","Type":"System.Decimal"},"59":{"Name":"mass_part","Index":-1,"NameInSource":"mass_part","Alias":"mass_part","Type":"System.Decimal"},"60":{"Name":"mesto","Index":-1,"NameInSource":"mesto","Alias":"mesto","Type":"System.String"},"61":{"Name":"mi_b","Index":-1,"NameInSource":"mi_b","Alias":"mi_b","Type":"System.String"},"62":{"Name":"mi_k","Index":-1,"NameInSource":"mi_k","Alias":"mi_k","Type":"System.String"},"63":{"Name":"mi_z","Index":-1,"NameInSource":"mi_z","Alias":"mi_z","Type":"System.String"},"64":{"Name":"name_typezajav","Index":-1,"NameInSource":"name_typezajav","Alias":"name_typezajav","Type":"System.String"},"65":{"Name":"name_typezajavk","Index":-1,"NameInSource":"name_typezajavk","Alias":"name_typezajavk","Type":"System.String"},"66":{"Name":"order_ins","Index":-1,"NameInSource":"order_ins","Alias":"order_ins","Type":"System.Int32"},"67":{"Name":"part_num","Index":-1,"NameInSource":"part_num","Alias":"part_num","Type":"System.String"},"68":{"Name":"pidschep","Index":-1,"NameInSource":"pidschep","Alias":"pidschep","Type":"System.String"},"69":{"Name":"podpis_zajavnik","Index":-1,"NameInSource":"podpis_zajavnik","Alias":"podpis_zajavnik","Type":"System.String"},"70":{"Name":"pole_num","Index":-1,"NameInSource":"pole_num","Alias":"pole_num","Type":"System.String"},"71":{"Name":"pov_auditor_fio","Index":-1,"NameInSource":"pov_auditor_fio","Alias":"pov_auditor_fio","Type":"System.String"},"72":{"Name":"prot_vypr_date","Index":-1,"NameInSource":"prot_vypr_date","Alias":"prot_vypr_date","Type":"System.DateTime"},"73":{"Name":"razmer_part","Index":-1,"NameInSource":"razmer_part","Alias":"razmer_part","Type":"System.Int32"},"74":{"Name":"razmer_part2","Index":-1,"NameInSource":"razmer_part2","Alias":"razmer_part2","Type":"System.Decimal"},"75":{"Name":"razmer_polya","Index":-1,"NameInSource":"razmer_polya","Alias":"razmer_polya","Type":"System.Decimal"},"76":{"Name":"resh_auditor_fio","Index":-1,"NameInSource":"resh_auditor_fio","Alias":"resh_auditor_fio","Type":"System.String"},"77":{"Name":"resh_cert_auditid","Index":-1,"NameInSource":"resh_cert_auditid","Alias":"resh_cert_auditid","Type":"System.String"},"78":{"Name":"resh_cert_date","Index":-1,"NameInSource":"resh_cert_date","Alias":"resh_cert_date","Type":"System.DateTime"},"79":{"Name":"resh_cert_fio","Index":-1,"NameInSource":"resh_cert_fio","Alias":"resh_cert_fio","Type":"System.String"},"80":{"Name":"resh_cert_otkaz_date","Index":-1,"NameInSource":"resh_cert_otkaz_date","Alias":"resh_cert_otkaz_date","Type":"System.DateTime"},"81":{"Name":"resh_cert_otkaz_n","Index":-1,"NameInSource":"resh_cert_otkaz_n","Alias":"resh_cert_otkaz_n","Type":"System.String"},"82":{"Name":"resh_cert_otkaz_podg","Index":-1,"NameInSource":"resh_cert_otkaz_podg","Alias":"resh_cert_otkaz_podg","Type":"System.String"},"83":{"Name":"resh_mog_cert_date","Index":-1,"NameInSource":"resh_mog_cert_date","Alias":"resh_mog_cert_date","Type":"System.DateTime"},"84":{"Name":"resh_mog_cert_n","Index":-1,"NameInSource":"resh_mog_cert_n","Alias":"resh_mog_cert_n","Type":"System.Int32"},"85":{"Name":"resh_mog_cert_podg","Index":-1,"NameInSource":"resh_mog_cert_podg","Alias":"resh_mog_cert_podg","Type":"System.String"},"86":{"Name":"typezajavid","Index":-1,"NameInSource":"typezajavid","Alias":"typezajavid","Type":"System.String"},"87":{"Name":"typezajavkid","Index":-1,"NameInSource":"typezajavkid","Alias":"typezajavkid","Type":"System.String"},"88":{"Name":"usercreate","Index":-1,"NameInSource":"usercreate","Alias":"usercreate","Type":"System.String"},"89":{"Name":"userupdate","Index":-1,"NameInSource":"userupdate","Alias":"userupdate","Type":"System.String"},"90":{"Name":"vladelec_sorta","Index":-1,"NameInSource":"vladelec_sorta","Alias":"vladelec_sorta","Type":"System.String"},"91":{"Name":"vlasn_name","Index":-1,"NameInSource":"vlasn_name","Alias":"vlasn_name","Type":"System.String"},"92":{"Name":"vlasnid","Index":-1,"NameInSource":"vlasnid","Alias":"vlasnid","Type":"System.String"},"93":{"Name":"vyrobleno","Index":-1,"NameInSource":"vyrobleno","Alias":"vyrobleno","Type":"System.String"},"94":{"Name":"year_urog","Index":-1,"NameInSource":"year_urog","Alias":"year_urog","Type":"System.Int32"},"95":{"Name":"zajav_date","Index":-1,"NameInSource":"zajav_date","Alias":"zajav_date","Type":"System.DateTime"},"96":{"Name":"zajavkid","Index":-1,"NameInSource":"zajavkid","Alias":"zajavkid","Type":"System.String"},"97":{"Name":"zajavn","Index":-1,"NameInSource":"zajavn","Alias":"zajavn","Type":"System.String"}},"NameInSource":"k2","Type":"Table","SqlCommand":"SELECT z.zajavkid, z.comment, z.fio, z.mesto, z.address, z.address_jur, addr.address_name, z.usercreate,  z.fix_usercreate, z.userupdate, z.datecreate, z.dateupdate, z.razmer_polya, z.CodKult, z.CodKult1, z.SortID, \r\n                    z.SortID1, z.SortID2, z.SortID3, z.is_aktpol, z.vyrobleno,\r\n                    z.clone_name, z.pidschep, z.catid, z.agronomid, z.firmid, z.doc_mayna_n, z.doc_mayna_date, z.k2firms_our, z.podpis_zajavnik, z.is_cond,\r\n                    z.zajavn, z.zajav_date, z.typezajavid, z.first_typezajavkid, z.year_urog, z.mass_part, z.part_num, z.kol_pack, z.doc_yakost_num, z.doc_yakost_date,\r\n                    z.dani_pro_oplatu_robit,\r\n                    z.dani_pro_oplatu_date, z.prot_vypr_date,\r\n                    z.order_ins, z.razmer_part, z.razmer_part2, z.act_n, z.act_date, z.vladelec_sorta,\r\n                    k.Kultura as Kultura, kmp.Kultura as Kultura1, s.NameUA as NameUA, s1.NameUA as NameUA1, s2.NameUA as NameUA2, s3.NameUA as NameUA3,\r\n                    a.fullname, a.dolgnid, dolg.dolgnname, f.VirobnikNameUA, f.AdresPocht, f.AdresYurid,\r\n                    tz.name_typezajav, tz1.name_typezajav as firstname_typezajav, z.typezajavkid, stat.name_typezajavk, z.OblastId, obl.OblastNameUA, c.cat_name, cu.cat_name cat_name_use,\r\n                    z.generationid, g.generation_name, z.generationid_use, gu.generation_name as generation_name_use, z.dstuid,dstu.dstu_name,\r\n                    z.vlasnid, vl.vlasn_name, z.resh_cert_date, z.resh_cert_fio, z.resh_cert_auditid, z.pov_cert_auditid, z.resh_cert_otkaz_date, z.resh_cert_otkaz_n,\r\n                    z.resh_cert_otkaz_podg, z.resh_mog_cert_date, z.resh_mog_cert_n, z.resh_mog_cert_podg, z.akt_pol_ocen_n, z.akt_pol_ocen_date,\r\n                    z.akt_pol_ocen_auditid, z.akt_brak_n, z.akt_brak_date, z.akt_brak_auditid, z.cert_date, z.cert_n, z.cert_podg, cert_podg_aud.fio cert_podg_aud_fio,\r\n                    resh_aud.fio resh_auditor_fio, pov_aud.fio pov_auditor_fio, pov_aud.dp_posad_name dp_posad_name, vidm_aud.fio vidm_auditor_fio, act_aud.fio act_auditor_fio, act_brak.fio act_brak_fio, agr_aud.fio agr_aud_fio,\r\n                    z.rishtypeid, rish.rishtype_name, z.prichinid1, z.prichinid2, z.prichinid3, pr1.text_prichin as text_prichin1, pr2.text_prichin as text_prichin2,\r\n                    pr3.text_prichin as text_prichin3, z.is_seen, gk.group_name, gk.group_kod, z.sort_hand, z.is_del, z.is_cert, z.pole_num, z.dil_num, z.chystota, z.cert_dateto,\r\n                    z.mog_cert_auditid, mog_cert_aud.fio mog_cert_aud_fio, z.cert_podg_auditid, z.rishtypeid_shablon, rish_sb.rishtype_name as rishtype_namesb, pz.country_poh_nas as cpn_z, pk.country_poh_nas as cpn_k, pb.country_poh_nas as cpn_b, pz.vymog_markuv as mi_z, pk.vymog_markuv as mi_k, pb.vymog_markuv as mi_b\r\n\r\n         FROM dp2_zajavka_obsteg z\r\n\r\n                LEFT JOIN dp2Kultur k\r\n                ON z.CodKult=k.CodKult\r\n                \r\n                LEFT JOIN dp2Kultur kmp\r\n                ON z.CodKult1=kmp.CodKult\r\n                \r\n                LEFT JOIN dp2GroupKult gk\r\n                ON k.group_kultid=gk.group_kultid\r\n\r\n                LEFT JOIN dp2SortReestr s\r\n                ON z.SortID=s.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s1\r\n                ON z.SortID1=s1.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s2\r\n                ON z.SortID2=s2.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s3\r\n                ON z.SortID3=s3.SortID\r\n\r\n                LEFT JOIN dp2Categors c\r\n                ON z.catid=c.catid\r\n                \r\n                LEFT JOIN dp2Categors cu\r\n                ON z.catid_use=cu.catid\r\n                \r\n                LEFT JOIN dp2generation g\r\n                ON z.generationid=g.generationid\r\n\r\n                LEFT JOIN dp2generation gu\r\n                ON z.generationid_use=gu.generationid\r\n\r\n                LEFT JOIN dp2Agronoms a\r\n                ON z.agronomid=a.agronomid\r\n                             \r\n                LEFT JOIN dp2Virobn f\r\n                ON z.firmid=f.VirobnikId\r\n\r\n                LEFT JOIN dp2_typezajav tz\r\n                ON z.typezajavid=tz.typezajavid\r\n\r\n                LEFT JOIN dp2_typezajav tz1\r\n                ON z.first_typezajavkid = tz1.typezajavid\r\n                \r\n                LEFT JOIN dp2StatusZajavk stat\r\n                ON z.typezajavkid=stat.typezajavkid\r\n                \r\n                LEFT JOIN dp2Oblast obl\r\n                ON z.OblastId=obl.OblastId\r\n                \r\n                LEFT JOIN dp2_dstu dstu\r\n                ON z.dstuid=dstu.dstuid\r\n                \r\n                LEFT JOIN dp2vlasn vl\r\n                ON z.vlasnid=vl.vlasnid\r\n                \r\n                LEFT JOIN dp2_auditors resh_aud\r\n                ON z.resh_cert_auditid=resh_aud.auditid\r\n\r\n                LEFT JOIN dp2_auditors mog_cert_aud\r\n                ON z.mog_cert_auditid=mog_cert_aud.auditid\r\n\r\n                LEFT JOIN dp2_auditors cert_podg_aud\r\n                ON z.cert_podg_auditid=cert_podg_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors pov_aud\r\n                ON z.pov_cert_auditid=pov_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors vidm_aud\r\n                ON z.resh_cert_otkaz_podg=vidm_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors act_aud\r\n                ON z.akt_pol_ocen_auditid=act_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors act_brak\r\n                ON z.akt_brak_auditid=act_brak.auditid\r\n                \r\n                LEFT JOIN dp2_auditors agr_aud\r\n                ON z.resh_cert_fio=agr_aud.auditid\r\n                \r\n                LEFT JOIN dp2RishType rish\r\n                ON z.rishtypeid=rish.rishtypeid\r\n\r\n                LEFT JOIN dp2RishType rish_sb\r\n                ON z.rishtypeid_shablon=rish_sb.rishtypeid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr1\r\n                ON z.prichinid1=pr1.prichinid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr2\r\n                ON z.prichinid2=pr2.prichinid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr3\r\n                ON z.prichinid3=pr3.prichinid\r\n                \r\n                LEFT JOIN k2dolgnost dolg\r\n                ON a.dolgnid=dolg.dolgnid\r\n\r\n                LEFT JOIN dp2address addr\r\n                ON z.address=addr.address\r\n               \r\n                LEFT JOIN dp2_protokol_zern pz\r\n                ON z.zajavkid=pz.zajavkid\r\n\r\n                LEFT JOIN dp2_protokol_kart pk\r\n                ON z.zajavkid=pk.zajavkid\r\n\r\n                LEFT JOIN dp2_protokol_bur pb\r\n                ON z.zajavkid=pb.zajavkid\r\n\r\nwhere (z.typezajavid='d6e880adc8806b00404bd29e6284fa8b'  or z.typezajavid='tov288f9c84a33a5186e6be77bb4eea0' ) AND (zajav_date<'2023-01-01') AND  (zajav_date>='2022-01-01')  AND (z.is_del<>1) order by z.zajav_date\r\n\r\n"},"2":{"Ident":"StiMySqlSource","Name":"dp2_protokol_bur","Alias":"dp2_protokol_bur","Columns":{"0":{"Name":"CodKult","Index":-1,"NameInSource":"CodKult","Alias":"CodKult","Type":"System.String"},"1":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"2":{"Name":"SortID","Index":-1,"NameInSource":"SortID","Alias":"SortID","Type":"System.String"},"3":{"Name":"add_auditor_info","Index":-1,"NameInSource":"add_auditor_info","Alias":"add_auditor_info","Type":"System.String"},"4":{"Name":"add_info","Index":-1,"NameInSource":"add_info","Alias":"add_info","Type":"System.String"},"5":{"Name":"agronomid","Index":-1,"NameInSource":"agronomid","Alias":"agronomid","Type":"System.String"},"6":{"Name":"aktvypr_date","Index":-1,"NameInSource":"aktvypr_date","Alias":"aktvypr_date","Type":"System.DateTime"},"7":{"Name":"aktvypr_num","Index":-1,"NameInSource":"aktvypr_num","Alias":"aktvypr_num","Type":"System.String"},"8":{"Name":"anomaln","Index":-1,"NameInSource":"anomaln","Alias":"anomaln","Type":"System.String"},"9":{"Name":"buryaniv","Index":-1,"NameInSource":"buryaniv","Alias":"buryaniv","Type":"System.String"},"10":{"Name":"catid","Index":-1,"NameInSource":"catid","Alias":"catid","Type":"System.String"},"11":{"Name":"cert_diya","Index":-1,"NameInSource":"cert_diya","Alias":"cert_diya","Type":"System.DateTime"},"12":{"Name":"chystota","Index":-1,"NameInSource":"chystota","Alias":"chystota","Type":"System.String"},"13":{"Name":"country_poh_nas","Index":-1,"NameInSource":"country_poh_nas","Alias":"country_poh_nas","Type":"System.String"},"14":{"Name":"countryid","Index":-1,"NameInSource":"countryid","Alias":"countryid","Type":"System.String"},"15":{"Name":"date_oderg","Index":-1,"NameInSource":"date_oderg","Alias":"date_oderg","Type":"System.DateTime"},"16":{"Name":"date_proved","Index":-1,"NameInSource":"date_proved","Alias":"date_proved","Type":"System.DateTime"},"17":{"Name":"date_proved_to","Index":-1,"NameInSource":"date_proved_to","Alias":"date_proved_to","Type":"System.DateTime"},"18":{"Name":"date_vidach_sert","Index":-1,"NameInSource":"date_vidach_sert","Alias":"date_vidach_sert","Type":"System.DateTime"},"19":{"Name":"datecreate","Index":-1,"NameInSource":"datecreate","Alias":"datecreate","Type":"System.DateTime"},"20":{"Name":"dateupdate","Index":-1,"NameInSource":"dateupdate","Alias":"dateupdate","Type":"System.DateTime"},"21":{"Name":"diametr","Index":-1,"NameInSource":"diametr","Alias":"diametr","Type":"System.String"},"22":{"Name":"dobroyakisnist","Index":-1,"NameInSource":"dobroyakisnist","Alias":"dobroyakisnist","Type":"System.String"},"23":{"Name":"doc_pravo_vik","Index":-1,"NameInSource":"doc_pravo_vik","Alias":"doc_pravo_vik","Type":"System.String"},"24":{"Name":"dstu","Index":-1,"NameInSource":"dstu","Alias":"dstu","Type":"System.String"},"25":{"Name":"dstu_metod","Index":-1,"NameInSource":"dstu_metod","Alias":"dstu_metod","Type":"System.String"},"26":{"Name":"generationid","Index":-1,"NameInSource":"generationid","Alias":"generationid","Type":"System.String"},"27":{"Name":"gryb_utv","Index":-1,"NameInSource":"gryb_utv","Alias":"gryb_utv","Type":"System.String"},"28":{"Name":"gyttezdatn","Index":-1,"NameInSource":"gyttezdatn","Alias":"gyttezdatn","Type":"System.String"},"29":{"Name":"inshi_kategorii","Index":-1,"NameInSource":"inshi_kategorii","Alias":"inshi_kategorii","Type":"System.String"},"30":{"Name":"is_close","Index":-1,"NameInSource":"is_close","Alias":"is_close","Type":"System.Int16"},"31":{"Name":"is_cond","Index":-1,"NameInSource":"is_cond","Alias":"is_cond","Type":"System.Int16"},"32":{"Name":"is_need_cert","Index":-1,"NameInSource":"is_need_cert","Alias":"is_need_cert","Type":"System.Int16"},"33":{"Name":"is_vidpov","Index":-1,"NameInSource":"is_vidpov","Alias":"is_vidpov","Type":"System.Int16"},"34":{"Name":"kilkposodyn","Index":-1,"NameInSource":"kilkposodyn","Alias":"kilkposodyn","Type":"System.String"},"35":{"Name":"laborant","Index":-1,"NameInSource":"laborant","Alias":"laborant","Type":"System.String"},"36":{"Name":"laborant_vidp","Index":-1,"NameInSource":"laborant_vidp","Alias":"laborant_vidp","Type":"System.String"},"37":{"Name":"mark_info","Index":-1,"NameInSource":"mark_info","Alias":"mark_info","Type":"System.String"},"38":{"Name":"mas_part","Index":-1,"NameInSource":"mas_part","Alias":"mas_part","Type":"System.Decimal"},"39":{"Name":"masa1000","Index":-1,"NameInSource":"masa1000","Alias":"masa1000","Type":"System.String"},"40":{"Name":"massposodyn","Index":-1,"NameInSource":"massposodyn","Alias":"massposodyn","Type":"System.Decimal"},"41":{"Name":"nakaz","Index":-1,"NameInSource":"nakaz","Alias":"nakaz","Type":"System.String"},"42":{"Name":"neprorosli","Index":-1,"NameInSource":"neprorosli","Alias":"neprorosli","Type":"System.String"},"43":{"Name":"normalnogo","Index":-1,"NameInSource":"normalnogo","Alias":"normalnogo","Type":"System.String"},"44":{"Name":"num_blank_cert","Index":-1,"NameInSource":"num_blank_cert","Alias":"num_blank_cert","Type":"System.Int16"},"45":{"Name":"num_sert_rozmn","Index":-1,"NameInSource":"num_sert_rozmn","Alias":"num_sert_rozmn","Type":"System.String"},"46":{"Name":"obrobka","Index":-1,"NameInSource":"obrobka","Alias":"obrobka","Type":"System.String"},"47":{"Name":"odnonasinnist","Index":-1,"NameInSource":"odnonasinnist","Alias":"odnonasinnist","Type":"System.String"},"48":{"Name":"odnorost","Index":-1,"NameInSource":"odnorost","Alias":"odnorost","Type":"System.String"},"49":{"Name":"order_ins","Index":-1,"NameInSource":"order_ins","Alias":"order_ins","Type":"System.Int64"},"50":{"Name":"part_num","Index":-1,"NameInSource":"part_num","Alias":"part_num","Type":"System.Decimal"},"51":{"Name":"perevag_group","Index":-1,"NameInSource":"perevag_group","Alias":"perevag_group","Type":"System.String"},"52":{"Name":"potrebid","Index":-1,"NameInSource":"potrebid","Alias":"potrebid","Type":"System.String"},"53":{"Name":"poverhn_inf","Index":-1,"NameInSource":"poverhn_inf","Alias":"poverhn_inf","Type":"System.String"},"54":{"Name":"prichinid_cert","Index":-1,"NameInSource":"prichinid_cert","Alias":"prichinid_cert","Type":"System.String"},"55":{"Name":"prichinid_obsteg","Index":-1,"NameInSource":"prichinid_obsteg","Alias":"prichinid_obsteg","Type":"System.String"},"56":{"Name":"prot_data","Index":-1,"NameInSource":"prot_data","Alias":"prot_data","Type":"System.DateTime"},"57":{"Name":"prot_num","Index":-1,"NameInSource":"prot_num","Alias":"prot_num","Type":"System.String"},"58":{"Name":"protokolid","Index":-1,"NameInSource":"protokolid","Alias":"protokolid","Type":"System.String"},"59":{"Name":"rayid","Index":-1,"NameInSource":"rayid","Alias":"rayid","Type":"System.String"},"60":{"Name":"razm_part","Index":-1,"NameInSource":"razm_part","Alias":"razm_part","Type":"System.Decimal"},"61":{"Name":"razresh_vidat_cert","Index":-1,"NameInSource":"razresh_vidat_cert","Alias":"razresh_vidat_cert","Type":"System.String"},"62":{"Name":"schema_rozmischen","Index":-1,"NameInSource":"schema_rozmischen","Alias":"schema_rozmischen","Type":"System.String"},"63":{"Name":"ser_blankid","Index":-1,"NameInSource":"ser_blankid","Alias":"ser_blankid","Type":"System.String"},"64":{"Name":"sert_ista","Index":-1,"NameInSource":"sert_ista","Alias":"sert_ista","Type":"System.String"},"65":{"Name":"shogist","Index":-1,"NameInSource":"shogist","Alias":"shogist","Type":"System.String"},"66":{"Name":"tryvalist","Index":-1,"NameInSource":"tryvalist","Alias":"tryvalist","Type":"System.String"},"67":{"Name":"tverdogo","Index":-1,"NameInSource":"tverdogo","Alias":"tverdogo","Type":"System.String"},"68":{"Name":"umovy","Index":-1,"NameInSource":"umovy","Alias":"umovy","Type":"System.String"},"69":{"Name":"usercreate","Index":-1,"NameInSource":"usercreate","Alias":"usercreate","Type":"System.String"},"70":{"Name":"userupdate","Index":-1,"NameInSource":"userupdate","Alias":"userupdate","Type":"System.String"},"71":{"Name":"vagkovidokreml","Index":-1,"NameInSource":"vagkovidokreml","Alias":"vagkovidokreml","Type":"System.String"},"72":{"Name":"vid_vikorid","Index":-1,"NameInSource":"vid_vikorid","Alias":"vid_vikorid","Type":"System.String"},"73":{"Name":"vmist_inshvyd","Index":-1,"NameInSource":"vmist_inshvyd","Alias":"vmist_inshvyd","Type":"System.String"},"74":{"Name":"vmist_kult","Index":-1,"NameInSource":"vmist_kult","Alias":"vmist_kult","Type":"System.String"},"75":{"Name":"vmist_obrush","Index":-1,"NameInSource":"vmist_obrush","Alias":"vmist_obrush","Type":"System.String"},"76":{"Name":"vmist_osnkult","Index":-1,"NameInSource":"vmist_osnkult","Alias":"vmist_osnkult","Type":"System.String"},"77":{"Name":"vmist_prorosl","Index":-1,"NameInSource":"vmist_prorosl","Alias":"vmist_prorosl","Type":"System.String"},"78":{"Name":"vmist_zlisn","Index":-1,"NameInSource":"vmist_zlisn","Alias":"vmist_zlisn","Type":"System.String"},"79":{"Name":"vnutr_inf","Index":-1,"NameInSource":"vnutr_inf","Alias":"vnutr_inf","Type":"System.String"},"80":{"Name":"vologist","Index":-1,"NameInSource":"vologist","Alias":"vologist","Type":"System.String"},"81":{"Name":"vyhid","Index":-1,"NameInSource":"vyhid","Alias":"vyhid","Type":"System.String"},"82":{"Name":"vymog_markuv","Index":-1,"NameInSource":"vymog_markuv","Alias":"vymog_markuv","Type":"System.String"},"83":{"Name":"vyrivnian","Index":-1,"NameInSource":"vyrivnian","Alias":"vyrivnian","Type":"System.String"},"84":{"Name":"vyrobleno","Index":-1,"NameInSource":"vyrobleno","Alias":"vyrobleno","Type":"System.String"},"85":{"Name":"vyrobn_part","Index":-1,"NameInSource":"vyrobn_part","Alias":"vyrobn_part","Type":"System.String"},"86":{"Name":"zajavkid","Index":-1,"NameInSource":"zajavkid","Alias":"zajavkid","Type":"System.String"},"87":{"Name":"zaragenist","Index":-1,"NameInSource":"zaragenist","Alias":"zaragenist","Type":"System.String"},"88":{"Name":"zasel_shkidn","Index":-1,"NameInSource":"zasel_shkidn","Alias":"zasel_shkidn","Type":"System.String"},"89":{"Name":"zignilogo","Index":-1,"NameInSource":"zignilogo","Alias":"zignilogo","Type":"System.String"},"90":{"Name":"zovn_vygl_colir","Index":-1,"NameInSource":"zovn_vygl_colir","Alias":"zovn_vygl_colir","Type":"System.String"},"91":{"Name":"zovn_vygl_zapah","Index":-1,"NameInSource":"zovn_vygl_zapah","Alias":"zovn_vygl_zapah","Type":"System.String"}},"NameInSource":"k2","SqlCommand":"select * from dp2_protokol_bur"},"3":{"Ident":"StiMySqlSource","Name":"dp2_protokol_kart","Alias":"dp2_protokol_kart","Columns":{"0":{"Name":"CodKult","Index":-1,"NameInSource":"CodKult","Alias":"CodKult","Type":"System.String"},"1":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"2":{"Name":"SortID","Index":-1,"NameInSource":"SortID","Alias":"SortID","Type":"System.String"},"3":{"Name":"add_auditor_info","Index":-1,"NameInSource":"add_auditor_info","Alias":"add_auditor_info","Type":"System.String"},"4":{"Name":"add_info","Index":-1,"NameInSource":"add_info","Alias":"add_info","Type":"System.String"},"5":{"Name":"agronomid","Index":-1,"NameInSource":"agronomid","Alias":"agronomid","Type":"System.String"},"6":{"Name":"aktvypr_date","Index":-1,"NameInSource":"aktvypr_date","Alias":"aktvypr_date","Type":"System.DateTime"},"7":{"Name":"aktvypr_num","Index":-1,"NameInSource":"aktvypr_num","Alias":"aktvypr_num","Type":"System.String"},"8":{"Name":"bakt_gnyl","Index":-1,"NameInSource":"bakt_gnyl","Alias":"bakt_gnyl","Type":"System.String"},"9":{"Name":"catid","Index":-1,"NameInSource":"catid","Alias":"catid","Type":"System.String"},"10":{"Name":"cert_diya","Index":-1,"NameInSource":"cert_diya","Alias":"cert_diya","Type":"System.DateTime"},"11":{"Name":"chern_nigk","Index":-1,"NameInSource":"chern_nigk","Alias":"chern_nigk","Type":"System.String"},"12":{"Name":"country_poh_nas","Index":-1,"NameInSource":"country_poh_nas","Alias":"country_poh_nas","Type":"System.String"},"13":{"Name":"countryid","Index":-1,"NameInSource":"countryid","Alias":"countryid","Type":"System.String"},"14":{"Name":"date_oderg","Index":-1,"NameInSource":"date_oderg","Alias":"date_oderg","Type":"System.DateTime"},"15":{"Name":"date_proved","Index":-1,"NameInSource":"date_proved","Alias":"date_proved","Type":"System.DateTime"},"16":{"Name":"date_proved_to","Index":-1,"NameInSource":"date_proved_to","Alias":"date_proved_to","Type":"System.DateTime"},"17":{"Name":"date_sert_insh","Index":-1,"NameInSource":"date_sert_insh","Alias":"date_sert_insh","Type":"System.DateTime"},"18":{"Name":"date_sert_sort","Index":-1,"NameInSource":"date_sert_sort","Alias":"date_sert_sort","Type":"System.DateTime"},"19":{"Name":"date_vidach_sert","Index":-1,"NameInSource":"date_vidach_sert","Alias":"date_vidach_sert","Type":"System.DateTime"},"20":{"Name":"datecreate","Index":-1,"NameInSource":"datecreate","Alias":"datecreate","Type":"System.DateTime"},"21":{"Name":"dateupdate","Index":-1,"NameInSource":"dateupdate","Alias":"dateupdate","Type":"System.DateTime"},"22":{"Name":"doc_pravo_vik","Index":-1,"NameInSource":"doc_pravo_vik","Alias":"doc_pravo_vik","Type":"System.String"},"23":{"Name":"drotyanyk","Index":-1,"NameInSource":"drotyanyk","Alias":"drotyanyk","Type":"System.String"},"24":{"Name":"dstu","Index":-1,"NameInSource":"dstu","Alias":"dstu","Type":"System.String"},"25":{"Name":"dstu_metod","Index":-1,"NameInSource":"dstu_metod","Alias":"dstu_metod","Type":"System.String"},"26":{"Name":"fitoftoroz","Index":-1,"NameInSource":"fitoftoroz","Alias":"fitoftoroz","Type":"System.String"},"27":{"Name":"generationid","Index":-1,"NameInSource":"generationid","Alias":"generationid","Type":"System.String"},"28":{"Name":"gryz_hrusch_sov","Index":-1,"NameInSource":"gryz_hrusch_sov","Alias":"gryz_hrusch_sov","Type":"System.String"},"29":{"Name":"himikat","Index":-1,"NameInSource":"himikat","Alias":"himikat","Type":"System.String"},"30":{"Name":"insh_doc","Index":-1,"NameInSource":"insh_doc","Alias":"insh_doc","Type":"System.String"},"31":{"Name":"is_close","Index":-1,"NameInSource":"is_close","Alias":"is_close","Type":"System.Int16"},"32":{"Name":"is_cond","Index":-1,"NameInSource":"is_cond","Alias":"is_cond","Type":"System.Int16"},"33":{"Name":"is_need_cert","Index":-1,"NameInSource":"is_need_cert","Alias":"is_need_cert","Type":"System.Int16"},"34":{"Name":"is_vidpov","Index":-1,"NameInSource":"is_vidpov","Alias":"is_vidpov","Type":"System.Int16"},"35":{"Name":"kilc_gnyl","Index":-1,"NameInSource":"kilc_gnyl","Alias":"kilc_gnyl","Type":"System.String"},"36":{"Name":"laborant","Index":-1,"NameInSource":"laborant","Alias":"laborant","Type":"System.String"},"37":{"Name":"laborant_vidp","Index":-1,"NameInSource":"laborant_vidp","Alias":"laborant_vidp","Type":"System.String"},"38":{"Name":"mark_info","Index":-1,"NameInSource":"mark_info","Alias":"mark_info","Type":"System.String"},"39":{"Name":"mas_part","Index":-1,"NameInSource":"mas_part","Alias":"mas_part","Type":"System.Decimal"},"40":{"Name":"meh_poshk","Index":-1,"NameInSource":"meh_poshk","Alias":"meh_poshk","Type":"System.String"},"41":{"Name":"mokr_gnyl","Index":-1,"NameInSource":"mokr_gnyl","Alias":"mokr_gnyl","Type":"System.String"},"42":{"Name":"najavn_zemli","Index":-1,"NameInSource":"najavn_zemli","Alias":"najavn_zemli","Type":"System.String"},"43":{"Name":"nakaz","Index":-1,"NameInSource":"nakaz","Alias":"nakaz","Type":"System.String"},"44":{"Name":"nayavn_bulb_insh","Index":-1,"NameInSource":"nayavn_bulb_insh","Alias":"nayavn_bulb_insh","Type":"System.String"},"45":{"Name":"nayavn_bulb_nev","Index":-1,"NameInSource":"nayavn_bulb_nev","Alias":"nayavn_bulb_nev","Type":"System.String"},"46":{"Name":"nayavn_bulb_urag","Index":-1,"NameInSource":"nayavn_bulb_urag","Alias":"nayavn_bulb_urag","Type":"System.String"},"47":{"Name":"naybilsh_diam","Index":-1,"NameInSource":"naybilsh_diam","Alias":"naybilsh_diam","Type":"System.String"},"48":{"Name":"nematodou","Index":-1,"NameInSource":"nematodou","Alias":"nematodou","Type":"System.String"},"49":{"Name":"num_blank_cert","Index":-1,"NameInSource":"num_blank_cert","Alias":"num_blank_cert","Type":"System.Int16"},"50":{"Name":"num_sert_rozmn","Index":-1,"NameInSource":"num_sert_rozmn","Alias":"num_sert_rozmn","Type":"System.String"},"51":{"Name":"obidr_shkir","Index":-1,"NameInSource":"obidr_shkir","Alias":"obidr_shkir","Type":"System.String"},"52":{"Name":"obrobka","Index":-1,"NameInSource":"obrobka","Alias":"obrobka","Type":"System.String"},"53":{"Name":"okrugl_oval","Index":-1,"NameInSource":"okrugl_oval","Alias":"okrugl_oval","Type":"System.String"},"54":{"Name":"opicy","Index":-1,"NameInSource":"opicy","Alias":"opicy","Type":"System.String"},"55":{"Name":"order_ins","Index":-1,"NameInSource":"order_ins","Alias":"order_ins","Type":"System.Int64"},"56":{"Name":"ozn_zaduh","Index":-1,"NameInSource":"ozn_zaduh","Alias":"ozn_zaduh","Type":"System.String"},"57":{"Name":"parsh_porosh","Index":-1,"NameInSource":"parsh_porosh","Alias":"parsh_porosh","Type":"System.String"},"58":{"Name":"parsh_zv_sribl","Index":-1,"NameInSource":"parsh_zv_sribl","Alias":"parsh_zv_sribl","Type":"System.String"},"59":{"Name":"part_num","Index":-1,"NameInSource":"part_num","Alias":"part_num","Type":"System.Decimal"},"60":{"Name":"pidmerzli","Index":-1,"NameInSource":"pidmerzli","Alias":"pidmerzli","Type":"System.String"},"61":{"Name":"poshk_bulb","Index":-1,"NameInSource":"poshk_bulb","Alias":"poshk_bulb","Type":"System.String"},"62":{"Name":"poshk_bulb_vtch","Index":-1,"NameInSource":"poshk_bulb_vtch","Alias":"poshk_bulb_vtch","Type":"System.String"},"63":{"Name":"potrebid","Index":-1,"NameInSource":"potrebid","Alias":"potrebid","Type":"System.String"},"64":{"Name":"prichinid_cert","Index":-1,"NameInSource":"prichinid_cert","Alias":"prichinid_cert","Type":"System.String"},"65":{"Name":"prichinid_obsteg","Index":-1,"NameInSource":"prichinid_obsteg","Alias":"prichinid_obsteg","Type":"System.String"},"66":{"Name":"prot_data","Index":-1,"NameInSource":"prot_data","Alias":"prot_data","Type":"System.DateTime"},"67":{"Name":"prot_num","Index":-1,"NameInSource":"prot_num","Alias":"prot_num","Type":"System.String"},"68":{"Name":"protokolid","Index":-1,"NameInSource":"protokolid","Alias":"protokolid","Type":"System.String"},"69":{"Name":"rayid","Index":-1,"NameInSource":"rayid","Alias":"rayid","Type":"System.String"},"70":{"Name":"razm_part","Index":-1,"NameInSource":"razm_part","Alias":"razm_part","Type":"System.Decimal"},"71":{"Name":"razresh_vidat_cert","Index":-1,"NameInSource":"razresh_vidat_cert","Alias":"razresh_vidat_cert","Type":"System.String"},"72":{"Name":"rizani","Index":-1,"NameInSource":"rizani","Alias":"rizani","Type":"System.String"},"73":{"Name":"rozchavl","Index":-1,"NameInSource":"rozchavl","Alias":"rozchavl","Type":"System.String"},"74":{"Name":"ryzoktonioz","Index":-1,"NameInSource":"ryzoktonioz","Alias":"ryzoktonioz","Type":"System.String"},"75":{"Name":"ryzoktonioz14","Index":-1,"NameInSource":"ryzoktonioz14","Alias":"ryzoktonioz14","Type":"System.String"},"76":{"Name":"schema_rozmischen","Index":-1,"NameInSource":"schema_rozmischen","Alias":"schema_rozmischen","Type":"System.String"},"77":{"Name":"ser_blankid","Index":-1,"NameInSource":"ser_blankid","Alias":"ser_blankid","Type":"System.String"},"78":{"Name":"sert_ista","Index":-1,"NameInSource":"sert_ista","Alias":"sert_ista","Type":"System.String"},"79":{"Name":"sort_chyst","Index":-1,"NameInSource":"sort_chyst","Alias":"sort_chyst","Type":"System.String"},"80":{"Name":"spotvoreni","Index":-1,"NameInSource":"spotvoreni","Alias":"spotvoreni","Type":"System.String"},"81":{"Name":"suh_gill","Index":-1,"NameInSource":"suh_gill","Alias":"suh_gill","Type":"System.String"},"82":{"Name":"usercreate","Index":-1,"NameInSource":"usercreate","Alias":"usercreate","Type":"System.String"},"83":{"Name":"userupdate","Index":-1,"NameInSource":"userupdate","Alias":"userupdate","Type":"System.String"},"84":{"Name":"vid_vikorid","Index":-1,"NameInSource":"vid_vikorid","Alias":"vid_vikorid","Type":"System.String"},"85":{"Name":"vydovgen","Index":-1,"NameInSource":"vydovgen","Alias":"vydovgen","Type":"System.String"},"86":{"Name":"vymog_markuv","Index":-1,"NameInSource":"vymog_markuv","Alias":"vymog_markuv","Type":"System.String"},"87":{"Name":"vyrobleno","Index":-1,"NameInSource":"vyrobleno","Alias":"vyrobleno","Type":"System.String"},"88":{"Name":"vyrobn_part","Index":-1,"NameInSource":"vyrobn_part","Alias":"vyrobn_part","Type":"System.String"},"89":{"Name":"zajavkid","Index":-1,"NameInSource":"zajavkid","Alias":"zajavkid","Type":"System.String"},"90":{"Name":"znarosty","Index":-1,"NameInSource":"znarosty","Alias":"znarosty","Type":"System.String"},"91":{"Name":"zonaid","Index":-1,"NameInSource":"zonaid","Alias":"zonaid","Type":"System.String"}},"NameInSource":"k2","SqlCommand":"select * from dp2_protokol_kart"},"4":{"Ident":"StiMySqlSource","Name":"dp2_protokol_zern","Alias":"dp2_protokol_zern","Columns":{"0":{"Name":"CodKult","Index":-1,"NameInSource":"CodKult","Alias":"CodKult","Type":"System.String"},"1":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"2":{"Name":"SortID","Index":-1,"NameInSource":"SortID","Alias":"SortID","Type":"System.String"},"3":{"Name":"add_auditor_info","Index":-1,"NameInSource":"add_auditor_info","Alias":"add_auditor_info","Type":"System.String"},"4":{"Name":"add_dstu","Index":-1,"NameInSource":"add_dstu","Alias":"add_dstu","Type":"System.String"},"5":{"Name":"add_info","Index":-1,"NameInSource":"add_info","Alias":"add_info","Type":"System.String"},"6":{"Name":"agronomid","Index":-1,"NameInSource":"agronomid","Alias":"agronomid","Type":"System.String"},"7":{"Name":"aktvypr_date","Index":-1,"NameInSource":"aktvypr_date","Alias":"aktvypr_date","Type":"System.DateTime"},"8":{"Name":"aktvypr_num","Index":-1,"NameInSource":"aktvypr_num","Alias":"aktvypr_num","Type":"System.String"},"9":{"Name":"anomaln","Index":-1,"NameInSource":"anomaln","Alias":"anomaln","Type":"System.String"},"10":{"Name":"buryaniv","Index":-1,"NameInSource":"buryaniv","Alias":"buryaniv","Type":"System.String"},"11":{"Name":"byte_chystota","Index":-1,"NameInSource":"byte_chystota","Alias":"byte_chystota","Type":"System.String"},"12":{"Name":"catid","Index":-1,"NameInSource":"catid","Alias":"catid","Type":"System.String"},"13":{"Name":"cert_diya","Index":-1,"NameInSource":"cert_diya","Alias":"cert_diya","Type":"System.DateTime"},"14":{"Name":"chystota","Index":-1,"NameInSource":"chystota","Alias":"chystota","Type":"System.String"},"15":{"Name":"country_poh_nas","Index":-1,"NameInSource":"country_poh_nas","Alias":"country_poh_nas","Type":"System.String"},"16":{"Name":"countryid","Index":-1,"NameInSource":"countryid","Alias":"countryid","Type":"System.String"},"17":{"Name":"date_oderg","Index":-1,"NameInSource":"date_oderg","Alias":"date_oderg","Type":"System.DateTime"},"18":{"Name":"date_proved","Index":-1,"NameInSource":"date_proved","Alias":"date_proved","Type":"System.DateTime"},"19":{"Name":"date_proved_to","Index":-1,"NameInSource":"date_proved_to","Alias":"date_proved_to","Type":"System.DateTime"},"20":{"Name":"date_sert_insh","Index":-1,"NameInSource":"date_sert_insh","Alias":"date_sert_insh","Type":"System.DateTime"},"21":{"Name":"date_sert_sort","Index":-1,"NameInSource":"date_sert_sort","Alias":"date_sert_sort","Type":"System.DateTime"},"22":{"Name":"date_vidach_sert","Index":-1,"NameInSource":"date_vidach_sert","Alias":"date_vidach_sert","Type":"System.DateTime"},"23":{"Name":"date_zajav_navypr","Index":-1,"NameInSource":"date_zajav_navypr","Alias":"date_zajav_navypr","Type":"System.DateTime"},"24":{"Name":"datecreate","Index":-1,"NameInSource":"datecreate","Alias":"datecreate","Type":"System.DateTime"},"25":{"Name":"dateupdate","Index":-1,"NameInSource":"dateupdate","Alias":"dateupdate","Type":"System.DateTime"},"26":{"Name":"doc_pravo_vik","Index":-1,"NameInSource":"doc_pravo_vik","Alias":"doc_pravo_vik","Type":"System.String"},"27":{"Name":"dstu","Index":-1,"NameInSource":"dstu","Alias":"dstu","Type":"System.String"},"28":{"Name":"dstu_metod","Index":-1,"NameInSource":"dstu_metod","Alias":"dstu_metod","Type":"System.String"},"29":{"Name":"fuzarioz","Index":-1,"NameInSource":"fuzarioz","Alias":"fuzarioz","Type":"System.String"},"30":{"Name":"generationid","Index":-1,"NameInSource":"generationid","Alias":"generationid","Type":"System.String"},"31":{"Name":"gmo","Index":-1,"NameInSource":"gmo","Alias":"gmo","Type":"System.String"},"32":{"Name":"goroh_zer","Index":-1,"NameInSource":"goroh_zer","Alias":"goroh_zer","Type":"System.String"},"33":{"Name":"gryb_utv","Index":-1,"NameInSource":"gryb_utv","Alias":"gryb_utv","Type":"System.String"},"34":{"Name":"gyttezdatn","Index":-1,"NameInSource":"gyttezdatn","Alias":"gyttezdatn","Type":"System.String"},"35":{"Name":"insh_bur","Index":-1,"NameInSource":"insh_bur","Alias":"insh_bur","Type":"System.String"},"36":{"Name":"insh_doc","Index":-1,"NameInSource":"insh_doc","Alias":"insh_doc","Type":"System.String"},"37":{"Name":"insh_kult","Index":-1,"NameInSource":"insh_kult","Alias":"insh_kult","Type":"System.String"},"38":{"Name":"insh_shkid","Index":-1,"NameInSource":"insh_shkid","Alias":"insh_shkid","Type":"System.String"},"39":{"Name":"inshi_chystota","Index":-1,"NameInSource":"inshi_chystota","Alias":"inshi_chystota","Type":"System.String"},"40":{"Name":"inshi_hvor_gr","Index":-1,"NameInSource":"inshi_hvor_gr","Alias":"inshi_hvor_gr","Type":"System.String"},"41":{"Name":"inshi_hvor_pov","Index":-1,"NameInSource":"inshi_hvor_pov","Alias":"inshi_hvor_pov","Type":"System.String"},"42":{"Name":"inshi_hvor_vn","Index":-1,"NameInSource":"inshi_hvor_vn","Alias":"inshi_hvor_vn","Type":"System.String"},"43":{"Name":"inshi_kategorii","Index":-1,"NameInSource":"inshi_kategorii","Alias":"inshi_kategorii","Type":"System.String"},"44":{"Name":"inshi_vmist","Index":-1,"NameInSource":"inshi_vmist","Alias":"inshi_vmist","Type":"System.String"},"45":{"Name":"invoice","Index":-1,"NameInSource":"invoice","Alias":"invoice","Type":"System.String"},"46":{"Name":"is_close","Index":-1,"NameInSource":"is_close","Alias":"is_close","Type":"System.Int16"},"47":{"Name":"is_cond","Index":-1,"NameInSource":"is_cond","Alias":"is_cond","Type":"System.Int16"},"48":{"Name":"is_meta","Index":-1,"NameInSource":"is_meta","Alias":"is_meta","Type":"System.Int16"},"49":{"Name":"is_need_cert","Index":-1,"NameInSource":"is_need_cert","Alias":"is_need_cert","Type":"System.Int16"},"50":{"Name":"is_vidpov","Index":-1,"NameInSource":"is_vidpov","Alias":"is_vidpov","Type":"System.Int16"},"51":{"Name":"is_vysnov","Index":-1,"NameInSource":"is_vysnov","Alias":"is_vysnov","Type":"System.Int16"},"52":{"Name":"laborant","Index":-1,"NameInSource":"laborant","Alias":"laborant","Type":"System.String"},"53":{"Name":"laborant_vidp","Index":-1,"NameInSource":"laborant_vidp","Alias":"laborant_vidp","Type":"System.String"},"54":{"Name":"mark_info","Index":-1,"NameInSource":"mark_info","Alias":"mark_info","Type":"System.String"},"55":{"Name":"mas_part","Index":-1,"NameInSource":"mas_part","Alias":"mas_part","Type":"System.Decimal"},"56":{"Name":"masa1000","Index":-1,"NameInSource":"masa1000","Alias":"masa1000","Type":"System.String"},"57":{"Name":"meta","Index":-1,"NameInSource":"meta","Alias":"meta","Type":"System.String"},"58":{"Name":"mishsazh","Index":-1,"NameInSource":"mishsazh","Alias":"mishsazh","Type":"System.String"},"59":{"Name":"nakaz","Index":-1,"NameInSource":"nakaz","Alias":"nakaz","Type":"System.String"},"60":{"Name":"naybshkidl","Index":-1,"NameInSource":"naybshkidl","Alias":"naybshkidl","Type":"System.String"},"61":{"Name":"neprorosli","Index":-1,"NameInSource":"neprorosli","Alias":"neprorosli","Type":"System.String"},"62":{"Name":"normalnogo","Index":-1,"NameInSource":"normalnogo","Alias":"normalnogo","Type":"System.String"},"63":{"Name":"num_blank_cert","Index":-1,"NameInSource":"num_blank_cert","Alias":"num_blank_cert","Type":"System.Int16"},"64":{"Name":"num_sert_rozmn","Index":-1,"NameInSource":"num_sert_rozmn","Alias":"num_sert_rozmn","Type":"System.String"},"65":{"Name":"obrobka","Index":-1,"NameInSource":"obrobka","Alias":"obrobka","Type":"System.String"},"66":{"Name":"oecd","Index":-1,"NameInSource":"oecd","Alias":"oecd","Type":"System.String"},"67":{"Name":"order_ins","Index":-1,"NameInSource":"order_ins","Alias":"order_ins","Type":"System.Int64"},"68":{"Name":"part_num","Index":-1,"NameInSource":"part_num","Alias":"part_num","Type":"System.Decimal"},"69":{"Name":"perevag_group","Index":-1,"NameInSource":"perevag_group","Alias":"perevag_group","Type":"System.String"},"70":{"Name":"potrebid","Index":-1,"NameInSource":"potrebid","Alias":"potrebid","Type":"System.String"},"71":{"Name":"poverhn_inf","Index":-1,"NameInSource":"poverhn_inf","Alias":"poverhn_inf","Type":"System.String"},"72":{"Name":"prichinid_cert","Index":-1,"NameInSource":"prichinid_cert","Alias":"prichinid_cert","Type":"System.String"},"73":{"Name":"prichinid_obsteg","Index":-1,"NameInSource":"prichinid_obsteg","Alias":"prichinid_obsteg","Type":"System.String"},"74":{"Name":"prot_data","Index":-1,"NameInSource":"prot_data","Alias":"prot_data","Type":"System.DateTime"},"75":{"Name":"prot_num","Index":-1,"NameInSource":"prot_num","Alias":"prot_num","Type":"System.String"},"76":{"Name":"protokolid","Index":-1,"NameInSource":"protokolid","Alias":"protokolid","Type":"System.String"},"77":{"Name":"rayid","Index":-1,"NameInSource":"rayid","Alias":"rayid","Type":"System.String"},"78":{"Name":"razm_part","Index":-1,"NameInSource":"razm_part","Alias":"razm_part","Type":"System.Decimal"},"79":{"Name":"razresh_vidat_cert","Index":-1,"NameInSource":"razresh_vidat_cert","Alias":"razresh_vidat_cert","Type":"System.String"},"80":{"Name":"reestr_num","Index":-1,"NameInSource":"reestr_num","Alias":"reestr_num","Type":"System.String"},"81":{"Name":"rizhky","Index":-1,"NameInSource":"rizhky","Alias":"rizhky","Type":"System.String"},"82":{"Name":"sazhkmish","Index":-1,"NameInSource":"sazhkmish","Alias":"sazhkmish","Type":"System.String"},"83":{"Name":"schema_rozmischen","Index":-1,"NameInSource":"schema_rozmischen","Alias":"schema_rozmischen","Type":"System.String"},"84":{"Name":"ser_blankid","Index":-1,"NameInSource":"ser_blankid","Alias":"ser_blankid","Type":"System.String"},"85":{"Name":"sert_ista","Index":-1,"NameInSource":"sert_ista","Alias":"sert_ista","Type":"System.String"},"86":{"Name":"shogist","Index":-1,"NameInSource":"shogist","Alias":"shogist","Type":"System.String"},"87":{"Name":"sim_bakterioz","Index":-1,"NameInSource":"sim_bakterioz","Alias":"sim_bakterioz","Type":"System.String"},"88":{"Name":"sklkonraktyf","Index":-1,"NameInSource":"sklkonraktyf","Alias":"sklkonraktyf","Type":"System.String"},"89":{"Name":"sklsirbilgnyl","Index":-1,"NameInSource":"sklsirbilgnyl","Alias":"sklsirbilgnyl","Type":"System.String"},"90":{"Name":"tryvalist","Index":-1,"NameInSource":"tryvalist","Alias":"tryvalist","Type":"System.String"},"91":{"Name":"tverdogo","Index":-1,"NameInSource":"tverdogo","Alias":"tverdogo","Type":"System.String"},"92":{"Name":"umovy","Index":-1,"NameInSource":"umovy","Alias":"umovy","Type":"System.String"},"93":{"Name":"usercreate","Index":-1,"NameInSource":"usercreate","Alias":"usercreate","Type":"System.String"},"94":{"Name":"userupdate","Index":-1,"NameInSource":"userupdate","Alias":"userupdate","Type":"System.String"},"95":{"Name":"vagkovidokreml","Index":-1,"NameInSource":"vagkovidokreml","Alias":"vagkovidokreml","Type":"System.String"},"96":{"Name":"vid_vikorid","Index":-1,"NameInSource":"vid_vikorid","Alias":"vid_vikorid","Type":"System.String"},"97":{"Name":"vmist_inshvyd","Index":-1,"NameInSource":"vmist_inshvyd","Alias":"vmist_inshvyd","Type":"System.String"},"98":{"Name":"vmist_kult","Index":-1,"NameInSource":"vmist_kult","Alias":"vmist_kult","Type":"System.String"},"99":{"Name":"vmist_obrush","Index":-1,"NameInSource":"vmist_obrush","Alias":"vmist_obrush","Type":"System.String"},"100":{"Name":"vmist_osnkult","Index":-1,"NameInSource":"vmist_osnkult","Alias":"vmist_osnkult","Type":"System.String"},"101":{"Name":"vmist_prorosl","Index":-1,"NameInSource":"vmist_prorosl","Alias":"vmist_prorosl","Type":"System.String"},"102":{"Name":"vmist_zlisn","Index":-1,"NameInSource":"vmist_zlisn","Alias":"vmist_zlisn","Type":"System.String"},"103":{"Name":"vnutr_inf","Index":-1,"NameInSource":"vnutr_inf","Alias":"vnutr_inf","Type":"System.String"},"104":{"Name":"vologist","Index":-1,"NameInSource":"vologist","Alias":"vologist","Type":"System.String"},"105":{"Name":"vyhid","Index":-1,"NameInSource":"vyhid","Alias":"vyhid","Type":"System.String"},"106":{"Name":"vymog_markuv","Index":-1,"NameInSource":"vymog_markuv","Alias":"vymog_markuv","Type":"System.String"},"107":{"Name":"vyrobleno","Index":-1,"NameInSource":"vyrobleno","Alias":"vyrobleno","Type":"System.String"},"108":{"Name":"vyrobn_part","Index":-1,"NameInSource":"vyrobn_part","Alias":"vyrobn_part","Type":"System.String"},"109":{"Name":"zajav_navypr","Index":-1,"NameInSource":"zajav_navypr","Alias":"zajav_navypr","Type":"System.String"},"110":{"Name":"zajavkid","Index":-1,"NameInSource":"zajavkid","Alias":"zajavkid","Type":"System.String"},"111":{"Name":"zaragenist","Index":-1,"NameInSource":"zaragenist","Alias":"zaragenist","Type":"System.String"},"112":{"Name":"zasel_shkidn","Index":-1,"NameInSource":"zasel_shkidn","Alias":"zasel_shkidn","Type":"System.String"},"113":{"Name":"zhuk","Index":-1,"NameInSource":"zhuk","Alias":"zhuk","Type":"System.String"},"114":{"Name":"zignilogo","Index":-1,"NameInSource":"zignilogo","Alias":"zignilogo","Type":"System.String"},"115":{"Name":"zoneid","Index":-1,"NameInSource":"zoneid","Alias":"zoneid","Type":"System.String"},"116":{"Name":"zovn_vygl_colir","Index":-1,"NameInSource":"zovn_vygl_colir","Alias":"zovn_vygl_colir","Type":"System.String"},"117":{"Name":"zovn_vygl_zapah","Index":-1,"NameInSource":"zovn_vygl_zapah","Alias":"zovn_vygl_zapah","Type":"System.String"}},"NameInSource":"k2","SqlCommand":"select * from dp2_protokol_zern"}},"Databases":{"0":{"Ident":"StiMySqlDatabase","Name":"k2","Alias":"k2","ConnectionStringEncrypted":"43i5CUMDUdngTzmIzxTgXote0WPdVwHB6X6hlOFxoGfGevPr5lV7iENZeb1ntG0X98h3TsIDa6xDH+XYxIjhL4Zg2QLFFsOAQxo="}}},"Pages":{"0":{"Ident":"StiPage","Name":"Page1","Guid":"45bc3a709c75c634e199c216aa58fe7c","Interaction":{"Ident":"StiInteraction"},"Border":";;2;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiPageHeaderBand","Name":"PageHeaderBand1","ClientRectangle":"0,0.4,40,0.8","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text18","ClientRectangle":"0.4,0.2,2.2,0.4","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Ф-ПЯ-03-02.2"},"HorAlignment":"Center","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"}}},"1":{"Ident":"StiReportTitleBand","Name":"ReportTitleBand1","ClientRectangle":"0,2,40,2.4","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text7","ClientRectangle":"0.4,0.8,1.2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"№\r\nз/п"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"1":{"Ident":"StiText","Name":"Text11","Guid":"87ceee1be8356b9d451099b52cd591da","ClientRectangle":"6,0.8,5.2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Заявник"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"2":{"Ident":"StiText","Name":"Text12","Guid":"2881853bc0bd1dbe91bfb463f42abf6e","ClientRectangle":"11.2,0.8,3,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Культура"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"3":{"Ident":"StiText","Name":"Text13","Guid":"8dd48dbe3ab7f6e9b7b1c9ad1facd88d","ClientRectangle":"17.2,0.8,2.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Категорія"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"4":{"Ident":"StiText","Name":"Text14","Guid":"d4faa44ec17a6b3ba48309db3165c604","ClientRectangle":"22.4,0.8,4.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Партія, №"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"5":{"Ident":"StiText","Name":"Text1","Guid":"7d487e9cf51a58ca2414991d709b7826","ClientRectangle":"14.2,0.8,3,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Сорт"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"6":{"Ident":"StiText","Name":"Text8","Guid":"a0070767f211393374285adcd80ebbbd","ClientRectangle":"19.6,0.8,2.8,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Генерація"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"7":{"Ident":"StiText","Name":"Text17","Guid":"50f0ddb2573071cbf9ba1f71857609a4","ClientRectangle":"35.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Видав"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"8":{"Ident":"StiText","Name":"Text24","Guid":"ea2ef23f169eb9db1e2c1ee838a94ea6","ClientRectangle":"1.6,0.8,4.4,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Заявка"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"9":{"Ident":"StiText","Name":"Text25","Guid":"2d456d1a84761ff30821675c53bfb281","ClientRectangle":"1.6,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"№"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"10":{"Ident":"StiText","Name":"Text27","Guid":"0fbd0e9707b9c41c12cbcb1772b22568","ClientRectangle":"3.8,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"дата"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"11":{"Ident":"StiText","Name":"Text3","Guid":"477b07a531131293418a89c7af5983ad","ClientRectangle":"26.8,0.8,4.4,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Протокол \r\nвипробувань"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"12":{"Ident":"StiText","Name":"Text5","Guid":"511d2a03f71d780aa306304924875eaa","ClientRectangle":"26.8,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"№"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"13":{"Ident":"StiText","Name":"Text6","Guid":"c4a7a9a8d61fe349034ce796feb8d40f","ClientRectangle":"29,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"дата"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"14":{"Ident":"StiText","Name":"Text22","Guid":"d867dd062110da245a63f5085d3a78fd","ClientRectangle":"31.2,0.8,4.4,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Сертифікат"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"15":{"Ident":"StiText","Name":"Text23","Guid":"a22098dec4f2010b0c6b3f017b184db9","ClientRectangle":"31.2,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"№"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"16":{"Ident":"StiText","Name":"Text31","Guid":"ae71c5151c0c65ff858eabcf65288ef3","ClientRectangle":"33.4,1.6,2.2,0.8","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"дата"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"17":{"Ident":"StiText","Name":"Text20","Guid":"e1b45686e27c5a66a00ee82995bafa21","ClientRectangle":"37.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Отримав"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"}}},"2":{"Ident":"StiDataBand","Name":"DataBand1","ClientRectangle":"0,5.2,40,0.6","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text26","ClientRectangle":"11.2,0,3,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.Kultura}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:Black","TextOptions":{"WordWrap":true},"Type":"Expression"},"1":{"Ident":"StiText","Name":"Text28","ClientRectangle":"0.4,0,1.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Line}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"SystemVariables"},"2":{"Ident":"StiText","Name":"Text30","ClientRectangle":"6,0,5.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.VirobnikNameUA}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true}},"3":{"Ident":"StiText","Name":"Text32","ClientRectangle":"17.2,0,2.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.cat_name}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"4":{"Ident":"StiText","Name":"Text2","Guid":"3bc716a579096490ba53dd466ce4b5a4","ClientRectangle":"14.2,0,3,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.NameUA}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:Black","TextOptions":{"WordWrap":true},"Type":"Expression"},"5":{"Ident":"StiText","Name":"Text4","Guid":"6e49133105c1c25deaf2ac647b6d6975","ClientRectangle":"22.4,0,4.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.part_num}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"6":{"Ident":"StiText","Name":"Text9","Guid":"aac23a9075523f7f612b2fe869362439","ClientRectangle":"19.6,0,2.8,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.generation_name}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"7":{"Ident":"StiText","Name":"Text15","Guid":"48404e8aca85cd64264f71e15844a039","ClientRectangle":"1.6,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.zajavn}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"8":{"Ident":"StiText","Name":"Text19","Guid":"1fedd4db334d52da052611b2b9062fdc","ClientRectangle":"33.4,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF( (Year(dp2_zajavka_obsteg.cert_date) <2000), \"\" ,dp2_zajavka_obsteg.cert_date.ToString(\"dd.MM.yyyy \"))}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"9":{"Ident":"StiText","Name":"Text29","Guid":"8d8eac3934b08ae170fba4874b862bdf","ClientRectangle":"3.8,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF( (Year(dp2_zajavka_obsteg.zajav_date) <2000), \"\" ,dp2_zajavka_obsteg.zajav_date.ToString(\"dd.MM.yyyy \"))}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"10":{"Ident":"StiText","Name":"Text21","Guid":"6e2b14f5b720571fc4ecbfb9f8031122","ClientRectangle":"35.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.cert_podg_aud_fio}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"11":{"Ident":"StiText","Name":"Text33","Guid":"88442bbd762726b599a2e50ddc373164","ClientRectangle":"37.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF(dp2_zajavka_obsteg.is_cert != 1,(IIF(dp2_zajavka_obsteg.is_cond == 0, \"не видано\",\"\")),\"відправлено поштою\")}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"12":{"Ident":"StiText","Name":"Text34","Guid":"8b6927b799b4feafa885996839d0e2be","ClientRectangle":"31.2,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.zajavn}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"13":{"Ident":"StiText","Name":"Text10","Guid":"e2d307a92e2a8d51d4e969d3aef6d2ea","ClientRectangle":"26.8,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.zajavn}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"14":{"Ident":"StiText","Name":"Text16","Guid":"dc124170abcf89a890b86767180d2004","ClientRectangle":"29,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF( (Year(dp2_zajavka_obsteg.prot_vypr_date) <2000), \"\" ,dp2_zajavka_obsteg.prot_vypr_date.ToString(\"dd.MM.yyyy \"))}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"}},"DataSourceName":"dp2_zajavka_obsteg"}},"PaperSize":"A3","Orientation":"Landscape","PageWidth":42,"PageHeight":29.699999999999999,"Watermark":{"TextBrush":"solid:50,0,0,0"},"Margins":{"Left":1,"Right":1,"Top":1,"Bottom":2}}}}