/**Begin D:\DBA\PDM_UPGRADE\PDM1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_EXTENDDATA_BUS' AND KSQL_COL_NAME IN ('FNUMEXT41')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT41 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 ('FNUMEXT42')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT42 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 ('FNUMEXT43')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT43 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 ('FNUMEXT44')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT44 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 ('FNUMEXT45')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT45 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 ('FNUMEXT46')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT46 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 ('FNUMEXT47')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT47 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 ('FNUMEXT48')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT48 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 ('FNUMEXT49')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT49 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 ('FNUMEXT50')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT50 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 ('FNUMEXT51')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT51 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 ('FNUMEXT52')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT52 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 ('FNUMEXT53')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT53 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 ('FNUMEXT54')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT54 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 ('FNUMEXT55')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT55 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 ('FNUMEXT56')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT56 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 ('FNUMEXT57')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT57 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 ('FNUMEXT58')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT58 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 ('FNUMEXT59')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT59 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 ('FNUMEXT60')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT60 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 ('FNUMEXT61')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT61 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 ('FNUMEXT62')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT62 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 ('FNUMEXT63')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT63 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 ('FNUMEXT64')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT64 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 ('FNUMEXT65')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT65 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 ('FNUMEXT66')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT66 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 ('FNUMEXT67')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT67 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 ('FNUMEXT68')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT68 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 ('FNUMEXT69')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT69 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 ('FNUMEXT70')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT70 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 ('FNUMEXT71')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT71 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 ('FNUMEXT72')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT72 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 ('FNUMEXT73')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT73 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 ('FNUMEXT74')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT74 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 ('FNUMEXT75')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT75 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 ('FNUMEXT76')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT76 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 ('FNUMEXT77')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT77 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 ('FNUMEXT78')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT78 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 ('FNUMEXT79')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT79 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 ('FNUMEXT80')) 
 ALTER TABLE T_BCM_EXTENDDATA_BUS ADD (FNUMEXT80 DECIMAL(34,15) DEFAULT 0 NOT NULL );

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