/**Begin D:\datamodel\pdm\PDM_UPGRADE_1.3\PDM_UPGRADE_1.3\PDM_UPGRADE\log\0521\RIM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_AIR' AND KSQL_COL_NAME ='FTRANSPORT_DEDUCTION') 
 ALTER TABLE T_RIM_INV_AIR ADD (FTRANSPORT_DEDUCTION NVARCHAR(2) DEFAULT ' ' NOT NULL ); 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_ORDINARY' AND KSQL_COL_NAME ='FTRANSPORT_DEDUCTION') 
 ALTER TABLE T_RIM_INV_ORDINARY ADD (FTRANSPORT_DEDUCTION NVARCHAR(2) DEFAULT ' ' NOT NULL ); 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_TRAIN' AND KSQL_COL_NAME ='FTRANSPORT_DEDUCTION') 
 ALTER TABLE T_RIM_INV_TRAIN ADD (FTRANSPORT_DEDUCTION NVARCHAR(2) DEFAULT ' ' NOT NULL ); 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INV_TRANSPORT' AND KSQL_COL_NAME ='FTRANSPORT_DEDUCTION') 
 ALTER TABLE T_RIM_INV_TRANSPORT ADD (FTRANSPORT_DEDUCTION NVARCHAR(2) DEFAULT ' ' NOT NULL ); 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INVOICE' AND KSQL_COL_NAME ='FTRANSPORT_DEDUCTION') 
 ALTER TABLE T_RIM_INVOICE ADD (FTRANSPORT_DEDUCTION NVARCHAR(2) DEFAULT ' ' NOT NULL );


/**End D:\datamodel\pdm\PDM_UPGRADE_1.3\PDM_UPGRADE_1.3\PDM_UPGRADE\log\0521\RIM_table.sql **/
