diff options
Diffstat (limited to 'insert_update_pricelist3.ktr')
| -rw-r--r-- | insert_update_pricelist3.ktr | 242 |
1 files changed, 126 insertions, 116 deletions
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index c35866d..ec3e954 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -569,6 +569,16 @@ <to>p Insert / update tier3</to> <enabled>Y</enabled> </hop> + <hop> + <from>p Insert / update tier3</from> + <to>pl3 solr flag pt</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>pl3 solr flag pt</from> + <to>pl3 solr flag pp</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Add constants</name> @@ -709,7 +719,7 @@ <currency/> <decimal/> <group/> - <nullif>1</nullif> + <nullif>2</nullif> <length>-1</length> <precision>-1</precision> <set_empty_string>N</set_empty_string> @@ -789,116 +799,7 @@ </GUI> </step> <step> - <name>p Insert / update tier3</name> - <type>InsertUpdate</type> - <description/> - <distribute>N</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>erp indoteknik production (localhost)</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_const</rename> - <update>Y</update> - </value> - <value> - <name>compute_price</name> - <rename>compute_price_1</rename> - <update>Y</update> - </value> - <value> - <name>price_discount</name> - <rename>disc_tier3</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</name> - <rename>base_const</rename> - <update>Y</update> - </value> - <value> - <name>base_pricelist_id</name> - <rename>base_pricelist_const</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> + <name>pl3 solr flag pt</name> <type>InsertUpdate</type> <description/> <distribute>Y</distribute> @@ -935,13 +836,13 @@ </output> </remotesteps> <GUI> - <xloc>896</xloc> - <yloc>128</yloc> + <xloc>912</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Insert / update 3</name> + <name>pl3 solr flag pp</name> <type>InsertUpdate</type> <description/> <distribute>Y</distribute> @@ -978,8 +879,8 @@ </output> </remotesteps> <GUI> - <xloc>1040</xloc> - <yloc>128</yloc> + <xloc>1088</xloc> + <yloc>272</yloc> <draw>Y</draw> </GUI> </step> @@ -1050,6 +951,115 @@ </GUI> </step> <step> + <name>p Insert / update tier3</name> + <type>InsertUpdate</type> + <description/> + <distribute>N</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</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_const</rename> + <update>Y</update> + </value> + <value> + <name>compute_price</name> + <rename>compute_price_1</rename> + <update>Y</update> + </value> + <value> + <name>price_discount</name> + <rename>disc_tier3</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</name> + <rename>base_const</rename> + <update>Y</update> + </value> + <value> + <name>base_pricelist_id</name> + <rename>base_pricelist_const</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>price compute</name> <type>TableInput</type> <description/> |