IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_contractentry_s' AND KSQL_COL_NAME ='fpayterms')
ALTER TABLE t_er_contractentry_s ADD (fpayterms NVARCHAR(255) DEFAULT ' ' NOT NULL);