package data files and sql tables -...

Progression 7.6 Package Data Files and SQL Tables

of 96


The following are the Progression Version 7.6 package data files and SQL tables. These are the data files and tables that are maintained as part of the Progression packages and can be used by any Progression package. The data files and tables are grouped by type (package data file or SQL table) and are shown in alphabetical order by their file or table name.

For quick reference, refer to the following list of the data files and tables included in this document.

Progression 7.6 Package Data Files.............................................................................................. 3 Assets and Depreciation (A/D) Package Data Files .............................................................. 3 Accounts Payable (A/P) Package Data Files ......................................................................... 6 Accounts Receivable (A/R) Package Data Files.................................................................... 9 Bank Book (B/B) Package Data Files ................................................................................... 13 Bill of Material (BOM) Package Data files ............................................................................ 15 Currency Manager (C/M) Package Data Files ...................................................................... 17 Capacity Requirements Planning (CRP) Package Data Files............................................. 17 General Ledger (G/L) Package Data Files............................................................................ 18 Manufacturing System (HZ) Package Data Files................................................................. 21 Inventory Management (I/M) Package Data Files ................................................................ 23 Labor Performance (L/P) Package Data Files...................................................................... 27 Manufacturing Cost Accounting (MCA) Package Data Files.............................................. 29 Material Requirements Planning (MRP) Package Data Files.............................................. 30 Master Scheduling (M/S) Package Data Files...................................................................... 32 Order Entry (O/E) Package Data Files .................................................................................. 32 Payroll (PR) Package Data Files ........................................................................................... 37 Purchase Order and Receiving (P/O) Package Data Files.................................................. 39 Production Order Processing (POP) Package Data files.................................................... 42 Quoting and Estimating (Q/E) Package Data Files.............................................................. 43 Shop Floor Control (SFC) Package Data Files .................................................................... 44 Standard Costing (S/C) Package Data Files ........................................................................ 45 Standard Product Routing (SPR) Package Data Files ........................................................ 45 System Manager (S/M) Package Data Files ......................................................................... 46

Progression 7.6 Package SQL Tables ......................................................................................... 50 Assets and Depreciation (A/D) Package SQL Tables ......................................................... 50 Accounts Payable (A/P) Package SQL Tables..................................................................... 53 Bank Book (B/B) Package SQL Tables ................................................................................ 60 Bill of Material (BOM) Package SQL Data Tables................................................................ 62 Currency Manager (C/M) Package SQL Tables ................................................................... 63 Capacity Requirements Planning (CRP) Package SQL Tables.......................................... 64 General Ledger (G/L) Package SQL Tables ......................................................................... 65 Manufacturing System (HZ) Package SQL Tables .............................................................. 68 Inventory Management (I/M) Package SQL Tables ............................................................. 70


of 96

Labor Performance (L/P) Package SQL Tables................................................................... 74 Manufacturing Cost Accounting (MCA) Package SQL Tables........................................... 75 Material Requirements Planning (MRP) Package SQL Data Tables .................................. 76 Master Scheduling (M/S) Package SQL Tables ................................................................... 78 Order Entry (O/E) Package SQL Data Tables....................................................................... 79 Production Order Processing (POP) Package SQL Tables................................................ 84 Purchase Order and Receiving (P/O) Package SQL Tables ............................................... 85 Quoting and Estimating (Q/E) Package Data Files.............................................................. 88 Shop Floor Control (SFC) Package SQL Tables.................................................................. 90 Standard Costing (S/C) Package SQL Tables...................................................................... 91 Standard Product Routing (SPR) Package SQL Tables ..................................................... 91 System Manager (S/M) Package SQL Tables....................................................................... 92


of 96

Progression 7.6 Package Data Files Assets and Depreciation (A/D) Package Data Files

The following are the Progression Assets and Depreciation Package Data files. These are the files that are maintained as part of the Assets and Depreciation package but can be used by any package that integrates with Assets and Depreciation. The files are shown in alphabetical order by their 8-character DOS file name.

FXACCWRK - Accum Depr Work file

Progression uses the Accum Depr Work file when printing the Accumulated Depreciation Report.

FXACQAST - A/D Asset Acquisition file

The A/D Asset Acquisition file is only used by the Trx, Acquisition, Enter Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Master file. Only that acquisition data that is independent of any reporting entity is written to this file; the entity 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 Trx, Acquisition, Enter Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Entity file.

FXAMDWRK - A/D Alternative Min Depr Work file

Progression uses the Alternative Min Depr Work file when printing the AMD Comparison Report.

FXASTENT - A/D Asset Entity file

The A/D Asset Entity file contains permanent asset data for each reporting entity. Since information used in depreciation calculations can differ for each reporting entity, the data 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 - Transferred Asset Work file

Progression uses the Transferred Asset Work file when printing the Asset Transfer Report.

FXCELFIL - Ceiling Codes file

The Ceiling Codes file contains IRS limitations on the amount of depreciation that can be taken annually on certain assets. You maintain this file through A/D Setup.


of 96

FXCNGAST - A/D Asset Change History file

The A/D Asset Change History file keeps before-change and after-change asset master records. This data is then used for the asset audit trail report, the transfer register, and the 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 asset entity records. This data is then used for the asset audit trail report, the transfer register, and the Change History Report.

FXCTLFIL - A/D Setup file

The A/D Setup file maintains information about how the package will operate. It contains the reporting entities, Alternative Minimum Depreciation Entity and the Next Main Asset No.

FXDCGWRK - Depr Method Change Work File

Progression uses the Depr Method Change Work file when printing the Depreciation Method change report.

FXDEPFIL - A/D Asset Depreciation Transaction file

The Calculate Depreciation process uses the A/D Asset Depreciation Transaction file. 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 and posted for each asset.

FXDEPJNL - Depr Journal Work file

Progression uses the Depreciation Journal Work file when posting depreciation.

FXDISFIL - A/D Distribution to G/L file

The A/D Distribution to G/L file contains a record for every account distribution posted. The General Ledger package uses this file during the Post from Sub Ledger process.

FXDSPFIL - A/D Asset Disposition file

The A/D Asset Disposition file is used by the Trx, Disposition, Enter Transactions application. It serves as a temporary storage place for Disposition information before that information is posted to the Asset Master file. Once posting is done, this file is purged so 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 - Bonus and Expense Work file

Progression uses the Bonus and Expense Work file when printing the Bonus and Expensed Asset report.

FXGLCWRK - Asset List by G/L Code Work file

Progression uses the Asset List by G/L Code Work file when printing the By G/L Code Asset report.


of 96

FXIRSWRK - 4562 Report Work file

Progression uses the 4562 Report Work file when printing the IRS 4562 Worksheet.

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 - Investment Tax Credit Work file

Progression uses the Investment Tax Credit Work file when printing the Investment Tax Credit Asset report.

FXMETCOM - A/D Method Comparison file

Progression uses the A/D Method Comparison file when printing the Depreciation Method Comparison Report. It contains records entered during this application and allows you to compare the annual depreciation amounts for an item using each depreciation method to help you determine which method to use. This is a temporary file, the data is not retained in this file after the report is printed.

FXPODWRK - Unit of Production Asset Work file

Progression uses the Unit of Production Asset Work file when printing the Units of Production Asset report.

FXPRDFIL - Period file

The Period file contains the calendar information for each entity. You set the default period code and period date ranges per entity. These dates are used by the Calculate Depreciation application.

FXPRDWRK - Detail Depr History Work file

Progression uses the Detail Depr History Work file when printing the Deprec History Depreciation Report.

FXRUNWRK - Calculate Depr Work file

Progression uses the Calculate Depr Work file when you run the Calculate Depreciation process.

FXSEPENT - A/D Asset Separation Entity file

The A/D Asset Separation Entity file is used by the Trx, Separation, Enter 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 used by the Trx, Separation, Enter 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 - Depr Projection Work file

Progression uses the Depr Projection Work file when printing the Depreciation Expense Projection report.


of 96

Accounts Payable (A/P) Package Data Files The following are the Progression Accounts Payable Package Data files. These are the files that are maintained as part of the Accounts Payable package but can be used by any package that integrates with Accounts Payable. The files are shown in alphabetical order by their 8-character DOS file name.

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 - A/P Bank file

The A/P Bank File contains Vendor bank information if the Globalization Kit is in use.

APCHKFLD - A/P Check Field file

The A/P Check Field File contains the fields that you can use on the check forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

APCHKFRM - A/P Check Form file

The A/P Check Form File contains the Progression check form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APCHKRST - A/P Check Reset file

The A/P Check Reset File contains the standard Progression check forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

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 the General Ledger package uses during the Post From Sub Ledger process.

APDISWRK - A/P Distribution To G/L Work file

Progression uses the A/P Distribution To G/L Work file to summarize the data so the A/P Distribution to G/L Report can be printed.

APIDFIL - A/P Batch ID file

The A/P Batch ID file contains all transaction Batch ID information.

APLBLFLD - A/P Label Field file

The A/P Label Field File contains the fields that you can use on the label forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.


of 96

APLBLFRM - A/P Label Form file

The A/P Label Form File contains the Progression label form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APLBLRST - A/P Label Reset file

The A/P Label Reset File contains the standard Progression label forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

APOPNFIL - A/P Open Item file

The A/P Open Item file contains a record for every transaction posted. The file contains vouchers, checks, and credit memos. Transactions remain in this file until you purge the file.

APOPNHST - A/P Open Item History file

The A/P Open Item History file contains a record of every transaction posted. The transactions remain in this file until you purge the open item history file.

APRCVWRK - A/P Receiver Work file

Progression uses the A/P Receiver Work file when processing voucher transactions attached to purchase orders.

APRECDST - A/P Recurring Voucher Distribution file

The A/P Recurring Voucher Distribution file contains the distribution records associated with the recurring voucher records. 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 in a certain amount of days (every 14 days for example).

APTRXDST - New A/P Transaction Distribution file

The New A/P Transaction Distribution file contains a record for each distribution that is associated with a transaction entered through A/P, Trx, Vouchers, Enter Transactions or Enter Unauthorized Vouchers. Each distribution record allows amounts to be distributed to specific accounts and to jobs if you activate the Use Job Numbers check box in A/P Setup.

APTRXFIL - New A/P Transaction file

The New A/P Transaction file contains a record for every transaction entered through A/P, Trx, Vouchers, Enter Transactions or Enter Unauthorized Vouchers. 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, A/P Open Item History file and to the A/P Distribution to G/L file.

APVENADT - A/P Vendor Audit Trail file

If you activate the Keep Vendor file Audit Trail? check box in the A/P Setup file, a record is written for every add, change, or deletion made to the Vendor file. You can purge The A/P Vendor Audit Trail file when you print the report.


of 96

APVENDST - A/P Vendor Auto Distribution file

The A/P Vendor Auto Distribution file contains the account distributions that you can use to automatically distribute transaction amounts in A/P, Trx, Voucher, Enter Transactions and Enter Unauthorized vouchers. The A/P Vendor Auto Distribution file contains G/L Account Distributions and percentages associated with each account. The percentages must equal 100 for each vendor.

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 of default G/L accounts for each vendor type.

APWRK1FL - APWRK1FL

Progression uses the APWRK1FL file when printing the A/P Reconciliation Rpt by Journal No with Account Distribution Summary.

APWRK2FL - APWRK2FL

Progression uses the APWRK2FL file when printing the A/P Reconciliation Rpt by Journal No.

APWRK3FL - APWRK3FL

Progression uses the APWRK3FL file when printing the A/P Reconciliation Rpt by Account No.

APX99FLD - A/P 1099 Field file

The A/P 1099 Field File contains the fields that you can use on the 1099 forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

APX99FRM - A/P 1099 Form file

The A/P 1099 Form File contains the Progression 1099 form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APX99RST - A/P 1099 Reset file

The A/P 1099 Reset File contains the standard Progression 1099 forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

CHECKREC - A/P Check Reconciliation file

If you activate the Reconcile Checks? check box in the A/P Setup, then a record is written to the A/P Check Reconciliation file for each check that is posted. Progression uses this file when running the reconcile checks process and printing the reconciliation report. This file can be purged through the Check Reconciliation process when printing the reconciliation report.


of 96

Accounts Receivable (A/R) Package Data Files The following are the Progression Accounts Receivable Package Data files. These are the files that are maintained as part of the Accounts Receivable package but can be used by any package that integrates with Accounts Receivable. The files are shown in alphabetical order by their 8-character DOS file name.

ARALTADR - A/R Alternate Address file

The Alternate Address file contains the alternate addresses for companies that you entered through maintain, alternate address. Progression uses this address file for the shipping address in Order Entry.

ARBATFIL - A/R Batch file

The A/R Batch file contains all the transaction Batch IDs as well as the user name that entered the transactions in the batch.

ARCARCDE - A/R Carrier Code file

The A/R Carrier Code file contains the codes used for manifest shipping carriers.

ARCOMDUE - A/R Commission Due file

The Commissions Due file contains all invoices and the commission amounts calculated and posted from sales transactions, service invoices or invoices from Order Entry.

ARCOMWRK - A/R Commission Work file

Progression uses the A/R Commission Work File to calculate commission due by cash receipts.

ARCSHAPL - Cash Application file

The Cash Application file contains a record of each invoice that has a cash receipt applied but not posted. Progression uses this to apply and post the cash receipts to the customers’ open items for open item customers.

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 Trail file

The Customer Audit trail 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 - Aging Report by Collector Work file

Progression uses the Aging Report by Collector Work file to make calculations when printing the Aging Report by Collector.


of 96

ARCUSWK2 - Aging Report by Parent Company Work file

Progression uses the Aging Report by Parent Company Work file to make calculations when printing the Aging Report by Parent Company.

ARCUSWK3 - Aged Customer Totals by Acct Work file

Progression uses the Aged Customer Totals by Acct Work file to make calculations when printing the A/R Reconciliation Report by Account/Cust No.

ARCUSWK4 - Tax Analysis Work file

Progression uses the Tax Analysis Work file to make calculations when printing the A/R Tax Analysis report.

ARDISFIL - A/R 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. This is the file the General Ledger uses during the post from sub ledger process.

ARDISWRK - A/R Distribution Work file

Progression uses the A/R Distribution To G/L Work file to summarize the data so the Distribution to G/L Report can be printed.

ARDUNFLD - A/R Dunning Field file

The A/R Dunning Field file contains the fields that you can use on the dunning letter forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARDUNFRM - A/R Dunning Form file

The A/R Dunning Form File contains the Progression Dunning letter layouts. You can modify the letters through S/M, Maintain, Form Designer.

ARDUNRST - A/R Dunning Reset file

The A/R Dunning Reset File contains the standard Progression dunning letters, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

ARFCHTRX - A/R Finance Charge Transaction file

The Finance Charge Trx file contains a record showing the finance charge calculated for each customer against his current open balance. You can make adjustments to the finance charge amounts until you post finance charges.

ARINVFLD - A/R Invoice Field file

The A/R Invoice Field file contains the fields that you can use on the invoice forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARINVFRM - A/R Invoice Form file

The A/R Invoice Form File contains the Progression invoice form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

ARINVRST - A/R Invoice Reset file

The A/R Invoice Reset File contains the standard Progression invoice forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

ARLBLFLD - A/R Label Field file

The A/R Label Field File contains the fields that you can use on the label forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARLBLFRM - A/R Label Form file

The A/R Label Form File contains the Progression label form layouts. You can modify the forms through S/M, Maintain, Form Designer.

ARLBLRST - A/R Label Reset file

The A/R Label Reset File contains the standard Progression label forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

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 charges are posted to this file. In addition to posted transactions the open item file contains records that are entered through maintain open item load.

AROPNHST - A/R Open Item History file

The A/R Open Item History file contains all records posted to a customer’s account. In addition to records that are posted, the open item history file also contains records entered through maintain, open item load. The open item history file includes records that are not included in the open item file: adjustment records created when changing records through maintain, open item load and when using the reapply transactions process.

ARPMTWRK - A/R Payment Selection Work file

Progression uses the A/R Payment Selection Work file when selecting to apply cash to open items using the open item push button on the cash application screen.

ARRECDST - A/R Recurring Distribution file

The Recurring Distribution file contains a record for each account distribution associated with a recurring invoice.

ARRECINV - A/R Recurring Invoice file

The Recurring Invoice file contains a record for each recurring invoice entered through Trx, Recurring Sales.

ARSAWORK - A/R Sales Analysis Work file

Progression uses the Sales Analysis Work file for printing the Sales Analysis reports by sales volume, by state and by territory. The Sales Analysis report uses information from the customer file to create these reports.


of 96

ARSELCUS - A/R Selected Customer file

Progression uses the A/R Selected Customer file during the printing of the Open Invoice Worksheet. It details, for each Customer, what unpaid open items are on file, what the current balance owed is on those items, and the amount of any valid discount.

ARSHOFIL - A/R Shipping Order file

Progression uses the A/R Shipping Order file with a Manifest system. This file contains records of the order shipping information and is updated when picking tickets are printed.

ARSHTFIL - A/R Shipping Transaction file

Progression uses the A/R Shipping Transaction file with a Manifest system and contains freight amounts for orders. This file adds freight amounts during the billing or manifest select processes.

ARSLMFIL - A/R Salesperson file

The Salesperson file contains a record for each salesperson. This file contains 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 General Ledger account associated with a sales transaction record. This file contains the records until they are posted.

ARSLSTRX - A/R Sales Transaction file

The Sales Transaction file contains a record for each invoice, CR/DR memo or finance charge entered through Enter Sales Transactions. This file contains the records until they are posted.

ARSRVFIL - A/R Service codes file

The Service Codes file contains the information entered through maintain, service codes. It contains the service code and description, unit of measure, unit cost, unit price, sales account, tax information, commission information and YTD and PTD sales and cost figures. These services can be billed through Enter Service Invoices and Order Entry.

ARSRVHST - A/R Service Transaction History file

The Service Transaction History file contains posted service invoice transactions. Progression uses this file to reprint posted service invoices.

ARSRVTRX - A/R Service Transaction file

The Service Transaction file contains all service invoices until they are posted and recurring service invoice transactions until they are deleted. This file can contain service invoices that have not been printed, service invoices that have been printed but not yet posted and recurring service invoice transactions.

ARSTMFLD - A/R Statement Field file

The A/R Statement Field File contains the fields that you can use on the statement forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARSTMFRM - A/R Statement Form file

The A/R Statement Form File contains the Progression statement form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

ARSTMRST - A/R Statement Reset file

The A/R Statement Reset File contains the standard Progression statement forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

ARTYPFIL - A/R Customer Type file

The Customer Type file contains default account numbers for transaction entry, posting and maintenance applications.

ARWRK1FL - A/R Reconciliation by Jnl No. Work file

Progression uses the A/R Reconciliation by Jnl No Work file when printing the A/R Reconciliation by Jnl No Report.

ARWRK2FL - Acct Summary Reconciliation Work file

Progression uses the Acct Summary Reconciliation Work file when printing the A/R Reconciliation by Jnl No Report.

ARWRK3FL - Acct Summary Rpt by Customer Work file

Progression uses the Acct Summary Rpt by Customer Work file when printing the A/R Reconciliation by Account/Cust No Report.

ARWRK4FL - Acct Summary Rpt by Acct No Work file

