Operation =1
Option =0
Where ="(((tbl_statustabelle.Status)=\"Termin Energie Analyse\" Or (tbl_statustabelle.St"
    "atus)=\"Termin Energie VK\" Or (tbl_statustabelle.Status)=\"Termin Energie Nachh"
    "oler\") AND ((tbl_statustabelle.AD) Like [Formulare]![frmAnalyse]![AD]) AND ((tb"
    "l_statustabelle.Termindatum) Between [Formulare]![frmAnalyse]![Von] And [Formula"
    "re]![frmAnalyse]![Bis]) AND ((tbl_statustabelle.Ergebnis)=\"12 Abschluß\"))"
Begin InputTables
    Name ="tbl_statustabelle"
    Name ="tbl_kunden_solar"
    Name ="tbl_energievertrag"
    Name ="tbl_ergebnisadquali"
End
Begin OutputColumns
    Expression ="tbl_statustabelle.KD_NR"
    Expression ="tbl_statustabelle.Status_NR"
    Alias ="Lead_ID"
    Expression ="tbl_kunden_solar.mep_kd_nummer"
    Expression ="tbl_statustabelle.Status"
    Expression ="tbl_statustabelle.AD"
    Expression ="tbl_statustabelle.Termindatum"
    Expression ="tbl_statustabelle.Ergebnis"
    Alias ="Vorname"
    Expression ="tbl_kunden_solar.kd_vorname"
    Alias ="Name"
    Expression ="tbl_kunden_solar.kd_nachname"
    Alias ="Vertragsstatus MEP"
    Expression ="tbl_energievertrag.AktuellerStatus"
    Alias ="Vertragsstatus MEP Datum"
    Expression ="tbl_energievertrag.DatumaktuellerStatus"
    Alias ="First Call Status"
    Expression ="tbl_ergebnisadquali.Staus_qnt"
    Expression ="tbl_ergebnisadquali.Info_Widerruf"
    Expression ="tbl_ergebnisadquali.Widerruf_Grund"
    Alias ="SB First Call"
    Expression ="tbl_ergebnisadquali.SB"
    Alias ="Bemerkung First Call"
    Expression ="tbl_ergebnisadquali.Bemerkung"
    Expression ="tbl_energievertrag.Tarif"
    Alias ="Vertragsnummer MEP"
    Expression ="tbl_energievertrag.MEP_Vertragsnummer"
End
Begin Joins
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_kunden_solar"
    Expression ="tbl_statustabelle.KD_NR = tbl_kunden_solar.bcs_kd_nummer"
    Flag =2
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_energievertrag"
    Expression ="tbl_statustabelle.Status_NR = tbl_energievertrag.Status_NR"
    Flag =2
    LeftTable ="tbl_statustabelle"
    RightTable ="tbl_ergebnisadquali"
    Expression ="tbl_statustabelle.Status_NR = tbl_ergebnisadquali.Status_Nr"
    Flag =2
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.Status"
        dbInteger "ColumnWidth" ="2415"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Vertragsstatus MEP"
        dbInteger "ColumnWidth" ="2100"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Vertragsstatus MEP Datum"
        dbInteger "ColumnWidth" ="2580"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Vertragsnummer MEP"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="First Call Status"
        dbInteger "ColumnWidth" ="2265"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Termindatum"
        dbInteger "ColumnWidth" ="1305"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.Ergebnis"
        dbInteger "ColumnWidth" ="1290"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_statustabelle.AD"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Vorname"
        dbInteger "ColumnWidth" ="990"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Name"
        dbInteger "ColumnWidth" ="1155"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Bemerkung First Call"
        dbInteger "ColumnWidth" ="3705"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ergebnisadquali.Widerruf_Grund"
        dbInteger "ColumnWidth" ="1530"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =1720
    Bottom =1241
    Left =-1
    Top =-1
    Right =1713
    Bottom =144
    Left =0
    Top =8
    ColumnsShown =539
    Begin
        Left =38
        Top =-2
        Right =134
        Bottom =112
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =274
        Top =2
        Right =475
        Bottom =116
        Top =4
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =505
        Top =5
        Right =748
        Bottom =119
        Top =37
        Name ="tbl_energievertrag"
        Name =""
    End
    Begin
        Left =828
        Top =4
        Right =1048
        Bottom =118
        Top =20
        Name ="tbl_ergebnisadquali"
        Name =""
    End
End
