-- 补全历史默认值（'0'）

update t_cas_accountcashs set fisbycurrency  = '0' where fisbycurrency = ' ';
update t_cas_accountcashs set fenable  = '0' where fenable = ' ';
update t_cas_accountcashs set fclosestatus  = '0' where fclosestatus = ' ';
update t_cas_accountcashs set fctrlstrategy  = '0' where fctrlstrategy = ' ';
update t_cas_accountcashs set fisdefaultpayee  = '0' where fisdefaultpayee = ' ';
update t_cas_accountcashs set FIsDefaultPayer  = '0' where FIsDefaultPayer = ' ';

update t_cas_bankbalanceadjust set fisarchive  = '0'   where fisarchive = ' ';

update t_cas_bankjournal set Fischeck  = '0'   where Fischeck = ' ';
update t_cas_bankjournal set FSyncCheck  = '0'   where FSyncCheck = ' ';

update t_cas_bankstatement set fischeck  = '0'   where fischeck = ' ';
update t_cas_bankstatement set FIsArchive  = '0'   where FIsArchive = ' ';

update t_cas_bankstateschedule set FIsClosed  = '0'   where FIsClosed = ' ';
update t_cas_bankstateschedule set FIsContainUpDown  = '0'   where FIsContainUpDown = ' ';
update t_cas_bankstateschedule set FIsContainReced  = '0'   where FIsContainReced = ' ';

update T_CAS_BankVCCheck set fverifystatus  = '0'   where fverifystatus = ' ';
update T_CAS_BankVCCheck set fadjuststatus  = '0'   where fadjuststatus = ' ';

update t_cas_cashmgtinitbank set FEqual  = '0'   where FEqual = ' ';

update T_CAS_CheckScheme set fischeckflag  = '0'   where fischeckflag = ' ';
update T_CAS_CheckScheme set fissettlenum4schedule  = '0'   where fissettlenum4schedule = ' ';
update T_CAS_CheckScheme set fisbizdate  = '0'   where fisbizdate = ' ';
update T_CAS_CheckScheme set fisdatediff  = '0'   where fisdatediff = ' ';
update T_CAS_CheckScheme set fissettlementtype  = '0'   where fissettlementtype = ' ';
update T_CAS_CheckScheme set fissettlenum4auto  = '0'   where fissettlenum4auto = ' ';
update T_CAS_CheckScheme set fisdescription  = '0'   where fisdescription = ' ';
update T_CAS_CheckScheme set fisoppunit  = '0'   where fisoppunit = ' ';


update t_cas_currencyfacevalue set fenable  = '0'   where fenable = ' ';

update T_CAS_CurrencyFvEntry set FUseStatus  = '0'   where FUseStatus = ' ';

update t_cas_elecreceipt set fismatch  = '0'   where fismatch = ' ';
update t_cas_elecreceipt set ffileflag  = '0'   where ffileflag = ' ';
update t_cas_elecreceipt set fcompleteflag  = '0'   where fcompleteflag = ' ';
update t_cas_elecreceipt set fisarchive  = '0'   where fisarchive = ' ';

update t_cas_exchangebill set FIsVoucher  = '0'   where FIsVoucher = ' ';
update t_cas_exchangebill set FIsArchive  = '0'   where FIsArchive = ' ';


update t_cas_fundflowitem set fisleaf  = '0'   where fisleaf = ' ';
update t_cas_fundflowitem set fenable  = '0'   where fenable = ' ';

update t_cas_interpayplan set fenable  = '0'   where fenable = ' ';

update t_cas_journalbalance set fenable  = '0'   where fenable = ' ';

update T_CAS_MatchingRuleEntry set FIsInternal  = '0'   where FIsInternal = ' ';


update T_CAS_PAYMENTBILL_E set fhotaccount  = '0'   where fhotaccount = ' ';

update T_CAS_PaymentBillType set fisreturnbg  = '0'   where fisreturnbg = ' ';
update T_CAS_PaymentBillType set fispreset  = '0'   where fispreset = ' ';
update T_CAS_PaymentBillType set fispartpayment  = '0'   where fispartpayment = ' ';
update T_CAS_PaymentBillType set fenable  = '0'   where fenable = ' ';

update T_CAS_PayWarnSet set fenable  = '0'   where fenable = ' ';
update T_CAS_PayWarnSet set FIsSamePayee  = '0'   where FIsSamePayee = ' ';
update T_CAS_PayWarnSet set FIsSamePayAmt  = '0'   where FIsSamePayAmt = ' ';
update T_CAS_PayWarnSet set FIsSameSettleType  = '0'   where FIsSameSettleType = ' ';
update T_CAS_PayWarnSet set FIsSamePayerBankNum  = '0'   where FIsSamePayerBankNum = ' ';
update T_CAS_PayWarnSet set FIsSamePayeeBankNum  = '0'   where FIsSamePayeeBankNum = ' ';
update T_CAS_PayWarnSet set FIsSameUsage  = '0'   where FIsSameUsage = ' ';


update T_CAS_RecBillChang set Fisagent  = '0'   where Fisagent = ' ';
update T_CAS_RecBillChang set FIsVoucher  = '0'   where FIsVoucher = ' ';
update T_CAS_RecBillChang set FIsArchive  = '0'   where FIsArchive = ' ';
update T_CAS_RecBillChang set fisdelete  = '0'   where fisdelete = ' ';

update T_CAS_ReceivingBill set Fisagent  = '0'   where Fisagent = ' ';
update T_CAS_ReceivingBill set FIsVoucher  = '0'   where FIsVoucher = ' ';
update T_CAS_ReceivingBill set FIsArchive  = '0'   where FIsArchive = ' ';

update T_CAS_ReceivingBillType set FIsReturnBg  = '0'   where FIsReturnBg = ' ';
update T_CAS_ReceivingBillType set FEnable  = '0'   where FEnable = ' ';
update T_CAS_ReceivingBillType set FIsPreSet  = '0'   where FIsPreSet = ' ';
update T_CAS_ReceivingBillType set FIsPartReceivable  = '0'   where FIsPartReceivable = ' ';

update T_CAS_ReconciliationRule set FEnable  = '0'   where FEnable = ' ';

update T_CAS_RECWARNRESULT set FStatus  = '0'   where FStatus = ' ';

update T_CAS_RECWARNRESULTENTRY set FHassave  = '0'   where FHassave = ' ';

update T_CAS_RECWARNSET set FPayer  = '0'   where FPayer = ' ';
update T_CAS_RECWARNSET set FPaynum  = '0'   where FPaynum = ' ';
update T_CAS_RECWARNSET set FRecnum  = '0'   where FRecnum = ' ';
update T_CAS_RECWARNSET set FRecamount  = '0'   where FRecamount = ' ';
update T_CAS_RECWARNSET set FBizdate  = '0'   where FBizdate = ' ';

update T_CAS_SetTemplate set fisdefault  = '0'   where fisdefault = ' ';


update T_CAS_GLVOUCHERNOTBOOK set FIsCheck  = '0'   where FIsCheck = ' ';