Progression uses the Acct Summary Rpt by Acct No Work file when printing the A/R Reconciliation by Account No Report.

Bank Book (B/B) Package Data Files The following are the Progression Bank Book Package Data files. These are the files that are maintained as part of the Bank Book package but can be used by any package that integrates with Bank Book. The files are shown in alphabetical order by their 8-character DOS file name.

BBADJWRK - Adjustment Transaction Work file

Progression uses the Adjustment Transaction Work file when entering adjustments during the Reconcile Cash Account process.

BBCTLFIL - B/B Setup file

The Setup file maintains information about how the bank book package operates. It also contains the Last Transaction No and the Next Deposit No.

BBDEPFIL - B/B Deposit file

The Deposit file contains a record for each document on each deposit ticket entered through Trx, Deposits, Enter Deposits. The records remain in this file until you run the purge deposits process.

BBDEPHDR - B/B Deposit Header file

The Deposit Header file contains a record for each deposit ticket entered through Trx, Deposits, Enter Deposits. The records remain in this file until you run the purge deposits process.


of 96

BBDEPWRK - B/B Deposit Ticket Work file

Progression uses the Deposit ticket Work file when you print the deposit ticket.

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 the posting of Trx, Transactions, Post Transactions. When you post the Deposits in B/B, Distributions to G/L are not posted since they are posted in A/R when you post cash receipts. This is the file that General Ledger uses during the Post from Sub Ledger process.

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 entered through Trx, Transactions, Enter Transactions.

BBOPNFIL - B/B Open Item file

The Open Item file contains a record of each transaction to be reconciled. A flag and a reconciliation date identify reconciled records. Records are posted to the open item file through post deposits and through A/P and Payroll whenever checks are posted. You can enter records into the open item file manually through maintain, open item load.

BBRECWRK - B/B Reconciliation Work file

Progression uses the B/B Reconciliation Work file when you print the Bank Reconciliation by Account No report.

BBSTMFIL - Bank Book Statement Balances

The Bank Book Statement Balances file contains a record for each statement balance entered through maintain statement balance. It includes the cash account, statement date, and starting and ending statement balances.

BBTRXFIL - B/B Transaction file

The Transaction file contains a record for each transaction entered through Trx, Transactions, Enter Transactions.

BBTYPFIL - B/B Trx Type file

The Trx Type file contains a record for each transaction type. The file includes a description of the type and a default distribution account.

BBWK1FIL - B/B Reconciliation Rpt by Deposit Ticket Work file 1

Progression uses the B/B Reconciliation Rpt by Deposit Ticket Work file 1 when printing the Bank Reconciliation by Deposit Ticket report.


of 96





BBWRKFIL - B/B Open Item Work file

Progression uses the B/B Open Item Work file when you purge the Bank Book Open Item file.

Bill of Material (BOM) Package Data files The following are the Progression Bill of Material Package Data files. These are the files that are maintained as part of the Bill of Material package but can be used by any package that integrates with Bill of Material. The files are shown in alphabetical order by their 8-character DOS file name.

BMCTLFIL - BOM Setup file

The BOM Setup file contains one record, which is the master control record for the bill of material. The default values are Audit Trail Field, 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 user defined field file. The BOM Setup file controls the preferences concerning changing price of the Orders and whether to display or print the cost on reports and views. The BOM Setup file also sets the Next Engineering Change Number and sets the Product Structure component increments with which Progression assigns the next component in the structure.

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 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 stores the selected options when a feature option is being entered. Mainly used for inquiry.


of 96

BMEXPLWK - Parent Item Exploded Work file

This is a work file used to explode a parent item for reporting purposes. The applications that use this file are:

• Indented Bill on Material - View

• Bill of Material - Single Level Where-Used - View

• Available To Promise - Inquiry

• Forecast Consumption - Component View

BMFTRFIL - Product Feature file

The Product Feature file contains the information, which identifies all of the features of a feature type item.

BMMASRPL - Mass Replace Work file

Progression uses the Mass Replace Work file 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

The Option Dependencies/Exclusions 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. The content consists of the feature item number, feature number, option number, and the option item number.

BMPRDAUD - Product Structure Audit file

The Product Structure Audit file keeps track of changes to the Product Structure File Maintenance.

BMPRDCPY - Product Structure Copy Work file

Progression uses the Product Structure Copy Work file in the copy mode of the Product Structure file Maintenance application 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 the old and new sequence number during the execution of this procedure.

BMPRDSTR - Product Structure file

The Product Structure file is a main file of the Bill of Material package. Progression uses this file 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.


of 96

Currency Manager (C/M) Package Data Files The following are the Progression Currency Manager Package Data files. These are the files that are maintained as part of the Currency Manager package but can be used by any package that integrates with Currency Manager. The files are shown in alphabetical order by their 8-character DOS file name.

CMCTLFIL - C/M Setup file

The C/M Setup file maintains information about how the package operates. It contains the home currency code and default information on how to determine which dates to use to determine rates in Order Entry and Purchase Order. It also contains information as to whether rates can be overridden at transaction entry.

CMCURCOD - C/M Currency Code file

The C/M Currency Code file contains all currency codes you entered in maintain, currency code.

CMCURRAT - C/M Currency Rate file

The C/M Currency Rate file contains all currency rates you entered in maintain, currency rate.

CMPRCCST - C/M Item Cost/Price file

The C/M Item Cost/Price file contains all item cost/price entries you entered in maintain, Item Cost/Price.

CMUNRFIL - Currency Manager Unrealized Gain Loss Work file

Progression uses the Currency Manager Unrealized Gain Loss Work file to make calculations when you print the Unrealized Gain/Loss report.

Capacity Requirements Planning (CRP) Package Data Files

The following are the Progression Capacity Requirements Planning (CRP) package data files. These are the files that are maintained as part of the CRP package but can be used by any package that integrates with CRP. The files are shown in alphabetical order by their 8-character DOS file name.

CRCTLFIL - CRP Setup File

The CRP Setup File contains information and defaults that determine how the CRP package operates. It also has historical information about each build load file.

CRDTLBL0, 1, 2, 3 - CRP Order Detail File 0, 1, 2, 3

The CRP Order Detail File 0, 1, 2, 3 contains detail information of the build load file. Some of this information includes the order type status, and number, job number, item number, work center, department, vendor component item numbers, quantity, operation details, standard and actual hours, planned and actual burden, setup details, and if an order contains a bottle neck operation.

CRLCKFIL - CRP Locked File

The CRP Locked file contains the name of the file that is currently in use. When an application finished processing the build load file, it deletes the file name from this file, meaning the build load file is no longer in use.


of 96

CRLOCFIL - CRP Location File

The CRP Location file contains valid locations for each build load file.

CRORDBL0, 1, 2, 3 - CRP Order Header File 0, 1, 2, 3

The CRP Order Header File 0, 1, 2, 3 contains the header information of the build load file. Some of the information is the order type, status, and number, item number and description, job number, due date, issue location, routing number, source package, and planned and actual costs.

CRTRXBL0, 1, 2, 3 - CRP Transaction File 0, 1, 2, 3

The CRP Transaction File 0, 1, 2, 3 contains a record of changes to the orders in a build load file. This is a file created each time a build load file is updated. The Visual Resource Planner, CRP Reschedule Dependent Orders, and Modify Scheduling Method applications update this file. The CRP Process Schedule Updates application processes this file.

CRTRXHST - CRP Transaction History file

The CRP Transaction History file saves the transactions that have been successfully processed through the CRP Process Schedule Updates application.

General Ledger (G/L) Package Data Files The following are the Progression General Ledger Package Data files. These are the files that are maintained as part of the General Ledger package but can be used by any package that integrates with General Ledger. The files are shown in alphabetical order by their 8-character DOS file name.

GLACTIDS - G/L ID Codes file

The G/L ID Codes file contains codes to identify G/L accounts. The account identifier is only available with the Globalization Kit.

GLACTWRK -G/L Account Work file

Progression uses the G/L Account Work file when you print the Trial Balance by Profit Center report.

GLBALFIL - G/L Period Balance file

The G/L Period Balance file contains account balances bucketed by period. The System Period File determines the periods. This file is updated during each posting procedure in G/L. The G/L Period Balance file provides the data to produce the trial balance in summary and financial statements.

GLBUDFIL - G/L Budget file

The G/L Budget file contains period budget amounts for multiple years and up to 99 revisions. You can print the budget amounts on financial statements and can print a list using the Reports/Graphs, Lists, Budget application.

GLCMPFIL - G/L Comparative file

The G/L Comparative file contains period comparative account amounts for any given year. Comparative amounts are updated when you perform a temporary or final year end procedure. You can print the comparative amount for prior years on financial statements and can print a list using the Reports/Graphs, Lists, Comparative application.


of 96

GLCMPRSF - G/L Compression Work file

The Compress G/Ledger Trx file process uses the G/L Compression Work file.

GLCTLFIL - G/L Setup file

The G/L Setup file maintains information about how the package will operate and the default retained earnings account number.

GLDISASC.DAT - G/L ASCII Interface file

The G/L ASCII Interface file is an ASCII text file you can create outside of Progression to post transactions to the General Ledger Transaction file. The file must be created in accordance with the file layout and must reside in your data directory to be posted using the post from sub ledger process.

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 distribution code.

GLENTITY - G/L Entity file

The G/L Entity file contains a record for each financial entity you set up in Maintain, Entities. A financial entity is defined as a set of profit centers and/or departments. Each entity is defined by up to 36 different ranges (or individual) profit centers and/or departments.

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 a work file used to pass the essential data needed to print financial statements. This data is not layout, specification, or account 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 Trx, General Journal, Enter Transactions. This file also contains the distributions posted from sub ledger if you activate the Interface to G/L Journal Trx File in G/L Setup. These entries are posted to the General Ledger Transaction file when you post transactions.

GLIDFIL - G/L Batch ID file

The G/L Batch ID file contains a record of Batch ID’s entered in Trx, General Journal, Enter Transactions and Trx, Recurring Journal, Enter Transactions. It contains information regarding the batch id, number of transactions in the batch and the balance of the batch.

GLINFTAB - G/L Inflation Table file

The G/L Inflation Table file contains the factors used to calculate the impact of monthly inflation. This file is only available with the Globalization Kit.

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 the codes and accounts that define which accounts will appear on the financial statement.


of 96

GLPASFLS - G/L Passing Flag Work file

Progression uses the G/L Passing Flag Work file when a post from Sub Ledger process is not completed. It displays a message indicating that the previous posting was not completed when you attempt to post from sub-ledger again.

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 Trx, Recurring Journal, Enter Transactions. 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 Edit Statement Specs (Standard or Custom Financials). Progression uses this file with the Statement Layout file to print the financial statements. 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 transaction posted to the General Ledger, either through Post from Sub Ledger, Trx, General Journal, Post Transactions or Trx, Recurring Journal, Post Transactions. This is the main transaction file for G/L. The trial balance in detail uses this 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 will print on the financial statement when you enter the TEXT layout code and the Text No. in Maintain, Statement Layout, Edit.

GLXREFIL - G/L Cross Reference file

The G/L Cross Reference file contains information used for the Source Cross Reference Report.

RESEQWRK - Resequence Work file

Progression uses the Resequence Work file when you resequence a statement layout.


of 96

SFLAYOUT - Source and Allocation of Funds Layout file

The generate SAF Statement process uses the Source and Allocation of Funds Layout file as a work file during the statement process. It contains records originating from a selected balance sheet layout and creates an SAF layout in the G/L Layout file.

STMNTWRK - G/L Statement Work file

Progression uses the G/L Statement Work file only for the printing of financial statements. Balances are calculated for all accounts and stored in this file.

Manufacturing System (HZ) Package Data Files The following are the Progression Manufacturing System Package Data files. These are the files that are maintained as part of the Manufacturing shared applications but can be used by any package that uses the Manufacturing shared applications. The files are shown in alphabetical order by their 8-character DOS file name.

HZBAI999 - Buyer/Planner/Item file

Manufacturing Buyer Analyst Work file (Not used).

HZCDEFIL - Manufacturing Codes file

The Manufacturing Codes file contains records for the valid codes entered in the manufacturing packages. It includes records for the following codes: crew, department, equipment type, indirect labor, incentive pay codes, labor grade, labor cost type, job type, scrap code, and win/loss.

HZCRWFIL - Manufacturing Crew file

The Manufacturing Crew file stores the crew members assigned to each crew.

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

The Manufacturing Work Center Account file stores the information entered in the Work Center Account Group application.

HZCTRCAP - 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 - Work Center file

The Work Center file contains information about work centers, production lines, and work cells used in a manufacturing environment.


of 96

HZCTRMCH - Work Center Machine file

The Manufacturing Work Center Machine file stores the information entered during Work Center Maintenance on the Work Center Machine screen. It includes the department, work center, machine number, labor factor, and whether or not the machine is considered critical to the work center.

HZEMPAUD - Mfg Employee Audit file

The Mfg Employee Audit file is the audit trail file maintained to keep track of changes to your employees. Activating the Employee Audit File? check box in Manufacturing Setup maintains an audit trail of changes to employee records and allows you to run the Mfg Employee Audit Trail Report to show any changes you have made to your employee records. You can purge the Mfg Employee Audit file as part of the printing process of the Mfg Employee Audit Trail Report.

If this check box is activated, Progression will also create add and change records in the Mfg Employee Audit file for employee records imported using one of the Copy Payroll applications, as it would if they had been added manually in Manufacturing Employee Maintenance.

HZEMPPER - Mfg Employee file

The Manufacturing Employee file holds the employee information entered in the Progression Manufacturing packages. This file also includes any employees imported from your payroll package.

HZEQPFIL - Equipment file

The Manufacturing Equipment file stores the tool and machine records entered in the Tool Master Maintenance or Machine Master Maintenance applications. The equipment type information is stored in the Manufacturing Codes file (HZCDEFIL).

HZERNFIL - Mfg Earnings Code file

The Mfg Earnings Code file contains the manufacturing earnings code records that you entered in the Manufacturing Earnings Code Maintenance application. These records also contain the associated payroll earnings code.

HZMCOFIL - MRP-CRP Orders file

The MRP-CRP Orders file contains 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 or) 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 1 = What If 1 file 2 = What If 2 file 3 = What If 3 file 4 = Results of Last Full Regeneration.

HZNOTFIL - Manufacturing Notes file

The Manufacturing Notes file contains all notes entered using the Manufacturing Global Notes screen. This file stores the package id and document type along with the note.

For example, selecting the Notes push button from the shop order header will link any notes entered on the Manufacturing Global Notes screen to that specific shop order header record. This information is then stored in the Manufacturing Notes file and is available in any package that displays this shop order header information.


of 96

HZNOTHST - Manufacturing Notes History file

Manufacturing Note History file.

HZOCFIL - Manufacturing Operation Code file

The Manufacturing Operation Code file stores the operation code records entered in the Operation Code Maintenance application.

HZPLPFIL - Product Load Profile file

The Product Load Profile file is a master file containing all pertinent information by Item for each work center it can run on. Master Scheduling (M/S) is the only package that uses this information.

HZPPVFIL - Purchase Price Variance file

Manufacturing PPV file.

HZPRELOD - SFC Preload file

HZ Preload file.

HZRPTCAL - Reporting Calendar file

The Reporting Calendar file contains the data that defines the period ending dates for the reporting periods (buckets) of various reporting calendars.

HZSHPCAL - Shop Calendar Header file

The Shop Calendar Header file contains the data that defines shop open/closed days.

HZSHPDTL - Shop Calendar Detail file

The Shop Calendar Detail file contains a record for every calendar day. The records contain the number of hours the shop is open on a specific day, along with the day of the week (Mon, Tue, etc.), and flags indicating whether the day is open in MRP and/or SFC.

Inventory Management (I/M) Package Data Files The following files are used by Progression Inventory Management. They are shown in alphabetical order by their 8-character DOS file name.

IM2801ST - Reset On-Order Quantity Work File

The Reset On-Order Quantity Work File is a work file used during the Reset On-Order Quantity application.

IMALLRST - Inventory Allocation Reset File

The Inventory Allocation Reset File is a permanent file used as a processing reference. Once this file is created, it is only referenced by I/M.

IMATPFIL - ATP Summary File

The ATP Summary File is created on the fly for ATP drill-down views.


of 96

IMATPORD - ATP Orders File

The ATP Orders File is created on the fly for ATP drill-down views.

IMBATFIL - Inventory Batch File

The Inventory Batch File contains all transaction batch IDs and their user names.

IMBINTRX - Bin Transaction File

The Bin Transaction File contains a record for each transaction entered through inventory transaction processing that has a batch number assigned to it. This file contains the history for all allocations, receipts, transfers, and issue records related to bins.

IMCAPBLD - Feature Option Capture File

The Feature Option Capture file stores feature option configurations for estimates from Quoting and Estimating and orders from Web.Orders.

IMCAPHST - Feature Option Capture History File

The Feature Option Capture History file stores feature option configurations for estimates from Quoting and Estimating and orders from Web.Orders, once the estimate or order has been pushed to history.

IMCATFIL - Product Category File

The 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 you to choose which category you want to print.

IMCNTDTE - Physical/Cycle Count Date File

The Physical/Cycle Count Date File contains a record for each date that either a physical or cycle count was performed.

IMCTLFIL - Inventory Setup File

The Inventory Setup File contains information about how the I/M package will operate. This file contains all the defaults for the I/M system, including cost method, warehouse, inventory asset account, serial/lot processing options, and bin processing options.

IMDISFIL - Account Distribution File

The Account Distribution File, or I/M Distribution to G/L File, contains a record for every distribution posted in the I/M package. The General Ledger (G/L) application uses this file to during the Post From Sub Ledger application.

IMINVAUD - Item Location Audit File

The Item Location Audit File contains a record for every addition, deletion, and change to the Item Location File.

IMINVBIN - Bin Master File

The Bin Master File The Bin Master File contains a record for each bin item.


of 96

IMINVHST - Inventory History File

The Inventory History File contains all period to date accumulators, by period number, for 24 periods. The Clear I/M Accumulators application updates this file.

IMINVLOC - Inventory Location File

The Inventory Location File contains a record for each item that is located at an inventory location other than the default location. This file contains records entered through Inventory Location Maintenance.

IMINVTRX - Inventory Transaction File

The Inventory Transaction File contains all history for allocations, receipts, issues, and transfers.

IMITMADT - Item Master Audit File

The Item Master Audit File contains a record for every addition, deletion, and change to the Item Master File.

IMITMIDX - Item Master File

The Item Master File contains a record for items entered through Item Master Maintenance.

IMITMNOT - Item Note File

The Item Note File contains notes related to a specific item that you can print on different documents.

IMITMSRT - Reset Item Location Allocated Quantity File

The Reset Item Location Allocated Quantity File is a work file used when generating the Reset Allocations report.

IMITMTXT - Item Text File

The Item Text File contains multiple lines of text related to an item note.

IMKITFIL - Kit Master File

The Kit Master File contains data similar to the BOM Product Structure File. The kit parent item is just like a bill of material parent, except the end item code must be "K". The kit parent contains components (whose end item code are not "K"). The kit parent has only one level of components (a single level bill).

IMLFMST - LIFO/FIFO Master File

The LIFO/FIFO Master File contains layer records for each inventory item/location, including quantity and cost.

