Re: End user guide

Installment # 6 from Al Mac.

BPCS has a file naming convention.
First letter
A = Accounts Payable (our use diminished)
B = Billing
C = Cost accounting (CIC and CMF are two very critical files)
D = Distribution planning (we quit using after a fight with Infor)
E = Customer Orders
F = Factory floor shop orders
G = General Ledger
H = Purchasing
I = Inventory Items
J = Forecasting (we don't use)
K = Final Assembly Scheduling (we don't use) and MRP/MPS (we do use)
L = Capacity Planning (our use diminished)
M = Product Structure
N = CIM Path (we don't use)
O = Cash Planning (we don't use)
P = Performance (we don't use)
Q = Fixed Assets (we don't use) and Laboratory (we don't use) and Quality
(we don't use)
R = Accounts Receivable (our use diminished)
S = Sales History Analysis
T = Currency Translation (we don't use)
U = Multi-currency (we don't use)
V = Just in Time
W = Payroll (we don't use on BPCS)
X = cross reference (security problems) and documentation and multi-facility
Y = Advanced Process Industries (we don't use)
Z = System

Versions of BPCS after 405CD add more to this list.

Warning ... your company might not be using all those file applications
Warning ... BPCS files have many fields ... your company is probably not
using them all

You can also see the same kind of list Rob told you about, if you have
command line access, as I will walk you thru here.

Here is a file name = IIM
It is the Item Master

On command line, key
WRKOBJ IIM then enter key

This will tell you library name where most of BPCS files are stored, which
will help you in later explorations.

Now try
WRKOBJ II* and enter
To list all files which start with the letters II

As you can see, there are a heck of a lot of files, so it helps to know the
naming conventions, and what info you are looking for.

Pick one of the letters from the above list, such as
I = Inventory Items

On command line, key
DSPLIB and enter
This gets you a list of libraries in your library list
Do you have one which calls itself BPCS405CDF Files . that is the vanilla
BPCS place where 405 CD files go . we are not using that system

You may end up with a couple names which probably have the files . jot them
down

Earlier you got the library name for vanilla files.
This helps you find files added to your company system in modifications.

On command line, key
WRKOBJ I* then press F4
For library, key in name of library with files (one of them) which you got
from DSPLIB

If you got the right library, you end up with a list of file names. The
ones we are usually most interested in are the 3 letter names, which have
attribute PF.
PF means physical file data.
LF means logical access to a PF.
Logical access controls sequence and sub-selection.

Al Mac (WOW) = Alister William Macintyre
via WOW WAY.com ISP
2012 April I had a serious PC melt down, from which I am still recovering

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of rob@xxxxxxxxx
Sent: Tuesday, October 16, 2012 6:11 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] End user guide

Ryan,

If you are familiar with other databases, and you have an interest in a
query generator of table names, then you're in luck.
Try this on your PC: Start, Programs, IBM System i Access for Windows,
System i Navigator. If you see IBM System i Access for Windows but not
Navigator it might take a case of Coke to the right people on your staff
to get it installed. (It's free.) I know you have parts of IBM System i
Access for Windows from your initial '5.9' comment. System i Navigator
has a great tool for looking at the tables in the BPCS database. It also
has a great tool call "Run SQL Scripts" in which you can type query
statements like this one:
SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, TABLE_TEXT
FROM qsys2/systables
WHERE system_table_schemA='ERPLXF'
ORDER BY SYSTEM_TABLE_NAME

SYSTEM_TABLE_SCHEMA SYSTEM_TABLE_NAME TABLE_TEXT
ERPLXF AAC A/P Approval Codes Master
ERPLXF AACL01 AAC By Comp/Approv Code (Act)
ERPLXF AACL02 AAC By Comp/Approv Code (All)
ERPLXF ABI Bank Master IBAN File
ERPLXF ABIL01 ABI by Company,Bank,Curr Act
ERPLXF ABIL02 ABI by Company,Bank,Curr All
ERPLXF ABK Bank Master File
ERPLXF ABKL01 ABK by Company, Bank, Currency
ERPLXF ABKL02 ABK by Company, Bank, Currency
ERPLXF ABKL03 ABK by Company, currency, bank
ERPLXF ABKX02 Bank Master Extract for SCM
ERPLXF ABK02I Bank Master Inquiry for SCM
ERPLXF ABR Bank Reconcilations File
ERPLXF ABRL01 ABR by COY/Bank/Cur/Type/SubTy
...

Try querying SYSCOLUMNS also.

My ERPLXF database is a newer version than what you're running.

If you are looking for something in the system which shows you the
relationship of the data, like how the order header file ties to the
customer master file, then you're out of luck. The system is capable of
generating that however Infor never set these relationships up (and
probably never will). Instead they rely upon programming to do it all. I
am talking about referential integrity (if that means anything to you).
Infor eschews doing this via the database.

Rob Berendt