|
This is an auto-reply... I am out of the office from 3/14/01 thru 3/16/01 returning on 3/19/01. Please contact the helpdesk at 8817 if you need immediate assistance. Thank you. Roberta Brockman AS/400 Development Mgr. Trinity Industries, Inc. (214)589-8220 >>> "BPCS-L@midrange.com" 03/14/01 01:40 >>> This is an auto-reply... I am out of the office from 3/14/01 thru 3/16/01 returning on 3/19/01. Please contact the helpdesk at 8817 if you need immediate assistance. Thank you. Roberta Brockman AS/400 Development Mgr. Trinity Industries, Inc. (214)589-8220 >>> "BPCS-L@midrange.com" 03/14/01 01:18 >>> This is an auto-reply... I am out of the office from 3/14/01 thru 3/16/01 returning on 3/19/01. Please contact the helpdesk at 8817 if you need immediate assistance. Thank you. Roberta Brockman AS/400 Development Mgr. Trinity Industries, Inc. (214)589-8220 >>> "BPCS-L@midrange.com" 03/14/01 00:57 >>> This is an auto-reply... I am out of the office from 3/14/01 thru 3/16/01 returning on 3/19/01. Please contact the helpdesk at 8817 if you need immediate assistance. Thank you. Roberta Brockman AS/400 Development Mgr. Trinity Industries, Inc. (214)589-8220 >>> "BPCS-L@midrange.com" 03/14/01 00:26 >>> > From: Christine.La@pfizer.com (La, Christine) > > 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 I do not believe there is a unique key in either direction, rather that RAR can be linked to SIH which would have a one-to-many relationship with SIL. At version 405 CD, Billing comes from BB* file that comes from Shipping, which also populates a bunch of ES* files, copying much data from original EC* customer orders, and sending "B" to ITH. These records can be interlinked using original customer order #, line # of that order, document # of shipment & other key factoids. Billing generates data to several files, including SIH SIL RAR & I am not sure what populates SSH & SSD. SIH has the header total info on the invoice such as the grand total & ECH type linkage information, SIL has individual lines of the invoice, such as quantity of what item at what price that got shipped, RAR has the account information that the customer owes for the invoice. I rather doubt that there is anything in RAR to uniquely link directly to SIL. I think it would be easier to link RAR to SIH since at that level you should have the grand total information on the invoice, the customer #, date of shipment, and other details. SIL can link to SIH using invoice #. I am not at the office right now, but if you can get at the source code, or to a command line & DSPFD you can get layout of these files & see if invoice # is in RAR, like it is in SIL. I am pretty sure RAR has that much. Be careful about field names which can be misleading relative to population. We get our shipping document # from someone keying in at shipping time & human beings can sometimes have a typo. Depending on how you do shipping - grouped by customer order, or individual lines, one document # could be a one line shipment or a cluster of shipments. MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac) AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax interactive & batch) @ http://www.cen-elec.com Central Industries of Indiana--->Quality manufacturer of wire harnesses and electrical sub-assemblies - fax # 812-424-6838 +--- | 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 +--- +--- | 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 +--- +--- | 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 +--- +--- | 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 +--- +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
