update Invoice set departCoding=(select departCoding from invoicePlan where id=Invoice.invoicePlan_ID) where invoicePlan_ID is not null;
update Invoice set settleAccountsDepartCoding=(select settleAccountsDepartCoding from invoicePlan where id=Invoice.invoicePlan_ID) where invoicePlan_ID is not null;
update Invoice set invoicePlanType=(select type from invoicePlan where id=Invoice.invoicePlan_ID) where invoicePlan_ID is not null;