Overnight check programs run nightly to maintain the integrity of the database files. The system runs as many of the check programs as possible in the allotted time. If the system is unable to run all of the programs in the allotted time, it picks up where it left off on the next day.
The CHECK.AR1 program checks the integrity of the indexes in the AR (Accrual Register) file, which contains summary information for closed ledger transactions, such as sales invoices, received purchase orders, cash receipts postings, accounts payable invoices, and completed branch transfers.
The CHECK.ASUB program checks the integrity of the data in the AR (Accrual Register) file, which contains summary information for closed ledger transactions, such as sales invoices, received purchase orders, cash receipts postings, accounts payable invoices, and completed branch transfers.
Note: Run the CHECK.ASUB program before running the CHECK.GLT program.
The CHECK.CCLOG program deletes records older than 60 days from the CC.LOG (credit card log) file.
The CHECK.ENTD program checks the integrity of the ENTITY.DYNAM file, which contains records of all open, bid, and lot orders for specific entities. This program can update or delete records; it does not add new records.
Note: The CHECK.LED2 program makes sure all open generations have an entry in the ENTITY.DYNAM file.
The CHECK.ETRX program checks the integrity of the ENTITY.ETRX file, which contains commissions, costs, totals, and sales for dollar entity transactions.
The CHECK.FDEF program checks the data in the FILE.DEFINE file and ensures that child/parent relationships are valid.
The CHECK.GLT program checks the integrity of the data in the GENLED.TRANS file, which is a summary file of all the G/L accounts broken down by JLI (journal) type.
Note: Run the CHECK.ASUB program before running the CHECK.GLT program.
The CHECK.JLI program checks the integrity of the JLI index on the AR file.
Note: Run the CHECK.JLI program before running the CHECK.GLT program.
CHECK.LED1 is the first of three programs that check the integrity of the LEDGER file. Use the CHECK.LED1 program to add missing A/R records. The program reads through the file and checks to see if the dependant A/R and JRL items are in sync.
The CHECK.LED2 program checks the integrity of future ledger issues in the LEDGER file.
The program rebuilds history in the PSUB file, as determined by the Number Of Years Sales In PSUB File control maintenance record, if necessary.
Note: Run the CHECK.LED2 program before running the CHECK.PRDD or CHECK.PSUB programs.
The CHECK.LED3 program checks the LEDGER file for internal balancing of branch, COGS, dollar, and total COGS amounts.
The CHECK.MATRIX program checks the integrity of the records in the MATRIX file, including combo group issues.
The CHECK.MSGS program purges old received messages, as determined by the number of days entered in the Days Before Messages Purged control maintenance record.
The CHECK.ORDERQ program checks the validity of the records in the Order Queue records.
The CHECK.PID.TABLE program checks the integrity of the process IDs in the EPID (Eclipse Process IDs) file.
The CHECK.PLOC checks the integrity of product inventory locations in the PROD.LOCS file.
The CHECK.PRDD checks the integrity of product locations and on-hands in the future ledger.
Note: Run the CHECK.LED2 program before running the CHECK.PRDD program.
The CHECK.PRDS program compares the contents of the PROD.SERIAL file, which stores serial numbers, to the PROD.DYNAM file which stores the serial numbers for each product and the onhand for each serial number.
Note: Run the CHECK.LED2 program, then the CHECK.PRDD program, then the CHECK.PRDS program.
The CHECK.PRICE-GRP program checks the integrity of price lines referenced by buy and sell groups in the PRICE-GRP file.
The CHECK.PRINTQ program checks the integrity of the data for printing invoices in the PRINT.QUEUE file.
The CHECK.PRINTRVW program checks the integrity of the data for printing shipping tickets in the PRINT.REVIEW file.
The CHECK.PROCURE program checks the integrity of procurement data.
The CHECK.PROD.FAMI program checks the integrity of data in the PROD.FAM (product families) file.
The CHECK.PRODUCT program checks the integrity of data in the PRODUCT file, including the price line, buy line, order sequence, and sort.
The CHECK.PSUB program checks the integrity of product sales history in the PSUB file and removes excess history, as determined by the Number Of Years Sales In PSUB File control maintenance record.
Note: Run the CHECK.LED2 program before running the CHECK.PSUB program.
The CHECK.PUIFILE program checks the integrity of the PU.IDX file, which holds the UPC and user-defined cross-references for products.
The CHECK.REPORTS program checks for documents that need to be deleted and removes them from the REPORTS file and the &HOLD& file, as determined by the Minimum Days Before Report Purge control maintenance record.
The CHECK.WHSEQ program checks the integrity of the data in the Replenishment and Warehouse Queues.
See Also: