delete From CommissionRate Where PlanInternalno = 871 and Mode = 'Q'

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710040, 5, 9, 1, 1,  'Q', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710041, 5, 9, 2, 3,  'Q', 5, 0.00)

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


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710044, 10, 14, 1, 1,  'Q', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710045, 10, 14, 2, 3,  'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710046, 10, 14, 4, 99,  'Q', 5, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (871, 8710048, 15, 99, 2, 3,  'Q', 7.5, 0.00)

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

Update ReportOption Set ReportDescription = 'View or Print Your Commission Bill' Where ReportNo = 30
