GAPS/Portal/System/IQD/NW/NW_AE.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,D:\Gaps\Portal\System\IQD\NW\NW_AE.imr
TITLE,NW_AE.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."BOOK_KEEPING_CODE" as c5,
	   T1."MILEAGE" as c6,
	   T1."PURCH_DEPARTMENT" as c7,
	   T1."PURCH_SALSMAN_CODE" as c8,
	   T1."PURCH_INVNO" as c9,
	   T1."PURCH_DATE" as c10,
	   T1."BUD_SALE_DET" as c11,
	   T1."BUD_PURCH_PRICE" as c12,
	   T1."BUD_REG_FEE" as c13,
	   T1."BUD_DEDUCT_FEE" as c14,
	   T1."BUD_COST" as c15,
	   T1."PREV_OWNER" as c16,
	   T1."PURCH_PRICE_UNIT" as c17,
	   T1."COST_UNIT" as c18,
	   T1."SALES_PRICE_UNIT" as c19,
	   T1."STOCK_DAYS" as c20,
	   T1."LOCATION_CODE" as c21,
	   T1."CONTRACT_DATE" as c22,
	   T1."RECEPTION_DATE" as c23,
	   T2."REGISTER_NUMBER" as c24,
	   T2."CHASSIS_NUMBER" as c25,
	   T2."CAR_GROUP" as c26,
	   T2."CAR_STATUS" as c27,
	   T2."FIRST_REG_DATE" as c28,
	   T2."ARRIVAL_DATE" as c29,
	   T2."MODEL_TEXT" as c30,
	   T2."COLOUR_CF" as c31,
	   T2."MODEL_LINE" as c32,
	   T2."WORKSHOP_MODEL" as c33,
	   T2."COLOUR_CODE" as c34,
	   T2."MAKE" as c35,
	   T2."MAKE_CD" as c36,
	   T3."MODEL_LINE" as c37,
	   T3."MOD_LIN_SPECIFY" as c38,
	   T3."MAKE_CD" as c39,
	   CASE WHEN (T1."ECC_STATUS" = '21') THEN ('21 - Vorlauf') WHEN (T1."ECC_STATUS" = '25') THEN ('25 - für Kd best. FZG') WHEN (T1."ECC_STATUS" = '41') THEN ('41 - Bestand') WHEN (T1."ECC_STATUS" = '44') THEN ('44 - am Hof nicht fakt.') WHEN (T1."ECC_STATUS" = '64') THEN ('64 - verkauft') ELSE null END as c40,
	   '1' as c41,
	   CASE WHEN (T1."LOCATION_CODE" IN ('GÖ        ','Gö        ')) THEN ('GÖ') ELSE (T1."LOCATION_CODE") END as c42,
	   CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','M','B','P','Q','W')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') WHEN (T1."VEHICLE_TYPE" IN ('G')) THEN ('Geschäftsfahrzeug') ELSE null END as c43,
	   T2."MAKE_CD" as c44,
	   T3."MOD_LIN_SPECIFY" as c45,
	   T2."MODEL_TEXT" as c46,
	   T2."CHASSIS_NUMBER" as c47,
	   T2."COLOUR_CODE" || '-' || T2."COLOUR_CF" as c48,
	   T1."UNIT_NUMBER" || T2."CHASSIS_NUMBER" as c49,
	   CASE WHEN (T1."VEHICLE_TYPE" IN ('N','P')) THEN ('N - Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('V','W','X')) THEN ('V - Vorführwagen') WHEN (T1."VEHICLE_TYPE" IN ('M','Y')) THEN ('M - Mietwagen/Opel Rent') WHEN (T1."VEHICLE_TYPE" IN ('R')) THEN ('R - GW regelbesteuert') WHEN (T1."VEHICLE_TYPE" IN ('D')) THEN ('D - GW §25A UStG') WHEN (T1."VEHICLE_TYPE" IN ('G')) THEN ('G - Geschäftsfahrzeug') WHEN (T1."VEHICLE_TYPE" IN ('T')) THEN ('T - Tageszulassung') ELSE null END as c50,
	   (now()) as c51,
	   CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END as c52,
	   CASE WHEN ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END) BETWEEN 0 AND 30) THEN ('0 - 30 Tage') WHEN ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END) BETWEEN 31 AND 60) THEN ('31 - 60 Tage') WHEN ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END) BETWEEN 61 AND 90) THEN ('61 - 90 Tage') WHEN ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END) BETWEEN 91 AND 180) THEN ('91 - 180 Tage') WHEN ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END) > 180) THEN ('> 180 Tage') ELSE null END as c53,
	   T1."PURCH_PRICE_UNIT" + T1."COST_UNIT" as c54,
	   1 as c55,
	   '' as c56,
	   T2."MOTOR_CODE" as c57,
	   (CASE WHEN (T1."LOCATION_CODE" IN ('GÖ        ','Gö        ')) THEN ('GÖ') ELSE (T1."LOCATION_CODE") END) as c58,
	   T1."COST_UNIT" as c59,
	   T1."BUD_COST" as c60,
	   T1."BUD_SALE_DET" as c61,
	   T2."DEALER_DEL_DATE" as c62,
	   CASE WHEN (T2."DEALER_DEL_DATE" <> TIMESTAMP '1800-01-01 00:00:00.000') THEN ((extract(DAY FROM ((now())) - T2."DEALER_DEL_DATE"))) ELSE ((CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM ((now())) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM ((now())) - T1."RECEPTION_DATE"))) END)) END as c63,
	   T4."SEL_NAME" as c64,
	   (asciiz(extract(YEAR FROM T2."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T2."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T2."FIRST_REG_DATE"),2)) as c65,
	   (substring(((asciiz(extract(YEAR FROM T2."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T2."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T2."FIRST_REG_DATE"),2))) from char_length(((asciiz(extract(YEAR FROM T2."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T2."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T2."FIRST_REG_DATE"),2)))) - 2 + 1 for 2)) || '.' || (substring(((asciiz(extract(YEAR FROM T2."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T2."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T2."FIRST_REG_DATE"),2))) from 6 for 2)) || '.' || (substring(((asciiz(extract(YEAR FROM T2."FIRST_REG_DATE"),4) || '-' || asciiz(extract(MONTH FROM T2."FIRST_REG_DATE"),2) || '-' || asciiz(extract(DAY FROM T2."FIRST_REG_DATE"),2))) from 1 for 4)) as c66,
	   (extract(DAY FROM (now()) - T2."FIRST_REG_DATE")) as c67,
	   CASE WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 0 AND 30) THEN ('0 - 30 Tage') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 31 AND 60) THEN ('31 - 60 Tage') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 61 AND 90) THEN ('61 - 90 Tage') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 91 AND 180) THEN ('91 - 180 Tage') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 181 AND 268) THEN ('> 181 - 268 Tage') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 0 AND 269) THEN ('kleiner 9 Monate') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) BETWEEN 270 AND 329) THEN (' 9  - 11 Monate') WHEN (((extract(DAY FROM (now()) - T2."FIRST_REG_DATE"))) > 330) THEN ('älter 11 Monate') ELSE null END as c68,
	   (od_left(T1."PURCH_DEPARTMENT",2)) as c69,
	   T1."UNIT_NUMBER" as c70,
	   T1."BASIS_NUMBER" as c71,
	   T1."ECC_STATUS" as c72,
	   T1."VEHICLE_TYPE" as c73,
	   T1."CATEGORY" as c74,
	   T1."CHAIN_NUMBER" as c75,
	   T1."STATE_CODE_UNIT" as c76,
	   T1."TRANSACT_DATE" as c77,
	   T1."HANDLER" as c78,
	   T1."CAR_CREATION_DATE" as c79,
	   T1."PMT_TERM" as c80,
	   T1."INVOICE_COPY_CODE" as c81,
	   T1."DELIVERY_WAY_CODE" as c82,
	   T1."SMALL_ACCESSORIES" as c83,
	   T1."SMALL_INV_CHARGE" as c84,
	   T1."DELIVERY_STOP_CODE" as c85,
	   T1."PRICE_CODE" as c86,
	   T1."DISCOUNT_PERC_WORK" as c87,
	   T1."DISCOUNT_LIMIT" as c88,
	   T1."INTERNAL_CODE" as c89,
	   T1."TAX_CODE" as c90,
	   T1."UNIT_LAST_UPD_DTE" as c91,
	   T1."DEPRECIATION" as c92,
	   T1."TRANSFER_TAX" as c93,
	   T1."BOOK_KEEPING_CODE" as c94,
	   T1."TAX_HANDLING" as c95,
	   T1."INTEREST_CODE" as c96,
	   T1."MILEAGE" as c97,
	   T1."PURCH_DEPARTMENT" as c98,
	   T1."PURCH_SALSMAN_CODE" as c99,
	   T1."PURCH_INVNO" as c100,
	   T1."PURCH_DATE" as c101,
	   T1."SALES_DEPARTMENT" as c102,
	   T1."SALE_SALESMAN" as c103,
	   T1."SALE_INV_NUMBER" as c104,
	   T1."SALE_DATE" as c105,
	   T1."SCRAP_CODE" as c106,
	   T1."UNIT_IN_CHANGE" as c107,
	   T1."BUD_SALE_DET" as c108,
	   T1."BUD_PURCH_PRICE" as c109,
	   T1."BUD_REG_FEE" as c110,
	   T1."BUD_DEDUCT_FEE" as c111,
	   T1."BUD_COST" as c112,
	   T1."PREV_OWNER" as c113,
	   T1."OWNER" as c114,
	   T1."PURCH_PRICE_UNIT" as c115,
	   T1."COST_UNIT" as c116,
	   T1."SALES_PRICE_UNIT" as c117,
	   T1."REG_FEE" as c118,
	   T1."INTEREST_1" as c119,
	   T1."INTEREST_2" as c120,
	   T1."NEXT_LINE_UNIT" as c121,
	   T1."NEXT_LINE_1" as c122,
	   T1."TRANSFER_LINE" as c123,
	   T1."TRANSFER_TAX_HAND" as c124,
	   T1."TRANSFER_ACC_CODE" as c125,
	   T1."TRANSFER_TAX_BASIS" as c126,
	   T1."TRANSFER_TAX_PCT" as c127,
	   T1."TRANSFER_SOLD" as c128,
	   T1."PURCH_TAX" as c129,
	   T1."COST_TAX" as c130,
	   T1."OR_MARK" as c131,
	   T1."TRANSFER_DATE" as c132,
	   T1."STOCK_DAYS" as c133,
	   T1."DELETE_PROPOSAL" as c134,
	   T1."TRANSFER_BBDB" as c135,
	   T1."CONDITION_UNIT" as c136,
	   T1."BUYING_ORDER_NO" as c137,
	   T1."BUYING_ORDER_DATE" as c138,
	   T1."PA_NUMBER" as c139,
	   T1."VEHICLE_UPDATE" as c140,
	   T1."LATEST_UPDATE" as c141,
	   T1."INVOICE_PERMISSION" as c142,
	   T1."LOCATION_CODE" as c143,
	   T1."ACCOUNT_PURCHASE" as c144,
	   T1."ACCOUNT_SALES" as c145,
	   T1."BUDG_PRICE_VAT" as c146,
	   T1."RECALC_CODE" as c147,
	   T1."COMMISION_NO" as c148,
	   T1."DELIVERY_DATE_VEH" as c149,
	   T1."RESERVATION_DATE" as c150,
	   T1."RESERVATION_PERSON" as c151,
	   T1."RESERVATION_TEXT" as c152,
	   T1."FREIGHT_BALANCE" as c153,
	   T1."TRF_TAXBASIS_SALES" as c154,
	   T1."TRF_TAXBASIS_PURCH" as c155,
	   T1."SALE_ORDER_NO" as c156,
	   T1."UNIT_SOLD" as c157,
	   T1."TRF_DEPARTMENT" as c158,
	   T1."ORDER_ARRIVAL_DATE" as c159,
	   T1."ORDER_CONFIRM_DATE" as c160,
	   T1."PRICE_LABEL_DATE" as c161,
	   T1."VAT_TABLE_WORK" as c162,
	   T1."VAT_TABLE_NORMAL" as c163,
	   T1."VAT_RATE_CODE" as c164,
	   T1."TRANSFER_VAT_RC" as c165,
	   T1."CNTRACT_DUE_DATE" as c166,
	   T1."CONTRACT_DATE" as c167,
	   T1."EXP_ARRIVAL_TIME" as c168,
	   T1."DEALER_MARKING" as c169,
	   T1."BOOKING_DEALER_NR" as c170,
	   T1."DESIRED_DELIV_DATE" as c171,
	   T1."VALUATION_DATE" as c172,
	   T1."NOVA_CALC_FLAG" as c173,
	   T1."NOVA_CALC_BASE" as c174,
	   T1."NOVA_PERCENT" as c175,
	   T1."NOVA_AMOUNT" as c176,
	   T1."NOVA_EXCEPT_CODE" as c177,
	   T1."NOVA_EXCEPT_TEXT" as c178,
	   T1."PID_TYPE" as c179,
	   T1."PID_NUMBER" as c180,
	   T1."PID_ISSUE_DATE" as c181,
	   T1."PID_ISSUE_AUTH" as c182,
	   T1."EXP_DESTINATION" as c183,
	   T1."ARGUS_PURCH_PRICE" as c184,
	   T1."ARGUS_SALES_PRICE" as c185,
	   T1."TRANSFER_BOOK_NO" as c186,
	   T1."SUB_DEALER_ID" as c187,
	   T1."CUST_COMPANY_NO" as c188,
	   T1."IQ_USED_VEHICLE" as c189,
	   T1."STOCK_VALUE_BPM" as c190,
	   T1."FORD_SUBTOTAL" as c191,
	   T1."FORD_INT_DATE" as c192,
	   T1."EST_SALES_PRICE" as c193,
	   T1."EST_REFERENCE_NO" as c194,
	   T1."OPT_VALID_DATE" as c195,
	   T1."WASTE_DISPOSAL_FEE" as c196,
	   T1."POLICE_REG_NUMBER" as c197,
	   T1."RECEPTION_DATE" as c198,
	   T1."BUD_OPT_PRICE" as c199,
	   T1."NOVA_AMOUNT_NEW" as c200,
	   T1."SALE_PRICE_DATE" as c201,
	   T1."VARIATION_PCT" as c202,
	   T1."POSTPONE_BOOKKEEPING" as c203,
	   T1."USED_VEH_DEST_CODE" as c204,
	   T1."PURCH_ORIGIN_CODE" as c205,
	   T1."PRICE_LIST_VERSION" as c206,
	   T1."PRICE_LIST_DATE" as c207,
	   T1."NOVA_MERIT_AMOUNT" as c208,
	   T1."TRANSFER_MARKETPLACE" as c209,
	   T1."CONV_FLAG" as c210,
	   T1."UNIQUE_IDENT" as c211,
	   T1."PRICE_VALUE_HOUSE" as c212,
	   T1."PRICE_VALUE_INTERNET" as c213,
	   T1."PURCH_DEPARTMENT" as c214
from ("deop01"."dbo"."UNIT_FILE" T1 left outer join "deop01"."dbo"."vPP43" T4 on T4."SELLER_CODE" = T1."PURCH_SALSMAN_CODE"),
	("deop01"."dbo"."VEHICLE_v" T2 left outer join "deop01"."dbo"."vPP5Q" T3 on (T2."MODEL_LINE" = T3."MODEL_LINE") and (T2."MAKE_CD" = T3."MAKE_CD"))
where (T1."BASIS_NUMBER" = T2."BASIS_NUMBER")
and (T1."ECC_STATUS" IN ('41','44'))
order by c52 desc

END SQL
COLUMN,0,Unit Number
COLUMN,1,Basis Number
COLUMN,2,Ecc Status
COLUMN,3,Vehicle Type
COLUMN,4,Book Keeping Code
COLUMN,5,Mileage
COLUMN,6,Purch Department
COLUMN,7,Purch Salsman Code
COLUMN,8,Purch Invno
COLUMN,9,Purch Date
COLUMN,10,Bud Sale Det
COLUMN,11,Bud Purch Price
COLUMN,12,Bud Reg Fee
COLUMN,13,Bud Deduct Fee
COLUMN,14,Bud Cost
COLUMN,15,Prev Owner
COLUMN,16,Purch Price Unit
COLUMN,17,Cost Unit
COLUMN,18,Sales Price Unit
COLUMN,19,Stock Days
COLUMN,20,Location Code
COLUMN,21,Contract Date
COLUMN,22,Reception Date
COLUMN,23,Register Number
COLUMN,24,Chassis Number
COLUMN,25,Car Group
COLUMN,26,Car Status
COLUMN,27,First Reg Date
COLUMN,28,Arrival Date
COLUMN,29,Model Text
COLUMN,30,Colour Cf
COLUMN,31,Model Line
COLUMN,32,Workshop Model
COLUMN,33,Colour Code
COLUMN,34,Make
COLUMN,35,Make Cd
COLUMN,36,Model Line
COLUMN,37,Mod Lin Specify
COLUMN,38,Make Cd
COLUMN,39,ECC_Status_Text
COLUMN,40,Hauptbetrieb
COLUMN,41,Standort
COLUMN,42,Fahrzeugart
COLUMN,43,Fabrikat
COLUMN,44,Model
COLUMN,45,Modellbez
COLUMN,46,Fahrgestellnr
COLUMN,47,Farbe
COLUMN,48,FZG
COLUMN,49,Fahrzeugtyp
COLUMN,50,Heute
COLUMN,51,Standtage_alt
COLUMN,52,Standtagestaffel
COLUMN,53,Einsatz
COLUMN,54,Menge
COLUMN,55,Fahrzeugart_Konsi
COLUMN,56,Motor Code
COLUMN,57,Betrieb
COLUMN,58,tatsächl. Kosten
COLUMN,59,geplante Kosten
COLUMN,60,geplanter VK
COLUMN,61,Dealer Del Date
COLUMN,62,Standtage
COLUMN,63,Einkäufer
COLUMN,64,EZ Zahl
COLUMN,65,EZ
COLUMN,66,Tage EZ
COLUMN,67,EZ Staffel
COLUMN,68,Standort_EK
COLUMN,69,Unit Number
COLUMN,70,Basis Number
COLUMN,71,Ecc Status
COLUMN,72,Vehicle Type
COLUMN,73,Category
COLUMN,74,Chain Number
COLUMN,75,State Code Unit
COLUMN,76,Transact Date
COLUMN,77,Handler
COLUMN,78,Car Creation Date
COLUMN,79,Pmt Term
COLUMN,80,Invoice Copy Code
COLUMN,81,Delivery Way Code
COLUMN,82,Small Accessories
COLUMN,83,Small Inv Charge
COLUMN,84,Delivery Stop Code
COLUMN,85,Price Code
COLUMN,86,Discount Perc Work
COLUMN,87,Discount Limit
COLUMN,88,Internal Code
COLUMN,89,Tax Code
COLUMN,90,Unit Last Upd Dte
COLUMN,91,Depreciation
COLUMN,92,Transfer Tax
COLUMN,93,Book Keeping Code
COLUMN,94,Tax Handling
COLUMN,95,Interest Code
COLUMN,96,Mileage
COLUMN,97,Purch Department
COLUMN,98,Purch Salsman Code
COLUMN,99,Purch Invno
COLUMN,100,Purch Date
COLUMN,101,Sales Department
COLUMN,102,Sale Salesman
COLUMN,103,Sale Inv Number
COLUMN,104,Sale Date
COLUMN,105,Scrap Code
COLUMN,106,Unit In Change
COLUMN,107,Bud Sale Det
COLUMN,108,Bud Purch Price
COLUMN,109,Bud Reg Fee
COLUMN,110,Bud Deduct Fee
COLUMN,111,Bud Cost
COLUMN,112,Prev Owner
COLUMN,113,Owner
COLUMN,114,Purch Price Unit
COLUMN,115,Cost Unit
COLUMN,116,Sales Price Unit
COLUMN,117,Reg Fee
COLUMN,118,Interest 1
COLUMN,119,Interest 2
COLUMN,120,Next Line Unit
COLUMN,121,Next Line 1
COLUMN,122,Transfer Line
COLUMN,123,Transfer Tax Hand
COLUMN,124,Transfer Acc Code
COLUMN,125,Transfer Tax Basis
COLUMN,126,Transfer Tax Pct
COLUMN,127,Transfer Sold
COLUMN,128,Purch Tax
COLUMN,129,Cost Tax
COLUMN,130,Or Mark
COLUMN,131,Transfer Date
COLUMN,132,Stock Days
COLUMN,133,Delete Proposal
COLUMN,134,Transfer Bbdb
COLUMN,135,Condition Unit
COLUMN,136,Buying Order No
COLUMN,137,Buying Order Date
COLUMN,138,Pa Number
COLUMN,139,Vehicle Update
COLUMN,140,Latest Update
COLUMN,141,Invoice Permission
COLUMN,142,Location Code
COLUMN,143,Account Purchase
COLUMN,144,Account Sales
COLUMN,145,Budg Price Vat
COLUMN,146,Recalc Code
COLUMN,147,Commision No
COLUMN,148,Delivery Date Veh
COLUMN,149,Reservation Date
COLUMN,150,Reservation Person
COLUMN,151,Reservation Text
COLUMN,152,Freight Balance
COLUMN,153,Trf Taxbasis Sales
COLUMN,154,Trf Taxbasis Purch
COLUMN,155,Sale Order No
COLUMN,156,Unit Sold
COLUMN,157,Trf Department
COLUMN,158,Order Arrival Date
COLUMN,159,Order Confirm Date
COLUMN,160,Price Label Date
COLUMN,161,Vat Table Work
COLUMN,162,Vat Table Normal
COLUMN,163,Vat Rate Code
COLUMN,164,Transfer Vat Rc
COLUMN,165,Cntract Due Date
COLUMN,166,Contract Date
COLUMN,167,Exp Arrival Time
COLUMN,168,Dealer Marking
COLUMN,169,Booking Dealer Nr
COLUMN,170,Desired Deliv Date
COLUMN,171,Valuation Date
COLUMN,172,Nova Calc Flag
COLUMN,173,Nova Calc Base
COLUMN,174,Nova Percent
COLUMN,175,Nova Amount
COLUMN,176,Nova Except Code
COLUMN,177,Nova Except Text
COLUMN,178,Pid Type
COLUMN,179,Pid Number
COLUMN,180,Pid Issue Date
COLUMN,181,Pid Issue Auth
COLUMN,182,Exp Destination
COLUMN,183,Argus Purch Price
COLUMN,184,Argus Sales Price
COLUMN,185,Transfer Book No
COLUMN,186,Sub Dealer Id
COLUMN,187,Cust Company No
COLUMN,188,Iq Used Vehicle
COLUMN,189,Stock Value Bpm
COLUMN,190,Ford Subtotal
COLUMN,191,Ford Int Date
COLUMN,192,Est Sales Price
COLUMN,193,Est Reference No
COLUMN,194,Opt Valid Date
COLUMN,195,Waste Disposal Fee
COLUMN,196,Police Reg Number
COLUMN,197,Reception Date
COLUMN,198,Bud Opt Price
COLUMN,199,Nova Amount New
COLUMN,200,Sale Price Date
COLUMN,201,Variation Pct
COLUMN,202,Postpone Bookkeeping
COLUMN,203,Used Veh Dest Code
COLUMN,204,Purch Origin Code
COLUMN,205,Price List Version
COLUMN,206,Price List Date
COLUMN,207,Nova Merit Amount
COLUMN,208,Transfer Marketplace
COLUMN,209,Conv Flag
COLUMN,210,Unique Ident
COLUMN,211,Price Value House
COLUMN,212,Price Value Internet
COLUMN,213,Einkaufs KST