/**Begin D:\PDM_UPGRADE\PDM1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT21')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT21 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT22')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT22 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT23')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT23 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT24')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT24 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT25')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT25 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT26')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT26 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT27')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT27 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT28')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT28 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT29')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT29 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT30')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT30 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT31')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT31 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT32')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT32 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT33')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT33 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT34')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT34 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT35')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT35 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT36')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT36 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT37')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT37 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT38')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT38 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT39')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT39 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA' AND KSQL_COL_NAME IN ('FNUMEXT40')) 
 ALTER TABLE T_BCM_EXTENDDATA ADD (FNUMEXT40 DECIMAL(34,15) DEFAULT 0 NOT NULL );
 
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT21')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT21 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT22')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT22 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT23')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT23 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT24')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT24 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT25')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT25 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT26')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT26 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT27')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT27 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT28')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT28 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT29')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT29 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT30')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT30 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT31')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT31 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT32')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT32 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT33')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT33 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT34')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT34 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT35')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT35 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT36')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT36 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT37')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT37 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT38')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT38 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT39')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT39 DECIMAL(34,15) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT40')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT40 DECIMAL(34,15) DEFAULT 0 NOT NULL );
 

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