Pomocný soubor rozpadu norem
| Pole | SQL | Typ | Popis |
|---|---|---|---|
| idpk | idpk | Long(18) | ID záznamu |
| version | version | Long(18) | Technický sloupec - verze |
| poradiN | poradi_n | Long(18) | Pořadí |
| idpkHlav | idpk_hlav | Long(18) | |
| idpkKthn | idpk_kthn | Long(18) | |
| idpkKthn1Po | idpk_kthn1_po | Long(18) | |
| idpkPolKthnPo | idpk_pol_kthn_po | Long(18) | |
| idpkKtpo | idpk_ktpo | Long(18) | |
| idpkKtpo1Po | idpk_ktpo1_po | Long(18) | |
| idpkPolKtpoPo | idpk_pol_ktpo_po | Long(18) | |
| idpkPolLcicenPo | idpk_pol_lcicen_po | Long(18) | |
| cisNormZaklHl | cis_norm_zakl_hl | String(15) | |
| cisNormRozHl | cis_norm_roz_hl | String(5) | |
| cisZakHl | cis_zak_hl | String(20) | |
| cisOperHl | cis_oper_hl | Short(4) | |
| doplHl | dopl_hl | String(10) | |
| datPlatDoHl | dat_plat_do_hl | Integer(8) | |
| datPlatOdHl | dat_plat_od_hl | Integer(8) | |
| datPlatDoNHl | dat_plat_do_n_hl | Date(23) | |
| datPlatOdNHl | dat_plat_od_n_hl | Date(23) | |
| cisNormZaklPo | cis_norm_zakl_po | String(15) | |
| cisNormRozPo | cis_norm_roz_po | String(5) | |
| cisZakPo | cis_zak_po | String(20) | |
| cisOperPo | cis_oper_po | Short(4) | |
| doplPo | dopl_po | String(10) | |
| datPlatDoPo | dat_plat_do_po | Integer(8) | |
| datPlatOdPo | dat_plat_od_po | Integer(8) | |
| pozVykr | poz_vykr | String(10) | |
| cisNoZaklPolPo | cis_no_zakl_pol_po | String(15) | |
| cisNoRozPolPo | cis_no_roz_pol_po | String(5) | |
| cisZakPolPo | cis_zak_pol_po | String(20) | |
| cisOperPolPo | cis_oper_pol_po | Short(4) | |
| doplPolPo | dopl_pol_po | String(10) | |
| datPlatDoPolPo | dat_plat_do_pol_po | Integer(8) | |
| datPlatOdPolPo | dat_plat_od_pol_po | Integer(8) | |
| puvodPo | puvod_po | Character(1) | |
| koefPrep | koef_prep | BigDecimal(18,6) | |
| mnoPo | mno_po | BigDecimal(18,6) | |
| mnoPlusPo | mno_plus_po | BigDecimal(18,6) | |
| kthnStupZanor | kthn_stup_zanor | Integer(9) | |
| kthnPozMno | kthn_poz_mno | BigDecimal(18,6) | |
| kthnMno1 | kthn_mno1 | BigDecimal(18,6) | |
| kthnMno2 | kthn_mno2 | BigDecimal(18,6) | |
| kthnMno3 | kthn_mno3 | BigDecimal(18,6) | |
| kthnDavka | kthn_davka | BigDecimal(18,6) | |
| kthnDavkaPocet | kthn_davka_pocet | BigDecimal(18,6) | |
| kthnMnoPocet | kthn_mno_pocet | BigDecimal(18,6) | |
| kthnMnoZbytek | kthn_mno_zbytek | BigDecimal(18,6) | |
| kthnDavka1 | kthn_davka1 | BigDecimal(18,6) | |
| kthnDavkaPocet1 | kthn_davka_pocet1 | BigDecimal(18,6) | |
| kthnMnoPocet1 | kthn_mno_pocet1 | BigDecimal(18,6) | |
| kthnMnoZbytek1 | kthn_mno_zbytek1 | BigDecimal(18,6) | |
| kthnDavka2 | kthn_davka2 | BigDecimal(18,6) | |
| kthnDavkaPocet2 | kthn_davka_pocet2 | BigDecimal(18,6) | |
| kthnMnoPocet2 | kthn_mno_pocet2 | BigDecimal(8,6) | |
| kthnMnoZbytek2 | kthn_mno_zbytek2 | BigDecimal(18,6) | |
| kthnDavka3 | kthn_davka3 | BigDecimal(18,6) | |
| kthnDavkaPocet3 | kthn_davka_pocet3 | BigDecimal(18,6) | |
| kthnMnoPocet3 | kthn_mno_pocet3 | BigDecimal(18,6) | |
| kthnMnoZbytek3 | kthn_mno_zbytek3 | BigDecimal(18,6) | |
| kthnDavka4 | kthn_davka4 | BigDecimal(18,6) | |
| kthnDavkaPocet4 | kthn_davka_pocet4 | BigDecimal(18,6) | |
| kthnMnoPocet4 | kthn_mno_pocet4 | BigDecimal(18,6) | |
| kthnMnoZbytek4 | kthn_mno_zbytek4 | BigDecimal(18,6) | |
| kthnDavka5 | kthn_davka5 | BigDecimal(18,6) | |
| kthnDavkaPocet5 | kthn_davka_pocet5 | BigDecimal(18,6) | |
| kthnMnoPocet5 | kthn_mno_pocet5 | BigDecimal(18,6) | |
| kthnMnoZbytek5 | kthn_mno_zbytek5 | BigDecimal(18,6) | |
| cisVyr | cis_vyr | String(15) | |
| datum1 | datum1 | Integer(8) | |
| datum2 | datum2 | Integer(8) | |
| datum1N | datum1_n | Date(23) | |
| datum2N | datum2_n | Date(23) | |
| skupina | skupina | String(8) | |
| smena | smena | Character(1) | |
| stroj | stroj | String(8) | |
| sklad | sklad | String(5) | |
| zakazka | zakazka | String(20) | |
| zdroj | zdroj | String(20) | |
| zdrojX | zdroj_x | String(40) | |
| hodn1 | hodn1 | String(20) | |
| hodn2 | hodn2 | String(20) | |
| hodn3 | hodn3 | String(30) | |
| hodn4 | hodn4 | String(30) | |
| cislo1 | cislo1 | BigDecimal(18,6) | |
| cislo2 | cislo2 | BigDecimal(18,6) | |
| cislo3 | cislo3 | BigDecimal(18,6) | |
| cislo4 | cislo4 | BigDecimal(18,6) | |
| misto1 | misto1 | String(10) | |
| misto2 | misto2 | String(10) | |
| prizn1 | prizn1 | Character(1) | |
| prizn2 | prizn2 | Character(1) | |
| idpkZdroje | idpk_zdroje | Long(18) | |
| idpkZdroje2 | idpk_zdroje_2 | Long(18) | |
| cislo5 | cislo5 | BigDecimal(18,6) | |
| cislo6 | cislo6 | BigDecimal(18,6) | |
| cislo7 | cislo7 | BigDecimal(18,6) | |
| cislo8 | cislo8 | BigDecimal(18,6) | |
| cislo9 | cislo9 | BigDecimal(18,6) | |
| cislo10 | cislo10 | BigDecimal(18,6) | |
| kalPolHl | kal_pol_hl | String(2) | |
| kalPolPo | kal_pol_po | String(2) | |
| ekoCleHl | eko_cle_hl | String(2) | |
| ekoClePo | eko_cle_po | String(2) | |
| merJedHl | mer_jed_hl | Integer(9) | |
| merJedPo | mer_jed_po | Integer(9) | |
| mjZkratHl | mj_zkrat_hl | String(8) | |
| mjZkratPo | mj_zkrat_po | String(8) | |
| sortSkHl | sort_sk_hl | Integer(9) | |
| sortSkPo | sort_sk_po | Integer(9) | |
| nazNormHl | naz_norm_hl | String(80) | |
| nazNormPo | naz_norm_po | String(80) | |
| nazPolPo | naz_pol_po | String(80) | |
| poPriznak | po_priznak | Character(1) | Příznak pořízení záznamu |
| poDatum | po_datum | Date(23) | Datum a čas pořízení záznamu |
| poKdo | po_kdo | Integer(9) | Uživatel, který pořídil záznam |
| zmPriznak | zm_priznak | Character(1) | Příznak poslední změny záznamu |
| zmDatum | zm_datum | Date(23) | Datum a čas poslední změny záznamu |
| zmKdo | zm_kdo | Integer(9) | Uživatel, který naposledy změnil záznam |
| poradiStr | poradi_str | String(80) |