# Infor System21 Key Application Files and Libraries Reference

> Source: https://netray.co/tools/infor-system21-key-files-and-libraries-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

The core System21 physical files with their file libraries, application, description and record-lock field, plus the library naming rules you need to find the rest.

## Category

other-erp

## Erp

Infor System21

## Audience

- ERP administrator
- IBM i developer
- Report writer
- Data migration analyst

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### File or library

**Key:** file

**Type:** text

#### Library

**Key:** library

**Type:** text

#### Application

**Key:** app

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Record-lock field

**Key:** lock

**Type:** text

#### Notes

**Key:** notes

**Type:** text

**Rows:**

**File:** FLP003

**Library:** OSLGLF3

**App:** GL

**Desc:** General ledger chart of accounts

**Notes:** GL control record locks use FLP099

**File:** FLP004

**Library:** OSLGLF3

**App:** GL

**Desc:** General ledger period balances

**File:** FLP007

**Library:** OSLGLF3

**App:** GL

**Desc:** General ledger journal header

**Notes:** Linked to FLP008 by CONO, TXSRCE, TT and DOCREF

**File:** FLP008

**Library:** OSLGLF3

**App:** GL

**Desc:** General ledger journal detail (debits and credits for the journal header)

**Notes:** Field names have no file number suffix; qualify them in SQL

**File:** FLP055

**Library:** OSLGLF3

**App:** GL

**Desc:** Period budgets

**File:** FLP083

**Library:** OSLGLF3

**App:** GL

**Desc:** Currency description

**File:** FLPUK2

**Library:** OSLGLF3

**App:** GL

**Desc:** VAT basic details

**File:** INP35

**Library:** OSLD1F3

**App:** IN

**Desc:** Inventory item master

**Lock:** ACTF35

**Notes:** IN uses PNUM for item number

**File:** INP56

**Library:** OSLD1F3

**App:** IN

**Desc:** Inventory pick note header

**File:** INP57

**Library:** OSLD1F3

**App:** IN

**Desc:** Inventory pick note details

**File:** INP60

**Library:** OSLD1F3

**App:** IN

**Desc:** Item stockroom balance profile (balance and availability of items)

**Lock:** STAT60

**Notes:** Stock by stockroom

**File:** INP65

**Library:** OSLD1F3

**App:** IN

**Desc:** Inventory kits lists

**File:** INP80

**Library:** OSLD1F3

**App:** IN

**Desc:** Item lot/batch/serial number control

**Notes:** Balance and availability of lot, batch and serial items

**File:** INP90

**Library:** OSLD1F3

**App:** IN

**Desc:** Item stockroom weekly history

**Notes:** Weekly summary of item transactions

**File:** INP95

**Library:** OSLD1F3

**App:** IN

**Desc:** Stock movement transaction details

**File:** INP96

**Library:** OSLD1F3

**App:** IN

**Desc:** Movements

**Notes:** Cleared by the Movements Audit Report after the inventory month end

**File:** INP99

**Library:** OSLD1F3

**App:** IN

**Desc:** Record locking control file

**Notes:** Used by Inventory, Sales Order Processing and other distribution applications; cleared in the suggested Day Start

**File:** OEP40

**Library:** OSLD1F3

**App:** OE

**Desc:** Sales order header

**Lock:** ACTF40

**Notes:** Order number field ORDN40; OE uses CATN for item number

**File:** OEP50

**Library:** OSLD1F3

**App:** OE

**Desc:** Sales order and invoice charges

**Notes:** Charge sequence 01 to 03 for order charges, 41 to 43 for invoice charges

**File:** OEP55

**Library:** OSLD1F3

**App:** OE

**Desc:** Sales order details by order line number

**Notes:** Header lock on OEP40 covers the lines

**File:** OEP65

**Library:** OSLD1F3

**App:** OE

**Desc:** Invoice header

**File:** OEP70

**Library:** OSLD1F3

**App:** OE

**Desc:** Invoice detail by order and order line number

**File:** PMP01

**Library:** OSLD1F3

**App:** PM

**Desc:** Supplier item details

**File:** PMP02

**Library:** OSLD1F3

**App:** PM

**Desc:** Purchase order header

**Lock:** ACTF02

**Notes:** PM record locking control file is PMP99

**File:** PMP03

**Library:** OSLD1F3

**App:** PM

**Desc:** Purchase order lines

**File:** PMP09

**Library:** OSLD1F3

**App:** PM

**Desc:** Purchase receipt transactions

**File:** PMP17

**Library:** OSLD1F3

**App:** PM

**Desc:** Purchase requisitions

**File:** MSP04

**Library:** OSLPDF3

**App:** Manufacturing

**Desc:** Production item master (planning and manufacturing details)

**Notes:** Extends the inventory item master for manufacturing

**File:** MSP20

**Library:** OSLPDF3

**App:** Manufacturing

**Desc:** Manufacturing routing and BOM header

**File:** MSP24

**Library:** OSLPDF3

**App:** Manufacturing

**Desc:** Manufacturing routing details

**File:** MSP28

**Library:** OSLPDF3

**App:** Manufacturing

**Desc:** Manufacturing component details (BOM at each routing step)

**File:** PLP05

**Library:** OSLPLF3

**App:** PL

**Desc:** Supplier master (A/P control account records and ship-from addresses)

**Lock:** INUS05

**Notes:** PL record locking control file is PLP99

**File:** PLP06

**Library:** OSLPLF3

**App:** PL

**Desc:** Supplier current A/P balance

**File:** PLP10

**Library:** OSLPLF3

**App:** PL

**Desc:** Supplier period A/P balances

**File:** PLP15

**Library:** OSLPLF3

**App:** PL

**Desc:** AP item details

**File:** PLP45

**Library:** OSLPLF3

**App:** PL

**Desc:** Supplier payment details (payments made, automatic and manual)

**File:** PLP50

**Library:** OSLPLF3

**App:** PL

**Desc:** Item payment details

**File:** SLP05

**Library:** OSLSLF3

**App:** SL

**Desc:** Customer master (AR account control, ship-to and invoice-to addresses)

**Lock:** INUS05

**Notes:** SL record locking control file is SLP99

**File:** SLP06

**Library:** OSLSLF3

**App:** SL

**Desc:** Customer current AR balance

**File:** SLP10

**Library:** OSLSLF3

**App:** SL

**Desc:** Customer period balances

**File:** SLP15

**Library:** OSLSLF3

**App:** SL

**Desc:** AR item details

**File:** Library OSLD1F3

**App:** AO, OE, IN, PM, SA, CN

**Desc:** Consolidated distribution file library

**Notes:** Naming: OSL + app code + type letter + version digit

**File:** Library OSLD2F3

**App:** AI, AC, AG, AS, CR, DR, DY, FC, TP, TS, US, VS, WH, WT

**Desc:** Second consolidated distribution file library

**Notes:** Type letters: F file, P program, S source, I IPG definition, D display

**File:** Library OSLPDF3

**App:** Manufacturing

**Desc:** All manufacturing application files

**File:** Library OSLSYS

**App:** System

**Desc:** System21 database commands (DSPFLD, DSPKEY, DSPDEP, PRTDBR and others)

**Notes:** List installed commands with the TOOLS command

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How System21 names files and fields

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What is Infor System 21?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

infor system21, infor system 21 erp, system 21 oep40, system21 inp35 item master, infor system 21 product guide, what is system 21, infor system21 aurora, system 21 file list

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json