Sniperdyne Asimilate Macola Ecommerce Logo for Exact Macola Progression and Exact Macola ES

Progression Package Data files

      Following are the files used by Progression. The files are shown by package and in alphabetical order by their 8-byte DOS file name.

      S/M Package Data files

      DOS file Name file Name Description
      COMPfile Company Setup file The Company Setup file is the system file that holds your company default information, company name and address, etc. It also holds the drive letter indicating the location of Macola software files.
      DEFERRPT Defer Report file The Deferred Report file contains entries of all reports which have been deferred and will be printed at another time.
      FIELDFIL Form Field file Form Field file.
      FIELDTBL Used with Forms and SQL Server Used with Forms and SQL Server.
      fileTBL Used with Forms and SQL Server Used with Forms and SQL Server.
      FORMfile Form file The Form file is the system file that holds the report layouts for all reports.
      INDEXTBL Used with Forms and SQL Server Used with Forms and SQL Server.
      JOBfile Job file The Job file contains a record for each activity or project tracked by the package.
      JOBHIST Job History file The Job History file contains a record for each distribution that is posted to a specific job.
      PRINTCOD Print Code file Print Code file.
      PRINTDFT Print Defaults file The Print Defaults file contains the report defaults which can be saved using the Save option on the Print Options window. This information can be used at a later time to "recall" the report parameter which were used.
      REPTPASS Report Passing file The Report Passing file is a system file used for passing information between entry screens and report programs.
      SPOOLCOD Spool Codes file The Spool Codes file contains the network spool codes options which are used to spool a report to a network printer under DOS.
      SPOOLFIL SPOOLFIL Work file SQL Server Work file.
      SYACTADT System Account Audit Trail file The System Account Audit Trail file contains a information regarding any changes which have been made to the System Account file by username, date, and time.
      SYACTFIL System Account file The System Account file contains the chart of accounts for all Progression packages.
      SYCDEFIL System Codes file The System Codes file contains ship via codes, terms codes, buyer/planner codes, etc. for the A/P and A/R packages.
      SYCSHFIL System Cash Account file The System Cash Account file contains all valid Cash Accounts which can be used in Progression.
      SYHSTLIN Tax History Line file The System Tax History Line file contains records of tax transaction history line items.
      SYJNLHST System Journal History file Each time you perform a posting for any package, Progression assigns a journal number to the posting run and keeps the grand totals for that posting run in this file.
      SYPRDFIL System Period file The System Period file contains the full definition of period start and end dates for the current fiscal year. It can be broken down to a maximum of 13 periods.
      SYSCOMP SYSCOMP SYSCOMP
      SYSEQCTL Serialized Docum Control file Sequential Forms Control file.
      SYSEQHST Serial History file Sequential Forms History file.
      SYSEQINV Sequential Invoice file Sequential Invoice file
      SYSMEDIA System Media file System Media file.
      SYSMESSG System Message file The System Message file contains generic exception messages used to identify errors that prevent posting to live Progression files.

      The contents of this file are pre-loaded by Macola. The standard System Manager Message Maintenance application is used to modify these messages.
      SYSNOTES System Notes file The System Notes file contains all notes that are entered using the notes button that is attached to certain fields in the system. The not is referenced by the note name attached to the field on the screenset and the actual contents of the field.
      SYSSRCH System Search file System Search file.
      SYSTATES System States file System States file
      SYSUPDEC SYSUPDEC SYSUPDEC
      SYTAXHST System Tax History file The System Tax History file contains a history record of each tax code used in conjunction with tax schedules.
      SYTAXLIN System Tax Transaction Line file The System Tax Transaction Line file contains records of tax transaction line items.
      SYTAXTRX System Tax Transaction file The System Tax Transaction file contains records of tax transactions.
      SYTRIGGR SYTRIGGR Work file SQL Server Work file.
      TAXDETL Tax Detail file The Tax Detail file contains records of all tax detail codes.
      TAXSCHED Tax Schedule file The Tax Schedule file stores a record of all the tax schedules you use. A combination of tax detail codes makes up a tax schedule. A tax schedule can be for customers, items, or vendors.

      A/D Package Data files

      DOS file Name file Name Description
      FXACCWRK FXACCWRK Work file SQL Server Work file.
      FXACQAST A/D Asset Acquisition file The A/D Asset Acquisition file is only used by the Enter Acquisition Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Master file. Once that posting is done, this file is purged so that it can be used again. Only that acquisition data that is independent of any reporting entity is written to this file; the other acquisition data is written to FXACQENT.
      FXACQENT A/D Asset Acquisition Entity file The A/D Asset Acquisition Entity file is only used by the Enter Acquisition Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Entity file. Once that posting is done, this file is purged so that it can be used again.
      FXAMDWRK FXAMDWRK Work file SQL Server Work file.
      FXASAUTO A/D Asset Number Automatic Master file The A/D Asset Number Automatic Master file ensures that duplicate asset numbers will not be entered into the Acquisition and Separation Transactions files.
      FXASTENT A/D Asset Entity file The A/D Asset Entity file contains permanent asset data that is particular to specific reporting entities. Since information used in depreciation calculations can differ from reporting entity, the data that can differ is kept in this file. This file also contains data on any bonus depreciation taken for a reporting entity and any amounts expensed during the first year of depreciation for a reporting entity.
      FXASTFIL A/D Asset Master file The A/D Asset Master file contains one record for each asset in the database. The Asset Master file holds the permanent data that identifies each asset and summarizes the asset’s acquisition, separation, and disposition history. It also contains investment tax credit information and data on the asset’s life in units and units used. It contains only data that is independent of any reporting entity and so must be used in conjunction with the Asset Entity file in order to get a complete picture of the asset. Posting is done to the Asset Master file to keep it up to date. It is the main source of asset information for many reports.
      FXATRWRK FXATRWRK Work file SQL Server Work file.
      FXCELFIL Ceiling Codes file The Ceiling Codes file contains IRS limitations on the amount of depreciation that can be taken on certain assets.
      FXCNGAST A/D Asset Change History file The A/D Asset Change History file keeps before-change and after-change records. This data is then used in following an audit trail, printing a transfer register, and printing a Change History Report.
      FXCNGENT A/D Asset Entity Change History file The A/D Asset Entity Change History file keeps before-change and after-change entity records. This data is then used in following an audit trail, printing a transfer register, and printing a Change History Report.
      FXCTLFIL A/D Setup file The A/D Setup file maintains information about how the package will operate.
      FXDCGWRK FXDCGWRK Work file SQL Server Work file.
      FXDEPFIL A/D Asset Depreciation Transaction file The A/D Asset Depreciation Transaction file is only used by the Calculate Depreciation application. It serves as a temporary storage place for depreciation calculations before those results are posted to the Asset Master and Entity files. Once that posting is done, this file is purged so that it can be used again and the posted records are then stored in FXDEPHST.
      FXDEPHST Depreciation History file The Depreciation History file contains history of all depreciation calculated by asset. Structure is similar to FXDEPFIL.
      FXDEPJNL FXDEPJNL Work file SQL Server Work file.
      FXDISFIL A/D Distribution to G/L file The A/D Distribution to G/L file contains a record for every distribution posted in the Fixed Assets Module. The General Ledger module uses this file during the Interface From Other Packages application.
      FXDISSEQ Distribution Sequence file The Distribution Sequence file serves as a temporary storage place for distribution information. Used to resequence distribution records prior to posting to G/L.
      FXDSPFIL A/D Asset Disposition file The A/D Asset Disposition file is only used by the Enter Disposition Transactions application. It serves as a temporary storage place for Disposition information before that information is posted to the Asset Master file. Once that posting is done, this file is purged sot that it can be used again.
      FXENTLST Entity List file The Entity List file contains a list of the entities and their descriptions. Created by the A/D Setup application to allow searches on entity number fields.
      FXEXPWRK FXEXPWRK Work file SQL Server Work file.
      FXGLCWRK FXGLCWRK Work file SQL Server Work file.
      FXIRSWRK FXIRSWRK Work file SQL Server Work file.
      FXITCFIL A/D Investment Tax Credit file The A/D Investment Tax Credit file contains reapplied investment tax credit amounts and the dates when they were reapplied.
      FXITCWRK FXITCWRK Work file SQL Server Work file.
      FXMETCOM A/D Method Comparison file (Temporary) The A/D Method Comparison file is used in the Print Depreciation Method Comparison Report. Its purpose is to file records entered during this application so that when the user finishes running the application, the data can be passed to a job stream and used in printing the Depreciation Method Comparison Report. It is purged when the user is finished with the application.
      FXPODWRK FXPODWRK Work file SQL Server Work file.
      FXPRDFIL Period file The Period file contains the calendar information used by the Calculate Depreciation application.
      FXPRDWRK FXPRDWRK Work file SQL Server Work file.
      FXRUNWRK FXRUNWRK Work file SQL Server Work file.
      FXSEPENT A/D Asset Separation Entity file The A/D Asset Separation Entity file is only used by the Enter Separation Transactions application. It serves as a temporary storage place for Separation information before that information is posted to the Asset Entity file. Once that posting is done, this file is purged so that it can be used again.
      FXSEPFIL A/D Asset Separation file The A/D Asset Separation file is only used by the Enter Separation Transactions application. It serves as a temporary storage place for Separation information before that information is posted to the Asset Master file. Once that posting is done, this file is purged so that it can be used again.
      FXTBLFIL A/D Codes file The A/D Codes file contains the codes used in the module such as: division code, location code, category code, and G/L codes.
      FXWRKDEP FXWRKDEP Work file SQL Server Work file.

      A/P Package Data files

      DOS file Name file Name Description
      AP1099 AP1099 file (Not Used) AP1099 file (Not Used).
      APADJTRX A/P Open Item Adjustment Transaction file The A/P Open Item Adjustment Transaction file contains a record for each adjustment entry. Adjustments can be made against open item records that have been posted. The two types of adjustments are: “M” for manual payment, and “T” for change voucher terms.
      APALTADR A/P Alternate Address file The A/P Alternate Address file maintains the Alternate Address file information.
      APBNKFIL AP Bank file AP Bank file.
      APCHKFLD APCHKFLD Form Work file for SQL Server APCHKFLD Form Work file for SQL Server.
      APCHKFRM APCHKFRM Form Work file for SQL Server APCHKFRM Form Work file for SQL Server.
      APCHKRST APCHKRST Form Work file for SQL Server APCHKRST Form Work file for SQL Server.
      APCTLFIL A/P Setup file The A/P Setup file maintains information about how the package will operate.
      APDISFIL A/P Distribution to G/L file The A/P Distribution to G/L file contains a record for every distribution posted in the Accounts Payable package. This is the file that the General Ledger package uses during the Post From Sub Ledger application.
      APDISSEQ A/P Distribution To G/L Sequence Work file The A/P Distribution To G/L Sequence Work file is used for producing the A/P To G/L Distribution Summary Report.
      APDISWRK A/P Distribution To G/L Work file The A/P Distribution To G/L Work file is used to summarize the data so that the A/P to G/L Distribution Report can be printed.
      APFRMFIL A/P Form file A/P Form file.
      APIDFIL A/P Batch ID file The A/P Batch ID file maintains all transaction Batch ID code information.
      APINTFIL A/P Interface file (Not Used) A/P Interface file (Not Used).
      APLBLFLD APLBLFLD Form Work file for SQL Server APLBLFLD Form Work file for SQL Server.
      APLBLFRM APLBLFRM Form Work file for SQL Server APLBLFRM Form Work file for SQL Server.
      APLBLRST APLBLRST Form Work file for SQL Server APLBLRST Form Work file for SQL Server.
      APOPNFIL A/P Open Item file The A/P Open Item file contains a record for every transaction posted. The file contains vouchers, checks, debit, and credit memos. Transactions remain in this file until they are purged by the user.
      APOPNHST A/P Open Item History file The A/P Open Item History file contains records posted to the A/P Open Item file.
      APRCVWRK APRCVWRK Work file SQL Server Work file.
      APRECDST A/P Recurring Voucher Distribution file The A/P Recurring Voucher Distribution file contains a distribution record that pertains to a recurring voucher record. Each distribution allows an amount to be distributed to a specific account number when the transaction is posted.
      APRECVCH A/P Recurring Voucher Transaction file The A/P Recurring Voucher Transaction file contains a record for each recurring voucher entered. The two types of intervals that may occur are: M for monthly payment, and N for number of days between payments. Recurring vouchers are entered to handle amounts that are due every month or a certain amount of days.
      APTRXDST New A/P Transaction Distribution file The New A/P Transaction Distribution file contains a record for each distribution record that pertains to specific transactions. Each distribution record allows amounts to be distributed to specific accounts and jobs.
      APTRXFIL New A/P Transaction file The New A/P Transaction file contains a record for every record entered through new A/P transaction processing. The valid types of vouchers are: V for a regular voucher, C for a vendor credit memo voucher, P for a prepaid voucher, X for a cancellation voucher, and A for an adjustment voucher. These transactions are posted to the A/P Open Item file and to the A/P Distribution to G/L file.
      APVENADT A/P Vendor Audit file If the Keep Vendor file Audit Trail? check box in the A/P Setup file is activated, then a record will be written for every add, change, or deletion made to the Vendor file. The A/P Vendor Audit file can be purged by the user.
      APVENDST A/P Vendor Auto Distribution file If the question Automatic Distribution? is answered Yes, then distribution records may be entered to distribute specific percentages to account numbers for that vendor in the A/P Vendor Auto Distribution file.
      APVENFIL A/P Vendor file The A/P Vendor file contains a record for every vendor used in the Accounts Payable package. This is the master file for the vendor and contains the name, address, city, state, zip, and year-to-date totals.
      APVENTYP A/P Vendor Type file The A/P Vendor Type file contains a record for each vendor type.
      APWRK1FL APWRK1FL Work file SQL Server Work file.
      APWRK2FL APWRK2FL Work file SQL Server Work file.
      APWRK3FL APWRK3FL Work file SQL Server Work file.
      APX99FLD APX99FLD Form Work file for SQL Server APX99FLD Form Work file for SQL Server.
      APX99FRM APX99FRM Form Work file for SQL Server APX99FRM Form Work file for SQL Server.
      APX99RST APX99RST Form Work file for SQL Server APX99RST Form Work file for SQL Server.
      CHECKREC A/P Check Reconciliation file If the question in the A/P Setup file Reconcile Checks? is answered Yes, then a record is written to the A/P Check Reconciliation file for each check that is posted. This file can then be updated or purged through the Check Reconciliation application.

      A/R Package Data files

      DOS file Name file Name Description
      ARALTADR Alternate Address file The Alternate Address file contains the alternate addresses for companies if the billing or shipping address differs from the company address.
      ARBATFIL A/R Batch file The A/R Batch file contains all the transaction Batch IDs as well as the user name
      ARCARCDE A/R Carrier Code file A/R Carrier Code file.
      ARCOMDUE Commissions Due file The Commissions Due file contains all commission amounts due to a Salesperson related posted sales transactions.
      ARCOMWRK ARCOMWRK Work file SQL Server Work file.
      ARCSHAPL Cash Application file The Cash Application file contains a record for each check entered for each customer.
      ARCSHTRX Cash Transaction file The Cash Transaction file contains a record for each check entered for each customer.
      ARCTLFIL A/R Setup file The A/R Setup file maintains information about how the package will operate. Contains aging periods, defaults and default account numbers for posting purposes.
      ARCUSADT Customer Audit file The Customer Audit file contains all the additions, changes and deletions made to the Customer file.
      ARCUSFIL Customer file The Customer file contains a record for each Customer. Maintains detailed information about the Customer such as period-to-date and year-to-date sales and costs, as well as maintaining credit history.
      ARCUSWK1 ARCUSWK1 Work file SQL Server Work file.
      ARCUSWK2 ARCUSWK2 Work file SQL Server Work file.
      ARCUSWK3 ARCUSWK3 Work file SQL Server Work file.
      ARCUSWK4 ARCUSWK4 Work file SQL Server Work file.
      ARCUSWK5 ARCUSWK5 Work file SQL Server Work file.
      ARDISFIL Distribution To G/L file The Distribution To G/L file contains a record for every distribution to an account made during any of the posting applications.
      ARDISSEQ A/R Distribution to G/L Sequence Work file The A/R Distribution To G/L Sequence Work file is used for producing the A/R Distribution To G/L Summary Report.
      ARDISWRK A/R Distribution Work file The A/R Distribution To G/L Work file is used to summarize the data so that the Distribution to G/L Report can be printed.
      ARDUNFLD ARDUNFLD Form Work file for SQL Server ARDUNFLD Form Work file for SQL Server.
      ARDUNFRM ARDUNFRM Form Work file for SQL Server ARDUNFRM Form Work file for SQL Server.
      ARDUNRST ARDUNRST Form Work file for SQL Server ARDUNRST Form Work file for SQL Server.
      ARFCHTRX Finance Charge Trx file The Finance Charge Trx file contains a record showing the finance charge calculated for each customer against his current open balance.
      ARINVFLD ARINVFLD Form Work file for SQL Server ARINVFLD Form Work file for SQL Server.
      ARINVFRM ARINVFRM Form Work file for SQL Server ARINVFRM Form Work file for SQL Server.
      ARINVRST ARINVRST Form Work file for SQL Server ARINVRST Form Work file for SQL Server.
      ARLBLFLD ARLBLFLD Form Work file for SQL Server ARLBLFLD Form Work file for SQL Server.
      ARLBLFRM ARLBLFRM Form Work file for SQL Server ARLBLFRM Form Work file for SQL Server.
      ARLBLRST ARLBLRST Form Work file for SQL Server ARLBLRST Form Work file for SQL Server.
      AROPNFIL A/R Open Item file The A/R Open Item file contains a record for each transaction posted to a customer’s account. invoices, checks, credit memos, debit memos, and finance will be part of this file.
      AROPNHST Open Item History file The Open Item History file contains records posted to the A/R Open Item file.
      ARPMTWRK ARPMTWRK Work file SQL Server Work file.
      ARRECDST Recurring Distribution file The Recurring Distribution file contains a record for each distribution made to an account associated with a recurring invoice that is entered.
      ARRECINV Recurring Invoice file The Recurring Invoice file contains a record for each recurring invoice entered through Recurring Invoice Processing.
      ARSAWORK Sales Analysis Work file The Sales Analysis Work file is used for the printing Sales Analysis reports by sales analysis by customer type, by sales volume, by state and by territory. This file allows the reports to be printed in an order different than the usual order for the Customer file.
      ARSELCUS Selected Customer file The Selected Customer file is used during the printing of the Open Invoice Worksheet. It details, for each Customer, what open items on file that are yet unpaid, what the current balance owed is on those items, and the amount of any valid discount.
      ARSHOFIL A/R Shipping Order file A/R Shipping Order file.
      ARSHTFIL A/R Shipping Transaction file A/R Shipping Transaction file.
      ARSLMFIL Salesperson file The Salesperson file contains a record for each salesperson used by the package. Maintains commission percentages for each salesperson by customer type and maintains sales and commission totals period-to-date and year-to-date.
      ARSLSDST Sales Distribution file The Sales Distribution file contains a record for each distribution to a specific General Ledger account associated with a sales transaction record.
      ARSLSTRX Sales Transaction file The Sales Transaction file contains a record for each invoice, CR/DR memo or finance charge entered through Enter Sales Transactions.
      ARSRVFIL Service Codes file The Service Codes file contains services a company provides which can be entered as transactions in Enter Service Invoices. The Service Codes file contains YTD and PTD sales and cost figures posted to that service.
      ARSRVHST Service Transaction History file The Service Transaction History file contains invoiced transactions posted entered through Posting Service Invoices.
      ARSRVTRX Service Transaction file The Service Transaction file contains service invoices or recurring invoice transactions entered through Enter Service Invoices.
      ARSTMFLD ARSTMFLD Form Work file for SQL Server ARSTMFLD Form Work file for SQL Server.
      ARSTMFRM ARSTMFRM Form Work file for SQL Server ARSTMFRM Form Work file for SQL Server.
      ARSTMRST ARSTMRST Form Work file for SQL Server ARSTMRST Form Work file for SQL Server.
      ARTYPFIL Customer Type file The Customer Type file contains default account numbers for posting. Progression looks here for defaults and if not found uses the A/R Setup file.
      ARWRK1FL ARWRK1FL Work file SQL Server Work file.
      ARWRK2FL ARWRK2FL Work file SQL Server Work file.
      ARWRK3FL ARWRK3FL Work file SQL Server Work file.
      ARWRK4FL ARWRK4FL Work file SQL Server Work file.

      B/B Package Data files

      DOS file Name file Name Description
      BBADJWRK BBADJWRK Work file SQL Server Work file.
      BBCTLFIL B/B Setup file The Setup file maintains information about how the system operates, also contains default values for posting purposes.
      BBDEPFIL B/B Deposit file The Deposit file contains a record for each document contained in the deposit.
      BBDEPHDR B/B Deposit Header file The Deposit Header file contains a record for each deposit to the cash account.
      BBDEPWRK BBDEPWRK Work file SQL Server Work file.
      BBDISFIL B/B Distribution to G/L file The Distribution to G/L file contains a record for every distribution to an account made during any of the posting applications.
      BBDISSEQ Distribution Work file The Distribution Work file is a temporary file used by the Distribution to G/L Report when the option to purge the distribution file is selected.
      BBEXPCSH Expected Cash Flow Report Work file The Expected Cash Flow Report Work file summarizes data for the Expected Cash Flow Report.
      BBIDFIL B/B Batch ID file The Bank Book Batch ID file contains a record for each batch ID code.
      BBOPNFIL B/B Open Item file The Open Item file contains a record of each transaction to be reconciled. Reconciled records are identified by a flag and a reconciliation date.
      BBOPNIDX BBOPNIDX Work file SQL Server Work file.
      BBRECWRK BBRECWRK Work file SQL Server Work file.
      BBSTMFIL Bank Book Statement Balances The Bank Book Statement Balances file contains records for the cash account, statement date, and statement balances.
      BBTRXFIL B/B Transaction file The Transaction file stores transaction data from transaction entry.
      BBTYPFIL B/B Trx Type file The Trx Type file contains a record for each transaction type.
      BBWK1FIL BBWK1FIL Work file SQL Server Work file.
      BBWK2FIL BBWK2FIL Work file SQL Server Work file.
      BBWK3FIL BBWK3FIL Work file SQL Server Work file.
      BBWK4FIL BBWK4FIL Work file SQL Server Work file.

      B/C Package Data files

      DOS file Name file Name Description
      BCCTLFIL Bar Code Setup file Bar Code Setup file.
      BCIMPDTL Transaction Import Detail file Contains Bin and Serial Lot transaction detail from the ASCII Import file.
      BCIMPHDR Transaction Import Header file Transaction header file created from ASCII Import file.

      This file contains information relating to I/M Inventory, O/E Ship, and P/O Receipt transactions.
      BCIMPSFC B/C Shop Floor Activity Transaction file B/C Shop Floor Activity Transaction file.
      BCLSWKFL B/C Tag Serial Lot Numbers Work file B/C Tag Serial Lot Numbers Work file.
      BCPEXDTL Transaction Exception Detail file Contains Bin and Serial Lot transaction detail relating to exception transactions.
      BCPEXHDR Transaction Exception Header file This file contains I/M Inventory, O/E Ship, and P/O Receipt transactions that could not be posted due to exceptions.
      BCPEXREL Transaction Exception Relational file Contains exception codes (message numbers) used to identify the error that will prevent transaction posting to live Macola files. Records in this file can be related to Transaction Exception Header or Detail file records for each type of transaction processing. In this way you can have an unlimited number of exceptions per transaction (relational file).
      BCPEXSFC B/C Shop Floor Activity Transactions Exception file B/C Shop Floor Activity Transactions Exception file.
      PCSFASCI B/C ASCII Import file B/C ASCII Import file.
      BCSFASCM B/C Detail For Bin/Serial/Lot Information file B/C Detail For Bin/Serial/Lot Information file.
      BCTAGFIL Bar Code Import Tag file Contains imported inventory tag records.
      BCTAGPEX Bar Code Import Tag Exception file Stores imported inventory tag records that contain missing or invalid data.
      BCTAGREL Bar Code Import Tag Exceptional Relational file Contains exception codes (message numbers) used to identify errors that have prevented imported Tag records from updating Tag records in the I/M Tag file.

      BOM Package Data files

      DOS file Name file Name Description
      BMCTLFIL BOM Control (Setup) file The BOM Control file contains one record which is the master control record for the bill of material. The default values are Audit Trail Flag which will determine whether an audit trail will be kept for all maintenance of the Product Structure file, and the description for the Product Structure file.
      BMENGCHG Engineering Change file Engineering changes for each engineering change number, parent item number and sequence number combination are maintained in the Engineering Change file until they are posted to the product structure. All information on the Engineering Processing add, change, and delete screen is stored in this file including reference designators.
      BMENGHST Engineering Change History file The Engineering Change History file contains the same information as the engineering change file after engineering change posting occurs. The only addition to the information is the posting date and the resulting posting status of each record.
      BMEXCWRK Exclusions/Dependencies Work file This is a work file that holds the selected options when a feature option is being entered. Mainly used for inquiry.
      BMEXPLWK Parent Item Exploded Work file This is a work file used to explode a parent item for reporting purposes.
      BMFTRFIL Product Feature file The Product Feature file contains the information which identifies all of the features of a feature type item. Only the first four fields entered on the Feature/Option Configuration Maintenance such as feature descriptions and feature required check boxes.
      BMMASRPL Mass Replace Work file The Mass Replace Work file is used in the mass mode of the Product Structure file Maintenance to temporarily hold the replaced records until they can be read again and added to the Product Structure file.
      BMOPTEXC Option Dependencies/Exclusions file This file contains the dependencies and exclusions for an individual option in relationship to the other options.
      BMOPTFIL Product Option file The Product Option file contains the information for all options available for the features of feature type items. It’s contents consist of the feature item number, feature number, option number, and the option item number.
      BMPRDAUD Product Structure Audit file The Product Structure Audit file is the Audit Trail file maintained to keep track of changes to the Product Structure file Maintenance.
      BMPRDCPY Product Structure Copy Work file The Product Structure Copy Work file is used in the copy mode of the Product Structure file Maintenance to temporarily hold the value of the records being copied until they can be read again and added to the Product Structure file.
      BMPRDRSQ Resequence Work file The Resequence Work file is utilized by the Resequence Component Items application. It temporarily holds information pertaining to the parent/component relationships including both old and new sequence number during the execution of this procedure.
      BMPRDSTR Product Structure file The Product Structure file is a major file of the Bill of Material package. It is sued to define the structure of an inventory item which is assembled from other inventory items. Each record in the Product Structure file defines the relationship between a parent and one of its components.

      C/M Package Data files

      DOS file Name file Name Description
      CMAPHST C/M AP History file (Not Used) C/M AP History file (Not Used).
      CMCTLFIL C/M Setup file The C/M Setup file maintains information about how the package operates, contains default dates, default account numbers, and other default information.
      CMCURCOD C/M Currency Code file The C/M Currency Code file contains all currency codes used by the package.
      CMCURRAT C/M Currency Rate file The C/M Currency Rate file contains all currency rates used by the package.
      CMEXPFIL C/M Currency Exception file The C/M Currency Exception file contains data records on all exception transactions in C/M.
      CMPRCCST C/M Item Cost/Price file The C/M Item Cost/Price file contains all item cost/price entries used by the package.
      CMUNRFIL Currency Manager Unrealized Gain Loss Work file Currency Manager Unrealized Gain Loss Work file.

      CRP Package Data files

      DOS file Name file Name Description
      CRCTLFIL CRP Control file CRP Control file
      CRDTLBL0 CRP Order Detail file 0 CRP Order Detail file 0
      CRDTLBL1 CRP Order Detail file 1 CRP Order Detail file 1
      CRDTLBL2 CRP Order Detail file 2 CRP Order Detail file 2
      CRDTLBL3 CRP Order Detail file 3 CRP Order Detail file 3
      CRDTLBLD CRP Order Detail file CRP Order Detail file
      CRLCKFIL CRP Lock Work file CRP Lock Work file
      CRLOCFIL CRP Location file CRP Location file
      CRORDBL0 CRP Order Build file 0 CRP Order Build file 0
      CRORDBL1 CRP Order Build file 1 CRP Order Build file 1
      CRORDBL2 CRP Order Build file 2 CRP Order Build file 2
      CRORDBL3 CRP Order Build file 3 CRP Order Build file 3
      CRORDBLD CRP Order Build file CRP Order Build file
      CRSCHBLD CRP Schedule Build Work file CRP Schedule Build Work file
      CRTRXBL0 CRP Transaction Build file 0 CRP Transaction Build file 0
      CRTRXBL1 CRP Transaction Build file 1 CRP Transaction Build file 1
      CRTRXBL2 CRP Transaction Build file 2 CRP Transaction Build file 2
      CRTRXBL3 CRP Transaction Build file 3 CRP Transaction Build file 3
      CRTRXBLD CRP Transaction Build file CRP Transaction Build file
      CRTRXHST CRP Transaction History file CRP Transaction History file


      EDI Package Data files

      DOS file Name file Name Description
      ED-FMTCD ED-FMTCD ED-FMTCD
      ED-FMTCE ED-FMTCE ED-FMTCE
      ED-FMTCF ED-FMTCF ED-FMTCF
      ED-FMTCH ED-FMTCH ED-FMTCH
      ED-FMTCM ED-FMTCM ED-FMTCM
      ED-FMTDE ED-FMTDE ED-FMTDE
      ED-FMTDF ED-FMTDF ED-FMTDF
      ED-FMTE2 ED-FMTE2 ED-FMTE2
      ED-FMTED ED-FMTED ED-FMTED
      ED-FMTEF ED-FMTEF ED-FMTEF
      ED-FMTEM ED-FMTEM ED-FMTEM
      ED-FMTFD ED-FMTFD ED-FMTFD
      ED-FMTFX ED-FMTFX ED-FMTFX
      ED-FMTLT ED-FMTLT ED-FMTLT
      ED-FMTSI ED-FMTSI ED-FMTSI
      ED-FMTSN ED-FMTSN ED-FMTSN
      ED-FMTXA ED-FMTXA ED-FMTXA
      ED-FMTXX ED-FMTXX ED-FMTXX
      EDABLKFL ASN Bulk Weight file ASN Bulk Weight file.
      EDACUMFL ASN YTD Accumulator file ASN YTD Accumulator file.
      EDAPKGFL ASN Package Code file ASN Package Code file.
      EDATMP02 EDATMP02 EDATMP02
      EDATMPFL EDATMPFL EDATMPFL
      EDATPQFL ASN Tare/Pack Quantity file ASN Tare/Pack Quantity file.
      EDATPSFL ASN Tare/Pack Structure file ASN Tare/Pack Structure file.
      EDBBCIFL ASN Barcode Interface file ASN Barcode Interface file.
      EDCAUDFL EDI Audit Report file The EDI Audit Report file contains a record of all of your EDI transmissions.
      EDCCAPFL EDI Capture file The EDI Capture file contains historical data concerning EDI invoices that you created.
      EDCCHGFL EDI Miscellaneous Charges Code Cross Reference file The EDI Miscellaneous Charges Code Cross Reference file contains cross reference records of EDI items and items stored in your Inventory Management file.
      EDCCTLFL EDI Control (Setup) file The EDI Control file maintains information about how EDI operates, and it also contains default values for posting purposes.
      EDCITMFIL EDI Item Cross Reference file The EDI Item Cross Reference file contains cross reference records of EDI items and items stored in your Inventory Management file.
      EDCLOGFL EDI Log file The EDI Log file contains, for both inbound and outbound transactions, the following: date, time, totals, line items, and order information.
      EDCSDQFL EDI Ship Destination Quantity The EDI Audit Log file contains inbound information for items ordered for each store.
      EDCSHTFL EDI Ship To Cross Reference file The EDI Ship To Cross Reference file contains cross reference records of EDI items and items stored in your Inventory Management file.
      EDCSHVFL EDI Ship Via Cross Reference file The EDI Ship Via Cross Reference file contains cross reference records of EDI items and items stored in your Inventory Management file.
      EDCTP-FL EDI Trading Partner (Customer) Cross Reference file The EDI Trading Partner Cross Reference file contains cross reference records of EDI items and items stored in your Inventory Management file.
      EDI-DDFL EDI-DDFL EDI-DDFL
      EDI-VDFL EDI-VDFL EDI-VDFL
      ED_CVTFL ED_CVTFL ED_CVTFL

      G/L Package Data files

      DOS file Name file Name Description
      GLACTIDS G/L ID Codes file The G/L ID Codes file contains codes to identify G/L accounts.
      GLACTWRK GLACTWRK Work file SQL Server Work file.
      GLBALFIL G/L Period Balance file The G/L Period Balance file contains account balances bucketed by period. This file is updated during each G/L transaction post procedure. The G/L Period Balance file provides the data to produce the trial balance and financial statements.
      GLBUDFIL G/L Budget file The G/L Budget file contains monthly budget amounts for multiple years and up to 99 revisions.
      GLCMPFIL G/L Comparative file The G/L Comparative file contains monthly comparative account amounts for any given year. Comparative amounts are updated at year end.
      GLCMPRSF G/L Compression Work file The G/L Compression Work file is used only by the Compress General Ledger Transaction file application.
      GLCTLFIL G/L Setup file The G/L Setup file maintains information about how the package will operate.
      GLDISASC G/L ASCII Interface file The G/L ASCII Interface file can be created to post to the General Ledger Transaction file.
      GLDISTCD G/L Distribution Code file The G/L Distribution Code file contains the automatic distribution codes that you associate with your G/L accounts. Up to 999 distributions may be specified for any one distribution code.
      GLENTITY Financial Entity file The Financial Entity file contains a record for each financial entity currently in use. A financial entity is defined as a collection of profit centers. Each entity is defined by up to 36 different ranges (or individual) profit centers.
      GLEXCEPT G/L Exception Work file The G/L Exception Work file is a temporary file used to print the Exception Report.
      GLFSPASS G/L Financial Statement Passing file The G/L Financial Statement Passing file is used to pass the essential data needed to print financial statements. This data is not layout, specification, or amount specific, it contains data for all layouts, specifications, and accounts.
      GLGENTRX General Journal Transaction file The General Journal Transaction file contains journal entries made through General Journal Trx Processing. These entries are posted to the General Ledger Transaction file.
      GLIDFIL G/L Batch ID file The G/L Batch ID file contains a record of Batch ID’s in G/L Journal Transaction Processing.
      GLINFTAB G/L Inflation Table file G/L Inflation Table file
      GLINTFIL G/L Interface file The G/L Interface file is used to summarize information in the sub-ledger post to the G/L Transaction file.
      GLJNLHST General Journal History file General Journal History file. Any posting procedures performed from A/R, A/P, PR, MCA, I/M, O/E, B/B or A/D which post transactions to the Distribution to G/L file(s), their records are created in the General Journal History file.
      GLJNLTMP G/L Temporary Journal file he G/L Temporary Journal file is a temporary work file used in all postings to the G/L Transaction file.
      GLLAYOUT Layout file The Layout file contains the layouts which define the formats of all the financial statements: balance sheets, profit and loss statements, supporting schedules and SAF’s (source and application of funds). It contains several types of records. The first is always the header record, defining what type of statement the layout is for.

      The detail records define, line by line, how the given financial statement will be printed.
      GLRECBAL Recurring Running Balance file The Recurring Running Balance file contains two pieces of information: the balance of the transaction amounts for all the records currently in the Recurring Journal Transaction file (this amount must be zero for the transactions to post), and the last date that recurring records were posted to the General Ledger Transaction file.
      GLRECTRX Recurring Journal Transaction file The Recurring Journal Transaction file contains records for each recurring journal transaction entered through Recurring Journal Trx Processing. When these transactions are posted, one record is created in the General Ledger Transaction file for every record in this file with a non-zero amount. There are two types of recurring journal transactions: variable and permanent. An example of a permanent transaction would be rent, the amount of which does not change from period to period. An example of a variable transaction might be electric utility expense, which occurs every period, but with a varying amount.
      GLSPECS Statement Specifications file The Statement Specifications file contains records associated with how you have defined the financial statements to print, in accordance with the layouts contained in the Layout file. This file is only used by the Select and Print Financial Statements menu application. It allows one layout to be printed several different ways; (by profit center, by financial entity, show current period, show YTD figures, show variance, show ratios, show budgets or comparatives, print “$”, and print next run).
      GLSRCFIL G/L Source Reference file The G/L Source Reference file contains source notes that can be attached to a transaction at G/L transaction entry time.
      GLTRXFIL G/L Transaction file The G/L Transaction file contains a record for every journal posted. This is the main transaction file for G/L. The trial balance and financial reports are generated from this file, the account file, the balance file, and the comparative file.
      GLTRXHST G/L History Trx file Every update to the GLTRXFIL will also update the G/L History Trx file. Used for drill down capabilities.
      GLTXTFIL G/L Text file Each text record can have up to 30 lines of 75 characters, which may be printed on a financial statement. These text records are only used in the print of financial statements, and are referenced by the TEXT layout code in the Layout file.
      GLXREFIL G/L Cross Reference file The G/L Cross Reference file contains information used for the Source Cross Reference Report.
      SFLAYOUT Source and Allocation of Funds Layout file The Source and Allocation of Funds Layout file is a work file that is used solely by the generate SAF Layout function of the Financial Statement Layout Maintenance application. It is used by the SAFGEN program. It contains records originating from one selected balance sheet layout on the Layout file. Its records have the same format as those on the Layout file.
      STMNTWRK G/L Statement Work file The G/L Statement Work file is used only for the printing of financial statements. Balances are calculated for all accounts and stored in this file.

      Manufacturing System files

      DOS file Name file Name Description
      HZBA1999 Buyer/Planner/Item file Manufacturing Buyer Analyst Work file (Not used).
      HZCDEFIL Manufacturing Codes file This file contains valid codes for the various manufacturing packages. It includes definitions for the following codes: labor grade, department, labor cost type, indirect labor, earnings codes, incentive pay codes, job type, gtc code, equipment type, failure code, maintenance type, request code, repair code, task code, operation status.
      HZCRWFIL Manufacturing Crew file Manufacturing Crew file.
      HZCTLFIL Manufacturing Setup file The Manufacturing Setup file contains global information and defaults that determine how the Progression manufacturing packages operate.
      HZCTRACT Work Center Account file Manufacturing Work Center Account file.
      HZCTRCAP Manufacturing Work Center Capacity file The Manufacturing Work Center Capacity file provides detailed daily capacity measures for your work centers, including machine hour and labor hour capacity measures. The file maintains a one-to-one correspondence with records in the Shop Calendar Detail file.
      HZCTRFIL Manufacturing Work Center file This file holds information about work centers, production lines and work cells used in a manufacturing environment.
      HZCTRMCH Work Center Machine file Manufacturing Work Center Machine file.
      HZEMPAUD Mfg Employee Audit file Manufacturing Employee Audit file.
      HZEMPPER Mfg Employee file Manufacturing Employee file.
      HZEQPFIL Equipment file Manufacturing Equipment file.
      HZMCOFIL MRP-CRP Orders file This file holds various kinds of orders that are used by MRP and CRP. This file also tracks firm planned orders. This data is entered via the Order file Maintenance application in the MRP package or copied in from shop orders, customer orders, or from the Master Schedule.

      Five possible values for the GEN-file field are available, depending on the MRP mode in use:

      0 = Current Material Plan

      (including effects of net change run since last full regeneration)

      1 = What If 1 file

      2 = What If 2 file

      3 = What If 3 file

      4 = Results of Last Full Regeneration.

      HZERNFIL HZ Earnings file HZ Earnings file.
      HZMCOFIL MRP-CRP Orders file This file holds various kinds of orders that are used by MRP and CRP. This file also tracks firm planned orders. This data is entered via the Order file Maintenance application in the MRP package or copied in from the regen.
      HZNOTFIL Manufacturing Notes file The notes that are created and attached to routing records will be stored in this file. The note record of the routing will no longer exist.
      HZNOTHST Manufacturing Notes History file Manufacturing Note History file.
      HZOCFIL Manufacturing Operation Code file Manufacturing Operation Code file.
      HZPLPFIL Manufacturing Product Load Profile file This file is a master file containing all pertinent information by Item for each Work Center it can run on. This information is used by Master Scheduling, Shop Floor Control, and Repetitive Manufacturing modules.
      HZPPVFIL Purchase Price Variance file Manufacturing PPV file.
      HZPRELOD HZ Preload file HZ Preload file.
      HZRPTCAL Report Calendar Header file This file holds the data that defines the period ending dates for the reporting periods (buckets) of various reporting calendars.
      HZSHPCAL Shop Calendar Header file This file holds the data that defines shop open/closed days.
      HZSHPDTL Shop Calendar Detail file The Shop Calendar Detail file is a relational representation of the 366 buckets found in the Shop Calendar Header record. Additional information is also stored, including date, text of day (Mon-Sun), and total hours.

      I/M Package Data files

      DOS file Name file Name Description
      IM2801ST IM2801ST Work file SQL Server Work file.
      IMALLRST IMALLRST Work file SQL Server Work file.
      IMATPFIL ATP Summary file ATP Summary file.
      IMATPORD ATP Orders file ATP Orders file.
      IMBATFIL I/M Batch file The I/M Batch file contains all the transaction batch IDs as well as the user name.
      IMBINTRX I/M Bin Transaction file The I/M Bin Transaction file contains a record for each transaction entered through Inventory Transaction Processing with a bin number assigned to it. The file contains the history for all allocations, receipts, transfers, and issue records related to bins.
      IMCATFIL I/M Product Category file The I/M Item Product Category file contains a record for each product category and its description. Categories are an easy way of grouping items that have similar characteristics, or are part of the same product line for selling purposes. Many reports within I/M allow the user to choose which category they want to print.
      IMCNTDTE I/M Physical/Cycle Count Date file The I/M Physical/Cycle Count Date file contains a record for each date that either a physical or cycle count was performed.
      IMCTLFIL I/M Inventory Setup file The I/M Inventory Setup file maintains information about how the package will operate. This file contains all the defaults for the I/M system including cost method, warehouse, inventory asset account, and allows the user to choose either serial/lot or bin processing.
      IMDISFIL I/M Distribution To G/L file The I/M Distribution to G/L file contains a record for every distribution posted in the Inventory Management package. This is the file that the General Ledger package uses during the Post From Sub Ledger application.
      IMINVAUD I/M Item Location Audit file The I/M Item Location Audit file contains a record for every addition, change, and deletion made to the Item Location file.
      IMINVBIN I/M Inventory Bin file The I/M Inventory Bin file contains a record for each Inventory Item Bin record.
      IMINVHST I/M Inventory History file The I/M Inventory History file contains period number and all period to date accumulators for 24 periods. This file is updated during the Clear I/M Accumulators function.
      IMINVLOC I/M Inventory Location file The I/M Inventory Location file contains a record for each item that is located at a warehouse location/s other than the default warehouse. This field contains records entered through Inventory Location Control.
      IMINVTRX I/M Inventory Transaction file The I/M Inventory Transaction file contains all history for allocations, receipts, issue, and transfers. It contains audits of all changes and additions to inventory. It retains detail to the bin and lot/serial level. Alternate keys allow you to access history detail for production reporting of finished goods and their components at the lot/serial level.
      IMITMADT I/M Item Audit file The I/M Item Audit file contains a record for every addition, change, and deletion made to the Item Master file.
      IMITMIDX I/M Item Index file The I/M Item Index file is the index to the Inventory Item file. It contains only the item number, the item description, and the relative record number of each record in the Inventory Item file. Whenever a record is retrieved from the Inventory Item file, Progression reads the Item Master file first to obtain the relative record number of the correct Inventory Item record.
      IMITMNOT I/M Note file The I/M Note file contains notes related to a specific item which could be printed on different documents.
      IMITMSRT IMITMSRT Work file SQL Server Work file.
      IMITMTXT I/M Text file The I/M Item Text file contains multiple lines of text related to an item note.
      IMKITFIL I/M Item Kit file The I/M Item Kit file contains data similar to the BOM Product Structure file. The kit parent item is just like a bill of material parent with the exception that the end item code must be a “K”. The kit parent contains components (not code K) and a quantity per parent kit. The kit parent has only one level of components (single level bill).
      IMLBLFLD IMLBLFLD Form Work file for SQL Server IMLBLFLD Form Work file for SQL Server.
      IMLBLFRM IMLBLFRM Form Work file for SQL Server IMLBLFRM Form Work file for SQL Server.
      IMLBLRST IMLBLRST Form Work file for SQL Server IMLBLRST Form Work file for SQL Server.
      IMLFMST I/M LIFO/FIFO Master file The I/M LIFO/FIFO Master file contains layer records for each Inventory Item/Location. These layer records include quantity and cost.
      IMLFTRX I/M LIFO/FIFO Transaction file The I/M LIFO/FIFO Transaction file contains a record for each transaction that occurred for the I/M LIFO/FIFO Master file.
      IMLOCFIL I/M Location file The I/M Location file contains a record for each valid warehouse location and its description.
      IMLSMST I/M Lot/Serial Master file The I/M Serial/Lot Master file contains a record for each serial or lot number.
      IMLSTRX I/M Lot/Serial Transaction file The I/M Lot/Serial Transaction file contains a record for each transaction entered through Inventory Transaction Processing with a lot or serial number assigned to it. Each record contains the item number, location, date sold, effective and expiration dates, cost, quantity on hand and allocated, purchase order number, and vendor number.
      IMMATCST I/M Material Cost Type file The I/M Material Cost Type file contains a record for each valid material cost type and its description.
      IMORDBLD I/M Order Line Build file The I/M Order Line Build file contains the information for all options selected during order entry for the features of feature type items. Its contents consist of the feature item number, option number, and the item number. It also contains the components for a kit type item entered in order entry.
      IMORDHST I/M Order History file The I/M Order History file contains records from the I/M Order Line Build file that are deleted due to posting.
      IMRECHST I/M Receiving History file The I/M Receiving History file contains records from all receipts in purchase order receiving, receiving inspection, and material review.
      IMREFDES I/M Order Reference Designator The I/M Order Reference Designator file contains the reference designators associated with the captured bill of material for an Order Entry order or a Production Order Processing order.
      IMREFHST I/M Order Reference Designator History The I/M Order Reference Designator History file contains the reference designators which were associated with the captured bill of material for a posted Order Entry order or a completed Production Order Processing order.
      IMREQWRK I/M Kit Gross Requirements Work file The I/M Kit Gross Requirements Work file is used when creating the Kit Gross Requirements report.
      IMREVWRK IMREVWRK Work file SQL Server Work file.
      IMSHT999 Inventory Shortage Work file Inventory Shortage Work file
      IMSHTFIL Inventory Shortage file Inventory Shortage file
      IMSUBITM I/M Substitute Item file The I/M Substitute Item file contains a record for each substitute item and inventory item with which it is associated.
      IMTAGFIL I/M Tag file This I/M Tag file contains current physical/cycle count tag information.
      IMTAGFLD IMTAGFLD Form Work file for SQL Server IMTAGFLD Form Work file for SQL Server
      IMTAGFRM IMTAGFRM Form Work file for SQL Server IMTAGFRM Form Work file for SQL Server
      IMTAGHST I/M Tag History file This I/M Tag History file contains a record for all physical/cycle count tags.
      IMTAGRST IMTAGRST Form Work file for SQL Server IMTAGRST Form Work file for SQL Server
      IMTAGSUB I/M Bin/Serial/Lot Tag file The I/M Bin/Serial/Lot Tag file is used when processing a physical count.
      IMTRXDST I/M Transaction Distribution file The I/M Transaction Distribution file contains a record for each distribution record that pertains to specific transactions. Each distribution record allows amounts to be distributed to specific accounts and jobs.
      IMTYPLOC I/M Material Cost Type Location Account file The I/M Material Cost Type Location Account file contains a record for cost types within a specific warehouse location for purposes of keeping track of inventory cost by material cost type within a particular location. O/E uses this file to post the cost of each item to the correct inventory asset account. The file also contains the purchase price variance account which may be used in A/P when the expected cost of an item is not the same as the actual cost.
      PRELOAD Distribution Preload file Distribution Preload file.

      L/P Package Data files

      DOS file Name file Name Description
      LP2PR L/P To PR Ascii file Not used.
      LPCCAUD L/P Clock Card Transaction Audit file L/P Clock Card Transaction Audit file.
      LPCCEXP L/P Clock Card Exception file L/P Clock Card Exception file.
      LPCCHST L/P Clock Card History file L/P Clock Card History file
      LPCCTRX L/P Clock Card Trx file L/P Clock Card Transaction file.
      LPCTLFIL L/P Setup file L/P Setup file.
      LPDTCTR L/P Clock Card Import file L/P Clock Card Import file
      LPDTLTR L/P Labor Transaction Import file L/P Labor Transaction Import file.
      LPEAR999 L/P Earnings Work file Work file for SQL Server.
      LPERNAUD L/P Earnings Audit file L/P Earnings Audit file
      LPERNFIL L/P Earnings file L/P Earnings file.
      LPERNHST L/P Earnings History file L/P Earnings History file.
      LPSFTFIL L/P Shift file L/P Shift file.
      LPTRXAUD L/P Transaction Audit file L/P Transaction Audit file.
      LPTRXEXP L/P Transaction Export file L/P Transaction Export file.
      LPTRXFIL L/P Transaction file L/P Transaction file.
      LPTRXHST L/P Transaction History file L/P Transaction History file.
      LPWRK999 L/P Generic Work file L/P Generic Work file.

      MCA Package Data files

      DOS file Name file Name Description
      MCCRWFIL MCA Crew Transaction file MCA Crew Transaction file.
      MCCRWHST MCA Crew History file MCA Crew History file.
      MCCTLFIL MCA Setup file MCA Setup file.
      MCDISFIL MCA Distribution to G/L file The MCA Distribution to G/L file contains a record for every distribution posted in the Job Cost Package. This is the file that the G/L package uses during the Post From Sub Ledger application.
      MCJOBAUD MCA Job Audit file MCA Job Audit file.
      MCJOBFIL MCA Job Master file MCA Job Master file.
      MCTRXFIL MCA Transaction file MCA Transaction file.
      MCTRXHST MCA Transaction History file MCA Transaction History file.
      MCWRK999 MCA Work file MCA Work file.

      MRP package data files

      DOS file Name file Name Description
      MRCPOFIL Computer Planned Orders file Used during Material Requirements Regeneration to store information about the computer planned orders that the regeneration process determines are necessary. The contents of this file along with the contents of the Low Level file are used to create the MRP Requirements file.
      MRCTLFIL MRP Setup file Contains setup information for MRP.
      MRETFFIL Explosion Table file Used to explode requirements for the item currently being processed in the MRP regeneration, net change, or what if programs. Even though it is a relative file, it is used as if it were a table with the relative record number corresponding to the table’s index. The file is dynamically created as needed.
      MREXPFIL MRP Exceptions file Used to hold the MRP Exceptions information. This file is recreated whenever MRP regeneration, net change, or what if analysis is run. The MRP Exceptions report and the exception information on the MRP By Date report comes from this file.
      MRITMFIL MRP Item file MRP Item file. Contains MRP quantity on hand At MRP locations amounts for each process used (full regen, what if, or net change). This replaces the Item Master file when calculating and storing quantity on hand at MRP locations as a preliminary step of the regeneration process.
      MRLOCFIL MRP Location file Used to store locations used for full regeneration, net change, and what if analysis. The user can change which locations to include for full regeneration and what if analysis as runtime parameters. The results of their selection are stored in this file, with a key on what type of process it was used for. All locations are stored, even if they are not used for processing.
      MRLOWRK Low Level Work file The Low Level Work file is used to temporarily hold the Low Level record generated by the VMS Cobol Sort utility. This file is opened and closed automatically by the sort utility in MRRGLWLV.
      MRLWLFIL Low Level file Used to hold information needed during the MRP regeneration, net change, or what if analysis process.
      MRORDFIL Order Table file Used to store information about the item currently being processed in the MRP regeneration, net change, and what if analysis programs. The file is created dynamically as needed.
      MRPEGFIL Peg file Used to hold the information needed to peg lower level requirements back to requirements at a higher level. This file is rebuilt during the MRP regeneration, net change, or what if process. It is a linked list of requirements and orders.
      MRPEGWFL Peg Work file Used to initially hold the information needed to peg lower level requirements back to requirements at a higher level. This file is created during the MRP regeneration, net change, or what if process. It is used at the end of the MRP regeneration to create the Peg file.
      MRREQFIL MRP Requirements file Used to hold detailed information for the MRP package. This is the primary file which is recreated whenever an MRP regeneration or what if is run. Most of the data on reports in the MRP package come directly or indirectly from this file. The requirements information in this file is by exact due date (bucketless format). This file is also used in the Master Schedule package in the Master Schedule Maintenance applications Merge Orders into Master Schedule function to merge computer planned orders from this file into the master schedule.
      MRSPCITM Special Item file Used to hold information on items that are on shop orders or purchase orders but were not found on the Inventory Item file during the last MRP regeneration, or what if analysis. Note that all items in the Special Item file are considered to be low level code zero items, even if they are found in shop order parent/component relationships.
      MRVPW999 Vendor Purchase Request Work file The Vendor Purchase Request Work file is used as a work file to collect vendor purchase request data in the order needed for printing the Purchase Request by Vendor Report.
      MRWRK999 MRP Work file

      M/S Package Data files

      DOS file Name file Name Description
      MSCTLFIL Master Schedule Setup file Contains master setup record for the Master Scheduling package.
      MSFRCFIL Forecast Orders file The Forecast Orders file contains information concerning forecast orders. This information may be copied from other forecast orders or added through Sales Forecast maintenance as needed. Info in this file is used on the Sales Forecast Report.
      MSPCWFIL Period Capacity Work file Used to help in the production of the Rough Cut Capacity Report. It collects scheduled load data by period.
      MSSCHFIL Master Scheduling file Contains the detail information for Master Scheduled Orders. This information may be added through Master Scheduling Maintenance or copied from customer orders, forecast orders, purchase orders, shop orders or from previous master schedules. This is the primary file used by Materials Requirements Planning during the MRP Generation application.
      MSWRK999 Master Schedule Work file Master Schedule Work file.

      O/E Package Data files

      DOS file Name file Name Description
      OEACKFLD OEACKFLD Form Work file for SQL Server OEACKFLD Form Work file for SQL Server.
      OEACKFRM OEACKFRM Form Work file for SQL Server OEACKFRM Form Work file for SQL Server.
      OEACKRST OEACKRST Form Work file for SQL Server OEACKRST Form Work file for SQL Server.
      OEBBWRK OEBBWRK Work file SQL Server Work file.
      OEBOLFIL Bill of Lading file The Bill of Lading file contains the customer shipping information for the bill of lading.
      OEBOLORD Bill of Lading Order file The Bill of Lading Order file contains all customer orders related to a bill of lading.
      OECARCDE O/E Carrier Code file The O/E Carrier Code file identifies carrier and mode codes for the ship-via types in the A/R Ship-Via file.
      OECMTCDE O/E Comment Code file The Comment Code file holds a line of comments tied to a code that can be used in the order header shipping instructions.
      OECMTHST O/E Comment History file The Comment History file holds a line of comments tied to a code that can be used in the order header shipping instructions.
      OECSHFIL O/E Cash file The Order Entry Cash file contains records of cash transactions from order entry transactions, such as prepayments or down payments.
      OECTLFIL O/E Setup file The O/E Setup file contains default codes and allows the user to customize the package to their specific needs.
      OECUSITM Customer Item file The Customer Item file contains relationships between your item numbers and the item numbers your customers use for the same items.
      OEFBOAUD Back Order Audit Trail file The Back Order Audit Trail file stores changes to the Order Line Item file as a result of filling backorders.
      OEFRMFIL Form file The Form file contains information on the forms used in O/E.
      OEHDRAUD O/E Header Audit Trail file The Header Audit Trail file contains a record of any changes made to the order header records.
      OEHDRHST O/E Header History file When order entry transactions are posted, they are written to the Header History file.
      OEHSTPRD Sales History Period file The Sales History Period file is used during the Post Invoices to A/R files so that the sales journal will print in document number order.
      OEINQORD Order View Master file Order Entry Inquiry Order Work file
      OEINVBAT OEINVBAT Form Work file for SQL Server SQL Server Work file.
      OEINVFLD OEINVFLD Form Work file for SQL Server OEINVFLD Form Work file for SQL Server.
      OEINVFRM OEINVFRM Form Work file for SQL Server OEINVFRM Form Work file for SQL Server.
      OEINVRST OEINVRST Form Work file for SQL Server OEINVRST Form Work file for SQL Server.
      OELADFLD OELADFLD Form Work file for SQL Server OELADFLD Form Work file for SQL Server.
      OELADFRM OELADFRM Form Work file for SQL Server OELADFRM Form Work file for SQL Server.
      OELADRST OELADRST Form Work file for SQL Server OELADRST Form Work file for SQL Server.
      OELBLFLD OELBLFLD Form Work file for SQL Server OELBLFLD Form Work file for SQL Server.
      OELBLFRM OELBLFRM Form Work file for SQL Server OELBLFRM Form Work file for SQL Server.
      OELBLRST OELBLRST Form Work file for SQL Server OELBLRST Form Work file for SQL Server.
      OELINAUD Order Line Audit Trail file The Order Line Audit Trail file holds a record of any changes made to the order line items.
      OELINCMT Order Line Comment file The Order Line Comment file holds both item notes and comments for order line items.
      OELINHST Order Line History file When order entry transactions are posted, the line item records are written to the Order Line History file.
      OELSTRXS Order Entry Serial Lot Trx file (Not Used) Order Entry Serial Lot Trx file (Not Used).
      OEOPTHST Option History file Order Entry Option History file.
      OEORDDTL Order View Detail Work file Order Entry Order Detail file (Not Used).
      OEORDHDR Order Header file The Order Header file contains general information for each order entered such as order number, billing and shipping information, salesperson information. This file contains the first screen of information in Order Entry, add, change and delete orders.
      OEORDLIN Order Line Item file The Order Line Item file contains information concerning each item that is entered on an order. This file contains information that is entered on the second screen in Order Entry; add, change, and delete Orders.
      OEORDREL Order Release file The Order Release file is used with blanket orders. This file holds all the releases for each line item.
      OEPAKFLD OEPAKFLD Form Work file for SQL Server OEPAKFLD Form Work file for SQL Server.
      OEPAKFRM OEPAKFRM Form Work file for SQL Server OEPAKFRM Form Work file for SQL Server.
      OEPAKRST OEPAKRST Form Work file for SQL Server OEPAKRST Form Work file for SQL Server.
      OEPIKFLD OEPIKFLD Form Work file for SQL Server OEPIKFLD Form Work file for SQL Server.
      OEPIKFRM OEPIKFRM Form Work file for SQL Server OEPIKFRM Form Work file for SQL Server.
      OEPIKRST OEPIKRST Form Work file for SQL Server OEPIKRST Form Work file for SQL Server.
      OEPRCFIL Price Codes file The Price Codes file stores the various pricing methods that have been defined in the Price Code file Maintenance. During the entry of orders, Progression checks this file to find prices for individual line items on the order, it finds a price code that matches the order, it will use the price in the price code file, otherwise, Progression uses the price in the Inventory Item file.
      OEPRDACT Product Category Account file The Product Category Account file identifies a product category with its associated warehouse location, sales and cost of goods sold account numbers.
      OEPREPAY O/E Prepayment file Order Entry Prepay file (OE Cash file).
      OEPURHDR Order Entry Purchase Header file (Not used) Order Entry Purchase Header file (Not used).
      OEQTEFLD OEQTEFLD Form Work file for SQL Server OEQTEFLD Form Work file for SQL Server.
      OEQTEFRM OEQTEFRM Form Work file for SQL Server OEQTEFRM Form Work file for SQL Server.
      OEQTERST OEQTERST Form Work file for SQL Server OEQTERST Form Work file for SQL Server.
      OERDTFIL RMA Detail file RMA Detail file.
      OERDTHIS RMA Detail History file RMA Detail History file.
      OERHDFIL RMA Header file RMA Header file.
      OERHDHIS RMA Header History file RMA Header History file.
      OESHPLDT Shipping Lead Time file The Shipping Lead Time file holds the number of days it will take for a package to reach its destination from a given location to a given ship-to address by a given ship-via method.
      OESLSHST Sales History file The Sales History file stores sales information by customer and item number for each period defined in the Sales History Period file. This file is used to produce all of the Sales Comparison Reports.
      OEWRK1FL OEWRK1FL Work file SQL Server Work file.
      RESEQWRK RESEQWRK Work file SQL Server Work file.

      P/O Package Data files

      DOS file Name file Name Description
      POBUYERP P/O Buyer Print file The P/O Buyer Print file determines if there are any purchase orders for a selected buyer/planner within the range of purchase orders to print.
      POCOMCDE P/O Commodity Code Work file The P/O Commodity Code Work file is used to sort the Vendor Commodity code data into an order that is suitable for use on the Commodity Code Vendor Report.
      POCOMFIL P/O Line Item Comments file The P/O Line Item Comments file contains all comment code information for each Purchase order.
      POCONFIL P/O Consolidated Requisition file P/O Consolidated Requisition file.
      POCONHST P/O Consolidated Requisition History file P/O Consolidated Requisition History file.
      POCSHREQ P/O Cash Requirements Work file The P/O Cash Requirements Work file is used to sort scheduled receivings into order by date within vendor number so that the file can be used to produce the Cash Requirements Projection Report.
      POCTLFIL P/O Setup file The P/O Setup file contains general information for each purchase order. This file contains the first screen of information in Purchase Order Processing: add/change/delete.
      POFRMFIL P/O Forms Master file The P/O Forms Master file contains the forms control codes for user defined purchase order forms.
      POHDRAUD P/O Header Audit Trail file The P/O Header Audit Trail file contains a record of any changes made to the order header records.
      POHDRHST P/O Header History file The P/O Header History file is created when purchase orders are printed and updated when purchase orders are purged.
      POINSAUD P/O Receiving Inspection Audit file The P/O Receiving Inspection Audit file contains audit records for receiving inspection and disposition.
      POINSHDR P/O Receiving Inspection Transaction file The P/O Receiving Inspection Transaction file contains a record for each receiver processed against purchase orders for every item requiring inspection.
      POINVFLD POINVFLD Form Work file for SQL Server POINVFLD Form Work file for SQL Server.
      POINVFRM POINVFRM Form Work file for SQL Server POINVFRM Form Work file for SQL Server.
      POINVRST POINVRST Form Work file for SQL Server POINVRST Form Work file for SQL Server.
      POITMVND Purchase Order Item Vendor file The P/O Item Vendor file keeps track of which vendors provide which items and, conversely, which items are available from which vendors. The vendor’s item number is stored for each item/vendor relationship. This information is used to print the Item Vendor Report. The data in this file is also available at other locations in the package to provide the operator with a means of identifying an item number when all that is available is the vendor number and the vendor’s item number.

      This file also stores Item Vendor performance data.
      POIVAUD P/O Item Vendor Audit file The P/O Item Vendor Audit file is used for item vendor maintenance.
      POLINAUD P/O Line Item Audit Trail file The P/O Line Audit Trail file holds a record of any changes made to the purchase order line items.
      POLINHST P/O Line History file The P/O Line History file stores historical data about line items on purchase orders that have been deleted. This data is used to print the Purchase Line History Report. This file is also updated for receiving and disposition.
      POLNDCST P/O Landed Cost Master file The P/O Landed Cost file contains all landed cost codes used by the package.
      POORDFLD POORDFLD Form Work file for SQL Server POORDFLD Form Work file for SQL Server.
      POORDFRM POORDFRM Form Work file for SQL Server POORDFRM Form Work file for SQL Server.
      POORDHDR P/O Order Header file The P/O Header file stores general information regarding a purchase order. The order header is the means by which a purchase order is identified.
      POORDLIN P/O Line Item file The P/O Line Item file contains information concerning each item that is entered on an order. This file contains information entered on the second screen on Purchase Order Processing.
      POORDRST POORDRST Form Work file for SQL Server POORDRST Form Work file for SQL Server.
      POPRPVEN P/O Prospective Vendor file P/O Prospective Vendor file.
      POPURCST P/O Landed Cost file The P/O Landed Cost file contains the landed cost information for a particular line item on a purchase order.
      POQTEHDR PO Quote Header file PO Quote Header file
      POQTELIN PO Quote Line file PO Quote Line file
      POQTELVL PO Quote Cost Level file PO Quote Cost Level file
      POQTEPRE PO Pre-Quote file PO Pre-Quote file
      POQTHDHS PO Quote Header History file PO Quote Header History file
      POQTLNHS PO Quote Line History file PO Quote Line History file
      PORECFLD PORECFLD Form Work file for SQL Server PORECFLD Form Work file for SQL Server
      PORECFRM PORECFRM Form Work file for SQL Server PORECFRM Form Work file for SQL Server
      PORECHDR PO Receipt Header file (Not used) PO Receipt Header file (Not used)
      PORECRST PORECRST Form Work file for SQL Server PORECRST Form Work file for SQL Server
      POREQHDR PO Requisition Header file PO Requisition Header file
      POREQLIN PO Requisition Line file PO Requisition Line file
      PORQHDHS PO Requisition Header History file PO Requisition Header History file
      PORQLNHS PO Requisition Line History file PO Requisition Line History file
      PORTNFLD PORTNFLD Form Work file for SQL Server PORTNFLD Form Work file for SQL Server
      PORTNFRM PORTNFRM Form Work file for SQL Server PORTNFRM Form Work file for SQL Server
      PORTNRST PORTNRST Form Work file for SQL Server PORTNRST Form Work file for SQL Server
      POSCHFLD POSCHFLD Form Work file for SQL Server POSCHFLD Form Work file for SQL Server
      POSCHFRM POSCHFRM Form Work file for SQL Server POSCHFRM Form Work file for SQL Server
      POSCHRST POSCHRST Form Work file for SQL Server POSCHRST Form Work file for SQL Server
      POSHPFIL P/O Ship-To Code file The P/O Ship-To Code file stores all addresses to which merchandise can be sent. If there are multiple locations at a particular address there should be a ship-to record for each of these locations.
      POTRXDST P/O Receivings Transaction Distribution file The P/O Receivings Transaction Distribution file contains the distributions for each receipt transaction. This file updates the IMDISFIL during posting. The records are coded “purchased” in the IMDISFIL. Valid records are deleted during posting. This file may be changed/deleted before posting.
      POTRXFIL P/O Transactions file The Receivings Transaction file contains data to update all related files for batch receivings. The records may be changed or deleted before posting. The posting process will purge valid records.

      POP Package Data files

      DOS file Name file Name Description
      PPADVWRK Production Order Advice Work file Work file used to create the Production Order Advice Report..
      PPCMTHST Production Order Comment History Contains the history comments from completed POP orders.
      PPCSTCAP Production Captured Cost file Contains information on the captured costs for each production order.
      PPCSTFIL Product Structure Cost Type file Maintains product structure costs with description, rate, and account.
      PPCSTSTR Product Structure Cost file Maintains product structure cost components per BOM product structure parent.
      PPCSTTRX Product Structure Cost Transaction file Contains records of transactions for product structure costs.
      PPCTLFIL POP Setup file Contains master setup record for the Production Order Processing package.
      PPEXPLWK BOM Explosion Work file Used for the explosion of bills of material used by POP.
      PPFRMFIL POP Form file POP Form file.
      PPLINCMT Production Order Line Comments file Contains the comments associated with the lines of POP orders.
      PPORDAUD Production Order Audit file Maintains an audit trail of production orders, including all additions, changes, and deletions of production orders.
      PPORDFIL Production Order file Contains information for each production order entered.
      PPORDFLD PPORDFLD Form Work file for SQL Server PPORDFLD Form Work file for SQL Server.
      PPORDFRM PPORDFRM Form Work file for SQL Server PPORDFRM Form Work file for SQL Server.
      PPORDRST PPORDRST Form Work file for SQL Server PPORDRST Form Work file for SQL Server.
      PPORDTRX Production Order Transaction file Contains information on the transactions associated with each production order.
      PPRCNCWK POP Reconciliation Work file POP Reconciliation Work file.

      PR Package Data files

      DOS file Name file Name Description
      PRACTFIL PR Account Reference file The PR Account Reference file contains all G/L accounts used the PR package.
      PRAUDFIL PR Employee Audit file The PR Employee Audit file contains records that pertain to add, change, and delete operations performed to the Employee Master file.
      PRCHKREC PR Check Reconciliation file The PR Check Reconciliation file contains one record for each check written. PR uses this file to reconcile checks.
      PRDIRFIL PR Directory file The PR Directory file contains most of the codes that you define in Maintenance applications.
      PRDISFIL PR Distribution file The PR Distribution file contains a record for every distribution to an account made during and of the PR activities.
      PREMPFIL PR Employee file The PR Employee file contains the employee master information such as the employee number, address, wage account, pay rate, tax codes, etc.
      PRGLSORT Payroll G/L Sort Work file Payroll G/L Sort Work file.
      PRNOTES PR Notes file The PR Notes file contains the notes entered on the Employee Notes screen, which is accessed from the Employee Master Maintenance screen by the Emp Notes push button.
      PRPAYFIL PR Pay History file The PR Pay History file contains history records from the Register file.
      PRREGFIL PR Register file The PR Register file contains payroll run information - one record for each employee or per check for a single pay period.
      PRSNVFIL PR Leave Accrual file The PR Leave Accrual file contains the Leave Accrual Codes data.
      PRTIMFIL PR Time file The PR Time file contains the time file records for one pay period.

      SC Package Data files

      DOS file Name file Name Description
      SCCSTAUD Cost Master Audit file Cost Master Audit file.
      SCCSTFIL Cost Master file Cost Master file.
      SCCTLFIL S/C Setup file S/C Setup file.
      SCSUMWRK S/C Summary Work file S/C Summary Work file.
      SCWRK999 S/C Work file S/C Work file.

      SFC Package Data files

      DOS file Name file Name Description
      SFBUYERP SFC Buyer Lock file SFC Buyer Lock file
      SFCTLFIL SFC Setup file SFC Setup file
      SFDTLAUD SFC Detail Audit file SFC Detail Audit file
      SFDTLFIL SFC Order Detail file SFC Order Detail file
      SFORDAUD SFC Order Audit file SFC Order Audit file
      SFORDFIL SFC Order Header file The Shop Floor Order file is used to maintain all information for each Shop Order created. It contains six types of records for each shop order: Header, Operation, Material, Note, Tool, and Outside.
      SFSHTFIL SFC Shortage file The Shop Floor Shortage file contains information concerning all shortages of materials for Shop Orders that exist on the Shop Floor.
      SFWRK999 SFC Work file Shop Floor Work file.

      SPR Package Data files

      DOS file Name file Name Description
      SRCTLFIL SPR Setup file Standard Product Routing Setup file.
      SRDTLAUD Routing Detail Audit Trail file Contains information concerning additions, changes, and deletions to routings in the Routing Detail file.
      SRDTLFIL Routing Detail file This file contains all detail type records for each item routing added through Routing file Entry application.
      SRRTGAUD Routing Header Audit Trail file Contains information concerning additions, changes, and deletions to routings in the Routing Header file.
      SRRTGFIL Routing Header file Contains all header information concerning routings used to produce items. This file contains header type records for each item routing added through Routing file Entry application.
      SRWRK999 Routing Work file Routing work file.