/**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_ACCDETAIL' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACCDETAIL' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACCDETAIL' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACCDETAIL' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FABSOLUTE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FABSOLUTE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FABSOLUTE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FTABLETYPE')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FTABLETYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FDATATYPE')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FDATATYPE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FRULEID')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FRULEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FITEMNUMBER')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FITEMNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FENTRYTYPE')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FENTRYTYPE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FABSOLUTE')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FABSOLUTE CHAR(1) DEFAULT '0' NOT NULL );

/**End D:\PDMTOOLS\PDM_UPGRADE_1.3\PDM_UPGRADE\PDM1\TCCIT_table.sql **/