IMLFTRX - LIFO/FIFO Transaction File

The LIFO/FIFO Transaction File contains a record for each transaction that occurred for the LIFO/FIFO Master File.

IMLOCFIL - Location Master File

The Location Master File contains a record for each valid warehouse location and its description.


of 96

IMLSMST - Serial/Lot Master File

The Serial/Lot Master File contains a record for each serial and lot number.

IMLSTRX - Serial/Lot Transaction File

The Serial/Lot Transaction File contains a record for each transaction entered through Inventory Transaction Processing with a serial or lot 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 - Material Cost Type File

The Material Cost Type File contains a record for each valid material cost type and its description.

IMORDBLD - Order Build File

The Order Build File contains information about all options selected for the features of feature items during order entry. This file contains feature item number, option number, and item number. This file also contains components of kit items entered in order entry.

IMORDHST - Order Build History File

The Order Build History File contains records from the Order Build File that were deleted due to posting.

IMRECHST - Receiving History File

The Receiving History File contains records from all receipts in purchase order receiving, receiving inspection, and material review.

IMREQWRK - Gross Requirements File

The Gross Requirements File is the work file used when creating the Kit Gross Requirements report.

IMREVWRK - POP Roll Back Work File

The POP Roll Back Work File is a work file used as a numbered work file for POP in a non-transaction tracking process.

IMSUBITM - Substitute Item File

The Substitute Item File contains a record for each substitute item and the inventory item with which it is associated.

IMTAGFIL - Inventory Tag File

The Inventory Tag File contains current Physical/Cycle Count Tag Information.

IMTAGHST - Tag History File

The Tag History File contains a record of all Physical/Cycle Count Tags.

IMTAGSUB - Serial/Lot Tag File

Progression uses the Serial/Lot Tag File when processing a physical count.


of 96

IMTRXDST - Transaction Distribution File

The Transaction Distribution File contains a record for each distribution record that pertains to specific transactions. Each distribution record allows amount to be distributed to specific accounts and jobs.

IMTYPLOC - Cost Type/Location Account File

The Cost type/Location Account File contains a record of cost types within a specific warehouse to keep track of inventory cost by material cost type for that location. O/E uses this file to post the correct cost of each item to the inventory asset account. This file also contains the purchase price variance account, which A/P may use when the expected cost of an item is not the same as the actual cost.

PRELOAD - Pre-Processing Work File

Progression uses the Pre-Processing Work File to preload POP Bin/Serial/Lot data.

Labor Performance (L/P) Package Data Files The following are the Progression Labor Performance (L/P) package data files. These are the files that are maintained as part of the L/P package but can be used by any package that integrates with L/P. The files are shown in alphabetical order by their 8-character DOS file name.

LP2PR - L/P To Payroll ASCII File

The Update Payroll application creates this file and the Earnings History File. It contains an ASCII file similar to other ASCII files used in L/P. The information written to this file is the same that is in the Earnings File. Once created, this file can be passed to a payroll system for calculation of payroll and printing of checks.

LPCCAUD - L/P Clock Card Audit File

The L/P Clock Card Audit file contains information about additions, changes, and deletions in the Clock Card Trx File.

LPCCEXP - L/P Clock Card Exception File

The L/P Clock Card Exception file contains incomplete or invalid records that have been created by the import applications. Use the edit exceptions applications to correct these transactions. Use the reprocess exceptions applications to move them to the clock card file.

LPCCHST - L/P Clock Card History File

The L/P Clock Card History file contains a history of all clock cards used by the system after they have been moved from the clock card file during the Update Payroll application.

LPCCTRX - L/P Clock Card Trx File

The L/P Clock Card Trx file contains all transactions entered though the Enter Clock Card Transactions application. This information is used for validating labor transactions.

LPCTLFIL - L/P Setup File

The L/P Setup File contains information and defaults that determine how the L/P package operates.


of 96

LPDTCTR - L/P Data Terminal Clock Card Transaction Import File

The L/P Data Terminal Clock Card Transaction Import file is an externally created ASCII file used to import clock card transactions into Progression Labor Performance.

LPDTLTR - L/P Data Terminal Labor Transaction Import File

The L/P Data Terminal Labor Transaction Import file is an externally created ASCII file used to import labor transactions into Progression Labor Performance.

LPEAR999 - L/P Earnings Work File

The L/P Earnings file is a work file used by the Generate Earnings application.

LPERNAUD - L/P Earnings Audit File

The L/P Earnings Audit file contains information about additions, changes, and deletions to records in the L/P Earnings File.

LPERNFIL - L/P Earnings File

The L/P Earnings file contains all L/P Payroll Earnings information before interfacing with Payroll or exporting earnings information to an ASCII file. The Generate Earnings application populates this file. This file can be edited before it is interfaced with Payroll or before it is exported to an ASCII file. Adjustments made to direct labor transactions through the Enter Earnings Transactions application are not made to the corresponding transactions in MCA/SFC.

LPERNHST - L/P Earnings History File

The L/P Earnings History file contains a history of all transactions used to Payroll. L/P writes this file as the Update Payroll application runs and records are moved from the Earnings File.

LPSFTFIL - L/P Shift File

The L/P Shift file contains information defining each work shift such as start and end, meal, and break times. This file also defines shift differential pay. It is used while entering clock cards and labor transactions and while calculating earnings.

LPTRXAUD - L/P Transaction Audit File

The L/P Transaction Audit file contains information about additions, changes, and deletions to records in the L/P Transaction File.

LPTRXEXP - L/P Transaction Exception File

The L/P Transaction Exception file contains labor transactions imported from an ASCII file where the system is missing information to update master files. These transactions are viewed as exceptions that may be edited through the edit exceptions applications to correct missing information. After this information is corrected, master files are updated with the reprocess exceptions applications.

LPTRXFIL - L/P Transaction File

The L/P Transaction file contains labor transactions used for generating payroll transactions by the Generate Earnings application. After the Update Payroll application is run, L/P moves the transactions to the Transaction History File. These transactions are posted to Shop Floor Control and Manufacturing Cost Accounting as they are entered.


of 96

LPTRXHST - L/P Transaction History File

The L/P Transaction History file contains labor transactions from the L/P Transaction File that have been updated to payroll.

LPWRK999 - L/P Work File

Labor Performance uses the L/P Work file as a general work file for multiple applications in the L/P package.

Manufacturing Cost Accounting (MCA) Package Data Files

The following are the Progression Manufacturing Cost Accounting (MCA) package data files. These are the files that are maintained as part of the MCA package but can be used by any package that integrates with MCA. The files are shown in alphabetical order by their 8-character DOS file name.

MCCRWFIL - MCA Crew Transaction File

The MCA Crew Transaction file contains the unposted records of shop floor activity transactions relating to direct labor cost by employee number. The wage rate and direct cost information is associated with a job/shop order/operation number combination.

MCCRWHST - MCA Crew History File

The MCA Crew History file contains the posted records of shop floor activity transactions relating to direct labor cost by employee number. The wage rate and direct cost information is associated with a job/shop order/operation number combination.

MCCTLFIL - MCA Setup File

The MCA Setup File contains information and defaults that determine how the MCA package operates.

MCDISFIL - MCA Distribution to G/L File

The MCA Distribution to G/L file contains a record for every distribution to an account made during posting. This is the file that the G/L package uses during the Post From Sub Ledger application.

MCJOBAUD - MCA Job Audit File

The MCA Job Audit file contains information about additions, changes, and deletions to jobs in the job master file.

MCJOBFIL - MCA Job Master File

The MCA Job Master file maintains planned and actual cost information about jobs. This file provides data about the value of work in process and cost analysis figures.

MCTRXFIL - MCA Transaction File

The MCA Transaction file updates the Job Master File with planned or actual data about jobs. Entering miscellaneous costs and cost adjustments adds information in this file. Reporting activity against shop orders in Shop Floor Control also adds information to this file.


of 96

MCTRXHST - MCA Transaction History File

The MCA Transaction History file provides a history of what activity has been posted against jobs in the Job Master File. It is also used to print the Job Transaction History Report. MCA adds information to this file when the Post Activity Transactions application is run.

MCWRK999 - MCA Work File

MCA uses the MCA Work file as a general work file for multiple applications in the MCA package.

Material Requirements Planning (MRP) Package Data Files

The following are the Progression MRP Package Data files. These are the files that are maintained as part of the MRP package but can be used by any package that integrates with MRP. The files are shown in alphabetical order by their 8-character DOS file name.

MRCPOFIL - Computer Planned Orders file

Progression uses the Computer Planned Orders file 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

The MRP Setup file contains setup information for MRP.

MRETFFIL - Explosion table

Progression uses the Explosion Table file 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

Progression uses the MRP Exceptions file 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 come from this file.

MRITMFIL - MRP Item file

The MRP Item file contains MRP quantity on hand At MRP locations and the 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

Progression uses the MRP Location file to store locations used for full regeneration, net change, and what if analysis. You can change which locations to include for full regeneration and what if analysis as runtime parameters. The results of your 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.


of 96

MRLOWRK - Low Level Work file

Progression uses the Low Level Work file 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 the MRRGLWLV file.

MRLWLFIL - Low Level file

Progression uses the Low Level file to hold information needed during the MRP regeneration, net change, or what if analysis process.

MRORDFIL - Order Table file

Progression uses the Order Table file 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 - Pegging file

Progression uses the Pegging file 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 list of requirements and orders.

MRPEGWFL - Pegging Work file

Progression uses the Pegging Work file 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 Pegging file.

MRREQFIL - MRP Requirements file

Progression uses the MRP Requirements file to hold detailed information for the MRP package. This is the primary file, which is recreated whenever an MRP regeneration application or an MRP What If application 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). The Master Scheduling package also uses this file in the Transactions, Master Schedule, Merge Orders application. The Merge Orders functions merges computer planned orders from this file into the master schedule.

MRSPCITM - Special Item file

Progression uses the Special Item file 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 MRP 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 - Purchase By Vendor Work file

Progression uses the Purchase By Vendor Work file 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

Material Requirements Planning uses the MRP Work file as a work file to collect data.


of 96

Master Scheduling (M/S) Package Data Files The following are the Progression M/S Package Data files. These files are maintained as part of the M/S package, but can be used by any package that integrates with M/S. The files are shown in alphabetical order by their 8-character DOS file name.

MSCTLFIL - Master Schedule Setup File

The Master Scheduling Setup File contains the master setup record for the M/S package. The setup record determines the default ATP/forecast calendars, the start/end of period method for consuming forecast orders, the next M/S order number, and the minimum probability code used for O/E quotes. The set up record also contains flags for displaying safety stock with beginning inventory and orders before the current period on M/S Reports and Views. This file also contains the default order types to purge and merge in the Master Schedule Merge application.

MSFRCFIL - Forecast Orders File

The Forecast Orders File contains information concerning sales forecast orders. This information may be copied from other forecast orders or added through Sales Forecast maintenance entry as needed. Information in this file is used for forecast consumption on reports, views, and O/E Post Invoices.

MSPCWFIL - Period Capacity Work File

The Period Work Capacity File is a temporary work file used to help produce the Rough Cut Capacity Report. This file collects scheduled load data by period from Report/Shop calendars and the Product Load Profile.

MSSCHFIL - Master Schedule File

The Master Schedule File contains the detail information for Master Scheduled Orders. This information may be added through Master Scheduling Maintenance Entry or merged from customer orders, production orders, forecast orders, purchase orders, shop orders, or copied from previous master schedules. This is the primary file that may be merged into MRP for Rough Cut Capacity ATP.

MSWRK999 - Master Schedule Work File

The Master Schedule Work File is a temporary work file used for sorting, sequencing, and storing data when creating some reports and views in M/S, such as the Master Schedule Report, the What If Comparison By Detail Report, and the Forecast Consumption View. This file is also used to perform some M/S transactions, such as Copy Master Schedule and Purge Master Schedule.

Order Entry (O/E) Package Data Files The following are the Progression Order Entry Package Data files. These are the files that are maintained as part of the Order Entry package but can be used by any package that integrates with Order Entry. The files are shown in alphabetical order by their 8-character DOS file name.

OEACKFLD - Acknowledgement Field file

The Acknowledgement Field file contains the fields that you can use on the Acknowledgement Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEACKFRM - Acknowledgement Form file

The Acknowledgement Form file contains the Progression Acknowledgement Form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

OEACKRST - Acknowledgement Reset file

The Acknowledgement Reset file contains the standard Progression Acknowledgement Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OEBBWRK - OEBBWRK Work file

Bank Book 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 - 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 - Comment Code file

The Comment Code file stores the user-defined information associated with the code that can be displayed in the order header shipping instructions.

OECMTHST - Comment History file

The Comment History file stores the user-defined information associated with the code that can be displayed in the order header shipping instructions.

OECSHFIL - O/E Cash file

The O/E 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 - Order Header Audit Trail file

The Order Header Audit Trail file contains a record of any changes made to the order header records.


of 96

OEHDRHST - O/E Header History file

When order entry transactions are posted, they are written to the Order Header History file.

OEHSTPRD - Sales History Period file

Progression uses the Sales History Period file 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 View Order Master file

OEINVBAT - Invoice Batch ID Work file

Invoice Batch ID Work file

OEINVFLD - Invoice Field file

The Invoice Field file contains the fields that you can use on Invoice Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEINVFRM - Invoice Form file

The Invoice Form file contains the Progression Invoice Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEINVRST - Invoice Reset file

The Invoice Reset file contains the standard Progression Invoice Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OELADFLD - Bill of Lading Field file

The Bill of Lading Field file contains the fields that you can use on the Bill of Lading Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OELADFRM - Bill of Lading Form file

The Bill of Lading Form file contains the Progression Bill of Lading Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OELADRST - Bill of Lading Reset file

The Bill of Lading Reset File contains the standard Progression Bill of Lading Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OELBLFLD - Label Field file

The Label Field file contains the fields that you can use on the Label Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OELBLFRM - Label Form file

The Label Form file contains the Progression Label Form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

OELBLRST - Label Reset file

The Label Reset File contains the standard Progression Label Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

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 - Serial Lot Trx file (Not Used)

Serial Lot Trx file (Not Used).

OEOPTHST - Option History file

For future use.

OEORDDTL - Order View Detail Work file

Order Detail Work 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 and salesperson information. This file contains the first screen of information in Order Entry including added, changed 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 including added, changed, and deleted orders.

OEORDREL - Order Release file

Progression uses the Order Release file with blanket orders. This file holds all the releases for each line item.

OEPAKFLD - Packing Field file

The Packing Field file contains the fields that you can use on the Packing Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEPAKFRM - Packing Form file

The Packing Form file contains the Progression Packing Form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

OEPAKRST - Packing Reset file

The Packing Reset file contains the standard Progression Packing Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OEPIKFLD - Picking Field file

The Picking Field file contains the fields that you can use on the Picking Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEPIKFRM - Picking Form file

The Picking Form file contains the Progression Picking Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEPIKRST - Picking Reset file

The Picking Reset file contains the standard Progression Picking Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

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. If Progression 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 and sales and cost of goods sold account numbers.

OEPREPAY - Prepayment file

The Prepayment file stores payment information for orders marked as O/E Cash, including information entered on the Order Entry Prepayment screen.

OEQTEFLD - Quote Field file

The Quote Field file contains the fields that you can use on Quote forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEQTEFRM - Quote Form file

The Quote Form file contains the Progression Quote form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEQTERST - Quote Reset file

The Quote Reset file contains the standard Progression Quote forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OERDTFIL - RMA Detail file

Return Material Authorization (RMA) Detail file stores the RMA line item information for the RMAs entered.


of 96

OERDTHIS - RMA Detail History file

Return Material Authorization (RMA) Detail History file stores the RMA line item information for the RMAs entered and closed.

OERHDFIL - RMA Header file

Return Material Authorization (RMA) Header file stores the RMA customer information for the RMAs entered.

OERHDHIS - RMA Header History file

Return Material Authorization (RMA) Header History file stores the RMA customer information for the RMAs entered and closed.

OESHPLDT - Ship Lead Time file

The Ship 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 - Order Entry Work file

Progression uses the Order Entry Work file when running the O/E Reconciliation Report.

Payroll (PR) Package Data Files The following are the Progression Payroll Package Data files. These are the files that are maintained as part of the Payroll package but can be used by any package that integrates with Payroll. The files are shown in alphabetical order by their 8-character DOS file name.

GLFILE.DAT – Payroll General Ledger Posting Work file

Progression uses the Payroll General Ledger Posting Work file during the Trial Post to the Distribution to G/L and the actual Post of Payroll to the Distribution to G/L file.

GLSORT.POS – Payroll General Ledger Work File

The Payroll GLSORT.POS and GLSORT.PRE files are work files used during the Trial Post to G/L file and the actual Post of Payroll to the Distribution to G/L file. These work files sort the records by account number to create the GLFILE.DAT file.

GLSORT.PRE – Payroll General Ledger Work File

The Payroll GLSORT.POS and GLSORT.PRE files are work files used during the Trial Post to G/L file and the actual Post of Payroll to the Distribution to G/L file. These work files sort the records by account number to create the GLFILE.DAT file.

PRACTFIL – Payroll Account Reference file

The Payroll Account Reference file contains all the G/L accounts used in the Payroll package.


of 96

PRAUDFIL - Payroll Employee Audit file

The Payroll Employee Audit file contains records that pertain to add, change, and delete operations performed to the Employee Master file.

PRCHKREC - Payroll Check Reconciliation file

The Payroll Check Reconciliation file contains one record for each check written. Payroll uses this file to reconcile checks.

PRDIRFIL - Payroll Directory file

The Payroll Directory file contains most of the codes that you define in the Payroll Maintenance applications.

PRDISFIL – Payroll Distribution file

The Payroll Distribution file contains a record for every distribution to an account made during any of the Payroll activities.

PREMPFIL - Payroll Employee file

The Payroll Employee file contains the payroll setup record and 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 – PRNOTES file

The Payroll Notes file contains the notes entered on the Employee Notes screen. You access the Employee Notes screen from the Emp Notes push button on the Employee Master Maintenance screen.

PRPAYFIL – Payroll Pay History file

The Payroll Pay History file contains history records from the Payroll Register file.

PRREGFIL – Payroll Register file

The Payroll Register file contains payroll run information - one record for each employee or per check for a single pay period.

PRSNVFIL – Payroll Leave Accrual file

The Payroll Leave Accrual file contains the Leave Accrual Codes data.

PRTIMFIL - Payroll Time file

The Payroll Time file contains the time file records for one pay period.


of 96

Purchase Order and Receiving (P/O) Package Data Files

The following files are used by Progression Purchase Order and Receiving. They are shown in alphabetical order by their 8-character DOS file name.

POBUYLCK - RFQ Buyer Lock File

Progression uses the RFQ Buyer Lock File to allow only one user at a time to access each buyer/planner record for RFQ applications that create purchase orders.

POCOMCDE - Commodity Code File

The Commodity Code File is a work file used to sort vendor commodity code data for the Commodity Code Vendor Report.

POCOMFIL - Line Item Comments File

The Line Item Comments File contains all comment code information for each purchase order.

POCONFIL - Requisition Consolidation File

