diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2025-07-07 13:47:48 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2025-07-07 13:47:48 +0700 |
| commit | 9903796b7e1471f6285c9884fadfda9becc890e6 (patch) | |
| tree | 329be278ddbc5d7a812cd74162001305b8861b8c /update_list_deadstock_opening.ktr | |
| parent | 6e58f9c35caa3a3c01c257dcf1137ce024ccc6eb (diff) | |
bf deadstock data
Diffstat (limited to 'update_list_deadstock_opening.ktr')
| -rw-r--r-- | update_list_deadstock_opening.ktr | 94 |
1 files changed, 47 insertions, 47 deletions
diff --git a/update_list_deadstock_opening.ktr b/update_list_deadstock_opening.ktr index 55f9883..4c8125f 100644 --- a/update_list_deadstock_opening.ktr +++ b/update_list_deadstock_opening.ktr @@ -593,10 +593,10 @@ </partitioning> <failIfNoFile>Y</failIfNoFile> <calculation> - <field_name>new_total_value</field_name> - <calc_type>MULTIPLY</calc_type> + <field_name>new_qty_available</field_name> + <calc_type>SUBTRACT</calc_type> <field_a>qty</field_a> - <field_b>value</field_b> + <field_b>qty_outgoing</field_b> <field_c/> <value_type>None</value_type> <value_length>-1</value_length> @@ -608,10 +608,10 @@ <currency_symbol/> </calculation> <calculation> - <field_name>new_qty_available</field_name> - <calc_type>SUBTRACT</calc_type> - <field_a>qty</field_a> - <field_b>qty_outgoing</field_b> + <field_name>new_total_value</field_name> + <calc_type>MULTIPLY</calc_type> + <field_a>new_qty_available</field_a> + <field_b>value</field_b> <field_c/> <value_type>None</value_type> <value_length>-1</value_length> @@ -695,6 +695,46 @@ </GUI> </step> <step> + <name>If field value is null 2</name> + <type>IfNull</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <replaceAllByValue>0</replaceAllByValue> + <replaceAllMask/> + <selectFields>Y</selectFields> + <selectValuesType>N</selectValuesType> + <setEmptyStringAll>N</setEmptyStringAll> + <valuetypes> + </valuetypes> + <fields> + <field> + <name>new_qty_available</name> + <value>0</value> + <mask/> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>656</xloc> + <yloc>304</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Merge join</name> <type>MergeJoin</type> <description/> @@ -1206,46 +1246,6 @@ order by sq.product_id</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>If field value is null 2</name> - <type>IfNull</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <replaceAllByValue>0</replaceAllByValue> - <replaceAllMask/> - <selectFields>Y</selectFields> - <selectValuesType>N</selectValuesType> - <setEmptyStringAll>N</setEmptyStringAll> - <valuetypes> - </valuetypes> - <fields> - <field> - <name>new_qty_available</name> - <value>0</value> - <mask/> - <set_empty_string>N</set_empty_string> - </field> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>656</xloc> - <yloc>304</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |