--declare @region varchar(20) declare @VATP decimal(18,2) --set @region=(Select default_value from system_default where default_name='Region_Code') set @VATP = (Select default_value from system_default where default_name='Vat_Percentage') --print @region --if @region != 'SADC' or @region = 'SADC' --Begin declare @STOREID int; Set @STOREID = (select default_value from System_Default where Default_Name = 'Main_Store_Id'); if @STOREID in (20,21,22,221,289,40,58,61) begin Print 'Create Promotion'; delete from Daily_Promotion_Statistics where Promotion_Item_ID in ( select Promotion_Item.Promotion_Item_ID from Promotion_Item where Promotion_ID=273); delete from DailyPromoData where Promotion_ID=273; delete from Promotion_item where promotion_id=273; delete from promotion where promotion_id=273; SET IDENTITY_INSERT [dbo].[Promotion] ON INSERT [dbo].[Promotion] ([Promotion_ID], [Period_Start], [Period_End], [Supplier_ID], [Description], [Promo_Type_ID], [System_User_ID], [Store_ID], [Sales_Notes],[Created],AddtoSales ,[LockDownDate],[BannerURL]) VALUES (273, CAST('2024-06-07' AS Date), CAST('2024-07-08' AS Date), 1, N'Mega corporate promo',1, 2, 1, NULL,CURRENT_TIMESTAMP,1,CAST('2024-06-06' AS Date) ,'https://res.cloudinary.com/cash-crusaders/image/upload/v1561116015/That_s_A_Wrap_Banner_3200x1500_idvqsx.jpg') SET IDENTITY_INSERT [dbo].[Promotion] OFF Print 'Create Temp Tables'; /****** Object: Table [dbo].[hqPromoTmp] Script Date: 05/02/2014 16:14:13 ******/ -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[[hqPromoTmp]]') AND type in (N'U')) IF OBJECT_ID(N'[dbo].[hqPromoTmp]',N'U') IS NOT NULL BEGIN DROP TABLE [dbo].[hqPromoTmp] END /****** Object: Table [dbo].[hqPromoTmp] Script Date: 10/28/2015 18:45:44 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[hqPromoTmp]( [Promotion_Item_ID] [bigint] NOT NULL, [Promotion_ID] [bigint] NOT NULL, [HQ_Master_ID] [bigint] NOT NULL, [Promo_RRP] [decimal](18, 2) NULL, [Cost_Price] [decimal](18, 2) NOT NULL, [Item_Promo_Type_ID] [int] NULL, [WC_Factor] [decimal](4, 2) NULL, [GTN_Factor] [decimal](4, 2) NULL, [KZN_Factor] [decimal](4, 2) NULL, [EC_Factor] [decimal](4, 2) NULL, [SADC_Factor] [decimal](4, 2) NULL, [Optional] [smallint] NULL, [Low_Margin] [smallint] NULL, [CCW_New] [smallint] NOT NULL, [Product_ID] [bigint], [ParOverride] [int] NULL, [Promo_RRP_Bot] [decimal](18, 2) NULL, [Promo_RRP_Nam] [decimal](18, 2) NULL, [LastUpdated] [datetime] NULL, [MarketingCouponPercentage] [decimal](4,2) null ) ON [PRIMARY] SET NOCOUNT ON INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130435, 273, 24133, CAST(29.90 AS Decimal(18, 2)), CAST(16.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 6, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130437, 273, 1874, CAST(79.90 AS Decimal(18, 2)), CAST(40.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130439, 273, 23637, CAST(79.90 AS Decimal(18, 2)), CAST(51.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130441, 273, 23909, CAST(1199.90 AS Decimal(18, 2)), CAST(804.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130443, 273, 10221, CAST(199.90 AS Decimal(18, 2)), CAST(120.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130445, 273, 10352, CAST(299.90 AS Decimal(18, 2)), CAST(192.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130447, 273, 12248, CAST(399.90 AS Decimal(18, 2)), CAST(268.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130449, 273, 17647, CAST(699.90 AS Decimal(18, 2)), CAST(462.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130451, 273, 17427, CAST(699.90 AS Decimal(18, 2)), CAST(469.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130453, 273, 22719, CAST(799.90 AS Decimal(18, 2)), CAST(536.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130455, 273, 17425, CAST(899.90 AS Decimal(18, 2)), CAST(603.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130457, 273, 22695, CAST(1699.90 AS Decimal(18, 2)), CAST(1190.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130459, 273, 23623, CAST(1799.90 AS Decimal(18, 2)), CAST(1206.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130461, 273, 17835, CAST(2499.90 AS Decimal(18, 2)), CAST(1750.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130463, 273, 15453, CAST(599.90 AS Decimal(18, 2)), CAST(450.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130465, 273, 24129, CAST(699.90 AS Decimal(18, 2)), CAST(525.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130467, 273, 23423, CAST(149.90 AS Decimal(18, 2)), CAST(100.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130469, 273, 15481, CAST(349.90 AS Decimal(18, 2)), CAST(234.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130471, 273, 23007, CAST(399.90 AS Decimal(18, 2)), CAST(286.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130473, 273, 3058, CAST(59.90 AS Decimal(18, 2)), CAST(30.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130475, 273, 13975, CAST(999.90 AS Decimal(18, 2)), CAST(670.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130477, 273, 22733, CAST(999.90 AS Decimal(18, 2)), CAST(670.75 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130479, 273, 22735, CAST(1199.90 AS Decimal(18, 2)), CAST(805.75 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130481, 273, 17697, CAST(1399.90 AS Decimal(18, 2)), CAST(938.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130483, 273, 1106, CAST(1499.90 AS Decimal(18, 2)), CAST(1005.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130485, 273, 22737, CAST(1699.90 AS Decimal(18, 2)), CAST(1139.75 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130487, 273, 3783, CAST(1799.90 AS Decimal(18, 2)), CAST(1350.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130489, 273, 3949, CAST(499.90 AS Decimal(18, 2)), CAST(333.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130491, 273, 23601, CAST(1999.90 AS Decimal(18, 2)), CAST(1400.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130493, 273, 23547, CAST(79.90 AS Decimal(18, 2)), CAST(50.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130495, 273, 21383, CAST(89.90 AS Decimal(18, 2)), CAST(63.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130497, 273, 22985, CAST(299.90 AS Decimal(18, 2)), CAST(201.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130499, 273, 15523, CAST(799.90 AS Decimal(18, 2)), CAST(600.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130501, 273, 17587, CAST(999.90 AS Decimal(18, 2)), CAST(750.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130503, 273, 23443, CAST(1099.90 AS Decimal(18, 2)), CAST(825.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130505, 273, 17621, CAST(1499.90 AS Decimal(18, 2)), CAST(1125.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130507, 273, 24131, CAST(199.90 AS Decimal(18, 2)), CAST(130.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130509, 273, 3071, CAST(1499.90 AS Decimal(18, 2)), CAST(1005.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130511, 273, 26295, CAST(39.90 AS Decimal(18, 2)), CAST(25.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130513, 273, 26297, CAST(39.90 AS Decimal(18, 2)), CAST(25.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130515, 273, 23677, CAST(39.90 AS Decimal(18, 2)), CAST(25.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130517, 273, 24157, CAST(49.90 AS Decimal(18, 2)), CAST(31.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130519, 273, 23681, CAST(49.90 AS Decimal(18, 2)), CAST(32.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130521, 273, 24003, CAST(69.90 AS Decimal(18, 2)), CAST(44.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130523, 273, 24171, CAST(79.90 AS Decimal(18, 2)), CAST(56.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130525, 273, 24141, CAST(89.90 AS Decimal(18, 2)), CAST(63.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130527, 273, 23587, CAST(99.90 AS Decimal(18, 2)), CAST(64.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130529, 273, 23581, CAST(169.90 AS Decimal(18, 2)), CAST(108.75 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130531, 273, 11480, CAST(199.90 AS Decimal(18, 2)), CAST(126.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130533, 273, 13294, CAST(199.90 AS Decimal(18, 2)), CAST(128.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130535, 273, 14093, CAST(189.90 AS Decimal(18, 2)), CAST(152.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130537, 273, 23579, CAST(249.90 AS Decimal(18, 2)), CAST(200.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130539, 273, 23583, CAST(249.90 AS Decimal(18, 2)), CAST(200.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130541, 273, 17463, CAST(799.90 AS Decimal(18, 2)), CAST(680.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130543, 273, 17465, CAST(799.90 AS Decimal(18, 2)), CAST(680.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130545, 273, 23573, CAST(899.90 AS Decimal(18, 2)), CAST(765.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130547, 273, 23575, CAST(899.90 AS Decimal(18, 2)), CAST(765.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130549, 273, 22689, CAST(899.90 AS Decimal(18, 2)), CAST(810.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130551, 273, 22687, CAST(899.90 AS Decimal(18, 2)), CAST(810.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130553, 273, 21657, CAST(599.90 AS Decimal(18, 2)), CAST(450.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130555, 273, 21655, CAST(599.90 AS Decimal(18, 2)), CAST(450.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130557, 273, 28151, CAST(199.90 AS Decimal(18, 2)), CAST(126.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130559, 273, 24183, CAST(59.90 AS Decimal(18, 2)), CAST(38.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130561, 273, 24179, CAST(69.90 AS Decimal(18, 2)), CAST(44.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130563, 273, 24181, CAST(79.90 AS Decimal(18, 2)), CAST(50.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130565, 273, 10366, CAST(89.90 AS Decimal(18, 2)), CAST(57.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130567, 273, 24189, CAST(449.90 AS Decimal(18, 2)), CAST(301.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130569, 273, 24191, CAST(699.90 AS Decimal(18, 2)), CAST(470.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130571, 273, 24193, CAST(999.90 AS Decimal(18, 2)), CAST(670.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130573, 273, 16801, CAST(29.90 AS Decimal(18, 2)), CAST(17.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130575, 273, 22871, CAST(39.90 AS Decimal(18, 2)), CAST(25.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130577, 273, 22765, CAST(49.90 AS Decimal(18, 2)), CAST(32.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130579, 273, 23959, CAST(39.90 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 10, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130581, 273, 23951, CAST(39.90 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 6, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130583, 273, 23961, CAST(39.90 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130585, 273, 23953, CAST(39.90 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 10, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130587, 273, 24151, CAST(249.90 AS Decimal(18, 2)), CAST(160.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130589, 273, 24121, CAST(349.90 AS Decimal(18, 2)), CAST(245.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130591, 273, 25985, CAST(349.90 AS Decimal(18, 2)), CAST(224.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 6, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130593, 273, 12580, CAST(249.90 AS Decimal(18, 2)), CAST(162.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130595, 273, 4282, CAST(699.90 AS Decimal(18, 2)), CAST(469.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130597, 273, 12446, CAST(119.90 AS Decimal(18, 2)), CAST(70.75 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130599, 273, 11181, CAST(999.90 AS Decimal(18, 2)), CAST(850.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130601, 273, 11214, CAST(6499.90 AS Decimal(18, 2)), CAST(5850.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 1, 0, 0, 1, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130603, 273, 23849, CAST(149.90 AS Decimal(18, 2)), CAST(97.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130605, 273, 11486, CAST(2999.90 AS Decimal(18, 2)), CAST(2100.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130607, 273, 23685, CAST(2999.90 AS Decimal(18, 2)), CAST(2700.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130609, 273, 23689, CAST(5999.90 AS Decimal(18, 2)), CAST(5400.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 1, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130611, 273, 23693, CAST(13999.90 AS Decimal(18, 2)), CAST(12600.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 1, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130613, 273, 23593, CAST(59.90 AS Decimal(18, 2)), CAST(38.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130615, 273, 12250, CAST(499.90 AS Decimal(18, 2)), CAST(350.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130617, 273, 12367, CAST(499.90 AS Decimal(18, 2)), CAST(350.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130619, 273, 10394, CAST(699.90 AS Decimal(18, 2)), CAST(525.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130621, 273, 12249, CAST(799.90 AS Decimal(18, 2)), CAST(600.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130623, 273, 6816, CAST(1799.90 AS Decimal(18, 2)), CAST(1260.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130625, 273, 17401, CAST(99.90 AS Decimal(18, 2)), CAST(59.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130627, 273, 23467, CAST(99.90 AS Decimal(18, 2)), CAST(59.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130629, 273, 23465, CAST(99.90 AS Decimal(18, 2)), CAST(59.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130631, 273, 24203, CAST(49.90 AS Decimal(18, 2)), CAST(31.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130633, 273, 26869, CAST(499.90 AS Decimal(18, 2)), CAST(350.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130635, 273, 4008, CAST(299.90 AS Decimal(18, 2)), CAST(196.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130637, 273, 12578, CAST(349.90 AS Decimal(18, 2)), CAST(224.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130639, 273, 11231, CAST(399.90 AS Decimal(18, 2)), CAST(256.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130641, 273, 11232, CAST(549.90 AS Decimal(18, 2)), CAST(353.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130643, 273, 12579, CAST(599.90 AS Decimal(18, 2)), CAST(384.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130645, 273, 12292, CAST(799.90 AS Decimal(18, 2)), CAST(536.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130647, 273, 17505, CAST(1299.90 AS Decimal(18, 2)), CAST(975.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130649, 273, 10174, CAST(249.90 AS Decimal(18, 2)), CAST(167.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130651, 273, 23485, CAST(39.90 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130653, 273, 23819, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130655, 273, 10310, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130657, 273, 13963, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130659, 273, 23883, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130661, 273, 13955, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130663, 273, 23813, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130665, 273, 23487, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130667, 273, 12582, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130669, 273, 10330, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130671, 273, 23791, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130673, 273, 23787, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130675, 273, 12617, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130677, 273, 23801, CAST(49.90 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130679, 273, 14023, CAST(999.90 AS Decimal(18, 2)), CAST(900.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130681, 273, 22675, CAST(2499.90 AS Decimal(18, 2)), CAST(2250.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130683, 273, 23773, CAST(99.90 AS Decimal(18, 2)), CAST(60.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130685, 273, 23775, CAST(129.90 AS Decimal(18, 2)), CAST(83.25 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130687, 273, 22809, CAST(199.90 AS Decimal(18, 2)), CAST(128.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130689, 273, 12832, CAST(199.90 AS Decimal(18, 2)), CAST(128.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130691, 273, 10278, CAST(499.90 AS Decimal(18, 2)), CAST(335.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130693, 273, 24125, CAST(699.90 AS Decimal(18, 2)), CAST(525.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130695, 273, 6842, CAST(599.90 AS Decimal(18, 2)), CAST(450.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130697, 273, 14745, CAST(49.90 AS Decimal(18, 2)), CAST(31.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130699, 273, 23859, CAST(39.90 AS Decimal(18, 2)), CAST(24.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130701, 273, 23863, CAST(49.90 AS Decimal(18, 2)), CAST(30.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 4, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130703, 273, 9450, CAST(349.90 AS Decimal(18, 2)), CAST(234.50 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 3, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) INSERT [dbo].[hqpromotmp] ([Promotion_Item_ID], [Promotion_ID], [HQ_Master_ID], [Promo_RRP], [Cost_Price], [Item_Promo_Type_ID], [WC_Factor], [GTN_Factor], [KZN_Factor], [EC_Factor], [SADC_Factor], [Optional], [Low_Margin], [CCW_New], [ParOverride], [Promo_RRP_Bot], [Promo_RRP_Nam], [LastUpdated], [MarketingCouponPercentage], [Product_Id]) VALUES (130705, 273, 4063, CAST(1699.90 AS Decimal(18, 2)), CAST(1190.00 AS Decimal(18, 2)), 1, CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), CAST(1.00 AS Decimal(4, 2)), 0, 0, 0, 2, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2024-06-06T03:29:00' AS SmallDateTime), CAST(0.00 AS Decimal(18, 2)), NULL) SET NOCOUNT OFF update hqpromotmp set Product_ID=(Select Top(1) Product_ID from product p where p.HQ_Product_ID=hqpromotmp.HQ_Master_ID); print 'Import New promotion'; INSERT INTO [dbo].[Promotion_Item] ([Promotion_ID] ,[Promo_RRP] ,[Store_ID] ,[Cost_Price] ,[Product_ID] ,[Item_Promo_Type_ID] , [Purchase_Quantity_A] ,[Purchase_Quantity_B] ,[Purchase_Quantity_C] ,[Purchase_Quantity_D] ,[Purchase_Quantity_E] ,[WC_Factor] ,[GTN_Factor] ,[KZN_Factor] ,[EC_Factor] ,[SADC_Factor],[ParOverride],[LowMargin],[Promo_RRP_VAT],[MarketingCouponPercentage]) Select promotion_Id, Promo_RRP,1,Cost_Price,Product_ID ,1 ,(case when p.optional=1 then 0 else 1 end) ,(case when p.optional=1 then 0 else 1 end) ,(case when p.optional=1 then 0 else 1 end) ,(case when p.optional=1 then 0 else 1 end) ,(case when p.optional=1 then 0 else 1 end) ,[WC_Factor],[GTN_Factor],[KZN_Factor],[EC_Factor],[SADC_Factor],[ParOverride],[Low_Margin], ([Promo_RRP]*(@VATP/(@VATP+100))),[MarketingCouponPercentage] from hqpromotmp p where Product_ID is not null --Print 'Delete WC exception items' --if (select Default_Value from System_Default where Default_Name = 'region_code') = 'WC' --begin -- DELETE from Promotion_Item -- where Promotion_ID =109 AND PRODUCT_ID IN (select Product_ID from product where product_code in ('HT-108','HT-114A','HT-196A','10071','SL61022','SL61026','SL62026')) --end --go Print 'Check Product_Catalogue' insert into Product_Catalogue_History(Product_Catalogue_ID, Product_Catalogue_Status_ID, reason, MonthEnd) select pc.Product_Catalogue_ID, 6, 'Promotion lines cannot be untried system update', GETDATE() from Product_Catalogue pc where product_catalogue_id in ( select product_catalogue_id from Product_Catalogue where supplier_id=1 and product_id in (select product_Id from Promotion_Item where promotion_id= 273 and (Purchase_Quantity_A=1 or ParOverride>1)) and Product_Catalogue_Status_ID=7 ); update Product_Catalogue set Product_Catalogue_Status_ID=6, Last_Change_Reason='Promotion lines cannot be untried system update', Last_Catalogue_Status_ID=7,Last_Catalogue_Changed=CURRENT_TIMESTAMP where supplier_id=1 and product_id in (select product_Id from Promotion_Item where promotion_id=273 and (Purchase_Quantity_A=1 or ParOverride>1)) and Product_Catalogue_Status_ID=7; Print 'Update Par Level Factor to 100' update system_default set Default_Value = 100 Where Default_name = 'Par_level_factor'; Print 'Clean Up'; Drop Table hqpromotmp; Print 'Done'; end