diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 11:12:39 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 11:12:39 +0700 |
| commit | 9828160c003af8915fd837f2ae4d3271387ea8e3 (patch) | |
| tree | 2f3e3506ed8cc27a3decefb0adff79be612682a6 | |
| parent | aa815b5a4d4f915f553f4ff122b06084868f4aa9 (diff) | |
refactor insert update pricelist
| -rw-r--r-- | insert_update_discount.ktr | 1888 | ||||
| -rw-r--r-- | insert_update_pricelist.ktr | 210 | ||||
| -rw-r--r-- | insert_update_pricelist1.ktr (renamed from insert_update_tier2.ktr) | 197 | ||||
| -rw-r--r-- | insert_update_pricelist2.ktr (renamed from insert_update_tier5.ktr) | 228 | ||||
| -rw-r--r-- | insert_update_pricelist3.ktr (renamed from insert_update_tier4.ktr) | 228 | ||||
| -rw-r--r-- | insert_update_pricelist4.ktr (renamed from insert_update_tier3.ktr) | 229 | ||||
| -rw-r--r-- | insert_update_pricelist5.ktr | 2031 |
7 files changed, 2844 insertions, 2167 deletions
diff --git a/insert_update_discount.ktr b/insert_update_discount.ktr deleted file mode 100644 index acc84c7..0000000 --- a/insert_update_discount.ktr +++ /dev/null @@ -1,1888 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<transformation> - <info> - <name>insert_update_discount</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>2023/08/22 15:35:29.262</created_date> - <modified_user>-</modified_user> - <modified_date>2023/08/22 15:35:29.262</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</name> - <server>192.168.23.5</server> - <type>POSTGRESQL</type> - <access>Native</access> - <database>dw_bi_indoteknik</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 local</name> - <server>localhost</server> - <type>POSTGRESQL</type> - <access>Native</access> - <database>indoteknik_20230913</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> - <order> - <hop> - <from>price compute</from> - <to>Merge join</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>price erp</from> - <to>Merge join</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Merge join</from> - <to>Filter rows</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Filter rows</from> - <to>Write to log</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Filter rows</from> - <to>Add constants</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Add constants</from> - <to>Insert / update</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Insert / update 2</from> - <to>Insert / update 3</to> - <enabled>Y</enabled> - </hop> - <hop> - <from>Insert / update</from> - <to>Insert / update 2</to> - <enabled>Y</enabled> - </hop> - </order> - <step> - <name>Add constants</name> - <type>Constant</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>applied_on</name> - <type>String</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>0_product_variant</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>base</name> - <type>String</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>pricelist</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>4</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>currency_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>12</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>active</name> - <type>Boolean</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>true</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>compute_price</name> - <type>String</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>formula</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>create_uid</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>28</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>create_date</name> - <type>Timestamp</type> - <format>yyyy-MM-dd</format> - <currency/> - <decimal/> - <group/> - <nullif>2023-03-29 08:15:57.651</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>write_uid</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>28</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>write_date</name> - <type>Timestamp</type> - <format>yyyy-MM-dd</format> - <currency/> - <decimal/> - <group/> - <nullif>2023-03-29 08:15:57.651</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>base_pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> - <name>solr_flag</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>560</xloc> - <yloc>272</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Filter rows</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>Add constants</send_true_to> - <send_false_to>Write to log</send_false_to> - <compare> - <condition> - <negated>N</negated> - <leftvalue>disc_tier1</leftvalue> - <function><></function> - <rightvalue>price_discount</rightvalue> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>432</xloc> - <yloc>272</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>erp indoteknik local</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>product_pricelist_item</table> - <key> - <name>product_id</name> - <field>product_id</field> - <condition>=</condition> - <name2/> - </key> - <key> - <name>pricelist_id_1</name> - <field>pricelist_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>N</update> - </value> - <value> - <name>applied_on</name> - <rename>applied_on_1</rename> - <update>Y</update> - </value> - <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> - <name>pricelist_id</name> - <rename>pricelist_id_1</rename> - <update>N</update> - </value> - <value> - <name>currency_id</name> - <rename>currency_id_1</rename> - <update>Y</update> - </value> - <value> - <name>active</name> - <rename>active_1</rename> - <update>Y</update> - </value> - <value> - <name>compute_price</name> - <rename>compute_price_1</rename> - <update>Y</update> - </value> - <value> - <name>create_uid</name> - <rename>create_uid_1</rename> - <update>Y</update> - </value> - <value> - <name>create_date</name> - <rename>create_date_1</rename> - <update>Y</update> - </value> - <value> - <name>write_uid</name> - <rename>write_uid_1</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date_1</rename> - <update>Y</update> - </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_id_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier1</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>272</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update 2</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>erp indoteknik local</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>product_template</table> - <key> - <name>template_id</name> - <field>id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>solr_flag</name> - <rename>solr_flag</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>864</xloc> - <yloc>272</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update 3</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>erp indoteknik local</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>product_product</table> - <key> - <name>product_id</name> - <field>id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>solr_flag</name> - <rename>solr_flag</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>992</xloc> - <yloc>272</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>price compute</step1> - <step2>price erp</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>288</xloc> - <yloc>272</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Write to log</name> - <type>WriteToLog</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <loglevel>log_level_basic</loglevel> - <displayHeader>Y</displayHeader> - <limitRows>N</limitRows> - <limitRowsNumber>0</limitRowsNumber> - <logmessage/> - <fields> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>432</xloc> - <yloc>400</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>price compute</name> - <type>TableInput</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 -from v_pricelist_compute pc -join product p on p.product_id = pc.product_id -order by 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>price compute</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>price_before_disc</name> - <length>-1</length> - <precision>-1</precision> - <origin>price compute</origin> - <comments>price_before_disc</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>disc_web_tier1</name> - <length>-1</length> - <precision>-1</precision> - <origin>price compute</origin> - <comments>disc_web_tier1</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>disc_tier2</name> - <length>-1</length> - <precision>-1</precision> - <origin>price compute</origin> - <comments>disc_tier2</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>disc_tier3</name> - <length>-1</length> - <precision>-1</precision> - <origin>price compute</origin> - <comments>disc_tier3</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> - <value-meta> - <type>Integer</type> - <storagetype>normal</storagetype> - <name>template_id</name> - <length>9</length> - <precision>0</precision> - <origin>price compute</origin> - <comments>template_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>192</xloc> - <yloc>128</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>price erp</name> - <type>TableInput</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 4 order by 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>id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</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>Integer</type> - <storagetype>normal</storagetype> - <name>product_tmpl_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>product_tmpl_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_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</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>categ_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>categ_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>min_quantity</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>min_quantity</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> - <value-meta> - <type>String</type> - <storagetype>normal</storagetype> - <name>applied_on</name> - <length>2147483647</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>applied_on</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>base</name> - <length>2147483647</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>base</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>Integer</type> - <storagetype>normal</storagetype> - <name>base_pricelist_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>base_pricelist_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>pricelist_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>pricelist_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>price_surcharge</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>price_surcharge</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>price_discount</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>price_discount</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>price_round</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>price_round</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>price_min_margin</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>price_min_margin</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> - <value-meta> - <type>BigNumber</type> - <storagetype>normal</storagetype> - <name>price_max_margin</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>price_max_margin</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> - <value-meta> - <type>Integer</type> - <storagetype>normal</storagetype> - <name>company_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>company_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>currency_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>currency_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>Boolean</type> - <storagetype>normal</storagetype> - <name>active</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>active</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>Timestamp</type> - <storagetype>normal</storagetype> - <name>date_start</name> - <length>6</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>date_start</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>Timestamp</type> - <storagetype>normal</storagetype> - <name>date_end</name> - <length>6</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>date_end</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>compute_price</name> - <length>2147483647</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>compute_price</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>fixed_price</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>fixed_price</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> - <value-meta> - <type>Number</type> - <storagetype>normal</storagetype> - <name>percent_price</name> - <length>-1</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>percent_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>create_uid</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>create_uid</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>Timestamp</type> - <storagetype>normal</storagetype> - <name>create_date</name> - <length>6</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>create_date</comments> - <conversion_Mask/> - <decimal_symbol>.</decimal_symbol> - <grouping_symbol>,</grouping_symbol> - <currency_symbol/> - <trim_type>none</trim_type> - <case_insensitive>N</case_insensitive> - <collator_disabled>Y</collator_disabled> - <collator_strength>0</collator_strength> - <sort_descending>N</sort_descending> - <output_padding>N</output_padding> - <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> - <date_format_timezone>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>write_uid</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>write_uid</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>Timestamp</type> - <storagetype>normal</storagetype> - <name>write_date</name> - <length>6</length> - <precision>-1</precision> - <origin>price erp</origin> - <comments>write_date</comments> - <conversion_Mask/> - <decimal_symbol>.</decimal_symbol> - <grouping_symbol>,</grouping_symbol> - <currency_symbol/> - <trim_type>none</trim_type> - <case_insensitive>N</case_insensitive> - <collator_disabled>Y</collator_disabled> - <collator_strength>0</collator_strength> - <sort_descending>N</sort_descending> - <output_padding>N</output_padding> - <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> - <date_format_timezone>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>manufacture_id</name> - <length>9</length> - <precision>0</precision> - <origin>price erp</origin> - <comments>manufacture_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>384</xloc> - <yloc>128</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/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 02d665a..f14e7f6 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -6,6 +6,7 @@ <extended_description/> <trans_version/> <trans_type>Normal</trans_type> + <trans_status>0</trans_status> <directory>/</directory> <parameters> </parameters> @@ -491,7 +492,7 @@ <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230913</database> + <database>indoteknik_20230914</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> @@ -604,25 +605,13 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base</name> - <type>String</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>list_price</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> <name>pricelist_id</name> <type>Integer</type> <format/> <currency/> <decimal/> <group/> - <nullif>1</nullif> + <nullif>17022</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -825,11 +814,6 @@ <update>Y</update> </value> <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> <name>pricelist_id</name> <rename>pricelist_id_1</rename> <update>N</update> @@ -1053,8 +1037,11 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id</sql> @@ -1089,6 +1076,29 @@ order by product_id</sql> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>template_id</name> + <length>9</length> + <precision>0</precision> + <origin>price compute</origin> + <comments>template_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>price_before_disc</name> @@ -1114,11 +1124,11 @@ order by product_id</sql> <value-meta> <type>BigNumber</type> <storagetype>normal</storagetype> - <name>disc_web_tier1</name> + <name>disc_tier1</name> <length>-1</length> <precision>-1</precision> <origin>price compute</origin> - <comments>disc_web_tier1</comments> + <comments>disc_tier1</comments> <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol/> @@ -1181,16 +1191,154 @@ order by product_id</sql> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> - <type>Integer</type> + <type>BigNumber</type> <storagetype>normal</storagetype> - <name>template_id</name> - <length>9</length> - <precision>0</precision> + <name>disc_tier4</name> + <length>-1</length> + <precision>-1</precision> <origin>price compute</origin> - <comments>template_id</comments> - <conversion_Mask>####0;-####0</conversion_Mask> + <comments>disc_tier4</comments> + <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> <decimal_symbol>.</decimal_symbol> - <grouping_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>disc_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier5</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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> @@ -1230,7 +1378,7 @@ order by product_id</sql> <schema_name/> </partitioning> <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 1 order by product_id</sql> + <sql>select * from product_pricelist_item where pricelist_id = 17022 order by product_id</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/insert_update_tier2.ktr b/insert_update_pricelist1.ktr index e2bc45e..77dc10f 100644 --- a/insert_update_tier2.ktr +++ b/insert_update_pricelist1.ktr @@ -1,11 +1,12 @@ <?xml version="1.0" encoding="UTF-8"?> <transformation> <info> - <name>insert_update_tier2</name> + <name>insert_update_pricelist1</name> <description/> <extended_description/> <trans_version/> <trans_type>Normal</trans_type> + <trans_status>0</trans_status> <directory>/</directory> <parameters> </parameters> @@ -427,9 +428,9 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2023/08/22 15:45:10.930</created_date> + <created_date>2023/08/22 15:08:34.331</created_date> <modified_user>-</modified_user> - <modified_date>2023/08/22 15:45:10.930</modified_date> + <modified_date>2023/08/22 15:08:34.331</modified_date> <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> @@ -491,7 +492,7 @@ <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230912</database> + <database>indoteknik_20230914</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> @@ -569,13 +570,13 @@ <enabled>Y</enabled> </hop> <hop> - <from>Insert / update 2</from> - <to>Insert / update 3</to> + <from>Insert / update</from> + <to>Insert / update 2</to> <enabled>Y</enabled> </hop> <hop> - <from>Insert / update</from> - <to>Insert / update 2</to> + <from>Insert / update 2</from> + <to>Insert / update 3</to> <enabled>Y</enabled> </hop> </order> @@ -604,25 +605,25 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base</name> - <type>String</type> + <name>pricelist_id</name> + <type>Integer</type> <format/> <currency/> <decimal/> <group/> - <nullif>pricelist</nullif> + <nullif>17023</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> </field> <field> - <name>pricelist_id</name> - <type>Integer</type> + <name>price_discount</name> + <type>Number</type> <format/> <currency/> <decimal/> <group/> - <nullif>15037</nullif> + <nullif>0</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -658,7 +659,7 @@ <currency/> <decimal/> <group/> - <nullif>formula</nullif> + <nullif>fixed</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -712,18 +713,6 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base_pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> <name>solr_flag</name> <type>Integer</type> <format/> @@ -766,9 +755,9 @@ <compare> <condition> <negated>N</negated> - <leftvalue>disc_tier2</leftvalue> + <leftvalue>price_tier1</leftvalue> <function><></function> - <rightvalue>price_discount</rightvalue> + <rightvalue>fixed_price</rightvalue> </condition> </compare> <attributes/> @@ -789,7 +778,7 @@ <name>Insert / update</name> <type>InsertUpdate</type> <description/> - <distribute>Y</distribute> + <distribute>N</distribute> <custom_distribution/> <copies>1</copies> <partitioning> @@ -825,11 +814,6 @@ <update>Y</update> </value> <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> <name>pricelist_id</name> <rename>pricelist_id_1</rename> <update>N</update> @@ -850,6 +834,11 @@ <update>Y</update> </value> <value> + <name>fixed_price</name> + <rename>price_tier1</rename> + <update>Y</update> + </value> + <value> <name>create_uid</name> <rename>create_uid_1</rename> <update>Y</update> @@ -869,16 +858,6 @@ <rename>write_date_1</rename> <update>Y</update> </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_id_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier2</rename> - <update>Y</update> - </value> </lookup> <attributes/> <cluster_schema/> @@ -932,7 +911,7 @@ </output> </remotesteps> <GUI> - <xloc>896</xloc> + <xloc>864</xloc> <yloc>272</yloc> <draw>Y</draw> </GUI> @@ -975,7 +954,7 @@ </output> </remotesteps> <GUI> - <xloc>1024</xloc> + <xloc>992</xloc> <yloc>272</yloc> <draw>Y</draw> </GUI> @@ -1058,8 +1037,11 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id</sql> @@ -1254,6 +1236,121 @@ order by product_id</sql> <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>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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/> @@ -1281,7 +1378,7 @@ order by product_id</sql> <schema_name/> </partitioning> <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 15037 order by product_id</sql> + <sql>select * from product_pricelist_item where pricelist_id = 17023 order by product_id</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/insert_update_tier5.ktr b/insert_update_pricelist2.ktr index d759ef5..dd0f6ea 100644 --- a/insert_update_tier5.ktr +++ b/insert_update_pricelist2.ktr @@ -1,7 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <transformation> <info> - <name>insert_update_tier5</name> + <name>insert_update_pricelist2</name> <description/> <extended_description/> <trans_version/> @@ -428,9 +428,9 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2023/08/22 15:47:24.260</created_date> + <created_date>2023/08/22 15:08:34.331</created_date> <modified_user>-</modified_user> - <modified_date>2023/08/22 15:47:24.260</modified_date> + <modified_date>2023/08/22 15:08:34.331</modified_date> <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> @@ -492,7 +492,7 @@ <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230913</database> + <database>indoteknik_20230914</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> @@ -570,13 +570,13 @@ <enabled>Y</enabled> </hop> <hop> - <from>Insert / update 2</from> - <to>Insert / update 3</to> + <from>Insert / update</from> + <to>Insert / update 2</to> <enabled>Y</enabled> </hop> <hop> - <from>Insert / update</from> - <to>Insert / update 2</to> + <from>Insert / update 2</from> + <to>Insert / update 3</to> <enabled>Y</enabled> </hop> </order> @@ -605,25 +605,25 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base</name> - <type>String</type> + <name>pricelist_id</name> + <type>Integer</type> <format/> <currency/> <decimal/> <group/> - <nullif>pricelist</nullif> + <nullif>17024</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> </field> <field> - <name>pricelist_id</name> - <type>Integer</type> + <name>price_discount</name> + <type>Number</type> <format/> <currency/> <decimal/> <group/> - <nullif>15235</nullif> + <nullif>0</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -659,7 +659,7 @@ <currency/> <decimal/> <group/> - <nullif>formula</nullif> + <nullif>fixed</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -713,18 +713,6 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base_pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> <name>solr_flag</name> <type>Integer</type> <format/> @@ -746,8 +734,8 @@ </output> </remotesteps> <GUI> - <xloc>624</xloc> - <yloc>240</yloc> + <xloc>592</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -767,9 +755,9 @@ <compare> <condition> <negated>N</negated> - <leftvalue>disc_tier5</leftvalue> + <leftvalue>price_tier2</leftvalue> <function><></function> - <rightvalue>price_discount</rightvalue> + <rightvalue>fixed_price</rightvalue> </condition> </compare> <attributes/> @@ -781,8 +769,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>240</yloc> + <xloc>464</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -790,7 +778,7 @@ <name>Insert / update</name> <type>InsertUpdate</type> <description/> - <distribute>Y</distribute> + <distribute>N</distribute> <custom_distribution/> <copies>1</copies> <partitioning> @@ -826,11 +814,6 @@ <update>Y</update> </value> <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> <name>pricelist_id</name> <rename>pricelist_id_1</rename> <update>N</update> @@ -851,6 +834,11 @@ <update>Y</update> </value> <value> + <name>fixed_price</name> + <rename>price_tier2</rename> + <update>Y</update> + </value> + <value> <name>create_uid</name> <rename>create_uid_1</rename> <update>Y</update> @@ -870,16 +858,6 @@ <rename>write_date_1</rename> <update>Y</update> </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_id_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier5</rename> - <update>Y</update> - </value> </lookup> <attributes/> <cluster_schema/> @@ -890,8 +868,8 @@ </output> </remotesteps> <GUI> - <xloc>768</xloc> - <yloc>240</yloc> + <xloc>736</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -933,8 +911,8 @@ </output> </remotesteps> <GUI> - <xloc>912</xloc> - <yloc>240</yloc> + <xloc>864</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -976,8 +954,8 @@ </output> </remotesteps> <GUI> - <xloc>1040</xloc> - <yloc>240</yloc> + <xloc>992</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1010,8 +988,8 @@ </output> </remotesteps> <GUI> - <xloc>352</xloc> - <yloc>240</yloc> + <xloc>320</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1042,8 +1020,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>368</yloc> + <xloc>464</xloc> + <yloc>400</yloc> <draw>Y</draw> </GUI> </step> @@ -1059,8 +1037,11 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id</sql> @@ -1255,6 +1236,121 @@ order by product_id</sql> <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>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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/> @@ -1265,8 +1361,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>256</xloc> - <yloc>96</yloc> + <xloc>224</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> @@ -1282,7 +1378,7 @@ order by product_id</sql> <schema_name/> </partitioning> <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 15235 order by product_id</sql> + <sql>select * from product_pricelist_item where pricelist_id = 17024 order by product_id</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1921,8 +2017,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>448</xloc> - <yloc>96</yloc> + <xloc>416</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> diff --git a/insert_update_tier4.ktr b/insert_update_pricelist3.ktr index fb774d8..357db0b 100644 --- a/insert_update_tier4.ktr +++ b/insert_update_pricelist3.ktr @@ -1,7 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <transformation> <info> - <name>insert_update_tier4</name> + <name>insert_update_pricelist3</name> <description/> <extended_description/> <trans_version/> @@ -428,9 +428,9 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2023/08/22 15:47:24.260</created_date> + <created_date>2023/08/22 15:08:34.331</created_date> <modified_user>-</modified_user> - <modified_date>2023/08/22 15:47:24.260</modified_date> + <modified_date>2023/08/22 15:08:34.331</modified_date> <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> @@ -492,7 +492,7 @@ <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230913</database> + <database>indoteknik_20230914</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> @@ -570,13 +570,13 @@ <enabled>Y</enabled> </hop> <hop> - <from>Insert / update 2</from> - <to>Insert / update 3</to> + <from>Insert / update</from> + <to>Insert / update 2</to> <enabled>Y</enabled> </hop> <hop> - <from>Insert / update</from> - <to>Insert / update 2</to> + <from>Insert / update 2</from> + <to>Insert / update 3</to> <enabled>Y</enabled> </hop> </order> @@ -605,25 +605,25 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base</name> - <type>String</type> + <name>pricelist_id</name> + <type>Integer</type> <format/> <currency/> <decimal/> <group/> - <nullif>pricelist</nullif> + <nullif>17025</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> </field> <field> - <name>pricelist_id</name> - <type>Integer</type> + <name>price_discount</name> + <type>Number</type> <format/> <currency/> <decimal/> <group/> - <nullif>15039</nullif> + <nullif>0</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -659,7 +659,7 @@ <currency/> <decimal/> <group/> - <nullif>formula</nullif> + <nullif>fixed</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -713,18 +713,6 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base_pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> <name>solr_flag</name> <type>Integer</type> <format/> @@ -746,8 +734,8 @@ </output> </remotesteps> <GUI> - <xloc>624</xloc> - <yloc>240</yloc> + <xloc>592</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -767,9 +755,9 @@ <compare> <condition> <negated>N</negated> - <leftvalue>disc_tier4</leftvalue> + <leftvalue>price_tier3</leftvalue> <function><></function> - <rightvalue>price_discount</rightvalue> + <rightvalue>fixed_price</rightvalue> </condition> </compare> <attributes/> @@ -781,8 +769,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>240</yloc> + <xloc>464</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -790,7 +778,7 @@ <name>Insert / update</name> <type>InsertUpdate</type> <description/> - <distribute>Y</distribute> + <distribute>N</distribute> <custom_distribution/> <copies>1</copies> <partitioning> @@ -826,11 +814,6 @@ <update>Y</update> </value> <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> <name>pricelist_id</name> <rename>pricelist_id_1</rename> <update>N</update> @@ -851,6 +834,11 @@ <update>Y</update> </value> <value> + <name>fixed_price</name> + <rename>price_tier3</rename> + <update>Y</update> + </value> + <value> <name>create_uid</name> <rename>create_uid_1</rename> <update>Y</update> @@ -870,16 +858,6 @@ <rename>write_date_1</rename> <update>Y</update> </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_id_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier4</rename> - <update>Y</update> - </value> </lookup> <attributes/> <cluster_schema/> @@ -890,8 +868,8 @@ </output> </remotesteps> <GUI> - <xloc>768</xloc> - <yloc>240</yloc> + <xloc>736</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -933,8 +911,8 @@ </output> </remotesteps> <GUI> - <xloc>912</xloc> - <yloc>240</yloc> + <xloc>864</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -976,8 +954,8 @@ </output> </remotesteps> <GUI> - <xloc>1040</xloc> - <yloc>240</yloc> + <xloc>992</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1010,8 +988,8 @@ </output> </remotesteps> <GUI> - <xloc>352</xloc> - <yloc>240</yloc> + <xloc>320</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1042,8 +1020,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>368</yloc> + <xloc>464</xloc> + <yloc>400</yloc> <draw>Y</draw> </GUI> </step> @@ -1059,8 +1037,11 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id</sql> @@ -1255,6 +1236,121 @@ order by product_id</sql> <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>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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/> @@ -1265,8 +1361,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>256</xloc> - <yloc>96</yloc> + <xloc>224</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> @@ -1282,7 +1378,7 @@ order by product_id</sql> <schema_name/> </partitioning> <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 15039 order by product_id</sql> + <sql>select * from product_pricelist_item where pricelist_id = 17025 order by product_id</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1921,8 +2017,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>448</xloc> - <yloc>96</yloc> + <xloc>416</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> diff --git a/insert_update_tier3.ktr b/insert_update_pricelist4.ktr index d050afc..c8feb72 100644 --- a/insert_update_tier3.ktr +++ b/insert_update_pricelist4.ktr @@ -1,11 +1,12 @@ <?xml version="1.0" encoding="UTF-8"?> <transformation> <info> - <name>insert_update_tier3</name> + <name>insert_update_pricelist4</name> <description/> <extended_description/> <trans_version/> <trans_type>Normal</trans_type> + <trans_status>0</trans_status> <directory>/</directory> <parameters> </parameters> @@ -427,9 +428,9 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2023/08/22 15:47:24.260</created_date> + <created_date>2023/08/22 15:08:34.331</created_date> <modified_user>-</modified_user> - <modified_date>2023/08/22 15:47:24.260</modified_date> + <modified_date>2023/08/22 15:08:34.331</modified_date> <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> @@ -491,7 +492,7 @@ <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230912</database> + <database>indoteknik_20230914</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> @@ -569,13 +570,13 @@ <enabled>Y</enabled> </hop> <hop> - <from>Insert / update 2</from> - <to>Insert / update 3</to> + <from>Insert / update</from> + <to>Insert / update 2</to> <enabled>Y</enabled> </hop> <hop> - <from>Insert / update</from> - <to>Insert / update 2</to> + <from>Insert / update 2</from> + <to>Insert / update 3</to> <enabled>Y</enabled> </hop> </order> @@ -604,25 +605,25 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base</name> - <type>String</type> + <name>pricelist_id</name> + <type>Integer</type> <format/> <currency/> <decimal/> <group/> - <nullif>pricelist</nullif> + <nullif>17026</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> </field> <field> - <name>pricelist_id</name> - <type>Integer</type> + <name>price_discount</name> + <type>Number</type> <format/> <currency/> <decimal/> <group/> - <nullif>15038</nullif> + <nullif>0</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -658,7 +659,7 @@ <currency/> <decimal/> <group/> - <nullif>formula</nullif> + <nullif>fixed</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -712,18 +713,6 @@ <set_empty_string>N</set_empty_string> </field> <field> - <name>base_pricelist_id</name> - <type>Integer</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>1</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> - </field> - <field> <name>solr_flag</name> <type>Integer</type> <format/> @@ -745,8 +734,8 @@ </output> </remotesteps> <GUI> - <xloc>624</xloc> - <yloc>240</yloc> + <xloc>592</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -766,9 +755,9 @@ <compare> <condition> <negated>N</negated> - <leftvalue>disc_tier3</leftvalue> + <leftvalue>price_tier4</leftvalue> <function><></function> - <rightvalue>price_discount</rightvalue> + <rightvalue>fixed_price</rightvalue> </condition> </compare> <attributes/> @@ -780,8 +769,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>240</yloc> + <xloc>464</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -789,7 +778,7 @@ <name>Insert / update</name> <type>InsertUpdate</type> <description/> - <distribute>Y</distribute> + <distribute>N</distribute> <custom_distribution/> <copies>1</copies> <partitioning> @@ -825,11 +814,6 @@ <update>Y</update> </value> <value> - <name>base</name> - <rename>base_1</rename> - <update>Y</update> - </value> - <value> <name>pricelist_id</name> <rename>pricelist_id_1</rename> <update>N</update> @@ -850,6 +834,11 @@ <update>Y</update> </value> <value> + <name>fixed_price</name> + <rename>price_tier4</rename> + <update>Y</update> + </value> + <value> <name>create_uid</name> <rename>create_uid_1</rename> <update>Y</update> @@ -869,16 +858,6 @@ <rename>write_date_1</rename> <update>Y</update> </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_id_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier3</rename> - <update>Y</update> - </value> </lookup> <attributes/> <cluster_schema/> @@ -889,8 +868,8 @@ </output> </remotesteps> <GUI> - <xloc>768</xloc> - <yloc>240</yloc> + <xloc>736</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -932,8 +911,8 @@ </output> </remotesteps> <GUI> - <xloc>912</xloc> - <yloc>240</yloc> + <xloc>864</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -975,8 +954,8 @@ </output> </remotesteps> <GUI> - <xloc>1040</xloc> - <yloc>240</yloc> + <xloc>992</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1009,8 +988,8 @@ </output> </remotesteps> <GUI> - <xloc>352</xloc> - <yloc>240</yloc> + <xloc>320</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1041,8 +1020,8 @@ </output> </remotesteps> <GUI> - <xloc>496</xloc> - <yloc>368</yloc> + <xloc>464</xloc> + <yloc>400</yloc> <draw>Y</draw> </GUI> </step> @@ -1058,8 +1037,11 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik</connection> - <sql>select pc.product_id, p.template_id, price_before_disc, disc_tier1, -disc_tier2, disc_tier3, disc_tier4, disc_tier5 + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 from v_pricelist_compute pc join product p on p.product_id = pc.product_id order by product_id</sql> @@ -1254,6 +1236,121 @@ order by product_id</sql> <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>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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/> @@ -1264,8 +1361,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>256</xloc> - <yloc>96</yloc> + <xloc>224</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> @@ -1281,7 +1378,7 @@ order by product_id</sql> <schema_name/> </partitioning> <connection>erp indoteknik local</connection> - <sql>select * from product_pricelist_item where pricelist_id = 15038 order by product_id</sql> + <sql>select * from product_pricelist_item where pricelist_id = 17026 order by product_id</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1920,8 +2017,8 @@ order by product_id</sql> </output> </remotesteps> <GUI> - <xloc>448</xloc> - <yloc>96</yloc> + <xloc>416</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr new file mode 100644 index 0000000..e747546 --- /dev/null +++ b/insert_update_pricelist5.ktr @@ -0,0 +1,2031 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>insert_update_pricelist5</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <trans_status>0</trans_status> + <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>2023/08/22 15:08:34.331</created_date> + <modified_user>-</modified_user> + <modified_date>2023/08/22 15:08:34.331</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</name> + <server>192.168.23.5</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</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 local</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>indoteknik_20230914</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> + <order> + <hop> + <from>price compute</from> + <to>Merge join</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>price erp</from> + <to>Merge join</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Merge join</from> + <to>Filter rows</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Write to log</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Add constants</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Add constants</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Insert / update</from> + <to>Insert / update 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Insert / update 2</from> + <to>Insert / update 3</to> + <enabled>Y</enabled> + </hop> + </order> + <step> + <name>Add constants</name> + <type>Constant</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>applied_on</name> + <type>String</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>0_product_variant</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>pricelist_id</name> + <type>Integer</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>17027</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>price_discount</name> + <type>Number</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>0</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>currency_id</name> + <type>Integer</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>12</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>active</name> + <type>Boolean</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>true</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>compute_price</name> + <type>String</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>fixed</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>create_uid</name> + <type>Integer</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>28</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>create_date</name> + <type>Timestamp</type> + <format>yyyy-MM-dd</format> + <currency/> + <decimal/> + <group/> + <nullif>2023-03-29 08:15:57.651</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>write_uid</name> + <type>Integer</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>28</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>write_date</name> + <type>Timestamp</type> + <format>yyyy-MM-dd</format> + <currency/> + <decimal/> + <group/> + <nullif>2023-03-29 08:15:57.651</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + <field> + <name>solr_flag</name> + <type>Integer</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>1</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>592</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>Add constants</send_true_to> + <send_false_to>Write to log</send_false_to> + <compare> + <condition> + <negated>N</negated> + <leftvalue>price_tier5</leftvalue> + <function><></function> + <rightvalue>fixed_price</rightvalue> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>464</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>N</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik local</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>product_pricelist_item</table> + <key> + <name>product_id</name> + <field>product_id</field> + <condition>=</condition> + <name2/> + </key> + <key> + <name>pricelist_id_1</name> + <field>pricelist_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>N</update> + </value> + <value> + <name>applied_on</name> + <rename>applied_on_1</rename> + <update>Y</update> + </value> + <value> + <name>pricelist_id</name> + <rename>pricelist_id_1</rename> + <update>N</update> + </value> + <value> + <name>currency_id</name> + <rename>currency_id_1</rename> + <update>Y</update> + </value> + <value> + <name>active</name> + <rename>active_1</rename> + <update>Y</update> + </value> + <value> + <name>compute_price</name> + <rename>compute_price_1</rename> + <update>Y</update> + </value> + <value> + <name>fixed_price</name> + <rename>price_tier5</rename> + <update>Y</update> + </value> + <value> + <name>create_uid</name> + <rename>create_uid_1</rename> + <update>Y</update> + </value> + <value> + <name>create_date</name> + <rename>create_date_1</rename> + <update>Y</update> + </value> + <value> + <name>write_uid</name> + <rename>write_uid_1</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date_1</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>736</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update 2</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik local</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>product_template</table> + <key> + <name>template_id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>solr_flag</name> + <rename>solr_flag</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>864</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update 3</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik local</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>product_product</table> + <key> + <name>product_id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>solr_flag</name> + <rename>solr_flag</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>992</xloc> + <yloc>272</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>price compute</step1> + <step2>price erp</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>320</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Write to log</name> + <type>WriteToLog</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <loglevel>log_level_basic</loglevel> + <displayHeader>Y</displayHeader> + <limitRows>N</limitRows> + <limitRowsNumber>0</limitRowsNumber> + <logmessage/> + <fields> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>464</xloc> + <yloc>400</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>price compute</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik</connection> + <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, +disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, +round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, +round(price_tier3) as price_tier3, round(price_tier4) as price_tier4, +round(price_tier5) as price_tier5 +from v_pricelist_compute pc +join product p on p.product_id = pc.product_id +order by 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>price compute</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>template_id</name> + <length>9</length> + <precision>0</precision> + <origin>price compute</origin> + <comments>template_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>price_before_disc</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_before_disc</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>disc_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>disc_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>disc_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>disc_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>disc_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>disc_tier5</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier1</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier1</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier2</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier2</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier3</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier3</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier4</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier4</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_tier5</name> + <length>-1</length> + <precision>-1</precision> + <origin>price compute</origin> + <comments>price_tier5</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>224</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>price erp</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik local</connection> + <sql>select * from product_pricelist_item where pricelist_id = 17027 order by 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>id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</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>Integer</type> + <storagetype>normal</storagetype> + <name>product_tmpl_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>product_tmpl_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_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</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>categ_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>categ_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>min_quantity</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>min_quantity</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> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>applied_on</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>applied_on</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>base</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>base</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>Integer</type> + <storagetype>normal</storagetype> + <name>base_pricelist_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>base_pricelist_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>pricelist_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>pricelist_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>price_surcharge</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>price_surcharge</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_discount</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>price_discount</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_round</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>price_round</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_min_margin</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>price_min_margin</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> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_max_margin</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>price_max_margin</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> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>company_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>company_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>currency_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>currency_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>Boolean</type> + <storagetype>normal</storagetype> + <name>active</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>active</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>Timestamp</type> + <storagetype>normal</storagetype> + <name>date_start</name> + <length>6</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>date_start</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>Timestamp</type> + <storagetype>normal</storagetype> + <name>date_end</name> + <length>6</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>date_end</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>compute_price</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>compute_price</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>fixed_price</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>fixed_price</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> + <value-meta> + <type>Number</type> + <storagetype>normal</storagetype> + <name>percent_price</name> + <length>-1</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>percent_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>create_uid</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>create_uid</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>Timestamp</type> + <storagetype>normal</storagetype> + <name>create_date</name> + <length>6</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>create_date</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>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>write_uid</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>write_uid</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>Timestamp</type> + <storagetype>normal</storagetype> + <name>write_date</name> + <length>6</length> + <precision>-1</precision> + <origin>price erp</origin> + <comments>write_date</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>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>manufacture_id</name> + <length>9</length> + <precision>0</precision> + <origin>price erp</origin> + <comments>manufacture_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>416</xloc> + <yloc>128</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> |