/**Begin D:\PDM_UPGRADE\PDM1\CAS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_CASHJOURNALENTRY' AND KSQL_COL_NAME IN ('FAMOUNT_ENP')) 
 ALTER TABLE T_CAS_CASHJOURNALENTRY ADD (FAMOUNT_ENP NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_CASHJOURNALENTRY' AND KSQL_COL_NAME IN ('FLOCALAMOUNT_ENP')) 
 ALTER TABLE T_CAS_CASHJOURNALENTRY ADD (FLOCALAMOUNT_ENP NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_BANKJOURNALENTRY' AND KSQL_COL_NAME IN ('FAMOUNT_ENP')) 
 ALTER TABLE T_CAS_BANKJOURNALENTRY ADD (FAMOUNT_ENP NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_BANKJOURNALENTRY' AND KSQL_COL_NAME IN ('FLOCALAMOUNT_ENP')) 
 ALTER TABLE T_CAS_BANKJOURNALENTRY ADD (FLOCALAMOUNT_ENP NCLOB );

/**End D:\PDM_UPGRADE\PDM1\CAS_table.sql **/
