/*收款信息*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PAYEE' AND KSQL_COL_NAME ='FPAYERACCOUNTNAME')
ALTER TABLE T_ER_PAYEE ADD (FPAYERACCOUNTNAME NVARCHAR(50) DEFAULT ' ' NOT NULL);

/*出差申请单*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REQACCOUNTENTRY' AND KSQL_COL_NAME ='FPAYERACCOUNTNAME')
ALTER TABLE T_ER_REQACCOUNTENTRY ADD (FPAYERACCOUNTNAME NVARCHAR(50) DEFAULT ' ' NOT NULL);

/*差旅报销单*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMACCOUNTENTRY' AND KSQL_COL_NAME ='FPAYERACCOUNTNAME')
ALTER TABLE T_ER_REIMACCOUNTENTRY ADD (FPAYERACCOUNTNAME NVARCHAR(50) DEFAULT ' ' NOT NULL);

/*费用报销单*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ACCOUNTINFO' AND KSQL_COL_NAME ='FPAYERACCOUNTNAME')
ALTER TABLE T_ER_ACCOUNTINFO ADD (FPAYERACCOUNTNAME NVARCHAR(50) DEFAULT ' ' NOT NULL);

/*还款单*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REPAYMENTBILL' AND KSQL_COL_NAME ='FPAYERACCOUNTNAME')
ALTER TABLE T_ER_REPAYMENTBILL ADD (FPAYERACCOUNTNAME NVARCHAR(50) DEFAULT ' ' NOT NULL);
