| 123456789101112131415161718192021222324252627282930313233343536 |
- select T1."order_number" as "Order Number",
- T1."order_position" as "Order Position",
- T1."labour_type" as "Labour Type",
- T2."code" as "Code_Labour_Types",
- T2."description" as "Description_Labour_Types",
- T3."order_number" as "Order Number_Labours",
- T3."order_position" as "Order Position_Labours",
- T3."order_position_line" as "Order Position Line_Labours",
- '0' + (rtrim((convert(varchar(50), T4."subsidiary")))) as "Subsidiary_Labours",
- T3."is_invoiced" as "Is Invoiced_Labours",
- T3."invoice_type" as "Invoice Type_Labours",
- T3."invoice_number" as "Invoice Number_Labours",
- T3."employee_no" as "Employee No_Labours",
- T3."mechanic_no" as "Mechanic No_Labours",
- T3."labour_operation_id" as "Labour Operation Id_Labours",
- T3."is_nominal" as "Is Nominal_Labours",
- T3."net_price_in_order" as "Net Price In Order_Labours",
- T3."rebate_percent" as "Rebate Percent_Labours",
- T3."goodwill_percent" as "Goodwill Percent_Labours",
- T3."charge_type" as "Charge Type_Labours",
- T3."text_line" as "Text Line_Labours",
- 10 as "AW/Std.",
- ((convert(float, T3."time_units"))) / 10 as "verk. Std.",
- 'verk. Std.' as "Zeitkategorie",
- '' as "Zeitkategorie2",
- T4."employee_number" as "Employee Number_Employee",
- T4."name" as "Name_Employee",
- (rtrim((convert(varchar(50), T4."employee_number")))) + ' - ' + T4."name" as "Monteur",
- T5."invoice_number" as "Invoice Number_Invoices",
- T5."invoice_date" as "Invoice Date_Invoices",
- T5."invoice_date" as "Datum",
- T3."time_units" as "Time Units_Labours",
- (convert(float, T3."time_units")) as "Time_Units_Zahl"
- from ("dbo"."invoices" T5 left outer join ((("dbo"."order_positions" T1 left outer join "dbo"."labour_types" T2 on T1."labour_type" = T2."code") left outer join "dbo"."labours" T3 on T1."order_number" = T3."order_number") left outer join "dbo"."employees" T4 on T3."mechanic_no" = T4."employee_number") on (T3."invoice_number" = T5."invoice_number") and (T3."invoice_type" = T5."invoice_type"))
- where (((convert(float, T3."time_units"))) <> 0)
- -- order by "Order Number" asc,"Order Position" asc
|
