| Kurzitel | Beschreibung | Tabelle/Script | Datei |
| konstanten | wichtige Konstanten aus FSV entladen, z.B. FSV-Version. |
| Quellsystem mbs DBMS ACCESS |
select 1, left(version,1), 'FSV-Version' from db_version where his_system like '%FSV%'
union select 2, left(version,1), 'MBS-Version' from db_version where his_system like '%MBS%'
union select 3, txt, 'TGR' from sys where msnr = 'TGR'
union select 4, left(txt,5), mid(txt,6,7) from sys where msnr='DTGR' and mid(txt,50,1) = ' ' and left(txt,1)<>''
union select 5, mid(txt,8,5), mid(txt,13,2) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,8,1) <>''
union select 6, mid(txt,15,5), mid(txt,20,2) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,15,1) <>''
union select 7, mid(txt,22,5), mid(txt,27,2) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,22,1) <>''
union select 8, mid(txt,29,5), mid(txt,34,2) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,29,1) <>''
union select 9, mid(txt,36,5), mid(txt,41,2) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,36,1) <>''
union select 10, mid(txt,43,5), mid(txt,48,9) from sys where msnr='DTGR' and mid(txt,50,1)= ' ' and mid(txt,43,1) <>''
union select distinct 11, '1', 'FIN_Quellsystem' from sys;
|
| Quellsystem mbs DBMS INFORMIX |
select 1,version[1,1],'FSV-Version' from db_version where his_system like '%FSV%'
union select 2,version[1,1],'MBS-Version' from db_version where his_system like '%MBS%'
union select 3,txt, 'TGR' from sys where msnr = "TGR"
union select 4, txt[1,5], txt[6,7] from sys where msnr="DTGR" and txt[50] = " " and txt[1] !=""
union select 5, txt[8,12], txt[13,14] from sys where msnr="DTGR" and txt[50] = " " and txt[8] !=""
union select 6, txt[15,19], txt[20,21] from sys where msnr="DTGR" and txt[50] = " " and txt[15] !=""
union select 7, txt[22,26], txt[27,28] from sys where msnr="DTGR" and txt[50] = " " and txt[22] !=""
union select 8, txt[29,33], txt[34,35] from sys where msnr="DTGR" and txt[50] = " " and txt[29] !=""
union select 9, txt[36,40], txt[41,42] from sys where msnr="DTGR" and txt[50] = " " and txt[36] !=""
union select 10, txt[43,47], txt[48,49] from sys where msnr="DTGR" and txt[50] = " " and txt[43] !=""
union select distinct 11, '1', 'FIN_Quellsystem' from sys;
|
| Quellsystem mbs DBMS POSTGRES |
select 1,substring(version from 1 for 1),'FSV-Version' from db_version where his_system like '%FSV%'
union select 2,substring(version from 1 for 1),'MBS-Version' from db_version where his_system like '%MBS%'
union select 3,txt,'TGR' from sys where msnr = 'TGR'
union select 4, substring(txt from 1 for 5), substring(txt from 6 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 1 for 1) !=''
union select 5, substring(txt from 8 for 5), substring(txt from 13 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 8 for 1) !=''
union select 6, substring(txt from 15 for 5), substring(txt from 20 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 15 for 1) !=''
union select 7, substring(txt from 22 for 5), substring(txt from 27 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 22 for 1) !=''
union select 8, substring(txt from 29 for 5), substring(txt from 34 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 29 for 1) !=''
union select 9, substring(txt from 36 for 5), substring(txt from 41 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 36 for 1) !=''
union select 10, substring(txt from 43 for 5), substring(txt from 48 for 2) from sys where msnr='DTGR' and substring(txt from 50 for 1) = ' ' and substring(txt from 43 for 1) !=''
union select distinct 11, '1', 'FIN_Quellsystem' from sys;
|
| Quellsystem kahika DBMS INFORMIX |
select distinct 11, '2', 'FIN_Quellsystem' from bab;
|
| Quellsystem kahika DBMS POSTGRES |
select distinct 11, '2', 'FIN_Quellsystem' from bab;
|
| unl/konstanten.unl |
| fin_zp | |
| Quellsystem mbs DBMS ACCESS |
select zp_nr, land, plz, null, null, null, null, mbs_umsatz, mbs_vj_umsatz1, mbs_vj_umsatz2 from zp;
|
| Quellsystem mbs DBMS INFORMIX |
select zp_nr, land, plz, '', '', '', '', mbs_umsatz, mbs_vj_umsatz1, mbs_vj_umsatz2 from zp;
|
| Quellsystem mbs DBMS POSTGRES |
select zp_nr, land, plz, null, null, null, null, mbs_umsatz, mbs_vj_umsatz1, mbs_vj_umsatz2 from zp;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select zpnr, kfz, plz_s, plz_p, sperrkz, grpkz, branche, null, null, null from zps;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select zpnr, kfz, plz_s, plz_p, sperrkz, grpkz, branche, '', '', '' from zps;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select zpnr, kfz, plz_s, plz_p, sperrkz, grpkz, branche, null, null, null from zps;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select zpnr, kfz, plz_s, plz_p, sperrkz, grpkz, branche, '', '', '' from zps;
|
| unl/fin_zp.unl |
| fin_zp_d | |
| Quellsystem mbs DBMS ACCESS |
select zp_nr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX$,FIN_EMAILKZ, $FIN_EMAIL from zp;
|
| Quellsystem mbs DBMS INFORMIX |
select zp_nr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, $FIN_EMAILKZ, $FIN_EMAIL from zp;
|
| Quellsystem mbs DBMS POSTGRES |
select zp_nr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, $FIN_EMAILKZ, $FIN_EMAIL from zp;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select zpnr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, '','' from zps;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select zpnr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, null, null from zps;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select zpnr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, '','' from zps;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select zpnr, $FIN_ZP1, $FIN_ZP2, $FIN_ZP_STR, $FIN_POSTFACH, $FIN_LIEFER_PLZ, $FIN_LIEFER_ADR, $FIN_ZP_ORT, $FIN_ANSPRECH, $FIN_TELEFON, $FIN_UNBEDENK, $FIN_FAX, null, null from zps;
|
| unl/fin_zp_d.unl |
| fin_buch | |
| Quellsystem mbs DBMS ACCESS Quellsystem-Version 7 |
select jahr, j_nr, kap, dr, dr2, tit, ut, ggnr, fb, ins, ins2, ins3, betrag,betrag2, rbetrag, b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, null, join_nr, sachkonto, null,op_kz,st_kz,'butype',a_nr,null, kperanf, kperend,fael from huel where jahr >= '$START_FIN';
|
| Quellsystem mbs DBMS INFORMIX Quellsystem-Version 7 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag,betrag2,rbetrag, b_dat, '', aw, huel, huelsi, kz, buchungsschluessel, u_nr, '', z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), '', '', '', '', mw_kz, mw_betrag, '', join_nr, sachkonto, '',op_kz,st_kz,'butype',a_nr,'', kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS POSTGRES Quellsystem-Version 7 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag, betrag2,rbetrag,b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, null, join_nr, sachkonto, null,op_kz,st_kz,'butype',a_nr,null, kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where to_number(jahr,'99999') >= $START_FIN;
|
| Quellsystem mbs DBMS ACCESS Quellsystem-Version 8 |
select jahr, j_nr, kap, dr, dr2, tit, ut, ggnr, fb, ins, ins2, ins3, betrag,betrag2, rbetrag, b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, bga, join_nr, sachkonto, null,op_kz,st_kz,'butype',a_nr,null, kperanf, kperend,fael from huel where jahr >= '$START_FIN';
|
| Quellsystem mbs DBMS INFORMIX Quellsystem-Version 8 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag,betrag2,rbetrag, b_dat, '', aw, huel, huelsi, kz, buchungsschluessel, u_nr, '', z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), '', '', '', '', mw_kz, mw_betrag, bga, join_nr, sachkonto, '',op_kz,st_kz,'butype',a_nr,'', kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS POSTGRES Quellsystem-Version 8 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag, betrag2,rbetrag,b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, bga, join_nr, sachkonto, null,op_kz,st_kz,'butype',a_nr,null, kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where to_number(jahr,'99999') >= $START_FIN;
|
| Quellsystem mbs DBMS ACCESS Quellsystem-Version 9 |
select jahr, j_nr, kap, dr, dr2, tit, ut, ggnr, fb, ins, ins2, ins3, betrag,betrag2, rbetrag, b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, bga, join_nr, sachkonto, null,op_kz,st_kz,sollbuschl,a_nr,null, kperanf, kperend,fael from huel where jahr >= '$START_FIN';
|
| Quellsystem mbs DBMS INFORMIX Quellsystem-Version 9 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag,betrag2,rbetrag, b_dat, '', aw, huel, huelsi, kz, buchungsschluessel, u_nr, '', z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), '', '', '', '', mw_kz, mw_betrag, bga, join_nr, sachkonto, '',op_kz,st_kz,sollbuschl,a_nr,'', kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS POSTGRES Quellsystem-Version 9 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag, betrag2,rbetrag,b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, bga, join_nr, sachkonto, null,op_kz,st_kz,sollbuschl,a_nr,null, kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where to_number(jahr,'99999') >= $START_FIN;
|
| Quellsystem mbs DBMS INFORMIX Quellsystem-Version 10,11,12 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag,betrag2,rbetrag, b_dat, '', aw, huel, huelsi, kz, buchungsschluessel, u_nr, '', z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), '', '', '', '', mw_kz, mw_betrag, bga, join_nr, sachkonto, '',op_kz,st_kz,sollbuschl,a_nr,'', kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS POSTGRES Quellsystem-Version 10,11,12 |
select jahr, j_nr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(ggnr), trim(fb), trim(ins), trim(ins2), trim(ins3), betrag, betrag2,rbetrag,b_dat, null, aw, huel, huelsi, kz, buchungsschluessel, u_nr, null, z_nr, bkz, trim(kst_nr), trim(kst_nr),trim(ktr_nr), trim(koa_nr), null, null, null, null, mw_kz, mw_betrag, bga, join_nr, sachkonto, null,op_kz,st_kz,sollbuschl,a_nr,null, kperanf, kperend,fael $FIN_BUCH_EXTRA_FIELDS from huel where to_number(jahr,'99999') >= $START_FIN;
|
| Quellsystem kahika DBMS INFORMIX |
select B.rj, B.journr, B.kap, K.dr, K.tg, B.titel, B.zb, B.mh, B.ba, B.pro, '', '', B.betrag,'','', B.budat, B.bunr, '', B.huelnr, '', '', B.voa, B.utnr, B.utrec, B.zpnr, (B.kkz1*1000)+(B.kkz2*100)+B.kkz3, B.kst_stelle, B.kst_stelle, B.kst_traeger, B.aa1, B.aa2, B.aa3, B.ktonr, '', '', '', '', B.huel_id, '', B.steuer_nr,'','',(B.kkz1*1000)+(B.kkz2*100)+B.kkz3,'',zw,'','','' $FIN_BUCH_EXTRA_FIELDS from bus B, kto K where B.ktonr=K.ktonr and B.rj >= $START_FIN and journr > $JOURNALNR;
|
| Quellsystem kahika DBMS POSTGRES |
select B.rj, B.journr, B.kap, K.dr, K.tg, B.titel, B.zb, B.mh, B.ba, B.pro, null, null, B.betrag,null,null, B.budat, B.bunr, null, B.huelnr, null, null, B.voa, B.utnr, B.utrec, B.zpnr, (B.kkz1*1000)+(B.kkz2*100)+B.kkz3, B.kst_stelle, B.kst_stelle, B.kst_traeger, B.aa1, B.aa2, B.aa3, B.ktonr, null, null, null, null, B.huel_id, null, B.steuer_nr,null,null,(B.kkz1*1000)+(B.kkz2*100)+B.kkz3,null,zw,null,null,null $FIN_BUCH_EXTRA_FIELDS from bus B, kto K where B.ktonr=K.ktonr and B.rj >= $START_FIN and journr > $JOURNALNR;
|
| Quellsystem hisinone DBMS POSTGRES |
select to_char(posting_date,'yyyy'), null::integer as j_nr, null::integer as kap, null::integer as dr, null::integer as dr2, null::integer as tit, null::integer as ut, null::integer as ggnr, null::integer as fb, null::integer as ins, null::integer as ins, null::integer as ins2,null::integer as ins3, amount_debit, amount_credit,null::integer as rbetrag,posting_date, null, balance_relevant as auswert_kz, null::integer as huel, null::integer as huelsi, null::integer as kz,null::integer as buchungsschluessel, null::integer as u_nr, null::integer, null::integer as z_nr, null::integer as bkz,null::integer as kst_nr, null::integer as kst_nr,null::integer as ktr_nr, null::integer as koa_nr, null::integer, null::integer, null::integer, null::integer, null::integer as mw_kz, null::integer as mw_betrag, null::integer as bga, id as join_nr, null::integer as sachkonto, null::integer,null::integer as op_kz,null::integer as st_kz,null::integer as sollbuschl,null::integer as a_nr,null::integer,created as kperanf,null::integer as kperend,null::integer as fael $FIN_BUCH_EXTRA_FIELDS from budget_posting where to_char(posting_date,'yyyy') >= '$START_FIN';
|
| unl/fin_buch.unl |
| fin_buch_d | |
| Quellsystem mbs DBMS ACCESS |
select jahr,join_nr, $FIN_VWZ, $FIN_Z_NAME, $FIN_R_NR, b_dat_kasse, r_dat, ref_h from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS INFORMIX |
select jahr,join_nr, $FIN_VWZ, $FIN_Z_NAME, $FIN_R_NR, b_dat_kasse, r_dat, ref_h from huel where jahr >= $START_FIN;
|
| Quellsystem mbs DBMS POSTGRES |
select jahr,join_nr, $FIN_VWZ, $FIN_Z_NAME, $FIN_R_NR, b_dat_kasse, r_dat, ref_h from huel where to_number(jahr,'99999') >= $START_FIN;
|
| Quellsystem kahika DBMS INFORMIX |
select rj,journr, $FIN_VWZ, '', '', '', '', '' from bus where rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES |
select rj,journr, $FIN_VWZ, null, null, null, null, null from bus where rj >= $START_FIN;
|
| unl/fin_buch_d.unl |
| fin_konten | |
| Quellsystem kahika DBMS INFORMIX |
select K.rj, K.kap, K.dr, K.tg, K.titel, K.zb, K.ba, '','','',K.ktobez, '', '', K.sum_zw, K.sum_bw, '', K.ktonr, '', '','','','' from kto K where rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES |
select K.rj, K.kap, K.dr, K.tg, K.titel, K.zb, K.ba, null,null,null,K.ktobez, null, null, K.sum_zw, K.sum_bw, null, K.ktonr, null,null,null,null,null from kto K where rj >= $START_FIN;
|
| Quellsystem mbs DBMS ACCESS |
select jahr, kap, dr, null, null, null, null, null, null,null,titdrbez, null, kz_ueber, null, null, null, null, null,null, dtgr,vojs,18 from titdr where jahr >= '$START_FIN'
union select jahr, kap, dr, null, null, null, fb, null, null,null,fbdrbez, art, kz_ueber, null, null, null, null, null,null, dtgr,vojs,29 from fbdr where jahr >= '$START_FIN'
union select jahr, kap, dr, null, null, null, fb, ins, null,null,insdrbez, art, kz_ueber, null, null, null, null, null,null, dtgr,vojs,310 from insdr where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, null, null, null, null, null,titbez, null,kz_ueber, null, null, finz_stat, null, null,null,dtgr,vojs, 4 from tit where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, ut, null, null, null, null,utbez, null,kz_ueber, null, null, finz_stat, null, null,null,dtgr,vojs, 5 from ut where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, ut, fb, null, null,null,fbbez, art, kz_ueber, null, null, finz_stat, null, null, null,dtgr,vojs,6 from fb where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, ut, fb, ins,null,null,insbez, art, kz_ueber, null, null, finz_stat, null, null, null,dtgr,vojs, 7 from ins where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, ut, fb,ins, ins2,null, ins2bez, art, kz_ueber, null, null, finz_stat, null, null, null,dtgr, vojs,13 from ins2 where jahr >= '$START_FIN'
union select jahr, kap, dr, dr2, tit, ut, fb, ins, ins2,ins3,ins3bez, art, kz_ueber, null, null, finz_stat, null, null, null,dtgr, vojs, 14 from ins3 where jahr >= '$START_FIN'
union select jahr, kap, dr, null, null, null, fb, ins, ins2,null,insdr2bez, art, kz_ueber, null, null, null, null, null, null,dtgr, vojs,1115 from insdr2 where jahr >= '$START_FIN'
union select jahr, kap, dr, null, null, null, fb, ins, ins2,ins3,insdr3bez ,art, kz_ueber, null, null, null, null, null, null,dtgr, vojs,1216 from insdr3 where jahr >= '$START_FIN';
|
| Quellsystem mbs DBMS INFORMIX |
select jahr, trim(kap), trim(dr), '', '', '', '', '', '','',titdrbez, '', kz_ueber, '', '', '', '', '', '',dtgr,vojs,18 from titdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), '', '', '', trim(fb), '', '','',fbdrbez, art, kz_ueber, '', '', '', '', '', '',dtgr,vojs,29 from fbdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), '', '', '', trim(fb), trim(ins), '','',insdrbez, art, kz_ueber, '', '', '', '', '', '',dtgr,vojs,310 from insdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), '', '', '', '', '',titbez, '',kz_ueber, '', '', finz_stat, '', '','',dtgr,vojs, 4 from tit where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), '', '', '', '',utbez, '',kz_ueber, '', '', finz_stat, '', '','',dtgr, vojs,5 from ut where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), '', '','',fbbez, art, kz_ueber, '', '', finz_stat, '', '','', dtgr,vojs,6 from fb where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), trim(ins),'','',insbez, art, kz_ueber, '', '', finz_stat, '', '', '',dtgr, vojs,7 from ins where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb),trim(ins), trim(ins2),'', ins2bez, art, kz_ueber, '', '', finz_stat, '', '','', dtgr, vojs,13 from ins2 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), trim(ins), trim(ins2),trim(ins3),ins3bez, art, kz_ueber, '', '', finz_stat, '', '','', dtgr, vojs,14 from ins3 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), '', '', '', trim(fb), trim(ins), trim(ins2),'',insdr2bez, art, kz_ueber, '', '', '', '', '','', dtgr, vojs,1115 from insdr2 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), '', '', '', trim(fb), trim(ins), trim(ins2),trim(ins3),insdr3bez ,art, kz_ueber, '', '', '', '', '', '',dtgr,vojs, 1216 from insdr3 where jahr >= '$START_FIN';
|
| Quellsystem mbs DBMS POSTGRES |
select jahr, trim(kap), trim(dr), null, null, null, null, null, null,null,titdrbez, null, kz_ueber, null, null, null, null, null, null,dtgr,vojs,18 from titdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), null, null, null, trim(fb), null, null,null,fbdrbez, art, kz_ueber, null, null, null, null, null, null,dtgr,vojs,29 from fbdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), null, null, null, trim(fb), trim(ins), null,null,insdrbez, art, kz_ueber, null, null, null, null, null, null,dtgr,vojs,310 from insdr where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), null, null, null, null, null,titbez, null,kz_ueber, null, null, finz_stat, null, null,null,dtgr,vojs, 4 from tit where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), null, null, null, null,utbez, null,kz_ueber, null, null, finz_stat, null, null,null,dtgr,vojs, 5 from ut where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), null, null,null,fbbez, art, kz_ueber, null, null, finz_stat, null, null,null, dtgr,vojs,6 from fb where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), trim(ins),null,null,insbez, art, kz_ueber, null, null, finz_stat, null, null, null,dtgr, vojs,7 from ins where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb),trim(ins), trim(ins2),null, ins2bez, art, kz_ueber, null, null, finz_stat, null, null,null, dtgr, vojs,13 from ins2 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), trim(dr2), trim(tit), trim(ut), trim(fb), trim(ins), trim(ins2),trim(ins3),ins3bez, art, kz_ueber, null, null, finz_stat, null, null,null, dtgr, vojs,14 from ins3 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), null, null, null, trim(fb), trim(ins), trim(ins2),null,insdr2bez, art, kz_ueber, null, null, null, null, null,null, dtgr, vojs,1115 from insdr2 where jahr >= '$START_FIN'
union select jahr, trim(kap), trim(dr), null, null, null, trim(fb), trim(ins), trim(ins2),trim(ins3),insdr3bez ,art, kz_ueber, null, null, null, null, null, null,dtgr, vojs,1216 from insdr3 where jahr >= '$START_FIN';
|
| unl/fin_konten.unl |
| fin_proj | |
| Quellsystem mbs DBMS ACCESS |
select projnr, ueberkey, ktext, ltxt1, ltxt2, az, fb, ins, pjlname1, pjlname2, pjlname3, null, lehr, spklnr1, spklnr2, bewdat1, bewdat2, bewabl, art1, art2, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, mwpf, laufzeitbeginn, spklnr3, spklnr4, koordination, key_extkotr, null,null,fins, null, null from proj;
|
| Quellsystem mbs DBMS INFORMIX |
select projnr, ueberkey, ktext, ltxt1, ltxt2, az, fb, ins, pjlname1, pjlname2, pjlname3, '', lehr, spklnr1, spklnr2, bewdat1, bewdat2, bewabl, art1, art2, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, mwpf, laufzeitbeginn, spklnr3, spklnr4, koordination, key_extkotr, '','', fins, '', '' from proj;
|
| Quellsystem mbs DBMS POSTGRES |
select projnr, ueberkey, ktext, ltxt1, ltxt2, az, fb, ins, pjlname1, pjlname2, pjlname3, null, lehr, spklnr1, spklnr2, bewdat1, bewdat2, bewabl, art1, art2, svarel, mbsrel, ivsrel, baurel, cobrel,besrel, mwpf, laufzeitbeginn, spklnr3, spklnr4, koordination, key_extkotr, null,null,fins, null, null from proj;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select ba, '', dname, name1, name2, akten_kz, ba, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', akt_von, akt_bis, finstat, fach, instnr from bab
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select ba, null, dname, name1, name2, akten_kz, ba, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, akt_von, akt_bis, finstat, fach, instnr from bab
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select kst_traeger, '', ktr_kurz, ktr_druck,'', '', ba, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', gueltig_von,gueltig_bis,'','','' from ktr
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select kst_traeger, null, ktr_kurz, ktr_druck,null, null, ba, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, gueltig_von,gueltig_bis,null,null,null from ktr
|
| unl/fin_proj.unl |
| fin_gege | |
| Quellsystem mbs DBMS ACCESS |
select ggnr, ueberkey, ggkey, fikey, ggkurz, ggdruck, ggname1, ggname2, ggname3, $FIN_GG_STR, $FIN_GG_ORT, $FIN_GG_PLZ, key_von, key_bis, bund_geldgeber, svarel, mbsrel, ivsrel, baurel, cobrel, klr_geldgeber from gege;
|
| Quellsystem mbs DBMS INFORMIX |
select ggnr, ueberkey, ggkey, fikey, ggkurz, ggdruck, ggname1, ggname2, ggname3, $FIN_GG_STR, $FIN_GG_ORT, $FIN_GG_PLZ, key_von, key_bis, bund_geldgeber, svarel, mbsrel, ivsrel, baurel, cobrel, klr_geldgeber from gege;
|
| Quellsystem mbs DBMS POSTGRES |
select ggnr, ueberkey, ggkey, fikey, ggkurz, ggdruck, ggname1, ggname2, ggname3, $FIN_GG_STR, $FIN_GG_ORT, $FIN_GG_PLZ, key_von, key_bis, bund_geldgeber, svarel, mbsrel, ivsrel, baurel, cobrel, klr_geldgeber from gege;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select mh, '', '', '', '', mh_bez, '', '', '', '', '', '', gueltig_von, gueltig_bis, '', '', '', '', '', '', mh_art from mhk;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select mh, null, null, null, null, mh_bez, null, null, null, null, null, null, gueltig_von, gueltig_bis, null, null, null, null, null, null, mh_art from mhk;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select mh, '', '', '', '', mh_bez, '', '', '', '', '', '', gueltig_von, gueltig_bis, '', '', '', '', '', '', mh_art from mhk;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select mh, null, null, null, null, mh_bez, null, null, null, null, null, null, gueltig_von, gueltig_bis, null, null, null, null, null, null, mh_art from mhk;
|
| unl/fin_gege.unl |
| fin_inst | |
| Quellsystem mbs DBMS ACCESS |
select inst_nr, uebinst_nr, kname, dname, lname1, lname2, str, gebname, plz, ort, bes_tel, bes_umsatz, bes_vj_umsatz1, bes_vj_umsatz2, ivs_tel, fins, lehr, habpos, orgstruktur, key_von, key_bis, anscid, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, bund_kategorie, bund_lehr_forsch, bund_fachgebiet, land_fachgebiet, sis_fachbereich, land_institut, genehmigungsstufe, aost_nr, bund_rahmenplan, listendruck, art, null from inst;
|
| Quellsystem mbs DBMS INFORMIX |
select inst_nr, uebinst_nr, kname, dname, lname1, lname2, str, gebname, plz, ort, bes_tel, bes_umsatz, bes_vj_umsatz1, bes_vj_umsatz2, ivs_tel, fins, lehr, habpos, orgstruktur, key_von, key_bis, anscid, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, bund_kategorie, bund_lehr_forsch, bund_fachgebiet, land_fachgebiet, '', land_institut, genehmigungsstufe, aost_nr, bund_rahmenplan, listendruck, art, '' from inst;
|
| Quellsystem mbs DBMS POSTGRES |
select inst_nr, uebinst_nr, kname, dname, lname1, lname2, str, gebname, plz, ort, bes_tel, bes_umsatz, bes_vj_umsatz1, bes_vj_umsatz2, ivs_tel, fins, lehr, habpos, orgstruktur, key_von, key_bis, anscid, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, bund_kategorie, bund_lehr_forsch, bund_fachgebiet, land_fachgebiet, '', land_institut, genehmigungsstufe, aost_nr, bund_rahmenplan, listendruck, art, null from inst;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select kst_stelle, kst_ueber, '', kst_kurz, kst_druck, '', '', '', '', '', '', '', '', '', '', '', '', '', orgeinh, gueltig_von, gueltig_bis, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' from kst;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select kst_stelle, kst_ueber, null, kst_kurz, kst_druck, null, null, null, null, null, null, null, null, null, null, null, null, null, orgeinh, gueltig_von, gueltig_bis, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null from kst;
|
| unl/fin_inst.unl |
| fin_inst_d | |
| Quellsystem mbs DBMS ACCESS |
select inst_nr, $FIN_PERSO_BESCH, $FIN_PERSO_INV from inst;
|
| Quellsystem mbs DBMS INFORMIX |
select inst_nr, $FIN_PERSO_BESCH, $FIN_PERSO_INV from inst;
|
| Quellsystem mbs DBMS POSTGRES |
select inst_nr, $FIN_PERSO_BESCH, $FIN_PERSO_INV from inst;
|
| unl/fin_inst_d.unl |
| fin_fikr | |
| Quellsystem mbs DBMS ACCESS |
select key, ueberg, kbez, lbez, kokl, habpos, key_von, key_bis, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, aost_nr, mbs_to_cob, null,null from fikr;
|
| Quellsystem mbs DBMS INFORMIX |
select key, ueberg, kbez, lbez, kokl, habpos, key_von, key_bis, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, aost_nr, mbs_to_cob, syf,'' from fikr;
|
| Quellsystem mbs DBMS POSTGRES |
select key, ueberg, kbez, lbez, kokl, habpos, key_von, key_bis, svarel, mbsrel, ivsrel, baurel, cobrel, besrel, aost_nr, mbs_to_cob, syf,null from fikr;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select koa, koa_ueber, koa_bez, koa_lbez, null,null, gueltig_von, gueltig_bis, null, null, null, null, null, null, null, null,null,null from koa;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select koa, koa_ueber, koa_bez, koa_lbez, '','', gueltig_von, gueltig_bis, '', '', '', '', '', '', '', '','','' from koa;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select koa, koa_ueber, koa_bez, koa_lbez, null,null, gueltig_von, gueltig_bis, null, null, null, null, null, null, null, null,null,null from koa;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select koa, koa_ueber, koa_bez, koa_lbez, '','', gueltig_von, gueltig_bis, '', '', '', '', '', '', '', '','','' from koa;
|
| unl/fin_fikr.unl |
| fin_mwst_betr | |
| Quellsystem mbs DBMS ACCESS |
select join_nr, mw_kz, mwbetrag_brutto, mwbetrag_steuer, mwbetrag_netto, huel_join_nr, bga from mwst_betraege;
|
| Quellsystem mbs DBMS INFORMIX |
select join_nr, mw_kz, mwbetrag_brutto, mwbetrag_steuer, mwbetrag_netto, huel_join_nr, bga from mwst_betraege;
|
| Quellsystem mbs DBMS POSTGRES |
select join_nr, mw_kz, mwbetrag_brutto, mwbetrag_steuer, mwbetrag_netto, huel_join_nr, bga from mwst_betraege;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select steuer_nr, mwst, brutto_norm, mwst_norm, netto_norm, rj||journr, bga from bga where rj>= $START_FIN and brutto_norm != 0;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select steuer_nr, mwst, brutto_norm, mwst_norm, netto_norm, rj||journr, bga from bga where rj>= $START_FIN and brutto_norm != 0;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select steuer_nr, mwst, brutto_norm, mwst_norm, netto_norm, rj||journr, bga from bga where rj>= $START_FIN and brutto_norm != 0;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select steuer_nr, mwst, brutto_norm, mwst_norm, netto_norm, rj||journr, bga from bga where rj>= $START_FIN and brutto_norm != 0;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 20 |
select steuer_nr, mwst, brutto_norm, mwst_norm, netto_norm, rj||journr, bga from mwst_betraege where rj>= $START_FIN and brutto_norm != 0;
|
| unl/fin_mwst_betr.unl |
| fin_fibu_konten | |
| Quellsystem mbs DBMS ACCESS |
select id, sachkonto, bezeichnung, haushaltsjahr, hhjende, klasse, kategorie, gruppe, sollhaben, basekonto, kostenart, titel from fibu_konten;
|
| Quellsystem mbs DBMS INFORMIX |
select id, sachkonto, bezeichnung, haushaltsjahr, hhjende, klasse, kategorie, gruppe, sollhaben, basekonto, kostenart, titel from fibu_konten;
|
| Quellsystem mbs DBMS POSTGRES |
select id, sachkonto, bezeichnung, haushaltsjahr, hhjende, klasse, kategorie, gruppe, sollhaben, basekonto, kostenart, titel from fibu_konten;
|
| Quellsystem kahika |
select 'nix' from kto where 1 = 0;
|
| unl/fin_fibu_konten.unl |
| fin_zwa | |
| Quellsystem mbs |
select 'nix' from huel where 0=1;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select rj, kap, titel, zb, ba, mh, pro, voa, bname, budat, bdatum, zuwart, betrag, komm, kkz1*1000+ kkz2*100+kkz3, aa1, aa2, aa3, kst_stelle, kst_traeger, huel_id where rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select rj, kap, titel, zb, ba, mh, pro, voa, bname, budat, bdatum, zuwart, betrag, komm, kkz1*1000+ kkz2*100+kkz3, aa1, aa2, aa3, kst_stelle, kst_traeger, huel_id from zwa where rj >= $START_FIN;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select rj, kap, titel, zb, ba, mh, pro, voa, bname, budat, bdatum, zuwart, betrag, komm, kkz1*1000+ kkz2*100+kkz3, aa1, aa2, aa3, kst_stelle, kst_traeger, huel_id where rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select rj, kap, titel, zb, ba, mh, pro, voa, bname, budat, bdatum, zuwart, betrag, komm, kkz1*1000+ kkz2*100+kkz3, aa1, aa2, aa3, kst_stelle, kst_traeger, huel_id from zwa where rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 20 |
select rj, kap, titel, zb, ba, mh, pro, voa, bname, budat, bdatum, zuwart, betrag, komm, kkz1*1000+ kkz2*100+kkz3, aa1, aa2, aa3, kst_stelle, kst_traeger, null from zwa where rj >= $START_FIN;
|
| unl/fin_zwa.unl |
| fin_pro | |
| Quellsystem mbs |
select 'nix' from huel where 0=1;
|
| Quellsystem kahika DBMS INFORMIX |
select rj, updtime,
trim(feld_neu[1, 6]) journr,
trim(feld_neu[8, 13]) huelnr,
trim(feld_neu[15, 20]) bunr,
trim(feld_neu[21, 22]) kkz1,
trim(feld_neu[23, 24]) kkz2,
trim(feld_neu[25, 28]) kkz3,
trim(feld_neu[30, 37]) aa1,
trim(feld_neu[39, 40]) aa2,
trim(feld_neu[42, 44]) aa3,
trim(feld_neu[45, 98]) komm,
trim(feld_neu[100, 102]) mh,
trim(feld_neu[104,113]) kst_stelle,
trim(feld_neu[115,124]) kst_traeger,
trim(feld_neu[126,129]) pro,
''
from pro where tabelle = 'BUS' and rj >= $START_FIN;
|
| Quellsystem kahika DBMS POSTGRES |
select rj, updtime,
trim(substring(feld_neu from 1 for 6)) as journr,
trim(substring(feld_neu from 8 for 6)) as huelnr,
trim(substring(feld_neu from 15 for 5)) as bunr,
trim(substring(feld_neu from 21 for 2)) as kkz1,
trim(substring(feld_neu from 23 for 2)) as kkz2,
trim(substring(feld_neu from 25 for 4)) as kkz3,
trim(substring(feld_neu from 30 for 8)) as aa1,
trim(substring(feld_neu from 39 for 2)) as aa2,
trim(substring(feld_neu from 42 for 2)) as aa3,
trim(substring(feld_neu from 45 for 54)) as komm,
trim(substring(feld_neu from 100 for 3)) as mh,
trim(substring(feld_neu from 104 for 10)) as kst_stelle,
trim(substring(feld_neu from 115 for 10)) as kst_traeger,
trim(substring(feld_neu from 126 for 4)) as pro,
null
from pro where tabelle = 'BUS' and rj >= $START_FIN and date(updtime)>=today();
|
| unl/fin_pro.unl |
| fin_proj_to_inst | |
| Quellsystem mbs DBMS ACCESS |
select projnr, inst_nr, haupt_kst_kz from proj_to_inst;
|
| Quellsystem mbs DBMS INFORMIX |
select projnr, inst_nr, haupt_kst_kz from proj_to_inst;
|
| Quellsystem mbs DBMS POSTGRES |
select projnr, inst_nr, haupt_kst_kz from proj_to_inst;
|
| Quellsystem kahika Quellsystem-Version 1 |
select 'nix' from kto where 1=0
|
| unl/fin_proj_to_inst.unl |
| fin_butype | |
| Quellsystem mbs DBMS INFORMIX |
SELECT key_sollbuschl,'', kurz_sollbuschl, druck_sollbuschl, text_sollbuschl,'','' FROM k_sollbuschl
|
| Quellsystem mbs DBMS POSTGRES |
SELECT key_sollbuschl,null, kurz_sollbuschl, druck_sollbuschl, text_sollbuschl,null,null FROM k_sollbuschl
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 1 |
select kkz, '','',kkz_bez,kkz_bez,'','' from kkz;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 1 |
select kkz, null,null,kkz_bez,kkz_bez,null,null from kkz;
|
| Quellsystem kahika DBMS INFORMIX Quellsystem-Version 10 |
select kkz, '','',kkz_bez,kkz_bez,'','' from kkz;
|
| Quellsystem kahika DBMS POSTGRES Quellsystem-Version 10 |
select kkz, null,null,kkz_bez,kkz_bez,null,null from kkz;
|
| unl/fin_butype.unl |
| fin_kap | |
| Quellsystem mbs |
SELECT jahr, kap, kapbez FROM kap;
|
| Quellsystem kahika DBMS INFORMIX |
select 'nix' from kto where 1=0
|
| unl/fin_kap.unl |
| fin_tit | |
| Quellsystem mbs |
SELECT jahr, kap,dr,dr2, tit,ltitbez,titbez FROM tit;
|
| Quellsystem kahika |
select distinct K.rj, K.kap, K.dr, K.tg, K.titel,K.ktobez,K.ktobez from kto K where K.ba is null;
|
| unl/fin_tit.unl |
| fin_titdr | |
| Quellsystem mbs |
SELECT jahr, kap, dr, dtgr, titdrbez,'','' from titdr;
|
| Quellsystem kahika DBMS INFORMIX |
select 'nix' from kto where 1=0
|
| unl/fin_dr.unl |
| fin_buchungsab_fb | |
| Quellsystem mbs DBMS INFORMIX |
SELECT jahr, kap,dr, dr2, tit, ut, fb, fbbez, dtgr,'','','','','' FROM fb;
|
| Quellsystem mbs DBMS POSTGRES |
SELECT jahr, kap,dr, dr2, tit, ut, fb, fbbez, dtgr,null,null,null,null,null FROM fb;
|
| Quellsystem kahika DBMS INFORMIX |
select distinct K.rj,K.kap,K.dr,K.tg, K.titel,K.zb,K.ba,B.dname,'',finstat, fach, instnr,B.akt_von,B.akt_bis from kto K,bab B where K.ba=B.ba and year(B.akt_von)<=K.rj and year(B.akt_bis)>=K.rj
|
| Quellsystem kahika DBMS POSTGRES |
select distinct K.rj,K.kap,K.dr,K.tg, K.titel,K.zb,K.ba,B.dname,null,finstat, fach, instnr,B.akt_von,B.akt_bis from kto K,bab B where K.ba=B.ba and extract(year from B.akt_von)::smallint<=K.rj and extract(year from B.akt_bis)::smallint>=K.rj
|
| unl/fin_buchab_fb.unl |
| fin_projnr_ins | |
| Quellsystem mbs |
SELECT jahr, kap,dr, dr2, tit, ut, fb, ins, insbez, dtgr FROM ins
|
| Quellsystem kahika |
select 'nix' from kto where 1=0
|
| unl/fin_projnr_ins.unl |
| fin_irrelevant | |
| Quellsystem mbs DBMS INFORMIX |
select kap,'' from zst_kapitel union select kap,tit from zst_sonderbuchst union select distinct kap,tit from tit where vwg=1
|
| Quellsystem mbs DBMS POSTGRES |
select kap,null from zst_kapitel union select kap,tit from zst_sonderbuchst union select distinct kap,tit from tit where vwg=1
|
| Quellsystem kahika |
select distinct kap,'' from kto where kap>1500 and kap<=1999
|
| unl/fin_irrelevant.unl |
| fin_syf | |
| Quellsystem mbs |
select key_syf, ueberkey, kurz_syf , druck_syf , text_syf, key_von,key_bis from k_syf
|
| Quellsystem kahika |
select 'nix' from kto where 1=0
|
| unl/fin_syf.unl |
| fin_bga | |
| Quellsystem mbs Quellsystem-Version 8,9 |
SELECT key_bga, kurz_bga, druck_bga, text_bga, key_von, key_bis, flag_bga, k_bga_id, '' FROM k_bga
|
| Quellsystem mbs Quellsystem-Version 10,11,12 |
SELECT key_bga, kurz_bga, druck_bga, text_bga, key_von, key_bis, flag_bga, k_bga_id, bilanz FROM k_bga
|
| Quellsystem kahika |
select 'nix' from kto where 1=0
|
| unl/fin_bga.unl |
| fin_bga_to_mbs | |
| Quellsystem mbs |
SELECT id, bga, jahr, kap, dr, tit, ut, fb, ins, ins2, ins3 FROM bga_to_mbs
|
| Quellsystem kahika |
select 'nix' from kto where 1=0
|
| unl/fin_bga_to_mbs.unl |
| fin_fins | |
| Quellsystem mbs |
SELECT fins_keygrp, fins_key, fins_lbez, join_nr FROM fins
|
| Quellsystem kahika |
select 'nix' from kto where 1=0
|
| unl/fin_fins.unl |