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
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.6,0.2,15.8,7
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
11.02,0.45,1.39,0.8
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]
5,1.7,3.2,0.4
Arial,9,Bold,Point,False,238
6617880d09c14a8082ca72e05ada61fc
0,0,0,0
CrossTab1_RowTotal3
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.45,2.6,0.8
Arial,9.75,Bold,Point,False,238
91179cac42ba477995f7debb387b4903
0,0,0,0
CrossTab1_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
ROK FISKALNI
[105:105:105]
Row:CrossTab1_Row1
All;[155:155:155];1;Solid;False;4;Black
White
0,0,8.2,0.4
Arial,8
c3b4aa2a2f544ce7af53748d79c87b99
0,0,0,0
CrossTab1_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,2.5,8.2,0.4
Arial,8
8a78e58bc1224d28af00d329e23c2c56
0,0,0,0
CrossTab1_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
2.6,0.45,2.4,0.8
Arial,8
4b4c7625f8974f45be651b5cf3a09564
0,0,0,0
CrossTab1_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
MESIC FISKALNI
[105:105:105]
Row:CrossTab1_Row2
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.6,2.1,5.6,0.4
Arial,8
4c90561de9034c6081282712f238b77a
0,0,0,0
CrossTab1_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
5,0.45,3.2,0.8
Arial,8
93188979263c4fba801b1ec0bb810fa9
0,0,0,0
CrossTab1_Row3_Title
AllowMove, AllowResize, AllowSelect, AllowChange
NAZEV ZKRACENY
[105:105:105]
Row:CrossTab1_Row3
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
9.91,0.85,1.11,0.4
Arial,8
7e86fb4449064a4a8e356dbfd82373e5
0,0,0,0
CrossTab1_ColTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
FISKALNI_ROK
All;[155:155:155];1;Solid;False;4;Black
White
0,1.3,2.6,1.2
{fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.FISKALNI_ROK}
Arial,8
f2210af8c04247d7a13b04be626d5864
0,0,0,0
CrossTab1_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
FISKALNI_ROK
[105:105:105]
8a78e58bc1224d28af00d329e23c2c56
{fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.FISKALNI_ROK}
MESIC
All;[155:155:155];1;Solid;False;4;Black
White
2.6,1.3,2.4,0.8
{fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.MESIC}
Arial,8
38ce228f6b9740e8a4c106c4ce61fe7f
0,0,0,0
CrossTab1_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
MESIC
[105:105:105]
4c90561de9034c6081282712f238b77a
{fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.MESIC}
ZKRACENY_NAZEV
All;[155:155:155];1;Solid;False;4;Black
White
5,1.3,3.2,0.4
{fv_polozky.Vazba_mezi_hlavickou_a_polozkami_FV.ZKRACENY_NAZEV}
Arial,9,Bold,Point,False,238
f08d104049294f749d2a94e1bcacede9
0,0,0,0
CrossTab1_Row3
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
8.25,0.45,2.77,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}
KARTA
All;[155:155:155];1;Solid;False;4;Black
White
8.25,0.85,1.66,0.4
{fv_polozky.Vazba_mezi_polozkami_FV_a_KARTOU.KARTA}
Arial,8
1c2522fcffc241debb70bdb0b8fa2705
0,0,0,0
CrossTab1_Column2
AllowMove, AllowResize, AllowSelect, AllowChange
KARTA
[105:105:105]
7e86fb4449064a4a8e356dbfd82373e5
{fv_polozky.Vazba_mezi_polozkami_FV_a_KARTOU.KARTA}
MNOZSTVI_VYD
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
8.25,1.3,1.66,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
8.25,0,4.16,0.4
Arial,8
246a8376d8e94c81b089bd58249e6ff6
0,0,0,0
CrossTab1_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
SKUPINA_KARET, KARTA
[105:105:105]
RightTitle
fv_polozky
CrossTab1
DataBand1
2c374cd3548c43868004c0d8a66611c6
1,1,1,1
Page1
29.7
21
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Sestava
8/4/2010 9:48:01 AM
7/29/2010 10:58:34 AM
C:\Dokumenty\Prace\KARAT\StimulSoft\Reporty\Sestava_cross_vice urovnove vazby.mrt
adf77bba331246cc901d4bfcdebdb2ee
Sestava
Centimeters
2010.1.700
CSharp