insert into InsurancePlan (
PlanInternalNo, PlanNo, PlanName, PlanType, WithProfit, NonMedicalGeneral, NonMedicalSpecial, 
NearBirthday, MinimumTerm, MaximumTerm, TermRider, PremiumWaiver, CashOption, LoanGeneral, 
LoanHousing, StartDate, GuranteedAddition, BonusType, FinalAdditionalBonusType,
DeductLoanFromReturn, LoyaltyAdditionType, SurrenderTable, InBuiltAccident, 
AccidentDeathBenefit, NormalDeathBenefit, JointLife, ExpiryDate, UseInPresentation, 
ApplicableMale, ApplicableFemale, MinSA,  MaxSa, MinVestingAge, MaxVestingAge, OrderNo, 
MultipleOf, ChildTermRider, Category, IncomeBenefit, FemaleIllness, CongenitalDisability,
CompanyShortName)
Values
(721, 721, 'New Money Back Plan - 25 years', 'M', 1, 0, 0,
1, 25, 25, 1, 0, 0, 1,
0, 'Jan 1, 2025', 0, '820', 'MBP', 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 200000, null, 0, 0, 7210,
25000, 0, 'M', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7210, 721, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7211, 721, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7212, 721, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7213, 721, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7214, 721, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72101, 1, 99, 1, 1,  'Y', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72102, 1, 99, 2, 5,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72103, 1, 99, 6, 99, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72104, 1, 99, 1, 1,  'H', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72105, 1, 99, 2, 5,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72106, 1, 99, 6, 99, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72107, 1, 99, 1, 1,  'Q', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72108, 1, 99, 2, 5,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72109, 1, 99, 6, 99, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72110, 1, 99, 1, 1,  'E', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72111, 1, 99, 2, 5,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72112, 1, 99, 6, 99, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72113, 1, 99, 1, 1,  'S', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72114, 1, 99, 2, 5,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (721, 72115, 1, 99, 6, 99, 'S', 5, 0.00)


Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (721, 7211, 'April 1, 2024', null, 1, 1, 4.5, 1, 100)

Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (721, 7212, 'April 1, 2024', null, 2, 99, 2.25, 1, 100)

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (721, 'New Money Back Plan - 25 Years', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (721, 'U;w euh cWd Iyku & 25 o"kZ', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (721, 'U;w euh cWd Iyku & 25 lky', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (721, '{«ÉÖ ©É{ÉÒ ¥ÉäG ~±ÉÉ{É - 25 ´ÉºÉÇ', 'GUJ')

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (721, 721001, 25, 60, 1)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (721, 721002, 25, 120, 2)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (721, 721003, 25, 180, 3)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (721, 721004, 25, 240, 4)

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (721, 7211, 11)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (721, 7213, 6)

update InsurancePlan Set HighlightColor = '$00FDEAEE' Where PlanInternalno = 721
