Operation =1
Option =0
Where ="(((tbl_statustabelle.Status_NR)=222369221) AND ((tbl_statustabelle.Status)=\"Ter"
    "min Energie VK\" Or (tbl_statustabelle.Status)=\"Termin Energie Nachholer\") AND"
    " ((tbl_statustabelle.delete)=\"KP\"))"
Begin InputTables
    Name ="tbl_statustabelle"
    Name ="tbl_kunden_solar"
    Name ="tbl_mepleadeingang"
End
Begin OutputColumns
    Expression ="tbl_statustabelle.Status_NR"
    Expression ="tbl_statustabelle.KD_NR"
    Expression ="tbl_kunden_solar.kd_nachname"
    Expression ="tbl_kunden_solar.mep_kd_nummer"
    Expression ="tbl_statustabelle.Status_NR"
    Expression ="tbl_statustabelle.Anruftag"
    Expression ="tbl_statustabelle.Status"
    Expression ="tbl_mepleadeingang.Kampagne"
    Expression ="tbl_statustabelle.Terminierer"
    Expression ="tbl_statustabelle.[WV Datum]"
    Expression ="tbl_statustabelle.[WV Uhrzeit]"
    Expression ="tbl_statustabelle.[WV Bemerkung]"
    Expression ="tbl_statustabelle.AD"
    Expression ="tbl_statustabelle.Termintag"
    Expression ="tbl_statustabelle.Termindatum"
    Expression ="tbl_statustabelle.Terminzeit"
    Expression ="tbl_statustabelle.[Termin Bemerkung]"
    Expression ="tbl_statustabelle.Bestätigt"
    Expression ="tbl_statustabelle.[Bestätigung Bemerkung]"
    Expression ="tbl_statustabelle.Ergebnis"
    Expression ="tbl_statustabelle.[Abschluß Mobil]"
    Expression ="tbl_statustabelle.[Abschluß Base]"
    Expression ="tbl_statustabelle.[Abschluß Arcor]"
    Expression ="tbl_statustabelle.[Abschluß Portierung]"
    Expression ="tbl_statustabelle.[Abschluß UMTS]"
    Expression ="tbl_statustabelle.[Abschluß DSL]"
    Expression ="tbl_statustabelle.[Abschluß Smart Home]"
    Expression ="tbl_statustabelle.Portierung"
    Expression ="tbl_statustabelle.Sofortportierung"
    Expression ="tbl_statustabelle.[Betrag Beratungsbogen]"
    Expression ="tbl_statustabelle.Nachforderung"
    Expression ="tbl_statustabelle.[Karte per Post am]"
    Expression ="tbl_statustabelle.[Uhrzeit Datum]"
    Expression ="tbl_mepleadeingang.tbl_mepleadeingang_id"
    Expression ="tbl_mepleadeingang.create_datetime"
    Expression ="tbl_statustabelle.Uhrzeit"
    Expression ="tbl_statustabelle.[Beratungsbestätigung liegt vor]"
    Expression ="tbl_statustabelle.[Kein Servicetermin gewünsch]"
    Expression ="tbl_statustabelle.Abschluss_Zweitkarte"
    Expression ="tbl_statustabelle.Terminbestaetigung"
    Expression ="tbl_statustabelle.Bestaetigt_am"
    Expression ="tbl_statustabelle.Bestaetigt_von"
    Expression ="tbl_statustabelle.Legitimation_fehlt"
    Expression ="tbl_statustabelle.Rechnung_fehlt"
    Expression ="tbl_statustabelle.Kennwort_fehlt"
    Expression ="tbl_statustabelle.Haeckchen_Sofortportierung_nicht_gesetzt"
    Expression ="tbl_statustabelle.delete"
    Expression ="tbl_statustabelle.StatusQualitaetskontrolle"
    Expression ="tbl_statustabelle.DatumQualitaetskontrolle"
    Expression ="tbl_statustabelle.SBQK"
    Expression ="tbl_statustabelle.DSiB"
    Expression ="tbl_statustabelle.InfoQK"
    Expression ="tbl_statustabelle.BemerkungQK"
    Expression ="tbl_statustabelle.Ergebnis_unter"
    Expression ="tbl_statustabelle.ID_TA"
    Expression ="tbl_statustabelle.Agent2"
    Expression ="tbl_statustabelle.Abschluss_Energy"
    Expression ="tbl_statustabelle.ShSicherheit"
    Expression ="tbl_statustabelle.KWEnergie"
    Expression ="tbl_statustabelle.update_datetime"
    Expression ="tbl_statustabelle.[Ordner hinterlassen]"
    Expression ="tbl_statustabelle.update_backoffice"
    Expression ="tbl_statustabelle.id_solartyp"
