IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FREMARK')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FREMARK NVARCHAR(500) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FSALER_TAX_NO')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FSALER_TAX_NO NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA_ITEM' AND KSQL_COL_NAME ='FPO_NUMBER')
 ALTER TABLE T_RIM_INV_OVERSEA_ITEM ADD (FPO_NUMBER NVARCHAR(50) DEFAULT ' ' NOT NULL );