/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BEI_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FISSUEPROMISERNAME') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FISSUEPROMISERNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FISSUEPROMISERACCOUNT') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FISSUEPROMISERACCOUNT NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FISSUEPROMISERADDR') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FISSUEPROMISERADDR NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FACCEPTPROMISERNAME') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FACCEPTPROMISERNAME NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FACCEPTPROMISERACCOUNT') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FACCEPTPROMISERACCOUNT NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BEI_RECEIVABLEHANDLE_F' AND KSQL_COL_NAME ='FACCEPTPROMISERADDR') 
 ALTER TABLE T_BEI_RECEIVABLEHANDLE_F ADD (FACCEPTPROMISERADDR NVARCHAR(50) DEFAULT ' ' NOT NULL );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BEI_table.sql **/
