Sestava pro účto (CC)

Sestava pro účto (CC)

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

Nesoučtovaná

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

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