KARAT Demo Driver={Adaptive Server Anywhere 8.0 KARAT};Eng=MHJ;Dbn=KARAT_DEMO;Dbf=C:\Karat_demo_102\data\karat_demo.db;Uid=dba;Pwd=demodemo; KARAT Demo False fv_polozky DOKLAD,System.String PORADI,System.String FISKALNI_ROK,System.String TYPPOL,System.String DRUHPOL,System.String ID_KARTY,System.String NOMENKLATURA,System.String TYP_POLOZKY,System.Int64 NAZEV,System.String OBALY_REZIM,System.Int64 POPIS,System.String MNOZSTVI_VYD,System.String MJ_VYD,System.String KOEF_MJ_VYD,System.String CENIK,System.String CENIK_PORADI,System.Int64 MJ_CEN,System.String KOEF_MJ_CEN,System.String CENA_CENIK,System.String SLEVA,System.String CENA_MJ_BEZ_DPH,System.String STRANA,System.Int64 UCET,System.String STREDISKO,System.String ZAKAZKA_TYP,System.String ZAKAZKA,System.String CINNOST,System.String DEALER,System.String VAR_SYMBOL,System.String PAR_ZNAK,System.String DATSPL,System.DateTime STAT_DPH,System.String KDPH,System.String DPH_SAZBA,System.String ID_SAZBY,System.String RADEK_CELKEM,System.String DEVIZY,System.String ID_MENY,System.String KOD_KURZ_LISTKU,System.String KURZ,System.String MNOZSTVI,System.String CASTKA,System.String ID_MENY_,System.String KOD_KURZ_LISTKU_,System.String KURZ_,System.String MNOZSTVI_,System.String DEVIZY_,System.String NU,System.String NU_MNOZSTVI,System.String STORNO,System.Int64 KONTACE,System.String MESIC,System.String POVAHA,System.Int64 PORIZENO,System.Int64 VL_MODUL,System.String VL_AGENDA,System.String VL_DOKLAD,System.String VL_POLOZKA,System.Int64 PRD_MODUL,System.String PRD_AGENDA,System.String PRD_DOKLAD,System.String PRD_PORADI,System.String UK_STAV_FV,System.Int64 UK_STAV_FV_D,System.Int64 UK_STAV_FV_U,System.Int64 ROZVEZENO,System.Int64 DPH_POLOZKY,System.Int64 AUTOR,System.String TS,System.DateTime XCMD,System.String XPRAVO,System.String XATTACH,System.Int64 id_meny_dph,System.String devizy_dph,System.String 30 fv_polozky KARAT Demo select * from fv_polozky karty ID_KARTY,System.String SKLAD,System.String KARTA,System.String TYP,System.Int64 NAZEV,System.String SKUPINA_KARET,System.String SESTAVA,System.Int64 POHYB_S,System.Int64 STAV_EV,System.String STAV_RT,System.String MIN_STAV,System.String MAX_STAV,System.String NEREZ_STAV,System.String PRUM_CENA,System.String PEVNA_CENA,System.String POSL_CENA,System.String LZE_MINUS,System.Int64 LZE_MINUS_RT,System.Int64 TYP_ATRIBUTU,System.String ATTR_LZE_MINUS,System.Int64 ATTR_LZE_MINUS_RT,System.Int64 ID_MJ_EVID,System.String ID_MJ_P,System.String ID_MJ_V,System.String ID_MJ_OP,System.String ID_MJ_OV,System.String POZNAMKA,System.String LZE_NAKLADY,System.Int64 ZAHRNOUT_DO_SN,System.Int64 CENA_POR_CELKEM,System.String FIFO_KONEC,System.String PLATNOST,System.Int64 SLEVNIT,System.Int64 STAV_RT2,System.String ID_MJ_EVID2,System.String DOKLAD_INV,System.String DATUM_INV,System.DateTime STRATNE,System.String ZPUSOB_KONTROLY,System.Int64 MAX_ODCHYLKA,System.String UMISTENI,System.String UMISTENI_NAHR,System.String VYPOCET_VYSKL,System.Int64 ZARUKA_V,System.Int64 ZARUKA,System.Int64 LHUTA_VYSKL,System.Int64 DAT_PRIJEM,System.Int64 ID_DODAVATELE,System.String SN,System.String OBJEDNANO_N,System.String OBJEDNANO_B,System.String OBJEDNANO,System.String BLOKACE,System.String REZERVACE,System.String OBJEDNANO_V,System.String OBJEDNANO_V_N,System.String VPR_SUM,System.String VPR_SUM_REZ,System.String OBJ_P_SKL,System.String OBJ_P_VPR,System.String OBJ_P_OV,System.String OBJ_P_NEV,System.String VKLADAT_NULOVE_DILY,System.Int64 AUTOR,System.String TS,System.DateTime XCMD,System.String XPRAVO,System.String XATTACH,System.Int64 delka_dodani,System.Int64 id_mj_vyr,System.String id_mj_exp,System.String lze_prijem,System.Int64 lze_vydej,System.Int64 disp_stav,System.String typ_skladu,System.Int64 virt_sklad,System.String pozadavky,System.Int64 id_meny,System.String min_stav_a,System.String max_stav_a,System.String id_dodavatele_ext,System.String 30 karty KARAT Demo select * from karty fv_zahlavi DOKLAD,System.String FISKALNI_ROK,System.String DENIK,System.String RADA,System.String ID_INSTALACE,System.String PRAVO,System.String CITAC,System.String DRUH_DOKLADU,System.String TYP_DOKLADU,System.Int64 DOKLAD_K_FA,System.String DOBROPISOVANO,System.Int64 DATSKU,System.DateTime MESIC,System.String TYP_ZAH,System.String ID_POSTY,System.String ID_BAN,System.String ID_BAN_POR,System.Int64 ID_OTCE,System.String ID_ADR_OTCE,System.Int64 ID_PARTNERA,System.String ICO,System.String DIC,System.String KOD_PARTNERA,System.String ZKRACENY_NAZEV,System.String ID_ADRPAR,System.Int64 ID_BANPAR,System.Int64 ID_SMLOUVY,System.String CENIK,System.String OBJEDNAVKA,System.String ID_ODBERATELE,System.String ID_ADRESY_ODB,System.Int64 DAT_VYST,System.DateTime DAT_SPL,System.DateTime DAT_ZD_PLN,System.DateTime MES_DPH,System.String OBDOBI_DPH,System.String UCET,System.String STREDISKO,System.String ZAKAZKA_TYP,System.String ZAKAZKA,System.String CINNOST,System.String DEALER,System.String VAR_SYMBOL,System.String PAR_ZNAK,System.String CELNI_REZIM,System.Int64 STAT_DPH,System.String DAN_REZIM,System.Int64 DPH_POVAHA,System.String DPH_POLOZKY,System.Int64 SPEC_SYMBOL,System.String KONST_SYMBOL,System.String TYP_PLATTIT,System.String FORMA_UHRADY,System.String HRADIT_IHNED,System.Int64 DODACI_PODMINKY,System.String F_TEXT_1,System.String KOD_POZN_1,System.String KOD_POZN_2,System.String F_POZN_1,System.String F_POZN_2,System.String PREDMET_PLNENI,System.String PRV_POZN_1,System.String PRV_POZN_2,System.String KOD_KURZ_LISTKU,System.String DEVIZY,System.String DEVIZY_ZALOHA,System.String DEVIZY_K_UHRADE,System.String DEVIZY_ZAOKROUHLENI,System.String ID_MENY,System.String KURZ,System.String MNOZSTVI,System.String CASTKA,System.String ZALOHA,System.String CASTKA_K_UHRADE,System.String ZAOKROUHLENI,System.String HRADIT,System.Int64 UHRAZENO,System.Int64 UHRAZENO_DEVIZY,System.String UHRAZENO_CASTKA,System.String UHRAZENO_DATUM,System.DateTime UHRAZENO_P,System.Int64 UHRAZENO_P_CASTKA,System.String UHRAZENO_P_DEVIZY,System.String UHRAZENO_P_DATUM,System.DateTime UPOMINKA,System.Int64 UPOMINKA_POCET,System.Int64 UPOMINKA_DATUM,System.DateTime PENALE_KOD,System.String PENALE,System.Int64 PENALE_PROC,System.String UZNANI,System.Int64 UZNANI_POCET,System.Int64 UZNANI_DATUM,System.DateTime ROZVEZENO,System.Int64 STAV,System.Int64 UK_STAV_FV,System.Int64 UK_STAV_FV_U,System.Int64 UK_STAV_FV_D,System.Int64 STORNO,System.Int64 STAV0_AUTOR,System.String STAV1_AUTOR,System.String STAV2_AUTOR,System.String STAV8_AUTOR,System.String STAV9_AUTOR,System.String STAV0_DATUM,System.DateTime STAV1_DATUM,System.DateTime STAV2_DATUM,System.DateTime STAV8_DATUM,System.DateTime STAV9_DATUM,System.DateTime STORNO_AUTOR,System.String STORNO_DATUM,System.DateTime UK_PROV,System.Int64 SK_PROV,System.Int64 OPR_PROV,System.Int64 ODESLANO,System.Int64 PROFORMA,System.Int64 PORIZENO,System.Int64 MOJE_ID,System.Int64 AUTOR,System.String TS,System.DateTime XCMD,System.String XPRAVO,System.String XATTACH,System.Int64 id_posty_poz,System.String id_posty_dor,System.DateTime devizy_bez_dph,System.String castka_bez_dph,System.String fm_written,System.Int64 doklad_k_fa_por,System.String id_koresp,System.String id_adr_kor,System.Int64 id_oso_vyr,System.Int64 modul_zdr,System.String agenda_zdr,System.String doklad_zdr,System.String id_par_oso,System.Int64 id_odb_oso,System.Int64 id_meny_dph,System.String kkl_dph,System.String mnozstvi_dph,System.String kurz_dph,System.String zpus_dph_zal,System.Int64 30 fv_zahlavi KARAT Demo select * from fv_zahlavi DataSource1 ZKRACENY_NAZEV,System.Object SKUPINA_KARET,System.Object MNOZSTVI_VYD,System.Decimal DataSource1 CrossTab1 Vazba mezi polozkami FV a KARTOU ID_KARTY Vazba mezi polozkami FV a KARTOU Vztah ID_KARTY Vazba mezi hlavickou a polozkami FV DOKLAD Vazba mezi hlavickou a polozkami FV Vztah2 DOKLAD EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,2 Transparent 0,0,19,2 Arial,36,Bold| Underline Center 0,0,0,0 Text Krizova tabuka s vazbami [237:28:36] Center ReportTitleBand Transparent 0,3.2,19,7.6 Transparent 1.4,0.2,15.8,7 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 5.65,0.45,0.8,0.4 Arial,9,Bold,Point,False,238 ec1c9605d4a54fe0b516d13a99fb6fe9 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,1.3,2.8,0.4 Arial,9,Bold,Point,False,238 6617880d09c14a8082ca72e05ada61fc 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 0,0.45,2.8,0.4 Arial,9.75,Bold,Point,False,238 91179cac42ba477995f7debb387b4903 0,0,0,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange POKUSNY ZKRACENY NAZEV [105:105:105] Row:CrossTab1_Row1 All;[155:155:155];1;Solid;False;4;Black White 0,0,2.8,0.4 Arial,8 c3b4aa2a2f544ce7af53748d79c87b99 0,0,0,0 CrossTab1_LeftTitle AllowMove, AllowResize, AllowSelect, AllowChange [105:105:105] LeftTitle ZKRACENY_NAZEV All;[155:155:155];1;Solid;False;4;Black White 0,0.9,2.8,0.4 {fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.ZKRACENY_NAZEV} Arial,9,Bold,Point,False,238 f08d104049294f749d2a94e1bcacede9 0,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange ByValue ZKRACENY_NAZEV [105:105:105] 6617880d09c14a8082ca72e05ada61fc {fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.ZKRACENY_NAZEV} SKUPINA_KARET All;[155:155:155];1;Solid;False;4;Black White 2.85,0.45,2.8,0.4 {fv_polozky.Vazba_mezi_polozkami_FV_a_KARTOU.SKUPINA_KARET} Arial,9,Bold,Point,False,238 ef79bd4a90fa480dbfff4ebbefdb8906 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange ByValue SKUPINA_KARET [105:105:105] ec1c9605d4a54fe0b516d13a99fb6fe9 {fv_polozky.Vazba_mezi_polozkami_FV_a_KARTOU.SKUPINA_KARET} MNOZSTVI_VYD All;[155:155:155];1;Solid;False;4;Black [255:255:255] 2.85,0.9,2.8,0.4 Arial,8.25,Regular,Point,False,238 711d68c9afaa472fb8b686109ee7c3a3 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black ,   1 {fv_polozky.MNOZSTVI_VYD} All;[155:155:155];1;Solid;False;4;Black White 2.85,0,3.6,0.4 Arial,9.75,Bold,Point,False,238 73d27588fe354383bea41ac8bc456118 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange POKUSNA SKUPINA KARET [105:105:105] RightTitle fv_polozky CrossTab1 DataBand1 Transparent 0,11.6,19,6.8 True 52, 48, 56 GradientBrush,[255:255:255],[242:238:246],90 100, 52, 48, 56 100, 52, 48, 56 Silver Gainsboro False 100, 52, 48, 56 100, 52, 48, 56 [10:102:98:106] [10:102:98:106] 52, 48, 56 Tahoma,8 52, 48, 56 0 0 52, 48, 56 Tahoma,8 52, 48, 56 52, 48, 56 Tahoma,8 52, 48, 56 0 0 52, 48, 56 Tahoma,8 52, 48, 56 [255:255:255] 0.6,0.4,18,6 DataSource1

52, 48, 56 GradientBrush,[255:255:255],[222:218:226],90 Arial,8 52, 48, 56 10, 10 52, 48, 56 Arial,14,Bold

Chart1 DataSource1.ZKRACENY_NAZEV 106, 85, 2 [206:185:102] Black White Arial,7 Black 8, 6 - DataSource1.MNOZSTVI_VYD DataSource1.ZKRACENY_NAZEV 56, 76, 32 [156:176:132] Black White Arial,7 Black 8, 6 - DataSource1.MNOZSTVI_VYD DataSource1.ZKRACENY_NAZEV 7, 77, 101 [107:177:201] Black White Arial,7 Black 8, 6 - DataSource1.MNOZSTVI_VYD 52, 48, 56 [202:198:206] Arial,7 52, 48, 56 8, 6 - ASC ZKRACENY_NAZEV