The Requisition Consolidation File contains a record of the individual requisitions that make up each consolidated requisition. Requisition line items marked for consolidation that have the same item, location, and buyer are grouped with other requisitions into a consolidated requisition with the Consolidate By Period application. Requisition line items that are not marked for consolidation are written to this file once they are saved on the Requisition Entry screen. A record from this file is purged once you create a purchase order based on that consolidated requisition.

POCONHST - Consolidated Requisition History File

The Consolidated Requisition History File contains a record of consolidated requisitions that have been deleted or purged. This file records the individual requisitions which make up the consolidated requisition. Once you delete a consolidated requisition or create a purchase order based on a consolidated requisition, that consolidated requisition record is moved into this history file.

POCSHREQ - Cash Requirements File

The Cash Requirements File is a work file used to sort scheduled receivings into order by date for each vendor number to produce the Cash Requirements Projection Report.

POCTLFIL - P/O Setup File

The P/O Setup File contains system default information for the entire package. This file contains information from the P/O Setup application.

POHDRAUD - P/O Header Audit File

The P/O Header Audit File contains a record of any changes made to 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.


of 96

POINSAUD - Receiving Inspection Audit File

The Receiving Inspection Audit File contains audit records from receiving inspection and disposition processing.

POINSHDR - Receiving Inspection Header File

The Receiving Inspection Header File contains a record for each receiver processed against purchase orders for every item requiring inspection.

POITMVND - Item Vendor File

The Item Vendor File keeps track of which vendors provide which items and which items are available from which vendors. The vendor's item number is stored for each item/vendor relationship and used to print the Item Vendor report. The information in this file is also available in other P/O applications, so the user can identify a Progression item number from a vendor number and vendor item number.

POIVAUD - Item Vendor Audit File

Progression uses the Item Vendor Audit File for item vendor maintenance.

POLINAUD - P/O Line Item Audit File

The Line Item Audit File contains a record of any changes made to purchase order line items.

POLINHST - P/O Line History File

The Line History File contains historical data about line items on deleted purchase orders, which is used to print the Line Item History Report.

POLNDCST - Landed Cost Master File

The Landed Cost Master file contains all the landed cost codes used in P/O.

POORDHDR - P/O Header File

The P/O Header File stores general information about each purchase order. The Header is how purchase orders are identified. This file contains information entered on the Purchase Order Entry screen.

POORDLIN - P/O Line Item File

The Line Item File contains information about each item entered on a purchase order. This file contains information entered on the Line Item screen during Purchase Order Entry.

POPRPVEN - Prospective Vendor File

The Prospective Vendor file contains records for vendors to whom you can send requisitions. This file contains a cross reference to the A/P Vendor record if the vendor exists in A/P.

POPURCST - P/O Landed Cost File

The Landed Cost File contains landed cost information for purchase order line items.

POQTEHDR - Quote Header File

The Quote Header File is created when you create quotes based on consolidated requisition records.


of 96

POQTELIN - Quote Line File

The Quote Line File contains line item information about requests for quotes sent to vendors. This file is created from the Vendor Pre-Quote File when you run the Create Quotes application.

POQTELVL - Quote Cost Level File

The Quote Cost Level File contains a list of quote amounts and corresponding passwords. When creating a quote, you must enter the appropriate password based on the amount on the quote.

POQTEPRE - Vendor Pre-Quote File

The Vendor Pre-Quote file contains information used to generate vendor requests for quotes. This file contains information about the consolidated requisition record for which you are requesting a quote, and the vendor you to whom you will send the quote request.

POQTHDHS - Quote Header History File

The Quote Header History File contains a record of quotes that have been deleted or those from which a purchase order was generated.

POQTLNHS - Quote Line History File

The Quote Line History File contains a record of individual line items for quotes that have been deleted or those from which a purchase order was generated.

PORQHDHS - Requisition Header History File

The Requisition Header History File contains a record of requisition header information for requisitions that have been deleted or purged. The requisition header information is entered through the Requisition Entry screen and contains data common to all the requisition line items. Once a requisition is deleted or a purchase order is created based on that requisition, the header information for that requisition is moved to this history file.

POREQHDR - Requisition Header File

The Requisition Header File contains general information that applies to all line items in the requisition.

PORQLNHS - Requisition Line History File

The Requisition Line History File contains a record of requisition line items that have been deleted or purged. A record is purged form this file when the corresponding requisition record is deleted or a purchase order is generated based on the requisition.

POREQLIN - Requisition Line File

The Requisition Line File contains line items for purchase order requisitions entered in the Requisition Entry screen. You can edit requisition line items until the requisition is consolidated. A record from this file is purged once you create a purchase order based on that requisition.

POSHPFIL - Ship-To File

The Ship-To File contains codes for all addresses where you can send inventory. If there are multiple locations for a single address, there should be a Ship-To record for each of these locations.


of 96

POTRXDST - Transaction Distribution File

The Transaction Distribution File contains distributions for each receipt transaction. This file updates IMDISFIL during posting, giving IMDISFIL records a "purchased" code. Valid records are deleted from the POTRXDST file during posting. This file can be changed/deleted before posting.

POTRXFIL - P/O Transactions File

The P/O Transactions file contains all history for purchase order and receipt transactions.

Production Order Processing (POP) Package Data files

The following are the Progression Production Order Processing Package Data files. These are the files that are maintained as part of the Production Order Processing package but can be used by any package that integrates with Production Order Processing. The files are shown in alphabetical order by their 8-character DOS file name.

PPADVWRK - Production Order Advice Work file

Progression uses the Production Order Advice Work file to create the Production Order Advice Report.

PPCMTHST - Production Comment History file

Contains the history comments from completed POP orders.

PPCSTCAP - Production Captured Cost file

Contains information on the captured costs for each production order.

PPCSTFIL - Value Added 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 Trx file

Contains records of transactions for product structure costs.

PPCTLFIL - POP Setup file

Contains master setup record for the Production Order Processing package.

PPEXPLWK - Explode Work file

Progression uses the Explode Work file for the explosion of bills of material used by POP.

PPFRMFIL - POP Form file

POP Form file.


of 96

PPLINCMT - Production Comment 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 - Production Order Field file

The Production Order Field file contains the fields that you can use on the POP Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

PPORDFRM - Production Order Form Work file

The Production Order Form file contains the Progression POP Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

PPORDRST - Production Order Reset Work file

The Production Order Reset file contains the standard Progression POP Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

PPORDTRX - Production Order Transaction file

Contains information on the transactions associated with each production order.

PPRCNCWK - POP Reconciliation Work file

POP Reconciliation Work file.

Quoting and Estimating (Q/E) Package Data Files With the release of Progression 7.5.103f, Quoting and Estimating is a Progression SQL only package. You can only use Q/E if you are running in a SQL environment. See the Quoting and Estimating SQL Tables section for a list of the available SQL tables.


of 96

Shop Floor Control (SFC) Package Data Files The following are the Progression Shop Floor Control (SFC) package data files. These are the files that are maintained as part of the SFC package but can be used by any package that integrates with SFC. The files are shown in alphabetical order by their 8-character DOS file name.

SFBUYERP - SFC Buyer Lock File

Progression uses the SFC Buyer Lock file to prevent multiple users from processing the same shop order at the same time.

SFCTLFIL - SFC Setup File

The SFC Setup File contains information and defaults that determine how the SFC package operates.

SFDTLAUD - SFC Detail Audit File

The SFC Detail Audit file contains information about additions, changes, and deletions to shop orders in the SFC Order Detail File.

SFDTLFIL - SFC Order Detail File

The SFC Order Detail file maintains all detail information for each shop order created. It contains six types of records for each shop order: operation, material, tool, outside process, parallel start, and parallel end.

SFORDAUD - SFC Order Audit File

The SFC Order Audit file contains information about additions, changes, and deletions to shop orders in the SFC Order Header File.

SFORDFIL - SFC Order Header File

The SFC Order Header file maintains all header information for all shop orders. This also includes planned cost information specifically related to shop orders.

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

Progression uses the SFC Work file as a general work file for multiple applications in SFC.


of 96

Standard Costing (S/C) Package Data Files The following are the Progression Standard Costing (S/C) package data files. These are the files that are maintained as part of the S/C package but can be used by any package that integrates with S/C. The files are shown in alphabetical order by their 8-character DOS file name.

SCCSTAUD - Cost Master Audit File

The Cost Master Audit file contains records of additions, changes, and deletions to the Cost Master File. If a record is changed, a before change and after change are written to this file. This file is used to print the cost master audit trail report.

SCCSTFIL - Cost Master File

The Cost Master file is the main file for S/C. It contains the current, standard, and projected cost of inventory items and is used in all of the costing reports in S/C.

SCCTLFIL - S/C Setup File

The S/C Setup File contains information and defaults that determine how the S/C package operates.

SCSUMWRK - S/C Summary Work File

Progression uses the S/C Summary Work file as a general work file for applications in S/C.

SCWRK999 - S/C Work File

Progression uses the S/C Work file as a general work file for multiple applications in S/C.

Standard Product Routing (SPR) Package Data Files

The following are the Progression Standard Product Routing (SPR) package data files. These are the files that are maintained as part of the SPR package but can be used by any package that integrates with SPR. The files are shown in alphabetical order by their 8-character DOS file name.

SRCTLFIL - SPR Setup file

The SPR Setup file contains information and defaults that determine how the SPR package operates, such as operation cycle multiple, next routing number, routing audit, historical average, backflush labor, and default crew number for routing operations.

SRDTLAUD - Routing Detail Audit file

The Routing Detail Audit file contains information about additions, changes, and deletions to routings in the Routing Detail file.

SRDTLFIL - Routing Detail file

The Routing Detail file contains all operation numbers and corresponding detail type records for each item routing added through the Routing Entry application.


of 96

SRRTGAUD - Routing Header Audit file

The Routing Header Audit file contains information about additions, changes, and deletions to special, general, specific, and primary routings in the Routing Header file.

SRRTGFIL - Routing Header file

The Routing Header file contains all header information, such as description, release, revision, increase operation by, standard lot size, variable hours and fixed time, overlap percent or quantity, last change date and time, and creation date for the general and primary routings. It has header information for each item routing added through the Routing Entry application. This information is used for updating the I/M Item Master file for routing number, routing revision, and lot size.

SRWRK999 - Routing Work file

Progression uses the Routing Work file as a general work file for multiple applications in SPR.

System Manager (S/M) Package Data Files The following are the Progression System Manager Package Data Files. These are the files that are maintained as part of the System Manager package, but can be used by any package that integrates with System Manager. The files are shown in alphabetical order by their 8-character DOS file name.

COMPfile - Company Setup file

The Company Setup file is the system file that holds your company default information, such as the company name and address. 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 that have been deferred and will be printed at another time.

FIELDFIL - Form Field file

The Form Field file is not used. Progression uses many form field files that use the following naming convention ?????fld.btr.

FORMfile - Form file

The Form file is not used. Progression uses many form files that use the following naming convention ?????frm.btr.

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 activity or project tracked by the package.

PRINTCOD - Print Code file

This file is not used.


of 96

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 parameters that were used. This file also stores the default printer information.

REPTPASS - Report Passing file

The Report Passing file is a system file used for passing information between entry screens and report programs.

SPOOLCOD

The Spool Codes file contains the network spool codes options that are used to spool a report to a network printer under DOS.

SPOOLFIL - SPOOLFIL Work file

This file is not used at this time.

SQLSRCH - SQL Search file

SQL Search file.

SYACTADT - System Audit Account Audit Trail file

The System Account Audit Trail file contains information regarding any changes that 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 that 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.


of 96

SYRPTFIL - System Report file

The System Report file stores the translations for the standard Progression reports.

SYSEQCTL - Serialized Docum Control file

Sequential Forms Control file.

SYSEQHST - Serial History file

Sequential Forms History file.

SYSEQINV - Sequential History file

This file is not used at this time.

SYSMEDIA - System Media file

The System Media file contains information used by the Progression Multimedia application that is part of Flexibility. It contains information that allows the Multimedia application to link Progression item numbers to multimedia elements, such as video, pictures, sound, and AutoCAD drawings.

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 note is referenced by the note name attached to the field on the screenset and the actual contents of the field.

SYSSRCH - System Search file

The System Search file stores the defined searches used in Progression.

SYSTATES - States file

The System States file contains the state ID and state description as defined in S/M State file Maintenance.

SYSSUPDEC - Supp Declaration file

Supplemental Declaration file is used in the UK.

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.


of 96

SYTAXTRX - System Tax Transaction file

The System Tax Transaction file contains records of tax transactions.

SYTRIGGR - SYTRIGGR Work file

The SYTRIGGER file is used to control when data is converted. See the progup.wri file in your Macola root directory for more information.

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.


of 96

Progression 7.6 Package SQL Tables Assets and Depreciation (A/D) Package SQL Tables

The following are the Progression Assets and Depreciation Package SQL Tables. These are the tables that are maintained as part of the Assets and Depreciation package but can be used by any package that integrates with Assets and Depreciation. The tables are shown in alphabetical order by their SQL Table name.

FXACCWRK_SQL - Accum Depr Work table

The Accum Depr Work table is used when printing the Accumulated Depreciation Report.

FXACQAST_SQL - A/D Asset Acquisition table

The A/D Asset Acquisition table is only used by the Trx, Acquisition, Enter Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Master table. Only that acquisition data that is independent of any reporting entity is written to this table; the entity acquisition data is written to FXACQENT.

FXACQENT_SQL - A/D Asset Acquisition Entity table

The A/D Asset Acquisition Entity table is only used by the Trx, Acquisition, Enter Transactions application. It serves as a temporary storage place for acquisition information before that information is posted to the Asset Entity table.

FXAMDWRK_SQL - A/D Alternative Min Depr Work table

The Alternative Min Depr Work table is used when printing the AMD Comparison Report.

FXASTENT_SQL - A/D Asset Entity table

The A/D Asset Entity table contains permanent asset data for each reporting entity. Since information used in depreciation calculations can differ for each reporting entity, the data is kept in this table. This table 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_SQL - A/D Asset Master table

The A/D Asset Master table contains one record for each asset in the database. The Asset Master table 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 table in order to get a complete picture of the asset. Posting is done to the Asset Master table to keep it up to date. It is the main source of asset information for many reports.

FXATRWRK_SQL - Transferred Asset Work table

The Transferred Asset Work table is used when printing the Asset Transfer Report.

FXCELFIL_SQL - Ceiling Codes table

The Ceiling Codes table contains IRS limitations on the amount of depreciation that can be taken annually on certain assets. You maintain this table through A/D Setup.


of 96

FXCNGAST_SQL - A/D Asset Change History table

The A/D Asset Change History table keeps before-change and after-change asset master records. This data is then used for the asset audit trail report, the transfer register, and the Change History Report.

FXCNGENT_SQL - A/D Asset Entity Change History table

The A/D Asset Entity Change History table keeps before-change and after-change asset entity records. This data is then used for the asset audit trail report, the transfer register, and the Change History Report.

FXCTLFIL_SQL - A/D Setup table

The A/D Setup table maintains information about how the package will operate. It contains the reporting entities, Alternative Minimum Depreciation Entity and the Next Main Asset No.

FXDCGWRK_SQL - Depr Method Change Work Table

The Depr Method Change Work table is used when printing the Depreciation Method change report.

FXDEPFIL_SQL - A/D Asset Depreciation Transaction table

The Calculate Depreciation process uses the A/D Asset Depreciation Transaction table. It serves as a temporary storage place for depreciation calculations before those results are posted to the Asset Master and Entity tables. Once that posting is done, this table is purged so that it can be used again and the posted records are then stored in FXDEPHST.

FXDEPHST_SQL - Depreciation History table

The Depreciation History table contains history of all depreciation calculated and posted for each asset.

FXDEPJNL_SQL - Depr Journal Work table

The Depreciation Journal Work table is used when posting depreciation.

FXDISFIL_SQL - A/D Distribution to G/L table

The A/D Distribution to G/L table contains a record for every account distribution posted. The General Ledger package uses this table during the Post from Sub Ledger process.

FXDSPFIL_SQL - A/D Asset Disposition table

The A/D Asset Disposition table is used by the Trx, Disposition, Enter Transactions application. It serves as a temporary storage place for Disposition information before that information is posted to the Asset Master table. Once posting is done, this table is purged so it can be used again.

FXENTLST_SQL - Entity List table

The Entity List table contains a list of the entities and their descriptions. Created by the A/D Setup application to allow searches on entity number fields.

FXEXPWRK_SQL - Bonus and Expense Work table

The Bonus and Expense Work table is used when printing the Bonus and Expensed Asset report.

FXGLCWRK_SQL - Asset List by G/L Code Work table

The Asset List by G/L Code Work table is used when printing the By G/L Code Asset report.


of 96

FXIRSWRK_SQL - 4562 Report Work table

The 4562 Report Work table is used when printing the IRS 4562 Worksheet.

FXITCFIL_SQL - A/D Investment Tax Credit table

The A/D Investment Tax Credit table contains reapplied investment tax credit amounts and the dates when they were reapplied.

FXITCWRK_SQL - Investment Tax Credit Work table

The Investment Tax Credit Work table is used when printing the Investment Tax Credit Asset report.

FXMETCOM_SQL - A/D Method Comparison table

The A/D Method Comparison table is used when printing the Depreciation Method Comparison Report. It contains records entered during this application and allows you to compare the annual depreciation amounts for an item using each depreciation method to help you determine which method to use. This is a temporary table, the data is not retained in this table after the report is printed.

FXPODWRK_SQL - Unit of Production Asset Work table

The Unit of Production Asset Work table is used when printing the Units of Production Asset report.

FXPRDFIL_SQL - Period table

The Period table contains the calendar information for each entity. You set the default period code and period date ranges per entity. These dates are used by the Calculate Depreciation application.

FXPRDWRK_SQL - Detail Depr History Work table

The Detail Depr History Work table is used when printing the Deprec History Depreciation Report.

FXRUNWRK_SQL - Calculate Depr Work table

The Calculate Depr Work table is used when you run the Calculate Depreciation process.

FXSEPENT_SQL - A/D Asset Separation Entity table

The A/D Asset Separation Entity table is used by the Trx, Separation, Enter Transactions application. It serves as a temporary storage place for Separation information before that information is posted to the Asset Entity table. Once that posting is done, this table is purged so that it can be used again.

FXSEPFIL_SQL - A/D Asset Separation table

The A/D Asset Separation table is used by the Trx, Separation, Enter Transactions application. It serves as a temporary storage place for Separation information before that information is posted to the Asset Master table. Once that posting is done, this table is purged so that it can be used again.

FXTBLFIL_SQL - A/D Codes table

The A/D Codes table contains the codes used in the module such as: division code, location code, category code, and G/L codes.

FXWRKDEP_SQL - Depr Projection Work table

The Depr Projection Work table is used when printing the Depreciation Expense Projection report.


of 96

Accounts Payable (A/P) Package SQL Tables The following are the Progression Accounts Payable Package SQL Tables. These are the tables that are maintained as part of the Accounts Payable package but can be used by any package that integrates with Accounts Payable. The tables are shown in alphabetical order by their SQL Table name.

APADJTRX_SQL - A/P Open Item Adjustment Transaction table

The A/P Open Item Adjustment Transaction table 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_SQL - A/P Alternate Address table

The A/P Alternate Address table maintains the Alternate Address table information.

