/**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_YJ_ASSETS_ACCDET' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_YJ_ASSETS_ACCDET ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADDDEDUCT_DET' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_ADDDEDUCT_DET ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_PROFITS_ACCDET' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_YJ_PROFITS_ACCDET ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEPRECIATION_DET' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_DEPRECIATION_DET ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_FDCTDYW_ACCDETAIL' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_FDCTDYW_ACCDETAIL ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACCDETAIL' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEP_DETAIL_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_DEP_DETAIL_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_FDC_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_FDC_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_ASS_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_YJ_ASS_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_PRO_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_YJ_PRO_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADDDEDUCT_DE_SJJT' AND KSQL_COL_NAME ='FCONDITIONJSON') 
 ALTER TABLE T_TCCIT_ADDDEDUCT_DE_SJJT ADD (FCONDITIONJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_BRANCH_SHARE_DET' AND KSQL_COL_NAME ='FCONDITIONJSON')
 ALTER TABLE T_TCCIT_BRANCH_SHARE_DET ADD (FCONDITIONJSON NCLOB );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_ASSETS_ACCDET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_YJ_ASSETS_ACCDET ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADDDEDUCT_DET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_ADDDEDUCT_DET ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_PROFITS_ACCDET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_YJ_PROFITS_ACCDET ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEPRECIATION_DET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_DEPRECIATION_DET ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_FDCTDYW_ACCDETAIL' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_FDCTDYW_ACCDETAIL ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACCDETAIL' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_INCRED_ACCDETAIL ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACCDETAIL' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_NONTAX_ACCDETAIL ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCE_ACCDETAIL' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_TREDUCE_ACCDETAIL ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECHTRANS_ACCDET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_TECHTRANS_ACCDET ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_DEP_DETAIL_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_DEP_DETAIL_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_FDC_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_FDC_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_ASS_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_YJ_ASS_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_YJ_PRO_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_YJ_PRO_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_INCRED_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_INCRED_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_NONTAX_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_NONTAX_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TECH_ACC_SJJ' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_TECH_ACC_SJJ ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_TREDUCED_ACC_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_TREDUCED_ACC_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_ADDDEDUCT_DE_SJJT' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_ADDDEDUCT_DE_SJJT ADD (FADVANCEDCONFJSON NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_BRANCH_SHARE_DET' AND KSQL_COL_NAME ='FADVANCEDCONFJSON')
 ALTER TABLE T_TCCIT_BRANCH_SHARE_DET ADD (FADVANCEDCONFJSON NCLOB );


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