Other ERPsFree referencePDF, Excel, Word exportInfor System21All Infor System21 tools

Infor System21 Key Application Files and Libraries Reference

A searchable list of the key Infor System21 application files on IBM i with their file library, application, description and record-lock field, plus the library naming rules. It is built from the Geac System 21 Implementation for AS/400 Redbook and helps admins, report writers and migration teams find the right file quickly.

Download:

File or library	Library	Application	Description	Record-lock field	Notes
FLP003	OSLGLF3	GL	General ledger chart of accounts		GL control record locks use FLP099
FLP004	OSLGLF3	GL	General ledger period balances
FLP007	OSLGLF3	GL	General ledger journal header		Linked to FLP008 by CONO, TXSRCE, TT and DOCREF
FLP008	OSLGLF3	GL	General ledger journal detail (debits and credits for the journal header)		Field names have no file number suffix; qualify them in SQL
FLP055	OSLGLF3	GL	Period budgets
FLP083	OSLGLF3	GL	Currency description
FLPUK2	OSLGLF3	GL	VAT basic details
INP35	OSLD1F3	IN	Inventory item master	ACTF35	IN uses PNUM for item number
INP56	OSLD1F3	IN	Inventory pick note header
INP57	OSLD1F3	IN	Inventory pick note details
INP60	OSLD1F3	IN	Item stockroom balance profile (balance and availability of items)	STAT60	Stock by stockroom
INP65	OSLD1F3	IN	Inventory kits lists
INP80	OSLD1F3	IN	Item lot/batch/serial number control		Balance and availability of lot, batch and serial items
INP90	OSLD1F3	IN	Item stockroom weekly history		Weekly summary of item transactions
INP95	OSLD1F3	IN	Stock movement transaction details
INP96	OSLD1F3	IN	Movements		Cleared by the Movements Audit Report after the inventory month end
INP99	OSLD1F3	IN	Record locking control file		Used by Inventory, Sales Order Processing and other distribution applications; cleared in the suggested Day Start
OEP40	OSLD1F3	OE	Sales order header	ACTF40	Order number field ORDN40; OE uses CATN for item number
OEP50	OSLD1F3	OE	Sales order and invoice charges		Charge sequence 01 to 03 for order charges, 41 to 43 for invoice charges
OEP55	OSLD1F3	OE	Sales order details by order line number		Header lock on OEP40 covers the lines
OEP65	OSLD1F3	OE	Invoice header
OEP70	OSLD1F3	OE	Invoice detail by order and order line number
PMP01	OSLD1F3	PM	Supplier item details
PMP02	OSLD1F3	PM	Purchase order header	ACTF02	PM record locking control file is PMP99
PMP03	OSLD1F3	PM	Purchase order lines
PMP09	OSLD1F3	PM	Purchase receipt transactions
PMP17	OSLD1F3	PM	Purchase requisitions
MSP04	OSLPDF3	Manufacturing	Production item master (planning and manufacturing details)		Extends the inventory item master for manufacturing
MSP20	OSLPDF3	Manufacturing	Manufacturing routing and BOM header
MSP24	OSLPDF3	Manufacturing	Manufacturing routing details
MSP28	OSLPDF3	Manufacturing	Manufacturing component details (BOM at each routing step)
PLP05	OSLPLF3	PL	Supplier master (A/P control account records and ship-from addresses)	INUS05	PL record locking control file is PLP99
PLP06	OSLPLF3	PL	Supplier current A/P balance
PLP10	OSLPLF3	PL	Supplier period A/P balances
PLP15	OSLPLF3	PL	AP item details
PLP45	OSLPLF3	PL	Supplier payment details (payments made, automatic and manual)
PLP50	OSLPLF3	PL	Item payment details
SLP05	OSLSLF3	SL	Customer master (AR account control, ship-to and invoice-to addresses)	INUS05	SL record locking control file is SLP99
SLP06	OSLSLF3	SL	Customer current AR balance
SLP10	OSLSLF3	SL	Customer period balances
SLP15	OSLSLF3	SL	AR item details
Library OSLD1F3		AO, OE, IN, PM, SA, CN	Consolidated distribution file library		Naming: OSL + app code + type letter + version digit
Library OSLD2F3		AI, AC, AG, AS, CR, DR, DY, FC, TP, TS, US, VS, WH, WT	Second consolidated distribution file library		Type letters: F file, P program, S source, I IPG definition, D display
Library OSLPDF3		Manufacturing	All manufacturing application files
Library OSLSYS		System	System21 database commands (DSPFLD, DSPKEY, DSPDEP, PRTDBR and others)		List installed commands with the TOOLS command