APBNKFIL_SQL - A/P Bank table

The A/P Bank Table contains Vendor bank information if the Globalization Kit is in use.

APCHKFLD_SQL - A/P Check Field table

The A/P Check Field Table contains the fields that you can use on the check forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

APCHKFRM_SQL - A/P Check Form table

The A/P Check Form Table contains the Progression check form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APCHKRST_SQL - A/P Check Reset table

The A/P Check Reset Table contains the standard Progression check forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

APCTLFIL_SQL - A/P Setup table

The A/P Setup table maintains information about how the package will operate.

APDISFIL_SQL - A/P Distribution to G/L table

The A/P Distribution to G/L table contains a record for every distribution posted in the Accounts Payable package. This is the table the General Ledger package uses during the Post From Sub Ledger process.

APDISWRK_SQL - A/P Distribution To G/L Work table

The A/P Distribution To G/L Work table is used to summarize the data so the A/P Distribution to G/L Report can be printed.

APIDFIL_SQL - A/P Batch ID table

The A/P Batch ID table contains all transaction Batch ID information.

APLBLFLD_SQL - A/P Label Field table

The A/P Label Field Table contains the fields that you can use on the label forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.


of 96

APLBLFRM_SQL - A/P Label Form table

The A/P Label Form Table contains the Progression label form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APLBLRST_SQL - A/P Label Reset table

The A/P Label Reset Table contains the standard Progression label forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

APOPNFIL_SQL - A/P Open Item table

The A/P Open Item table contains a record for every transaction posted. The table contains vouchers, checks, and credit memos. Transactions remain in this table until you purge the table.

APOPNHST_SQL - A/P Open Item History table

The A/P Open Item History table contains a record of every transaction posted. The transactions remain in this table until you purge the open item history table.

APRCVWRK_SQL - A/P Receiver Work table

The A/P Receiver Work table is used when processing voucher transactions attached to purchase orders.

APRECDST_SQL - A/P Recurring Voucher Distribution table

The A/P Recurring Voucher Distribution table contains the distribution records associated with the recurring voucher records. Each distribution allows an amount to be distributed to a specific account number when the transaction is posted.

APRECVCH_SQL - A/P Recurring Voucher Transaction table

The A/P Recurring Voucher Transaction table 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 in a certain amount of days (every 14 days for example).

APTRXDST_SQL - New A/P Transaction Distribution table

The New A/P Transaction Distribution table contains a record for each distribution that is associated with a transaction entered through A/P, Trx, Vouchers, Enter Transactions or Enter Unauthorized Vouchers. Each distribution record allows amounts to be distributed to specific accounts and to jobs if you activate the Use Job Numbers check box in A/P Setup.

APTRXFIL_SQL - New A/P Transaction table

The New A/P Transaction table contains a record for every transaction entered through A/P, Trx, Vouchers, Enter Transactions or Enter Unauthorized Vouchers. 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 table, A/P Open Item History table and to the A/P Distribution to G/L table.

APVENADT_SQL - A/P Vendor Audit Trail table

If you activate the Keep Vendor table Audit Trail? check box in the A/P Setup table, a record will be written for every add, change, or deletion made to the Vendor table. You can purge The A/P Vendor Audit Trail table when you print the report.


of 96

APVENDST_SQL - A/P Vendor Auto Distribution table

The A/P Vendor Auto Distribution table contains the account distributions that you can use to automatically distribute transaction amounts in A/P, Trx, Voucher, Enter Transactions and Enter Unauthorized vouchers. The A/P Vendor Auto Distribution table contains G/L Account Distributions and percentages associated with each account. The percentages must equal 100 for each vendor.

APVENFIL_SQL - A/P Vendor table

The A/P Vendor table contains a record for every vendor used in the Accounts Payable package. This is the master table for the vendor and contains the name, address, city, state, zip, and year-to-date totals.

APVENTYP_SQL - A/P Vendor Type table

The A/P Vendor Type table contains a record of default G/L accounts for each vendor type.

APWRK1FL_SQL - APWRK1FL

Progression uses the APWRK1FL table when printing the A/P Reconciliation Rpt by Journal No with Account Distribution Summary.


Progression uses the APWRK2FL table when printing the A/P Reconciliation Rpt by Journal No.


Progression uses the APWRK3FL table when printing the A/P Reconciliation Rpt by Account No.

APX99FLD_SQL - A/P 1099 Field table

The A/P 1099 Field Table contains the fields that you can use on the 1099 forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

APX99FRM_SQL - A/P 1099 Form table

The A/P 1099 Form Table contains the Progression 1099 form layouts. You can modify the forms through S/M, Maintain, Form Designer.

APX99RST_SQL - A/P 1099 Reset table

The A/P 1099 Reset Table contains the standard Progression 1099 forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

CHECKREC_SQL - A/P Check Reconciliation table

If you activate the Reconcile Checks? check box in the A/P Setup, then a record is written to the A/P Check Reconciliation table for each check that is posted. This table is used when running the reconcile checks process and printing the reconciliation report. This table can be purged through the Check Reconciliation process when printing the reconciliation report.


of 96

Accounts Receivable (A/R) Package SQL Tables The following are the Progression Accounts Receivable Package SQL tables. These are the tables that are maintained as part of the Accounts Receivable package but can be used by any package that integrates with Accounts Receivable. The tables are shown in alphabetical order by their SQL table name.

ARALTADR_SQL - A/R Alternate Address table

The Alternate Address table contains the alternate addresses for companies that you entered through maintain, alternate address. This address table is used for the shipping address in Order Entry.

ARBATFIL_SQL - A/R Batch table

The A/R Batch table contains all the transaction Batch IDs as well as the user name that entered the transactions in the batch.

ARCARCDE_SQL - A/R Carrier Code table

The A/R Carrier Code table contains the codes used for manifest shipping carriers.

ARCOMDUE_SQL - A/R Commission Due table

The Commissions Due table contains all invoices and the commission amounts calculated and posted from sales transactions, service invoices or invoices from Order Entry.

ARCOMWRK_SQL - A/R Commission Work table

Progression uses the A/R Commission Work Table to calculate commission due by cash receipts.

ARCSHAPL_SQL - Cash Application table

The Cash Application table contains a record of each invoice that has a cash receipt applied but not posted. Progression uses this table to apply and post the cash receipts to the customers’ open items for open item customers.

ARCSHTRX_SQL - Cash Transaction table

The Cash Transaction table contains a record for each check entered for each customer.

ARCTLFIL_SQL - A/R Setup table

The A/R Setup table maintains information about how the package will operate. Contains aging periods, defaults and default account numbers for posting purposes.

ARCUSADT_SQL - Customer Audit Trail table

The Customer Audit trail table contains all the additions, changes and deletions made to the Customer table.

ARCUSFIL_SQL - Customer table

The Customer table 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_SQL - Aging Report by Collector Work table

The Aging Report by Collector Work table is used to make calculations when printing the Aging Report by Collector.

ARCUSWK2_SQL - Aging Report by Parent Company Work table


of 96

The Aging Report by Parent Company Work table is used to make calculations when printing the Aging Report by Parent Company.

ARCUSWK3_SQL - Aged Customer Totals by Acct Work table

The Aged Customer Totals by Acct Work table is used to make calculations when printing the A/R Reconciliation Report by Account/Cust No.

ARCUSWK4_SQL - Tax Analysis Work table

The Tax Analysis Work table is used to make calculations when printing the A/R Tax Analysis report.

ARDISFIL_SQL - A/R Distribution to G/L table

The Distribution To G/L table contains a record for every distribution to an account made during any of the posting applications. This is the table the General Ledger uses during the post from sub ledger process.

ARDISWRK_SQL - A/R Distribution Work table

The A/R Distribution To G/L Work table is used to summarize the data so the Distribution to G/L Report can be printed.

ARDUNFLD_SQL - A/R Dunning Field table

The A/R Dunning Field table contains the fields that you can use on the dunning letter forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARDUNFRM_SQL - A/R Dunning Form table

The A/R Dunning Form Table contains the Progression Dunning letter layouts. You can modify the letters through S/M, Maintain, Form Designer.

ARDUNRST_SQL - A/R Dunning Reset table

The A/R Dunning Reset Table contains the standard Progression dunning letters, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

ARFCHTRX_SQL - A/R Finance Charge Transaction table

The Finance Charge Trx table contains a record showing the finance charge calculated for each customer against his current open balance. You can make adjustments to the finance charge amounts until you post finance charges.

ARINVFLD_SQL - A/R Invoice Field table

The A/R Invoice Field table contains the fields that you can use on the invoice forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARINVFRM_SQL - A/R Invoice Form table

The A/R Invoice Form Table contains the Progression invoice form layouts. You can modify the forms through S/M, Maintain, Form Designer.


of 96

ARINVRST_SQL - A/R Invoice Reset table

The A/R Invoice Reset Table contains the standard Progression invoice forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

ARLBLFLD_SQL - A/R Label Field table

The A/R Label Field Table contains the fields that you can use on the label forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARLBLFRM_SQL - A/R Label Form table

The A/R Label Form Table contains the Progression label form layouts. You can modify the forms through S/M, Maintain, Form Designer.

ARLBLRST_SQL - A/R Label Reset table

The A/R Label Reset Table contains the standard Progression label forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

AROPNFIL_SQL - A/R Open Item table

The A/R Open Item table contains a record for each transaction posted to a customer’s account. Invoices, checks, credit memos, debit memos, and finance charges are posted to this table. In addition to posted transactions the open item table contains records that are entered through maintain open item load.

AROPNHST_SQL - A/R Open Item History table

The A/R Open Item History table contains all records posted to a customer’s account. In addition to records that are posted, the open item history table also contains records entered through maintain, open item load. The open item history table includes records that are not included in the open item table: adjustment records created when changing records through maintain, open item load and when using the reapply transactions process.

ARPMTWRK_SQL - A/R Payment Selection Work table

The A/R Payment Selection Work table is used when selecting to apply cash to open items using the open item push button on the cash application screen.

ARRECDST_SQL - A/R Recurring Distribution table

The Recurring Distribution table contains a record for each account distribution associated with a recurring invoice.

ARRECINV_SQL - A/R Recurring Invoice table

The Recurring Invoice table contains a record for each recurring invoice entered through Trx, Recurring Sales.

ARSAWORK_SQL - A/R Sales Analysis Work table

The Sales Analysis Work table is used for printing the Sales Analysis reports by sales volume, by state and by territory. The Sales Analysis report uses information from the customer table to create these reports.

ARSELCUS_SQL - A/R Selected Customer table

The Selected Customer table is used during the printing of the Open Invoice Worksheet. It details, for each Customer, what unpaid open items are on file, what the current balance owed is on those items, and the amount of any valid discount.


of 96

ARSHOFIL_SQL - A/R Shipping Order table

The A/R Shipping Order table is used with a Manifest system and contains records of the order shipping information. This table is updated when picking tickets are printed.

ARSHTFIL_SQL - A/R Shipping Transaction table

The A/R Shipping Transaction table is used with a Manifest system and contains freight amounts for orders. This table is used to add freight amounts during the billing or manifest select processes.

ARSLMFIL_SQL - A/R Salesperson table

The Salesperson table contains a record for each salesperson. This table contains commission percentages for each salesperson by customer type and maintains sales and commission totals, period-to-date and year-to-date.

ARSLSDST_SQL - Sales Distribution table

The Sales Distribution table contains a record for each General Ledger account associated with a sales transaction record. This table contains the records until they are posted.

ARSLSTRX_SQL - A/R Sales Transaction table

The Sales Transaction table contains a record for each invoice, CR/DR memo or finance charge entered through Enter Sales Transactions. This table contains the records until they are posted.

ARSRVFIL_SQL - A/R Service codes table

The Service Codes table contains the information entered through maintain, service codes. It contains the service code and description, unit of measure, unit cost, unit price, sales account, tax information, commission information and YTD and PTD sales and cost figures. These services can be billed through Enter Service Invoices and Order Entry.

ARSRVHST_SQL - A/R Service Transaction History table

The Service Transaction History table contains posted service invoice transactions. This table is used to reprint posted service invoices.

ARSRVTRX_SQL - A/R Service Transaction table

The Service Transaction table contains all service invoices until they are posted and recurring service invoice transactions until they are deleted. This table can contain service invoices that have not been printed, service invoices that have been printed but not yet posted and recurring service invoice transactions.

ARSTMFLD_SQL - A/R Statement Field table

The A/R Statement Field Table contains the fields that you can use on the statement forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

ARSTMFRM_SQL - A/R Statement Form table

The A/R Statement Form Table contains the Progression statement form layouts. You can modify the forms through S/M, Maintain, Form Designer.

ARSTMRST_SQL - A/R Statement Reset table

The A/R Statement Reset Table contains the standard Progression statement forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.


of 96

ARTYPFIL_SQL - A/R Customer Type table

The Customer Type table contains default account numbers for transaction entry, posting and maintenance applications.

ARWRK1FL_SQL - A/R Reconciliation by Jnl No. Work table

The A/R Reconciliation by Jnl No Work table is used when printing the A/R Reconciliation by Jnl No Report.

ARWRK2FL_SQL - Acct Summary Reconciliation Work table

The Acct Summary Reconciliation Work table is used when printing the A/R Reconciliation by Jnl No Report.

ARWRK3FL_SQL - Acct Summary Rpt by Customer Work table

The Acct Summary Rpt by Customer Work table is used when printing the A/R Reconciliation by Account/Cust No Report.

ARWRK4FL_SQL - Acct Summary Rpt by Acct No Work table

The Acct Summary Rpt by Acct No Work table is used when printing the A/R Reconciliation by Account No Report.

Bank Book (B/B) Package SQL Tables The following are the Progression Bank Book Package SQL Tables. These are the tables that are maintained as part of the Bank Book package but can be used by any package that integrates with Bank Book. The tables are shown in alphabetical order by their SQL Table name.

BBADJWRK_SQL - Adjustment Transaction Work table

The Adjustment Transaction Work table is used when entering adjustments during the Reconcile Cash Account process.

BBCTLFIL_SQL - B/B Setup table

The Setup table maintains information about how the bank book package operates. It also contains the Last Transaction No and the Next Deposit No.

BBDEPFIL_SQL - B/B Deposit table

The Deposit table contains a record for each document on each deposit ticket entered through Trx, Deposits, Enter Deposits. The records remain in this table until you run the purge deposits process.

BBDEPHDR_SQL - B/B Deposit Header table

The Deposit Header table contains a record for each deposit ticket entered through Trx, Deposits, Enter Deposits. The records remain in this table until you run the purge deposits process.

BBDEPWRK_SQL - B/B Deposit Ticket Work table

The Deposit ticket work table is used when you print the deposit ticket.


of 96

BBDISFIL_SQL - B/B Distribution to G/L table

The Distribution to G/L table contains a record for every distribution to an account made during the posting of Trx, Transactions, Post Transactions. When you post the Deposits in B/B, Distributions to G/L are not posted since they are posted in A/R when you post cash receipts. This is the table that General Ledger uses during the Post from Sub Ledger process.

BBEXPCSH_SQL - Expected Cash Flow Report Work table

The Expected Cash Flow Report Work table summarizes data for the Expected Cash Flow Report.

BBIDFIL_SQL - B/B Batch ID table

The Bank Book Batch ID table contains a record for each batch ID entered through Trx, Transactions, Enter Transactions.

BBOPNFIL_SQL - B/B Open Item table

The Open Item table contains a record of each transaction to be reconciled. A flag and a reconciliation date identify reconciled records. Records are posted to the open item table through post deposits and through A/P and Payroll whenever checks are posted. You can enter records into the open item table manually through maintain, open item load.

BBRECWRK_SQL - B/B Reconciliation Work table

The B/B Reconciliation Work table is used when you print the Bank Reconciliation by Account No report.

BBSTMFIL_SQL - Bank Book Statement Balances

The Bank Book Statement Balances table contains a record for each statement balance entered through maintain statement balance. It includes the cash account, statement date, and starting and ending statement balances.

BBTRXFIL_SQL - B/B Transaction table

The Transaction table contains a record for each transaction entered through Trx, Transactions, Enter Transactions.

BBTYPFIL_SQL - B/B Trx Type table

The Trx Type table contains a record for each transaction type. The table includes a description of the type and a default distribution account.

BBWK1FIL_SQL - B/B Reconciliation Rpt by Deposit Ticket Work file 1 table

The B/B Reconciliation Rpt by Deposit Ticket Work file 1 table is used when printing the Bank Reconciliation by Deposit Ticket report.






of 96

BBWRKFIL_SQL - B/B Open Item Work file table

The B/B Open Item Work file table is used when you purge the Bank Book Open Item table.

Bill of Material (BOM) Package SQL Data Tables The following are the Progression Bill of Material Package SQL Tables. These are the tables that are maintained as part of the Bill of Material package but can be used by any package that integrates with Bill of Material. The tables are shown in alphabetical order by their SQL Table name.

BMCTLFIL_SQL - BOM Control (Setup) table

The BOM Setup table contains one record, which is the master control record for the bill of material. The default values are Audit Trail Field, which will determine whether an audit trail will be kept for all maintenance of the Product Structure table, and the description for the Product Structure user defined field table. The BOM Setup table controls the preferences concerning changing price of the Orders and whether to display or print the cost on reports and views. The BOM Setup table also sets the Next Engineering Change Number and sets the Product Structure component increments with which Progression assigns the next component in the structure.

BMENGCHG_SQL - Engineering Change table

Engineering changes for each engineering change number, parent item number and sequence number combination are maintained in the Engineering Change table until they are posted to the product structure. All information on the Engineering Processing add, change, and delete screen is stored in this table including reference designators.

BMENGHST_SQL - Engineering Change History table

The Engineering Change History table contains the same information as the engineering change table after engineering change posting occurs. The only addition to the information is the posting date and the resulting posting status of each record.

BMEXCWRK_SQL - Exclusions/Dependencies Work table

The Exclusions/Dependencies Work table is a work table that stores the selected options when a feature option is being entered.

BMEXPLWK_SQL - Parent Item Exploded Work table

The Parent Item Exploded Work table is a work table used to explode a parent item for reporting purposes. The applications that use this table are:

• Indented Bill on Material - View

• Bill of Material - Single Level Where-Used - View

• Available To Promise - Inquiry

• Forecast Consumption - Component View

BMFTRFIL_SQL - Product Feature table

The Product Feature table contains the information, which identifies all of the features of a feature type item.


of 96

BMMASRPL_SQL - Mass Replace Work table

The Mass Replace Work table is used in the mass mode of the Product Structure table Maintenance to temporarily hold the replaced records until they can be read again and added to the Product Structure table.

BMOPTEXC_SQL - Option Dependencies/Exclusions table

The Option Dependencies/Exclusions table contains the dependencies and exclusions for an individual option in relationship to the other options.

BMOPTFIL_SQL - Product Option table

The Product Option table contains the information for all options available for the features of feature type items. The content consists of the feature item number, feature number, option number, and the option item number.

BMPRDAUD_SQL - Product Structure Audit table

The Product Structure Audit table keeps track of changes to the Product Structure File Maintenance.

BMPRDCPY_SQL - Product Structure Copy Work table

The Product Structure Copy Work table is used in the copy mode of the Product Structure table Maintenance application to temporarily hold the value of the records being copied until they can be read again and added to the Product Structure table.

