===== Entitní třída Opolq ===== OPOL pro NC ==== Seznam polí ==== ^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) | |