OPOL pro NC
| Pole | SQL | Typ | Popis |
|---|---|---|---|
| id.podsystem | podsystem | Character(1) | |
| id.spojCisDavky | spoj_cis_davky | Integer(9) | |
| id.porCis | por_cis | Integer(9) | |
| obdobiCele | obdobi_cele | Integer(9) | |
| zavod | zavod | String(2) | |
| doklRada | dokl_rada | String(4) | |
| davka | davka | Short(4) | |
| icoVl | ico_vl | Long(10) | |
| ucDokl | uc_dokl | Integer(9) | |
| druhOp | druh_op | Short(4) | |
| CDokladu | c_dokladu | String(20) | |
| CZapisu | c_zapisu | Integer(9) | |
| CRadku | c_radku | Short(4) | |
| datZauct | dat_zauct | Integer(9) | |
| datum2 | datum2 | Integer(9) | |
| datUplDph | dat_upl_dph | Integer(9) | |
| obdDphRok | obd_dph_rok | Short(4) | |
| obdDphMes | obd_dph_mes | Short(4) | |
| pohyb | pohyb | String(11) | |
| varianta | varianta | Character(1) | |
| druhZapisu | druh_zapisu | Character(1) | |
| nos1Md | nos_1_md | String(30) | |
| nos2Md | nos_2_md | String(30) | |
| nos3Md | nos_3_md | String(30) | |
| nos4Md | nos_4_md | String(30) | |
| nos5Md | nos_5_md | String(30) | |
| nos6Md | nos_6_md | String(30) | |
| nos7Md | nos_7_md | String(30) | |
| nos8Md | nos_8_md | String(30) | |
| nos9Md | nos_9_md | String(30) | |
| nos10Md | nos_10_md | String(30) | |
| nos1Dal | nos_1_dal | String(30) | |
| nos2Dal | nos_2_dal | String(30) | |
| nos3Dal | nos_3_dal | String(30) | |
| nos4Dal | nos_4_dal | String(30) | |
| nos5Dal | nos_5_dal | String(30) | |
| nos6Dal | nos_6_dal | String(30) | |
| nos7Dal | nos_7_dal | String(30) | |
| nos8Dal | nos_8_dal | String(30) | |
| nos9Dal | nos_9_dal | String(30) | |
| nos10Dal | nos_10_dal | String(30) | |
| obnTuz | obn_tuz | BigDecimal(16,2) | |
| mena | mena | String(4) | |
| kurs | kurs | BigDecimal(10,4) | |
| obnCizi | obn_cizi | BigDecimal(16,2) | |
| menaPrep | mena_prep | String(4) | |
| kursPrep | kurs_prep | BigDecimal(10,4) | |
| obnPrepoc | obn_prepoc | BigDecimal(16,2) | |
| mnozstvi1 | mnozstvi_1 | BigDecimal(18,5) | |
| mj1 | mj_1 | String(3) | |
| mnozstvi2 | mnozstvi_2 | BigDecimal(18,5) | |
| mj2 | mj_2 | String(3) | |
| mnozstvi3 | mnozstvi_3 | BigDecimal(18,5) | |
| mj3 | mj_3 | String(3) | |
| vazUdaj1 | vaz_udaj_1 | String(20) | |
| vazUdaj2 | vaz_udaj_2 | String(20) | |
| vazUdaj3 | vaz_udaj_3 | String(20) | |
| vazUdaj4 | vaz_udaj_4 | String(20) | |
| vazUdaj5 | vaz_udaj_5 | String(20) | |
| vazUdaj6 | vaz_udaj_6 | String(20) | |
| charaktDokl | charakt_dokl | String(3) | |
| textDokladu | text_dokladu | String(20) | |
| textZapisu | text_zapisu | String(30) | |
| dobrStorno | dobr_storno | Character(1) | |
| danSkup | dan_skup | String(3) | |
| cisObj | cis_obj | String(20) | |
| dodList | dod_list | String(20) | |
| cashFlow | cash_flow | String(3) | |
| ico | ico | Long(10) | |
| icoDopl | ico_dopl | Short(4) | |
| rabat | rabat | Short(4) | |
| platnost | platnost | Character(1) | |
| zuctFu | zuct_fu | Character(1) | |
| zuctVpu | zuct_vpu | Character(1) | |
| likvidace | likvidace | Character(1) | |
| dph | dph | Character(1) | |
| uzavOtev | uzav_otev | Character(1) | |
| tuzZah | tuz_zah | Character(1) | |
| priznak1 | priznak1 | Character(1) | |
| priznak2 | priznak2 | Character(1) | |
| priznak3 | priznak3 | Character(1) | |
| priznak4 | priznak4 | Character(1) | |
| priznak5 | priznak5 | String(2) | |
| opohVznik | opoh_vznik | Character(1) | |
| sbornikMd | sbornik_md | String(76) | |
| sbornikDal | sbornik_dal | String(76) | |
| soubor | soubor | Short(4) | |
| rezerva | rezerva | String(98) | |
| zpusobVzniku | zpusob_vzniku | String(4) | |
| poridil | poridil | Integer(9) | |
| datPorizeni | dat_porizeni | Integer(9) | |
| casPorizeni | cas_porizeni | Integer(9) | |
| mistoPorizeni | misto_porizeni | Character(1) | |
| opravil | opravil | Integer(9) | |
| datOpravy | dat_opravy | Integer(9) | |
| casOpravy | cas_opravy | Integer(9) | |
| mistoOpravy | misto_opravy | Character(1) | |
| odsouhlasil | odsouhlasil | Integer(9) |