<?xml version="1.0" encoding="UTF-8"?> <transformation> <info> <name>front_db_demo</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>2021/03/29 10:33:20.082</created_date> <modified_user>-</modified_user> <modified_date>2021/03/29 10:33:20.082</modified_date> <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> <name>10.225.240.21-ent</name> <server>10.225.240.21</server> <type>POSTGRESQL</type> <access>Native</access> <database>front_db</database> <port>5432</port> <username>resmg</username> <password>Encrypted 2be98afc86aa7f2e4cb79bc75cd9fa88b</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>INITIAL_POOL_SIZE</code> <attribute>10</attribute> </attribute> <attribute> <code>IS_CLUSTERED</code> <attribute>N</attribute> </attribute> <attribute> <code>MAXIMUM_POOL_SIZE</code> <attribute>5</attribute> </attribute> <attribute> <code>PORT_NUMBER</code> <attribute>5432</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>Y</attribute> </attribute> </attributes> </connection> <connection> <name>scyy_local</name> <server>${source_local.server}</server> <type>MYSQL</type> <access>Native</access> <database>${source_local.database}</database> <port>3306</port> <username>${source_local.username}</username> <password>${source_local.password}</password> <servername/> <data_tablespace/> <index_tablespace/> <attributes> <attribute> <code>EXTRA_OPTION_MYSQL.characterEncoding</code> <attribute>utf8</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>PORT_NUMBER</code> <attribute>3306</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>STREAM_RESULTS</code> <attribute>Y</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>表输出</to> <enabled>Y</enabled> </hop> </order> <step> <name>表输入</name> <type>TableInput</type> <description/> <distribute>Y</distribute> <custom_distribution/> <copies>1</copies> <partitioning> <method>none</method> <schema_name/> </partitioning> <connection>10.225.240.21-ent</connection> <sql>SELECT qylx , tzze , zczb , yzbm , qymc , fddbr , sszb , bz , gq , djjg , djjgbm , qyzt , hyml , hydm , czfs , clrq , dzyj , ybjyxm , xkjyxm , sdjggss , gxjg , jyqxq , jyqxz , zs , sfzrd , sfgsq , hzrq , gpz , sjly , sfcqyx , dabh , wxl , tyshxydm , zch , ins , seq , updatestatus , updatetime FROM resmg.qyjbxxmd127142 </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>qylx</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>qylx</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>tzze</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>tzze</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>zczb</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>zczb</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>yzbm</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>yzbm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>qymc</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>qymc</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>fddbr</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>fddbr</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sszb</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sszb</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>bz</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>bz</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>gq</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>gq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>djjg</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>djjg</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>djjgbm</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>djjgbm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>qyzt</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>qyzt</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>hyml</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>hyml</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>hydm</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>hydm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>czfs</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>czfs</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>clrq</name> <length>50</length> <precision>-1</precision> <origin>表输入</origin> <comments>clrq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>dzyj</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>dzyj</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>ybjyxm</name> <length>1600</length> <precision>-1</precision> <origin>表输入</origin> <comments>ybjyxm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>xkjyxm</name> <length>1600</length> <precision>-1</precision> <origin>表输入</origin> <comments>xkjyxm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sdjggss</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sdjggss</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>gxjg</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>gxjg</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>jyqxq</name> <length>50</length> <precision>-1</precision> <origin>表输入</origin> <comments>jyqxq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>jyqxz</name> <length>50</length> <precision>-1</precision> <origin>表输入</origin> <comments>jyqxz</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>zs</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>zs</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sfzrd</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sfzrd</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sfgsq</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sfgsq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>hzrq</name> <length>50</length> <precision>-1</precision> <origin>表输入</origin> <comments>hzrq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>gpz</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>gpz</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sjly</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sjly</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>sfcqyx</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>sfcqyx</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>dabh</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>dabh</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>wxl</name> <length>800</length> <precision>-1</precision> <origin>表输入</origin> <comments>wxl</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>tyshxydm</name> <length>400</length> <precision>-1</precision> <origin>表输入</origin> <comments>tyshxydm</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>zch</name> <length>250</length> <precision>-1</precision> <origin>表输入</origin> <comments>zch</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>Integer</type> <storagetype>normal</storagetype> <name>ins</name> <length>9</length> <precision>0</precision> <origin>表输入</origin> <comments>ins</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>Integer</type> <storagetype>normal</storagetype> <name>seq</name> <length>15</length> <precision>0</precision> <origin>表输入</origin> <comments>seq</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>Integer</type> <storagetype>normal</storagetype> <name>updatestatus</name> <length>15</length> <precision>0</precision> <origin>表输入</origin> <comments>updatestatus</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> <type>String</type> <storagetype>normal</storagetype> <name>updatetime</name> <length>50</length> <precision>-1</precision> <origin>表输入</origin> <comments>updatetime</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>zh_CN</date_format_locale> <date_format_timezone>Asia/Shanghai</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>768</xloc> <yloc>176</yloc> <draw>Y</draw> </GUI> </step> <step> <name>表输出</name> <type>TableOutput</type> <description/> <distribute>Y</distribute> <custom_distribution/> <copies>1</copies> <partitioning> <method>none</method> <schema_name/> </partitioning> <connection>scyy_local</connection> <schema>scyy</schema> <table>enterprise_info</table> <commit>1000</commit> <truncate>N</truncate> <ignore_errors>N</ignore_errors> <use_batch>Y</use_batch> <specify_fields>N</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> </fields> <attributes/> <cluster_schema/> <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> <xloc>928</xloc> <yloc>176</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>