/** 对公报销单 冲借款 冲申请分录添加换算方式字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMWRIOFFDET' AND KSQL_COL_NAME ='FQUOTETYPE')
 ALTER TABLE T_ER_PUBREIMWRIOFFDET ADD (FQUOTETYPE CHAR(1) DEFAULT '0' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMWRIOFFAPPLY' AND KSQL_COL_NAME ='FQUOTETYPE')
 ALTER TABLE T_ER_PUBREIMWRIOFFAPPLY ADD (FQUOTETYPE CHAR(1) DEFAULT '0' NOT NULL );

/**费用报销单 冲申请 冲借款 分录**/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_WRITEOFFAPPLY' AND KSQL_COL_NAME ='FQUOTETYPE')
 ALTER TABLE T_ER_WRITEOFFAPPLY ADD (FQUOTETYPE CHAR(1) DEFAULT '0' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_WRITEOFFDETAIL' AND KSQL_COL_NAME ='FQUOTETYPE')
  ALTER TABLE T_ER_WRITEOFFDETAIL ADD (FQUOTETYPE CHAR(1) DEFAULT '0' NOT NULL );


/**差旅报销单 冲借款分录 添加换算方式字段**/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBCLEARLOANENTRY' AND KSQL_COL_NAME ='FQUOTETYPE')
 ALTER TABLE T_ER_REIMBCLEARLOANENTRY ADD (FQUOTETYPE CHAR(1) DEFAULT '0' NOT NULL );

