MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference and Help > Technical Support > Key Concepts and Procedures > Control Language > File Support Menu Processing

File Support Menu Processing

 

 

The File Support Menu Program is used:

·     To create or reorganize/purge master files.

·     To display master file statistics.

·     To display data base control fields of master files and the Data Base Control File.

The following processing takes place in the File Support Menu Program:

1.   Display and Validate.  The menu is displayed.  F3 (Return) transfers control back to the System Processing Menu (CFSPMENU).  The ROLL keys display additional file selections.  The options available are:

1 - Create
2 - Display Statistics
3 - Purge/Reorganize
4 - Data Base Inquiry

The file selected must be currently displayed on the menu.  There is relational validation between Option, File Selection, and Horizon Date.

2.   Create Files.  The menu calls the appropriate control language program and passes a file abbreviation to it as a parameter.  The file abbreviations are listed in Figure 2.  (The file abbreviations are defined on Reference File category E38.)  The control language programs in turn call the appropriate RPG programs.  The RPG program called by each control language program is shown in Figure 1.  If an error occurs in the RPG program, it is passed back to the System File Support Menu (MPFSMENU) and displayed.

 

Control Language
Program

RPG
Program

DE010CLP

DE010E

ME010CLP

ME010E

IC010CLP

IC010E

MS010CLP

MS010E

TC010CLP

TC010E

SF010CLP

SF010E

PO010CLP

PO010E

JT010CLP

JT010E

OP010CLP

OP010E

SA010CLP

SA010E

BD010CLP

BD010E

EC010CLP

EC010E

MA010CLP

MA010E

 

 

 

 

 

 

          CLP and RPG Programs Used to Create Files.

 

 

File Code


File Name


Description

VN

APMASTP

Vendor Master File

BC

BCTRN

Bar Coding Transactions

DM

BD100M

Document Master

DS

BD120M

Document Structure

CB

CB540AP

CONBON Card Count Workfile by Cell/Part

CR

CF160M

Carrier Master

EF

CF201M

Std. Extract Data

EU

CF650AP1

EC Sales Statistics Data

ST

CF650AP2

Supp. Sales Statistics Data

CP

CP100AP

CP Planned Labor Req.

CQ

CP310AP

Capacity Planning Report Request

DB

CT110ML

Data Base and System Control

PM

DE100M

Part Master

PS

DE120M

Product Structure

CM

DE130M

Container Master File

LV

DE140M

Location Validation

EC

DE160M

Engineering Changes Master

RV

DE170M

Revision Level Master

PT

DE210M

Part Text Master

SR

EC100M

Standard Rule Master

S1

EC110M1

Screens Rule Header Master

S2

EC110M2

Screen Rule Detail Master

M1

EC120M1

Matrix Header Master

M2

EC120M2

Matrix Detail Master

CF

EC140M

Configuration Code Master

TM

EC160M

Template Master

CL

EC170M

Configuration Assignment

GV

EC205AP

EC Sales Order Global Var.

ED

EDTRN

ED Transaction

ES

ED120AP1

EDI PO Receipt Trans.

HA

ED100AP1

PO Acknowledgment

P9

ED120PURGE

EDI PO Receipt Transaction Purge

P6

ED120REORG

EDI PO Receipt Transaction Reorg

RE

ED140AP1

EDI Sales Order Transactions

GB

GA100M1

Delivery Point

GC

GA100M2

Delivery Rules

GD

GA105M

Exception Dates

GT

GA115M

EDI Numbers

GE

GA120M1

Synchro Blanket Order

GF

GA120M2

Item/Delivery Point

GG

GA120M3

Endorsements

GH

GA120M4

Endorsement Comments

GI

GA145M1

Delivery Notes - Header

GJ

GA145M2

Delivery Notes - Line

GK

GA145M3

Delivery Notes - Comments

GL

GA160M

Labels

GM

GA170M

Intermediate Points

GN

GA200M

Offset Releases

GO

GA210M1

Delivery Request - Header

GP

GA210M2

Delivery Requests - Release

GQ

GA210M3

Delivery Requests - Comments

GR

GA230M1

Synchro Picker - Header

GS

GA230M2

Synchro Picker - Line

MH

GA265AP1

Ship Notice Workfile

AC

IA300AP1

Accounting Cost Generation Request

IR

IA320AP

Inventory Accounting Report Request

R5

ICMOPURGE

MO Purge

R2

ICMOREORG

MO Reorganization

R6

ICSHPURGE

Sales Order Header Purge

R3

ICSHREORG

Sales Order Header Reorganization

R4

ICTHPURGE

Inventory Transaction Purge

R1

ICTHREORG

Inventory Transaction Reorganization

TH

IC020AL

Inventory Transaction Purge

OM

IC100M

Manufacturing Order

BB

IC110AP1

Batch Billing Transaction

CR

IC120M

Component Requirements

LR

IC125M

Labor Requirements

RR

IC130AP

Component Issues/MO Receipt

ML

IC130M

Multiple Location

BF

IC140AP1

Batch Forecast Ship Trans.

WB

IC140M

Warehouse Balance

LC

IC150M

Lot Control

WD

IC170M

Warehouse Description

IN

IC175M

Physical Inventory Ticket File

JM

JC100M

Job Master

PW

JT100AP

Production Schedule/Maintenance Workfile

FA

JT100M

Flow Authorizations Master

FR

JT120M

Flow Requirements Master

JP

JT160M

Part/Production Center Relationship

CE

JT180M

Production Center Master

K1

KC100M

Customer KANBAN Order

K2

KC120M

KANBAN Label Master

LD

LG100M

Load Master

ME

MA100M

Menu Master

OP

MA110M1

Option Master

OD

MA110M2

Option Detail

MN

MA120M

Menu/Option

SM

MA130M

Security Master

SD

MA140M

Security Detail

UM

MA150M

User/Menu Assignment

WC

ME100M

Workcenter

RT

ME120M

Routing

DV

ME140M

Department Validation

KF

MS100M

Key Facility

PR

MS110M

Planned Routing

PP

MS120M

Production Plan

DF

MS150M

Project Demand

MS

MS160M

Master Schedule

SH

OP100M1

Sales Order Header

SL

OP100M2

Sales Order Line

SC

OP100M3

Sales Order Comment

ST

OP100M4

Sales Order Lot/Line

BS

OP100M5

Blanket Order Schedule

SK

OP112AP

Serial Number History

WH

OP120AP1

Shipping/Billing Workfile

OH

OP120M

Sales History

PF

OP140M

Contract Price

RM

OP145M1

RMA Header File

QH

OP170M1

Quote Order Header

QM

OP170M2

Quote Order Detail

QN

OP170M3

Quote Order Comment

CI

OP210M

Purchase Order Receipt Line

PL

OP230M1

Price List Records

DC

OP240M1

Discount Records

BM

OP280M1

Bundle Master File

HR

OP290AP1

Invoice Request Header

EH

OP520AP1

Outbound EDI SO Ackn Hdr

EI

OP540AP1

Outbound EDI Invoice Hdr

BL

OP690AP1

Bill of Lading Transaction

OS

OP695AP1

Outbound EDI Shipment Hdr

P8

POAUTPURGE

Purch. Audit Trail Purge

PA

POAUTR

Purch. Audit Trails

P5

POAUTREORG

Purchase Audit Trails Reorg.

IL

PO140M1

Item/Vendor Relationship

IC

PO140M2

Item/Vendor Relationship Comment

R7

PO140PURGE

Item/Vendor Rel. Hdr. Purge

P1

PO140REORG

Item/Vendor Rel. Hdr. Reorg.

QL

PO150M1

Purchasing Quotation

QC

PO150M2

Purchasing Quotation Comment

RL

PO160M1

Requisition

RC

PO160M2

Requisition Comment

R8

PO160PURGE

Requisition Master Purge

P2

PO160REORG

Requisition Master Reorg.

PO

PO180M1

Purchase Order Header

PH

PO180M2

Purchase Order Line

PD

PO180M3

Purchase Order Release

PC

PO180M4

Purchase Order Comments

R9

PO180PURGE

Purchase Order Header Purge

P3

PO180REORG

Purchase Order Header Reorg

CH

PO210M1

Purchase Order Receipt Header

CL

PO210M2

Purchase Order Receipt Line

CP

PO210M3

Purchase Order Receipt Parcel

CC

PO210M4

Receipt Comment

P7

PO210PURGE

Receipt Header Purge

P4

PO210REORG

Receipt Header Reorg.

IS

PO260M

Item/Buyer Statistics

VA

PO270M

Item/Vendor Analysis

IH

PO280M

Item/Vendor Statistics

VH

PO290M

Vendor Purchase History

BA

PO300M

Item/Buyer Analysis

HP

PO630AP1

Outbound EDI PO Header

RH

RP100AP1

Planning Action Report Header

RP

RP100AP2

Planning Action Report Supply Detail

RD

RP100AP3

Planning Action Report Demand Detail

RJ

RP100AP4

Planning Action Report Job Header

RY

RP100AP5

Planning Action Report Spl. Tr.

TI

RP130AP1

Target Inv/Consl. Demand

TI

RP130AP2

Target Inv/Consl Demand

SW

RP140AP

Sim. Mnt. Workfile

SW

RP140AP2

Sim. Mnt. Workfile

SW

RP140AP3

Sim. Mnt. Workfile

SW

RP140AP4

Sim. Mnt. Workfile

DH

RP330AP1

Part Description Report Hdr.

DD

RP330AP2

Part Description Report Dtl.

RF

RS100M

RS Delivery Conditions

RA

RS110M

RS Endorsement File

DI

RS645AP

RS Ansi Schedule

SA

SA100M

Sales Analysis

SF

SA110M

Sales Forecast Master

SS

SA120M

Sales Summary Master

SQ

SA310AP

Sales Analysis Report Request

TJ

SF020AL

Shop Floor Transaction History

RS

SF310AP

Shop Floor Report Request

TO

TC100M1

Transfer Order Header Master

TL

TC100M2

Transfer Order Line Master

TC

TC100M3

Transfer Order Comment Master

RQ

TC110M1

Transfer Requisition Master

RK

TC110M2

Transfer Requisition Comment

TA

TC510AP

Expected TO Receipts Report

    System File Support Menus - File Abbreviations

 

3.   Display File Statistics.  This option executes the DSPFD command with TYPE (*MBRLIST) for the selected file.  This display shows the number of active and deleted records for each file.  The number of deleted records refers to those deleted by use of the DELET RPG command; it may not reflect the actual number of inactive records for files such as the Part Master, which only tags records for deletion.

4.   File Purge/Reorganization.  When this option is selected, a job to reorganize the selected file is submitted to the batch job queue specified on job description MPPROCJOB.  The menu supports three types of reorganization. 

a.   The first type is for files that have records deleted by the file maintenance programs using the DELET RPG operation.  An example is the Product Structure File.  These files are reorganized by the RGZPFM (Reorganize Physical File Member) control language command. 

b.   The second type is for files that contain records flagged for deletion.  Examples of these files are Part Master and Workcenter.  These reorganization programs are written in RPG and produce a deletion report. 

c.   The third type of reorganization, also in RPG, uses a horizon date to determine whether or not the record is to be removed from the file.  An example of this is the Manufacturing Order File Purge, in which all orders closed earlier than the horizon date and meeting other criteria are removed from the file. 

Figure 3 lists all RPG programs used during the file purging process.

To allow files to be purged and reorganized during the day and reduce the downtime window, the following programs were modified to separate the purges from the reorganizations:

IC020E
IC060E
OP020E
PO020E

Figure 3 identifies the purge and reorganization files and the processing involved with each one.

Some files are purged automatically when another file is selected for reorganization.  Figure 3 identifies what processing occurs when a specific file is selected for reorganization.  This information is defined on Reference File category L34.  The Technical Support Manual - Operation Procedures contains a brief description of the conditions under which records are deleted from each of the files during a reorganization.  For more detailed information, refer to the corresponding module's program documentation manual.

 

 

Program

Program Name

AP010E

Open Item/Payment

AP500E

AP Transaction Files

AR770P

Database Audit

AR775P

Accounting Transaction

CF030E

Vendor Master File Reorganization

CF090E

Bill of Lading Transaction File Purge and Reorganization

CF165E

Carrier Master File Purge

DE020E

Part Master Reorganization

DE025E

Bundle Master Reorganization Program

DE050E

Revision Levels File Purge

EC020E

Rules Reorganization

EC030E

Matrix Reorganization

EC060E

Configuration Code Purge

ED050E

Outbound OP EDI Translation File Purge Program

ED070E

Outbound PO EDI Translation File Purge Program

GA020E*

Synchro Files Reorganization (Master Files)

GA022E

Synchro Files Reorganization (Blanket Order & Endorsement)

GA024E*

Synchro Files Reorganization (Delivery Request)

GA026E*

Synchro Files Reorganization (Picker Header and Line)

GA040E

SYNCHRO Dispatch Notice Workfile Purge Program

GL140P

Journal Report Print and Purge

IC020E

Inventory Control History Purge

IC050E

Lot Control Purge

IC060E

Order/Requirements Purge

IC070E

Warehouse Balance and Multiple Location Purge

JC050E

Job Master Purge

JT020E

Just-in-Time File Purge

ME020E

Workcenter Reorganization

MS040E

Master Scheduling Master File Purge

OP020E

Sales Order Reorganization

OP022E

RMA File Reorganization Program

OP027E

Serial Number History Reorganize Program

OP070E

Contract Price File Purge

OP080E

Quote Order Reorganization

OP090E

Sales Order History Purge

OP127E

Open Order Shipping and Billing Workfile Purge

PO020E

Purchasing File Reorganization

RM290P

Asynchronous Workfile Purge

SF020E

Shop Floor Control Audit Trail Purge

TC020E

Transfer Control File Reorganization

       RPG Purge Programs.

5.   Data Base Inquiry.  The menu calls a control language program (DE030CLP) and passes a file abbreviation to it as a parameter.  The control language program then calls the RPG program (DE030E).

6.   Error Processing.  When any serious or unusual error is encountered by the menu program or the operating system, control is passed to the system error section through the global MONMSG command.  The first message in the program queue is displayed.  The message that a job has been submitted is also shown in this section as a confirmation that a reorganization was run. (For more information on message handling, see Chapter 13 of the IBM manual CPF Programmer's Guide - SC21-7730.)

 

File Number

Abbreviation

Affects

Method

APMASTP

VN

APMASTP - Vendor Master

CF030*

BCTRN

BC

IC120DP - EDC Transactions
OP120EP
PO220DP
IC130DP*
JT***DP*
SF127DP

RGZPFM

BD100M

DM

BD100M - Document Master

RGZPFM

BD120M

DS

BD120M - Document Structure

RGZPFM

CB540AP

CB

CB540AP - CONBON Card Count

RGZPFM

CF160M

CR

CF160M - Carrier Master

CF165E

CF201M1

EF

CF201M1 - Extracted Data Master

CF035E

CF650AP1

EU

CF650AP1 - EC Sales Statistics

CF021E

CF650AP2

ST

CF650AP2 - Supplementary Sales             Statistics

CF021E

CP100AP

CP

CP100AP - CP Planned Labor             Requirements

RGZPFM

CP310AP

CQ

CP310AP - CP Report Req

RGZPFM

CT110ML

DB
Data Base Control

Not Applicable

-----------------------------

DE100M

PM

DE100M - Part Master
DE170M - Revision Levels
DE210M - Part Comments
DE105M - Part Costs
JT160M - Part/Production Center
ME160M1 - Misc Cost Header
ME160M2 - Misc Cost Detail
CF260ML2 - Part Translation

DE020*
RGZPFM

DE120M

PS

DE120M - Product Structure

RGZPFM

DE130M

CM

DE130M - Container Master

RGZPFM

DE140M

LV

DE140M - Loc Validation

RGZPFM

DE160M

EC

DE160M - Engineering Change

RGZPFM

DE170M

RV

DE170M - Revision Level

DE050*, RGZPFM

DE210M

PT

DE210M - Part Comments

RGZPFM

EC100M

SR

EC100M - Standard Header

EC020*,            RGZPFM

EC110M1

S1

EC100M1-2 - Screen Rule Header

EC020*,            RGZPFM

EC110M2

S2

Not Applicable

-----------------------------

EC120M1

M1

EC120M1-2 - Matrix Rule

EC030*,            RGZPFM

EC120M2

M2

Not Applicable

-----------------------------

EC140M

CF

Configuration Code Master

EC060E

EC160M

TM

Template Master

RGZPFM

EC170M

CL

Not Applicable

-----------------------------

EC205AP

GV

EC205AP - EC Sales Order Global             Variable

RGZPFM

EDTRN

ED

ED100AP1 - PO Acknowledgment             Transaction Header

RGZPFM

ED100AP1

HA

ED100AP1 - PO Acknowledgment             Transaction Header

RGZPFM

ED120PURGE

P9 (purge only)

ED120AP1 - Inbound Receipt Header
ED120AP2 - Inbound Receipt Lines
ED120AP3 - Inbound Receipt Lot

Note:  File are not reorganized with             this option.

PO020E

ED120REORG

P6 (reorg. only)

ED120AP1 - Inbound Receipt Header
ED120AP2 - Inbound Receipt Lines
ED120AP3 - Inbound Receipt Lot

PO020E

ED120AP1

ES (purges and reorganizes)

ED120AP1 - Inbound Receipt Header
ED120AP2 - Inbound Receipt Lines
ED120AP3 - Inbound Receipt Lot

PO020E

ED140AP1

RE

ED140AP1 - EDI Sales Order             Transaction
ED140AP2 - EDI Sales Order             Transaction Detail
ED140AP3 - EDI Sales Order Header             Comments
ED140AP4 - EDI Sales Order Detail             Comments
ED140AP5 - EDI Sales Order             Transaction Error

RGZPFM

GA060M

GA

GA060M - Shipping Calendars

RGZPFM

GA100M1

GB

GA100M1 - Delivery Point

GA020E*

GA100M2

GC

GA100M2 - Delivery Rules

RGZPFM

GA105M

BD

GA105M - Exception Dates

GA020E*

GA115M

GT

Not Applicable

-----------------------------

GA120M1

GE

GA120M1 - Synchro Blanket Order
GA120M2 - Item/Delivery Point
GA120M3 - Endorsements
GA120M4 - Endorsement Comments

GA022E*

GA120M2

GF

GA120M2 - Item/Delivery Point

GA022E*, RGZPFM

GA120M3

GG

GA120M3 - Endorsements
GA120M4 - Endorsement Comments

GA022*, RGZPFM

GA120M4

GH

GA120M4 - Endorsement Comments

RGZPFM

GA145M1

GI

GA145M1 - Delivery Notes-Header

RGZPFM

GA145M2

GJ

GA145M1 - Delivery Notes - Line

RGZPFM

GA145M3

GG

GA145M3 - Endorsements

RGZPFM

GA160M

GL

GA160M - Labels

RGZPFM

GA170M

GM

GA170M - Intermediate Points

RGZPFM

GA200M

GN

GA200M - Offset Releases

GA020E*

GA210M1

GO

GA210M* - Delivery Requests
GA200M - Offset Releases

GA024E*

GA210M2

GP

GA210M2 - Delivery Requests -             Release

RGZPFM

GA210M3

GQ

GA210M3 - Endorsements

RGZPFM

GA230M1

GR

GA230M* - Synchro Picker
GA145M* - Shipping List
GA160M - Labels

GA026E*

GA230M2

GS

GA230M2 - Synchro Picker Line

RGZPFM

GA265AP1

MH

GA265AL1 - Ship Notice Header By             Date
GA265AP2 - Ship Notice/Manifest Line      Workfile

GA040E

IA300AP1

AC

IA300AP* - Cost Gen Req
IA310AP

RGZPFM

IA320AP

IR

IA320AP - IA Report Req

RGZPFM

ICMOPURGE

R5 (purge only)

IC100M - MO Header
IC120M - CR Detail
IC125M - LR Detail
IC100A* - Translations
IC130M* - Translations
IC200A* - Translations

IC060E

ICMOREORG

R2 (reorg. only)

IC100M - MO Header
IC120M - CR Detail
IC125M - LR Detail
IC100A* - Translations
IC130M* - Translations
IC200A* - Translations

IC060E

ICSHPURGE

R6 (purge only)

OP100M1-4 - Sales Orders
EC200M - Options
EC200BP - Before Images of Quote             Options
EC200DP - Asynchronous Trans
EC220AP - Detected Errors
EC230AP - Generated Comments
EC240AP - Quote Order Prices
EC300AP - Spy File for Trace

OP020E

ICSHREORG

R3 (reorg. only)

OP100M1-4 - Sales Orders
EC200M - Options
EC200BP - Before Images of Quote             Options
EC200DP - Asynchronous Trans
EC220AP - Detected Errors
EC230AP - Generated Comments
EC240AP - Quote Order Prices
EC300AP - Spy File for Trace

OP020E

ICTHPURGE

R4 (purge only)

IC***BP - IC Trans Hist
JT120BP

IC020E

ICTHREORG

R1 (reorg. only)

IC***BP - IC Trans Hist
JT120BP

IC020E

IC020AL

TH (purge and reorg.)

IC***BP - IC Trans Hist
JT120BP


IC020*             RGZPFM

IC100M

OM (purge and  reorg.)

IC100M - MO Header
IC120M - CR Detail
IC125M - LR Detail
IC100A* - Translations
IC130M* - Translations
IC200A* - Translations

IC060*, RGZPFM

IC110AP1

BB

IC110AP1 - F3 Batch Billing             Transaction

RGZPFM

IC120M

CR

Not Applicable

-----------------------------

IC125M

LR

Not Applicable

-----------------------------

IC130AP

RR

IC130AP - Comp Iss/MO Recpt

RGZPFM

IC130M

ML

Not Applicable

-----------------------------

IC140AP1

BF

IC140AP1 - F3 Batch Forecast             Shipments Transaction

RGZPFM

IC140M

WB

IC130M - Multiple Loc
IC140M - Warehouse Bal

IC070*
CLRPFM       IC070AP
                     RGZPFM

IC150M

LC

IC150M - Lot Control
EC170M - Configuration Assignment

IC050*,  RGZPFM

IC170M

WD

IC170M - Warehouse Desc

RGZPFM

IC175M

IN

IC175M - Physical Inventory Ticket

IC055E

IC310AP

RR

IC130AP - IC Report Req

RGZPFM

JC100M

JM

JC100M - Job Master
JC105M - Job Comments
JA100M - Additional Job Charge
JA105M - Additional Job Charge             Comments
JA110M - Job Material Cost
JA115M - Job Labor Cost

RGZPFM

JT100AP

PW

JT100AP - Prod Sched Workfile

RGZPFM

JT100M

FA

JT100M - Flow Authorization
JT120M, JT100AP1

JT020*
RGZPFM

JT120M

FR

Not Applicable

-----------------------------

JT160M

JP

JT160M - Part/Production Center
            Relationship

RGZPFM

JT180M

CE

JT180M - Production Ctr

RGZPFM

KC100M

K1

KC100M - Pluquo Order Master

KC020E

KC120M

K2

KC120M - KANBAN Label Master

KC120E

LG100M

LD

LG100M - Load Master

LG105E

MA100M

ME

Not Applicable

-----------------------------

MA110M1

OP

Not Applicable

-----------------------------

MA110M2

OD

Not Applicable

-----------------------------

MA120M

MN

Not Applicable

-----------------------------

MA130M

SM

Not Applicable

-----------------------------

MA140M

SD

Not Applicable

-----------------------------

MA150M

UM

Not Applicable

-----------------------------

ME100M

WC

ME100M - Workcenter
CP110M - Effective Capacity
ME105M - Workcenter Rate
ME160M1 - Misc Cost Header
ME160M2 - Misc Cost Detail

ME020*
RGZPFM

ME120M

RT

ME120M - Routing

RGZPFM

ME140M

DV

ME140M - Dept Validation

RGZPFM

MS100M

KF

MS100M - Key Facility

RGZPFM

MS110M

PR

MS110M - Planned Rtg

RGZPFM

MS120M

PP

MS120M - Production Plan

MS040*, RGZPFM

MS150M

DF

MS150M - Projected Demand

MS040*, RGZPFM

MS160M

MS

MS160M - Tentative MS

MS040* RGZPFM

OP100M1

SH (purge and reorg.)

OP100M1-4 - Sales Orders
EC200M - Options
EC200BP - Before Images of Quote             Options
EC200DP - Asynchronous Trans
EC220AP - Detected Errors
EC230AP - Generated Comments
EC240AP - Quote Order Prices
EC300AP - Spy File for Trace

OP020*
RGZPFM

OP100M2

SL

Not Applicable

----------------------------

OP100M3

SC

Not Applicable

----------------------------

OP100M4

ST

Not Applicable

----------------------------

OP100M5

BS

OP100M5 - Blanket Order Schedule

RGZPFM

OP112AP

SK

OP112AP - Serial Number History

OP027E

OP120AP1

WH

OP120AP1-5 - Ship/Bill Workfile

OP127*

OP120M

OH

OP120M - Sales History

OP090*,            RGZPFM

OP140M

PF

OP140M - Contract Price

OP070*

OP145M1

RM

OP145M1 - RMA Header
OP145M2 - RMA Line
CF190M - Comments

OP022E

OP170M1

QH

OP170M* - Quote Orders
EC200BP2 - Quote Option Audit Trail
EC200M2 - Quote Order Options
EC200AP2 - Sales Order Prices

OP080*

OP170M2

QM

Not Applicable

----------------------------

OP170M3

QN

Not Applicable

----------------------------

OP210M

CI

OP210M - Customer/Item

RGZPFM

OP230M1

PL

OP230M1 - Price List Header

OP005E

OP240M1

DC

OP240M1 - Discount Header

OP073E

OP280M1

BM

OP280M1 - Bundle Master
DE100M - Part Master

DE025E

OP290AP1

HR

OP290AP1 - Invoice Request Header
OP290AP2 - Invoice Request Detail

RGZPFM

OP520AP1

EH

OP520AP1 - Outbound EDI SO Ackn             Hdr
OP520AP2 - Outbound EDI SO Ackn             Line
OP540AP1 - Outbound EDI Invoice             Hdr
OP540AP2 - Outbound EDI Invoice             Detail
OP540AP3 - Outbound EDI Invoice             Hdr Comments
OP540AP4 - Outbound EDI Invoice             Line Comments
OP695AP1 - Outbound EDI Shipment             Hdr
OP695AP2 - Outbound EDI Shipment             Line
OP695AP3 - Outbound EDI Shipment             Lot

ED050E

OP540AP1

EI

OP520AP1 - Outbound EDI SO Ackn             Hdr
OP520AP2 - Outbound EDI SO Ackn             Line
OP540AP1 - Outbound EDI Invoice             Hdr
OP540AP2 - Outbound EDI Invoice             Detail
OP540AP3 - Outbound EDI Invoice             Hdr Comments
OP540AP4 - Outbound EDI Invoice             Line Comments
OP695AP1 - Outbound EDI Shipment             Hdr
OP695AP2 - Outbound EDI Shipment             Line
OP695AP3 - Outbound EDI Shipment             Lot

ED050E

OP690AP1

BL

OP690AP1 - Bill of Lading Tran Hdr
OP690AP2 - BOL Line
OP690AP3 - BOL Lot

CF090E

OP695AP1

OS

OP520AP1 - Outbound EDI SO Ackn             Hdr
OP520AP2 - Outbound EDI SO Ackn             Line
OP540AP1 - Outbound EDI Invoice             Hdr
OP540AP2 - Outbound EDI Invoice             Detail
OP540AP3 - Outbound EDI Invoice             Hdr Comments
OP540AP4 - Outbound EDI Invoice             Line Comments
OP695AP1 - Outbound EDI Shipment             Hdr
OP695AP2 - Outbound EDI Shipment             Line
OP695AP3 - Outbound EDI Shipment             Lot

ED050E

POAUTPURGE

P8 (purge only)

PO***BP* - PO Audit Trail

PO020E

POAUTR

PA (purge and reorg.)

PO***BP* - PO Audit Trail

PO020*,
            RGZPFM

POAUTREORG

P5 (reorg. only)

PO***BP* - PO Audit Trail

PO020E

PO140PURGE

R7 (purge only)

PO140M* - Item/Vendor
            Comments

PO020E

PO140REORG

P1 (reorg. only)

PO140M* - Item/Vendor
            Comments

PO020E

PO140M1

IL (purge and reorg.)

PO140M* - Item/Vendor
            Comments

PO020*

PO140M2

IC

Not Applicable

----------------------------

PO150M1

IC

Not Applicable

----------------------------

PO150M2

QL

Not Applicable

----------------------------

PO150M2

QC

Not Applicable

----------------------------

PO160PURGE

R8 (purge only)

PO160M* - Requisition

PO020E

PO160REORG

P2 (reorg. only)

PO160M* - Requisition

PO020E

PO160M1

RL (purge and reorg)

PO160M* - Requisition

PO020*

PO160M2

RC

Not Applicable

----------------------------

PO180PURGE

R9 (purge only)

PO180M1-4 - Purchase Order
            Lines, Comments,
            Releases

PO020E

PO180REORG

P3 (reorg. only)

PO180M1-4 - Purchase Order
            Lines, Comments,
            Releases

PO020E

PO180M1

PO (purge and reorg)

PO180M1-4 - Purchase Order
            Lines, Comments,
            Releases

PO020*
(RGZPFM)

PO180M2

PH

Not Applicable

----------------------------

PO180M3

PD

Not Applicable

----------------------------

PO180M4

PC

Not Applicable

----------------------------

PO210PURGE

P7 (purge only)

PO210M* - Receipts

PO020E

PO210REORG

P4 (reorg. only)

PO210M* - Receipts

PO020E

PO210M1

CH (purge and reorg)

PO210M* - Receipts

PO020*

PO210M2

CL

Not Applicable

----------------------------

PO210M3

CP

Not Applicable

----------------------------

PO210M4

CC

Not Applicable

----------------------------

PO260M

IS

Not Applicable

----------------------------

PO270M

VA

Not Applicable

----------------------------

PO280M

IH

Not Applicable

----------------------------

PO290M

VH

Not Applicable

----------------------------

PO300M

BA

Not Applicable

----------------------------

PO630AP1

HP

PO630AP1 - Outbound EDI PO             Header
PO630AP2 - Outbound EDI PO Line
PO630AP3 - Outbound EDI PO Cmt             Hdr
PO630AP4 - Outbound EDI PO Cmt             Line

ED070E

RP100AP1

RH

RP100AP1 - Planning Action Report             Header

RGZPFM

RP100AP2

RP

RP100AP2 - Planning Action Report             Supply Detail

RGZPFM

RP100AP3

RD

RP100AP3 - Planning Action Report             Demand Detail

RGZPFM

RP100AP4

RJ

RP100AP4 - Planning Action Report             Job Header

RGZPFM

RP100AP5

RY

RP100AP5 - Planning Action Report             Supply Trailer

RGZPFM

RP130AP1

TI

RP130AP1 - Consolidated             Unconsumed Forecast

RGZPFM

RP130AP2

TI

RP130AP2 - Target Inventory

RGZPFM

RP140AP

SW

RP140AP - Simulation Maintenance             Workfile
RP140AP2 - RP Simulated Point             Demand
RP140AP3 - RP Simulated Flow             Supply
RP140AP4 - RP Simulated Flow             Demand

RGZPFM

RP330AP1

DH

RP330AP1 - Part Depletion Report             Request

RGZPFM

RP330AP2

DD

RP330AP2 - Part Depletion Report             Detail

RGZPFM

RS100M

RF

RS100M - RS Delivery Conditions             Master

RGZPFM

RS110M

RA

RS110M - RS Endorsement Master

RGZPFM

RS645AP

DI

RS645AP - RS Ansi Schedule

RS050E

SA100M

SA

Not Applicable

---------------------------------

SA110M

SF

Not Applicable

---------------------------------

SA120M

SS

Not Applicable

---------------------------------

SA310AP

SQ

SA310AP - SA Report Req

RGZPFM

SF020AL

TJ

SF120BP* - SF Trans Hist

SF020*,            RGZPFM

SF310AP

RS

SF310AP - SF Report Req

RGZPFM

TC100M1

TO

TC100M* - Transfer Order

TC020*, RGZPFM

TC100M2

TL

Not Applicable

---------------------------------

TC100M3

TC

Not Applicable

---------------------------------

TC110M1

RQ

TC110M* - Transfer Requisition

TC020*, RGZPFM

TC110M2

RK

Not Applicable

---------------------------------

TC510AP

TA

TC100BP* - Transfer Audit Trails
TC110BP

TC020*, RGZPFM

    Guide to File Reorganization (MPFSMENU Option 3).