C11/System/OPTIMA/IQD/NW/nw_be_csv.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GlobalCube\SYSTEM\OPTIMA\IQD\nw\nw_be_csv.imr
TITLE,nw_be_csv.imr
BEGIN SQL
select T1."UNIT_NUMBER" as c1,
	   T1."BASIS_NUMBER" as c2,
	   T1."ECC_STATUS" as c3,
	   T1."VEHICLE_TYPE" as c4,
	   T1."TRANSACT_DATE" as c5,
	   T1."HANDLER" as c6,
	   T1."CAR_CREATION_DATE" as c7,
	   T1."PMT_TERM" as c8,
	   T1."SMALL_ACCESSORIES" as c9,
	   T1."SMALL_INV_CHARGE" as c10,
	   T1."DELIVERY_STOP_CODE" as c11,
	   T1."PRICE_CODE" as c12,
	   T1."DISCOUNT_PERC_WORK" as c13,
	   T1."DISCOUNT_LIMIT" as c14,
	   T1."INTERNAL_CODE" as c15,
	   T1."TAX_CODE" as c16,
	   T1."UNIT_LAST_UPD_DTE" as c17,
	   T1."DEPRECIATION" as c18,
	   T1."TRANSFER_TAX" as c19,
	   T1."BOOK_KEEPING_CODE" as c20,
	   T1."TAX_HANDLING" as c21,
	   T1."INTEREST_CODE" as c22,
	   T1."MILEAGE" as c23,
	   T1."PURCH_DEPARTMENT" as c24,
	   T1."PURCH_SALSMAN_CODE" as c25,
	   T1."PURCH_INVNO" as c26,
	   T1."PURCH_DATE" as c27,
	   T1."SALES_DEPARTMENT" as c28,
	   T1."SALE_SALESMAN" as c29,
	   T1."SALE_INV_NUMBER" as c30,
	   T1."SALE_DATE" as c31,
	   T1."SCRAP_CODE" as c32,
	   T1."UNIT_IN_CHANGE" as c33,
	   T1."BUD_SALE_DET" as c34,
	   T1."BUD_PURCH_PRICE" as c35,
	   T1."BUD_REG_FEE" as c36,
	   T1."BUD_DEDUCT_FEE" as c37,
	   T1."BUD_COST" as c38,
	   T1."PREV_OWNER" as c39,
	   T1."OWNER" as c40,
	   T1."PURCH_PRICE_UNIT" as c41,
	   T1."COST_UNIT" as c42,
	   T1."SALES_PRICE_UNIT" as c43,
	   T1."REG_FEE" as c44,
	   T1."INTEREST_1" as c45,
	   T1."INTEREST_2" as c46,
	   T1."NEXT_LINE_UNIT" as c47,
	   T1."NEXT_LINE_1" as c48,
	   T1."TRANSFER_LINE" as c49,
	   T1."TRANSFER_TAX_HAND" as c50,
	   T1."TRANSFER_ACC_CODE" as c51,
	   T1."TRANSFER_TAX_BASIS" as c52,
	   T1."TRANSFER_TAX_PCT" as c53,
	   T1."TRANSFER_SOLD" as c54,
	   T1."PURCH_TAX" as c55,
	   T1."COST_TAX" as c56,
	   T1."OR_MARK" as c57,
	   T1."TRANSFER_DATE" as c58,
	   T1."STOCK_DAYS" as c59,
	   T1."DELETE_PROPOSAL" as c60,
	   T1."TRANSFER_BBDB" as c61,
	   T1."CONDITION_UNIT" as c62,
	   T1."BUYING_ORDER_NO" as c63,
	   T1."BUYING_ORDER_DATE" as c64,
	   T1."PA_NUMBER" as c65,
	   T1."VEHICLE_UPDATE" as c66,
	   T1."LATEST_UPDATE" as c67,
	   T1."INVOICE_PERMISSION" as c68,
	   T1."LOCATION_CODE" as c69,
	   T1."ACCOUNT_PURCHASE" as c70,
	   T1."ACCOUNT_SALES" as c71,
	   T1."BUDG_PRICE_VAT" as c72,
	   T1."RECALC_CODE" as c73,
	   T1."COMMISION_NO" as c74,
	   T1."DELIVERY_DATE_VEH" as c75,
	   T1."RESERVATION_DATE" as c76,
	   T1."RESERVATION_PERSON" as c77,
	   T1."RESERVATION_TEXT" as c78,
	   T1."FREIGHT_BALANCE" as c79,
	   T1."TRF_TAXBASIS_SALES" as c80,
	   T1."TRF_TAXBASIS_PURCH" as c81,
	   T1."SALE_ORDER_NO" as c82,
	   T1."UNIT_SOLD" as c83,
	   T1."TRF_DEPARTMENT" as c84,
	   T1."ORDER_ARRIVAL_DATE" as c85,
	   T1."ORDER_CONFIRM_DATE" as c86,
	   T1."PRICE_LABEL_DATE" as c87,
	   T1."VAT_TABLE_WORK" as c88,
	   T1."VAT_TABLE_NORMAL" as c89,
	   T1."VAT_RATE_CODE" as c90,
	   T1."TRANSFER_VAT_RC" as c91,
	   T1."CNTRACT_DUE_DATE" as c92,
	   T1."CONTRACT_DATE" as c93,
	   T1."EXP_ARRIVAL_TIME" as c94,
	   T1."DEALER_MARKING" as c95,
	   T1."BOOKING_DEALER_NR" as c96,
	   T1."DESIRED_DELIV_DATE" as c97,
	   T1."VALUATION_DATE" as c98,
	   T1."FORD_INT_DATE" as c99,
	   T1."EST_SALES_PRICE" as c100,
	   T1."EST_REFERENCE_NO" as c101,
	   T1."RECEPTION_DATE" as c102,
	   T1."BUD_OPT_PRICE" as c103,
	   T1."SALE_PRICE_DATE" as c104,
	   T1."PURCH_ORIGIN_CODE" as c105,
	   T1."PRICE_LIST_VERSION" as c106,
	   T1."PRICE_LIST_DATE" as c107,
	   T1."UNIQUE_IDENT" as c108,
	   T2."VEHICLE_TYPE" as c109,
	   T2."VEHICLE_TYPE_TEXT" as c110,
	   CASE WHEN (T1."ECC_STATUS" = '21') THEN ('21 - Lagerauftrag') WHEN (T1."ECC_STATUS" = '25') THEN ('25 - Kundenauftrag') WHEN (T1."ECC_STATUS" = '41') THEN ('41 - Bestand') WHEN (T1."ECC_STATUS" = '44') THEN ('44 - auf Lager verkauft') WHEN (T1."ECC_STATUS" = '64') THEN ('64 - verkauft') WHEN (T1."ECC_STATUS" = '42') THEN ('42') ELSE null END as c111,
	   T3."BASIS_NUMBER" as c112,
	   T3."TRANSACT_DATE" as c113,
	   T3."HANDLER" as c114,
	   T3."REGISTER_NUMBER" as c115,
	   T3."CHASSIS_NUMBER" as c116,
	   T3."CAR_GROUP" as c117,
	   T3."CAR_STATUS" as c118,
	   T3."FAC_MODEL_CODE_L" as c119,
	   T3."FIRST_REG_DATE" as c120,
	   T3."LATEST_REG_DATE" as c121,
	   T3."FIRST_OCCUR_DATE" as c122,
	   T3."EXPECTED_ARR_DATE" as c123,
	   T3."ARRIVAL_DATE" as c124,
	   T3."SALESMAN_BUY" as c125,
	   T3."SALESMAN_SALE" as c126,
	   T3."MODEL_TEXT" as c127,
	   T3."ORIG_MODEL_CODE1" as c128,
	   T3."ORIG_MODEL_CODE2" as c129,
	   T3."COLOUR_CF" as c130,
	   T3."TRIM_TXT" as c131,
	   T3."MODEL_LINE" as c132,
	   T3."WORKSHOP_MODEL" as c133,
	   T3."FAC_MODEL_CODE_S" as c134,
	   T3."CLASSIFICATION" as c135,
	   T3."MOTOR_NUMBER" as c136,
	   T3."KEY_CODE" as c137,
	   T3."YEAR_MODEL_CF" as c138,
	   T3."CYLINDER_VOLUME" as c139,
	   T3."SEATS" as c140,
	   T3."DECLARATION_DATE" as c141,
	   T3."DECLARATION_PLACE" as c142,
	   T3."DECLARATION_NUMBER" as c143,
	   T3."EQUIPMENT_1" as c144,
	   T3."EQUIPMENT_2" as c145,
	   T3."EQUIPMENT_3" as c146,
	   T3."EQUIPMENT_4" as c147,
	   T3."MILEAGE" as c148,
	   T3."MISC_1_CF" as c149,
	   T3."MISC_2_CF" as c150,
	   T3."MISC_3_CF" as c151,
	   T3."MISC_4_CF" as c152,
	   T3."MISC_5_CF" as c153,
	   T3."MISC_6_CF" as c154,
	   T3."MISC_7_CF" as c155,
	   T3."MISC_8_CF" as c156,
	   T3."MISC_9_CF" as c157,
	   T3."MISC_10_CF" as c158,
	   T3."MOTOR_CODE" as c159,
	   T3."GEAR_CODE" as c160,
	   T3."DRIVE_CODE" as c161,
	   T3."COLOUR_CODE" as c162,
	   T3."TRIM_CODE" as c163,
	   T3."NO_OF_OWNERS" as c164,
	   T3."TUV_TYPE" as c165,
	   T3."TUV_DATE" as c166,
	   T3."TUV_INSP" as c167,
	   T3."ASU_TYPE" as c168,
	   T3."ASU_DATE" as c169,
	   T3."ASU_INSP" as c170,
	   T3."TYPE_YEAR" as c171,
	   T3."AVAILABLE" as c172,
	   T3."CAL_COST" as c173,
	   T3."CAL_COST_DATE" as c174,
	   T3."STOCK_DATE" as c175,
	   T3."PURCH_CAL_DATE" as c176,
	   T3."MODEL_LINE_GROUP" as c177,
	   T3."MODEL_TYPE_2" as c178,
	   T3."MAKE" as c179,
	   T3."HOUR_RATE_TABLE" as c180,
	   T3."PAID_DATE" as c181,
	   T3."LATEST_INV_DATE" as c182,
	   T3."PURCH_AMOUNT" as c183,
	   T3."DEALER_NUMBER" as c184,
	   T3."DEALER_MARKING" as c185,
	   T3."FUELTYPE" as c186,
	   T3."SERVICE_DAYS" as c187,
	   T3."HOURLY_REPAIR_RATE" as c188,
	   T3."WORKSHOP_PRICECODE" as c189,
	   T3."DISCOUNT_PERC_WORK" as c190,
	   T3."SOLDMARK_DATE" as c191,
	   T3."MAKE_CD" as c192,
	   T4."MODEL_LINE" as c193,
	   T4."MOD_LIN_SPECIFY" as c194,
	   T4."MAKE_CD" as c195,
	   T5."WORKSHOP_MODEL" as c196,
	   T5."MAKE_CD" as c197,
	   T5."MODEL_TEXT" as c198,
	   T5."ORIG_MODEL_CODE" as c199,
	   T5."MODEL_TYPE" as c200,
	   T5."MODEL_GROUP" as c201,
	   T5."MAKE_CODE" as c202,
	   T1."CLIENT_DB" as c203,
	   (substring(T6."DEPARTMENT_TYPE_ID" from 1 for 2)) as c204,
	   T6."DEPARTMENT_TYPE_ID" as c205,
	   T6."DESCRIPTION" as c206,
	   CASE WHEN (T2."VEHICLE_TYPE" IN ('N','T','V')) THEN ('Neuwagen') WHEN (T2."VEHICLE_TYPE" IN ('D','G','K','R','M')) THEN ('Gebrauchtwagen') ELSE null END as c207,
	   T7."DESCRIPTION" as c208,
	   T3."MODEL_TEXT" as c209,
	   T3."CHASSIS_NUMBER" as c210,
	   T3."COLOUR_CODE" || ' - ' || T3."COLOUR_CF" as c211,
	   (truncate(T1."UNIT_NUMBER")) || ' - ' || T3."CHASSIS_NUMBER" || ' - ' || (CASE WHEN (T2."VEHICLE_TYPE" IS NULL) THEN (T1."VEHICLE_TYPE") ELSE (T2."VEHICLE_TYPE" || ' - ' || T2."VEHICLE_TYPE_TEXT") END) as c212,
	   CASE WHEN (T2."VEHICLE_TYPE" IS NULL) THEN (T1."VEHICLE_TYPE") ELSE (T2."VEHICLE_TYPE" || ' - ' || T2."VEHICLE_TYPE_TEXT") END as c213,
	   T7."GLOBAL_MAKE_CD" as c214,
	   T7."DESCRIPTION" as c215,
	   T1."PURCH_PRICE_UNIT" + T1."COST_UNIT" as c216,
	   1 as c217,
	   (getdate()) as c218,
	   CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END as c219,
	   CASE WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) BETWEEN 0 AND 30) THEN ('0 - 30 Tage') WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) BETWEEN 31 AND 60) THEN ('31 - 60 Tage') WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) BETWEEN 61 AND 90) THEN ('61 - 90 Tage') WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) BETWEEN 91 AND 180) THEN ('91 - 180 Tage') WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) BETWEEN 181 AND 360) THEN ('181 - 360 Tage') WHEN ((CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) > 360) THEN ('> 360 Tage') ELSE null END as c220,
	   T3."CAR_LETTER" as c221,
	   CASE WHEN (T3."CAR_LETTER" = 'Konsi') THEN ('Konsi-FZG') ELSE ('Lagerfahrzeug') END as c222,
	   (CASE WHEN (T1."ECC_STATUS" IN ('21','25')) THEN (0) WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((getdate())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((getdate())) - T1."RECEPTION_DATE"))) END) * 15 as c223,
	   (T1."LOCATION_CODE") as c224,
	   T8."SELLER_CODE" as c225,
	   T8."SEL_NAME" as c226,
	   T8."SEL_NAME" as c227,
	   T1."BUD_COST" as c228,
	   T1."COST_UNIT" as c229,
	   T1."BUD_SALE_DET" as c230,
	   CASE WHEN (T7."DESCRIPTION" IN ('Opel','Kia')) THEN (T7."DESCRIPTION") ELSE ('Fremdfabrikat') END as c231,
	   CASE WHEN (T9."Hauptbetrieb_ID" IS NULL) THEN ('1') ELSE (T9."Hauptbetrieb_ID") END as c232,
	   'Bergneustadt Ley' as c233,
	   CASE WHEN ((T9."Standort_ID" IS NULL) and (T1."CLIENT_DB" = '1')) THEN ('01') WHEN ((T9."Standort_ID" IS NULL) and (T1."CLIENT_DB" = '2')) THEN ('02') ELSE (T9."Standort_ID") END as c234,
	   CASE WHEN ((T9."Standort_Name" IS NULL) and (T1."CLIENT_DB" IN ('1'))) THEN ('Bergneustadt') WHEN ((T9."Standort_Name" IS NULL) and (T1."CLIENT_DB" IN ('2'))) THEN ('Verwaltung') ELSE (T9."Standort_Name") END as c235,
	   T10."Fabrikat" as c236,
	   CASE WHEN (T3."MAKE_CD" IN ('OP')) THEN ('Opel') ELSE ('Fremdfabrikat') END as c237,
	   CASE WHEN (T10."Order_By" IS NULL) THEN (99) ELSE (T10."Order_By") END as c238,
	   T4."MOD_LIN_SPECIFY" as c239,
	   T3."MODEL_TEXT" as c240,
	   '' as c241,
	   T1."LOCATION_CODE" as c242,
	   (truncate(T1."PREV_OWNER")) || ' / ' || T8."SEL_NAME" as c243,
	   T1."PREV_OWNER" as c244,
	   T8."SEL_NAME" as c245,
	   (truncate(T1."UNIT_NUMBER")) || ' - ' || T8."SEL_NAME" as c246,
	   (asciiz(extract(YEAR FROM T3."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T3."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T3."FIRST_REG_DATE"),2)) as c247,
	   T1."MILEAGE" as c248,
	   0 as c249,
	   T1."BUD_SALE_DET" as c250,
	   0 as c251,
	   0 as c252,
	   ((getdate())) as c253,
	   CASE WHEN (T3."MODEL_TEXT" IS NOT NULL) THEN ((truncate(T3."MODEL_TEXT")) || ' - ' || T1."UNIT_NUMBER") ELSE (T1."UNIT_NUMBER") END as c254,
	   CASE WHEN (T1."ECC_STATUS" LIKE '2%') THEN ('Vorlauf') WHEN (T1."ECC_STATUS" LIKE '4%') THEN ('Bestand') ELSE null END as c255,
	   CASE WHEN (T1."ECC_STATUS" IN ('21','41')) THEN ('Lager') WHEN (T1."ECC_STATUS" IN ('25','44')) THEN ('verkauft') ELSE null END as c256
