diff options
| -rw-r--r-- | capture_available_minus.ktr | 2234 | ||||
| -rw-r--r-- | example_use_param_table_input.ktr | 361 | ||||
| -rw-r--r-- | revert_purchase_pricelist.ktr | 7032 | ||||
| -rw-r--r-- | run_single_ktr.sh | 2 |
4 files changed, 9443 insertions, 186 deletions
diff --git a/capture_available_minus.ktr b/capture_available_minus.ktr new file mode 100644 index 0000000..2bcb431 --- /dev/null +++ b/capture_available_minus.ktr @@ -0,0 +1,2234 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>capture_available_minus</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>2025/05/09 15:31:07.054</created_date> + <modified_user>-</modified_user> + <modified_date>2025/05/09 15:31:07.054</modified_date> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> + <is_key_private>N</is_key_private> + </info> + <notepads> + </notepads> + <connection> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</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>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>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <connection> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>erp_indoteknik</database> + <port>5432</port> + <username>pdi</username> + <password>Encrypted 2be989bb20084ca95810197629d9ea18e</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>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>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <order> + <hop> + <from>select stock quant</from> + <to>Merge join</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>select outgoing</from> + <to>Merge join</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Merge join</from> + <to>stock+outgoing</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 2</from> + <to>qty outgoing</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>qty outgoing</from> + <to>Sort rows</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Sort rows</from> + <to>select outgoing</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Sort rows 2</from> + <to>select stock quant</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>stock quant</from> + <to>Select values 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>stock quant</from> + <to>Sort rows 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 2</from> + <to>qty incoming</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>qty incoming</from> + <to>Sort rows 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Sort rows 3</from> + <to>select incoming</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>stock+outgoing</from> + <to>Merge join 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>select incoming</from> + <to>Merge join 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Merge join 2</from> + <to>stock+outgoing+incoming</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>stock+outgoing+incoming</from> + <to>Calculator available</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Calculator available</from> + <to>available</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>reordering</from> + <to>Sort rows 4</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Sort rows 4</from> + <to>Merge join 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>available</from> + <to>Merge join 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Merge join 3</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>max plafon</from> + <to>Select values 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>If field value is null</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>If field value is null</from> + <to>max plafon</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 3</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> + </order> + <step> + <name>Calculator available</name> + <type>Calculator</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <failIfNoFile>Y</failIfNoFile> + <calculation> + <field_name>incoming_plus_onhand</field_name> + <calc_type>ADD</calc_type> + <field_a>qty_incoming</field_a> + <field_b>qty_onhand</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <calculation> + <field_name>qty_available</field_name> + <calc_type>SUBTRACT</calc_type> + <field_a>incoming_plus_onhand</field_a> + <field_b>qty_outgoing</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>944</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>If field value is null</name> + <type>IfNull</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <replaceAllByValue>0</replaceAllByValue> + <replaceAllMask/> + <selectFields>Y</selectFields> + <selectValuesType>N</selectValuesType> + <setEmptyStringAll>N</setEmptyStringAll> + <valuetypes> + </valuetypes> + <fields> + <field> + <name>product_max_qty</name> + <value>0</value> + <mask/> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>928</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Merge join</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>LEFT OUTER</join_type> + <step1>select stock quant</step1> + <step2>select outgoing</step2> + <keys_1> + <key>product_id</key> + </keys_1> + <keys_2> + <key>product_id_3</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>480</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Merge join 2</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>LEFT OUTER</join_type> + <step1>stock+outgoing</step1> + <step2>select incoming</step2> + <keys_1> + <key>product_id</key> + </keys_1> + <keys_2> + <key>product_id</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>656</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Merge join 3</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>LEFT OUTER</join_type> + <step1>available</step1> + <step2>Sort rows 4</step2> + <keys_1> + <key>product_id</key> + </keys_1> + <keys_2> + <key>product_id</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1088</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>N</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>product_id2</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>qty_onhand</name> + <rename/> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename/> + </field> + <field> + <name>product_id_3</name> + <rename/> + </field> + <field> + <name>qty_outgoing</name> + <rename/> + </field> + <field> + <name>product_id_1</name> + <rename/> + </field> + <field> + <name>qty_incoming</name> + <rename/> + </field> + <field> + <name>incoming_plus_onhand</name> + <rename/> + </field> + <field> + <name>qty_available</name> + <rename/> + </field> + <field> + <name>product_id_2</name> + <rename/> + </field> + <field> + <name>product_max_qty</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + <meta> + <name>product_max_qty</name> + <rename>product_max_qty</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1088</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 2</name> + <type>SelectValues</type> + <description/> + <distribute>N</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + </field> + <field> + <name>product_id2</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>256</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 3</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>qty_onhand</name> + <rename/> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename>history_date</rename> + </field> + <field> + <name>qty_outgoing</name> + <rename/> + </field> + <field> + <name>qty_incoming</name> + <rename/> + </field> + <field> + <name>qty_available</name> + <rename/> + </field> + <field> + <name>product_max_qty</name> + <rename/> + </field> + <field> + <name>plafon_qty</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + <meta> + <name>product_max_qty</name> + <rename>product_max_qty</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>plafon_qty</name> + <rename>plafon_qty</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>656</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>product_id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>368</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows 2</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>product_id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>112</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows 3</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>product_id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>480</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows 4</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>product_id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1088</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>available</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>product_id2</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>qty_onhand</name> + <rename/> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename/> + </field> + <field> + <name>product_id_3</name> + <rename/> + </field> + <field> + <name>qty_outgoing</name> + <rename/> + </field> + <field> + <name>product_id_1</name> + <rename/> + </field> + <field> + <name>qty_incoming</name> + <rename/> + </field> + <field> + <name>incoming_plus_onhand</name> + <rename/> + </field> + <field> + <name>qty_available</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>944</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>max plafon</name> + <type>Calculator</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <failIfNoFile>Y</failIfNoFile> + <calculation> + <field_name>plafon_qty</field_name> + <calc_type>SUBTRACT</calc_type> + <field_a>product_max_qty</field_a> + <field_b>qty_available</field_b> + <field_c/> + <value_type>Number</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>800</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>qty incoming</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select ? as product_id, get_qty_incoming(?) as qty_incoming</sql> + <limit>0</limit> + <lookup>Select values 2</lookup> + <execute_each_row>Y</execute_each_row> + <variables_active>Y</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>product_id</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>qty incoming</origin> + <comments>product_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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>qty_incoming</name> + <length>-1</length> + <precision>-1</precision> + <origin>qty incoming</origin> + <comments>qty_incoming</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>Asia/Bangkok</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>368</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>qty outgoing</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select ? as product_id, get_qty_outgoing(?) as qty_outgoing</sql> + <limit>0</limit> + <lookup>Select values 2</lookup> + <execute_each_row>Y</execute_each_row> + <variables_active>Y</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>product_id</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>qty outgoing</origin> + <comments>product_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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>qty_outgoing</name> + <length>-1</length> + <precision>-1</precision> + <origin>qty outgoing</origin> + <comments>qty_outgoing</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>Asia/Bangkok</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>256</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>reordering</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select product_id, product_max_qty from stock_warehouse_orderpoint</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>Integer</type> + <storagetype>normal</storagetype> + <name>product_id</name> + <length>9</length> + <precision>0</precision> + <origin>reordering</origin> + <comments>product_id</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>product_max_qty</name> + <length>-1</length> + <precision>-1</precision> + <origin>reordering</origin> + <comments>product_max_qty</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>Asia/Bangkok</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>1088</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>select incoming</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + </field> + <field> + <name>qty_incoming</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>656</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>select outgoing</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename>product_id_3</rename> + </field> + <field> + <name>qty_outgoing</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>480</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>select stock quant</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>product_id2</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>quantity</name> + <rename/> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>112</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>stock quant</name> + <type>TableInput</type> + <description/> + <distribute>N</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select sq.product_id, sq.product_id as product_id2, sq.location_id, sq.quantity, sq.reserved_quantity, +coalesce(pp.default_code, pt.default_code) as item_code, pt.name as product_name, +now()::timestamp-'7 hours'::interval as current_date +from stock_quant sq +join product_product pp on pp.id = sq.product_id +join product_template pt on pt.id = pp.product_tmpl_id +where sq.location_id = 57 and sq.quantity > 0 +order by sq.product_id</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>Integer</type> + <storagetype>normal</storagetype> + <name>product_id</name> + <length>9</length> + <precision>0</precision> + <origin>stock quant</origin> + <comments>product_id</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>product_id2</name> + <length>9</length> + <precision>0</precision> + <origin>stock quant</origin> + <comments>product_id2</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>location_id</name> + <length>9</length> + <precision>0</precision> + <origin>stock quant</origin> + <comments>location_id</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Number</type> + <storagetype>normal</storagetype> + <name>quantity</name> + <length>-1</length> + <precision>-1</precision> + <origin>stock quant</origin> + <comments>quantity</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Number</type> + <storagetype>normal</storagetype> + <name>reserved_quantity</name> + <length>-1</length> + <precision>-1</precision> + <origin>stock quant</origin> + <comments>reserved_quantity</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>item_code</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>stock quant</origin> + <comments>item_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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>product_name</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>stock quant</origin> + <comments>product_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>Asia/Bangkok</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>112</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>stock+outgoing</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>product_id2</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>quantity</name> + <rename/> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename/> + </field> + <field> + <name>product_id_3</name> + <rename/> + </field> + <field> + <name>qty_outgoing</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>656</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>stock+outgoing+incoming</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>product_id</name> + <rename/> + </field> + <field> + <name>product_id2</name> + <rename/> + </field> + <field> + <name>location_id</name> + <rename/> + </field> + <field> + <name>quantity</name> + <rename>qty_onhand</rename> + </field> + <field> + <name>reserved_quantity</name> + <rename/> + </field> + <field> + <name>item_code</name> + <rename/> + </field> + <field> + <name>product_name</name> + <rename/> + </field> + <field> + <name>current_date</name> + <rename/> + </field> + <field> + <name>product_id_3</name> + <rename/> + </field> + <field> + <name>qty_outgoing</name> + <rename/> + </field> + <field> + <name>product_id_1</name> + <rename/> + </field> + <field> + <name>qty_incoming</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>784</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>Y</update_bypassed> + <lookup> + <schema>public</schema> + <table>stock_quant_history</table> + <key> + <name>product_id</name> + <field>product_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>Y</update> + </value> + <value> + <name>location_id</name> + <rename>location_id</rename> + <update>Y</update> + </value> + <value> + <name>qty_onhand</name> + <rename>qty_onhand</rename> + <update>Y</update> + </value> + <value> + <name>reserved_quantity</name> + <rename>reserved_quantity</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>product_name</name> + <rename>product_name</rename> + <update>Y</update> + </value> + <value> + <name>history_date</name> + <rename>history_date</rename> + <update>Y</update> + </value> + <value> + <name>qty_outgoing</name> + <rename>qty_outgoing</rename> + <update>Y</update> + </value> + <value> + <name>qty_incoming</name> + <rename>qty_incoming</rename> + <update>Y</update> + </value> + <value> + <name>qty_available</name> + <rename>qty_available</rename> + <update>Y</update> + </value> + <value> + <name>product_max_qty</name> + <rename>product_max_qty</rename> + <update>Y</update> + </value> + <value> + <name>plafon_qty</name> + <rename>plafon_qty</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>528</xloc> + <yloc>352</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> diff --git a/example_use_param_table_input.ktr b/example_use_param_table_input.ktr index 64d9612..863d5e8 100644 --- a/example_use_param_table_input.ktr +++ b/example_use_param_table_input.ktr @@ -431,7 +431,7 @@ <created_date>2024/11/09 07:41:25.978</created_date> <modified_user>-</modified_user> <modified_date>2024/11/09 07:41:25.978</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -443,8 +443,8 @@ <access>Native</access> <database>erp_indoteknik</database> <port>5901</port> - <username>pdi</username> - <password>Encrypted 2be989bb20084ca95810197629d9ea18e</password> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -525,6 +525,179 @@ </hop> </order> <step> + <name>Merge join</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>INNER</join_type> + <step1>Select values 2</step1> + <step2>Select values</step2> + <keys_1> + <key>id</key> + </keys_1> + <keys_2> + <key>sale_order_id</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>352</xloc> + <yloc>192</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>sale_order_id</name> + </field> + <field> + <name>po</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>544</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 2</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>id</name> + </field> + <field> + <name>name</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>128</xloc> + <yloc>192</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 3</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>id</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>240</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 4</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>id</name> + </field> + <field> + <name>name</name> + </field> + <field> + <name>sale_order_id</name> + </field> + <field> + <name>po</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>576</xloc> + <yloc>192</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -606,42 +779,6 @@ </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>sale_order_id</name> - <rename/> - </field> - <field> - <name>po</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>544</xloc> - <yloc>80</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Table input 2</name> <type>TableInput</type> <description/> @@ -748,152 +885,6 @@ order by sale_order_id</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>Select values 2</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>128</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Select values 3</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>240</xloc> - <yloc>80</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Merge join</name> - <type>MergeJoin</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <join_type>INNER</join_type> - <step1>Select values 2</step1> - <step2>Select values</step2> - <keys_1> - <key>id</key> - </keys_1> - <keys_2> - <key>sale_order_id</key> - </keys_2> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>352</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Select values 4</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>sale_order_id</name> - <rename/> - </field> - <field> - <name>po</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>576</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/revert_purchase_pricelist.ktr b/revert_purchase_pricelist.ktr new file mode 100644 index 0000000..c2f27be --- /dev/null +++ b/revert_purchase_pricelist.ktr @@ -0,0 +1,7032 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>revert_purchase_pricelist</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>2025/05/09 09:46:15.764</created_date> + <modified_user>-</modified_user> + <modified_date>2025/05/09 09:46:15.764</modified_date> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> + <is_key_private>N</is_key_private> + </info> + <notepads> + </notepads> + <connection> + <name>erp indoteknik laptop local</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>indoteknik_20250508</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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>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>N</attribute> + </attribute> + </attributes> + </connection> + <connection> + <name>erp indoteknik production</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>erp_indoteknik</database> + <port>5901</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</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>PORT_NUMBER</code> + <attribute>5901</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>Table input</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>Update</to> + <enabled>Y</enabled> + </hop> + </order> + <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>id</name> + </field> + <field> + <name>system_price</name> + </field> + <field> + <name>taxes_system_id</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>304</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Table input</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik laptop local</connection> + <sql>select id, system_price, taxes_system_id from purchase_pricelist +where id in( +547335, +528291, +557642, +551451, +345746, +507658, +484433, +528327, +346175, +345565, +484383, +481316, +346199, +547389, +554029, +556222, +556223, +556224, +513319, +488176, +421477, +518063, +518064, +518065, +518066, +518067, +518068, +527309, +527310, +527944, +527311, +527820, +547189, +546986, +528285, +544718, +532517, +501665, +505545, +527427, +528066, +528065, +544719, +544720, +544721, +545687, +546985, +505546, +507701, +552704, +344405, +550906, +486776, +546966, +483748, +483749, +484487, +487608, +346251, +548539, +553641, +484402, +488161, +480505, +484577, +508108, +527830, +556046, +484416, +556048, +528711, +344631, +556483, +380638, +489800, +500057, +505390, +518081, +547383, +500056, +518080, +491182, +554133, +547274, +528071, +547718, +480530, +485008, +527582, +547675, +528382, +551452, +556015, +527814, +547316, +528331, +528691, +345549, +346534, +344385, +551164, +346066, +552716, +346108, +545601, +383076, +557449, +486815, +457090, +346065, +391347, +557630, +547148, +545685, +344462, +385170, +457541, +344581, +457619, +383169, +344582, +344583, +344584, +344586, +344626, +383145, +344699, +451369, +484384, +382341, +409332, +480517, +484465, +551611, +345548, +380826, +552671, +527922, +527923, +451420, +527924, +550931, +545579, +520193, +406302, +558745, +507782, +514231, +383103, +347002, +151136, +344511, +344536, +344644, +484979, +344755, +344756, +451282, +344508, +344531, +344532, +500051, +485143, +481325, +379279, +383975, +344625, +344954, +345374, +527990, +486914, +344535, +151149, +406304, +486754, +451392, +486816, +521621, +521622, +391324, +344917, +519111, +344607, +527989, +380770, +486755, +486756, +500048, +527413, +410890, +382363, +547343, +345661, +527414, +527415, +344533, +553542, +527953, +544801, +480469, +559369, +383833, +485069, +550911, +345390, +485082, +344798, +490119, +527968, +385174, +383093, +478698, +478699, +483704, +483705, +547706, +553541, +480499, +345443, +528330, +345802, +345918, +346049, +527970, +527971, +346443, +478696, +478697, +484401, +408752, +383137, +344687, +544800, +484403, +344445, +552036, +345766, +345767, +345768, +345769, +486879, +390530, +390577, +390578, +390609, +390649, +390653, +390679, +390688, +390711, +390716, +390729, +390761, +390792, +390934, +390955, +391000, +391039, +391046, +391050, +391069, +391103, +391108, +391114, +391161, +391185, +391187, +391307, +528122, +532519, +457291, +457294, +457313, +457314, +551807, +544769, +544787, +527252, +407027, +345177, +380841, +487579, +487580, +519113, +544729, +345038, +345039, +380840, +346056, +480503, +478716, +542603, +542604, +528276, +501663, +552685, +547382, +483744, +447437, +448444, +484432, +480466, +558541, +558542, +558543, +554428, +547687, +345927, +528094, +528096, +528097, +528098, +528099, +517972, +346007, +552732, +527398, +545492, +545493, +547138, +553802, +559066, +517965, +527430, +528262, +559065, +548638, +526623, +527204, +527205, +527206, +527207, +527209, +527208, +528068, +346549, +345931, +527928, +344457, +344458, +527925, +544796, +379198, +527927, +553890, +557633, +527860, +527861, +545602, +544237, +346757, +480458, +480459, +543596, +543595, +543593, +543594, +345772, +558419, +492096, +345080, +391399, +528313, +345054, +544730, +544781, +542584, +544731, +544732, +544782, +544783, +542583, +544784, +544785, +547333, +391384, +527779, +485098, +554037, +528261, +476583, +476626, +477375, +547007, +551606, +483703, +521620, +527828, +485087, +547715, +507678, +507679, +485142, +485085, +501187, +551156, +526638, +526639, +345758, +528185, +485035, +547190, +528056, +527965, +485034, +380827, +344748, +345112, +345116, +384992, +345119, +345122, +345131, +345555, +345759, +346964, +527316, +547351, +346366, +547352, +545607, +478711, +477410, +477411, +544748, +527775, +527850, +480462, +483743, +485001, +484997, +485002, +485003, +485004, +485005, +485057, +487203, +488157, +488158, +488174, +486882, +518088, +530882, +528323, +544711, +545694, +547420, +547419, +556035, +508099, +345837, +345838, +487487, +506909, +506908, +485136, +528269, +345836, +527776, +517966, +544761, +544236, +481324, +484578, +545599, +391418, +519129, +486860, +410714, +480525, +488159, +346774, +380811, +423797, +480519, +484527, +484803, +484931, +484932, +486857, +486858, +501664, +527581, +527821, +527822, +528696, +546978, +547772, +484437, +546981, +346001, +484529, +551589, +447440, +448159, +553847, +544767, +527795, +345775, +557640, +557639, +547425, +547347, +547426, +486846, +547387, +483759, +484411, +488141, +31366, +527945, +344488, +30979, +551612, +556006, +519133, +557545, +551446, +477423, +527807, +554327, +484442, +345094, +556093, +345096, +161894, +161896, +161883, +161885, +161892, +161893, +161886, +161887, +528273, +161737, +161763, +161762, +161726, +161854, +161900, +161707, +161728, +161727, +161718, +161719, +161720, +161721, +161724, +161725, +161722, +161723, +161855, +161852, +161853, +161701, +161702, +161903, +161713, +161703, +161704, +161705, +161733, +161734, +161735, +161736, +161710, +161711, +161764, +161765, +161766, +161767, +161768, +161769, +161898, +161899, +161700, +161697, +161698, +161714, +161739, +161740, +161738, +161781, +161789, +161790, +161791, +161773, +161775, +161776, +161793, +161794, +161813, +161815, +161816, +161817, +161818, +161819, +161821, +161823, +161825, +161826, +161827, +161806, +161809, +161810, +161829, +161830, +161841, +161843, +161844, +161846, +161849, +161831, +161832, +161833, +161834, +161835, +161873, +161875, +161874, +161879, +161878, +161860, +161863, +161865, +161867, +161850, +161858, +161757, +161758, +161760, +161754, +161851, +161741, +161743, +161753, +161761, +161745, +161770, +161796, +161797, +161798, +161799, +161800, +161801, +161802, +161803, +161904, +161909, +161910, +164798, +164801, +164799, +164802, +163704, +163784, +163998, +164806, +164805, +163705, +164807, +164808, +163706, +163707, +163708, +163710, +163715, +163716, +163714, +163713, +163711, +163709, +163717, +163718, +163720, +163719, +163721, +163724, +163712, +164812, +164813, +164810, +164811, +164814, +164809, +164816, +164815, +163700, +163699, +163873, +164800, +163738, +163735, +163739, +163743, +163736, +163744, +163737, +163758, +163762, +163766, +163759, +163763, +163767, +163760, +163764, +163768, +163761, +163769, +163746, +163754, +163747, +163751, +163748, +163752, +163756, +163749, +163753, +163757, +163770, +163771, +163772, +163779, +163782, +163774, +163776, +163780, +163783, +163775, +163777, +163778, +163725, +163701, +163702, +163727, +163728, +164595, +164977, +164978, +164979, +164980, +164981, +164982, +164913, +164914, +164915, +164916, +164917, +164918, +163806, +163839, +163788, +163841, +163844, +163847, +163838, +163840, +163842, +163843, +163846, +385112, +385115, +163802, +163793, +163794, +163730, +164778, +164983, +346827, +163824, +164761, +164112, +164113, +164185, +163726, +163897, +163849, +163848, +163854, +163855, +163850, +163851, +163856, +385154, +163971, +163972, +163941, +163973, +164820, +164600, +164598, +164601, +164094, +164095, +164567, +344383, +164587, +164592, +164579, +165005, +164729, +164111, +164110, +164109, +164102, +164105, +164106, +164107, +164108, +163556, +164103, +164104, +163974, +164776, +164777, +164781, +164782, +164783, +164784, +164785, +164780, +164923, +164841, +164096, +164097, +164098, +164819, +164730, +163857, +164612, +163795, +164594, +164922, +164919, +164920, +164984, +163858, +163731, +163732, +164763, +164623, +163692, +163909, +164986, +164987, +163263, +164985, +163785, +165000, +163691, +165001, +164117, +165002, +165003, +164118, +164119, +163729, +382384, +382383, +165052, +346475, +422829, +385147, +164911, +164100, +164101, +164884, +164890, +164870, +164872, +164875, +164877, +164855, +164856, +164857, +508065, +163942, +381722, +161666, +164088, +164089, +340369, +340370, +340371, +340372, +163790, +163792, +163797, +163798, +163799, +163800, +163801, +163796, +164087, +527416, +527417, +527418, +527420, +164167, +164168, +164169, +164170, +164171, +164172, +164134, +164135, +379283, +163822, +164759, +164760, +164180, +164183, +379260, +379261, +379262, +164765, +164764, +164748, +164142, +164143, +164140, +164141, +380724, +164735, +380726, +164817, +164138, +164139, +164136, +164137, +164155, +164154, +164153, +163931, +164767, +164086, +163907, +164775, +164568, +164569, +164162, +164160, +164161, +164742, +164743, +164144, +163975, +164892, +164891, +164158, +163938, +163940, +163937, +163939, +163929, +163992, +163993, +163994, +163995, +163996, +163977, +163979, +163981, +163984, +163986, +163989, +163910, +163911, +385123, +385125, +163997, +163978, +385130, +385131, +163982, +385140, +163991, +163933, +164769, +164006, +164012, +164013, +164007, +164755, +164756, +164771, +385150, +164581, +164880, +164881, +163945, +163946, +164609, +164610, +164611, +164608, +164603, +164758, +164619, +164620, +164739, +164766, +164734, +164733, +336690, +163865, +163866, +163867, +163868, +163869, +164584, +163914, +163915, +163917, +164772, +164774, +163925, +163926, +163927, +163928, +163922, +163923, +163924, +163918, +163919, +163920, +163930, +163932, +164133, +164130, +164131, +164788, +164787, +163912, +163913, +385152, +385153, +164128, +164129, +164126, +164127, +164585, +164586, +505393, +508059, +164803, +164910, +163557, +164740, +164741, +164770, +164166, +164164, +163864, +164090, +164091, +164151, +164152, +164149, +164150, +527834, +164909, +164147, +164148, +164145, +164146, +164750, +164751, +163553, +163690, +163523, +163693, +163646, +163294, +163555, +164738, +164746, +164747, +164753, +164754, +164990, +164991, +164992, +164993, +164994, +164996, +164998, +164989, +164296, +164295, +164297, +164298, +164229, +164230, +164231, +164232, +164233, +164234, +164235, +164236, +164241, +164242, +164243, +164245, +164246, +164249, +164247, +164292, +164294, +164291, +164258, +164259, +164260, +164262, +164263, +164265, +164266, +164267, +164274, +164275, +164276, +164278, +164279, +164282, +164286, +164271, +164293, +164299, +164818, +164839, +164831, +164833, +164834, +164835, +164836, +164837, +164838, +164840, +164223, +164224, +164225, +164226, +164227, +164222, +164021, +164018, +164017, +164020, +164019, +164016, +163366, +163367, +163368, +163369, +163370, +163372, +163373, +163374, +163375, +163376, +163377, +163378, +163379, +163380, +163381, +163382, +163383, +163384, +163385, +163387, +163388, +559172, +559174, +559173, +163310, +163311, +163309, +163563, +163562, +163435, +163436, +163438, +163439, +163440, +163442, +163443, +163444, +163445, +163446, +163447, +163448, +163450, +163451, +163452, +163453, +163454, +163455, +163456, +163457, +163605, +163606, +163607, +163608, +163609, +163610, +163611, +163612, +163613, +163614, +163615, +163616, +163617, +163618, +163619, +163620, +163621, +163622, +163623, +163624, +163625, +163626, +163627, +163628, +163629, +163630, +163631, +163632, +163633, +163634, +163635, +163268, +163269, +163270, +163271, +163272, +163273, +163274, +163275, +163276, +163277, +163278, +163279, +163280, +163281, +163282, +163637, +163288, +163640, +163290, +163564, +163642, +163292, +163833, +163835, +163834, +163836, +163733, +164762, +558416, +558417, +163947, +163948, +164882, +163808, +163809, +163810, +163811, +163812, +163813, +164768, +164886, +164887, +164883, +164885, +164889, +163870, +164888, +164864, +164863, +164862, +164861, +164869, +164871, +164873, +346987, +164874, +164876, +164878, +164867, +164893, +164894, +164895, +164896, +164900, +164904, +164898, +164902, +164906, +164897, +164901, +164905, +164899, +164903, +164907, +164908, +164868, +405908, +164865, +164866, +163167, +163164, +163165, +385091, +163166, +162180, +163228, +163177, +163179, +163180, +163175, +163176, +163182, +163181, +163183, +163191, +162181, +163192, +163172, +163173, +163174, +163171, +163186, +163187, +163168, +163170, +163184, +163229, +163195, +163193, +163194, +163196, +163198, +163197, +546958, +163199, +163208, +163210, +163211, +163213, +162197, +163205, +163217, +163219, +163218, +163220, +162530, +161955, +162199, +163221, +162200, +163021, +163257, +163258, +163259, +163260, +163256, +163261, +163223, +163227, +163224, +163225, +163226, +163230, +163231, +163232, +163235, +163027, +163237, +162213, +162215, +163236, +162216, +163242, +385092, +163243, +546980, +163244, +163245, +163248, +163150, +163151, +163041, +162222, +163153, +163159, +162073, +163155, +163157, +163045, +385076, +163262, +163046, +163252, +163253, +163239, +163255, +519098, +161681, +161676, +161677, +161678, +161679, +161680, +161682, +161683, +161684, +161685, +161686, +161688, +161687, +164114, +163950, +163969, +163966, +163697, +163695, +163696, +163694, +163698, +163803, +164854, +164853, +163413, +163414, +163416, +163417, +163418, +163419, +163420, +163421, +163422, +163423, +163424, +163425, +163426, +163427, +163428, +163429, +163430, +163433, +163391, +163393, +163395, +163397, +163403, +163405, +163407, +163530, +163648, +163649, +163298, +163299, +163297, +163560, +163561, +163559, +163265, +163264, +163531, +163650, +163300, +163302, +163303, +163304, +163305, +163306, +163307, +163301, +163308, +164085, +164590, +164588, +164589, +163485, +163486, +163636, +163287, +163545, +163679, +163491, +163492, +344378, +344379, +344380, +163654, +163314, +163312, +163315, +163316, +163317, +164859, +163656, +163657, +163658, +164848, +164858, +163516, +163517, +163518, +163532, +163533, +163544, +163534, +163535, +163536, +163537, +163538, +163540, +163665, +163666, +163667, +163668, +163669, +163670, +163671, +163674, +163675, +163676, +163659, +163660, +163661, +163662, +163663, +163664, +163342, +163343, +163344, +163345, +163346, +163347, +163348, +163349, +163350, +163351, +163352, +163353, +163354, +163355, +163356, +163357, +163358, +163359, +163360, +163361, +163362, +163363, +163364, +163318, +163319, +163320, +163321, +163322, +163323, +163324, +163325, +163326, +163327, +163328, +163329, +163330, +163331, +163332, +163333, +163334, +163335, +163336, +163337, +163338, +163339, +163340, +163341, +163585, +163586, +163587, +163588, +163589, +163590, +163591, +163592, +163593, +163594, +163595, +163596, +163597, +163598, +163599, +163600, +163601, +163602, +163603, +163604, +163565, +163566, +163567, +163568, +163569, +163570, +163571, +163572, +163573, +163574, +163575, +163576, +163577, +163578, +163579, +163580, +163581, +163582, +163583, +163584, +163484, +163550, +163686, +163685, +163513, +163514, +163509, +163515, +163510, +163498, +163507, +163644, +163643, +163500, +163496, +163501, +163494, +163682, +163681, +163527, +163511, +163506, +163502, +163499, +163497, +163495, +163684, +163512, +163548, +163549, +163651, +163524, +163508, +163526, +163525, +508061, +407024, +163460, +163461, +163463, +163465, +163466, +163467, +163468, +163469, +163480, +163655, +163504, +163505, +163683, +163503, +163641, +163291, +163552, +163689, +163522, +164643, +164650, +164644, +164645, +164646, +164647, +164648, +164649, +164651, +164658, +164652, +164653, +164654, +164655, +164656, +164657, +164659, +163862, +163861, +163860, +164845, +164804, +164635, +164636, +164637, +164638, +164639, +164640, +164641, +164642, +164627, +164628, +164629, +164630, +164631, +164632, +164633, +164634, +164844, +163804, +164001, +163805, +164064, +164065, +164062, +164054, +164057, +164059, +164055, +164056, +164061, +164072, +164066, +164067, +164069, +164070, +164071, +164079, +164073, +164074, +164075, +164076, +164078, +164080, +164081, +164082, +164083, +164025, +164026, +164024, +164027, +164028, +164029, +164031, +164032, +164035, +164042, +164036, +164037, +164039, +164040, +164041, +164049, +164043, +164045, +164046, +164047, +164050, +164051, +164053, +164084, +164022, +164023, +164660, +164672, +164673, +164625, +164668, +164669, +164670, +164671, +164662, +164663, +164664, +164665, +164666, +164667, +164674, +164572, +164574, +164571, +164573, +164661, +164728, +164843, +164842, +164846, +164675, +164676, +164709, +164710, +164711, +164720, +164721, +164722, +164723, +164725, +164727, +164712, +164713, +164715, +164717, +164719, +164847, +164694, +164696, +164693, +164695, +164697, +164704, +164698, +164699, +164700, +164708, +164702, +164705, +164706, +164707, +164677, +164679, +164680, +164681, +164685, +164682, +164684, +164692, +164686, +164688, +164689, +164690, +164691, +164939, +164626, +481329, +163814, +163815, +164937, +164935, +164924, +163816, +164791, +164797, +164795, +164792, +164794, +164934, +164933, +164925, +164928, +164929, +164930, +164927, +164931, +164932, +164926, +528055, +164936, +346581, +163558, +163677, +163678, +163487, +163488, +163489, +163490, +163638, +163639, +163289, +163687, +163688, +163519, +163521, +163520, +163645, +163293, +163551, +163877, +163880, +163874, +163890, +163889, +163883, +163878, +163886, +163891, +163879, +163887, +163885, +163888, +163884, +163881, +163893, +163876, +385073, +163894, +163895, +163875, +163882, +163999, +164000, +163827, +163828, +163829, +163830, +163831, +163832, +164851, +164850, +164849, +164002, +164003, +164004, +164120, +164005, +164188, +164197, +164199, +164187, +164189, +164191, +164193, +164195, +164407, +164413, +164410, +164359, +164362, +164365, +164368, +164371, +164374, +164377, +164380, +164383, +164386, +164389, +164392, +164395, +164398, +164401, +164404, +164409, +164415, +164361, +164364, +164367, +164370, +164376, +164379, +164385, +164388, +164391, +164394, +164397, +164403, +164406, +164408, +164414, +164411, +164360, +164363, +164366, +164369, +164372, +164375, +164378, +164381, +164384, +164387, +164390, +164393, +164399, +164402, +164405, +164560, +164561, +164184, +164453, +164455, +164457, +164459, +164461, +164463, +164465, +164467, +164469, +164471, +164473, +164475, +164477, +164479, +164481, +164483, +164485, +164487, +164489, +164491, +164493, +164495, +164497, +164499, +164501, +164503, +164505, +164506, +164507, +164508, +164509, +164510, +164511, +164512, +164513, +164514, +164515, +164447, +164450, +164442, +164452, +164449, +164443, +164446, +164444, +164451, +164441, +164440, +164454, +164456, +164458, +164460, +164462, +164466, +164468, +164470, +164472, +164474, +164476, +164478, +164480, +164484, +164486, +164488, +164490, +164496, +164502, +164504, +164212, +164213, +164214, +164215, +164217, +164218, +164219, +164220, +164563, +164565, +164523, +164516, +164517, +164518, +164519, +164520, +164521, +164522, +164524, +164300, +164301, +164302, +164303, +164209, +164210, +164211, +164423, +164425, +164426, +164427, +164336, +164341, +164339, +164304, +164306, +164308, +164310, +164312, +164314, +164316, +164318, +164320, +164322, +164324, +164326, +164328, +164330, +164332, +164334, +164337, +164342, +164340, +164305, +164311, +164319, +164321, +164329, +164331, +164338, +164428, +164357, +164358, +164350, +164351, +164352, +164353, +164354, +164355, +164356, +164544, +164546, +164548, +164551, +164550, +164556, +164552, +164557, +164347, +164343, +164348, +164545, +164547, +164549, +164559, +164553, +164349, +164344, +164542, +164543, +164554, +164555, +164346, +164541, +164534, +164535, +164536, +164538, +164539, +164540, +164532, +164525, +164526, +164527, +164528, +164529, +164530, +164531, +164533, +164429, +164430, +164431, +164432, +164433, +164434, +164435, +164436, +164437, +164416, +164417, +164418, +164419, +164420, +164421, +164975, +164976, +164941, +164942, +164945, +164946, +164949, +164952, +164955, +164958, +164961, +164964, +164940, +164971, +165007, +165008, +165009, +165011, +165015, +165014, +486927, +484689, +486827, +484670, +484879, +527450, +527451, +484655, +484657, +547701, +346250, +485044, +487618, +553633, +544798, +544799, +550910, +550912, +550913, +558556, +487012, +480502, +380749, +547147, +551152, +551162, +550932, +528294, +528284, +528283, +487362, +528234, +501194, +527825, +551437, +528201, +528200, +528196, +528195, +528193, +528190, +528192, +528189, +528188, +528112, +528184, +528104, +528127, +528129, +528172, +528302, +487575, +557638, +486774, +505870, +547178, +547427, +447428, +526746, +526747, +526748, +346656, +526743, +346912, +346913, +346914, +347049, +347050, +346204, +347051, +505871, +410777, +505872, +505873, +505874, +347054, +447430, +505875, +505876, +505877, +505878, +505879, +505880, +526744, +505881, +505882, +505934, +526745, +345993, +346905, +346906, +346907, +345949, +345950, +543591, +526749, +505935, +505936, +505937, +505938, +505940, +505941, +505943, +505944, +505945, +505946, +505947, +505948, +505949, +506191, +506192, +506194, +506195, +506196, +506197, +506198, +506199, +506200, +506201, +346187, +478704, +478705, +506202, +505942, +505939, +547695, +547696, +457075, +345955, +345956, +345957, +346189, +345958, +346190, +345959, +345960, +345961, +345962, +345963, +345964, +345965, +506156, +506157, +506158, +457074, +506159, +346188, +505950, +506193, +506160, +346661, +457079, +457078, +345984, +506162, +506161, +506163, +506164, +447425, +506165, +506166, +506144, +345985, +345992, +521618, +521617, +552702, +527428, +484422, +546976, +546977, +559123, +555713, +507651, +418459, +528694, +528695, +451407, +501660, +551441, +484681, +551635, +547110, +447439, +527788, +26877, +26887, +37523, +37557, +37589, +552668, +547163, +38179, +38184, +38186, +38250, +38342, +38478, +38481, +485051, +527400, +527401, +527402, +527403, +527404, +527405, +527406, +527407, +527408, +528047, +550928, +547730, +547183, +547260, +545483, +408717, +383944, +527562, +507683, +542591, +542592, +531997, +507684, +519115, +526636, +528076, +447808, +527210, +547729, +547356, +478586, +344418, +556488, +547733, +547168, +547258, +484481, +526635, +547184, +447622, +477416, +547259, +555854, +553552, +547263, +380781, +547008, +547722, +346060, +488172, +383954, +487201, +383952, +484893, +547776, +477436, +383084, +559168, +557636, +547153, +553492, +542593, +542594, +447998, +547354, +447498, +413625, +547199, +487010, +391421, +383933, +528693, +547191, +527308, +528248, +531996, +547731, +551453, +488171, +451414, +488173, +547355, +547198, +383950, +547223, +380670, +451413, +494093, +494094, +528075, +555853, +489467, +557637, +527973, +555859, +527452, +546961, +546962, +558408, +346638, +547336, +506445, +547337, +527445, +448666, +448672, +380637, +545688, +551625, +552750, +487604, +557644, +447874, +542596, +485037, +551427, +484822, +384998, +405922, +407028, +559175, +345023, +345016, +345017, +345019, +345021, +384949, +556114, +345032, +345033, +550922, +458540, +345034, +481331, +554038, +345035, +551592, +345099, +552669, +447891, +512767, +512766, +512868, +512704, +512111, +512288, +481320, +451410, +484459, +547241, +485041, +554046, +494262, +547716, +344608, +345400, +345641, +360417, +360418, +56781, +4311, +4380, +4381, +360598, +57097, +427702, +431701, +360741, +57351, +4618, +4622, +4701, +361102, +361103, +57543, +361146, +4905, +361414, +58332, +4944, +361690, +58421, +361767, +58498, +361920, +361931, +361942, +361944, +342249, +362079, +58781, +362451, +421004, +362583, +362628, +5245, +59062, +59165, +362833, +362834, +362847, +362865, +427724, +59293, +362984, +362994, +363007, +363012, +59329, +363079, +363151, +363356, +363361, +363367, +363392, +363400, +363409, +363510, +338569, +5580, +5581, +59533, +364064, +364071, +364075, +30463, +364125, +65132, +364205, +364229, +364440, +364494, +6000, +364672, +364706, +6062, +6063, +6066, +6076, +6078, +338788, +6103, +6105, +6106, +6107, +338793, +6111, +364799, +364866, +364885, +364892, +365004, +365012, +365060, +365192, +342803, +445965, +413122, +413123, +413194, +546983, +548639, +528305, +545600, +547770, +345414, +528243, +427182, +427206, +427210, +427224, +60147, +60150, +60154, +60156, +60200, +60294, +60454, +60479, +60556, +60572, +60693, +61124, +430350, +547724, +483727, +365924, +366063, +366065, +366194, +366196, +366240, +366277, +366305, +366308, +366313, +366458, +366462, +366542, +366658, +366752, +366765, +367136, +367233, +367303, +367814, +367818, +367931, +368221, +368290, +368291, +368329, +368714, +368715, +368773, +368784, +368785, +368805, +368828, +368863, +368891, +369147, +369179, +369203, +369665, +369692, +369698, +369949, +369979, +369983, +369994, +371857, +372123, +372560, +372613, +372616, +372862, +430997, +341360, +6381, +6382, +6387, +6412, +6413, +6425, +6427, +6428, +6429, +6485, +6521, +6522, +6591, +6603, +6604, +6642, +6643, +6664, +6721, +6724, +6725, +6726, +6727, +6731, +6752, +6755, +7087, +7366, +7383, +7402, +7740, +339303, +8828, +157209, +157236, +157274, +157310, +62805, +27174, +27178, +27180, +27199, +27203, +27225, +27298, +65206, +65220, +65226, +65234, +65269, +65270, +65271, +65294, +65295, +65298, +65299, +65300, +65304, +65305, +65307, +65308, +65310, +65313, +487606, +487253, +488000, +488001, +488002, +487998, +488003, +488004, +488005, +488006, +488007, +488008, +488009, +488010, +488011, +488012, +487999, +488013, +488014, +488015, +488016, +488017, +485048, +481314, +545472, +544714, +344856, +490112, +553556, +409340, +531991, +373687, +547717, +344403, +344894, +486824, +480490, +345744, +391322, +381117, +451402, +553547, +544806, +527975, +346040, +346647, +344662, +346589, +494710, +346985, +345388, +486866, +346194, +448445, +346290, +479216, +344713, +344714, +484420, +484386, +554100, +344966, +345726, +547321, +478706, +380768, +382171, +382173, +344826, +382166, +405969, +382090, +344885, +480454, +485116, +344909, +410874, +380630, +458550, +458549, +379202, +554443, +346314, +346586, +345828, +346662, +527559, +555822, +381124, +406232, +346810, +552021, +383119, +345545, +447398, +345546, +383897, +385201, +346271, +385200, +345199, +478629, +481326, +484430, +487615, +508183, +383971, +480475, +344793, +345648, +481318, +383088, +480532, +345184, +345183, +547010, +373686, +344409, +486747, +345626, +345323, +345628, +383150, +484473, +345933, +346751, +346725, +346868, +458521, +380843, +451360, +408712, +347032, +347033, +344384, +345212, +558739, +345213, +383081, +345217, +345219, +391422, +554119, +554120, +554121, +554122, +554123, +554125, +547309, +547310, +547311, +547312, +547270, +547313, +544713, +345676, +345677, +345678, +518036, +527561, +559171, +527577, +527578, +527579, +559170, +347034, +451281, +346476, +397321, +544716, +345695, +551154, +373728, +481327, +345681, +552676, +552678, +379263, +551155, +383089, +481319, +391340, +547390, +484455, +484456, +478628, +493938, +345574, +345578, +345579, +345582, +345586, +345786, +345788, +345790, +528683, +547235, +544807, +478630, +346010, +491184, +345209, +345536, +345537, +347058, +345694, +481315, +345634, +552675, +346521, +346296, +346822, +558544, +484936, +484981, +346259, +346260, +345193, +544715, +345194, +345846, +451368, +557652, +557651, +346413, +346164, +406303, +346165, +405903, +405904, +547262, +531990, +554068, +383121, +383122, +483733, +479207, +385008, +479208, +486896, +391341, +487014, +478627, +380636, +385223, +407030, +409342, +409343, +479056, +527810, +548651, +554601, +526738, +373711, +494806, +346266, +483708, +484984, +553592, +553593, +553596, +530269, +487624, +382522, +382651, +382716, +382728, +382811, +382807, +382810, +407344, +407360, +422756, +422770, +547252, +547011, +382850, +382871, +382874, +382881, +382888, +382892, +382896, +382897, +382898, +383027, +407418, +527558, +479218, +526622, +527585, +500050, +527783, +528303, +527915, +547683, +383155, +552673, +527914, +345387, +478847, +479206, +344390, +346178, +346420, +347044, +507677, +553513, +519110, +345930, +346982, +346983, +446618, +346522, +528275, +556583, +544235, +545598, +553535, +558650, +556582, +345996, +527851, +527852, +527853, +527854, +527855, +527856, +506348, +479217, +547732, +485021, +447431, +547386, +346011, +547196, +344790, +556589, +528244, +552747, +552703, +486435, +486734, +344425, +407004, +344501, +501195, +406877, +406880, +344890, +391396, +345373, +346067, +406891, +406894, +406946, +407272, +345124, +345540, +344495, +486742, +527232, +527172, +547136, +547137, +151556, +528308, +380569, +457589, +380573, +380578, +380597, +380598, +544820, +527443, +501197, +505843, +346533, +547169, +494807, +494808, +547238, +527974, +507655, +552710, +481322, +527441, +451279, +487495, +479054, +556645, +550918, +344802, +380694, +380695, +344391, +380693, +547154, +551428, +344884, +477434, +346684, +346792, +447862, +458699, +480529, +481317, +486844, +487681, +487682, +494565, +527409, +528247, +532520, +532521, +545555, +551158, +551429, +552729, +345748, +344415, +344999, +344413, +385222, +385221, +413969, +413968, +547244, +458698, +413970, +547243, +547242, +345994, +346062, +344416, +346097, +346166, +346390, +346547, +346685, +486743, +479215, +344414, +547677, +550917, +550919, +486976, +505391, +486974, +514230, +552705, +527454, +528309, +527446, +547182, +557645, +385217, +558651, +489468, +528091, +528702, +528703, +528704, +528705, +383888, +547276, +488150, +491749, +491750, +528042, +518024, +528292, +528293, +518023, +518028, +518030, +528114, +528186, +528208, +528217, +528227, +528228, +528229, +559365, +518026, +518029, +518025, +518027, +487140, +519106, +344466, +406289, +344468, +344507, +413623, +553561, +383079, +508101, +413631, +532515, +447875, +344717, +344932, +344475, +344831, +485112, +484491, +344778, +484458, +556028, +508107, +346843, +346845, +346846, +406227, +406228, +406229, +418465, +448717, +448720, +487600, +501666, +501667, +384999, +527453, +544705, +544706, +544707, +345484, +345795, +411463, +411473, +411526, +411528, +411530, +411535, +411538, +411539, +411549, +411555, +411575, +550909, +550907, +550908, +411623, +411624, +411626, +411631, +411637, +411725, +547142, +411896, +411898, +411908, +411947, +411984, +408762, +478715, +527941, +458511, +478714, +410906, +410907, +410904, +527372, +527373, +552749, +486745, +542585, +548532, +519108, +484753, +543610, +346626, +413629, +552039, +418455, +545512, +451371, +382352, +382351, +385195, +551430, +484983, +528121, +380731, +550929, +422878, +383830, +346707, +346747, +446298, +471407, +483738, +483739, +485127, +485128, +485129, +487673, +527312, +527934, +381113, +381112, +381114, +413628, +457617, +385181, +384957, +381115, +384952, +345875, +519116, +93217, +93198, +93199, +93200, +93176, +93178, +544818, +544819, +93221, +550920, +550921, +556568, +344426, +528093, +545677, +554585, +554405, +484804, +527790, +528319, +346325, +344487, +446578, +528320, +527797, +528092, +344427, +31326, +31335, +31337, +31339, +31346, +31348, +488039, +501659, +501656, +501658, +501657, +485028, +485029, +518076, +518077, +518075, +485025, +485026, +485027, +488040, +485107, +487562, +544802, +487635, +489719, +486761, +528709, +553635, +345852, +383159, +557370, +557369, +526740, +344887, +553634, +547208, +546956, +487011, +528692, +544763, +546873, +467430, +484645, +528142, +556646, +527787, +547253, +553488, +503321, +503322, +503323, +503324, +503325, +447296, +447273, +409298, +513417, +421468, +491179, +544745, +544749, +547375, +547402, +551431, +554103, +554104, +556647, +379205, +446951, +544725, +346122, +528714, +344382, +547728, +409109, +346124, +409279, +344674, +409115, +491738, +409078, +409079, +547222, +409234, +409273, +409097, +409134, +556644, +480434, +527199, +556039, +551153, +488145, +487683, +505394, +528224, +507676, +528054, +391417, +345140, +471428, +422831, +380773, +517964, +517970, +335644, +335645, +335650, +335654, +552726, +335661, +554524, +335663, +476189, +380757, +527940, +335673, +345485, +491168, +335677, +553619, +489413, +489407, +527429, +408759, +547212, +547140, +547708, +448443, +488175, +335687, +335688, +488165, +547139, +488022, +552738, +489174, +489346, +489432, +547141, +544743, +527447, +335696, +335697, +335698, +335699, +335700, +528617, +528618, +335702, +530730, +448441, +530748, +528622, +478616, +505269, +530771, +335712, +530767, +384932, +335713, +335714, +341540, +527200, +477413, +532423, +532419, +532422, +335724, +489317, +489316, +489150, +489453, +489242, +335725, +507672, +335726, +335727, +335729, +335730, +335731, +335732, +335737, +335738, +335740, +335744, +335749, +335751, +335754, +335757, +545576, +335758, +335763, +519097, +547768, +344402, +344448, +344449, +451289, +344451, +344522, +553887, +552730, +486888, +409329, +552731, +447876, +344616, +480513, +473754, +484762, +490106, +527448, +547366, +553618, +335772, +335779, +335785, +335788, +346701, +335789, +335790, +335791, +335792, +380669, +384926, +335797, +335798, +335800, +335801, +335804, +335807, +384928, +335808, +383149, +335812, +335813, +335814, +335816, +335817, +545545, +335820, +527976, +547211, +335825, +391377, +530764, +530762, +335830, +527831, +335831, +483706, +335835, +554606, +544821, +551463, +545473, +558744, +557447, +558743, +544757, +544760, +544758, +528311, +528341, +544759, +547684, +547685, +553840, +551458, +551459, +551460, +551461, +344657, +30823, +30836, +487663, +409966, +345723, +108244, +108209, +108203, +108204, +108205, +108206, +514032, +547779, +527889, +546342, +527901, +546346, +527902, +528321, +527888, +527892, +528304, +527891, +546404, +527887, +490110, +527442, +547777, +547350, +551864, +547134, +551591, +543606, +542602, +405068, +345920, +404974, +391359, +344763, +397336, +379324, +151030, +481995, +397352, +527563, +346740, +151057, +383175, +551150, +151060, +151074, +151080, +151098, +344634, +344823, +344824, +344820, +397337, +448714, +457543, +344632, +486772, +527818, +545561, +547295, +405734, +553491, +31642, +31687, +31706, +31711, +487225, +447797, +530887, +530886, +530885, +530884, +485014, +485015, +485016, +487675, +551426, +551596, +551597, +551598, +551599, +344696, +551016, +551031, +551033, +552713, +550925, +527399, +527253, +380641, +383837, +526739, +528290, +478323, +478326, +478420, +478394, +498802, +527906, +498892, +478303, +478318, +478316, +345734, +478309, +478345, +498998, +499010, +505554, +344953, +526732, +554106, +380844, +547338, +344606, +21444, +345405, +547266, +345257, +486870, +480482, +486884, +545691, +542595, +38804, +38811, +490086, +547171, +479209, +527933, +519096, +505556, +480470, +373719, +507653, +446753, +344489, +446752, +480531, +484995, +484996, +544747, +380764, +484866, +547676, +381715, +344600, +485030, +517962, +446755, +558546, +344753, +527932, +484483, +552712, +527832, +484982, +480518, +558547, +344386, +380845, +406271, +407018, +407019, +451283, +477409, +481323, +483740, +484380, +484810, +486851, +486852, +507654, +507682, +519095, +527313, +527571, +527572, +527573, +527800, +528043, +528332, +528306, +531987, +544234, +545695, +547233, +547341, +547678, +547693, +547745, +550923, +551694, +551886, +554328, +555629, +555628, +556493, +557450, +558545, +345105, +345346, +9269, +9273, +487617, +383113, +553489, +528253, +480451, +544233, +526742, +487261, +543608, +487993, +487992, +505553, +527410, +544794, +526750, +491753, +480509, +39119, +39144, +447878, +457097, +39170, +39295, +487571, +487572, +547345, +547346, +553848, +553850, +553849, +559081, +487570, +481328, +486801, +487671, +383608, +383611, +383612, +383613, +383626, +383811, +547264, +383791, +383789, +383750, +383752, +383749, +383783, +383818, +383813, +383804, +383798, +383801, +383688, +383693, +383768, +551161, +481307, +528113, +547225, +551601, +383610, +346125, +547385, +455794, +455825, +455839, +455856, +455917, +455921, +456085, +456189, +456799, +527455, +527456, +518045, +528381, +528110, +528111, +546982, +484379, +527952, +420729, +548541, +384896, +421409, +421411, +383995, +383997, +383998, +344530, +384002, +384004, +384005, +421413, +384010, +384108, +384033, +384042, +384053, +384056, +547707, +384081, +384094, +384095, +384574, +384762, +384577, +384584, +384592, +384130, +384815, +384526, +384385, +384876, +384432, +384886, +420749, +519086, +344788, +449023, +505549, +505550, +547194, +547195, +547720, +552742, +552741, +546959, +546960, +505271, +344724, +384907, +501201, +527350, +555653, +527349, +553804, +553805, +553806, +553807, +553803, +553808, +553809, +553810, +553811, +553812, +553813, +553814, +553815, +552733, +552735, +553834, +527967, +528053, +527815, +544703, +544702, +552688, +551932, +508188, +551443, +384988, +551595, +527584, +486837, +544717, +527980, +553554, +480508, +552670, +494809, +550924, +488178, +528265, +546967, +554444, +528268, +554138, +491197, +490114, +346998, +528684, +380782, +528264, +546965, +546964, +506907, +528267, +380785, +527983, +548652, +345564, +551869, +547710, +547711, +551868, +485032, +545605, +480477, +528254, +505389, +553835, +553836, +484391, +553837, +553838, +553839, +544752, +553826, +553827, +553828, +544750, +544753, +544751, +553822, +553823, +553816, +553817, +553818, +553829, +553830, +553831, +553824, +553825, +553819, +553820, +553832, +553833, +486798, +485039, +555861, +382385, +499497, +499495, +527910, +480476, +528312, +418454, +551120, +490108, +487621, +486759, +488160, +527978, +519093, +486836, +553543, +527966, +553640, +527982, +499489, +553544, +547224, +458683, +458684, +487529, +346318, +508189, +383911, +527992, +484582, +480471, +547176, +381126, +381125, +527919, +527984, +527921, +527431, +528286, +405919, +391397, +547314, +546957, +491175, +507686, +547151, +547213, +553555, +547261, +527981, +489465, +489466, +551121, +480495, +486758, +547282, +422825, +380784, +553548, +527979, +551931, +380732, +542577, +380847, +527786, +527917, +527911, +551159, +551893, +486778, +556010, +547175, +551604, +527817, +554589, +554588, +554587, +554586, +477435, +408716, +373705, +458695, +409345, +409346, +447927, +409347, +553889, +480506, +480507, +345221, +550915, +477426, +527918, +554134, +554135, +556648, +547391, +547663, +547392, +528236, +519092, +552740, +527816, +418476, +421209, +546963, +527784, +545603, +553484, +545604, +383844, +410897, +552683, +552684, +528255, +380787, +410883, +547393, +547394, +547395, +489805, +552739, +379301, +379302, +486757, +380602, +547697, +547698, +477428, +532002, +528287, +406287, +528288, +406288, +528289, +547234, +553549, +553550, +553551, +547236, +552687, +458681, +380786, +488164, +346988, +552689, +557653, +499501, +553841, +484998, +527960, +527961, +385005, +528266, +552734, +551445, +547680, +553487, +553639, +553490, +553638, +527785, +451397, +385213, +547188, +547187, +547186, +547185, +527962, +527963, +499499, +484462, +508190, +519094, +547152, +547149, +379276, +527314, +551122, +513414, +513415, +478622, +478618, +478619, +478620, +478621, +499493, +478710, +480461, +487388, +383829, +547150, +528685, +547423, +553485, +553495, +484999, +500064, +557641, +547281, +484390, +547422, +478694, +485113, +469410, +528159, +528270, +528157, +528154, +528152, +528148, +528272, +528168, +528176, +528169, +528177, +528171, +528178, +528179, +528271, +528180, +528181, +481279, +481250, +481245, +551607, +481161, +481162, +481160, +345997, +547009, +553560, +494568, +552727, +552728, +406239, +527780, +486861, +448127, +448431, +530879, +344963, +527781, +527782, +38713, +38714, +483755, +483756, +483757, +483758, +527374, +543597, +543599, +543598, +556221, +480456, +41159, +41163, +41183, +41179, +41187, +38689, +38707, +38711, +38693, +38700, +38704, +346623, +483750, +483751, +483752, +483753, +483754, +418479, +485046, +344571, +487461, +486750, +527956, +527954, +527955, +448715, +547699, +489760, +489837, +1936, +101483, +103463, +2254, +490920, +2262, +2266, +2269, +1722, +2449, +2458, +2459, +2461, +1724, +1729, +1730, +2513, +378867, +2554, +2574, +2580, +2583, +2585, +345619, +2619, +2632, +2633, +551967, +2669, +2671, +2672, +2673, +2674, +2675, +2677, +490942, +2679, +520179, +2682, +484377, +378881, +1740, +1785, +1786, +1787, +1788, +1789, +1790, +1791, +1792, +1793, +1794, +1796, +1797, +1825, +1834, +378944, +378945, +378946, +378947, +378949, +378951, +378952, +1849, +1855, +45199, +489749, +1900, +1901, +1910, +1916, +1959, +1976, +1978, +1980, +1981, +1982, +1983, +1985, +1986, +1987, +2015, +379003, +2029, +2066, +556490, +2077, +2082, +2083, +2084, +2179, +2180, +2182, +2198, +2199, +2200, +2201, +2202, +379055, +379059, +2294, +2297, +2298, +2322, +379086, +491031, +491032, +2353, +2357, +2367, +2369, +2372, +2378, +2379, +2380, +2393, +379106, +2423, +344395, +2425, +2426, +2427, +2429, +547197, +2464, +2479, +2496, +2504, +379129, +491080, +2540, +407416, +2588, +487987, +345522, +2599, +379152, +2629, +485047, +2638, +379153, +2642, +2652, +2653, +2654, +2666, +491142, +46678, +379122, +2589, +32010, +528251, +528249, +554041, +554039, +554040, +408725, +547681, +547694, +547363, +547362, +547361, +527972, +391392, +407023, +528070, +547360, +478703, +481321, +520194, +494260, +494261, +528069, +527957, +528197, +528173, +544708, +548534, +556101, +553845, +557631, +527432, +379219, +484792, +488156, +527819, +484381, +558422, +558421, +558420, +40952, +40969, +40984, +41011, +41058, +41067, +40703, +345928, +40708, +484575, +383148, +380658, +383086, +517968, +345318, +346338, +554624, +554625, +554626, +554627, +555847, +447945, +501183, +477421, +421472, +501184, +345999, +527859, +545490, +344893, +478708, +527857, +391424, +48905, +48958, +49034, +49084, +49089, +49090, +49115, +49222, +49270, +49279, +49281, +49283, +49366, +49435, +49437, +49512, +49522, +49533, +49583, +49585, +49596, +49598, +49599, +49630, +49636, +49668, +49673, +49681, +49706, +49726, +49735, +49739, +49741, +49745, +346571, +347019, +380765, +391339, +480504, +481997, +484457, +487614, +519101, +527916, +528132, +528237, +528257, +543609, +545491, +545550, +545549, +547180, +547181, +547320, +548655, +548656, +548657, +551165, +551439, +551879, +551880, +551881, +552667, +552674, +552681, +552736, +554107, +554130, +558412, +556504, +556590, +484468, +381111, +548542, +484580, +382367, +345102, +382374, +345103, +528191, +345134, +380814, +558418, +345171, +484469, +345172, +422880, +345175, +391419, +391420, +548654, +552751, +547381, +345521, +528279, +478617, +544803, +346128, +346227, +422814, +346364, +346558, +410908, +483746, +547746, +485104, +544712, +545562, +478707, +547251, +486805, +513316, +487620, +380794, +557538, +551887, +557539, +557537, +343612, +343630, +343688, +343632, +346235, +547167, +345773, +346655, +343595, +343896, +343911, +343940, +346676, +551432, +343769, +343722, +346478, +550914, +343699, +344058, +343902, +343635, +346132, +557540, +551442, +528095, +484431, +344562, +345497, +542601, +346986, +506446, +547155, +517973, +551934, +505552, +487585, +487594, +487601, +527201, +527777, +543470, +543471, +543472, +543473, +543474, +551450, +551462, +552737, +526642, +422873, +31432, +414349, +380510, +380511, +380512, +380513, +380514, +380515, +380531, +557544, +557543, +554069, +423641, +345457, +423723, +346984, +526641, +32059, +32061, +447989, +530881, +423614, +484947, +410561, +547377, +547378, +547376, +547380, +528380, +528680, +346540, +410749, +484434, +290540, +527804, +484388, +290041, +290042, +290038, +286146, +333863, +286533, +279213, +286924, +327343, +327346, +325661, +316368, +301007, +285209, +330349, +317001, +294087, +331061, +331674, +304443, +284909, +333968, +294259, +296942, +487199, +283281, +487197, +487198, +280879, +312389, +527949, +558548, +296388, +508102, +291723, +507694, +528295, +528296, +507695, +507697, +507696, +507698, +507699, +507700, +507674, +518079, +553653, +553652, +447884, +381721, +528103, +530861, +528128, +547771, +554048, +553886, +528322, +479205, +557448, +481867, +481873, +481884, +481942, +481956, +481966, +554075, +483631, +483589, +346651, +486856, +346869, +344664, +344718, +344720, +486889, +344667, +344698, +344747, +347043, +344796, +488177, +491751, +346712, +500060, +528259, +528298, +543612, +547319, +528297, +547193, +487360, +554052, +528258, +408710, +344803, +553711, +527384, +418467, +524709, +547284, +486813, +559078, +559368, +486812, +559080, +379316, +548533, +521439, +524439, +545608, +547673, +547674, +485130, +485131, +547280, +545474, +447497, +544762, +558740, +382311, +382336, +547349, +506429, +506430, +484389, +491177, +447811, +553801, +165356, +408705, +485059, +559018, +481985, +527908, +553636, +526741, +485055, +384973, +384972, +520176, +335155, +335174, +335214, +485119, +527319, +527909, +345752, +447988, +345470, +345341, +346854, +345469, +547130, +344398, +547131, +547132, +345805, +527947, +406254, +346852, +346888, +513318, +528077, +544822, +544823, +546452, +547143, +547231, +547232, +547296, +547688, +547689, +547690, +547691, +547692, +551088, +551425, +551424, +553712, +547230, +528080, +526733, +528078, +477437, +345601, +345602, +527560, +501203, +547162, +547344, +544808, +383960, +554132, +527564, +484472, +486752, +528246, +527943, +528219, +545471, +554128, +556489, +528245, +544809, +489471, +408751, +542597, +528250, +551933, +518006, +517997, +518013, +518011, +517993, +517994, +556007, +517995, +550934, +550935, +550936, +486748, +517996, +550937, +550938, +517998, +517999, +518000, +518001, +518003, +518004, +518005, +518008, +518009, +518010, +518012, +518014, +518015, +518016, +518017, +518018, +518019, +518020, +518021, +550939, +528107, +528108, +528109, +528149, +528151, +528153, +528117, +528119, +528120, +528135, +528136, +528138, +528139, +528141, +528144, +528147, +528155, +528163, +528167, +528170, +528209, +528210, +528211, +528215, +547616, +553637, +554334, +518022, +518002, +518007, +546984, +485019, +547388, +476670, +528715, +546968, +546969, +528252, +547170, +485100, +547773, +487677, +553496, +547767, +551806, +528256, +500079, +552743, +553623, +527792, +547358, +526736, +500080, +528347, +485033, +520180, +520181, +520183, +520184, +478623, +484365, +485043, +485018, +526637, +487676, +520185, +487633, +519114, +487678, +488148, +520186, +520187, +520188, +520189, +520190, +551423, +527444, +527920, +547359, +544754, +528143, +528145, +528146, +528156, +528223, +528225, +528686, +544766, +544786, +545686, +544817, +545556, +546951, +547714, +547734, +547747, +547766, +551422, +551609, +552686, +552745, +552746, +553846, +553624, +556108, +554131, +554410, +554411, +554525, +528329, +545595, +519134, +556115, +554077, +547133, +552690, +547765, +543222, +551921, +507667, +520182, +524711, +545692, +552865, +552866, +556559, +479055, +345284, +344621, +528316, +547269, +346723, +528314, +483728, +545606, +544790, +544791, +544792, +480528, +527805, +532518, +345856, +466614, +485099, +547357, +544722, +552189, +552190, +552191, +552176, +552177, +552216, +552183, +552207, +552210, +552186, +552142, +552208, +552209, +552188, +552180, +552149, +552150, +552151, +552206, +552147, +552152, +552153, +552154, +552141, +552155, +552157, +552156, +552148, +552160, +552116, +552117, +552118, +552119, +552120, +552121, +552122, +552123, +552124, +552125, +552161, +552099, +552100, +552101, +552102, +552103, +552104, +552105, +552106, +552107, +552108, +552109, +552110, +552111, +552112, +552113, +552114, +552115, +552159, +552158, +552140, +552138, +552139, +552137, +552146, +552145, +552144, +552143, +552133, +552134, +552132, +552136, +552135, +552130, +552129, +552131, +552126, +552127, +552128, +552196, +552197, +552203, +552205, +552204, +552194, +552200, +552202, +552201, +552198, +552199, +552193, +552192, +552195, +552187, +552211, +552213, +552214, +552212, +552215, +552182, +552181, +552169, +552168, +552167, +552166, +552165, +552170, +552164, +552163, +552173, +552172, +552174, +552171, +552220, +552162, +552217, +552218, +552219, +552185, +552184, +552091, +552092, +552093, +552672, +552040, +552041, +552042, +552043, +552044, +552045, +552046, +552047, +552048, +552049, +552050, +552051, +552052, +552053, +552054, +552055, +552056, +552057, +552058, +552059, +552060, +552061, +552062, +552063, +552064, +552065, +552066, +552067, +552068, +552069, +552070, +552071, +552072, +552178, +552094, +552095, +552096, +552097, +552098, +552179, +552175, +552081, +552082, +552083, +552084, +552085, +552086, +552087, +552088, +552089, +552090, +552073, +552074, +552075, +552076, +552077, +552078, +552079, +552080, +487212, +487215, +487214, +487213, +471418, +485105, +458546, +485058, +485060, +551464, +486773, +527806, +528231, +528233, +528232, +480460, +346884, +551435, +527813, +547384, +528280, +545676, +555617, +506912, +554076, +478615, +528206, +547220, +547401, +527433, +551163, +551804, +486796, +478848, +478849, +528063, +520191, +527799, +406183, +406186, +406185, +406187, +406188, +528698, +528277, +485040, +486839, +485083, +553630, +551610, +406294, +528707, +457545, +487628, +481311, +491180, +346677, +484502, +558551, +507670, +554111, +486753, +557643, +487507, +554744, +554032, +556484, +547204, +485089, +556003, +556002, +517991, +553486, +544815, +527778, +544700, +484482, +556622, +556752, +554297, +528044, +547759, +554745, +519128, +506375, +484443, +547749, +484392, +556588, +379209, +507702, +552709, +552744, +481312, +547421, +458688, +553715, +544824, +527987, +483736, +527570, +513317, +488162, +528300, +547752, +546955, +409323, +548625, +558754, +527827, +481313, +547750, +547207, +553629, +484368, +551433, +551605, +487616, +487557, +486760, +487558, +544704, +544795, +547726, +547617, +510669, +344639, +501198, +527969, +385205, +478712, +553626, +485053, +481986, +548540, +406192, +559079, +527950, +380803, +344760, +344805, +527411, +420112, +344898, +483726, +407335, +344936, +547702, +477427, +344972, +485140, +484366, +345751, +381131, +383840, +384982, +385203, +406191, +391402, +397371, +406255, +406256, +406267, +406280, +407020, +413328, +380789, +346669, +346726, +346730, +346731, +479170, +346836, +346839, +346887, +346931, +346932, +346952, +346981, +379177, +379297, +527986, +379285, +385207, +380715, +380809, +551629, +447991, +383158, +381144, +381143, +383898, +383116, +383141, +547277, +471421, +519087, +480452, +547342, +528337, +528045, +519088, +494559, +510837, +510838, +527565, +408739, +408765, +447886, +418456, +418457, +422832, +519089, +422893, +447924, +448436, +448726, +457626, +457539, +457328, +457623, +458538, +458551, +458691, +458685, +480457, +471409, +477419, +471411, +471424, +473743, +479211, +476664, +477417, +477418, +477420, +477425, +478624, +527395, +478625, +478626, +478709, +478713, +478854, +478850, +478851, +478852, +478853, +478855, +479212, +479534, +480463, +480464, +505272, +480473, +480474, +480515, +480516, +480479, +480480, +480481, +480510, +480511, +480514, +480521, +480522, +480524, +483707, +480527, +481310, +481987, +481988, +481989, +481990, +481991, +481992, +481993, +481994, +483731, +483734, +483735, +484579, +484364, +484378, +484393, +484394, +484395, +484436, +484503, +484470, +484471, +484504, +484479, +484485, +484486, +547304, +484929, +484933, +484928, +485007, +484937, +507668, +485009, +485020, +485061, +485062, +485063, +485139, +485134, +485135, +485137, +486739, +486890, +486891, +486892, +486893, +486894, +486795, +486788, +486789, +486790, +486843, +486840, +487210, +487184, +487211, +489469, +487205, +487206, +487207, +487405, +487668, +487664, +487665, +487666, +487667, +487669, +487670, +487629, +487630, +487631, +487632, +487994, +487995, +501662, +488024, +488036, +488037, +488143, +488146, +488147, +488169, +488170, +490115, +490116, +489470, +490104, +494560, +491181, +492095, +494561, +494562, +494564, +494711, +494712, +494095, +518048, +518049, +518050, +543600, +528263, +544728, +500071, +483747, +484720, +486800, +500072, +500073, +500058, +500074, +500062, +518038, +527791, +507669, +507656, +508103, +508104, +508105, +510670, +510671, +520192, +518039, +518040, +517992, +518041, +518062, +518084, +518085, +518087, +519090, +519091, +527557, +519109, +528058, +519102, +519103, +519104, +519105, +519117, +519118, +519119, +519120, +519121, +519122, +519123, +519124, +519125, +519126, +519127, +519130, +519131, +519132, +527203, +527386, +527387, +527388, +527389, +527390, +527391, +527392, +527434, +527393, +527254, +527380, +527376, +527811, +527317, +527318, +527812, +527396, +527435, +527377, +527397, +527566, +527567, +527575, +527576, +527796, +527801, +527802, +527803, +527823, +544723, +544724, +527824, +527912, +527848, +527913, +527929, +527930, +527931, +527959, +528073, +528074, +528174, +528051, +528052, +528060, +528061, +528062, +528115, +528118, +528124, +528125, +528199, +528102, +528194, +528101, +544793, +528281, +528106, +528182, +528158, +528345, +528134, +528133, +528131, +528130, +528137, +528213, +528214, +528150, +528203, +528162, +528164, +528165, +528187, +528198, +528212, +528216, +528218, +528220, +528278, +547744, +528238, +528239, +528204, +528126, +528207, +528242, +528299, +528282, +528700, +530802, +528310, +528346, +528679, +528701, +528712, +528713, +528710, +546989, +532522, +543467, +543468, +543469, +544701, +544710, +544746, +544756, +544811, +544812, +544813, +544814, +544816, +545546, +545548, +545557, +545596, +545609, +545610, +546953, +546954, +547203, +547192, +546970, +546971, +546990, +547164, +547165, +547166, +547179, +547202, +547205, +547200, +547201, +547206, +547221, +547218, +547219, +547240, +547257, +547278, +547279, +551434, +547305, +547307, +547326, +547322, +547323, +547324, +547325, +547353, +547364, +547365, +547367, +547396, +547397, +547398, +547399, +547400, +552707, +547700, +547703, +551590, +547723, +547735, +547736, +547741, +547742, +547743, +547737, +547739, +547751, +547756, +547762, +547763, +547764, +547774, +548538, +548535, +547775, +548536, +548537, +548637, +548653, +550916, +550930, +551151, +551157, +551160, +551447, +551448, +551602, +551593, +551652, +551813, +551814, +551815, +551816, +551817, +552038, +552037, +552222, +552714, +552715, +552748, +553493, +553713, +553494, +553537, +554101, +553628, +553546, +553553, +553625, +553631, +553632, +553714, +554031, +556106, +556107, +554033, +554109, +554110, +554113, +554114, +554115, +554116, +554117, +554118, +554519, +554746, +555618, +556018, +555952, +555953, +555954, +556217, +558555, +558554, +558553, +556753, +557452, +557635, +559044, +559022, +558753, +558550, +558549, +559016, +558752, +559021, +559020, +559017, +559043, +559372, +559371, +559370, +559361, +447887, +447888, +345835, +480472, +345839, +345867, +544810, +480523, +551449, +380804, +408755, +554296, +385017, +547761, +547239, +485138, +528064, +383153, +345285, +383910, +546988, +345344, +554108, +410865, +345747, +345750, +554129, +345822, +447889, +345841, +510836, +527385, +553627, +553545, +346111, +346135, +346177, +528315, +532516, +381142, +346335, +528050, +346382, +346399, +346401, +346417, +346433, +346448, +346449, +381141, +543601, +346536, +487611, +346587, +346680, +379273, +480520, +406190, +406193, +527202, +519112, +558552, +545597, +347059, +559019, +547327, +547209, +527939, +547679, +528100, +556485, +556486, +484935, +526734, +346618, +527951, +547214, +487183, +485022, +544825, +345820, +485141, +346400, +551436, +547713, +490117, +517969, +527798, +481330, +545547, +517990, +508106, +547618, +553716, +528240, +546972, +546973, +546974, +546975, +518083, +552221, +485036, +518042, +543602, +520195, +528205, +553483, +547758, +513416, +528059, +527381, +553843, +553844, +553842, +547210, +346493, +547682, +527379, +527382, +527383, +530808, +547738, +528241, +527569, +527988, +344813, +527568, +484382, +547306, +406189, +547727, +530803, +544709, +527833, +527958, +554030, +544797, +344408, +554105, +483725, +409330, +477424, +552708, +546952, +391381, +346957, +494563, +557451, +486973, +407026, +380704, +520177, +544788, +544789, +557634, +344400, +477415, +551603, +383919, +545697, +518089, +528041, +545591, +545592, +545593, +545594 +)</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>Integer</type> + <storagetype>normal</storagetype> + <name>id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>id</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Number</type> + <storagetype>normal</storagetype> + <name>system_price</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>system_price</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>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>taxes_system_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>taxes_system_id</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>Asia/Bangkok</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>160</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Update</name> + <type>Update</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production</connection> + <skip_lookup>N</skip_lookup> + <commit>100</commit> + <use_batch>N</use_batch> + <error_ignored>N</error_ignored> + <ignore_flag_field/> + <lookup> + <schema>public</schema> + <table>purchase_pricelist</table> + <key> + <name>id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>system_price</name> + <rename>system_price</rename> + </value> + <value> + <name>taxes_system_id</name> + <rename>taxes_system_id</rename> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>432</xloc> + <yloc>112</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> diff --git a/run_single_ktr.sh b/run_single_ktr.sh index ef15b12..ea60bc6 100644 --- a/run_single_ktr.sh +++ b/run_single_ktr.sh @@ -1 +1 @@ -sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/update_winner_purchase_pricelist.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" +sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/capture_available_minus.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" |