/***服务商添加根据订单票价的实际发票类型进行开票与计税字段**/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BIZ_INFO' AND KSQL_COL_NAME IN ('FBILLINGANDTAX'))
ALTER TABLE T_ER_BIZ_INFO ADD (FBILLINGANDTAX VARCHAR(1) DEFAULT '0' NOT NULL );

-- 酒店 用车订单/结算单添加票价 开票类型 字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_HOTELCHECKINGBILL' AND KSQL_COL_NAME IN ('FPRICEBILLINGTYPE'))
ALTER TABLE T_ER_HOTELCHECKINGBILL ADD (FPRICEBILLINGTYPE VARCHAR(10) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_VEHICLECHECKINGBILL' AND KSQL_COL_NAME IN ('FPRICEBILLINGTYPE'))
ALTER TABLE T_ER_VEHICLECHECKINGBILL ADD (FPRICEBILLINGTYPE VARCHAR(10) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_VEHICLEBILL' AND KSQL_COL_NAME IN ('FPRICEBILLINGTYPE'))
ALTER TABLE T_ER_VEHICLEBILL ADD (FPRICEBILLINGTYPE VARCHAR(10) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_HOTELBILL' AND KSQL_COL_NAME IN ('FPRICEBILLINGTYPE'))
ALTER TABLE T_ER_HOTELBILL ADD (FPRICEBILLINGTYPE VARCHAR(10) DEFAULT ' ' NOT NULL );
