Insert into TargetCriteria Values (5, 111, 'Jan 1, 2026', 'Dec 31, 2026', 1, 1, 1)
Insert into TargetCriteria Values (6, 112, 'Jan 1, 2026', 'Dec 31, 2026', 1, 1, 1)
Insert into TargetCriteria Values (7, 113, 'Jan 1, 2026', 'Dec 31, 2026', 1, 1, 1)

insert into TargetCriteriaDetail Values (5, 111, 415, 1, 'FYR', 7815000) -- TOT firstYearCommission = 5253000, firstYearPremium = 21012000
insert into TargetCriteriaDetail Values (5, 111, 416, 1, 'FYP', 31260000)
insert into TargetCriteriaDetail Values (6, 112, 417, 1, 'FYR', 3907500) -- COT firstYearCommission = 2626500, firstYearPremium = 10506000
insert into TargetCriteriaDetail Values (6, 112, 418, 1, 'FYP', 15630000)
insert into TargetCriteriaDetail Values (7, 113, 419, 1, 'FYR', 1302500) -- MDRT firstYearCommission = 875500, firstYearPremium = 3502000
insert into TargetCriteriaDetail Values (7, 113, 420, 1, 'FYP', 5210000)

insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (5, 111, 102, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (6, 112, 103, 'P', 'FYP', 10)
insert into TargetOtherCriteria(TargetInternalNo, TargetCriteriaInternalNo, TargetOtherCriteriaInternalNo, Mode, Criteria, Percentage)
Values (7, 113, 104, 'P', 'FYP', 10)


update insuranceplan set HighlightColor = '$00B1FCF8' where planinternalno = 732

Update PremiumDue Set ServiceTax = 0