-- 发票云配置增加发票币别设置、往来单位与开票公司一致
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_KDINVOICECFG' AND KSQL_COL_NAME ='FIDENTICALPARTYINVCOM')
ALTER TABLE T_ER_KDINVOICECFG ADD (FIDENTICALPARTYINVCOM CHAR(1) DEFAULT '2' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_KDINVOICECFG' AND KSQL_COL_NAME ='FINVOICECURRENCY')
ALTER TABLE T_ER_KDINVOICECFG ADD (FINVOICECURRENCY BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_KDINVOICECTRLCFG' AND KSQL_COL_NAME ='FIDENTICALPARTYINVCOM')
ALTER TABLE T_ER_KDINVOICECTRLCFG ADD (FIDENTICALPARTYINVCOM CHAR(1) DEFAULT '2' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_KDINVOICECTRLCFG' AND KSQL_COL_NAME ='FINVOICECURRENCY')
ALTER TABLE T_ER_KDINVOICECTRLCFG ADD (FINVOICECURRENCY BIGINT DEFAULT 0 NOT NULL );