ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Crum <adrian.c...@sandglass-software.com>
Subject Re: Order Sequence
Date Fri, 18 May 2012 08:30:31 GMT
On 5/18/2012 9:27 AM, Venkat Mangudi wrote:
> On Fri, May 18, 2012 at 1:53 PM, varun bhansaly<vbhansaly@gmail.com>  wrote:
>
>> If you are storing orders in the same entity OrderHeader, then you
>> will have to take measures to prevent PK violations.
>>
>>
> Here's what I had in mind.
>
> A flag will identify if the SO and PO sequences have to be different. A
> configuration that must be done. If this flag is true, the admin has to set
> seq start values for PO and SO. We can warn the admin to set these
> sufficiently apart so that there are no violations. Say 100000 for SO and
> 500000 for PO.

That is not necessary. Just prefix the ID with "PO" or "SO".

Order IDs
---------

SO0001
SO0002
PO0001
PO0002
...


-Adrian


Mime
View raw message