MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference and Help > Technical Support > Key Concepts and Procedures > Operation Procedures > Appendix A - File Reorganization

Appendix A - File Reorganization

 

 

The following chart details what processing occurs when each file is selected from the File Support Menu with the reorganize/purge option. 

 

File Number

File Name

Description

APMASTP

Vendor Master

Submits the Vendor Master Purge (CF030E).  Deletes the Vendor Master record (APMASTP) if no records for the vendor are found on the Active Vendor Key File (AP640AL), the Item/Vendor Analysis File (PO270M), the Item/Vendor Statistics File (PO280M), and the Vendor Purchase History File (PO290M).

BCTRN

EDC Transactions

Submits the reorganizations of the following physical file members:

·      IC120DP, Bar Coded Transactions File for SRA and Stock Transfers

·      OP120EP, Shipment Error File

·      PO220DP, Bar Coded Transactions File for Purchase Order Receipts

·      IC130DP, SIR Asynchronous/EDC Transactions

·      IC130DP1, EDC Component Issue Transaction File

·     JT120DP, Flow Receipts Asynchronous Transactions

·     JT140DP, Deduct Point Asynchronous Transactions

·     JT150DP, Bar Coded Transactions File for Lot Issues

·     JT170DP, Bar Coded Transactions File for Unplanned Usage

 

BCTRN

EDC Transactions(cont.)

 

 

 

·     JT200DP1, From-To Hours Labor Transaction File

·     JT200DP2, Number of Hours Labor Transaction File

·     JT210DP1, From-To Hours Machine Transaction File

·     JT210DP2, Number of Hours Machine Transaction File

·     SF127DP, Labor Requirements Update Asynchronous Transaction File.

BD100M

Document Master

Submits the reorganization of the physical file member BD100M, the Document Master File.

BD120M

Document Structure

Submits the reorganization of the physical file member BD120M, the Document Structure File.

CB540AP

CONBON Card Count

Submits the reorganization of the physical file member CB540AP, the CONBON Card Count Workfile.

CF160M

Carrier Master

Submits the Carrier Master Purge (CF165E).  Deletes records that have been flagged for deletion if the deletion date is less than or equal to the horizon date.

CP100AP

Planned Labor Requirements

Submits the reorganization of the physical file memeber CP100AP.

CP310AP

CP Report Request

Submits the reorganization of the physical file member CP310AP, the CP Report Request File.

CT110ML

Data Base Control

Invalid to reorganize.

DE100M

Part Master

Submits Part Master Reorganization (DE020E).  Deletes inactive part (DE100M) if Part Master Quantity Transaction Flag (OLFLG3) is not on, if part has no Warehouse Balance records (IC140M), and if part has no unprocessed Inventory Accounting transactions (IA110AL).  Associated Revision Level records (DE170M), Part Comment records (DE210M), Part Cost records (DE105M), Part/Production Center records (JT160M).  Miscellaneous Cost Header records
(ME160M1), Miscellaneous Cost Detail records (ME160M2), Serial History records (OP112AP), and Part Translation records (CF260ML2) are deleted.

DE120M

Product Structure

Submits reorganization of physical file member DE120M, the Product Structure File.

DE130M

Container Master

Submits the reorganization of the physical file member DE130M, the Container Master File.

DE140M

Loc Validation

Submits reorganization of physical file member DE140M, the Location Validation File.

DE160M

Engineering Change

Submits the reorganization of the physical file member DE160M, the Engineering Changes Master File.

DE170M

Revision Level

Submits the Revision Levels Purge (DE050E).  Deletes the Revision Level (DE170ML2) if the part has no Flow Authorization activity (JT 100ML2), if the effectivity date (RVEFF) is less than the user-entered horizon date, and if the revision level (RVLVL) is not equal to the part master revision level.

DE210M

Part Comments

Submits the reorganization of the physical file member DE210M, the Part Text Master File.

EC100M

Standard Rule

Submits the Rules Reorganization Program (EC020E).  Deletes all deactivated Standard Rules (EC100MLP).

EC110M1

Screen Rule Header

Submits the Rules Reorganization Program (EC020E).  Deletes all deactivated Screen Header Rules (EC111MLP) and the corresponding Screen Detail Rules(EC110M2).

EC110M2

Screen Rule Detail

Invalid to reorganize.

EC120M1

Matrix Header

Submits the Matrix Reorganization Program (EC030E).  Deletes all deactivated Matrix Header records (EC120MLP) and the corresponding Matrix Lines (EC120M2).

EC120M2

Matrix Detail

Invalid to reorganize.

EC140M

Configuration Code Master

Submits the Configuration Code Purge (EC060E).  Deletes configuration codes where:

·     No configuration records exist (EC170M)

·     On-hand quantity for previous period was zero.

·     All manufacturing orders (IC100M), component requirements (IC120M), and sales order lines (OP100M2) for the code are accounting closed.

EC160M

Template Master

Submits the reorganization of the physical file member EC160M.

EC170M

Configuration Assignment

Invalid to reorganize.

ED120AP1

Inbound Receipt Header

Submits the Purchasing File Reorganization Program (PO020E).  This program deletes all closed inbound EDI receipts falling within the horizon date from the following files:
Inbound Receipt Header (ED120AP1)
Inbound Receipt Lines (ED120AP2)
Inbound Receipt Lot (ED120AP3)

The program also prints a report showing the inbound EDI receipts that have been deleted (PO020A).  This report details all the receipt headers, lines, and lot information deleted.

 

Note:

ED120PURGE performs the same processing as ED120AP1, except no reorganization of files occurs. 

ED120REORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

GA100M1

Delivery Point

Submits GA020E to delete all closed (DCSTAT = 'D') delivery points (GA100M1).

GA100M2

Delivery Rules

Submits the reorganization of the physical file member GA100M2.

GA105M

Exception Dates

Submits GA020E to delete all exception date records (GA105M) with an exception date less than the lesser of:

·     The user-defined horizon date

·     The actual date minus the retention period (from Reference File category G19).  A date cannot be deleted if the customer delivery rule has the exception date flag set to yes.

GA115M

EDI Numbers

Invalid to reorganize.

GA120M1

Synchro Blanket Order

Submits GA022E to delete all closed (BOSTAT = 'C') blanket orders (GA120M1) and their associated item/delivery point records (GA120M2), endorsement master records (GA120M3), and endorsement comments (GA120M4).

GA120M2

Part/Delivery Point

Invalid to reorganize.

GA120M3

Endorsements

Submits GA020E to delete endorsements (GA120M3) and their related comments (GA120M4).  An endorsement is deleted if:

·     If it is not active.

·     The number of endorsements kept by the item/delivery point is reached (as specified on Reference File category G19).  Endorsements with validity dates in the future are not counted in the number of endorsements to keep.

·     Validity date and number of months/endorsement (as specified on Reference File category G19) is less than or equal to the minimum horizon date.

GA120M4

Endorsement Comments

Invalid to reorganize.

GA145M1

Delivery Notes-Header

Invalid to reorganize.

GA145M2

Delivery Notes-Line

Invalid to reorganize.

GA145M3

Delivery Notes - Comments

Invalid to reorganize.

GA160M

Labels

Submits the reorganization of the physical file member GA160M.

GA170M

Intermediate Points

Submits the reorganization of the physical file member GA170M.

GA200M

Offset Releases

Submits GA020E to delete any closed offset releases (GA200M).

GA210M1

Delivery Requests-Header

Submits GA024E to delete all split delivery requests (GA210M1 and GA210M2) if they have no associated releases or if the greatest period end date of the release is less than or equal to the user-defined horizon date.  The associated offset releases (GA200M) and request comments (GA210M3) are also deleted.

GA210M2

Delivery Requests -Release

Invalid to reorganize.

GA210M3

Delivery Requests-Comments

Invalid to reorganize.

GA230M1

Synchro Picker-Header

Submits GA026E to delete all picker headers and lines (GA230M1 and GA230M2) that have a forwarding flag of Y and a delivery date less than or equal to the user-entered horizon date.  Shipping list headers (GA145M1), lines (GA145M2), comments (GA145M3), and labels (GA160M) are also deleted.

GA230M2

Synchro Picker -Lines

Invalid to reorganize.

GA265AP1

Ship Notice Workfile

Submits the SYNCHRO Dispatch Notice Workfile Purge Program (GA040E).  This program deletes all closed ship notices falling within the horizon date from the following files:
Ship Notice Header By Date (GA265AL1)
Ship Notice/Manifest Line Workfile (GA265AP2)

IA300AP1

Acctg Cost Gen Request

Submits the reorganization of the physical file members IA300AP1, the Accounting Cost Generation Part Transaction File, IA300AP2, the Accounting Cost Generation Workcenter Transaction File, and IA310AP, the Accounting Cost Generation Request File.

IA320AP

Acctg Cost Gen W/C Tran

Submits the reorganization of the physical file member IA320AP, the Inventory Accounting Report Request File.

IC020AL

IC Trans History

Submits the Inventory Control Transaction History Purge (IC020E).  Deletes IC audit trails (IC020AL) if the following conditions are satisfied:

·     The post date (DATPST) is less than or equal to the user-entered horizon date.

·     If a manufacturing order receipt or component issue and IA is installed, manufacturing order must be purged before the audit trail

·     If the environment is lot controlled, the lot number must be blank or the lot number/part number must not exist on the Lot History File (IC150M).  For flow issues, both the parent part number and the component part number must be validated.

·     If the uninvoiced receipt report (AP760A) is used, it is important to purge PO210M1 and IC020AL through the same horizon date.  Otherwise, unpredictable results will occur on AP760A.

 

Note:

ICTHPURGE performs the same processing as IC020AL, except no reorganization of the purged files occurs.

ICTHREORG submits IC020CLP2.  If 10% of the records on files are purged, then files are reorganized.

IC100M

Manufacturing Order

Submits Manufacturing and Customer Order Delete (IC060E).  All IC Audit Trails (IC495AL) must be printed before this program is submitted.  Deletes closed manufacturing orders (IC100ML4) if last activity date (HDTLA) is less than or equal to the user-entered horizon date.  If IA installed, the manufacturing order must be IA closed (HSTATS = "Z").  The associated component requirements (IC120M) and, if SF installed, the labor requirements (IC125M) are deleted.

 

Note:

ICMOPURGE performs the same processing as IC100M, except no reorganization of the purged files occurs.

ICMOREORG submits IC060CLP2.  If 10% of records on files are purged, then files are reorganized.

IC120M

Component Reqmts

Invalid to reorganize.

IC125M

Labor Requirements

Invalid to reorganize.

IC130AP

Component Issues/MO Receipt Transaction

Submits the reorganization of the physical file member IC130AP.

IC130M

Multiple Location

Invalid to reorganize.

IC140M

Warehouse Balance

Submits Warehouse Balance and Multiple Location Reorganization (IC070E).  Deletes Multiple Location (IC130M) record if its last transaction date (LLDTLT) is less than or equal to the user-entered horizon date and, if cycle counting is used, it shows no activity since the last cycle count (LLASLC = 0).  Deletes inactive (WBACTC = *) Warehouse Balance record (IC140ML3) if the following conditions are satisfied:

·     Last transaction date (WBDTLT) is less than or equal to the user-entered horizon date,

·     All quantity fields equal zero,

·     No Item/Vendor relationships exist (PO140M1)

·     No Multiple Location records exist (IC130M),

·     If IA installed, no unprocessed Inventory Accounting transactions exist (IA110AL)

·     If no availability records exist (IC100ML2).  Associated Warehouse Cost records (IC145M) are deleted.

·     If the cost analysis flag on Reference File category 133 is set to Y (yes), no audit trails can exist on IC280AL for the part.

IC150M

Lot Control

Submits Lot Control Purge (IC050E).  All IC Audit Trails (IC495AL) must be printed before this program is submitted.  Deletes configuration assignment records (EC170M) if all of the related audit trail records have been processed by IA, if the manufacturing order no longer exists, and if the lot close date is less than or equal to the horizon date.  Deletes closed (LCLSTS = 'C') Lot Control records (IC150ML3) if the lot close date (LCCLDT) is less than or equal to the user-entered horizon date and if there are no lot/part records on the Multiple Location File (IC130ML3).  It then deleted records from the Comment Records File (CF190M) for the lot's that have been deleted.

IC170M

Warehouse Desc

Submits reorganization of physical file member IC170M, the Warehouse Description File.

IC310AP

IC Report Request

Submits the reorganization of the physical file member IC310AP, the Inventory Control Transaction File.

JC100M

Job Master

Submits Job Master File Purge (JC050E).  Deletes record where the job status is accounting closed (Z).  Job Master records (JC100M), job comments (JC105M), miscellaneous charges (JA100M), additional job comments (JA105M), planned costs (JA110M), and actual costs (JA115M), are deleted for the job.

JT100AP

Prod Schedule Workfile

Submits the reorganization of the physical file member JT100AP, the Production Schedule Maintenance Workfile.

JT100M

Flow Authorization

Submits the JIT File Purge (JT020E).  Deletes flow authorizations (JT100ML5) if the FA end date (FAEDTE) is less than or equal to the user-entered horizon date.  Associated flow requirements (JT120M) are deleted.

JT120M

Flow Requirements

Invalid to reorganize.

JT160M

Part/Prod Ctr Relationship

Submits the reorganization of physical file member JT160M.

JT180M

Production Center

Submits the reorganization of the physical file member JT180M, the Production Center File.

MA100M

Menu Master

Invalid to reorganize.

MA110M1

Option Master

Invalid to reorganize.

MA110M2

Option Detail

Invalid to reorganize.

MA120M

Menu/Option

Invalid to reorganize.

MA130M

Security Master

Invalid to reorganize.

MA140M

Security Detail

Invalid to reorganize.

MA150M

User/Menu Assignment

Invalid to reorganize.

ME100M

Workcenter

Submits Workcenter Reorganization (ME020E).  Deletes inactive workcenters (MS100M) and their associated effective capacity definitions (CP110M) workcenter rate records (ME105M), miscellaneous cost header records (ME160M1), and miscellaneous cost detail records (ME160M2).

ME120M

Routing

Submits reorganization of physical file member ME120M, the Routing File.

ME140M

Dept Validation

Submits reorganization of physical file member ME140M, the Department Master File.

MS100M

Key Facility

Submits reorganization of physical file member MS100M, the Key Facility File.

MS110M

Planned Routing

Submits reorganization of physical file member MS110M, the Planned Routing File.

MS120M

Production Plan

Submits the Master Scheduling Master File Purge (MS040E).  Deletes Production Plan (MS120ML2) if the start date (PPSTDT) is less than or equal to the user-entered horizon date.

MS150M

Projected Demand

Submits the Master Scheduling Master File Purge (MS040E).  Deletes the projected demand (MS150ML2) if the demand date (FCSTDT) is less than or equal to the user-entered horizon date.

MS160M

Tentative Master Schedule

Submits the Master Scheduling Master File Purge (MS040E).  Deletes the tentative master schedule (MS160ML2) if the due date (MSDUED) is less than or equal to the user-entered horizon date.

OP100M1

Sales Order Hdr

If OP is installed, submits the Sales Order File Reorganization (OP020E).  Deletes closed or canceled sales order header (OP100M1) if the last maintenance date (SHLMDT) is less than or equal to the user-entered horizon date.  The horizon date must be less than the current date.  Associated sales order lines (OP100M2), sales order comments (OP100M3), Sales Order Line/Lot record (OP100M4), sales order shipment schedule (OP100M5), sales order options (EC200M), before-images of quote order options (EC200BP), asynchronous transactions (EC200DP), detected errors (EC220AP), generated comments (EC230AP), quote order prices (EC240AP), and Spy File for Trace Mode records (EC300AP) are deleted.

If OP is not installed, Customer orders (IC180ML1) are deleted if the close date (SHCLDT) and the last shipment date (SHLMDT) are less than or equal to the user-entered horizon date.  Associated Customer Order Detail records (OP100M2) are deleted.

 

Note:

ICSHPURGE performs the same processing as OP100M1, except no file reorganization occurs.

ICSHREORG submits OP020CLP2 and IC060CLP2.  If 10% of records on files are purged, then files are reorganized.

OP100M2

Sales Order Line

Invalid to reorganize.

OP100M3

Sales Order Comments

Invalid to reorganize.

OP100M4

Sales Order Line/Lot

Invalid to reorganize.

OP100M5

Blanket Order Schedule

Submits the reorganization of the physical file member OP100M5.

OP112AP

Serial Number History

Submits the Serial Number History Reorganize Program (OP027E).  This program deletes all the transactions for all serial numbers whose transaction date is less than the horizon date as long as the transaction is not the last transaction processed for the part/serial number combination.

OP120AP1

Ship/Bill Header

Submits Shipping/Billing Workfile Purge (OP127E).  Deletes the Shipping/Billing Header (OP120AL) and its associated lines (OP120AP2), comments, (OP120AP3), line location records (OP120AP4), and VAT detail records (OP120AP5).

OP120M

Sales History

Submits the Sales Order History Purge (OP090E).  Deletes Sales Order History records (OP120ML4) if the ship date (HISHDT) is less than the user-entered horizon date.

OP140M

Contract Price File

Submits the Contract Price File Purge (OP070E).  Deletes contract price (OP140ML2) if the expiration date (PFEXDT) is less than the user-entered horizon date.
 

OP145M1

RMA Header File

Submits the RMA File Reorganization Program (OP022E).  This program deletes records from the following files that have a date less than or equal to the horizon date.
RMA Header Records (OP145M1)
RMA Line Records (OP145M2).  It then deleted records from the Comment Records File (CF190M) for the RMA's that have been deleted.

The program also prints a report showing the RMAs that have been deleted (OP022A) and a report showing a summary of all the RMA headers, Lines, and comments deleted (OP022B).

OP170M1

Quote Order Header

Submits the Quote Order File Reorganization (OP080E).  Deletes closed or canceled Quote Order Header (OP170M1) if the expiration date (SHRVDT) is less than or equal to the user-entered horizon date.  The horizon date must be less than the current date.    Associated quote order lines (OP170M2), quote order comments (OP170M3), Quote Order Option Audit Trail records (EC200BP2), quote order options (EC200M2), and sales order prices (EC240AP2) are also deleted.

OP170M2

Quote Order Line

Invalid to reorganize.

OP170M3

Quote Order Comments

Invalid to reorganize.

OP210M

Cust/Item Relationship

Submits the reorganization of the physical file member OP210M.

OP280M1

Bundle Master File

Submits the Bundle Master Reorganization Program (DE025E).  This program deletes bundles that have been flagged as inactive (available for deletion) and are not on an active sales order line.  It also deletes the corresponding Part Master File (DE100M) record if there are no other bundles of the same name in the same plant.

OP520AP1

Outbound EDI SO Ackn Hdr

Submits the Outbound OP EDI Translation File Purge Program (ED050E).  This program purges all records that have been processed successfully (status = 'P') falling within the horizon date from the following files:
Outbound EDI SO Ackn Hdr (OP520AP1)
Outbound EDI SO Ackn Line (OP520AP2)

A summary report (ED050A) listing the number of records deleted from the files will be printed.

OP540AP1

Outbound EDI Invoice Hdr

Submits the Outbound OP EDI Translation File Purge Program (ED050E).  This program purges all records that have been processed successfully (status = 'P') falling within the horizon date from the following files:
Outbound EDI Invoice Hdr (OP540AP1)
Outbound EDI Invoice Detail (OP540AP2)
Outbound EDI Invoice Hdr Comments             (OP540AP3)
Outbound EDI Invoice Line Comments             (OP540AP4)

A summary report (ED050A) listing the number of records deleted from the files will be printed.

OP690AP1

Bill of Lading Transaction

Submits the Bill of Lading Transaction Purge (CF090E).  Deletes the transaction header (OP690AP1), line (OP690AP2), and lot (OP690AP3) records providing that the bill of lading number is not blank, the record is not waiting to be printed (OP690BP), and the last maintenance date is less than or equal to the horizon date. 

OP695AP1

Outbound EDI Shipment Hdr

Submits the Outbound OP EDI Translation File Purge Program (ED050E).  This program purges all records that have been processed successfully (status = 'P') falling within the horizon date from the following files:
Outbound EDI SO Ackn Hdr (OP520AP1)
Outbound EDI SO Ackn Line (OP520AP2)
Outbound EDI Invoice Hdr (OP540AP1)
Outbound EDI Invoice Detail (OP540AP2)
Outbound EDI Invoice Hdr Comments             (OP540AP3)
Outbound EDI Invoice Line Comments            (OP540AP4))

A summary report (ED050A) listing the number of records deleted from the files will be printed.

PO140M1

Item/Vendor Rel. Header

Submits the File Reorganization Program (PO020E). Associated item/vendor relationship comments (PO140M2) are deleted.  Deletes inactive Item/Vendor Relationship Header records (PO140M1) if the deactivation date (IVCLDT) is less than or equal to the user-entered horizon date. 

 

Note:

PO140PURGE performs same processing as PO140M1, except file reorganization does not occur.

PO140REORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

PO140M2

I/V Rel. Comment

Invalid to reorganize.

PO150M1

Quotation

Invalid to reorganize.

PO150M2

Quotation Comment

Invalid to reorganize.

PO160M1

Requisition

Submits the File Reorganization Program (PO020E).  Deletes Requisitions (PO160M1) with all lines closed or canceled if the close date (RQCLDT) is less than or equal to the user-entered horizon date. 

A requisition cannot be purged if it is found on a purchase order release line.  The purchase order must be purged first. 

Associated requisition comments (PO160M2) are deleted.

 

Note:

PO160PURGE performs same processing as PO160M1, except file reorganization doesn't occur.

POREORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

PO160M2

Requisition Cmt.

Invalid to reorganize.

PO180M1

Purch Order Header

Submits File Reorganization Program (PO020E).  Associated purchase order lines (PO180M2), purchase order releases (PO180M3), and purchase order comments (PO180M4) are deleted.  Deletes closed Purchase Order Header (PO180M1) if the close date is less than or equal to the user-entered horizon date. 

Purchase orders cannot be purged if open receipts exist for the order.  In a job costing environment, P.O.'s cannot be purged if the job has not been final costed.  Phantom P.O.'s cannot be purged if a manufacturing order exists for it.

 

 

Note:

PO180PURGE performs the same processing as PO180M1, except file reorganization doesn't occur.

PO180REORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

PO180M2

Purch Order Line

Invalid to reorganize.

PO180M3

Purch Order Release

Invalid to reorganize.

PO180M4

Purch Order Comments

Invalid to reorganize.

PO210M1

P.O. Receipt Header

Submits the File Reorganization Program (PO020E).  Associated receipt lines (PO210M2), receipt parcels (PO210M3), and receipt comments (PO210M4) are deleted.  Deletes purchase order receipt header (PO210M1) if the following conditions are satisfied:

·     If AP installed, if receipt invoice matched (RLINST = 'Y') and if invoice date (RLINDT) and last maintenance date (RLLMT) are less than or equal to the user-entered horizon date

·     If AP not installed, if last maintenance date (RLLMDT) is less than or equal to the user-entered horizon date and if the quality control status (RLQCST) is either no control ('N') or complete ('C').

·     If the uninvoiced report (AP760A) is used, it is important to purge PO210M1 and IC020AL through the same horizon date.  Otherwise, unpredictable results will occur on AP760A.·        In a job costing environment, receipts cannot be purged if the job has not been final costed.

 

 

Note:

PO210PURGE performs the same processing as PO210M1, except file reorganization does not occur.

PO210REORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

PO210M2

P.O. Receipt Line

Invalid to reorganize.

PO210M3

P.O. Receipt Parcel

Invalid to reorganize.

PO210M4

P.O. Receipt Comment

Invalid to reorganize.

PO260M

Item/Buyer Stat.

Invalid to reorganize.

PO270M

Item/Vendor Analysis

Invalid to reorganize.

PO280M

Item/Vendor Stat.

Invalid to reorganize.

PO290M

Vendor Purch. Hist

Invalid to reorganize.

PO300M

Item/Buyer Analysis

Invalid to reorganize.

PO630AP1

Outbound EDI PO Header

Submits the Outbound PO EDI Translation File Purge Program (ED070E).  This program purges all records that have been processed successfully (status = 'P') falling within the horizon date from the following files:
Outbound EDI PO Header (PO630AP1)
Outbound EDI PO Line (PO630AP2)
Outbound EDI PO Cmt Hdr (PO630AP3)
Outbound EDI PO Cmt Line (PO630AP4)

A summary report (ED070A) listing the number of records deleted from the files will be printed.

POAUTR

P.O. Audit Trails

Submits the File Reorganization Program (PO020E).  Deletes the PO Audit Trail (PO500AL) if the post date (DATPST) is less than or equal to the user-entered horizon date and the audit trail print flag (ATPRNT) is set on.

 

Note:

POAUTPURGE performs the same processing as POAUTR, except file reorganization does not occur.

POAUTREORG submits PO020CLP2.  If 10% of records on files are purged, then files are reorganized.

RP100AP1

Planning Action Report Header

Submits the reorganization of the physical file member RP100AP1.

RP100AP2

Planning Action Report Supply Detail

Submits the reorganization of the physical file member RP100AP2.

RP100AP3

Planning Action Report Demand Detail

Submits the reorganization of the physical file member RP100AP3.

SA100M

Sales Analysis

Invalid to reorganize.

SA110M

Sales Forecast

Invalid to reorganize.

SA120M

Sales Summary

Invalid to reorganize.

SA310AP

SA Report Request

Submits the reorganization of the physical file member SA310AP, the Sales Analysis Report Request File.

SF020AL

Shop Floor Audit Trail

Submits Shop Floor Audit Trail Purge (SF020E).  Deletes previously printed SF audit trails (SF020AL) if the post date (DATPST) is less than or equal to the user-entered horizon date and, if a manufacturing order is on the record, the manufacturing order does not exist.

SF310AP

SF Report Request

Submits the reorganization of the physical file member SF310AP, the Shop Floor Control Report Request File.

TC100M1

Transfer Order Header

Submits the File Reorganization Program (TC020E).  Deletes closed transfer order header (TC100M1) if the closed date (THCLDT) is less than or equal to the user-entered horizon date.  Associated transfer order lines (TC100M2), transfer order comments (TC100M3), and audit trails (TC120BP1, TC120BP2, TC120BP3, TC120BP4) are deleted.  TC100M1, TC100M2, and TC100M3 are reorganized.

TC100M2

Transfer Order Line

Invalid to reorganize.

TC100M3

Transfer Order Comments

Invalid to reorganize.

TC110M1

Transfer Requisitions

Submits the File Reorganization Program (TC020E).  Deletes transfer requisition (TC110M1) if all lines of a transfer requisition are either closed or canceled and the close date (QTCLDT) is less than or equal to the user-entered horizon date.  Associated transfer requisition comments (TC110M2) are deleted.  Also, non-closed transfer requisitions are closed if the covered quantity (QTRCQT) is greater than or equal to the requested quantity (QTRQTY).  TC110M1 and TC110M2 are reorganized.

TC110M2

Transfer Req. Comments

Invalid to reorganize.

TC510AP

TC Report Request

The Expected Receipts Report Request File (TC510AP), the To Picker Print Report Request File (TC510CP), and the To Open Requisitions by Due Date Report Request File (TC510DP) are reorganized.