Sybrand Bakker wrote:
> On Tue, 05 Aug 2003 16:26:43 +0200, Stefan Röhle <roehle_at_uni-mainz.de>
> wrote:
>
>
>>But traditionally (and I cannot change that) we use numbers composed of
>>a special scheme and certain number ranges indicate some properties
>>connected with it (e.g. numbers between 1 and 199 indicate that those
>>invoices return every year, numbers between 200 and 2999 are for general
>>purposes etc.).
>>So I have to make sure that they do not leave the intervals which can
>>happen if there are many missing numbers.
>
>
> So you now have hit the reason NOT to do that, and separate those
> 'meaningful' numbers in separate columns.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Follow Sybrand's advice, and also use a separate process for getting invoice
numbers. Yes auditors like there to be no gaps, so you might consider other
methods. (HINT: look at it like a pad of numbered blank invoices.
--
Ed Prochak
running http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost
Received on Wed Aug 06 2003 - 05:50:34 CDT
