
--alter table t_ai_bizvoucher alter column fnumber type VARCHAR (80);
/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\GL_table.sql **/
 EXEC p_AlterColumn 'T_AI_BIZVOUCHER', 'FNUMBER', 'NVARCHAR(80)', 'NOT NULL', '0100', ''' ''';

 EXEC p_DropIdx 'IDX_AI_BIZVOUCHER_SOURCE', 'T_AI_BIZVOUCHER';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AI_BIZVOUCHER_ORG') CREATE INDEX IDX_AI_BIZVOUCHER_ORG ON T_AI_BIZVOUCHER ( FORGID ,FBOOKTYPEID ,FPERIODID );

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
















