Re: 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