RE: Purging BPCS Files of Items not in IIM

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

HiHo

Weather is still great. No rain yet. My garden is yielding a beautiful green 
tomato, heck the kids next door are using them for baseballs.

Try these SQL Statements from a command line

1.      SELECT * FROM ITH WHERE TPROD NOT IN (SELECT IPROD      FROM IIM) AND 
THCOM = ' '

2.      SELECT * from ILI WHERE LPROD NOT IN (SELECT IPROD FROM         IIM)

3.      SELECT * from IWI WHERE WPROD NOT IN (SELECT IPROD      FROM IIM)

4.      SELECT * FROM FRT WHERE RPROD NOT IN (SELECT IPROD      FROM IIM)

5.      SELECT * FROM MBM WHERE BPROD NOT IN (SELECT IPROD      FROM IIM)

These are only a few SQL Statements to verify your system integrity. If these 
SQL Statements yield results don't panic. You probably are carrying incorrect 
data from version to version ( I hope PENTOP is not one of those items) or you 
are importing data to BPCS via bridging.

Your (IIM) Item Master is the key center point. Compare Items found in other 
data files to the (IIM).

IMPORTANT:

Kevin is correct in mentioning the (HPC) Commodity File. The (ITH) Transaction 
History File does contain a mix of Items (IIM) and (HPC) Commodities.

There other files such as the  (ELA) Lot Master File. It is important NOT TO 
DELETE any of the records in the (ELA) file.

The same can be said for.

        (HPO) Purchase order detail
        (ECL) Order Detail

These are only a few of the files.

I hope this helps

Marc "Fried Green Tomatoes" Lacelle
Royal Canadian Mint


> ----------
> From:         Somsen, Jerry[SMTP:SomsenJ@Dakotah.com]
> Reply To:     bpcs-l@midrange.com
> Sent:         Wednesday, September 18, 2002 12:26 PM
> To:   'bpcs-l@midrange.com'
> Subject:      Purging BPCS Files of Items not in IIM
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> We have BPCS files that contain records that have no matching Item in the
> Item Master (IIM) file.  Is it safe to delete these items from other BPCS
> files without any kind of verification?  Thanks for the advice in advance!
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>