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
(717, 717, 'Single Premium Endowment Plan', 'E', 1, 0, 0,
1, 10, 25, 1, 0, 0, 1,
0, 'Oct 1, 2024', 0, '917', 'ENP', 
1, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 100000, null, 0, 0, 7170,
10000, 0, 'E', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7170, 717, 'P')

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (717, 'Single Premium Endowment Plan', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (717, 'flaxy fçfe;e ,UMksoesaV ikWfylh', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (717, 'flaxy fizfe;e ,UMksoesaV ikWfylh', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (717, 'Ï »ÉNÉ±É ¡ÉÒ©ÉÒSÉ©É +à{eÉì©Éá÷ ~ÉÉà±ÉÒ»ÉÒ', 'GUJ')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (717, 71701, 1, 99, 1, 1, 'P', 2, 0.00)

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