/**Begin  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_BANKPAYINGBILL_E' AND KSQL_COL_NAME IN ('FINFORPAYMENT'))
 ALTER TABLE T_BEI_BANKPAYINGBILL_E ADD (FINFORPAYMENT char(1) DEFAULT '0' NOT NULL  );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_BANKPAYINGBILL_E' AND KSQL_COL_NAME IN ('FINFORMRECEMAIL'))
 ALTER TABLE T_BEI_BANKPAYINGBILL_E ADD (FINFORMRECEMAIL NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_BANKPAYINGBILL_E' AND KSQL_COL_NAME IN ('FPAYMENTAREACODE'))
 ALTER TABLE T_BEI_BANKPAYINGBILL_E ADD (FPAYMENTAREACODE NVARCHAR(3) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_BANKPAYINGBILL_E' AND KSQL_COL_NAME IN ('FPAYMENTFPS'))
 ALTER TABLE T_BEI_BANKPAYINGBILL_E ADD (FPAYMENTFPS NVARCHAR(30) DEFAULT ' ' NOT NULL );

/**End  **/