C11/System/NAVISION/IQD/NW/nw_gw_vk_mit_stk.sql

select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code_2" as "Department Code_2",
	   "Make Code_2" as "Make Code_2",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart_alt" as "Fahrzeugart_alt",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "FZG_alt" as "FZG_alt",
	   "Location Code" as "Location Code",
	   "Code_Salesperson Purchase" as "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase" as "Name_Salesperson Purchase",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Option Type_Polster" as "Option Type_Polster",
	   "Polster" as "Polster",
	   "Option Type_Farbe" as "Option Type_Farbe",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Salesperson Code" as "Salesperson Code",
	   "Code_Verkäufer_Salesperson_Sales" as "Code_Verkäufer_Salesperson_Sales",
	   "Name_Salesperson_Sales" as "Name_Salesperson_Sales",
	   "Verkäufer_alt" as "Verkäufer_alt",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No_2" as "Old Customer No_2",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Summe EK-FZG" as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   "Menge2" as "Menge2",
	   "Menge3" as "Menge3",
	   "Menge4" as "Menge4",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   SUM("Menge4") OVER (partition by "Vin") as "Summe Menge4",
	   "Menge_2_test" as "Menge_2_test",
	   "Menge3_test" as "Menge3_test",
	   "Menge4_test" as "Menge4_test",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Standort" as "Standort",
	   "Gen Bus Posting Group" as "Gen Bus Posting Group",
	   "Summe_Erlös" as "Summe_Erlös",
	   "Menge1_final" as "Menge1_final",
	   "Menge2_final" as "Menge2_final",
	   "Menge_final" as "Menge_final",
	   "Customer Group Code" as "Customer Group Code",
	   "Kundengruppe" as "Kundengruppe",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Vehicle Category Code_Item" as "Vehicle Category Code_Item",
	   "Baureihe" as "Baureihe",
	   "FZG" as "FZG",
	   "User Id_aus_VB_ims" as "User Id_aus_VB_ims",
	   "Employee No_aus_VB_ims" as "Employee No_aus_VB_ims",
	   "Salesperson_aus_VB_ims" as "Salesperson_aus_VB_ims",
	   "No_aus_VB_ims" as "No_aus_VB_ims",
	   "First Name_aus_VB_ims" as "First Name_aus_VB_ims",
	   "Last Name_aus_VB_ims" as "Last Name_aus_VB_ims",
	   "Name_aus_VB_ims" as "Name_aus_VB_ims",
	   "Status_aus_VB_ims" as "Status_aus_VB_ims",
	   "Inactive Date_aus_VB_ims" as "Inactive Date_aus_VB_ims",
	   "Termination Date_aus_VB_ims" as "Termination Date_aus_VB_ims",
	   "Verkäufer gruppiert" as "Verkäufer gruppiert",
	   "Verkäufer Gruppe" as "Verkäufer Gruppe",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Hauptbetrieb_ID" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name" as "Hauptbetrieb_Name",
	   "Standort_ID" as "Standort_ID",
	   "Standort_Name" as "Standort_Name"
