On 5/18/2012 9:27 AM, Venkat Mangudi wrote:
On Fri, May 18, 2012 at 1:53 PM, varun bhansaly<[email protected]> 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
