| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- -- auto-generated definition
- CREATE view load.Aftersales_Rechnungen_neu AS
- select convert(varchar(10), Hauptbetrieb_ID) as Hauptbetrieb_ID,
- convert(varchar(50), Hauptbetrieb_Name) as Hauptbetrieb_Name,
- convert(varchar(10), Standort_ID) as Standort_ID,
- convert(varchar(50), Standort_Name) as Standort_Name,
- convert(varchar(20), Employee_Function) as Employee_Function,
- convert(varchar(150), Serviceberater) as Serviceberater,
- convert(varchar(500), Order_Number) as [Order Number],
- convert(varchar(500), Invoice_Desc_100) as Invoice_Desc_100,
- convert(varchar(100), Fabrikat) as Fabrikat,
- convert(varchar(50), Model) as Model,
- convert(varchar(100), Fahrzeug) as Fahrzeug,
- convert(varchar(56), Kostenstelle) as Kostenstelle,
- convert(varchar(50), Marke) as Marke,
- convert(varchar(20), Umsatzart) as Umsatzart,
- convert(varchar(20), Auftragsart) as Auftragsart,
- convert(varchar(20), Auftragsposition) as Auftragsposition,
- convert(varchar(20), Kundenart) as Kundenart,
- convert(varchar(250), Kunde) as Kunde,
- convert(varchar(500), Order_Desc_30) as Order_Desc_30,
- convert(varchar(500), Invoice_Desc_30) as Invoice_Desc_30,
- convert(varchar(50), c22) as Zuordnung_Produktbuchungsgruppe,
- convert(varchar(100), Produktbuchungsgruppe) as Produktbuchungsgruppe,
- convert(varchar(20), FZG_Altersstaffel) as [FZG-Altersstaffel],
- convert(varchar(50), Repair_Group_Desc) as Repair_Group_Desc,
- convert(varchar(20), DB1____EK) as [DB1_><_EK],
- convert(varchar(20), Rechnung_Gutschrift) as Rechnung_Gutschrift,
- convert(varchar(50), Parts_Focus_Group) as Parts_Focus_Group,
- convert(varchar(50), Parts_Make_Desc) as Parts_Make_Desc,
- convert(varchar(50), Parts_Group_Desc) as Parts_Group_Desc,
- convert(varchar(20), PLZ_1_Stelle) as PLZ_1_Stelle,
- convert(varchar(20), PLZ_2_Stelle) as PLZ_2_Stelle,
- convert(varchar(20), PLZ_3_Stelle) as PLZ_3_Stelle,
- convert(varchar(20), PLZ_4_Stelle) as PLZ_4_Stelle,
- convert(varchar(100), PLZ) as PLZ,
- convert(varchar(20), Zuordnung_Funktion) as Zuordnung_Funktion,
- convert(varchar(500), Order_Desc_100) as Order_Desc_100,
- convert(decimal(28, 8), Lohn_Umsatz) as Lohn,
- convert(decimal(28, 8), Teile_Umsatz) as Teile,
- convert(decimal(28, 8), EW_Teile) as [EW Teile],
- convert(decimal(28, 8), Sonst_) as [Sonst.],
- convert(decimal(28, 8), TÜV) as TÜV,
- convert(decimal(28, 8), Fremdl_) as [Fremdl.],
- convert(decimal(28, 8), Mietw_) as [Mietw.],
- convert(decimal(28, 8), Rädereinl_) as [Rädereinl.],
- convert(decimal(28, 8), verk__Std_) as [verk. Std.],
- convert(decimal(28, 8), ben__Std_) as [ben. Std.],
- convert(decimal(28, 8), NL_Lohn) as [NL Lohn],
- convert(decimal(28, 8), NL_Teile) as [NL Teile],
- convert(decimal(28, 8), NL_Sonst_) as [NL Sonst.],
- convert(decimal(28, 8), [NL_Sonst__]) as [NL Sonst %],
- convert(decimal(28, 8), DG) as DG,
- convert(decimal(28, 8), Anz__AT) as [Anz. AT],
- convert(varchar(20), Anwesenheit_Mech_Karo_Lack) as [Anwesenheit Mech Karo Lack],
- convert(varchar(20), Anwesenheit_Meister) as [Anwesenheit Meister],
- convert(datetime, Invoice_Date) as [Invoice Date],
- convert(varchar(500), Rechnungsausgang) as Rechnungsausgang,
- convert(int, Fabrikat_Order_By) as Fabrikat_Order_By,
- convert(decimal(28, 8), [EW_Fremdl_]) as [EW Fremdl.],
- convert(varchar(150), Serviceberater_Rg_Steller) as Serviceberater_Rg_Steller
- from transform.Aftersales_Rechnungen_neu
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS OFF
- GO
- GO
|
