/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105019_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_B105019_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105019_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_B105019_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105020_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_B105020_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105020_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_B105020_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105021_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_B105021_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105021_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_B105021_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105038_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_B105038_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_B105038_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_B105038_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A100000_7_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_A100000_7_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A100000_7_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_A100000_7_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEDUCT_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DEDUCT_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEDUCT_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DEDUCT_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_THINKOFSELL_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_THINKOFSELL_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_THINKOFSELL_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_THINKOFSELL_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSETS_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ASSETS_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSETS_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ASSETS_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_RIGHTS_INCOME_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_RIGHTS_INCOME_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_RIGHTS_INCOME_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_RIGHTS_INCOME_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZKZRTH_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ZKZRTH_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZKZRTH_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ZKZRTH_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INVEST_PROFIT_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_INVEST_PROFIT_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INVEST_PROFIT_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_INVEST_PROFIT_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HHQYHHR_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_HHQYHHR_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HHQYHHR_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_HHQYHHR_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TZZCCSCBTZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_TZZCCSCBTZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TZZCCSCBTZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_TZZCCSCBTZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INTEREST_TZ_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_INTEREST_TZ_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INTEREST_TZ_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_INTEREST_TZ_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_GYJZBDSY_TZ_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_GYJZBDSY_TZ_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_GYJZBDSY_TZ_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_GYJZBDSY_TZ_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NON_INSURANCE_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_NON_INSURANCE_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NON_INSURANCE_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_NON_INSURANCE_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INSURANCE_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_INSURANCE_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INSURANCE_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_INSURANCE_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCOME_OTHER_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_INCOME_OTHER_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCOME_OTHER_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_INCOME_OTHER_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_OTHER_OTHER_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_OTHER_OTHER_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_OTHER_OTHER_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_OTHER_OTHER_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_OTHER_SPEC_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_OTHER_SPEC_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_OTHER_SPEC_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_OTHER_SPEC_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SPEC_OTHER_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_SPEC_OTHER_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SPEC_OTHER_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_SPEC_OTHER_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCTZ_OTHER_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ZCTZ_OTHER_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCTZ_OTHER_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ZCTZ_OTHER_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSET_DISPOSE_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ASSET_DISPOSE_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSET_DISPOSE_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ASSET_DISPOSE_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_COST_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_PROFIT_COST_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_COST_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_PROFIT_COST_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_FEES_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_PROFIT_FEES_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_FEES_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_PROFIT_FEES_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_INCOME_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_PROFIT_INCOME_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PROFIT_INCOME_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_PROFIT_INCOME_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCZJTX_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ZCZJTX_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCZJTX_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ZCZJTX_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSETS_LOSS_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ASSETS_LOSS_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ASSETS_LOSS_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ASSETS_LOSS_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_EDUFULL_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_EDUFULL_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_EDUFULL_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_EDUFULL_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_EDULIMIT_TZ_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_EDULIMIT_TZ_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_EDULIMIT_TZ_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_EDULIMIT_TZ_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QT_SALARY_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_QT_SALARY_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QT_SALARY_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_QT_SALARY_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A100000_1_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_A100000_1_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A100000_1_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_A100000_1_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A101020_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_A101020_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A101020_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_A101020_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A102020_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_A102020_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A102020_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_A102020_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A103000_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DG_A103000_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DG_A103000_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DG_A103000_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYCZJDYNS_TZ_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_QYCZJDYNS_TZ_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYCZJDYNS_TZ_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_QYCZJDYNS_TZ_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEV_JJKC_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_DEV_JJKC_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEV_JJKC_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_DEV_JJKC_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YH_TAXCREDIT_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_YH_TAXCREDIT_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YH_TAXCREDIT_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_YH_TAXCREDIT_DET ADD (FBIZNAME 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 ='FTAXORGID') 
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FTAXORGID 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 ='FBIZNAME') 
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FBIZNAME 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 ='FTAXORGID') 
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FTAXORGID 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 ='FBIZNAME') 
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FBIZNAME 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 ='FTAXORGID') 
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FTAXORGID 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 ='FBIZNAME') 
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FBIZNAME 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 ='FTAXORGID') 
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FTAXORGID 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 ='FBIZNAME') 
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_BEFORETAX_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_BEFORETAX_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_BEFORETAX_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_BEFORETAX_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PERIOD_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_PERIOD_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_PERIOD_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_PERIOD_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SALARY_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_SALARY_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SALARY_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_SALARY_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADVERT_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ADVERT_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADVERT_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ADVERT_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YWZDF_TZ_DETAIL' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_YWZDF_TZ_DETAIL ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YWZDF_TZ_DETAIL' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_YWZDF_TZ_DETAIL ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SPEC_DKSS_TZ_DETA' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_SPEC_DKSS_TZ_DETA ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_SPEC_DKSS_TZ_DETA' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_SPEC_DKSS_TZ_DETA ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCTZ_EXPENSE_DET' AND KSQL_COL_NAME ='FTAXORGID') 
 ALTER TABLE T_TCCIT_ZCTZ_EXPENSE_DET ADD (FTAXORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ZCTZ_EXPENSE_DET' AND KSQL_COL_NAME ='FBIZNAME') 
 ALTER TABLE T_TCCIT_ZCTZ_EXPENSE_DET ADD (FBIZNAME VARCHAR(50) DEFAULT ' ' NOT NULL );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_table.sql **/
