>ID Generation procedure should use last sequential number stored separately,
>i.e. you should have separate table which will store these numbers for each
>genaration process (e.g. customer ID, invoice ID etc.).

What he said. :-) In addition, integer fields tend to work faster than numeric: you don't indicate in your post which you are currently using.