C11/System/AUTOLINE/IQD/Serv_Teile/Auftraege_Lohn_offen.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_AUTOLINE
DATASOURCENAME,C:\GlobalCube\System\Autoline\IQD\serv_teile\Auftraege_Lohn_offen.imr
TITLE,Auftraege_Lohn_offen.imr
BEGIN SQL
select T1."Client_DB" || '_' || (rtrim((cast_numberToString(cast_integer(T1."WIPNumber"))))) as c1,
	   T1."WIPNumber" as c2,
	   T1."DateCreated" as c3,
	   T1."Registration" as c4,
	   T1."AccountNo" as c5,
	   T1."SaleType" as c6,
	   T1."CustomerName" as c7,
	   T1."MakeModel" as c8,
	   T1."DiscountCategory" as c9,
	   T1."ChassisNumber" as c10,
	   T1."Department" as c11,
	   T1."DateFirstReg" as c12,
	   T1."FranchiseCode" as c13,
	   T1."DateDueIn" as c14,
	   T1."TimeIn" as c15,
	   T1."DateDueOut" as c16,
	   T1."TimeOut" as c17,
	   T1."DeleteFlag" as c18,
	   T1."CustomerDiscType" as c19,
	   T1."InvoiceNumber" as c20,
	   T1."CompanyNumber" as c21,
	   T1."DateUpdated" as c22,
	   T1."MagicMKVehicle" as c23,
	   T1."JobNumber" as c24,
	   T1."MagicNumber001" as c25,
	   T1."MagicNumber002" as c26,
	   T1."MagicNumber003" as c27,
	   T1."SellingDealer" as c28,
	   T1."RetentionType" as c29,
	   T1."WIPLabour" as c30,
	   T1."WIPParts" as c31,
	   T1."WLDateIn" as c32,
	   T1."WLDateOut" as c33,
	   T1."CustomerContact" as c34,
	   T1."MagicMKTarget" as c35,
	   T1."MagicMKCompany" as c36,
	   T1."DateDeleteFlagSet" as c37,
	   T1."InvoicableValue" as c38,
	   T1."BookingStatus" as c39,
	   T1."CreatingOperator" as c40,
	   T1."BookedInOperator" as c41,
	   T1."InvoicingOperator" as c42,
	   T1."BookedOutOperator" as c43,
	   T1."OwningOperator" as c44,
	   T1."Client_DB" as c45,
	   T2."RTSCode" as c46,
	   T2."AllowedTime" as c47,
	   T2."TimeTaken" as c48,
	   T2."RatePerHour" as c49,
	   T2."MechanicNumber" as c50,
	   T2."LabourTypeCode" as c51,
	   T2."LabourAnalysisCode" as c52,
	   T2."DateInserted" as c53,
	   T2."InvoiceStatus" as c54,
	   T2."OriginalInvStat" as c55,
	   T2."VATCode" as c56,
	   T2."DiscountPercent" as c57,
	   T2."MenuPrice" as c58,
	   T2."Unit" as c59,
	   T2."MinsPerUnit" as c60,
	   T2."WIPNumber" as c61,
	   T2."LineNumber" as c62,
	   T2."AccountCode" as c63,
	   T2."DepartmentCode" as c64,
	   T2."InvoiceNumber" as c65,
	   T2."DateEditted" as c66,
	   T2."FranchiseCode" as c67,
	   T2."SaleType" as c68,
	   T2."PostedToWarranty" as c69,
	   T2."WarrantyCode" as c70,
	   T2."CostPerHour" as c71,
	   T2."LoadType" as c72,
	   T2."LoadStatus" as c73,
	   T2."EmployeeNumber" as c74,
	   T2."ContributionVal" as c75,
	   T2."VehicleMagic" as c76,
	   T3."LabourRateCode" as c77,
	   T3."RateDescription002" as c78,
	   T2."Description" as c79,
	   T2."WLTAKENS001" as c80,
	   T2."WLTAKENS002" as c81,
	   T2."WLTAKENS003" as c82,
	   T2."WLTAKENS004" as c83,
	   T2."WLTAKENS005" as c84,
	   T2."WLTAKENS006" as c85,
	   T2."DateCosted" as c86,
	   T2."SOLoghdMagic001" as c87,
	   T2."SOLoghdMagic002" as c88,
	   T2."PreviousLoadStatus" as c89,
	   T2."BonusTime" as c90,
	   T2."SpecialPrice" as c91,
	   T2."JobCardNumber" as c92,
	   T2."CreatingOperator" as c93,
	   T2."ValidLabourRates" as c94,
	   T2."StandardTime" as c95,
	   T2."ExtendedPrice" as c96,
	   T2."FirstDayBooked" as c97,
	   T2."LastDayBooked" as c98,
	   T2."ResourceClocked" as c99,
	   T2."ActualLineNoSort" as c100,
	   T2."CompanyMagic" as c101,
	   T2."TargetMagic" as c102,
	   T2."OriginalLine" as c103,
	   T2."Client_DB" as c104,
	   T4."UserID" as c105,
	   T4."UserName" as c106,
	   T4."JobTitle" as c107,
	   T5."FranchiseCode" as c108,
	   T5."FullName001" as c109,
	   T5."FullName002" as c110,
	   T5."FullName003" as c111,
	   T6."LocationCode" as c112,
	   T6."Description" as c113,
	   T6."LocationName" as c114,
	   CASE WHEN (T1."Client_DB" BETWEEN '10' AND '19') THEN ('10') WHEN (T1."Client_DB" BETWEEN '20' AND '29') THEN ('20') WHEN (T1."Client_DB" BETWEEN '30' AND '39') THEN ('30') WHEN (T1."Client_DB" BETWEEN '40' AND '49') THEN ('40') WHEN (T1."Client_DB" BETWEEN '50' AND '59') THEN ('50') ELSE null END as c115,
	   '' as c116,
	   T6."LocationCode" as c117,
	   T6."LocationCode" || ' - ' || T6."Description" as c118,
	   'Serviceberater' as c119,
	   CASE WHEN (T4."UserName" IS NULL) THEN ('n.N.') ELSE (T4."UserName") END as c120,
	   CASE WHEN (T7."Franchise" = 'M') THEN ('Mercedes PKW') WHEN (T7."Franchise" = 'T') THEN ('Mercedes TRAPO') WHEN (T7."Franchise" = 'Z') THEN ('Fremd') WHEN (T7."Franchise" = 'S') THEN ('Smart') WHEN (T7."Franchise" = 'F') THEN ('Fremd TRAPO') ELSE null END as c121,
	   (od_left((ucase(T7."Description")),4)) as c122,
	   T1."ChassisNumber" as c123,
	   (CASE WHEN (T7."Franchise" = 'M') THEN ('Mercedes PKW') WHEN (T7."Franchise" = 'T') THEN ('Mercedes TRAPO') WHEN (T7."Franchise" = 'Z') THEN ('Fremd') WHEN (T7."Franchise" = 'S') THEN ('Smart') WHEN (T7."Franchise" = 'F') THEN ('Fremd TRAPO') ELSE null END) as c124,
	   'Service' as c125,
	   (substring(T3."LabourRateCode" from 2 for 1)) as c126,
	   CASE WHEN (((substring(T3."LabourRateCode" from 2 for 1))) = 'W') THEN ('GWL') WHEN (((substring(T3."LabourRateCode" from 2 for 1))) = 'I') THEN ('Intern') ELSE ('Extern') END as c127,
	   T1."AccountNo" || ' - ' || T1."CustomerName" as c128,
	   T1."SaleType" as c129,
	   '' as c130,
	   T8."DocumentNumber" as c131,
	   T8."DocumentDate" as c132,
	   CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END as c133,
	   CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END as c134,
	   CASE WHEN ((extract(DAY FROM (now()) - (CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END))) <= 30) THEN ((T1."Client_DB" || '_' || (rtrim((cast_numberToString(cast_integer(T1."WIPNumber"))))))) ELSE ('Aufträge älter 30 Tage') END as c135,
	   CASE WHEN ((extract(DAY FROM (now()) - (CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END))) <= 30) THEN ((rtrim((cast_numberToString(cast_integer(T2."InvoiceNumber"))))) || ' - ' || (CASE WHEN (T4."UserName" IS NULL) THEN ('n.N.') ELSE (T4."UserName") END) || ' - ' || (T1."AccountNo" || ' - ' || T1."CustomerName") || ' - ' || T1."ChassisNumber") ELSE ('Rechnungen älter 30 Tage') END as c136,
	   CASE WHEN ((extract(DAY FROM (now()) - (CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END))) <= 100) THEN ((T1."Client_DB" || '_' || (rtrim((cast_numberToString(cast_integer(T1."WIPNumber")))))) || ' - ' || (T1."AccountNo" || ' - ' || T1."CustomerName") || ' - ' || T1."ChassisNumber") ELSE ('Aufträge älter 100 Tage') END as c137,
	   CASE WHEN ((extract(DAY FROM (now()) - (CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END))) <= 100) THEN ((rtrim((cast_numberToString(cast_integer(T2."InvoiceNumber"))))) || ' - ' || (T1."AccountNo" || ' - ' || T1."CustomerName") || ' - ' || T1."ChassisNumber") ELSE ('Rechnungen älter 100 Tage') END as c138,
	   CASE WHEN ((extract(DAY FROM (now()) - (CASE WHEN ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END) IS NULL) THEN (T1."DateUpdated") ELSE ((CASE WHEN (T8."DocumentDate" IS NULL) THEN (T1."DateDueOut") ELSE (T8."DocumentDate") END)) END))) <= 30) THEN ((rtrim((cast_numberToString(cast_integer(T2."LineNumber"))))) || ' - ' || T3."LabourRateCode" || ' - ' || T2."Description") ELSE ('Auftragspositionen älter 30 Tage') END as c139,
	   CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END as c140,
	   T3."LabourRateCode" || ' - ' || T3."RateDescription002" as c141,
	   '' as c142,
	   '' as c143,
	   'VK > EK' as c144,
	   'Rechnung' as c145,
	   '' as c146,
	   '' as c147,
	   '' as c148,
	   T9."Postcode" as c149,
	   (od_left(T9."Postcode",1)) as c150,
	   (od_left(T9."Postcode",2)) as c151,
	   (od_left(T9."Postcode",3)) as c152,
	   (od_left(T9."Postcode",4)) as c153,
	   T9."Postcode" as c154,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('M - Lack','C - Karo.','A - Mech.')) THEN (T2."ExtendedPrice") ELSE (0) END as c155,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('S - Fremdl.')) THEN (T2."ExtendedPrice") ELSE (0) END as c156,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('Sonst.')) THEN (T2."ExtendedPrice") ELSE (0) END as c157,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('Y - Mietw.')) THEN (T2."ExtendedPrice") ELSE (0) END as c158,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('R - Rädereinl.')) THEN (T2."ExtendedPrice") ELSE (0) END as c159,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('M - Lack','C - Karo.','A - Mech.')) THEN (T2."AllowedTime") ELSE (0) END as c160,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('M - Lack','C - Karo.','A - Mech.')) THEN (T2."TimeTaken") ELSE (0) END as c161,
	   CASE WHEN ((CASE WHEN (T2."LabourAnalysisCode" IN ('A','AW','W')) THEN ('A - Mech.') WHEN (T2."LabourAnalysisCode" IN ('C')) THEN ('C - Karo./Lack') WHEN (T2."LabourAnalysisCode" IN ('R')) THEN ('R - Rädereinl.') WHEN (T2."LabourAnalysisCode" IN ('S')) THEN ('S - Fremdl.') WHEN (T2."LabourAnalysisCode" IN ('Y','L','F')) THEN ('Y - Mietw.') WHEN (T2."LabourAnalysisCode" IN ('P')) THEN ('P - MFK') ELSE ('Sonst.') END) IN ('M - Lack','C - Karo.','A - Mech.')) THEN (T2."AllowedTime" * T2."RatePerHour" - T2."ExtendedPrice") ELSE (0) END as c162,
	   CASE WHEN (T1."SaleType" IN ('W')) THEN ('GWL') WHEN (T1."SaleType" IN ('I')) THEN ('Intern') ELSE ('Extern') END as c163,
	   T1."DateCreated" as c164,
	   (T1."Client_DB" || '_' || (rtrim((cast_numberToString(cast_integer(T1."WIPNumber")))))) || '/' || T1."BookingStatus" || ' - ' || (CASE WHEN (T4."UserName" IS NULL) THEN ('n.N.') ELSE (T4."UserName") END) || ' - ' || (T1."AccountNo" || ' - ' || T1."CustomerName") || ' - ' || T1."ChassisNumber" as c165,
	   (extract(DAY FROM (now()) - T1."DateCreated")) as c166,
	   T7."Franchise" as c167
from (((((((("AUTOLINE"."import"."SO_HeaderRecords" T1 left outer join "AUTOLINE"."import"."SO_LabourLines" T2 on (T1."WIPNumber" = T2."WIPNumber") and (T1."Client_DB" = T2."Client_DB")) left outer join "AUTOLINE"."import"."SO_LabourRates" T3 on ((T2."LabourTypeCode" = T3."LabourRateCode") and (T2."Client_DB" = T3."Client_DB")) and (T2."FranchiseCode" = T3."FranchiseCode")) left outer join "AUTOLINE"."import"."GB_UserDetails" T4 on ((cast_float(T1."BookedInOperator")) = T4."POSOperator") and ((T1."Department" = T4."CRMDepartment") or (T4."POSOperator" = 888))) left outer join "AUTOLINE"."import"."DD_FranchiseRecords" T5 on T1."FranchiseCode" = T5."FranchiseCode") left outer join "AUTOLINE"."import"."GB_CompanyLocations" T6 on T6."LocationCode" = T1."CompanyNumber") left outer join "AUTOLINE"."import"."MK_VehicleRecords" T7 on T7."VehicleNumber" = T1."MagicMKVehicle") left outer join "AUTOLINE"."import"."SL_SLTransactions" T8 on ((T8."DocumentNumber" = T2."InvoiceNumber") and (T8."TruePostingOrigin" = T2."Client_DB")) and (T8."AccountCode" = T2."AccountCode")) left outer join "AUTOLINE"."import"."SL_SalesLedgerAccounts" T9 on (T1."AccountNo" = T9."AccountCode") and (T9."Client_DB" = '10'))
where ((((((T1."DateCreated" >= TIMESTAMP '2020-01-01 00:00:00.000') and (T1."InvoiceNumber" = 0)) and (not T2."InvoiceStatus" IN ('X'))) and (T2."LabourAnalysisCode" <> 'T')) and (not T2."Description" LIKE '%Selbstbehalt%')) and (not T1."BookingStatus" IN ('M')))
order by c1 asc,c2 asc

