diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 15:22:20 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 15:22:20 +0700 |
| commit | 0564c4028595d0a6ca66350e6778de454fe5088d (patch) | |
| tree | d0c9c75b23daacdff5feef9102cff48aa6fb8d01 /insert_update_pricelist3.ktr | |
| parent | 841af45973932090b64012db1941ed5d657299b7 (diff) | |
add base price
Diffstat (limited to 'insert_update_pricelist3.ktr')
| -rw-r--r-- | insert_update_pricelist3.ktr | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index c2981fb..7de2e7f 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -547,6 +547,11 @@ <to>Insert / update 3</to> <enabled>Y</enabled> </hop> + <hop> + <from>Insert / update 3</from> + <to>Execute SQL script</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Add constants</name> @@ -692,6 +697,18 @@ <precision>-1</precision> <set_empty_string>N</set_empty_string> </field> + <field> + <name>base_const</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> </fields> <attributes/> <cluster_schema/> @@ -826,6 +843,11 @@ <rename>write_date_1</rename> <update>Y</update> </value> + <value> + <name>base</name> + <rename>base_const</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -1990,6 +2012,44 @@ order by product_id</sql> <draw>Y</draw> </GUI> </step> + <step> + <name>Execute SQL script</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17025;</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1136</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |