1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917 |
- Kataloginformationen
- Katalog-Dateiname: C:\GlobalCube\System\OPTIMA\Catalogs\Monteur.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: ORDER_HEADER
- Spalte: ORDER_NUMBER (decimal)
- Spalte: REGISTER_NUMBER (char)
- Spalte: STATUS (char)
- Spalte: STATE_KEY_DATE (datetime)
- Spalte: DEBIT_ACCOUNT (char)
- Spalte: INVOICE_NUMBER (decimal)
- Spalte: WORKSHOP_MODEL (char)
- Spalte: STATE_CODE (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DELIVERY_ACCOUNT (char)
- Spalte: DEPARTMENT (char)
- Spalte: DEBET_DEPARTMENT (char)
- Spalte: SALESMAN (char)
- Spalte: DEBIT_PERM (char)
- Spalte: ORDER_DATE (datetime)
- Spalte: DELIVERY_DATE (datetime)
- Spalte: INVOICE_DATE (datetime)
- Spalte: TAX_CODE (char)
- Spalte: TAX_PERC (decimal)
- Spalte: PMT_TERM (char)
- Spalte: DELIVERY_WAY_CODE (char)
- Spalte: DELIVERY_TERM (char)
- Spalte: REFERENCE (varchar)
- Spalte: NOTE (varchar)
- Spalte: SPEC_TERMS (varchar)
- Spalte: NEXT_LINE_NUMBER (decimal)
- Spalte: DUEDATE_1 (datetime)
- Spalte: PAYMENT_TEXT (varchar)
- Spalte: COSTS (decimal)
- Spalte: PURCH_TAX (decimal)
- Spalte: ORDERS_GROSSVALUE (decimal)
- Spalte: TAX_SHARE (decimal)
- Spalte: DISCOUNT_AMOUNT (decimal)
- Spalte: PRICE_CODE (char)
- Spalte: MISC_ADDS (decimal)
- Spalte: STOCK (char)
- Spalte: PLACE_CODE (char)
- Spalte: INTERNAL_CODE (char)
- Spalte: CUSTOMER_GROUP (char)
- Spalte: SMALL_ACCESSORIES (char)
- Spalte: INVOICE_COPY_CODE (char)
- Spalte: BASIS_NUMBER (char)
- Spalte: MILEAGE (decimal)
- Spalte: PREV_STATUS (char)
- Spalte: TEXT_CODE_1 (char)
- Spalte: TEXT_CODE_2 (char)
- Spalte: TEXT_CODE_3 (char)
- Spalte: SALES_CLASS_NUMBER (char)
- Spalte: INVOICE_DISC_PERC (decimal)
- Spalte: INVOICE_ROUNDED (decimal)
- Spalte: INVOICE_CHARGE (decimal)
- Spalte: SALES_TAX_FREE (decimal)
- Spalte: TITLE (varchar)
- Spalte: NAME (varchar)
- Spalte: STREET_ADDR (varchar)
- Spalte: ADDR_2 (varchar)
- Spalte: ZIPCODE (char)
- Spalte: MAIL_ADDR (varchar)
- Spalte: DISCOUNT_LIMIT (char)
- Spalte: REFERENCE_NUMBER (decimal)
- Spalte: EXPECTED_ORDER_TIM (decimal)
- Spalte: BOL_TAX_SHARE (decimal)
- Spalte: MODEL_TEXT (varchar)
- Spalte: EFFECT_CODE (char)
- Spalte: INVOICE_CODE (char)
- Spalte: SMALL_INV_CHARGE (char)
- Spalte: CREDIT_ORDER (char)
- Spalte: ON_MICROFICHE (char)
- Spalte: WORKSHOP_PRICECODE (char)
- Spalte: SPLIT_COUNTER (decimal)
- Spalte: BACK_ORDER_PERM (char)
- Spalte: REDUCTION_CODE (char)
- Spalte: BACK_ORDER_RELEASE (char)
- Spalte: VAT_TABLE_WORK (char)
- Spalte: VAT_TABLE_NORMAL (char)
- Spalte: SMALL_MAT_WUST_CD (char)
- Spalte: SMALL_MAT_VAT_TAB (char)
- Spalte: INV_CHARGE_WUST_CD (char)
- Spalte: INV_CHARGE_VAT_TAB (char)
- Spalte: QUICK_END_STATUS (char)
- Spalte: LANGUAGE_CODE (char)
- Spalte: ARRIVAL_TIME (decimal)
- Spalte: ARRIVAL_DATE (datetime)
- Spalte: END_DATE (datetime)
- Spalte: END_TIME (decimal)
- Spalte: PRIORITY (decimal)
- Spalte: MARK_NUMBER (char)
- Spalte: JOB_NUMBER (varchar)
- Spalte: DISCOUNT_PERC_BIG (decimal)
- Spalte: DISPATCH_FEE_PCT (decimal)
- Spalte: ADDR_3 (varchar)
- Spalte: COUNTY (varchar)
- Spalte: MILEAGE_ACCEPTED (char)
- Spalte: FAC_MODEL_CODE_S (varchar)
- Spalte: SPLIT_MAIN_ORDERNO (decimal)
- Spalte: SPLIT_SUB1_ORDERNO (decimal)
- Spalte: SPLIT_SUB2_ORDERNO (decimal)
- Spalte: SPLIT_TYPE (char)
- Spalte: SPLIT_TYPE_2 (char)
- Spalte: SPLIT_REDUC_MAIN (char)
- Spalte: SPLIT_PCT_MAIN (decimal)
- Spalte: SPLIT_TOT_AM_MAIN (decimal)
- Spalte: SPLIT_FIX_MAIN (char)
- Spalte: SPLIT_REDUC_SUB1 (char)
- Spalte: SPLIT_PCT_SUB1 (decimal)
- Spalte: SPLIT_TOT_AM_SUB1 (decimal)
- Spalte: SPLIT_FIX_SUB1 (char)
- Spalte: SPLIT_REDUC_SUB2 (char)
- Spalte: SPLIT_PCT_SUB2 (decimal)
- Spalte: SPLIT_TOT_AM_SUB2 (decimal)
- Spalte: SPLIT_FIX_SUB2 (char)
- Spalte: BOOK_NO (char)
- Spalte: BOOK_NO_FLAG (char)
- Spalte: BOOK_NO_CASH_PMT (char)
- Spalte: REFERENCE_DATE (datetime)
- Spalte: REPAIR_CARD_DONE (char)
- Spalte: HOURLY_REPAIR_RATE (decimal)
- Spalte: CUSTOMER_ID (char)
- Spalte: CUSTOMER_STOCK (char)
- Spalte: LINE_REFERENCE (decimal)
- Spalte: CAMPAIGN_TYPE (char)
- Spalte: CAMPAIGN_NUMBER (char)
- Spalte: WORK_TYPE_CODE (char)
- Spalte: EXTERNAL_REFERENCE (varchar)
- Spalte: MAKE_CD (char)
- Spalte: PERSONAL_RECEIPT (char)
- Spalte: INSPECTION_DONE (char)
- Spalte: ADDITIONAL_WORK (char)
- Spalte: QUALITY_INSPECTED (char)
- Spalte: READY_IN_DUE_TIME (char)
- Spalte: INV_EXPLAINED (char)
- Spalte: MEMBERSHIP_NUMBER (varchar)
- Spalte: CREATE_MSC (char)
- Spalte: YEAR_MODEL (char)
- Spalte: PLANNED_ST_WK_TIME (decimal)
- Spalte: TUV_INSP (char)
- Spalte: CAMPAIGN_YES_NO (char)
- Spalte: E_MAIL_INVOICE (char)
- Spalte: E_MAIL_DNOTE (char)
- Spalte: E_MAIL_OCONF (char)
- Spalte: SEND_ORDER_ADVICE (char)
- Spalte: TRANSFER_MAKE_CD (char)
- Spalte: CHASSIS_NUMBER (varchar)
- Spalte: CUSTOMER_WAITING (char)
- Spalte: CREDIT_NOTE (char)
- Spalte: DISPATCH_FEE_ALL_LINES (char)
- Spalte: VAT_SUSPENSION (char)
- Spalte: CUSTOMER_EAN_NUMBER (decimal)
- Spalte: EAN_DEPARTMENT (varchar)
- Spalte: EAN_REFERENCE (varchar)
- Spalte: EAN_INTERNAL_ACCT (varchar)
- Spalte: WORKSHOP_TEAM (char)
- Spalte: COMMISSION_SALESMAN (char)
- Spalte: COURTESY_CAR_ID (char)
- Spalte: CUSTOMER_ARRIVED (char)
- Spalte: INSPECTION_DONE_BY (char)
- Spalte: TEST_DRIVE_DONE (char)
- Spalte: TEST_DRIVE_DONE_BY (char)
- Spalte: ORDER_ORIGIN (char)
- Spalte: INSPECTION_WITH_CUSTOMER (char)
- Spalte: CONTRACT_NUMBER (char)
- Spalte: REF_IDENT_INV_TOTAL (decimal)
- Spalte: REF_IDENT_SALES_CLASS (decimal)
- Spalte: USE_PARTS_PRE_PICKING (char)
- Spalte: LDC_ORDER (char)
- Spalte: FHG_REPORT (char)
- Spalte: ACTUAL_INV_DATE_TIME (datetime)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: ORDER_LINE
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: KEY_PROD_CODE (varchar)
- Spalte: KEY_MAKE_CD (char)
- Spalte: DELIVERY_DATE (datetime)
- Spalte: LINE_GROUP_CODE (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: STATE_CODE (char)
- Spalte: PERSON_CODE (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: ORDER_LINETYPE (char)
- Spalte: ORDER_LINETYPE_2 (char)
- Spalte: ORDER_LINETYPE_3 (char)
- Spalte: RESULTING_LINE (decimal)
- Spalte: RESULTING_LINE_2 (decimal)
- Spalte: JOB_CODE (char)
- Spalte: PRINT_INVOICE (char)
- Spalte: REDUCTION_CODE (char)
- Spalte: REDUCTION_AMOUNT (decimal)
- Spalte: REDUCTION_CODE_2 (char)
- Spalte: REDUCTION_POS (decimal)
- Spalte: SPLIT_CODE (char)
- Spalte: SPLIT_CODE_2 (char)
- Spalte: SMALL_ACCESSORIES (char)
- Spalte: PICKED (char)
- Spalte: MECHANIC_CODE (char)
- Spalte: SALESMAN (char)
- Spalte: DISCOUNT_TABLE (char)
- Spalte: DISCOUNT_CODE (char)
- Spalte: CLAIM_CODE_IND (char)
- Spalte: CLAIM_NUMBER (decimal)
- Spalte: KIT_FIXED_PRICE_CD (char)
- Spalte: R_DELIVERY_DATE (datetime)
- Spalte: WUST_CODE (char)
- Spalte: STATUS (char)
- Spalte: STOCK (char)
- Spalte: GROSS_DISCOUNT (char)
- Spalte: STATISTIC_CODE (char)
- Spalte: DECIMAL_INDICATOR (char)
- Spalte: ADD_COST_CODE (char)
- Spalte: DISCOUNT_PERC (decimal)
- Spalte: DISCOUNT_PERC_2 (decimal)
- Spalte: DISCOUNT (decimal)
- Spalte: STDPRICE (decimal)
- Spalte: LINES_NET_VALUE (decimal)
- Spalte: TAX_CODE_1 (char)
- Spalte: VAT_RATE_CODE (char)
- Spalte: TAX_C_U (decimal)
- Spalte: TAX_DRAWN (decimal)
- Spalte: LINE_MISC_ADDS (decimal)
- Spalte: LINE_MISC_ADDS_PER (decimal)
- Spalte: CLAIM_TROUBLE_CD (char)
- Spalte: SPLIT_TYPE (char)
- Spalte: SPLIT_AM_MAIN (decimal)
- Spalte: SPLIT_AM_SUB1 (decimal)
- Spalte: SPLIT_AM_SUB2 (decimal)
- Spalte: PROD_CODE (varchar)
- Spalte: MAKE_CD (char)
- Spalte: PRODUCT_GROUP (char)
- Spalte: PROD_NAME (varchar)
- Spalte: LOCATION (varchar)
- Spalte: LOCATION_2 (varchar)
- Spalte: LOCATION_3 (varchar)
- Spalte: DEDUCTABLE (char)
- Spalte: ORDER_QUANTITY (decimal)
- Spalte: DELIVERY_QUANTITY (decimal)
- Spalte: SPEC_PURCH_PRICE (char)
- Spalte: RE_PURCHASE_PRICE (decimal)
- Spalte: LINE_COSTS (decimal)
- Spalte: COSTPRICE_TAX (decimal)
- Spalte: CLAIM_RETURN_CODE (char)
- Spalte: INV_TOTAL_NUMBER (decimal)
- Spalte: SPECIAL_PRICE (decimal)
- Spalte: SALES_PRICE (decimal)
- Spalte: SALES_PRICE_INCL (decimal)
- Spalte: ORIG_ORDER_NO (decimal)
- Spalte: ORIG_LINE_NO (decimal)
- Spalte: ORIG_CREATION_CODE (char)
- Spalte: BACK_ORDER_CD (char)
- Spalte: BACK_ORDER (decimal)
- Spalte: INTERNAL_TRANSFER (char)
- Spalte: STDPRICE_2 (decimal)
- Spalte: QUANTITY_DISC_CODE (char)
- Spalte: CAMPAIGN_CODE (char)
- Spalte: REPLACE_CODE (char)
- Spalte: N_MAIN_PART_NO (char)
- Spalte: LINE_TEXTLINE_1 (varchar)
- Spalte: LINE_TEXTLINE_2 (varchar)
- Spalte: LINE_TEXTLINE_3 (varchar)
- Spalte: LINE_TEXT_CODE (char)
- Spalte: LINE_CODE (char)
- Spalte: LINE_WORKSHOP (char)
- Spalte: BACK_REG_CODE (char)
- Spalte: REQUISITION_NUM (char)
- Spalte: REPAIR_CODE (varchar)
- Spalte: REPAIR_GROUP (char)
- Spalte: REPAIR_NAME (varchar)
- Spalte: RATE_PRICE_CODE (char)
- Spalte: TIME_RATE (char)
- Spalte: USED_TIME (decimal)
- Spalte: EST_TIME (decimal)
- Spalte: INV_TIME (decimal)
- Spalte: REPAIR_CODE_2 (char)
- Spalte: REPAIR_POS (decimal)
- Spalte: LINE_COMMENT (char)
- Spalte: INSPECTION_1 (char)
- Spalte: INSPECTION_2 (char)
- Spalte: WORK_DATE (datetime)
- Spalte: START_TIME (decimal)
- Spalte: END_DATE (datetime)
- Spalte: END_TIME (decimal)
- Spalte: WORKSHOP_AREA (varchar)
- Spalte: W_MAIN_REPAIR_NO (char)
- Spalte: KIT_GROUP (char)
- Spalte: KIT_CODE (varchar)
- Spalte: WORKSHOP_MODEL (char)
- Spalte: KIT_TEXT (varchar)
- Spalte: KIT_FIXED_PRICE (decimal)
- Spalte: CLASS_RULE (char)
- Spalte: KIT_ONE_LINE (char)
- Spalte: KIT_ONE_LINEPRICE (char)
- Spalte: KIT_CATALOG_CODE (char)
- Spalte: KIT_PARTS_DISC_PER (decimal)
- Spalte: KIT_WORK_DISC_PER (decimal)
- Spalte: KIT_MISC_DISC_PER (decimal)
- Spalte: KIT_DELETE (char)
- Spalte: KIT_PRICE_DIFF (decimal)
- Spalte: KIT_PRINT_SPLIT (char)
- Spalte: TYPE_OL (char)
- Spalte: TRANSACTION_CODE_2 (char)
- Spalte: TXT_OL (varchar)
- Spalte: AMOUNT_OL (decimal)
- Spalte: CASH_ACCOUNT (char)
- Spalte: REPAIR_CODE_ACCU (char)
- Spalte: RECOMMENDED_PRICE (decimal)
- Spalte: COST_PRICE_WORK (decimal)
- Spalte: TIME_CODE_1 (char)
- Spalte: USED_TIME_TYPE_1 (decimal)
- Spalte: COST_PRICE_TYPE_1 (decimal)
- Spalte: TIME_CODE_2 (char)
- Spalte: USED_TIME_TYPE_2 (decimal)
- Spalte: COST_PRICE_TYPE_2 (decimal)
- Spalte: DISCOUNT_ALLOWANCE (char)
- Spalte: CREATE_AFTER_RC (char)
- Spalte: REPEAT_REPAIR (char)
- Spalte: INV_TIME_COST (decimal)
- Spalte: TIME_CODE (char)
- Spalte: FACTOR_CODE (char)
- Spalte: REDUCTION_FACTOR_1 (decimal)
- Spalte: RESULTING_LINE_1 (decimal)
- Spalte: EXTERNAL_STOCK (char)
- Spalte: REPAIR_GROUP_TYPE (char)
- Spalte: AUTOMATIC_CREATED (char)
- Spalte: INCOMPLETE_LINE (char)
- Spalte: INCOMPLETE_LINE_2 (char)
- Spalte: ORDER_LINETYPE_4 (char)
- Spalte: CONSIGNMENT_CODE (char)
- Spalte: PART_GROUP (char)
- Spalte: MISC_1 (char)
- Spalte: MISC_2 (char)
- Spalte: MISC_3 (char)
- Spalte: MISC_4 (char)
- Spalte: MISC_5 (char)
- Spalte: MISC_6 (char)
- Spalte: ORDER_LINE_TRANSM (char)
- Spalte: ORIG_PROD_CODE (varchar)
- Spalte: ORIG_MAKE_CD (char)
- Spalte: ORIG_PROD_GROUP (char)
- Spalte: BUYERS_REFERENCE (varchar)
- Spalte: CCC_CATEGORY (char)
- Spalte: CCC (char)
- Spalte: EXTERNAL_ORIGIN (char)
- Spalte: STOCK_SHOP_LIST (char)
- Spalte: LINE_REFERENCE (decimal)
- Spalte: WORK_TYPE_CODE (char)
- Spalte: CUSTOMER_COMPLAINT (char)
- Spalte: JOB_CODE_DESCR (char)
- Spalte: TEXT_200 (varchar)
- Spalte: PAYER_PERCENTAGE (decimal)
- Spalte: PRICE_A_G (char)
- Spalte: ALTERNATIVE_PRICE (decimal)
- Spalte: QTY_OWNERSHIP (char)
- Spalte: FLAT_SEARCH_2 (char)
- Spalte: FLAT_SEARCH_3 (char)
- Spalte: FLAT_SEARCH_4 (char)
- Spalte: FLAT_SEARCH_5 (char)
- Spalte: FLAT_SEARCH_6 (char)
- Spalte: FLAT_SEARCH_7 (char)
- Spalte: FLAT_SEARCH_8 (char)
- Spalte: FLAT_SEARCH_9 (char)
- Spalte: CREATE_MSC (char)
- Spalte: SPECIAL_LOCK_NO (char)
- Spalte: SUPPLIER_CODE (char)
- Spalte: REQUISITION_NUMBER (varchar)
- Spalte: USED_TIME_INT (decimal)
- Spalte: EST_TIME_INT (decimal)
- Spalte: INV_TIME_INT (decimal)
- Spalte: MAKE_TIME_UNIT (char)
- Spalte: DEPOSIT_TYPE (char)
- Spalte: LINE_STATUS (char)
- Spalte: SALES_UNIT_STD (char)
- Spalte: SALES_UNIT_ALT (char)
- Spalte: ORDER_QUANTITY_ALT_UNIT (decimal)
- Spalte: OIL (char)
- Spalte: DEDUCTIBLE_VAT (char)
- Spalte: ACCUMULATED_MENU_CHANGES (decimal)
- Spalte: WORKSHOP_TEAM (char)
- Spalte: REPAIR_LOCATION_CODE (char)
- Spalte: MENU_TYPE (char)
- Spalte: PROMOTION_NUMBER (decimal)
- Spalte: PROMOTION_DISCOUNT_PCT (decimal)
- Spalte: QTY_SOLD_NEGATIVE (decimal)
- Spalte: ORIG_COST_PRICE (decimal)
- Spalte: REQUESTED_QUANTITY (decimal)
- Spalte: PICKING_LIST_NO (decimal)
- Spalte: EXCHANGE_PART (char)
- Spalte: EXCHANGE_RETURN_CODE (char)
- Spalte: EXTERNAL_PICK_IN_PROGRESS (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP25
- Spalte: STAT_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: STAT_SPECIFY (varchar)
- Spalte: STAT_BILLOFL (varchar)
- Spalte: STAT_INVOICE (varchar)
- Spalte: STAT_NO_TURNOVER (varchar)
- Spalte: STAT_EFFECT_CODE (varchar)
- Spalte: STAT_DELETE_TERM (varchar)
- Spalte: STAT_NEW_STATUS (varchar)
- Spalte: STAT_NEW_CRED_STAT (varchar)
- Spalte: STAT_NEW_BOL_STAT (varchar)
- Spalte: STAT_UPD_SAL_DATE (varchar)
- Spalte: STAT_UPD_SALES (varchar)
- Spalte: STAT_ORDER_STAT_1 (varchar)
- Spalte: STAT_ORDER_STAT_2 (varchar)
- Spalte: STAT_ORDER_STAT_3 (varchar)
- Spalte: STAT_ORDER_STAT_4 (varchar)
- Spalte: STAT_ORDER_STAT_5 (varchar)
- Spalte: STAT_UNIT_SALES (varchar)
- Spalte: STAT_FIXED_TXT_COD (varchar)
- Spalte: STAT_MAKE_CHK_USED (varchar)
- Spalte: STAT_QUICK_ENDSTAT (varchar)
- Spalte: STAT_PART_ORDER (varchar)
- Spalte: STAT_GREAT_ORDER (varchar)
- Spalte: STAT_MILEAGE_CHECK (varchar)
- Spalte: ACTIVITY_CODE (varchar)
- Spalte: KIT_W_LINES (varchar)
- Spalte: USE_PRICE_A_G (varchar)
- Spalte: SEND_ADVICE (varchar)
- Spalte: MINUTE_CODE (varchar)
- Spalte: VEH_INV_PURCHASE_TEXT (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP2C
- Spalte: LOGIN (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: USER_HANDLER (varchar)
- Spalte: USER_GROUP (varchar)
- Spalte: HELP_LEVEL (varchar)
- Spalte: LOW_ENTENSITY (varchar)
- Spalte: ERROR_BEEP (varchar)
- Spalte: KEY_IN_ATTR (varchar)
- Spalte: HARDCOPY_PRINTER (varchar)
- Spalte: RESTORE_SCREEN (varchar)
- Spalte: STOCK (varchar)
- Spalte: DATE_ORDER (varchar)
- Spalte: DAILY_CLOS_RESP (varchar)
- Spalte: DAILY_CLOS_FUNC (varchar)
- Spalte: PRICE_CONTROL_GRP (varchar)
- Spalte: USER_CLEARANCE (varchar)
- Spalte: CASH_ACCOUNT (varchar)
- Spalte: DEPARTMENT (varchar)
- Spalte: CASHBON_PRINTER (varchar)
- Spalte: OPEN_STATUS_STEP (varchar)
- Spalte: ACCT_PERM_CODE (varchar)
- Spalte: ORDER_OTHER_STOCKS (varchar)
- Spalte: INVOICE_ALLOW (varchar)
- Spalte: NO_RETURN_CHECK (varchar)
- Spalte: NEWS_MES (varchar)
- Spalte: NEWS_MES_SEEN (varchar)
- Spalte: NEWS_UPD (varchar)
- Spalte: NEWS_UPD_SEEN (varchar)
- Spalte: CREATE_PART (varchar)
- Spalte: CREATE_WMN (varchar)
- Spalte: SU_ORDER_UNLOCK (varchar)
- Spalte: BOOKKEEP_6420 (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: ALLOW_PRINT_CHEQUE (varchar)
- Spalte: CREDIT_WITHOUT_RETURN (varchar)
- Spalte: KEYCARD_READER_ID (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP43
- Spalte: SELLER_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SEL_NAME (varchar)
- Spalte: SEL_DEPARTMENT (varchar)
- Spalte: SEL_FIRST_NAME (varchar)
- Spalte: SEL_FAMILY_NAME (varchar)
- Spalte: SEL_TITLE (varchar)
- Spalte: SEL_MALE_FEMALE (varchar)
- Spalte: SEL_FACTOR (decimal)
- Spalte: SEL_COM_SALESMAN (varchar)
- Spalte: MECHANIC_PAY_GROUP (varchar)
- Spalte: ORDER_APPROV_PERM (varchar)
- Spalte: LICENCE_ID (varchar)
- Spalte: EMPLOYEE_CATEGORY (decimal)
- Spalte: TRAINEE_YEAR (decimal)
- Spalte: EMAIL_ADDRESS (varchar)
- 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 (varchar)
- Spalte: END_USER (varchar)
- Spalte: ORDER_DISCOUNT_GRP (varchar)
- Spalte: CONVERT_SOLD_TIME (varchar)
- 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: 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: vPP61
- Spalte: STOCK (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: STOCK_NAME (varchar)
- Spalte: STOCK_INTEREST (decimal)
- Spalte: SERVICE_FACTOR_ALPHA (varchar)
- Spalte: SERVICE_FACTOR (decimal)
- Spalte: BEH_CHECK (varchar)
- Spalte: LOCKED (varchar)
- Spalte: LOCKED_TEXT (varchar)
- Spalte: LOCKED_TEXT1 (varchar)
- Spalte: LOCKED_TEXT2 (varchar)
- Spalte: ZERO_QNT_LIST (varchar)
- Spalte: NOCARD_ON_ZERO_LIST (varchar)
- Spalte: TOYOTA_DEALER (decimal)
- Spalte: VOLVO_DEALER (varchar)
- Spalte: CALC_MIN_IN_STOCK (varchar)
- Spalte: FORD_DEALER (varchar)
- Spalte: GOD_DEALER (decimal)
- Spalte: UDAS_HANDLER (varchar)
- Spalte: BRANCH_NO (varchar)
- Spalte: FORD_STOCK_ID (varchar)
- Spalte: FORD_PART_DEALER (varchar)
- Spalte: PSA_F_DEALER (decimal)
- Spalte: NCG_DEALER (varchar)
- Spalte: RENAULT_DEALER (varchar)
- Spalte: VO_DEALER (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP65
- Spalte: PRODUCT_GROUP (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROD_GRP_SPECIFY (varchar)
- Spalte: COEFF (decimal)
- Spalte: COST_PERC (decimal)
- Spalte: DEPARTMENT_10 (varchar)
- Spalte: LINE_MISC_ADDS_PER (decimal)
- Spalte: SALES_ACCOUNT (varchar)
- Spalte: PRICE_TYPE_PROD_1 (varchar)
- Spalte: PRICE_TYPE_PROD_2 (varchar)
- Spalte: PRICE_TYPE_PROD_3 (varchar)
- Spalte: PRICE_TYPE_PROD_4 (varchar)
- Spalte: PRICE_TYPE_PROD_5 (varchar)
- Spalte: PROD_SORT_KEY (varchar)
- Spalte: PROD_GRP_CHECK (varchar)
- Spalte: INVOICE_TOTAL_NO (decimal)
- Spalte: BACK_ORDER_PERM (varchar)
- Spalte: ORIG_PROD_GRP (varchar)
- Spalte: FB_STATISTIC (varchar)
- Spalte: FORD_PART (varchar)
- Spalte: SALES_PRICE_ZERO (varchar)
- Spalte: DC2000_PROD_GRP (varchar)
- Spalte: SHORT_COMMUNITY (varchar)
- Spalte: RETURN_ALLOWED (varchar)
- Spalte: OPEL_PART (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: PURCH_PROD_GRP (varchar)
- Spalte: PRODUCT_GROUP_TP (varchar)
- Spalte: VR_PART (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP72
- Spalte: WORKSHOP_PRICECODE (varchar)
- Spalte: PRICE_CATEGORY (varchar)
- Spalte: WORKSHOP_MODEL (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: NAME (varchar)
- Spalte: PRICE_1 (decimal)
- Spalte: RUNNO_1 (varchar)
- Spalte: PRICE_2 (decimal)
- Spalte: RUNNO_2 (varchar)
- Spalte: PRICE_3 (decimal)
- Spalte: RUNNO_3 (varchar)
- Spalte: PRICE_4 (decimal)
- Spalte: RUNNO_4 (varchar)
- Spalte: PRICE_5 (decimal)
- Spalte: RUNNO_5 (varchar)
- Spalte: PRICE_6 (decimal)
- Spalte: RUNNO_6 (varchar)
- Spalte: PRICE_7 (decimal)
- Spalte: RUNNO_7 (varchar)
- Spalte: PRICE_8 (decimal)
- Spalte: RUNNO_8 (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: VPP73
- Spalte: REPAIR_GROUP (varchar)
- Spalte: MAKE_CD (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: REPAIR_GRP_SPECIFY (varchar)
- Spalte: ADD_PERC (decimal)
- Spalte: REPAIR_CODE1 (varchar)
- Spalte: REPAIR_POS (decimal)
- Spalte: REPAIR_STATISTIC_CODE (varchar)
- Spalte: SKILL_CODE (varchar)
- Spalte: REPAIR_GROUP_TYPE (varchar)
- Spalte: FACTOR (decimal)
- Spalte: CALC_OWN_REPAIR (varchar)
- Spalte: CALC_CENTR_REPAIR (varchar)
- Spalte: REPAIR_CALC_TYPE (varchar)
- Spalte: MONTH (decimal)
- Spalte: REPAIR_GROUP_TP (varchar)
- Spalte: REPAIR_GROUP_TYPE2 (varchar)
- Spalte: JOB_TYPE (varchar)
- Spalte: OPERATION_TYPE (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: VPP91
- Spalte: WORK_LEADER_GROUP (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: WORKLEADER_TEXT (varchar)
- Spalte: WORKLEADER_COLUMN (decimal)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: vPP93
- Spalte: ACT_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: ACTIVITY_TEXT (varchar)
- Spalte: SALARY_TYPE (varchar)
- Spalte: CLOCK_CARD_ACT (varchar)
- Spalte: ACTIVITY_COLUMN (decimal)
- Spalte: LONG_LASTING_ACT (varchar)
- Spalte: SICKNESS_ACT (varchar)
- Spalte: TIME_BASED_ACT (varchar)
- Spalte: ORDER_BASED_ACT (varchar)
- Spalte: PRESENT_ACT (varchar)
- Spalte: REPNO_PREFIX (varchar)
- Spalte: PRINT_INVOICE_ACT (varchar)
- Spalte: WAGE_TYPE (decimal)
- Spalte: ACTIVITY_COLUMN_2 (decimal)
- Spalte: AW_DEPARTMENT (varchar)
- Spalte: ACT_CODE_CHANGE_WL (varchar)
- Spalte: ACTIVITY_COLUMN_3 (decimal)
- Spalte: ACTIVITY_COLUMN_4 (decimal)
- Spalte: CLOCK_IN_FUNCTION (varchar)
- Spalte: CLOCK_OFF_FUNCTION (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: VPP43_Mechaniker
- Spalte: SELLER_CODE (varchar)
- Spalte: STATE_CODE_PARAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: SEL_NAME (varchar)
- Spalte: SEL_DEPARTMENT (varchar)
- Spalte: SEL_FIRST_NAME (varchar)
- Spalte: SEL_FAMILY_NAME (varchar)
- Spalte: SEL_TITLE (varchar)
- Spalte: SEL_MALE_FEMALE (varchar)
- Spalte: SEL_FACTOR (decimal)
- Spalte: SEL_COM_SALESMAN (varchar)
- Spalte: MECHANIC_PAY_GROUP (varchar)
- Spalte: ORDER_APPROV_PERM (varchar)
- Spalte: LICENCE_ID (varchar)
- Spalte: EMPLOYEE_CATEGORY (decimal)
- Spalte: TRAINEE_YEAR (decimal)
- Spalte: EMAIL_ADDRESS (varchar)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: ORDER_ACCUMULATION
- Spalte: ORDER_NUMBER (decimal)
- Spalte: ACCU_LEVEL (decimal)
- Spalte: ACCU_TYPE (char)
- Spalte: ACCU_CODE (char)
- Spalte: VAT_TABLE (char)
- Spalte: STATE_CODE_ACCU (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: TAX_PERC (decimal)
- Spalte: EXCHANGE_PART (char)
- Spalte: AMOUNT_EXCL (decimal)
- Spalte: TAX_SHARE (decimal)
- Spalte: PRINT_CHARS (char)
- Spalte: WUST_CODE (char)
- Spalte: TAX_DIFF_LINE (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: ORDER_OPEN_ITEMS
- Spalte: VEH_ORDER_OPTION_ID (decimal)
- Spalte: LINE_NO (decimal)
- Spalte: CREATION_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: CUSTOMER_TRANSACT_ID (decimal)
- Spalte: SUPPLIER_TRANSACT_ID (decimal)
- Spalte: MATCH_AMOUNT (decimal)
- Spalte: ORIG_CUSTOMER_TRANSACT_ID (decimal)
- Spalte: ORIG_SUPPLIER_TRANSACT_ID (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: ORDER_SERVICE_SCHEMES
- Spalte: ORDER_NUMBER (decimal)
- Spalte: SCHEME_NO (decimal)
- Spalte: GUIDING_TEXT_NO (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: FIELD_NO (decimal)
- Spalte: GUIDING_TEXT (varchar)
- Spalte: FIELD_A (char)
- Spalte: FIELD_B (char)
- Spalte: FIELD_C (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: SERVICE_2000_FILE
- Spalte: REC_TYPE (char)
- Spalte: MAKE_CD (char)
- Spalte: DEPARTMENT (char)
- Spalte: YEAR (char)
- Spalte: WEEK_NO_MONTH (char)
- Spalte: WEEK_NO (char)
- Spalte: WEEK_DAY_NO (char)
- Spalte: EXTRACTED_DATE (datetime)
- Spalte: STATE_CODE (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: TRANSACT_TIME (decimal)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: DEPARTMENT_TYPE (char)
- Spalte: DAYS_OPEN (decimal)
- Spalte: O_OPENED (decimal)
- Spalte: O_PRE_ARRANGED (decimal)
- Spalte: O_PRE_ARRANGED_PCT (decimal)
- Spalte: PERS_RECEIPT (decimal)
- Spalte: PERS_RECEIPT_PCT (decimal)
- Spalte: INSPECT_DONE (decimal)
- Spalte: INSPECT_DONE_PCT (decimal)
- Spalte: FIXED_KIT_WRK (decimal)
- Spalte: FIXED_KIT_WRK_PCT (decimal)
- Spalte: ADDITIONAL_WRK (decimal)
- Spalte: ADDITIONAL_WRK_PCT (decimal)
- Spalte: FINISH_APPTIME (decimal)
- Spalte: FINISH_APPTIME_PCT (decimal)
- Spalte: OVER_AGAIN_WRK (decimal)
- Spalte: OVER_AGAIN_WRK_PCT (decimal)
- Spalte: O_MECHANIC_WRK (decimal)
- Spalte: O_PRE_PICKED (decimal)
- Spalte: O_PRE_PICKED_PCT (decimal)
- Spalte: O_PRE_PICKED_PCT_2 (decimal)
- Spalte: MECH_SKILLED_DAYS (decimal)
- Spalte: WRK_CAPACITY_EFF (decimal)
- Spalte: MECH_TRAINEE_DAYS (decimal)
- Spalte: USED_HOURS_INV (decimal)
- Spalte: INVOICED_HOURS (decimal)
- Spalte: O_INVOICED (decimal)
- Spalte: INV_KIT_WRK_HOURS (decimal)
- Spalte: WORKSHOP_USE_PCT (decimal)
- Spalte: PRODUCTIVITY_PCT (decimal)
- Spalte: WRK_EFFICIENCY_PCT (decimal)
- Spalte: INV_WRK_AMT (decimal)
- Spalte: INV_PART_AMT (decimal)
- Spalte: INV_MISC_AMT (decimal)
- Spalte: TOTAL_INV_PART_WRK (decimal)
- Spalte: TOTAL_INV (decimal)
- Spalte: AVR_WRK_PART_AMT (decimal)
- Spalte: AVR_WRK_AMT (decimal)
- Spalte: AVR_PART_AMT (decimal)
- Spalte: AVR_WRK_PCT (decimal)
- Spalte: AVR_PART_PCT (decimal)
- Spalte: TURNOVER_FACTOR (decimal)
- Spalte: ORDER_ANALYSE (decimal)
- Spalte: MECH_DAYS_IN_WRK (decimal)
- Spalte: AVR_INV_PER_MECH (decimal)
- Spalte: AVR_INV_SOLD_HOURS (decimal)
- Spalte: AVR_WRK_SOLD_HOURS (decimal)
- Spalte: AVR_WRK_LOST_HOURS (decimal)
- Spalte: KIT_EFFICIENCY_PCT (decimal)
- Spalte: OPEN_ORDERS (decimal)
- Spalte: OPEN_PART_WRK_AMT (decimal)
- Spalte: OPEN_MISC_AMT (decimal)
- Spalte: WHOLESALE_AMT (decimal)
- Spalte: DETAILSALE_AMT (decimal)
- Spalte: PART_WORKSHOP_AMT (decimal)
- Spalte: TOTAL_PART_AMT (decimal)
- Spalte: O_QUALITY_INSPECT (decimal)
- Spalte: INVOICE_EXPLAINED (decimal)
- Spalte: O_PRE_ORDERED (decimal)
- Spalte: INV_EXT_WRK_AMT (decimal)
- Spalte: INV_CL_WRK_AMT (decimal)
- Spalte: INV_INT_WRK_AMT (decimal)
- Spalte: INV_EXT_PART_AMT (decimal)
- Spalte: INV_CL_PART_AMT (decimal)
- Spalte: INV_INT_PART_AMT (decimal)
- Spalte: INV_EXT_USED_HOURS (decimal)
- Spalte: INV_CL_USED_HOURS (decimal)
- Spalte: INT_USED_HOURS (decimal)
- Spalte: HOURS_ALL (decimal)
- Spalte: WRK_HOURS (decimal)
- Spalte: NOT_INV_HOURS (decimal)
- Spalte: TURNOVER_FACTOR_2 (decimal)
- Spalte: AVR_RATE_INV (decimal)
- Spalte: AVR_RATE_CAPACITY (decimal)
- Spalte: AVR_RATE_WRK (decimal)
- Spalte: AVR_RATE_ALL (decimal)
- Spalte: AVR_TURNOVER_MECH (decimal)
- Spalte: ADDITIONAL_P_AMT (decimal)
- Spalte: ADDITIONAL_W_AMT (decimal)
- Spalte: ADDITIONAL_M_AMT (decimal)
- Spalte: WRK_CAPACITY_EFF_INT (decimal)
- Spalte: WRK_CAPACITY_EFF_EXACT (decimal)
- Spalte: USED_HOURS_INV_INT (decimal)
- Spalte: USED_HOURS_INV_EXACT (decimal)
- Spalte: INVOICED_HOURS_INT (decimal)
- Spalte: INV_KIT_WRK_HOURS_INT (decimal)
- Spalte: INV_EXT_USED_HOURS_INT (decimal)
- Spalte: INV_EXT_USED_HOURS_EXACT (decimal)
- Spalte: INV_CL_USED_HOURS_INT (decimal)
- Spalte: INV_CL_USED_HOURS_EXACT (decimal)
- Spalte: INT_USED_HOURS_INT (decimal)
- Spalte: INT_USED_HOURS_EXACT (decimal)
- Spalte: HOURS_ALL_INT (decimal)
- Spalte: HOURS_ALL_EXACT (decimal)
- Spalte: WRK_HOURS_INT (decimal)
- Spalte: WRK_HOURS_EXACT (decimal)
- Spalte: NOT_INV_HOURS_INT (decimal)
- Spalte: NOT_INV_HOURS_EXACT (decimal)
- Spalte: MAKE_TIME_UNIT (char)
- Spalte: AVR_INV_SOLD_HOURS_INT (decimal)
- Spalte: AVR_WRK_SOLD_HOURS_INT (decimal)
- Spalte: AVR_WRK_LOST_HOURS_INT (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: TIME_CONTROL_END
- Spalte: PERSON_GROUP (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: WORK_TRANS_DATE (datetime)
- Spalte: WORK_START_TIME (decimal)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: WORK_STATE_CODE (char)
- Spalte: HANDLER (char)
- Spalte: WORK_ACT_CODE (char)
- Spalte: WORK_ACT_TEXT (varchar)
- Spalte: WORK_END_DATE (datetime)
- Spalte: WORK_END_TIME (decimal)
- Spalte: REPAIR_CODE (varchar)
- Spalte: REPAIR_NAME (varchar)
- Spalte: WORK_ORDER_TIME (decimal)
- Spalte: WORK_USED_TIME (decimal)
- Spalte: WORK_INVOICED_TIME (decimal)
- Spalte: WORK_ESTIM_TIME (decimal)
- Spalte: WORK_PRINT_INVOICE (char)
- Spalte: WORK_SALESPRICE (decimal)
- Spalte: DAYTIME_START_1 (decimal)
- Spalte: DAYTIME_END_1 (decimal)
- Spalte: DAYTIME_START_2 (decimal)
- Spalte: DAYTIME_END_2 (decimal)
- Spalte: DAYTIME_START_3 (decimal)
- Spalte: DAYTIME_END_3 (decimal)
- Spalte: DAYTIME_START_4 (decimal)
- Spalte: DAYTIME_END_4 (decimal)
- Spalte: DAYTIME_START_5 (decimal)
- Spalte: DAYTIME_END_5 (decimal)
- Spalte: EXTRACTED (char)
- Spalte: REDUCE_TIME (decimal)
- Spalte: PROGRAM (char)
- Spalte: CLOCK_IN_PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: TIME_CONTROL_OPEN
- Spalte: PERSON_GROUP (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: WORK_TRANS_DATE (datetime)
- Spalte: WORK_START_TIME (decimal)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: WORK_STATE_CODE (char)
- Spalte: HANDLER (char)
- Spalte: WORK_ACT_CODE (char)
- Spalte: WORK_ACT_TEXT (varchar)
- Spalte: WORK_END_DATE (datetime)
- Spalte: WORK_END_TIME (decimal)
- Spalte: REPAIR_CODE (varchar)
- Spalte: REPAIR_NAME (varchar)
- Spalte: WORK_ORDER_TIME (decimal)
- Spalte: WORK_USED_TIME (decimal)
- Spalte: WORK_INVOICED_TIME (decimal)
- Spalte: WORK_ESTIM_TIME (decimal)
- Spalte: WORK_PRINT_INVOICE (char)
- Spalte: WORK_SALESPRICE (decimal)
- Spalte: DAYTIME_START_1 (decimal)
- Spalte: DAYTIME_END_1 (decimal)
- Spalte: DAYTIME_START_2 (decimal)
- Spalte: DAYTIME_END_2 (decimal)
- Spalte: DAYTIME_START_3 (decimal)
- Spalte: DAYTIME_END_3 (decimal)
- Spalte: DAYTIME_START_4 (decimal)
- Spalte: DAYTIME_END_4 (decimal)
- Spalte: DAYTIME_START_5 (decimal)
- Spalte: DAYTIME_END_5 (decimal)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: TIME_CONTROL_TRANS
- Spalte: PERSON_GROUP (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: WORK_TRANS_DATE (datetime)
- Spalte: WORK_START_TIME (decimal)
- Spalte: WORK_END_TIME (decimal)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: REPAIR_CODE (varchar)
- Spalte: WORK_ACT_CODE (char)
- Spalte: TMCS_TRANS_TYPE (char)
- Spalte: HANDLER (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: PROGRAM (char)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: timestamp (binary)
- Spalte: CONV_FLAG (char)
- Spalte: CLIENT_DB (varchar)
- Table: WORK_LINE_STATUS
- Spalte: WORK_STATUS (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: WORK_STATUS_TEXT (varchar)
- Spalte: WORK_FINISHED_MARK (tinyint)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: WORK_UNITS
- Spalte: TIME_UNIT (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: UNIT_DESC (varchar)
- Spalte: AW_TYPE (char)
- Spalte: AW_SEGMENTS (decimal)
- Spalte: ROUNDING (char)
- Spalte: SUM_TIME_BEFORE_AW_CALC (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: WORKSHOP_ORDER_SPLIT
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: WORKSHOP_TEAM (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: START_DATE (datetime)
- Spalte: END_DATE (datetime)
- Spalte: EST_TIME (decimal)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: WORKSHOP_PLANNING
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: COLOR_NOT_STARTED (int)
- Spalte: COLOR_NOT_STARTED_WAIT (int)
- Spalte: COLOR_JOBCARD_PRINTED (int)
- Spalte: COLOR_IN_WORK (int)
- Spalte: COLOR_IN_WORK_WAIT (int)
- Spalte: COLOR_SUSPENDED (int)
- Spalte: COLOR_FINISHED (int)
- Spalte: COLOR_FINISHED_WAIT (int)
- Spalte: COLOR_INVOICED (int)
- Spalte: COLOR_QUALITY_INSPECTED (int)
- Spalte: COLOR_EMPLOYEE_CLOCKED_IN (int)
- Spalte: COLOR_EMPLOYEE_NOT_PRESENT (int)
- Spalte: COLOR_TEAM_CAPACITY_USED (int)
- Spalte: COLOR_TEAM_CAPACITY_FREE (int)
- Spalte: COLOR_OFF_TIME (int)
- Spalte: COLOR_WORK_TIME (int)
- Spalte: COLOR_BREAK_TIME (int)
- Spalte: COLOR_APP_FORE (int)
- Spalte: COLOR_APP_BACK (int)
- Spalte: COLOR_APP_FORE_WAIT (int)
- Spalte: COLOR_APP_BACK_WAIT (int)
- Spalte: COLOR_ORDER_CREATED_FORE (int)
- Spalte: COLOR_ORDER_CREATED_BACK (int)
- Spalte: COLOR_FREE_CAPACITY (int)
- Spalte: COLOR_USED_CAPACITY (int)
- Spalte: COLOR_OVERBOOKED_CAPACITY (int)
- Spalte: TIMER_REFRESH (decimal)
- Spalte: ONLY_SHOW_TEAMS (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: WORKSHOP_TEAMS
- Spalte: WORKSHOP_TEAM (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: DESCRIPTION (varchar)
- Spalte: WORK_LEADER_GROUP (char)
- Spalte: CAPACITY_RULE (char)
- Spalte: CAPACITY (decimal)
- Spalte: CONV_FLAG (char)
- 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: SERVICE_SCHEME_HEADER
- Spalte: SCHEME_NO (decimal)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: MAKE_CD (char)
- Spalte: DESCRIPTION (varchar)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: SERVICE_SCHEME_MENUS
- Spalte: SERVICE_SCHEMES_ID (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: MENU_GROUP (char)
- Spalte: MENU_NUMBER (varchar)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: SERVICE_SCHEMES
- Spalte: SERVICE_SCHEME_HEADER_ID (decimal)
- Spalte: GUIDING_TEXT_NO (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: FIELD_NO (decimal)
- Spalte: GUIDING_TEXT (varchar)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: PERSON_INFO
- Spalte: PERSON_GROUP (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: NAME (varchar)
- Spalte: PERS_DEPARTMENT (char)
- Spalte: PERS_STATE_CODE (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PERS_PERSON_CODE (varchar)
- Spalte: PERS_STREET_ADDR (varchar)
- Spalte: PERS_MAIL_ADDR (varchar)
- Spalte: PERS_ZIPCODE (char)
- Spalte: PERS_PHONE (varchar)
- Spalte: PERS_SEX (char)
- Spalte: PERS_TASK (varchar)
- Spalte: PERS_BIRTH_PLACE (varchar)
- Spalte: PERS_BANK (varchar)
- Spalte: PERS_ACCT_NR (varchar)
- Spalte: PERS_JOB_START (datetime)
- Spalte: PERS_JOB_END (datetime)
- Spalte: PERS_MECHNO_GROUP (char)
- Spalte: PERS_UNION_START (datetime)
- Spalte: PERS_MM_HOURS (decimal)
- Spalte: PERS_ACT_CODE (char)
- Spalte: PERS_PERSONAL_NO (decimal)
- Spalte: PERS_OVERWORK (char)
- Spalte: PERS_EFF_AW_DIV (decimal)
- Spalte: OVERWORK_TIME (decimal)
- Spalte: ADDR_3 (varchar)
- Spalte: COUNTY (varchar)
- Spalte: DEF_DAY_ACTIVITY (char)
- Spalte: DEF_JOB_ORDER_ACTIVITY (char)
- Spalte: DEF_JOB_ACTIVITY (char)
- Spalte: PERSON_NUMBER_NUM (decimal)
- Spalte: WORKSHOP_TEAM (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: REPAIR_MNEMONICS
- Spalte: REPAIR_CODE (char)
- Spalte: LINE_TYPE_GM (char)
- Spalte: LINE_NUMBER_GM (decimal)
- Spalte: STATE_CODE_REPAIR (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DESCRIPTION_1 (varchar)
- Spalte: DESCRIPTION_2 (varchar)
- Spalte: APPROVAL_CODE_GM (char)
- Spalte: MNEMONICS_CODE_1 (char)
- Spalte: MNEMONICS_NAME_1 (char)
- Spalte: MNEMONICS_CODE_2 (char)
- Spalte: MNEMONICS_NAME_2 (char)
- Spalte: MNEMONICS_CODE_3 (char)
- Spalte: MNEMONICS_NAME_3 (char)
- Spalte: MNEMONICS_CODE_4 (char)
- Spalte: MNEMONICS_NAME_4 (char)
- Spalte: MNEMONICS_CODE_5 (char)
- Spalte: MNEMONICS_NAME_5 (char)
- Spalte: CLAIM_HOURS (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: MONTH_WORK_TIME_X
- Spalte: WORK_LEADER_GROUP (char)
- Spalte: PERSON_NUMBER (char)
- Spalte: YEAR_WORK_TIME (decimal)
- Spalte: MONTH_WORK_TIME (decimal)
- Spalte: STATE_CODE_PLAN (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: DAY_TIME_TABLE_1 (varchar)
- Spalte: DAY_TIME_TABLE_2 (varchar)
- Spalte: DAY_TIME_TABLE_3 (varchar)
- Spalte: DAY_TIME_TABLE_4 (varchar)
- Spalte: DAY_TIME_TABLE_5 (varchar)
- Spalte: DAY_TIME_TABLE_6 (varchar)
- Spalte: DAY_TIME_TABLE_7 (varchar)
- Spalte: DAY_TIME_TABLE_8 (varchar)
- Spalte: DAY_TIME_TABLE_9 (varchar)
- Spalte: DAY_TIME_TABLE_10 (varchar)
- Spalte: DAY_TIME_TABLE_11 (varchar)
- Spalte: DAY_TIME_TABLE_12 (varchar)
- Spalte: DAY_TIME_TABLE_13 (varchar)
- Spalte: DAY_TIME_TABLE_14 (varchar)
- Spalte: DAY_TIME_TABLE_15 (varchar)
- Spalte: DAY_TIME_TABLE_16 (varchar)
- Spalte: DAY_TIME_TABLE_17 (varchar)
- Spalte: DAY_TIME_TABLE_18 (varchar)
- Spalte: DAY_TIME_TABLE_19 (varchar)
- Spalte: DAY_TIME_TABLE_20 (varchar)
- Spalte: DAY_TIME_TABLE_21 (varchar)
- Spalte: DAY_TIME_TABLE_22 (varchar)
- Spalte: DAY_TIME_TABLE_23 (varchar)
- Spalte: DAY_TIME_TABLE_24 (varchar)
- Spalte: DAY_TIME_TABLE_25 (varchar)
- Spalte: DAY_TIME_TABLE_26 (varchar)
- Spalte: DAY_TIME_TABLE_27 (varchar)
- Spalte: DAY_TIME_TABLE_28 (varchar)
- Spalte: DAY_TIME_TABLE_29 (varchar)
- Spalte: DAY_TIME_TABLE_30 (varchar)
- Spalte: DAY_TIME_TABLE_31 (varchar)
- Spalte: WEEK_NUMBER_1 (decimal)
- Spalte: CALENDAR_TYPE_1 (decimal)
- Spalte: WEEK_NUMBER_2 (decimal)
- Spalte: CALENDAR_TYPE_2 (decimal)
- Spalte: WEEK_NUMBER_3 (decimal)
- Spalte: CALENDAR_TYPE_3 (decimal)
- Spalte: WEEK_NUMBER_4 (decimal)
- Spalte: CALENDAR_TYPE_4 (decimal)
- Spalte: WEEK_NUMBER_5 (decimal)
- Spalte: CALENDAR_TYPE_5 (decimal)
- Spalte: WEEK_NUMBER_6 (decimal)
- Spalte: CALENDAR_TYPE_6 (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: FHG_DETAIL
- Spalte: DEALER_NO_IMP (char)
- Spalte: FHG_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: LINE_TYPE (char)
- Spalte: PROD_CODE (varchar)
- Spalte: MAKE_CD (char)
- Spalte: REPAIR_CODE (char)
- Spalte: PROD_CODE_MISC (varchar)
- Spalte: QUANTITY (decimal)
- Spalte: HOURS (decimal)
- Spalte: QUANTITY_MISC (decimal)
- Spalte: DEAL_CLAIM_SALES_PRICE (decimal)
- Spalte: DEAL_CLAIM_PRICE (decimal)
- Spalte: DEAL_CREDIT_SALES_PRICE (decimal)
- Spalte: DEAL_CREDIT_PRICE (decimal)
- Spalte: DETAIL_TEXT (varchar)
- Spalte: TEXT_200 (varchar)
- Spalte: FLAT_SEARCH_2 (char)
- Spalte: FLAT_SEARCH_3 (char)
- Spalte: FLAT_SEARCH_4 (char)
- Spalte: FLAT_SEARCH_5 (char)
- Spalte: FLAT_SEARCH_6 (char)
- Spalte: FLAT_SEARCH_7 (char)
- Spalte: FLAT_SEARCH_8 (char)
- Spalte: FLAT_SEARCH_9 (char)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: IMP_CLAIM_PRICE (decimal)
- Spalte: IMP_CLAIM_SALES_PRICE (decimal)
- Table: FHG_HEADER
- Spalte: DEALER_NO_IMP (char)
- Spalte: FHG_NUMBER (decimal)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: CLAIM_NUMBER (decimal)
- Spalte: CHASSIS_NUMBER (varchar)
- Spalte: UNIT_NUMBER (char)
- Spalte: BASIS_NUMBER (char)
- Spalte: REGISTER_NUMBER (char)
- Spalte: CLAIM_REPORT_NO (decimal)
- Spalte: FHG_STATUS (char)
- Spalte: BREAK_DOWN (char)
- Spalte: RETAIL_CUSTOMER (char)
- Spalte: RECORD_TRANS (char)
- Spalte: FHG_CREAT_DATE (datetime)
- Spalte: FHG_VALID_TO_DATE (datetime)
- Spalte: FHG_DETERM_DATE (datetime)
- Spalte: TROUBLE_CODE (char)
- Spalte: SYMPTOM_CODE (char)
- Spalte: PNC_CODE (varchar)
- Spalte: ORDER_DATE (datetime)
- Spalte: CL_TYPE (char)
- Spalte: MILEAGE_IMP (decimal)
- Spalte: PAINT_CORROSION (char)
- Spalte: FHG_DETERM_CODE (char)
- Spalte: DETERM_INITIALS1 (char)
- Spalte: DETERM_INITIALS2 (char)
- Spalte: DETERMINE_TEXT_1 (varchar)
- Spalte: DETERMINE_TEXT_2 (varchar)
- Spalte: PAY_PERCENT_FOR_WORK (decimal)
- Spalte: PAY_PERCENT_PART (decimal)
- Spalte: PAY_PERCENT_WORK (decimal)
- Spalte: NUMB_ATTACH_FILES (decimal)
- Spalte: TRANSACT_DATE (datetime)
- Spalte: HANDLER (char)
- Spalte: PROGRAM (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: UNIQUE_IDENT (decimal)
- Table: ACTIVITY
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: ACTIVITY_CATEGORY (tinyint)
- Spalte: HANDLER (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: PROGRAM (char)
- Spalte: TRANSACT_DATE_LONG (datetime)
- Spalte: ACTIVITY_CODE (char)
- Spalte: ACTIVITY_DESCRIPTION (varchar)
- Spalte: CREATE_ORDER_LINE (tinyint)
- Spalte: REPNO_PREFIX (char)
- Spalte: PRESENT (tinyint)
- Spalte: SICKNESS (tinyint)
- Spalte: ONLY_USED_BY_LEADERS (tinyint)
- Spalte: IDLE_ORDER_ACTIVITY (tinyint)
- Spalte: ACTIVITY_OBSOLETE (tinyint)
- Spalte: USED_TIME_PAY_ACTIVITY (tinyint)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: ABSENCE_CODE (char)
- Spalte: EXTRACTION_MODE (decimal)
- Spalte: CLIENT_DB (varchar)
- Table: PUNCH
- Spalte: UNIQUE_IDENT (decimal)
- Spalte: ACTIVITY_CODE (char)
- Spalte: PROFILE_CODE (varchar)
- Spalte: HANDLER (char)
- Spalte: FUNCTION_CODE (char)
- Spalte: PROGRAM (char)
- Spalte: TRANSACT_DATE_LONG (datetime)
- Spalte: START_PUNCH_FUNCTION (char)
- Spalte: START_PUNCH_PROGRAM (char)
- Spalte: END_PUNCH_FUNCTION (char)
- Spalte: END_PUNCH_PROGRAM (char)
- Spalte: DONE_FOR_DEPARTMENT (char)
- Spalte: DONE_FOR_WORK_LEADER (char)
- Spalte: ENDED_PUNCH (tinyint)
- Spalte: ORDER_NUMBER (decimal)
- Spalte: LINE_NUMBER (decimal)
- Spalte: START_DATE_TIME (datetime)
- Spalte: END_DATE_TIME (datetime)
- Spalte: TMCS_IDLE_PUNCH (tinyint)
- Spalte: DURATION_INT (decimal)
- Spalte: USED_TIME_INT (decimal)
- Spalte: WAGE_EXTRACTED (tinyint)
- Spalte: PUNCH_REMARK_CODE (tinyint)
- Spalte: REMARK_ACCEPTED (tinyint)
- Spalte: PUNCH_PERIOD_START_ID (decimal)
- Spalte: CONV_FLAG (char)
- Spalte: timestamp (binary)
- Spalte: CLIENT_DB (varchar)
- Katalogordner
- Ordner: Order Header
- Spalte: Order Number ([O21.OPTIMA.import.ORDER_HEADER.ORDER_NUMBER], Zahl)
- Spalte: Register Number ([O21.OPTIMA.import.ORDER_HEADER.REGISTER_NUMBER], Zeichenkette)
- Spalte: Status ([O21.OPTIMA.import.ORDER_HEADER.STATUS], Zeichenkette)
- Spalte: State Key Date ([O21.OPTIMA.import.ORDER_HEADER.STATE_KEY_DATE], Datum/Uhrzeit)
- Spalte: Debit Account ([O21.OPTIMA.import.ORDER_HEADER.DEBIT_ACCOUNT], Zeichenkette)
- Spalte: Invoice Number ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_NUMBER], Zahl)
- Spalte: Workshop Model ([O21.OPTIMA.import.ORDER_HEADER.WORKSHOP_MODEL], Zeichenkette)
- Spalte: State Code ([O21.OPTIMA.import.ORDER_HEADER.STATE_CODE], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.ORDER_HEADER.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.ORDER_HEADER.HANDLER], Zeichenkette)
- Spalte: Delivery Account ([O21.OPTIMA.import.ORDER_HEADER.DELIVERY_ACCOUNT], Zeichenkette)
- Spalte: Department ([O21.OPTIMA.import.ORDER_HEADER.DEPARTMENT], Zeichenkette)
- Spalte: Debet Department ([O21.OPTIMA.import.ORDER_HEADER.DEBET_DEPARTMENT], Zeichenkette)
- Spalte: Salesman ([O21.OPTIMA.import.ORDER_HEADER.SALESMAN], Zeichenkette)
- Spalte: Debit Perm ([O21.OPTIMA.import.ORDER_HEADER.DEBIT_PERM], Zeichenkette)
- Spalte: Order Date ([O21.OPTIMA.import.ORDER_HEADER.ORDER_DATE], Datum/Uhrzeit)
- Spalte: Delivery Date ([O21.OPTIMA.import.ORDER_HEADER.DELIVERY_DATE], Datum/Uhrzeit)
- Spalte: Invoice Date ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_DATE], Datum/Uhrzeit)
- Spalte: Tax Code ([O21.OPTIMA.import.ORDER_HEADER.TAX_CODE], Zeichenkette)
- Spalte: Tax Perc ([O21.OPTIMA.import.ORDER_HEADER.TAX_PERC], Zahl)
- Spalte: Pmt Term ([O21.OPTIMA.import.ORDER_HEADER.PMT_TERM], Zeichenkette)
- Spalte: Delivery Way Code ([O21.OPTIMA.import.ORDER_HEADER.DELIVERY_WAY_CODE], Zeichenkette)
- Spalte: Delivery Term ([O21.OPTIMA.import.ORDER_HEADER.DELIVERY_TERM], Zeichenkette)
- Spalte: Reference ([O21.OPTIMA.import.ORDER_HEADER.REFERENCE], Zeichenkette)
- Spalte: Note ([O21.OPTIMA.import.ORDER_HEADER.NOTE], Zeichenkette)
- Spalte: Spec Terms ([O21.OPTIMA.import.ORDER_HEADER.SPEC_TERMS], Zeichenkette)
- Spalte: Next Line Number ([O21.OPTIMA.import.ORDER_HEADER.NEXT_LINE_NUMBER], Zahl)
- Spalte: Duedate 1 ([O21.OPTIMA.import.ORDER_HEADER.DUEDATE_1], Datum/Uhrzeit)
- Spalte: Payment Text ([O21.OPTIMA.import.ORDER_HEADER.PAYMENT_TEXT], Zeichenkette)
- Spalte: Costs ([O21.OPTIMA.import.ORDER_HEADER.COSTS], Zahl)
- Spalte: Purch Tax ([O21.OPTIMA.import.ORDER_HEADER.PURCH_TAX], Zahl)
- Spalte: Orders Grossvalue ([O21.OPTIMA.import.ORDER_HEADER.ORDERS_GROSSVALUE], Zahl)
- Spalte: Tax Share ([O21.OPTIMA.import.ORDER_HEADER.TAX_SHARE], Zahl)
- Spalte: Discount Amount ([O21.OPTIMA.import.ORDER_HEADER.DISCOUNT_AMOUNT], Zahl)
- Spalte: Price Code ([O21.OPTIMA.import.ORDER_HEADER.PRICE_CODE], Zeichenkette)
- Spalte: Misc Adds ([O21.OPTIMA.import.ORDER_HEADER.MISC_ADDS], Zahl)
- Spalte: Stock ([O21.OPTIMA.import.ORDER_HEADER.STOCK], Zeichenkette)
- Spalte: Place Code ([O21.OPTIMA.import.ORDER_HEADER.PLACE_CODE], Zeichenkette)
- Spalte: Internal Code ([O21.OPTIMA.import.ORDER_HEADER.INTERNAL_CODE], Zeichenkette)
- Spalte: Customer Group ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_GROUP], Zeichenkette)
- Spalte: Small Accessories ([O21.OPTIMA.import.ORDER_HEADER.SMALL_ACCESSORIES], Zeichenkette)
- Spalte: Invoice Copy Code ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_COPY_CODE], Zeichenkette)
- Spalte: Basis Number ([O21.OPTIMA.import.ORDER_HEADER.BASIS_NUMBER], Zeichenkette)
- Spalte: Mileage ([O21.OPTIMA.import.ORDER_HEADER.MILEAGE], Zahl)
- Spalte: Prev Status ([O21.OPTIMA.import.ORDER_HEADER.PREV_STATUS], Zeichenkette)
- Spalte: Text Code 1 ([O21.OPTIMA.import.ORDER_HEADER.TEXT_CODE_1], Zeichenkette)
- Spalte: Text Code 2 ([O21.OPTIMA.import.ORDER_HEADER.TEXT_CODE_2], Zeichenkette)
- Spalte: Text Code 3 ([O21.OPTIMA.import.ORDER_HEADER.TEXT_CODE_3], Zeichenkette)
- Spalte: Sales Class Number ([O21.OPTIMA.import.ORDER_HEADER.SALES_CLASS_NUMBER], Zeichenkette)
- Spalte: Invoice Disc Perc ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_DISC_PERC], Zahl)
- Spalte: Invoice Rounded ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_ROUNDED], Zahl)
- Spalte: Invoice Charge ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_CHARGE], Zahl)
- Spalte: Sales Tax Free ([O21.OPTIMA.import.ORDER_HEADER.SALES_TAX_FREE], Zahl)
- Spalte: Title ([O21.OPTIMA.import.ORDER_HEADER.TITLE], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.ORDER_HEADER.NAME], Zeichenkette)
- Spalte: Street Addr ([O21.OPTIMA.import.ORDER_HEADER.STREET_ADDR], Zeichenkette)
- Spalte: Addr 2 ([O21.OPTIMA.import.ORDER_HEADER.ADDR_2], Zeichenkette)
- Spalte: Zipcode ([O21.OPTIMA.import.ORDER_HEADER.ZIPCODE], Zeichenkette)
- Spalte: Mail Addr ([O21.OPTIMA.import.ORDER_HEADER.MAIL_ADDR], Zeichenkette)
- Spalte: Discount Limit ([O21.OPTIMA.import.ORDER_HEADER.DISCOUNT_LIMIT], Zeichenkette)
- Spalte: Reference Number ([O21.OPTIMA.import.ORDER_HEADER.REFERENCE_NUMBER], Zahl)
- Spalte: Expected Order Tim ([O21.OPTIMA.import.ORDER_HEADER.EXPECTED_ORDER_TIM], Zahl)
- Spalte: Bol Tax Share ([O21.OPTIMA.import.ORDER_HEADER.BOL_TAX_SHARE], Zahl)
- Spalte: Model Text ([O21.OPTIMA.import.ORDER_HEADER.MODEL_TEXT], Zeichenkette)
- Spalte: Effect Code ([O21.OPTIMA.import.ORDER_HEADER.EFFECT_CODE], Zeichenkette)
- Spalte: Invoice Code ([O21.OPTIMA.import.ORDER_HEADER.INVOICE_CODE], Zeichenkette)
- Spalte: Small Inv Charge ([O21.OPTIMA.import.ORDER_HEADER.SMALL_INV_CHARGE], Zeichenkette)
- Spalte: Credit Order ([O21.OPTIMA.import.ORDER_HEADER.CREDIT_ORDER], Zeichenkette)
- Spalte: On Microfiche ([O21.OPTIMA.import.ORDER_HEADER.ON_MICROFICHE], Zeichenkette)
- Spalte: Workshop Pricecode ([O21.OPTIMA.import.ORDER_HEADER.WORKSHOP_PRICECODE], Zeichenkette)
- Spalte: Split Counter ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_COUNTER], Zahl)
- Spalte: Back Order Perm ([O21.OPTIMA.import.ORDER_HEADER.BACK_ORDER_PERM], Zeichenkette)
- Spalte: Reduction Code ([O21.OPTIMA.import.ORDER_HEADER.REDUCTION_CODE], Zeichenkette)
- Spalte: Back Order Release ([O21.OPTIMA.import.ORDER_HEADER.BACK_ORDER_RELEASE], Zeichenkette)
- Spalte: Vat Table Work ([O21.OPTIMA.import.ORDER_HEADER.VAT_TABLE_WORK], Zeichenkette)
- Spalte: Vat Table Normal ([O21.OPTIMA.import.ORDER_HEADER.VAT_TABLE_NORMAL], Zeichenkette)
- Spalte: Small Mat Wust Cd ([O21.OPTIMA.import.ORDER_HEADER.SMALL_MAT_WUST_CD], Zeichenkette)
- Spalte: Small Mat Vat Tab ([O21.OPTIMA.import.ORDER_HEADER.SMALL_MAT_VAT_TAB], Zeichenkette)
- Spalte: Inv Charge Wust Cd ([O21.OPTIMA.import.ORDER_HEADER.INV_CHARGE_WUST_CD], Zeichenkette)
- Spalte: Inv Charge Vat Tab ([O21.OPTIMA.import.ORDER_HEADER.INV_CHARGE_VAT_TAB], Zeichenkette)
- Spalte: Quick End Status ([O21.OPTIMA.import.ORDER_HEADER.QUICK_END_STATUS], Zeichenkette)
- Spalte: Language Code ([O21.OPTIMA.import.ORDER_HEADER.LANGUAGE_CODE], Zeichenkette)
- Spalte: Arrival Time ([O21.OPTIMA.import.ORDER_HEADER.ARRIVAL_TIME], Zahl)
- Spalte: Arrival Date ([O21.OPTIMA.import.ORDER_HEADER.ARRIVAL_DATE], Datum/Uhrzeit)
- Spalte: End Date ([O21.OPTIMA.import.ORDER_HEADER.END_DATE], Datum/Uhrzeit)
- Spalte: End Time ([O21.OPTIMA.import.ORDER_HEADER.END_TIME], Zahl)
- Spalte: Priority ([O21.OPTIMA.import.ORDER_HEADER.PRIORITY], Zahl)
- Spalte: Mark Number ([O21.OPTIMA.import.ORDER_HEADER.MARK_NUMBER], Zeichenkette)
- Spalte: Job Number ([O21.OPTIMA.import.ORDER_HEADER.JOB_NUMBER], Zeichenkette)
- Spalte: Discount Perc Big ([O21.OPTIMA.import.ORDER_HEADER.DISCOUNT_PERC_BIG], Zahl)
- Spalte: Dispatch Fee Pct ([O21.OPTIMA.import.ORDER_HEADER.DISPATCH_FEE_PCT], Zahl)
- Spalte: Addr 3 ([O21.OPTIMA.import.ORDER_HEADER.ADDR_3], Zeichenkette)
- Spalte: County ([O21.OPTIMA.import.ORDER_HEADER.COUNTY], Zeichenkette)
- Spalte: Mileage Accepted ([O21.OPTIMA.import.ORDER_HEADER.MILEAGE_ACCEPTED], Zeichenkette)
- Spalte: Fac Model Code S ([O21.OPTIMA.import.ORDER_HEADER.FAC_MODEL_CODE_S], Zeichenkette)
- Spalte: Split Main Orderno ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_MAIN_ORDERNO], Zahl)
- Spalte: Split Sub1 Orderno ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_SUB1_ORDERNO], Zahl)
- Spalte: Split Sub2 Orderno ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_SUB2_ORDERNO], Zahl)
- Spalte: Split Type ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_TYPE], Zeichenkette)
- Spalte: Split Type 2 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_TYPE_2], Zeichenkette)
- Spalte: Split Reduc Main ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_REDUC_MAIN], Zeichenkette)
- Spalte: Split Pct Main ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_PCT_MAIN], Zahl)
- Spalte: Split Tot Am Main ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_TOT_AM_MAIN], Zahl)
- Spalte: Split Fix Main ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_FIX_MAIN], Zeichenkette)
- Spalte: Split Reduc Sub1 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_REDUC_SUB1], Zeichenkette)
- Spalte: Split Pct Sub1 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_PCT_SUB1], Zahl)
- Spalte: Split Tot Am Sub1 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_TOT_AM_SUB1], Zahl)
- Spalte: Split Fix Sub1 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_FIX_SUB1], Zeichenkette)
- Spalte: Split Reduc Sub2 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_REDUC_SUB2], Zeichenkette)
- Spalte: Split Pct Sub2 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_PCT_SUB2], Zahl)
- Spalte: Split Tot Am Sub2 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_TOT_AM_SUB2], Zahl)
- Spalte: Split Fix Sub2 ([O21.OPTIMA.import.ORDER_HEADER.SPLIT_FIX_SUB2], Zeichenkette)
- Spalte: Book No ([O21.OPTIMA.import.ORDER_HEADER.BOOK_NO], Zeichenkette)
- Spalte: Book No Flag ([O21.OPTIMA.import.ORDER_HEADER.BOOK_NO_FLAG], Zeichenkette)
- Spalte: Book No Cash Pmt ([O21.OPTIMA.import.ORDER_HEADER.BOOK_NO_CASH_PMT], Zeichenkette)
- Spalte: Reference Date ([O21.OPTIMA.import.ORDER_HEADER.REFERENCE_DATE], Datum/Uhrzeit)
- Spalte: Repair Card Done ([O21.OPTIMA.import.ORDER_HEADER.REPAIR_CARD_DONE], Zeichenkette)
- Spalte: Hourly Repair Rate ([O21.OPTIMA.import.ORDER_HEADER.HOURLY_REPAIR_RATE], Zahl)
- Spalte: Customer Id ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_ID], Zeichenkette)
- Spalte: Customer Stock ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_STOCK], Zeichenkette)
- Spalte: Line Reference ([O21.OPTIMA.import.ORDER_HEADER.LINE_REFERENCE], Zahl)
- Spalte: Campaign Type ([O21.OPTIMA.import.ORDER_HEADER.CAMPAIGN_TYPE], Zeichenkette)
- Spalte: Campaign Number ([O21.OPTIMA.import.ORDER_HEADER.CAMPAIGN_NUMBER], Zeichenkette)
- Spalte: Work Type Code ([O21.OPTIMA.import.ORDER_HEADER.WORK_TYPE_CODE], Zeichenkette)
- Spalte: External Reference ([O21.OPTIMA.import.ORDER_HEADER.EXTERNAL_REFERENCE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.ORDER_HEADER.MAKE_CD], Zeichenkette)
- Spalte: Personal Receipt ([O21.OPTIMA.import.ORDER_HEADER.PERSONAL_RECEIPT], Zeichenkette)
- Spalte: Inspection Done ([O21.OPTIMA.import.ORDER_HEADER.INSPECTION_DONE], Zeichenkette)
- Spalte: Additional Work ([O21.OPTIMA.import.ORDER_HEADER.ADDITIONAL_WORK], Zeichenkette)
- Spalte: Quality Inspected ([O21.OPTIMA.import.ORDER_HEADER.QUALITY_INSPECTED], Zeichenkette)
- Spalte: Ready In Due Time ([O21.OPTIMA.import.ORDER_HEADER.READY_IN_DUE_TIME], Zeichenkette)
- Spalte: Inv Explained ([O21.OPTIMA.import.ORDER_HEADER.INV_EXPLAINED], Zeichenkette)
- Spalte: Membership Number ([O21.OPTIMA.import.ORDER_HEADER.MEMBERSHIP_NUMBER], Zeichenkette)
- Spalte: Create Msc ([O21.OPTIMA.import.ORDER_HEADER.CREATE_MSC], Zeichenkette)
- Spalte: Year Model ([O21.OPTIMA.import.ORDER_HEADER.YEAR_MODEL], Zeichenkette)
- Spalte: Planned St Wk Time ([O21.OPTIMA.import.ORDER_HEADER.PLANNED_ST_WK_TIME], Zahl)
- Spalte: Tuv Insp ([O21.OPTIMA.import.ORDER_HEADER.TUV_INSP], Zeichenkette)
- Spalte: Campaign Yes No ([O21.OPTIMA.import.ORDER_HEADER.CAMPAIGN_YES_NO], Zeichenkette)
- Spalte: E Mail Invoice ([O21.OPTIMA.import.ORDER_HEADER.E_MAIL_INVOICE], Zeichenkette)
- Spalte: E Mail Dnote ([O21.OPTIMA.import.ORDER_HEADER.E_MAIL_DNOTE], Zeichenkette)
- Spalte: E Mail Oconf ([O21.OPTIMA.import.ORDER_HEADER.E_MAIL_OCONF], Zeichenkette)
- Spalte: Send Order Advice ([O21.OPTIMA.import.ORDER_HEADER.SEND_ORDER_ADVICE], Zeichenkette)
- Spalte: Transfer Make Cd ([O21.OPTIMA.import.ORDER_HEADER.TRANSFER_MAKE_CD], Zeichenkette)
- Spalte: Chassis Number ([O21.OPTIMA.import.ORDER_HEADER.CHASSIS_NUMBER], Zeichenkette)
- Spalte: Customer Waiting ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_WAITING], Zeichenkette)
- Spalte: Credit Note ([O21.OPTIMA.import.ORDER_HEADER.CREDIT_NOTE], Zeichenkette)
- Spalte: Dispatch Fee All Lines ([O21.OPTIMA.import.ORDER_HEADER.DISPATCH_FEE_ALL_LINES], Zeichenkette)
- Spalte: Vat Suspension ([O21.OPTIMA.import.ORDER_HEADER.VAT_SUSPENSION], Zeichenkette)
- Spalte: Customer Ean Number ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_EAN_NUMBER], Zahl)
- Spalte: Ean Department ([O21.OPTIMA.import.ORDER_HEADER.EAN_DEPARTMENT], Zeichenkette)
- Spalte: Ean Reference ([O21.OPTIMA.import.ORDER_HEADER.EAN_REFERENCE], Zeichenkette)
- Spalte: Ean Internal Acct ([O21.OPTIMA.import.ORDER_HEADER.EAN_INTERNAL_ACCT], Zeichenkette)
- Spalte: Workshop Team ([O21.OPTIMA.import.ORDER_HEADER.WORKSHOP_TEAM], Zeichenkette)
- Spalte: Commission Salesman ([O21.OPTIMA.import.ORDER_HEADER.COMMISSION_SALESMAN], Zeichenkette)
- Spalte: Courtesy Car Id ([O21.OPTIMA.import.ORDER_HEADER.COURTESY_CAR_ID], Zeichenkette)
- Spalte: Customer Arrived ([O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_ARRIVED], Zeichenkette)
- Spalte: Inspection Done By ([O21.OPTIMA.import.ORDER_HEADER.INSPECTION_DONE_BY], Zeichenkette)
- Spalte: Test Drive Done ([O21.OPTIMA.import.ORDER_HEADER.TEST_DRIVE_DONE], Zeichenkette)
- Spalte: Test Drive Done By ([O21.OPTIMA.import.ORDER_HEADER.TEST_DRIVE_DONE_BY], Zeichenkette)
- Spalte: Order Origin ([O21.OPTIMA.import.ORDER_HEADER.ORDER_ORIGIN], Zeichenkette)
- Spalte: Inspection With Customer ([O21.OPTIMA.import.ORDER_HEADER.INSPECTION_WITH_CUSTOMER], Zeichenkette)
- Spalte: Contract Number ([O21.OPTIMA.import.ORDER_HEADER.CONTRACT_NUMBER], Zeichenkette)
- Spalte: Ref Ident Inv Total ([O21.OPTIMA.import.ORDER_HEADER.REF_IDENT_INV_TOTAL], Zahl)
- Spalte: Ref Ident Sales Class ([O21.OPTIMA.import.ORDER_HEADER.REF_IDENT_SALES_CLASS], Zahl)
- Spalte: Use Parts Pre Picking ([O21.OPTIMA.import.ORDER_HEADER.USE_PARTS_PRE_PICKING], Zeichenkette)
- Spalte: Ldc Order ([O21.OPTIMA.import.ORDER_HEADER.LDC_ORDER], Zeichenkette)
- Spalte: Fhg Report ([O21.OPTIMA.import.ORDER_HEADER.FHG_REPORT], Zeichenkette)
- Spalte: Actual Inv Date Time ([O21.OPTIMA.import.ORDER_HEADER.ACTUAL_INV_DATE_TIME], Datum/Uhrzeit)
- Spalte: Conv Flag ([O21.OPTIMA.import.ORDER_HEADER.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ORDER_HEADER.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.ORDER_HEADER.UNIQUE_IDENT], Zahl)
- Ordner: Order Line
- Spalte: Order Number ([O21.OPTIMA.import.ORDER_LINE.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.ORDER_LINE.LINE_NUMBER], Zahl)
- Spalte: Key Prod Code ([O21.OPTIMA.import.ORDER_LINE.KEY_PROD_CODE], Zeichenkette)
- Spalte: Key Make Cd ([O21.OPTIMA.import.ORDER_LINE.KEY_MAKE_CD], Zeichenkette)
- Spalte: Delivery Date ([O21.OPTIMA.import.ORDER_LINE.DELIVERY_DATE], Datum/Uhrzeit)
- Spalte: Line Group Code ([O21.OPTIMA.import.ORDER_LINE.LINE_GROUP_CODE], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.ORDER_LINE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.ORDER_LINE.HANDLER], Zeichenkette)
- Spalte: State Code ([O21.OPTIMA.import.ORDER_LINE.STATE_CODE], Zeichenkette)
- Spalte: Person Code ([O21.OPTIMA.import.ORDER_LINE.PERSON_CODE], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.ORDER_LINE.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.ORDER_LINE.FUNCTION_CODE], Zeichenkette)
- Spalte: Order Linetype ([O21.OPTIMA.import.ORDER_LINE.ORDER_LINETYPE], Zeichenkette)
- Spalte: Order Linetype 2 ([O21.OPTIMA.import.ORDER_LINE.ORDER_LINETYPE_2], Zeichenkette)
- Spalte: Order Linetype 3 ([O21.OPTIMA.import.ORDER_LINE.ORDER_LINETYPE_3], Zeichenkette)
- Spalte: Resulting Line ([O21.OPTIMA.import.ORDER_LINE.RESULTING_LINE], Zahl)
- Spalte: Resulting Line 2 ([O21.OPTIMA.import.ORDER_LINE.RESULTING_LINE_2], Zahl)
- Spalte: Job Code ([O21.OPTIMA.import.ORDER_LINE.JOB_CODE], Zeichenkette)
- Spalte: Print Invoice ([O21.OPTIMA.import.ORDER_LINE.PRINT_INVOICE], Zeichenkette)
- Spalte: Reduction Code ([O21.OPTIMA.import.ORDER_LINE.REDUCTION_CODE], Zeichenkette)
- Spalte: Reduction Amount ([O21.OPTIMA.import.ORDER_LINE.REDUCTION_AMOUNT], Zahl)
- Spalte: Reduction Code 2 ([O21.OPTIMA.import.ORDER_LINE.REDUCTION_CODE_2], Zeichenkette)
- Spalte: Reduction Pos ([O21.OPTIMA.import.ORDER_LINE.REDUCTION_POS], Zahl)
- Spalte: Split Code ([O21.OPTIMA.import.ORDER_LINE.SPLIT_CODE], Zeichenkette)
- Spalte: Split Code 2 ([O21.OPTIMA.import.ORDER_LINE.SPLIT_CODE_2], Zeichenkette)
- Spalte: Small Accessories ([O21.OPTIMA.import.ORDER_LINE.SMALL_ACCESSORIES], Zeichenkette)
- Spalte: Picked ([O21.OPTIMA.import.ORDER_LINE.PICKED], Zeichenkette)
- Spalte: Mechanic Code ([O21.OPTIMA.import.ORDER_LINE.MECHANIC_CODE], Zeichenkette)
- Spalte: Salesman ([O21.OPTIMA.import.ORDER_LINE.SALESMAN], Zeichenkette)
- Spalte: Discount Table ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT_TABLE], Zeichenkette)
- Spalte: Discount Code ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT_CODE], Zeichenkette)
- Spalte: Claim Code Ind ([O21.OPTIMA.import.ORDER_LINE.CLAIM_CODE_IND], Zeichenkette)
- Spalte: Claim Number ([O21.OPTIMA.import.ORDER_LINE.CLAIM_NUMBER], Zahl)
- Spalte: Kit Fixed Price Cd ([O21.OPTIMA.import.ORDER_LINE.KIT_FIXED_PRICE_CD], Zeichenkette)
- Spalte: R Delivery Date ([O21.OPTIMA.import.ORDER_LINE.R_DELIVERY_DATE], Datum/Uhrzeit)
- Spalte: Wust Code ([O21.OPTIMA.import.ORDER_LINE.WUST_CODE], Zeichenkette)
- Spalte: Status ([O21.OPTIMA.import.ORDER_LINE.STATUS], Zeichenkette)
- Spalte: Stock ([O21.OPTIMA.import.ORDER_LINE.STOCK], Zeichenkette)
- Spalte: Gross Discount ([O21.OPTIMA.import.ORDER_LINE.GROSS_DISCOUNT], Zeichenkette)
- Spalte: Statistic Code ([O21.OPTIMA.import.ORDER_LINE.STATISTIC_CODE], Zeichenkette)
- Spalte: Decimal Indicator ([O21.OPTIMA.import.ORDER_LINE.DECIMAL_INDICATOR], Zeichenkette)
- Spalte: Add Cost Code ([O21.OPTIMA.import.ORDER_LINE.ADD_COST_CODE], Zeichenkette)
- Spalte: Discount Perc ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT_PERC], Zahl)
- Spalte: Discount Perc 2 ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT_PERC_2], Zahl)
- Spalte: Discount ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT], Zahl)
- Spalte: Stdprice ([O21.OPTIMA.import.ORDER_LINE.STDPRICE], Zahl)
- Spalte: Lines Net Value ([O21.OPTIMA.import.ORDER_LINE.LINES_NET_VALUE], Zahl)
- Spalte: Tax Code 1 ([O21.OPTIMA.import.ORDER_LINE.TAX_CODE_1], Zeichenkette)
- Spalte: Vat Rate Code ([O21.OPTIMA.import.ORDER_LINE.VAT_RATE_CODE], Zeichenkette)
- Spalte: Tax C U ([O21.OPTIMA.import.ORDER_LINE.TAX_C_U], Zahl)
- Spalte: Tax Drawn ([O21.OPTIMA.import.ORDER_LINE.TAX_DRAWN], Zahl)
- Spalte: Line Misc Adds ([O21.OPTIMA.import.ORDER_LINE.LINE_MISC_ADDS], Zahl)
- Spalte: Line Misc Adds Per ([O21.OPTIMA.import.ORDER_LINE.LINE_MISC_ADDS_PER], Zahl)
- Spalte: Claim Trouble Cd ([O21.OPTIMA.import.ORDER_LINE.CLAIM_TROUBLE_CD], Zeichenkette)
- Spalte: Split Type ([O21.OPTIMA.import.ORDER_LINE.SPLIT_TYPE], Zeichenkette)
- Spalte: Split Am Main ([O21.OPTIMA.import.ORDER_LINE.SPLIT_AM_MAIN], Zahl)
- Spalte: Split Am Sub1 ([O21.OPTIMA.import.ORDER_LINE.SPLIT_AM_SUB1], Zahl)
- Spalte: Split Am Sub2 ([O21.OPTIMA.import.ORDER_LINE.SPLIT_AM_SUB2], Zahl)
- Spalte: Prod Code ([O21.OPTIMA.import.ORDER_LINE.PROD_CODE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.ORDER_LINE.MAKE_CD], Zeichenkette)
- Spalte: Product Group ([O21.OPTIMA.import.ORDER_LINE.PRODUCT_GROUP], Zeichenkette)
- Spalte: Prod Name ([O21.OPTIMA.import.ORDER_LINE.PROD_NAME], Zeichenkette)
- Spalte: Location ([O21.OPTIMA.import.ORDER_LINE.LOCATION], Zeichenkette)
- Spalte: Location 2 ([O21.OPTIMA.import.ORDER_LINE.LOCATION_2], Zeichenkette)
- Spalte: Location 3 ([O21.OPTIMA.import.ORDER_LINE.LOCATION_3], Zeichenkette)
- Spalte: Deductable ([O21.OPTIMA.import.ORDER_LINE.DEDUCTABLE], Zeichenkette)
- Spalte: Order Quantity ([O21.OPTIMA.import.ORDER_LINE.ORDER_QUANTITY], Zahl)
- Spalte: Delivery Quantity ([O21.OPTIMA.import.ORDER_LINE.DELIVERY_QUANTITY], Zahl)
- Spalte: Spec Purch Price ([O21.OPTIMA.import.ORDER_LINE.SPEC_PURCH_PRICE], Zeichenkette)
- Spalte: Re Purchase Price ([O21.OPTIMA.import.ORDER_LINE.RE_PURCHASE_PRICE], Zahl)
- Spalte: Line Costs ([O21.OPTIMA.import.ORDER_LINE.LINE_COSTS], Zahl)
- Spalte: Costprice Tax ([O21.OPTIMA.import.ORDER_LINE.COSTPRICE_TAX], Zahl)
- Spalte: Claim Return Code ([O21.OPTIMA.import.ORDER_LINE.CLAIM_RETURN_CODE], Zeichenkette)
- Spalte: Inv Total Number ([O21.OPTIMA.import.ORDER_LINE.INV_TOTAL_NUMBER], Zahl)
- Spalte: Special Price ([O21.OPTIMA.import.ORDER_LINE.SPECIAL_PRICE], Zahl)
- Spalte: Sales Price ([O21.OPTIMA.import.ORDER_LINE.SALES_PRICE], Zahl)
- Spalte: Sales Price Incl ([O21.OPTIMA.import.ORDER_LINE.SALES_PRICE_INCL], Zahl)
- Spalte: Orig Order No ([O21.OPTIMA.import.ORDER_LINE.ORIG_ORDER_NO], Zahl)
- Spalte: Orig Line No ([O21.OPTIMA.import.ORDER_LINE.ORIG_LINE_NO], Zahl)
- Spalte: Orig Creation Code ([O21.OPTIMA.import.ORDER_LINE.ORIG_CREATION_CODE], Zeichenkette)
- Spalte: Back Order Cd ([O21.OPTIMA.import.ORDER_LINE.BACK_ORDER_CD], Zeichenkette)
- Spalte: Back Order ([O21.OPTIMA.import.ORDER_LINE.BACK_ORDER], Zahl)
- Spalte: Internal Transfer ([O21.OPTIMA.import.ORDER_LINE.INTERNAL_TRANSFER], Zeichenkette)
- Spalte: Stdprice 2 ([O21.OPTIMA.import.ORDER_LINE.STDPRICE_2], Zahl)
- Spalte: Quantity Disc Code ([O21.OPTIMA.import.ORDER_LINE.QUANTITY_DISC_CODE], Zeichenkette)
- Spalte: Campaign Code ([O21.OPTIMA.import.ORDER_LINE.CAMPAIGN_CODE], Zeichenkette)
- Spalte: Replace Code ([O21.OPTIMA.import.ORDER_LINE.REPLACE_CODE], Zeichenkette)
- Spalte: N Main Part No ([O21.OPTIMA.import.ORDER_LINE.N_MAIN_PART_NO], Zeichenkette)
- Spalte: Line Textline 1 ([O21.OPTIMA.import.ORDER_LINE.LINE_TEXTLINE_1], Zeichenkette)
- Spalte: Line Textline 2 ([O21.OPTIMA.import.ORDER_LINE.LINE_TEXTLINE_2], Zeichenkette)
- Spalte: Line Textline 3 ([O21.OPTIMA.import.ORDER_LINE.LINE_TEXTLINE_3], Zeichenkette)
- Spalte: Line Text Code ([O21.OPTIMA.import.ORDER_LINE.LINE_TEXT_CODE], Zeichenkette)
- Spalte: Line Code ([O21.OPTIMA.import.ORDER_LINE.LINE_CODE], Zeichenkette)
- Spalte: Line Workshop ([O21.OPTIMA.import.ORDER_LINE.LINE_WORKSHOP], Zeichenkette)
- Spalte: Back Reg Code ([O21.OPTIMA.import.ORDER_LINE.BACK_REG_CODE], Zeichenkette)
- Spalte: Requisition Num ([O21.OPTIMA.import.ORDER_LINE.REQUISITION_NUM], Zeichenkette)
- Spalte: Repair Code ([O21.OPTIMA.import.ORDER_LINE.REPAIR_CODE], Zeichenkette)
- Spalte: Repair Group ([O21.OPTIMA.import.ORDER_LINE.REPAIR_GROUP], Zeichenkette)
- Spalte: Repair Name ([O21.OPTIMA.import.ORDER_LINE.REPAIR_NAME], Zeichenkette)
- Spalte: Rate Price Code ([O21.OPTIMA.import.ORDER_LINE.RATE_PRICE_CODE], Zeichenkette)
- Spalte: Time Rate ([O21.OPTIMA.import.ORDER_LINE.TIME_RATE], Zeichenkette)
- Spalte: Used Time ([O21.OPTIMA.import.ORDER_LINE.USED_TIME], Zahl)
- Spalte: Est Time ([O21.OPTIMA.import.ORDER_LINE.EST_TIME], Zahl)
- Spalte: Inv Time ([O21.OPTIMA.import.ORDER_LINE.INV_TIME], Zahl)
- Spalte: Repair Code 2 ([O21.OPTIMA.import.ORDER_LINE.REPAIR_CODE_2], Zeichenkette)
- Spalte: Repair Pos ([O21.OPTIMA.import.ORDER_LINE.REPAIR_POS], Zahl)
- Spalte: Line Comment ([O21.OPTIMA.import.ORDER_LINE.LINE_COMMENT], Zeichenkette)
- Spalte: Inspection 1 ([O21.OPTIMA.import.ORDER_LINE.INSPECTION_1], Zeichenkette)
- Spalte: Inspection 2 ([O21.OPTIMA.import.ORDER_LINE.INSPECTION_2], Zeichenkette)
- Spalte: Work Date ([O21.OPTIMA.import.ORDER_LINE.WORK_DATE], Datum/Uhrzeit)
- Spalte: Start Time ([O21.OPTIMA.import.ORDER_LINE.START_TIME], Zahl)
- Spalte: End Date ([O21.OPTIMA.import.ORDER_LINE.END_DATE], Datum/Uhrzeit)
- Spalte: End Time ([O21.OPTIMA.import.ORDER_LINE.END_TIME], Zahl)
- Spalte: Workshop Area ([O21.OPTIMA.import.ORDER_LINE.WORKSHOP_AREA], Zeichenkette)
- Spalte: W Main Repair No ([O21.OPTIMA.import.ORDER_LINE.W_MAIN_REPAIR_NO], Zeichenkette)
- Spalte: Kit Group ([O21.OPTIMA.import.ORDER_LINE.KIT_GROUP], Zeichenkette)
- Spalte: Kit Code ([O21.OPTIMA.import.ORDER_LINE.KIT_CODE], Zeichenkette)
- Spalte: Workshop Model ([O21.OPTIMA.import.ORDER_LINE.WORKSHOP_MODEL], Zeichenkette)
- Spalte: Kit Text ([O21.OPTIMA.import.ORDER_LINE.KIT_TEXT], Zeichenkette)
- Spalte: Kit Fixed Price ([O21.OPTIMA.import.ORDER_LINE.KIT_FIXED_PRICE], Zahl)
- Spalte: Class Rule ([O21.OPTIMA.import.ORDER_LINE.CLASS_RULE], Zeichenkette)
- Spalte: Kit One Line ([O21.OPTIMA.import.ORDER_LINE.KIT_ONE_LINE], Zeichenkette)
- Spalte: Kit One Lineprice ([O21.OPTIMA.import.ORDER_LINE.KIT_ONE_LINEPRICE], Zeichenkette)
- Spalte: Kit Catalog Code ([O21.OPTIMA.import.ORDER_LINE.KIT_CATALOG_CODE], Zeichenkette)
- Spalte: Kit Parts Disc Per ([O21.OPTIMA.import.ORDER_LINE.KIT_PARTS_DISC_PER], Zahl)
- Spalte: Kit Work Disc Per ([O21.OPTIMA.import.ORDER_LINE.KIT_WORK_DISC_PER], Zahl)
- Spalte: Kit Misc Disc Per ([O21.OPTIMA.import.ORDER_LINE.KIT_MISC_DISC_PER], Zahl)
- Spalte: Kit Delete ([O21.OPTIMA.import.ORDER_LINE.KIT_DELETE], Zeichenkette)
- Spalte: Kit Price Diff ([O21.OPTIMA.import.ORDER_LINE.KIT_PRICE_DIFF], Zahl)
- Spalte: Kit Print Split ([O21.OPTIMA.import.ORDER_LINE.KIT_PRINT_SPLIT], Zeichenkette)
- Spalte: Type Ol ([O21.OPTIMA.import.ORDER_LINE.TYPE_OL], Zeichenkette)
- Spalte: Transaction Code 2 ([O21.OPTIMA.import.ORDER_LINE.TRANSACTION_CODE_2], Zeichenkette)
- Spalte: Txt Ol ([O21.OPTIMA.import.ORDER_LINE.TXT_OL], Zeichenkette)
- Spalte: Amount Ol ([O21.OPTIMA.import.ORDER_LINE.AMOUNT_OL], Zahl)
- Spalte: Cash Account ([O21.OPTIMA.import.ORDER_LINE.CASH_ACCOUNT], Zeichenkette)
- Spalte: Repair Code Accu ([O21.OPTIMA.import.ORDER_LINE.REPAIR_CODE_ACCU], Zeichenkette)
- Spalte: Recommended Price ([O21.OPTIMA.import.ORDER_LINE.RECOMMENDED_PRICE], Zahl)
- Spalte: Cost Price Work ([O21.OPTIMA.import.ORDER_LINE.COST_PRICE_WORK], Zahl)
- Spalte: Time Code 1 ([O21.OPTIMA.import.ORDER_LINE.TIME_CODE_1], Zeichenkette)
- Spalte: Used Time Type 1 ([O21.OPTIMA.import.ORDER_LINE.USED_TIME_TYPE_1], Zahl)
- Spalte: Cost Price Type 1 ([O21.OPTIMA.import.ORDER_LINE.COST_PRICE_TYPE_1], Zahl)
- Spalte: Time Code 2 ([O21.OPTIMA.import.ORDER_LINE.TIME_CODE_2], Zeichenkette)
- Spalte: Used Time Type 2 ([O21.OPTIMA.import.ORDER_LINE.USED_TIME_TYPE_2], Zahl)
- Spalte: Cost Price Type 2 ([O21.OPTIMA.import.ORDER_LINE.COST_PRICE_TYPE_2], Zahl)
- Spalte: Discount Allowance ([O21.OPTIMA.import.ORDER_LINE.DISCOUNT_ALLOWANCE], Zeichenkette)
- Spalte: Create After Rc ([O21.OPTIMA.import.ORDER_LINE.CREATE_AFTER_RC], Zeichenkette)
- Spalte: Repeat Repair ([O21.OPTIMA.import.ORDER_LINE.REPEAT_REPAIR], Zeichenkette)
- Spalte: Inv Time Cost ([O21.OPTIMA.import.ORDER_LINE.INV_TIME_COST], Zahl)
- Spalte: Time Code ([O21.OPTIMA.import.ORDER_LINE.TIME_CODE], Zeichenkette)
- Spalte: Factor Code ([O21.OPTIMA.import.ORDER_LINE.FACTOR_CODE], Zeichenkette)
- Spalte: Reduction Factor 1 ([O21.OPTIMA.import.ORDER_LINE.REDUCTION_FACTOR_1], Zahl)
- Spalte: Resulting Line 1 ([O21.OPTIMA.import.ORDER_LINE.RESULTING_LINE_1], Zahl)
- Spalte: External Stock ([O21.OPTIMA.import.ORDER_LINE.EXTERNAL_STOCK], Zeichenkette)
- Spalte: Repair Group Type ([O21.OPTIMA.import.ORDER_LINE.REPAIR_GROUP_TYPE], Zeichenkette)
- Spalte: Automatic Created ([O21.OPTIMA.import.ORDER_LINE.AUTOMATIC_CREATED], Zeichenkette)
- Spalte: Incomplete Line ([O21.OPTIMA.import.ORDER_LINE.INCOMPLETE_LINE], Zeichenkette)
- Spalte: Incomplete Line 2 ([O21.OPTIMA.import.ORDER_LINE.INCOMPLETE_LINE_2], Zeichenkette)
- Spalte: Order Linetype 4 ([O21.OPTIMA.import.ORDER_LINE.ORDER_LINETYPE_4], Zeichenkette)
- Spalte: Consignment Code ([O21.OPTIMA.import.ORDER_LINE.CONSIGNMENT_CODE], Zeichenkette)
- Spalte: Part Group ([O21.OPTIMA.import.ORDER_LINE.PART_GROUP], Zeichenkette)
- Spalte: Misc 1 ([O21.OPTIMA.import.ORDER_LINE.MISC_1], Zeichenkette)
- Spalte: Misc 2 ([O21.OPTIMA.import.ORDER_LINE.MISC_2], Zeichenkette)
- Spalte: Misc 3 ([O21.OPTIMA.import.ORDER_LINE.MISC_3], Zeichenkette)
- Spalte: Misc 4 ([O21.OPTIMA.import.ORDER_LINE.MISC_4], Zeichenkette)
- Spalte: Misc 5 ([O21.OPTIMA.import.ORDER_LINE.MISC_5], Zeichenkette)
- Spalte: Misc 6 ([O21.OPTIMA.import.ORDER_LINE.MISC_6], Zeichenkette)
- Spalte: Order Line Transm ([O21.OPTIMA.import.ORDER_LINE.ORDER_LINE_TRANSM], Zeichenkette)
- Spalte: Orig Prod Code ([O21.OPTIMA.import.ORDER_LINE.ORIG_PROD_CODE], Zeichenkette)
- Spalte: Orig Make Cd ([O21.OPTIMA.import.ORDER_LINE.ORIG_MAKE_CD], Zeichenkette)
- Spalte: Orig Prod Group ([O21.OPTIMA.import.ORDER_LINE.ORIG_PROD_GROUP], Zeichenkette)
- Spalte: Buyers Reference ([O21.OPTIMA.import.ORDER_LINE.BUYERS_REFERENCE], Zeichenkette)
- Spalte: Ccc Category ([O21.OPTIMA.import.ORDER_LINE.CCC_CATEGORY], Zeichenkette)
- Spalte: Ccc ([O21.OPTIMA.import.ORDER_LINE.CCC], Zeichenkette)
- Spalte: External Origin ([O21.OPTIMA.import.ORDER_LINE.EXTERNAL_ORIGIN], Zeichenkette)
- Spalte: Stock Shop List ([O21.OPTIMA.import.ORDER_LINE.STOCK_SHOP_LIST], Zeichenkette)
- Spalte: Line Reference ([O21.OPTIMA.import.ORDER_LINE.LINE_REFERENCE], Zahl)
- Spalte: Work Type Code ([O21.OPTIMA.import.ORDER_LINE.WORK_TYPE_CODE], Zeichenkette)
- Spalte: Customer Complaint ([O21.OPTIMA.import.ORDER_LINE.CUSTOMER_COMPLAINT], Zeichenkette)
- Spalte: Job Code Descr ([O21.OPTIMA.import.ORDER_LINE.JOB_CODE_DESCR], Zeichenkette)
- Spalte: Text 200 ([O21.OPTIMA.import.ORDER_LINE.TEXT_200], Zeichenkette)
- Spalte: Payer Percentage ([O21.OPTIMA.import.ORDER_LINE.PAYER_PERCENTAGE], Zahl)
- Spalte: Price A G ([O21.OPTIMA.import.ORDER_LINE.PRICE_A_G], Zeichenkette)
- Spalte: Alternative Price ([O21.OPTIMA.import.ORDER_LINE.ALTERNATIVE_PRICE], Zahl)
- Spalte: Qty Ownership ([O21.OPTIMA.import.ORDER_LINE.QTY_OWNERSHIP], Zeichenkette)
- Spalte: Flat Search 2 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_2], Zeichenkette)
- Spalte: Flat Search 3 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_3], Zeichenkette)
- Spalte: Flat Search 4 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_4], Zeichenkette)
- Spalte: Flat Search 5 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_5], Zeichenkette)
- Spalte: Flat Search 6 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_6], Zeichenkette)
- Spalte: Flat Search 7 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_7], Zeichenkette)
- Spalte: Flat Search 8 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_8], Zeichenkette)
- Spalte: Flat Search 9 ([O21.OPTIMA.import.ORDER_LINE.FLAT_SEARCH_9], Zeichenkette)
- Spalte: Create Msc ([O21.OPTIMA.import.ORDER_LINE.CREATE_MSC], Zeichenkette)
- Spalte: Special Lock No ([O21.OPTIMA.import.ORDER_LINE.SPECIAL_LOCK_NO], Zeichenkette)
- Spalte: Supplier Code ([O21.OPTIMA.import.ORDER_LINE.SUPPLIER_CODE], Zeichenkette)
- Spalte: Requisition Number ([O21.OPTIMA.import.ORDER_LINE.REQUISITION_NUMBER], Zeichenkette)
- Spalte: Used Time Int ([O21.OPTIMA.import.ORDER_LINE.USED_TIME_INT], Zahl)
- Spalte: Est Time Int ([O21.OPTIMA.import.ORDER_LINE.EST_TIME_INT], Zahl)
- Spalte: Inv Time Int ([O21.OPTIMA.import.ORDER_LINE.INV_TIME_INT], Zahl)
- Spalte: Make Time Unit ([O21.OPTIMA.import.ORDER_LINE.MAKE_TIME_UNIT], Zeichenkette)
- Spalte: Deposit Type ([O21.OPTIMA.import.ORDER_LINE.DEPOSIT_TYPE], Zeichenkette)
- Spalte: Line Status ([O21.OPTIMA.import.ORDER_LINE.LINE_STATUS], Zeichenkette)
- Spalte: Sales Unit Std ([O21.OPTIMA.import.ORDER_LINE.SALES_UNIT_STD], Zeichenkette)
- Spalte: Sales Unit Alt ([O21.OPTIMA.import.ORDER_LINE.SALES_UNIT_ALT], Zeichenkette)
- Spalte: Order Quantity Alt Unit ([O21.OPTIMA.import.ORDER_LINE.ORDER_QUANTITY_ALT_UNIT], Zahl)
- Spalte: Oil ([O21.OPTIMA.import.ORDER_LINE.OIL], Zeichenkette)
- Spalte: Deductible Vat ([O21.OPTIMA.import.ORDER_LINE.DEDUCTIBLE_VAT], Zeichenkette)
- Spalte: Accumulated Menu Changes ([O21.OPTIMA.import.ORDER_LINE.ACCUMULATED_MENU_CHANGES], Zahl)
- Spalte: Workshop Team ([O21.OPTIMA.import.ORDER_LINE.WORKSHOP_TEAM], Zeichenkette)
- Spalte: Repair Location Code ([O21.OPTIMA.import.ORDER_LINE.REPAIR_LOCATION_CODE], Zeichenkette)
- Spalte: Menu Type ([O21.OPTIMA.import.ORDER_LINE.MENU_TYPE], Zeichenkette)
- Spalte: Promotion Number ([O21.OPTIMA.import.ORDER_LINE.PROMOTION_NUMBER], Zahl)
- Spalte: Promotion Discount Pct ([O21.OPTIMA.import.ORDER_LINE.PROMOTION_DISCOUNT_PCT], Zahl)
- Spalte: Qty Sold Negative ([O21.OPTIMA.import.ORDER_LINE.QTY_SOLD_NEGATIVE], Zahl)
- Spalte: Orig Cost Price ([O21.OPTIMA.import.ORDER_LINE.ORIG_COST_PRICE], Zahl)
- Spalte: Requested Quantity ([O21.OPTIMA.import.ORDER_LINE.REQUESTED_QUANTITY], Zahl)
- Spalte: Picking List No ([O21.OPTIMA.import.ORDER_LINE.PICKING_LIST_NO], Zahl)
- Spalte: Exchange Part ([O21.OPTIMA.import.ORDER_LINE.EXCHANGE_PART], Zeichenkette)
- Spalte: Exchange Return Code ([O21.OPTIMA.import.ORDER_LINE.EXCHANGE_RETURN_CODE], Zeichenkette)
- Spalte: External Pick In Progress ([O21.OPTIMA.import.ORDER_LINE.EXTERNAL_PICK_IN_PROGRESS], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.ORDER_LINE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ORDER_LINE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.ORDER_LINE.UNIQUE_IDENT], Zahl)
- Ordner: Vpp25
- Spalte: Stat Code ([O21.OPTIMA.import.VPP25.STAT_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP25.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP25.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP25.HANDLER], Zeichenkette)
- Spalte: Stat Specify ([O21.OPTIMA.import.VPP25.STAT_SPECIFY], Zeichenkette)
- Spalte: Stat Billofl ([O21.OPTIMA.import.VPP25.STAT_BILLOFL], Zeichenkette)
- Spalte: Stat Invoice ([O21.OPTIMA.import.VPP25.STAT_INVOICE], Zeichenkette)
- Spalte: Stat No Turnover ([O21.OPTIMA.import.VPP25.STAT_NO_TURNOVER], Zeichenkette)
- Spalte: Stat Effect Code ([O21.OPTIMA.import.VPP25.STAT_EFFECT_CODE], Zeichenkette)
- Spalte: Stat Delete Term ([O21.OPTIMA.import.VPP25.STAT_DELETE_TERM], Zeichenkette)
- Spalte: Stat New Status ([O21.OPTIMA.import.VPP25.STAT_NEW_STATUS], Zeichenkette)
- Spalte: Stat New Cred Stat ([O21.OPTIMA.import.VPP25.STAT_NEW_CRED_STAT], Zeichenkette)
- Spalte: Stat New Bol Stat ([O21.OPTIMA.import.VPP25.STAT_NEW_BOL_STAT], Zeichenkette)
- Spalte: Stat Upd Sal Date ([O21.OPTIMA.import.VPP25.STAT_UPD_SAL_DATE], Zeichenkette)
- Spalte: Stat Upd Sales ([O21.OPTIMA.import.VPP25.STAT_UPD_SALES], Zeichenkette)
- Spalte: Stat Order Stat 1 ([O21.OPTIMA.import.VPP25.STAT_ORDER_STAT_1], Zeichenkette)
- Spalte: Stat Order Stat 2 ([O21.OPTIMA.import.VPP25.STAT_ORDER_STAT_2], Zeichenkette)
- Spalte: Stat Order Stat 3 ([O21.OPTIMA.import.VPP25.STAT_ORDER_STAT_3], Zeichenkette)
- Spalte: Stat Order Stat 4 ([O21.OPTIMA.import.VPP25.STAT_ORDER_STAT_4], Zeichenkette)
- Spalte: Stat Order Stat 5 ([O21.OPTIMA.import.VPP25.STAT_ORDER_STAT_5], Zeichenkette)
- Spalte: Stat Unit Sales ([O21.OPTIMA.import.VPP25.STAT_UNIT_SALES], Zeichenkette)
- Spalte: Stat Fixed Txt Cod ([O21.OPTIMA.import.VPP25.STAT_FIXED_TXT_COD], Zeichenkette)
- Spalte: Stat Make Chk Used ([O21.OPTIMA.import.VPP25.STAT_MAKE_CHK_USED], Zeichenkette)
- Spalte: Stat Quick Endstat ([O21.OPTIMA.import.VPP25.STAT_QUICK_ENDSTAT], Zeichenkette)
- Spalte: Stat Part Order ([O21.OPTIMA.import.VPP25.STAT_PART_ORDER], Zeichenkette)
- Spalte: Stat Great Order ([O21.OPTIMA.import.VPP25.STAT_GREAT_ORDER], Zeichenkette)
- Spalte: Stat Mileage Check ([O21.OPTIMA.import.VPP25.STAT_MILEAGE_CHECK], Zeichenkette)
- Spalte: Activity Code ([O21.OPTIMA.import.VPP25.ACTIVITY_CODE], Zeichenkette)
- Spalte: Kit W Lines ([O21.OPTIMA.import.VPP25.KIT_W_LINES], Zeichenkette)
- Spalte: Use Price A G ([O21.OPTIMA.import.VPP25.USE_PRICE_A_G], Zeichenkette)
- Spalte: Send Advice ([O21.OPTIMA.import.VPP25.SEND_ADVICE], Zeichenkette)
- Spalte: Minute Code ([O21.OPTIMA.import.VPP25.MINUTE_CODE], Zeichenkette)
- Spalte: Veh Inv Purchase Text ([O21.OPTIMA.import.VPP25.VEH_INV_PURCHASE_TEXT], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP25.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP25.UNIQUE_IDENT], Zahl)
- Ordner: Vpp2c
- Spalte: Login ([O21.OPTIMA.import.vPP2C.LOGIN], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP2C.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP2C.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP2C.HANDLER], Zeichenkette)
- Spalte: User Handler ([O21.OPTIMA.import.vPP2C.USER_HANDLER], Zeichenkette)
- Spalte: User Group ([O21.OPTIMA.import.vPP2C.USER_GROUP], Zeichenkette)
- Spalte: Help Level ([O21.OPTIMA.import.vPP2C.HELP_LEVEL], Zeichenkette)
- Spalte: Low Entensity ([O21.OPTIMA.import.vPP2C.LOW_ENTENSITY], Zeichenkette)
- Spalte: Error Beep ([O21.OPTIMA.import.vPP2C.ERROR_BEEP], Zeichenkette)
- Spalte: Key In Attr ([O21.OPTIMA.import.vPP2C.KEY_IN_ATTR], Zeichenkette)
- Spalte: Hardcopy Printer ([O21.OPTIMA.import.vPP2C.HARDCOPY_PRINTER], Zeichenkette)
- Spalte: Restore Screen ([O21.OPTIMA.import.vPP2C.RESTORE_SCREEN], Zeichenkette)
- Spalte: Stock ([O21.OPTIMA.import.vPP2C.STOCK], Zeichenkette)
- Spalte: Date Order ([O21.OPTIMA.import.vPP2C.DATE_ORDER], Zeichenkette)
- Spalte: Daily Clos Resp ([O21.OPTIMA.import.vPP2C.DAILY_CLOS_RESP], Zeichenkette)
- Spalte: Daily Clos Func ([O21.OPTIMA.import.vPP2C.DAILY_CLOS_FUNC], Zeichenkette)
- Spalte: Price Control Grp ([O21.OPTIMA.import.vPP2C.PRICE_CONTROL_GRP], Zeichenkette)
- Spalte: User Clearance ([O21.OPTIMA.import.vPP2C.USER_CLEARANCE], Zeichenkette)
- Spalte: Cash Account ([O21.OPTIMA.import.vPP2C.CASH_ACCOUNT], Zeichenkette)
- Spalte: Department ([O21.OPTIMA.import.vPP2C.DEPARTMENT], Zeichenkette)
- Spalte: Cashbon Printer ([O21.OPTIMA.import.vPP2C.CASHBON_PRINTER], Zeichenkette)
- Spalte: Open Status Step ([O21.OPTIMA.import.vPP2C.OPEN_STATUS_STEP], Zeichenkette)
- Spalte: Acct Perm Code ([O21.OPTIMA.import.vPP2C.ACCT_PERM_CODE], Zeichenkette)
- Spalte: Order Other Stocks ([O21.OPTIMA.import.vPP2C.ORDER_OTHER_STOCKS], Zeichenkette)
- Spalte: Invoice Allow ([O21.OPTIMA.import.vPP2C.INVOICE_ALLOW], Zeichenkette)
- Spalte: No Return Check ([O21.OPTIMA.import.vPP2C.NO_RETURN_CHECK], Zeichenkette)
- Spalte: News Mes ([O21.OPTIMA.import.vPP2C.NEWS_MES], Zeichenkette)
- Spalte: News Mes Seen ([O21.OPTIMA.import.vPP2C.NEWS_MES_SEEN], Zeichenkette)
- Spalte: News Upd ([O21.OPTIMA.import.vPP2C.NEWS_UPD], Zeichenkette)
- Spalte: News Upd Seen ([O21.OPTIMA.import.vPP2C.NEWS_UPD_SEEN], Zeichenkette)
- Spalte: Create Part ([O21.OPTIMA.import.vPP2C.CREATE_PART], Zeichenkette)
- Spalte: Create Wmn ([O21.OPTIMA.import.vPP2C.CREATE_WMN], Zeichenkette)
- Spalte: Su Order Unlock ([O21.OPTIMA.import.vPP2C.SU_ORDER_UNLOCK], Zeichenkette)
- Spalte: Bookkeep 6420 ([O21.OPTIMA.import.vPP2C.BOOKKEEP_6420], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.vPP2C.MAKE_CD], Zeichenkette)
- Spalte: Allow Print Cheque ([O21.OPTIMA.import.vPP2C.ALLOW_PRINT_CHEQUE], Zeichenkette)
- Spalte: Credit Without Return ([O21.OPTIMA.import.vPP2C.CREDIT_WITHOUT_RETURN], Zeichenkette)
- Spalte: Keycard Reader Id ([O21.OPTIMA.import.vPP2C.KEYCARD_READER_ID], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP2C.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP2C.UNIQUE_IDENT], Zahl)
- Ordner: Vpp43
- Spalte: Seller Code ([O21.OPTIMA.import.VPP43.SELLER_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP43.STATE_CODE_PARAM], 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], Zeichenkette)
- Spalte: Sel Factor ([O21.OPTIMA.import.VPP43.SEL_FACTOR], Zahl)
- Spalte: Sel Com Salesman ([O21.OPTIMA.import.VPP43.SEL_COM_SALESMAN], Zeichenkette)
- Spalte: Mechanic Pay Group ([O21.OPTIMA.import.VPP43.MECHANIC_PAY_GROUP], Zeichenkette)
- Spalte: Order Approv Perm ([O21.OPTIMA.import.VPP43.ORDER_APPROV_PERM], 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: 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], Zeichenkette)
- Spalte: End User ([O21.OPTIMA.import.VPP48.END_USER], Zeichenkette)
- Spalte: Order Discount Grp ([O21.OPTIMA.import.VPP48.ORDER_DISCOUNT_GRP], Zeichenkette)
- Spalte: Convert Sold Time ([O21.OPTIMA.import.VPP48.CONVERT_SOLD_TIME], Zeichenkette)
- 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: 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: Vpp61
- Spalte: Stock ([O21.OPTIMA.import.vPP61.STOCK], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP61.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP61.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP61.HANDLER], Zeichenkette)
- Spalte: Stock Name ([O21.OPTIMA.import.vPP61.STOCK_NAME], Zeichenkette)
- Spalte: Stock Interest ([O21.OPTIMA.import.vPP61.STOCK_INTEREST], Zahl)
- Spalte: Service Factor Alpha ([O21.OPTIMA.import.vPP61.SERVICE_FACTOR_ALPHA], Zeichenkette)
- Spalte: Service Factor ([O21.OPTIMA.import.vPP61.SERVICE_FACTOR], Zahl)
- Spalte: Beh Check ([O21.OPTIMA.import.vPP61.BEH_CHECK], Zeichenkette)
- Spalte: Locked ([O21.OPTIMA.import.vPP61.LOCKED], Zeichenkette)
- Spalte: Locked Text ([O21.OPTIMA.import.vPP61.LOCKED_TEXT], Zeichenkette)
- Spalte: Locked Text1 ([O21.OPTIMA.import.vPP61.LOCKED_TEXT1], Zeichenkette)
- Spalte: Locked Text2 ([O21.OPTIMA.import.vPP61.LOCKED_TEXT2], Zeichenkette)
- Spalte: Zero Qnt List ([O21.OPTIMA.import.vPP61.ZERO_QNT_LIST], Zeichenkette)
- Spalte: Nocard On Zero List ([O21.OPTIMA.import.vPP61.NOCARD_ON_ZERO_LIST], Zeichenkette)
- Spalte: Toyota Dealer ([O21.OPTIMA.import.vPP61.TOYOTA_DEALER], Zahl)
- Spalte: Volvo Dealer ([O21.OPTIMA.import.vPP61.VOLVO_DEALER], Zeichenkette)
- Spalte: Calc Min In Stock ([O21.OPTIMA.import.vPP61.CALC_MIN_IN_STOCK], Zeichenkette)
- Spalte: Ford Dealer ([O21.OPTIMA.import.vPP61.FORD_DEALER], Zeichenkette)
- Spalte: God Dealer ([O21.OPTIMA.import.vPP61.GOD_DEALER], Zahl)
- Spalte: Udas Handler ([O21.OPTIMA.import.vPP61.UDAS_HANDLER], Zeichenkette)
- Spalte: Branch No ([O21.OPTIMA.import.vPP61.BRANCH_NO], Zeichenkette)
- Spalte: Ford Stock Id ([O21.OPTIMA.import.vPP61.FORD_STOCK_ID], Zeichenkette)
- Spalte: Ford Part Dealer ([O21.OPTIMA.import.vPP61.FORD_PART_DEALER], Zeichenkette)
- Spalte: Psa F Dealer ([O21.OPTIMA.import.vPP61.PSA_F_DEALER], Zahl)
- Spalte: Ncg Dealer ([O21.OPTIMA.import.vPP61.NCG_DEALER], Zeichenkette)
- Spalte: Renault Dealer ([O21.OPTIMA.import.vPP61.RENAULT_DEALER], Zeichenkette)
- Spalte: Vo Dealer ([O21.OPTIMA.import.vPP61.VO_DEALER], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP61.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP61.UNIQUE_IDENT], Zahl)
- Ordner: Vpp65
- Spalte: Product Group ([O21.OPTIMA.import.vPP65.PRODUCT_GROUP], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP65.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP65.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP65.HANDLER], Zeichenkette)
- Spalte: Prod Grp Specify ([O21.OPTIMA.import.vPP65.PROD_GRP_SPECIFY], Zeichenkette)
- Spalte: Coeff ([O21.OPTIMA.import.vPP65.COEFF], Zahl)
- Spalte: Cost Perc ([O21.OPTIMA.import.vPP65.COST_PERC], Zahl)
- Spalte: Department 10 ([O21.OPTIMA.import.vPP65.DEPARTMENT_10], Zeichenkette)
- Spalte: Line Misc Adds Per ([O21.OPTIMA.import.vPP65.LINE_MISC_ADDS_PER], Zahl)
- Spalte: Sales Account ([O21.OPTIMA.import.vPP65.SALES_ACCOUNT], Zeichenkette)
- Spalte: Price Type Prod 1 ([O21.OPTIMA.import.vPP65.PRICE_TYPE_PROD_1], Zeichenkette)
- Spalte: Price Type Prod 2 ([O21.OPTIMA.import.vPP65.PRICE_TYPE_PROD_2], Zeichenkette)
- Spalte: Price Type Prod 3 ([O21.OPTIMA.import.vPP65.PRICE_TYPE_PROD_3], Zeichenkette)
- Spalte: Price Type Prod 4 ([O21.OPTIMA.import.vPP65.PRICE_TYPE_PROD_4], Zeichenkette)
- Spalte: Price Type Prod 5 ([O21.OPTIMA.import.vPP65.PRICE_TYPE_PROD_5], Zeichenkette)
- Spalte: Prod Sort Key ([O21.OPTIMA.import.vPP65.PROD_SORT_KEY], Zeichenkette)
- Spalte: Prod Grp Check ([O21.OPTIMA.import.vPP65.PROD_GRP_CHECK], Zeichenkette)
- Spalte: Invoice Total No ([O21.OPTIMA.import.vPP65.INVOICE_TOTAL_NO], Zahl)
- Spalte: Back Order Perm ([O21.OPTIMA.import.vPP65.BACK_ORDER_PERM], Zeichenkette)
- Spalte: Orig Prod Grp ([O21.OPTIMA.import.vPP65.ORIG_PROD_GRP], Zeichenkette)
- Spalte: Fb Statistic ([O21.OPTIMA.import.vPP65.FB_STATISTIC], Zeichenkette)
- Spalte: Ford Part ([O21.OPTIMA.import.vPP65.FORD_PART], Zeichenkette)
- Spalte: Sales Price Zero ([O21.OPTIMA.import.vPP65.SALES_PRICE_ZERO], Zeichenkette)
- Spalte: Dc2000 Prod Grp ([O21.OPTIMA.import.vPP65.DC2000_PROD_GRP], Zeichenkette)
- Spalte: Short Community ([O21.OPTIMA.import.vPP65.SHORT_COMMUNITY], Zeichenkette)
- Spalte: Return Allowed ([O21.OPTIMA.import.vPP65.RETURN_ALLOWED], Zeichenkette)
- Spalte: Opel Part ([O21.OPTIMA.import.vPP65.OPEL_PART], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.vPP65.MAKE_CD], Zeichenkette)
- Spalte: Purch Prod Grp ([O21.OPTIMA.import.vPP65.PURCH_PROD_GRP], Zeichenkette)
- Spalte: Product Group Tp ([O21.OPTIMA.import.vPP65.PRODUCT_GROUP_TP], Zeichenkette)
- Spalte: Vr Part ([O21.OPTIMA.import.vPP65.VR_PART], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP65.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP65.UNIQUE_IDENT], Zahl)
- Ordner: Vpp72
- Spalte: Workshop Pricecode ([O21.OPTIMA.import.vPP72.WORKSHOP_PRICECODE], Zeichenkette)
- Spalte: Price Category ([O21.OPTIMA.import.vPP72.PRICE_CATEGORY], Zeichenkette)
- Spalte: Workshop Model ([O21.OPTIMA.import.vPP72.WORKSHOP_MODEL], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.vPP72.MAKE_CD], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP72.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP72.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP72.HANDLER], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.vPP72.NAME], Zeichenkette)
- Spalte: Price 1 ([O21.OPTIMA.import.vPP72.PRICE_1], Zahl)
- Spalte: Runno 1 ([O21.OPTIMA.import.vPP72.RUNNO_1], Zeichenkette)
- Spalte: Price 2 ([O21.OPTIMA.import.vPP72.PRICE_2], Zahl)
- Spalte: Runno 2 ([O21.OPTIMA.import.vPP72.RUNNO_2], Zeichenkette)
- Spalte: Price 3 ([O21.OPTIMA.import.vPP72.PRICE_3], Zahl)
- Spalte: Runno 3 ([O21.OPTIMA.import.vPP72.RUNNO_3], Zeichenkette)
- Spalte: Price 4 ([O21.OPTIMA.import.vPP72.PRICE_4], Zahl)
- Spalte: Runno 4 ([O21.OPTIMA.import.vPP72.RUNNO_4], Zeichenkette)
- Spalte: Price 5 ([O21.OPTIMA.import.vPP72.PRICE_5], Zahl)
- Spalte: Runno 5 ([O21.OPTIMA.import.vPP72.RUNNO_5], Zeichenkette)
- Spalte: Price 6 ([O21.OPTIMA.import.vPP72.PRICE_6], Zahl)
- Spalte: Runno 6 ([O21.OPTIMA.import.vPP72.RUNNO_6], Zeichenkette)
- Spalte: Price 7 ([O21.OPTIMA.import.vPP72.PRICE_7], Zahl)
- Spalte: Runno 7 ([O21.OPTIMA.import.vPP72.RUNNO_7], Zeichenkette)
- Spalte: Price 8 ([O21.OPTIMA.import.vPP72.PRICE_8], Zahl)
- Spalte: Runno 8 ([O21.OPTIMA.import.vPP72.RUNNO_8], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP72.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP72.UNIQUE_IDENT], Zahl)
- Ordner: Vpp73
- Spalte: Repair Group ([O21.OPTIMA.import.VPP73.REPAIR_GROUP], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.VPP73.MAKE_CD], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP73.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP73.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP73.HANDLER], Zeichenkette)
- Spalte: Repair Grp Specify ([O21.OPTIMA.import.VPP73.REPAIR_GRP_SPECIFY], Zeichenkette)
- Spalte: Add Perc ([O21.OPTIMA.import.VPP73.ADD_PERC], Zahl)
- Spalte: Repair Code1 ([O21.OPTIMA.import.VPP73.REPAIR_CODE1], Zeichenkette)
- Spalte: Repair Pos ([O21.OPTIMA.import.VPP73.REPAIR_POS], Zahl)
- Spalte: Repair Statistic Code ([O21.OPTIMA.import.VPP73.REPAIR_STATISTIC_CODE], Zeichenkette)
- Spalte: Skill Code ([O21.OPTIMA.import.VPP73.SKILL_CODE], Zeichenkette)
- Spalte: Repair Group Type ([O21.OPTIMA.import.VPP73.REPAIR_GROUP_TYPE], Zeichenkette)
- Spalte: Factor ([O21.OPTIMA.import.VPP73.FACTOR], Zahl)
- Spalte: Calc Own Repair ([O21.OPTIMA.import.VPP73.CALC_OWN_REPAIR], Zeichenkette)
- Spalte: Calc Centr Repair ([O21.OPTIMA.import.VPP73.CALC_CENTR_REPAIR], Zeichenkette)
- Spalte: Repair Calc Type ([O21.OPTIMA.import.VPP73.REPAIR_CALC_TYPE], Zeichenkette)
- Spalte: Month ([O21.OPTIMA.import.VPP73.MONTH], Zahl)
- Spalte: Repair Group Tp ([O21.OPTIMA.import.VPP73.REPAIR_GROUP_TP], Zeichenkette)
- Spalte: Repair Group Type2 ([O21.OPTIMA.import.VPP73.REPAIR_GROUP_TYPE2], Zeichenkette)
- Spalte: Job Type ([O21.OPTIMA.import.VPP73.JOB_TYPE], Zeichenkette)
- Spalte: Operation Type ([O21.OPTIMA.import.VPP73.OPERATION_TYPE], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP73.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP73.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: Vpp91
- Spalte: Work Leader Group ([O21.OPTIMA.import.VPP91.WORK_LEADER_GROUP], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP91.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP91.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP91.HANDLER], Zeichenkette)
- Spalte: Workleader Text ([O21.OPTIMA.import.VPP91.WORKLEADER_TEXT], Zeichenkette)
- Spalte: Workleader Column ([O21.OPTIMA.import.VPP91.WORKLEADER_COLUMN], Zahl)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP91.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP91.UNIQUE_IDENT], Zahl)
- Ordner: Vpp93
- Spalte: Act Code ([O21.OPTIMA.import.vPP93.ACT_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.vPP93.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.vPP93.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.vPP93.HANDLER], Zeichenkette)
- Spalte: Activity Text ([O21.OPTIMA.import.vPP93.ACTIVITY_TEXT], Zeichenkette)
- Spalte: Salary Type ([O21.OPTIMA.import.vPP93.SALARY_TYPE], Zeichenkette)
- Spalte: Clock Card Act ([O21.OPTIMA.import.vPP93.CLOCK_CARD_ACT], Zeichenkette)
- Spalte: Activity Column ([O21.OPTIMA.import.vPP93.ACTIVITY_COLUMN], Zahl)
- Spalte: Long Lasting Act ([O21.OPTIMA.import.vPP93.LONG_LASTING_ACT], Zeichenkette)
- Spalte: Sickness Act ([O21.OPTIMA.import.vPP93.SICKNESS_ACT], Zeichenkette)
- Spalte: Time Based Act ([O21.OPTIMA.import.vPP93.TIME_BASED_ACT], Zeichenkette)
- Spalte: Order Based Act ([O21.OPTIMA.import.vPP93.ORDER_BASED_ACT], Zeichenkette)
- Spalte: Present Act ([O21.OPTIMA.import.vPP93.PRESENT_ACT], Zeichenkette)
- Spalte: Repno Prefix ([O21.OPTIMA.import.vPP93.REPNO_PREFIX], Zeichenkette)
- Spalte: Print Invoice Act ([O21.OPTIMA.import.vPP93.PRINT_INVOICE_ACT], Zeichenkette)
- Spalte: Wage Type ([O21.OPTIMA.import.vPP93.WAGE_TYPE], Zahl)
- Spalte: Activity Column 2 ([O21.OPTIMA.import.vPP93.ACTIVITY_COLUMN_2], Zahl)
- Spalte: Aw Department ([O21.OPTIMA.import.vPP93.AW_DEPARTMENT], Zeichenkette)
- Spalte: Act Code Change Wl ([O21.OPTIMA.import.vPP93.ACT_CODE_CHANGE_WL], Zeichenkette)
- Spalte: Activity Column 3 ([O21.OPTIMA.import.vPP93.ACTIVITY_COLUMN_3], Zahl)
- Spalte: Activity Column 4 ([O21.OPTIMA.import.vPP93.ACTIVITY_COLUMN_4], Zahl)
- Spalte: Clock In Function ([O21.OPTIMA.import.vPP93.CLOCK_IN_FUNCTION], Zeichenkette)
- Spalte: Clock Off Function ([O21.OPTIMA.import.vPP93.CLOCK_OFF_FUNCTION], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.vPP93.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.vPP93.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: Vpp43 Mechaniker
- Spalte: Seller Code ([O21.OPTIMA.import.VPP43_Mechaniker.SELLER_CODE], Zeichenkette)
- Spalte: State Code Param ([O21.OPTIMA.import.VPP43_Mechaniker.STATE_CODE_PARAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.VPP43_Mechaniker.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.VPP43_Mechaniker.HANDLER], Zeichenkette)
- Spalte: Sel Name ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_NAME], Zeichenkette)
- Spalte: Sel Department ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_DEPARTMENT], Zeichenkette)
- Spalte: Sel First Name ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_FIRST_NAME], Zeichenkette)
- Spalte: Sel Family Name ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_FAMILY_NAME], Zeichenkette)
- Spalte: Sel Title ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_TITLE], Zeichenkette)
- Spalte: Sel Male Female ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_MALE_FEMALE], Zeichenkette)
- Spalte: Sel Factor ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_FACTOR], Zahl)
- Spalte: Sel Com Salesman ([O21.OPTIMA.import.VPP43_Mechaniker.SEL_COM_SALESMAN], Zeichenkette)
- Spalte: Mechanic Pay Group ([O21.OPTIMA.import.VPP43_Mechaniker.MECHANIC_PAY_GROUP], Zeichenkette)
- Spalte: Order Approv Perm ([O21.OPTIMA.import.VPP43_Mechaniker.ORDER_APPROV_PERM], Zeichenkette)
- Spalte: Licence Id ([O21.OPTIMA.import.VPP43_Mechaniker.LICENCE_ID], Zeichenkette)
- Spalte: Employee Category ([O21.OPTIMA.import.VPP43_Mechaniker.EMPLOYEE_CATEGORY], Zahl)
- Spalte: Trainee Year ([O21.OPTIMA.import.VPP43_Mechaniker.TRAINEE_YEAR], Zahl)
- Spalte: Email Address ([O21.OPTIMA.import.VPP43_Mechaniker.EMAIL_ADDRESS], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.VPP43_Mechaniker.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.VPP43_Mechaniker.UNIQUE_IDENT], Zahl)
- Ordner: At Position Reg
- Ordner: Comm Unit
- Ordner: Order Accumulation
- Spalte: Order Number ([O21.OPTIMA.import.ORDER_ACCUMULATION.ORDER_NUMBER], Zahl)
- Spalte: Accu Level ([O21.OPTIMA.import.ORDER_ACCUMULATION.ACCU_LEVEL], Zahl)
- Spalte: Accu Type ([O21.OPTIMA.import.ORDER_ACCUMULATION.ACCU_TYPE], Zeichenkette)
- Spalte: Accu Code ([O21.OPTIMA.import.ORDER_ACCUMULATION.ACCU_CODE], Zeichenkette)
- Spalte: Vat Table ([O21.OPTIMA.import.ORDER_ACCUMULATION.VAT_TABLE], Zeichenkette)
- Spalte: State Code Accu ([O21.OPTIMA.import.ORDER_ACCUMULATION.STATE_CODE_ACCU], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.ORDER_ACCUMULATION.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.ORDER_ACCUMULATION.HANDLER], Zeichenkette)
- Spalte: Tax Perc ([O21.OPTIMA.import.ORDER_ACCUMULATION.TAX_PERC], Zahl)
- Spalte: Exchange Part ([O21.OPTIMA.import.ORDER_ACCUMULATION.EXCHANGE_PART], Zeichenkette)
- Spalte: Amount Excl ([O21.OPTIMA.import.ORDER_ACCUMULATION.AMOUNT_EXCL], Zahl)
- Spalte: Tax Share ([O21.OPTIMA.import.ORDER_ACCUMULATION.TAX_SHARE], Zahl)
- Spalte: Print Chars ([O21.OPTIMA.import.ORDER_ACCUMULATION.PRINT_CHARS], Zeichenkette)
- Spalte: Wust Code ([O21.OPTIMA.import.ORDER_ACCUMULATION.WUST_CODE], Zeichenkette)
- Spalte: Tax Diff Line ([O21.OPTIMA.import.ORDER_ACCUMULATION.TAX_DIFF_LINE], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.ORDER_ACCUMULATION.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ORDER_ACCUMULATION.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.ORDER_ACCUMULATION.UNIQUE_IDENT], Zahl)
- Ordner: Order Open Items
- Spalte: Veh Order Option Id ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.VEH_ORDER_OPTION_ID], Zahl)
- Spalte: Line No ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.LINE_NO], Zahl)
- Spalte: Creation Date ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.CREATION_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.HANDLER], Zeichenkette)
- Spalte: Customer Transact Id ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.CUSTOMER_TRANSACT_ID], Zahl)
- Spalte: Supplier Transact Id ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.SUPPLIER_TRANSACT_ID], Zahl)
- Spalte: Match Amount ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.MATCH_AMOUNT], Zahl)
- Spalte: Orig Customer Transact Id ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.ORIG_CUSTOMER_TRANSACT_ID], Zahl)
- Spalte: Orig Supplier Transact Id ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.ORIG_SUPPLIER_TRANSACT_ID], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.ORDER_OPEN_ITEMS.UNIQUE_IDENT], Zahl)
- Ordner: Order Service Schemes
- Spalte: Order Number ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.ORDER_NUMBER], Zahl)
- Spalte: Scheme No ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.SCHEME_NO], Zahl)
- Spalte: Guiding Text No ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.GUIDING_TEXT_NO], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.FUNCTION_CODE], Zeichenkette)
- Spalte: Field No ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.FIELD_NO], Zahl)
- Spalte: Guiding Text ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.GUIDING_TEXT], Zeichenkette)
- Spalte: Field A ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.FIELD_A], Zeichenkette)
- Spalte: Field B ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.FIELD_B], Zeichenkette)
- Spalte: Field C ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.FIELD_C], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.ORDER_SERVICE_SCHEMES.UNIQUE_IDENT], Zahl)
- Ordner: Service 2000 File
- Spalte: Rec Type ([O21.OPTIMA.import.SERVICE_2000_FILE.REC_TYPE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.SERVICE_2000_FILE.MAKE_CD], Zeichenkette)
- Spalte: Department ([O21.OPTIMA.import.SERVICE_2000_FILE.DEPARTMENT], Zeichenkette)
- Spalte: Year ([O21.OPTIMA.import.SERVICE_2000_FILE.YEAR], Zeichenkette)
- Spalte: Week No Month ([O21.OPTIMA.import.SERVICE_2000_FILE.WEEK_NO_MONTH], Zeichenkette)
- Spalte: Week No ([O21.OPTIMA.import.SERVICE_2000_FILE.WEEK_NO], Zeichenkette)
- Spalte: Week Day No ([O21.OPTIMA.import.SERVICE_2000_FILE.WEEK_DAY_NO], Zeichenkette)
- Spalte: Extracted Date ([O21.OPTIMA.import.SERVICE_2000_FILE.EXTRACTED_DATE], Datum/Uhrzeit)
- Spalte: State Code ([O21.OPTIMA.import.SERVICE_2000_FILE.STATE_CODE], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.SERVICE_2000_FILE.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Transact Time ([O21.OPTIMA.import.SERVICE_2000_FILE.TRANSACT_TIME], Zahl)
- Spalte: Handler ([O21.OPTIMA.import.SERVICE_2000_FILE.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.SERVICE_2000_FILE.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.SERVICE_2000_FILE.FUNCTION_CODE], Zeichenkette)
- Spalte: Department Type ([O21.OPTIMA.import.SERVICE_2000_FILE.DEPARTMENT_TYPE], Zeichenkette)
- Spalte: Days Open ([O21.OPTIMA.import.SERVICE_2000_FILE.DAYS_OPEN], Zahl)
- Spalte: O Opened ([O21.OPTIMA.import.SERVICE_2000_FILE.O_OPENED], Zahl)
- Spalte: O Pre Arranged ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_ARRANGED], Zahl)
- Spalte: O Pre Arranged Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_ARRANGED_PCT], Zahl)
- Spalte: Pers Receipt ([O21.OPTIMA.import.SERVICE_2000_FILE.PERS_RECEIPT], Zahl)
- Spalte: Pers Receipt Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.PERS_RECEIPT_PCT], Zahl)
- Spalte: Inspect Done ([O21.OPTIMA.import.SERVICE_2000_FILE.INSPECT_DONE], Zahl)
- Spalte: Inspect Done Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.INSPECT_DONE_PCT], Zahl)
- Spalte: Fixed Kit Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.FIXED_KIT_WRK], Zahl)
- Spalte: Fixed Kit Wrk Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.FIXED_KIT_WRK_PCT], Zahl)
- Spalte: Additional Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.ADDITIONAL_WRK], Zahl)
- Spalte: Additional Wrk Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.ADDITIONAL_WRK_PCT], Zahl)
- Spalte: Finish Apptime ([O21.OPTIMA.import.SERVICE_2000_FILE.FINISH_APPTIME], Zahl)
- Spalte: Finish Apptime Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.FINISH_APPTIME_PCT], Zahl)
- Spalte: Over Again Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.OVER_AGAIN_WRK], Zahl)
- Spalte: Over Again Wrk Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.OVER_AGAIN_WRK_PCT], Zahl)
- Spalte: O Mechanic Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.O_MECHANIC_WRK], Zahl)
- Spalte: O Pre Picked ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_PICKED], Zahl)
- Spalte: O Pre Picked Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_PICKED_PCT], Zahl)
- Spalte: O Pre Picked Pct 2 ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_PICKED_PCT_2], Zahl)
- Spalte: Mech Skilled Days ([O21.OPTIMA.import.SERVICE_2000_FILE.MECH_SKILLED_DAYS], Zahl)
- Spalte: Wrk Capacity Eff ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_CAPACITY_EFF], Zahl)
- Spalte: Mech Trainee Days ([O21.OPTIMA.import.SERVICE_2000_FILE.MECH_TRAINEE_DAYS], Zahl)
- Spalte: Used Hours Inv ([O21.OPTIMA.import.SERVICE_2000_FILE.USED_HOURS_INV], Zahl)
- Spalte: Invoiced Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.INVOICED_HOURS], Zahl)
- Spalte: O Invoiced ([O21.OPTIMA.import.SERVICE_2000_FILE.O_INVOICED], Zahl)
- Spalte: Inv Kit Wrk Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_KIT_WRK_HOURS], Zahl)
- Spalte: Workshop Use Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.WORKSHOP_USE_PCT], Zahl)
- Spalte: Productivity Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.PRODUCTIVITY_PCT], Zahl)
- Spalte: Wrk Efficiency Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_EFFICIENCY_PCT], Zahl)
- Spalte: Inv Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_WRK_AMT], Zahl)
- Spalte: Inv Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_PART_AMT], Zahl)
- Spalte: Inv Misc Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_MISC_AMT], Zahl)
- Spalte: Total Inv Part Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.TOTAL_INV_PART_WRK], Zahl)
- Spalte: Total Inv ([O21.OPTIMA.import.SERVICE_2000_FILE.TOTAL_INV], Zahl)
- Spalte: Avr Wrk Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_PART_AMT], Zahl)
- Spalte: Avr Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_AMT], Zahl)
- Spalte: Avr Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_PART_AMT], Zahl)
- Spalte: Avr Wrk Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_PCT], Zahl)
- Spalte: Avr Part Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_PART_PCT], Zahl)
- Spalte: Turnover Factor ([O21.OPTIMA.import.SERVICE_2000_FILE.TURNOVER_FACTOR], Zahl)
- Spalte: Order Analyse ([O21.OPTIMA.import.SERVICE_2000_FILE.ORDER_ANALYSE], Zahl)
- Spalte: Mech Days In Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.MECH_DAYS_IN_WRK], Zahl)
- Spalte: Avr Inv Per Mech ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_INV_PER_MECH], Zahl)
- Spalte: Avr Inv Sold Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_INV_SOLD_HOURS], Zahl)
- Spalte: Avr Wrk Sold Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_SOLD_HOURS], Zahl)
- Spalte: Avr Wrk Lost Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_LOST_HOURS], Zahl)
- Spalte: Kit Efficiency Pct ([O21.OPTIMA.import.SERVICE_2000_FILE.KIT_EFFICIENCY_PCT], Zahl)
- Spalte: Open Orders ([O21.OPTIMA.import.SERVICE_2000_FILE.OPEN_ORDERS], Zahl)
- Spalte: Open Part Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.OPEN_PART_WRK_AMT], Zahl)
- Spalte: Open Misc Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.OPEN_MISC_AMT], Zahl)
- Spalte: Wholesale Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.WHOLESALE_AMT], Zahl)
- Spalte: Detailsale Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.DETAILSALE_AMT], Zahl)
- Spalte: Part Workshop Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.PART_WORKSHOP_AMT], Zahl)
- Spalte: Total Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.TOTAL_PART_AMT], Zahl)
- Spalte: O Quality Inspect ([O21.OPTIMA.import.SERVICE_2000_FILE.O_QUALITY_INSPECT], Zahl)
- Spalte: Invoice Explained ([O21.OPTIMA.import.SERVICE_2000_FILE.INVOICE_EXPLAINED], Zahl)
- Spalte: O Pre Ordered ([O21.OPTIMA.import.SERVICE_2000_FILE.O_PRE_ORDERED], Zahl)
- Spalte: Inv Ext Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_EXT_WRK_AMT], Zahl)
- Spalte: Inv Cl Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_CL_WRK_AMT], Zahl)
- Spalte: Inv Int Wrk Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_INT_WRK_AMT], Zahl)
- Spalte: Inv Ext Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_EXT_PART_AMT], Zahl)
- Spalte: Inv Cl Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_CL_PART_AMT], Zahl)
- Spalte: Inv Int Part Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_INT_PART_AMT], Zahl)
- Spalte: Inv Ext Used Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_EXT_USED_HOURS], Zahl)
- Spalte: Inv Cl Used Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_CL_USED_HOURS], Zahl)
- Spalte: Int Used Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.INT_USED_HOURS], Zahl)
- Spalte: Hours All ([O21.OPTIMA.import.SERVICE_2000_FILE.HOURS_ALL], Zahl)
- Spalte: Wrk Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_HOURS], Zahl)
- Spalte: Not Inv Hours ([O21.OPTIMA.import.SERVICE_2000_FILE.NOT_INV_HOURS], Zahl)
- Spalte: Turnover Factor 2 ([O21.OPTIMA.import.SERVICE_2000_FILE.TURNOVER_FACTOR_2], Zahl)
- Spalte: Avr Rate Inv ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_RATE_INV], Zahl)
- Spalte: Avr Rate Capacity ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_RATE_CAPACITY], Zahl)
- Spalte: Avr Rate Wrk ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_RATE_WRK], Zahl)
- Spalte: Avr Rate All ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_RATE_ALL], Zahl)
- Spalte: Avr Turnover Mech ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_TURNOVER_MECH], Zahl)
- Spalte: Additional P Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.ADDITIONAL_P_AMT], Zahl)
- Spalte: Additional W Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.ADDITIONAL_W_AMT], Zahl)
- Spalte: Additional M Amt ([O21.OPTIMA.import.SERVICE_2000_FILE.ADDITIONAL_M_AMT], Zahl)
- Spalte: Wrk Capacity Eff Int ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_CAPACITY_EFF_INT], Zahl)
- Spalte: Wrk Capacity Eff Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_CAPACITY_EFF_EXACT], Zahl)
- Spalte: Used Hours Inv Int ([O21.OPTIMA.import.SERVICE_2000_FILE.USED_HOURS_INV_INT], Zahl)
- Spalte: Used Hours Inv Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.USED_HOURS_INV_EXACT], Zahl)
- Spalte: Invoiced Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.INVOICED_HOURS_INT], Zahl)
- Spalte: Inv Kit Wrk Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_KIT_WRK_HOURS_INT], Zahl)
- Spalte: Inv Ext Used Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_EXT_USED_HOURS_INT], Zahl)
- Spalte: Inv Ext Used Hours Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_EXT_USED_HOURS_EXACT], Zahl)
- Spalte: Inv Cl Used Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_CL_USED_HOURS_INT], Zahl)
- Spalte: Inv Cl Used Hours Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.INV_CL_USED_HOURS_EXACT], Zahl)
- Spalte: Int Used Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.INT_USED_HOURS_INT], Zahl)
- Spalte: Int Used Hours Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.INT_USED_HOURS_EXACT], Zahl)
- Spalte: Hours All Int ([O21.OPTIMA.import.SERVICE_2000_FILE.HOURS_ALL_INT], Zahl)
- Spalte: Hours All Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.HOURS_ALL_EXACT], Zahl)
- Spalte: Wrk Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_HOURS_INT], Zahl)
- Spalte: Wrk Hours Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.WRK_HOURS_EXACT], Zahl)
- Spalte: Not Inv Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.NOT_INV_HOURS_INT], Zahl)
- Spalte: Not Inv Hours Exact ([O21.OPTIMA.import.SERVICE_2000_FILE.NOT_INV_HOURS_EXACT], Zahl)
- Spalte: Make Time Unit ([O21.OPTIMA.import.SERVICE_2000_FILE.MAKE_TIME_UNIT], Zeichenkette)
- Spalte: Avr Inv Sold Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_INV_SOLD_HOURS_INT], Zahl)
- Spalte: Avr Wrk Sold Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_SOLD_HOURS_INT], Zahl)
- Spalte: Avr Wrk Lost Hours Int ([O21.OPTIMA.import.SERVICE_2000_FILE.AVR_WRK_LOST_HOURS_INT], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.SERVICE_2000_FILE.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.SERVICE_2000_FILE.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.SERVICE_2000_FILE.UNIQUE_IDENT], Zahl)
- Ordner: Time Control End
- Spalte: Person Group ([O21.OPTIMA.import.TIME_CONTROL_END.PERSON_GROUP], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.TIME_CONTROL_END.PERSON_NUMBER], Zeichenkette)
- Spalte: Work Trans Date ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_TRANS_DATE], Datum/Uhrzeit)
- Spalte: Work Start Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_START_TIME], Zahl)
- Spalte: Order Number ([O21.OPTIMA.import.TIME_CONTROL_END.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.TIME_CONTROL_END.LINE_NUMBER], Zahl)
- Spalte: Work State Code ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_STATE_CODE], Zeichenkette)
- Spalte: Handler ([O21.OPTIMA.import.TIME_CONTROL_END.HANDLER], Zeichenkette)
- Spalte: Work Act Code ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_ACT_CODE], Zeichenkette)
- Spalte: Work Act Text ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_ACT_TEXT], Zeichenkette)
- Spalte: Work End Date ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_END_DATE], Datum/Uhrzeit)
- Spalte: Work End Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_END_TIME], Zahl)
- Spalte: Repair Code ([O21.OPTIMA.import.TIME_CONTROL_END.REPAIR_CODE], Zeichenkette)
- Spalte: Repair Name ([O21.OPTIMA.import.TIME_CONTROL_END.REPAIR_NAME], Zeichenkette)
- Spalte: Work Order Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_ORDER_TIME], Zahl)
- Spalte: Work Used Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_USED_TIME], Zahl)
- Spalte: Work Invoiced Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_INVOICED_TIME], Zahl)
- Spalte: Work Estim Time ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_ESTIM_TIME], Zahl)
- Spalte: Work Print Invoice ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_PRINT_INVOICE], Zeichenkette)
- Spalte: Work Salesprice ([O21.OPTIMA.import.TIME_CONTROL_END.WORK_SALESPRICE], Zahl)
- Spalte: Daytime Start 1 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_START_1], Zahl)
- Spalte: Daytime End 1 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_END_1], Zahl)
- Spalte: Daytime Start 2 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_START_2], Zahl)
- Spalte: Daytime End 2 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_END_2], Zahl)
- Spalte: Daytime Start 3 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_START_3], Zahl)
- Spalte: Daytime End 3 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_END_3], Zahl)
- Spalte: Daytime Start 4 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_START_4], Zahl)
- Spalte: Daytime End 4 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_END_4], Zahl)
- Spalte: Daytime Start 5 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_START_5], Zahl)
- Spalte: Daytime End 5 ([O21.OPTIMA.import.TIME_CONTROL_END.DAYTIME_END_5], Zahl)
- Spalte: Extracted ([O21.OPTIMA.import.TIME_CONTROL_END.EXTRACTED], Zeichenkette)
- Spalte: Reduce Time ([O21.OPTIMA.import.TIME_CONTROL_END.REDUCE_TIME], Zahl)
- Spalte: Program ([O21.OPTIMA.import.TIME_CONTROL_END.PROGRAM], Zeichenkette)
- Spalte: Clock In Program ([O21.OPTIMA.import.TIME_CONTROL_END.CLOCK_IN_PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.TIME_CONTROL_END.FUNCTION_CODE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.TIME_CONTROL_END.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.TIME_CONTROL_END.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.TIME_CONTROL_END.UNIQUE_IDENT], Zahl)
- Ordner: Time Control Open
- Spalte: Person Group ([O21.OPTIMA.import.TIME_CONTROL_OPEN.PERSON_GROUP], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.TIME_CONTROL_OPEN.PERSON_NUMBER], Zeichenkette)
- Spalte: Work Trans Date ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_TRANS_DATE], Datum/Uhrzeit)
- Spalte: Work Start Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_START_TIME], Zahl)
- Spalte: Order Number ([O21.OPTIMA.import.TIME_CONTROL_OPEN.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.TIME_CONTROL_OPEN.LINE_NUMBER], Zahl)
- Spalte: Work State Code ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_STATE_CODE], Zeichenkette)
- Spalte: Handler ([O21.OPTIMA.import.TIME_CONTROL_OPEN.HANDLER], Zeichenkette)
- Spalte: Work Act Code ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_ACT_CODE], Zeichenkette)
- Spalte: Work Act Text ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_ACT_TEXT], Zeichenkette)
- Spalte: Work End Date ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_END_DATE], Datum/Uhrzeit)
- Spalte: Work End Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_END_TIME], Zahl)
- Spalte: Repair Code ([O21.OPTIMA.import.TIME_CONTROL_OPEN.REPAIR_CODE], Zeichenkette)
- Spalte: Repair Name ([O21.OPTIMA.import.TIME_CONTROL_OPEN.REPAIR_NAME], Zeichenkette)
- Spalte: Work Order Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_ORDER_TIME], Zahl)
- Spalte: Work Used Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_USED_TIME], Zahl)
- Spalte: Work Invoiced Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_INVOICED_TIME], Zahl)
- Spalte: Work Estim Time ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_ESTIM_TIME], Zahl)
- Spalte: Work Print Invoice ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_PRINT_INVOICE], Zeichenkette)
- Spalte: Work Salesprice ([O21.OPTIMA.import.TIME_CONTROL_OPEN.WORK_SALESPRICE], Zahl)
- Spalte: Daytime Start 1 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_START_1], Zahl)
- Spalte: Daytime End 1 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_END_1], Zahl)
- Spalte: Daytime Start 2 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_START_2], Zahl)
- Spalte: Daytime End 2 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_END_2], Zahl)
- Spalte: Daytime Start 3 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_START_3], Zahl)
- Spalte: Daytime End 3 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_END_3], Zahl)
- Spalte: Daytime Start 4 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_START_4], Zahl)
- Spalte: Daytime End 4 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_END_4], Zahl)
- Spalte: Daytime Start 5 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_START_5], Zahl)
- Spalte: Daytime End 5 ([O21.OPTIMA.import.TIME_CONTROL_OPEN.DAYTIME_END_5], Zahl)
- Spalte: Program ([O21.OPTIMA.import.TIME_CONTROL_OPEN.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.TIME_CONTROL_OPEN.FUNCTION_CODE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.TIME_CONTROL_OPEN.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.TIME_CONTROL_OPEN.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.TIME_CONTROL_OPEN.UNIQUE_IDENT], Zahl)
- Ordner: Time Control Trans
- Spalte: Person Group ([O21.OPTIMA.import.TIME_CONTROL_TRANS.PERSON_GROUP], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.TIME_CONTROL_TRANS.PERSON_NUMBER], Zeichenkette)
- Spalte: Work Trans Date ([O21.OPTIMA.import.TIME_CONTROL_TRANS.WORK_TRANS_DATE], Datum/Uhrzeit)
- Spalte: Work Start Time ([O21.OPTIMA.import.TIME_CONTROL_TRANS.WORK_START_TIME], Zahl)
- Spalte: Work End Time ([O21.OPTIMA.import.TIME_CONTROL_TRANS.WORK_END_TIME], Zahl)
- Spalte: Order Number ([O21.OPTIMA.import.TIME_CONTROL_TRANS.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.TIME_CONTROL_TRANS.LINE_NUMBER], Zahl)
- Spalte: Repair Code ([O21.OPTIMA.import.TIME_CONTROL_TRANS.REPAIR_CODE], Zeichenkette)
- Spalte: Work Act Code ([O21.OPTIMA.import.TIME_CONTROL_TRANS.WORK_ACT_CODE], Zeichenkette)
- Spalte: Tmcs Trans Type ([O21.OPTIMA.import.TIME_CONTROL_TRANS.TMCS_TRANS_TYPE], Zeichenkette)
- Spalte: Handler ([O21.OPTIMA.import.TIME_CONTROL_TRANS.HANDLER], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.TIME_CONTROL_TRANS.FUNCTION_CODE], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.TIME_CONTROL_TRANS.PROGRAM], Zeichenkette)
- Spalte: Unique Ident ([O21.OPTIMA.import.TIME_CONTROL_TRANS.UNIQUE_IDENT], Zahl)
- Spalte: Timestamp ([O21.OPTIMA.import.TIME_CONTROL_TRANS.timestamp], Unbekannt)
- Spalte: Conv Flag ([O21.OPTIMA.import.TIME_CONTROL_TRANS.CONV_FLAG], Zeichenkette)
- Ordner: Work Line Status
- Spalte: Work Status ([O21.OPTIMA.import.WORK_LINE_STATUS.WORK_STATUS], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.WORK_LINE_STATUS.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.WORK_LINE_STATUS.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.WORK_LINE_STATUS.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.WORK_LINE_STATUS.FUNCTION_CODE], Zeichenkette)
- Spalte: Work Status Text ([O21.OPTIMA.import.WORK_LINE_STATUS.WORK_STATUS_TEXT], Zeichenkette)
- Spalte: Work Finished Mark ([O21.OPTIMA.import.WORK_LINE_STATUS.WORK_FINISHED_MARK], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.WORK_LINE_STATUS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.WORK_LINE_STATUS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.WORK_LINE_STATUS.UNIQUE_IDENT], Zahl)
- Ordner: Work Units
- Spalte: Time Unit ([O21.OPTIMA.import.WORK_UNITS.TIME_UNIT], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.WORK_UNITS.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.WORK_UNITS.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.WORK_UNITS.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.WORK_UNITS.FUNCTION_CODE], Zeichenkette)
- Spalte: Unit Desc ([O21.OPTIMA.import.WORK_UNITS.UNIT_DESC], Zeichenkette)
- Spalte: Aw Type ([O21.OPTIMA.import.WORK_UNITS.AW_TYPE], Zeichenkette)
- Spalte: Aw Segments ([O21.OPTIMA.import.WORK_UNITS.AW_SEGMENTS], Zahl)
- Spalte: Rounding ([O21.OPTIMA.import.WORK_UNITS.ROUNDING], Zeichenkette)
- Spalte: Sum Time Before Aw Calc ([O21.OPTIMA.import.WORK_UNITS.SUM_TIME_BEFORE_AW_CALC], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.WORK_UNITS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.WORK_UNITS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.WORK_UNITS.UNIQUE_IDENT], Zahl)
- Ordner: Workshop Order Split
- Spalte: Order Number ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.LINE_NUMBER], Zahl)
- Spalte: Workshop Team ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.WORKSHOP_TEAM], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.PERSON_NUMBER], Zeichenkette)
- Spalte: Start Date ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.START_DATE], Datum/Uhrzeit)
- Spalte: End Date ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.END_DATE], Datum/Uhrzeit)
- Spalte: Est Time ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.EST_TIME], Zahl)
- Spalte: Transact Date ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.FUNCTION_CODE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.WORKSHOP_ORDER_SPLIT.UNIQUE_IDENT], Zahl)
- Ordner: Workshop Planning
- Spalte: Transact Date ([O21.OPTIMA.import.WORKSHOP_PLANNING.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.WORKSHOP_PLANNING.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.WORKSHOP_PLANNING.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.WORKSHOP_PLANNING.FUNCTION_CODE], Zeichenkette)
- Spalte: Color Not Started ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_NOT_STARTED], Zahl)
- Spalte: Color Not Started Wait ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_NOT_STARTED_WAIT], Zahl)
- Spalte: Color Jobcard Printed ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_JOBCARD_PRINTED], Zahl)
- Spalte: Color In Work ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_IN_WORK], Zahl)
- Spalte: Color In Work Wait ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_IN_WORK_WAIT], Zahl)
- Spalte: Color Suspended ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_SUSPENDED], Zahl)
- Spalte: Color Finished ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_FINISHED], Zahl)
- Spalte: Color Finished Wait ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_FINISHED_WAIT], Zahl)
- Spalte: Color Invoiced ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_INVOICED], Zahl)
- Spalte: Color Quality Inspected ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_QUALITY_INSPECTED], Zahl)
- Spalte: Color Employee Clocked In ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_EMPLOYEE_CLOCKED_IN], Zahl)
- Spalte: Color Employee Not Present ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_EMPLOYEE_NOT_PRESENT], Zahl)
- Spalte: Color Team Capacity Used ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_TEAM_CAPACITY_USED], Zahl)
- Spalte: Color Team Capacity Free ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_TEAM_CAPACITY_FREE], Zahl)
- Spalte: Color Off Time ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_OFF_TIME], Zahl)
- Spalte: Color Work Time ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_WORK_TIME], Zahl)
- Spalte: Color Break Time ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_BREAK_TIME], Zahl)
- Spalte: Color App Fore ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_APP_FORE], Zahl)
- Spalte: Color App Back ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_APP_BACK], Zahl)
- Spalte: Color App Fore Wait ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_APP_FORE_WAIT], Zahl)
- Spalte: Color App Back Wait ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_APP_BACK_WAIT], Zahl)
- Spalte: Color Order Created Fore ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_ORDER_CREATED_FORE], Zahl)
- Spalte: Color Order Created Back ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_ORDER_CREATED_BACK], Zahl)
- Spalte: Color Free Capacity ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_FREE_CAPACITY], Zahl)
- Spalte: Color Used Capacity ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_USED_CAPACITY], Zahl)
- Spalte: Color Overbooked Capacity ([O21.OPTIMA.import.WORKSHOP_PLANNING.COLOR_OVERBOOKED_CAPACITY], Zahl)
- Spalte: Timer Refresh ([O21.OPTIMA.import.WORKSHOP_PLANNING.TIMER_REFRESH], Zahl)
- Spalte: Only Show Teams ([O21.OPTIMA.import.WORKSHOP_PLANNING.ONLY_SHOW_TEAMS], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.WORKSHOP_PLANNING.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.WORKSHOP_PLANNING.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.WORKSHOP_PLANNING.UNIQUE_IDENT], Zahl)
- Ordner: Workshop Teams
- Spalte: Workshop Team ([O21.OPTIMA.import.WORKSHOP_TEAMS.WORKSHOP_TEAM], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.WORKSHOP_TEAMS.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.WORKSHOP_TEAMS.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.WORKSHOP_TEAMS.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.WORKSHOP_TEAMS.FUNCTION_CODE], Zeichenkette)
- Spalte: Description ([O21.OPTIMA.import.WORKSHOP_TEAMS.DESCRIPTION], Zeichenkette)
- Spalte: Work Leader Group ([O21.OPTIMA.import.WORKSHOP_TEAMS.WORK_LEADER_GROUP], Zeichenkette)
- Spalte: Capacity Rule ([O21.OPTIMA.import.WORKSHOP_TEAMS.CAPACITY_RULE], Zeichenkette)
- Spalte: Capacity ([O21.OPTIMA.import.WORKSHOP_TEAMS.CAPACITY], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.WORKSHOP_TEAMS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.WORKSHOP_TEAMS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.WORKSHOP_TEAMS.UNIQUE_IDENT], Zahl)
- Ordner: Order Link Ext
- 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: Month Work Time X
- Ordner: Person Info
- Ordner: Wage Transactions
- Ordner: Service Scheme Header
- Spalte: Scheme No ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.SCHEME_NO], Zahl)
- Spalte: Transact Date ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.FUNCTION_CODE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.MAKE_CD], Zeichenkette)
- Spalte: Description ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.DESCRIPTION], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.SERVICE_SCHEME_HEADER.UNIQUE_IDENT], Zahl)
- Ordner: Service Scheme Menus
- Spalte: Service Schemes Id ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.SERVICE_SCHEMES_ID], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.LINE_NUMBER], Zahl)
- Spalte: Transact Date ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.FUNCTION_CODE], Zeichenkette)
- Spalte: Menu Group ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.MENU_GROUP], Zeichenkette)
- Spalte: Menu Number ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.MENU_NUMBER], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.SERVICE_SCHEME_MENUS.UNIQUE_IDENT], Zahl)
- Ordner: Service Schemes
- Spalte: Service Scheme Header Id ([O21.OPTIMA.import.SERVICE_SCHEMES.SERVICE_SCHEME_HEADER_ID], Zahl)
- Spalte: Guiding Text No ([O21.OPTIMA.import.SERVICE_SCHEMES.GUIDING_TEXT_NO], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.SERVICE_SCHEMES.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.SERVICE_SCHEMES.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.SERVICE_SCHEMES.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.SERVICE_SCHEMES.FUNCTION_CODE], Zeichenkette)
- Spalte: Field No ([O21.OPTIMA.import.SERVICE_SCHEMES.FIELD_NO], Zahl)
- Spalte: Guiding Text ([O21.OPTIMA.import.SERVICE_SCHEMES.GUIDING_TEXT], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.SERVICE_SCHEMES.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.SERVICE_SCHEMES.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.SERVICE_SCHEMES.UNIQUE_IDENT], Zahl)
- Ordner: Person Info Nr.2
- Spalte: Person Group ([O21.OPTIMA.import.PERSON_INFO.PERSON_GROUP], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.PERSON_INFO.PERSON_NUMBER], Zeichenkette)
- Spalte: Name ([O21.OPTIMA.import.PERSON_INFO.NAME], Zeichenkette)
- Spalte: Pers Department ([O21.OPTIMA.import.PERSON_INFO.PERS_DEPARTMENT], Zeichenkette)
- Spalte: Pers State Code ([O21.OPTIMA.import.PERSON_INFO.PERS_STATE_CODE], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.PERSON_INFO.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.PERSON_INFO.HANDLER], Zeichenkette)
- Spalte: Pers Person Code ([O21.OPTIMA.import.PERSON_INFO.PERS_PERSON_CODE], Zeichenkette)
- Spalte: Pers Street Addr ([O21.OPTIMA.import.PERSON_INFO.PERS_STREET_ADDR], Zeichenkette)
- Spalte: Pers Mail Addr ([O21.OPTIMA.import.PERSON_INFO.PERS_MAIL_ADDR], Zeichenkette)
- Spalte: Pers Zipcode ([O21.OPTIMA.import.PERSON_INFO.PERS_ZIPCODE], Zeichenkette)
- Spalte: Pers Phone ([O21.OPTIMA.import.PERSON_INFO.PERS_PHONE], Zeichenkette)
- Spalte: Pers Sex ([O21.OPTIMA.import.PERSON_INFO.PERS_SEX], Zeichenkette)
- Spalte: Pers Task ([O21.OPTIMA.import.PERSON_INFO.PERS_TASK], Zeichenkette)
- Spalte: Pers Birth Place ([O21.OPTIMA.import.PERSON_INFO.PERS_BIRTH_PLACE], Zeichenkette)
- Spalte: Pers Bank ([O21.OPTIMA.import.PERSON_INFO.PERS_BANK], Zeichenkette)
- Spalte: Pers Acct Nr ([O21.OPTIMA.import.PERSON_INFO.PERS_ACCT_NR], Zeichenkette)
- Spalte: Pers Job Start ([O21.OPTIMA.import.PERSON_INFO.PERS_JOB_START], Datum/Uhrzeit)
- Spalte: Pers Job End ([O21.OPTIMA.import.PERSON_INFO.PERS_JOB_END], Datum/Uhrzeit)
- Spalte: Pers Mechno Group ([O21.OPTIMA.import.PERSON_INFO.PERS_MECHNO_GROUP], Zeichenkette)
- Spalte: Pers Union Start ([O21.OPTIMA.import.PERSON_INFO.PERS_UNION_START], Datum/Uhrzeit)
- Spalte: Pers Mm Hours ([O21.OPTIMA.import.PERSON_INFO.PERS_MM_HOURS], Zahl)
- Spalte: Pers Act Code ([O21.OPTIMA.import.PERSON_INFO.PERS_ACT_CODE], Zeichenkette)
- Spalte: Pers Personal No ([O21.OPTIMA.import.PERSON_INFO.PERS_PERSONAL_NO], Zahl)
- Spalte: Pers Overwork ([O21.OPTIMA.import.PERSON_INFO.PERS_OVERWORK], Zeichenkette)
- Spalte: Pers Eff Aw Div ([O21.OPTIMA.import.PERSON_INFO.PERS_EFF_AW_DIV], Zahl)
- Spalte: Overwork Time ([O21.OPTIMA.import.PERSON_INFO.OVERWORK_TIME], Zahl)
- Spalte: Addr 3 ([O21.OPTIMA.import.PERSON_INFO.ADDR_3], Zeichenkette)
- Spalte: County ([O21.OPTIMA.import.PERSON_INFO.COUNTY], Zeichenkette)
- Spalte: Def Day Activity ([O21.OPTIMA.import.PERSON_INFO.DEF_DAY_ACTIVITY], Zeichenkette)
- Spalte: Def Job Order Activity ([O21.OPTIMA.import.PERSON_INFO.DEF_JOB_ORDER_ACTIVITY], Zeichenkette)
- Spalte: Def Job Activity ([O21.OPTIMA.import.PERSON_INFO.DEF_JOB_ACTIVITY], Zeichenkette)
- Spalte: Person Number Num ([O21.OPTIMA.import.PERSON_INFO.PERSON_NUMBER_NUM], Zahl)
- Spalte: Workshop Team ([O21.OPTIMA.import.PERSON_INFO.WORKSHOP_TEAM], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.PERSON_INFO.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.PERSON_INFO.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.PERSON_INFO.UNIQUE_IDENT], Zahl)
- Ordner: Customer Det
- Ordner: Area
- Ordner: At Operations
- Ordner: Repair Mnemonics
- Spalte: Repair Code ([O21.OPTIMA.import.REPAIR_MNEMONICS.REPAIR_CODE], Zeichenkette)
- Spalte: Line Type Gm ([O21.OPTIMA.import.REPAIR_MNEMONICS.LINE_TYPE_GM], Zeichenkette)
- Spalte: Line Number Gm ([O21.OPTIMA.import.REPAIR_MNEMONICS.LINE_NUMBER_GM], Zahl)
- Spalte: State Code Repair ([O21.OPTIMA.import.REPAIR_MNEMONICS.STATE_CODE_REPAIR], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.REPAIR_MNEMONICS.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.REPAIR_MNEMONICS.HANDLER], Zeichenkette)
- Spalte: Description 1 ([O21.OPTIMA.import.REPAIR_MNEMONICS.DESCRIPTION_1], Zeichenkette)
- Spalte: Description 2 ([O21.OPTIMA.import.REPAIR_MNEMONICS.DESCRIPTION_2], Zeichenkette)
- Spalte: Approval Code Gm ([O21.OPTIMA.import.REPAIR_MNEMONICS.APPROVAL_CODE_GM], Zeichenkette)
- Spalte: Mnemonics Code 1 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_CODE_1], Zeichenkette)
- Spalte: Mnemonics Name 1 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_NAME_1], Zeichenkette)
- Spalte: Mnemonics Code 2 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_CODE_2], Zeichenkette)
- Spalte: Mnemonics Name 2 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_NAME_2], Zeichenkette)
- Spalte: Mnemonics Code 3 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_CODE_3], Zeichenkette)
- Spalte: Mnemonics Name 3 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_NAME_3], Zeichenkette)
- Spalte: Mnemonics Code 4 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_CODE_4], Zeichenkette)
- Spalte: Mnemonics Name 4 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_NAME_4], Zeichenkette)
- Spalte: Mnemonics Code 5 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_CODE_5], Zeichenkette)
- Spalte: Mnemonics Name 5 ([O21.OPTIMA.import.REPAIR_MNEMONICS.MNEMONICS_NAME_5], Zeichenkette)
- Spalte: Claim Hours ([O21.OPTIMA.import.REPAIR_MNEMONICS.CLAIM_HOURS], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.REPAIR_MNEMONICS.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.REPAIR_MNEMONICS.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.REPAIR_MNEMONICS.UNIQUE_IDENT], Zahl)
- Ordner: Month Work Time X Nr.2
- Spalte: Work Leader Group ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WORK_LEADER_GROUP], Zeichenkette)
- Spalte: Person Number ([O21.OPTIMA.import.MONTH_WORK_TIME_X.PERSON_NUMBER], Zeichenkette)
- Spalte: Year Work Time ([O21.OPTIMA.import.MONTH_WORK_TIME_X.YEAR_WORK_TIME], Zahl)
- Spalte: Month Work Time ([O21.OPTIMA.import.MONTH_WORK_TIME_X.MONTH_WORK_TIME], Zahl)
- Spalte: State Code Plan ([O21.OPTIMA.import.MONTH_WORK_TIME_X.STATE_CODE_PLAN], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.MONTH_WORK_TIME_X.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.MONTH_WORK_TIME_X.HANDLER], Zeichenkette)
- Spalte: Day Time Table 1 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_1], Zeichenkette)
- Spalte: Day Time Table 2 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_2], Zeichenkette)
- Spalte: Day Time Table 3 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_3], Zeichenkette)
- Spalte: Day Time Table 4 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_4], Zeichenkette)
- Spalte: Day Time Table 5 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_5], Zeichenkette)
- Spalte: Day Time Table 6 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_6], Zeichenkette)
- Spalte: Day Time Table 7 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_7], Zeichenkette)
- Spalte: Day Time Table 8 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_8], Zeichenkette)
- Spalte: Day Time Table 9 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_9], Zeichenkette)
- Spalte: Day Time Table 10 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_10], Zeichenkette)
- Spalte: Day Time Table 11 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_11], Zeichenkette)
- Spalte: Day Time Table 12 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_12], Zeichenkette)
- Spalte: Day Time Table 13 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_13], Zeichenkette)
- Spalte: Day Time Table 14 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_14], Zeichenkette)
- Spalte: Day Time Table 15 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_15], Zeichenkette)
- Spalte: Day Time Table 16 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_16], Zeichenkette)
- Spalte: Day Time Table 17 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_17], Zeichenkette)
- Spalte: Day Time Table 18 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_18], Zeichenkette)
- Spalte: Day Time Table 19 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_19], Zeichenkette)
- Spalte: Day Time Table 20 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_20], Zeichenkette)
- Spalte: Day Time Table 21 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_21], Zeichenkette)
- Spalte: Day Time Table 22 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_22], Zeichenkette)
- Spalte: Day Time Table 23 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_23], Zeichenkette)
- Spalte: Day Time Table 24 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_24], Zeichenkette)
- Spalte: Day Time Table 25 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_25], Zeichenkette)
- Spalte: Day Time Table 26 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_26], Zeichenkette)
- Spalte: Day Time Table 27 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_27], Zeichenkette)
- Spalte: Day Time Table 28 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_28], Zeichenkette)
- Spalte: Day Time Table 29 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_29], Zeichenkette)
- Spalte: Day Time Table 30 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_30], Zeichenkette)
- Spalte: Day Time Table 31 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.DAY_TIME_TABLE_31], Zeichenkette)
- Spalte: Week Number 1 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_1], Zahl)
- Spalte: Calendar Type 1 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_1], Zahl)
- Spalte: Week Number 2 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_2], Zahl)
- Spalte: Calendar Type 2 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_2], Zahl)
- Spalte: Week Number 3 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_3], Zahl)
- Spalte: Calendar Type 3 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_3], Zahl)
- Spalte: Week Number 4 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_4], Zahl)
- Spalte: Calendar Type 4 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_4], Zahl)
- Spalte: Week Number 5 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_5], Zahl)
- Spalte: Calendar Type 5 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_5], Zahl)
- Spalte: Week Number 6 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.WEEK_NUMBER_6], Zahl)
- Spalte: Calendar Type 6 ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CALENDAR_TYPE_6], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.MONTH_WORK_TIME_X.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.MONTH_WORK_TIME_X.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.MONTH_WORK_TIME_X.UNIQUE_IDENT], Zahl)
- Ordner: Fhg Detail
- Spalte: Dealer No Imp ([O21.OPTIMA.import.FHG_DETAIL.DEALER_NO_IMP], Zeichenkette)
- Spalte: Fhg Number ([O21.OPTIMA.import.FHG_DETAIL.FHG_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.FHG_DETAIL.LINE_NUMBER], Zahl)
- Spalte: Line Type ([O21.OPTIMA.import.FHG_DETAIL.LINE_TYPE], Zeichenkette)
- Spalte: Prod Code ([O21.OPTIMA.import.FHG_DETAIL.PROD_CODE], Zeichenkette)
- Spalte: Make Cd ([O21.OPTIMA.import.FHG_DETAIL.MAKE_CD], Zeichenkette)
- Spalte: Repair Code ([O21.OPTIMA.import.FHG_DETAIL.REPAIR_CODE], Zeichenkette)
- Spalte: Prod Code Misc ([O21.OPTIMA.import.FHG_DETAIL.PROD_CODE_MISC], Zeichenkette)
- Spalte: Quantity ([O21.OPTIMA.import.FHG_DETAIL.QUANTITY], Zahl)
- Spalte: Hours ([O21.OPTIMA.import.FHG_DETAIL.HOURS], Zahl)
- Spalte: Quantity Misc ([O21.OPTIMA.import.FHG_DETAIL.QUANTITY_MISC], Zahl)
- Spalte: Deal Claim Sales Price ([O21.OPTIMA.import.FHG_DETAIL.DEAL_CLAIM_SALES_PRICE], Zahl)
- Spalte: Deal Claim Price ([O21.OPTIMA.import.FHG_DETAIL.DEAL_CLAIM_PRICE], Zahl)
- Spalte: Deal Credit Sales Price ([O21.OPTIMA.import.FHG_DETAIL.DEAL_CREDIT_SALES_PRICE], Zahl)
- Spalte: Deal Credit Price ([O21.OPTIMA.import.FHG_DETAIL.DEAL_CREDIT_PRICE], Zahl)
- Spalte: Detail Text ([O21.OPTIMA.import.FHG_DETAIL.DETAIL_TEXT], Zeichenkette)
- Spalte: Text 200 ([O21.OPTIMA.import.FHG_DETAIL.TEXT_200], Zeichenkette)
- Spalte: Flat Search 2 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_2], Zeichenkette)
- Spalte: Flat Search 3 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_3], Zeichenkette)
- Spalte: Flat Search 4 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_4], Zeichenkette)
- Spalte: Flat Search 5 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_5], Zeichenkette)
- Spalte: Flat Search 6 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_6], Zeichenkette)
- Spalte: Flat Search 7 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_7], Zeichenkette)
- Spalte: Flat Search 8 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_8], Zeichenkette)
- Spalte: Flat Search 9 ([O21.OPTIMA.import.FHG_DETAIL.FLAT_SEARCH_9], Zeichenkette)
- Spalte: Transact Date ([O21.OPTIMA.import.FHG_DETAIL.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.FHG_DETAIL.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.FHG_DETAIL.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.FHG_DETAIL.FUNCTION_CODE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.FHG_DETAIL.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.FHG_DETAIL.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.FHG_DETAIL.UNIQUE_IDENT], Zahl)
- Spalte: Imp Claim Price ([O21.OPTIMA.import.FHG_DETAIL.IMP_CLAIM_PRICE], Zahl)
- Spalte: Imp Claim Sales Price ([O21.OPTIMA.import.FHG_DETAIL.IMP_CLAIM_SALES_PRICE], Zahl)
- Ordner: Fhg Header
- Spalte: Dealer No Imp ([O21.OPTIMA.import.FHG_HEADER.DEALER_NO_IMP], Zeichenkette)
- Spalte: Fhg Number ([O21.OPTIMA.import.FHG_HEADER.FHG_NUMBER], Zahl)
- Spalte: Order Number ([O21.OPTIMA.import.FHG_HEADER.ORDER_NUMBER], Zahl)
- Spalte: Claim Number ([O21.OPTIMA.import.FHG_HEADER.CLAIM_NUMBER], Zahl)
- Spalte: Chassis Number ([O21.OPTIMA.import.FHG_HEADER.CHASSIS_NUMBER], Zeichenkette)
- Spalte: Unit Number ([O21.OPTIMA.import.FHG_HEADER.UNIT_NUMBER], Zeichenkette)
- Spalte: Basis Number ([O21.OPTIMA.import.FHG_HEADER.BASIS_NUMBER], Zeichenkette)
- Spalte: Register Number ([O21.OPTIMA.import.FHG_HEADER.REGISTER_NUMBER], Zeichenkette)
- Spalte: Claim Report No ([O21.OPTIMA.import.FHG_HEADER.CLAIM_REPORT_NO], Zahl)
- Spalte: Fhg Status ([O21.OPTIMA.import.FHG_HEADER.FHG_STATUS], Zeichenkette)
- Spalte: Break Down ([O21.OPTIMA.import.FHG_HEADER.BREAK_DOWN], Zeichenkette)
- Spalte: Retail Customer ([O21.OPTIMA.import.FHG_HEADER.RETAIL_CUSTOMER], Zeichenkette)
- Spalte: Record Trans ([O21.OPTIMA.import.FHG_HEADER.RECORD_TRANS], Zeichenkette)
- Spalte: Fhg Creat Date ([O21.OPTIMA.import.FHG_HEADER.FHG_CREAT_DATE], Datum/Uhrzeit)
- Spalte: Fhg Valid To Date ([O21.OPTIMA.import.FHG_HEADER.FHG_VALID_TO_DATE], Datum/Uhrzeit)
- Spalte: Fhg Determ Date ([O21.OPTIMA.import.FHG_HEADER.FHG_DETERM_DATE], Datum/Uhrzeit)
- Spalte: Trouble Code ([O21.OPTIMA.import.FHG_HEADER.TROUBLE_CODE], Zeichenkette)
- Spalte: Symptom Code ([O21.OPTIMA.import.FHG_HEADER.SYMPTOM_CODE], Zeichenkette)
- Spalte: Pnc Code ([O21.OPTIMA.import.FHG_HEADER.PNC_CODE], Zeichenkette)
- Spalte: Order Date ([O21.OPTIMA.import.FHG_HEADER.ORDER_DATE], Datum/Uhrzeit)
- Spalte: Cl Type ([O21.OPTIMA.import.FHG_HEADER.CL_TYPE], Zeichenkette)
- Spalte: Mileage Imp ([O21.OPTIMA.import.FHG_HEADER.MILEAGE_IMP], Zahl)
- Spalte: Paint Corrosion ([O21.OPTIMA.import.FHG_HEADER.PAINT_CORROSION], Zeichenkette)
- Spalte: Fhg Determ Code ([O21.OPTIMA.import.FHG_HEADER.FHG_DETERM_CODE], Zeichenkette)
- Spalte: Determ Initials1 ([O21.OPTIMA.import.FHG_HEADER.DETERM_INITIALS1], Zeichenkette)
- Spalte: Determ Initials2 ([O21.OPTIMA.import.FHG_HEADER.DETERM_INITIALS2], Zeichenkette)
- Spalte: Determine Text 1 ([O21.OPTIMA.import.FHG_HEADER.DETERMINE_TEXT_1], Zeichenkette)
- Spalte: Determine Text 2 ([O21.OPTIMA.import.FHG_HEADER.DETERMINE_TEXT_2], Zeichenkette)
- Spalte: Pay Percent For Work ([O21.OPTIMA.import.FHG_HEADER.PAY_PERCENT_FOR_WORK], Zahl)
- Spalte: Pay Percent Part ([O21.OPTIMA.import.FHG_HEADER.PAY_PERCENT_PART], Zahl)
- Spalte: Pay Percent Work ([O21.OPTIMA.import.FHG_HEADER.PAY_PERCENT_WORK], Zahl)
- Spalte: Numb Attach Files ([O21.OPTIMA.import.FHG_HEADER.NUMB_ATTACH_FILES], Zahl)
- Spalte: Transact Date ([O21.OPTIMA.import.FHG_HEADER.TRANSACT_DATE], Datum/Uhrzeit)
- Spalte: Handler ([O21.OPTIMA.import.FHG_HEADER.HANDLER], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.FHG_HEADER.PROGRAM], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.FHG_HEADER.FUNCTION_CODE], Zeichenkette)
- Spalte: Conv Flag ([O21.OPTIMA.import.FHG_HEADER.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.FHG_HEADER.timestamp], Unbekannt)
- Spalte: Unique Ident ([O21.OPTIMA.import.FHG_HEADER.UNIQUE_IDENT], Zahl)
- Ordner: Activity
- Spalte: Unique Ident ([O21.OPTIMA.import.ACTIVITY.UNIQUE_IDENT], Zahl)
- Spalte: Activity Category ([O21.OPTIMA.import.ACTIVITY.ACTIVITY_CATEGORY], Zahl)
- Spalte: Handler ([O21.OPTIMA.import.ACTIVITY.HANDLER], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.ACTIVITY.FUNCTION_CODE], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.ACTIVITY.PROGRAM], Zeichenkette)
- Spalte: Transact Date Long ([O21.OPTIMA.import.ACTIVITY.TRANSACT_DATE_LONG], Datum/Uhrzeit)
- Spalte: Activity Code ([O21.OPTIMA.import.ACTIVITY.ACTIVITY_CODE], Zeichenkette)
- Spalte: Activity Description ([O21.OPTIMA.import.ACTIVITY.ACTIVITY_DESCRIPTION], Zeichenkette)
- Spalte: Create Order Line ([O21.OPTIMA.import.ACTIVITY.CREATE_ORDER_LINE], Zahl)
- Spalte: Repno Prefix ([O21.OPTIMA.import.ACTIVITY.REPNO_PREFIX], Zeichenkette)
- Spalte: Present ([O21.OPTIMA.import.ACTIVITY.PRESENT], Zahl)
- Spalte: Sickness ([O21.OPTIMA.import.ACTIVITY.SICKNESS], Zahl)
- Spalte: Only Used By Leaders ([O21.OPTIMA.import.ACTIVITY.ONLY_USED_BY_LEADERS], Zahl)
- Spalte: Idle Order Activity ([O21.OPTIMA.import.ACTIVITY.IDLE_ORDER_ACTIVITY], Zahl)
- Spalte: Activity Obsolete ([O21.OPTIMA.import.ACTIVITY.ACTIVITY_OBSOLETE], Zahl)
- Spalte: Used Time Pay Activity ([O21.OPTIMA.import.ACTIVITY.USED_TIME_PAY_ACTIVITY], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.ACTIVITY.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.ACTIVITY.timestamp], Unbekannt)
- Ordner: Punch
- Spalte: Unique Ident ([O21.OPTIMA.import.PUNCH.UNIQUE_IDENT], Zahl)
- Spalte: Activity Code ([O21.OPTIMA.import.PUNCH.ACTIVITY_CODE], Zeichenkette)
- Spalte: Profile Code ([O21.OPTIMA.import.PUNCH.PROFILE_CODE], Zeichenkette)
- Spalte: Handler ([O21.OPTIMA.import.PUNCH.HANDLER], Zeichenkette)
- Spalte: Function Code ([O21.OPTIMA.import.PUNCH.FUNCTION_CODE], Zeichenkette)
- Spalte: Program ([O21.OPTIMA.import.PUNCH.PROGRAM], Zeichenkette)
- Spalte: Transact Date Long ([O21.OPTIMA.import.PUNCH.TRANSACT_DATE_LONG], Datum/Uhrzeit)
- Spalte: Start Punch Function ([O21.OPTIMA.import.PUNCH.START_PUNCH_FUNCTION], Zeichenkette)
- Spalte: Start Punch Program ([O21.OPTIMA.import.PUNCH.START_PUNCH_PROGRAM], Zeichenkette)
- Spalte: End Punch Function ([O21.OPTIMA.import.PUNCH.END_PUNCH_FUNCTION], Zeichenkette)
- Spalte: End Punch Program ([O21.OPTIMA.import.PUNCH.END_PUNCH_PROGRAM], Zeichenkette)
- Spalte: Done For Department ([O21.OPTIMA.import.PUNCH.DONE_FOR_DEPARTMENT], Zeichenkette)
- Spalte: Done For Work Leader ([O21.OPTIMA.import.PUNCH.DONE_FOR_WORK_LEADER], Zeichenkette)
- Spalte: Ended Punch ([O21.OPTIMA.import.PUNCH.ENDED_PUNCH], Zahl)
- Spalte: Order Number ([O21.OPTIMA.import.PUNCH.ORDER_NUMBER], Zahl)
- Spalte: Line Number ([O21.OPTIMA.import.PUNCH.LINE_NUMBER], Zahl)
- Spalte: Start Date Time ([O21.OPTIMA.import.PUNCH.START_DATE_TIME], Datum/Uhrzeit)
- Spalte: End Date Time ([O21.OPTIMA.import.PUNCH.END_DATE_TIME], Datum/Uhrzeit)
- Spalte: Tmcs Idle Punch ([O21.OPTIMA.import.PUNCH.TMCS_IDLE_PUNCH], Zahl)
- Spalte: Duration Int ([O21.OPTIMA.import.PUNCH.DURATION_INT], Zahl)
- Spalte: Used Time Int ([O21.OPTIMA.import.PUNCH.USED_TIME_INT], Zahl)
- Spalte: Wage Extracted ([O21.OPTIMA.import.PUNCH.WAGE_EXTRACTED], Zahl)
- Spalte: Punch Remark Code ([O21.OPTIMA.import.PUNCH.PUNCH_REMARK_CODE], Zahl)
- Spalte: Remark Accepted ([O21.OPTIMA.import.PUNCH.REMARK_ACCEPTED], Zahl)
- Spalte: Punch Period Start Id ([O21.OPTIMA.import.PUNCH.PUNCH_PERIOD_START_ID], Zahl)
- Spalte: Conv Flag ([O21.OPTIMA.import.PUNCH.CONV_FLAG], Zeichenkette)
- Spalte: Timestamp ([O21.OPTIMA.import.PUNCH.timestamp], Unbekannt)
- Tabellenverbindungen:
- ORDER_HEADER - ORDER_LINE: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.ORDER_NUMBER] = [O21.OPTIMA.import.ORDER_LINE.ORDER_NUMBER] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.ORDER_LINE.CLIENT_DB]
- ORDER_HEADER - VPP25: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.STATUS] = [O21.OPTIMA.import.VPP25.STAT_CODE] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.VPP25.CLIENT_DB]
- ORDER_HEADER - DEPARTMENT_TYPE: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.DEPARTMENT] = [O21.OPTIMA.import.DEPARTMENT_TYPE.DEPARTMENT_TYPE_ID] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.DEPARTMENT_TYPE.CLIENT_DB]
- ORDER_HEADER - VPP43: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.SALESMAN] = [O21.OPTIMA.import.VPP43.SELLER_CODE] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.VPP43.CLIENT_DB]
- ORDER_HEADER - VPP48: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.CUSTOMER_GROUP] = [O21.OPTIMA.import.VPP48.CUSTOMER_GROUP] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.VPP48.CLIENT_DB]
- ORDER_LINE - VPP73: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_LINE.REPAIR_GROUP] = [O21.OPTIMA.import.VPP73.REPAIR_GROUP] UND [O21.OPTIMA.import.ORDER_LINE.MAKE_CD] = [O21.OPTIMA.import.VPP73.MAKE_CD] UND [O21.OPTIMA.import.ORDER_LINE.CLIENT_DB] = [O21.OPTIMA.import.VPP73.CLIENT_DB]
- ORDER_HEADER - GLOBAL_MAKE: Linke offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.MAKE_CD] = [O21.OPTIMA.import.GLOBAL_MAKE.GLOBAL_MAKE_CD] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.GLOBAL_MAKE.CLIENT_DB]
- TIME_CONTROL_END - vPP93: Linke offene Verbindung
- [O21.OPTIMA.import.TIME_CONTROL_END.WORK_ACT_CODE] = [O21.OPTIMA.import.vPP93.ACT_CODE] UND [O21.OPTIMA.import.TIME_CONTROL_END.CLIENT_DB] = [O21.OPTIMA.import.vPP93.CLIENT_DB]
- TIME_CONTROL_END - VPP91: Linke offene Verbindung
- [O21.OPTIMA.import.TIME_CONTROL_END.PERSON_GROUP] = [O21.OPTIMA.import.VPP91.WORK_LEADER_GROUP] UND [O21.OPTIMA.import.TIME_CONTROL_END.CLIENT_DB] = [O21.OPTIMA.import.VPP91.CLIENT_DB]
- TIME_CONTROL_END - VPP43_Mechaniker: Linke offene Verbindung
- [O21.OPTIMA.import.TIME_CONTROL_END.PERSON_NUMBER] = [O21.OPTIMA.import.VPP43.SELLER_CODE] UND [O21.OPTIMA.import.TIME_CONTROL_END.CLIENT_DB] = [O21.OPTIMA.import.VPP43.CLIENT_DB]
- TIME_CONTROL_END - ORDER_LINE: Linke offene Verbindung
- [O21.OPTIMA.import.TIME_CONTROL_END.ORDER_NUMBER] = [O21.OPTIMA.import.ORDER_LINE.ORDER_NUMBER] UND [O21.OPTIMA.import.TIME_CONTROL_END.FUNCTION_CODE] = [O21.OPTIMA.import.ORDER_LINE.FUNCTION_CODE] UND ( RECHTS ( ZAHL-IN-ZEICHENKETTE ( [O21.OPTIMA.import.ORDER_LINE.LINE_NUMBER] ) ; 2 ) = RECHTS ( ZAHL-IN-ZEICHENKETTE ( [O21.OPTIMA.import.TIME_CONTROL_END.LINE_NUMBER] ) ; 2 ) ) UND [O21.OPTIMA.import.ORDER_LINE.CLIENT_DB] = [O21.OPTIMA.import.TIME_CONTROL_END.CLIENT_DB]
- VPP43_Mechaniker - DEPARTMENT_TYPE: Linke offene Verbindung
- [O21.OPTIMA.import.VPP43.SEL_DEPARTMENT] = [O21.OPTIMA.import.DEPARTMENT_TYPE.DEPARTMENT_TYPE_ID] UND [O21.OPTIMA.import.VPP43.CLIENT_DB] = [O21.OPTIMA.import.DEPARTMENT_TYPE.CLIENT_DB]
- VPP43 - PERSON_INFO: Volle offene Verbindung
- [O21.OPTIMA.import.VPP43.SELLER_CODE] = [O21.OPTIMA.import.PERSON_INFO.PERSON_NUMBER] UND [O21.OPTIMA.import.VPP43.CLIENT_DB] = [O21.OPTIMA.import.PERSON_INFO.CLIENT_DB]
- TIME_CONTROL_END - ORDER_HEADER: Linke offene Verbindung
- [O21.OPTIMA.import.TIME_CONTROL_END.ORDER_NUMBER] = [O21.OPTIMA.import.ORDER_HEADER.ORDER_NUMBER] UND [O21.OPTIMA.import.TIME_CONTROL_END.CLIENT_DB] = [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB]
- PUNCH - VPP43_Mechaniker: Linke offene Verbindung
- [O21.OPTIMA.import.PUNCH.PROFILE_CODE] = [O21.OPTIMA.import.VPP43.SELLER_CODE] UND [O21.OPTIMA.import.PUNCH.CLIENT_DB] = [O21.OPTIMA.import.VPP43.CLIENT_DB]
- VPP91 - PUNCH: Rechte offene Verbindung
- [O21.OPTIMA.import.VPP91.WORK_LEADER_GROUP] = [O21.OPTIMA.import.PUNCH.DONE_FOR_WORK_LEADER] UND [O21.OPTIMA.import.VPP91.CLIENT_DB] = [O21.OPTIMA.import.PUNCH.CLIENT_DB]
- PUNCH - ACTIVITY: Linke offene Verbindung
- [O21.OPTIMA.import.PUNCH.ACTIVITY_CODE] = [O21.OPTIMA.import.ACTIVITY.ACTIVITY_CODE] UND [O21.OPTIMA.import.PUNCH.CLIENT_DB] = [O21.OPTIMA.import.ACTIVITY.CLIENT_DB]
- ORDER_HEADER - PUNCH: Rechte offene Verbindung
- [O21.OPTIMA.import.ORDER_HEADER.ORDER_NUMBER] = [O21.OPTIMA.import.PUNCH.ORDER_NUMBER] UND [O21.OPTIMA.import.ORDER_HEADER.CLIENT_DB] = [O21.OPTIMA.import.PUNCH.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
|