from ((((((((("OPTIMA"."import"."UNIT_FILE" T1 left outer join "OPTIMA"."import"."vPP5R" T2 on (T1."VEHICLE_TYPE" = T2."VEHICLE_TYPE") and (T1."CLIENT_DB" = T2."CLIENT_DB")) left outer join "OPTIMA"."import"."VEHICLE" T3 on T1."BASIS_NUMBER" = T3."BASIS_NUMBER") left outer join "OPTIMA"."import"."VPP5Q" T4 on ((T3."MODEL_LINE" = T4."MODEL_LINE") and (T3."MAKE_CD" = T4."MAKE_CD")) and (T3."CLIENT_DB" = T4."CLIENT_DB")) left outer join "OPTIMA"."import"."vPP74" T5 on ((T3."WORKSHOP_MODEL" = T5."WORKSHOP_MODEL") and (T3."MAKE_CD" = T5."MAKE_CD")) and (T3."CLIENT_DB" = T5."CLIENT_DB")) left outer join "OPTIMA"."import"."DEPARTMENT_TYPE" T6 on (T1."PURCH_DEPARTMENT" = T6."DEPARTMENT_TYPE_ID") and (T1."CLIENT_DB" = T6."CLIENT_DB")) left outer join "OPTIMA"."import"."GLOBAL_MAKE" T7 on (T3."MAKE_CD" = T7."GLOBAL_MAKE_CD") and (T3."CLIENT_DB" = T7."CLIENT_DB")) left outer join "OPTIMA"."import"."VPP43" T8 on (T1."PURCH_SALSMAN_CODE" = T8."SELLER_CODE") and (T1."CLIENT_DB" = T8."CLIENT_DB")) left outer join "OPTIMA"."data"."GC_Department" T9 on (T1."CLIENT_DB" = T9."Hauptbetrieb") and ((substring(T1."PURCH_DEPARTMENT" from 1 for 2)) = T9."Standort")) left outer join "OPTIMA"."data"."GC_Marken" T10 on (T3."CLIENT_DB" = T10."Client_DB") and (T3."MAKE_CD" = T10."Make"))
where (T1."ECC_STATUS" IN ('41','42','44'))
order by c1 asc,c219 desc

