https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Sestava_pro_%C3%BA%C4%8Dto_nesou%C4%8Dtovan%C3%A1_%28%C3%9A%C4%8Detnictv%C3%AD_cc%29 Sestava pro účto nesoučtovaná (Účetnictví cc) - Historie editací 2026-10-17T11:24:19Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Sestava_pro_%C3%BA%C4%8Dto_nesou%C4%8Dtovan%C3%A1_(%C3%9A%C4%8Detnictv%C3%AD_cc)&diff=37603&oldid=prev Petrm v 3. 12. 2019, 15:04 2019-12-03T15:04:56Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 3. 12. 2019, 17:04</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">''Sestava pro účto nesoučtovaná ([[Účetnictví cc]])''</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Sestava-Ucto-Nesouctovana-cc.png|950px]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image: Sestava-Ucto-Nesouctovana-cc.png|950px]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l34">Řádek 34:</td> <td colspan="2" class="diff-lineno">Řádek 36:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/small&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/small&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Omezení ==</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Sestava je koncipována pro variantu: standardní a účtování po zdravotních pojišťovnách</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Není sestavena pro variantu: účtování po pracovních kategoriích (záporné kódy účtování v číselníku mzd.položek).</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Odkazy ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Odkazy ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Účetnictví cc]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[Účetnictví cc]]</div></td></tr> </table> Petrm https://prirucky.ksprogram.cz/index.php?title=Sestava_pro_%C3%BA%C4%8Dto_nesou%C4%8Dtovan%C3%A1_(%C3%9A%C4%8Detnictv%C3%AD_cc)&diff=37602&oldid=prev Petrm: Založena nová stránka: 950px <small> select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev, P.os_cislo, PR.prijmeni, PR.jmeno, P.cislo_pom, P.id_uc_dim1… 2019-12-03T15:03:14Z <p>Založena nová stránka: <a href="/index.php?title=Soubor:Sestava-Ucto-Nesouctovana-cc.png" title="Soubor:Sestava-Ucto-Nesouctovana-cc.png">950px</a> &lt;small&gt; select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev, P.os_cislo, PR.prijmeni, PR.jmeno, P.cislo_pom, P.id_uc_dim1…</p> <p><b>Nová stránka</b></p><div>[[Image: Sestava-Ucto-Nesouctovana-cc.png|950px]]<br /> <br /> &lt;small&gt;<br /> select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev, <br /> P.os_cislo, PR.prijmeni, PR.jmeno, P.cislo_pom,<br /> P.id_uc_dim1, <br /> (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,<br /> P.id_uc_dim2, <br /> (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,<br /> P.id_uc_dim3, <br /> (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,<br /> P.kod, C.vyznam, P.castka, P.datum, P.poznamka<br /> from par_ucty_tyco P, kody_uc A, ciselnik C, pracovnici PR where<br /> P.os_cislo = PR.os_cislo and<br /> P.kod = C.kod and C.kod_uc = A.kod_uc and P.kod not in (select distinct kod from kody_uc_zp) and P.datum &gt;=%DATUMOD% and P.datum &lt;=%DATUMDO%<br /> <br /> union all<br /> <br /> select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev, <br /> P.os_cislo, PR.prijmeni, PR.jmeno, P.cislo_pom,<br /> P.id_uc_dim1, <br /> (select nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,<br /> P.id_uc_dim2, <br /> (select nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,<br /> P.id_uc_dim3, <br /> (select nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,<br /> P.kod, C.vyznam, P.castka, P.datum, P.poznamka<br /> from par_ucty_tyco P, kody_uc A, kody_uc_zp B, ciselnik C, pracovnici PR where<br /> P.kod = B.kod and P.kod = C.kod and B.kod_uc = A.kod_uc and B.cis_poj = PR.zdrav_poj and PR.os_cislo = P.os_cislo and P.kod in (select distinct kod from kody_uc_zp)<br /> and P.datum &gt;=%DATUMOD% and P.datum &lt;=%DATUMDO%<br /> <br /> order by <br /> P.os_cislo, P.cislo_pom, P.kod, P.datum<br /> &lt;/small&gt;<br /> <br /> <br /> == Odkazy ==<br /> * [[Účetnictví cc]]</div> Petrm