I have a similar need.  From time to time someone wants us to track some
other value, that BPCS has no provision for, and I can find tons of fields
in Item Master and other files that currently are not populated, but I do
not know what they are FOR, and the manuals we have are for end users, we
don't have any of the serious IT field explanation manuals.  I do not want
to adopt some unused field that will later be in conflict with its real
purpose in BPCS.

I am looking for a list of fields in BPCS key files that truely are unused
by our version of BPCS, that nothing will go wrong regardless of what we
populate them with, and a list of fields used only by certain applications,
such that if we are not using those applications nothing will go wrong if
we populate them as we please.  We are not on OSG, so I can't go to some
place there for answers.

In a few cases, I have added a new file to contain new info, which can be
linked to BPCS files via item # customer # vendor # etc.  But it is much
better to look at all the fields that are already on INV300 BOM300 SFC300
and the other 300ds, locate one that is unpopulated and try to find out if
it is safe to use that.  Some engineering fields are larger than we need,
so we have parsed them out to say things like - the first X positions is
the customer # we are making this item # for, the last X positions is the
real revision code.  We located the L# message id on field description, and
changed it to the new usage, so that all BPCS programs (screens and
reports) now showed the new label, without us having to do any
modifications to those programs.  We have copy of all our L# substitutions
in a separate library for ease of remerger after any BPCS BMR PTF etc.
upgrade that wipes out all our hard work.

At the very foot of this e-mail is a copy of our notes on our L#
substitutions that we have been useing for years without any known
trouble.  So assuming your version (V6 Unix) sufficiently similar to us (we
405 CD on mixed mode AS/400) and collection of applications and SYS800
settings, then the fields we mucked with might be starting points for you
to consider.  Are you using the whole extra description field?  If not, you
could assign the last 5 positions to your stock locator.

In your case, even if you are operating with multiple facilities, you can
still use some field of IIM item master provided each facility uses the
same kind of Aisle Row Shelf number system within its stockroom warehouse.

We use Item Notes for multiple purposes.
Note that we are using additional description for purposes that most other
companies use notes.
Customer Service department makes heavy use of notes on customers, orders,
lines, ship to etc.
Engineering department does use notes heavily on Items Revisions BOM but
other departments also use some notes.
Raw Materials have notes related to our vendor part numbers for these
items, and contract pricing information managed by the Purchasing Department.
We track factory floor capital products maintenance using Item Numbers for
each machine mold applicator, and the people in charge of that maintenance
use those notes for a history of repairs needed.

Our materials department would like to enter a stock locator for all part
numbers.  This locator will be a reference field only which would be used
for barcode scanning and various reports.  The purpose of the Stock
Locator:  Receiving will know which Aisle, Row and Shelf in which to place
Stock and the material handlers and cycle counter will know where stock is
stored.  We will not manage inventory in and out of these
locations.  Materials controls Facility Planning Data and this would be
the ideal place for this information as materials may enter/update the
locator as required.  The locator number would be 5 characters and
alpha-numeric.

Some of the ideas that we currently considered:  Item Notes but this area
is controlled by Engineering.  Drawing/formula field, controlled by
Engineering and already in use.  List/Catalog No in the Item Master but
this field will be used by Sales in the future.

Is there another company that uses something similar to this now?  Does
anyone have any suggestions on where I could store this data?

Current BPCS Version 6.0.04 (Unix).

> Sincerely,
> ___________________________________________
> Sylvia L. Dufour
> Business Analyst
> Schukra of North America Ltd.
> 666 Ellis Street West
> Windsor, Ontario  N8X 1B4
> Telephone (519) 254-2633  Ext-241
> Fax (519)254-7515
Here are our current Literal substitutions to support our use of fields
other than how BPCS intended them to be used.

MSGFXPLORE contains the "master" collection & the merge program is called
SYSMSGF

Updates here since last installment are mainly in
             none at all - just a review since some of the fields involved
are next mod bait