from 
(select "No" as "No",
	   "Name" as "Name",
	   "Account Type" as "Account Type",
	   "Department Code_2" as "Department Code_2",
	   "Make Code_2" as "Make Code_2",
	   "Income Balance" as "Income Balance",
	   "Entry No" as "Entry No",
	   "G L Account No" as "G L Account No",
	   "Posting Date" as "Posting Date",
	   "Document Type" as "Document Type",
	   "Document No" as "Document No",
	   "Description" as "Description",
	   "Amount" as "Amount",
	   "Bal Account No" as "Bal Account No",
	   "Department Code" as "Department Code",
	   "Make Code" as "Make Code",
	   "User Id" as "User Id",
	   "Source Code" as "Source Code",
	   "Quantity" as "Quantity",
	   "Debit Amount" as "Debit Amount",
	   "Credit Amount" as "Credit Amount",
	   "Document Date" as "Document Date",
	   "Source Type" as "Source Type",
	   "Source No" as "Source No",
	   "No Series" as "No Series",
	   "Branch Code" as "Branch Code",
	   "Main Area" as "Main Area",
	   "Vin" as "Vin",
	   "Book No" as "Book No",
	   "Veh Source Code" as "Veh Source Code",
	   "Betrag" as "Betrag",
	   "Vin_Vehicle" as "Vin_Vehicle",
	   "Vehicle Status" as "Vehicle Status",
	   "Model_ori" as "Model_ori",
	   "Type" as "Type",
	   "Class" as "Class",
	   "Model No" as "Model No",
	   "Hauptbetrieb" as "Hauptbetrieb",
	   "Standort_alt" as "Standort_alt",
	   "Make Code_Vehicle" as "Make Code_Vehicle",
	   "Fabrikat_ori" as "Fabrikat_ori",
	   "Model" as "Model",
	   "Market Segment Code" as "Market Segment Code",
	   "Modellbez" as "Modellbez",
	   "Fahrzeugart_alt" as "Fahrzeugart_alt",
	   "Vat Prod Posting Group" as "Vat Prod Posting Group",
	   "Fahrzeugtyp" as "Fahrzeugtyp",
	   "FZG_alt" as "FZG_alt",
	   "Location Code" as "Location Code",
	   "Code_Salesperson Purchase" as "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase" as "Name_Salesperson Purchase",
	   "VB_Einkauf" as "VB_Einkauf",
	   "Purchase Receipt Date" as "Purchase Receipt Date",
	   "Standtage_ori" as "Standtage_ori",
	   "Standtagestaffel" as "Standtagestaffel",
	   "Initial Registration" as "Initial Registration",
	   "EZ/Eingang" as "EZ/Eingang",
	   "Option Type_Polster" as "Option Type_Polster",
	   "Polster" as "Polster",
	   "Option Type_Farbe" as "Option Type_Farbe",
	   "Farbe" as "Farbe",
	   "Einsatz_ori" as "Einsatz_ori",
	   "Heute" as "Heute",
	   "Fahrzeugstatus" as "Fahrzeugstatus",
	   "FZG-Liste" as "FZG-Liste",
	   "Anzahl" as "Anzahl",
	   "Standtage" as "Standtage",
	   "Salesperson Code" as "Salesperson Code",
	   "Code_Verkäufer_Salesperson_Sales" as "Code_Verkäufer_Salesperson_Sales",
	   "Name_Salesperson_Sales" as "Name_Salesperson_Sales",
	   "Verkäufer_alt" as "Verkäufer_alt",
	   "Inventory Posting Group" as "Inventory Posting Group",
	   "Date Of Sale" as "Date Of Sale",
	   "Invoice Date" as "Invoice Date",
	   "Customer No" as "Customer No",
	   "No_Customer" as "No_Customer",
	   "Name_Customer" as "Name_Customer",
	   "Kunde" as "Kunde",
	   "Customer Type" as "Customer Type",
	   "Kundenart" as "Kundenart",
	   "Old Customer No_2" as "Old Customer No_2",
	   "Old Customer No" as "Old Customer No",
	   "No_Vorbesitzer" as "No_Vorbesitzer",
	   "Name_Vorbesitzer" as "Name_Vorbesitzer",
	   "Vorbesitzer" as "Vorbesitzer",
	   "Engine Code" as "Engine Code",
	   "Motor Code" as "Motor Code",
	   "Geschäftsart" as "Geschäftsart",
	   "FZG_Liste_1_ori" as "FZG_Liste_1_ori",
	   "FZG_Liste_2" as "FZG_Liste_2",
	   "FZG_Liste_3" as "FZG_Liste_3",
	   "FZG_Liste_4" as "FZG_Liste_4",
	   "Erlös" as "Erlös",
	   "Einsatz" as "Einsatz",
	   "EK Fahrzeug" as "EK Fahrzeug",
	   "Bonus" as "Bonus",
	   "int. Kosten" as "int. Kosten",
	   "Current Branch Book No" as "Current Branch Book No",
	   "Current Book No" as "Current Book No",
	   "Summe EK-FZG" as "Summe EK-FZG",
	   "Fabrikat" as "Fabrikat",
	   "Buchnummer gleich_ja_nein" as "Buchnummer gleich_ja_nein",
	   "Menge1" as "Menge1",
	   COUNT("Vin") OVER (partition by "VIN + PostingDate") as "Menge2",
	   ("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) as "Menge3",
	   CASE WHEN ("Document No" LIKE 'VGGF%') THEN (("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) * -1) ELSE ("Menge1" / COUNT("Vin") OVER (partition by "VIN + PostingDate")) END as "Menge4",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   COUNT("Vin") OVER (partition by c296) as "Menge_2_test",
	   ("Menge1" / COUNT("Vin") OVER (partition by c296)) as "Menge3_test",
	   CASE WHEN ("Document No" LIKE 'VGGF%') THEN (("Menge1" / COUNT("Vin") OVER (partition by c296)) * -1) ELSE ("Menge1" / COUNT("Vin") OVER (partition by c296)) END as "Menge4_test",
	   "Fahrzeugart_Schmidt" as "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE" as "Salespers Purch Code_VLE",
	   "Code_für_VEH_Ledger_Entry" as "Code_für_VEH_Ledger_Entry",
	   "Name_für_VEH_Ledger_Entry" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer" as "Verkäufer",
	   "FZG_Liste_1_falsch" as "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori" as "FZG_Liste_0_ori",
	   "FZG_Liste_1" as "FZG_Liste_1",
	   "FZG_Liste_0" as "FZG_Liste_0",
	   "Beleg" as "Beleg",
	   "Standort_FIBU" as "Standort_FIBU",
	   "Fahrzeugart" as "Fahrzeugart",
	   "Standort" as "Standort",
	   "Gen Bus Posting Group" as "Gen Bus Posting Group",
	   SUM("Erlös") OVER (partition by c297) as "Summe_Erlös",
	   CASE WHEN (SUM("Erlös") OVER (partition by c297) <= 0) THEN (0) ELSE "Menge1" END as "Menge1_final",
	   COUNT("Vin") OVER (partition by "Current Book No") as "Menge2_final",
	   (CASE WHEN (SUM("Erlös") OVER (partition by c297) <= 0) THEN (0) ELSE "Menge1" END / COUNT("Vin") OVER (partition by "Current Book No")) as "Menge_final",
	   "Customer Group Code" as "Customer Group Code",
	   "Kundengruppe" as "Kundengruppe",
	   "No_Item" as "No_Item",
	   "Description_Item" as "Description_Item",
	   "Vehicle Type Code_Item" as "Vehicle Type Code_Item",
	   "Vehicle Category Code_Item" as "Vehicle Category Code_Item",
	   "Baureihe" as "Baureihe",
	   "FZG" as "FZG",
	   "User Id_aus_VB_ims" as "User Id_aus_VB_ims",
	   "Employee No_aus_VB_ims" as "Employee No_aus_VB_ims",
	   "Salesperson_aus_VB_ims" as "Salesperson_aus_VB_ims",
	   "No_aus_VB_ims" as "No_aus_VB_ims",
	   "First Name_aus_VB_ims" as "First Name_aus_VB_ims",
	   "Last Name_aus_VB_ims" as "Last Name_aus_VB_ims",
	   "Name_aus_VB_ims" as "Name_aus_VB_ims",
	   "Status_aus_VB_ims" as "Status_aus_VB_ims",
	   "Inactive Date_aus_VB_ims" as "Inactive Date_aus_VB_ims",
	   "Termination Date_aus_VB_ims" as "Termination Date_aus_VB_ims",
	   "Verkäufer gruppiert" as "Verkäufer gruppiert",
	   "Verkäufer Gruppe" as "Verkäufer Gruppe",
	   "Vehicle Category Code" as "Vehicle Category Code",
	   "Hauptbetrieb_ID" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name" as "Hauptbetrieb_Name",
	   "Standort_ID" as "Standort_ID",
	   "Standort_Name" as "Standort_Name"
from 
(select "No",
	   "Name",
	   "Account Type",
	   "Department Code_2",
	   "Make Code_2",
	   "Income Balance",
	   "Entry No",
	   "G L Account No",
	   "Posting Date",
	   "Document Type",
	   "Document No",
	   "Description",
	   "Amount",
	   "Bal Account No",
	   "Department Code",
	   "Make Code",
	   "User Id",
	   "Source Code",
	   "Quantity",
	   "Debit Amount",
	   "Credit Amount",
	   "Document Date",
	   "Source Type",
	   "Source No",
	   "No Series",
	   "Branch Code",
	   "Main Area",
	   "Vin",
	   "Book No",
	   "Veh Source Code",
	   "Betrag",
	   "Vin_Vehicle",
	   "Vehicle Status",
	   "Model_ori",
	   "Type",
	   "Class",
	   "Model No",
	   "Hauptbetrieb",
	   "Standort_alt",
	   "Make Code_Vehicle",
	   "Make Code_Vehicle" as "Fabrikat_ori",
	   "Model",
	   "Model" as "Market Segment Code",
	   "Model_ori" as "Modellbez",
	   "Fahrzeugart_alt",
	   "Vat Prod Posting Group",
	   "Fahrzeugtyp",
	   "FZG_alt",
	   "Location Code",
	   "Code_Salesperson Purchase",
	   "Name_Salesperson Purchase",
	   "VB_Einkauf",
	   "Purchase Receipt Date",
	   "Standtage_ori",
	   "Standtagestaffel",
	   "Initial Registration",
	   "EZ/Eingang",
	   "Option Type_Polster",
	   "Polster",
	   "Option Type_Farbe",
	   "Farbe",
	   "Betrag" as "Einsatz_ori",
	   (getdate()) as "Heute",
	   'Bestand' as "Fahrzeugstatus",
	   "FZG-Liste",
	   COUNT("Standtage_ori") OVER (partition by "Vin") as "Anzahl",
	   ("Standtage_ori") / (COUNT("Standtage_ori") OVER (partition by "Vin")) as "Standtage",
	   "Salesperson Code",
	   "Code_Verkäufer_Salesperson_Sales",
	   "Name_Salesperson_Sales",
	   "Verkäufer_alt",
	   "Inventory Posting Group",
	   "Date Of Sale",
	   "Invoice Date",
	   "Customer No",
	   "No_Customer",
	   "Name_Customer",
	   "Kunde",
	   "Customer Type",
	   "Kundenart",
	   "Old Customer No_2",
	   "Old Customer No_2" as "Old Customer No",
	   "No_Vorbesitzer",
	   "Name_Vorbesitzer",
	   "Name_Vorbesitzer" as "Vorbesitzer",
	   "Engine Code",
	   "Engine Code" as "Motor Code",
	   '' as "Geschäftsart",
	   "FZG_Liste_1_ori",
	   "FZG_Liste_2",
	   "Model_ori" as "FZG_Liste_3",
	   "FZG_Liste_4",
	   "Erlös",
	   "Einsatz",
	   "EK Fahrzeug",
	   "Bonus",
	   "int. Kosten",
	   "Current Branch Book No",
	   "Current Book No",
	   SUM("EK Fahrzeug") OVER (partition by "Vin") as "Summe EK-FZG",
	   "Fabrikat",
	   "Buchnummer gleich_ja_nein",
	   1 as "Menge1",
	   "VIN + PostingDate" as "VIN + PostingDate",
	   "Fahrzeugart_Schmidt",
	   "Salespers Purch Code_VLE",
	   "Code_Verkäufer_Salesperson_Sales" as "Code_für_VEH_Ledger_Entry",
	   "Name_Salesperson_Sales" as "Name_für_VEH_Ledger_Entry",
	   "Verkäufer",
	   "FZG_Liste_1_falsch",
	   "FZG_Liste_0_ori",
	   "FZG_Liste_1",
	   "FZG_Liste_0",
	   "Beleg",
	   "Standort_FIBU",
	   "Fahrzeugart",
	   "Standort",
	   "Kundenart" as "Gen Bus Posting Group",
	   "Customer Group Code",
	   "Kundengruppe",
	   "No_Item",
	   "Description_Item",
	   "Vehicle Type Code_Item",
	   "Vehicle Category Code_Item",
	   "Baureihe",
	   "FZG",
	   "User Id_aus_VB_ims",
	   "Employee No_aus_VB_ims",
	   "Salesperson_aus_VB_ims",
	   "No_aus_VB_ims",
	   "First Name_aus_VB_ims",
	   "Last Name_aus_VB_ims",
	   "Name_aus_VB_ims",
	   "Status_aus_VB_ims",
	   "Inactive Date_aus_VB_ims",
	   "Termination Date_aus_VB_ims",
	   "Verkäufer gruppiert",
	   "Verkäufer Gruppe",
	   "Vehicle Category Code",
	   "Hauptbetrieb" as "Hauptbetrieb_ID",
	   "Hauptbetrieb_Name",
	   "Standort" as "Standort_ID",
	   "Standort_Name",
	   c173 as c296,
	   c172 as c297
from 
(select T3."Current Book No_" as "Current Book No",
	   (((T2."VIN"))) as c172,
	   (((T2."VIN")) + T2."Document No_") as c173,
	   (((T2."VIN")) + (convert(varchar(50), year(T2."Posting Date")) + '-' + convert(varchar(50), month(T2."Posting Date")) + '-' + convert(varchar(50), day(T2."Posting Date")))) as "VIN + PostingDate",
	   CASE WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('10')) THEN ('MM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('30')) THEN ('KRU') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('40')) THEN ('ULM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('50')) THEN ('LL') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('55')) THEN ('GZ') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('60')) THEN ('AAM') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('70')) THEN ('LEH') WHEN (((CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END)) IN ('80')) THEN ('WTB') ELSE null END as "Standort_Name",
	   (CASE WHEN (T3."Location Code" = 'MM') THEN ('10') WHEN (T3."Location Code" = 'KRU') THEN ('30') WHEN (T3."Location Code" = 'ULM') THEN ('40') WHEN (T3."Location Code" = 'LL') THEN ('50') WHEN (T3."Location Code" = 'GZ') THEN ('55') WHEN (T3."Location Code" = 'AAM') THEN ('60') WHEN (T3."Location Code" = 'LEH') THEN ('70') ELSE ('Standort fehlt') END) as "Standort",
	   CASE WHEN (T1."Client_DB" = '1') THEN ('AHR') WHEN (T1."Client_DB" = '2') THEN ('AAM') ELSE null END as "Hauptbetrieb_Name",
	   T1."Client_DB" as "Hauptbetrieb",
	   T3."Vehicle Category Code" as "Vehicle Category Code",
	   CASE WHEN ((CASE WHEN (T12."User ID" IS NULL) THEN ('Sonstige') ELSE ((CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T10."Salespers__Purch_ Code") END)) END) = 'Sonstige') THEN ('Sonstige Verkäufer') ELSE ('aktive Verkäufer') END as "Verkäufer Gruppe",
	   CASE WHEN (T12."User ID" IS NULL) THEN ('Sonstige') ELSE ((CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T10."Salespers__Purch_ Code") END)) END as "Verkäufer gruppiert",
	   T12."Termination Date" as "Termination Date_aus_VB_ims",
	   T12."Inactive Date" as "Inactive Date_aus_VB_ims",
	   T12."Status" as "Status_aus_VB_ims",
	   T12."Name" as "Name_aus_VB_ims",
	   T12."Last Name" as "Last Name_aus_VB_ims",
	   T12."First Name" as "First Name_aus_VB_ims",
	   T12."No_" as "No_aus_VB_ims",
	   T12."Salesperson" as "Salesperson_aus_VB_ims",
	   T12."Employee No_" as "Employee No_aus_VB_ims",
	   T12."User ID" as "User Id_aus_VB_ims",
	   CASE WHEN ((-1 * datediff(day, (getdate()), (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) <= 700) THEN ((CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') THEN ((right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + T3."Location Code") ELSE ((right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + T3."Location Code") END)) ELSE ('FZG-Verkäufe älter 1 Jahr') END as "FZG",
	   CASE WHEN (T3."Vehicle Category Code" <> ' ') THEN (T3."Vehicle Category Code") ELSE (T11."Vehicle Category Code") END as "Baureihe",
	   T11."Vehicle Category Code" as "Vehicle Category Code_Item",
	   T11."Vehicle Type Code" as "Vehicle Type Code_Item",
	   T11."Description" as "Description_Item",
	   T11."No_" as "No_Item",
	   CASE WHEN (T8."Customer Group Code" IN ('HDL-BMW','HDL-KFZ')) THEN ('WVK') ELSE ('Endkunden') END as "Kundengruppe",
	   T8."Customer Group Code" as "Customer Group Code",
	   T8."Gen_ Bus_ Posting Group" as "Kundenart",
	   CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) IS NULL) THEN ((CASE WHEN ((substring(T1."Department Code", 3, 2)) = '10') THEN ('NA') WHEN ((substring(T1."Department Code", 3, 2)) = '20') THEN ('GA') WHEN ((substring(T1."Department Code", 3, 2)) = '80') THEN ('NA') WHEN ((substring(T1."Department Code", 3, 2)) = '90') THEN ('NA') ELSE null END)) ELSE ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END)) END as "Fahrzeugart",
	   (left(T1."Department Code",2)) as "Standort_FIBU",
	   T2."Document No_" + ' - ' + T2."Description" + ' - ' + T2."User ID" as "Beleg",
	   CASE WHEN (((CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END) = 'Buchungen m. FZG') and (T3."VIN" IS NULL)) THEN ('sonst. Buchungen m. FZG') ELSE ((CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END)) END as "FZG_Liste_0",
	   CASE WHEN ((CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END) = 'Buchungen o. FZG') THEN (T2."Document No_" + ' - ' + T2."Description") ELSE ((CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((right(((T2."VIN")))) + ' - ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) END)) END as "FZG_Liste_1",
	   CASE WHEN (((T2."VIN")) = ' ') THEN ('Buchungen o. FZG') ELSE ('Buchungen m. FZG') END as "FZG_Liste_0_ori",
	   CASE WHEN (T1."No_" IN ('78700','78710','79000','79030','79100','79130','88210','88220','88230','88240','88290','88310','88320','88400','88410','88420','88430','88560','88570','88700','88710','88720','88730','88740','88750','88760','88770','88780','88790')) THEN ('Buchungen aus Sonstige Erlöse') ELSE ((CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((right(((T2."VIN")))) + ' - ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) END)) END as "FZG_Liste_1_falsch",
	   CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T10."Salespers__Purch_ Code") END as "Verkäufer",
	   T7."Name" as "Name_Salesperson_Sales",
	   T7."Code" as "Code_Verkäufer_Salesperson_Sales",
	   T10."Salespers__Purch_ Code" as "Salespers Purch Code_VLE",
	   CASE WHEN ((substring(T1."Department Code", 3, 2)) = '10') THEN ('NA') WHEN ((substring(T1."Department Code", 3, 2)) = '20') THEN ('GA') WHEN ((substring(T1."Department Code", 3, 2)) = '80') THEN ('NA') WHEN ((substring(T1."Department Code", 3, 2)) = '90') THEN ('NA') ELSE null END as "Fahrzeugart_Schmidt",
	   T2."Document No_" as "Document No",
	   CASE WHEN ((T2."Book No_" = T3."Current Book No_") and ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA')) THEN ('ja') WHEN ((T2."Book No_" <> T3."Current Book No_") and ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA')) THEN ('nein') ELSE null END as "Buchnummer gleich_ja_nein",
	   CASE WHEN (T3."Make Code" IN ('BMW','BMW-MINI','BMW-MOT','BMWI')) THEN (T3."Make Code") ELSE ('Fremdfabrikat') END as "Fabrikat",
	   T3."Current Branch Book No_" as "Current Branch Book No",
	   CASE WHEN (T1."No_" LIKE '4%') THEN (((convert(float, T2."Amount")))) ELSE (0) END as "int. Kosten",
	   CASE WHEN ((T1."No_" BETWEEN '71400' AND '71690') or (T1."No_" IN ('72930'))) THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END as "Bonus",
	   CASE WHEN (((T1."No_" BETWEEN '71000' AND '71390') or (T1."No_" BETWEEN '71700' AND '72995')) or (T1."No_" IN ('78200','78700','78710','79000','79030','79100','79130'))) THEN (((convert(float, T2."Amount")))) ELSE (0) END as "EK Fahrzeug",
	   (CASE WHEN (((T1."No_" BETWEEN '71000' AND '71390') or (T1."No_" BETWEEN '71700' AND '72995')) or (T1."No_" IN ('78200','78700','78710','79000','79030','79100','79130'))) THEN (((convert(float, T2."Amount")))) ELSE (0) END) - (CASE WHEN ((T1."No_" BETWEEN '71400' AND '71690') or (T1."No_" IN ('72930'))) THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END) as "Einsatz",
	   CASE WHEN ((T1."No_" LIKE '8%') and ((right(T1."Department Code",2)) IN ('10','20','80',''))) THEN (((convert(float, T2."Amount"))) * -1) ELSE (0) END as "Erlös",
	   CASE WHEN ((CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T10."Salespers__Purch_ Code") END) IS NULL) THEN (' - ' + ' / ' + (T8."No_" + ' - ' + T8."Name")) ELSE ((CASE WHEN (T7."Code" IS NOT NULL) THEN (T7."Code" + ' - ' + T7."Name") ELSE (T10."Salespers__Purch_ Code") END) + ' / ' + (T8."No_" + ' - ' + T8."Name")) END as "FZG_Liste_4",
	   T3."Model" as "Model_ori",
	   CASE WHEN ((T4."Code" + ' - ' + T4."Name") IS NULL) THEN (' - ' + ' / ' + T9."Name") ELSE ((T4."Code" + ' - ' + T4."Name") + ' / ' + T9."Name") END as "FZG_Liste_2",
	   CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) IS NOT NULL) THEN ((right(((T2."VIN")),7)) + ' - ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) ELSE ((right(((T2."VIN")))) + ' - ' + (convert(varchar(50), year((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), month((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))) + '-' + convert(varchar(50), day((CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END))))) END as "FZG_Liste_1_ori",
	   T3."Engine Code" as "Engine Code",
	   T9."Name" as "Name_Vorbesitzer",
	   T9."No_" as "No_Vorbesitzer",
	   T3."Old Customer No_" as "Old Customer No_2",
	   T8."Customer Type" as "Customer Type",
	   T8."No_" + ' - ' + T8."Name" as "Kunde",
	   T8."Name" as "Name_Customer",
	   T8."No_" as "No_Customer",
	   T3."Customer No_" as "Customer No",
	   CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END as "Invoice Date",
	   T3."Date of Sale" as "Date Of Sale",
	   T3."Inventory Posting Group" as "Inventory Posting Group",
	   T7."Code" + ' - ' + T7."Name" as "Verkäufer_alt",
	   T3."Salesperson Code" as "Salesperson Code",
	   (-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date")) as "Standtage_ori",
	   (right(((T2."VIN")),7)) as "FZG-Liste",
	   ((convert(float, T2."Amount"))) as "Betrag",
	   T6."Description" as "Farbe",
	   T6."Option Type" as "Option Type_Farbe",
	   T5."Description" as "Polster",
	   T5."Option Type" as "Option Type_Polster",
	   CASE WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') THEN ((convert(varchar(50), year(T3."Initial Registration")) + '-' + convert(varchar(50), month(T3."Initial Registration")) + '-' + convert(varchar(50), day(T3."Initial Registration")))) WHEN ((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group")) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') THEN ((convert(varchar(50), year(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), month(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), day(T3."Purchase Receipt Date")))) WHEN ((CASE WHEN ((left(T3."Inventory Posting Group")) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') THEN ((convert(varchar(50), year(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), month(T3."Purchase Receipt Date")) + '-' + convert(varchar(50), day(T3."Purchase Receipt Date")))) ELSE null END as "EZ/Eingang",
	   T3."Initial Registration" as "Initial Registration",
	   CASE WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 91 AND 180)) THEN ('91 - 180 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'NA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 0 AND 90)) THEN ('0 - 90 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 91 AND 150)) THEN ('91 - 150 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 151 AND 210)) THEN ('151 - 210 Tage') WHEN (((CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) = 'VFW') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) > 210)) THEN ('> 210 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 0 AND 30)) THEN ('0 - 30 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 31 AND 60)) THEN ('31 - 60 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 61 AND 90)) THEN ('61 - 90 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) BETWEEN 91 AND 180)) THEN ('91 - 180 Tage') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (((-1 * datediff(day, (CASE WHEN (T3."Date of Sale" IS NULL) THEN (T2."Posting Date") ELSE (T3."Date of Sale") END), T3."Purchase Receipt Date"))) > 180)) THEN ('> 180 Tage') ELSE null END as "Standtagestaffel",
	   T3."Purchase Receipt Date" as "Purchase Receipt Date",
	   T4."Code" + ' - ' + T4."Name" as "VB_Einkauf",
	   T4."Name" as "Name_Salesperson Purchase",
	   T4."Code" as "Code_Salesperson Purchase",
	   T3."Location Code" as "Location Code",
	   CASE WHEN ((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') THEN ((right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + (CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END) + ' / ' + T3."Location Code") ELSE ((right(((T2."VIN")),7)) + ' / ' + T3."Model" + ' / ' + T3."Location Code") END as "FZG_alt",
	   CASE WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - diff.best.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'GA') and (not T3."VAT Prod_ Posting Group" LIKE 'DIFF%')) THEN ('GA - regelbest.') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'NW')) THEN ('NA') WHEN (((CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END) = 'NA') and ((left(T3."Inventory Posting Group",2)) = 'VF')) THEN ('VFW') ELSE null END as "Fahrzeugtyp",
	   T3."VAT Prod_ Posting Group" as "Vat Prod Posting Group",
	   CASE WHEN ((left(T3."Inventory Posting Group",2)) IN ('NW','VF')) THEN ('NA') WHEN ((left(T3."Inventory Posting Group",2)) = 'GW') THEN ('GA') ELSE null END as "Fahrzeugart_alt",
	   T3."Market Segment Code" as "Model",
	   T3."Make Code" as "Make Code_Vehicle",
	   CASE WHEN ((T2."Branch Code" = 'FIL1') or (T2."Branch Code" = '')) THEN ('10') WHEN (T2."Branch Code" = 'FIL2') THEN ('20') ELSE ((left(T1."Department Code",2))) END as "Standort_alt",
	   T3."Model No_" as "Model No",
	   T3."Class" as "Class",
	   T3."Type" as "Type",
	   T3."Vehicle Status" as "Vehicle Status",
	   T3."VIN" as "Vin_Vehicle",
	   T2."Veh_ Source Code" as "Veh Source Code",
	   T2."Book No_" as "Book No",
	   (T2."VIN") as "Vin",
	   T2."Main Area" as "Main Area",
	   T2."Branch Code" as "Branch Code",
	   T2."No_ Series" as "No Series",
	   T2."Source No_" as "Source No",
	   T2."Source Type" as "Source Type",
	   T2."Document Date" as "Document Date",
	   T2."Credit Amount" as "Credit Amount",
	   T2."Debit Amount" as "Debit Amount",
	   T2."Quantity" as "Quantity",
	   T2."Source Code" as "Source Code",
	   T2."User ID" as "User Id",
	   T2."Make Code" as "Make Code",
	   T2."Department Code" as "Department Code",
	   T2."Bal_ Account No_" as "Bal Account No",
	   T2."Amount" as "Amount",
	   T2."Description" as "Description",
	   T2."Document Type" as "Document Type",
	   T2."Posting Date" as "Posting Date",
	   T2."G_L Account No_" as "G L Account No",
	   T2."Entry No_" as "Entry No",
	   T1."Income_Balance" as "Income Balance",
	   T1."Make Code" as "Make Code_2",
	   T1."Department Code" as "Department Code_2",
	   T1."Account Type" as "Account Type",
	   T1."Name" as "Name",
	   T1."No_" as "No"
