/*PRJ-00064472 差旅壹号机票结算单和酒店结算单增加产品子类型字段 */
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PLANECHECKINGBILL' AND KSQL_COL_NAME ='FPRODUCTSONTYPE')
ALTER TABLE T_ER_PLANECHECKINGBILL ADD (FPRODUCTSONTYPE VARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_HOTELCHECKINGBILL' AND KSQL_COL_NAME ='FPRODUCTSONTYPE')
ALTER TABLE T_ER_HOTELCHECKINGBILL ADD (FPRODUCTSONTYPE VARCHAR(100) DEFAULT ' ' NOT NULL );