12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010 |
- <?xml version="1.0" encoding="UTF-8"?>
- <transformation>
- <info>
- <name>businessdoc</name>
- <description/>
- <extended_description/>
- <trans_version/>
- <trans_type>Normal</trans_type>
- <directory>/</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>2019/05/13 20:10:40.442</created_date>
- <modified_user>-</modified_user>
- <modified_date>2019/05/13 20:10:40.442</modified_date>
- <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
- <is_key_private>N</is_key_private>
- </info>
- <notepads>
- </notepads>
- <connection>
- <name>esSqlserver</name>
- <server>192.168.50.30</server>
- <type>MSSQLNATIVE</type>
- <access>Native</access>
- <database>LJHYBZK</database>
- <port>1433</port>
- <username>es</username>
- <password>Encrypted 2be98afc86ac281d5f94afa2588d38f99</password>
- <servername/>
- <data_tablespace/>
- <index_tablespace/>
- <attributes>
- <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>MSSQLUseIntegratedSecurity</code>
- <attribute>false</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>表输入</from>
- <to>Elasticsearch bulk insert</to>
- <enabled>Y</enabled>
- </hop>
- </order>
- <step>
- <name>Elasticsearch bulk insert</name>
- <type>ElasticSearchBulk</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <general>
- <index>businessdoc</index>
- <type>_doc</type>
- <batchSize>500</batchSize>
- <timeout>100</timeout>
- <timeoutUnit>SECONDS</timeoutUnit>
- <isJson>N</isJson>
- <idField>BusinessId</idField>
- <overwriteIfExists>N</overwriteIfExists>
- <useOutput>N</useOutput>
- <stopOnError>Y</stopOnError>
- </general>
- <fields>
- <field>
- <columnName>AcctName</columnName>
- <targetName>AcctName</targetName>
- </field>
- <field>
- <columnName>ActBalance</columnName>
- <targetName>ActBalance</targetName>
- </field>
- <field>
- <columnName>Address</columnName>
- <targetName>Address</targetName>
- </field>
- <field>
- <columnName>BankAccount</columnName>
- <targetName>BankAccount</targetName>
- </field>
- <field>
- <columnName>Beactive</columnName>
- <targetName>Beactive</targetName>
- </field>
- <field>
- <columnName>BillCode</columnName>
- <targetName>BillCode</targetName>
- </field>
- <field>
- <columnName>BillNo</columnName>
- <targetName>BillNo</targetName>
- </field>
- <field>
- <columnName>BusinessCode</columnName>
- <targetName>BusinessCode</targetName>
- </field>
- <field>
- <columnName>BusinessCont</columnName>
- <targetName>BusinessCont</targetName>
- </field>
- <field>
- <columnName>BusinessId</columnName>
- <targetName>BusinessId</targetName>
- </field>
- <field>
- <columnName>BusinessName</columnName>
- <targetName>BusinessName</targetName>
- </field>
- <field>
- <columnName>CEntId</columnName>
- <targetName>CEntId</targetName>
- </field>
- <field>
- <columnName>CZoneId</columnName>
- <targetName>CZoneId</targetName>
- </field>
- <field>
- <columnName>Capacity</columnName>
- <targetName>Capacity</targetName>
- </field>
- <field>
- <columnName>ChanceId</columnName>
- <targetName>ChanceId</targetName>
- </field>
- <field>
- <columnName>Contact</columnName>
- <targetName>Contact</targetName>
- </field>
- <field>
- <columnName>Content</columnName>
- <targetName>Content</targetName>
- </field>
- <field>
- <columnName>CreateDate</columnName>
- <targetName>CreateDate</targetName>
- </field>
- <field>
- <columnName>CreateTime</columnName>
- <targetName>CreateTime</targetName>
- </field>
- <field>
- <columnName>CreaterId</columnName>
- <targetName>CreaterId</targetName>
- </field>
- <field>
- <columnName>CreaterInfo</columnName>
- <targetName>CreaterInfo</targetName>
- </field>
- <field>
- <columnName>CusNatId</columnName>
- <targetName>CusNatId</targetName>
- </field>
- <field>
- <columnName>CusSubId</columnName>
- <targetName>CusSubId</targetName>
- </field>
- <field>
- <columnName>DelTime</columnName>
- <targetName>DelTime</targetName>
- </field>
- <field>
- <columnName>DelUserID</columnName>
- <targetName>DelUserID</targetName>
- </field>
- <field>
- <columnName>DeptId</columnName>
- <targetName>DeptId</targetName>
- </field>
- <field>
- <columnName>DirectorId</columnName>
- <targetName>DirectorId</targetName>
- </field>
- <field>
- <columnName>DocLevId</columnName>
- <targetName>DocLevId</targetName>
- </field>
- <field>
- <columnName>Email</columnName>
- <targetName>Email</targetName>
- </field>
- <field>
- <columnName>EntId</columnName>
- <targetName>EntId</targetName>
- </field>
- <field>
- <columnName>ExpAutOrg</columnName>
- <targetName>ExpAutOrg</targetName>
- </field>
- <field>
- <columnName>Fax</columnName>
- <targetName>Fax</targetName>
- </field>
- <field>
- <columnName>GPSAdd</columnName>
- <targetName>GPSAdd</targetName>
- </field>
- <field>
- <columnName>GroupId</columnName>
- <targetName>GroupId</targetName>
- </field>
- <field>
- <columnName>IdCard</columnName>
- <targetName>IdCard</targetName>
- </field>
- <field>
- <columnName>InfoState</columnName>
- <targetName>InfoState</targetName>
- </field>
- <field>
- <columnName>IsAbandon</columnName>
- <targetName>IsAbandon</targetName>
- </field>
- <field>
- <columnName>IsBusiness</columnName>
- <targetName>IsBusiness</targetName>
- </field>
- <field>
- <columnName>IsClients</columnName>
- <targetName>IsClients</targetName>
- </field>
- <field>
- <columnName>IsFreeze</columnName>
- <targetName>IsFreeze</targetName>
- </field>
- <field>
- <columnName>IsLogistics</columnName>
- <targetName>IsLogistics</targetName>
- </field>
- <field>
- <columnName>IsMfc</columnName>
- <targetName>IsMfc</targetName>
- </field>
- <field>
- <columnName>IsPartner</columnName>
- <targetName>IsPartner</targetName>
- </field>
- <field>
- <columnName>IsPass</columnName>
- <targetName>IsPass</targetName>
- </field>
- <field>
- <columnName>Is_Supp</columnName>
- <targetName>Is_Supp</targetName>
- </field>
- <field>
- <columnName>K_yfzffs</columnName>
- <targetName>K_yfzffs</targetName>
- </field>
- <field>
- <columnName>LastCareTime</columnName>
- <targetName>LastCareTime</targetName>
- </field>
- <field>
- <columnName>LastDate</columnName>
- <targetName>LastDate</targetName>
- </field>
- <field>
- <columnName>LastModifyTime</columnName>
- <targetName>LastModifyTime</targetName>
- </field>
- <field>
- <columnName>LastRtnTime</columnName>
- <targetName>LastRtnTime</targetName>
- </field>
- <field>
- <columnName>LastServTime</columnName>
- <targetName>LastServTime</targetName>
- </field>
- <field>
- <columnName>LastStfId</columnName>
- <targetName>LastStfId</targetName>
- </field>
- <field>
- <columnName>LastVisitTime</columnName>
- <targetName>LastVisitTime</targetName>
- </field>
- <field>
- <columnName>LegalRep</columnName>
- <targetName>LegalRep</targetName>
- </field>
- <field>
- <columnName>LevelId</columnName>
- <targetName>LevelId</targetName>
- </field>
- <field>
- <columnName>Logogram</columnName>
- <targetName>Logogram</targetName>
- </field>
- <field>
- <columnName>OldCode</columnName>
- <targetName>OldCode</targetName>
- </field>
- <field>
- <columnName>OperMode</columnName>
- <targetName>OperMode</targetName>
- </field>
- <field>
- <columnName>OrgCert</columnName>
- <targetName>OrgCert</targetName>
- </field>
- <field>
- <columnName>OrgCertDate</columnName>
- <targetName>OrgCertDate</targetName>
- </field>
- <field>
- <columnName>OrgCertVal</columnName>
- <targetName>OrgCertVal</targetName>
- </field>
- <field>
- <columnName>OrgId</columnName>
- <targetName>OrgId</targetName>
- </field>
- <field>
- <columnName>PBusinessId</columnName>
- <targetName>PBusinessId</targetName>
- </field>
- <field>
- <columnName>PostCode</columnName>
- <targetName>PostCode</targetName>
- </field>
- <field>
- <columnName>PowerBalance</columnName>
- <targetName>PowerBalance</targetName>
- </field>
- <field>
- <columnName>QADirName</columnName>
- <targetName>QADirName</targetName>
- </field>
- <field>
- <columnName>Reason</columnName>
- <targetName>Reason</targetName>
- </field>
- <field>
- <columnName>RegAuthority</columnName>
- <targetName>RegAuthority</targetName>
- </field>
- <field>
- <columnName>RegCapital</columnName>
- <targetName>RegCapital</targetName>
- </field>
- <field>
- <columnName>RegDates</columnName>
- <targetName>RegDates</targetName>
- </field>
- <field>
- <columnName>RegNo</columnName>
- <targetName>RegNo</targetName>
- </field>
- <field>
- <columnName>RegValDate</columnName>
- <targetName>RegValDate</targetName>
- </field>
- <field>
- <columnName>RegYearDate</columnName>
- <targetName>RegYearDate</targetName>
- </field>
- <field>
- <columnName>ResAutOrg</columnName>
- <targetName>ResAutOrg</targetName>
- </field>
- <field>
- <columnName>RfEntId</columnName>
- <targetName>RfEntId</targetName>
- </field>
- <field>
- <columnName>RouteId</columnName>
- <targetName>RouteId</targetName>
- </field>
- <field>
- <columnName>RouteOrder</columnName>
- <targetName>RouteOrder</targetName>
- </field>
- <field>
- <columnName>RptYear</columnName>
- <targetName>RptYear</targetName>
- </field>
- <field>
- <columnName>SelAttachId</columnName>
- <targetName>SelAttachId</targetName>
- </field>
- <field>
- <columnName>ShortName</columnName>
- <targetName>ShortName</targetName>
- </field>
- <field>
- <columnName>Subbranch</columnName>
- <targetName>Subbranch</targetName>
- </field>
- <field>
- <columnName>SyncId</columnName>
- <targetName>SyncId</targetName>
- </field>
- <field>
- <columnName>TaxNo</columnName>
- <targetName>TaxNo</targetName>
- </field>
- <field>
- <columnName>Telephone</columnName>
- <targetName>Telephone</targetName>
- </field>
- <field>
- <columnName>Url</columnName>
- <targetName>Url</targetName>
- </field>
- <field>
- <columnName>ZoneId</columnName>
- <targetName>ZoneId</targetName>
- </field>
- <field>
- <columnName>businessKey</columnName>
- <targetName>businessKey</targetName>
- </field>
- <field>
- <columnName>ing</columnName>
- <targetName>ing</targetName>
- </field>
- <field>
- <columnName>jkfsid</columnName>
- <targetName>jkfsid</targetName>
- </field>
- <field>
- <columnName>k_b2bAccountName</columnName>
- <targetName>k_b2bAccountName</targetName>
- </field>
- <field>
- <columnName>k_b2bIDCard</columnName>
- <targetName>k_b2bIDCard</targetName>
- </field>
- <field>
- <columnName>k_b2bNickName</columnName>
- <targetName>k_b2bNickName</targetName>
- </field>
- <field>
- <columnName>k_b2bUserName</columnName>
- <targetName>k_b2bUserName</targetName>
- </field>
- <field>
- <columnName>k_deliverid</columnName>
- <targetName>k_deliverid</targetName>
- </field>
- <field>
- <columnName>k_ismr</columnName>
- <targetName>k_ismr</targetName>
- </field>
- <field>
- <columnName>k_kdlx</columnName>
- <targetName>k_kdlx</targetName>
- </field>
- <field>
- <columnName>k_qu</columnName>
- <targetName>k_qu</targetName>
- </field>
- <field>
- <columnName>k_sheng</columnName>
- <targetName>k_sheng</targetName>
- </field>
- <field>
- <columnName>k_shi</columnName>
- <targetName>k_shi</targetName>
- </field>
- <field>
- <columnName>k_xiangxi</columnName>
- <targetName>k_xiangxi</targetName>
- </field>
- <field>
- <columnName>koul</columnName>
- <targetName>koul</targetName>
- </field>
- <field>
- <columnName>lat</columnName>
- <targetName>lat</targetName>
- </field>
- <field>
- <columnName>source</columnName>
- <targetName>source</targetName>
- </field>
- <field>
- <columnName>yingyzz</columnName>
- <targetName>yingyzz</targetName>
- </field>
- </fields>
- <servers>
- <server>
- <address>192.168.50.32</address>
- <port>9300</port>
- </server>
- </servers>
- <settings>
- <setting>
- <name>cluster.name</name>
- <value>es</value>
- </setting>
- </settings>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>560</xloc>
- <yloc>368</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step>
- <name>表输入</name>
- <type>TableInput</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <connection>esSqlserver</connection>
- <sql>SELECT *,'erp' as source,ROW_NUMBER() OVER (ORDER BY businessId DESC) as businessKey FROM businessdoc</sql>
- <limit>0</limit>
- <lookup/>
- <execute_each_row>N</execute_each_row>
- <variables_active>N</variables_active>
- <lazy_conversion_active>Y</lazy_conversion_active>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>496</xloc>
- <yloc>192</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>
|