Re: RAR Vs SIL

["Devin Bowen" <devinbowen@xxxxxxxxxxx>]

Christine,

 

Document number (also doc prefix, doc year) is the link between SIH and RAR.  Since SIL is the invoice lines file, there is a many to one relationship to RAR.  Keep in mind that two SIH records with the same prefix can have the same invoice # (invoice and credit) but not the same document #.  I may be forgetting something important, but I'm sure I'll be corrected if I am.  That's the beauty of this list!

 

Devin

----- Original Message -----

From: La, Christine

Sent: Tuesday, March 13, 2001 5:04 PM

To: 'BPCS-L@midrange.com'

Subject: RAR Vs SIL

Hi,

Can anyone tell me the exact link between RAR and SIL.
What is the unique key from RAR to SIL?
Is RAR a one-to-many relationship with SIL?

Cheers,
Christine

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---

---

Get your FREE download of MSN Explorer at http://explorer.msn.com