Legler Systems Company | DB Menu | Contact Us | Help | Home |

Database Control System Menu

The latest version of the Database Control System menu by Legler Systems in CA identifies 18 separate database control (DB) computer procedures plus three procedures (9x) common to all accounting applications that can be run by the user, provided the user has access to these online procedures. Access control to the Database Control application is specified in the User Control Record (DB08). Each end-user procedure shown on the DB menu corresponds to a separate computer program.

Any online database control procedure is started at any time from the DB Menu Screen by entering a 2-digit procedure number or single-click on the procedure name with the mouse. For all DB inquiry and reporting procedures, a selection screen is displayed so the user can enter various data selection parameters to retrieve specific data records from the online Master File and to format the output, including a report sort option. Reporting procedures print information in hardcopy DB reports on letter-size paper, while inquiry procedures display information in a results screen. Active keyboard function keys are shown at the bottom of all DB screens.

DB Menu Screen:

 ------------------------------------------------------------------------------
|        Database Control System Menu  (2017)            TST    01-09-14 16:09 |
|==============================================================================|
|                                                                              |
| No     Procedure Name                  No     Procedure Name                 |
| --   --------------------------------  --   -------------------------------  |
| 01 - Enter Code Definition Record      11 - Load And Print Support Files     |
| 02 - Print Code Definitions Report     12 - Print User Defined Report        |
| 03 - Enter Company Control Record      13 - Print User Activity Report       |
| 04 - Query Global Control Record       14 - Inquire Active Users             |
| 05 - Dump Master File To History       15 - Print Transaction Audit Report   |
| 06 - Restore Master File From History  16 - Inquire Pending Batch Requests   |
| 07 - Print Master File Records         17 - Enter General Notes Record       |
| 08 - Enter User Control Record         18 - Process Import/Export Data       |
| 09 - Print User Control Report         92 - Redefine System Printer          |
| 10 - Print Company Control Report      94 - Search DB System                 |
|                                        96 - Inquire Latest DB Changes        |
|                                        99 - End DB Menu                      |
|                                                                              |
|    Enter DB Procedure Number......[    ]                                     |
|                                                                              |
|                                                                              |
|                  Dashboard 1 - Number of Data Records Changed                |
|             ----------------------------------------------------             |
|              10 |                                               |            |
|               9 |                                               |            |
|               8 |-----------------------------------------------|            |
|               7 |                                               |            |
|               6 |-------------------XX--------------------------|            |
|               5 |                   XX                          |            |
|               4 |-------------------XX--------------------------|            |
|               3 |                XX XX                          |            |
|               2 |----------------XX-XX-XX-----------------------|            |
|               1 |                XX XX XX XX                    |            |
|             ----|---|-------------------------------------------|            |
|              MO | 01 01 01 01 01 01 01 01 01 01 12 12 12 12 12  |            |
|              DA | 10 09 08 07 06 05 04 03 02 01 31 30 29 28 27  |            |
|              YR | 14 14 14 14 14 14 14 14 14 14 13 13 13 13 13  |            |
|                                                                              |
|                   Total transactions = 12 (3 per day)                        |
|                                                                              |
|==============================================================================|
|F1=Help  F2=Enter F9=Print F10=Exit                       Dashboard=F4/F5/F6  |
|                                                                              |
 ------------------------------------------------------------------------------

Real-Time Database Control Dashboard:

One of four different real-time transaction dashboards for database Control System are displayed below the DB Menu Screen depending on the Dashboard-ID setting in procedure DB08. Dashboard 1 displays a bar chart of the number of data records changed for the last 15 days, last 15 months or last 15 years. Dashboard 2 displays a bar chart of the number of data records deleted for the last 15 days, last 15 months or last 15 years over a specific dollar amount set in procedure DB08. Function key F4 key is used to switch between days, months or years. Dashboard 3 displays a list of the latest Code Definition Records changed in DB01. Dashboard 4 displays a list of the latest data records deleted. To toggle between these four real-time transaction dashboards, use function key F5 (back) or F6 (forward).

A Report History Dashboard is displayed under the data selection parameters for all DB end-user procedures except data entry procedures DB01, DB03, DB04, DB08, DB17 and DB18. The last 12 runs are shown in the Report History Dashboard. The display of the Report History Dashboard is determined by the setting of the Dashboard-ID field in procedure DB08. To review a detail activity report of all prior runs, run procedure DB13 with a Report Option of "P".

DB01 - Enter Code Definition Record:

Data entry procedure DB01 is used to enter a master record for each major code referenced by one or more accounting applications. Each code is defined by a Code-Type and Code number. For example, GL account codes have a Code-Type of "AC" and a Code number of "600" for revenue. The user can add new Code Definition Records (DB01) as required. If any information for GL account codes is changed, the corresponding Account Master Record (GL19) in the General Ledger System is also updated. To view a sample Code Definition screen, click DB01 screen.

DB02 - Print Code Definition Report:

Report procedure DB02 prints the Code Definition Report documenting the codes referenced in all accounting systems and for operator verification. Selected codes for a specific Code-Type are printed in the Code Definition Report (DB02). The Code Definition Report for Code-Type of "AC" can be referenced to manually lookup a GL account code. To view a sample of the DB02 data selection prompts and DB report, click DB02 screen.

DB03 - Enter Company Control Record:

Data entry procedure DB03 is used to update basic accounting control information, such as the current accounting period (YRMO), current entry period, system options and other important data. Generally, this procedure is run at least once a month to change the accounting period and dates. A separate Company Control Record (DB03) can be set up for each System-ID, if required. Computer procedure DB03 is run at the beginning of the month. To view a sample Company Control screen, click DB03 screen.

DB04 - Query Global Control Record:

Query procedure DB04 is used to temporarily change the file definitions and some system options, such as transaction logging. Only supervisory personnel should have access to procedure DB04. Computer procedure DB04 is rarely executed.

DB05 - Dump Master File To History:

Update procedure DB05 copies data records from the online indexed sequential Master File (DBSMST) to a backup sequential History File (DBSHST). The Dump Control Report printed by procedure DB05 contains record counts for audit documentation along with the elapsed execution time in seconds. Multiple database record transactions are processed at one time. Only supervisory personnel should perform procedure DB05.

DB06 - Restore Master File From History:

Update procedure DB06 copies data records from the backup sequential History File (DBSHST) to the online indexed sequential Master File (DBSMST). The Restore Control Report printed by procedure DB06 contains record counts for audit documentation along with the elapsed execution time in seconds. Multiple database record transactions are processed at one time. Only supervisory personnel should perform procedure DB06.

DB07 - Print Master File Records:

Report procedure DB07 prints the Database Records List containing all fields in the selected master records. Data records in the Database Records List (DB07) can be shown in character format or hex format. In addition, data records in the Transfer File can be printed. Generally, the Database Records List (DB07) is referenced by the programming staff. A separate Database Records Summary report can be requested and printed to monitor record counts by type of data record.

DB08 - Enter User Control Record:

Data entry procedure DB08 is used to define the users that are to have access to various procedures within each accounting application. Some users may be setup with only query capability, while others have full update capability. Only supervisory personnel should have access to procedure DB08. Other key options set for each user include screen color codes (background screen color and foreground screen color), override some edit errors, display real-time dashboards (Dashboard-ID field), screen color codes for the online Help Window (background screen color and foreground screen color), display dollar sign ($) in dollar amount fields and set the default printer assignment. The background screen color code cannot equal the foreground screen color code. The online Help Window is displayed whenever function key F1 is pressed by the user. To view a sample User Control screen, click DB08 screen.

DB09 - Print User Control Report:

Report procedure DB09 prints the User Control Report listing all users and the procedures they have access to execute for audit documentation. This report is a backup document of data entered in procedure DB08. Only supervisory personnel should have access to the User Control Report (DB09). A copy of the User Control Report should be filed with the company's financial papers for audit documentation.

DB10 - Print Company Control Report:

Report procedure DB10 prints the Company Control Report containing all information in each Company Control Record for audit documentation and provides backup documentation. Information in the User Control Report is from data entered online by procedure DB03. Only supervisory personnel should have access to the Company Control Report. A copy of the Company Control Report (DB10) should be filed with the company's financial papers for audit documentation.

DB11 - Load and Print Support Files:

Update procedure DB11 loads three indexed sequential support files: (1) Screen definition file (DBSFMT), (2) Online Help file (DBSHLP) and (3) Program definition file (DBSPGM). Any time changes are made to the source text files associated with these indexed files, procedure DB11 must be run to load those changes. In addition, procedure DB11 is used to print various management reports from these online support files. Computer procedure DB11 can be run at any time. The DBS Control Report printed by procedure DB11 contains the results of running this procedure for audit documentation along with the elapsed execution time in seconds or minutes.

DB12 - Print User Defined Report:

Report procedure DB12 is a generalized report writer for data mining, where the user tests specific data fields and defines the content of the User Defined Report (data fields). Any data in the online master database can be selected, sorted and printed in the User Defined Report (DB12). Alternatively, findings can be displayed on the results screen. Computer procedure DB12 can be performed at any time. A separate User Defined Summary report can be requested and printed.

DB13 - Print User Activity Report:

Report procedure DB13 prints the User Activity Report containing the computer procedures the user executed and when for audit documentation. The User Activity Report (DB13) is used to monitor the procedures a user performed and when. The elapsed execution time is computed in either seconds or minutes for each and every procedure run by any user and is printed in the User Activity Report. The elapsed execution time covers the time between starting a procedure and when it ends, including the time it takes to enter in data selection parameters. The elapsed execution time printed at the end of control reports refers to the CPU time after the prompts have been entered. A separate User Activity Summary report can be requested and printed.

DB14 - Inquire Active Users:

Inquiry procedure DB14 displays a results screen of active users who are signed on the financial system. Also, all users defined by procedure DB08 can be displayed. This DB end-user procedure can be run at any time to display active users. Procedure DB14 supports dynamic linking to the DB08 screen when function key F7 is pressed. To view a sample of the DB14 data selection prompts and output results screen, click DB14 screen.

DB15 - Print Transaction Audit Report:

Report procedure DB15 prints the Transaction Audit Report identifying all deleted records from the online Master File for audit documentation. Also, any changes to an online data record can be printed in the Transaction Audit Report (DB15), provided the transaction logging feature is set in procedure DB04. Computer procedure DB15 can be done at any time.

DB16 - Inquire Pending Batch Requests:

Inquiry procedure DB16 displays a results screen of current batch report requests entered online with an "Entry Correct" equals "B". These batch report requests (generally long reports) are automatically processed by the Jobs.bat script when the user signs-off the financial system. Computer procedure DB16 is optional.

DB17 - Enter General Notes Record:

Data entry procedure DB17 is used to enter comments, instructions, text or special notes on customers (AR01), vendors (AP01), customer orders (OE01), products (OE09), mailing names (ML01) and Bill-To/Ship-To names (OE19). The hot key (function key F7) in various accounting modules can easily load procedure DB17 to enter new special notes or view existing "NOTES". Computer procedure DB17 can be started at any time. The Note-ID field in the General Notes Record identifies the source data record associated with the special notes.

DB18 - Process Import/Export Data:

Procedure DB18 reads (imports) a PC Text File of comma separate values (csv) containing data records to reformat and write them to the import Transfer File for subsequent processing by other online accounting procedures that edit and add these records to the online master database. For example, procedure AP13 in the AP System processes this import Transfer File of vendor transactions to edit and add them to the online master database.

Procedure DB18 writes (export) a PC Text File of comma separate values (csv) containing data fields extracted from the online master file. This export PC Text File can be imported into a spreadsheet program, such as MS Excel. The DBS Control Report is printed for audit documentation and includes the elapsed execution time in seconds.

DB92 - Redefine System Printer:

Redefine system printer procedure DB92 allows the user to redefine where management reports are to be printed. If a disk file is specified, the DB report is written to a disk file from which it can be displayed in a pop-up report window (92V) and then printed on paper by pressing function key F9. The computer program DBS892 associated with procedure DB92 is the same for all accounting modules. Computer procedure DB92 can be done at any time.

DB94 - Search DB System:

Search procedure DB94 is used to search the DB System for any dollar amount, code value or text in the last x months and display a results screen of the search results along with the database record counts searched and found. Both lowercase letters and uppercase letters are tested to identify a match. The computer program DBS894 associated with procedure DB94 is the same for all accounting modules. This DB end-user procedure can be started at any time to lookup any database information, such as code names, text descriptions and dates.

DB96 - Inquire Latest DB Changes:

Inquiry procedure DB96 displays a list of the latest Code Definition Records (DB01) or User Control Records (DB08) in descending chronological sequence by date and time. The computer program DBS896 associated with procedure DB96 is the same for all accounting modules. This online procedure can be started at any time to identify the most recent changes in the DB System.

DB99 - End DB Menu:

Exit procedure 99 ends the Database Control System menu and displays the main Financial Menu. To switch directly to a different accounting procedure, just enter the System-ID plus procedure number, such as AP10, rather than three entries: 99 (end DB), AP (menu) and 10 (Inquire Vendor Status).

More Information on the DBS Software:

The DBS Procedure Manual provides complete written user documentation of over 200 pages about all user procedures of the Database Control System software by Legler Systems. The DBS Systems Manual describes the technical aspects of the database application programs and is included with the cobol source programs (optional). In addition to the written documentation, the online Help File of all text and error messages is included with the DBS executable programs. These online messages are only displayed in a separate Help Window whenever function key F1 is pressed.

For additional information on the DBS software and a free CD-ROM demo for Microsoft Windows XP, e-mail Bill Legler in the SF Bay Area, California or go to the Database Control System main page.

Version 11.7 (2017). All rights reserved by Legler Systems Company.