Files, libraries, descriptions and lock fields are from IBM Redbook SG24-5967, Geac System 21 Implementation for AS/400, chapter 3 (tables 6, 8, 9 and 11). The Redbook describes the 3.5-era product; later Infor System21 and Aurora releases may add files or change details, so confirm with DSPFFD or the System21 Technical Reference.

Get a System21 file map for your site

Send us your library list and the reports you need, and we will map them to the right System21 files, including any custom files you have added.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

How System21 names files and fields

Physical files are named with the two-character application code, the letter P and a sequential file number: OEP40 is the sales order header, INP35 the item master. Field names combine a short field reference code with the last two digits of the file number, so the order number in OEP40 is ORDN40, and the same ORDN code is reused in other files. Applications do not always use the same reference code for the same thing: OE references the item number as CATN while IN uses PNUM. Many General Ledger fields carry no file number at all; FLP007 and FLP008 are linked by CONO, TXSRCE, TT and DOCREF in both files, so always qualify them in SQL.

OEP40 + ORDN = ORDN40 (order number in the order header)
Field reference files are named AAREF, for example OEREF
Work files use suffixes WA to WZ, for example OEPWA

Where the files live

Library names follow OSL + application code + type letter + version digit, for example OSLGLF3 for General Ledger files. Type F is a file library, P program, S source, I IPG definition and D display. Distribution files are consolidated into OSLD1F3 (AO, OE, IN, PM, SA, CN) and OSLD2F3 (AI, AC, AG, AS, CR, DR, DY, FC, TP, TS, US, VS, WH, WT). All manufacturing files are in OSLPDF3. Financial applications keep their own file libraries such as OSLSLF3 and OSLPLF3. To see every System21 library on your system, run DSPOBJD OBJ(QSYS/OSL*) OBJTYPE(*LIB) OUTPUT(*PRINT).

How to list fields and dependencies

System21 ships database commands in OSLSYS that are quicker than the raw IBM i commands for day-to-day work: DSPFLD displays a file's layout, DSPKEY its access path, DSPDEP all logical files over a physical, and PRTDBR prints the database relationships for a library. The standard IBM i commands DSPFFD and DSPDBR give the same information. Before you write a report, check the field list and remember the Redbook's warning that some fields may be obsolete, reused or reserved, so verify the source of each field against real data. The System21 Technical Reference cross-references programs, files and menus if you have it installed.

Record locks you must respect

System21 does not use DBMS record locks or commitment control for maintenance. It uses soft locks. Some master and header files carry a lock field that is set to a non-blank value, usually A, while a user maintains the record: ACTF40 on OEP40, ACTF35 on INP35, ACTF02 on PMP02, INUS05 on SLP05 and PLP05, and STAT60 on INP60. A header lock covers its detail lines. Most applications instead write a row to a record locking control file, such as INP99, PMP99, SLP99, PLP99 or FLP099. After a program failure these locks stay set, which is why the suggested Day Start clears INP99.

Frequently Asked Questions

What is Infor System 21?

System21 is an ERP suite for IBM i, originally from JBA and later Geac, now owned by Infor, with Aurora as a later release line. It covers finance (GL, SL, PL), distribution (OE, IN, PM, WH and others) and manufacturing, and runs on Db2 for i with its files in OSL libraries such as OSLD1F3 and OSLGLF3.

Which file is the sales order header in System21?

OEP40 in library OSLD1F3 is the sales order header, and OEP55 holds the order lines by line number. Invoices are in OEP65 (header) and OEP70 (detail). The header carries the lock field ACTF40, which is set while someone maintains the order.

Where is the customer master in System21?

The customer master is SLP05 in the Sales Ledger file library OSLSLF3. It holds AR account control records and ship-to and invoice-to addresses, and its lock field is INUS05. Balances are in SLP06 (current) and SLP10 (period), and AR item details in SLP15.

Does this list apply to System21 Aurora?

The core files and naming conventions carry through, but the source Redbook describes the 3.5-era product, and later Aurora releases can add files or change details. Confirm each file in your environment with DSPFFD or the System21 DSPFLD command before relying on it.

If you want users to ask System21 about orders, stock and customers in plain English, with read-only queries on your own IBM i, we can set that up.

Talk to an Expert Explore More Free Tools