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
(735, 735, 'New Endowment Plus', 'E', 0, 1, 1,
1, 10, 20, 0, 0, 0, 0,
0, 'Jan 1, 2025', 0, NULL, NULL, 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 0, null, 0, 0, 7350,
10000, 0, 'E', 0, 0, 0, 'LIC')

Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7351, 735, 4, 10, 4, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7352, 735, 1, 10, 6, 1)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7353, 735, 2, 10, 8, 0)
Insert Into PlanNAVReturn (PlanNAVReturnInternalNo, PlanInternalNo, FundInternalNo, NAV, AnnualReturn, DefaultFund)
Values (7354, 735, 6, 10, 10, 0)

insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (735, 4, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (735, 1, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (735, 2, 'Jan 1, 2025', 10)
insert into insurancePlanNAV (PlanInternalno, FundInternalno, Date, NAV) values (735, 6, 'Jan 1, 2025', 10)

Insert Into Mode values (7351, 735, 'Y')
Insert Into Mode values (7352, 735, 'H')
Insert Into Mode values (7353, 735, 'Q')
Insert Into Mode values (7354, 735, 'E')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73501, 0, 99, 1, 1,  'Y', 5, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73502, 0, 99, 2, 3,  'Y', 3.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73503, 0, 99, 4, 99,  'Y', 2.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73504, 0, 99, 1, 1,  'H', 5, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73505, 0, 99, 2, 3,  'H', 3.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73506, 0, 99, 4, 99,  'H', 2.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73507, 0, 99, 1, 1,  'Q', 5, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73508, 0, 99, 2, 3,  'Q', 3.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73509, 0, 99, 4, 99,  'Q', 2.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73510, 0, 99, 1, 1,  'E', 5, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73511, 0, 99, 2, 3,  'E', 3.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (735, 73512, 0, 99, 4, 99,  'E', 2.5, 0.00)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (735, 'ENG', 'New Endowment Plus')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (735, 'MAR', 'U;w ,.MksesaV Iyl')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (735, 'HIN', 'U;w ,.MksesaV Iyl')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (735, 'GUJ', '{«ÉÖ +à{eÉà©Éà{÷ ~±É­­»É')

Update InsurancePlan Set HighlightColor = '$00FCFBE0' where PlanInternalno = 735
