Also - not all SIH will have RAR (Order Types affect whether there is Sales and A/R impact).
----- Original Message -----
From: Devin Bowen
Sent: Wednesday, March 14, 2001 1:45 AM
To: BPCS-L@midrange.com
Subject: Re: RAR Vs SIL
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
+---