From fe5f8e1a09e37716a1197aa00c5042e198983a90 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 19 May 2025 10:32:51 +0700 Subject: bf capure available minus --- calculate_bi_marketing_md.ktr | 1863 ++++++++++++++++++++--------------------- capture_available_minus.ktr | 272 +++--- 2 files changed, 1025 insertions(+), 1110 deletions(-) diff --git a/calculate_bi_marketing_md.ktr b/calculate_bi_marketing_md.ktr index 83e522e..2c9fd24 100644 --- a/calculate_bi_marketing_md.ktr +++ b/calculate_bi_marketing_md.ktr @@ -430,7 +430,7 @@ 2025/05/13 13:45:32.351 - 2025/05/13 13:45:32.351 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -655,8 +655,8 @@ - parent category - TableInput + Calculator + Calculator Y @@ -665,82 +665,259 @@ none - erp indoteknik production - select id, category, now()::timestamp-'7 hours'::interval as history_date -from( - select ppc.id, name as category - from product_public_category ppc - where ppc.id in( - 2040, - 2097, - 2161, - 2222, - 2246, - 2273, - 2315, - 2354, - 2394, - 2420, - 2477, - 2445 - ) - union - select 999999, 'Others' -)a order by id - 0 - - N - N - N - N - - - Integer - normal + Y + + diff_ly + SUBTRACT + this_year + last_year + + Number + -1 + -1 + N + + + + + + + growth_value + DIVIDE + diff_ly + last_year + + Number + -1 + -1 + N + + + + + + + diff_target + SUBTRACT + this_year + target + + Number + -1 + -1 + N + + + + + + + achv_target + DIVIDE + diff_target + target + + Number + -1 + -1 + N + + + + + + + diff_trx + SUBTRACT + trx_this_year + trx_last_year + + Number + -1 + -1 + N + + + + + + + growth_trx + DIVIDE + diff_trx + trx_last_year + + Number + -1 + -1 + N + + + + + + + diff_ly_full + SUBTRACT + this_year + last_year_full + + Number + -1 + -1 + N + + + + + + + growth_value_full + DIVIDE + diff_ly_full + last_year_full + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 864 + 384 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public + t_omset_by_parent_category
+ id - 9 - 0 - parent category - id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + id + = + + + + id + id + N + + category - 2147483647 - -1 - parent category - category - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - + category + Y + + + history_date + history_date + Y + + + last_year + last_year + Y + + + this_year + this_year + Y + + + target + target + Y + + + trx_last_year + trx_last_year + Y + + + trx_this_year + trx_this_year + Y + + + growth_value + growth_value + Y + + + achv_target + achv_target + Y + + + growth_trx + growth_trx + Y + + + growth_value_full + growth_value_full + Y + + + + + + + + + + + + 624 + 384 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + Sort rows + Sort rows 2 + + id + + + product_category_id + @@ -750,14 +927,14 @@ from( - 160 + 352 288 Y - last year - TableInput + Merge join 2 + MergeJoin Y @@ -766,70 +943,15 @@ from( none - dw bi indoteknik - select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as last_year -from account_move_line aml -join product p on p.product_id = aml.product_id -join account_move am on am.id = aml.move_id -where 1=1 -and aml.parent_state = 'posted' -and am.move_type = 'out_invoice' -and aml.date between to_timestamp(get_first_day_last_year(), 'YYYY-MM-DD') and to_timestamp(get_now_last_year(), 'YYYY-MM-DD') -group by p.parent_category_id - 0 - - N - N - N - N - - - Integer - normal - product_category_id - 9 - 0 - last year - product_category_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - last_year - -1 - -1 - last year - last_year - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - + LEFT OUTER + Merge join + Sort rows 3 + + id + + + product_category_id + @@ -839,14 +961,14 @@ group by p.parent_category_id - 352 - 112 + 496 + 288 Y - Sort rows - SortRows + Merge join 3 + MergeJoin Y @@ -855,23 +977,15 @@ group by p.parent_category_id none - %%java.io.tmpdir%% - out - 1000000 - - N - - N - - - id - Y - N - N - 0 - N - - + LEFT OUTER + Merge join 2 + Sort rows 4 + + id + + + id + @@ -881,14 +995,14 @@ group by p.parent_category_id - 256 + 624 288 Y - Sort rows 2 - SortRows + Merge join 4 + MergeJoin Y @@ -897,23 +1011,15 @@ group by p.parent_category_id none - %%java.io.tmpdir%% - out - 1000000 - - N - - N - - - product_category_id - Y - N - N - 0 - N - - + LEFT OUTER + Merge join 3 + Sort rows 5 + + id + + + product_category_id + @@ -923,13 +1029,47 @@ group by p.parent_category_id - 352 - 208 + 752 + 288 Y - Merge join + Merge join 5 + MergeJoin + + N + + 1 + + none + + + LEFT OUTER + Merge join 4 + Sort rows 6 + + id + + + product_category_id + + + + + + + + + + + 864 + 288 + Y + + + + Merge join 6 MergeJoin Y @@ -940,8 +1080,8 @@ group by p.parent_category_id LEFT OUTER - Sort rows - Sort rows 2 + Merge join 5 + Sort rows 7 id @@ -957,14 +1097,69 @@ group by p.parent_category_id - 352 - 288 + 992 + 288 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + id + + + category + + + history_date + + + last_year + + + this_year + + + target + + + trx_last_year + + + trx_this_year + + + last_year_full + + N + + + + + + + + + + + 992 + 384 Y - this year - TableInput + Select values 2 + SelectValues Y @@ -973,70 +1168,45 @@ group by p.parent_category_id none - dw bi indoteknik - select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as this_year -from account_move_line aml -join product p on p.product_id = aml.product_id -join account_move am on am.id = aml.move_id -where 1=1 -and aml.parent_state = 'posted' -and am.move_type = 'out_invoice' -and to_char(aml.date, 'YYYY') = get_now_year() -group by p.parent_category_id - 0 - - N - N - N - N - - - Integer - normal - product_category_id - 9 - 0 - this year - product_category_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + + + id + + + category + + + history_date + + + last_year + + this_year - -1 - -1 - this year - this_year - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - + + + target + + + trx_last_year + + + trx_this_year + + + growth_value + + + achv_target + + + growth_trx + + + growth_value_full + + N + @@ -1046,13 +1216,13 @@ group by p.parent_category_id - 496 - 112 + 752 + 384 Y - Sort rows 3 + Sort rows SortRows Y @@ -1071,7 +1241,7 @@ group by p.parent_category_id N - product_category_id + id Y N N @@ -1088,14 +1258,14 @@ group by p.parent_category_id - 496 - 208 + 256 + 288 Y - Merge join 2 - MergeJoin + Sort rows 2 + SortRows Y @@ -1104,119 +1274,65 @@ group by p.parent_category_id none - LEFT OUTER - Merge join - Sort rows 3 - - id - - - product_category_id - + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_category_id + Y + N + N + 0 + N + + - - - - - - - 496 - 288 - Y - - - - category target - TableInput - - Y - - 1 - - none - - - dw bi indoteknik - select * from category_target - 0 - - N - N - N - N - - - Integer - normal - id - 9 - 0 - Table input - id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - name - 2147483647 - -1 - Table input - name - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - target - -1 - -1 - Table input - target - ######0.0###################;-######0.0################### - . - - - none - N - Y + + + + + + + 352 + 208 + Y + + + + Sort rows 3 + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_category_id + Y + N + N 0 - N - N - N - en_US - Asia/Bangkok - N - - + N + + @@ -1226,8 +1342,8 @@ group by p.parent_category_id - 624 - 112 + 496 + 208 Y @@ -1274,8 +1390,8 @@ group by p.parent_category_id - Merge join 3 - MergeJoin + Sort rows 5 + SortRows Y @@ -1284,15 +1400,23 @@ group by p.parent_category_id none - LEFT OUTER - Merge join 2 - Sort rows 4 - - id - - - id - + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_category_id + Y + N + N + 0 + N + + @@ -1302,14 +1426,14 @@ group by p.parent_category_id - 624 - 288 + 752 + 208 Y - Calculator - Calculator + Sort rows 6 + SortRows Y @@ -1318,127 +1442,65 @@ group by p.parent_category_id none - Y - - diff_ly - SUBTRACT - this_year - last_year - - Number - -1 - -1 - N - - - - - - - growth_value - DIVIDE - diff_ly - last_year - - Number - -1 - -1 - N - - - - - - - diff_target - SUBTRACT - this_year - target - - Number - -1 - -1 - N - - - - - - - achv_target - DIVIDE - diff_target - target - - Number - -1 - -1 - N - - - - - - - diff_trx - SUBTRACT - trx_this_year - trx_last_year - - Number - -1 - -1 - N - - - - - - - growth_trx - DIVIDE - diff_trx - trx_last_year - - Number - -1 - -1 - N - - - - - - - diff_ly_full - SUBTRACT - this_year - last_year_full - - Number - -1 - -1 - N - - - - - - - growth_value_full - DIVIDE - diff_ly_full - last_year_full - - Number - -1 - -1 - N - - - - - + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_category_id + Y + N + N + 0 + N + + + + + + + + + + + + 864 + 208 + Y + + + + Sort rows 7 + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + product_category_id + Y + N + N + 0 + N + + @@ -1448,13 +1510,13 @@ group by p.parent_category_id - 864 - 384 + 992 + 208 Y - trx last year + category target TableInput Y @@ -1465,15 +1527,7 @@ group by p.parent_category_id dw bi indoteknik - select coalesce(p.parent_category_id, 999999) as product_category_id, count(distinct aml.move_id) as trx_last_year -from account_move_line aml -join product p on p.product_id = aml.product_id -join account_move am on am.id = aml.move_id -where 1=1 -and aml.parent_state = 'posted' -and am.move_type = 'out_invoice' -and aml.date between to_timestamp(get_first_day_last_year(), 'YYYY-MM-DD') and to_timestamp(get_now_last_year(), 'YYYY-MM-DD') -group by p.parent_category_id + select * from category_target 0 N @@ -1484,11 +1538,11 @@ group by p.parent_category_id Integer normal - product_category_id + id 9 0 - trx last year - product_category_id + Table input + id ####0;-####0 . , @@ -1505,14 +1559,14 @@ group by p.parent_category_id N - Integer + String normal - trx_last_year - 15 - 0 - trx last year - trx_last_year - ####0;-####0 + name + 2147483647 + -1 + Table input + name + . , @@ -1527,6 +1581,29 @@ group by p.parent_category_id Asia/Bangkok N + + BigNumber + normal + target + -1 + -1 + Table input + target + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + @@ -1537,13 +1614,13 @@ group by p.parent_category_id - 752 + 624 112 Y - trx this year + last year TableInput Y @@ -1554,14 +1631,14 @@ group by p.parent_category_id dw bi indoteknik - select coalesce(p.parent_category_id, 999999) as product_category_id, count(distinct aml.move_id) as trx_this_year + select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as last_year from account_move_line aml join product p on p.product_id = aml.product_id join account_move am on am.id = aml.move_id where 1=1 and aml.parent_state = 'posted' and am.move_type = 'out_invoice' -and to_char(aml.date, 'YYYY') = get_now_year() +and aml.date between to_timestamp(get_first_day_last_year(), 'YYYY-MM-DD') and to_timestamp(get_now_last_year(), 'YYYY-MM-DD') group by p.parent_category_id 0 @@ -1576,7 +1653,7 @@ group by p.parent_category_id product_category_id 9 0 - trx this year + last year product_category_id ####0;-####0 . @@ -1594,181 +1671,29 @@ group by p.parent_category_id N - Integer + BigNumber normal - trx_this_year - 15 - 0 - trx this year - trx_this_year - ####0;-####0 + last_year + -1 + -1 + last year + last_year + ######0.0###################;-######0.0################### . - , + none N Y 0 N - N - N - en_US - Asia/Bangkok - N - - - - - - - - - - - - 864 - 112 - Y - - - - Sort rows 5 - SortRows - - Y - - 1 - - none - - - %%java.io.tmpdir%% - out - 1000000 - - N - - N - - - product_category_id - Y - N - N - 0 - N - - - - - - - - - - - - 752 - 208 - Y - - - - Sort rows 6 - SortRows - - Y - - 1 - - none - - - %%java.io.tmpdir%% - out - 1000000 - - N - - N - - - product_category_id - Y - N - N - 0 - N - - - - - - - - - - - - 864 - 208 - Y - - - - Merge join 4 - MergeJoin - - Y - - 1 - - none - - - LEFT OUTER - Merge join 3 - Sort rows 5 - - id - - - product_category_id - - - - - - - - - - - 752 - 288 - Y - - - - Merge join 5 - MergeJoin - - N - - 1 - - none - - - LEFT OUTER - Merge join 4 - Sort rows 6 - - id - - - product_category_id - + N + N + en_US + Asia/Bangkok + N + + @@ -1778,14 +1703,14 @@ group by p.parent_category_id - 864 - 288 + 352 + 112 Y - Select values - SelectValues + last year full + TableInput Y @@ -1794,45 +1719,70 @@ group by p.parent_category_id none - - - id - - - - category - - - - history_date - - - - last_year - - - - this_year - - - - target - - - - trx_last_year - - - - trx_this_year - - - + dw bi indoteknik + select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as last_year_full +from account_move_line aml +join product p on p.product_id = aml.product_id +join account_move am on am.id = aml.move_id +where 1=1 +and aml.parent_state = 'posted' +and am.move_type = 'out_invoice' +and to_char(aml.date, 'YYYY') = get_last_year() +group by p.parent_category_id + 0 + + N + N + N + N + + + Integer + normal + product_category_id + 9 + 0 + last year full + product_category_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal last_year_full - - - N - + -1 + -1 + last year full + last_year_full + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -1843,89 +1793,13 @@ group by p.parent_category_id 992 - 384 - Y - - - - Select values 2 - SelectValues - - Y - - 1 - - none - - - - - id - - - - category - - - - history_date - - - - last_year - - - - this_year - - - - target - - - - trx_last_year - - - - trx_this_year - - - - growth_value - - - - achv_target - - - - growth_trx - - - - growth_value_full - - - N - - - - - - - - - - - 752 - 384 + 112 Y - Insert / update - InsertUpdate + parent category + TableInput Y @@ -1934,79 +1808,82 @@ group by p.parent_category_id none - dw bi indoteknik - 100 - N - - public - t_omset_by_parent_category
- - id - id - = - - - - id - id - N - - - category - category - Y - - - history_date - history_date - Y - - - last_year - last_year - Y - - - this_year - this_year - Y - - - target - target - Y - - - trx_last_year - trx_last_year - Y - - - trx_this_year - trx_this_year - Y - - - growth_value - growth_value - Y - - - achv_target - achv_target - Y - - - growth_trx - growth_trx - Y - - - growth_value_full - growth_value_full - Y - - + erp indoteknik production + select id, category, now()::timestamp-'7 hours'::interval as history_date +from( + select ppc.id, name as category + from product_public_category ppc + where ppc.id in( + 2040, + 2097, + 2161, + 2222, + 2246, + 2273, + 2315, + 2354, + 2394, + 2420, + 2477, + 2445 + ) + union + select 999999, 'Others' +)a order by id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + parent category + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + category + 2147483647 + -1 + parent category + category + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2016,13 +1893,13 @@ group by p.parent_category_id - 624 - 384 + 160 + 288 Y - last year full + this year TableInput Y @@ -2033,14 +1910,14 @@ group by p.parent_category_id dw bi indoteknik - select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as last_year_full + select coalesce(p.parent_category_id, 999999) as product_category_id, sum(aml.price_subtotal) as this_year from account_move_line aml join product p on p.product_id = aml.product_id join account_move am on am.id = aml.move_id where 1=1 and aml.parent_state = 'posted' and am.move_type = 'out_invoice' -and to_char(aml.date, 'YYYY') = get_last_year() +and to_char(aml.date, 'YYYY') = get_now_year() group by p.parent_category_id 0 @@ -2055,7 +1932,7 @@ group by p.parent_category_id product_category_id 9 0 - last year full + this year product_category_id ####0;-####0 . @@ -2075,11 +1952,11 @@ group by p.parent_category_id BigNumber normal - last_year_full + this_year -1 -1 - last year full - last_year_full + this year + this_year ######0.0###################;-######0.0################### . @@ -2105,14 +1982,14 @@ group by p.parent_category_id - 992 + 496 112 Y - Sort rows 7 - SortRows + trx last year + TableInput Y @@ -2121,23 +1998,70 @@ group by p.parent_category_id none - %%java.io.tmpdir%% - out - 1000000 - - N - - N - - + dw bi indoteknik + select coalesce(p.parent_category_id, 999999) as product_category_id, count(distinct aml.move_id) as trx_last_year +from account_move_line aml +join product p on p.product_id = aml.product_id +join account_move am on am.id = aml.move_id +where 1=1 +and aml.parent_state = 'posted' +and am.move_type = 'out_invoice' +and aml.date between to_timestamp(get_first_day_last_year(), 'YYYY-MM-DD') and to_timestamp(get_now_last_year(), 'YYYY-MM-DD') +group by p.parent_category_id + 0 + + N + N + N + N + + + Integer + normal product_category_id - Y - N - N + 9 + 0 + trx last year + product_category_id + ####0;-####0 + . + , + + none + N + Y 0 - N - - + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + trx_last_year + 15 + 0 + trx last year + trx_last_year + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2147,14 +2071,14 @@ group by p.parent_category_id - 992 - 208 + 752 + 112 Y - Merge join 6 - MergeJoin + trx this year + TableInput Y @@ -2163,15 +2087,70 @@ group by p.parent_category_id none - LEFT OUTER - Merge join 5 - Sort rows 7 - - id - - - product_category_id - + dw bi indoteknik + select coalesce(p.parent_category_id, 999999) as product_category_id, count(distinct aml.move_id) as trx_this_year +from account_move_line aml +join product p on p.product_id = aml.product_id +join account_move am on am.id = aml.move_id +where 1=1 +and aml.parent_state = 'posted' +and am.move_type = 'out_invoice' +and to_char(aml.date, 'YYYY') = get_now_year() +group by p.parent_category_id + 0 + + N + N + N + N + + + Integer + normal + product_category_id + 9 + 0 + trx this year + product_category_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + trx_this_year + 15 + 0 + trx this year + trx_this_year + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2181,8 +2160,8 @@ group by p.parent_category_id - 992 - 288 + 864 + 112 Y diff --git a/capture_available_minus.ktr b/capture_available_minus.ktr index 2bcb431..e717bf7 100644 --- a/capture_available_minus.ktr +++ b/capture_available_minus.ktr @@ -760,6 +760,110 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + Y + + public + stock_quant_history
+ + history_date + history_date + = + + + + product_id + product_id + = + + + + product_id + product_id + Y + + + location_id + location_id + Y + + + qty_onhand + qty_onhand + Y + + + reserved_quantity + reserved_quantity + Y + + + item_code + item_code + Y + + + product_name + product_name + Y + + + history_date + history_date + Y + + + qty_outgoing + qty_outgoing + Y + + + qty_incoming + qty_incoming + Y + + + qty_available + qty_available + Y + + + product_max_qty + product_max_qty + Y + + + plafon_qty + plafon_qty + Y + + + + + + + + + + + + 528 + 352 + Y + + Merge join MergeJoin @@ -876,67 +980,51 @@ product_id - product_id2 - location_id - qty_onhand - reserved_quantity - item_code - product_name - current_date - product_id_3 - qty_outgoing - product_id_1 - qty_incoming - incoming_plus_onhand - qty_available - product_id_2 - product_max_qty - N @@ -1019,27 +1107,21 @@ product_id - location_id - qty_onhand - reserved_quantity - item_code - product_name - current_date @@ -1047,23 +1129,18 @@ qty_outgoing - qty_incoming - qty_available - product_max_qty - plafon_qty - N @@ -1297,59 +1374,45 @@ product_id - product_id2 - location_id - qty_onhand - reserved_quantity - item_code - product_name - current_date - product_id_3 - qty_outgoing - product_id_1 - qty_incoming - incoming_plus_onhand - qty_available - N @@ -1734,35 +1797,27 @@ product_id - product_id2 - location_id - quantity - reserved_quantity - item_code - product_name - current_date - N @@ -1997,43 +2052,33 @@ order by sq.product_id product_id - product_id2 - location_id - quantity - reserved_quantity - item_code - product_name - current_date - product_id_3 - qty_outgoing - N @@ -2065,15 +2110,12 @@ order by sq.product_id product_id - product_id2 - location_id - quantity @@ -2081,35 +2123,27 @@ order by sq.product_id reserved_quantity - item_code - product_name - current_date - product_id_3 - qty_outgoing - product_id_1 - qty_incoming - N @@ -2127,104 +2161,6 @@ order by sq.product_id Y - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - Y - - public - stock_quant_history
- - product_id - product_id - = - - - - product_id - product_id - Y - - - location_id - location_id - Y - - - qty_onhand - qty_onhand - Y - - - reserved_quantity - reserved_quantity - Y - - - item_code - item_code - Y - - - product_name - product_name - Y - - - history_date - history_date - Y - - - qty_outgoing - qty_outgoing - Y - - - qty_incoming - qty_incoming - Y - - - qty_available - qty_available - Y - - - product_max_qty - product_max_qty - Y - - - plafon_qty - plafon_qty - Y - - - - - - - - - - - - 528 - 352 - Y - - -- cgit v1.2.3