|
|
| Řádek 1: |
Řádek 1: |
| ''Sestava pro účto (CC)''
| |
|
| |
|
| [[Image: Sestava pro ucto-cc.png|590px]]
| |
| <small>
| |
|
| |
| select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,
| |
| P.id_uc_dim2,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,
| |
| P.id_uc_dim3,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,
| |
| sum (castka) as uhrn_kc
| |
| from par_ucty_tyco P, kody_uc A, ciselnik C where
| |
| 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 >=%DATUMOD% and P.datum <=%DATUMDO%
| |
| group by
| |
| A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1, P.id_uc_dim2, P.id_uc_dim3
| |
|
| |
| union all
| |
| (
| |
| select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,
| |
| P.id_uc_dim2,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,
| |
| P.id_uc_dim3,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,
| |
| sum (castka) as uhrn_kc
| |
| from par_ucty_tyco P, kody_uc A, kody_uc_zp B, pracovnici PR where
| |
| P.kod = B.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)
| |
| and P.datum >=%DATUMOD% and P.datum <=%DATUMDO%
| |
|
| |
| group by
| |
| A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1, P.id_uc_dim2, P.id_uc_dim3
| |
| )
| |
|
| |
| order by
| |
| A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1, P.id_uc_dim2, P.id_uc_dim3
| |
|
| |
| </small>
| |
|
| |
| == Nesoučtovaná ==
| |
| [[Image: Sestava pro ucto-Nesouctovana-cc.png|590px]]
| |
|
| |
| <small>
| |
| select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.os_cislo, P.cislo_pom,
| |
| P.id_uc_dim1,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,
| |
| P.id_uc_dim2,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,
| |
| P.id_uc_dim3,
| |
| (select DIM.nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,
| |
| P.castka, P.datum, P.poznamka
| |
| from par_ucty_tyco P, kody_uc A, ciselnik C where
| |
| 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 >=%DATUMOD% and P.datum <=%DATUMDO%
| |
|
| |
| union all
| |
|
| |
| select A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.os_cislo, P.cislo_pom,
| |
| P.id_uc_dim1,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 1 and DIM.id = P.id_uc_dim1) as nazev1,
| |
| P.id_uc_dim2,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 2 and DIM.id = P.id_uc_dim2) as nazev2,
| |
| P.id_uc_dim3,
| |
| (select nazev from uc_dim DIM where DIM.typ_dimenze = 3 and DIM.id = P.id_uc_dim3) as nazev3,
| |
| P.castka, P.datum, P.poznamka
| |
| from par_ucty_tyco P, kody_uc A, kody_uc_zp B, pracovnici PR where
| |
| P.kod = B.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)
| |
| and P.datum >=%DATUMOD% and P.datum <=%DATUMDO%
| |
|
| |
| order by
| |
| A.kod_uc, A.ucet_md, A.ucet_dal, A.nazev,
| |
| P.id_uc_dim1, P.id_uc_dim2, P.id_uc_dim3
| |
| </small>
| |
|
| |
| == Omezení ==
| |
| * Sestavy jsou koncipovány pro variantu: standardní a účtování po zdravotních pojišťovnách
| |
| * Nejsou sestaveny pro variantu: účtování po pracovních kategoriích (záporné kódy účtování v číselníku mzd.položek).
| |
|
| |
| == Odkazy ==
| |
| * [[Úpravy CC]]
| |
