-- 修改发票是否来源父节点默认值
EXEC p_AlterColumn 'T_ER_REIMBURSEENTRY_A', 'FINVOICEFROMPARENT', 'CHAR(1)', 'NOT NULL', '0001', '''0''';
EXEC p_AlterColumn 'T_ER_PUBREIMEXPDET', 'FINVOICEFROMPARENT', 'CHAR(1)', 'NOT NULL', '0001', '''0''';
EXEC p_AlterColumn 'T_ER_EXPENSEDETAIL', 'FINVOICEFROMPARENT', 'CHAR(1)', 'NOT NULL', '0001', '''0''';

-- 发票是否来源父节点 空值处理为'0'
UPDATE T_ER_REIMBURSEENTRY_A SET FINVOICEFROMPARENT = '0' WHERE FINVOICEFROMPARENT != '1';
UPDATE T_ER_PUBREIMEXPDET SET FINVOICEFROMPARENT = '0' WHERE FINVOICEFROMPARENT != '1';
UPDATE T_ER_EXPENSEDETAIL SET FINVOICEFROMPARENT = '0' WHERE FINVOICEFROMPARENT != '1';