from "NAVISION"."import"."G_L_Account" T1,
	"NAVISION"."import"."G_L_Entry" T2,
	"NAVISION"."import"."Customer" T8,
	(((((((("NAVISION"."import"."Vehicle" T3 left outer join "NAVISION"."import"."Salesperson_Purchaser" T4 on (T3."Purchaser Code" = T4."Code") and (T3."Client_DB" = T4."Client_DB")) left outer join "NAVISION"."import"."Vehicle_Option" T5 on (((T3."VIN" = T5."VIN") and (T5."Option Type" = 2)) and (T5."Built-in Date" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Client_DB" = T5."Client_DB")) left outer join "NAVISION"."import"."Vehicle_Option" T6 on (((T3."VIN" = T6."VIN") and (T6."Option Type" = 1)) and (T6."Built-in Date" <> convert(datetime, '1753-01-01 00:00:00.000'))) and (T3."Client_DB" = T6."Client_DB")) left outer join "NAVISION"."import"."Vehicle_Ledger_Entry" T10 on (((T10."VIN" = T3."VIN") and (T10."Current Sales Ledger Entry" = 1)) and (T10."Book No_" = T3."Current Book No_")) and (T10."Client_DB" = T3."Client_DB")) left outer join "NAVISION"."import"."Salesperson_Purchaser" T7 on (T10."Salespers__Purch_ Code" = T7."Code") and (T10."Client_DB" = T7."Client_DB")) left outer join "NAVISION"."import"."Customer" T9 on (T3."Old Customer No_" = T9."No_") and (T3."Client_DB" = T9."Client_DB")) left outer join "NAVISION"."import"."Item" T11 on (T11."No_" = T3."Model No_") and (T11."Client_DB" = T3."Client_DB")) left outer join "ims"."Verkaeufer_aktiv" T12 on T10."Salespers__Purch_ Code" = T12."Salesperson")
where ((T1."No_" = T2."G_L Account No_") and (T1."Client_DB" = T2."Client_DB")) and ((T3."VIN" = T2."VIN") and (T3."Client_DB" = T2."Client_DB")) and ((T3."Customer No_" = T8."No_") and (T3."Client_DB" = T8."Client_DB"))
and (((((((((T1."No_" IN ('88200','78200','78700','78710','79000','79030','79100','79130','88210','88220','88230','88240','88290','88310','88320','88400','88410','88420','88430','88560','88570','88700','88710','88720','88730','88740','88750','88760','88770','88780','88790','89000','89030','88270','88280')) or (T1."No_" BETWEEN '71000' AND '72990')) or (T1."No_" BETWEEN '81000' AND '82990')) or (((T1."No_" LIKE '4%') and (T2."Book No_" <> ' ')) and (T2."Posting Date" >= T3."Purchase Receipt Date"))) and (not T2."Description" IN ('GuV-Konten Nullstellung','GuV Konten Nullstellung'))) and (T2."Posting Date" >= convert(datetime, '2021-01-01 00:00:00.000'))) and (((T2."VIN")) <> ' ')) and (T3."Inventory Posting Group" <> 'GROSSKD')) and (T3."Current Book No_" = T2."Book No_"))
) D2
) D8
) D1
-- order by "Summe EK-FZG" asc,"Vin" asc,"Posting Date" asc,"Document No" asc