/*出纳初始化历史数据处理*/
delete T_CAS_CashMgtInitCash where FYearDebit = 0 and FYearCredit = 0 and FBalance = 0;
delete T_CAS_CashMgtInitBank where FJournalDebit = 0 and FJournalCredit = 0 and FJournalBalance = 0 and FStatementDebit = 0 and FStatementCredit = 0 and FStatementBalance = 0 and FJournalBalanceAdj = 0 and FStatementBalanceAdj = 0;

/*对公对私处理历史数据处理*/
update T_CAS_PaymentBill_E set fispersonpay = 1  where FID IN (select FID from T_CAS_PaymentBill where fpayeetypeid = 'bos_user');
update T_CAS_PaymentBill_E set fispersonpay = 0   where FID IN (select FID from T_CAS_PaymentBill where  fpayeetypeid != 'bos_user');
update T_CAS_AgentPayBill_E set fispersonpay = 1   where FID IN (select FID from T_CAS_AgentPayBill where  fpayeetype = 'bos_user');
update T_CAS_AgentPayBill_E set fispersonpay = 0   where FID IN (select FID from T_CAS_AgentPayBill where fpayeetype != 'bos_user');

