/**Begin D:\dbpdm\TCVAT_table.sql **/
/**IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FKJZG') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FKJZG VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FDLSB') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FDLSB CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FDLSBZJJG') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FDLSBZJJG VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FJBR') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FJBR VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FBLRYSFZJLX') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FBLRYSFZJLX VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FSLR') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FSLR VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FZGSWJG') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FZGSWJG VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FFDDBRQZRQ') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FFDDBRQZRQ DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FTBRQ') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FTBRQ DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FBLR') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FBLR VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FDLSBRQ') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FDLSBRQ DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FJBRZYZJHM') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FJBRZYZJHM VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FBLRYSFZJHM') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FBLRYSFZJHM VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FSLRQ') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FSLRQ DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FSBLX') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FSBLX VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FSBRQ') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FSBRQ DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FKSZJGXZQH') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FKSZJGXZQH VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FTAXLIMIT') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FTAXLIMIT VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCVAT_NSRXX' AND KSQL_COL_NAME ='FAPANAGE') 
 ALTER TABLE T_TCVAT_NSRXX ADD (FAPANAGE VARCHAR(50) DEFAULT ' ' NOT NULL );**/


/**End D:\dbpdm\TCVAT_table.sql **/
