I like to use a load id into the database. Why would you base *your*
database integrity on a number generated by your trading partner? Who
knows when they recycle valid po numbers, send you invalid out of
sequence po numbers, etc.
Tyrone Lumley wrote:
> Travis wrote:
>
> > Our accounting package's "documented interface" with it's built-in
> integrity checks- likes to unpredictably (yet frequently) steal lines
> from imported
> EDI POs and place them on manually entered POs our sales people may be
> entering.<
>
> Sounds like the underlying DB was designed poorly. I almost always
> make the PO number the primary key. Or, if importing a PO with SDQ
> segments (by store) a concoctinated key of PO + Line Item. The system
> simply won't let it in. You could even trap the duplicate error and
> display a nag screen. "PO already entered" or something.
>
>
> ---------------------------------
> Do you Yahoo!?
> Get on board. You're invited to try the new Yahoo! Mail.
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
