/**Begin D:\PDMTOOLS\PDM_UPGRADE_1.3\PDM_UPGRADE\PDM1\TCCIT_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FABSOLUTE CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FABSOLUTE CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FTABLETYPE')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FTABLETYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FDATATYPE')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FDATATYPE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FABSOLUTE CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FABSOLUTE CHAR(1) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADJ_DETAIL_SJJT' AND KSQL_COL_NAME ='FADJUSTEXPLAIN')
 ALTER TABLE T_TCCIT_ADJ_DETAIL_SJJT ADD (FADJUSTEXPLAIN VARCHAR(1000) DEFAULT ' ' NOT NULL );
/**End D:\PDMTOOLS\PDM_UPGRADE_1.3\PDM_UPGRADE\PDM1\TCCIT_table.sql **/
