12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113 |
- <transformation>
- <info>
- <name>LOAD_DWH_Verkauf</name>
- <description/>
- <extended_description/>
- <trans_version/>
- <trans_type>Normal</trans_type>
- <trans_status>0</trans_status>
- <directory>/3_GC_DWH</directory>
- <parameters>
- </parameters>
- <log>
- <trans-log-table>
- <connection/>
- <schema/>
- <table/>
- <size_limit_lines/>
- <interval/>
- <timeout_days/>
- <field>
- <id>ID_BATCH</id>
- <enabled>Y</enabled>
- <name>ID_BATCH</name>
- </field>
- <field>
- <id>CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>CHANNEL_ID</name>
- </field>
- <field>
- <id>TRANSNAME</id>
- <enabled>Y</enabled>
- <name>TRANSNAME</name>
- </field>
- <field>
- <id>STATUS</id>
- <enabled>Y</enabled>
- <name>STATUS</name>
- </field>
- <field>
- <id>LINES_READ</id>
- <enabled>Y</enabled>
- <name>LINES_READ</name>
- <subject/>
- </field>
- <field>
- <id>LINES_WRITTEN</id>
- <enabled>Y</enabled>
- <name>LINES_WRITTEN</name>
- <subject/>
- </field>
- <field>
- <id>LINES_UPDATED</id>
- <enabled>Y</enabled>
- <name>LINES_UPDATED</name>
- <subject/>
- </field>
- <field>
- <id>LINES_INPUT</id>
- <enabled>Y</enabled>
- <name>LINES_INPUT</name>
- <subject/>
- </field>
- <field>
- <id>LINES_OUTPUT</id>
- <enabled>Y</enabled>
- <name>LINES_OUTPUT</name>
- <subject/>
- </field>
- <field>
- <id>LINES_REJECTED</id>
- <enabled>Y</enabled>
- <name>LINES_REJECTED</name>
- <subject/>
- </field>
- <field>
- <id>ERRORS</id>
- <enabled>Y</enabled>
- <name>ERRORS</name>
- </field>
- <field>
- <id>STARTDATE</id>
- <enabled>Y</enabled>
- <name>STARTDATE</name>
- </field>
- <field>
- <id>ENDDATE</id>
- <enabled>Y</enabled>
- <name>ENDDATE</name>
- </field>
- <field>
- <id>LOGDATE</id>
- <enabled>Y</enabled>
- <name>LOGDATE</name>
- </field>
- <field>
- <id>DEPDATE</id>
- <enabled>Y</enabled>
- <name>DEPDATE</name>
- </field>
- <field>
- <id>REPLAYDATE</id>
- <enabled>Y</enabled>
- <name>REPLAYDATE</name>
- </field>
- <field>
- <id>LOG_FIELD</id>
- <enabled>Y</enabled>
- <name>LOG_FIELD</name>
- </field>
- <field>
- <id>EXECUTING_SERVER</id>
- <enabled>N</enabled>
- <name>EXECUTING_SERVER</name>
- </field>
- <field>
- <id>EXECUTING_USER</id>
- <enabled>N</enabled>
- <name>EXECUTING_USER</name>
- </field>
- <field>
- <id>CLIENT</id>
- <enabled>N</enabled>
- <name>CLIENT</name>
- </field>
- </trans-log-table>
- <perf-log-table>
- <connection/>
- <schema/>
- <table/>
- <interval/>
- <timeout_days/>
- <field>
- <id>ID_BATCH</id>
- <enabled>Y</enabled>
- <name>ID_BATCH</name>
- </field>
- <field>
- <id>SEQ_NR</id>
- <enabled>Y</enabled>
- <name>SEQ_NR</name>
- </field>
- <field>
- <id>LOGDATE</id>
- <enabled>Y</enabled>
- <name>LOGDATE</name>
- </field>
- <field>
- <id>TRANSNAME</id>
- <enabled>Y</enabled>
- <name>TRANSNAME</name>
- </field>
- <field>
- <id>STEPNAME</id>
- <enabled>Y</enabled>
- <name>STEPNAME</name>
- </field>
- <field>
- <id>STEP_COPY</id>
- <enabled>Y</enabled>
- <name>STEP_COPY</name>
- </field>
- <field>
- <id>LINES_READ</id>
- <enabled>Y</enabled>
- <name>LINES_READ</name>
- </field>
- <field>
- <id>LINES_WRITTEN</id>
- <enabled>Y</enabled>
- <name>LINES_WRITTEN</name>
- </field>
- <field>
- <id>LINES_UPDATED</id>
- <enabled>Y</enabled>
- <name>LINES_UPDATED</name>
- </field>
- <field>
- <id>LINES_INPUT</id>
- <enabled>Y</enabled>
- <name>LINES_INPUT</name>
- </field>
- <field>
- <id>LINES_OUTPUT</id>
- <enabled>Y</enabled>
- <name>LINES_OUTPUT</name>
- </field>
- <field>
- <id>LINES_REJECTED</id>
- <enabled>Y</enabled>
- <name>LINES_REJECTED</name>
- </field>
- <field>
- <id>ERRORS</id>
- <enabled>Y</enabled>
- <name>ERRORS</name>
- </field>
- <field>
- <id>INPUT_BUFFER_ROWS</id>
- <enabled>Y</enabled>
- <name>INPUT_BUFFER_ROWS</name>
- </field>
- <field>
- <id>OUTPUT_BUFFER_ROWS</id>
- <enabled>Y</enabled>
- <name>OUTPUT_BUFFER_ROWS</name>
- </field>
- </perf-log-table>
- <channel-log-table>
- <connection/>
- <schema/>
- <table/>
- <timeout_days/>
- <field>
- <id>ID_BATCH</id>
- <enabled>Y</enabled>
- <name>ID_BATCH</name>
- </field>
- <field>
- <id>CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>CHANNEL_ID</name>
- </field>
- <field>
- <id>LOG_DATE</id>
- <enabled>Y</enabled>
- <name>LOG_DATE</name>
- </field>
- <field>
- <id>LOGGING_OBJECT_TYPE</id>
- <enabled>Y</enabled>
- <name>LOGGING_OBJECT_TYPE</name>
- </field>
- <field>
- <id>OBJECT_NAME</id>
- <enabled>Y</enabled>
- <name>OBJECT_NAME</name>
- </field>
- <field>
- <id>OBJECT_COPY</id>
- <enabled>Y</enabled>
- <name>OBJECT_COPY</name>
- </field>
- <field>
- <id>REPOSITORY_DIRECTORY</id>
- <enabled>Y</enabled>
- <name>REPOSITORY_DIRECTORY</name>
- </field>
- <field>
- <id>FILENAME</id>
- <enabled>Y</enabled>
- <name>FILENAME</name>
- </field>
- <field>
- <id>OBJECT_ID</id>
- <enabled>Y</enabled>
- <name>OBJECT_ID</name>
- </field>
- <field>
- <id>OBJECT_REVISION</id>
- <enabled>Y</enabled>
- <name>OBJECT_REVISION</name>
- </field>
- <field>
- <id>PARENT_CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>PARENT_CHANNEL_ID</name>
- </field>
- <field>
- <id>ROOT_CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>ROOT_CHANNEL_ID</name>
- </field>
- </channel-log-table>
- <step-log-table>
- <connection/>
- <schema/>
- <table/>
- <timeout_days/>
- <field>
- <id>ID_BATCH</id>
- <enabled>Y</enabled>
- <name>ID_BATCH</name>
- </field>
- <field>
- <id>CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>CHANNEL_ID</name>
- </field>
- <field>
- <id>LOG_DATE</id>
- <enabled>Y</enabled>
- <name>LOG_DATE</name>
- </field>
- <field>
- <id>TRANSNAME</id>
- <enabled>Y</enabled>
- <name>TRANSNAME</name>
- </field>
- <field>
- <id>STEPNAME</id>
- <enabled>Y</enabled>
- <name>STEPNAME</name>
- </field>
- <field>
- <id>STEP_COPY</id>
- <enabled>Y</enabled>
- <name>STEP_COPY</name>
- </field>
- <field>
- <id>LINES_READ</id>
- <enabled>Y</enabled>
- <name>LINES_READ</name>
- </field>
- <field>
- <id>LINES_WRITTEN</id>
- <enabled>Y</enabled>
- <name>LINES_WRITTEN</name>
- </field>
- <field>
- <id>LINES_UPDATED</id>
- <enabled>Y</enabled>
- <name>LINES_UPDATED</name>
- </field>
- <field>
- <id>LINES_INPUT</id>
- <enabled>Y</enabled>
- <name>LINES_INPUT</name>
- </field>
- <field>
- <id>LINES_OUTPUT</id>
- <enabled>Y</enabled>
- <name>LINES_OUTPUT</name>
- </field>
- <field>
- <id>LINES_REJECTED</id>
- <enabled>Y</enabled>
- <name>LINES_REJECTED</name>
- </field>
- <field>
- <id>ERRORS</id>
- <enabled>Y</enabled>
- <name>ERRORS</name>
- </field>
- <field>
- <id>LOG_FIELD</id>
- <enabled>N</enabled>
- <name>LOG_FIELD</name>
- </field>
- </step-log-table>
- <metrics-log-table>
- <connection/>
- <schema/>
- <table/>
- <timeout_days/>
- <field>
- <id>ID_BATCH</id>
- <enabled>Y</enabled>
- <name>ID_BATCH</name>
- </field>
- <field>
- <id>CHANNEL_ID</id>
- <enabled>Y</enabled>
- <name>CHANNEL_ID</name>
- </field>
- <field>
- <id>LOG_DATE</id>
- <enabled>Y</enabled>
- <name>LOG_DATE</name>
- </field>
- <field>
- <id>METRICS_DATE</id>
- <enabled>Y</enabled>
- <name>METRICS_DATE</name>
- </field>
- <field>
- <id>METRICS_CODE</id>
- <enabled>Y</enabled>
- <name>METRICS_CODE</name>
- </field>
- <field>
- <id>METRICS_DESCRIPTION</id>
- <enabled>Y</enabled>
- <name>METRICS_DESCRIPTION</name>
- </field>
- <field>
- <id>METRICS_SUBJECT</id>
- <enabled>Y</enabled>
- <name>METRICS_SUBJECT</name>
- </field>
- <field>
- <id>METRICS_TYPE</id>
- <enabled>Y</enabled>
- <name>METRICS_TYPE</name>
- </field>
- <field>
- <id>METRICS_VALUE</id>
- <enabled>Y</enabled>
- <name>METRICS_VALUE</name>
- </field>
- </metrics-log-table>
- </log>
- <maxdate>
- <connection/>
- <table/>
- <field/>
- <offset>0.0</offset>
- <maxdiff>0.0</maxdiff>
- </maxdate>
- <size_rowset>10000</size_rowset>
- <sleep_time_empty>50</sleep_time_empty>
- <sleep_time_full>50</sleep_time_full>
- <unique_connections>N</unique_connections>
- <feedback_shown>Y</feedback_shown>
- <feedback_size>50000</feedback_size>
- <using_thread_priorities>Y</using_thread_priorities>
- <shared_objects_file/>
- <capture_step_performance>N</capture_step_performance>
- <step_performance_capturing_delay>1000</step_performance_capturing_delay>
- <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
- <dependencies>
- </dependencies>
- <partitionschemas>
- </partitionschemas>
- <slaveservers>
- </slaveservers>
- <clusterschemas>
- </clusterschemas>
- <created_user>-</created_user>
- <created_date>2024/09/25 09:53:59.778</created_date>
- <modified_user>-</modified_user>
- <modified_date>2024/10/01 12:17:59.737</modified_date>
- <key_for_session_key/>
- <is_key_private>N</is_key_private>
- </info>
- <notepads>
- </notepads>
- <connection>
- <name>GC_DWH</name>
- <server>192.168.2.43</server>
- <type>MSSQL</type>
- <access>Native</access>
- <database>GC_DWH</database>
- <port>1433</port>
- <username>sa</username>
- <password>Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99</password>
- <servername/>
- <data_tablespace/>
- <index_tablespace/>
- <attributes>
- <attribute>
- <code>EXTRA_OPTION_MSSQL.instance</code>
- <attribute>GLOBALCUBE</attribute>
- </attribute>
- <attribute>
- <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>IS_CLUSTERED</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>PORT_NUMBER</code>
- <attribute>1433</attribute>
- </attribute>
- <attribute>
- <code>PRESERVE_RESERVED_WORD_CASE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>QUOTE_ALL_FIELDS</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>USE_POOLING</code>
- <attribute>N</attribute>
- </attribute>
- </attributes>
- </connection>
- <connection>
- <name>GC_STAGING_OPTIMA</name>
- <server>192.168.2.43</server>
- <type>MSSQL</type>
- <access>Native</access>
- <database>GC_STAGING_OPTIMA</database>
- <port>1433</port>
- <username>sa</username>
- <password>Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99</password>
- <servername/>
- <data_tablespace/>
- <index_tablespace/>
- <attributes>
- <attribute>
- <code>EXTRA_OPTION_MSSQL.instance</code>
- <attribute>GLOBALCUBE</attribute>
- </attribute>
- <attribute>
- <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>IS_CLUSTERED</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>PORT_NUMBER</code>
- <attribute>1433</attribute>
- </attribute>
- <attribute>
- <code>PRESERVE_RESERVED_WORD_CASE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>QUOTE_ALL_FIELDS</code>
- <attribute>N</attribute>
- </attribute>
- <attribute>
- <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
- <attribute>Y</attribute>
- </attribute>
- <attribute>
- <code>USE_POOLING</code>
- <attribute>N</attribute>
- </attribute>
- </attributes>
- </connection>
- <order>
- <hop>
- <from>GC_STAGING_OPTIMA.dbo.vw_Transformer_Verkauf</from>
- <to>Select values</to>
- <enabled>Y</enabled>
- </hop>
- <hop>
- <from>Select values</from>
- <to>Table output</to>
- <enabled>Y</enabled>
- </hop>
- </order>
- <step>
- <name>Table output</name>
- <type>TableOutput</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <connection>GC_DWH</connection>
- <schema>dbo</schema>
- <table>Verkauf</table>
- <commit>10000</commit>
- <truncate>Y</truncate>
- <ignore_errors>N</ignore_errors>
- <use_batch>Y</use_batch>
- <specify_fields>Y</specify_fields>
- <partitioning_enabled>N</partitioning_enabled>
- <partitioning_field/>
- <partitioning_daily>N</partitioning_daily>
- <partitioning_monthly>Y</partitioning_monthly>
- <tablename_in_field>N</tablename_in_field>
- <tablename_field/>
- <tablename_in_table>Y</tablename_in_table>
- <return_keys>N</return_keys>
- <return_field/>
- <fields>
- <field>
- <column_name>CLIENT_DB</column_name>
- <stream_name>CLIENT_DB</stream_name>
- </field>
- <field>
- <column_name>FZG-Nr.</column_name>
- <stream_name>FZG-Nr.</stream_name>
- </field>
- <field>
- <column_name>Rg.-Datum</column_name>
- <stream_name>Rg.-Datum</stream_name>
- </field>
- <field>
- <column_name>Standtage</column_name>
- <stream_name>Standtage</stream_name>
- </field>
- <field>
- <column_name>FZG-Art</column_name>
- <stream_name>FZG-Art</stream_name>
- </field>
- <field>
- <column_name>FZG-Typ</column_name>
- <stream_name>FZG-Typ</stream_name>
- </field>
- <field>
- <column_name>Tage_seit_Verkauf</column_name>
- <stream_name>Tage_seit_Verkauf</stream_name>
- </field>
- <field>
- <column_name>Rg.-Nr.</column_name>
- <stream_name>Rg.-Nr.</stream_name>
- </field>
- <field>
- <column_name>Konto</column_name>
- <stream_name>Konto</stream_name>
- </field>
- <field>
- <column_name>Buch_Text</column_name>
- <stream_name>Buch_Text</stream_name>
- </field>
- <field>
- <column_name>Menge</column_name>
- <stream_name>Menge</stream_name>
- </field>
- <field>
- <column_name>Betrag</column_name>
- <stream_name>Betrag</stream_name>
- </field>
- <field>
- <column_name>Erlös</column_name>
- <stream_name>Erlös</stream_name>
- </field>
- <field>
- <column_name>Ums. Fracht</column_name>
- <stream_name>Ums. Fracht</stream_name>
- </field>
- <field>
- <column_name>Sonst. Erlöse</column_name>
- <stream_name>Sonst. Erlöse</stream_name>
- </field>
- <field>
- <column_name>Provisionen</column_name>
- <stream_name>Provisionen</stream_name>
- </field>
- <field>
- <column_name>Nachlass</column_name>
- <stream_name>Nachlass</stream_name>
- </field>
- <field>
- <column_name>Einsatz FZG</column_name>
- <stream_name>Einsatz FZG</stream_name>
- </field>
- <field>
- <column_name>EK-FZG</column_name>
- <stream_name>EK-FZG</stream_name>
- </field>
- <field>
- <column_name>FZG-Kosten</column_name>
- <stream_name>FZG-Kosten</stream_name>
- </field>
- <field>
- <column_name>VK-Hilfen</column_name>
- <stream_name>VK-Hilfen</stream_name>
- </field>
- <field>
- <column_name>Rest</column_name>
- <stream_name>Rest</stream_name>
- </field>
- <field>
- <column_name>DB1</column_name>
- <stream_name>DB1</stream_name>
- </field>
- <field>
- <column_name>Basis Number</column_name>
- <stream_name>Basis Number</stream_name>
- </field>
- <field>
- <column_name>Fahrgestellnr</column_name>
- <stream_name>Fahrgestellnr</stream_name>
- </field>
- <field>
- <column_name>Modellbez</column_name>
- <stream_name>Modellbez</stream_name>
- </field>
- <field>
- <column_name>Fabrikat</column_name>
- <stream_name>Fabrikat</stream_name>
- </field>
- <field>
- <column_name>Model</column_name>
- <stream_name>Model</stream_name>
- </field>
- <field>
- <column_name>Kundennr.</column_name>
- <stream_name>Kundennr.</stream_name>
- </field>
- <field>
- <column_name>Name</column_name>
- <stream_name>Name</stream_name>
- </field>
- <field>
- <column_name>Kunde</column_name>
- <stream_name>Kunde</stream_name>
- </field>
- <field>
- <column_name>Kundenart</column_name>
- <stream_name>Kundenart</stream_name>
- </field>
- <field>
- <column_name>PLZ_1</column_name>
- <stream_name>PLZ_1</stream_name>
- </field>
- <field>
- <column_name>PLZ_2</column_name>
- <stream_name>PLZ_2</stream_name>
- </field>
- <field>
- <column_name>PLZ_3</column_name>
- <stream_name>PLZ_3</stream_name>
- </field>
- <field>
- <column_name>PLZ_4</column_name>
- <stream_name>PLZ_4</stream_name>
- </field>
- <field>
- <column_name>PLZ Code_Deb</column_name>
- <stream_name>PLZ Code_Deb</stream_name>
- </field>
- <field>
- <column_name>Verkäufer</column_name>
- <stream_name>Verkäufer</stream_name>
- </field>
- <field>
- <column_name>Verkaeufer_mit_Code</column_name>
- <stream_name>Verkaeufer_mit_Code</stream_name>
- </field>
- <field>
- <column_name>Name_Einkäufer</column_name>
- <stream_name>Name_Einkäufer</stream_name>
- </field>
- <field>
- <column_name>Einkaeufer_mit_Code</column_name>
- <stream_name>Einkaeufer_mit_Code</stream_name>
- </field>
- <field>
- <column_name>Hauptbetrieb_ID</column_name>
- <stream_name>Hauptbetrieb_ID</stream_name>
- </field>
- <field>
- <column_name>Hauptbetrieb_Name</column_name>
- <stream_name>Hauptbetrieb_Name</stream_name>
- </field>
- <field>
- <column_name>Standort_ID</column_name>
- <stream_name>Standort_ID</stream_name>
- </field>
- <field>
- <column_name>Standort_Name</column_name>
- <stream_name>Standort_Name</stream_name>
- </field>
- <field>
- <column_name>Standort_Kategoriecode</column_name>
- <stream_name>Standort_Kategoriecode</stream_name>
- </field>
- <field>
- <column_name>Marke_ID</column_name>
- <stream_name>Marke_ID</stream_name>
- </field>
- <field>
- <column_name>Marke_Name</column_name>
- <stream_name>Marke_Name</stream_name>
- </field>
- <field>
- <column_name>Make</column_name>
- <stream_name>Make</stream_name>
- </field>
- <field>
- <column_name>Kostenstelle_ID</column_name>
- <stream_name>Kostenstelle_ID</stream_name>
- </field>
- <field>
- <column_name>Kostenstelle_Name</column_name>
- <stream_name>Kostenstelle_Name</stream_name>
- </field>
- <field>
- <column_name>Kostenstelle_Text</column_name>
- <stream_name>Kostenstelle_Text</stream_name>
- </field>
- <field>
- <column_name>Gruppe_ID</column_name>
- <stream_name>Gruppe_ID</stream_name>
- </field>
- <field>
- <column_name>Gruppe_Name</column_name>
- <stream_name>Gruppe_Name</stream_name>
- </field>
- <field>
- <column_name>Einkäufer/Vorbesitzer</column_name>
- <stream_name>Einkäufer/Vorbesitzer</stream_name>
- </field>
- <field>
- <column_name>FZG_Detail</column_name>
- <stream_name>FZG_Detail</stream_name>
- </field>
- <field>
- <column_name>Jahre</column_name>
- <stream_name>Jahre</stream_name>
- </field>
- <field>
- <column_name>Monate</column_name>
- <stream_name>Monate</stream_name>
- </field>
- <field>
- <column_name>Fabrikat NW</column_name>
- <stream_name>Fabrikat NW</stream_name>
- </field>
- <field>
- <column_name>Modell_NW_Dashboard</column_name>
- <stream_name>Modell_NW_Dashboard</stream_name>
- </field>
- <field>
- <column_name>DB1 < 0</column_name>
- <stream_name>DB1 < 0</stream_name>
- </field>
- <field>
- <column_name>DB 1 < 3000</column_name>
- <stream_name>DB 1 < 3000</stream_name>
- </field>
- </fields>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>432</xloc>
- <yloc>144</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step>
- <name>GC_STAGING_OPTIMA.dbo.vw_Transformer_Verkauf</name>
- <type>TableInput</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <connection>GC_STAGING_OPTIMA</connection>
- <sql>SELECT * FROM vw_Transformer_Verkauf</sql>
- <limit>0</limit>
- <lookup/>
- <execute_each_row>N</execute_each_row>
- <variables_active>N</variables_active>
- <lazy_conversion_active>N</lazy_conversion_active>
- <cached_row_meta_active>N</cached_row_meta_active>
- <row-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>CLIENT_DB</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>CLIENT_DB</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>FZG-Nr.</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>FZG-Nr.</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>LINE_NO</name>
- <length>9</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>LINE_NO</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Timestamp</type>
- <storagetype>normal</storagetype>
- <name>Rg.-Datum</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Rg.-Datum</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Timestamp</type>
- <storagetype>normal</storagetype>
- <name>RECEPTION_DATE</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>RECEPTION_DATE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Timestamp</type>
- <storagetype>normal</storagetype>
- <name>PURCH_DATE</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PURCH_DATE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>Standtage</name>
- <length>15</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>Standtage</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PREV_OWNER</name>
- <length>60</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PREV_OWNER</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>ACCOUNT_SALES</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>ACCOUNT_SALES</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>SALES_DEPARTMENT</name>
- <length>4</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>SALES_DEPARTMENT</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>SALE_SALESMAN</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>SALE_SALESMAN</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>SALE_ORDER_NO</name>
- <length>1</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>SALE_ORDER_NO</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PURCH_SALSMAN_CODE</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PURCH_SALSMAN_CODE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>FZG-Art</name>
- <length>14</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>FZG-Art</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>FZG-Typ</name>
- <length>35</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>FZG-Typ</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>Tage_seit_Verkauf</name>
- <length>15</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>Tage_seit_Verkauf</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Rg.-Nr.</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Rg.-Nr.</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>LINE_TYPE</name>
- <length>2</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>LINE_TYPE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>TRANSACTION_CODE</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>TRANSACTION_CODE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>SPECIFY</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>SPECIFY</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>REFERENCE</name>
- <length>255</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>REFERENCE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Konto</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Konto</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>UNIQUE_IDENT_ACCT_DOC_KEY</name>
- <length>15</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>UNIQUE_IDENT_ACCT_DOC_KEY</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Buch_Text</name>
- <length>1</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Buch_Text</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Number</type>
- <storagetype>normal</storagetype>
- <name>Menge</name>
- <length>2</length>
- <precision>1</precision>
- <origin>Table input</origin>
- <comments>Menge</comments>
- <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Betrag</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Betrag</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Erlös</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Erlös</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Ums. Fracht</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Ums. Fracht</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Sonst. Erlöse</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Sonst. Erlöse</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Provisionen</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Provisionen</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Nachlass</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Nachlass</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>Einsatz FZG</name>
- <length>9</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>Einsatz FZG</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>EK-FZG</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>EK-FZG</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>FZG-Kosten</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>FZG-Kosten</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>VK-Hilfen</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>VK-Hilfen</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>Rest</name>
- <length>16</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>Rest</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>BigNumber</type>
- <storagetype>normal</storagetype>
- <name>DB1</name>
- <length>18</length>
- <precision>2</precision>
- <origin>Table input</origin>
- <comments>DB1</comments>
- <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
- <decimal_symbol>.</decimal_symbol>
- <grouping_symbol/>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Basis Number</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Basis Number</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Fahrgestellnr</name>
- <length>30</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Fahrgestellnr</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Timestamp</type>
- <storagetype>normal</storagetype>
- <name>ORIG_INV_DATE</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>ORIG_INV_DATE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Modellbez</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Modellbez</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>MAKE_CD</name>
- <length>2</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>MAKE_CD</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Fabrikat</name>
- <length>30</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Fabrikat</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>MODEL_LINE</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>MODEL_LINE</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Model</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Model</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kundennr.</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kundennr.</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Name</name>
- <length>100</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kunde</name>
- <length>113</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kunde</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kundenart</name>
- <length>35</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kundenart</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PLZ_1</name>
- <length>1</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PLZ_1</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PLZ_2</name>
- <length>2</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PLZ_2</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PLZ_3</name>
- <length>3</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PLZ_3</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PLZ_4</name>
- <length>4</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PLZ_4</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>PLZ Code_Deb</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>PLZ Code_Deb</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Verkäufer</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Verkäufer</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Verkaeufer_mit_Code</name>
- <length>68</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Verkaeufer_mit_Code</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Name_Einkäufer</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Name_Einkäufer</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Einkaeufer_mit_Code</name>
- <length>68</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Einkaeufer_mit_Code</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Hauptbetrieb_ID</name>
- <length>20</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Hauptbetrieb_ID</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Hauptbetrieb_Name</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Hauptbetrieb_Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Standort_ID</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Standort_ID</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Standort_Name</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Standort_Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Standort_Kategoriecode</name>
- <length>21</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Standort_Kategoriecode</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Marke_ID</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Marke_ID</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Marke_Name</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Marke_Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Make</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Make</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kostenstelle_ID</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kostenstelle_ID</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kostenstelle_Name</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kostenstelle_Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Kostenstelle_Text</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Kostenstelle_Text</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Gruppe_ID</name>
- <length>10</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Gruppe_ID</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Gruppe_Name</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Gruppe_Name</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Einkäufer/Vorbesitzer</name>
- <length>113</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Einkäufer/Vorbesitzer</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>FZG_Detail</name>
- <length>287</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>FZG_Detail</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>Jahre</name>
- <length>9</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>Jahre</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>Integer</type>
- <storagetype>normal</storagetype>
- <name>Monate</name>
- <length>9</length>
- <precision>0</precision>
- <origin>Table input</origin>
- <comments>Monate</comments>
- <conversion_Mask>####0;-####0</conversion_Mask>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Fabrikat NW</name>
- <length>30</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Fabrikat NW</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>Modell_NW_Dashboard</name>
- <length>50</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>Modell_NW_Dashboard</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>DB1 < 0</name>
- <length>7</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>DB1 < 0</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- <value-meta>
- <type>String</type>
- <storagetype>normal</storagetype>
- <name>DB 1 < 3000</name>
- <length>11</length>
- <precision>-1</precision>
- <origin>Table input</origin>
- <comments>DB 1 < 3000</comments>
- <conversion_Mask/>
- <decimal_symbol>,</decimal_symbol>
- <grouping_symbol>.</grouping_symbol>
- <currency_symbol/>
- <trim_type>none</trim_type>
- <case_insensitive>N</case_insensitive>
- <collator_disabled>Y</collator_disabled>
- <collator_strength>0</collator_strength>
- <sort_descending>N</sort_descending>
- <output_padding>N</output_padding>
- <date_format_lenient>N</date_format_lenient>
- <date_format_locale>en_US</date_format_locale>
- <date_format_timezone>Europe/Berlin</date_format_timezone>
- <lenient_string_to_number>N</lenient_string_to_number>
- </value-meta>
- </row-meta>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>48</xloc>
- <yloc>144</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step>
- <name>Select values</name>
- <type>SelectValues</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <fields>
- <field>
- <name>CLIENT_DB</name>
- <rename/>
- </field>
- <field>
- <name>FZG-Nr.</name>
- <rename/>
- </field>
- <field>
- <name>LINE_NO</name>
- <rename/>
- </field>
- <field>
- <name>Rg.-Datum</name>
- <rename/>
- </field>
- <field>
- <name>RECEPTION_DATE</name>
- <rename/>
- </field>
- <field>
- <name>PURCH_DATE</name>
- <rename/>
- </field>
- <field>
- <name>Standtage</name>
- <rename/>
- </field>
- <field>
- <name>PREV_OWNER</name>
- <rename/>
- </field>
- <field>
- <name>ACCOUNT_SALES</name>
- <rename/>
- </field>
- <field>
- <name>SALES_DEPARTMENT</name>
- <rename/>
- </field>
- <field>
- <name>SALE_SALESMAN</name>
- <rename/>
- </field>
- <field>
- <name>SALE_ORDER_NO</name>
- <rename/>
- </field>
- <field>
- <name>PURCH_SALSMAN_CODE</name>
- <rename/>
- </field>
- <field>
- <name>FZG-Art</name>
- <rename/>
- </field>
- <field>
- <name>FZG-Typ</name>
- <rename/>
- </field>
- <field>
- <name>Tage_seit_Verkauf</name>
- <rename/>
- </field>
- <field>
- <name>Rg.-Nr.</name>
- <rename/>
- </field>
- <field>
- <name>LINE_TYPE</name>
- <rename/>
- </field>
- <field>
- <name>TRANSACTION_CODE</name>
- <rename/>
- </field>
- <field>
- <name>SPECIFY</name>
- <rename/>
- </field>
- <field>
- <name>REFERENCE</name>
- <rename/>
- </field>
- <field>
- <name>Konto</name>
- <rename/>
- </field>
- <field>
- <name>UNIQUE_IDENT_ACCT_DOC_KEY</name>
- <rename/>
- </field>
- <field>
- <name>Buch_Text</name>
- <rename/>
- </field>
- <field>
- <name>Menge</name>
- <rename/>
- </field>
- <field>
- <name>Betrag</name>
- <rename/>
- </field>
- <field>
- <name>Erlös</name>
- <rename/>
- </field>
- <field>
- <name>Ums. Fracht</name>
- <rename/>
- </field>
- <field>
- <name>Sonst. Erlöse</name>
- <rename/>
- </field>
- <field>
- <name>Provisionen</name>
- <rename/>
- </field>
- <field>
- <name>Nachlass</name>
- <rename/>
- </field>
- <field>
- <name>Einsatz FZG</name>
- <rename/>
- </field>
- <field>
- <name>EK-FZG</name>
- <rename/>
- </field>
- <field>
- <name>FZG-Kosten</name>
- <rename/>
- </field>
- <field>
- <name>VK-Hilfen</name>
- <rename/>
- </field>
- <field>
- <name>Rest</name>
- <rename/>
- </field>
- <field>
- <name>DB1</name>
- <rename/>
- </field>
- <field>
- <name>Basis Number</name>
- <rename/>
- </field>
- <field>
- <name>Fahrgestellnr</name>
- <rename/>
- </field>
- <field>
- <name>ORIG_INV_DATE</name>
- <rename/>
- </field>
- <field>
- <name>Modellbez</name>
- <rename/>
- </field>
- <field>
- <name>MAKE_CD</name>
- <rename/>
- </field>
- <field>
- <name>Fabrikat</name>
- <rename/>
- </field>
- <field>
- <name>MODEL_LINE</name>
- <rename/>
- </field>
- <field>
- <name>Model</name>
- <rename/>
- </field>
- <field>
- <name>Kundennr.</name>
- <rename/>
- </field>
- <field>
- <name>Name</name>
- <rename/>
- </field>
- <field>
- <name>Kunde</name>
- <rename/>
- </field>
- <field>
- <name>Kundenart</name>
- <rename/>
- </field>
- <field>
- <name>PLZ_1</name>
- <rename/>
- </field>
- <field>
- <name>PLZ_2</name>
- <rename/>
- </field>
- <field>
- <name>PLZ_3</name>
- <rename/>
- </field>
- <field>
- <name>PLZ_4</name>
- <rename/>
- </field>
- <field>
- <name>PLZ Code_Deb</name>
- <rename/>
- </field>
- <field>
- <name>Verkäufer</name>
- <rename/>
- </field>
- <field>
- <name>Verkaeufer_mit_Code</name>
- <rename/>
- </field>
- <field>
- <name>Name_Einkäufer</name>
- <rename/>
- </field>
- <field>
- <name>Einkaeufer_mit_Code</name>
- <rename/>
- </field>
- <field>
- <name>Hauptbetrieb_ID</name>
- <rename/>
- </field>
- <field>
- <name>Hauptbetrieb_Name</name>
- <rename/>
- </field>
- <field>
- <name>Standort_ID</name>
- <rename/>
- </field>
- <field>
- <name>Standort_Name</name>
- <rename/>
- </field>
- <field>
- <name>Standort_Kategoriecode</name>
- <rename/>
- </field>
- <field>
- <name>Marke_ID</name>
- <rename/>
- </field>
- <field>
- <name>Marke_Name</name>
- <rename/>
- </field>
- <field>
- <name>Make</name>
- <rename/>
- </field>
- <field>
- <name>Kostenstelle_ID</name>
- <rename/>
- </field>
- <field>
- <name>Kostenstelle_Name</name>
- <rename/>
- </field>
- <field>
- <name>Kostenstelle_Text</name>
- <rename/>
- </field>
- <field>
- <name>Gruppe_ID</name>
- <rename/>
- </field>
- <field>
- <name>Gruppe_Name</name>
- <rename/>
- </field>
- <field>
- <name>Einkäufer/Vorbesitzer</name>
- <rename/>
- </field>
- <field>
- <name>FZG_Detail</name>
- <rename/>
- </field>
- <field>
- <name>Jahre</name>
- <rename/>
- </field>
- <field>
- <name>Monate</name>
- <rename/>
- </field>
- <field>
- <name>Fabrikat NW</name>
- <rename/>
- </field>
- <field>
- <name>Modell_NW_Dashboard</name>
- <rename/>
- </field>
- <field>
- <name>DB1 < 0</name>
- <rename/>
- </field>
- <field>
- <name>DB 1 < 3000</name>
- <rename/>
- </field>
- <select_unspecified>N</select_unspecified>
- <remove>
- <name>LINE_NO</name>
- </remove>
- <remove>
- <name>RECEPTION_DATE</name>
- </remove>
- <remove>
- <name>PURCH_DATE</name>
- </remove>
- <remove>
- <name>PREV_OWNER</name>
- </remove>
- <remove>
- <name>ACCOUNT_SALES</name>
- </remove>
- <remove>
- <name>SALES_DEPARTMENT</name>
- </remove>
- <remove>
- <name>SALE_SALESMAN</name>
- </remove>
- <remove>
- <name>SALE_ORDER_NO</name>
- </remove>
- <remove>
- <name>PURCH_SALSMAN_CODE</name>
- </remove>
- <remove>
- <name>LINE_TYPE</name>
- </remove>
- <remove>
- <name>TRANSACTION_CODE</name>
- </remove>
- <remove>
- <name>SPECIFY</name>
- </remove>
- <remove>
- <name>REFERENCE</name>
- </remove>
- <remove>
- <name>UNIQUE_IDENT_ACCT_DOC_KEY</name>
- </remove>
- <remove>
- <name>ORIG_INV_DATE</name>
- </remove>
- <remove>
- <name>MAKE_CD</name>
- </remove>
- <remove>
- <name>MODEL_LINE</name>
- </remove>
- </fields>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>256</xloc>
- <yloc>144</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step_error_handling>
- </step_error_handling>
- <slave-step-copy-partition-distribution>
- </slave-step-copy-partition-distribution>
- <slave_transformation>N</slave_transformation>
- <attributes/>
- </transformation>
|