End
Begin Joins
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_kunden_solar"
    Expression ="tbl_statustabelle.KD_NR = tbl_kunden_solar.bcs_kd_nummer"
    Flag =1
    LeftTable ="tbl_kunden_solar"
    RightTable ="tbl_mepleadeingang"
    Expression ="tbl_kunden_solar.mep_kd_nummer = tbl_mepleadeingang.lead_id"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="tbl_statustabelle.Anruftag"
        dbInteger "ColumnOrder" ="5"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Status"
        dbInteger "ColumnOrder" ="8"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Terminierer"
        dbInteger "ColumnWidth" ="1215"
        dbInteger "ColumnOrder" ="9"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.KD_NR"
        dbInteger "ColumnOrder" ="2"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Status_NR"
        dbInteger "ColumnOrder" ="4"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[WV Datum]"
        dbInteger "ColumnOrder" ="14"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[WV Uhrzeit]"
        dbInteger "ColumnOrder" ="15"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[WV Bemerkung]"
        dbInteger "ColumnOrder" ="16"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.AD"
        dbInteger "ColumnOrder" ="10"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Termintag"
        dbInteger "ColumnOrder" ="11"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Termindatum"
        dbInteger "ColumnOrder" ="12"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Terminzeit"
        dbInteger "ColumnOrder" ="13"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Termin Bemerkung]"
        dbInteger "ColumnOrder" ="17"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Bestätigt"
        dbInteger "ColumnOrder" ="18"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Bestätigung Bemerkung]"
        dbInteger "ColumnOrder" ="19"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Ergebnis"
        dbInteger "ColumnOrder" ="20"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß Mobil]"
        dbInteger "ColumnOrder" ="21"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß Base]"
        dbInteger "ColumnOrder" ="22"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß Arcor]"
        dbInteger "ColumnOrder" ="23"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß Portierung]"
        dbInteger "ColumnOrder" ="24"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß UMTS]"
        dbInteger "ColumnOrder" ="25"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß DSL]"
        dbInteger "ColumnOrder" ="26"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Abschluß Smart Home]"
        dbInteger "ColumnOrder" ="27"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Portierung"
        dbInteger "ColumnOrder" ="28"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Sofortportierung"
        dbInteger "ColumnOrder" ="29"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Betrag Beratungsbogen]"
        dbInteger "ColumnOrder" ="30"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Nachforderung"
        dbInteger "ColumnOrder" ="31"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Karte per Post am]"
        dbInteger "ColumnOrder" ="32"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.[Uhrzeit Datum]"
        dbInteger "ColumnOrder" ="33"
    End
    Begin
        dbText "Name" ="tbl_kunden_solar.kd_nachname"
        dbInteger "ColumnOrder" ="3"
    End
    Begin
        dbText "Name" ="tbl_mepleadeingang.tbl_mepleadeingang_id"
        dbInteger "ColumnOrder" ="6"
    End
    Begin
        dbText "Name" ="tbl_mepleadeingang.create_datetime"
        dbInteger "ColumnOrder" ="7"
    End
    Begin
        dbText "Name" ="tbl_kunden_solar.mep_kd_nummer"
        dbInteger "ColumnOrder" ="1"
    End
End
Begin
    State =2
    Left =-4
    Top =-25
    Right =3440
    Bottom =1246
    Left =-1
    Top =-1
    Right =3433
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =115
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =464
        Top =10
        Right =723
        Bottom =119
        Top =0
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =848
        Top =21
        Right =1421
        Bottom =130
        Top =17
        Name ="tbl_mepleadeingang"
        Name =""
    End
End
