/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/
EXEC p_AlterColumn 'T_EB_MEMBERMAPPING', 'FRANGE', 'NVARCHAR(100)', 'NOT NULL', '0001', '''10''';
EXEC p_AlterColumn 'T_EB_DIMMEMBERMAPPING', 'FUSEASSISTDATA', 'CHAR(1)', 'NOT NULL', '0001', '''0''';
EXEC p_AlterColumn 'T_EB_DIMMEMBERMAPPING', 'FISFREETYPE', 'CHAR(1)', 'NOT NULL', '0001', '''0''';
EXEC p_AlterColumn 'T_EB_DIMMEMBERMAPPING', 'FISEXITNOLEAF', 'CHAR(1)', 'NOT NULL', '0001', '''0''';

update T_EB_MEMBERMAPPING set FRANGE = '10' where FRANGE = ' ';
update T_EB_DIMMEMBERMAPPING set FUSEASSISTDATA = '0' where FUSEASSISTDATA = ' ';
update T_EB_DIMMEMBERMAPPING set FISFREETYPE = '0' where FISFREETYPE = ' ';
update T_EB_DIMMEMBERMAPPING set FISEXITNOLEAF = '0' where FISEXITNOLEAF = ' ';

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/
