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
(774, '774', 'Amritbaal', 'E', 0, 1, 1,
0, 5, 25, 0, 1, 0, 1,
0, 'Oct 1, 2024', 80, null, null, 
1, null, 'N', 0, 
0, 1, 0, null, 1,
1, 1, 200000, null, 0, 0, 7740, 
25000, 0, 'E', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7741, 774, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7742, 774, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7743, 774, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7744, 774, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7745, 774, 'S')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (7746, 774, 'P')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77401, 5, 99, 1, 1,  'Y', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77402, 5, 99, 2, 3,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77403, 5, 99, 4, 99, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77404, 5, 99, 1, 1,  'H', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77405, 5, 99, 2, 3,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77406, 5, 99, 4, 99, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77407, 5, 99, 1, 1,  'Q', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77408, 5, 99, 2, 3,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77409, 5, 99, 4, 99, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77410, 5, 99, 1, 1,  'E', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77411, 5, 99, 2, 3,  'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77412, 5, 99, 4, 99, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77413, 5, 99, 1, 1,  'S', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77414, 5, 99, 2, 3,  'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (774, 77415, 5, 99, 4, 99, 'S', 5, 0.00)

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

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

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

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (774, 'Amritbaal', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (774, 've`rcky', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (774, 've`rcky', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (774, '+©ÉÞlÉ¥ÉÉ±É', 'GUJ')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo)
Values (774, 77401, 2)

Update InsurancePlan Set HighlightColor = '$00B1FCF8' where PlanInternalno in (774)