BMPRDRSQ_SQL - Resequence Work table

The Resequence Work table is utilized by the Resequence Component Items application. It temporarily holds information pertaining to the parent/component relationships including both the old and new sequence number during the execution of this procedure.

BMPRDSTR_SQL - Product Structure table

The Product Structure table is a main table of the Bill of Material package. It is used to define the structure of an inventory item, which is assembled from other inventory items. Each record in the Product Structure table defines the relationship between a parent and one of its components.

Currency Manager (C/M) Package SQL Tables The following are the Progression Currency Manager Package SQL Tables. These are the tables that are maintained as part of the Currency Manager package but can be used by any package that integrates with Currency Manager. The tables are shown in alphabetical order by their SQL Table name.

CMCTLFIL_SQL - C/M Setup table

The C/M Setup table maintains information about how the package operates. It contains the home currency code and default information on how to determine which dates to use to determine rates in Order Entry and Purchase Order. It also contains information as to whether rates can be overridden at transaction entry.

CMCURCOD_SQL - C/M Currency Code table

The C/M Currency Code table contains all currency codes you entered in maintain, currency code.


of 96

CMCURRAT_SQL - C/M Currency Rate table

The C/M Currency Rate table contains all currency rates you entered in maintain, currency rate.

CMPRCCST_SQL - C/M Item Cost/Price table

The C/M Item Cost/Price table contains all item cost/price entries you entered in maintain, Item Cost/Price.

CMUNRFIL_SQL - Currency Manager Unrealized Gain Loss Work table

The Currency Manager Unrealized Gain Loss Work table is used to make calculations when you print the Unrealized Gain/Loss report.

Capacity Requirements Planning (CRP) Package SQL Tables

The following are the Progression Capacity Requirements Planning (CRP) SQL tables. These are the tables that are maintained as part of the CRP package but can be used by any package that integrates with CRP. The tables are shown in alphabetical order by their SQL table name.

CRCTLFIL_SQL - CRP Setup File table

The CRP Setup File table contains information and defaults that determine how the CRP package operates. It also has historical information about each build load file.

CRDTLBL0_SQL, 1, 2, 3 - CRP Order Detail File 0, 1, 2, 3

The CRP Order Detail File 0, 1, 2, 3 table contains detail information of the build load file. Some of this information includes the order type status, and number, job number, item number, work center, department, vendor component item numbers, quantity, operation details, standard and actual hours, planned and actual burden, setup details, and if an order contains a bottle neck operation.

CRLCKFIL_SQL - CRP Locked File table

The CRP Locked File table contains the name of the file that is currently in use. When an application finished processing the build load file, it deletes the file name from this table, meaning the build load file is no longer in use.

CRLOCFIL_SQL - CRP Location File table

The CRP Location File table contains valid locations for each build load file.

CRORDBL0_SQL, 1, 2, 3 - CRP Order Header File 0, 1, 2, 3

The CRP Order Header File 0, 1, 2, 3 table contains the header information of the build load file. Some of the information is the order type, status, and number, item number and description, job number, due date, issue location, routing number, source package, and planned and actual costs.

CRTRXBL0_SQL, 1, 2, 3 - CRP Transaction File 0, 1, 2, 3

The CRP Transaction File 0, 1, 2, 3 table contains a record of changes to the orders in a build load file. This table is created each time a build load file is updated. The Visual Resource Planner, CRP Reschedule Dependent Orders, and Modify Scheduling Method applications update this table. The CRP Process Schedule Updates application processes this table.


of 96

CRTRXHST_SQL - CRP Transaction History table

The CRP Transaction History table saves the transactions that have been successfully processed through the CRP Process Schedule Updates application.

General Ledger (G/L) Package SQL Tables The following are the Progression General Ledger Package SQL Tables. These are the tables that are maintained as part of the General Ledger package but can be used by any package that integrates with General Ledger. The tables are shown in alphabetical order by their SQL Table name.

GLACTIDS_SQL - G/L ID Codes table

The G/L ID Codes table contains codes to identify G/L accounts. The account identifier is only available with the Globalization Kit.

GLACTWRK_SQL -G/L Account Work table

The G/L Account Work table is used when you print the Trial Balance by Profit Center report.

GLBALFIL_SQL - G/L Period Balance table

The G/L Period Balance table contains account balances bucketed by period. The System Period Table determines the periods. This table is updated during each posting procedure in G/L. The G/L Period Balance table provides the data to produce the trial balance in summary and financial statements.

GLBUDFIL_SQL - G/L Budget table

The G/L Budget table contains period budget amounts for multiple years and up to 99 revisions. You can print the budget amounts on financial statements and can print a list using the Reports/Graphs, Lists, Budget application.

GLCMPFIL_SQL - G/L Comparative table

The G/L Comparative table contains period comparative account amounts for any given year. Comparative amounts are updated when you perform a temporary or final year end procedure. You can print the comparative amount for prior years on financial statements and can print a list using the Reports/Graphs, Lists, Comparative application.

GLCMPRSF_SQL - G/L Compression Work table

The Compress G/Ledger Trx table process uses the G/L Compression Work table.

GLCTLFIL_SQL - G/L Setup table

The G/L Setup table maintains information about how the package will operate and the default retained earnings account number.

GLDISASC.DAT - G/L ASCII Interface file

The G/L ASCII Interface file is an ASCII text file you can create outside of Progression to post transactions to the General Ledger Transaction table. The file must be created in accordance with the file layout and must reside in your data directory to be posted using the post from sub ledger process.


of 96

GLDISTCD_SQL - G/L Distribution Code table

The G/L Distribution Code table contains the automatic distribution codes that you associate with your G/L accounts. Up to 999 distributions may be specified for any distribution code.

GLENTITY_SQL - G/L Entity table

The G/L Entity table contains a record for each financial entity you set up in Maintain, Entities. A financial entity is defined as a set of profit centers and/or departments. Each entity is defined by up to 36 different ranges (or individual) profit centers and/or departments.

GLEXCEPT_SQL - G/L Exception Work table

The G/L Exception Work table is a temporary table used to print the Exception Report.

GLFSPASS_SQL - G/L Financial Statement Passing table

The G/L Financial Statement Passing table is a work table used to pass the essential data needed to print financial statements. This data is not layout, specification, or account specific; it contains data for all layouts, specifications, and accounts.

GLGENTRX_SQL - General Journal Transaction table

The General Journal Transaction table contains journal entries made through Trx, General Journal, Enter Transactions. This table also contains the distributions posted from sub ledger if you activate the Interface to G/L Journal Trx Table in G/L Setup. These entries are posted to the General Ledger Transaction table when you post transactions.

GLIDFIL_SQL - G/L Batch ID table

The G/L Batch ID table contains a record of Batch ID’s entered in Trx, General Journal, Enter Transactions and Trx, Recurring Journal, Enter Transactions. It contains information regarding the batch id, number of transactions in the batch and the balance of the batch.

GLINFTAB_SQL - G/L Inflation Table table

The G/L Inflation Table table contains the factors used to calculate the impact of monthly inflation. This table is only available with the Globalization Kit.

GLLAYOUT_SQL - Layout table

The Layout table 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 the codes and accounts that define which accounts will appear on the financial statement.

GLPASFLS_SQL - G/L Passing Flag Work table

The G/L Passing Flag Work table is used when a post from Sub Ledger process is not completed. It displays a message indicating that the previous posting was not completed when you attempt to post from sub-ledger again.

GLRECBAL_SQL - Recurring Running Balance table

The Recurring Running Balance table contains two pieces of information: the balance of the transaction amounts for all the records currently in the Recurring Journal Transaction table (this amount must be zero for the transactions to post), and the last date that recurring records were posted to the General Ledger Transaction table.


of 96

GLRECTRX_SQL - Recurring Journal Transaction table

The Recurring Journal Transaction table contains records for each recurring journal transaction entered through Trx, Recurring Journal, Enter Transactions. When these transactions are posted, one record is created in the General Ledger Transaction table for every record in this table 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_SQL - Statement Specifications table

The Statement Specifications table contains records associated with how you have defined the financial statements to print in Edit Statement Specs (Standard or Custom Financials). This table is used with the Statement Layout table to print the financial statements. 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_SQL - G/L Source Reference table

The G/L Source Reference table contains source notes that can be attached to a transaction at G/L transaction entry time.

GLTRXFIL_SQL - G/L Transaction table

The G/L Transaction table contains a record for every transaction posted to the General Ledger, either through Post from Sub Ledger, Trx, General Journal, Post Transactions or Trx, Recurring Journal, Post Transactions. This is the main transaction table for G/L. The trial balance in detail uses this table.

GLTRXHST_SQL - G/L History Trx table

Every update to the GLTRXFIL will also update the G/L History Trx table. Used for drill down capabilities.

GLTXTFIL_SQL - G/L Text table

Each text record can have up to 30 lines of 75 characters, which may be printed on a financial statement. These text records will print on the financial statement when you enter the TEXT layout code and the Text No. in Maintain, Statement Layout, Edit.

GLXREFIL_SQL - G/L Cross Reference table

The G/L Cross Reference table contains information used for the Source Cross Reference Report.

RESEQWRK_SQL - Resequence Work table

The Resequence Work table is used when you resequence a statement layout.

SFLAYOUT_SQL - Source and Allocation of Funds Layout table

The Source and Allocation of Funds Layout table is a work table that is used by the generate SAF Statement process. It contains records originating from a selected balance sheet layout and creates an SAF layout in the G/L Layout table.

STMNTWRK_SQL - G/L Statement Work table

The G/L Statement Work table is used only for the printing of financial statements. Balances are calculated for all accounts and stored in this table.


of 96

Manufacturing System (HZ) Package SQL Tables The following are the Progression Manufacturing System SQL Tables. These are the tables that are maintained as part of the Manufacturing shared applications but can be used by any package that uses the Manufacturing shared applications . The tables are shown in alphabetical order by their SQL Table name.

HZBAI999_SQL - Buyer/Planner/Item table

Manufacturing Buyer Analyst Work table (Not used).

HZCDEFIL_SQL - Manufacturing Codes table

The Manufacturing Codes table contains records for the valid codes entered in the manufacturing packages. It includes records for the following codes: crew, department, equipment type, indirect labor, incentive pay codes, labor grade, labor cost type, job type, scrap code, and win/loss.

HZCRWFIL_SQL - Manufacturing Crew File table

The Manufacturing Crew File table stores the crew members assigned to each crew.

HZCTLFIL_SQL - Manufacturing Setup table

The Manufacturing Setup table contains global information and defaults that determine how the Progression manufacturing packages operate.

HZCTRACT_SQL - Work Center Account table

The Manufacturing Work Center Account table stores the information entered in the Work Center Account Group application.

HZCTRCAP_SQL - Work Center Capacity table

The Manufacturing Work Center Capacity table 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_SQL - Work Center table

The Work Center table contains information about work centers, production lines, and work cells used in a manufacturing environment.

HZCTRMCH_SQL - Work Center Machine table

The Manufacturing Work Center Machine table stores the information entered during Work Center Maintenance on the Work Center Machine screen. It includes the department, work center, machine number, labor factor, and whether or not the machine is considered critical to the work center.

HZEMPAUD_SQL - Mfg Employee Audit table

The Mfg Employee Audit table is the audit trail maintained to keep track of changes to your employees. Activating the Employee Audit File? check box in Manufacturing Setup maintains an audit trail of changes to employee records and allows you to run the Mfg Employee Audit Trail Report to show any changes you have made to your employee records. You can purge the Mfg Employee Audit file as part of the printing process of the Mfg Employee Audit Trail Report. If this check box is activated, Progression will also create add and change records in the Mfg Employee Audit file for employee records imported using one of the Copy Payroll applications, as it would if they had been added manually in Manufacturing Employee Maintenance.


of 96

HZEMPPER_SQL - Mfg Employee table

The Manufacturing Employee table holds the employee information entered in the Progression Manufacturing packages. This file also includes any employees imported from your payroll package.

HZEQPFIL_SQL - Equipment table

The Manufacturing Equipment table stores the tool and machine records entered in the Tool Master Maintenance or Machine Master Maintenance applications. The equipment type information is stored in the Manufacturing Codes table.

HZERNFIL_SQL - Mfg Earnings Code File table

The Mfg Earnings Code File table contains the manufacturing earnings code records that you entered in the Manufacturing Earnings Code Maintenance application. These records also contain the associated payroll earnings code.

HZMCOFIL_SQL - MRP-CRP Orders table

The MRP-CRP Orders table contains 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 or) 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

1 = What If 1 file

2 = What If 2 file

3 = What If 3 file

4 = Results of Last Full Regeneration.

HZNOTFIL_SQL - Manufacturing Notes table

The Manufacturing Notes table contains all notes entered using the Manufacturing Global Notes screen. This table stores the package id and document type along with the note. For example, selecting the Notes push button from the shop order header will link any notes entered on the Manufacturing Global Notes screen to that specific shop order header record. This information is then stored in the Manufacturing Notes table and is available in any package that displays this shop order header information.

HZNOTHST_SQL - Manufacturing Notes History table

Manufacturing Note History table.

HZOCFIL_SQL - Manufacturing Operation Code table

The Manufacturing Operation Code table stores the operation code records entered in the Operation Code Maintenance application.

HZPLPFIL_SQL - Product Load Profile table

The Product Load Profile table is a master table containing all pertinent information by Item for each work center it can run on. This information is used by the Master Scheduling (M/S) package.

HZPPVFIL_SQL - Purchase Price Variance table

Manufacturing PPV table.


of 96

HZPRELOD_SQL - SFC Preload File table

HZ Preload File table.

HZRPTCAL_SQL - Reporting Calendar table

The Reporting Calendar table contains the data that defines the period ending dates for the reporting periods (buckets) of various reporting calendars.

HZSHPCAL_SQL - Shop Calendar Header table

The Shop Calendar Header table contains the data that defines shop open/closed days.

HZSHPDTL_SQL - Shop Calendar Detail table

The Shop Calendar Detail table contains a record for every calendar day. The records contain the number of hours the shop is open on a specific day, along with the day of the week (Mon, Tue, etc.), and flags indicating whether the day is open in MRP and/or SFC.

Inventory Management (I/M) Package SQL Tables The following are the Progression Inventory Management Package SQL Tables. These are the tables that are maintained as part of the Inventory Management package but can be used by any package that integrates with Inventory Management. The tables are shown in alphabetical order by their SQL Table name.

IMALLRST_SQL - Inventory Allocation Reset Table

The Inventory Allocation Reset Table is a permanent table used as a processing reference. Once this table is populated, it is only referenced by I/M.

IMATPFIL_SQL - ATP Summary Table

The ATP Summary Table is created on the fly for ATP drill-down views.

IMATPORD_SQL - ATP Orders Table

The ATP Orders Table is created on the fly for ATP drill-down views.

IMBATFIL_SQL - Inventory Batch Table

The Inventory Batch Table contains all transaction batch IDs and their user names.

IMBINTRX_SQL - Bin Transaction Table

The Bin Transaction Table contains a record for each transaction entered through inventory transaction processing that has a batch number assigned to it. This table contains the history for all allocations, receipts, transfers, and issue records related to bins.

IMCAPBLD_SQL - Feature Option Capture Table

The Feature Option Capture table stores feature option configurations for estimates from Quoting and Estimating and orders from Web.Orders.


of 96

IMCAPHST_SQL - Feature Option Capture History Table

The Feature Option Capture History table stores feature option configurations for estimates from Quoting and Estimating and orders from Web.Orders, once the estimate or order has been pushed to history.

IMCATFIL_SQL - Product Category Table

The Product Category Table 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 you to choose which category you want to print.

IMCNTDTE_SQL - Physical/Cycle Count Date Table

The Physical/Cycle Count Date Table contains a record for each date that either a physical or cycle count was performed.

IMCTLFIL_SQL - Inventory Setup Table

The Inventory Setup Table contains information about how the I/M package will operate. This table contains all the defaults for the I/M system, including cost method, warehouse, inventory asset account, serial/lot processing options, and bin processing options.

IMDISFIL_SQL - Account Distribution Table

The Account Distribution Table, or I/M Distribution to G/L Table, contains a record for every distribution posted in the I/M package. The General Ledger (G/L) application uses this table to during the Post From Sub Ledger application.

IMINVAUD_SQL - Item Location Audit Table

The Item Location Audit Table contains a record for every addition, deletion, and change to the Item Location Table.

IMINVBIN_SQL - Bin Master Table

The Bin Master Table The Bin Master Table contains a record for each bin item.

IMINVHST_SQL - Inventory History Table

The Inventory History Table contains all period to date accumulators, by period number, for 24 periods. The Clear I/M Accumulators application updates this table.

IMINVLOC_SQL - Inventory Location Table

The Inventory Location Table contains a record for each item that is located at an inventory location other than the default location. This table contains records entered through Inventory Location Maintenance.

IMINVTRX_SQL - Inventory Transaction Table

The Inventory Transaction Table contains all history for allocations, receipts, issues, and transfers.

IMITMADT_SQL - Item Master Audit Table

The Item Master Audit Table contains a record for every addition, deletion, and change to the Item Master Table.


of 96

IMITMIDX_SQL - Item Master Table

The Item Master Table contains a record for items entered through Item Master Maintenance.

IMITMNOT_SQL - Item Note Table

The Item Note Table contains notes related to a specific item that you can print on different documents.

IMITMSRT_SQL - Reset Item Location Allocated Quantity Table

The Reset Item Location Allocated Quantity Table is a work table used when generating the Reset Allocations report.

IMITMTXT_SQL - Item Text Table

The Item Text Table contains multiple lines of text related to an item note.

IMKITFIL_SQL - Kit Master Table

The Kit Master Table contains data similar to the BOM Product Structure Table. The kit parent item is just like a bill of material parent, except the end item code must be "K". The kit parent contains components (whose end item code are not "K"). The kit parent has only one level of components (a single level bill).

IMLFMST_SQL - LIFO/FIFO Master Table

The LIFO/FIFO Master Table contains layer records for each inventory item/location, including quantity and cost.

IMLFTRX_SQL - LIFO/FIFO Transaction Table

The LIFO/FIFO Transaction Table contains a record for each transaction that occurred for the LIFO/FIFO Master Table.

IMLOCFIL_SQL - Location Master Table

The Location Master Table contains a record for each valid warehouse location and its description.

IMLSMST_SQL - Serial/Lot Master Table

The Serial/Lot Master Table contains a record for each serial and lot number.

IMLSTRX_SQL - Serial/Lot Transaction Table

The Serial/Lot Transaction Table contains a record for each transaction entered through Inventory Transaction Processing with a serial or lot 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_SQL - Material Cost Type Table

The Material Cost Type Table contains a record for each valid material cost type and its description.

IMORDBLD_SQL - Order Build Table

The Order Build Table contains information about all options selected for the features of feature items during order entry. This table contains feature item number, option number, and item number. This table also contains components of kit items entered in order entry.


of 96

IMORDHST_SQL - Order Build History Table

The Order Build History Table contains records from the Order Build Table that were deleted due to posting.

IMRECHST_SQL - Receiving History Table

The Receiving History Table contains records from all receipts in purchase order receiving, receiving inspection, and material review.

IMREQWRK_SQL - Gross Requirements Table

The Gross Requirements Table is the work table used when creating the Kit Gross Requirements report.

IMREVWRK_SQL - POP Roll Back Work Table

The POP Roll Back Work Table is a work table used as a numbered work file for POP in a non-transaction tracking process.

IMSUBITM_SQL - Substitute Item Table

The Substitute Item Table contains a record for each substitute item and the inventory item with which it is associated.

IMTAGFIL_SQL - Inventory Tag Table

The Inventory Tag Table contains current Physical/Cycle Count Tag Information.

IMTAGHST_SQL - Tag History Table

The Tag History Table contains a record of all Physical/Cycle Count Tags.

IMTAGSUB_SQL - Serial/Lot Tag Table

The Serial/Lot Tag Table is used when processing a physical count.

IMTRXDST_SQL - Transaction Distribution Table

The Transaction Distribution Table contains a record for each distribution record that pertains to specific transactions. Each distribution record allows amount to be distributed to specific accounts and jobs.

IMTYPLOC_SQL - Cost Type/Location Account Table

The Cost type/Location Account Table contains a record of cost types within a specific warehouse to keep track of inventory cost by material cost type for that location. O/E uses this table to post the correct cost of each item to the inventory asset account. This table also contains the purchase price variance account, which A/P may use when the expected cost of an item is not the same as the actual cost.

PRELOAD_SQL - Pre-Processing Work Table

The Pre-Processing Work Table is used to preload POP Bin/Serial/Lot data.


of 96

Labor Performance (L/P) Package SQL Tables The following are the Progression Labor Performance (L/P) SQL tables. These are the tables that are maintained as part of the L/P package but can be used by any package that integrates with L/P. The tables are shown in alphabetical order by their SQL table name.

LPCCAUD_SQL - L/P Clock Card Audit table

The L/P Clock Card Audit table contains information about additions, changes, and deletions in the Clock Card Trx table.

LPCCEXP_SQL - L/P Clock Card Exception table

The L/P Clock Card Exception table contains incomplete or invalid records that have been created by the import applications. Use the edit exceptions applications to correct these transactions. Use the reprocess exceptions applications to move them to the clock card file.

LPCCHST_SQL - L/P Clock Card History table

The L/P Clock Card History table contains a history of all clock cards used by the system after they have been moved from the clock card file during the Update Payroll application.

LPCCTRX_SQL - L/P Clock Card Trx table

The L/P Clock Card Trx table contains all transactions entered though the Enter Clock Card Transactions application. This information is used for validating labor transactions.

LPCTLFIL_SQL - L/P Setup File table

The L/P Setup File table contains information and defaults that determine how the L/P package operates.

LPERNAUD_SQL - L/P Earnings Audit table

The L/P Earnings Audit table contains information about additions, changes, and deletions to records in the L/P Earnings table.

LPERNFIL_SQL - L/P Earnings table

The L/P Earnings table contains all L/P Payroll Earnings information before interfacing with Payroll or exporting earnings information to an ASCII file. The Generate Earnings application populates this table. This table can be edited before it is interfaced with Payroll or before it is exported to an ASCII file. Adjustments made to direct labor transactions through the Enter Earnings Transactions application are not made to the corresponding transactions in MCA or SFC.

LPERNHST_SQL - L/P Earnings History table

The L/P Earnings History table contains a history of all transactions used to Payroll. L/P writes this table as the Update Payroll application runs and records are moved from the Earnings table.

LPSFTFIL_SQL - L/P Shift table

The L/P Shift table contains information defining each work shift such as start and end, meal, and break times. This file also defines shift differential pay. It is used while entering clock cards and labor transactions and while calculating earnings.

LPTRXAUD_SQL - L/P Transaction Audit table

The L/P Transaction Audit table contains information about additions, changes, and deletions to records in the L/P Transaction table.


of 96

LPTRXEXP_SQL - L/P Transaction Exception table

The L/P Transaction Exception table contains labor transactions imported from an ASCII file where the system is missing information to update master files. These transactions are viewed as exceptions that may be edited through the edit exceptions applications to correct missing information. After this information is corrected, master tables are updated with the reprocess exceptions applications.

LPTRXFIL_SQL - L/P Transaction table

The L/P Transaction table contains labor transactions used for generating payroll transactions by the Generate Earnings application. After the Update Payroll application is run, L/P moves the transactions to the Transaction History table. These transactions are posted to Shop Floor Control and Manufacturing Cost Accounting as they are entered.

LPTRXHST_SQL - L/P Transaction History table

The L/P Transaction History table contains labor transactions from the L/P Transaction table that have been updated to payroll.

LPWRK999_SQL - L/P Work table

The L/P Work table is used as a general work file for multiple applications in L/P.

Manufacturing Cost Accounting (MCA) Package SQL Tables

The following are the Progression Manufacturing Cost Accounting (MCA) SQL tables. These are the tables that are maintained as part of the MCA package but can be used by any package that integrates with MCA. The tables are shown in alphabetical order by their SQL table name.

MCCRWFIL_SQL - MCA Crew Transaction File table

The MCA Crew Transaction File table contains the unposted records of shop floor activity transactions relating to direct labor cost by employee number. The wage rate and direct cost information is associated with a job/shop order/operation number combination.

MCCRWHST_SQL - MCA Crew History File table

The MCA Crew History File table contains the posted records of shop floor activity transactions relating to direct labor cost by employee number. The wage rate and direct cost information is associated with a job/shop order/operation number combination.

MCCTLFIL_SQL - MCA Setup table

The MCA Setup table contains information and defaults that determine how the MCA package operates.

MCDISFIL_SQL - MCA Distribution to G/L table

The MCA Distribution to G/L table contains a record for every distribution to an account made during posting. This is the table that the G/L package uses during the Post From Sub Ledger application.

MCJOBAUD_SQL - MCA Job Audit File table

The MCA Job Audit File table contains information about additions, changes, and deletions to jobs in the Job Master File table.


of 96

MCJOBFIL_SQL - MCA Job Master File table

The MCA Job Master File table maintains planned and actual cost information about jobs. This table provides data about the value of work in process and cost analysis figures.

MCTRXFIL_SQL - MCA Transaction File table

The MCA Transaction File table updates the Job Master File table with planned or actual data about jobs. Entering miscellaneous costs and cost adjustments adds information in this table. Reporting activity against shop orders in Shop Floor Control also adds information to this table.

MCTRXHST_SQL - MCA Transaction History File table

The MCA Transaction History File table provides a history of what activity has been posted against jobs in the Job Master File table. It is also used to print the Job Transaction History Report. MCA adds information to this table when the Post Activity Transactions application is run.

MCWRK999_SQL - MCA Work File table

The MCA Work File table is used as a general work table for multiple applications in MCA.

Material Requirements Planning (MRP) Package SQL Data Tables

The following are the Progression MRP Package SQL Tables. These are the tables that are maintained as part of the MRP package but can be used by any package that integrates with MRP. The tables are shown in alphabetical order by their SQL Table name.

MRCPOFIL_SQL - Computer Planned Orders table

The Computer Planned Orders table is used during Material Requirements Regeneration to store information about the computer-planned orders that the regeneration process determines are necessary. The contents of this table along with the contents of the Low Level table are used to create the MRP Requirements table.

MRCTLFIL_SQL - MRP Setup table

The MRP Setup table contains setup information that control how the MRP package functions.

MRETFFIL_SQL - Explosion table

The Explosion table is 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 table, it is used as if it were a table with the relative record number corresponding to the table’s index. The table is dynamically created as needed.

MREXPFIL_SQL - MRP Exceptions table

The MRP Exceptions table is used to hold the MRP Exceptions information. This table 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 come from this table.


of 96

MRITMFIL_SQL - MRP Item table

The MRP Item table contains MRP quantity on hand At MRP locations and the amounts for each process used (full regen, what if, or net change). This replaces the Item Master table when calculating and storing quantity on hand at MRP locations as a preliminary step of the regeneration process.

MRLOCFIL_SQL - MRP Location table

The MRP Location table is used to store locations used for full regeneration, net change, and what if analysis. You can change which locations to include for full regeneration and what if analysis as runtime parameters. The results of your selection are stored in this table, 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_SQL - Low Level Work table

The Low Level Work table is used to temporarily hold the Low Level record generated by the VMS Cobol Sort utility. This table is opened and closed automatically by the sort utility in MRRGLWLV table.

MRLWLFIL_SQL - Low Level table

The Low Level table is used to hold information needed during the MRP regeneration, net change, or what if analysis process.

MRORDFIL_SQL - Order Table table

The Order Table table is used to store information about the item currently being processed in the MRP regeneration, net change, and what if analysis programs. The table is created dynamically as needed.

MRPEGFIL_SQL - Pegging table

The Peg table is used to hold the information needed to peg lower level requirements back to requirements at a higher level. This table is rebuilt during the MRP regeneration, net change, or what if process. It is a linked list of requirements and orders.

MRPEGWFL_SQL - Pegging Work table

The Peg Work table is used to initially hold the information needed to peg lower level requirements back to requirements at a higher level. This table 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 table.

MRREQFIL_SQL - MRP Requirements table

The MRP Requirements table is used to hold detailed information for the MRP package. This is the primary table, which is recreated whenever an MRP regeneration application or an MRP What If application is run. Most of the data on reports in the MRP package come directly or indirectly from this table. The requirements information in this table is by exact due date (bucketless format). This table is also used in the Master Schedule package in the Transactions, Master Schedule, Merge Orders application. The Merge Orders functions to merge computer planned orders from this table into the master schedule.

MRSPCITM_SQL - Special Item table

The Special Item table is used to hold information on items that are on shop orders or purchase orders but were not found on the Inventory Item table during the last MRP regeneration or what if analysis. Note that all items in the Special Item table are considered to be low level code zero items, even if they are found in shop order parent/component relationships.


of 96

MRVPW999_SQL - Purchase By Vendor Work table

The Purchase By Vendor Work table is used as a work table to collect vendor purchase request data in the order needed for printing the Purchase Request by Vendor Report.

MRWRK999_SQL - MRP Work File table

The MRP Work File table is used as a work table to storing data.

Master Scheduling (M/S) Package SQL Tables The following are the Progression M/S Package SQL Tables. These tables are maintained as part of the M/S package, but can be used by any package that integrates with M/S. The tables are shown in alphabetical order by their SQL Table name.

MSCTLFIL_SQL - Master Schedule Setup table

The Master Scheduling Setup table contains the master setup record for the M/S package. The setup record determines the default ATP/forecast calendars, the start/end of period method for consuming forecast orders, the next M/S order number, and the minimum probability code used for O/E quotes. The set up record also contains flags for displaying safety stock with beginning inventory and orders before the current period on M/S Reports and Views. This table also contains the default order types to purge and merge in the Master Schedule Merge application.

MSFRCFIL_SQL - Forecast Orders table

The Forecast Orders table contains information concerning sales forecast orders. This information may be copied from other forecast orders or added through Sales Forecast maintenance entry as needed. Information in this table is used for forecast consumption on reports, views, and O/E Post Invoices.

MSPCWFIL_SQL - Period Capacity Work table

The Period Work Capacity table is a temporary work table used to help produce the Rough Cut Capacity Report. This table collects scheduled load data by period from Report/Shop calendars and the Product Load Profile.

MSSCHFIL_SQL - Master Schedule table

The Master Schedule table contains the detail information for Master Scheduled Orders. This information may be added through Master Scheduling Maintenance Entry or merged from customer orders, production orders, forecast orders, purchase orders, shop orders, or copied from previous master schedules. This is the primary table that may be merged into MRP for Rough Cut Capacity ATP.

MSWRK999_SQL - Master Schedule Work File table

The Master Schedule Work File table is a temporary work table used for sorting, sequencing, and storing data when creating some reports and views in M/S, such as the Master Schedule Report, the What If Comparison By Detail Report, and the Forecast Consumption View. This table is also used to perform some M/S transactions, such as Copy Master Schedule and Purge Master Schedule.


of 96

Order Entry (O/E) Package SQL Data Tables The following are the Progression Order Entry Package SQL Tables. These are the tables that are maintained as part of the Order Entry package but can be used by any package that integrates with Order Entry. The tables are shown in alphabetical order by their SQL Table name

OEACKFLD_SQL - Acknowledgement Field table

The Acknowledgement Field table contains the fields that you can use on the Acknowledgement Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEACKFRM_SQL - Acknowledgement Form table

The Acknowledgement Form table contains the Progression Acknowledgement Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEACKRST_SQL - Acknowledgement Reset table

The Acknowledgement Reset table contains the standard Progression Acknowledgement Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OEBBWRK_SQL - OEBBWRK Work table

Bank Book Work table.

OEBOLFIL_SQL - Bill of Lading table

The Bill of Lading table contains the customer shipping information for the bill of lading.

OEBOLORD_SQL - Bill of Lading Order table

The Bill of Lading Order table contains all customer orders related to a bill of lading.

OECARCDE_SQL - Carrier Code table

The O/E Carrier Code table identifies carrier and mode codes for the ship-via types in the A/R Ship-Via table.

OECMTCDE_SQL - Comment Code table

The Comment Code table stores the user-defined information associated with the code that can be displayed in the order header shipping instructions.

OECMTHST_SQL - Comment History table

The Comment History table stores the user-defined information associated with the code that can be displayed in the order header shipping instructions.

OECSHFIL_SQL - O/E Cash table

The O/E Cash table contains records of cash transactions from order entry transactions, such as prepayments or down payments.

OECTLFIL_SQL - O/E Setup table

The O/E Setup table contains default codes and allows the user to customize the package to their specific needs.


of 96

OECUSITM_SQL - Customer Item table

The Customer Item table contains relationships between your item numbers and the item numbers your customers use for the same items.

OEFBOAUD_SQL - Back Order Audit Trail table

The Back Order Audit Trail table stores changes to the Order Line Item table as a result of filling backorders.

OEFRMFIL_SQL - Form table

The Form table contains information on the forms used in O/E.

OEHDRAUD_SQL - Order Header Audit Trail table

The Order Header Audit Trail table contains a record of any changes made to the order header records.

OEHDRHST_SQL - O/E Header History table

When order entry transactions are posted, they are written to the Order Header History table.

OEHSTPRD_SQL - Sales History Period table

The Sales History Period table is used during the Post Invoices to A/R tables so that the sales journal will print in document number order.

OEINQORD_SQL - Order View Master table

Order Entry View Order Master table

OEINVBAT_SQL - Invoice Batch ID Work table

Invoice Batch ID Work table

OEINVFLD_SQL - Invoice Field table

The Invoice Field table contains the fields that you can use on Invoice Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEINVFRM_SQL - Invoice Form table

The Invoice Form table contains the Progression Invoice Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEINVRST_SQL - Invoice Reset table

The Invoice Reset table contains the standard Progression Invoice Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OELADFLD_SQL - Bill of Lading Field table

The Bill of Lading Field table contains the fields that you can use on the Bill of Lading Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.


of 96

OELADFRM_SQL - Bill of Lading Form table

The Bill of Lading Form table contains the Progression Bill of Lading Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OELADRST_SQL - Bill of Lading Reset table

The Bill of Lading Reset Table contains the standard Progression Bill of Lading Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OELBLFLD_SQL - Label Field table

The Label Field table contains the fields that you can use on the Label Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OELBLFRM_SQL - Label Form table

The Label Form table contains the Progression Label Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OELBLRST_SQL - Label Reset table

The Label Reset Table contains the standard Progression Label Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OELINAUD_SQL - Order Line Audit Trail table

The Order Line Audit Trail table holds a record of any changes made to the order line items.

OELINCMT_SQL - Order Line Comment table

The Order Line Comment table holds both item notes and comments for order line items.

OELINHST_SQL - Order Line History table

When order entry transactions are posted, the line item records are written to the Order Line History table.

OELSTRXS_SQL - Serial Lot Trx table (Not Used)

Serial Lot Trx table (Not Used).

OEOPTHST_SQL - Option History table

For future use.

OEORDDTL_SQL - Order View Detail Work table

Order Detail Work table (Not Used).

OEORDHDR_SQL - Order Header table

The Order Header table contains general information for each order entered such as order number, billing and shipping information and salesperson information. This table contains the first screen of information in Order Entry including added, changed and delete orders.


of 96

OEORDLIN_SQL - Order Line Item table

The Order Line Item table contains information concerning each item that is entered on an order. This table contains information that is entered on the second screen in Order Entry including added, changed, and deleted orders.

OEORDREL_SQL - Order Release table

The Order Release table is used with blanket orders. This table holds all the releases for each line item.

OEPAKFLD_SQL - Packing Field file

The Packing Field table contains the fields that you can use on the Packing Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEPAKFRM_SQL - Packing Form table

The Packing Form table contains the Progression Packing Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEPAKRST_SQL - Packing Reset table

The Packing Reset table contains the standard Progression Packing Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OEPIKFLD_SQL - Picking Field table

The Picking Field table contains the fields that you can use on the Picking Forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEPIKFRM_SQL - Picking Form table

The Picking Form table contains the Progression Picking Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEPIKRST_SQL - Picking Reset table

The Picking Reset table contains the standard Progression Picking Forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OEPRCFIL_SQL - Price Codes table

The Price Codes table stores the various pricing methods that have been defined in the Price Code Table Maintenance. During the entry of orders, Progression checks this table to find prices for individual line items on the order. If Progression finds a price code that matches the order, it will use the price in the price code table, otherwise, Progression uses the price in the Inventory Item table.

OEPRDACT_SQL - Product Category Account table

The Product Category Account table identifies a product category with its associated warehouse location and sales and cost of goods sold account numbers.

OEPREPAY_SQL - Prepayment table

The Prepayment table stores payment information for orders marked as O/E Cash, including information entered on the Order Entry Prepayment screen.


of 96

OEQTEFLD_SQL - Quote Field table

The Quote Field table contains the fields that you can use on Quote forms. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

OEQTEFRM_SQL - Quote Form table

The Quote Form table contains the Progression Quote form layouts. You can modify the forms through S/M, Maintain, Form Designer.

OEQTERST_SQL - Quote Reset file

The Quote Reset table contains the standard Progression Quote forms, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

OERDTFIL_SQL - RMA Detail table

Return Material Authorization (RMA) Detail table stores the RMA line item information for the RMAs entered.

OERDTHIS_SQL - RMA Detail History table

Return Material Authorization (RMA) Detail History table stores the RMA line item information for the RMAs entered and closed.

OERHDFIL_SQL - RMA Header table

Return Material Authorization (RMA) Header table stores the RMA customer information for the RMAs entered.

OERHDHIS_SQL - RMA Header History table

Return Material Authorization (RMA) Header History table stores the RMA customer information for the RMAs entered and closed.

OESHPLDT_SQL - Ship Lead Time table

The Ship Lead Time table 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_SQL - Sales History table

The Sales History table stores sales information by customer and item number for each period defined in the Sales History Period table. This table is used to produce all of the Sales Comparison Reports.

OEWRK1FL_SQL - Order Entry Work table

The Order Entry Work file is used when running the O/E Reconciliation Report.


of 96

Production Order Processing (POP) Package SQL Tables

The following are the Progression Production Order Processing Package SQL Tables. These are the tables that are maintained as part of the Production Order Processing package but can be used by any package that integrates with Production Order Processing. The tables are shown in alphabetical order by their SQL Table name.

