From 86b41b151a3d096340bd385d86788bc4682f32c3 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 19 Sep 2023 15:22:08 +0700 Subject: change to discount --- insert_update_pricelist.ktr | 4 ++-- insert_update_pricelist1.ktr | 29 +++++++++++++++++++++++------ insert_update_pricelist2.ktr | 29 +++++++++++++++++++++++------ insert_update_pricelist3.ktr | 25 +++++++++++++++++++++---- insert_update_pricelist4.ktr | 25 +++++++++++++++++++++---- insert_update_pricelist5.ktr | 25 +++++++++++++++++++++---- 6 files changed, 111 insertions(+), 26 deletions(-) diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 1a3e5b8..bff46d2 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -918,8 +918,8 @@ - 896 - 128 + 864 + 112 Y diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr index f45c2d1..ded5424 100644 --- a/insert_update_pricelist1.ktr +++ b/insert_update_pricelist1.ktr @@ -649,7 +649,7 @@ - fixed + formula -1 -1 N @@ -721,7 +721,19 @@ - list_price + pricelist + -1 + -1 + N + + + base_pricelist_const + Integer + + + + + 17022 -1 -1 N @@ -757,9 +769,9 @@ N - price_tier1 + disc_tier1 <> - fixed_price + price_discount @@ -836,8 +848,8 @@ Y - fixed_price - price_tier1 + price_discount + disc_tier1 Y @@ -865,6 +877,11 @@ base_const Y + + base_pricelist_id + base_pricelist_const + Y + diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index ddbc082..9f5a36e 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -649,7 +649,7 @@ - fixed + formula -1 -1 N @@ -721,7 +721,19 @@ - list_price + pricelist + -1 + -1 + N + + + base_pricelist_const + Integer + + + + + 17022 -1 -1 N @@ -757,9 +769,9 @@ N - price_tier2 + disc_tier2 <> - fixed_price + price_discount @@ -836,8 +848,8 @@ Y - fixed_price - price_tier2 + price_discount + disc_tier2 Y @@ -865,6 +877,11 @@ base_const Y + + base_pricelist_id + base_pricelist_const + Y + diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index 52d3dc9..974c99b 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -649,7 +649,7 @@ - fixed + formula -1 -1 N @@ -721,7 +721,19 @@ - list_price + pricelist + -1 + -1 + N + + + base_pricelist_const + Integer + + + + + 17022 -1 -1 N @@ -836,8 +848,8 @@ Y - fixed_price - price_tier3 + price_discount + disc_tier3 Y @@ -865,6 +877,11 @@ base_const Y + + base_pricelist_id + base_pricelist_const + Y + diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr index c09de77..96a13e5 100644 --- a/insert_update_pricelist4.ktr +++ b/insert_update_pricelist4.ktr @@ -649,7 +649,7 @@ - fixed + formula -1 -1 N @@ -721,7 +721,19 @@ - list_price + pricelist + -1 + -1 + N + + + base_pricelist_const + Integer + + + + + 17022 -1 -1 N @@ -836,8 +848,8 @@ Y - fixed_price - price_tier4 + price_discount + disc_tier4 Y @@ -865,6 +877,11 @@ base_const Y + + base_pricelist_id + base_pricelist_const + Y + diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr index 128f6e4..480a8db 100644 --- a/insert_update_pricelist5.ktr +++ b/insert_update_pricelist5.ktr @@ -649,7 +649,7 @@ - fixed + formula -1 -1 N @@ -721,7 +721,19 @@ - list_price + pricelist + -1 + -1 + N + + + base_pricelist_const + Integer + + + + + 17022 -1 -1 N @@ -836,8 +848,8 @@ Y - fixed_price - price_tier5 + price_discount + disc_tier5 Y @@ -865,6 +877,11 @@ base_const Y + + base_pricelist_id + base_pricelist_const + Y + -- cgit v1.2.3