END SQL
COLUMN,0,Order_Number_eindeutig
COLUMN,1,Wipnumber
COLUMN,2,Datecreated
COLUMN,3,Registration
COLUMN,4,Accountno
COLUMN,5,Saletype
COLUMN,6,Customername
COLUMN,7,Makemodel
COLUMN,8,Discountcategory
COLUMN,9,Chassisnumber
COLUMN,10,Department
COLUMN,11,Datefirstreg
COLUMN,12,Franchisecode
COLUMN,13,Dateduein
COLUMN,14,Timein
COLUMN,15,Datedueout
COLUMN,16,Timeout
COLUMN,17,Deleteflag
COLUMN,18,Customerdisctype
COLUMN,19,Invoicenumber
COLUMN,20,Companynumber
COLUMN,21,Dateupdated
COLUMN,22,Magicmkvehicle
COLUMN,23,Jobnumber
COLUMN,24,Magicnumber001
COLUMN,25,Magicnumber002
COLUMN,26,Magicnumber003
COLUMN,27,Sellingdealer
COLUMN,28,Retentiontype
COLUMN,29,Wiplabour
COLUMN,30,Wipparts
COLUMN,31,Wldatein
COLUMN,32,Wldateout
COLUMN,33,Customercontact
COLUMN,34,Magicmktarget
COLUMN,35,Magicmkcompany
COLUMN,36,Datedeleteflagset
COLUMN,37,Invoicablevalue
COLUMN,38,Bookingstatus
COLUMN,39,Creatingoperator
COLUMN,40,Bookedinoperator
COLUMN,41,Invoicingoperator
COLUMN,42,Bookedoutoperator
COLUMN,43,Owningoperator
COLUMN,44,Client Db
COLUMN,45,Rtscode
COLUMN,46,Allowedtime
COLUMN,47,Timetaken
COLUMN,48,Rateperhour
COLUMN,49,Mechanicnumber
COLUMN,50,Labourtypecode
COLUMN,51,Labouranalysiscode
COLUMN,52,Dateinserted
COLUMN,53,Invoicestatus_Labourlines
COLUMN,54,Originalinvstat
COLUMN,55,Vatcode
COLUMN,56,Discountpercent
COLUMN,57,Menuprice
COLUMN,58,Unit
COLUMN,59,Minsperunit
COLUMN,60,Wipnumber
COLUMN,61,Linenumber
COLUMN,62,Accountcode
COLUMN,63,Departmentcode
COLUMN,64,Invoicenumber_Labourlines
COLUMN,65,Dateeditted
COLUMN,66,Franchisecode
COLUMN,67,Saletype_Labourline
COLUMN,68,Postedtowarranty
COLUMN,69,Warrantycode
COLUMN,70,Costperhour
COLUMN,71,Loadtype
COLUMN,72,Loadstatus
COLUMN,73,Employeenumber
COLUMN,74,Contributionval
COLUMN,75,Vehiclemagic
COLUMN,76,Labourratecode
COLUMN,77,Ratedescription002
COLUMN,78,Description
COLUMN,79,Wltakens001
COLUMN,80,Wltakens002
COLUMN,81,Wltakens003
COLUMN,82,Wltakens004
COLUMN,83,Wltakens005
COLUMN,84,Wltakens006
COLUMN,85,Datecosted
COLUMN,86,Sologhdmagic001
COLUMN,87,Sologhdmagic002
COLUMN,88,Previousloadstatus
COLUMN,89,Bonustime
COLUMN,90,Specialprice
COLUMN,91,Jobcardnumber
COLUMN,92,Creatingoperator
COLUMN,93,Validlabourrates
COLUMN,94,Standardtime
COLUMN,95,Extendedprice
COLUMN,96,Firstdaybooked
COLUMN,97,Lastdaybooked
COLUMN,98,Resourceclocked
COLUMN,99,Actuallinenosort
COLUMN,100,Companymagic
COLUMN,101,Targetmagic
COLUMN,102,Originalline
COLUMN,103,Client Db
COLUMN,104,Userid
COLUMN,105,Username
COLUMN,106,Jobtitle
COLUMN,107,Franchisecode
COLUMN,108,Fullname001
COLUMN,109,Fullname002
COLUMN,110,Fullname003
COLUMN,111,Locationcode
COLUMN,112,Description
COLUMN,113,Locationname
COLUMN,114,Hauptbetrieb_ID
COLUMN,115,Hauptbetrieb_Name
COLUMN,116,Standort_ID
COLUMN,117,Standort_Name
COLUMN,118,Zuordnung_Funktion
COLUMN,119,Serviceberater
COLUMN,120,Fabrikat
COLUMN,121,Model
COLUMN,122,Fahrzeug
COLUMN,123,Marke
COLUMN,124,Auftragsart
COLUMN,125,2_Stelle_Labourratecode
COLUMN,126,Umsatzart_Labourratecode
COLUMN,127,Kunde
COLUMN,128,Kundenart
COLUMN,129,Kostenstelle
COLUMN,130,Documentnumber_Sltransactions
COLUMN,131,Documentdate_Sltransactions
COLUMN,132,Invoice Date_ori
COLUMN,133,Invoice Date
COLUMN,134,Order_Desc_30
COLUMN,135,Invoice_Desc_30
COLUMN,136,Order_Desc_100
COLUMN,137,Invoice_Desc_100
COLUMN,138,Auftragsposition
COLUMN,139,Zuordnung_Produktbuchungsgruppe
COLUMN,140,Produktbuchungsgruppe
COLUMN,141,FZG-Altersstaffel
COLUMN,142,Repair_Group_Desc
COLUMN,143,DB1_><_EK
COLUMN,144,Rechnung_Gutschrift
COLUMN,145,Parts_Focus_Group
COLUMN,146,Parts_Make_Desc
COLUMN,147,Parts_Group_Desc
COLUMN,148,Postcode_Slsalesledgeraccount
COLUMN,149,PLZ_1_Stelle
COLUMN,150,PLZ_2_Stelle
COLUMN,151,PLZ_3_Stelle
COLUMN,152,PLZ_4_Stelle
COLUMN,153,PLZ
COLUMN,154,Lohn
COLUMN,155,Fremdl.
COLUMN,156,Sonst.
COLUMN,157,Mietw.
COLUMN,158,Rädereinl.
COLUMN,159,verk. Std.
COLUMN,160,ben. Zeit
COLUMN,161,NL Lohn
COLUMN,162,Umsatzart
COLUMN,163,Order Date
COLUMN,164,Order Number
COLUMN,165,Tage offen
COLUMN,166,Franchise_MK_Vehiclerecords