PPADVWRK_SQL - Production Order Advice Work table

Work table used to create the Production Order Advice Report.

PPCMTHST_SQL - Production Comment History table

Contains the history comments from completed POP orders.

PPCSTCAP_SQL - Production Captured Cost table

Contains information on the captured costs for each production order.

PPCSTFIL_SQL - Value Added Cost Type table

Maintains product structure costs with description, rate, and account.

PPCSTSTR_SQL - Product Structure Cost table

Maintains product structure cost components per BOM product structure parent.

PPCSTTRX_SQL - Product Structure Cost Trx table

Contains records of transactions for product structure costs.

PPCTLFIL_SQL - POP Setup table

Contains master setup record for the Production Order Processing package.

PPEXPLWK_SQL - Explode Work table

Used for the explosion of bills of material used by POP.

PPFRMFIL_SQL - POP Form table

POP Form table.

PPLINCMT_SQL - Production Comment table

Contains the comments associated with the lines of POP orders.

PPORDAUD_SQL - Production Order Audit table

Maintains an audit trail of production orders, including all additions, changes, and deletions of production orders.

PPORDFIL_SQL - Production Order table

Contains information for each production order entered.


of 96

PPORDFLD_SQL - Production Order Field table

The Production Order Field table contains the fields that you can use on the Progression POP Form layouts. You can modify which fields can be used through S/M, Maintain, Form Field Maintenance.

PPORDFRM_SQL - Production Order Form Work table

The Production Order Form table contains the Progression POP Form layouts. You can modify the forms through S/M, Maintain, Form Designer.

PPORDRST_SQL - Production Order Reset Work table

The Production Order Reset table contains the standard Progression POP Form layouts, which can be used to reset modified forms to the original forms through S/M, Maintain, Form Maintenance, Reset Form.

PPORDTRX_SQL - Production Order Trx table

Contains information on the transactions associated with each production order.

PPRCNCWK_SQL - POP Reconciliation Work table

POP Reconciliation Work table.

Purchase Order and Receiving (P/O) Package SQL Tables

The following are the Progression Purchase Order and Receiving SQL Tables. These are the tables that are maintained as part of the Purchase Order and Receiving package but can be used by any package that integrates with P/O. The tables are shown in alphabetical order by their SQL Table name.

POBUYLCK_SQL - RFQ Buyer Lock Table

The RFQ Buyer Lock Table is used to allow only one user at a time to access each buyer/planner record for RFQ applications that create purchase orders.

POCOMCDE_SQL - Commodity Code Table

The Commodity Code Table is a work table used to sort vendor commodity code data for the Commodity Code Vendor Report.

POCOMFIL_SQL - Line Item Comments Table

The Line Item Comments Table contains all comment code information for each purchase order.

POCONFIL_SQL - Requisition Consolidation Table

The Requisition Consolidation Table contains a record of the individual requisitions that make up each consolidated requisition. Requisition line items marked for consolidation that have the same item, location, and buyer are grouped with other requisitions into a consolidated requisition with the Consolidate By Period application. Requisition line items that are not marked for consolidation are written to this table once they are saved on the Requisition Entry screen. A record from this table is purged once you create a purchase order based on that consolidated requisition.


of 96

POCONHST_SQL - Consolidated Requisition History Table

The Consolidated Requisition History Table contains a record of consolidated requisitions that have been deleted or purged. This table records the individual requisitions which make up the consolidated requisition. Once you delete a consolidated requisition or create a purchase order based on a consolidated requisition, that consolidated requisition record is moved into this history table.

POCSHREQ_SQL - Cash Requirements Table

The Cash Requirements Table is a work table used to sort scheduled receivings into order by date for each vendor number to produce the Cash Requirements Projection Report.

POCTLFIL_SQL - P/O Setup Table

The P/O Setup Table contains system default information for the entire package. This table contains information from the P/O Setup application.

POHDRAUD_SQL - P/O Header Audit Table

The P/O Header Audit Table contains a record of any changes made to order header records.

POHDRHST_SQL - P/O Header History Table

The P/O Header History Table is created when purchase orders are printed and updated when purchase orders are purged.

POINSAUD_SQL - Receiving Inspection Audit Table

The Receiving Inspection Audit Table contains audit records from receiving inspection and disposition processing.

POINSHDR_SQL - Receiving Inspection Header Table

The Receiving Inspection Header Table contains a record for each receiver processed against purchase orders for every item requiring inspection.

POITMVND_SQL - Item Vendor Table

The Item Vendor Table keeps track of which vendors provide which items and which items are available from which vendors. The vendor's item number is stored for each item/vendor relationship and used to print the Item Vendor report. The information in this table is also available in other P/O applications, so the user can identify a Progression item number from a vendor number and vendor item number.

POIVAUD_SQL - Item Vendor Audit Table

The Item Vendor Audit Table is used for item vendor maintenance.

POLINAUD_SQL - P/O Line Item Audit Table

The Line Item Audit Table contains a record of any changes made to purchase order line items.

POLINHST_SQL - P/O Line History Table

The Line History Table contains historical data about line items on deleted purchase orders, which is used to print the Line Item History Report.


of 96

POLNDCST_SQL - Landed Cost Master Table

The Landed Cost Master table contains all the landed cost codes used in P/O.

POORDHDR_SQL - P/O Header Table

The P/O Header Table stores general information about each purchase order. The Header is how purchase orders are identified. This table contains information entered on the Purchase Order Entry screen.

POORDLIN_SQL - P/O Line Item Table

The Line Item Table contains information about each item entered on a purchase order. This table contains information entered on the Line Item screen during Purchase Order Entry.

POPRPVEN_SQL - Prospective Vendor Table

The Prospective Vendor table contains records for vendors to whom you can send requisitions. This table contains a cross reference to the A/P Vendor record if the vendor exists in A/P.

POPURCST_SQL - P/O Landed Cost Table

The Landed Cost Table contains landed cost information for purchase order line items.

POQTEHDR_SQL - Quote Header Table

The Quote Header Table is created when you create quotes based on consolidated requisition records.

POQTELIN_SQL - Quote Line Table

The Quote Line Table contains line item information about requests for quotes sent to vendors. This table is created from the Vendor Pre-Quote Table when you run the Create Quotes application.

POQTELVL_SQL - Quote Cost Level Table

The Quote Cost Level Table contains a list of quote amounts and corresponding passwords. When creating a quote, you must enter the appropriate password based on the amount on the quote.

POQTEPRE_SQL - Vendor Pre-Quote Table

The Vendor Pre-Quote table contains information used to generate vendor requests for quotes. This table contains information about the consolidated requisition record for which you are requesting a quote, and the vendor you to whom you will send the quote request.

POQTHDHS_SQL - Quote Header History Table

The Quote Header History Table contains a record of quotes that have been deleted or those from which a purchase order was generated.

POQTLNHS_SQL - Quote Line History Table

The Quote Line History Table contains a record of individual line items for quotes that have been deleted or those from which a purchase order was generated.


of 96

PORQHDHS_SQL - Requisition Header History Table

The Requisition Header History Table contains a record of requisition header information for requisitions that have been deleted or purged. The requisition header information is entered through the Requisition Entry screen and contains data common to all the requisition line items. Once a requisition is deleted or a purchase order is created based on that requisition, the header information for that requisition is moved to this history table.

POREQHDR_SQL - Requisition Header Table

The Requisition Header Table contains general information that applies to all line items in the requisition.

PORQLNHS_SQL - Requisition Line History Table

The Requisition Line History Table contains a record of requisition line items that have been deleted or purged. A record is purged form this table when the corresponding requisition record is deleted or a purchase order is generated based on the requisition.

POREQLIN_SQL - Requisition Line Table

The Requisition Line Table contains line items for purchase order requisitions entered in the Requisition Entry screen. You can edit requisition line items until the requisition is consolidated. A record from this table is purged once you create a purchase order based on that requisition.

POSHPFIL_SQL - Ship-To Table

The Ship-To Table contains codes for all addresses where you can send inventory. If there are multiple locations for a single address, there should be a Ship-To record for each of these locations.

POTRXDST_SQL - Transaction Distribution Table

The Transaction Distribution Table contains distributions for each receipt transaction. This table updates IMDISFIL during posting, giving IMDISFIL records a "purchased" code. Valid records are deleted from the POTRXDST table during posting. This table can be changed/deleted before posting.

POTRXFIL_SQL - P/O Transactions Table

The P/O Transactions table contains all history for purchase order and receipt transactions.

Quoting and Estimating (Q/E) Package Data Files Note: With the release of Progression 7.5.103f, Quoting and Estimating is a Progression SQL only package. You can only use Q/E if you are running in a SQL environment.

The following are the Progression Quoting and Estimating (Q/E) package SQL Tables. These are the tables that are maintained as part of the Q/E package but can be used by any package that integrates with Q/E. The tables are shown in alphabetical order by their SQL Table name.

QECNFFIL_SQL - Estimate Configuration File table

The Estimate Configuration File table contains personalized layout information for the Estimate Entry screen.


of 96

QECTLFIL_SQL - Q/E Setup table

The Q/E Setup table maintains information about how the package will operate. It also contains defaults for order location, issue locations, terms code, type, ship via code, tax codes, tax schedule, and salesperson number.

QECUSAUD_SQL - Prospective Customer Audit File table

This table is not used at this time.

QECUSFIL_SQL - Prospective Customer File table

The Prospective Customer File table contains a record for each prospective customer. It maintains contact information for each prospect.

QEDTLAUD_SQL - Estimate Detail Audit File table


QEDTLHST_SQL - Estimate Detail History File table


QEESTAUD_SQL - Estimate Header Audit File table


QEESTDTL_SQL - Estimate Detail File table

This Estimate Detail File table contains estimate detail information, such as operations, materials, overhead, tools, and outside processes for each estimate entered.

QEESTFIL_SQL - Estimate Header File table

This Estimate Header File table contains header information for each estimate entered.

QEESTHST_SQL - Estimate Header History File table


QEESTITM_SQL - Estimate Item File table

This Estimate Item File table contains information from the Items spreadsheet on the Estimate Entry screen for each item.

QEITMAUD_SQL - Estimate Item Audit File table


QEITMHST_SQL - Estimate Item History File table


QENOTFIL_SQL - Estimating Notes File table

This Estimating Notes File table contains all notes entered on the Estimate Entry screen. This table stores the document type along with the note.


of 96

QENOTHST_SQL - Estimating Notes History File table


QEQTYAUD_SQL - Q/E Quantity Break Audit File table


QEQTYFIL_SQL - Q/E Quantity Break File table

This Q/E Quantity Break File table contains quantity break information for each line item on each estimate.

QEQTYHST_SQL - Quantity Break History File table


Shop Floor Control (SFC) Package SQL Tables The following are the Progression Shop Floor Control (SFC) SQL tables. These are the tables that are maintained as part of the SFC package but can be used by any package that integrates with SFC. The tables are shown in alphabetical order by their SQL table name.

SFBUYERP_SQL - SFC Buyer Lock File table

The SFC Buyer Lock File table is used to prevent multiple users from processing the same shop order at the same time.

SFCTLFIL_SQL - SFC Setup table

The SFC Setup table contains information and defaults that determine how the SFC package operates.

SFDTLAUD_SQL - SFC Detail Audit File table

The SFC Detail Audit File table contains information about additions, changes, and deletions to shop orders in the SFC Order Detail File table.

SFDTLFIL_SQL - SFC Order Detail File table

The SFC Order Detail File table maintains all detail information for each shop order created. This table contains six types of records for each shop order: operation, material, tool, outside process, parallel start, and parallel end.

SFORDAUD_SQL - SFC Order Audit File table

The SFC Order Audit File table contains information about additions, changes, and deletions to shop orders in the SFC Order Header table.

SFORDFIL_SQL - SFC Order Header File table

The SFC Order Header File table maintains all header information for all shop orders. This also includes planned cost information specifically related to shop orders.

SFSHTFIL_SQL - SFC Shortage File table

The Shop Floor Shortage File table contains information concerning all shortages of materials for Shop Orders that exist on the Shop Floor.


of 96

SFWRK999_SQL - SFC Work File table

The SFC Work File table is used as a general work table for multiple applications in SFC.

Standard Costing (S/C) Package SQL Tables The following are the Progression Standard Costing (S/C) SQL tables. These are the tables that are maintained as part of the S/C package but can be used by any package that integrates with S/C. The tables are shown in alphabetical order by their SQL table name.

SCCSTAUD_SQL - Cost Master Audit table

The Cost Master Audit table contains records of additions, changes, and deletions to the Cost Master table. If a record is changed, a before change and after change are written to this table. This table is used to print the cost master audit trail report.

SCCSTFIL_SQL - Cost Master table

The Cost Master table is the main table for S/C. It contains the current, standard, and projected cost of inventory items and is used in all of the costing reports in S/C.

SCCTLFIL_SQL - S/C Setup table

The S/C Setup table contains information and defaults that determine how the S/C package operates.

SCSUMWRK_SQL - S/C Summary Work File table

The S/C Summary Work File table is used as a general work table for applications in S/C.

SCWRK999_SQL - S/C Work File table

The S/C Work File table is used as a general work table for multiple applications in S/C.

Standard Product Routing (SPR) Package SQL Tables

The following are the Progression Standard Product Routing (SPR) SQL tables. These are the tables that are maintained as part of the SPR package but can be used by any package that integrates with SPR. The tables are shown in alphabetical order by their SQL table name.

SRCTLFIL_SQL - SPR Setup table

The SPR Setup table contains information and defaults that determine how the SPR package operates, such as operation cycle multiple, next routing number, routing audit, historical average, backflush labor, and default crew number for routing operations.

SRDTLAUD_SQL - Routing Detail Audit table

The Routing Detail Audit table contains information about additions, changes, and deletions to routings in the Routing Detail File table.


of 96

SRDTLFIL_SQL - Routing Detail File table

The Routing Detail File table contains all operation numbers and corresponding detail type records for each item routing added through the Routing Entry application.

SRRTGAUD_SQL - Routing Header Audit table

The Routing Header Audit table contains information about additions, changes, and deletions to special, general, specific, and primary routings in the Routing Header File table.

SRRTGFIL_SQL - Routing Header File table

The Routing Header File table contains all header information, such as description, release, revision, increase operation by, standard lot size, variable hours and fixed time, overlap percent or quantity, last change date and time, and creation date for the general and primary routings. It has header information for each item routing added through the Routing Entry application. This information is used for updating the I/M Item Master table for routing number, routing revision, and lot size.

SRWRK999_SQL - Routing Work File table

The Routing Work File table is used as a general work table for multiple applications in SPR.

System Manager (S/M) Package SQL Tables The following are the Progression System Manager Package SQL Tables. These are the tables that are maintained as part of the System Manager package, but can be used by any package that integrates with System Manager. The tables are shown in alphabetical order by their SQL table name.

COMPfile_SQL - Company Setup table

The Company Setup table 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_SQL- Defer Report File table

The Deferred Report File table contains entries of all reports that have been deferred and will be printed at another time.

FIELDFIL - Form Field table

The Form Field table is not used. Progression uses many form field tables that use the following naming convention ?????fld_SQL.

FIELDTBL_SQL

FieldTBL_SQL represents the data in Field.ddf. Field.ddf is used in Progression SQL search and form maintenance.

FileTBL_SQL

FileTBL_SQL represents the data in File.ddf. File.ddf is used in Progression SQL search and form maintenance.


of 96

FORMfile - Form table

The Form table is not used. Progression uses many form tables that use the following naming convention ?????frm_SQL.

INDEXTBL_SQL

IndexTBL_SQL represents the data in Index.ddf. Index.ddf is used in Progression SQL search and form maintenance.

JOBfile_SQL - Job File table

The Job File table contains a record for each activity or project tracked by the package.

JOBHIST_SQL - Job History File table

The Job History File table contains a record for each activity or project tracked by the package.

PRINTCOD_SQL - Print Code table

This table is not used.

PRINTDFT_SQL- Print Defaults File table

The Print Defaults File table 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 parameters that were used. This table also stores the default printer information.

REPTPASS_SQL - Report Passing File table

The Report Passing File table is a system table used for passing information between entry screens and report programs.

SPOOLCOD_SQL - Spool Codes File table

The Spool Codes File table contains the network spool codes options that are used to spool a report to a network printer under DOS.

SPOOLFIL_SQL - SPOOLFIL Work table


SQLSRCH - SQL Search table

SQL Search table.

SYACTADT_SQL - System Acct Audit Trail table

The System Acct Audit Trail table contains information regarding any changes which have been made to the System Account File table by username, date, and time.

SYACTFIL_SQL - System Account File table

The System Account File table contains the chart of accounts for all Progression packages.


of 96

SYCDEFIL_SQL - System Codes File table

The System Codes File table contains ship via codes, terms codes, buyer/planner codes, etc. for the A/P and A/R packages.

SYCSHFIL_SQL - System Cash Acct File table

The System Cash Acct File table contains all valid Cash Accounts which can be used in Progression.

SYHSTLIN_SQL - Tax History Line File table

The System Tax History File Line table contains records of tax transaction history line items.

SYJNLHST_SQL - Journal History File table

Each time you perform a posting for any package, Progression assigns a journal number to the posting run and stores the grand totals for that posting run in the Journal History File table.

SYPRDFIL_SQL - System Period File table

The System Period File table 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.

SYRPTFIL - System Report File table

The System Report File table stores the translations for the standard Progression reports.

SYSEQCTL_SQL - Serialized Docum Control table

Serialized Docum Control table.

SYSEQHST_SQL - Serial History File table

Serial History File table.

SYSEQINV - Sequential History table


SYSMEDIA - System Media table

The System Media table contains information used by the Progression Multimedia application that is part of Flexibility. It contains information that allows the Multimedia application to link Progression item numbers to multimedia elements, such as video, pictures, sound, and AutoCAD drawings.

SYSMESSG - System Message table

The System Message table contains generic exception messages used to identify errors that prevent posting to live Progression files. The contents of this table are pre-loaded by Macola. The standard System Manager Message Maintenance application is used to modify these messages.

SYSNOTES_SQL - System Notes Files table

The System Notes Files table contains all notes that are entered using the notes button that is attached to certain fields in the system. The note is referenced by the note name attached to the field on the screenset and the actual contents of the field.


of 96

SYSTATES_SQL - States File table

The States File table contains the state ID and state description as defined in S/M State File Maintenance.

SYSSUPDEC_SQL- Supp Declaration File table

The Supplemental Declaration File table is used in the UK.

SYTAXHST_SQL - Tax History File table

The Tax History File table contains a history record of each tax code used in conjunction with tax schedules.

SYTAXLIN_SQL - Tax Transaction Line File table

The Tax Transaction Line File table contains records of tax transaction line items.

SYTAXTRX_SQL - Tax Transaction File table

The Tax Transaction File table contains records of tax transactions.

SYTRIGGR_SQL - System Trigger File table

The System Trigger File table is used to control when data is converted. See the progup.wri file in your macola root directory for more information.

TAXDETL_SQL - Tax Detail File table

The Tax Detail File table contains records of all tax detail codes.

TAXSCHED_SQL - Tax Schedule File table

The Tax Schedule File table 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.


of 96

package data files and sql tables -...

Documents