12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627 |
- Kataloginformationen
- Katalog-Dateiname: C:\GlobalCube\System\OPTIMA\Catalogs\NWGW_neu.cat
- Beschreibung:
- Datenbankinformationen
- Datenbankname: O21
- Verbindungszeichenkette: Provider=SQL Server Native Client 11.0;User ID=%s;Password=%s;Data Source=LOCALHOST\GLOBALCUBE;Provider_String=Initial Catalog=OPTIMA@COLSEQ=
- Datenbankstruktur
- Table: UNIT_FILE
- Spalte: UNIT_NUMBER (char)
- Spalte: BASIS_NUMBER (char)
- Spalte: ECC_STATUS (char)
- Spalte: VEHICLE_TYPE (char)
- Spalte: CATEGORY (char)
- Spalte: CHAIN_NUMBER (decimal)
- Spalte: STATE_CODE_UNIT (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: CAR_CREATION_DATE (datetime)
- Spalte: PMT_TERM (char)
- Spalte: INVOICE_COPY_CODE (char)
- Spalte: DELIVERY_WAY_CODE (char)
- Spalte: SMALL_ACCESSORIES (char)
- Spalte: SMALL_INV_CHARGE (char)
- Spalte: DELIVERY_STOP_CODE (char)
- Spalte: PRICE_CODE (char)
- Spalte: DISCOUNT_PERC_WORK (decimal)
- Spalte: DISCOUNT_LIMIT (char)
- Spalte: INTERNAL_CODE (char)
- Spalte: TAX_CODE (char)
- Spalte: UNIT_LAST_UPD_DTE (datetime)
- Spalte: DEPRECIATION (decimal)
- Spalte: TRANSFER_TAX (decimal)
- Spalte: BOOK_KEEPING_CODE (char)
- Spalte: TAX_HANDLING (char)
- Spalte: INTEREST_CODE (char)
- Spalte: MILEAGE (decimal)
- Spalte: PURCH_DEPARTMENT (char)
- Spalte: PURCH_SALSMAN_CODE (char)
- Spalte: PURCH_INVNO (char)
- Spalte: PURCH_DATE (datetime)
- Spalte: SALES_DEPARTMENT (char)
- Spalte: SALE_SALESMAN (char)
- Spalte: SALE_INV_NUMBER (char)
- Spalte: SALE_DATE (datetime)
- Spalte: SCRAP_CODE (char)
- Spalte: UNIT_IN_CHANGE (char)
- Spalte: BUD_SALE_DET (decimal)
- Spalte: BUD_PURCH_PRICE (decimal)
- Spalte: BUD_REG_FEE (decimal)
- Spalte: BUD_DEDUCT_FEE (decimal)
- Spalte: BUD_COST (decimal)
- Spalte: PREV_OWNER (varchar)
- Spalte: OWNER (varchar)
- Spalte: PURCH_PRICE_UNIT (decimal)
- Spalte: COST_UNIT (decimal)
- Spalte: SALES_PRICE_UNIT (decimal)
- Spalte: REG_FEE (decimal)
- Spalte: INTEREST_1 (decimal)
- Spalte: INTEREST_2 (decimal)
- Spalte: NEXT_LINE_UNIT (decimal)
- Spalte: NEXT_LINE_1 (decimal)
- Spalte: TRANSFER_LINE (decimal)
- Spalte: TRANSFER_TAX_HAND (char)
- Spalte: TRANSFER_ACC_CODE (char)
- Spalte: TRANSFER_TAX_BASIS (decimal)
- Spalte: TRANSFER_TAX_PCT (decimal)
- Spalte: TRANSFER_SOLD (char)
- Spalte: PURCH_TAX (decimal)
- Spalte: COST_TAX (decimal)
- Spalte: OR_MARK (char)
- Spalte: TRANSFER_DATE (datetime)
- Spalte: STOCK_DAYS (char)
- Spalte: DELETE_PROPOSAL (char)
- Spalte: TRANSFER_BBDB (datetime)
- Spalte: CONDITION_UNIT (char)
- Spalte: BUYING_ORDER_NO (char)
- Spalte: BUYING_ORDER_DATE (datetime)
- Spalte: PA_NUMBER (char)
- Spalte: VEHICLE_UPDATE (char)
- Spalte: LATEST_UPDATE (datetime)
- Spalte: INVOICE_PERMISSION (char)
- Spalte: LOCATION_CODE (char)
- Spalte: ACCOUNT_PURCHASE (char)
- Spalte: ACCOUNT_SALES (char)
- Spalte: BUDG_PRICE_VAT (char)
- Spalte: RECALC_CODE (char)
- Spalte: COMMISION_NO (char)
- Spalte: DELIVERY_DATE_VEH (datetime)
- Spalte: RESERVATION_DATE (datetime)
- Spalte: RESERVATION_PERSON (char)
- Spalte: RESERVATION_TEXT (varchar)
- Spalte: FREIGHT_BALANCE (decimal)
- Spalte: TRF_TAXBASIS_SALES (decimal)
- Spalte: TRF_TAXBASIS_PURCH (decimal)
- Spalte: SALE_ORDER_NO (char)
- Spalte: UNIT_SOLD (char)
- Spalte: TRF_DEPARTMENT (char)
- Spalte: ORDER_ARRIVAL_DATE (datetime)
- Spalte: ORDER_CONFIRM_DATE (datetime)
- Spalte: PRICE_LABEL_DATE (datetime)
- Spalte: VAT_TABLE_WORK (char)
- Spalte: VAT_TABLE_NORMAL (char)
- Spalte: VAT_RATE_CODE (char)
- Spalte: TRANSFER_VAT_RC (char)
- Spalte: CNTRACT_DUE_DATE (datetime)
- Spalte: CONTRACT_DATE (datetime)
- Spalte: EXP_ARRIVAL_TIME (char)
- Spalte: DEALER_MARKING (char)
- Spalte: BOOKING_DEALER_NR (char)
- Spalte: DESIRED_DELIV_DATE (datetime)
- Spalte: VALUATION_DATE (datetime)
- Spalte: NOVA_CALC_FLAG (char)
- Spalte: NOVA_CALC_BASE (char)
- Spalte: NOVA_PERCENT (decimal)
- Spalte: NOVA_AMOUNT (decimal)
- Spalte: NOVA_EXCEPT_CODE (char)
- Spalte: NOVA_EXCEPT_TEXT (varchar)
- Spalte: PID_TYPE (varchar)
- Spalte: PID_NUMBER (varchar)
- Spalte: PID_ISSUE_DATE (datetime)
- Spalte: PID_ISSUE_AUTH (varchar)
- Spalte: EXP_DESTINATION (char)
- Spalte: ARGUS_PURCH_PRICE (decimal)
- Spalte: ARGUS_SALES_PRICE (decimal)
- Spalte: TRANSFER_BOOK_NO (char)
- Spalte: SUB_DEALER_ID (varchar)
- Spalte: CUST_COMPANY_NO (char)
- Spalte: IQ_USED_VEHICLE (char)
- Spalte: STOCK_VALUE_BPM (decimal)
- Spalte: FORD_SUBTOTAL (decimal)
- Spalte: FORD_INT_DATE (datetime)
- Spalte: EST_SALES_PRICE (decimal)
- Spalte: EST_REFERENCE_NO (varchar)
- Spalte: OPT_VALID_DATE (datetime)
- Spalte: WASTE_DISPOSAL_FEE (decimal)
- Spalte: POLICE_REG_NUMBER (decimal)
- Spalte: RECEPTION_DATE (datetime)
- Spalte: BUD_OPT_PRICE (decimal)
- Spalte: NOVA_AMOUNT_NEW (decimal)
- Spalte: SALE_PRICE_DATE (datetime)
- Spalte: VARIATION_PCT (decimal)
- Spalte: POSTPONE_BOOKKEEPING (char)
- Spalte: USED_VEH_DEST_CODE (char)
- Spalte: PURCH_ORIGIN_CODE (char)
- Spalte: PRICE_LIST_VERSION (char)
- Spalte: PRICE_LIST_DATE (datetime)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: NOVA_MERIT_AMOUNT (decimal)
- Spalte: PRICE_VALUE_HOUSE (decimal)
- Spalte: PRICE_VALUE_INTERNET (decimal)
- Spalte: TRANSFER_MARKETPLACE (tinyint)
- Spalte: DEALER_PRICE (decimal)
- Spalte: DRIVER_DEMO (varchar)
- Spalte: LOWEST_SALESPRICE (decimal)
- Spalte: SALES_PROGRAM (varchar)
- Spalte: TEXT_INTERNET (varchar)
- Spalte: CLIENT_DB (varchar)
- Table: UNIT_HISTORY
- Spalte: UNIT_NUMBER (char)
- Spalte: LINE_TYPE (char)
- Spalte: LINE_NO (decimal)
- Spalte: STATE_CODE_UNIT (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: DOCUMENT_DATE (datetime)
- Spalte: DOCUMENT_NR (decimal)
- Spalte: ORDER_DATE (datetime)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: TRANSACTION_CODE (char)
- Spalte: TAX_CODE (char)
- Spalte: REFERENCE (varchar)
- Spalte: COSTS (decimal)
- Spalte: PURCH_TAX (decimal)
- Spalte: ORDERS_GROSSVALUE (decimal)
- Spalte: TAX_SHARE (decimal)
- Spalte: DISCOUNT (decimal)
- Spalte: CLASSIFICATION_DTE (datetime)
- Spalte: BOOK_KEEPING_CODE (char)
- Spalte: TAX_HANDLING (char)
- Spalte: TRANSFER_TAX_PCT (decimal)
- Spalte: TRANSFER_DATE (datetime)
- Spalte: TRANSFER_SALES_TAX (decimal)
- Spalte: TRANSFER_PURCH_TAX (decimal)
- Spalte: DEPARTMENT (char)
- Spalte: BOOK_NO (char)
- Spalte: PURCH_INVNO (char)
- Spalte: BATCH_NUMBER_S (decimal)
- Spalte: SETOFF_ACCT (char)
- Spalte: INT_EXT_CODE (char)
- Spalte: DESTINATION (char)
- Spalte: OWN_DIMENSION_1 (varchar)
- Spalte: OWN_DIMENSION_2 (varchar)
- Spalte: OWN_DIMENSION_3 (varchar)
- Spalte: OWN_DIMENSION_4 (varchar)
- Spalte: OWN_DIMENSION_5 (varchar)
- Spalte: ACTIVITY (char)
- Spalte: VAT_RATE_CODE (char)
- Spalte: CALC_RULE_SYSTEM (decimal)
- Spalte: ACC_AMOUNT_TYPE (decimal)
- Spalte: TRANSACT_CODE_REV (char)
- Spalte: INT_VOUCHER_NO (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VEHICLE
- Spalte: BASIS_NUMBER (char)
- Spalte: STATE_CODE_CF (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DEBIT_ACCOUNT (char)
- Spalte: REGISTER_NUMBER (char)
- Spalte: CHASSIS_NUMBER (varchar)
- Spalte: CAR_GROUP (char)
- Spalte: CAR_STATUS (char)
- Spalte: FAC_MODEL_CODE_L (varchar)
- Spalte: USER_CODE (char)
- Spalte: OWNER_CODE (char)
- Spalte: UNIT_ACCOUNTING_CF (char)
- Spalte: CONTACT_PERSON (varchar)
- Spalte: FIRST_REG_DATE (datetime)
- Spalte: LATEST_REG_DATE (datetime)
- Spalte: FIRST_OCCUR_DATE (datetime)
- Spalte: EXPECTED_ARR_DATE (datetime)
- Spalte: ARRIVAL_DATE (datetime)
- Spalte: LAST_OWNER_CHANGE (datetime)
- Spalte: SALESMAN_BUY (char)
- Spalte: SALESMAN_SALE (char)
- Spalte: MODEL_TEXT (varchar)
- Spalte: ORIG_MODEL_CODE1 (varchar)
- Spalte: ORIG_MODEL_CODE2 (varchar)
- Spalte: COLOUR_CF (varchar)
- Spalte: TRIM_TXT (varchar)
- Spalte: MODEL_LINE (char)
- Spalte: WORKSHOP_MODEL (char)
- Spalte: FAC_MODEL_CODE_S (varchar)
- Spalte: CLASSIFICATION (char)
- Spalte: MOTOR_NUMBER (varchar)
- Spalte: KEY_CODE (varchar)
- Spalte: YEAR_MODEL_CF (char)
- Spalte: CYLINDER_VOLUME (decimal)
- Spalte: SEATS (char)
- Spalte: DECLARATION_DATE (datetime)
- Spalte: DECLARATION_PLACE (char)
- Spalte: DECLARATION_NUMBER (char)
- Spalte: ARRIVAL_SHIP (varchar)
- Spalte: ARRIVAL_NUMBER (char)
- Spalte: BILL_OF_LANDING (char)
- Spalte: SCRUTINEERING_DATE (datetime)
- Spalte: EQUIPMENT_1 (varchar)
- Spalte: EQUIPMENT_2 (varchar)
- Spalte: EQUIPMENT_3 (varchar)
- Spalte: EQUIPMENT_4 (varchar)
- Spalte: INSURANCE (varchar)
- Spalte: INSURANCE_COMPANY (varchar)
- Spalte: MILEAGE (decimal)
- Spalte: MISC_1_CF (varchar)
- Spalte: MISC_2_CF (varchar)
- Spalte: MISC_3_CF (varchar)
- Spalte: MISC_4_CF (char)
- Spalte: MISC_5_CF (char)
- Spalte: MISC_6_CF (char)
- Spalte: MISC_7_CF (char)
- Spalte: MISC_8_CF (char)
- Spalte: MISC_9_CF (char)
- Spalte: MISC_10_CF (char)
- Spalte: LAST_INVOICE_DTE (datetime)
- Spalte: CONTACT_DATE (datetime)
- Spalte: MAIL_CODE_1 (char)
- Spalte: MAIL_CODE_2 (char)
- Spalte: MAIL_CODE_3 (char)
- Spalte: MAIL_CODE_4 (char)
- Spalte: MAIL_CODE_5 (char)
- Spalte: MAIL_CODE_6 (char)
- Spalte: MAIL_CODE_7 (char)
- Spalte: MAIL_CODE_8 (char)
- Spalte: MAIL_CODE_9 (char)
- Spalte: MOTOR_CODE (varchar)
- Spalte: GEAR_CODE (varchar)
- Spalte: DRIVE_CODE (char)
- Spalte: COLOUR_CODE (varchar)
- Spalte: TRIM_CODE (varchar)
- Spalte: LATEST_UNIT_NO (char)
- Spalte: FOLLOW_UP (char)
- Spalte: NO_OF_OWNERS (decimal)
- Spalte: CAR_LETTER (char)
- Spalte: TUV_TYPE (char)
- Spalte: TUV_DATE (datetime)
- Spalte: TUV_INSP (char)
- Spalte: ASU_TYPE (char)
- Spalte: ASU_DATE (datetime)
- Spalte: ASU_INSP (char)
- Spalte: TYPE_YEAR (char)
- Spalte: PACKAGE_CF (char)
- Spalte: VEH_ASS_TYPE (char)
- Spalte: SALE_THIS_YEAR (decimal)
- Spalte: SALE_LAST_YEAR (decimal)
- Spalte: SALE_LAST_YEAR_1 (decimal)
- Spalte: DELETE_PROPOSAL (char)
- Spalte: DUPLICATE_REG_NO (char)
- Spalte: LEASING (char)
- Spalte: SHIP_DATE (datetime)
- Spalte: FAC_ORDER_NUMBER (char)
- Spalte: AVAILABLE (char)
- Spalte: CAL_COST (char)
- Spalte: CAL_COST_DATE (datetime)
- Spalte: RUN_1 (char)
- Spalte: RUN_2 (char)
- Spalte: RUN_3 (char)
- Spalte: RUN_4 (char)
- Spalte: RUN_5 (char)
- Spalte: RUN_6 (char)
- Spalte: RUN_7 (char)
- Spalte: RUN_8 (char)
- Spalte: RUN_9 (char)
- Spalte: RUN_10 (char)
- Spalte: RUN_11 (char)
- Spalte: RUN_12 (char)
- Spalte: RUN_13 (char)
- Spalte: RUN_14 (char)
- Spalte: RUN_15 (char)
- Spalte: RUN_16 (char)
- Spalte: RUN_17 (char)
- Spalte: RUN_18 (char)
- Spalte: RUN_19 (char)
- Spalte: RUN_20 (char)
- Spalte: STOCK_DATE (datetime)
- Spalte: MARKING_1 (char)
- Spalte: MARKING_2 (char)
- Spalte: MARKING_3 (char)
- Spalte: MARKING_4 (char)
- Spalte: MARKING_5 (char)
- Spalte: IMP_ORDER_NUMBER (char)
- Spalte: SCRAP_DATE (datetime)
- Spalte: TRANSMISSION_DATE (datetime)
- Spalte: PURCH_CAL_DATE (datetime)
- Spalte: SALES_CAL_DATE (datetime)
- Spalte: DEALER_DEL_DATE (datetime)
- Spalte: OPTIONAL_DATE_1 (datetime)
- Spalte: OPTIONAL_DATE_2 (datetime)
- Spalte: OPTIONAL_DATE_3 (datetime)
- Spalte: OPTIONAL_DATE_4 (datetime)
- Spalte: OPTIONAL_DATE_5 (datetime)
- Spalte: MODEL_LINE_GROUP (char)
- Spalte: MODEL_TYPE_2 (char)
- Spalte: MAKE (char)
- Spalte: HOUR_RATE_TABLE (char)
- Spalte: PAID_DATE (datetime)
- Spalte: LATEST_INV_DATE (datetime)
- Spalte: ORIG_INV_DATE (datetime)
- Spalte: CREDIT_NOTE_DATE (datetime)
- Spalte: EXTRACTION_DATE (datetime)
- Spalte: PROD_INFO (varchar)
- Spalte: REG_NUMBER_IMP (char)
- Spalte: PRICE_CARD (char)
- Spalte: PURCH_AMOUNT (decimal)
- Spalte: DEALER_NUMBER (char)
- Spalte: INVOICE_STATE (char)
- Spalte: VEH_DUE_DATE (datetime)
- Spalte: DEALER_MARKING (char)
- Spalte: TRADE_IN_CAR (varchar)
- Spalte: TRADE_IN_CAR_YEAR (decimal)
- Spalte: EXPORT_VEHICLE (char)
- Spalte: DOORS (decimal)
- Spalte: KBA_CODE (char)
- Spalte: FUELTYPE (char)
- Spalte: FUEL_CONS_TOWN (decimal)
- Spalte: FUEL_CONS_90KMH (decimal)
- Spalte: FUEL_CONS_EUNORM (decimal)
- Spalte: CALL_FOR_SERVICE (char)
- Spalte: EXP_KM_PER_YEAR (decimal)
- Spalte: EXP_SERVICE_DATE_1 (datetime)
- Spalte: EXP_SERVICE_DATE_2 (datetime)
- Spalte: EXP_SERVICE_DATE_3 (datetime)
- Spalte: EXP_SERVICE_DATE_4 (datetime)
- Spalte: EXP_SERVICE_DATE_5 (datetime)
- Spalte: DEALER_MESSAGE_NO (char)
- Spalte: SERVICE_DAYS (decimal)
- Spalte: HOURLY_REPAIR_RATE (decimal)
- Spalte: WORKSHOP_PRICECODE (char)
- Spalte: DISCOUNT_PERC_WORK (decimal)
- Spalte: SOLDMARK_DATE (datetime)
- Spalte: MOBIL_SC_DATE (datetime)
- Spalte: TYPE_CER_TXT (varchar)
- Spalte: MAKE_CD (char)
- Spalte: VEH_LOCATION (char)
- Spalte: IMP_COMMENT (varchar)
- Spalte: DEALER_NOTE (varchar)
- Spalte: DELIVER_TO_DEALER (char)
- Spalte: TRADE_IN_CAR_CHAS (varchar)
- Spalte: GMS_REFERENCE (varchar)
- Spalte: USE_OF_VEHICLE (char)
- Spalte: PAINT_TYPE (char)
- Spalte: GEAR_NO (varchar)
- Spalte: SERV_CONTRACT_NO (varchar)
- Spalte: PRODUCTION_NO (varchar)
- Spalte: PHOTO (varchar)
- Spalte: UPLOAD_MARKING (char)
- Spalte: DOOR_CODE (char)
- Spalte: BPM_AMOUNT (decimal)
- Spalte: RADIO_CODE (varchar)
- Spalte: WARRENTY_END (datetime)
- Spalte: LAST_MOT_DATE (datetime)
- Spalte: LAST_SERVICE_DATE (datetime)
- Spalte: LAST_SERVICE_TXT (varchar)
- Spalte: REPLACEMENT_DATE (datetime)
- Spalte: NEXT_SERVICE_TXT (varchar)
- Spalte: MAINTAIN_INT_YEARS (decimal)
- Spalte: MAINTAIN_INT_MILES (decimal)
- Spalte: SALES_LOCATION (char)
- Spalte: SERVICE_LOCATION (char)
- Spalte: FISCAL_HORSEPOWER (decimal)
- Spalte: EXPORT_EUROCASION (char)
- Spalte: HORSEPOWER (decimal)
- Spalte: GOV_CERT_REQUEST_DATE (datetime)
- Spalte: GOV_CERT_RECEPTION_DATE (datetime)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP43
- Spalte: SELLER_CODE (varchar)
- Spalte: ORDER_APPROV_PERM (varchar)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SEL_NAME (varchar)
- Spalte: SEL_DEPARTMENT (char)
- Spalte: SEL_FIRST_NAME (varchar)
- Spalte: SEL_FAMILY_NAME (varchar)
- Spalte: SEL_TITLE (char)
- Spalte: SEL_MALE_FEMALE (int)
- Spalte: SEL_FACTOR (decimal)
- Spalte: SEL_COM_SALESMAN (int)
- Spalte: MECHANIC_PAY_GROUP (char)
- Spalte: LICENCE_ID (char)
- Spalte: EMPLOYEE_CATEGORY (decimal)
- Spalte: TRAINEE_YEAR (decimal)
- Spalte: EMAIL_ADDRESS (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: CUSTOMER
- Spalte: CUSTOMER_NUMBER (char)
- Spalte: STATE_CODE_CUST (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: CUST_ALT_KEY (char)
- Spalte: NAME (varchar)
- Spalte: STREET_ADDR (varchar)
- Spalte: ADDR_2 (varchar)
- Spalte: MAIL_ADDR (varchar)
- Spalte: ZIPCODE (char)
- Spalte: DEBIT_CUSTOMER (char)
- Spalte: TITLE_CODE (char)
- Spalte: TITLE (varchar)
- Spalte: PMT_TERM (char)
- Spalte: INVOICE_COPY_CODE (char)
- Spalte: DELIVERY_WAY_CODE (char)
- Spalte: SMALL_ACCESSORIES (char)
- Spalte: SMALL_INV_CHARGE (char)
- Spalte: WORKSHOP_PRICECODE (char)
- Spalte: VAT_REGNO (varchar)
- Spalte: SALESMAN (char)
- Spalte: GROSS_DISCOUNT (char)
- Spalte: DELIVERY_STOP_CODE (char)
- Spalte: CREDIT_LIMIT (decimal)
- Spalte: REMINDER_CODE (char)
- Spalte: ACCOUNT_TYPE_CU (char)
- Spalte: ACCOUNT_PRINT (char)
- Spalte: BANK_NAME (varchar)
- Spalte: BANK_REG_NO (char)
- Spalte: BANK_ACCOUNT_NO (varchar)
- Spalte: PAYMENT_WAY (char)
- Spalte: PRICE_CODE (char)
- Spalte: DISCOUNT_PERC_WORK (decimal)
- Spalte: DISCOUNT_LIMIT (char)
- Spalte: ANNUAL_DISC_PERC (decimal)
- Spalte: ANNUAL_DISC_AMOUNT (decimal)
- Spalte: ANNUAL_DISC_CODE (char)
- Spalte: ADVERT_DISC_PERC (decimal)
- Spalte: ADVERT_DISC_AMOUNT (decimal)
- Spalte: INTERNAL_CODE_CUST (char)
- Spalte: CUSTOMER_GROUP (char)
- Spalte: CUSTOMER_PROSPECT (char)
- Spalte: TAX_CODE (char)
- Spalte: FLEET_OWNER (char)
- Spalte: CONTACT_PERSON (varchar)
- Spalte: PHONE_1 (varchar)
- Spalte: PHONE_2 (varchar)
- Spalte: COMMENT_1 (varchar)
- Spalte: COMMENT_2 (varchar)
- Spalte: CONTACT_DATE (datetime)
- Spalte: MAIL_CODE_1 (char)
- Spalte: MAIL_CODE_2 (char)
- Spalte: MAIL_CODE_3 (char)
- Spalte: MAIL_CODE_4 (char)
- Spalte: MAIL_CODE_5 (char)
- Spalte: MAIL_CODE_6 (char)
- Spalte: MAIL_CODE_7 (char)
- Spalte: MAIL_CODE_8 (char)
- Spalte: MAIL_CODE_9 (char)
- Spalte: LAST_INVOICE_DATE (datetime)
- Spalte: PROFIT_C_U (decimal)
- Spalte: DEBITED_MM_CUST (decimal)
- Spalte: DEBITED_TY_CUST (decimal)
- Spalte: DEBITED_PRYE_CUST (decimal)
- Spalte: DISCOUNT_MM_CUST (decimal)
- Spalte: DISCOUNT_TY_CUST (decimal)
- Spalte: DISCOUNT_PY_CUST (decimal)
- Spalte: MARG_MM_CUST (decimal)
- Spalte: MARG_TY_CUST (decimal)
- Spalte: MARG_PY_CUST (decimal)
- Spalte: SALDO_C_U_CUST (decimal)
- Spalte: LAST_PMT_DTE_CUST (datetime)
- Spalte: PMT_TIME_CUST (decimal)
- Spalte: INTERESTS (decimal)
- Spalte: SALDO_LAST_ST (decimal)
- Spalte: AOS_DEAL_NUMBER (char)
- Spalte: CPR_NUMBER (decimal)
- Spalte: DELETE_PROPOSAL (char)
- Spalte: CREATION_DATE (datetime)
- Spalte: CREATER (char)
- Spalte: REDUCTION_CODE (char)
- Spalte: START_NO (decimal)
- Spalte: LAST_NO (decimal)
- Spalte: LATEST_PERIOD (datetime)
- Spalte: REMINDER_GROUP (char)
- Spalte: REMINDER_DATE (datetime)
- Spalte: PMT_TERMCODE_2 (char)
- Spalte: BACK_ORDER_DELIV (char)
- Spalte: COUNTRY_CODE_CU (char)
- Spalte: INSTALMENT_CODE (decimal)
- Spalte: FOLLOW_UP_CU (char)
- Spalte: VAT_TABLE_WORK (char)
- Spalte: VAT_TABLE_NORMAL (char)
- Spalte: VAT_TABLE (char)
- Spalte: OCCUPATION_CODE (char)
- Spalte: TELEFAX_NUMBER (varchar)
- Spalte: LANGUAGE_CODE (char)
- Spalte: BIRTHDAY (datetime)
- Spalte: BIRTHDAY2 (datetime)
- Spalte: ADDR_3 (varchar)
- Spalte: COUNTY (varchar)
- Spalte: MAX_BOOKING_DAYS (decimal)
- Spalte: DEPARTMENT_5 (decimal)
- Spalte: RIB_KEY (decimal)
- Spalte: PRICE_A_G (char)
- Spalte: REQ_NO_COMPULSORY (char)
- Spalte: VAT_REGNO_EU (varchar)
- Spalte: WORKSHOP_SALESMAN (char)
- Spalte: HOURLY_REPAIR_RATE (decimal)
- Spalte: ELEC_INVOICE (char)
- Spalte: ELEC_DEL_NOTE (char)
- Spalte: ELEC_ORDER_CONF (char)
- Spalte: ELEC_INVOICE_FORM (char)
- Spalte: ELEC_COLL_INV_FORM (char)
- Spalte: ELEC_DEL_NOTE_FORM (char)
- Spalte: ELEC_ORD_CONF_FORM (char)
- Spalte: ONLY_COLL_INVOICE (char)
- Spalte: CUST_COMPANY_NO (char)
- Spalte: DEALER_NUMBER (char)
- Spalte: MOBILE_PHONE (varchar)
- Spalte: MOBILE_PHONE_2 (varchar)
- Spalte: E_MAIL_ADDRESS (varchar)
- Spalte: E_MAIL_ADDRESS_2 (varchar)
- Spalte: BRANCH (char)
- Spalte: DECLARATION_STATE (char)
- Spalte: USE_WORK_TYPE_CODE (char)
- Spalte: FLEET_ID_NUMBER (char)
- Spalte: FIRST_NAME (varchar)
- Spalte: LAST_NAME (varchar)
- Spalte: GENDER (char)
- Spalte: COMPANY (char)
- Spalte: MAIL_SUPPRESS (char)
- Spalte: PO_BOX_15 (varchar)
- Spalte: PO_BOX_ZIPCODE (char)
- Spalte: PO_BOX_TOWN (varchar)
- Spalte: WEB_ADDRESS (varchar)
- Spalte: FAMILY_STATUS (char)
- Spalte: CHILDREN (decimal)
- Spalte: HOBBY (varchar)
- Spalte: EXT_CUSTOMER_GROUP (char)
- Spalte: MEMBERSHIP_NUMBER (varchar)
- Spalte: TRADE_REGISTER (varchar)
- Spalte: PDF_INVOICE (char)
- Spalte: E_COMMERCE_VEH (char)
- Spalte: E_MAIL_ADDRESS_3 (varchar)
- Spalte: SEND_ORDER_ADVICE (char)
- Spalte: SALES_LOCATION (char)
- Spalte: SERVICE_LOCATION (char)
- Spalte: STREET_NUMBER (decimal)
- Spalte: STREET_NUMBER_EXT (char)
- Spalte: STREET_NUMBER_EXT2 (char)
- Spalte: MAIL_ADDR_2 (varchar)
- Spalte: COUNTY_2 (varchar)
- Spalte: EXTERNAL_ID (decimal)
- Spalte: LICENSE_NUMBER (varchar)
- Spalte: STREET_NUMBER_2 (decimal)
- Spalte: V5_CUSTOMER_TYPE (varchar)
- Spalte: ZIPCODE_2 (char)
- Spalte: DECL_STATE_DATE (datetime)
- Spalte: ORDER_LIMIT (decimal)
- Spalte: ADDR_2_2 (varchar)
- Spalte: ADDR_3_2 (varchar)
- Spalte: INTERNAL_TRANSFER (char)
- Spalte: COLLECT_INV_FREQUENCY (char)
- Spalte: VAT_SUSPENSION (char)
- Spalte: CUSTOMER_GROUP_VEH (char)
- Spalte: RENAULT_DEALER_NUMBER (decimal)
- Spalte: RENAULT_TRANS_METHOD (decimal)
- Spalte: BIRTH_PLACE (varchar)
- Spalte: BIRTH_TOWN_CODE (char)
- Spalte: COMPANY_ACRONYM_CODE (char)
- Spalte: REGISTERED_OFFICE (char)
- Spalte: INCOME_TAX_CODE (varchar)
- Spalte: HOBBY_CODE (char)
- Spalte: AGENT_CODE (char)
- Spalte: BANK_BRANCH_REG_NO (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: FREIGHT_PER_DAY (decimal)
- Spalte: INVOICE_FORM_CODE_NON_ELEC (char)
- Spalte: INSURANCE_CODE (char)
- Spalte: OBSOLETE (char)
- Spalte: SKIP_CUST_DATA_CHECKS (char)
- Spalte: CLIENT_DB (varchar)
- Table: vPP5M
- Spalte: BOOK_KEEPING_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SPECIFY (varchar)
- Spalte: DEMOCARS (tinyint)
- Spalte: BOOK_NO_SALE (varchar)
- Spalte: BOOK_NO_PURCH (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP5R
- Spalte: VEHICLE_TYPE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: VEHICLE_TYPE_TEXT (varchar)
- Spalte: VEHICLE_TYPE_NEW (int)
- Spalte: COST_ACC_USED (int)
- Spalte: COST_ECC_STATUS_FROM (varchar)
- Spalte: COST_ECC_STATUS_TO (varchar)
- Spalte: BONUS_ACC_USED (int)
- Spalte: BONUS_ECC_STATUS_FROM (varchar)
- Spalte: BONUS_ECC_STATUS_TO (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP5Q
- Spalte: MODEL_LINE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: MOD_LIN_SPECIFY (varchar)
- Spalte: MOD_LIN_OWN_OPT_1 (varchar)
- Spalte: MOD_LIN_OWN_OPT_2 (varchar)
- Spalte: MOD_LIN_OWN_OPT_3 (varchar)
- Spalte: MOD_LIN_OWN_OPT_4 (varchar)
- Spalte: MOD_LIN_OWN_OPT_5 (varchar)
- Spalte: EDICS_PRICECALC (varchar)
- Spalte: EDICS_MODEL_01 (varchar)
- Spalte: EDICS_MODEL_02 (varchar)
- Spalte: EDICS_MODEL_03 (varchar)
- Spalte: EDICS_MODEL_04 (varchar)
- Spalte: EDICS_MODEL_05 (varchar)
- Spalte: EDICS_MODEL_06 (varchar)
- Spalte: EDICS_MODEL_07 (varchar)
- Spalte: EDICS_MODEL_08 (varchar)
- Spalte: EDICS_MODEL_09 (varchar)
- Spalte: EDICS_MODEL_10 (varchar)
- Spalte: EDICS_MODEL_11 (varchar)
- Spalte: EDICS_MODEL_12 (varchar)
- Spalte: EDICS_MODEL_13 (varchar)
- Spalte: EDICS_MODEL_14 (varchar)
- Spalte: EDICS_MODEL_15 (varchar)
- Spalte: EDICS_MODEL_16 (varchar)
- Spalte: EDICS_MODEL_17 (varchar)
- Spalte: EDICS_MODEL_18 (varchar)
- Spalte: EDICS_MODEL_19 (varchar)
- Spalte: EDICS_MODEL_20 (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP74
- Spalte: WORKSHOP_MODEL (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: MODEL_TEXT (varchar)
- Spalte: ORIG_MODEL_CODE (varchar)
- Spalte: CLAIM_TYPE (varchar)
- Spalte: PRODUCT_LINE (varchar)
- Spalte: MNEMONIC_1 (varchar)
- Spalte: MNEMONIC_2 (varchar)
- Spalte: MODEL_TYPE (varchar)
- Spalte: MODEL_GROUP (varchar)
- Spalte: FACTORY_CLAIM_CODE (int)
- Spalte: MODEL_LINE_OSP (varchar)
- Spalte: CALL_FOR_SERVICE (int)
- Spalte: FOLLOW_UP_CODE_1 (varchar)
- Spalte: FOLLOW_UP_CODE_2 (varchar)
- Spalte: FOLLOW_UP_CODE_3 (varchar)
- Spalte: FOLLOW_UP_CODE_4 (varchar)
- Spalte: FOLLOW_UP_CODE_5 (varchar)
- Spalte: MAKE_CODE (varchar)
- Spalte: CARDFILE_PAGE (decimal)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: GLOBAL_MAKE
- Spalte: GLOBAL_MAKE_CD (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DESCRIPTION (varchar)
- Spalte: ADP_MAKE (tinyint)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: ADP_EXCHANGE_MAKE_CD (char)
- Spalte: CLIENT_DB (varchar)
- Table: VEH_ORDER_HEADER
- Spalte: ORDER_NUMBER (decimal)
- Spalte: DEBIT_ACCOUNT (char)
- Spalte: STATUS (char)
- Spalte: STATE_KEY_DATE (datetime)
- Spalte: INVOICE_NUMBER (decimal)
- Spalte: DEPARTMENT (char)
- Spalte: STATE_DELIV_DATE (datetime)
- Spalte: STATE_CODE_VO (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DELIVERY_ACCOUNT (char)
- Spalte: USER_UPDATE_VO (char)
- Spalte: SALESMAN (char)
- Spalte: DEBIT_PERM (char)
- Spalte: ORDER_DATE (datetime)
- Spalte: DELIVERY_DATE (datetime)
- Spalte: DELIVERY_PLACE (varchar)
- Spalte: INVOICE_DATE (datetime)
- Spalte: PMT_TERM (char)
- Spalte: NEXT_LINE_NUMBER (decimal)
- Spalte: PAYMENT_TEXT (varchar)
- Spalte: INVOICE_COPY_CODE (char)
- Spalte: TEXT_CODE_1 (char)
- Spalte: TEXT_CODE_2 (char)
- Spalte: TEXT_CODE_3 (char)
- Spalte: TEXT1_1_VO (varchar)
- Spalte: TEXT1_2_VO (varchar)
- Spalte: TEXT_FL1_VO (char)
- Spalte: TEXT2_1_VO (varchar)
- Spalte: TEXT2_2_VO (varchar)
- Spalte: TEXT_FL2_VO (char)
- Spalte: TEXT3_1_VO (varchar)
- Spalte: TEXT3_2_VO (varchar)
- Spalte: TEXT_FL3_VO (char)
- Spalte: TEXT4_1_VO (varchar)
- Spalte: TEXT4_2_VO (varchar)
- Spalte: TEXT_FL4_VO (char)
- Spalte: FLEET_OWNER (char)
- Spalte: OPTION_SPECIFIC (char)
- Spalte: VEHICLE_LINES_VO (decimal)
- Spalte: ORDER_SUM_VO (decimal)
- Spalte: REQ_NO (char)
- Spalte: REFERENCE_NUMBER (decimal)
- Spalte: DUEDATE_1 (datetime)
- Spalte: TITLE (varchar)
- Spalte: NAME (varchar)
- Spalte: STREET_ADDR (varchar)
- Spalte: ADDR_2 (varchar)
- Spalte: ZIPCODE (char)
- Spalte: MAIL_ADDR (varchar)
- Spalte: ADDR_3 (varchar)
- Spalte: COUNTY (varchar)
- Spalte: VEHICLE_SOLD (char)
- Spalte: VEHICLE_SOLD_SUM (decimal)
- Spalte: VEHICLE_PURCH (char)
- Spalte: VEHICLE_PURCH_SUM (decimal)
- Spalte: CHAIN_NUMBER (decimal)
- Spalte: SYSTEM_INV_PERM (char)
- Spalte: INTERNAL_CODE (char)
- Spalte: PREV_STATUS (char)
- Spalte: CREDIT_ORDER_VEH (char)
- Spalte: TAX_HANDLING (char)
- Spalte: TAX_PERC (decimal)
- Spalte: DELIVERY_WAY_CODE (char)
- Spalte: DELIVERY_TERM (char)
- Spalte: CUSTOMER_GROUP (char)
- Spalte: PRICE_CODE (char)
- Spalte: STOCK (char)
- Spalte: PLACE_CODE_2 (char)
- Spalte: INVOICE_DISC_PERC (decimal)
- Spalte: ORDER_ARR_DATE_VO (datetime)
- Spalte: OFFER (char)
- Spalte: VEH_ORDER_TYPE (char)
- Spalte: MAIN_ORDER_NO (decimal)
- Spalte: SUB_ORDER_NO_1 (decimal)
- Spalte: SUB_ORDER_NO_2 (decimal)
- Spalte: SUB_ORDER_NO_3 (decimal)
- Spalte: SUB_ORDER_NO_4 (decimal)
- Spalte: SUB_ORDER_NO_5 (decimal)
- Spalte: SUB_ORDER_NO_6 (decimal)
- Spalte: SUB_ORDER_NO_7 (decimal)
- Spalte: SUB_ORDER_NO_8 (decimal)
- Spalte: SUB_ORDER_NO_9 (decimal)
- Spalte: SUB_ORDER_NO_10 (decimal)
- Spalte: TO_MICROFICHE (char)
- Spalte: LANGUAGE_CODE (char)
- Spalte: TAX_CODE_VO (char)
- Spalte: INV_ROUNDING_VO (decimal)
- Spalte: DEBT_NEW (decimal)
- Spalte: CASH_AMOUNT (decimal)
- Spalte: CNTRACT_DUE_DATE (datetime)
- Spalte: CONTRACT_DATE (datetime)
- Spalte: FAC_MODEL_CODE_L (varchar)
- Spalte: CUSTOMER_SOLD (char)
- Spalte: EXP_ARRIVAL_TIME (char)
- Spalte: BOOK_NO (char)
- Spalte: BOOK_NO_FLAG (char)
- Spalte: REFERENCE_DATE (datetime)
- Spalte: DEBET_DEPARTMENT (char)
- Spalte: CUSTOMER_EAN_NUMBER (decimal)
- Spalte: EAN_DEPARTMENT (varchar)
- Spalte: EAN_REFERENCE (varchar)
- Spalte: EAN_INTERNAL_ACCT (varchar)
- Spalte: NWFAKT_MARKING (decimal)
- Spalte: EXT_ORDER_NUMBER (decimal)
- Spalte: DEAL_ID (varchar)
- Spalte: PREORDER_ID (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: E_INVOICE (tinyint)
- Spalte: CLIENT_DB (varchar)
- Table: VEH_ORDER_LINE
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: UNIT_NUMBER (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: STATE_CODE (char)
- Spalte: PERSON_CODE (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: VEHICLE_TYPE_VO (char)
- Spalte: LAYOUT_TYPE (char)
- Spalte: REGISTER_NUMBER (char)
- Spalte: CHASSIS_NUMBER (varchar)
- Spalte: DELIVERY_DATE (datetime)
- Spalte: TEXT_CODE_1 (char)
- Spalte: TEXT_CODE_2 (char)
- Spalte: TEXT_CODE_3 (char)
- Spalte: PROMISSED_PRICE (decimal)
- Spalte: VEHICLE_SUM_OLD (decimal)
- Spalte: VEHICLE_SUM_NEW (decimal)
- Spalte: OPTION_LINES (decimal)
- Spalte: VAT_HANDLING (char)
- Spalte: TEXT1_1_VO (varchar)
- Spalte: TEXT1_2_VO (varchar)
- Spalte: TEXT_FL1_VO (char)
- Spalte: TEXT2_1_VO (varchar)
- Spalte: TEXT2_2_VO (varchar)
- Spalte: TEXT_FL2_VO (char)
- Spalte: TEXT3_1_VO (varchar)
- Spalte: TEXT3_2_VO (varchar)
- Spalte: TEXT_FL3_VO (char)
- Spalte: TEXT4_1_VO (varchar)
- Spalte: TEXT4_2_VO (varchar)
- Spalte: TEXT_FL4_VO (char)
- Spalte: LINE_TYPE_VEH (char)
- Spalte: UPDATE_VO (char)
- Spalte: SALE_VO (char)
- Spalte: PRINT_LAYOUT (char)
- Spalte: MILEAGE (decimal)
- Spalte: SALEREF (char)
- Spalte: VAT_RATE_CODE (char)
- Spalte: DISC_CODE_1 (char)
- Spalte: DISC_PCT_1 (decimal)
- Spalte: DISC_PCT_2 (decimal)
- Spalte: DISC_AMOUNT_1 (decimal)
- Spalte: DISC_AMOUNT_2 (decimal)
- Spalte: NOVA_CALC_FLAG (char)
- Spalte: NOVA_AMOUNT (decimal)
- Spalte: NOVA_EXCEPT_CODE (char)
- Spalte: NOVA_EXCEPT_TEXT (varchar)
- Spalte: ACCOUNTING_CODE (char)
- Spalte: CREATE_MSC (char)
- Spalte: BOOK_NO (char)
- Spalte: CONTRACT_NUMBER (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP43(Einkauf)
- Spalte: SELLER_CODE (varchar)
- Spalte: ORDER_APPROV_PERM (varchar)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SEL_NAME (varchar)
- Spalte: SEL_DEPARTMENT (char)
- Spalte: SEL_FIRST_NAME (varchar)
- Spalte: SEL_FAMILY_NAME (varchar)
- Spalte: SEL_TITLE (char)
- Spalte: SEL_MALE_FEMALE (int)
- Spalte: SEL_FACTOR (decimal)
- Spalte: SEL_COM_SALESMAN (int)
- Spalte: MECHANIC_PAY_GROUP (char)
- Spalte: LICENCE_ID (char)
- Spalte: EMPLOYEE_CATEGORY (decimal)
- Spalte: TRAINEE_YEAR (decimal)
- Spalte: EMAIL_ADDRESS (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: DEPARTMENT_TYPE
- Spalte: DEPARTMENT_TYPE_ID (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DESCRIPTION (varchar)
- Spalte: DEPARTMENT_GROUP (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP48
- Spalte: CUSTOMER_GROUP (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: CUST_GROUP_SPECIFY (varchar)
- Spalte: CUSTOMER_AMOUNT (decimal)
- Spalte: COLLECT_ACCOUNT (varchar)
- Spalte: ROUNDING_ACCOUNT (varchar)
- Spalte: CASH_DISCOUNT_ACC (varchar)
- Spalte: INTEREST_ACCOUNT (varchar)
- Spalte: SETOFF_ACCT (varchar)
- Spalte: BACK_ORDER_PERM (int)
- Spalte: END_USER (int)
- Spalte: ORDER_DISCOUNT_GRP (varchar)
- Spalte: CONVERT_SOLD_TIME (int)
- Spalte: INTEREST_CRED_ACCT (varchar)
- Spalte: VAT_TABLE_VEHICLE (varchar)
- Spalte: VAT_TABLE_WORK (varchar)
- Spalte: VAT_TABLE_NORMAL (varchar)
- Spalte: TAX_CODE (varchar)
- Spalte: CODE_CUST_GROUP (decimal)
- Spalte: SWED_DESCRIP_CODE (varchar)
- Spalte: PMT_CHARGE_TYPE (varchar)
- Spalte: TUP_CUST_GROUP (varchar)
- Spalte: INVOICE_CATEGORY (varchar)
- Spalte: CUSTOMER_CLASS (varchar)
- Spalte: RECOMMENDED_PRICE_ID (varchar)
- Spalte: CUST_GROUP_VEH (int)
- Spalte: TRACKERPACK_CUST_GROUP (varchar)
- Spalte: CITROEN_CUST_GROUP (varchar)
- Spalte: ROUNDING_ACCOUNT_POSITIVE (varchar)
- Spalte: CLASS_CUSTOMER_GROUP (varchar)
- Spalte: DEFAULT_ORDER_STATUS (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP5A
- Spalte: TRANSACTION_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SPECIFY (varchar)
- Spalte: TRANSFER_CODE (varchar)
- Spalte: VAT_ALLOWED (tinyint)
- Spalte: PRINT5A (tinyint)
- Spalte: SALES_PRICE (tinyint)
- Spalte: EQUIPMENT (tinyint)
- Spalte: DELIVERY_COST (tinyint)
- Spalte: PURCH_PRICE (tinyint)
- Spalte: DEPRECIATION (tinyint)
- Spalte: PPCALC_BLOCK_NO (decimal)
- Spalte: PPCALC_FIELD_NO (decimal)
- Spalte: COUNTER_ACCOUNT (varchar)
- Spalte: PMT_TYPE (varchar)
- Spalte: EXTRACT_VAT (tinyint)
- Spalte: CALC_DIFF_VAT (tinyint)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: UNIT_CHANGE_HIST
- Spalte: UNIT_NUMBER (char)
- Spalte: VAL_DATE (datetime)
- Spalte: SEQ_NO (decimal)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: BOOK_KEEPING_CODE (char)
- Spalte: TAX_HANDLING (char)
- Spalte: VAT_RATE_CODE (char)
- Spalte: DEPARTMENT (char)
- Spalte: CLASSIFICATION_DTE (datetime)
- Spalte: VEHICLE_TYPE (char)
- Spalte: MAKE_CD (char)
- Spalte: MAKE_FAMILY_CD (char)
- Spalte: MODEL_LINE (char)
- Spalte: WORKSHOP_MODEL (char)
- Spalte: FAC_MODEL_CODE (varchar)
- Spalte: USED_VEH_DEST_CODE (char)
- Spalte: PURCH_ORIGIN_CODE (char)
- Spalte: USE_OF_VEHICLE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: PURCH_SALESMAN (char)
- Spalte: SALE_SALESMAN (char)
- Spalte: CLIENT_DB (varchar)
- Table: Customer_Owner
- Spalte: CUSTOMER_NUMBER (char)
- Spalte: STATE_CODE_CUST (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: CUST_ALT_KEY (varchar)
- Spalte: NAME (varchar)
- Spalte: STREET_ADDR (varchar)
- Spalte: ADDR_2 (varchar)
- Spalte: MAIL_ADDR (varchar)
- Spalte: ZIPCODE (varchar)
- Spalte: DEBIT_CUSTOMER (char)
- Spalte: TITLE_CODE (char)
- Spalte: TITLE (varchar)
- Spalte: PMT_TERM (char)
- Spalte: INVOICE_COPY_CODE (char)
- Spalte: DELIVERY_WAY_CODE (char)
- Spalte: SMALL_ACCESSORIES (char)
- Spalte: SMALL_INV_CHARGE (char)
- Spalte: WORKSHOP_PRICECODE (char)
- Spalte: VAT_REGNO (varchar)
- Spalte: SALESMAN (varchar)
- Spalte: GROSS_DISCOUNT (char)
- Spalte: DELIVERY_STOP_CODE (char)
- Spalte: CREDIT_LIMIT (decimal)
- Spalte: REMINDER_CODE (char)
- Spalte: ACCOUNT_TYPE_CU (char)
- Spalte: ACCOUNT_PRINT (char)
- Spalte: BANK_NAME (varchar)
- Spalte: BANK_REG_NO (char)
- Spalte: BANK_ACCOUNT_NO (varchar)
- Spalte: PAYMENT_WAY (char)
- Spalte: PRICE_CODE (char)
- Spalte: DISCOUNT_PERC_WORK (decimal)
- Spalte: DISCOUNT_LIMIT (char)
- Spalte: ANNUAL_DISC_PERC (decimal)
- Spalte: ANNUAL_DISC_AMOUNT (decimal)
- Spalte: ANNUAL_DISC_CODE (char)
- Spalte: ADVERT_DISC_PERC (decimal)
- Spalte: ADVERT_DISC_AMOUNT (decimal)
- Spalte: INTERNAL_CODE_CUST (char)
- Spalte: CUSTOMER_GROUP (char)
- Spalte: CUSTOMER_PROSPECT (char)
- Spalte: TAX_CODE (char)
- Spalte: FLEET_OWNER (char)
- Spalte: CONTACT_PERSON (varchar)
- Spalte: PHONE_1 (varchar)
- Spalte: PHONE_2 (varchar)
- Spalte: COMMENT_1 (varchar)
- Spalte: COMMENT_2 (varchar)
- Spalte: CONTACT_DATE (datetime)
- Spalte: MAIL_CODE_1 (char)
- Spalte: MAIL_CODE_2 (char)
- Spalte: MAIL_CODE_3 (char)
- Spalte: MAIL_CODE_4 (char)
- Spalte: MAIL_CODE_5 (char)
- Spalte: MAIL_CODE_6 (char)
- Spalte: MAIL_CODE_7 (char)
- Spalte: MAIL_CODE_8 (char)
- Spalte: MAIL_CODE_9 (char)
- Spalte: LAST_INVOICE_DATE (datetime)
- Spalte: PROFIT_C_U (decimal)
- Spalte: DEBITED_MM_CUST (decimal)
- Spalte: DEBITED_TY_CUST (decimal)
- Spalte: DEBITED_PRYE_CUST (decimal)
- Spalte: DISCOUNT_MM_CUST (decimal)
- Spalte: DISCOUNT_TY_CUST (decimal)
- Spalte: DISCOUNT_PY_CUST (decimal)
- Spalte: MARG_MM_CUST (decimal)
- Spalte: MARG_TY_CUST (decimal)
- Spalte: MARG_PY_CUST (decimal)
- Spalte: SALDO_C_U_CUST (decimal)
- Spalte: LAST_PMT_DTE_CUST (datetime)
- Spalte: PMT_TIME_CUST (decimal)
- Spalte: INTERESTS (decimal)
- Spalte: SALDO_LAST_ST (decimal)
- Spalte: AOS_DEAL_NUMBER (char)
- Spalte: CPR_NUMBER (decimal)
- Spalte: DELETE_PROPOSAL (char)
- Spalte: CREATION_DATE (datetime)
- Spalte: CREATER (char)
- Spalte: REDUCTION_CODE (char)
- Spalte: START_NO (decimal)
- Spalte: LAST_NO (decimal)
- Spalte: LATEST_PERIOD (datetime)
- Spalte: REMINDER_GROUP (char)
- Spalte: REMINDER_DATE (datetime)
- Spalte: PMT_TERMCODE_2 (char)
- Spalte: BACK_ORDER_DELIV (char)
- Spalte: COUNTRY_CODE_CU (char)
- Spalte: INSTALMENT_CODE (decimal)
- Spalte: FOLLOW_UP_CU (char)
- Spalte: VAT_TABLE_WORK (char)
- Spalte: VAT_TABLE_NORMAL (char)
- Spalte: VAT_TABLE (char)
- Spalte: OCCUPATION_CODE (char)
- Spalte: TELEFAX_NUMBER (varchar)
- Spalte: LANGUAGE_CODE (varchar)
- Spalte: BIRTHDAY (datetime)
- Spalte: BIRTHDAY2 (datetime)
- Spalte: ADDR_3 (varchar)
- Spalte: COUNTY (varchar)
- Spalte: MAX_BOOKING_DAYS (decimal)
- Spalte: DEPARTMENT_5 (decimal)
- Spalte: RIB_KEY (decimal)
- Spalte: PRICE_A_G (char)
- Spalte: REQ_NO_COMPULSORY (char)
- Spalte: VAT_REGNO_EU (varchar)
- Spalte: WORKSHOP_SALESMAN (char)
- Spalte: HOURLY_REPAIR_RATE (decimal)
- Spalte: ELEC_INVOICE (char)
- Spalte: ELEC_DEL_NOTE (char)
- Spalte: ELEC_ORDER_CONF (char)
- Spalte: ELEC_INVOICE_FORM (char)
- Spalte: ELEC_COLL_INV_FORM (char)
- Spalte: ELEC_DEL_NOTE_FORM (char)
- Spalte: ELEC_ORD_CONF_FORM (char)
- Spalte: ONLY_COLL_INVOICE (char)
- Spalte: CUST_COMPANY_NO (char)
- Spalte: DEALER_NUMBER (char)
- Spalte: MOBILE_PHONE (varchar)
- Spalte: MOBILE_PHONE_2 (varchar)
- Spalte: E_MAIL_ADDRESS (varchar)
- Spalte: E_MAIL_ADDRESS_2 (varchar)
- Spalte: BRANCH (varchar)
- Spalte: DECLARATION_STATE (char)
- Spalte: USE_WORK_TYPE_CODE (char)
- Spalte: FLEET_ID_NUMBER (char)
- Spalte: FIRST_NAME (varchar)
- Spalte: LAST_NAME (varchar)
- Spalte: GENDER (char)
- Spalte: COMPANY (char)
- Spalte: MAIL_SUPPRESS (char)
- Spalte: PO_BOX_15 (varchar)
- Spalte: PO_BOX_ZIPCODE (char)
- Spalte: PO_BOX_TOWN (varchar)
- Spalte: WEB_ADDRESS (varchar)
- Spalte: FAMILY_STATUS (char)
- Spalte: CHILDREN (decimal)
- Spalte: HOBBY (varchar)
- Spalte: EXT_CUSTOMER_GROUP (char)
- Spalte: MEMBERSHIP_NUMBER (varchar)
- Spalte: TRADE_REGISTER (varchar)
- Spalte: PDF_INVOICE (char)
- Spalte: E_COMMERCE_VEH (char)
- Spalte: E_MAIL_ADDRESS_3 (varchar)
- Spalte: SEND_ORDER_ADVICE (char)
- Spalte: SALES_LOCATION (char)
- Spalte: SERVICE_LOCATION (char)
- Spalte: STREET_NUMBER (decimal)
- Spalte: STREET_NUMBER_EXT (char)
- Spalte: STREET_NUMBER_EXT2 (char)
- Spalte: MAIL_ADDR_2 (varchar)
- Spalte: COUNTY_2 (varchar)
- Spalte: EXTERNAL_ID (decimal)
- Spalte: LICENSE_NUMBER (varchar)
- Spalte: STREET_NUMBER_2 (decimal)
- Spalte: V5_CUSTOMER_TYPE (varchar)
- Spalte: ZIPCODE_2 (char)
- Spalte: DECL_STATE_DATE (datetime)
- Spalte: ORDER_LIMIT (decimal)
- Spalte: ADDR_2_2 (varchar)
- Spalte: ADDR_3_2 (varchar)
- Spalte: INTERNAL_TRANSFER (char)
- Spalte: COLLECT_INV_FREQUENCY (char)
- Spalte: VAT_SUSPENSION (char)
- Spalte: CUSTOMER_GROUP_VEH (char)
- Spalte: RENAULT_DEALER_NUMBER (decimal)
- Spalte: RENAULT_TRANS_METHOD (decimal)
- Spalte: BIRTH_PLACE (varchar)
- Spalte: BIRTH_TOWN_CODE (char)
- Spalte: COMPANY_ACRONYM_CODE (char)
- Spalte: REGISTERED_OFFICE (char)
- Spalte: INCOME_TAX_CODE (varchar)
- Spalte: HOBBY_CODE (char)
- Spalte: AGENT_CODE (char)
- Spalte: BANK_BRANCH_REG_NO (char)
- Spalte: INVOICE_FORM_CODE_NON_ELEC (char)
- Spalte: FREIGHT_PER_DAY (decimal)
- Spalte: PDF_STATEMENT (char)
- Spalte: PDF_FORMCODE (char)
- Spalte: E_MAIL_ADDRESS_4 (varchar)
- Spalte: IN_HOUSE_FINANCING (char)
- Spalte: INSURANCE_CODE (char)
- Spalte: HANDLER_SYSTEM (decimal)
- Spalte: LOCATION_CODE (char)
- Spalte: SKIP_CUST_DATA_CHECKS (char)
- Spalte: OBSOLETE (char)
- Spalte: FREIGHT_FEE_GROUP (char)
- Spalte: CASH_MARK (char)
- Spalte: SEND_ORDER_FOLLOW_UP (char)
- Spalte: VEH_CERTIFICATE_PRINT_IMP (char)
- Spalte: DECL_FIRST_CHANGE_DATE (datetime)
- Spalte: DECL_LAST_CUST_CONT_DATE (datetime)
- Spalte: DECL_LAST_CHANGE_ORDER_NO (decimal)
- Spalte: DECL_STATE_ORIGIN (char)
- Spalte: DECL_STATE_REMARK (varchar)
- Spalte: PDF_INTEREST_INVOICE (char)
- Spalte: PDF_FORMCODE_II (char)
- Spalte: E_MAIL_ADDRESS_5 (varchar)
- Spalte: PDF_CLAIM_INVOICE (char)
- Spalte: PDF_FORMCODE_CI (char)
- Spalte: E_MAIL_ADDRESS_6 (varchar)
- Spalte: BIC (varchar)
- Spalte: IBAN (varchar)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (int)
- Spalte: PMT_CODE_VEHICLE (char)
- Spalte: BYPASS_AUTO_SEARCH (char)
- Spalte: E_MAIL_ADDRESS_7 (varchar)
- Spalte: IDENTITY_CARD (varchar)
- Spalte: SMALL_ACCESS_SEPARATE (char)
- Spalte: E_MAIL_ADDRESS_8 (varchar)
- Spalte: PDF_FORMCODE_RL (char)
- Spalte: PDF_REMINDER_LETTER (char)
- Spalte: DECL_FORM_PRESENTED (char)
- Spalte: E_MAIL_ADDRESS_10 (varchar)
- Spalte: E_MAIL_ADDRESS_9 (varchar)
- Spalte: FORD_PAYMENT_CARD (varchar)
- Spalte: PDF_FORMCODE_L1 (char)
- Spalte: PDF_FORMCODE_L2 (char)
- Spalte: PDF_LEASING_INVOICE (char)
- Spalte: PDF_SERVICE_INVOICE (char)
- Spalte: SHOW_TIME_PRICE (char)
- Spalte: CENTRAL_CUSTOMER_FILE (char)
- Spalte: CONTACT_FIRST_NAME (varchar)
- Spalte: CONTACT_LAST_NAME (varchar)
- Spalte: CONTACT_TITLE (varchar)
- Spalte: CONTACT_TITLE_CODE (char)
- Spalte: E_MAIL_ADDRESS_11 (varchar)
- Spalte: MOBILE_PHONE_3 (varchar)
- Spalte: PDF_FORMCODE_SC (char)
- Spalte: PDF_SEPA_NOTIFICATION (char)
- Spalte: PDF_SERVICE_CONTRACT (char)
- Spalte: PREFERRED_CHANNEL (char)
- Spalte: PREFERRED_SMART_PAY (char)
- Spalte: RENAULT_BRANCH (char)
- Spalte: CLIENT_DB (varchar)
- Table: GC_Department
- Spalte: Hauptbetrieb (varchar)
- Spalte: Standort (varchar)
- Spalte: Site (varchar)
- Spalte: Hauptbetrieb_ID (varchar)
- Spalte: Hauptbetrieb_Name (varchar)
- Spalte: Standort_ID (varchar)
- Spalte: Standort_Name (varchar)
- Spalte: Gruppe_ID (varchar)
- Spalte: Gruppe_Name (varchar)
- Spalte: Marke_ID (varchar)
- Spalte: Marke_Name (varchar)
- Table: GC_Marken
- Spalte: Client_DB (varchar)
- Spalte: Make (varchar)
- Spalte: Description (varchar)
- Spalte: Fabrikat (varchar)
- Spalte: Order_By (int)
- Katalogordner
- Ordner: Unit File
- Spalte: Unit Number ([O21.OPTIMA.import.UNIT_FILE.UNIT_NUMBER], Zeichenkette)
- Spalte: Basis Number ([O21.OPTIMA.import.UNIT_FILE.BASIS_NUMBER], Zeichenkette)
- Spalte: Ecc Status ([O21.OPTIMA.import.UNIT_FILE.ECC_STATUS], Zeichenkette)
- Spalte: Vehicle Type ([O21.OPTIMA.import.UNIT_FILE.VEHICLE_TYPE], Zeichenkette)
- Spalte: Category ([O21.OPTIMA.import.UNIT_FILE.CATEGORY], Zeichenkette)
- Spalte: Chain Number ([O21.OPTIMA.import.UNIT_FILE.CHAIN_NUMBER], Zahl)
- Spalte: State Code Unit ([O21.OPTIMA.import.UNIT_FILE.STATE_CODE_UNIT], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.UNIT_FILE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.UNIT_FILE.HANDLER], Zeichenkette)
- Spalte: Car Creation Date ([O21.OPTIMA.import.UNIT_FILE.CAR_CREATION_DATE], Datum/Uhrzeit)
- Spalte: Pmt Term ([O21.OPTIMA.import.UNIT_FILE.PMT_TERM], Zeichenkette)
- Spalte: Invoice Copy Code ([O21.OPTIMA.import.UNIT_FILE.INVOICE_COPY_CODE], Zeichenkette)
- Spalte: Delivery Way Code ([O21.OPTIMA.import.UNIT_FILE.DELIVERY_WAY_CODE], Zeichenkette)
- Spalte: Small Accessories ([O21.OPTIMA.import.UNIT_FILE.SMALL_ACCESSORIES], Zeichenkette)
- Spalte: Small Inv Charge ([O21.OPTIMA.import.UNIT_FILE.SMALL_INV_CHARGE], Zeichenkette)
- Spalte: Delivery Stop Code ([O21.OPTIMA.import.UNIT_FILE.DELIVERY_STOP_CODE], Zeichenkette)
- Spalte: Price Code ([O21.OPTIMA.import.UNIT_FILE.PRICE_CODE], Zeichenkette)
- Spalte: Discount Perc Work ([O21.OPTIMA.import.UNIT_FILE.DISCOUNT_PERC_WORK], Zahl)
- Spalte: Discount Limit ([O21.OPTIMA.import.UNIT_FILE.DISCOUNT_LIMIT], Zeichenkette)
- Spalte: Internal Code ([O21.OPTIMA.import.UNIT_FILE.INTERNAL_CODE], Zeichenkette)
- Spalte: Tax Code ([O21.OPTIMA.import.UNIT_FILE.TAX_CODE], Zeichenkette)
- Spalte: Unit Last Upd Dte ([O21.OPTIMA.import.UNIT_FILE.UNIT_LAST_UPD_DTE], Datum/Uhrzeit)
- Spalte: Depreciation ([O21.OPTIMA.import.UNIT_FILE.DEPRECIATION], Zahl)
- Spalte: Transfer Tax ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_TAX], Zahl)
- Spalte: Book Keeping Code ([O21.OPTIMA.import.UNIT_FILE.BOOK_KEEPING_CODE], Zeichenkette)
- Spalte: Tax Handling ([O21.OPTIMA.import.UNIT_FILE.TAX_HANDLING], Zeichenkette)
- Spalte: Interest Code ([O21.OPTIMA.import.UNIT_FILE.INTEREST_CODE], Zeichenkette)
- Spalte: Mileage ([O21.OPTIMA.import.UNIT_FILE.MILEAGE], Zahl)
- Spalte: Purch Department ([O21.OPTIMA.import.UNIT_FILE.PURCH_DEPARTMENT], Zeichenkette)
- Spalte: Purch Salsman Code ([O21.OPTIMA.import.UNIT_FILE.PURCH_SALSMAN_CODE], Zeichenkette)
- Spalte: Purch Invno ([O21.OPTIMA.import.UNIT_FILE.PURCH_INVNO], Zeichenkette)
- Spalte: Purch Date ([O21.OPTIMA.import.UNIT_FILE.PURCH_DATE], Datum/Uhrzeit)
- Spalte: Sales Department ([O21.OPTIMA.import.UNIT_FILE.SALES_DEPARTMENT], Zeichenkette)
- Spalte: Sale Salesman ([O21.OPTIMA.import.UNIT_FILE.SALE_SALESMAN], Zeichenkette)
- Spalte: Sale Inv Number ([O21.OPTIMA.import.UNIT_FILE.SALE_INV_NUMBER], Zeichenkette)
- Spalte: Sale Date ([O21.OPTIMA.import.UNIT_FILE.SALE_DATE], Datum/Uhrzeit)
- Spalte: Scrap Code ([O21.OPTIMA.import.UNIT_FILE.SCRAP_CODE], Zeichenkette)
- Spalte: Unit In Change ([O21.OPTIMA.import.UNIT_FILE.UNIT_IN_CHANGE], Zeichenkette)
- Spalte: Bud Sale Det ([O21.OPTIMA.import.UNIT_FILE.BUD_SALE_DET], Zahl)
- Spalte: Bud Purch Price ([O21.OPTIMA.import.UNIT_FILE.BUD_PURCH_PRICE], Zahl)
- Spalte: Bud Reg Fee ([O21.OPTIMA.import.UNIT_FILE.BUD_REG_FEE], Zahl)
- Spalte: Bud Deduct Fee ([O21.OPTIMA.import.UNIT_FILE.BUD_DEDUCT_FEE], Zahl)
- Spalte: Bud Cost ([O21.OPTIMA.import.UNIT_FILE.BUD_COST], Zahl)
- Spalte: Prev Owner ([O21.OPTIMA.import.UNIT_FILE.PREV_OWNER], Zeichenkette)
- Spalte: Owner ([O21.OPTIMA.import.UNIT_FILE.OWNER], Zeichenkette)
- Spalte: Purch Price Unit ([O21.OPTIMA.import.UNIT_FILE.PURCH_PRICE_UNIT], Zahl)
- Spalte: Cost Unit ([O21.OPTIMA.import.UNIT_FILE.COST_UNIT], Zahl)
- Spalte: Sales Price Unit ([O21.OPTIMA.import.UNIT_FILE.SALES_PRICE_UNIT], Zahl)
- Spalte: Reg Fee ([O21.OPTIMA.import.UNIT_FILE.REG_FEE], Zahl)
- Spalte: Interest 1 ([O21.OPTIMA.import.UNIT_FILE.INTEREST_1], Zahl)
- Spalte: Interest 2 ([O21.OPTIMA.import.UNIT_FILE.INTEREST_2], Zahl)
- Spalte: Next Line Unit ([O21.OPTIMA.import.UNIT_FILE.NEXT_LINE_UNIT], Zahl)
- Spalte: Next Line 1 ([O21.OPTIMA.import.UNIT_FILE.NEXT_LINE_1], Zahl)
- Spalte: Transfer Line ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_LINE], Zahl)
- Spalte: Transfer Tax Hand ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_TAX_HAND], Zeichenkette)
- Spalte: Transfer Acc Code ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_ACC_CODE], Zeichenkette)
- Spalte: Transfer Tax Basis ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_TAX_BASIS], Zahl)
- Spalte: Transfer Tax Pct ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_TAX_PCT], Zahl)
- Spalte: Transfer Sold ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_SOLD], Zeichenkette)
- Spalte: Purch Tax ([O21.OPTIMA.import.UNIT_FILE.PURCH_TAX], Zahl)
- Spalte: Cost Tax ([O21.OPTIMA.import.UNIT_FILE.COST_TAX], Zahl)
- Spalte: Or Mark ([O21.OPTIMA.import.UNIT_FILE.OR_MARK], Zeichenkette)
- Spalte: Transfer Date ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_DATE], Datum/Uhrzeit)
- Spalte: Stock Days ([O21.OPTIMA.import.UNIT_FILE.STOCK_DAYS], Zeichenkette)
- Spalte: Delete Proposal ([O21.OPTIMA.import.UNIT_FILE.DELETE_PROPOSAL], Zeichenkette)
- Spalte: Transfer Bbdb ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_BBDB], Datum/Uhrzeit)
- Spalte: Condition Unit ([O21.OPTIMA.import.UNIT_FILE.CONDITION_UNIT], Zeichenkette)
- Spalte: Buying Order No ([O21.OPTIMA.import.UNIT_FILE.BUYING_ORDER_NO], Zeichenkette)
- Spalte: Buying Order Date ([O21.OPTIMA.import.UNIT_FILE.BUYING_ORDER_DATE], Datum/Uhrzeit)
- Spalte: Pa Number ([O21.OPTIMA.import.UNIT_FILE.PA_NUMBER], Zeichenkette)
- Spalte: Vehicle Update ([O21.OPTIMA.import.UNIT_FILE.VEHICLE_UPDATE], Zeichenkette)
- Spalte: Latest Update ([O21.OPTIMA.import.UNIT_FILE.LATEST_UPDATE], Datum/Uhrzeit)
- Spalte: Invoice Permission ([O21.OPTIMA.import.UNIT_FILE.INVOICE_PERMISSION], Zeichenkette)
- Spalte: Location Code ([O21.OPTIMA.import.UNIT_FILE.LOCATION_CODE], Zeichenkette)
- Spalte: Account Purchase ([O21.OPTIMA.import.UNIT_FILE.ACCOUNT_PURCHASE], Zeichenkette)
- Spalte: Account Sales ([O21.OPTIMA.import.UNIT_FILE.ACCOUNT_SALES], Zeichenkette)
- Spalte: Budg Price Vat ([O21.OPTIMA.import.UNIT_FILE.BUDG_PRICE_VAT], Zeichenkette)
- Spalte: Recalc Code ([O21.OPTIMA.import.UNIT_FILE.RECALC_CODE], Zeichenkette)
- Spalte: Commision No ([O21.OPTIMA.import.UNIT_FILE.COMMISION_NO], Zeichenkette)
- Spalte: Delivery Date Veh ([O21.OPTIMA.import.UNIT_FILE.DELIVERY_DATE_VEH], Datum/Uhrzeit)
- Spalte: Reservation Date ([O21.OPTIMA.import.UNIT_FILE.RESERVATION_DATE], Datum/Uhrzeit)
- Spalte: Reservation Person ([O21.OPTIMA.import.UNIT_FILE.RESERVATION_PERSON], Zeichenkette)
- Spalte: Reservation Text ([O21.OPTIMA.import.UNIT_FILE.RESERVATION_TEXT], Zeichenkette)
- Spalte: Freight Balance ([O21.OPTIMA.import.UNIT_FILE.FREIGHT_BALANCE], Zahl)
- Spalte: Trf Taxbasis Sales ([O21.OPTIMA.import.UNIT_FILE.TRF_TAXBASIS_SALES], Zahl)
- Spalte: Trf Taxbasis Purch ([O21.OPTIMA.import.UNIT_FILE.TRF_TAXBASIS_PURCH], Zahl)
- Spalte: Sale Order No ([O21.OPTIMA.import.UNIT_FILE.SALE_ORDER_NO], Zeichenkette)
- Spalte: Unit Sold ([O21.OPTIMA.import.UNIT_FILE.UNIT_SOLD], Zeichenkette)
- Spalte: Trf Department ([O21.OPTIMA.import.UNIT_FILE.TRF_DEPARTMENT], Zeichenkette)
- Spalte: Order Arrival Date ([O21.OPTIMA.import.UNIT_FILE.ORDER_ARRIVAL_DATE], Datum/Uhrzeit)
- Spalte: Order Confirm Date ([O21.OPTIMA.import.UNIT_FILE.ORDER_CONFIRM_DATE], Datum/Uhrzeit)
- Spalte: Price Label Date ([O21.OPTIMA.import.UNIT_FILE.PRICE_LABEL_DATE], Datum/Uhrzeit)
- Spalte: Vat Table Work ([O21.OPTIMA.import.UNIT_FILE.VAT_TABLE_WORK], Zeichenkette)
- Spalte: Vat Table Normal ([O21.OPTIMA.import.UNIT_FILE.VAT_TABLE_NORMAL], Zeichenkette)
- Spalte: Vat Rate Code ([O21.OPTIMA.import.UNIT_FILE.VAT_RATE_CODE], Zeichenkette)
- Spalte: Transfer Vat Rc ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_VAT_RC], Zeichenkette)
- Spalte: Cntract Due Date ([O21.OPTIMA.import.UNIT_FILE.CNTRACT_DUE_DATE], Datum/Uhrzeit)
- Spalte: Contract Date ([O21.OPTIMA.import.UNIT_FILE.CONTRACT_DATE], Datum/Uhrzeit)
- Spalte: Exp Arrival Time ([O21.OPTIMA.import.UNIT_FILE.EXP_ARRIVAL_TIME], Zeichenkette)
- Spalte: Dealer Marking ([O21.OPTIMA.import.UNIT_FILE.DEALER_MARKING], Zeichenkette)
- Spalte: Booking Dealer Nr ([O21.OPTIMA.import.UNIT_FILE.BOOKING_DEALER_NR], Zeichenkette)
- Spalte: Desired Deliv Date ([O21.OPTIMA.import.UNIT_FILE.DESIRED_DELIV_DATE], Datum/Uhrzeit)
- Spalte: Valuation Date ([O21.OPTIMA.import.UNIT_FILE.VALUATION_DATE], Datum/Uhrzeit)
- Spalte: Nova Calc Flag ([O21.OPTIMA.import.UNIT_FILE.NOVA_CALC_FLAG], Zeichenkette)
- Spalte: Nova Calc Base ([O21.OPTIMA.import.UNIT_FILE.NOVA_CALC_BASE], Zeichenkette)
- Spalte: Nova Percent ([O21.OPTIMA.import.UNIT_FILE.NOVA_PERCENT], Zahl)
- Spalte: Nova Amount ([O21.OPTIMA.import.UNIT_FILE.NOVA_AMOUNT], Zahl)
- Spalte: Nova Except Code ([O21.OPTIMA.import.UNIT_FILE.NOVA_EXCEPT_CODE], Zeichenkette)
- Spalte: Nova Except Text ([O21.OPTIMA.import.UNIT_FILE.NOVA_EXCEPT_TEXT], Zeichenkette)
- Spalte: Pid Type ([O21.OPTIMA.import.UNIT_FILE.PID_TYPE], Zeichenkette)
- Spalte: Pid Number ([O21.OPTIMA.import.UNIT_FILE.PID_NUMBER], Zeichenkette)
- Spalte: Pid Issue Date ([O21.OPTIMA.import.UNIT_FILE.PID_ISSUE_DATE], Datum/Uhrzeit)
- Spalte: Pid Issue Auth ([O21.OPTIMA.import.UNIT_FILE.PID_ISSUE_AUTH], Zeichenkette)
- Spalte: Exp Destination ([O21.OPTIMA.import.UNIT_FILE.EXP_DESTINATION], Zeichenkette)
- Spalte: Argus Purch Price ([O21.OPTIMA.import.UNIT_FILE.ARGUS_PURCH_PRICE], Zahl)
- Spalte: Argus Sales Price ([O21.OPTIMA.import.UNIT_FILE.ARGUS_SALES_PRICE], Zahl)
- Spalte: Transfer Book No ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_BOOK_NO], Zeichenkette)
- Spalte: Sub Dealer Id ([O21.OPTIMA.import.UNIT_FILE.SUB_DEALER_ID], Zeichenkette)
- Spalte: Cust Company No ([O21.OPTIMA.import.UNIT_FILE.CUST_COMPANY_NO], Zeichenkette)
- Spalte: Iq Used Vehicle ([O21.OPTIMA.import.UNIT_FILE.IQ_USED_VEHICLE], Zeichenkette)
- Spalte: Stock Value Bpm ([O21.OPTIMA.import.UNIT_FILE.STOCK_VALUE_BPM], Zahl)
- Spalte: Ford Subtotal ([O21.OPTIMA.import.UNIT_FILE.FORD_SUBTOTAL], Zahl)
- Spalte: Ford Int Date ([O21.OPTIMA.import.UNIT_FILE.FORD_INT_DATE], Datum/Uhrzeit)
- Spalte: Est Sales Price ([O21.OPTIMA.import.UNIT_FILE.EST_SALES_PRICE], Zahl)
- Spalte: Est Reference No ([O21.OPTIMA.import.UNIT_FILE.EST_REFERENCE_NO], Zeichenkette)
- Spalte: Opt Valid Date ([O21.OPTIMA.import.UNIT_FILE.OPT_VALID_DATE], Datum/Uhrzeit)
- Spalte: Waste Disposal Fee ([O21.OPTIMA.import.UNIT_FILE.WASTE_DISPOSAL_FEE], Zahl)
- Spalte: Police Reg Number ([O21.OPTIMA.import.UNIT_FILE.POLICE_REG_NUMBER], Zahl)
- Spalte: Reception Date ([O21.OPTIMA.import.UNIT_FILE.RECEPTION_DATE], Datum/Uhrzeit)
- Spalte: Bud Opt Price ([O21.OPTIMA.import.UNIT_FILE.BUD_OPT_PRICE], Zahl)
- Spalte: Nova Amount New ([O21.OPTIMA.import.UNIT_FILE.NOVA_AMOUNT_NEW], Zahl)
- Spalte: Sale Price Date ([O21.OPTIMA.import.UNIT_FILE.SALE_PRICE_DATE], Datum/Uhrzeit)
- Spalte: Variation Pct ([O21.OPTIMA.import.UNIT_FILE.VARIATION_PCT], Zahl)
- Spalte: Postpone Bookkeeping ([O21.OPTIMA.import.UNIT_FILE.POSTPONE_BOOKKEEPING], Zeichenkette)
- Spalte: Used Veh Dest Code ([O21.OPTIMA.import.UNIT_FILE.USED_VEH_DEST_CODE], Zeichenkette)
- Spalte: Purch Origin Code ([O21.OPTIMA.import.UNIT_FILE.PURCH_ORIGIN_CODE], Zeichenkette)
- Spalte: Price List Version ([O21.OPTIMA.import.UNIT_FILE.PRICE_LIST_VERSION], Zeichenkette)
- Spalte: Price List Date ([O21.OPTIMA.import.UNIT_FILE.PRICE_LIST_DATE], Datum/Uhrzeit)
- Spalte: Conv Flag ([O21.OPTIMA.import.UNIT_FILE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.UNIT_FILE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.UNIT_FILE.UNIQUE_IDENT], Zahl)
- Spalte: Nova Merit Amount ([O21.OPTIMA.import.UNIT_FILE.NOVA_MERIT_AMOUNT], Zahl)
- Spalte: Price Value House ([O21.OPTIMA.import.UNIT_FILE.PRICE_VALUE_HOUSE], Zahl)
- Spalte: Price Value Internet ([O21.OPTIMA.import.UNIT_FILE.PRICE_VALUE_INTERNET], Zahl)
- Spalte: Transfer Marketplace ([O21.OPTIMA.import.UNIT_FILE.TRANSFER_MARKETPLACE], Zahl)
- Spalte: Dealer Price ([O21.OPTIMA.import.UNIT_FILE.DEALER_PRICE], Zahl)
- Spalte: Driver Demo ([O21.OPTIMA.import.UNIT_FILE.DRIVER_DEMO], Zeichenkette)
- Spalte: Lowest Salesprice ([O21.OPTIMA.import.UNIT_FILE.LOWEST_SALESPRICE], Zahl)
- Spalte: Sales Program ([O21.OPTIMA.import.UNIT_FILE.SALES_PROGRAM], Zeichenkette)
- Spalte: Text Internet ([O21.OPTIMA.import.UNIT_FILE.TEXT_INTERNET], Zeichenkette)
- Spalte: Client Db ([O21.OPTIMA.import.UNIT_FILE.CLIENT_DB], Zeichenkette)
- Ordner: Unit History
- Spalte: Unit Number ([O21.OPTIMA.import.UNIT_HISTORY.UNIT_NUMBER], Zeichenkette)
- Spalte: Line Type ([O21.OPTIMA.import.UNIT_HISTORY.LINE_TYPE], Zeichenkette)
- Spalte: Line No ([O21.OPTIMA.import.UNIT_HISTORY.LINE_NO], Zahl)
- Spalte: State Code Unit ([O21.OPTIMA.import.UNIT_HISTORY.STATE_CODE_UNIT], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.UNIT_HISTORY.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.UNIT_HISTORY.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.UNIT_HISTORY.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.UNIT_HISTORY.FUNCTION_CODE], Zeichenkette)
- Spalte: Document Date ([O21.OPTIMA.import.UNIT_HISTORY.DOCUMENT_DATE], Datum/Uhrzeit)
- Spalte: Document Nr ([O21.OPTIMA.import.UNIT_HISTORY.DOCUMENT_NR], Zahl)
- Spalte: Order Date ([O21.OPTIMA.import.UNIT_HISTORY.ORDER_DATE], Datum/Uhrzeit)
- Spalte: Order Number ([O21.OPTIMA.import.UNIT_HISTORY.ORDER_NUMBER], Zahl)
- Spalte: Transaction Code ([O21.OPTIMA.import.UNIT_HISTORY.TRANSACTION_CODE], Zeichenkette)
- Spalte: Tax Code ([O21.OPTIMA.import.UNIT_HISTORY.TAX_CODE], Zeichenkette)
- Spalte: Reference ([O21.OPTIMA.import.UNIT_HISTORY.REFERENCE], Zeichenkette)
- Spalte: Costs ([O21.OPTIMA.import.UNIT_HISTORY.COSTS], Zahl)
- Spalte: Purch Tax ([O21.OPTIMA.import.UNIT_HISTORY.PURCH_TAX], Zahl)
- Spalte: Orders Grossvalue ([O21.OPTIMA.import.UNIT_HISTORY.ORDERS_GROSSVALUE], Zahl)
- Spalte: Tax Share ([O21.OPTIMA.import.UNIT_HISTORY.TAX_SHARE], Zahl)
- Spalte: Discount ([O21.OPTIMA.import.UNIT_HISTORY.DISCOUNT], Zahl)
- Spalte: Classification Dte ([O21.OPTIMA.import.UNIT_HISTORY.CLASSIFICATION_DTE], Datum/Uhrzeit)
- Spalte: Book Keeping Code ([O21.OPTIMA.import.UNIT_HISTORY.BOOK_KEEPING_CODE], Zeichenkette)
- Spalte: Tax Handling ([O21.OPTIMA.import.UNIT_HISTORY.TAX_HANDLING], Zeichenkette)
- Spalte: Transfer Tax Pct ([O21.OPTIMA.import.UNIT_HISTORY.TRANSFER_TAX_PCT], Zahl)
- Spalte: Transfer Date ([O21.OPTIMA.import.UNIT_HISTORY.TRANSFER_DATE], Datum/Uhrzeit)
- Spalte: Transfer Sales Tax ([O21.OPTIMA.import.UNIT_HISTORY.TRANSFER_SALES_TAX], Zahl)
- Spalte: Transfer Purch Tax ([O21.OPTIMA.import.UNIT_HISTORY.TRANSFER_PURCH_TAX], Zahl)
- Spalte: Department ([O21.OPTIMA.import.UNIT_HISTORY.DEPARTMENT], Zeichenkette)
- Spalte: Book No ([O21.OPTIMA.import.UNIT_HISTORY.BOOK_NO], Zeichenkette)
- Spalte: Purch Invno ([O21.OPTIMA.import.UNIT_HISTORY.PURCH_INVNO], Zeichenkette)
- Spalte: Batch Number S ([O21.OPTIMA.import.UNIT_HISTORY.BATCH_NUMBER_S], Zahl)
- Spalte: Setoff Acct ([O21.OPTIMA.import.UNIT_HISTORY.SETOFF_ACCT], Zeichenkette)
- Spalte: Int Ext Code ([O21.OPTIMA.import.UNIT_HISTORY.INT_EXT_CODE], Zeichenkette)
- Spalte: Destination ([O21.OPTIMA.import.UNIT_HISTORY.DESTINATION], Zeichenkette)
- Spalte: Own Dimension 1 ([O21.OPTIMA.import.UNIT_HISTORY.OWN_DIMENSION_1], Zeichenkette)
- Spalte: Own Dimension 2 ([O21.OPTIMA.import.UNIT_HISTORY.OWN_DIMENSION_2], Zeichenkette)
- Spalte: Own Dimension 3 ([O21.OPTIMA.import.UNIT_HISTORY.OWN_DIMENSION_3], Zeichenkette)
- Spalte: Own Dimension 4 ([O21.OPTIMA.import.UNIT_HISTORY.OWN_DIMENSION_4], Zeichenkette)
- Spalte: Own Dimension 5 ([O21.OPTIMA.import.UNIT_HISTORY.OWN_DIMENSION_5], Zeichenkette)
- Spalte: Activity ([O21.OPTIMA.import.UNIT_HISTORY.ACTIVITY], Zeichenkette)
- Spalte: Vat Rate Code ([O21.OPTIMA.import.UNIT_HISTORY.VAT_RATE_CODE], Zeichenkette)
- Spalte: Calc Rule System ([O21.OPTIMA.import.UNIT_HISTORY.CALC_RULE_SYSTEM], Zahl)
- Spalte: Acc Amount Type ([O21.OPTIMA.import.UNIT_HISTORY.ACC_AMOUNT_TYPE], Zahl)
- Spalte: Transact Code Rev ([O21.OPTIMA.import.UNIT_HISTORY.TRANSACT_CODE_REV], Zeichenkette)
- Spalte: Int Voucher No ([O21.OPTIMA.import.UNIT_HISTORY.INT_VOUCHER_NO], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.UNIT_HISTORY.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.UNIT_HISTORY.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.UNIT_HISTORY.UNIQUE_IDENT], Zahl)
- Ordner: Vehicle
- Spalte: Basis Number ([O21.OPTIMA.import.VEHICLE.BASIS_NUMBER], Zeichenkette)
- Spalte: State Code Cf ([O21.OPTIMA.import.VEHICLE.STATE_CODE_CF], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VEHICLE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VEHICLE.HANDLER], Zeichenkette)
- Spalte: Debit Account ([O21.OPTIMA.import.VEHICLE.DEBIT_ACCOUNT], Zeichenkette)
- Spalte: Register Number ([O21.OPTIMA.import.VEHICLE.REGISTER_NUMBER], Zeichenkette)
- Spalte: Chassis Number ([O21.OPTIMA.import.VEHICLE.CHASSIS_NUMBER], Zeichenkette)
- Spalte: Car Group ([O21.OPTIMA.import.VEHICLE.CAR_GROUP], Zeichenkette)
- Spalte: Car Status ([O21.OPTIMA.import.VEHICLE.CAR_STATUS], Zeichenkette)
- Spalte: Fac Model Code L ([O21.OPTIMA.import.VEHICLE.FAC_MODEL_CODE_L], Zeichenkette)
- Spalte: User Code ([O21.OPTIMA.import.VEHICLE.USER_CODE], Zeichenkette)
- Spalte: Owner Code ([O21.OPTIMA.import.VEHICLE.OWNER_CODE], Zeichenkette)
- Spalte: Unit Accounting Cf ([O21.OPTIMA.import.VEHICLE.UNIT_ACCOUNTING_CF], Zeichenkette)
- Spalte: Contact Person ([O21.OPTIMA.import.VEHICLE.CONTACT_PERSON], Zeichenkette)
- Spalte: First Reg Date ([O21.OPTIMA.import.VEHICLE.FIRST_REG_DATE], Datum/Uhrzeit)
- Spalte: Latest Reg Date ([O21.OPTIMA.import.VEHICLE.LATEST_REG_DATE], Datum/Uhrzeit)
- Spalte: First Occur Date ([O21.OPTIMA.import.VEHICLE.FIRST_OCCUR_DATE], Datum/Uhrzeit)
- Spalte: Expected Arr Date ([O21.OPTIMA.import.VEHICLE.EXPECTED_ARR_DATE], Datum/Uhrzeit)
- Spalte: Arrival Date ([O21.OPTIMA.import.VEHICLE.ARRIVAL_DATE], Datum/Uhrzeit)
- Spalte: Last Owner Change ([O21.OPTIMA.import.VEHICLE.LAST_OWNER_CHANGE], Datum/Uhrzeit)
- Spalte: Salesman Buy ([O21.OPTIMA.import.VEHICLE.SALESMAN_BUY], Zeichenkette)
- Spalte: Salesman Sale ([O21.OPTIMA.import.VEHICLE.SALESMAN_SALE], Zeichenkette)
- Spalte: Model Text ([O21.OPTIMA.import.VEHICLE.MODEL_TEXT], Zeichenkette)
- Spalte: Orig Model Code1 ([O21.OPTIMA.import.VEHICLE.ORIG_MODEL_CODE1], Zeichenkette)
- Spalte: Orig Model Code2 ([O21.OPTIMA.import.VEHICLE.ORIG_MODEL_CODE2], Zeichenkette)
- Spalte: Colour Cf ([O21.OPTIMA.import.VEHICLE.COLOUR_CF], Zeichenkette)
- Spalte: Trim Txt ([O21.OPTIMA.import.VEHICLE.TRIM_TXT], Zeichenkette)
- Spalte: Model Line ([O21.OPTIMA.import.VEHICLE.MODEL_LINE], Zeichenkette)
- Spalte: Workshop Model ([O21.OPTIMA.import.VEHICLE.WORKSHOP_MODEL], Zeichenkette)
- Spalte: Fac Model Code S ([O21.OPTIMA.import.VEHICLE.FAC_MODEL_CODE_S], Zeichenkette)
- Spalte: Classification ([O21.OPTIMA.import.VEHICLE.CLASSIFICATION], Zeichenkette)
- Spalte: Motor Number ([O21.OPTIMA.import.VEHICLE.MOTOR_NUMBER], Zeichenkette)
- Spalte: Key Code ([O21.OPTIMA.import.VEHICLE.KEY_CODE], Zeichenkette)
- Spalte: Year Model Cf ([O21.OPTIMA.import.VEHICLE.YEAR_MODEL_CF], Zeichenkette)
- Spalte: Cylinder Volume ([O21.OPTIMA.import.VEHICLE.CYLINDER_VOLUME], Zahl)
- Spalte: Seats ([O21.OPTIMA.import.VEHICLE.SEATS], Zeichenkette)
- Spalte: Declaration Date ([O21.OPTIMA.import.VEHICLE.DECLARATION_DATE], Datum/Uhrzeit)
- Spalte: Declaration Place ([O21.OPTIMA.import.VEHICLE.DECLARATION_PLACE], Zeichenkette)
- Spalte: Declaration Number ([O21.OPTIMA.import.VEHICLE.DECLARATION_NUMBER], Zeichenkette)
- Spalte: Arrival Ship ([O21.OPTIMA.import.VEHICLE.ARRIVAL_SHIP], Zeichenkette)
- Spalte: Arrival Number ([O21.OPTIMA.import.VEHICLE.ARRIVAL_NUMBER], Zeichenkette)
- Spalte: Bill Of Landing ([O21.OPTIMA.import.VEHICLE.BILL_OF_LANDING], Zeichenkette)
- Spalte: Scrutineering Date ([O21.OPTIMA.import.VEHICLE.SCRUTINEERING_DATE], Datum/Uhrzeit)
- Spalte: Equipment 1 ([O21.OPTIMA.import.VEHICLE.EQUIPMENT_1], Zeichenkette)
- Spalte: Equipment 2 ([O21.OPTIMA.import.VEHICLE.EQUIPMENT_2], Zeichenkette)
- Spalte: Equipment 3 ([O21.OPTIMA.import.VEHICLE.EQUIPMENT_3], Zeichenkette)
- Spalte: Equipment 4 ([O21.OPTIMA.import.VEHICLE.EQUIPMENT_4], Zeichenkette)
- Spalte: Insurance ([O21.OPTIMA.import.VEHICLE.INSURANCE], Zeichenkette)
- Spalte: Insurance Company ([O21.OPTIMA.import.VEHICLE.INSURANCE_COMPANY], Zeichenkette)
- Spalte: Mileage ([O21.OPTIMA.import.VEHICLE.MILEAGE], Zahl)
- Spalte: Misc 1 Cf ([O21.OPTIMA.import.VEHICLE.MISC_1_CF], Zeichenkette)
- Spalte: Misc 2 Cf ([O21.OPTIMA.import.VEHICLE.MISC_2_CF], Zeichenkette)
- Spalte: Misc 3 Cf ([O21.OPTIMA.import.VEHICLE.MISC_3_CF], Zeichenkette)
- Spalte: Misc 4 Cf ([O21.OPTIMA.import.VEHICLE.MISC_4_CF], Zeichenkette)
- Spalte: Misc 5 Cf ([O21.OPTIMA.import.VEHICLE.MISC_5_CF], Zeichenkette)
- Spalte: Misc 6 Cf ([O21.OPTIMA.import.VEHICLE.MISC_6_CF], Zeichenkette)
- Spalte: Misc 7 Cf ([O21.OPTIMA.import.VEHICLE.MISC_7_CF], Zeichenkette)
- Spalte: Misc 8 Cf ([O21.OPTIMA.import.VEHICLE.MISC_8_CF], Zeichenkette)
- Spalte: Misc 9 Cf ([O21.OPTIMA.import.VEHICLE.MISC_9_CF], Zeichenkette)
- Spalte: Misc 10 Cf ([O21.OPTIMA.import.VEHICLE.MISC_10_CF], Zeichenkette)
- Spalte: Last Invoice Dte ([O21.OPTIMA.import.VEHICLE.LAST_INVOICE_DTE], Datum/Uhrzeit)
- Spalte: Contact Date ([O21.OPTIMA.import.VEHICLE.CONTACT_DATE], Datum/Uhrzeit)
- Spalte: Mail Code 1 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_1], Zeichenkette)
- Spalte: Mail Code 2 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_2], Zeichenkette)
- Spalte: Mail Code 3 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_3], Zeichenkette)
- Spalte: Mail Code 4 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_4], Zeichenkette)
- Spalte: Mail Code 5 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_5], Zeichenkette)
- Spalte: Mail Code 6 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_6], Zeichenkette)
- Spalte: Mail Code 7 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_7], Zeichenkette)
- Spalte: Mail Code 8 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_8], Zeichenkette)
- Spalte: Mail Code 9 ([O21.OPTIMA.import.VEHICLE.MAIL_CODE_9], Zeichenkette)
- Spalte: Motor Code ([O21.OPTIMA.import.VEHICLE.MOTOR_CODE], Zeichenkette)
- Spalte: Gear Code ([O21.OPTIMA.import.VEHICLE.GEAR_CODE], Zeichenkette)
- Spalte: Drive Code ([O21.OPTIMA.import.VEHICLE.DRIVE_CODE], Zeichenkette)
- Spalte: Colour Code ([O21.OPTIMA.import.VEHICLE.COLOUR_CODE], Zeichenkette)
- Spalte: Trim Code ([O21.OPTIMA.import.VEHICLE.TRIM_CODE], Zeichenkette)
- Spalte: Latest Unit No ([O21.OPTIMA.import.VEHICLE.LATEST_UNIT_NO], Zeichenkette)
- Spalte: Follow Up ([O21.OPTIMA.import.VEHICLE.FOLLOW_UP], Zeichenkette)
- Spalte: No Of Owners ([O21.OPTIMA.import.VEHICLE.NO_OF_OWNERS], Zahl)
- Spalte: Car Letter ([O21.OPTIMA.import.VEHICLE.CAR_LETTER], Zeichenkette)
- Spalte: Tuv Type ([O21.OPTIMA.import.VEHICLE.TUV_TYPE], Zeichenkette)
- Spalte: Tuv Date ([O21.OPTIMA.import.VEHICLE.TUV_DATE], Datum/Uhrzeit)
- Spalte: Tuv Insp ([O21.OPTIMA.import.VEHICLE.TUV_INSP], Zeichenkette)
- Spalte: Asu Type ([O21.OPTIMA.import.VEHICLE.ASU_TYPE], Zeichenkette)
- Spalte: Asu Date ([O21.OPTIMA.import.VEHICLE.ASU_DATE], Datum/Uhrzeit)
- Spalte: Asu Insp ([O21.OPTIMA.import.VEHICLE.ASU_INSP], Zeichenkette)
- Spalte: Type Year ([O21.OPTIMA.import.VEHICLE.TYPE_YEAR], Zeichenkette)
- Spalte: Package Cf ([O21.OPTIMA.import.VEHICLE.PACKAGE_CF], Zeichenkette)
- Spalte: Veh Ass Type ([O21.OPTIMA.import.VEHICLE.VEH_ASS_TYPE], Zeichenkette)
- Spalte: Sale This Year ([O21.OPTIMA.import.VEHICLE.SALE_THIS_YEAR], Zahl)
- Spalte: Sale Last Year ([O21.OPTIMA.import.VEHICLE.SALE_LAST_YEAR], Zahl)
- Spalte: Sale Last Year 1 ([O21.OPTIMA.import.VEHICLE.SALE_LAST_YEAR_1], Zahl)
- Spalte: Delete Proposal ([O21.OPTIMA.import.VEHICLE.DELETE_PROPOSAL], Zeichenkette)
- Spalte: Duplicate Reg No ([O21.OPTIMA.import.VEHICLE.DUPLICATE_REG_NO], Zeichenkette)
- Spalte: Leasing ([O21.OPTIMA.import.VEHICLE.LEASING], Zeichenkette)
- Spalte: Ship Date ([O21.OPTIMA.import.VEHICLE.SHIP_DATE], Datum/Uhrzeit)
- Spalte: Fac Order Number ([O21.OPTIMA.import.VEHICLE.FAC_ORDER_NUMBER], Zeichenkette)
- Spalte: Available ([O21.OPTIMA.import.VEHICLE.AVAILABLE], Zeichenkette)
- Spalte: Cal Cost ([O21.OPTIMA.import.VEHICLE.CAL_COST], Zeichenkette)
- Spalte: Cal Cost Date ([O21.OPTIMA.import.VEHICLE.CAL_COST_DATE], Datum/Uhrzeit)
- Spalte: Run 1 ([O21.OPTIMA.import.VEHICLE.RUN_1], Zeichenkette)
- Spalte: Run 2 ([O21.OPTIMA.import.VEHICLE.RUN_2], Zeichenkette)
- Spalte: Run 3 ([O21.OPTIMA.import.VEHICLE.RUN_3], Zeichenkette)
- Spalte: Run 4 ([O21.OPTIMA.import.VEHICLE.RUN_4], Zeichenkette)
- Spalte: Run 5 ([O21.OPTIMA.import.VEHICLE.RUN_5], Zeichenkette)
- Spalte: Run 6 ([O21.OPTIMA.import.VEHICLE.RUN_6], Zeichenkette)
- Spalte: Run 7 ([O21.OPTIMA.import.VEHICLE.RUN_7], Zeichenkette)
- Spalte: Run 8 ([O21.OPTIMA.import.VEHICLE.RUN_8], Zeichenkette)
- Spalte: Run 9 ([O21.OPTIMA.import.VEHICLE.RUN_9], Zeichenkette)
- Spalte: Run 10 ([O21.OPTIMA.import.VEHICLE.RUN_10], Zeichenkette)
- Spalte: Run 11 ([O21.OPTIMA.import.VEHICLE.RUN_11], Zeichenkette)
- Spalte: Run 12 ([O21.OPTIMA.import.VEHICLE.RUN_12], Zeichenkette)
- Spalte: Run 13 ([O21.OPTIMA.import.VEHICLE.RUN_13], Zeichenkette)
- Spalte: Run 14 ([O21.OPTIMA.import.VEHICLE.RUN_14], Zeichenkette)
- Spalte: Run 15 ([O21.OPTIMA.import.VEHICLE.RUN_15], Zeichenkette)
- Spalte: Run 16 ([O21.OPTIMA.import.VEHICLE.RUN_16], Zeichenkette)
- Spalte: Run 17 ([O21.OPTIMA.import.VEHICLE.RUN_17], Zeichenkette)
- Spalte: Run 18 ([O21.OPTIMA.import.VEHICLE.RUN_18], Zeichenkette)
- Spalte: Run 19 ([O21.OPTIMA.import.VEHICLE.RUN_19], Zeichenkette)
- Spalte: Run 20 ([O21.OPTIMA.import.VEHICLE.RUN_20], Zeichenkette)
- Spalte: Stock Date ([O21.OPTIMA.import.VEHICLE.STOCK_DATE], Datum/Uhrzeit)
- Spalte: Marking 1 ([O21.OPTIMA.import.VEHICLE.MARKING_1], Zeichenkette)
- Spalte: Marking 2 ([O21.OPTIMA.import.VEHICLE.MARKING_2], Zeichenkette)
- Spalte: Marking 3 ([O21.OPTIMA.import.VEHICLE.MARKING_3], Zeichenkette)
- Spalte: Marking 4 ([O21.OPTIMA.import.VEHICLE.MARKING_4], Zeichenkette)
- Spalte: Marking 5 ([O21.OPTIMA.import.VEHICLE.MARKING_5], Zeichenkette)
- Spalte: Imp Order Number ([O21.OPTIMA.import.VEHICLE.IMP_ORDER_NUMBER], Zeichenkette)
- Spalte: Scrap Date ([O21.OPTIMA.import.VEHICLE.SCRAP_DATE], Datum/Uhrzeit)
- Spalte: Transmission Date ([O21.OPTIMA.import.VEHICLE.TRANSMISSION_DATE], Datum/Uhrzeit)
- Spalte: Purch Cal Date ([O21.OPTIMA.import.VEHICLE.PURCH_CAL_DATE], Datum/Uhrzeit)
- Spalte: Sales Cal Date ([O21.OPTIMA.import.VEHICLE.SALES_CAL_DATE], Datum/Uhrzeit)
- Spalte: Dealer Del Date ([O21.OPTIMA.import.VEHICLE.DEALER_DEL_DATE], Datum/Uhrzeit)
- Spalte: Optional Date 1 ([O21.OPTIMA.import.VEHICLE.OPTIONAL_DATE_1], Datum/Uhrzeit)
- Spalte: Optional Date 2 ([O21.OPTIMA.import.VEHICLE.OPTIONAL_DATE_2], Datum/Uhrzeit)
- Spalte: Optional Date 3 ([O21.OPTIMA.import.VEHICLE.OPTIONAL_DATE_3], Datum/Uhrzeit)
- Spalte: Optional Date 4 ([O21.OPTIMA.import.VEHICLE.OPTIONAL_DATE_4], Datum/Uhrzeit)
- Spalte: Optional Date 5 ([O21.OPTIMA.import.VEHICLE.OPTIONAL_DATE_5], Datum/Uhrzeit)
- Spalte: Model Line Group ([O21.OPTIMA.import.VEHICLE.MODEL_LINE_GROUP], Zeichenkette)
- Spalte: Model Type 2 ([O21.OPTIMA.import.VEHICLE.MODEL_TYPE_2], Zeichenkette)
- Spalte: Make ([O21.OPTIMA.import.VEHICLE.MAKE], Zeichenkette)
- Spalte: Hour Rate Table ([O21.OPTIMA.import.VEHICLE.HOUR_RATE_TABLE], Zeichenkette)
- Spalte: Paid Date ([O21.OPTIMA.import.VEHICLE.PAID_DATE], Datum/Uhrzeit)
- Spalte: Latest Inv Date ([O21.OPTIMA.import.VEHICLE.LATEST_INV_DATE], Datum/Uhrzeit)
- Spalte: Orig Inv Date ([O21.OPTIMA.import.VEHICLE.ORIG_INV_DATE], Datum/Uhrzeit)
- Spalte: Credit Note Date ([O21.OPTIMA.import.VEHICLE.CREDIT_NOTE_DATE], Datum/Uhrzeit)
- Spalte: Extraction Date ([O21.OPTIMA.import.VEHICLE.EXTRACTION_DATE], Datum/Uhrzeit)
- Spalte: Prod Info ([O21.OPTIMA.import.VEHICLE.PROD_INFO], Zeichenkette)
- Spalte: Reg Number Imp ([O21.OPTIMA.import.VEHICLE.REG_NUMBER_IMP], Zeichenkette)
- Spalte: Price Card ([O21.OPTIMA.import.VEHICLE.PRICE_CARD], Zeichenkette)
- Spalte: Purch Amount ([O21.OPTIMA.import.VEHICLE.PURCH_AMOUNT], Zahl)
- Spalte: Dealer Number ([O21.OPTIMA.import.VEHICLE.DEALER_NUMBER], Zeichenkette)
- Spalte: Invoice State ([O21.OPTIMA.import.VEHICLE.INVOICE_STATE], Zeichenkette)
- Spalte: Veh Due Date ([O21.OPTIMA.import.VEHICLE.VEH_DUE_DATE], Datum/Uhrzeit)
- Spalte: Dealer Marking ([O21.OPTIMA.import.VEHICLE.DEALER_MARKING], Zeichenkette)
- Spalte: Trade In Car ([O21.OPTIMA.import.VEHICLE.TRADE_IN_CAR], Zeichenkette)
- Spalte: Trade In Car Year ([O21.OPTIMA.import.VEHICLE.TRADE_IN_CAR_YEAR], Zahl)
- Spalte: Export Vehicle ([O21.OPTIMA.import.VEHICLE.EXPORT_VEHICLE], Zeichenkette)
- Spalte: Doors ([O21.OPTIMA.import.VEHICLE.DOORS], Zahl)
- Spalte: Kba Code ([O21.OPTIMA.import.VEHICLE.KBA_CODE], Zeichenkette)
- Spalte: Fueltype ([O21.OPTIMA.import.VEHICLE.FUELTYPE], Zeichenkette)
- Spalte: Fuel Cons Town ([O21.OPTIMA.import.VEHICLE.FUEL_CONS_TOWN], Zahl)
- Spalte: Fuel Cons 90kmh ([O21.OPTIMA.import.VEHICLE.FUEL_CONS_90KMH], Zahl)
- Spalte: Fuel Cons Eunorm ([O21.OPTIMA.import.VEHICLE.FUEL_CONS_EUNORM], Zahl)
- Spalte: Call For Service ([O21.OPTIMA.import.VEHICLE.CALL_FOR_SERVICE], Zeichenkette)
- Spalte: Exp Km Per Year ([O21.OPTIMA.import.VEHICLE.EXP_KM_PER_YEAR], Zahl)
- Spalte: Exp Service Date 1 ([O21.OPTIMA.import.VEHICLE.EXP_SERVICE_DATE_1], Datum/Uhrzeit)
- Spalte: Exp Service Date 2 ([O21.OPTIMA.import.VEHICLE.EXP_SERVICE_DATE_2], Datum/Uhrzeit)
- Spalte: Exp Service Date 3 ([O21.OPTIMA.import.VEHICLE.EXP_SERVICE_DATE_3], Datum/Uhrzeit)
- Spalte: Exp Service Date 4 ([O21.OPTIMA.import.VEHICLE.EXP_SERVICE_DATE_4], Datum/Uhrzeit)
- Spalte: Exp Service Date 5 ([O21.OPTIMA.import.VEHICLE.EXP_SERVICE_DATE_5], Datum/Uhrzeit)
- Spalte: Dealer Message No ([O21.OPTIMA.import.VEHICLE.DEALER_MESSAGE_NO], Zeichenkette)
- Spalte: Service Days ([O21.OPTIMA.import.VEHICLE.SERVICE_DAYS], Zahl)
- Spalte: Hourly Repair Rate ([O21.OPTIMA.import.VEHICLE.HOURLY_REPAIR_RATE], Zahl)
- Spalte: Workshop Pricecode ([O21.OPTIMA.import.VEHICLE.WORKSHOP_PRICECODE], Zeichenkette)
- Spalte: Discount Perc Work ([O21.OPTIMA.import.VEHICLE.DISCOUNT_PERC_WORK], Zahl)
- Spalte: Soldmark Date ([O21.OPTIMA.import.VEHICLE.SOLDMARK_DATE], Datum/Uhrzeit)
- Spalte: Mobil Sc Date ([O21.OPTIMA.import.VEHICLE.MOBIL_SC_DATE], Datum/Uhrzeit)
- Spalte: Type Cer Txt ([O21.OPTIMA.import.VEHICLE.TYPE_CER_TXT], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.VEHICLE.MAKE_CD], Zeichenkette)
- Spalte: Veh Location ([O21.OPTIMA.import.VEHICLE.VEH_LOCATION], Zeichenkette)
- Spalte: Imp Comment ([O21.OPTIMA.import.VEHICLE.IMP_COMMENT], Zeichenkette)
- Spalte: Dealer Note ([O21.OPTIMA.import.VEHICLE.DEALER_NOTE], Zeichenkette)
- Spalte: Deliver To Dealer ([O21.OPTIMA.import.VEHICLE.DELIVER_TO_DEALER], Zeichenkette)
- Spalte: Trade In Car Chas ([O21.OPTIMA.import.VEHICLE.TRADE_IN_CAR_CHAS], Zeichenkette)
- Spalte: Gms Reference ([O21.OPTIMA.import.VEHICLE.GMS_REFERENCE], Zeichenkette)
- Spalte: Use Of Vehicle ([O21.OPTIMA.import.VEHICLE.USE_OF_VEHICLE], Zeichenkette)
- Spalte: Paint Type ([O21.OPTIMA.import.VEHICLE.PAINT_TYPE], Zeichenkette)
- Spalte: Gear No ([O21.OPTIMA.import.VEHICLE.GEAR_NO], Zeichenkette)
- Spalte: Serv Contract No ([O21.OPTIMA.import.VEHICLE.SERV_CONTRACT_NO], Zeichenkette)
- Spalte: Production No ([O21.OPTIMA.import.VEHICLE.PRODUCTION_NO], Zeichenkette)
- Spalte: Photo ([O21.OPTIMA.import.VEHICLE.PHOTO], Zeichenkette)
- Spalte: Upload Marking ([O21.OPTIMA.import.VEHICLE.UPLOAD_MARKING], Zeichenkette)
- Spalte: Door Code ([O21.OPTIMA.import.VEHICLE.DOOR_CODE], Zeichenkette)
- Spalte: Bpm Amount ([O21.OPTIMA.import.VEHICLE.BPM_AMOUNT], Zahl)
- Spalte: Radio Code ([O21.OPTIMA.import.VEHICLE.RADIO_CODE], Zeichenkette)
- Spalte: Warrenty End ([O21.OPTIMA.import.VEHICLE.WARRENTY_END], Datum/Uhrzeit)
- Spalte: Last Mot Date ([O21.OPTIMA.import.VEHICLE.LAST_MOT_DATE], Datum/Uhrzeit)
- Spalte: Last Service Date ([O21.OPTIMA.import.VEHICLE.LAST_SERVICE_DATE], Datum/Uhrzeit)
- Spalte: Last Service Txt ([O21.OPTIMA.import.VEHICLE.LAST_SERVICE_TXT], Zeichenkette)
- Spalte: Replacement Date ([O21.OPTIMA.import.VEHICLE.REPLACEMENT_DATE], Datum/Uhrzeit)
- Spalte: Next Service Txt ([O21.OPTIMA.import.VEHICLE.NEXT_SERVICE_TXT], Zeichenkette)
- Spalte: Maintain Int Years ([O21.OPTIMA.import.VEHICLE.MAINTAIN_INT_YEARS], Zahl)
- Spalte: Maintain Int Miles ([O21.OPTIMA.import.VEHICLE.MAINTAIN_INT_MILES], Zahl)
- Spalte: Sales Location ([O21.OPTIMA.import.VEHICLE.SALES_LOCATION], Zeichenkette)
- Spalte: Service Location ([O21.OPTIMA.import.VEHICLE.SERVICE_LOCATION], Zeichenkette)
- Spalte: Fiscal Horsepower ([O21.OPTIMA.import.VEHICLE.FISCAL_HORSEPOWER], Zahl)
- Spalte: Export Eurocasion ([O21.OPTIMA.import.VEHICLE.EXPORT_EUROCASION], Zeichenkette)
- Spalte: Horsepower ([O21.OPTIMA.import.VEHICLE.HORSEPOWER], Zahl)
- Spalte: Gov Cert Request Date ([O21.OPTIMA.import.VEHICLE.GOV_CERT_REQUEST_DATE], Datum/Uhrzeit)
- Spalte: Gov Cert Reception Date ([O21.OPTIMA.import.VEHICLE.GOV_CERT_RECEPTION_DATE], Datum/Uhrzeit)
- Spalte: Conv Flag ([O21.OPTIMA.import.VEHICLE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VEHICLE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VEHICLE.UNIQUE_IDENT], Zahl)
- Ordner: Vpp43
- Spalte: Seller Code ([O21.OPTIMA.import.VPP43.SELLER_CODE], Zeichenkette)
- Spalte: Order Approv Perm ([O21.OPTIMA.import.VPP43.ORDER_APPROV_PERM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP43.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP43.HANDLER], Zeichenkette)
- Spalte: Sel Name ([O21.OPTIMA.import.VPP43.SEL_NAME], Zeichenkette)
- Spalte: Sel Department ([O21.OPTIMA.import.VPP43.SEL_DEPARTMENT], Zeichenkette)
- Spalte: Sel First Name ([O21.OPTIMA.import.VPP43.SEL_FIRST_NAME], Zeichenkette)
- Spalte: Sel Family Name ([O21.OPTIMA.import.VPP43.SEL_FAMILY_NAME], Zeichenkette)
- Spalte: Sel Title ([O21.OPTIMA.import.VPP43.SEL_TITLE], Zeichenkette)
- Spalte: Sel Male Female ([O21.OPTIMA.import.VPP43.SEL_MALE_FEMALE], Zahl)
- Spalte: Sel Factor ([O21.OPTIMA.import.VPP43.SEL_FACTOR], Zahl)
- Spalte: Sel Com Salesman ([O21.OPTIMA.import.VPP43.SEL_COM_SALESMAN], Zahl)
- Spalte: Mechanic Pay Group ([O21.OPTIMA.import.VPP43.MECHANIC_PAY_GROUP], Zeichenkette)
- Spalte: Licence Id ([O21.OPTIMA.import.VPP43.LICENCE_ID], Zeichenkette)
- Spalte: Employee Category ([O21.OPTIMA.import.VPP43.EMPLOYEE_CATEGORY], Zahl)
- Spalte: Trainee Year ([O21.OPTIMA.import.VPP43.TRAINEE_YEAR], Zahl)
- Spalte: Email Address ([O21.OPTIMA.import.VPP43.EMAIL_ADDRESS], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP43.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP43.UNIQUE_IDENT], Zahl)
- Ordner: Customer
- Spalte: Customer Number ([O21.OPTIMA.import.CUSTOMER.CUSTOMER_NUMBER], Zeichenkette)
- Spalte: State Code Cust ([O21.OPTIMA.import.CUSTOMER.STATE_CODE_CUST], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.CUSTOMER.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.CUSTOMER.HANDLER], Zeichenkette)
- Spalte: Cust Alt Key ([O21.OPTIMA.import.CUSTOMER.CUST_ALT_KEY], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.CUSTOMER.NAME], Zeichenkette)
- Spalte: Street Addr ([O21.OPTIMA.import.CUSTOMER.STREET_ADDR], Zeichenkette)
- Spalte: Addr 2 ([O21.OPTIMA.import.CUSTOMER.ADDR_2], Zeichenkette)
- Spalte: Mail Addr ([O21.OPTIMA.import.CUSTOMER.MAIL_ADDR], Zeichenkette)
- Spalte: Zipcode ([O21.OPTIMA.import.CUSTOMER.ZIPCODE], Zeichenkette)
- Spalte: Debit Customer ([O21.OPTIMA.import.CUSTOMER.DEBIT_CUSTOMER], Zeichenkette)
- Spalte: Title Code ([O21.OPTIMA.import.CUSTOMER.TITLE_CODE], Zeichenkette)
- Spalte: Title ([O21.OPTIMA.import.CUSTOMER.TITLE], Zeichenkette)
- Spalte: Pmt Term ([O21.OPTIMA.import.CUSTOMER.PMT_TERM], Zeichenkette)
- Spalte: Invoice Copy Code ([O21.OPTIMA.import.CUSTOMER.INVOICE_COPY_CODE], Zeichenkette)
- Spalte: Delivery Way Code ([O21.OPTIMA.import.CUSTOMER.DELIVERY_WAY_CODE], Zeichenkette)
- Spalte: Small Accessories ([O21.OPTIMA.import.CUSTOMER.SMALL_ACCESSORIES], Zeichenkette)
- Spalte: Small Inv Charge ([O21.OPTIMA.import.CUSTOMER.SMALL_INV_CHARGE], Zeichenkette)
- Spalte: Workshop Pricecode ([O21.OPTIMA.import.CUSTOMER.WORKSHOP_PRICECODE], Zeichenkette)
- Spalte: Vat Regno ([O21.OPTIMA.import.CUSTOMER.VAT_REGNO], Zeichenkette)
- Spalte: Salesman ([O21.OPTIMA.import.CUSTOMER.SALESMAN], Zeichenkette)
- Spalte: Gross Discount ([O21.OPTIMA.import.CUSTOMER.GROSS_DISCOUNT], Zeichenkette)
- Spalte: Delivery Stop Code ([O21.OPTIMA.import.CUSTOMER.DELIVERY_STOP_CODE], Zeichenkette)
- Spalte: Credit Limit ([O21.OPTIMA.import.CUSTOMER.CREDIT_LIMIT], Zahl)
- Spalte: Reminder Code ([O21.OPTIMA.import.CUSTOMER.REMINDER_CODE], Zeichenkette)
- Spalte: Account Type Cu ([O21.OPTIMA.import.CUSTOMER.ACCOUNT_TYPE_CU], Zeichenkette)
- Spalte: Account Print ([O21.OPTIMA.import.CUSTOMER.ACCOUNT_PRINT], Zeichenkette)
- Spalte: Bank Name ([O21.OPTIMA.import.CUSTOMER.BANK_NAME], Zeichenkette)
- Spalte: Bank Reg No ([O21.OPTIMA.import.CUSTOMER.BANK_REG_NO], Zeichenkette)
- Spalte: Bank Account No ([O21.OPTIMA.import.CUSTOMER.BANK_ACCOUNT_NO], Zeichenkette)
- Spalte: Payment Way ([O21.OPTIMA.import.CUSTOMER.PAYMENT_WAY], Zeichenkette)
- Spalte: Price Code ([O21.OPTIMA.import.CUSTOMER.PRICE_CODE], Zeichenkette)
- Spalte: Discount Perc Work ([O21.OPTIMA.import.CUSTOMER.DISCOUNT_PERC_WORK], Zahl)
- Spalte: Discount Limit ([O21.OPTIMA.import.CUSTOMER.DISCOUNT_LIMIT], Zeichenkette)
- Spalte: Annual Disc Perc ([O21.OPTIMA.import.CUSTOMER.ANNUAL_DISC_PERC], Zahl)
- Spalte: Annual Disc Amount ([O21.OPTIMA.import.CUSTOMER.ANNUAL_DISC_AMOUNT], Zahl)
- Spalte: Annual Disc Code ([O21.OPTIMA.import.CUSTOMER.ANNUAL_DISC_CODE], Zeichenkette)
- Spalte: Advert Disc Perc ([O21.OPTIMA.import.CUSTOMER.ADVERT_DISC_PERC], Zahl)
- Spalte: Advert Disc Amount ([O21.OPTIMA.import.CUSTOMER.ADVERT_DISC_AMOUNT], Zahl)
- Spalte: Internal Code Cust ([O21.OPTIMA.import.CUSTOMER.INTERNAL_CODE_CUST], Zeichenkette)
- Spalte: Customer Group ([O21.OPTIMA.import.CUSTOMER.CUSTOMER_GROUP], Zeichenkette)
- Spalte: Customer Prospect ([O21.OPTIMA.import.CUSTOMER.CUSTOMER_PROSPECT], Zeichenkette)
- Spalte: Tax Code ([O21.OPTIMA.import.CUSTOMER.TAX_CODE], Zeichenkette)
- Spalte: Fleet Owner ([O21.OPTIMA.import.CUSTOMER.FLEET_OWNER], Zeichenkette)
- Spalte: Contact Person ([O21.OPTIMA.import.CUSTOMER.CONTACT_PERSON], Zeichenkette)
- Spalte: Phone 1 ([O21.OPTIMA.import.CUSTOMER.PHONE_1], Zeichenkette)
- Spalte: Phone 2 ([O21.OPTIMA.import.CUSTOMER.PHONE_2], Zeichenkette)
- Spalte: Comment 1 ([O21.OPTIMA.import.CUSTOMER.COMMENT_1], Zeichenkette)
- Spalte: Comment 2 ([O21.OPTIMA.import.CUSTOMER.COMMENT_2], Zeichenkette)
- Spalte: Contact Date ([O21.OPTIMA.import.CUSTOMER.CONTACT_DATE], Datum/Uhrzeit)
- Spalte: Mail Code 1 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_1], Zeichenkette)
- Spalte: Mail Code 2 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_2], Zeichenkette)
- Spalte: Mail Code 3 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_3], Zeichenkette)
- Spalte: Mail Code 4 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_4], Zeichenkette)
- Spalte: Mail Code 5 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_5], Zeichenkette)
- Spalte: Mail Code 6 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_6], Zeichenkette)
- Spalte: Mail Code 7 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_7], Zeichenkette)
- Spalte: Mail Code 8 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_8], Zeichenkette)
- Spalte: Mail Code 9 ([O21.OPTIMA.import.CUSTOMER.MAIL_CODE_9], Zeichenkette)
- Spalte: Last Invoice Date ([O21.OPTIMA.import.CUSTOMER.LAST_INVOICE_DATE], Datum/Uhrzeit)
- Spalte: Profit C U ([O21.OPTIMA.import.CUSTOMER.PROFIT_C_U], Zahl)
- Spalte: Debited Mm Cust ([O21.OPTIMA.import.CUSTOMER.DEBITED_MM_CUST], Zahl)
- Spalte: Debited Ty Cust ([O21.OPTIMA.import.CUSTOMER.DEBITED_TY_CUST], Zahl)
- Spalte: Debited Prye Cust ([O21.OPTIMA.import.CUSTOMER.DEBITED_PRYE_CUST], Zahl)
- Spalte: Discount Mm Cust ([O21.OPTIMA.import.CUSTOMER.DISCOUNT_MM_CUST], Zahl)
- Spalte: Discount Ty Cust ([O21.OPTIMA.import.CUSTOMER.DISCOUNT_TY_CUST], Zahl)
- Spalte: Discount Py Cust ([O21.OPTIMA.import.CUSTOMER.DISCOUNT_PY_CUST], Zahl)
- Spalte: Marg Mm Cust ([O21.OPTIMA.import.CUSTOMER.MARG_MM_CUST], Zahl)
- Spalte: Marg Ty Cust ([O21.OPTIMA.import.CUSTOMER.MARG_TY_CUST], Zahl)
- Spalte: Marg Py Cust ([O21.OPTIMA.import.CUSTOMER.MARG_PY_CUST], Zahl)
- Spalte: Saldo C U Cust ([O21.OPTIMA.import.CUSTOMER.SALDO_C_U_CUST], Zahl)
- Spalte: Last Pmt Dte Cust ([O21.OPTIMA.import.CUSTOMER.LAST_PMT_DTE_CUST], Datum/Uhrzeit)
- Spalte: Pmt Time Cust ([O21.OPTIMA.import.CUSTOMER.PMT_TIME_CUST], Zahl)
- Spalte: Interests ([O21.OPTIMA.import.CUSTOMER.INTERESTS], Zahl)
- Spalte: Saldo Last St ([O21.OPTIMA.import.CUSTOMER.SALDO_LAST_ST], Zahl)
- Spalte: Aos Deal Number ([O21.OPTIMA.import.CUSTOMER.AOS_DEAL_NUMBER], Zeichenkette)
- Spalte: Cpr Number ([O21.OPTIMA.import.CUSTOMER.CPR_NUMBER], Zahl)
- Spalte: Delete Proposal ([O21.OPTIMA.import.CUSTOMER.DELETE_PROPOSAL], Zeichenkette)
- Spalte: Creation Date ([O21.OPTIMA.import.CUSTOMER.CREATION_DATE], Datum/Uhrzeit)
- Spalte: Creater ([O21.OPTIMA.import.CUSTOMER.CREATER], Zeichenkette)
- Spalte: Reduction Code ([O21.OPTIMA.import.CUSTOMER.REDUCTION_CODE], Zeichenkette)
- Spalte: Start No ([O21.OPTIMA.import.CUSTOMER.START_NO], Zahl)
- Spalte: Last No ([O21.OPTIMA.import.CUSTOMER.LAST_NO], Zahl)
- Spalte: Latest Period ([O21.OPTIMA.import.CUSTOMER.LATEST_PERIOD], Datum/Uhrzeit)
- Spalte: Reminder Group ([O21.OPTIMA.import.CUSTOMER.REMINDER_GROUP], Zeichenkette)
- Spalte: Reminder Date ([O21.OPTIMA.import.CUSTOMER.REMINDER_DATE], Datum/Uhrzeit)
- Spalte: Pmt Termcode 2 ([O21.OPTIMA.import.CUSTOMER.PMT_TERMCODE_2], Zeichenkette)
- Spalte: Back Order Deliv ([O21.OPTIMA.import.CUSTOMER.BACK_ORDER_DELIV], Zeichenkette)
- Spalte: Country Code Cu ([O21.OPTIMA.import.CUSTOMER.COUNTRY_CODE_CU], Zeichenkette)
- Spalte: Instalment Code ([O21.OPTIMA.import.CUSTOMER.INSTALMENT_CODE], Zahl)
- Spalte: Follow Up Cu ([O21.OPTIMA.import.CUSTOMER.FOLLOW_UP_CU], Zeichenkette)
- Spalte: Vat Table Work ([O21.OPTIMA.import.CUSTOMER.VAT_TABLE_WORK], Zeichenkette)
- Spalte: Vat Table Normal ([O21.OPTIMA.import.CUSTOMER.VAT_TABLE_NORMAL], Zeichenkette)
- Spalte: Vat Table ([O21.OPTIMA.import.CUSTOMER.VAT_TABLE], Zeichenkette)
- Spalte: Occupation Code ([O21.OPTIMA.import.CUSTOMER.OCCUPATION_CODE], Zeichenkette)
- Spalte: Telefax Number ([O21.OPTIMA.import.CUSTOMER.TELEFAX_NUMBER], Zeichenkette)
- Spalte: Language Code ([O21.OPTIMA.import.CUSTOMER.LANGUAGE_CODE], Zeichenkette)
- Spalte: Birthday ([O21.OPTIMA.import.CUSTOMER.BIRTHDAY], Datum/Uhrzeit)
- Spalte: Birthday2 ([O21.OPTIMA.import.CUSTOMER.BIRTHDAY2], Datum/Uhrzeit)
- Spalte: Addr 3 ([O21.OPTIMA.import.CUSTOMER.ADDR_3], Zeichenkette)
- Spalte: County ([O21.OPTIMA.import.CUSTOMER.COUNTY], Zeichenkette)
- Spalte: Max Booking Days ([O21.OPTIMA.import.CUSTOMER.MAX_BOOKING_DAYS], Zahl)
- Spalte: Department 5 ([O21.OPTIMA.import.CUSTOMER.DEPARTMENT_5], Zahl)
- Spalte: Rib Key ([O21.OPTIMA.import.CUSTOMER.RIB_KEY], Zahl)
- Spalte: Price A G ([O21.OPTIMA.import.CUSTOMER.PRICE_A_G], Zeichenkette)
- Spalte: Req No Compulsory ([O21.OPTIMA.import.CUSTOMER.REQ_NO_COMPULSORY], Zeichenkette)
- Spalte: Vat Regno Eu ([O21.OPTIMA.import.CUSTOMER.VAT_REGNO_EU], Zeichenkette)
- Spalte: Workshop Salesman ([O21.OPTIMA.import.CUSTOMER.WORKSHOP_SALESMAN], Zeichenkette)
- Spalte: Hourly Repair Rate ([O21.OPTIMA.import.CUSTOMER.HOURLY_REPAIR_RATE], Zahl)
- Spalte: Elec Invoice ([O21.OPTIMA.import.CUSTOMER.ELEC_INVOICE], Zeichenkette)
- Spalte: Elec Del Note ([O21.OPTIMA.import.CUSTOMER.ELEC_DEL_NOTE], Zeichenkette)
- Spalte: Elec Order Conf ([O21.OPTIMA.import.CUSTOMER.ELEC_ORDER_CONF], Zeichenkette)
- Spalte: Elec Invoice Form ([O21.OPTIMA.import.CUSTOMER.ELEC_INVOICE_FORM], Zeichenkette)
- Spalte: Elec Coll Inv Form ([O21.OPTIMA.import.CUSTOMER.ELEC_COLL_INV_FORM], Zeichenkette)
- Spalte: Elec Del Note Form ([O21.OPTIMA.import.CUSTOMER.ELEC_DEL_NOTE_FORM], Zeichenkette)
- Spalte: Elec Ord Conf Form ([O21.OPTIMA.import.CUSTOMER.ELEC_ORD_CONF_FORM], Zeichenkette)
- Spalte: Only Coll Invoice ([O21.OPTIMA.import.CUSTOMER.ONLY_COLL_INVOICE], Zeichenkette)
- Spalte: Cust Company No ([O21.OPTIMA.import.CUSTOMER.CUST_COMPANY_NO], Zeichenkette)
- Spalte: Dealer Number ([O21.OPTIMA.import.CUSTOMER.DEALER_NUMBER], Zeichenkette)
- Spalte: Mobile Phone ([O21.OPTIMA.import.CUSTOMER.MOBILE_PHONE], Zeichenkette)
- Spalte: Mobile Phone 2 ([O21.OPTIMA.import.CUSTOMER.MOBILE_PHONE_2], Zeichenkette)
- Spalte: E Mail Address ([O21.OPTIMA.import.CUSTOMER.E_MAIL_ADDRESS], Zeichenkette)
- Spalte: E Mail Address 2 ([O21.OPTIMA.import.CUSTOMER.E_MAIL_ADDRESS_2], Zeichenkette)
- Spalte: Branch ([O21.OPTIMA.import.CUSTOMER.BRANCH], Zeichenkette)
- Spalte: Declaration State ([O21.OPTIMA.import.CUSTOMER.DECLARATION_STATE], Zeichenkette)
- Spalte: Use Work Type Code ([O21.OPTIMA.import.CUSTOMER.USE_WORK_TYPE_CODE], Zeichenkette)
- Spalte: Fleet Id Number ([O21.OPTIMA.import.CUSTOMER.FLEET_ID_NUMBER], Zeichenkette)
- Spalte: First Name ([O21.OPTIMA.import.CUSTOMER.FIRST_NAME], Zeichenkette)
- Spalte: Last Name ([O21.OPTIMA.import.CUSTOMER.LAST_NAME], Zeichenkette)
- Spalte: Gender ([O21.OPTIMA.import.CUSTOMER.GENDER], Zeichenkette)
- Spalte: Company ([O21.OPTIMA.import.CUSTOMER.COMPANY], Zeichenkette)
- Spalte: Mail Suppress ([O21.OPTIMA.import.CUSTOMER.MAIL_SUPPRESS], Zeichenkette)
- Spalte: Po Box 15 ([O21.OPTIMA.import.CUSTOMER.PO_BOX_15], Zeichenkette)
- Spalte: Po Box Zipcode ([O21.OPTIMA.import.CUSTOMER.PO_BOX_ZIPCODE], Zeichenkette)
- Spalte: Po Box Town ([O21.OPTIMA.import.CUSTOMER.PO_BOX_TOWN], Zeichenkette)
- Spalte: Web Address ([O21.OPTIMA.import.CUSTOMER.WEB_ADDRESS], Zeichenkette)
- Spalte: Family Status ([O21.OPTIMA.import.CUSTOMER.FAMILY_STATUS], Zeichenkette)
- Spalte: Children ([O21.OPTIMA.import.CUSTOMER.CHILDREN], Zahl)
- Spalte: Hobby ([O21.OPTIMA.import.CUSTOMER.HOBBY], Zeichenkette)
- Spalte: Ext Customer Group ([O21.OPTIMA.import.CUSTOMER.EXT_CUSTOMER_GROUP], Zeichenkette)
- Spalte: Membership Number ([O21.OPTIMA.import.CUSTOMER.MEMBERSHIP_NUMBER], Zeichenkette)
- Spalte: Trade Register ([O21.OPTIMA.import.CUSTOMER.TRADE_REGISTER], Zeichenkette)
- Spalte: Pdf Invoice ([O21.OPTIMA.import.CUSTOMER.PDF_INVOICE], Zeichenkette)
- Spalte: E Commerce Veh ([O21.OPTIMA.import.CUSTOMER.E_COMMERCE_VEH], Zeichenkette)
- Spalte: E Mail Address 3 ([O21.OPTIMA.import.CUSTOMER.E_MAIL_ADDRESS_3], Zeichenkette)
- Spalte: Send Order Advice ([O21.OPTIMA.import.CUSTOMER.SEND_ORDER_ADVICE], Zeichenkette)
- Spalte: Sales Location ([O21.OPTIMA.import.CUSTOMER.SALES_LOCATION], Zeichenkette)
- Spalte: Service Location ([O21.OPTIMA.import.CUSTOMER.SERVICE_LOCATION], Zeichenkette)
- Spalte: Street Number ([O21.OPTIMA.import.CUSTOMER.STREET_NUMBER], Zahl)
- Spalte: Street Number Ext ([O21.OPTIMA.import.CUSTOMER.STREET_NUMBER_EXT], Zeichenkette)
- Spalte: Street Number Ext2 ([O21.OPTIMA.import.CUSTOMER.STREET_NUMBER_EXT2], Zeichenkette)
- Spalte: Mail Addr 2 ([O21.OPTIMA.import.CUSTOMER.MAIL_ADDR_2], Zeichenkette)
- Spalte: County 2 ([O21.OPTIMA.import.CUSTOMER.COUNTY_2], Zeichenkette)
- Spalte: External Id ([O21.OPTIMA.import.CUSTOMER.EXTERNAL_ID], Zahl)
- Spalte: License Number ([O21.OPTIMA.import.CUSTOMER.LICENSE_NUMBER], Zeichenkette)
- Spalte: Street Number 2 ([O21.OPTIMA.import.CUSTOMER.STREET_NUMBER_2], Zahl)
- Spalte: V5 Customer Type ([O21.OPTIMA.import.CUSTOMER.V5_CUSTOMER_TYPE], Zeichenkette)
- Spalte: Zipcode 2 ([O21.OPTIMA.import.CUSTOMER.ZIPCODE_2], Zeichenkette)
- Spalte: Decl State Date ([O21.OPTIMA.import.CUSTOMER.DECL_STATE_DATE], Datum/Uhrzeit)
- Spalte: Order Limit ([O21.OPTIMA.import.CUSTOMER.ORDER_LIMIT], Zahl)
- Spalte: Addr 2 2 ([O21.OPTIMA.import.CUSTOMER.ADDR_2_2], Zeichenkette)
- Spalte: Addr 3 2 ([O21.OPTIMA.import.CUSTOMER.ADDR_3_2], Zeichenkette)
- Spalte: Internal Transfer ([O21.OPTIMA.import.CUSTOMER.INTERNAL_TRANSFER], Zeichenkette)
- Spalte: Collect Inv Frequency ([O21.OPTIMA.import.CUSTOMER.COLLECT_INV_FREQUENCY], Zeichenkette)
- Spalte: Vat Suspension ([O21.OPTIMA.import.CUSTOMER.VAT_SUSPENSION], Zeichenkette)
- Spalte: Customer Group Veh ([O21.OPTIMA.import.CUSTOMER.CUSTOMER_GROUP_VEH], Zeichenkette)
- Spalte: Renault Dealer Number ([O21.OPTIMA.import.CUSTOMER.RENAULT_DEALER_NUMBER], Zahl)
- Spalte: Renault Trans Method ([O21.OPTIMA.import.CUSTOMER.RENAULT_TRANS_METHOD], Zahl)
- Spalte: Birth Place ([O21.OPTIMA.import.CUSTOMER.BIRTH_PLACE], Zeichenkette)
- Spalte: Birth Town Code ([O21.OPTIMA.import.CUSTOMER.BIRTH_TOWN_CODE], Zeichenkette)
- Spalte: Company Acronym Code ([O21.OPTIMA.import.CUSTOMER.COMPANY_ACRONYM_CODE], Zeichenkette)
- Spalte: Registered Office ([O21.OPTIMA.import.CUSTOMER.REGISTERED_OFFICE], Zeichenkette)
- Spalte: Income Tax Code ([O21.OPTIMA.import.CUSTOMER.INCOME_TAX_CODE], Zeichenkette)
- Spalte: Hobby Code ([O21.OPTIMA.import.CUSTOMER.HOBBY_CODE], Zeichenkette)
- Spalte: Agent Code ([O21.OPTIMA.import.CUSTOMER.AGENT_CODE], Zeichenkette)
- Spalte: Bank Branch Reg No ([O21.OPTIMA.import.CUSTOMER.BANK_BRANCH_REG_NO], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.CUSTOMER.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.CUSTOMER.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.CUSTOMER.UNIQUE_IDENT], Zahl)
- Spalte: Freight Per Day ([O21.OPTIMA.import.CUSTOMER.FREIGHT_PER_DAY], Zahl)
- Spalte: Invoice Form Code Non Elec ([O21.OPTIMA.import.CUSTOMER.INVOICE_FORM_CODE_NON_ELEC], Zeichenkette)
- Spalte: Insurance Code ([O21.OPTIMA.import.CUSTOMER.INSURANCE_CODE], Zeichenkette)
- Spalte: Obsolete ([O21.OPTIMA.import.CUSTOMER.OBSOLETE], Zeichenkette)
- Spalte: Skip Cust Data Checks ([O21.OPTIMA.import.CUSTOMER.SKIP_CUST_DATA_CHECKS], Zeichenkette)
- Ordner: Vpp5m
- Spalte: Book Keeping Code ([O21.OPTIMA.import.vPP5M.BOOK_KEEPING_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP5M.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP5M.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP5M.HANDLER], Zeichenkette)
- Spalte: Specify ([O21.OPTIMA.import.vPP5M.SPECIFY], Zeichenkette)
- Spalte: Democars ([O21.OPTIMA.import.vPP5M.DEMOCARS], Zahl)
- Spalte: Book No Sale ([O21.OPTIMA.import.vPP5M.BOOK_NO_SALE], Zeichenkette)
- Spalte: Book No Purch ([O21.OPTIMA.import.vPP5M.BOOK_NO_PURCH], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP5M.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP5M.UNIQUE_IDENT], Zahl)
- Ordner: Vpp5r
- Spalte: Vehicle Type ([O21.OPTIMA.import.vPP5R.VEHICLE_TYPE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP5R.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP5R.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP5R.HANDLER], Zeichenkette)
- Spalte: Vehicle Type Text ([O21.OPTIMA.import.vPP5R.VEHICLE_TYPE_TEXT], Zeichenkette)
- Spalte: Vehicle Type New ([O21.OPTIMA.import.vPP5R.VEHICLE_TYPE_NEW], Zahl)
- Spalte: Cost Acc Used ([O21.OPTIMA.import.vPP5R.COST_ACC_USED], Zahl)
- Spalte: Cost Ecc Status From ([O21.OPTIMA.import.vPP5R.COST_ECC_STATUS_FROM], Zeichenkette)
- Spalte: Cost Ecc Status To ([O21.OPTIMA.import.vPP5R.COST_ECC_STATUS_TO], Zeichenkette)
- Spalte: Bonus Acc Used ([O21.OPTIMA.import.vPP5R.BONUS_ACC_USED], Zahl)
- Spalte: Bonus Ecc Status From ([O21.OPTIMA.import.vPP5R.BONUS_ECC_STATUS_FROM], Zeichenkette)
- Spalte: Bonus Ecc Status To ([O21.OPTIMA.import.vPP5R.BONUS_ECC_STATUS_TO], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP5R.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP5R.UNIQUE_IDENT], Zahl)
- Ordner: Vpp5q
- Spalte: Model Line ([O21.OPTIMA.import.VPP5Q.MODEL_LINE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP5Q.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP5Q.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP5Q.HANDLER], Zeichenkette)
- Spalte: Mod Lin Specify ([O21.OPTIMA.import.VPP5Q.MOD_LIN_SPECIFY], Zeichenkette)
- Spalte: Mod Lin Own Opt 1 ([O21.OPTIMA.import.VPP5Q.MOD_LIN_OWN_OPT_1], Zeichenkette)
- Spalte: Mod Lin Own Opt 2 ([O21.OPTIMA.import.VPP5Q.MOD_LIN_OWN_OPT_2], Zeichenkette)
- Spalte: Mod Lin Own Opt 3 ([O21.OPTIMA.import.VPP5Q.MOD_LIN_OWN_OPT_3], Zeichenkette)
- Spalte: Mod Lin Own Opt 4 ([O21.OPTIMA.import.VPP5Q.MOD_LIN_OWN_OPT_4], Zeichenkette)
- Spalte: Mod Lin Own Opt 5 ([O21.OPTIMA.import.VPP5Q.MOD_LIN_OWN_OPT_5], Zeichenkette)
- Spalte: Edics Pricecalc ([O21.OPTIMA.import.VPP5Q.EDICS_PRICECALC], Zeichenkette)
- Spalte: Edics Model 01 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_01], Zeichenkette)
- Spalte: Edics Model 02 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_02], Zeichenkette)
- Spalte: Edics Model 03 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_03], Zeichenkette)
- Spalte: Edics Model 04 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_04], Zeichenkette)
- Spalte: Edics Model 05 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_05], Zeichenkette)
- Spalte: Edics Model 06 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_06], Zeichenkette)
- Spalte: Edics Model 07 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_07], Zeichenkette)
- Spalte: Edics Model 08 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_08], Zeichenkette)
- Spalte: Edics Model 09 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_09], Zeichenkette)
- Spalte: Edics Model 10 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_10], Zeichenkette)
- Spalte: Edics Model 11 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_11], Zeichenkette)
- Spalte: Edics Model 12 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_12], Zeichenkette)
- Spalte: Edics Model 13 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_13], Zeichenkette)
- Spalte: Edics Model 14 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_14], Zeichenkette)
- Spalte: Edics Model 15 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_15], Zeichenkette)
- Spalte: Edics Model 16 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_16], Zeichenkette)
- Spalte: Edics Model 17 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_17], Zeichenkette)
- Spalte: Edics Model 18 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_18], Zeichenkette)
- Spalte: Edics Model 19 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_19], Zeichenkette)
- Spalte: Edics Model 20 ([O21.OPTIMA.import.VPP5Q.EDICS_MODEL_20], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.VPP5Q.MAKE_CD], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP5Q.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP5Q.UNIQUE_IDENT], Zahl)
- Ordner: Vpp74
- Spalte: Workshop Model ([O21.OPTIMA.import.vPP74.WORKSHOP_MODEL], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.vPP74.MAKE_CD], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP74.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP74.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP74.HANDLER], Zeichenkette)
- Spalte: Model Text ([O21.OPTIMA.import.vPP74.MODEL_TEXT], Zeichenkette)
- Spalte: Orig Model Code ([O21.OPTIMA.import.vPP74.ORIG_MODEL_CODE], Zeichenkette)
- Spalte: Claim Type ([O21.OPTIMA.import.vPP74.CLAIM_TYPE], Zeichenkette)
- Spalte: Product Line ([O21.OPTIMA.import.vPP74.PRODUCT_LINE], Zeichenkette)
- Spalte: Mnemonic 1 ([O21.OPTIMA.import.vPP74.MNEMONIC_1], Zeichenkette)
- Spalte: Mnemonic 2 ([O21.OPTIMA.import.vPP74.MNEMONIC_2], Zeichenkette)
- Spalte: Model Type ([O21.OPTIMA.import.vPP74.MODEL_TYPE], Zeichenkette)
- Spalte: Model Group ([O21.OPTIMA.import.vPP74.MODEL_GROUP], Zeichenkette)
- Spalte: Factory Claim Code ([O21.OPTIMA.import.vPP74.FACTORY_CLAIM_CODE], Zahl)
- Spalte: Model Line Osp ([O21.OPTIMA.import.vPP74.MODEL_LINE_OSP], Zeichenkette)
- Spalte: Call For Service ([O21.OPTIMA.import.vPP74.CALL_FOR_SERVICE], Zahl)
- Spalte: Follow Up Code 1 ([O21.OPTIMA.import.vPP74.FOLLOW_UP_CODE_1], Zeichenkette)
- Spalte: Follow Up Code 2 ([O21.OPTIMA.import.vPP74.FOLLOW_UP_CODE_2], Zeichenkette)
- Spalte: Follow Up Code 3 ([O21.OPTIMA.import.vPP74.FOLLOW_UP_CODE_3], Zeichenkette)
- Spalte: Follow Up Code 4 ([O21.OPTIMA.import.vPP74.FOLLOW_UP_CODE_4], Zeichenkette)
- Spalte: Follow Up Code 5 ([O21.OPTIMA.import.vPP74.FOLLOW_UP_CODE_5], Zeichenkette)
- Spalte: Make Code ([O21.OPTIMA.import.vPP74.MAKE_CODE], Zeichenkette)
- Spalte: Cardfile Page ([O21.OPTIMA.import.vPP74.CARDFILE_PAGE], Zahl)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP74.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP74.UNIQUE_IDENT], Zahl)
- Ordner: Global Make
- Spalte: Global Make Cd ([O21.OPTIMA.import.GLOBAL_MAKE.GLOBAL_MAKE_CD], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.GLOBAL_MAKE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.GLOBAL_MAKE.HANDLER], Zeichenkette)
- Spalte: Description ([O21.OPTIMA.import.GLOBAL_MAKE.DESCRIPTION], Zeichenkette)
- Spalte: Adp Make ([O21.OPTIMA.import.GLOBAL_MAKE.ADP_MAKE], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.GLOBAL_MAKE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.GLOBAL_MAKE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.GLOBAL_MAKE.UNIQUE_IDENT], Zahl)
- Spalte: Adp Exchange Make Cd ([O21.OPTIMA.import.GLOBAL_MAKE.ADP_EXCHANGE_MAKE_CD], Zeichenkette)
- Ordner: Veh Order Header
- Spalte: Order Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.ORDER_NUMBER], Zahl)
- Spalte: Debit Account ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEBIT_ACCOUNT], Zeichenkette)
- Spalte: Status ([O21.OPTIMA.import.VEH_ORDER_HEADER.STATUS], Zeichenkette)
- Spalte: State Key Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.STATE_KEY_DATE], Datum/Uhrzeit)
- Spalte: Invoice Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.INVOICE_NUMBER], Zahl)
- Spalte: Department ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEPARTMENT], Zeichenkette)
- Spalte: State Deliv Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.STATE_DELIV_DATE], Datum/Uhrzeit)
- Spalte: State Code Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.STATE_CODE_VO], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VEH_ORDER_HEADER.HANDLER], Zeichenkette)
- Spalte: Delivery Account ([O21.OPTIMA.import.VEH_ORDER_HEADER.DELIVERY_ACCOUNT], Zeichenkette)
- Spalte: User Update Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.USER_UPDATE_VO], Zeichenkette)
- Spalte: Salesman ([O21.OPTIMA.import.VEH_ORDER_HEADER.SALESMAN], Zeichenkette)
- Spalte: Debit Perm ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEBIT_PERM], Zeichenkette)
- Spalte: Order Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.ORDER_DATE], Datum/Uhrzeit)
- Spalte: Delivery Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.DELIVERY_DATE], Datum/Uhrzeit)
- Spalte: Delivery Place ([O21.OPTIMA.import.VEH_ORDER_HEADER.DELIVERY_PLACE], Zeichenkette)
- Spalte: Invoice Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.INVOICE_DATE], Datum/Uhrzeit)
- Spalte: Pmt Term ([O21.OPTIMA.import.VEH_ORDER_HEADER.PMT_TERM], Zeichenkette)
- Spalte: Next Line Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.NEXT_LINE_NUMBER], Zahl)
- Spalte: Payment Text ([O21.OPTIMA.import.VEH_ORDER_HEADER.PAYMENT_TEXT], Zeichenkette)
- Spalte: Invoice Copy Code ([O21.OPTIMA.import.VEH_ORDER_HEADER.INVOICE_COPY_CODE], Zeichenkette)
- Spalte: Text Code 1 ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_CODE_1], Zeichenkette)
- Spalte: Text Code 2 ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_CODE_2], Zeichenkette)
- Spalte: Text Code 3 ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_CODE_3], Zeichenkette)
- Spalte: Text1 1 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT1_1_VO], Zeichenkette)
- Spalte: Text1 2 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT1_2_VO], Zeichenkette)
- Spalte: Text Fl1 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_FL1_VO], Zeichenkette)
- Spalte: Text2 1 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT2_1_VO], Zeichenkette)
- Spalte: Text2 2 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT2_2_VO], Zeichenkette)
- Spalte: Text Fl2 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_FL2_VO], Zeichenkette)
- Spalte: Text3 1 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT3_1_VO], Zeichenkette)
- Spalte: Text3 2 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT3_2_VO], Zeichenkette)
- Spalte: Text Fl3 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_FL3_VO], Zeichenkette)
- Spalte: Text4 1 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT4_1_VO], Zeichenkette)
- Spalte: Text4 2 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT4_2_VO], Zeichenkette)
- Spalte: Text Fl4 Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TEXT_FL4_VO], Zeichenkette)
- Spalte: Fleet Owner ([O21.OPTIMA.import.VEH_ORDER_HEADER.FLEET_OWNER], Zeichenkette)
- Spalte: Option Specific ([O21.OPTIMA.import.VEH_ORDER_HEADER.OPTION_SPECIFIC], Zeichenkette)
- Spalte: Vehicle Lines Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEHICLE_LINES_VO], Zahl)
- Spalte: Order Sum Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.ORDER_SUM_VO], Zahl)
- Spalte: Req No ([O21.OPTIMA.import.VEH_ORDER_HEADER.REQ_NO], Zeichenkette)
- Spalte: Reference Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.REFERENCE_NUMBER], Zahl)
- Spalte: Duedate 1 ([O21.OPTIMA.import.VEH_ORDER_HEADER.DUEDATE_1], Datum/Uhrzeit)
- Spalte: Title ([O21.OPTIMA.import.VEH_ORDER_HEADER.TITLE], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.VEH_ORDER_HEADER.NAME], Zeichenkette)
- Spalte: Street Addr ([O21.OPTIMA.import.VEH_ORDER_HEADER.STREET_ADDR], Zeichenkette)
- Spalte: Addr 2 ([O21.OPTIMA.import.VEH_ORDER_HEADER.ADDR_2], Zeichenkette)
- Spalte: Zipcode ([O21.OPTIMA.import.VEH_ORDER_HEADER.ZIPCODE], Zeichenkette)
- Spalte: Mail Addr ([O21.OPTIMA.import.VEH_ORDER_HEADER.MAIL_ADDR], Zeichenkette)
- Spalte: Addr 3 ([O21.OPTIMA.import.VEH_ORDER_HEADER.ADDR_3], Zeichenkette)
- Spalte: County ([O21.OPTIMA.import.VEH_ORDER_HEADER.COUNTY], Zeichenkette)
- Spalte: Vehicle Sold ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEHICLE_SOLD], Zeichenkette)
- Spalte: Vehicle Sold Sum ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEHICLE_SOLD_SUM], Zahl)
- Spalte: Vehicle Purch ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEHICLE_PURCH], Zeichenkette)
- Spalte: Vehicle Purch Sum ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEHICLE_PURCH_SUM], Zahl)
- Spalte: Chain Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.CHAIN_NUMBER], Zahl)
- Spalte: System Inv Perm ([O21.OPTIMA.import.VEH_ORDER_HEADER.SYSTEM_INV_PERM], Zeichenkette)
- Spalte: Internal Code ([O21.OPTIMA.import.VEH_ORDER_HEADER.INTERNAL_CODE], Zeichenkette)
- Spalte: Prev Status ([O21.OPTIMA.import.VEH_ORDER_HEADER.PREV_STATUS], Zeichenkette)
- Spalte: Credit Order Veh ([O21.OPTIMA.import.VEH_ORDER_HEADER.CREDIT_ORDER_VEH], Zeichenkette)
- Spalte: Tax Handling ([O21.OPTIMA.import.VEH_ORDER_HEADER.TAX_HANDLING], Zeichenkette)
- Spalte: Tax Perc ([O21.OPTIMA.import.VEH_ORDER_HEADER.TAX_PERC], Zahl)
- Spalte: Delivery Way Code ([O21.OPTIMA.import.VEH_ORDER_HEADER.DELIVERY_WAY_CODE], Zeichenkette)
- Spalte: Delivery Term ([O21.OPTIMA.import.VEH_ORDER_HEADER.DELIVERY_TERM], Zeichenkette)
- Spalte: Customer Group ([O21.OPTIMA.import.VEH_ORDER_HEADER.CUSTOMER_GROUP], Zeichenkette)
- Spalte: Price Code ([O21.OPTIMA.import.VEH_ORDER_HEADER.PRICE_CODE], Zeichenkette)
- Spalte: Stock ([O21.OPTIMA.import.VEH_ORDER_HEADER.STOCK], Zeichenkette)
- Spalte: Place Code 2 ([O21.OPTIMA.import.VEH_ORDER_HEADER.PLACE_CODE_2], Zeichenkette)
- Spalte: Invoice Disc Perc ([O21.OPTIMA.import.VEH_ORDER_HEADER.INVOICE_DISC_PERC], Zahl)
- Spalte: Order Arr Date Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.ORDER_ARR_DATE_VO], Datum/Uhrzeit)
- Spalte: Offer ([O21.OPTIMA.import.VEH_ORDER_HEADER.OFFER], Zeichenkette)
- Spalte: Veh Order Type ([O21.OPTIMA.import.VEH_ORDER_HEADER.VEH_ORDER_TYPE], Zeichenkette)
- Spalte: Main Order No ([O21.OPTIMA.import.VEH_ORDER_HEADER.MAIN_ORDER_NO], Zahl)
- Spalte: Sub Order No 1 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_1], Zahl)
- Spalte: Sub Order No 2 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_2], Zahl)
- Spalte: Sub Order No 3 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_3], Zahl)
- Spalte: Sub Order No 4 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_4], Zahl)
- Spalte: Sub Order No 5 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_5], Zahl)
- Spalte: Sub Order No 6 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_6], Zahl)
- Spalte: Sub Order No 7 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_7], Zahl)
- Spalte: Sub Order No 8 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_8], Zahl)
- Spalte: Sub Order No 9 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_9], Zahl)
- Spalte: Sub Order No 10 ([O21.OPTIMA.import.VEH_ORDER_HEADER.SUB_ORDER_NO_10], Zahl)
- Spalte: To Microfiche ([O21.OPTIMA.import.VEH_ORDER_HEADER.TO_MICROFICHE], Zeichenkette)
- Spalte: Language Code ([O21.OPTIMA.import.VEH_ORDER_HEADER.LANGUAGE_CODE], Zeichenkette)
- Spalte: Tax Code Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.TAX_CODE_VO], Zeichenkette)
- Spalte: Inv Rounding Vo ([O21.OPTIMA.import.VEH_ORDER_HEADER.INV_ROUNDING_VO], Zahl)
- Spalte: Debt New ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEBT_NEW], Zahl)
- Spalte: Cash Amount ([O21.OPTIMA.import.VEH_ORDER_HEADER.CASH_AMOUNT], Zahl)
- Spalte: Cntract Due Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.CNTRACT_DUE_DATE], Datum/Uhrzeit)
- Spalte: Contract Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.CONTRACT_DATE], Datum/Uhrzeit)
- Spalte: Fac Model Code L ([O21.OPTIMA.import.VEH_ORDER_HEADER.FAC_MODEL_CODE_L], Zeichenkette)
- Spalte: Customer Sold ([O21.OPTIMA.import.VEH_ORDER_HEADER.CUSTOMER_SOLD], Zeichenkette)
- Spalte: Exp Arrival Time ([O21.OPTIMA.import.VEH_ORDER_HEADER.EXP_ARRIVAL_TIME], Zeichenkette)
- Spalte: Book No ([O21.OPTIMA.import.VEH_ORDER_HEADER.BOOK_NO], Zeichenkette)
- Spalte: Book No Flag ([O21.OPTIMA.import.VEH_ORDER_HEADER.BOOK_NO_FLAG], Zeichenkette)
- Spalte: Reference Date ([O21.OPTIMA.import.VEH_ORDER_HEADER.REFERENCE_DATE], Datum/Uhrzeit)
- Spalte: Debet Department ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEBET_DEPARTMENT], Zeichenkette)
- Spalte: Customer Ean Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.CUSTOMER_EAN_NUMBER], Zahl)
- Spalte: Ean Department ([O21.OPTIMA.import.VEH_ORDER_HEADER.EAN_DEPARTMENT], Zeichenkette)
- Spalte: Ean Reference ([O21.OPTIMA.import.VEH_ORDER_HEADER.EAN_REFERENCE], Zeichenkette)
- Spalte: Ean Internal Acct ([O21.OPTIMA.import.VEH_ORDER_HEADER.EAN_INTERNAL_ACCT], Zeichenkette)
- Spalte: Nwfakt Marking ([O21.OPTIMA.import.VEH_ORDER_HEADER.NWFAKT_MARKING], Zahl)
- Spalte: Ext Order Number ([O21.OPTIMA.import.VEH_ORDER_HEADER.EXT_ORDER_NUMBER], Zahl)
- Spalte: Deal Id ([O21.OPTIMA.import.VEH_ORDER_HEADER.DEAL_ID], Zeichenkette)
- Spalte: Preorder Id ([O21.OPTIMA.import.VEH_ORDER_HEADER.PREORDER_ID], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.VEH_ORDER_HEADER.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VEH_ORDER_HEADER.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VEH_ORDER_HEADER.UNIQUE_IDENT], Zahl)
- Spalte: E Invoice ([O21.OPTIMA.import.VEH_ORDER_HEADER.E_INVOICE], Zahl)
- Ordner: Veh Order Line
- Spalte: Order Number ([O21.OPTIMA.import.VEH_ORDER_LINE.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.VEH_ORDER_LINE.LINE_NUMBER], Zahl)
- Spalte: Unit Number ([O21.OPTIMA.import.VEH_ORDER_LINE.UNIT_NUMBER], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VEH_ORDER_LINE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VEH_ORDER_LINE.HANDLER], Zeichenkette)
- Spalte: State Code ([O21.OPTIMA.import.VEH_ORDER_LINE.STATE_CODE], Zeichenkette)
- Spalte: Person Code ([O21.OPTIMA.import.VEH_ORDER_LINE.PERSON_CODE], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.VEH_ORDER_LINE.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.VEH_ORDER_LINE.FUNCTION_CODE], Zeichenkette)
- Spalte: Vehicle Type Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.VEHICLE_TYPE_VO], Zeichenkette)
- Spalte: Layout Type ([O21.OPTIMA.import.VEH_ORDER_LINE.LAYOUT_TYPE], Zeichenkette)
- Spalte: Register Number ([O21.OPTIMA.import.VEH_ORDER_LINE.REGISTER_NUMBER], Zeichenkette)
- Spalte: Chassis Number ([O21.OPTIMA.import.VEH_ORDER_LINE.CHASSIS_NUMBER], Zeichenkette)
- Spalte: Delivery Date ([O21.OPTIMA.import.VEH_ORDER_LINE.DELIVERY_DATE], Datum/Uhrzeit)
- Spalte: Text Code 1 ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_CODE_1], Zeichenkette)
- Spalte: Text Code 2 ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_CODE_2], Zeichenkette)
- Spalte: Text Code 3 ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_CODE_3], Zeichenkette)
- Spalte: Promissed Price ([O21.OPTIMA.import.VEH_ORDER_LINE.PROMISSED_PRICE], Zahl)
- Spalte: Vehicle Sum Old ([O21.OPTIMA.import.VEH_ORDER_LINE.VEHICLE_SUM_OLD], Zahl)
- Spalte: Vehicle Sum New ([O21.OPTIMA.import.VEH_ORDER_LINE.VEHICLE_SUM_NEW], Zahl)
- Spalte: Option Lines ([O21.OPTIMA.import.VEH_ORDER_LINE.OPTION_LINES], Zahl)
- Spalte: Vat Handling ([O21.OPTIMA.import.VEH_ORDER_LINE.VAT_HANDLING], Zeichenkette)
- Spalte: Text1 1 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT1_1_VO], Zeichenkette)
- Spalte: Text1 2 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT1_2_VO], Zeichenkette)
- Spalte: Text Fl1 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_FL1_VO], Zeichenkette)
- Spalte: Text2 1 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT2_1_VO], Zeichenkette)
- Spalte: Text2 2 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT2_2_VO], Zeichenkette)
- Spalte: Text Fl2 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_FL2_VO], Zeichenkette)
- Spalte: Text3 1 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT3_1_VO], Zeichenkette)
- Spalte: Text3 2 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT3_2_VO], Zeichenkette)
- Spalte: Text Fl3 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_FL3_VO], Zeichenkette)
- Spalte: Text4 1 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT4_1_VO], Zeichenkette)
- Spalte: Text4 2 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT4_2_VO], Zeichenkette)
- Spalte: Text Fl4 Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.TEXT_FL4_VO], Zeichenkette)
- Spalte: Line Type Veh ([O21.OPTIMA.import.VEH_ORDER_LINE.LINE_TYPE_VEH], Zeichenkette)
- Spalte: Update Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.UPDATE_VO], Zeichenkette)
- Spalte: Sale Vo ([O21.OPTIMA.import.VEH_ORDER_LINE.SALE_VO], Zeichenkette)
- Spalte: Print Layout ([O21.OPTIMA.import.VEH_ORDER_LINE.PRINT_LAYOUT], Zeichenkette)
- Spalte: Mileage ([O21.OPTIMA.import.VEH_ORDER_LINE.MILEAGE], Zahl)
- Spalte: Saleref ([O21.OPTIMA.import.VEH_ORDER_LINE.SALEREF], Zeichenkette)
- Spalte: Vat Rate Code ([O21.OPTIMA.import.VEH_ORDER_LINE.VAT_RATE_CODE], Zeichenkette)
- Spalte: Disc Code 1 ([O21.OPTIMA.import.VEH_ORDER_LINE.DISC_CODE_1], Zeichenkette)
- Spalte: Disc Pct 1 ([O21.OPTIMA.import.VEH_ORDER_LINE.DISC_PCT_1], Zahl)
- Spalte: Disc Pct 2 ([O21.OPTIMA.import.VEH_ORDER_LINE.DISC_PCT_2], Zahl)
- Spalte: Disc Amount 1 ([O21.OPTIMA.import.VEH_ORDER_LINE.DISC_AMOUNT_1], Zahl)
- Spalte: Disc Amount 2 ([O21.OPTIMA.import.VEH_ORDER_LINE.DISC_AMOUNT_2], Zahl)
- Spalte: Nova Calc Flag ([O21.OPTIMA.import.VEH_ORDER_LINE.NOVA_CALC_FLAG], Zeichenkette)
- Spalte: Nova Amount ([O21.OPTIMA.import.VEH_ORDER_LINE.NOVA_AMOUNT], Zahl)
- Spalte: Nova Except Code ([O21.OPTIMA.import.VEH_ORDER_LINE.NOVA_EXCEPT_CODE], Zeichenkette)
- Spalte: Nova Except Text ([O21.OPTIMA.import.VEH_ORDER_LINE.NOVA_EXCEPT_TEXT], Zeichenkette)
- Spalte: Accounting Code ([O21.OPTIMA.import.VEH_ORDER_LINE.ACCOUNTING_CODE], Zeichenkette)
- Spalte: Create Msc ([O21.OPTIMA.import.VEH_ORDER_LINE.CREATE_MSC], Zeichenkette)
- Spalte: Book No ([O21.OPTIMA.import.VEH_ORDER_LINE.BOOK_NO], Zeichenkette)
- Spalte: Contract Number ([O21.OPTIMA.import.VEH_ORDER_LINE.CONTRACT_NUMBER], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.VEH_ORDER_LINE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VEH_ORDER_LINE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VEH_ORDER_LINE.UNIQUE_IDENT], Zahl)
- Ordner: Vpp43(einkauf)
- Spalte: Seller Code ([O21.OPTIMA.import.VPP43(Einkauf).SELLER_CODE], Zeichenkette)
- Spalte: Order Approv Perm ([O21.OPTIMA.import.VPP43(Einkauf).ORDER_APPROV_PERM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP43(Einkauf).TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP43(Einkauf).HANDLER], Zeichenkette)
- Spalte: Sel Name ([O21.OPTIMA.import.VPP43(Einkauf).SEL_NAME], Zeichenkette)
- Spalte: Sel Department ([O21.OPTIMA.import.VPP43(Einkauf).SEL_DEPARTMENT], Zeichenkette)
- Spalte: Sel First Name ([O21.OPTIMA.import.VPP43(Einkauf).SEL_FIRST_NAME], Zeichenkette)
- Spalte: Sel Family Name ([O21.OPTIMA.import.VPP43(Einkauf).SEL_FAMILY_NAME], Zeichenkette)
- Spalte: Sel Title ([O21.OPTIMA.import.VPP43(Einkauf).SEL_TITLE], Zeichenkette)
- Spalte: Sel Male Female ([O21.OPTIMA.import.VPP43(Einkauf).SEL_MALE_FEMALE], Zahl)
- Spalte: Sel Factor ([O21.OPTIMA.import.VPP43(Einkauf).SEL_FACTOR], Zahl)
- Spalte: Sel Com Salesman ([O21.OPTIMA.import.VPP43(Einkauf).SEL_COM_SALESMAN], Zahl)
- Spalte: Mechanic Pay Group ([O21.OPTIMA.import.VPP43(Einkauf).MECHANIC_PAY_GROUP], Zeichenkette)
- Spalte: Licence Id ([O21.OPTIMA.import.VPP43(Einkauf).LICENCE_ID], Zeichenkette)
- Spalte: Employee Category ([O21.OPTIMA.import.VPP43(Einkauf).EMPLOYEE_CATEGORY], Zahl)
- Spalte: Trainee Year ([O21.OPTIMA.import.VPP43(Einkauf).TRAINEE_YEAR], Zahl)
- Spalte: Email Address ([O21.OPTIMA.import.VPP43(Einkauf).EMAIL_ADDRESS], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP43(Einkauf).timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP43(Einkauf).UNIQUE_IDENT], Zahl)
- Ordner: Department Type
- Spalte: Department Type Id ([O21.OPTIMA.import.DEPARTMENT_TYPE.DEPARTMENT_TYPE_ID], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.DEPARTMENT_TYPE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.DEPARTMENT_TYPE.HANDLER], Zeichenkette)
- Spalte: Description ([O21.OPTIMA.import.DEPARTMENT_TYPE.DESCRIPTION], Zeichenkette)
- Spalte: Department Group ([O21.OPTIMA.import.DEPARTMENT_TYPE.DEPARTMENT_GROUP], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.DEPARTMENT_TYPE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.DEPARTMENT_TYPE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.DEPARTMENT_TYPE.UNIQUE_IDENT], Zahl)
- Ordner: Vpp48
- Spalte: Customer Group ([O21.OPTIMA.import.VPP48.CUSTOMER_GROUP], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP48.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP48.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP48.HANDLER], Zeichenkette)
- Spalte: Cust Group Specify ([O21.OPTIMA.import.VPP48.CUST_GROUP_SPECIFY], Zeichenkette)
- Spalte: Customer Amount ([O21.OPTIMA.import.VPP48.CUSTOMER_AMOUNT], Zahl)
- Spalte: Collect Account ([O21.OPTIMA.import.VPP48.COLLECT_ACCOUNT], Zeichenkette)
- Spalte: Rounding Account ([O21.OPTIMA.import.VPP48.ROUNDING_ACCOUNT], Zeichenkette)
- Spalte: Cash Discount Acc ([O21.OPTIMA.import.VPP48.CASH_DISCOUNT_ACC], Zeichenkette)
- Spalte: Interest Account ([O21.OPTIMA.import.VPP48.INTEREST_ACCOUNT], Zeichenkette)
- Spalte: Setoff Acct ([O21.OPTIMA.import.VPP48.SETOFF_ACCT], Zeichenkette)
- Spalte: Back Order Perm ([O21.OPTIMA.import.VPP48.BACK_ORDER_PERM], Zahl)
- Spalte: End User ([O21.OPTIMA.import.VPP48.END_USER], Zahl)
- Spalte: Order Discount Grp ([O21.OPTIMA.import.VPP48.ORDER_DISCOUNT_GRP], Zeichenkette)
- Spalte: Convert Sold Time ([O21.OPTIMA.import.VPP48.CONVERT_SOLD_TIME], Zahl)
- Spalte: Interest Cred Acct ([O21.OPTIMA.import.VPP48.INTEREST_CRED_ACCT], Zeichenkette)
- Spalte: Vat Table Vehicle ([O21.OPTIMA.import.VPP48.VAT_TABLE_VEHICLE], Zeichenkette)
- Spalte: Vat Table Work ([O21.OPTIMA.import.VPP48.VAT_TABLE_WORK], Zeichenkette)
- Spalte: Vat Table Normal ([O21.OPTIMA.import.VPP48.VAT_TABLE_NORMAL], Zeichenkette)
- Spalte: Tax Code ([O21.OPTIMA.import.VPP48.TAX_CODE], Zeichenkette)
- Spalte: Code Cust Group ([O21.OPTIMA.import.VPP48.CODE_CUST_GROUP], Zahl)
- Spalte: Swed Descrip Code ([O21.OPTIMA.import.VPP48.SWED_DESCRIP_CODE], Zeichenkette)
- Spalte: Pmt Charge Type ([O21.OPTIMA.import.VPP48.PMT_CHARGE_TYPE], Zeichenkette)
- Spalte: Tup Cust Group ([O21.OPTIMA.import.VPP48.TUP_CUST_GROUP], Zeichenkette)
- Spalte: Invoice Category ([O21.OPTIMA.import.VPP48.INVOICE_CATEGORY], Zeichenkette)
- Spalte: Customer Class ([O21.OPTIMA.import.VPP48.CUSTOMER_CLASS], Zeichenkette)
- Spalte: Recommended Price Id ([O21.OPTIMA.import.VPP48.RECOMMENDED_PRICE_ID], Zeichenkette)
- Spalte: Cust Group Veh ([O21.OPTIMA.import.VPP48.CUST_GROUP_VEH], Zahl)
- Spalte: Trackerpack Cust Group ([O21.OPTIMA.import.VPP48.TRACKERPACK_CUST_GROUP], Zeichenkette)
- Spalte: Citroen Cust Group ([O21.OPTIMA.import.VPP48.CITROEN_CUST_GROUP], Zeichenkette)
- Spalte: Rounding Account Positive ([O21.OPTIMA.import.VPP48.ROUNDING_ACCOUNT_POSITIVE], Zeichenkette)
- Spalte: Class Customer Group ([O21.OPTIMA.import.VPP48.CLASS_CUSTOMER_GROUP], Zeichenkette)
- Spalte: Default Order Status ([O21.OPTIMA.import.VPP48.DEFAULT_ORDER_STATUS], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP48.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP48.UNIQUE_IDENT], Zahl)
- Ordner: Vpp5a
- Spalte: Transaction Code ([O21.OPTIMA.import.vPP5A.TRANSACTION_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP5A.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP5A.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP5A.HANDLER], Zeichenkette)
- Spalte: Specify ([O21.OPTIMA.import.vPP5A.SPECIFY], Zeichenkette)
- Spalte: Transfer Code ([O21.OPTIMA.import.vPP5A.TRANSFER_CODE], Zeichenkette)
- Spalte: Vat Allowed ([O21.OPTIMA.import.vPP5A.VAT_ALLOWED], Zahl)
- Spalte: Print5a ([O21.OPTIMA.import.vPP5A.PRINT5A], Zahl)
- Spalte: Sales Price ([O21.OPTIMA.import.vPP5A.SALES_PRICE], Zahl)
- Spalte: Equipment ([O21.OPTIMA.import.vPP5A.EQUIPMENT], Zahl)
- Spalte: Delivery Cost ([O21.OPTIMA.import.vPP5A.DELIVERY_COST], Zahl)
- Spalte: Purch Price ([O21.OPTIMA.import.vPP5A.PURCH_PRICE], Zahl)
- Spalte: Depreciation ([O21.OPTIMA.import.vPP5A.DEPRECIATION], Zahl)
- Spalte: Ppcalc Block No ([O21.OPTIMA.import.vPP5A.PPCALC_BLOCK_NO], Zahl)
- Spalte: Ppcalc Field No ([O21.OPTIMA.import.vPP5A.PPCALC_FIELD_NO], Zahl)
- Spalte: Counter Account ([O21.OPTIMA.import.vPP5A.COUNTER_ACCOUNT], Zeichenkette)
- Spalte: Pmt Type ([O21.OPTIMA.import.vPP5A.PMT_TYPE], Zeichenkette)
- Spalte: Extract Vat ([O21.OPTIMA.import.vPP5A.EXTRACT_VAT], Zahl)
- Spalte: Calc Diff Vat ([O21.OPTIMA.import.vPP5A.CALC_DIFF_VAT], Zahl)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP5A.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP5A.UNIQUE_IDENT], Zahl)
- Ordner: Unit Change Hist
- Spalte: Unit Number ([O21.OPTIMA.import.UNIT_CHANGE_HIST.UNIT_NUMBER], Zeichenkette)
- Spalte: Val Date ([O21.OPTIMA.import.UNIT_CHANGE_HIST.VAL_DATE], Datum/Uhrzeit)
- Spalte: Seq No ([O21.OPTIMA.import.UNIT_CHANGE_HIST.SEQ_NO], Zahl)
- Spalte: Transact Date ([O21.OPTIMA.import.UNIT_CHANGE_HIST.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.UNIT_CHANGE_HIST.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.UNIT_CHANGE_HIST.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.FUNCTION_CODE], Zeichenkette)
- Spalte: Book Keeping Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.BOOK_KEEPING_CODE], Zeichenkette)
- Spalte: Tax Handling ([O21.OPTIMA.import.UNIT_CHANGE_HIST.TAX_HANDLING], Zeichenkette)
- Spalte: Vat Rate Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.VAT_RATE_CODE], Zeichenkette)
- Spalte: Department ([O21.OPTIMA.import.UNIT_CHANGE_HIST.DEPARTMENT], Zeichenkette)
- Spalte: Classification Dte ([O21.OPTIMA.import.UNIT_CHANGE_HIST.CLASSIFICATION_DTE], Datum/Uhrzeit)
- Spalte: Vehicle Type ([O21.OPTIMA.import.UNIT_CHANGE_HIST.VEHICLE_TYPE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.UNIT_CHANGE_HIST.MAKE_CD], Zeichenkette)
- Spalte: Make Family Cd ([O21.OPTIMA.import.UNIT_CHANGE_HIST.MAKE_FAMILY_CD], Zeichenkette)
- Spalte: Model Line ([O21.OPTIMA.import.UNIT_CHANGE_HIST.MODEL_LINE], Zeichenkette)
- Spalte: Workshop Model ([O21.OPTIMA.import.UNIT_CHANGE_HIST.WORKSHOP_MODEL], Zeichenkette)
- Spalte: Fac Model Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.FAC_MODEL_CODE], Zeichenkette)
- Spalte: Used Veh Dest Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.USED_VEH_DEST_CODE], Zeichenkette)
- Spalte: Purch Origin Code ([O21.OPTIMA.import.UNIT_CHANGE_HIST.PURCH_ORIGIN_CODE], Zeichenkette)
- Spalte: Use Of Vehicle ([O21.OPTIMA.import.UNIT_CHANGE_HIST.USE_OF_VEHICLE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.UNIT_CHANGE_HIST.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.UNIT_CHANGE_HIST.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.UNIT_CHANGE_HIST.UNIQUE_IDENT], Zahl)
- Spalte: Purch Salesman ([O21.OPTIMA.import.UNIT_CHANGE_HIST.PURCH_SALESMAN], Zeichenkette)
- Spalte: Sale Salesman ([O21.OPTIMA.import.UNIT_CHANGE_HIST.SALE_SALESMAN], Zeichenkette)
- Ordner: Gc Department
- Spalte: Hauptbetrieb ([O21.OPTIMA.data.GC_Department.Hauptbetrieb], Zeichenkette)
- Spalte: Standort ([O21.OPTIMA.data.GC_Department.Standort], Zeichenkette)
- Spalte: Site ([O21.OPTIMA.data.GC_Department.Site], Zeichenkette)
- Spalte: Hauptbetrieb Id ([O21.OPTIMA.data.GC_Department.Hauptbetrieb_ID], Zeichenkette)
- Spalte: Hauptbetrieb Name ([O21.OPTIMA.data.GC_Department.Hauptbetrieb_Name], Zeichenkette)
- Spalte: Standort Id ([O21.OPTIMA.data.GC_Department.Standort_ID], Zeichenkette)
- Spalte: Standort Name ([O21.OPTIMA.data.GC_Department.Standort_Name], Zeichenkette)
- Spalte: Gruppe Id ([O21.OPTIMA.data.GC_Department.Gruppe_ID], Zeichenkette)
- Spalte: Gruppe Name ([O21.OPTIMA.data.GC_Department.Gruppe_Name], Zeichenkette)
- Spalte: Marke Id ([O21.OPTIMA.data.GC_Department.Marke_ID], Zeichenkette)
- Spalte: Marke Name ([O21.OPTIMA.data.GC_Department.Marke_Name], Zeichenkette)
- Ordner: Gc Marken
- Spalte: Client Db ([O21.OPTIMA.data.GC_Marken.Client_DB], Zeichenkette)
- Spalte: Make ([O21.OPTIMA.data.GC_Marken.Make], Zeichenkette)
- Spalte: Description ([O21.OPTIMA.data.GC_Marken.Description], Zeichenkette)
- Spalte: Fabrikat ([O21.OPTIMA.data.GC_Marken.Fabrikat], Zeichenkette)
- Spalte: Order By ([O21.OPTIMA.data.GC_Marken.Order_By], Zahl)
- Ordner: Customer Owner
- Spalte: Customer Number ([O21.OPTIMA.import.Customer_Owner.CUSTOMER_NUMBER], Zeichenkette)
- Spalte: State Code Cust ([O21.OPTIMA.import.Customer_Owner.STATE_CODE_CUST], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.Customer_Owner.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.Customer_Owner.HANDLER], Zeichenkette)
- Spalte: Cust Alt Key ([O21.OPTIMA.import.Customer_Owner.CUST_ALT_KEY], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.Customer_Owner.NAME], Zeichenkette)
- Spalte: Street Addr ([O21.OPTIMA.import.Customer_Owner.STREET_ADDR], Zeichenkette)
- Spalte: Addr 2 ([O21.OPTIMA.import.Customer_Owner.ADDR_2], Zeichenkette)
- Spalte: Mail Addr ([O21.OPTIMA.import.Customer_Owner.MAIL_ADDR], Zeichenkette)
- Spalte: Zipcode ([O21.OPTIMA.import.Customer_Owner.ZIPCODE], Zeichenkette)
- Spalte: Debit Customer ([O21.OPTIMA.import.Customer_Owner.DEBIT_CUSTOMER], Zeichenkette)
- Spalte: Title Code ([O21.OPTIMA.import.Customer_Owner.TITLE_CODE], Zeichenkette)
- Spalte: Title ([O21.OPTIMA.import.Customer_Owner.TITLE], Zeichenkette)
- Spalte: Pmt Term ([O21.OPTIMA.import.Customer_Owner.PMT_TERM], Zeichenkette)
- Spalte: Invoice Copy Code ([O21.OPTIMA.import.Customer_Owner.INVOICE_COPY_CODE], Zeichenkette)
- Spalte: Delivery Way Code ([O21.OPTIMA.import.Customer_Owner.DELIVERY_WAY_CODE], Zeichenkette)
- Spalte: Small Accessories ([O21.OPTIMA.import.Customer_Owner.SMALL_ACCESSORIES], Zeichenkette)
- Spalte: Small Inv Charge ([O21.OPTIMA.import.Customer_Owner.SMALL_INV_CHARGE], Zeichenkette)
- Spalte: Workshop Pricecode ([O21.OPTIMA.import.Customer_Owner.WORKSHOP_PRICECODE], Zeichenkette)
- Spalte: Vat Regno ([O21.OPTIMA.import.Customer_Owner.VAT_REGNO], Zeichenkette)
- Spalte: Salesman ([O21.OPTIMA.import.Customer_Owner.SALESMAN], Zeichenkette)
- Spalte: Gross Discount ([O21.OPTIMA.import.Customer_Owner.GROSS_DISCOUNT], Zeichenkette)
- Spalte: Delivery Stop Code ([O21.OPTIMA.import.Customer_Owner.DELIVERY_STOP_CODE], Zeichenkette)
- Spalte: Credit Limit ([O21.OPTIMA.import.Customer_Owner.CREDIT_LIMIT], Zahl)
- Spalte: Reminder Code ([O21.OPTIMA.import.Customer_Owner.REMINDER_CODE], Zeichenkette)
- Spalte: Account Type Cu ([O21.OPTIMA.import.Customer_Owner.ACCOUNT_TYPE_CU], Zeichenkette)
- Spalte: Account Print ([O21.OPTIMA.import.Customer_Owner.ACCOUNT_PRINT], Zeichenkette)
- Spalte: Bank Name ([O21.OPTIMA.import.Customer_Owner.BANK_NAME], Zeichenkette)
- Spalte: Bank Reg No ([O21.OPTIMA.import.Customer_Owner.BANK_REG_NO], Zeichenkette)
- Spalte: Bank Account No ([O21.OPTIMA.import.Customer_Owner.BANK_ACCOUNT_NO], Zeichenkette)
- Spalte: Payment Way ([O21.OPTIMA.import.Customer_Owner.PAYMENT_WAY], Zeichenkette)
- Spalte: Price Code ([O21.OPTIMA.import.Customer_Owner.PRICE_CODE], Zeichenkette)
- Spalte: Discount Perc Work ([O21.OPTIMA.import.Customer_Owner.DISCOUNT_PERC_WORK], Zahl)
- Spalte: Discount Limit ([O21.OPTIMA.import.Customer_Owner.DISCOUNT_LIMIT], Zeichenkette)
- Spalte: Annual Disc Perc ([O21.OPTIMA.import.Customer_Owner.ANNUAL_DISC_PERC], Zahl)
- Spalte: Annual Disc Amount ([O21.OPTIMA.import.Customer_Owner.ANNUAL_DISC_AMOUNT], Zahl)
- Spalte: Annual Disc Code ([O21.OPTIMA.import.Customer_Owner.ANNUAL_DISC_CODE], Zeichenkette)
- Spalte: Advert Disc Perc ([O21.OPTIMA.import.Customer_Owner.ADVERT_DISC_PERC], Zahl)
- Spalte: Advert Disc Amount ([O21.OPTIMA.import.Customer_Owner.ADVERT_DISC_AMOUNT], Zahl)
- Spalte: Internal Code Cust ([O21.OPTIMA.import.Customer_Owner.INTERNAL_CODE_CUST], Zeichenkette)
- Spalte: Customer Group ([O21.OPTIMA.import.Customer_Owner.CUSTOMER_GROUP], Zeichenkette)
- Spalte: Customer Prospect ([O21.OPTIMA.import.Customer_Owner.CUSTOMER_PROSPECT], Zeichenkette)
- Spalte: Tax Code ([O21.OPTIMA.import.Customer_Owner.TAX_CODE], Zeichenkette)
- Spalte: Fleet Owner ([O21.OPTIMA.import.Customer_Owner.FLEET_OWNER], Zeichenkette)
- Spalte: Contact Person ([O21.OPTIMA.import.Customer_Owner.CONTACT_PERSON], Zeichenkette)
- Spalte: Phone 1 ([O21.OPTIMA.import.Customer_Owner.PHONE_1], Zeichenkette)
- Spalte: Phone 2 ([O21.OPTIMA.import.Customer_Owner.PHONE_2], Zeichenkette)
- Spalte: Comment 1 ([O21.OPTIMA.import.Customer_Owner.COMMENT_1], Zeichenkette)
- Spalte: Comment 2 ([O21.OPTIMA.import.Customer_Owner.COMMENT_2], Zeichenkette)
- Spalte: Contact Date ([O21.OPTIMA.import.Customer_Owner.CONTACT_DATE], Datum/Uhrzeit)
- Spalte: Mail Code 1 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_1], Zeichenkette)
- Spalte: Mail Code 2 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_2], Zeichenkette)
- Spalte: Mail Code 3 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_3], Zeichenkette)
- Spalte: Mail Code 4 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_4], Zeichenkette)
- Spalte: Mail Code 5 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_5], Zeichenkette)
- Spalte: Mail Code 6 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_6], Zeichenkette)
- Spalte: Mail Code 7 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_7], Zeichenkette)
- Spalte: Mail Code 8 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_8], Zeichenkette)
- Spalte: Mail Code 9 ([O21.OPTIMA.import.Customer_Owner.MAIL_CODE_9], Zeichenkette)
- Spalte: Last Invoice Date ([O21.OPTIMA.import.Customer_Owner.LAST_INVOICE_DATE], Datum/Uhrzeit)
- Spalte: Profit C U ([O21.OPTIMA.import.Customer_Owner.PROFIT_C_U], Zahl)
- Spalte: Debited Mm Cust ([O21.OPTIMA.import.Customer_Owner.DEBITED_MM_CUST], Zahl)
- Spalte: Debited Ty Cust ([O21.OPTIMA.import.Customer_Owner.DEBITED_TY_CUST], Zahl)
- Spalte: Debited Prye Cust ([O21.OPTIMA.import.Customer_Owner.DEBITED_PRYE_CUST], Zahl)
- Spalte: Discount Mm Cust ([O21.OPTIMA.import.Customer_Owner.DISCOUNT_MM_CUST], Zahl)
- Spalte: Discount Ty Cust ([O21.OPTIMA.import.Customer_Owner.DISCOUNT_TY_CUST], Zahl)
- Spalte: Discount Py Cust ([O21.OPTIMA.import.Customer_Owner.DISCOUNT_PY_CUST], Zahl)
- Spalte: Marg Mm Cust ([O21.OPTIMA.import.Customer_Owner.MARG_MM_CUST], Zahl)
- Spalte: Marg Ty Cust ([O21.OPTIMA.import.Customer_Owner.MARG_TY_CUST], Zahl)
- Spalte: Marg Py Cust ([O21.OPTIMA.import.Customer_Owner.MARG_PY_CUST], Zahl)
- Spalte: Saldo C U Cust ([O21.OPTIMA.import.Customer_Owner.SALDO_C_U_CUST], Zahl)
- Spalte: Last Pmt Dte Cust ([O21.OPTIMA.import.Customer_Owner.LAST_PMT_DTE_CUST], Datum/Uhrzeit)
- Spalte: Pmt Time Cust ([O21.OPTIMA.import.Customer_Owner.PMT_TIME_CUST], Zahl)
- Spalte: Interests ([O21.OPTIMA.import.Customer_Owner.INTERESTS], Zahl)
- Spalte: Saldo Last St ([O21.OPTIMA.import.Customer_Owner.SALDO_LAST_ST], Zahl)
- Spalte: Aos Deal Number ([O21.OPTIMA.import.Customer_Owner.AOS_DEAL_NUMBER], Zeichenkette)
- Spalte: Cpr Number ([O21.OPTIMA.import.Customer_Owner.CPR_NUMBER], Zahl)
- Spalte: Delete Proposal ([O21.OPTIMA.import.Customer_Owner.DELETE_PROPOSAL], Zeichenkette)
- Spalte: Creation Date ([O21.OPTIMA.import.Customer_Owner.CREATION_DATE], Datum/Uhrzeit)
- Spalte: Creater ([O21.OPTIMA.import.Customer_Owner.CREATER], Zeichenkette)
- Spalte: Reduction Code ([O21.OPTIMA.import.Customer_Owner.REDUCTION_CODE], Zeichenkette)
- Spalte: Start No ([O21.OPTIMA.import.Customer_Owner.START_NO], Zahl)
- Spalte: Last No ([O21.OPTIMA.import.Customer_Owner.LAST_NO], Zahl)
- Spalte: Latest Period ([O21.OPTIMA.import.Customer_Owner.LATEST_PERIOD], Datum/Uhrzeit)
- Spalte: Reminder Group ([O21.OPTIMA.import.Customer_Owner.REMINDER_GROUP], Zeichenkette)
- Spalte: Reminder Date ([O21.OPTIMA.import.Customer_Owner.REMINDER_DATE], Datum/Uhrzeit)
- Spalte: Pmt Termcode 2 ([O21.OPTIMA.import.Customer_Owner.PMT_TERMCODE_2], Zeichenkette)
- Spalte: Back Order Deliv ([O21.OPTIMA.import.Customer_Owner.BACK_ORDER_DELIV], Zeichenkette)
- Spalte: Country Code Cu ([O21.OPTIMA.import.Customer_Owner.COUNTRY_CODE_CU], Zeichenkette)
- Spalte: Instalment Code ([O21.OPTIMA.import.Customer_Owner.INSTALMENT_CODE], Zahl)
- Spalte: Follow Up Cu ([O21.OPTIMA.import.Customer_Owner.FOLLOW_UP_CU], Zeichenkette)
- Spalte: Vat Table Work ([O21.OPTIMA.import.Customer_Owner.VAT_TABLE_WORK], Zeichenkette)
- Spalte: Vat Table Normal ([O21.OPTIMA.import.Customer_Owner.VAT_TABLE_NORMAL], Zeichenkette)
- Spalte: Vat Table ([O21.OPTIMA.import.Customer_Owner.VAT_TABLE], Zeichenkette)
- Spalte: Occupation Code ([O21.OPTIMA.import.Customer_Owner.OCCUPATION_CODE], Zeichenkette)
- Spalte: Telefax Number ([O21.OPTIMA.import.Customer_Owner.TELEFAX_NUMBER], Zeichenkette)
- Spalte: Language Code ([O21.OPTIMA.import.Customer_Owner.LANGUAGE_CODE], Zeichenkette)
- Spalte: Birthday ([O21.OPTIMA.import.Customer_Owner.BIRTHDAY], Datum/Uhrzeit)
- Spalte: Birthday2 ([O21.OPTIMA.import.Customer_Owner.BIRTHDAY2], Datum/Uhrzeit)
- Spalte: Addr 3 ([O21.OPTIMA.import.Customer_Owner.ADDR_3], Zeichenkette)
- Spalte: County ([O21.OPTIMA.import.Customer_Owner.COUNTY], Zeichenkette)
- Spalte: Max Booking Days ([O21.OPTIMA.import.Customer_Owner.MAX_BOOKING_DAYS], Zahl)
- Spalte: Department 5 ([O21.OPTIMA.import.Customer_Owner.DEPARTMENT_5], Zahl)
- Spalte: Rib Key ([O21.OPTIMA.import.Customer_Owner.RIB_KEY], Zahl)
- Spalte: Price A G ([O21.OPTIMA.import.Customer_Owner.PRICE_A_G], Zeichenkette)
- Spalte: Req No Compulsory ([O21.OPTIMA.import.Customer_Owner.REQ_NO_COMPULSORY], Zeichenkette)
- Spalte: Vat Regno Eu ([O21.OPTIMA.import.Customer_Owner.VAT_REGNO_EU], Zeichenkette)
- Spalte: Workshop Salesman ([O21.OPTIMA.import.Customer_Owner.WORKSHOP_SALESMAN], Zeichenkette)
- Spalte: Hourly Repair Rate ([O21.OPTIMA.import.Customer_Owner.HOURLY_REPAIR_RATE], Zahl)
- Spalte: Elec Invoice ([O21.OPTIMA.import.Customer_Owner.ELEC_INVOICE], Zeichenkette)
- Spalte: Elec Del Note ([O21.OPTIMA.import.Customer_Owner.ELEC_DEL_NOTE], Zeichenkette)
- Spalte: Elec Order Conf ([O21.OPTIMA.import.Customer_Owner.ELEC_ORDER_CONF], Zeichenkette)
- Spalte: Elec Invoice Form ([O21.OPTIMA.import.Customer_Owner.ELEC_INVOICE_FORM], Zeichenkette)
- Spalte: Elec Coll Inv Form ([O21.OPTIMA.import.Customer_Owner.ELEC_COLL_INV_FORM], Zeichenkette)
- Spalte: Elec Del Note Form ([O21.OPTIMA.import.Customer_Owner.ELEC_DEL_NOTE_FORM], Zeichenkette)
- Spalte: Elec Ord Conf Form ([O21.OPTIMA.import.Customer_Owner.ELEC_ORD_CONF_FORM], Zeichenkette)
- Spalte: Only Coll Invoice ([O21.OPTIMA.import.Customer_Owner.ONLY_COLL_INVOICE], Zeichenkette)
- Spalte: Cust Company No ([O21.OPTIMA.import.Customer_Owner.CUST_COMPANY_NO], Zeichenkette)
- Spalte: Dealer Number ([O21.OPTIMA.import.Customer_Owner.DEALER_NUMBER], Zeichenkette)
- Spalte: Mobile Phone ([O21.OPTIMA.import.Customer_Owner.MOBILE_PHONE], Zeichenkette)
- Spalte: Mobile Phone 2 ([O21.OPTIMA.import.Customer_Owner.MOBILE_PHONE_2], Zeichenkette)
- Spalte: E Mail Address ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS], Zeichenkette)
- Spalte: E Mail Address 2 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_2], Zeichenkette)
- Spalte: Branch ([O21.OPTIMA.import.Customer_Owner.BRANCH], Zeichenkette)
- Spalte: Declaration State ([O21.OPTIMA.import.Customer_Owner.DECLARATION_STATE], Zeichenkette)
- Spalte: Use Work Type Code ([O21.OPTIMA.import.Customer_Owner.USE_WORK_TYPE_CODE], Zeichenkette)
- Spalte: Fleet Id Number ([O21.OPTIMA.import.Customer_Owner.FLEET_ID_NUMBER], Zeichenkette)
- Spalte: First Name ([O21.OPTIMA.import.Customer_Owner.FIRST_NAME], Zeichenkette)
- Spalte: Last Name ([O21.OPTIMA.import.Customer_Owner.LAST_NAME], Zeichenkette)
- Spalte: Gender ([O21.OPTIMA.import.Customer_Owner.GENDER], Zeichenkette)
- Spalte: Company ([O21.OPTIMA.import.Customer_Owner.COMPANY], Zeichenkette)
- Spalte: Mail Suppress ([O21.OPTIMA.import.Customer_Owner.MAIL_SUPPRESS], Zeichenkette)
- Spalte: Po Box 15 ([O21.OPTIMA.import.Customer_Owner.PO_BOX_15], Zeichenkette)
- Spalte: Po Box Zipcode ([O21.OPTIMA.import.Customer_Owner.PO_BOX_ZIPCODE], Zeichenkette)
- Spalte: Po Box Town ([O21.OPTIMA.import.Customer_Owner.PO_BOX_TOWN], Zeichenkette)
- Spalte: Web Address ([O21.OPTIMA.import.Customer_Owner.WEB_ADDRESS], Zeichenkette)
- Spalte: Family Status ([O21.OPTIMA.import.Customer_Owner.FAMILY_STATUS], Zeichenkette)
- Spalte: Children ([O21.OPTIMA.import.Customer_Owner.CHILDREN], Zahl)
- Spalte: Hobby ([O21.OPTIMA.import.Customer_Owner.HOBBY], Zeichenkette)
- Spalte: Ext Customer Group ([O21.OPTIMA.import.Customer_Owner.EXT_CUSTOMER_GROUP], Zeichenkette)
- Spalte: Membership Number ([O21.OPTIMA.import.Customer_Owner.MEMBERSHIP_NUMBER], Zeichenkette)
- Spalte: Trade Register ([O21.OPTIMA.import.Customer_Owner.TRADE_REGISTER], Zeichenkette)
- Spalte: Pdf Invoice ([O21.OPTIMA.import.Customer_Owner.PDF_INVOICE], Zeichenkette)
- Spalte: E Commerce Veh ([O21.OPTIMA.import.Customer_Owner.E_COMMERCE_VEH], Zeichenkette)
- Spalte: E Mail Address 3 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_3], Zeichenkette)
- Spalte: Send Order Advice ([O21.OPTIMA.import.Customer_Owner.SEND_ORDER_ADVICE], Zeichenkette)
- Spalte: Sales Location ([O21.OPTIMA.import.Customer_Owner.SALES_LOCATION], Zeichenkette)
- Spalte: Service Location ([O21.OPTIMA.import.Customer_Owner.SERVICE_LOCATION], Zeichenkette)
- Spalte: Street Number ([O21.OPTIMA.import.Customer_Owner.STREET_NUMBER], Zahl)
- Spalte: Street Number Ext ([O21.OPTIMA.import.Customer_Owner.STREET_NUMBER_EXT], Zeichenkette)
- Spalte: Street Number Ext2 ([O21.OPTIMA.import.Customer_Owner.STREET_NUMBER_EXT2], Zeichenkette)
- Spalte: Mail Addr 2 ([O21.OPTIMA.import.Customer_Owner.MAIL_ADDR_2], Zeichenkette)
- Spalte: County 2 ([O21.OPTIMA.import.Customer_Owner.COUNTY_2], Zeichenkette)
- Spalte: External Id ([O21.OPTIMA.import.Customer_Owner.EXTERNAL_ID], Zahl)
- Spalte: License Number ([O21.OPTIMA.import.Customer_Owner.LICENSE_NUMBER], Zeichenkette)
- Spalte: Street Number 2 ([O21.OPTIMA.import.Customer_Owner.STREET_NUMBER_2], Zahl)
- Spalte: V5 Customer Type ([O21.OPTIMA.import.Customer_Owner.V5_CUSTOMER_TYPE], Zeichenkette)
- Spalte: Zipcode 2 ([O21.OPTIMA.import.Customer_Owner.ZIPCODE_2], Zeichenkette)
- Spalte: Decl State Date ([O21.OPTIMA.import.Customer_Owner.DECL_STATE_DATE], Datum/Uhrzeit)
- Spalte: Order Limit ([O21.OPTIMA.import.Customer_Owner.ORDER_LIMIT], Zahl)
- Spalte: Addr 2 2 ([O21.OPTIMA.import.Customer_Owner.ADDR_2_2], Zeichenkette)
- Spalte: Addr 3 2 ([O21.OPTIMA.import.Customer_Owner.ADDR_3_2], Zeichenkette)
- Spalte: Internal Transfer ([O21.OPTIMA.import.Customer_Owner.INTERNAL_TRANSFER], Zeichenkette)
- Spalte: Collect Inv Frequency ([O21.OPTIMA.import.Customer_Owner.COLLECT_INV_FREQUENCY], Zeichenkette)
- Spalte: Vat Suspension ([O21.OPTIMA.import.Customer_Owner.VAT_SUSPENSION], Zeichenkette)
- Spalte: Customer Group Veh ([O21.OPTIMA.import.Customer_Owner.CUSTOMER_GROUP_VEH], Zeichenkette)
- Spalte: Renault Dealer Number ([O21.OPTIMA.import.Customer_Owner.RENAULT_DEALER_NUMBER], Zahl)
- Spalte: Renault Trans Method ([O21.OPTIMA.import.Customer_Owner.RENAULT_TRANS_METHOD], Zahl)
- Spalte: Birth Place ([O21.OPTIMA.import.Customer_Owner.BIRTH_PLACE], Zeichenkette)
- Spalte: Birth Town Code ([O21.OPTIMA.import.Customer_Owner.BIRTH_TOWN_CODE], Zeichenkette)
- Spalte: Company Acronym Code ([O21.OPTIMA.import.Customer_Owner.COMPANY_ACRONYM_CODE], Zeichenkette)
- Spalte: Registered Office ([O21.OPTIMA.import.Customer_Owner.REGISTERED_OFFICE], Zeichenkette)
- Spalte: Income Tax Code ([O21.OPTIMA.import.Customer_Owner.INCOME_TAX_CODE], Zeichenkette)
- Spalte: Hobby Code ([O21.OPTIMA.import.Customer_Owner.HOBBY_CODE], Zeichenkette)
- Spalte: Agent Code ([O21.OPTIMA.import.Customer_Owner.AGENT_CODE], Zeichenkette)
- Spalte: Bank Branch Reg No ([O21.OPTIMA.import.Customer_Owner.BANK_BRANCH_REG_NO], Zeichenkette)
- Spalte: Invoice Form Code Non Elec ([O21.OPTIMA.import.Customer_Owner.INVOICE_FORM_CODE_NON_ELEC], Zeichenkette)
- Spalte: Freight Per Day ([O21.OPTIMA.import.Customer_Owner.FREIGHT_PER_DAY], Zahl)
- Spalte: Pdf Statement ([O21.OPTIMA.import.Customer_Owner.PDF_STATEMENT], Zeichenkette)
- Spalte: Pdf Formcode ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE], Zeichenkette)
- Spalte: E Mail Address 4 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_4], Zeichenkette)
- Spalte: In House Financing ([O21.OPTIMA.import.Customer_Owner.IN_HOUSE_FINANCING], Zeichenkette)
- Spalte: Insurance Code ([O21.OPTIMA.import.Customer_Owner.INSURANCE_CODE], Zeichenkette)
- Spalte: Handler System ([O21.OPTIMA.import.Customer_Owner.HANDLER_SYSTEM], Zahl)
- Spalte: Location Code ([O21.OPTIMA.import.Customer_Owner.LOCATION_CODE], Zeichenkette)
- Spalte: Skip Cust Data Checks ([O21.OPTIMA.import.Customer_Owner.SKIP_CUST_DATA_CHECKS], Zeichenkette)
- Spalte: Obsolete ([O21.OPTIMA.import.Customer_Owner.OBSOLETE], Zeichenkette)
- Spalte: Freight Fee Group ([O21.OPTIMA.import.Customer_Owner.FREIGHT_FEE_GROUP], Zeichenkette)
- Spalte: Cash Mark ([O21.OPTIMA.import.Customer_Owner.CASH_MARK], Zeichenkette)
- Spalte: Send Order Follow Up ([O21.OPTIMA.import.Customer_Owner.SEND_ORDER_FOLLOW_UP], Zeichenkette)
- Spalte: Veh Certificate Print Imp ([O21.OPTIMA.import.Customer_Owner.VEH_CERTIFICATE_PRINT_IMP], Zeichenkette)
- Spalte: Decl First Change Date ([O21.OPTIMA.import.Customer_Owner.DECL_FIRST_CHANGE_DATE], Datum/Uhrzeit)
- Spalte: Decl Last Cust Cont Date ([O21.OPTIMA.import.Customer_Owner.DECL_LAST_CUST_CONT_DATE], Datum/Uhrzeit)
- Spalte: Decl Last Change Order No ([O21.OPTIMA.import.Customer_Owner.DECL_LAST_CHANGE_ORDER_NO], Zahl)
- Spalte: Decl State Origin ([O21.OPTIMA.import.Customer_Owner.DECL_STATE_ORIGIN], Zeichenkette)
- Spalte: Decl State Remark ([O21.OPTIMA.import.Customer_Owner.DECL_STATE_REMARK], Zeichenkette)
- Spalte: Pdf Interest Invoice ([O21.OPTIMA.import.Customer_Owner.PDF_INTEREST_INVOICE], Zeichenkette)
- Spalte: Pdf Formcode Ii ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_II], Zeichenkette)
- Spalte: E Mail Address 5 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_5], Zeichenkette)
- Spalte: Pdf Claim Invoice ([O21.OPTIMA.import.Customer_Owner.PDF_CLAIM_INVOICE], Zeichenkette)
- Spalte: Pdf Formcode Ci ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_CI], Zeichenkette)
- Spalte: E Mail Address 6 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_6], Zeichenkette)
- Spalte: Bic ([O21.OPTIMA.import.Customer_Owner.BIC], Zeichenkette)
- Spalte: Iban ([O21.OPTIMA.import.Customer_Owner.IBAN], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.Customer_Owner.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.Customer_Owner.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.Customer_Owner.UNIQUE_IDENT], Zahl)
- Spalte: Pmt Code Vehicle ([O21.OPTIMA.import.Customer_Owner.PMT_CODE_VEHICLE], Zeichenkette)
- Spalte: Bypass Auto Search ([O21.OPTIMA.import.Customer_Owner.BYPASS_AUTO_SEARCH], Zeichenkette)
- Spalte: E Mail Address 7 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_7], Zeichenkette)
- Spalte: Identity Card ([O21.OPTIMA.import.Customer_Owner.IDENTITY_CARD], Zeichenkette)
- Spalte: Small Access Separate ([O21.OPTIMA.import.Customer_Owner.SMALL_ACCESS_SEPARATE], Zeichenkette)
- Spalte: E Mail Address 8 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_8], Zeichenkette)
- Spalte: Pdf Formcode Rl ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_RL], Zeichenkette)
- Spalte: Pdf Reminder Letter ([O21.OPTIMA.import.Customer_Owner.PDF_REMINDER_LETTER], Zeichenkette)
- Spalte: Decl Form Presented ([O21.OPTIMA.import.Customer_Owner.DECL_FORM_PRESENTED], Zeichenkette)
- Spalte: E Mail Address 10 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_10], Zeichenkette)
- Spalte: E Mail Address 9 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_9], Zeichenkette)
- Spalte: Ford Payment Card ([O21.OPTIMA.import.Customer_Owner.FORD_PAYMENT_CARD], Zeichenkette)
- Spalte: Pdf Formcode L1 ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_L1], Zeichenkette)
- Spalte: Pdf Formcode L2 ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_L2], Zeichenkette)
- Spalte: Pdf Leasing Invoice ([O21.OPTIMA.import.Customer_Owner.PDF_LEASING_INVOICE], Zeichenkette)
- Spalte: Pdf Service Invoice ([O21.OPTIMA.import.Customer_Owner.PDF_SERVICE_INVOICE], Zeichenkette)
- Spalte: Show Time Price ([O21.OPTIMA.import.Customer_Owner.SHOW_TIME_PRICE], Zeichenkette)
- Spalte: Central Customer File ([O21.OPTIMA.import.Customer_Owner.CENTRAL_CUSTOMER_FILE], Zeichenkette)
- Spalte: Contact First Name ([O21.OPTIMA.import.Customer_Owner.CONTACT_FIRST_NAME], Zeichenkette)
- Spalte: Contact Last Name ([O21.OPTIMA.import.Customer_Owner.CONTACT_LAST_NAME], Zeichenkette)
- Spalte: Contact Title ([O21.OPTIMA.import.Customer_Owner.CONTACT_TITLE], Zeichenkette)
- Spalte: Contact Title Code ([O21.OPTIMA.import.Customer_Owner.CONTACT_TITLE_CODE], Zeichenkette)
- Spalte: E Mail Address 11 ([O21.OPTIMA.import.Customer_Owner.E_MAIL_ADDRESS_11], Zeichenkette)
- Spalte: Mobile Phone 3 ([O21.OPTIMA.import.Customer_Owner.MOBILE_PHONE_3], Zeichenkette)
- Spalte: Pdf Formcode Sc ([O21.OPTIMA.import.Customer_Owner.PDF_FORMCODE_SC], Zeichenkette)
- Spalte: Pdf Sepa Notification ([O21.OPTIMA.import.Customer_Owner.PDF_SEPA_NOTIFICATION], Zeichenkette)
- Spalte: Pdf Service Contract ([O21.OPTIMA.import.Customer_Owner.PDF_SERVICE_CONTRACT], Zeichenkette)
- Spalte: Preferred Channel ([O21.OPTIMA.import.Customer_Owner.PREFERRED_CHANNEL], Zeichenkette)
- Spalte: Preferred Smart Pay ([O21.OPTIMA.import.Customer_Owner.PREFERRED_SMART_PAY], Zeichenkette)
- Spalte: Renault Branch ([O21.OPTIMA.import.Customer_Owner.RENAULT_BRANCH], Zeichenkette)
- Spalte: Client Db ([O21.OPTIMA.import.Customer_Owner.CLIENT_DB], Zeichenkette)
- Tabellenverbindungen:
- UNIT_FILE - UNIT_HISTORY: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.UNIT_NUMBER] = [O21.OPTIMA.import.UNIT_HISTORY.UNIT_NUMBER] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.UNIT_HISTORY.CLIENT_DB]
- UNIT_FILE - VEHICLE: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.BASIS_NUMBER] = [O21.OPTIMA.import.VEHICLE.BASIS_NUMBER] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.VEHICLE.CLIENT_DB]
- UNIT_FILE - VPP43: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.SALE_SALESMAN] = [O21.OPTIMA.import.VPP43.SELLER_CODE] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.VPP43.CLIENT_DB]
- UNIT_FILE - VPP43(Einkauf): Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.PURCH_SALSMAN_CODE] = [O21.OPTIMA.import.VPP43.SELLER_CODE] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.VPP43.CLIENT_DB]
- UNIT_FILE - vPP5R: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.VEHICLE_TYPE] = [O21.OPTIMA.import.vPP5R.VEHICLE_TYPE] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.vPP5R.CLIENT_DB]
- UNIT_FILE - DEPARTMENT_TYPE: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.SALES_DEPARTMENT] = [O21.OPTIMA.import.DEPARTMENT_TYPE.DEPARTMENT_TYPE_ID] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.DEPARTMENT_TYPE.CLIENT_DB]
- UNIT_FILE - CUSTOMER: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.ACCOUNT_SALES] = [O21.OPTIMA.import.CUSTOMER.CUSTOMER_NUMBER] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.CUSTOMER.CLIENT_DB]
- CUSTOMER - VPP48: Linke offene Verbindung
- [O21.OPTIMA.import.CUSTOMER.CUSTOMER_GROUP] = [O21.OPTIMA.import.VPP48.CUSTOMER_GROUP] UND [O21.OPTIMA.import.CUSTOMER.CLIENT_DB] = [O21.OPTIMA.import.VPP48.CLIENT_DB]
- UNIT_FILE - vPP5M: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_FILE.BOOK_KEEPING_CODE] = [O21.OPTIMA.import.vPP5M.BOOK_KEEPING_CODE] UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.vPP5M.CLIENT_DB]
- VEHICLE - VPP5Q: Linke offene Verbindung
- [O21.OPTIMA.import.VEHICLE.MODEL_LINE] = [O21.OPTIMA.import.VPP5Q.MODEL_LINE] UND [O21.OPTIMA.import.VEHICLE.MAKE_CD] = [O21.OPTIMA.import.VPP5Q.MAKE_CD] UND [O21.OPTIMA.import.VEHICLE.CLIENT_DB] = [O21.OPTIMA.import.VPP5Q.CLIENT_DB]
- VEHICLE - vPP74: Linke offene Verbindung
- [O21.OPTIMA.import.VEHICLE.MAKE_CD] = [O21.OPTIMA.import.vPP74.MAKE_CD] UND [O21.OPTIMA.import.VEHICLE.WORKSHOP_MODEL] = [O21.OPTIMA.import.vPP74.WORKSHOP_MODEL] UND [O21.OPTIMA.import.VEHICLE.CLIENT_DB] = [O21.OPTIMA.import.vPP74.CLIENT_DB]
- VEHICLE - GLOBAL_MAKE: Linke offene Verbindung
- [O21.OPTIMA.import.VEHICLE.MAKE_CD] = [O21.OPTIMA.import.GLOBAL_MAKE.GLOBAL_MAKE_CD] UND [O21.OPTIMA.import.VEHICLE.CLIENT_DB] = [O21.OPTIMA.import.GLOBAL_MAKE.CLIENT_DB]
- UNIT_HISTORY - vPP5A: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_HISTORY.TRANSACTION_CODE] = [O21.OPTIMA.import.vPP5A.TRANSACTION_CODE] UND [O21.OPTIMA.import.UNIT_HISTORY.CLIENT_DB] = [O21.OPTIMA.import.vPP5A.CLIENT_DB]
- UNIT_CHANGE_HIST - UNIT_FILE: Rechte offene Verbindung
- [O21.OPTIMA.import.UNIT_CHANGE_HIST.UNIT_NUMBER] = [O21.OPTIMA.import.UNIT_FILE.UNIT_NUMBER] UND [O21.OPTIMA.import.UNIT_CHANGE_HIST.DEPARTMENT] <> ' ' UND [O21.OPTIMA.import.UNIT_FILE.CLIENT_DB] = [O21.OPTIMA.import.UNIT_CHANGE_HIST.CLIENT_DB]
- UNIT_CHANGE_HIST - GC_Department: Linke offene Verbindung
- [O21.OPTIMA.import.UNIT_CHANGE_HIST.CLIENT_DB] = [O21.OPTIMA.data.GC_Department.Hauptbetrieb] UND LINKS ( [O21.OPTIMA.import.UNIT_CHANGE_HIST.DEPARTMENT]; 2 ) = [O21.OPTIMA.data.GC_Department.Standort]
- GC_Marken - VEHICLE: Rechte offene Verbindung
- [O21.OPTIMA.data.GC_Marken.Client_DB] = [O21.OPTIMA.import.VEHICLE.CLIENT_DB] UND [O21.OPTIMA.data.GC_Marken.Make] = [O21.OPTIMA.import.VEHICLE.MAKE_CD]
- VEHICLE - Customer_Owner: Linke offene Verbindung
- [O21.OPTIMA.import.VEHICLE.OWNER_CODE] = [O21.OPTIMA.import.CUSTOMER.CUSTOMER_NUMBER] UND [O21.OPTIMA.import.VEHICLE.CLIENT_DB] = [O21.OPTIMA.import.CUSTOMER.CLIENT_DB]
- 'Benutzerklasseninformationen
- Benutzerklasse: Ersteller
- Client/Server-Informationen
- Abfrageverarbeitung: Flexible Verarbeitung
- Verbindungsdauer minimieren: False
- Gouverneur-Informationen
- Neue Berichte erstellen: True
- Ordner hinzufügen/ändern: True
- Benutzerklassen hinzufügen/ändern: True
- SQL-Direkteingabe: True
- 'Über-Kreuz'-Produktabfragen: Verhindern
- Offene Verbindungen zulassen: Zulassen
- Sortieren an nicht-indizierten Spalten: Zulassen
- 'Select Distinct' zulassen: Zulassen
- Abruf der Zeilen aus der Datenbank beschränken
- Warnen bei: 0
- Stoppen bei: 0
- Abfrageausführungs-Zeitlimits
- Warnen bei: 0
- Stoppen bei: 0
- Tabellen-Limit je Bericht
- Warnen bei: 0
- Stoppen bei: 0
- Text-Blob-Limit: False
- Max. Text-Blob-Zeichen: nv
|