IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_SALOUTSTOCKENTRY' AND KSQL_COL_NAME IN ('FRCVPERSONNAME')) 
 ALTER TABLE T_PUR_SALOUTSTOCKENTRY ADD (FRCVPERSONNAME NVARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_SALOUTSTOCKENTRY' AND KSQL_COL_NAME IN ('FRCVPERSONTEL')) 
 ALTER TABLE T_PUR_SALOUTSTOCKENTRY ADD (FRCVPERSONTEL VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PUR_ORDERENTRY_A' AND KSQL_COL_NAME IN ('FRCVPERSONNAME')) 
 ALTER TABLE T_PUR_ORDERENTRY_A ADD (FRCVPERSONNAME NVARCHAR(200) DEFAULT ' ' NOT NULL );