-- 对公报销单增加国家 多税率信息
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMINVOICEINFO' AND KSQL_COL_NAME IN ('FCOUNTRYSTR'))
ALTER TABLE T_ER_PUBREIMINVOICEINFO ADD (FCOUNTRYSTR NVARCHAR(500) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMINVOICEINFO' AND KSQL_COL_NAME IN ('FTAXDETAILS'))
ALTER TABLE T_ER_PUBREIMINVOICEINFO ADD (FTAXDETAILS NVARCHAR(500) DEFAULT ' ' NOT NULL );

-- 账单池增加国家 多税率信息
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_COL_NAME IN ('FCOUNTRYSTR'))
ALTER TABLE T_ER_BILLINGPOOL ADD (FCOUNTRYSTR NVARCHAR(500) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_COL_NAME IN ('FTAXDETAILS'))
ALTER TABLE T_ER_BILLINGPOOL ADD (FTAXDETAILS NVARCHAR(500) DEFAULT ' ' NOT NULL );