|
|
| (Není zobrazeno 378 mezilehlých verzí od stejného uživatele.) |
| Řádek 1: |
Řádek 1: |
| Souhrn kódů účtování (sestava)
| |
|
| |
|
|
| |
|
| |
| select A.kod, A.vyznam, A.kod_uc, abs(null) as kod_uc_zp, abs(null) as cis_poj, abs(null) as prac_kateg,
| |
| B.id_podniku, B.ucet_md, B.ucet_dal, B.nazev
| |
| from ciselnik A, kody_uc B
| |
| where
| |
| A.kod_uc = B.kod_uc and
| |
| A.kod_uc >=0
| |
|
| |
| union
| |
|
| |
| select A.kod, A.vyznam, A.kod_uc, abs(null) as kod_uc_zp, abs(null) as cis_poj, C.prac_kateg,
| |
| B.id_podniku, B.ucet_md, B.ucet_dal, B.nazev
| |
| from ciselnik A, kody_uc B, uc_kateg C
| |
| where
| |
| A.kod_uc = C.zpusob_uc and
| |
| C.kod_uc = B.kod_uc and
| |
| A.kod_uc < 0
| |
|
| |
| union
| |
|
| |
| select A.kod, A.vyznam, A.kod_uc, D.kod_uc as kod_uc_zp, D.cis_poj, abs(null) as prac_kateg,
| |
| B.id_podniku, B.ucet_md, B.ucet_dal, B.nazev
| |
| from ciselnik A, kody_uc B, kody_uc_zp D
| |
| where
| |
| D.kod_uc = B.kod_uc and
| |
| A.kod in (902, 903, 904, 999) and D.kod_uc >=0
| |
|
| |
| union
| |
|
| |
| select A.kod, A.vyznam, A.kod_uc, D.kod_uc as kod_uc_zp, D.cis_poj, C.prac_kateg,
| |
| B.id_podniku, B.ucet_md, B.ucet_dal, B.nazev
| |
| from ciselnik A, kody_uc B, uc_kateg C, kody_uc_zp D
| |
| where
| |
| D.kod_uc = C.zpusob_uc and
| |
| C.kod_uc = B.kod_uc and
| |
| A.kod in (902, 903, 904, 999) and D.kod_uc <0
| |
