Operation =1
Option =0
Where ="(((tbl_mepleadeingang.Kampagne)=\"bc5\") AND ((tbl_energievertrag.Provisioniert)"
    "=\"Ja\") AND ((tbl_energievertrag.ProvisioniertDatum)>[Formulare]![frmAnalyse]!["
    "Von]))"
Begin InputTables
    Name ="tbl_energievertrag"
    Name ="tbl_statustabelle"
    Name ="tbl_kunden_solar"
    Name ="tbl_mepleadeingang"
End
Begin OutputColumns
    Expression ="tbl_statustabelle.KD_NR"
    Expression ="tbl_statustabelle.Status_NR"
    Expression ="tbl_energievertrag.Tarif"
    Expression ="tbl_mepleadeingang.Kampagne"
    Expression ="tbl_energievertrag.Provisioniert"
    Expression ="tbl_energievertrag.ProvisioniertDatum"
    Alias ="Prov bekommen"
    Expression ="tbl_energievertrag.ProvisionZiel"
    Expression ="tbl_kunden_solar.kd_anrede"
    Expression ="tbl_kunden_solar.kd_vorname"
    Expression ="tbl_kunden_solar.kd_nachname"
    Expression ="tbl_energievertrag.MEP_Vertragsnummer"
    Alias ="Prov fehlt"
    Expression ="[Prov bekommen]/200*100"
End
Begin Joins
    LeftTable ="tbl_energievertrag"
    RightTable ="tbl_statustabelle"
    Expression ="tbl_energievertrag.Status_NR = tbl_statustabelle.Status_NR"
    Flag =1
    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" ="Prov bekommen"
        dbInteger "ColumnWidth" ="1575"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =1720
    Bottom =1241
    Left =-1
    Top =-1
    Right =1717
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =38
        Top =6
        Right =567
        Bottom =120
        Top =39
        Name ="tbl_energievertrag"
        Name =""
    End
    Begin
        Left =710
        Top =-1
        Right =806
        Bottom =113
        Top =0
        Name ="tbl_statustabelle"
        Name =""
    End
    Begin
        Left =888
        Top =4
        Right =984
        Bottom =118
        Top =6
        Name ="tbl_kunden_solar"
        Name =""
    End
    Begin
        Left =1206
        Top =9
        Right =1302
        Bottom =123
        Top =17
        Name ="tbl_mepleadeingang"
        Name =""
    End
End
