Amaly-SQL-PG-Update1.20

Aus INFOKOM-Wiki
Wechseln zu: Navigation, Suche

[Bearbeiten] SQL - Update für PostgreSQL von Version 1.14 auf 1.20.1

Bitte auf bearbeiten gehen, um die SQL-Statments korrekt zu sehen

alter table def_schlbez alter schlbez TYPE char(50); alter table def_fkt alter fktnr TYPE int; alter table kon_zugr alter fktnr TYPE int;

alter table kon_besch

add   faellig_mon SMALLINT,
add   faellig_week SMALLINT

alter table kon_gprof add pos_von smallint, add pos_bis smallint;

alter table kon_prvorl

add   rechtegruppe CHAR(1),
add   vorlagengrp smallint

alter table agebbe

add  adatum DATE,
add   edatum DATE,
add   abbuch_jn CHAR(1),
add   blz DECIMAL(8,0),
add   kontonr DECIMAL(10,0),
add   kontoinh CHAR(30),
add   reflfdnr SMALLINT

create table amsollst (

   beschid INT not null,
   bunr SMALLINT not null,
   lastss DATE,
   faellig DATE,
   betrag DECIMAL(16)

) with oids;

create index idx_sollst on amsollst ( beschid, bunr );

create table amactivuser (

   zeit timestamp default now(),
   username CHAR(14) not null,
   connid int not null,
   ident VARCHAR(64)

) with oids; create index idx_actuser on amactivuser(username, connid);

create table kon_gfavo (

   gebprofil CHAR(20) not null,
   aart CHAR(4),
   ordnr SMALLINT not null

) with oids; create unique index gfavo_gp on kon_gfavo(gebprofil);

create table kon_rollen (

   rollennr SMALLINT,
   rollenbez VARCHAR(32)

) with oids; create unique index rol_ind1 on kon_rollen(rollennr);

create table kon_user_ro (

   usernr smallint,
   rollennr smallint

) with oids; create unique index urol_ind1 on kon_user_ro(usernr, rollennr);

create table kon_zugr_ro (

   rollennr SMALLINT not null,
   fktnr int not null,
   fkttyp CHAR(4) not null,
   zug_kz INT

) with oids;

create unique index zugrro_ind1 on kon_zugr_ro ( rollennr, fktnr, fkttyp );

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(171, 'K', 'kon_gfavo', 'GebFavoriten', 'Profile f. Gebührenfavori', 'Bezeichnung für Favoriten der Gebührenprofile', NULL, NULL, NULL, 'n', 'n', 'n');

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(172, 'K', 'kon_rollen', 'Rollen', 'Rollen (Zugriffsrechte)', 'Rollen der Zugriffsrechte', NULL, NULL, 2, 'n', 'n', 'n');

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(173, 'K', 'kon_user_ro', 'Rollen(User)', 'Rollen des Users', 'Zuordnung, welche Rollen der User hat', NULL, 126, 2, 'n', 'n', 'n');

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(174, 'K', 'kon_zugr_ro', 'Ro-Rechte', 'Zugriffsrechte', 'Zugriffsrechte der Rolle', 'de.infokomGT.ageb_j.RechtePanel', 172, 1, 'n', 'n', 'n');

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(201, 'F', 'amsollst', 'Sollstellung', 'Regelmäßige Sollstellung', 'Liste der regelmäßigen Sollstellungen', NULL, 111, 3, 'n', 'n', 'j');

