diff options
Diffstat (limited to 'import_stock_location.ktr')
| -rw-r--r-- | import_stock_location.ktr | 316 |
1 files changed, 270 insertions, 46 deletions
diff --git a/import_stock_location.ktr b/import_stock_location.ktr index 7e01b64..0136248 100644 --- a/import_stock_location.ktr +++ b/import_stock_location.ktr @@ -556,7 +556,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from stock_quant where write_date >= (now() - '5 days'::interval)</sql> + <sql>select * from stock_location --where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -588,14 +588,83 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> - <type>Integer</type> + <type>String</type> <storagetype>normal</storagetype> - <name>product_id</name> - <length>9</length> - <precision>0</precision> + <name>name</name> + <length>2147483647</length> + <precision>-1</precision> <origin>Table input</origin> - <comments>product_id</comments> - <conversion_Mask>####0;-####0</conversion_Mask> + <comments>name</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>complete_name</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>complete_name</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Boolean</type> + <storagetype>normal</storagetype> + <name>active</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</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>String</type> + <storagetype>normal</storagetype> + <name>usage</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>usage</comments> + <conversion_Mask/> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> <currency_symbol/> @@ -613,11 +682,11 @@ <value-meta> <type>Integer</type> <storagetype>normal</storagetype> - <name>company_id</name> + <name>location_id</name> <length>9</length> <precision>0</precision> <origin>Table input</origin> - <comments>company_id</comments> + <comments>location_id</comments> <conversion_Mask>####0;-####0</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -634,13 +703,36 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>comment</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>comment</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>location_id</name> + <name>posx</name> <length>9</length> <precision>0</precision> <origin>Table input</origin> - <comments>location_id</comments> + <comments>posx</comments> <conversion_Mask>####0;-####0</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -659,11 +751,11 @@ <value-meta> <type>Integer</type> <storagetype>normal</storagetype> - <name>lot_id</name> + <name>posy</name> <length>9</length> <precision>0</precision> <origin>Table input</origin> - <comments>lot_id</comments> + <comments>posy</comments> <conversion_Mask>####0;-####0</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -682,11 +774,11 @@ <value-meta> <type>Integer</type> <storagetype>normal</storagetype> - <name>package_id</name> + <name>posz</name> <length>9</length> <precision>0</precision> <origin>Table input</origin> - <comments>package_id</comments> + <comments>posz</comments> <conversion_Mask>####0;-####0</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -703,13 +795,36 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>parent_path</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>parent_path</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>owner_id</name> + <name>company_id</name> <length>9</length> <precision>0</precision> <origin>Table input</origin> - <comments>owner_id</comments> + <comments>company_id</comments> <conversion_Mask>####0;-####0</conversion_Mask> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -726,14 +841,14 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> - <type>Number</type> + <type>Boolean</type> <storagetype>normal</storagetype> - <name>quantity</name> + <name>scrap_location</name> <length>-1</length> <precision>-1</precision> <origin>Table input</origin> - <comments>quantity</comments> - <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask> + <comments>scrap_location</comments> + <conversion_Mask/> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> <currency_symbol/> @@ -749,14 +864,14 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> - <type>Number</type> + <type>Boolean</type> <storagetype>normal</storagetype> - <name>reserved_quantity</name> + <name>return_location</name> <length>-1</length> <precision>-1</precision> <origin>Table input</origin> - <comments>reserved_quantity</comments> - <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask> + <comments>return_location</comments> + <conversion_Mask/> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> <currency_symbol/> @@ -772,13 +887,36 @@ <lenient_string_to_number>N</lenient_string_to_number> </value-meta> <value-meta> - <type>Timestamp</type> + <type>Integer</type> <storagetype>normal</storagetype> - <name>in_date</name> - <length>6</length> + <name>removal_strategy_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>removal_strategy_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>String</type> + <storagetype>normal</storagetype> + <name>barcode</name> + <length>2147483647</length> <precision>-1</precision> <origin>Table input</origin> - <comments>in_date</comments> + <comments>barcode</comments> <conversion_Mask/> <decimal_symbol>.</decimal_symbol> <grouping_symbol>,</grouping_symbol> @@ -886,6 +1024,52 @@ <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>valuation_in_account_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>valuation_in_account_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>valuation_out_account_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>valuation_out_account_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/> @@ -896,7 +1080,7 @@ </output> </remotesteps> <GUI> - <xloc>144</xloc> + <xloc>128</xloc> <yloc>48</yloc> <draw>Y</draw> </GUI> @@ -930,13 +1114,23 @@ <update>N</update> </value> <value> - <name>product_id</name> - <rename>product_id</rename> + <name>name</name> + <rename>name</rename> <update>Y</update> </value> <value> - <name>company_id</name> - <rename>company_id</rename> + <name>complete_name</name> + <rename>complete_name</rename> + <update>Y</update> + </value> + <value> + <name>active</name> + <rename>active</rename> + <update>Y</update> + </value> + <value> + <name>usage</name> + <rename>usage</rename> <update>Y</update> </value> <value> @@ -945,33 +1139,53 @@ <update>Y</update> </value> <value> - <name>lot_id</name> - <rename>lot_id</rename> + <name>comment</name> + <rename>comment</rename> <update>Y</update> </value> <value> - <name>package_id</name> - <rename>package_id</rename> + <name>posx</name> + <rename>posx</rename> <update>Y</update> </value> <value> - <name>owner_id</name> - <rename>owner_id</rename> + <name>posy</name> + <rename>posy</rename> <update>Y</update> </value> <value> - <name>quantity</name> - <rename>quantity</rename> + <name>posz</name> + <rename>posz</rename> + <update>Y</update> + </value> + <value> + <name>parent_path</name> + <rename>parent_path</rename> + <update>Y</update> + </value> + <value> + <name>company_id</name> + <rename>company_id</rename> <update>Y</update> </value> <value> - <name>reserved_quantity</name> - <rename>reserved_quantity</rename> + <name>scrap_location</name> + <rename>scrap_location</rename> <update>Y</update> </value> <value> - <name>in_date</name> - <rename>in_date</rename> + <name>return_location</name> + <rename>return_location</rename> + <update>Y</update> + </value> + <value> + <name>removal_strategy_id</name> + <rename>removal_strategy_id</rename> + <update>Y</update> + </value> + <value> + <name>barcode</name> + <rename>barcode</rename> <update>Y</update> </value> <value> @@ -994,6 +1208,16 @@ <rename>write_date</rename> <update>Y</update> </value> + <value> + <name>valuation_in_account_id</name> + <rename>valuation_in_account_id</rename> + <update>Y</update> + </value> + <value> + <name>valuation_out_account_id</name> + <rename>valuation_out_account_id</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> |