IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_CHECKENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_CHECKENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_INSTOCKENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_INSTOCKENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_RECEIPTENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_RECEIPTENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_INVOICENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_INVOICENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_ORDERENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_ORDERENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_ORDCHANGENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_ORDCHANGENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_RETURNENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_RETURNENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_SALOUTSTOCKENTRY' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_SALOUTSTOCKENTRY ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_INVOICENTRY2' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_INVOICENTRY2 ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_CHECKENTRY2' AND KSQL_COL_NAME IN ('FJOINTDATACHANNELID')) 
 ALTER TABLE T_PUR_CHECKENTRY2 ADD (FJOINTDATACHANNELID VARCHAR(80) DEFAULT ' ' NOT NULL );