
/*发票合并规则 合并条件, 增加金额相同字段*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICEMERGERULE' AND KSQL_COL_NAME ='FSEATGRADEQUAL')
ALTER TABLE T_ER_INVOICEMERGERULE ADD (FSEATGRADEQUAL CHAR(1) DEFAULT '0' NOT NULL );


/*手动合并规则 合并条件, 增加金额相同字段*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_MERGERULECFG' AND KSQL_COL_NAME ='FSEATGRADE')
ALTER TABLE T_ER_MERGERULECFG ADD (FSEATGRADE CHAR(1) DEFAULT '0' NOT NULL );

