PVPOJ 2023: Porovnání verzí
Z Prirucky
| Řádek 12: | Řádek 12: | ||
[[Image: PVPOJ 2023 v10-3.png|400px]] | [[Image: PVPOJ 2023 v10-3.png|400px]] | ||
[[Image: PVPOJ 2023 v10-4.png|400px]] | [[Image: PVPOJ 2023 v10-4.png|400px]] | ||
== Položky == | |||
B.3 <small> | |||
select sum(soc_zakl) FROM pom_mes where datum = '2023-01-01' and os_cislo in (select os_cislo from pracovnici where id_podniku = 1)and sp_vyssi = 1; | |||
B.4 | |||
select sum (castka) from pichacky where kod = 998 and typ_vazby = 'sv' and datum = '2023-01-01' and id_podniku = 1; | |||
== Odkazy == | == Odkazy == | ||
* [[PVPOJ]] | * [[PVPOJ]] | ||
Verze z 26. 1. 2023, 15:17
PVPOJ 2023
C. Slevy na pojistném
Ukázka formuláře
Položky
B.3
select sum(soc_zakl) FROM pom_mes where datum = '2023-01-01' and os_cislo in (select os_cislo from pracovnici where id_podniku = 1)and sp_vyssi = 1;
B.4
select sum (castka) from pichacky where kod = 998 and typ_vazby = 'sv' and datum = '2023-01-01' and id_podniku = 1;
