Operation =1
Option =0
Begin InputTables
    Name ="tbl_kunden_solar"
    Name ="qry_TerminEnergieVKLeads2"
    Name ="qry_TerminEnergieVKLeadsbrutto2"
    Name ="qry_TerminEnergieVKLeadsLetzterStatus3"
    Name ="qry_TerminEnergieVKLeadsErgebnis3"
End
Begin OutputColumns
    Expression ="tbl_kunden_solar.mep_kd_nummer"
    Alias ="KDNR Kunden Solar"
    Expression ="tbl_kunden_solar.bcs_kd_nummer"
    Expression ="tbl_kunden_solar.kd_nachname"
    Expression ="tbl_kunden_solar.sys_erstellt_am"
    Expression ="qry_TerminEnergieVKLeads2.[VK Termine]"
    Alias ="Bruttokontakte"
    Expression ="qry_TerminEnergieVKLeadsbrutto2.[VK Termine]"
    Alias ="Letzter Status"
    Expression ="qry_TerminEnergieVKLeadsLetzterStatus3.Status"
    Expression ="qry_TerminEnergieVKLeadsLetzterStatus3.Terminierer"
    Alias ="Anruftag letzter Brutto"
    Expression ="qry_TerminEnergieVKLeadsLetzterStatus3.Anruftag"
    Alias ="Anruftag letzter Termin"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Anruftag"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.AD"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Termindatum"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Terminzeit"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Bestätigt"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Ergebnis"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.Abschluss_Energy"
    Expression ="qry_TerminEnergieVKLeadsErgebnis3.KWEnergie"
    Alias ="Zeit Anruf zu Termin"
    Expression ="DateDiff(\"d\",[Anruftag letzter Termin],[Termindatum])"
    Alias ="Zeit Lead zu Termin"
    Expression ="DateDiff(\"d\",[sys_erstellt_am],[Termindatum])"
    Alias ="Werber / Web, TV"
    Expression ="IIf([mep_kd_nummer] Like \"L*\",\"Web, TV\",\"Werber\")"
End
Begin Joins
    LeftTable ="tbl_kunden_solar"
    RightTable ="qry_TerminEnergieVKLeads2"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = qry_TerminEnergieVKLeads2.KD_NR"
    Flag =2
    LeftTable ="tbl_kunden_solar"
    RightTable ="qry_TerminEnergieVKLeadsbrutto2"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = qry_TerminEnergieVKLeadsbrutto2.KD_NR"
    Flag =2
    LeftTable ="tbl_kunden_solar"
    RightTable ="qry_TerminEnergieVKLeadsLetzterStatus3"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = qry_TerminEnergieVKLeadsLetzterStatus3.KD_NR"
    Flag =2
    LeftTable ="tbl_kunden_solar"
    RightTable ="qry_TerminEnergieVKLeadsErgebnis3"
    Expression ="tbl_kunden_solar.bcs_kd_nummer = qry_TerminEnergieVKLeadsErgebnis3.KD_NR"
    Flag =2
End
Begin OrderBy
    Expression ="qry_TerminEnergieVKLeads2.[VK Termine]"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbMemo "Filter" ="((EXLeadsTermineAlt.[Anruftag letzter Termin] Is Null))"
Begin
    Begin
        dbText "Name" ="tbl_kunden_solar.sys_erstellt_am"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_TerminEnergieVKLeadsLetzterStatus3.Terminierer"
        dbInteger "ColumnWidth" ="1575"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_TerminEnergieVKLeadsErgebnis3.Ergebnis"
        dbInteger "ColumnWidth" ="2385"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Zeit Anruf zu Termin"
        dbInteger "ColumnWidth" ="1920"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Zeit Lead zu Termin"
        dbInteger "ColumnWidth" ="1920"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Anruftag letzter Brutto"
        dbInteger "ColumnWidth" ="2085"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Anruftag letzter Termin"
        dbInteger "ColumnWidth" ="2145"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Letzter Status"
        dbInteger "ColumnWidth" ="2745"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_TerminEnergieVKLeadsErgebnis3.Abschluss_Energy"
        dbInteger "ColumnWidth" ="1815"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =1922
    Bottom =883
    Left =-1
    Top =-1
    Right =2393
    Bottom =144
    Left =0
    Top =4
    ColumnsShown =539
    Begin
        Left =493
        Top =5
        Right =643
        Bottom =119
        Top =0
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =1303
        Top =30
        Right =1399
        Bottom =114
        Top =0
        Name ="qry_TerminEnergieVKLeads2"
        Name =""
    End
    Begin
        Left =1454
        Top =15
        Right =1550
        Bottom =99
        Top =0
        Name ="qry_TerminEnergieVKLeadsbrutto2"
        Name =""
    End
    Begin
        Left =1662
        Top =5
        Right =1758
        Bottom =119
        Top =0
        Name ="qry_TerminEnergieVKLeadsLetzterStatus3"
        Name =""
    End
    Begin
        Left =1895
        Top =19
        Right =1991
        Bottom =103
        Top =3
        Name ="qry_TerminEnergieVKLeadsErgebnis3"
        Name =""
    End
End
