IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_TYPE1')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_TYPE1 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_RATE1')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_RATE1 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_AMOUNT1')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_AMOUNT1 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FINVOICE_AMOUNT1')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FINVOICE_AMOUNT1 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_TYPE3')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_TYPE3 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_RATE3')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_RATE3 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_AMOUNT3')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_AMOUNT3 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FINVOICE_AMOUNT3')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FINVOICE_AMOUNT3 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_TYPE2')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_TYPE2 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_RATE2')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_RATE2 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_AMOUNT2')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_AMOUNT2 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FINVOICE_AMOUNT2')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FINVOICE_AMOUNT2 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_TYPE4')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_TYPE4 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_RATE4')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_RATE4 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_AMOUNT4')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_AMOUNT4 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FINVOICE_AMOUNT4')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FINVOICE_AMOUNT4 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_TYPE5')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_TYPE5 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_RATE5')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_RATE5 NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FTAX_AMOUNT5')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FTAX_AMOUNT5 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA' AND KSQL_COL_NAME ='FINVOICE_AMOUNT5')
 ALTER TABLE T_RIM_INV_OVERSEA ADD (FINVOICE_AMOUNT5 DECIMAL(23,2) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_OVERSEA_ITEM' AND KSQL_COL_NAME ='FUNIT')
 ALTER TABLE T_RIM_INV_OVERSEA_ITEM ADD (FUNIT NVARCHAR(50) DEFAULT ' ' NOT NULL );
