Operation =1
Option =0
Begin InputTables
    Name ="qry_HandySubRueckstellung2"
    Name ="qry_HandySubRueckstellung1"
End
Begin OutputColumns
    Expression ="qry_HandySubRueckstellung1.Status_NR"
    Expression ="qry_HandySubRueckstellung2.Art"
    Expression ="qry_HandySubRueckstellung2.Artdatum"
    Expression ="qry_HandySubRueckstellung2.Artikelbezeichnung"
    Expression ="qry_HandySubRueckstellung2.Anzahl"
    Expression ="qry_HandySubRueckstellung2.EkEinzelpreisNetto"
    Expression ="qry_HandySubRueckstellung2.Gesamtbetrag"
    Expression ="qry_HandySubRueckstellung2.Einzel_VK_Preis_brutto"
    Expression ="qry_HandySubRueckstellung2.Vertriebsweg"
    Alias ="Subvention"
    Expression ="Round(([Einzel_VK_Preis_brutto]/1.19)-[Gesamtbetrag],2)"
    Alias ="Subvention nach AD Beteiligung"
    Expression ="Round(IIf([Vertriebsweg]<>\"WKZ\",[Subvention]/2,[Subvention]),2)"
End
Begin Joins
    LeftTable ="qry_HandySubRueckstellung2"
    RightTable ="qry_HandySubRueckstellung1"
    Expression ="qry_HandySubRueckstellung2.Status_Nr = qry_HandySubRueckstellung1.Status_NR"
    Flag =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbMemo "Filter" ="((EXHandySubRueckstellung3_NEU.Art=\"Storno\"))"
Begin
    Begin
        dbText "Name" ="qry_HandySubRueckstellung2.Artikelbezeichnung"
        dbInteger "ColumnWidth" ="3990"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Subvention nach AD Beteiligung"
        dbText "Format" ="Standard"
        dbByte "DecimalPlaces" ="2"
        dbInteger "ColumnWidth" ="2955"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Subvention"
        dbText "Format" ="Standard"
        dbByte "DecimalPlaces" ="2"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =3442
    Bottom =1243
    Left =-1
    Top =-1
    Right =3441
    Bottom =144
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =638
        Top =-6
        Right =1294
        Bottom =108
        Top =5
        Name ="qry_HandySubRueckstellung2"
        Name =""
    End
    Begin
        Left =431
        Top =11
        Right =524
        Bottom =110
        Top =0
        Name ="qry_HandySubRueckstellung1"
        Name =""
    End
End