END SQL
COLUMN,0,Unit Number
COLUMN,1,Basis Number
COLUMN,2,Ecc Status
COLUMN,3,Vehicle Type
COLUMN,4,Transact Date
COLUMN,5,Handler
COLUMN,6,Car Creation Date
COLUMN,7,Pmt Term
COLUMN,8,Small Accessories
COLUMN,9,Small Inv Charge
COLUMN,10,Delivery Stop Code
COLUMN,11,Price Code
COLUMN,12,Discount Perc Work
COLUMN,13,Discount Limit
COLUMN,14,Internal Code
COLUMN,15,Tax Code
COLUMN,16,Unit Last Upd Dte
COLUMN,17,Depreciation
COLUMN,18,Transfer Tax
COLUMN,19,Book Keeping Code
COLUMN,20,Tax Handling
COLUMN,21,Interest Code
COLUMN,22,Mileage
COLUMN,23,Purch Department
COLUMN,24,Purch Salsman Code
COLUMN,25,Purch Invno
COLUMN,26,Purch Date
COLUMN,27,Sales Department
COLUMN,28,Sale Salesman
COLUMN,29,Sale Inv Number
COLUMN,30,Sale Date
COLUMN,31,Scrap Code
COLUMN,32,Unit In Change
COLUMN,33,Bud Sale Det
COLUMN,34,Bud Purch Price
COLUMN,35,Bud Reg Fee
COLUMN,36,Bud Deduct Fee
COLUMN,37,Bud Cost
COLUMN,38,Prev Owner
COLUMN,39,Owner
COLUMN,40,Purch Price Unit
COLUMN,41,Cost Unit
COLUMN,42,Sales Price Unit
COLUMN,43,Reg Fee
COLUMN,44,Interest 1
COLUMN,45,Interest 2
COLUMN,46,Next Line Unit
COLUMN,47,Next Line 1
COLUMN,48,Transfer Line
COLUMN,49,Transfer Tax Hand
COLUMN,50,Transfer Acc Code
COLUMN,51,Transfer Tax Basis
COLUMN,52,Transfer Tax Pct
COLUMN,53,Transfer Sold
COLUMN,54,Purch Tax
COLUMN,55,Cost Tax
COLUMN,56,Or Mark
COLUMN,57,Transfer Date
COLUMN,58,Stock Days
COLUMN,59,Delete Proposal
COLUMN,60,Transfer Bbdb
COLUMN,61,Condition Unit
COLUMN,62,Buying Order No
COLUMN,63,Buying Order Date
COLUMN,64,Pa Number
COLUMN,65,Vehicle Update
COLUMN,66,Latest Update
COLUMN,67,Invoice Permission
COLUMN,68,Location Code
COLUMN,69,Account Purchase
COLUMN,70,Account Sales
COLUMN,71,Budg Price Vat
COLUMN,72,Recalc Code
COLUMN,73,Commision No
COLUMN,74,Delivery Date Veh
COLUMN,75,Reservation Date
COLUMN,76,Reservation Person
COLUMN,77,Reservation Text
COLUMN,78,Freight Balance
COLUMN,79,Trf Taxbasis Sales
COLUMN,80,Trf Taxbasis Purch
COLUMN,81,Sale Order No
COLUMN,82,Unit Sold
COLUMN,83,Trf Department
COLUMN,84,Order Arrival Date
COLUMN,85,Order Confirm Date
COLUMN,86,Price Label Date
COLUMN,87,Vat Table Work
COLUMN,88,Vat Table Normal
COLUMN,89,Vat Rate Code
COLUMN,90,Transfer Vat Rc
COLUMN,91,Cntract Due Date
COLUMN,92,Contract Date
COLUMN,93,Exp Arrival Time
COLUMN,94,Dealer Marking
COLUMN,95,Booking Dealer Nr
COLUMN,96,Desired Deliv Date
COLUMN,97,Valuation Date
COLUMN,98,Ford Int Date
COLUMN,99,Est Sales Price
COLUMN,100,Est Reference No
COLUMN,101,Reception Date
COLUMN,102,Bud Opt Price
COLUMN,103,Sale Price Date
COLUMN,104,Purch Origin Code
COLUMN,105,Price List Version
COLUMN,106,Price List Date
COLUMN,107,Unique Ident
COLUMN,108,Vehicle Type
COLUMN,109,Vehicle Type Text
COLUMN,110,ECC_Status_Text
COLUMN,111,Basis Number
COLUMN,112,Transact Date
COLUMN,113,Handler
COLUMN,114,Register Number
COLUMN,115,Chassis Number
COLUMN,116,Car Group
COLUMN,117,Car Status
COLUMN,118,Fac Model Code L
COLUMN,119,First Reg Date
COLUMN,120,Latest Reg Date
COLUMN,121,First Occur Date
COLUMN,122,Expected Arr Date
COLUMN,123,Arrival Date
COLUMN,124,Salesman Buy
COLUMN,125,Salesman Sale
COLUMN,126,Model Text
COLUMN,127,Orig Model Code1
COLUMN,128,Orig Model Code2
COLUMN,129,Colour Cf
COLUMN,130,Trim Txt
COLUMN,131,Model Line
COLUMN,132,Workshop Model
COLUMN,133,Fac Model Code S
COLUMN,134,Classification
COLUMN,135,Motor Number
COLUMN,136,Key Code
COLUMN,137,Year Model Cf
COLUMN,138,Cylinder Volume
COLUMN,139,Seats
COLUMN,140,Declaration Date
COLUMN,141,Declaration Place
COLUMN,142,Declaration Number
COLUMN,143,Equipment 1
COLUMN,144,Equipment 2
COLUMN,145,Equipment 3
COLUMN,146,Equipment 4
COLUMN,147,Mileage
COLUMN,148,Misc 1 Cf
COLUMN,149,Misc 2 Cf
COLUMN,150,Misc 3 Cf
COLUMN,151,Misc 4 Cf
COLUMN,152,Misc 5 Cf
COLUMN,153,Misc 6 Cf
COLUMN,154,Misc 7 Cf
COLUMN,155,Misc 8 Cf
COLUMN,156,Misc 9 Cf
COLUMN,157,Misc 10 Cf
COLUMN,158,Motor Code
COLUMN,159,Gear Code
COLUMN,160,Drive Code
COLUMN,161,Colour Code
COLUMN,162,Trim Code
COLUMN,163,No Of Owners
COLUMN,164,Tuv Type
COLUMN,165,Tuv Date
COLUMN,166,Tuv Insp
COLUMN,167,Asu Type
COLUMN,168,Asu Date
COLUMN,169,Asu Insp
COLUMN,170,Type Year
COLUMN,171,Available
COLUMN,172,Cal Cost
COLUMN,173,Cal Cost Date
COLUMN,174,Stock Date
COLUMN,175,Purch Cal Date
COLUMN,176,Model Line Group
COLUMN,177,Model Type 2
COLUMN,178,Make
COLUMN,179,Hour Rate Table
COLUMN,180,Paid Date
COLUMN,181,Latest Inv Date
COLUMN,182,Purch Amount
COLUMN,183,Dealer Number
COLUMN,184,Dealer Marking
COLUMN,185,Fueltype
COLUMN,186,Service Days
COLUMN,187,Hourly Repair Rate
COLUMN,188,Workshop Pricecode
COLUMN,189,Discount Perc Work
COLUMN,190,Soldmark Date
COLUMN,191,Make Cd
COLUMN,192,Model Line
COLUMN,193,Mod Lin Specify
COLUMN,194,Make Cd
COLUMN,195,Workshop Model
COLUMN,196,Make Cd
COLUMN,197,Model Text
COLUMN,198,Orig Model Code
COLUMN,199,Model Type
COLUMN,200,Model Group
COLUMN,201,Make Code
COLUMN,202,Hauptbetrieb
COLUMN,203,Standort
COLUMN,204,Department Type Id
COLUMN,205,Description
COLUMN,206,Fahrzeugart
COLUMN,207,Fabrikat_ori
COLUMN,208,Modellbez
COLUMN,209,Fahrgestellnr
COLUMN,210,Farbe
COLUMN,211,FZG
COLUMN,212,Fahrzeugtyp
COLUMN,213,Global Make Cd
COLUMN,214,Description
COLUMN,215,Einsatz
COLUMN,216,Menge
COLUMN,217,Heute
COLUMN,218,Standtage
COLUMN,219,Standtagestaffel
COLUMN,220,Car Letter
COLUMN,221,Fahrzeugart_Konsi
COLUMN,222,kalk_Kosten
COLUMN,223,Betrieb
COLUMN,224,Seller Code
COLUMN,225,Sel Name
COLUMN,226,VB_Einkauf
COLUMN,227,geplante Kosten
COLUMN,228,int. Aufw.
COLUMN,229,geplanter VK
COLUMN,230,Fabrikat_manuell
COLUMN,231,Hauptbetrieb_ID
COLUMN,232,Hauptbetrieb_Name
COLUMN,233,Standort_ID
COLUMN,234,Standort_Name
COLUMN,235,Fabrikat_GC_Marke
COLUMN,236,Fabrikat
COLUMN,237,Fabrikat_Order_By
COLUMN,238,Modell_Beschreibung
COLUMN,239,Model
COLUMN,240,Fahrzeugtyp_1
COLUMN,241,Standort_1
COLUMN,242,Lieferant/Einkäufer
COLUMN,243,Name_Lieferant
COLUMN,244,Name_Einkäufer
COLUMN,245,FZG_Einkäufer
COLUMN,246,EZ
COLUMN,247,Km-stand
COLUMN,248,Plan VK Netz brutto
COLUMN,249,Plan VK Netz netto
COLUMN,250,Plan Vk Platz brutto
COLUMN,251,Plan VK Platz netto
COLUMN,252,Invoice Date
COLUMN,253,FZG_Bestand_Dashboard
COLUMN,254,Status
COLUMN,255,Lager / verkauft