INSERT INTO metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(998, 'K', 'amactivuser', 'Aktive User', 'Aktive User', 'Hält Liste der aktiven User mit Auftragsangabe', NULL, NULL, NULL, 'n', 'n', 'j');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(171, 1, 1, 'ordnr', 'Ordn.Nr', 'Ordnungs-Nummer', 'Ordnungs-Nummer als Sortiermerkmal', 'LASTPLUS', NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(171, 2, 2, 'gebprofil', 'GebProfil', 'Gebühren-Profile', 'Bezeichnung des Gebührenprofils', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(171, 3, 3, 'aart', 'AufArt', 'Auftragsart', 'Auftragsart', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(172, 1, 1, 'rollennr', 'Rollen-Nr', 'Rollen-Nummer', 'Nummer der Rolle', 'MAXPLUS', NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(172, 2, 2, 'rollenbez', 'Bezeich', 'Bezeichnung', 'Bezeichnung der Rolle', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(173, 1, 1, 'usernr', 'Benutzer', 'Benutzer', 'Benutzer', 'MASTER', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 126, 1, '6', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(173, 2, 2, 'rollennr', 'Rolle', 'Rolle', 'Rolle mit Zugriffsrechten, die dem Benutzer zuzuordnern ist', NULL, NULL, 'j', '3', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 172, 1, '2', NULL, NULL, NULL, NULL, NULL, 'j');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(174, 1, 1, 'rollennr', 'Rollen-Nr', 'Rollen-Nummer', 'Rollen-Nummer', 'MASTER', NULL, 'j', '3', 'j', 'j', 'j', 'n', 'n', 'j', 'n', NULL, 172, 1, '2', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(174, 2, 3, 'fktnr', 'Funkt.Nr', 'Funktions-Nummer', 'Nummer der Funktion', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 119, 1, '3', '3', 2, NULL, NULL, NULL, 'j');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(174, 3, 2, 'fkttyp', 'Funkt-Typ', 'Funktions-Typ', 'Typ der Funktion', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 116, 2, '3', '#F', 1, NULL, NULL, NULL, NULL);

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(174, 4, 4, 'zug_kz', 'Zugr.Kz.', 'Zugriffs-Kennzeichen', 'Zugriffs-Kennzeichen (für differenzierte Schreib-/Leserechte', '0', NULL, 'j', '5', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(201, 1, 5, 'beschid', 'BelegerID', 'Beleger-ID', 'Identifikator Beleger', 'MASTER', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 111, 1, '1', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(201, 2, 10, 'bunr', 'Unternr.', 'Unternummer', 'Unternummer des Belegers', 'MASTER', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 111, 2, '2', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(201, 3, 15, 'lastss', 'Sollst.', 'Letzte Sollstellung', 'Datum der letzten Sollstellung', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(201, 4, 20, 'faellig', 'Fällig', 'Betrag fällig am', 'Datum der Fälligkeit', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(201, 5, 25, 'betrag', 'Betrag', 'Sollst.-Betrag', 'Betrag der Sollstellung', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(998, 1, 1, 'zeit', 'Zeitpunkt', 'Zeitpunkte', 'Zeitpunkt, an dem der Auftrag ausgewählt wurde', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(998, 2, 2, 'username', 'User', 'Benutzer', 'Benutzer, der gegenwärtig aktiv ist', NULL, NULL, 'n', '3', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 126, 2, '6', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(998, 3, 3, 'connid', 'Verbindung', 'Verbindungs-ID', 'ID der Connect-Verbindung zur DB (HashCode)', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(998, 4, 4, 'ident', 'Identifik.', 'Identifikator', 'Auftrag oder Bescheid', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid,feldid,m_darstid,m_feldname,m_kurzname,m_langname,m_hilfe,m_default,m_up_down,m_pflicht_jn,m_darstart,m_2spcombo_jn,m_edicombo_jn,m_darst_jn,m_neuein_jn,m_korr_jn,m_suchf_jn,m_join_jn,m_variable,m_reft,m_reff,m_refw,m_join2_q,m_join2_z,m_join3_q,m_join3_z,m_pflbeista,m_langtext)

 VALUES(509,6,2,'tage','Tage','Tage','Anzahl Tage, die für eine Berechnung anzusetzen sind',30,null,'n','1','n','n','n','j','j','n','n',null,null,null,null,null,null,null,null,null,'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 39, 23, 'edatum', 'Einstieg', 'Einstiegs-Datum', 'Datum des Beginns der regelm. Buchung', 'TODAY', NULL, 'n', '4', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'EINZUG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 40, 24, 'adatum', 'Ablauf', 'Ablauf-Datum', 'Datum, an dem die regelm. Buchung abläuft', NULL, NULL, 'n', '4', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'AUSZUG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 44, 31, 'abbuch_jn', 'Abbuchung', 'Abbuchung', 'Liegt eine Abbuchungsvollmacht vor (Lastschriftverfahren)', 'n', NULL, 'n', '2', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'ABM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 45, 28, 'blz', 'BLZ', 'Bankleitzahl', 'Bankleitzahl für das Abbuchungskonto', NULL, NULL, 'n', '1', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'BLZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 46, 29, 'kontonr', 'Konto', 'Konto-Nummer', 'Konto-Nummer des Abbucherkontos', NULL, NULL, 'n', '1', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'KONTO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 47, 30, 'kontoinh', 'Konto-Inh', 'Konto-Inhaber', 'Vom Empfänger abweichender Kontoinhaber (Name, Vorname)', NULL, NULL, 'n', '1', 'n', 'n', 'n', 'j', 'j', 'j', 'n', 'KONTOINH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(111, 90, 90, 'reflfdnr', 'Referenz', 'Referenz auf Unternr', 'Referenz auf Unternr des zu korrigierenden Ansatzes', 'BLANK', NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(141, 7, 4, 'faellig_week', 'Wöch. zum', 'wöchtl. Abr. fällig', 'Regelmäßige wöchentl. Buchungen sind fällig auf Wochentag', '3', NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(141, 8, 4, 'faellig_mon', 'Monatl zum', 'Monatl. Abr. fällig', 'Regelmäßige monatl. Buchungen sind fällig auf Tag im Monat', '3', NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(153, 9, 9, 'rechtegruppe', 'RechteGrp', 'Rechtegruppe', 'Gruppe für Berechtigungen', NULL, NULL, 'j', '3', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 120, 1, '1', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(153, 10, 10, 'vorlagengrp', 'VorlGrp', 'Vorlagengruppe', 'Gruppe der Vorlage', NULL, NULL, 'n', '3', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 160, 1, '2', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO def_fkt(fktnr,fkttyp,prog_txt,fkt_name)

 VALUES(56,'P','Auswertetabellen','Tabellen für Auswertungen aufbauen');

INSERT INTO def_progf(aktion_id,aktionbez,aktionpar,methode)

 VALUES(5,'Editierstatus Master',null,null);

INSERT INTO def_progf(aktion_id,aktionbez,aktionpar,methode)

 VALUES(105,'Felder zusammensetz.',null,null);

INSERT INTO def_progf(aktion_id,aktionbez,aktionpar,methode)

 VALUES(1201,'Summe bilden u. kop.',null,null);

INSERT INTO def_progf(aktion_id,aktionbez,aktionpar,methode)

 VALUES(1202,'E/A-Datum prüfen',null,null);

INSERT INTO def_progf(aktion_id,aktionbez,aktionpar,methode)

 VALUES(1203,'A-Dat bei Kor. geset',null,null);

insert into kon_meldtxt (meld_id, meld_typ, meld_txt) values (1114,'E','Vor einer Korrektur muss das Ablaufdatum gesetzt sein!'); insert into kon_meldtxt (meld_id, meld_typ, meld_txt) values (1115,'E','Einstiegs-/Ablaufdatum falsch (A-Dat < E-Dat, Überschn.)');

update metatabellen set m_detailtab = 171, m_detaillfd = 1 where tabid = 130;

update metafelder set m_default = 'MASTER', m_neuein_jn = 'n', m_korr_jn = 'n', m_reft = 171, m_reff = 2, m_refw = '2' where tabid = 130 and feldid = 1; update metafelder set m_darstid = 5 where m_darstid = 3 and tabid = 130; update metafelder set m_darstid = 6 where m_darstid = 4 and tabid = 130;

update kon_besch set faellig_week = 2, faellig_mon = 1 where hhjahr = 2006;

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(130, 5, 3, 'pos_von', 'Von Pos.', 'Von Position', 'Gebührenposition bezieht sich auf', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(130, 6, 4, 'pos_bis', 'Bis Pos.', 'Bis Position', 'Gebührenposition bezieht sich auf', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(171, 'T', 'GebFavoriten', 'Favoriten von  Profile für Gebührenansätze');

INSERT INTO def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(172, 'T', 'Rollen', 'Rollen für Zugriffsrechte');

INSERT INTO def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(173, 'T', 'Rollen des Users', 'Zugriffsrechte-Rollen des Benutzers');

INSERT INTO def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(174, 'T', 'Rollenrechte', 'Zugriffsrechte einer Rolle');

INSERT INTO def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(998, 'T', 'Aktive User', 'Liste der aktiven User und der in Bearbeitung befindlichen Aufträge');

insert into kon_zugr select usernr, 1, 'O', 0 from kon_zugr where fkttyp = 'P' and fktnr = 31 and not exists(select fkttyp from kon_zugr b where

 kon_zugr.usernr = b.usernr and b.fkttyp = 'O' and b.fktnr = 1);
Meine Werkzeuge
Namensräume

Varianten
Aktionen
Navigation
Werkzeuge