× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 02:22 >>>

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
+---

+---
| 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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.