Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.
| Beide Seiten, vorherige ÜberarbeitungVorherige ÜberarbeitungNächste Überarbeitung | Vorherige Überarbeitung | ||
| feldbefehle [2023/05/24 11:03] – [adn_termin_vorlauf] petelka | feldbefehle [2023/07/05 16:37] (aktuell) – [adn_termin] behr | ||
|---|---|---|---|
| Zeile 2: | Zeile 2: | ||
| [[belegmuster_ohnelager# | [[belegmuster_ohnelager# | ||
| \\ | \\ | ||
| - | \\ | ||
| - | ===== adn_abrechnung_kosten ===== | ||
| - | |||
| - | adn_mandanten_id => | ||
| - | \\ | ||
| - | datum => | ||
| - | \\ | ||
| - | mitarbeiter => | ||
| - | \\ | ||
| - | adn_abrechnung_typ_id => | ||
| - | \\ | ||
| - | buchungstext => | ||
| - | \\ | ||
| - | betrag => | ||
| - | \\ | ||
| - | bemerkung => | ||
| - | \\ | ||
| - | adn_abrechnung_rechnung_id => | ||
| - | \\ | ||
| - | \\ | ||
| - | |||
| - | ===== adn_abrechnung_typ ===== | ||
| - | |||
| - | kennzeichen => | ||
| - | \\ | ||
| - | text => | ||
| - | \\ | ||
| \\ | \\ | ||
| ===== adn_amtsgerichte ===== | ===== adn_amtsgerichte ===== | ||
| - | gericht => | + | gericht => Gericht |
| \\ | \\ | ||
| - | ort => | + | ort => Ort |
| \\ | \\ | ||
| - | zusatz => | + | zusatz => Adresszusatz |
| \\ | \\ | ||
| - | plz => | + | plz => Postleitzahl |
| \\ | \\ | ||
| - | strasse => | + | strasse => Straße |
| \\ | \\ | ||
| - | telefon => | + | telefon => Telefon |
| \\ | \\ | ||
| - | fax => | + | fax => Fax |
| - | \\ | + | |
| - | richter => | + | |
| - | \\ | + | |
| - | rechtspfleger => | + | |
| - | \\ | + | |
| - | region => | + | |
| - | \\ | + | |
| - | ra_kennz => | + | |
| \\ | \\ | ||
| + | richter => Richter | ||
| \\ | \\ | ||
| + | rechtspfleger => Rechtspfleger | ||
| ===== adn_behoerdliche_daten ===== | ===== adn_behoerdliche_daten ===== | ||
| - | gen_stelle => | + | gen_stelle => Stelle |
| - | \\ | + | |
| - | gen_behoerde => | + | |
| - | \\ | + | |
| - | gen_datum_zulassung => | + | |
| \\ | \\ | ||
| - | gen_az | + | gen_behoerde |
| \\ | \\ | ||
| - | gen_str | + | gen_datum_zulassung |
| \\ | \\ | ||
| - | gen_hausnr | + | gen_az |
| \\ | \\ | ||
| - | gen_plz | + | gen_str |
| \\ | \\ | ||
| - | gen_ort | + | gen_hausnr |
| \\ | \\ | ||
| - | gen_gf | + | gen_plz |
| \\ | \\ | ||
| - | gen_tel | + | gen_ort |
| \\ | \\ | ||
| - | gen_fax | + | gen_gf |
| \\ | \\ | ||
| - | region | + | gen_tel |
| \\ | \\ | ||
| - | ra_kennz | + | gen_fax |
| \\ | \\ | ||
| - | bs_stellenid => | + | bs_stellenid => Stellen-ID |
| \\ | \\ | ||
| \\ | \\ | ||
| - | ===== adn_forderung ===== | + | ===== adn_forderung |
| - | adn_glaeubiger_name | + | glnr => Gläubigernummer |
| \\ | \\ | ||
| - | glnr => | + | glzeichen |
| \\ | \\ | ||
| - | glzeichen | + | eingang_ford_aufst |
| \\ | \\ | ||
| - | eingang_ford_aufst | + | vgl_antwort |
| \\ | \\ | ||
| - | vgl_antwort | + | vgl_rate_anteil |
| \\ | \\ | ||
| + | zahlung_interval => Das Intervall der Zahlung an den Gläubiger | ||
| \\ | \\ | ||
| - | + | einmalzahlung_anteil | |
| - | ===== adn_forderung_pos ===== | + | |
| - | + | ||
| - | eingang_ford_aufst => | + | |
| - | \\ | + | |
| - | zinsberechnung_bis => | + | |
| - | \\ | + | |
| - | art_der_ford_unterlage => | + | |
| - | \\ | + | |
| - | hauptforderung => | + | |
| - | \\ | + | |
| - | zinsen => | + | |
| - | \\ | + | |
| - | kosten => | + | |
| - | \\ | + | |
| - | gesamtforderung => | + | |
| - | \\ | + | |
| - | datum_der_unterl => | + | |
| - | \\ | + | |
| - | glzeichen => | + | |
| - | \\ | + | |
| - | glaeubiger_ur_az => | + | |
| - | \\ | + | |
| - | bemerkung | + | |
| \\ | \\ | ||
| + | bemerkung => Bemerkung | ||
| \\ | \\ | ||
| + | ===== adn_forderung_pos - (Forderungen eines Gläubigers) ===== | ||
| - | ===== adn_gebuehren ===== | + | zinsberechnung_bis |
| - | + | ||
| - | beratung | + | |
| \\ | \\ | ||
| - | bh_geb | + | art_der_ford_unterlage |
| \\ | \\ | ||
| - | telefon_pau | + | hauptforderung |
| \\ | \\ | ||
| - | fa => | + | zinsen |
| \\ | \\ | ||
| - | vgl_5 => | + | kosten |
| \\ | \\ | ||
| - | vgl_10 | + | gesamtforderung |
| \\ | \\ | ||
| - | vgl_15 | + | datum_der_unterl |
| \\ | \\ | ||
| - | vgl_16 | + | glaeubiger_ur_az |
| \\ | \\ | ||
| - | honorar | + | bemerkung |
| \\ | \\ | ||
| - | insoantrag | + | forderungsgrund |
| \\ | \\ | ||
| - | satz => | + | gesicherte_forderung |
| \\ | \\ | ||
| - | kopierkosten => | + | vertreter_az |
| - | \\ | + | |
| - | mahnung => | + | |
| - | \\ | + | |
| - | sachstand => | + | |
| - | \\ | + | |
| - | planverf => | + | |
| - | \\ | + | |
| - | geb_rz => | + | |
| - | \\ | + | |
| - | ust => | + | |
| - | \\ | + | |
| - | porto_20 => | + | |
| - | \\ | + | |
| - | porto_more_20 => | + | |
| - | \\ | + | |
| - | einschreiben => | + | |
| - | \\ | + | |
| - | sb_stelle => | + | |
| - | \\ | + | |
| - | sb_region => | + | |
| - | \\ | + | |
| - | p_konto => | + | |
| - | \\ | + | |
| - | p_konto_prozent => | + | |
| - | \\ | + | |
| - | geb_stand | + | |
| \\ | \\ | ||
| \\ | \\ | ||
| + | |||
| ===== adn_glaeubiger_stammdaten ===== | ===== adn_glaeubiger_stammdaten ===== | ||
| - | adn_mandanten_id | + | glname |
| \\ | \\ | ||
| - | ra_kennz | + | glaeubiger_rep |
| \\ | \\ | ||
| - | region | + | glaeubiger_str |
| \\ | \\ | ||
| - | kdnr => | + | glaeubiger_ort |
| \\ | \\ | ||
| - | name_as1 | + | gl_vertreter |
| \\ | \\ | ||
| - | glnr => | + | glbank |
| \\ | \\ | ||
| - | glordner | + | gliban_nr |
| \\ | \\ | ||
| - | raordner | + | telefon |
| \\ | \\ | ||
| - | gl_zuordnung | + | fax => Fax |
| \\ | \\ | ||
| - | glname => | + | email => E-Mail-Adresse |
| - | \\ | + | |
| - | position_gl_rep => | + | |
| - | \\ | + | |
| - | glaeubiger_rep => | + | |
| - | \\ | + | |
| - | glaeubiger_str => | + | |
| - | \\ | + | |
| - | glaeubiger_ort => | + | |
| - | \\ | + | |
| - | gl_vertreter => | + | |
| - | \\ | + | |
| - | zhd => | + | |
| - | \\ | + | |
| - | anrede => | + | |
| - | \\ | + | |
| - | str_nr => | + | |
| - | \\ | + | |
| - | plz_ort => | + | |
| - | \\ | + | |
| - | ktoemp => | + | |
| - | \\ | + | |
| - | glbank => | + | |
| - | \\ | + | |
| - | glkto => | + | |
| - | \\ | + | |
| - | glblz => | + | |
| - | \\ | + | |
| - | verwendungszweck => | + | |
| - | \\ | + | |
| - | verwendungszweck2 => | + | |
| - | \\ | + | |
| - | telefon => | + | |
| - | \\ | + | |
| - | fax => | + | |
| - | \\ | + | |
| - | buerge => | + | |
| - | \\ | + | |
| - | eingang_ford_aufst => | + | |
| - | \\ | + | |
| - | zinsberechnung_bis => | + | |
| - | \\ | + | |
| - | art_der_ford_unterlage => | + | |
| - | \\ | + | |
| - | hauptforderung => | + | |
| - | \\ | + | |
| - | zinsen => | + | |
| - | \\ | + | |
| - | kosten => | + | |
| - | \\ | + | |
| - | gesamtforderung => | + | |
| - | \\ | + | |
| - | datum_der_unterl => | + | |
| - | \\ | + | |
| - | glzeichen => | + | |
| - | \\ | + | |
| - | glaeubiger_ur_az => | + | |
| - | \\ | + | |
| - | art_der_ford_unterlage1 => | + | |
| - | \\ | + | |
| - | hauptforderung1 => | + | |
| - | \\ | + | |
| - | zinsen1 => | + | |
| - | \\ | + | |
| - | kosten1 => | + | |
| - | \\ | + | |
| - | gesamtforderung1 => | + | |
| - | \\ | + | |
| - | datum_der_unterl1 => | + | |
| - | \\ | + | |
| - | glzeichen1 => | + | |
| - | \\ | + | |
| - | glaeubiger_ur_az1 => | + | |
| - | \\ | + | |
| - | art_der_ford_unterlage2 => | + | |
| - | \\ | + | |
| - | tituliert2 => | + | |
| - | \\ | + | |
| - | hauptforderung2 => | + | |
| - | \\ | + | |
| - | zinsen2 => | + | |
| - | \\ | + | |
| - | kosten2 => | + | |
| - | \\ | + | |
| - | gesamtforderung2 => | + | |
| - | \\ | + | |
| - | datum_der_unterl2 => | + | |
| - | \\ | + | |
| - | glzeichen2 => | + | |
| - | \\ | + | |
| - | glaeubiger_ur_az2 => | + | |
| - | \\ | + | |
| - | weitere_az => | + | |
| - | \\ | + | |
| - | vgl_antwort => | + | |
| - | \\ | + | |
| - | lgabtr_datum => | + | |
| - | \\ | + | |
| - | lgabtr_hoehe => | + | |
| - | \\ | + | |
| - | weitere_angaben_abtr => | + | |
| - | \\ | + | |
| - | sicherheiten => | + | |
| - | \\ | + | |
| - | art_der_sicherheiten => | + | |
| - | \\ | + | |
| - | seit => | + | |
| - | \\ | + | |
| - | fa_abgeschickt_datum => | + | |
| - | \\ | + | |
| - | fa_mahnung_datum => | + | |
| - | \\ | + | |
| - | fa_tel_mahnung => | + | |
| - | \\ | + | |
| - | fa_tel_mahnung_datum => | + | |
| - | \\ | + | |
| - | quote_anteil => | + | |
| - | \\ | + | |
| - | quote_vergleich => | + | |
| - | \\ | + | |
| - | vergleichsbetrag => | + | |
| - | \\ | + | |
| - | zahl_sq => | + | |
| - | \\ | + | |
| - | rate => | + | |
| - | \\ | + | |
| - | ab => | + | |
| - | \\ | + | |
| - | bis => | + | |
| - | \\ | + | |
| - | absonderungsbetrag => | + | |
| - | \\ | + | |
| - | zahl_sq1 => | + | |
| - | \\ | + | |
| - | rate1 => | + | |
| - | \\ | + | |
| - | ab1 => | + | |
| - | \\ | + | |
| - | bis1 => | + | |
| - | \\ | + | |
| - | vgl_abgeschickt_datum => | + | |
| - | \\ | + | |
| - | vgl_angemahnt_datum => | + | |
| - | \\ | + | |
| - | vgl_tel_angemahnt => | + | |
| - | \\ | + | |
| - | vgl_tel_angemahnt_datum => | + | |
| - | \\ | + | |
| - | gezahlt => | + | |
| - | \\ | + | |
| - | bemerkungen => | + | |
| - | \\ | + | |
| - | gek => | + | |
| - | \\ | + | |
| - | gl_aufgenommen_von => | + | |
| - | \\ | + | |
| - | zinsberechnung_durchgefuehrt_von => | + | |
| - | \\ | + | |
| - | letzte_gl_aenderung_durch => | + | |
| - | \\ | + | |
| - | zahl_sq2 => | + | |
| - | \\ | + | |
| - | rate2 => | + | |
| - | \\ | + | |
| - | ab2 => | + | |
| - | \\ | + | |
| - | bis2 => | + | |
| - | \\ | + | |
| - | zahl_sq3 => | + | |
| - | \\ | + | |
| - | rate3 => | + | |
| - | \\ | + | |
| - | ab3 => | + | |
| - | \\ | + | |
| - | bis3 => | + | |
| - | \\ | + | |
| - | email => | + | |
| - | \\ | + | |
| - | gliban_nr => | + | |
| - | \\ | + | |
| - | artglaeubiger => | + | |
| \\ | \\ | ||
| \\ | \\ | ||
| Zeile 389: | Zeile 125: | ||
| ===== adn_glaeubiger_vertreter ===== | ===== adn_glaeubiger_vertreter ===== | ||
| - | gl_vertreter => | + | gl_vertreter => Name |
| \\ | \\ | ||
| - | strasse => | + | strasse => Straße |
| \\ | \\ | ||
| - | hausnummer => | + | hausnummer => Hausnummer |
| \\ | \\ | ||
| - | plz => | + | plz => Postleitzahl |
| \\ | \\ | ||
| - | ort => | + | ort => Ort |
| \\ | \\ | ||
| - | telefon => | + | telefon => Telefon |
| \\ | \\ | ||
| - | fax => | + | fax => Fax |
| \\ | \\ | ||
| - | email => | + | email => E-Mail-Adresse |
| \\ | \\ | ||
| \\ | \\ | ||
| ===== adn_mandanten_haushaltsplan ===== | ===== adn_mandanten_haushaltsplan ===== | ||
| - | + | id => Haushaltsplan ID | |
| - | adn_mandanten_id | + | |
| \\ | \\ | ||
| - | kdnr => | + | kdnr => Kundennummer |
| \\ | \\ | ||
| - | datum => | + | datum => Datum der Erstellung |
| \\ | \\ | ||
| - | 1_lohn_gehalt => | + | 1_lohn_gehalt => Lohn / Gehalt |
| \\ | \\ | ||
| - | 2_rente => | + | 2_rente => Rente |
| \\ | \\ | ||
| - | 3_provisionen => | + | 3_provisionen => Provisionen |
| \\ | \\ | ||
| - | 5_vermietung_verpachtung => | + | 5_vermietung_verpachtung => Vermietung / Verpachtung |
| \\ | \\ | ||
| - | 6_selbstaendigkeit => | + | 6_selbstaendigkeit => Selbständigkeit |
| \\ | \\ | ||
| - | 7_sonstige_einnahmen => | + | 7_sonstige_einnahmen => sonstige Einnahmen |
| \\ | \\ | ||
| - | 8_krankengeld => | + | 8_krankengeld => Krankengeld |
| \\ | \\ | ||
| - | 9_wohngeld => | + | 9_wohngeld => Wohngeld |
| \\ | \\ | ||
| - | 10_alg_i => | + | 10_alg_i => Arbeitslosengeld 1 |
| \\ | \\ | ||
| - | 11_alg_ii_hartz_iv_sgb_ii => | + | 11_alg_ii_hartz_iv_sgb_ii => Arbeitslosengeld II / Bürgergeld / SGB II |
| \\ | \\ | ||
| - | 12_sgb_xii => | + | 12_sgb_xii => SGB XII |
| \\ | \\ | ||
| - | 13_kindergeld => | + | 13_kindergeld => Kindergeld |
| \\ | \\ | ||
| - | 14_erziehungsgeld => | + | 14_erziehungsgeld => Erziehungsgeld |
| \\ | \\ | ||
| - | 15_unterhalt => | + | 15_unterhalt => Unterhalt |
| \\ | \\ | ||
| - | 17_sonstige_einkuenfte => | + | 17_sonstige_einkuenfte => sonstige Einkünfte |
| \\ | \\ | ||
| - | 18_sonstige_einkuenfte => | + | 18_sonstige_einkuenfte => Zusatz |
| \\ | \\ | ||
| - | 201_miete => | + | 201_miete => Miete |
| \\ | \\ | ||
| - | 202_nebenkosten => | + | 202_nebenkosten => Nebenkosten |
| \\ | \\ | ||
| - | 203_strom_gas => | + | 203_strom_gas => Strom / Gas |
| \\ | \\ | ||
| - | 205_privathaftpflicht => | + | 205_privathaftpflicht => private Haftpflichtversicherung |
| \\ | \\ | ||
| - | 206_hausrat => | + | 206_hausrat => Hausratversicherung |
| \\ | \\ | ||
| - | 207_rechtschutz => | + | 207_rechtschutz => Rechtschutzversicherung |
| \\ | \\ | ||
| - | 208_unfall => | + | 208_unfall => Unfallversicherung |
| \\ | \\ | ||
| - | 209_verm_leistung_vl => | + | 209_verm_leistung_vl => |
| \\ | \\ | ||
| - | 210_rentenvers => | + | 210_rentenvers => Rentenversciherung |
| \\ | \\ | ||
| - | 211_sonstige_vers => | + | 211_sonstige_vers => sonstige Versicherungen |
| \\ | \\ | ||
| - | 212_sonstige_vers | + | 213_kreditraten |
| \\ | \\ | ||
| - | 213_kreditraten | + | 214_raten_an_versandhaeuser => Raten an Versandhäuser |
| \\ | \\ | ||
| - | 214_raten_an_versandhaeuser | + | 215_leasingraten |
| \\ | \\ | ||
| - | 215_leasingraten | + | 216_unterhalt |
| \\ | \\ | ||
| - | 216_unterhalt | + | 217_sonstige_ratenzahlungen |
| \\ | \\ | ||
| - | 217_sonstige_ratenzahlungen | + | 219_kfz_versicherung |
| \\ | \\ | ||
| - | 219_kfz_versicherung | + | 220_kfz_steuer |
| \\ | \\ | ||
| - | 220_kfz_steuer | + | 221_kraftstoff |
| \\ | \\ | ||
| - | 221_kraftstoff | + | 222_wartung_reparatur |
| \\ | \\ | ||
| - | 222_wartung_reparatur | + | 224_gez |
| \\ | \\ | ||
| - | 224_gez | + | 225_telefon |
| \\ | \\ | ||
| - | 225_telefon | + | 226_mobiltelefon |
| \\ | \\ | ||
| - | 226_mobiltelefon | + | 227_internet |
| \\ | \\ | ||
| - | 227_internet | + | 228_abonnement |
| \\ | \\ | ||
| - | 228_abonnement | + | 229_lebenshaltungskosten |
| \\ | \\ | ||
| - | 229_lebenshaltungskosten | + | 232_kindergartenbeitraege |
| \\ | \\ | ||
| - | 232_kindergartenbeitraege | + | 233_vereinsbeitraege |
| \\ | \\ | ||
| - | 233_vereinsbeitraege | + | 234_sonstige |
| \\ | \\ | ||
| - | 234_sonstige | + | anzahl_pers_erwachsene |
| \\ | \\ | ||
| - | anzahl_pers_erwachsene | + | anzahl_pers_kinder |
| \\ | \\ | ||
| - | anzahl_pers_kinder | + | bemerkung |
| \\ | \\ | ||
| - | bemerkung => | + | erstellt_von => Sachbearbeiter |
| - | \\ | + | |
| - | erstellt_von => | + | |
| \\ | \\ | ||
| \\ | \\ | ||
| - | ===== adn_mandanten_memo ===== | ||
| - | |||
| - | kdnr => | ||
| - | \\ | ||
| - | gl_nr => | ||
| - | \\ | ||
| - | bemerkung => | ||
| - | \\ | ||
| - | wiedervorlage => | ||
| - | \\ | ||
| - | datum => | ||
| - | \\ | ||
| - | sachbearbeiter => | ||
| - | \\ | ||
| - | memo_erstellt_von => | ||
| - | \\ | ||
| - | region => | ||
| - | \\ | ||
| - | ra_kennz => | ||
| - | \\ | ||
| - | \\ | ||
| ===== adn_mandanten_stammdaten ===== | ===== adn_mandanten_stammdaten ===== | ||
| - | ra_kennz => | + | ra_kennz => Stellenkennzahl |
| \\ | \\ | ||
| - | region => | + | region => Regionskennzahl |
| \\ | \\ | ||
| - | kdnr => | + | kdnr => Kundennummer |
| \\ | \\ | ||
| - | gl_ordner | + | sachbearbeiter |
| \\ | \\ | ||
| - | sachbearbeiter | + | vertragsdatum |
| \\ | \\ | ||
| - | vertragsdatum | + | datenanfrage |
| \\ | \\ | ||
| - | vertragsbeginn | + | antwort_datenanfr |
| \\ | \\ | ||
| - | datenanfrage | + | beratungstermin |
| \\ | \\ | ||
| - | antwort_datenanfr | + | beginn_forderungsaufst |
| \\ | \\ | ||
| - | beratungstermin | + | forderungsaufst_frist |
| \\ | \\ | ||
| - | beginn_forderungsaufst | + | ford_angemahnt |
| \\ | \\ | ||
| - | ford_angemahnt | + | ford_angemahnt_frist |
| \\ | \\ | ||
| - | beginn_vergleichsangebote => | + | beginn_vergleichsangebote => Beginn der Vergleichsangebote |
| \\ | \\ | ||
| - | vgl_angemahnt => | + | vgl_angemahnt => Datum der Anmahnung der Vergleichsangebote |
| \\ | \\ | ||
| - | vgl_nachbesserung => | + | vgl_nachbesserung => erneuter außergerichtlicher Einigungsversuch |
| \\ | \\ | ||
| - | datum_insoantrag => | + | datum_insoantrag => Datum der Frist des Insolvenzantrages |
| \\ | \\ | ||
| - | insolvenzantrag => | + | insolvenzantrag => Datum der Erstellung des Insolvenzantrages |
| \\ | \\ | ||
| - | ab => | + | anrede |
| \\ | \\ | ||
| - | anrede | + | titel => Titel |
| \\ | \\ | ||
| - | titel => | + | name => Nachname |
| \\ | \\ | ||
| - | name => | + | vorname |
| \\ | \\ | ||
| - | vorname | + | geburtsname |
| \\ | \\ | ||
| - | geburtsname | + | geb => Geburtsdatum |
| \\ | \\ | ||
| - | geb => | + | geburtsort |
| \\ | \\ | ||
| - | geburtsort | + | adr_zusatz |
| \\ | \\ | ||
| - | adr_zusatz | + | strasse |
| \\ | \\ | ||
| - | strasse | + | hausnummer |
| \\ | \\ | ||
| - | hausnummer | + | plz => Postleitzahl |
| \\ | \\ | ||
| - | plz => | + | ort => Ort |
| \\ | \\ | ||
| - | ort => | + | telefon |
| \\ | \\ | ||
| - | telefon | + | mobil => Mobiltelefonnummer |
| \\ | \\ | ||
| - | mobil => | + | email => E-Mail-Adresse |
| \\ | \\ | ||
| - | fax => | + | fam_stand |
| \\ | \\ | ||
| - | email => | + | seit_fms |
| \\ | \\ | ||
| - | fam_stand | + | erlernter_beruf |
| \\ | \\ | ||
| - | seit_fms | + | ausgeuebte_taetigkeit |
| \\ | \\ | ||
| - | erlernter_beruf | + | seit => Datum, seit wann die Tätigkeit ausgeübt wird |
| \\ | \\ | ||
| - | ausgeuebte_taetigkeit | + | lohnsteuerklasse |
| \\ | \\ | ||
| - | seit => | + | scheitern_vergl |
| \\ | \\ | ||
| - | lohnsteuerklasse | + | mtl_ueberw |
| \\ | \\ | ||
| - | scheitern_vergl | + | zw => Zahlweise |
| \\ | \\ | ||
| - | mtl_ueberw | + | netto => Nettoeinkommen |
| \\ | \\ | ||
| - | zw => | + | art_des_einkommens |
| \\ | \\ | ||
| - | netto => | + | pfaendbar |
| \\ | \\ | ||
| - | art_des_einkommens | + | aktive_pfaendung |
| \\ | \\ | ||
| - | pfaendbar | + | auszahlung |
| \\ | \\ | ||
| - | aktive_pfaendung | + | ebschaft_erwartet |
| \\ | \\ | ||
| - | auszahlung | + | kontoinhaber |
| \\ | \\ | ||
| - | ebschaft_erwartet | + | bankv => Bankverbindung |
| \\ | \\ | ||
| - | kontoinhaber | + | ktonr => IBAN |
| \\ | \\ | ||
| - | bankv => | + | grund_zu |
| \\ | \\ | ||
| - | ktonr => | + | forderungen_as |
| \\ | \\ | ||
| - | blz => | + | gl_anzahl_as |
| \\ | \\ | ||
| - | verb_as | + | allg_bemerkung |
| \\ | \\ | ||
| - | zahlungsunfaehig | + | kunden_gekuendigt |
| \\ | \\ | ||
| - | beleg_zu | + | hinweise_fuer_das_insoverf |
| \\ | \\ | ||
| - | grund_zu | + | hinweise_fuer_die_vgl_verh |
| \\ | \\ | ||
| - | wohlverhaltensp | + | sonstiges_vermoegen_1 |
| \\ | \\ | ||
| - | insovenzmasse | + | stamm_memo |
| \\ | \\ | ||
| - | forderungen_as | + | unterlagen_abgelegt |
| \\ | \\ | ||
| - | vergl_quote_as | + | betreuer |
| \\ | \\ | ||
| - | vergl_rate_as | + | az_insogericht |
| \\ | \\ | ||
| - | absonderung_rate | + | arbeitseinkommen |
| \\ | \\ | ||
| - | beratungsgebuehr | + | sozialleistungen |
| \\ | \\ | ||
| - | vgl_gebuehr | + | sonstiges |
| \\ | \\ | ||
| - | gl_gebuehren_nachtrag | + | ek_abgaben |
| \\ | \\ | ||
| - | forderungsaufstellungen | + | versicherungen |
| \\ | \\ | ||
| - | geb_insoantrag | + | altersvorsorge |
| \\ | \\ | ||
| - | telefonpauschale | + | werbungskosten |
| \\ | \\ | ||
| - | erfolgshonorar | + | einkommensfreibetrag |
| \\ | \\ | ||
| - | sachstandsmitteilungen | + | erwerbstaetigenfreibetrag |
| \\ | \\ | ||
| - | kopierkosten | + | unterhaltsfreibetrag_gatte |
| \\ | \\ | ||
| - | 1_4_std_satz | + | unterhaltsfreibetrag |
| \\ | \\ | ||
| - | mahnungen | + | wohnkosten |
| \\ | \\ | ||
| - | einrichtungsgeb | + | sbg_xii |
| \\ | \\ | ||
| - | edv_erfassung_gl | + | erwerb_behinderte |
| \\ | \\ | ||
| - | verwaltungsgebuehr | + | unterhaltsber |
| \\ | \\ | ||
| - | ueberweisungsgeb | + | kredit_abzahlungsraten |
| \\ | \\ | ||
| - | tpt_pauschale | + | arzt_zahnersatz_kurkosten |
| \\ | \\ | ||
| - | abrechnungsgeb | + | unterhaltsleistung |
| - | \\ | + | |
| - | erweitere_betreuung => | + | |
| - | \\ | + | |
| - | kz_abr => | + | |
| - | \\ | + | |
| - | mahngebuehren => | + | |
| - | \\ | + | |
| - | gl_anzahl_as => | + | |
| - | \\ | + | |
| - | unterh1_as => | + | |
| - | \\ | + | |
| - | unterh2_as => | + | |
| - | \\ | + | |
| - | unterh3_as => | + | |
| - | \\ | + | |
| - | unterh4_as => | + | |
| - | \\ | + | |
| - | unterh5_as => | + | |
| - | \\ | + | |
| - | allg_bemerkung => | + | |
| - | \\ | + | |
| - | ev1datum => | + | |
| - | \\ | + | |
| - | ev2datum => | + | |
| - | \\ | + | |
| - | ansparsumme => | + | |
| - | \\ | + | |
| - | kunden_gekuendigt => | + | |
| - | \\ | + | |
| - | kunde_hat_gekuendigt => | + | |
| - | \\ | + | |
| - | glgek => | + | |
| - | \\ | + | |
| - | hinweise_fuer_das_insoverf => | + | |
| - | \\ | + | |
| - | hinweise_fuer_die_vgl_verh => | + | |
| - | \\ | + | |
| - | sonstiges_vermoegen_1 => | + | |
| - | \\ | + | |
| - | prognosebetrag_1 => | + | |
| - | \\ | + | |
| - | zinzberechnung_ges_bis => | + | |
| - | \\ | + | |
| - | stamm_memo => | + | |
| - | \\ | + | |
| - | glaeubigerzahlungen => | + | |
| - | \\ | + | |
| - | regelinso => | + | |
| - | \\ | + | |
| - | verbraucherinso => | + | |
| - | \\ | + | |
| - | isno_status => | + | |
| - | \\ | + | |
| - | unterlagen_abgelegt => | + | |
| - | \\ | + | |
| - | kd_aufgenommen_von => | + | |
| - | \\ | + | |
| - | schuldenber_plan_erstellt_von => | + | |
| - | \\ | + | |
| - | letzte_kd_aenderung_durch => | + | |
| - | \\ | + | |
| - | gewuenschte_bank => | + | |
| - | \\ | + | |
| - | filiale_gew_bank => | + | |
| - | \\ | + | |
| - | str_nr_gew_bank => | + | |
| - | \\ | + | |
| - | plz_ort_gew_bank => | + | |
| - | \\ | + | |
| - | gewuenschte_bank => | + | |
| - | \\ | + | |
| - | rechnungsnr => | + | |
| - | \\ | + | |
| - | antrag_an_ag => | + | |
| - | \\ | + | |
| - | bh_bewilligt => | + | |
| - | \\ | + | |
| - | bh_re_an_ag => | + | |
| - | \\ | + | |
| - | zwersterate => | + | |
| - | \\ | + | |
| - | kostenuebernahme_von => | + | |
| - | \\ | + | |
| - | vertretung_ger_verf_geb => | + | |
| - | \\ | + | |
| - | aktenzeichen_ag => | + | |
| - | \\ | + | |
| - | eselbstaendigkeit => | + | |
| - | \\ | + | |
| - | sgb_kdnr => | + | |
| - | \\ | + | |
| - | betreuer => | + | |
| - | \\ | + | |
| - | \\ | + | |
| ===== adn_mandanten_unterhalt ===== | ===== adn_mandanten_unterhalt ===== | ||
| - | adn_mandanten_id | + | name => Name |
| \\ | \\ | ||
| - | name => | + | vorname |
| \\ | \\ | ||
| - | vorname | + | geburtsdatum |
| \\ | \\ | ||
| - | geburtsdatum | + | wohnort |
| \\ | \\ | ||
| - | wohnort | + | postleitzahl |
| \\ | \\ | ||
| - | postleitzahl | + | strasse |
| \\ | \\ | ||
| - | strasse | + | hausnummer |
| \\ | \\ | ||
| - | hausnummer | + | beziehung |
| \\ | \\ | ||
| - | beziehung | + | bemerkung |
| \\ | \\ | ||
| - | bemerkung | + | summe => Summe |
| \\ | \\ | ||
| - | summe => | + | einkommen => Einkommen |
| - | \\ | + | |
| - | einkommen => | + | |
| \\ | \\ | ||
| \\ | \\ | ||
| - | ===== adn_netzwerk ===== | ||
| - | sn_einrichtung => | ||
| - | \\ | ||
| - | sn_art => | ||
| - | \\ | ||
| - | sn_ort => | ||
| - | \\ | ||
| - | sn_zusatz => | ||
| - | \\ | ||
| - | sn_plz => | ||
| - | \\ | ||
| - | sn_strasse_postfach => | ||
| - | \\ | ||
| - | sn_ansprechpartner_vorname => | ||
| - | \\ | ||
| - | sn_ansprechpartner_nachname => | ||
| - | \\ | ||
| - | sn_anrede => | ||
| - | \\ | ||
| - | sn_telefon => | ||
| - | \\ | ||
| - | sn_fax => | ||
| - | \\ | ||
| - | sn_mail => | ||
| - | \\ | ||
| - | region => | ||
| - | \\ | ||
| - | ra_kennz => | ||
| - | \\ | ||
| - | sn_notiz => | ||
| - | \\ | ||
| - | \\ | ||
| - | ===== adn_sachbearbeiter ===== | ||
| - | |||
| - | name => | ||
| - | \\ | ||
| - | idp_sb => | ||
| - | \\ | ||
| - | region => | ||
| - | \\ | ||
| - | ra_kennz => | ||
| - | \\ | ||
| - | user => | ||
| - | \\ | ||
| - | \\ | ||
| - | |||
| - | ===== adn_stellen_kosten ===== | ||
| - | |||
| - | adn_stellen_id => | ||
| - | \\ | ||
| - | adn_abrechnung_typ_id => | ||
| - | \\ | ||
| - | betrag => | ||
| - | \\ | ||
| - | \\ | ||
| ===== adn_termin ===== | ===== adn_termin ===== | ||
| - | created_username | + | confirm_date |
| \\ | \\ | ||
| - | created_date | + | termin_art |
| \\ | \\ | ||
| - | confirm_date | + | termin_date |
| \\ | \\ | ||
| - | adn_mandant_id | + | von_hour |
| \\ | \\ | ||
| - | adn_mandant2_id | + | von_minute |
| \\ | \\ | ||
| - | termin_art | + | bis_hour |
| \\ | \\ | ||
| - | termin_date | + | bis_minute |
| \\ | \\ | ||
| - | von_hour | + | termin_status |
| \\ | \\ | ||
| - | von_minute => | + | bem => Stamm Memo |
| - | \\ | + | |
| - | bis_hour => | + | |
| - | \\ | + | |
| - | bis_minute => | + | |
| - | \\ | + | |
| - | termin_status => | + | |
| - | \\ | + | |
| - | bem => | + | |
| \\ | \\ | ||
| \\ | \\ | ||
| - | ===== adn_termin_vorlauf ===== | ||
| - | |||
| - | name => | ||
| - | \\ | ||
| - | date_start => | ||
| - | \\ | ||
| - | von_hour => | ||
| - | \\ | ||
| - | von_minute => | ||
| - | \\ | ||
| - | sys_user_id => | ||
| - | \\ | ||
| - | interval_days => | ||
| - | \\ | ||
| - | last_date => | ||
| - | \\ | ||
| - | bemerkung => | ||
| - | \\ | ||
| - | \\ | ||