First Column is what we want BPCS screens & reports to say
     Second is "old BPCS" object description DDS into IBM tools like Query
          Third = L# Al changed & now y"all need further testing to verify
got right one
                Fourth = field name corresponding to this to help MIS &
Query creators
                     Fifth = where should we be looking to see if it got
changed right
                            Sixth = Additional Notes on occasion

# of wires
     packaging size
          L006353
               IPACK in IIM item master
                    INV100

Customer Number
     Drawing/Formula No
           L018135
                IDRAW in IIM item master
                      INV100 INV300 BOM300

Freight
     Pre Paid Amount
           L# not yet re-constructed ... 1998 records misplaced  6646? 6661 ?
                field scenario not yet refreshed from lost corporate memories
                       Shipping

***** next three relevant to Machine Applicator Mold Application

JIT Max Run Rate
     Machine Cut-Off
          L005036
               IMAXR in IIM item master
                    INV100 Machine Applicator Mold Application
                         Rediscovered 2000-July while tidying Al's hovel

JIT Min Run Rate
     Machine To-Date
          L005038
               IMINR in IIM item master
                    INV100 Machine Applicator Mold Application
                         Rediscovered 2000-July while tidying Al's hovel

Maximum Inventory
     Machine Last labor
          L?????
               IMXIN in IIM item master
                    INV100 Machine Applicator Mold Application
                         Rediscovered 2000-July while tidying Al's hovel

Not Used
       Revision Number
             L000633
                    IFENO in IIM item master
                              INV100

Part # / Descr
       Item Description
              L004764
                   IDESC in IIM item master
                              INV100

Pro Bill #
      Loading Pier
             L005223
                field scenario not yet refreshed from lost corporate memories
                           Shipping

Qty per Carton
      Units per Pallet
              L018324
                   IVULP in IIM item master
                              INV100
                                   Jerry wanted "Quantity per Carton" but
                                    Al does not know where else in BPCS
that L#
                                    "object" is used ... creating a
potential for breaking
                                     other software if literal is made
larger than the space the
                                     other software has allocated for it
to fit in
                                     Counter Proposal = "Quantity/Carton"
(no spaces)

Quantity/Carton
                                    see "Qty per Carton"

Quantity per Carton
                                     see "Qty per Carton"

Rev #
   Ref 1
         L007309
              IFII in IIM item master
                              INV100

***** next one relevant to Machine Applicator Mold Application

Target Annual Quantity
     Machine Date Last Maintenance
          L008353
               ITGQY in IIM item master
                    INV100 Machine Applicator Mold Application
                         Rediscovered 2000-July while tidying Al's hovel

Test Board Y/N
       List/Catalog No
              L018136
                   IABBT in IIM item master
                              INV100
                                    Also see Tst Board YN

Tst Board YN
       List/Catalog
              L005205
                   IABBT in IIM item master
                              INV300
                                    Jerry wanted "Test Board Y/N" here
                                     and there is room for that text to
fit on INV300 but
                                    Al does not know where else in BPCS
that L#
                                    "object" is used ... creating a
potential for breaking
                                     other software if literal is made
larger than the space the
                                     other software has allocated for it
to fit in
                                     Counter Proposal = substitute L018136
                                     of INV100 for L005205 of INV300
                                     as a modification, or use plain text
                                     Note INV300 is not a virgin - the DDS
already been
                                     modified at Central
                                     IABBT starts at position 22 of line
15 of INV300
                                     L005205 starts at sideways 2 of line 15
                                     That means there is room in INV300 for a
                                     -19- long literal (22-2-1)

***** next one relevant to Machine Applicator Mold Application

Units per KANBAN Card
     Machine History
          L008849
               IUNCN in IIM item master
                    INV100 Machine Applicator Mold Application
                         Rediscovered 2000-July while tidying Al's hovel

Weight Per 1000
    Weight Per Unit
           L018323
               IWGHT in IIM item master
                              INV100


Al Macintyre
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html



This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 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].