Create Table CommissionMissingPolicy(
  MissingPolicyInternalNo int not null Primary Key,
  CommissionInternalNo int not null foreign key references Commission(CommissionInternalNo),
  PolicyNo varchar(20) not null,
  HolderName varchar(50) not null,
  PlanNo varchar(5) null,
  Term smallint null,
  DueDate DateTime not null,
  RiskDate DateTime not null,
  AdjustmentDate DateTime not null,
  Premium money not null default 0,
  CommissionAmount money not null default 0
)

Insert into IdGenerator values ('CommissionMissingPolicy', 1)
