ProfitPress Mega CDROM2 Shareware Freeware (MSDOS)(1992)(Eng)

home *** CD-ROM | disk | FTP | other *** search

/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / APPS / DAYO / DAYOYE.ZIP / DAYOYE.EXE / DAYOPAY.DOC < prev next >

Wrap

Text File | 1991-09-10 | 435.4 KB | 5,588 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ██▄████▒░ ║ ║ ██▒░ ██▒░ ▄███▄ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▄████▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▄█████▄ ║ ║ ██▒░ ██▄▄▄██▒░ ██▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ████▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ▀█████▀ ██▒░ ██▒░ ║ ║ █████▒░ ██▒░ ║ ║ █████▒░ ║ ║ ║ ║ ║ ║ PAYROLL & PERSONNEL MANAGEMENT ║ ║ ║ ║ ║ ║ Copyright (c) 1990-91, TJS LAB, Inc, PO Box 585366, Orlando, FL 32858-5366 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB, Inc. Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......MAIN MENU 3...... NAME/PASSWORDS 4......EMPLOYEES BROWSE 4...... BROWSE HELP - F1 5...... EDITS 6...... EDIT PAY - PERSONAL DATA 7...... EDIT PAY - CURRENT DATA 8...... EDIT PAY - QUARTER DATA 9...... EDIT PAY - YEAR TO DATE (YTD) DATA 10...... EDIT PAY - VACATION DATA 11...... EDIT PAY - SICK PAY DATA 12...... EDIT PAY - NEXT OF KIN/EMERGENCY DATA 13...... EDIT PAY - DEDUCTIONS DATA 14...... EDIT PAY - ALL DATA 15...... ADD NEW EMPLOYEE RECORD - CTRL N 15...... ZERO CURRENT PAYROLL PERIOD - F3 16...... REPLACE HOURS WITH DEFAULT - F4 16...... FIND - F5,F6,F7,F8,F9 16...... FIND NUMBER - F5 17...... FIND EMPLOYEE NAME - F6 17...... FIND RIGHT 4 NUMBERS OF THE SSN - F7 17...... FIND RIGHT 4 NUMBERS OF TELEPHONE - F8 17...... FIND DEPARTMENT - F9 18......COMPUTE PAYROLL 22......POST PAYROLL & PRINT CHECKS 25...... WHERE TO ORDER THE PRE-PRINTED CHECK FORMS 26......REPORTS 26...... REPORTS & ROUTINES LISTING 27...... EMPLOYEE EXPANDED REPORT 28...... EMPLOYEE PAYROLL REPORT 29...... EMPLOYEE PERSONAL REPORT 30...... EMPLOYEE LIST 30...... EXAMPLE OF THE EMPLOYEE LIST 31...... EMPLOYEE MEMO/NOTES REPORT 31...... EMPLOYEE DUMP REPORT 32...... EMPLOYEE ADDRESS LABELS 33...... RESET QUARTER & YTD FIELDS *** 34...... CURRENT PAYROLL SUMMARY REPORT 34...... EXAMPLE OF THE CURRENT PRE-POST PAYROLL REPORT DAYO PAYROLL, TJS LAB, Inc. Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 35...... POSTED PAYROLL SUMMARY REPORT 36...... EXAMPLE OF A POSTED PAYROLL REPORT 37...... QUARTERLY PAYROLL SUMMARY 38...... EXAMPLE OF THE QUARTERLY SUMMARY REPORT 38...... YEAR TO DATE (YTD) SUMMARY REPORT 39...... EXAMPLE OF THE YEAR TO DATE (YTD) PAYROLL REPORT 39...... PAYROLL DETAIL REPORT 40...... STATE TAX SUMMARY - STATE CODE 41...... EXAMPLE OF THE STATE TAX SUMMARY REPORT 41...... STATE TAX SUMMARY - CLASS CODE 42...... EXAMPLE OF THE STATE TAX SUMMARY - BY CLASS CODE 42...... REPRINT CHECKS 44...... ROLL PAYROLL YEAR 45...... W2s 47...... EXAMPLE OF THE W2 48...... YEAR TO DATE (YTD) PAYROLL GRAPH 50...... CONFIGURATION STATUS REPORT 51...... EXAMPLE OF THE CONFIGURATION REPORT 52...... VIEW REPORTS ON SCREEN 53...... REPORT VIEWING SCREEN 54...... PRINTER DRIVER (SETUP) 54...... PRINTER DRIVER OPTIONS 55...... CHANGE DEFAULT PRINTER 56......CONFIGURATION 56...... CONFIGURATION LIST 57...... COMPANY NAME 57...... COMPANY ADDRESS 57...... COMPANY TELEPHONE 57...... MAXIMUM FEDERAL INSURANCE CONTRIBUTIONS ACT (FICA) DEDUCTION 57...... FICA PERCENTAGE RATE 58...... MAXIMUM MEDICARE DEDUCTION 58...... MEDICARE PERCENTAGE RATE 58...... MAXIMUM STATE INSURANCE (SDI) DEDUCTION 58...... SDI PERCENTAGE RATE 59...... DEFAULT STATE TAX CODE 59...... DEFAULT STATE TAX RATE 59...... LAST PAYROLL CHECK NUMBER USED 59...... LAST EMPLOYEE NUMBER USED 59...... OVERTIME FACTOR 60...... PREMIUM FACTOR 60...... DEFAULT PAY PERIOD 60...... DEFAULT WEEKLY HOURS 60...... EXEMPTION AMOUNT 61...... QUARTERLY START DATES 61...... DEFAULT CHECK COMMENT/NOTE DAYO PAYROLL, TJS LAB, Inc. Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 62...... FEDERAL TAX TABLES 62...... FEDERAL EMPLOYER NUMBER 62...... STATE EMPLOYER NUMBER 63...... CURRENT DIRECTORY DATABASE LOCATION 63...... GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 63...... AUTOMATIC GL POSTING 64...... EDIT CLASS CODE RECORD 65...... ADD NEW CLASS CODE RECORD 65...... FIND CLASS CODE 66...... LEFT MARGIN FOR THE PAYROLL CHECK 66...... RUN PAYROLL - COMPUTE FICA TAX ONLY 66...... REPORT PRINTER TYPE 66...... REPORT PRINTER PORT 67...... VISUAL INDEXING 67...... AUTOMATIC DAILY INDEXING 67...... COLOR MONITOR 67...... COLOR INTENSITY 68......MISCELLANEOUS ROUTINES 68...... MISC Routines Menu: 69...... APPEND FROM 71...... BROWSE DATABASES 73...... COPY (.DBF) TO 75...... CREATE DATABASE 77...... DELETE RECORDS 78...... ERASE FILE 78...... EXIT TO DOS 79...... INDEX A DATABASE 80...... LIST FIELDS 83...... MODIFY DATABASE 84...... PACK DATABASE 85...... RECALL RECORDS 85...... RETURN TO MENU 85...... RUN (DOS COMMAND) 86...... SIMPLE EDITOR 87...... SORT DATABASE 88...... TYPE (PRINT) FILE 89...... ZAP DATABASE 91......HELP SCREENS 92...... EXPANDED HELP 93...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 94...... VIEW DOCUMENTATION ONSCREEN 95......DATABASE STRUCTURE 102......DATA DICTIONARY 109......DAYO PAYROLL MAINTENANCE & QUIRKS 110......TJS 'Computer' LAB DAYO PAYROLL, TJS LAB, Inc. Orlando, Florida Page: 1 ■ INTRODUCTION DAYO Payroll provides a system for the computation of payroll for businesses of any size. DAYO Payroll contains many features and functions not normally found in any PC payroll application. Some of DAYO payroll's features include: Multiuser, unlimited employees, Weekly, BiWeekly, and/or Monthly payrolls, quarterly, year to date (YTD), and current summary databases, databases are dBase IV (tm) compatible, Automatic payroll posting & computation, vacation maintenance, sick pay/days maintenance, check printing, multiple states, standard or fixed state tax, standard or fixed federal tax, SDI tax, overtime & premium hourly wages, up to 8 deductions, exempt/non-exempt deductions, view reports on screen, printer setup & drivers, and over 34+ configurable options. Reports include the following: Employee Expanded Payroll Summary YTD Employee List Payroll Payroll Detail Employee List Personal State Tax Employee List Abbr. State Tax by CLASS Employee Notes Reprint Checks Employee Dump Roll Year Employee Labels Print W2s Payroll Summary Pre-Post YTD Graph Payroll Summary Post Configuration Settings Payroll Summary QTR DAYO Payroll is fully integrated with DAYO General Ledger, however, it does not require any of the other DAYO modules for operation... Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO BO Customer Backorders DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO GL General Ledger DAYO BO Back Orders DAYO EOP End of Period Purge & Physical Inventory DAYO MRP Materials Requirement Planning for Manufacturers DAYO Passwords Password protect your DAYO system DAYOX Network/LAN Index Maintenance Utility DAYO Smart Reports A variety of reports pertaining to the above modules DAYO PAYROLL, TJS LAB Orlando, Florida Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO PAYROLL software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO PAYROLL. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO PAYROLL, run the SETUP program found on the Menu, Update & Conversion, and/or the Installation diskettes. This program will decompress the payroll files onto your hard disk into directory: \DAYOPAY. When you run DAYO Payroll for the first time, it will create all the database, index, and configuration files it requires for operation. Type and enter 'DAYOPAY' at the DOS prompt to run the program. *** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and your files must have a MINIMUM setting of 55! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! DAYO PAYROLL, TJS LAB Orlando, Florida Page: 3 ■ MAIN MENU The main menu displays the options on the left side of the screen. On the bottom left is displayed the key payroll databases with their sizes and number of records. The employee database (PAY.DBF) contains the information on each of your employees. The payroll database (PAYROLL.DBF) contains year to date (YTD) payroll records (one per check). The payroll history database (PAYHIST.DBF) contains previous year payroll records. DAYO Payroll Version 3.0 TJS LAB ┌───[February 1991]──┐ ╓──────────────────────╖ │S M T W T F S │ ║ 1 EMPLOYEES ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟──────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│ ║ 2 PAYROLL ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│ ╟──────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│ ║ 3 CHECKS & POSTING ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│ ╟──────────────────────╢ █▀██▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 │ ║ 4 REPORTS ║ │ │ ╟──────────────────────╢ Copyright (c) 1990-1991 └────────────────────┘ ║ 5 CONFIGURATION ║ ╟──────────────────────╢ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ ║ 6 MISC ROUTINES ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ ╟──────────────────────╢ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ ║ 7 EXIT ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ ╚╦╦╦════════════════╦╦╦╝ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ ╚╬╣ Select Option ╠╬╝ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ ╚╩════════════════╩╝ ╓──────────────────────────────╖ ║Database # Records Size║ ║PAY 36 61931║ ║PAYROLL 37 11968║ ║PAYHIST 0 1091║ ╚══════════════════════════════╝ Browse/Edit/Maintain your Employee Records To select/enter any of the main menu options, use the arrow keys to highlight the desired one and press enter/return. ■ NAME/PASSWORDS Upon entering a main menu option for the first time, you will be presented with a prompt asking for your name or your password if using DAYO passwords. Something (anything) must be entered at the name prompt. The exact spelling (case sensitive) of passwords must be provided. ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 4 ■ EMPLOYEES BROWSE The first main menu option is the employee browse screen. From this browse screen you can view, edit, enter weekly hours and general maintenance on your employee payroll (and personnel) records. Only 1 employee is displayed at a time on the screen. Use the arrow keys (or FIND keys) to move to other employee records. Key employee/payroll information is displayed onto the screen. *** Note, the employee record is rather large, containing at least 150 fields! Use the left/right arrow keys to view the entire record. You can edit at any time by simply typing in the change. ╔════════════════════════[ EMPLOYEE PAYROLL BROWSE ]═════════════════════════╗ ║Number: 999999 Name: George Moonilal <Active> ║ ║Marital Status:SAL Sex: M SSN: 123-45-6789 DOB: 12/10/58 DOH: 03/08/87 ║ ║Status: Department: Type: P Class: MGM Paid: Weekly Parttime║ ║Address: PO Box 3453 Orlando, FL 32808 ║ ║Rate: 10.5000 Withhold Taxes: Yes Exemptions: 3 State Tax: 0.0000 ║ ║1st Qtr: 11240.00 2nd Qtr: 22230.00 3rd Qtr: 22230.00 4th Qtr: 120.00║ ║Regular Hours: 0.000 Overtime: 0.000 Other: 0.00 ║ ║CURRENT: Reg Hrs: 0.000 Overtime: 0.000 Other Amount: 0.00 ║ ║Gross: 0.00 Fed: 0.00 FICA: 0.00 Deductions: 0.00║ ║State: 0.00 Net: 0.00 Check#: 109090 Date: 07/12/90 ║ ║Note: 401 K Signup next week ║ ║YTD: Reg Hrs: 3120.000 Overtime: 30.000 Other Amount: 120.00 ║ ║Gross: 56444.23 Fed: 12349.39 FICA: 8956.45 Deductions: 5.00║ ║State: 0.00 Net: 41223.21 ║ ╚════════════════════════════════════════════════════════════════════════════╝ NUMBER NAME SSN ────────────────────╥────────────────────────────────╥──────────────────────── 999999 ║ George Moonilal ║ 234-23-4344 ────────────────────╨────────────────────────────────╨──────────────────────── Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Del) F3 (Zero Hours) F4 (Default Hours) Alt F1 (Notes) Find F5 (Employee Number) F6 (Name) F7 (SSN) F8 (PHONE) F9 (DEPT) 1/3 ■ BROWSE HELP - F1 To view the special function keys while in any browse, press F1. Read more about this help later in this manual... DAYO PAYROLL, TJS LAB Orlando, Florida Page: 5 ■ EDITS Due to the large number of fields in the employee record, the fields were segregated into 9 edit screens: ┌────────────────────────────────[ EDIT PAY ]────────────────────────────────┐ │ Due to the large number of records in the Employee database (PAY.DBF) │ │ a full screen edit of all fields would not be practical, therefore │ │ the following options are provided for you: │ │ │ │ │ │ Select Edit Option -> Personal Data │ │ Current Data │ │ Quarterly Data │ │ Year to Date Data │ │ Vacation Data │ │ Sick Pay Data │ │ Next of Kin │ │ Deductions │ │ All in a selection window │ │ Exit │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit/Abort) DAYO PAYROLL, TJS LAB Orlando, Florida Page: 6 ■ EDIT PAY - PERSONAL DATA This option contains all the personal data for the employee: ┌────────────────────────[ EDIT PAY - PERSONAL DATA ]────────────────────────┐ │ NUMBER: 999999 │ │ NAME: Terry Smith │ │ SSN: 070-73-4689 │ │ ADDRESS LINE 1: PO Box 5077 │ │ ADDRESS LINE 2: │ │ CITY: Augusta │ │ STATE: GA │ │ ZIP: 30909 │ │ TELEPHONE: (404) 231-4350 │ │ TYPE: FUL │ │ STATUS: SAL │ │ CLASS: MGM │ │ DEPARTMENT: SLS │ │ SEX: M │ │ MARITAL STATUS (M/S): M │ │ DATE OF BIRTH: 12/09/57 DATE OF HIRE: 08/02/75 │ │ HOURLY RATE: 24.7500 │ │ PAY PERIOD (W,B,M): W │ │ WITHHOLD: Y │ │ EXEMPTIONS: 2 │ │ NEXT OF KIN: Sally Smith (407) 295-1704 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 7 ■ EDIT PAY - CURRENT DATA This option lets you scroll to the field you wish to enter. ┌────────────────────────[ EDIT PAY - CURRENT DATA ]─────────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ RATE │ │ PAYPERIOD │ │ There are more fields REG_HOURS │ │ off screen... OT_HOURS │ │ P_HOURS │ │ Use the up, down, OTHER │ │ PgUp, and/or PgDn SICK_PAY │ │ keys to access them... VAC_PAY │ │ WITHHOLD │ │ EXEMPTIONS │ │ FED_FIX │ │ FED_FACTOR │ │ PRINTED │ │ TAX_STATE │ │ STATE_RATE │ │ STATE_FIX │ │ SICK_DAYS │ └────────────────────────────────────────────────────────────────────────────┘ Editing is possible by highlighting the field and pressing enter as seen with the RATE field: ┌────────────────────────[ EDIT PAY - CURRENT DATA ]─────────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ 24.7500 │ │ PAYPERIOD │ │ There are more fields REG_HOURS │ │ off screen... OT_HOURS │ │ P_HOURS │ │ Use the up, down, OTHER │ │ PgUp, and/or PgDn SICK_PAY │ │ keys to access them... VAC_PAY │ │ WITHHOLD │ │ EXEMPTIONS │ │ FED_FIX │ │ FED_FACTOR │ │ PRINTED │ │ TAX_STATE │ │ STATE_RATE │ │ STATE_FIX │ │ SICK_DAYS │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 8 ■ EDIT PAY - QUARTER DATA The quarter data contains payrolls sums for each quarter of the employee, and subtotals for the current payroll period. ┌────────────────────────[ EDIT PAY - QUARTER DATA ]─────────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ QUARTER1 │ │ QUARTER2 │ │ There are more fields QUARTER3 │ │ off screen... QUARTER4 │ │ QTR_RHOUR │ │ Use the up, down, QTR_OHOUR │ │ PgUp, and/or PgDn QTR_PHOUR │ │ keys to access them... QTR_RPAY │ │ QTR_OPAY │ │ QTR_PPAY │ │ QTR_OTHER │ │ QTR_GROSS │ │ QTR_FED │ │ QTR_STATE │ │ QTR_FICA │ │ QTR_SDI │ │ QTR_NET │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 9 ■ EDIT PAY - YEAR TO DATE (YTD) DATA The year to date (YTD) data contains payrolls sums for the year of each employee and subtotals for the current payroll period. ┌──────────────────────────[ EDIT PAY - YTD DATA ]───────────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ YTD_RHOUR │ │ YTD_OHOUR │ │ There are more fields YTD_PHOUR │ │ off screen... YTD_RPAY │ │ YTD_OPAY │ │ Use the up, down, YTD_PPAY │ │ PgUp, and/or PgDn YTD_OTHER │ │ keys to access them... YTD_GROSS │ │ YTD_FED │ │ YTD_STATE │ │ YTD_FICA │ │ YTD_SDI │ │ YTD_NET │ │ YTD_DEDX │ │ YTD_DEDN │ │ YTD_DED1 │ │ YTD_DED2 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 10 ■ EDIT PAY - VACATION DATA This option contains the fields linked to vacation. ┌────────────────────────[ EDIT PAY - VACATION DATA ]────────────────────────┐ │ │ │ │ │ NUMBER: 999999 │ │ NAME: George Moonilal │ │ SSN: 234-23-4344 │ │ ACCRUED VACATION DAYS/HOURS: 7.000 │ │ VACATION DAYS/HOURS USED: 5.000 │ │ VACATION DAYS/HOURS PER PERIOD: .500 │ │ VACATION DAYS/HOURS PAY: 0.00 │ │ CURRENT VACATION DAYS/HOURS: 0.00 │ │ QUARTER VACATION DAYS/HOURS: 0.00 │ │ YTD VACATION DAYS/HOURS: 0.00 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 11 ■ EDIT PAY - SICK PAY DATA This option contains the fields relating to the maintenance of Sick Pay. ┌────────────────────────[ EDIT PAY - SICK PAY DATA ]────────────────────────┐ │ │ │ │ │ NUMBER: 999999 │ │ NAME: George Moonilal │ │ SSN: 234-23-4344 │ │ ACCRUED SICK DAYS/HOURS: 15.000 │ │ SICK DAYS/HOURS USED: 1.000 │ │ SICK DAYS/HOURS PER PERIOD: .250 │ │ SICK DAYS/HOURS PAY: 0.00 │ │ CURRENT SICK DAYS/HOURS: 0.00 │ │ QUARTER SICK DAYS/HOURS: 0.00 │ │ YTD SICK DAYS/HOURS: 0.00 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 12 ■ EDIT PAY - NEXT OF KIN/EMERGENCY DATA Use this option/field to enter the name and telephone number of the employee's next of kin or contact in case of emergency. ┌─────────────────[ EDIT PAY - EMERGENCY/NEXT OF KIN DATA ]──────────────────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ Employee: George Moonilal Number: 999999 │ │ │ │ │ │ │ │ Enter the Next of Kin and/or Emergency Information on the next line: │ │ Pat Taylor, 671-0930 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 13 ■ EDIT PAY - DEDUCTIONS DATA This option lets you scroll/edit your many deduction related fields. To edit one, highlight it, then press enter. A prompt will appear allowing you to edit/change the value of that field. ┌───────────────────────[ EDIT PAY - DEDUCTIONS DATA ]───────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ DEDUCT1 │ │ DEDUCT1AMT │ │ There are more fields DEDUCT1X │ │ off screen... DEDUCT2 │ │ DEDUCT2AMT │ │ Use the up, down, DEDUCT2X │ │ PgUp, and/or PgDn DEDUCT3 │ │ keys to access them... DEDUCT3AMT │ │ DEDUCT3X │ │ DEDUCT4 │ │ DEDUCT4AMT │ │ DEDUCT4X │ │ DEDUCT5 │ │ DEDUCT5AMT │ │ DEDUCT5X │ │ DEDUCT6 │ │ DEDUCT6AMT │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 14 ■ EDIT PAY - ALL DATA This option contains a scroll of ALL fields. To edit any of them, highlight the field and press enter. A prompt will appear allowing you to edit/change the value of that field. ┌──────────────────────────[ EDIT PAY - ALL DATA ]───────────────────────────┐ │ Select The Field(s) │ │ That You Wish To Edit -> NUMBER │ │ Then Press Enter.. NAME │ │ SSN │ │ ADDR1 │ │ ADDR2 │ │ There are more fields CITY │ │ off screen... STATE │ │ ZIP │ │ Use the up, down, PHONE │ │ PgUp, and/or PgDn TYPE │ │ keys to access them... STATUS │ │ DEPARTMENT │ │ SEX │ │ MARITAL │ │ DOB │ │ DOH │ │ RATE │ │ PAYPERIOD │ │ REG_HOURS │ │ OT_HOURS │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 15 ■ ADD NEW EMPLOYEE RECORD - CTRL N Press Ctrl N to add a new employee. A Full Screen Edit function will appear, but take note that only the first 42 fields will be displayed. Note, it is recommended that the employee's name be in the format: First Name, Middle Name/Initial, Last Name Use the F2 Edit option to finish editing the key fields for new employee records. ┌────────────────────[ NEW EMPLOYEE - FULL SCREEN EDIT ]─────────────────────┐ │ NUMBER: 012302 OTHER: 0.00 │ │ NAME: JOE NEW SICK_PAY: 0.00 │ │ SSN: - - VAC_PAY: 0.00 │ │ ADDR1: WITHHOLD: T │ │ ADDR2: EXEMPTIONS: 0 │ │ CITY: CURR_RHOUR: 0.000 │ │ STATE: CURR_OHOUR: 0.000 │ │ ZIP: CURR_PHOUR: 0.000 │ │ PHONE: CURR_RPAY: 0.00 │ │ TYPE: CURR_OPAY: 0.00 │ │ STATUS: CURR_PPAY: 0.00 │ │ DEPARTMENT: CURR_OTHER: 0.00 │ │ SEX: CURR_GROSS: 0.00 │ │ MARITAL: CURR_FED: 0.00 │ │ DOB: / / CURR_STATE: 0.00 │ │ DOH: / / CURR_FICA: 0.00 │ │ RATE: 0.0000 CURR_SDI: 0.00 │ │ PAYPERIOD: W CURR_NET: 0.00 │ │ REG_HOURS: 0.000 CURR_DEDX: 0.00 │ │ OT_HOURS: 0.000 CURR_DEDN: 0.00 │ │ P_HOURS: 0.000 CURR_DED1: 0.00 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ ZERO CURRENT PAYROLL PERIOD - F3 At the beginning of a new payroll period, and before any entry of hours, it is recommended that you zero out all current pay period fields (ie: hours). ╔═══════════[ ZERO OUT: HOURS, SICK PAY, VACATION PAY, & OTHER ]═══════════╗ ║ Do you really want to ZERO out the current hours and pay amounts? (Y/N)║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 16 ■ REPLACE HOURS WITH DEFAULT - F4 Press F4 to place the default number of hours (as set in the configuration menu) in each employee record. You can do this for all employees, or for just specific pay period employees. ╔══════════════[ REPLACE HOURS WITH DEFAULT ]══════════════╗ ║ ║ ║ Run Payroll For -> All Employees ║ ║ W - Weekly Employees Only ║ ║ B - BiWeekly Employees Only ║ ║ M - Monthly Employees Only ║ ║ ║ ╚══════════════════════════════════════════════════════════╝ The progress of the replacement of default hours is displayed upon the screen: ╔══════════════[ REPLACE HOURS WITH DEFAULT ]══════════════╗ ║ ║ ║ Run Payroll For -> All Employees ║ ║ W - Weekly Employees Only ║ ║ B - BiWeekly Employees Only ║ ║ M - Monthly Employees Only ║ ║ ║ ╚═╡██████████████████████████┼──┼──┼──┼──┼──┼──┼──┼──┼──╞══╝ ■ FIND - F5,F6,F7,F8,F9 The employee payroll database has 5 indexes; on the employee number, employee name, the right 4 numbers of the employee's social security number (SSN), the right 4 numbers of the employee's telephone number, and the employee's department. ■ FIND NUMBER - F5 ┌─────────────────────────────────────────────────────────────┐ │ Enter NUMBER: 99999 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 17 ■ FIND EMPLOYEE NAME - F6 ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: George │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND RIGHT 4 NUMBERS OF THE SSN - F7 ┌─────────────────────────────────────────────────────────────┐ │ Enter RIGHT(SSN,4): 434 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND RIGHT 4 NUMBERS OF TELEPHONE - F8 ┌─────────────────────────────────────────────────────────────┐ │ Enter RIGHT(PHONE,4): 3960 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FIND DEPARTMENT - F9 ┌─────────────────────────────────────────────────────────────┐ │ Enter DEPARTMENT+NAME: MGM │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 18 ■ COMPUTE PAYROLL This option takes the information you entered in the Employee Browse (ie: number of hours worked, vacation pay, other...) and computes the pay per employee based on the configuration values and the employee rates and settings. Note, running this option does not perform any posting, but does overwrite the information in the CURRENT fields (they start with 'CURR_'). The payroll is based on the values of the following fields found in each employee record: RATE - Pay rate per hour PAYPERIOD - Pay type, ie: 'W'eekly, 'B'iweekly, 'M'onthly REG_HOURS - Number of regular hours worked OT_HOURS - Number of overtime hours worked P_HOURS - Number of premium hours worked OTHER - Amount of miscellaneous pay SICK_PAY - Amount of sick pay VAC_PAY - Amount of vacation pay DEDUCTxAMT - 1 thru 8 deduction amounts When this routine is run, pay is computed based on the employee's rate of pay and the hours he worked. This total plus the sick pay, vacation pay, and other pay minus the deductions and taxes equals the employee's gross pay. The Payroll Equations: Regular Pay = RATE * REG_HOURS Overtime Pay = RATE * OT_HOURS * Overtime Factor Premium Pay = RATE * P_HOURS * Premium Factor Gross Pay = Regular Pay + Overtime Pay + Premium Pay Net Pay = (Regular Pay + Overtime Pay + Premium Pay + Other Pay + Sick Pay + Vacation Pay ) - ( Federal Taxes + FICA Tax + Medicare + State Tax + SDI Tax + Deductions ) At each pay period, the hours each employee worked must be inputed/placed into the following fields; REG_HOURS (regular hours), OT_HOURS (overtime hours), and P_HOURS (premium hours). The regular hours are multipled by the employee's RATE to get the regular pay amount. Overtime and premium hours are multiplied by the RATE and factors maintained in the configuration menu. If any sick pay is due, place it in the field SICK_PAY. Vacation pay is placed into the field VAC_PAY. If the employee is receiving any miscellaneous pay (ie: bonus), place the amount in the OTHER field. These values will determine the gross wages for the employee for the current period. DAYO PAYROLL, TJS LAB Orlando, Florida Page: 19 Federal income tax is computed based on the Federal Tax Table accessed in the configuration menu. This computed federal income tax can also be adjusted by a factor (ie: pay 10% more than the computed rate...). If the field FED_FACTOR (in the employee record of the database PAY.DBF) has a positive value, the value will be multiplied with the computed federal tax to produce a new and adjusted federal income tax. Also available is a Fixed Federal Tax which (if used) is the value contained in the field FED_FIX in the employee's record. FICA tax is computed based on a factor or percentage rate. The default rate for FICA is maintained in the configuration menu. Like the FICA tax, as of 1991, Medicare is deducted similarly. The State income rate is the value of the field STATE_RATE. Note, the field STATE_TAX must contain the state abbreviation code for the employee or the tax will not be computed... If so desired, a fixed State tax can be used by placing a positive value in the field STATE_FIX. The State insurance rate (SDI) is maintained in the configuration menu. The field USE_SDI in the employee database (PAY.DBF) must be set to true (.T.) if SDI tax is to be withheld. Deductions (up to 8 per employee) are maintained for each employee in the fields that start with 'DEDUCT'. Each deduction is made at each pay period. The maintenance of each deduction requires the inputting of the deduction name into the field DEDUCTx ( where 'x' is a number 1 - 8). The amount of the deduction (per pay period) is inputted into the field (DEDUCTxAMT). If the deduction is to be tax exempt, you will need to mark the DEDUCTxX field as FALSE (.F.); the default is to classify all deductions as exempt (.T). The deduction balance (total amount to be collected) is placed into the field DEDUCTxBAL. Note, this balance field will be reduced by the DEDUCTxAMT value each payroll period. No more maintenance will be required for deductions... Each payroll period is keyed upon a pay date. This date is usually fixed, (ie, the last or first day of the week). Insure you have the correct date before starting! ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██▄████▒░ ▄███▄ ██▒░ ██▒░ ██▄████▒░ ▄█████▄ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▄▄██▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▄▄▄██▒░ ████▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▀█████▀ █████▒░ █████▒░ ║ ║ ║ ║ Do you really want to start a payroll? (Y/N) ║ ║ ║ ║ Enter Week Ending/Payroll Date: 07/21/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 20 You can 'run a payroll' for all types of employees, or all: ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██▄████▒░ ▄███▄ ██▒░ ██▒░ ██▄████▒░ ▄█████▄ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▄▄██▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▄▄▄██▒░ ████▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▀█████▀ █████▒░ █████▒░ ║ ║ ║ ║ Do you really want to start a payroll? (Y/N) ║ ║ ║ ║ Enter Week Ending/Payroll Date: 07/21/90 ║ ║ ║ ║ Run Payroll For -> All Employees ║ ║ W - Weekly Employees Only ║ ║ B - BiWeekly Employees Only ║ ║ M - Monthly Employees Only ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ You will be prompted to print/not to print a summary of this process. If you decide to print one, it can be directed to the printer or to a file that can later be printed or viewed on screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██▄████▒░ ▄███▄ ██▒░ ██▒░ ██▄████▒░ ▄█████▄ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▄▄██▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▄▄▄██▒░ ████▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▀█████▀ █████▒░ █████▒░ ║ ║ ║ ║ Do you really want to start a payroll? (Y/N) ║ ║ ║ ║ Enter Week Ending/Payroll Date: 07/21/90 ║ ║ ║ ║ Run Payroll For -> All Employees ║ ║ ║ ║ Do you want a report? (Y/N) ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PAY0790.TXT ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 21 The progress of the 'payroll run' is displayed onto the screen with 2 progress graphs. The first is displayed while it zeros out all fields that start with 'CURR_': ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██▄████▒░ ▄███▄ ██▒░ ██▒░ ██▄████▒░ ▄█████▄ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▄▄██▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▄▄▄██▒░ ████▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▀█████▀ █████▒░ █████▒░ ║ ║ ║ ║ Standby while I zero out the totals from the last payroll... ║ ║ ║ ║╔══════════════════════════════════════════════════════════════════════════╗║ ║╟█████████████████████████████████████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢║ ║╚══════════════════════════════════════════════════════════════════════════╝║ ║0% 50% Finis║ ║ Employee Name SSN Pay Period ║ ║ Stacy Anna Johnson 342-32-4333 Weekly ║ ║ Andrew Pete Watcher 693-92-0204 BiWeekly ║ ║ Francis Gregory LaRossa 342-83-0990 BiWeekly ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ The second progress graph is displayed while the payroll computation for each employee takes place: ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██▄████▒░ ▄███▄ ██▒░ ██▒░ ██▄████▒░ ▄█████▄ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ▄██ ██▄ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▀████▒░ ██▒░ ██▒░ ██▄▄██▒░ ██▄▄▄██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▄▄▄██▒░ ████▒░ ██▀▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▀ ▀██▒░ ██▒░ ██▒░ ▀██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ▀█████▀ █████▒░ █████▒░ ║ ║ ║ ║ Standby now while I compute the payroll... Payroll Total: 2000.00║ ║ ║ ║╔══════════════════════════════════════════════════════════════════════════╗║ ║╟█████████████████████████████████████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢║ ║╚══════════════════════════════════════════════════════════════════════════╝║ ║0% 50% Finis║ ║ Employee Name SSN Pay Period Gross║ ║ Stacy Anna Johnson 342-32-4333 Weekly 2000.00║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 22 ■ POST PAYROLL & PRINT CHECKS This is the third main menu option, and the final set in the processing of a payroll. Run this routine when satisfied with the current payroll values as set with the PAYROLL routine and employee browse editing. This routine takes the values in the current fields (those that start with 'CURR_') and posts them to the quarterly and yearly fields. Payroll records (check records) are also created in the database PAYROLL.DBF. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░ ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ Did you make a backup? It is highly recommended that you do! ║ ║ ║ ║ Do you really want to print checks and post the Current Payroll? (Y/N) ║ ║ ║ ║ Are you sure? (Y/N) { Point of No Return } ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ You will be prompted to enter the starting check number that will be used on new payroll records being created. This value will be sequentially incremented and place with each payroll record created (in the database PAYROLL.DBF). ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░ ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ Did you make a backup? It is highly recommended that you do! ║ ║ ║ ║ Do you really want to print checks and post the Current Payroll? (Y/N) ║ ║ ║ ║ Enter starting Check Number: 115 ║ ║ ║ ║ Note! Only one check per employee! If a check already exists for an ║ ║ employee, a new one will not be created! This starting check number ║ ║ will only apply to NEW check records. Use the REPRINT CHECKS option ║ ║ in the Reports menu to change check numbers of current pay period... ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 23 You have the option of selecting which employees are to be paid. The default pay period is determined by a configuration setting. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░ ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ Did you make a backup? It is highly recommended that you do! ║ ║ ║ ║ Do you really want to print checks and post the Current Payroll? (Y/N) ║ ║ ║ ║ Enter starting Check Number: 115 ║ ║ ║ ║ Print Checks & Post Payroll For ->All Employees ║ ║ W - Weekly Employees Only ║ ║ B - BiWeekly Employees Only ║ ║ M - Monthly Employees Only ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ You have the option to print a summary report to printer or file. Note, the name of the report (if printed to a file) will contain the month/year of this 'payroll run'. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░ ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ Did you make a backup? It is highly recommended that you do! ║ ║ ║ ║ Do you really want to print checks and post the Current Payroll? (Y/N) ║ ║ ║ ║ Enter starting Check Number: 115 ║ ║ ║ ║ Print Checks & Post Payroll For ->All Employees ║ ║ ║ ║ Do you want a report? (Y/N) ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: RUNA0790.TXT ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 24 The progress of the posting is displayed with a progress graph: ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ ║ ║ ║ ║ Standby now while I Post the Current... Payroll Total: 2000.00 ║ ║ ║ ║╔══════════════════════════════════════════════════════════════════════════╗║ ║╟█████████████████████████████████████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢║ ║╚══════════════════════════════════════════════════════════════════════════╝║ ║0% 50% Finis║ ║ Employee Name SSN Pay Period Gross║ ║ Susie Martin 393-92-0204 BiWeekly 2000.00║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ After all posting is done, the option to print the checks will appear. You can print them now or later with the REPRINT routine in the Reports Menu. If you wish, you can test print a check for alignment. ╔══════════════════════════════[ PRINT CHECKS ]══════════════════════════════╗ ║ ║ ║ You can print checks with the REPRINT CHECKS option from the Reports Menu. ║ ║ ║ ║ Do you wish to print checks at this time? (Y/N) ║ ║ ║ ║ Do you want to pause between checks? (Y/N) ║ ║ ║ ║ Okay, Ready The Printer! ║ ║ Select Option -> Continue/Start Printing ║ ║ Print TEST Pattern ║ ║ Esc - Abort Printing & Exit ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 25 When ready to start printing the actual checks, press 'C'. If you had responded Y (Yes) to the 'pause between checks' prompt, you need to press any key to print each check. A facsimile of the check is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ █▄███░ ▄███▄ ▄██▄ █████░ ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ █▀███░ █░ █░ ▀██▄ █░ ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ █░ ▀███▀ ▀██▀ █░ ║ ║ ║ ║ ║ ║████████████████████████████████████████████████████████████████████████████║ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░Employee Check Check ░░░░░░█║ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░Number Date Number ░░░░░░█║ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░000001░░░░07/21/90░░115 ░░░░░░█║ ║█░░One Thousand, Five Hundred Thirty Dollars & Two Cents░░░░░░░░░░░░░░░░░░█║ ║█░░ 1530.02░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░Susie Martin ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░394 East Lancaster Road ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░South End ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║█░░Maitland, FL 32819-1903 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█║ ║████████████████████████████████████████████████████████████████████████████║ ╚╚══════════════════════════════════════════════════════════════════════════╝╝ ■ WHERE TO ORDER THE PRE-PRINTED CHECK FORMS The payroll check form can be ordered from: ┌───────────────────────────────────────────────────────────────┐ │ DELUXE COMPUTER FORMS, ST. Paul, Minn 1-800-328-0304 │ │ │ │ Product# 91070 │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 26 ■ REPORTS There are 22+ reports and routines in the Reports Menu option. Not all the reports are displayed in the selection box. Use the down/up arrow keys to view them all: DAYO Payroll Version 3.0 TJS LAB REPORTS ┌───[February 1991]──┐ ╔═════════════════════════╗ │S M T W T F S │ ║ PAYROLL REPORTS ║█▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟─────────────────────────╢█░ █░ █░█░ █░ █░ █░ █░ │ 1 2│ ║ Employee Expanded ║█░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│ ║ Employee List Payroll ║█░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│ ║ Employee List Personal ║█░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│ ║ Employee List Abbr. ║█▀██▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 │ ║ Employee Notes ║ │ │ ║ Employee Dump ║ Copyright (c) 1990-1991 └────────────────────┘ ║ Employee Labels ║ ║ Reset Quarter & YTD *** ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ ║ Payroll Summary Pre-Post║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ ║ Payroll Summary Post ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ ║ Payroll Summary QTR ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ ║ Payroll Summary YTD ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ ║ Payroll Detail ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ ║ State Tax ║ ║ State Tax by CLASS ║────╖ ║ Reprint Checks ║Size║ ║ Roll Year ║1931║ ╟─────────────────────────╢8715║ ║ Select Option ║1091║ ╚═════════════════════════╝════╝ ■ REPORTS & ROUTINES LISTING Employee Expanded Payroll Detail Employee List Payroll State Tax Employee List Personal State Tax by CLASS Employee List Abbr. Reprint Checks Employee Notes Roll Year Employee Dump Print W2s Employee Labels YTD Graph Payroll Summary Pre-Post Configuration Settings Payroll Summary Post View Reports On Screen Payroll Summary QTR Printer Setup Payroll Summary YTD DAYO PAYROLL, TJS LAB Orlando, Florida Page: 27 ■ EMPLOYEE EXPANDED REPORT This report can be printed using 5 different indexes. ╔═══════════════════════════════════════════════════════╗ ║The Employee Expanded Report contains the following ║ ║fields: NAME, NUMBER, SSN, ADDRESS, RATE, PAYPERIOD ║ ║PHONE, TYPE, STATUS, DEPARTMENT, SEX, MARITAL, CLASS ║ ║PARTTIME, and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Employee Number ║ ║ Employee Name ║ ║ Last 4 SSN ║ ║ Last 4 Telephone ║ ║ Department & Name ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee Expanded Report contains the following ║ ║fields: NAME, NUMBER, SSN, ADDRESS, RATE, PAYPERIOD ║ ║PHONE, TYPE, STATUS, DEPARTMENT, SEX, MARITAL, CLASS ║ ║PARTTIME, and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Employee Number ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EMPXPAND.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 28 ■ EMPLOYEE PAYROLL REPORT This report contains the payroll 'constants' for each employee. Like the Expanded Report, there is the option to print it in one of five indexes. ╔═══════════════════════════════════════════════════════╗ ║The Employee Payroll Report contains the following ║ ║fields: NAME, NUMBER, SSN, STATUS, TYPE, DEPARTMENT ║ ║MARITAL, EXEMPTIONS, CLASS, PARTTIME, PAYPERIOD, RATE ║ ║GROSS, NET, and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Employee Number ║ ║ Employee Name ║ ║ Last 4 SSN ║ ║ Last 4 Telephone ║ ║ Department & Name ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee Payroll Report contains the following ║ ║fields: NAME, NUMBER, SSN, STATUS, TYPE, DEPARTMENT ║ ║MARITAL, EXEMPTIONS, CLASS, PARTTIME, PAYPERIOD, RATE ║ ║GROSS, NET, and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Last 4 SSN ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EMPPAY.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 29 ■ EMPLOYEE PERSONAL REPORT This report contains the 'personal' data about each employee. You can print it in 5 different indexes (orders). ╔═══════════════════════════════════════════════════════╗ ║The Employee Personal Report contains the following ║ ║fields: NAME, NUMBER, SSN, ADDRESS, PHONE, STATUS, ║ ║TYPE, DEPARTMENT, SEX, MARITAL, DOB, DOH, PARTTIME, ║ ║and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Employee Number ║ ║ Employee Name ║ ║ Last 4 SSN ║ ║ Last 4 Telephone ║ ║ Department & Name ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee Personal Report contains the following ║ ║fields: NAME, NUMBER, SSN, ADDRESS, PHONE, STATUS, ║ ║TYPE, DEPARTMENT, SEX, MARITAL, DOB, DOH, PARTTIME, ║ ║and ACTIVE. Report is 132 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select the Index -> Employee Number ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EMPPER.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 30 ■ EMPLOYEE LIST This is just a simple listing of all your employees. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee List Report contains the following ║ ║fields: NAME, NUMBER, SSN, PHONE, & DEPARTMENT. ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║ ║ ║Select the Index -> Employee Number ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EMPLIST.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE EMPLOYEE LIST Employee List Page: 1 TJS LAB 07/22/90 NAME NUMBER SSN DEPARTMENT NOTES ----------------------------- ------ ----------- ---------- Stacy Anna Johnson 000100 122-65-7777 MGT George Moonilal 000101 650-77-5488 SAL Frank G. LaRossa 000102 363-10-3490 SAL John Watcher 000103 137-43-5688 MFG Andy Watcher 000104 457-27-7880 MFG AJ Watcher 000105 459-42-1160 INC Pete Watcher 000106 453-12-3282 INC Samual Moses 000108 355-22-8981 LAB Ann Elizabeth Smith 001001 553-13-5527 X Donna George 001020 523-05-4779 LAB Joe Martinez 002000 021-00-2787 LAB Gigi L. Moonilal 005002 924-38-7276 MGT DAYO PAYROLL, TJS LAB Orlando, Florida Page: 31 ■ EMPLOYEE MEMO/NOTES REPORT Use this report to print all memos/notes for ALL or a specific employee. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee Memo/Notes Report prints out all (if any) ║ ║memos/notes for all or a specific employee. The notes ║ ║are maintained in the database: PAYNOTES.DBF & DBT. ║ ║ ║ ║Uses Report Form: PAYNOTES.FRM. ║ ║ ║ ║Enter Employee Number: 999999 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PAYNOTES.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ EMPLOYEE DUMP REPORT This report 'dumps' all data for ALL or a specific employee. Data is derived from the following databases/sources: PAY.DBF, PAYROLL.DBF, and PAYNOTES.DBF. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Employee Dump Report prints out all data on all ║ ║or a specific employee. ║ ║Report is 80 characters wide. ║ ║ ║ ║Not a Report Form. ║ ║ ║ ║Print All Employees! ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EMPDUMP.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 32 ■ EMPLOYEE ADDRESS LABELS You have the option to print labels for all the employees: ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the Employee address ║ ║Labels. The Address Label is the standard size of ║ ║3.5 x 15/16 (at 6LPI). ║ ║ ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │░░░█▄██░░░░█░░░█░░░█░░▄██▄░░░░│ ║ ║ │░░░█░░█░░░█▀█░░▀█░█▀░░█░░█░░░░│ ║ ║ │░░░█░░█░░░█▄█░░░▀█▀░░░█░░█░░░░│ ║ ║ │░░░█░░█░░█▀░▀█░░░█░░░░█░░█░░░░│ ║ ║ │░░░█▀██░░█░░░█░░░█░░░░▀██▀░░░░│ ║ ║ ╘══════════════════════════════╛ ║ ║ ║ ║ ║ ║Do you wish to run labels for all employees? (Y/N) ║ ║ ║ ║Enter number of labels per employee: 3 ║ ║ ║ ║Ready printer, then press any key to start! ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ Or individually: ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the Employee address ║ ║Labels. The Address Label is the standard size of ║ ║3.5 x 15/16 (at 6LPI). ║ ║ ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │Susie Martin │ ║ ║ │394 East Lane │ ║ ║ │Winter Park, FL │ ║ ║ │32819-2029 │ ║ ║ │ │ ║ ║ ╘══════════════════════════════╛ ║ ║ ║ ║ NUMBER NAME ║ ║Select Employee ->000101 Susie Martin ║ ║ 000102 Joe Martin ║ ║ 000103 Jane Martin ║ ║ 000104 George Martin ║ ║ ║ ║Esc(Exit) Enter/Return(Print) F5/F6/F7/F8/F9(Find) ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 33 ■ RESET QUARTER & YTD FIELDS *** If you are ever in doubt about the quarterly or year to date (YTD) sums in the employee's database (PAY.DBF) or the quarterly summary database (QTR_SUM.DBF), then use this routine to reset those fields. No printed report is generated with this routine. Run as often as necessary... DAYO Payroll Version 3.0 TJS LAB REPORTS ┌───[February 1991]──┐ ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄███░████░████░████░█████░ ▄██▄ █████░█▄███░ █░ █░█████░█▄███░ ║ ║ █░ █░█░ █░ █░ █░ █░ █░ █░ █░ █░ █ █▄ ▄█░ █░ █░ █░ ║ ║ █████░███░ ████░███░ █░ █░ █░ █░ █████░ ███ ███░ █░ █░ █░ ║ ║ █░ █░ █░ █░█░ █░ █░ █░ █░ █░ █░ █ █░ █░ █░ █░ ║ ║ █░ ██░████░████░████░ █░ ▀██▀█░ █░ █░ ██░ █░ █░ █▀███░ ║ ║ ║ ║ ║ ║ This routine resets the YTD_ and QTR_ fields in the employee database ║ ║ and the quarter summary in the database: QTR_SUM.DBF. ║ ║ ║ ║ Data is derived from the posted payroll database: PAYROLL.DBF ║ ║ ║ ║ Continue? (Y/N) ║ ║ ║ ║ Enter Year Starting Date: 01/01/91 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) The progress is displayed onto the screen: Current Employee: 000011 GEORGE MOONILAL (9 of 36) ╔═[ Employees ]════════════════════════════════════════════════════════════╗ ╟██████████████████──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢ ╚═════════════════╪══════════════════╪══════════════════╪══════════════════╝ 1 9 18 27 36 Posting: PAY.DBF QTR_SUM.DBF PAY_SUM.DBF DAYO PAYROLL, TJS LAB Orlando, Florida Page: 34 ■ CURRENT PAYROLL SUMMARY REPORT This report summarizes the current payroll values. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Current Payroll Summary Report reports totals ║ ║for the current payroll. Data is derived from the ║ ║database EMPLOYEE.DBF. ║ ║* This report is not valid after a Payroll Posting! ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PAYROLL.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CURRENT PRE-POST PAYROLL REPORT 07/22/90 Current PRE-POST Payroll Report for Week Ending: 07/21/90 -------------------------------------------- Current QUARTER YTD ---------- ---------- ---------- Regular Wages: 400.00 400.00 400.00 Overtime Wages: 180.00 180.00 180.00 Premium Wages: 0.00 0.00 0.00 Sick Pay: 0.00 0.00 0.00 Vacation Pay: 0.00 0.00 0.00 Other Wages: 100.01 100.01 100.01 ---------- ---------- ---------- Federal Tax: 107.32 107.32 107.32 FICA Tax: 43.37 43.37 43.37 Medicare: 1.00 1.00 1.00 State: 0.00 0.00 0.00 SDI Tax: 0.00 0.00 0.00 Deductions: ---------- ---------- ---------- Deduction # 1: 100.00 100.00 100.00 Deduction # 2: 0.00 0.00 0.00 Deduction # 3: 0.00 0.00 0.00 Deduction # 4: 0.00 0.00 0.00 Deduction # 5: 0.00 0.00 0.00 Deduction # 6: 0.00 0.00 0.00 Deduction # 7: 0.00 0.00 0.00 Deduction # 8: 0.00 0.00 0.00 ---------- ---------- ---------- Exempt: 0.00 0.00 0.00 Non Exempt: 100.00 100.00 100.00 ---------- ---------- ---------- Gross Wages: 680.01 680.01 680.01 ---------- ---------- ---------- Net Wages: 428.32 428.32 428.32 ---------- ---------- ---------- DAYO PAYROLL, TJS LAB Orlando, Florida Page: 35 ■ POSTED PAYROLL SUMMARY REPORT This report summarizes selected payroll periods. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Posted Payroll Summary Report reports totals ║ ║for the posted payroll. Data is derived from the ║ ║database PAYROLL.DBF. ║ ║This report is valid only after a Payroll Posting! ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Select Pay Period: 07/21/90 ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PAYPOST.TXT ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 36 ■ EXAMPLE OF A POSTED PAYROLL REPORT 07/22/90 POSTED Payroll Report for Week Ending: 07/21/90 TJS LAB -------------------------------------------- ---------- Regular Wages: 400.00 Overtime Wages: 180.00 Premium Wages: 0.00 Sick Pay: 0.00 Vacation Pay: 0.00 Other Wages: 100.01 ---------- Federal Tax: 107.32 FICA Tax: 43.37 Medicare: 1.00 State: 0.00 SDI Tax: 0.00 Deductions: ---------- Deduction # 1: 100.00 Deduction # 2: 0.00 Deduction # 3: 0.00 Deduction # 4: 0.00 Deduction # 5: 0.00 Deduction # 6: 0.00 Deduction # 7: 0.00 Deduction # 8: 0.00 ---------- Gross Wages: 680.01 ---------- Net Wages: 428.32 ---------- DAYO PAYROLL, TJS LAB Orlando, Florida Page: 37 ■ QUARTERLY PAYROLL SUMMARY This report prints the quarterly summary. Data is derived from the database QTR_SUM.DBF. ╔═══════════════════════════════════════════════════════╗ ║The Quarterly Payroll Summary Report reports totals ║ ║for the selected quarter. Data is derived from the ║ ║database QTR_SUM.DBF. ║ ║This report is valid only after a Payroll Posting! ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║ Select Quarter ->1st Quarter ║ ║ 2nd Quarter ║ ║ 3rd Quarter ║ ║ 4th Quarter ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Quarterly Payroll Summary Report reports totals ║ ║for the selected quarter. Data is derived from the ║ ║database QTR_SUM.DBF. ║ ║This report is valid only after a Payroll Posting! ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║ Select Quarter ->1st Quarter ║ ║ ║ ║Enter Report Title: TJS LAB 1st Quarter ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: QTR_SUM.TXT ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 38 ■ EXAMPLE OF THE QUARTERLY SUMMARY REPORT 07/22/90 Year to Date Payroll Report TJS LAB -------------------------------------------- Regular Wages: 3520.20 Overtime Wages: 33.00 Premium Wages: 0.00 Sick Pay: 530.00 Vacation Pay: 53.21 Other Wages: 403.00 ---------- Federal Tax: 704.32 FICA Tax: 529.00 Medicare: 1.21 State: 10.00 SDI Tax: 0.00 Deductions: ---------- Exempt: 0.00 Non Exempt: 55.00 ---------- Gross Wages: 4539.21 ---------- Net Wages: 3239.68 ---------- ■ YEAR TO DATE (YTD) SUMMARY REPORT This report will report the year to date payroll summary. Data is derived from the database PAY_SUM.DBF. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Year to Date Payroll Summary Report reports ║ ║totals for the entire year. Data is derived from ║ ║the database PAY_SUM.DBF. ║ ║Report is 80 characters wide. ║ ║Not a Report Form! ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: YTD_SUM.TXT ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 39 ■ EXAMPLE OF THE YEAR TO DATE (YTD) PAYROLL REPORT 07/22/90 Year to Date Payroll Report TJS LAB -------------------------------------------- Regular Wages: 3520.20 Overtime Wages: 33.00 Premium Wages: 0.00 Sick Pay: 530.00 Vacation Pay: 53.21 Other Wages: 403.00 ---------- Federal Tax: 704.32 FICA Tax: 529.00 Medicare: 1.21 State: 10.00 SDI Tax: 0.00 Deductions: ---------- Exempt: 0.00 Non Exempt: 55.00 ---------- Gross Wages: 4539.21 ---------- Net Wages: 3239.68 ---------- ■ PAYROLL DETAIL REPORT This is really 3 reports in 1 depending on the index selected. A subtotal will be given for the first 2 options (PAYROLL DATE & EMPLOYEE NUMBER). ╔═══════════════════════════════════════════════════════╗ ║The Payroll Detail Report lists all Payroll Records ║ ║within the selected date range. ║ ║Report is 131 characters wide. ║ ║ ║ ║Uses Report Forms PAYROLL1/PAYROLL2/PAYROLL3.FRM. ║ ║ ║ ║Select the Index -> Payroll Date + Number ║ ║ Employee Number ║ ║ Check Number ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 40 Prompts will appear for the start and ending dates for the report. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Payroll Detail Report lists all Payroll Records ║ ║within the selected date range. ║ ║Report is 131 characters wide. ║ ║ ║ ║Uses Report Forms PAYROLL1/PAYROLL2/PAYROLL3.FRM. ║ ║ ║ ║Select the Index -> Payroll Date + Number ║ ║ ║ ║Start Date: 01/01/90 Ending Date: 07/21/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PAYDET.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ STATE TAX SUMMARY - STATE CODE This report is used to compute the total amount due to each state that receives revenue from you. This report subtotals on each state code found in the database PAYROLL.DBF. Prompts for the start and ending dates are given. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The State Tax Report summarizes State Tax for ║ ║each state. ║ ║Report is 80 characters wide. ║ ║ ║ ║Uses Report Form STATE1.FRM. ║ ║ ║ ║Start Date: 01/01/90 Ending Date: 07/21/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: STATESUM.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 41 ■ EXAMPLE OF THE STATE TAX SUMMARY REPORT Page No. 1 TJS LAB 07/22/90 STATE TAX SUMMARY BY STATE Regular Premium Other Sick Vacation SDI State Pay Pay Pay Pay Pay Tax Tax ---------- ---------- ---------- --------- --------- ---------- ---------- ** State Code: FL ** Subtotal ** 400.00 0.00 100.01 0.00 0.00 0.00 3.00 ** State Code: GA ** Subtotal ** 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ** State Code: SC ** Subtotal ** 0.00 0.00 100.00 0.00 0.00 0.00 23.00 *** Total *** 400.00 0.00 200.01 0.00 0.00 0.00 26.00 ■ STATE TAX SUMMARY - CLASS CODE This report is used to verify posting to DAYO General Ledger (GL) since GL posting is determine by CLASS codes. Prompts for the start and ending dates are given. This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The State Tax Report summarizes State Tax for ║ ║each CLASS. ║ ║Report is 80 characters wide. ║ ║ ║ ║Uses Report Form STATE2.FRM. ║ ║ ║ ║Start Date: 01/01/90 Ending Date: 07/21/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: STATECLS.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 42 ■ EXAMPLE OF THE STATE TAX SUMMARY - BY CLASS CODE Page No. 1 TJS LAB 07/22/90 STATE TAX SUMMARY BY CLASS CODE Regular Premium Other Sick Vacation SDI State Pay Pay Pay Pay Pay Tax Tax ---------- ---------- ---------- --------- --------- ---------- ---------- ** Class Code: STX ** Subtotal ** 400.00 1210.00 100.01 4.00 0.00 0.00 200.00 ** Class Code: SCX ** Subtotal ** 400.00 10.00 20.01 4.00 0.00 0.00 220.00 ** Class Code: SXX ** Subtotal ** 400.00 10.00 20.01 4.00 0.00 0.00 230.00 *** Total *** 400.00 1230.00 140.03 12.00 0.00 0.00 650.00 ■ REPRINT CHECKS You can use this option to reprint checks. Check records must be for the current period and already be created (found in the database PAYROLL.DBF) before they can be printed/reprinted. When check records are initially created, check numbers are assigned to them. You can overwrite this assignment of check numbers... ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░█▄██░░███░░█▄██░░█▄██░░███░░█░░░█░░█████░░░░░███░░█░░█░░███░░███░░█░░█░░▄██▄░ ░█░░█░░█░░░░█░░█░░█░░█░░░█░░░██░░█░░░░█░░░░░░░█░▀░░█░░█░░█░░░░█░▀░░█░██░░█░░░░ ░█▄▄█░░█▄░░░█▄▄█░░█▄▄█░░░█░░░███░█░░░░█░░░░░░░█░░░░█▄▄█░░█▄░░░█░░░░█▄█░░░▀██▄░ ░█▀█░░░█░░░░█░░░░░█▀█░░░░█░░░█░███░░░░█░░░░░░░█░░░░█░░█░░█░░░░█░░░░██▄░░░░░░█░ ░█░██░░█░░░░█░░░░░█░██░░░█░░░█░░██░░░░█░░░░░░░█░▄░░█░░█░░█░░░░█░▄░░█░██░░░░░█░ ░█░░█░░███░░█░░░░░█░░█░░███░░█░░░█░░░░█░░░░░░░███░░█░░█░░███░░███░░█░░█░░▀██▀░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ╔════════════════════════════════════════════════════════════════════════════╗ ║ Use this report/routine to print/reprint posted check records. ║ ║ Posted checks can be found in the database PAYROLL.DBF. ║ ║ Only Current Payroll checks can be printed/reprinted. ║ ║ The check records already have a check number assigned to them. ║ ║ Do you wish to overwrite this number & start new sequence? (Y/N) ║ ║ Enter New Starting Check Number: 118 ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 43 Reprints can be made for ALL employees or a specific pay period type. Press 'T' to print a voided check to verify your printer alignment, press 'C' to start printing the actual checks. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Use this report/routine to print/reprint posted check records. ║ ║ Posted checks can be found in the database PAYROLL.DBF. ║ ║ Only Current Payroll checks can be printed/reprinted. ║ ║ The check records already have a check number assigned to them. ║ ║ Do you wish to overwrite this number & start new sequence? (Y/N) ║ ║ Enter New Starting Check Number: 118 ║ ║ Print Checks & Post Payroll For ->All Employees ║ ║ Do you want to pause between checks? (Y/N) ║ ║ ║ ║ Okay, Ready The Printer! ║ ║ Select Option -> Continue/Start Printing ║ ║ Print TEST Pattern ║ ║ Esc - Abort Printing & Exit ║ ╚════════════════════════════════════════════════════════════════════════════╝ A facsimile of the printed check is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░Employee Check Check ░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░Number Date Number ░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░000101░░░░07/21/90░░118 ░░░░░░░║ ║░░░One Thousand, Five Hundred Thirty Dollars & Two Cents░░░░░░░░░░░░░░░░░░░║ ║░░░ 1530.02░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░Sally Southard ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░4020 Senic Lake Drive ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░# 3 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░Walterboro, GA 30912 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... If you had selected Y (Yes) to the prompt to 'pause between checks', you need to press any key between the checks. DAYO PAYROLL, TJS LAB Orlando, Florida Page: 44 ■ ROLL PAYROLL YEAR VERY DANGEROUS! USE WITH EXTREME CAUTION AND ONLY AFTER A FULL BACKUP! At some point after the end of each payroll year, this option needs to be run to 'clean out' previous year data. ╔════════════════════════════════════════════════════════════════════════════╗ ║█▀▀█ ▄██▄ █ █ █▀▀█ █ █ █ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█║ ║█▄▄█ █ █ █ █ █▄▄█ █▀█ ▀█ █▀ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█║ ║█▀█▄ █ █ █ █ █ ▄█▄█▄ ▀█▀ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄║ ║█ █ ▀██▀ ███ ███ █ █ █ █ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █║ ║ ║ ║ This routine should only be run at the end/beginning of a new account year.║ ║ All payroll data in the following databases will be set to Zero (0). ║ ║ PAY.DBF, PAYROLL.DBF, PAY_SUM.DBF, QTR_SUM.DBF. ║ ║ ║ ║ Data/Records from database PAYROLL.DBF will be appended into the payroll ║ ║ history database PAYHIST.DBF. ║ ║ It is highly recommended that a complete data backup is perform prior to ║ ║ performing this operation! *** Use with caution! *** ║ ║ ║ ║ Do you want to start the ROLL? (Y/N) ║ ║ ║ ║ Are you really sure? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ The progress of this process is printed onto the screen. The final set of zeroing out the employee database (PAY.DBF) is depicted with a progress graph. ╔════════════════════════════════════════════════════════════════════════════╗ ║█▀▀█ ▄██▄ █ █ █▀▀█ █ █ █ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█║ ║█▄▄█ █ █ █ █ █▄▄█ █▀█ ▀█ █▀ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█║ ║█▀█▄ █ █ █ █ █ ▄█▄█▄ ▀█▀ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄║ ║█ █ ▀██▀ ███ ███ █ █ █ █ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █║ ║ ║ ║ This routine should only be run at the end/beginning of a new account year.║ ║ All payroll data in the following databases will be set to Zero (0). ║ ║ PAY.DBF, PAYROLL.DBF, PAY_SUM.DBF, QTR_SUM.DBF. ║ ║ ║ ║ Data/Records from database PAYROLL.DBF will be appended into the payroll ║ ║ history database PAYHIST.DBF. ║ ║ ║ ║ APPENDING DATA FROM PAYROLL.DBF INTO PAYHIST.DBF - Completed! ║ ║ ZAP PAYROLL.DBF - Completed! ║ ║ ZAP PAY_SUM.DBF - Completed! ║ ║ ZAP PAY_SUM.DBF - Completed! ║ ║ Zeroing out payroll data/fields in database PAY.DBF ║ ║╔══════════════════════════════════════════════════════════════════════════╗║ ║╟█████████████████████████████████████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢║ ║╚══════════════════════════════════════════════════════════════════════════╝║ ║0% 50% Finis║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 45 ■ W2s This is not an official W2 form. It is recommended that you receive the annual 'fix' from TJS LAB, or create a report of your own to print the 'official' W2 form. The first prompt is for the year to be reported. The second prompt is for the number of copies of each (prints 3 per page). The third prompt is to select the database that the payroll data will be found in. If the payroll year has been 'rolled', then you will have to select the payroll history database (PAYHIST.DBF). ╔═══════════════════════════════════════════════════════╗ ║This routine prints a non-official copy of the W2. ║ ║Data is derived from either the current year payroll ║ ║database PAYROLL.DBF or the payroll history database ║ ║PAYHIST.DBF (use PAYHIST.DBF if you rolled the year). ║ ║Report is 80 characters wide. Not a Report Form! ║ ║ Enter Year (ie: 1991): 1990 ║ ║ Enter Number of copies: 1 ║ ║ Select Database -> Current Payroll (PAYROLL.DBF) ║ ║ Payroll History (PAYHIST.DBF) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═╣ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ╠═╝ The next prompt is for the index: ╔═══════════════════════════════════════════════════════╗ ║This routine prints a non-official copy of the W2. ║ ║Data is derived from either the current year payroll ║ ║database PAYROLL.DBF or the payroll history database ║ ║PAYHIST.DBF (use PAYHIST.DBF if you rolled the year). ║ ║Report is 80 characters wide. Not a Report Form! ║ ║ Enter Year (ie: 1991): 1990 ║ ║ Enter Number of copies: 1 ║ ║ Select Database -> Current Payroll (PAYROLL.DBF) ║ ║ ║ ║ Select Index -> NUMBER ║ ║ NAME ║ ║ SSN ║ ║ CLASS + NUMBER ║ ║ TYPE + NUMBER ║ ║ STATE + NUMBER ║ ║ DEPARTMENT + NUMBER ║ ║ DEPARTMENT + NAME ║ ║ DEPARTMENT + SSN ║ ║ DEPARTMENT + CLASS + NUMBER ║ ║ DEPARTMENT + TYPE + NUMBER ║ ╚═╣ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ╠═╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 46 Up to 12 indexes are available: NUMBER DEPARTMENT + NUMBER NAME DEPARTMENT + NAME SSN DEPARTMENT + SSN CLASS + NUMBER DEPARTMENT + CLASS + NUMBER TYPE + NUMBER DEPARTMENT + TYPE + NUMBER STATE + NUMBER DEPARTMENT + STATE + NUMBER All but the NUMBER, NAME, SSN, and DEPARTMENT+NAME selections require the creation of a temporary index. The progress of the index creation is displayed onto the screen: ┌──────────────────────────────────────────────────────────┐ │ Database Name: PAY.DBF │ │ Index Name: TEMP55.NTX │ │ Number of Records: 5 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ After the indexing (if any is required), you will be prompted to direct the report to the printer or to a disk file: ╔═══════════════════════════════════════════════════════╗ ║This routine prints a non-official copy of the W2. ║ ║Data is derived from either the current year payroll ║ ║database PAYROLL.DBF or the payroll history database ║ ║PAYHIST.DBF (use PAYHIST.DBF if you rolled the year). ║ ║Report is 80 characters wide. Not a Report Form! ║ ║ Enter Year (ie: 1991): 1990 ║ ║ Enter Number of copies: 1 ║ ║ Select Database -> Current Payroll (PAYROLL.DBF) ║ ║ ║ ║ Select Index -> DEPARTMENT + CLASS + NUMBER ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: W2.TXT ║ ║George Moonilal 234-23-4344 78000.06 ║ ║Joe Morial 233-20-5555 41210.00 ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═╣████████████████████ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ╠═╝ Standby, While I Print the report... Press Esc to abort... DAYO PAYROLL, TJS LAB Orlando, Florida Page: 47 ■ EXAMPLE OF THE W2 - - - - - - - - - - - - - - - - - - - - W-2 Wage and Tax Statement 1990 *** Not For Official Use *** Control #: 1990-1 Employee Number: 101010 Employer's Name, Address, and Zip Code..........Employer's Federal ID# TJS LAB 123456-019-10292 Attn: Finance & Payroll Employer's State ID# P.O. BOX 585366 SC-910-1029-3 Orlando, Florida 32858-5366 Employee Stats (407)-291-3960 Active BOX SAL A W Employee's SSN.....Federal Withholding..........Gross Wages..FICA Withholding 393-92-0204 3278.04 12040.03 741.25 Medicare Withholding: 7.01 Employee's Name (first middle last).............FICA Wages...Medicare Wages Susan Morgan 12040.03 7.01 394 East Lancaster Road State Income Tax...Tax State Suite A-4 0.00 FL Altamonte Springs, FL 39718-1903 State SDI Withholding 0.00 Regular Pay....Overtime.....Premium.......Other........Sick....Vacation 11200.00 540.00 0.00 300.03 0.00 0.00 ...Net Pay......Taxable Deductions....Tax Exempt Deductions 7644.73 69.00 300.00 - - - - - - - - - - - - - - - - - - - - W-2 Wage and Tax Statement 1990 *** Not For Official Use *** Control #: 1990-2 Employee Number: 101011 Employer's Name, Address, and Zip Code..........Employer's Federal ID# Morgan's House of Flowers, Inc. 123456-019-10292 Attn: Herman Morgan Employer's State ID# P.O. Box 3939 SC-910-1029-3 Winter Park, FL 32828-1166 Employee Stats (407)-495-3009 Active AV AAA 13M B Employee's SSN.....Federal Withholding..........Gross Wages..FICA Withholding DAYO PAYROLL, TJS LAB Orlando, Florida Page: 48 ■ YEAR TO DATE (YTD) PAYROLL GRAPH This onscreen report consists of a summary (by calendar month) of the total wages and taxes for the current year. If you wish a print out, you must print the screen (Prt Scrn). The initial screen displays the progress of the routine: 07/21/90 Year to Date Payroll Graph TJS LAB ┼ ╔═══════════════════════════════════════════════╗ ┼ ║ Month Wages Taxes Total ║ ┼ ║ Jan 64334.88 38285.17 102620.05 ║ ┼ █████ ║ Feb 85359.76 50096.46 135456.22 ║ ┼ Total ║ Mar 125910.80 71236.20 197147.00 ║ ┼ ║ Apr 23099.95 12982.42 36082.37 ║ ┼ ▓▓▓▓▓ ║ May 56266.53 33353.67 89620.20 ║ ┼ Wages ║ Jun 6402.00 1409.94 7811.94 ║ ┼ ║ ║ ┼ ▒▒▒▒▒ ║ ║ ┼ Taxes ║ ║ ┼ ║ ║ ┼ ║ ║ ┼ ║ ║ ┼ ╚═══════════════════════════════════════════════╝ ┼ ┼ ┼ ┼ ├─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┤ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec DAYO PAYROLL, TJS LAB Orlando, Florida Page: 49 After the routine has computed the year to date summary, a graph is 'painted' onto the screen. After a few seconds, the message at the bottom of the screen ('Press any key to continue...') will disappear, so that a print screen will not include it... 07/21/90 Year to Date Payroll Graph TJS LAB ┼ █████ ┼ █████ ┼ █████ ┼ █████ █████ ┼ Total █████ ┼ █████ ┼ ▓▓▓▓▓ ██▒▒█ ┼ Wages ██▒▒█ ┼ ██▒▒█ ┼ ▒▒▒▒▒ ██▒▒█ ┼ Taxes ██▒▓▓ █████┼ ██▒▓▓ █████┼ ██▒▓▓ ██▒▒█┼ ██▒▓▓ ██▒▒█┼ ██▒▓▓ ██▒▓▓┼ ██▒▓▓ ██▒▓▓┼ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓┼ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓┼ ├─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┤ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec DAYO PAYROLL, TJS LAB Orlando, Florida Page: 50 After a few seconds (or if you press any key), the summary is redisplayed onto the screen overtop the graph (for better visuals...). Another print screen may take place at this point... 07/21/90 Year to Date Payroll Graph TJS LAB ┼ ╔═══════════════════════════════════════════════╗ ┼ ║ Month Wages Taxes Total ║ ┼ ║ Jan 64334.88 38285.17 102620.05 ║ ┼ █████ ║ Feb 85359.76 50096.46 135456.22 ║ ┼ Total ║ Mar 125910.80 71236.20 197147.00 ║ ┼ ║ Apr 23099.95 12982.42 36082.37 ║ ┼ ▓▓▓▓▓ ║ May 56266.53 33353.67 89620.20 ║ ┼ Wages ║ Jun 6402.00 1409.94 7811.94 ║ ┼ ║ Jul 5573345.61 3207360.23 8780705.84 ║ ┼ ▒▒▒▒▒ ║ Aug 98466.41 56878.90 155345.31 ║ ┼ Taxes ║ Sep 70333.14 40486.47 110819.61 ║ █████┼ ║ Oct 103155.28 60604.80 163760.08 ║ █████┼ ║ Nov 112602.04 64814.04 177416.08 ║ ██▒▒█┼ ║ Dec 2177014.80 1255939.12 3432953.92 ║ ██▒▒█┼ ╚═══════════════════════════════════════════════╝ ██▒▓▓┼ ██▒▓▓ ██▒▓▓┼ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓┼ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓ ██▒▓▓┼ ├─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┼─────┤ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ CONFIGURATION STATUS REPORT This report can be directed to the printer or to a file. ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOPAY.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 51 ■ EXAMPLE OF THE CONFIGURATION REPORT +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + DAYO PAYROLL CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 07/22/90 12:22:05 Company Name: TJS LAB Address Line 1: Attn: Finance & Payroll Address Line 2: P.O. BOX 585366 City, State Zip: Orlando, Florida 32858-5366 Telephone: (407)-291-3960 FICA Maximum: 53400.00 FICA Rate: 0.06200 Medicare Maximum: 125000.00 Medicare Rate: 0.01450 SDI Maximum: 0.00 SDI Rate: 0.0000 Default State Tax Code: Default State Tax Rate: 0.0000 Last Check Number: 0 Last Employee Number: 0 Overtime Factor: 1.500 Default Pay Period: W Default Hours per Week: 40 Fed. Exemption Amount: 51300.00 1st Quarter Date: 01/01/90 2nd Quarter Date: 04/01/90 3rd Quarter Date: 07/01/90 4th Quarter Date: 10/01/90 Default Check Comment/Note: Report Printer Type: STANDARD Report Printer Port: LPT1 Visual Indexing: Yes Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes DAYO PAYROLL, TJS LAB Orlando, Florida Page: 52 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 8397 │ 07/21/90 ║ ║RUNA0790.TXT │ 120 │ 07/21/90 ║ ║EMPXPAND.TXT │ 1321 │ 07/21/90 ║ ║EMPPAY.TXT │ 130 │ 07/21/90 ║ ║EMPPER.TXT │ 130 │ 07/21/90 ║ ║EMPLIST.TXT │ 514 │ 07/21/90 ║ ║PAYNOTES.TXT │ 130 │ 07/21/90 ║ ┌────────────────────────┐ ║EMPDUMP.TXT │ 130 │ 07/21/90 ║ │ Highlight the Report │ ║PAYROLL.TXT │ 2129 │ 07/21/90 ║ │ using the │ ║QTR_SUM.TXT │ 938 │ 07/21/90 ║ │ arrow keys, then press │ ║YTD_SUM.TXT │ 930 │ 07/21/90 ║ │ Enter/Return. │ ║PAY0790.TXT │ 10982 │ 07/21/90 ║ └────────────────────────┘ ║PAYPOST.TXT │ 1176 │ 07/21/90 ║ ║CONFIG.TXT │ 1495 │ 07/21/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 53 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYO PAYROLL View Reports │ File Name: PAYDET1.TXT 07/21/90 PAYROLL DETAIL LISTING INDEXED BY EMPLOYEE NUMBE Reg Over Prem Federal State State Hours Hours Hours Gross Tax FICA Tax Ins ------- ------- ------- ---------- ---------- ---------- ---------- ---------- ** EMPLOYEE NUMBER: ** Subtotal ** 0 0 0 0 0 0 0 0 *** Total *** 0 0 0 0 0 0 0 0 Esc (Exit) F1 (Help) DAYO PAYROLL, TJS LAB Orlando, Florida Page: 54 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from manually setting the printer options by allowing you to make changes automatically with the keyboard. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO PAYROLL, TJS LAB Orlando, Florida Page: 55 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 56 ■ CONFIGURATION There are currently 34+ configuration settings. Many of these settings determine how your payroll will be computed! The initial Configuration Menu display does not show all configuration options. Use the down/up arrow keys to view/edit the others... DAYO Payroll Version 3.31 TJS LAB CONFIG ┌───[February 1991]──┐ ╔════════════════════════╗ │S M T W T F S │ ║ CONFIGURATION ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ Company Name ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Company Address ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ Company Telephone ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ FICA Maximum ║ █▀██▀ █░ █░ █░ ▀███▀ │29 30 31 │ ║ FICA Rate ║ │ │ ║ SDI Maximum ║ └────────────────────┘ ║ SDI Rate ║ ║ Default State Tax Code ║ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ ║ Default State Tax Rate ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ ║ Last Check Number ║ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ ║ Last Employee Number ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ ║ Overtime Factor ║ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ ║ Premium Factor ║ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ ║ Default Pay Period ║ ║ Default Hours per Week ║─────╖ ║ Fed. Exemption Amount ║ Size║ ║ Quarter Dates ║10823║ ╟────────────────────────╢59302║ ║ Select Option ║66232║ ╚════════════════════════╝═════╝ ■ CONFIGURATION LIST Company Name Medicare Maximum Company Address Medicare Rate Company Telephone Premium Factor FICA Maximum Default Pay Period FICA Rate Default Hours per Week SDI Maximum Fed. Exemption Amount SDI Rate Quarter Dates Default State Tax Code Default Check Comment Default State Tax Rate Report Printer Type Last Check Number Report Printer Port Last Employee Number Visual Indexing Overtime Factor Auto Daily Indexing Edit Federal Tax Table Color GL Database Location High Intensity Automatic GL Posting Current Directory Federal Employer Number State Employer # Left Margin for Check Run Payroll..FICA Only DAYO PAYROLL, TJS LAB Orlando, Florida Page: 57 ■ COMPANY NAME ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: TJS LAB │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ADDRESS ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Finance & Payroll │ │ Address Line 2: P.O. BOX 585366 │ │ City, State ZIP: Orlando, Florida 32858-5366 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: (407)-291-3960 │ └────────────────────────────────────────────────────────────────────────────┘ ■ MAXIMUM FEDERAL INSURANCE CONTRIBUTIONS ACT (FICA) DEDUCTION ┌──────[ MAXIMUM FEDERAL INSURANCE CONTRIBUTIONS ACT (FICA) DEDUCTION ]──────┐ │ This amount is established (usually every year) by the I.R.S. │ │ Wages (up to this amount) are subject to the FICA tax. │ │ Default maximum amount (1991) is $53,400.00. │ │ │ │ Enter the Maximum FICA deduction amount: 53400.00 │ └────────────────────────────────────────────────────────────────────────────┘ ■ FICA PERCENTAGE RATE ┌──────────────────────────[ FICA PERCENTAGE RATE ]──────────────────────────┐ │ This rate is the percentage of the employee's gross wage that is to be │ │ withheld. Default percentage rate (1991) is .06200% │ │ │ │ Enter the FICA percentage rate: 0.062000 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 58 These options are new as of 1991! *** ■ MAXIMUM MEDICARE DEDUCTION ┌───────────────────────[ MAXIMUM MEDICARE DEDUCTION ]───────────────────────┐ │ This amount is established (usually every year) by the I.R.S. │ │ Wages (up to this amount) are subject to the Medicare tax. │ │ Default maximum amount (1991) is $125,000.00. │ │ │ │ Enter the Maximum Medicare deduction amount: 125000.00 │ └────────────────────────────────────────────────────────────────────────────┘ ■ MEDICARE PERCENTAGE RATE ┌────────────────────────[ MEDICARE PERCENTAGE RATE ]────────────────────────┐ │ This rate is the percentage of the employee's gross wage that is to be │ │ withheld. Default percentage rate (1991) is .01450% │ │ │ │ Enter the Medicare percentage rate: 0.014500 │ └────────────────────────────────────────────────────────────────────────────┘ ■ MAXIMUM STATE INSURANCE (SDI) DEDUCTION ┌────────────────[ MAXIMUM STATE INSURANCE (SDI) DEDUCTION ]─────────────────┐ │ This amount is established (usually every year) by states. │ │ Wages (up to this amount) are subject to the SDI tax. │ │ Default maximum amount $0.00. │ │ │ │ Enter the Maximum SDI deduction amount: 0.00 │ └────────────────────────────────────────────────────────────────────────────┘ ■ SDI PERCENTAGE RATE ┌──────────────────────────[ SDI PERCENTAGE RATE ]───────────────────────────┐ │ This rate is the percentage of the employee's gross wage that is to be │ │ withheld. Default percentage rate is .000000% │ │ │ │ Enter the SDI percentage rate: 0.000000 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 59 ■ DEFAULT STATE TAX CODE ┌─────────────────────────[ DEFAULT STATE TAX CODE ]─────────────────────────┐ │ This code is used in determining what percentage rate (if any) is to be │ │ used when/if state taxes are to be withheld. Default code is nil. │ │ │ │ Enter the Default State Code: │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT STATE TAX RATE ┌─────────────────────────[ DEFAULT STATE TAX RATE ]─────────────────────────┐ │ This rate is the percentage of the employee's gross wage that is to be │ │ withheld for state taxes. Default percentage rate is .000000% │ │ │ │ Enter the State Tax percentage rate: 0.000000 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST PAYROLL CHECK NUMBER USED ┌─────────────────────[ LAST PAYROLL CHECK NUMBER USED ]─────────────────────┐ │ This is the last payroll check number used. The default next check │ │ number will equal the value of this number plus one... │ │ │ │ Enter the Last Payroll Check Number: 119 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST EMPLOYEE NUMBER USED ┌───────────────────────[ LAST EMPLOYEE NUMBER USED ]────────────────────────┐ │ This is the last employee number created. The default next employee │ │ number will equal the value of this number plus one... │ │ │ │ Enter the Last Employee Number: 2 │ └────────────────────────────────────────────────────────────────────────────┘ ■ OVERTIME FACTOR ┌────────────────────────────[ OVERTIME FACTOR ]─────────────────────────────┐ │ This is the value/factor used when determining the amount of overtime │ │ wages. The overtime hours and rate are multiplied by this factor. │ │ IE: OVERTIME_PAY = ( RATE * OVERTIME_HOURS ) * OVERTIME_FACTOR │ │ │ │ Enter the Overtime Factor: 1.50000 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 60 ■ PREMIUM FACTOR ┌─────────────────────────────[ PREMIUM FACTOR ]─────────────────────────────┐ │ This is the value/factor used when determining the amount of premium │ │ overtime wages. The premium hours and rate are multiplied by this │ │ factor. IE: PREMIUM_PAY = ( RATE * PREMIUM_HOURS ) * PREMIUM_FACTOR │ │ │ │ Enter the Premium Factor: 2.00000 │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT PAY PERIOD ┌───────────────────────────[ DEFAULT PAY PERIOD ]───────────────────────────┐ │ Pay Periods are either Weekly, BiWeekly, or Monthly. │ │ Valid codes are W, B, and M. │ │ Default Pay Period is Weekly ->"W". │ │ │ │ Select the Default Pay Period Code -> W - Weekly │ │ B - BiWeekly │ │ M - Monthly │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT WEEKLY HOURS ┌──────────────────────────[ DEFAULT WEEKLY HOURS ]──────────────────────────┐ │ This is the number of hours that are normally worked in a week. │ │ Default BiWeekly wages are twice this amount, Default Monthly wages │ │ are four times this amount. Default is 40 hours. │ │ │ │ Enter the normal number of hours worked per week: 40 │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXEMPTION AMOUNT ┌────────────────────────────[ EXEMPTION AMOUNT ]────────────────────────────┐ │ This is the amount (times the number of exemptions) that is exempt │ │ from federal taxes. │ │ Default is $2050.00. │ │ │ │ Enter the Exemption Amount: 2050.00 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 61 ■ QUARTERLY START DATES ┌─────────────────────────[ QUARTERLY START DATES ]──────────────────────────┐ │ These dates divide your payroll year into Quarters and determine which │ │ Quarter receives payroll totals. │ │ Default Settings: 1st Quarter: 01/01/90 │ │ 2nd Quarter: 04/01/90 │ │ 3rd Quarter: 07/01/90 │ │ 4th Quarter: 10/01/90 │ │ Current Settings: 1st Quarter: 01/01/90 │ │ 2nd Quarter: 04/01/90 │ │ 3rd Quarter: 07/01/90 │ │ 4th Quarter: 10/01/90 │ │ │ │ Do you wish to change the Current Quarterly Start Dates? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT CHECK COMMENT/NOTE ┌───────────────────────[ DEFAULT CHECK COMMENT/NOTE ]───────────────────────┐ │ This comment/note will appear on every payroll voucher unless removed │ │ from the field: CURR_NOTE in the employee database: PAY.DBF prior to │ │ printing of checks. │ │ │ │ Examples: 'W-2s will be issued next week' │ │ 'Signup for 401K!' │ │ 'New State Tax (7%) effective 15 October 1990' │ │ 'Stacy had twins!' │ │ │ │ Enter Default Comment/Note on next line.....................│ │ │ Comment: Whatever comment you want on this line! │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 62 ■ FEDERAL TAX TABLES ╔═════════════════════════╡ FEDERAL TAX TABLES ╞═════════════════════════╗ ║ Consult your accountant or I.R.S. for the current values... ║ ╠═══════╡ Single Employees ╞═════════════════════════════════════════════╣ ║ Zero tax if annual salary is less than 1200 ║ ║ If tax is less than 20650.00 then compute tax as: ║ ║ ( 0.1500 * ( annual salary - 1200.00 ))/ pay weeks ║ ║ If tax is less than 48250.00 then compute tax as: ║ ║ ( 0.2800 * ( annual salary - 20650.00 ) + 2917.50 )/ pay weeks ║ ║ If tax is less than 110300.00 then compute tax as: ║ ║ ( 0.3300 * ( annual salary - 48250.00 ) + 10645.50 )/ pay weeks ║ ║ Otherwise, the computation is: ║ ║ ( 0.2800 * ( annual salary - 110300.00 ) + 31122.00 )/ pay weeks ║ ╠═══════╡ Married Employees ╞════════════════════════════════════════════╣ ║ Zero tax if annual salary is less than 3400.00 ║ ║ If tax is less than 35850.00 then compute tax as: ║ ║ ( 0.1500 * ( annual salary - 3400.00 ))/ pay weeks ║ ║ If tax is less than 81800.00 then compute tax as: ║ ║ ( 0.2800 * ( annual salary - 35850.00 ) + 4867.50 )/ pay weeks ║ ║ If tax is less than 200610.00 then compute tax as: ║ ║ ( 0.3300 * ( annual salary - 81800.00 ) + 17733.50 )/ pay weeks ║ ║ Otherwise, the computation is: ║ ║ ( 0.2800 * ( annual salary - 200610.00 ) + 56940.80 )/ pay weeks ║ ╚════════════════════════════════════════════════════════════════════════╝ ■ FEDERAL EMPLOYER NUMBER ┌────────────────────────[ FEDERAL EMPLOYER NUMBER ]─────────────────────────┐ │ Enter your Federal Employer Identification number to be used │ │ on various reports (ie: W2s). │ │ │ │ Enter Federal Employer Number: 57-07735606 │ └────────────────────────────────────────────────────────────────────────────┘ ■ STATE EMPLOYER NUMBER ┌─────────────────────────[ STATE EMPLOYER NUMBER ]──────────────────────────┐ │ Enter your State Employer Identification number to be used │ │ on various reports (ie: W2s). │ │ │ │ Enter State Employer Number: 25154932-9 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 63 ■ CURRENT DIRECTORY DATABASE LOCATION ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOPOS\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐ │ The location of DAYO General Ledger Databases does not have to be │ │ in the same drive/directory as this module. If you have installed DAYO GL │ │ into a different directory, you need to tell this module where to find │ │ the GL databases. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOGL\ │ │ The drive designation is optional (if same as this module). │ │ │ │ Enter Location: \DAYOGL\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: COST, AMOUNT, SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created. DAYO PAYROLL, TJS LAB Orlando, Florida Page: 64 This routine includes an option to browse, edit, add, and/or delete records in the General Ledger Class Code Table/Database (GLCLASS.DBF). ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗ ║ If you are using General Ledger (GL), you can automatically update ║ ║ or create GL transactions every time you make an accounting adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: AR Name: RECEIPTS ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: RECEIPTS.DBF Field: AMOUNT ║ ╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢ ║ CLASS NAME DEBIT CREDIT ║ ║──────────╥────────────────────────────────╥──────────────╥─────────────────║ ║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Adjustments *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║ ║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║ ║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║ ║ AR ║ RECEIPTS ║ 10000-000000 ║ 20000-000000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE) 20/20 ■ EDIT CLASS CODE RECORD Press 'F2' to edit a Class Code record. Note, valid entries are crucial to making this posting process work correctly... ╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗ ║ CLASS Code: AR ║ ║ Name: AR FREIGHT ║ ║ Debit Account: 11000-000000 ║ ║ Credit Account: 10000-000000 ║ ║ Database (.DBF): ARH.DBF ║ ║ Field: FREIGHT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO PAYROLL, TJS LAB Orlando, Florida Page: 65 ■ ADD NEW CLASS CODE RECORD Press 'Ctrl N' to add a new CLASS code record. ╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗ ║ CLASS Code: ║ ║ Name: ║ ║ Debit Account: 00000-000000 ║ ║ Credit Account: 00000-000000 ║ ║ Database (.DBF): INVADJ.DBF ║ ║ Field: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ■ FIND CLASS CODE Use the 'F5' through 'F9' keys to locate a desired CLASS code record Press 'F5' to locate a CLASS code record based on the CLASS field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to locate a CLASS code record based on the DEBIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 30000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to locate a CLASS code record based on the CREDIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 10000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to locate a CLASS code record based on the NAME field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to locate a CLASS code record based on the DATABASE field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 66 ■ LEFT MARGIN FOR THE PAYROLL CHECK ┌───────────────────[ LEFT MARGIN FOR THE PAYROLL CHECK ]────────────────────┐ │ Enter the left margin/column for you payroll checks to start printing │ │ from. Default is '3', but the limits are from 0 - 30. │ │ │ │ Enter Left Margin For The Payroll Check: 0 │ └────────────────────────────────────────────────────────────────────────────┘ ■ RUN PAYROLL - COMPUTE FICA TAX ONLY ┌──────────────────[ RUN PAYROLL - COMPUTE FICA TAX ONLY ]───────────────────┐ │ Use this option to compute a payroll that will only compute tax for │ │ FICA & Medicare (ie: Bonus checks). │ │ The default is No. │ │ │ │ Run Payroll, Computing FICA & Medicare Tax Only? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 67 ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO PAYROLL will be recreated once daily. This will occur when the first│ │ DAYO PAYROLL program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO PAYROLL Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, high intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 68 ■ MISCELLANEOUS ROUTINES - The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC Routines Menu: DAYO Payroll Version 3.0 TJS LAB ┌───[February 1991]──┐ ╔════════════════════╗─╖ │S M T W T F S │ ║ MISC ROUTINES ║ ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢─╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ BROWSE DATABASES ║─╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ CREATE DATABASE ║─╢ █▀██▀ █░ █░ █░ ▀███▀ │29 30 31 │ ║ DELETE RECORDS ║ ║ │ │ ║ ERASE FILE ║─╢ └────────────────────┘ ║ EXIT TO DOS ║ ║ ║ INDEX A DATABASE ║─╢ █▄███░ ▄█▄ █░ █░ █▄███░ ▄███▄ █░ █░ ║ LIST FIELDS ║ ║ █░ █░ ▄█ █▄ █░ █░ █░ █░ █░ █░ █░ █░ ║ PACK DATABASE ║─╢ █▀███░ █░ █░ █▄ ▄█░ █▄▄▄█░ █░ █░ █░ █░ ║ MODIFY DATABASE ║ ║ █░ █▄▄▄█░ ███░ █▀▀█░ █░ █░ █░ █░ ║ RECALL RECORDS ║╦╝ █░ █▀ ▀█░ █░ █░ ▀█░ █░ █░ █░ █░ ║ RETURN TO MENU ║╝ █░ █░ █░ █░ █░ █░ ▀███▀ ███░ ███░ ║ RUN (DOS COMMAND) ║ ║ SIMPLE EDITOR ║─────────╖ ║ SORT DATABASE ║ Size║ ║ TYPE (PRINT) FILE ║ 6332║ ║ ZAP DATABASE ║ 1384║ ╟────────────────────╢ 1091║ ║ Select Option ║═════════╝ ╚════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 69 ■ APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ - If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 70 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 71 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 72 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation - Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO PAYROLL, TJS LAB Orlando, Florida Page: 73 ■ COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO PAYROLL, TJS LAB Orlando, Florida Page: 74 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 75 - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 76 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 77 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO PAYROLL, TJS LAB Orlando, Florida Page: 78 ■ ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO PAYROLL, TJS LAB Orlando, Florida Page: 79 ■ INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 80 - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 81 - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 82 - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 83 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO PAYROLL, TJS LAB Orlando, Florida Page: 84 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 85 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO PAYROLL, TJS LAB Orlando, Florida Page: 86 ■ SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 87 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 88 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 89 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO PAYROLL, TJS LAB Orlando, Florida Page: 90 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 91 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOPAY HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌───────────────────────[ DAYOPAY HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 92 - Editor help: ┌──────────────────────[ DAYOPAY HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO PAYROLL, TJS LAB Orlando, Florida Page: 93 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO Payroll Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOPAY Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOPAY. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO PAYROLL, TJS LAB Orlando, Florida Page: 94 DAYO Payroll Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOPAY Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOPAY the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE: 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO PAYROLL, TJS LAB Orlando, Florida Page: 95 ■ DATABASE STRUCTURE Database: PAY.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 2 NAME Character 30 7 36 3 SSN Character 11 37 47 4 ADDR1 Character 30 48 77 5 ADDR2 Character 30 78 107 6 CITY Character 20 108 127 7 STATE Character 2 128 129 8 ZIP Character 10 130 139 9 PHONE Character 14 140 153 10 TYPE Character 3 154 156 11 STATUS Character 3 157 159 12 DEPARTMENT Character 3 160 162 13 SEX Character 1 163 163 14 MARITAL Character 1 164 164 15 DOB Date 8 165 172 16 DOH Date 8 173 180 17 RATE Numeric 10 4 181 190 18 PAYPERIOD Character 1 191 191 19 REG_HOURS Numeric 7 3 192 198 20 OT_HOURS Numeric 7 3 199 205 21 P_HOURS Numeric 7 3 206 212 22 OTHER Numeric 10 2 213 222 23 SICK_PAY Numeric 10 2 223 232 24 VAC_PAY Numeric 10 2 233 242 25 WITHHOLD Logical 1 243 243 26 EXEMPTIONS Numeric 2 244 245 27 CURR_RHOUR Numeric 7 3 246 252 28 CURR_OHOUR Numeric 7 3 253 259 29 CURR_PHOUR Numeric 7 3 260 266 30 CURR_RPAY Numeric 10 2 267 276 31 CURR_OPAY Numeric 10 2 277 286 32 CURR_PPAY Numeric 10 2 287 296 33 CURR_OTHER Numeric 10 2 297 306 34 CURR_GROSS Numeric 10 2 307 316 35 CURR_FED Numeric 10 2 317 326 36 CURR_STATE Numeric 10 2 327 336 37 CURR_FICA Numeric 10 2 337 346 38 CURR_SDI Numeric 10 2 347 356 39 CURR_NET Numeric 10 2 357 366 40 CURR_DEDX Numeric 10 2 367 376 41 CURR_DEDN Numeric 10 2 377 386 42 CURR_DED1 Numeric 10 2 387 396 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 96 Database: PAY.DBF continued... Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 43 CURR_DED2 Numeric 10 2 397 406 44 CURR_DED3 Numeric 10 2 407 416 45 CURR_DED4 Numeric 10 2 417 426 46 CURR_DED5 Numeric 10 2 427 436 47 CURR_DED6 Numeric 10 2 437 446 48 CURR_DED7 Numeric 10 2 447 456 49 CURR_DED8 Numeric 10 2 457 466 50 CURR_SICK Numeric 10 2 467 476 51 CURR_VAC Numeric 10 2 477 486 52 LAST_CHECK Character 10 487 496 53 CURR_NOTE Character 50 497 546 54 CURR_DATE Date 8 547 554 55 QTR_RHOUR Numeric 10 3 555 564 56 QTR_OHOUR Numeric 10 3 565 574 57 QTR_PHOUR Numeric 10 3 575 584 58 QTR_RPAY Numeric 10 2 585 594 59 QTR_OPAY Numeric 10 2 595 604 60 QTR_PPAY Numeric 10 2 605 614 61 QTR_OTHER Numeric 10 2 615 624 62 QTR_GROSS Numeric 10 2 625 634 63 QTR_FED Numeric 10 2 635 644 64 QTR_STATE Numeric 10 2 645 654 65 QTR_FICA Numeric 10 2 655 664 66 QTR_SDI Numeric 10 2 665 674 67 QTR_NET Numeric 10 2 675 684 68 QTR_DEDX Numeric 10 2 685 694 69 QTR_DEDN Numeric 10 2 695 704 70 QTR_DED1 Numeric 10 2 705 714 71 QTR_DED2 Numeric 10 2 715 724 72 QTR_DED3 Numeric 10 2 725 734 73 QTR_DED4 Numeric 10 2 735 744 74 QTR_DED5 Numeric 10 2 745 754 75 QTR_DED6 Numeric 10 2 755 764 76 QTR_DED7 Numeric 10 2 765 774 77 QTR_DED8 Numeric 10 2 775 784 78 QTR_SICK Numeric 10 2 785 794 79 QTR_VAC Numeric 10 2 795 804 80 YTD_RHOUR Numeric 10 3 805 814 81 YTD_OHOUR Numeric 10 3 815 824 82 YTD_PHOUR Numeric 10 3 825 834 83 YTD_RPAY Numeric 10 2 835 844 84 YTD_OPAY Numeric 10 2 845 854 85 YTD_PPAY Numeric 10 2 855 864 86 YTD_OTHER Numeric 10 2 865 874 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 97 Database: PAY.DBF continued... Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 87 YTD_GROSS Numeric 10 2 875 884 88 YTD_FED Numeric 10 2 885 894 89 YTD_STATE Numeric 10 2 895 904 90 YTD_FICA Numeric 10 2 905 914 91 YTD_SDI Numeric 10 2 915 924 92 YTD_NET Numeric 10 2 925 934 93 YTD_DEDX Numeric 10 2 935 944 94 YTD_DEDN Numeric 10 2 945 954 95 YTD_DED1 Numeric 10 2 955 964 96 YTD_DED2 Numeric 10 2 965 974 97 YTD_DED3 Numeric 10 2 975 984 98 YTD_DED4 Numeric 10 2 985 994 99 YTD_DED5 Numeric 10 2 995 1004 100 YTD_DED6 Numeric 10 2 1005 1014 101 YTD_DED7 Numeric 10 2 1015 1024 102 YTD_DED8 Numeric 10 2 1025 1034 103 YTD_SICK Numeric 10 2 1035 1044 104 YTD_VAC Numeric 10 2 1045 1054 105 QUARTER1 Numeric 10 2 1055 1064 106 QUARTER2 Numeric 10 2 1065 1074 107 QUARTER3 Numeric 10 2 1075 1084 108 QUARTER4 Numeric 10 2 1085 1094 109 PRINTED Logical 1 1095 1095 110 DEDUCT1 Character 20 1096 1115 111 DEDUCT1AMT Numeric 10 2 1116 1125 112 DEDUCT1BAL Numeric 10 2 1126 1135 113 DEDUCT1X Logical 1 1136 1136 114 DEDUCT2 Character 20 1137 1156 115 DEDUCT2AMT Numeric 10 2 1157 1166 116 DEDUCT2BAL Numeric 10 2 1167 1176 117 DEDUCT2X Logical 1 1177 1177 118 DEDUCT3 Character 20 1178 1197 119 DEDUCT3AMT Numeric 10 2 1198 1207 120 DEDUCT3BAL Numeric 10 2 1208 1217 121 DEDUCT3X Logical 1 1218 1218 122 DEDUCT4 Character 20 1219 1238 123 DEDUCT4AMT Numeric 10 2 1239 1248 124 DEDUCT4BAL Numeric 10 2 1249 1258 125 DEDUCT4X Logical 1 1259 1259 126 DEDUCT5 Character 20 1260 1279 127 DEDUCT5AMT Numeric 10 2 1280 1289 128 DEDUCT5BAL Numeric 10 2 1290 1299 129 DEDUCT5X Logical 1 1300 1300 130 DEDUCT6 Character 20 1301 1320 131 DEDUCT6AMT Numeric 10 2 1321 1330 132 DEDUCT6BAL Numeric 10 2 1331 1340 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 98 Database: PAY.DBF continued... Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 133 DEDUCT6X Logical 1 1341 1341 134 DEDUCT7 Character 20 1342 1361 135 DEDUCT7AMT Numeric 10 2 1362 1371 136 DEDUCT7BAL Numeric 10 2 1372 1381 137 DEDUCT7X Logical 1 1382 1382 138 DEDUCT8 Character 20 1383 1402 139 DEDUCT8AMT Numeric 10 2 1403 1412 140 DEDUCT8BAL Numeric 10 2 1413 1422 141 DEDUCT8X Logical 1 1423 1423 142 USE_SDI Logical 1 1424 1424 143 TAX_STATE Character 2 1425 1426 144 STATE_RATE Numeric 10 4 1427 1436 145 STATE_FIX Numeric 10 2 1437 1446 146 FED_FIX Numeric 10 2 1447 1456 147 FED_FACTOR Numeric 6 4 1457 1462 148 SICK_DAYS Numeric 7 3 1463 1469 149 SICK_USED Numeric 7 3 1470 1476 150 SICK_PER Numeric 7 3 1477 1483 151 VAC_DAYS Numeric 7 3 1484 1490 152 VAC_USED Numeric 7 3 1491 1497 153 VAC_PER Numeric 7 3 1498 1504 154 CLASS Character 3 1505 1507 155 THE_GROSS Numeric 10 2 1508 1517 156 NEXT_KIN Character 50 1518 1567 157 DATE Date 8 1568 1575 158 PARTTIME Logical 1 1576 1576 159 ACTIVE Logical 1 1577 1577 160 CURR_MEDI Numeric 10 2 1578 1587 161 QTR_MEDI Numeric 10 2 1588 1597 162 YTD_MEDI Numeric 10 2 1598 1607 ───── Total 1608 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 99 Database: PAYROLL.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Character 6 1 6 2 RHOUR Numeric 7 3 7 13 3 OHOUR Numeric 7 3 14 20 4 PHOUR Numeric 7 3 21 27 5 RPAY Numeric 10 2 28 37 6 OPAY Numeric 10 2 38 47 7 PPAY Numeric 10 2 48 57 8 OTHER Numeric 10 2 58 67 9 SICK_PAY Numeric 10 2 68 77 10 VAC_PAY Numeric 10 2 78 87 11 GROSS Numeric 10 2 88 97 12 FED Numeric 10 2 98 107 13 STATE Numeric 10 2 108 117 14 FICA Numeric 10 2 118 127 15 SDI Numeric 10 2 128 137 16 NET Numeric 10 2 138 147 17 LAST_CHECK Character 10 148 157 18 DEDUCT1AMT Numeric 10 2 158 167 19 DEDUCT2AMT Numeric 10 2 168 177 20 DEDUCT3AMT Numeric 10 2 178 187 21 DEDUCT4AMT Numeric 10 2 188 197 22 DEDUCT5AMT Numeric 10 2 198 207 23 DEDUCT6AMT Numeric 10 2 208 217 24 DEDUCT7AMT Numeric 10 2 218 227 25 DEDUCT8AMT Numeric 10 2 228 237 26 DEDX Numeric 10 2 238 247 27 DEDN Numeric 10 2 248 257 28 DATE Date 8 258 265 29 TIME Character 8 266 273 30 CSTATE Character 2 274 275 31 CLASS Character 3 276 278 32 TYPE Character 3 279 281 33 TRANSACT Character 12 282 293 34 MEDI Numeric 10 2 294 303 ───── Total 304 Database: PAYNOTES.DBF (and File PAYNOTES.DBT) Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Character 6 0 1 6 2 NOTES Memo 10 0 7 16 ───── Total 17 This database is associated with the memo file: PAYNOTES.DBT DAYO PAYROLL, TJS LAB Orlando, Florida Page: 100 Database: PAYHIST.DBF Same as PAYROLL.DBF Database: PAY_SUM.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 RHOUR Numeric 10 3 1 10 2 OHOUR Numeric 10 3 11 20 3 PHOUR Numeric 10 3 21 30 4 RPAY Numeric 11 2 31 41 5 OPAY Numeric 11 2 42 52 6 PPAY Numeric 11 2 53 63 7 OTHER Numeric 11 2 64 74 8 SICK_PAY Numeric 11 2 75 85 9 VAC_PAY Numeric 11 2 86 96 10 GROSS Numeric 11 2 97 107 11 FED Numeric 11 2 108 118 12 STATE Numeric 11 2 119 129 13 FICA Numeric 11 2 130 140 14 SDI Numeric 11 2 141 151 15 NET Numeric 11 2 152 162 16 LAST_CHECK Character 10 163 172 17 DEDX Numeric 11 2 173 183 18 DEDN Numeric 11 2 184 194 19 LAST_DATE Date 8 195 202 20 LAST_TIME Character 8 203 210 21 MEDI Numeric 10 2 211 220 ───── Total 221 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 101 Database: QTR_SUM.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 QUARTER Numeric 1 1 1 2 RHOUR Numeric 10 3 2 11 3 OHOUR Numeric 10 3 12 21 4 PHOUR Numeric 10 3 22 31 5 RPAY Numeric 11 2 32 42 6 OPAY Numeric 11 2 43 53 7 PPAY Numeric 11 2 54 64 8 OTHER Numeric 11 2 65 75 9 SICK_PAY Numeric 11 2 76 86 10 VAC_PAY Numeric 11 2 87 97 11 GROSS Numeric 11 2 98 108 12 FED Numeric 11 2 109 119 13 STATE Numeric 11 2 120 130 14 FICA Numeric 11 2 131 141 15 SDI Numeric 11 2 142 152 16 NET Numeric 11 2 153 163 17 DEDX Numeric 11 2 164 174 18 DEDN Numeric 11 2 175 185 19 LAST_CHECK Character 10 186 195 20 LAST_DATE Date 8 196 203 21 LAST_TIME Character 8 204 211 22 MEDI Numeric 10 2 212 221 ───── Total 222 DAYO PAYROLL, TJS LAB Orlando, Florida Page: 102 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ACTIVE L 1 0 PAY.DBF Flag to denote whether employee is in an active status. Non-active (.f.) employees are not included in payroll computations ADDR1 C 30 0 PAY.DBF Employee address line 1 ADDR2 C 30 0 PAY.DBF Employee address line 2 CITY C 20 0 PAY.DBF Employee city CLASS C 3 0 PAYHIST.DBF Employee Class code used in PAY.DBF posting to DAYO General Ledger PAYROLL.DBF CSTATE C 2 0 PAYROLL.DBF State code, ie: FL, MI, CA ... PAYHIST.DBF CURR_DATE D 8 0 PAY.DBF Current payroll period/date CURR_DED1 N 10 2 PAY.DBF Current deduction #1 total CURR_DED2 N 10 2 PAY.DBF Current deduction #2 total CURR_DED3 N 10 2 PAY.DBF Current deduction #3 total CURR_DED4 N 10 2 PAY.DBF Current deduction #4 total CURR_DED5 N 10 2 PAY.DBF Current deduction #5 total CURR_DED6 N 10 2 PAY.DBF Current deduction #6 total CURR_DED7 N 10 2 PAY.DBF Current deduction #7 total CURR_DED8 N 10 2 PAY.DBF Current deduction #8 total CURR_DEDN N 10 2 PAY.DBF Current non-exempt deduction total CURR_DEDX N 10 2 PAY.DBF Current tax-exempt deduction total CURR_FED N 10 2 PAY.DBF Current federal tax total CURR_FICA N 10 2 PAY.DBF Current FICA tax total CURR_MEDI N 10 2 PAY.DBF Current Medicare tax total CURR_GROSS N 10 2 PAY.DBF Current gross wages CURR_NET N 10 2 PAY.DBF Current net wages CURR_NOTE C 50 0 PAY.DBF Current check note/comment CURR_OHOUR N 7 3 PAY.DBF Current overtime hours CURR_OPAY N 10 2 PAY.DBF Current overtime pay CURR_OTHER N 10 2 PAY.DBF Current other pay CURR_PHOUR N 7 3 PAY.DBF Current premium hours CURR_PPAY N 10 2 PAY.DBF Current premium pay CURR_RHOUR N 7 3 PAY.DBF Current regular hours CURR_RPAY N 10 2 PAY.DBF Current regular pay CURR_SDI N 10 2 PAY.DBF Current SDI tax CURR_SICK N 10 2 PAY.DBF Current sick pay CURR_STATE N 10 2 PAY.DBF Current state tax CURR_VAC N 10 2 PAY.DBF Current vacation pay DATE D 8 0 PAY.DBF Date record was created PAYROLL.DBF Pay period date PAYHIST.DBF DEDN N 10 2 PAYROLL.DBF Non-exempt deduction total QTR_SUM.DBF PAY_SUM.DBF PAYHIST.DBF DEDUCT1 C 20 0 PAY.DBF Name of 1st deduction DAYO PAYROLL, TJS LAB Orlando, Florida Page: 103 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── DEDUCT1AMT N 10 2 PAY.DBF Amount of 1st deduction PAYHIST.DBF PAYROLL.DBF DEDUCT1BAL N 10 2 PAY.DBF Deduction balance DEDUCT1X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT2 C 20 0 PAY.DBF Name of 2nd deduction DEDUCT2AMT N 10 2 PAYROLL.DBF Amount of 2nd deduction PAYHIST.DBF PAY.DBF DEDUCT2BAL N 10 2 PAY.DBF Deduction balance DEDUCT2X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT3 C 20 0 PAY.DBF Name of 3rd deduction DEDUCT3AMT N 10 2 PAY.DBF Amount of 3rd deduction PAYROLL.DBF PAYHIST.DBF DEDUCT3BAL N 10 2 PAY.DBF Deduction balance DEDUCT3X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT4 C 20 0 PAY.DBF Name of 4th deduction DEDUCT4AMT N 10 2 PAYHIST.DBF Amount of 4th deduction PAYROLL.DBF PAY.DBF DEDUCT4BAL N 10 2 PAY.DBF Deduction balance DEDUCT4X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT5 C 20 0 PAY.DBF Name of 5th deduction DEDUCT5AMT N 10 2 PAY.DBF Amount of 5th deduction PAYHIST.DBF PAYROLL.DBF DEDUCT5BAL N 10 2 PAY.DBF Deduction balance DEDUCT5X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT6 C 20 0 PAY.DBF Name of 6th deduction DEDUCT6AMT N 10 2 PAYROLL.DBF Amount of 6th deduction PAYHIST.DBF PAY.DBF DEDUCT6BAL N 10 2 PAY.DBF Deduction balance DEDUCT6X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT7 C 20 0 PAY.DBF Name of 7th deduction DEDUCT7AMT N 10 2 PAY.DBF Amount of 7th deduction PAYROLL.DBF PAYHIST.DBF DEDUCT7BAL N 10 2 PAY.DBF Deduction balance DEDUCT7X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDUCT8 C 20 0 PAY.DBF Name of 8th deduction DAYO PAYROLL, TJS LAB Orlando, Florida Page: 104 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── DEDUCT8AMT N 10 2 PAYHIST.DBF Amount of 8th deduction PAYROLL.DBF PAY.DBF DEDUCT8BAL N 10 2 PAY.DBF Deduction balance DEDUCT8X L 1 0 PAY.DBF Flag to denote whether deduction is tax exempt or not DEDX N 10 2 PAY_SUM.DBF Amount of tax-exempt amount QTR_SUM.DBF PAYHIST.DBF PAYROLL.DBF DEPARTMENT C 3 0 PAY.DBF Department of the employee DOB D 8 0 PAY.DBF Date of birth DOH D 8 0 PAY.DBF Date of hire EXEMPTIONS N 2 0 PAY.DBF Number of exemptions FED N 10 2 PAYROLL.DBF Federal tax total PAYHIST.DBF QTR_SUM.DBF PAY_SUM.DBF FED_FACTOR N 6 4 PAY.DBF This value (if not zero) is multiplied to the federal tax to adjust it accordingly FED_FIX N 10 2 PAY.DBF This amount (if not zero) will override the computed federal tax amount FICA N 10 2 PAYHIST.DBF Social security tax PAY_SUM.DBF QTR_SUM.DBF PAYROLL.DBF MEDI N 10 2 PAYHIST.DBF Medicare tax PAY_SUM.DBF QTR_SUM.DBF PAYROLL.DBF GROSS N 10 2 QTR_SUM.DBF Gross wages PAYHIST.DBF PAYROLL.DBF PAY_SUM.DBF LAST_CHECK C 10 0 PAY.DBF Last check number PAYROLL.DBF PAYHIST.DBF PAY_SUM.DBF QTR_SUM.DBF LAST_DATE D 8 0 QTR_SUM.DBF Date of last pay period/date PAY_SUM.DBF LAST_TIME C 8 0 PAY_SUM.DBF Time of last pay period/date QTR_SUM.DBF MARITAL C 1 0 PAY.DBF Marital status NAME C 30 0 PAY.DBF Employee's name NET N 10 2 PAYHIST.DBF Net wages (after taxes and PAYROLL.DBF deductions). This value equals PAY_SUM.DBF the check total QTR_SUM.DBF NEXT_KIN C 50 0 PAY.DBF Next of kin/emergency information NOTES M 10 0 PAYNOTES.DBF Employee notes/memos/comments DAYO PAYROLL, TJS LAB Orlando, Florida Page: 105 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── NUMBER C 6 0 PAYNOTES.DBF Employee identification number PAY.DBF PAYHIST.DBF PAYROLL.DBF OHOUR N 7 3 PAY_SUM.DBF Overtime hours worked PAYHIST.DBF QTR_SUM.DBF PAYROLL.DBF OPAY N 10 2 PAYROLL.DBF Overtime pay PAY_SUM.DBF QTR_SUM.DBF PAYHIST.DBF OTHER N 10 2 PAY.DBF Other pay, ie: bonus, commissions PAY_SUM.DBF QTR_SUM.DBF PAYHIST.DBF PAYROLL.DBF OT_HOURS N 7 3 PAY.DBF Overtime hours worked PARTTIME L 1 0 PAY.DBF Flag to denote if employee is a part-time employee PAYPERIOD C 1 0 PAY.DBF Employee pay type (ie: weekly, biweekly, monthly) PHONE C 14 0 PAY.DBF Employee's telephone number PHOUR N 7 3 PAYROLL.DBF Premium hours worked PAY_SUM.DBF QTR_SUM.DBF PAYHIST.DBF PPAY N 10 2 PAY_SUM.DBF Premium pay PAYROLL.DBF PAYHIST.DBF QTR_SUM.DBF PRINTED L 1 0 PAY.DBF Flag to denote if employee's current check has been printed P_HOURS N 7 3 PAY.DBF Premium hours worked QTR_DED1 N 10 2 PAY.DBF Quarter deduction #1 total QTR_DED2 N 10 2 PAY.DBF Quarter deduction #2 total QTR_DED3 N 10 2 PAY.DBF Quarter deduction #3 total QTR_DED4 N 10 2 PAY.DBF Quarter deduction #4 total QTR_DED5 N 10 2 PAY.DBF Quarter deduction #5 total QTR_DED6 N 10 2 PAY.DBF Quarter deduction #6 total QTR_DED7 N 10 2 PAY.DBF Quarter deduction #7 total QTR_DED8 N 10 2 PAY.DBF Quarter deduction #8 total QTR_DEDN N 10 2 PAY.DBF Quarter non-exempt deduction total QTR_DEDX N 10 2 PAY.DBF Quarter tax-exempt deduction total QTR_FED N 10 2 PAY.DBF Quarter federal tax total QTR_FICA N 10 2 PAY.DBF Quarter FICA total QTR_MEDI N 10 2 PAY.DBF Quarter Medicare total QTR_GROSS N 10 2 PAY.DBF Quarter gross wages DAYO PAYROLL, TJS LAB Orlando, Florida Page: 106 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── QTR_NET N 10 2 PAY.DBF Quarter net wages QTR_OHOUR N 10 3 PAY.DBF Quarter overtime hours total QTR_OPAY N 10 2 PAY.DBF Quarter overtime pay QTR_OTHER N 10 2 PAY.DBF Quarter other (misc) pay QTR_PHOUR N 10 3 PAY.DBF Quarter premium hours total QTR_PPAY N 10 2 PAY.DBF Quarter premium pay total QTR_RHOUR N 10 3 PAY.DBF Quarter regular hours total QTR_RPAY N 10 2 PAY.DBF Quarter regular pay total QTR_SDI N 10 2 PAY.DBF Quarter SDI tax total QTR_SICK N 10 2 PAY.DBF Quarter sick pay total QTR_STATE N 10 2 PAY.DBF Quarter state tax total QTR_VAC N 10 2 PAY.DBF Quarter vacation pay total QUARTER N 1 0 QTR_SUM.DBF Quarter number (1-4) QUARTER1 N 10 2 PAY.DBF 1st quarter total QUARTER2 N 10 2 PAY.DBF 2nd quarter total QUARTER3 N 10 2 PAY.DBF 3rd quarter total QUARTER4 N 10 2 PAY.DBF 4th quarter total RATE N 10 4 PAY.DBF Hourly pay rate REG_HOURS N 7 3 PAY.DBF Regular hours worked RHOUR N 7 3 PAYHIST.DBF Regular hours worked PAYROLL.DBF PAY_SUM.DBF QTR_SUM.DBF RPAY N 10 2 QTR_SUM.DBF Regular pay total PAYROLL.DBF PAY_SUM.DBF PAYHIST.DBF SDI N 10 2 PAY_SUM.DBF SDI (state tax) total PAYROLL.DBF QTR_SUM.DBF PAYHIST.DBF SEX C 1 0 PAY.DBF Employee's sex (M or F) SICK_DAYS N 7 3 PAY.DBF ACCRUED sick days SICK_PAY N 10 2 QTR_SUM.DBF Total sick pay paid PAYROLL.DBF " PAY_SUM.DBF " PAY.DBF Amount of sick pay to be paid PAYHIST.DBF Total sick pay paid SICK_PER N 7 3 PAY.DBF Incremental amount of sick days that is added to SICK_DAYS at each pay period SICK_USED N 7 3 PAY.DBF Total sick days used SSN C 11 0 PAY.DBF Social security number STATE N 10 2 PAYROLL.DBF State tax amount PAYHIST.DBF QTR_SUM.DBF PAY_SUM.DBF DAYO PAYROLL, TJS LAB Orlando, Florida Page: 107 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── STATE C 2 0 PAY.DBF State code, ie: FL, GA, CA, MI STATE_FIX N 10 2 PAY.DBF Fixed state tax amount. This amount overrides the computed state tax amount (if not zero) STATE_RATE N 10 4 PAY.DBF State tax rate/factor. This value is multiplied with the gross wages to determine the amount to be withheld for state taxes STATUS C 3 0 PAY.DBF Employee status, ie: SAL for salary, PT for part-time TAX_STATE C 2 0 PAY.DBF State code to receive state tax revenues THE_GROSS N 10 2 PAY.DBF Total gross wages. Accumulates forever (or until you zero it out) TIME C 8 0 PAYHIST.DBF Time of last payroll posting PAYROLL.DBF TRANSACT C 12 0 PAYHIST.DBF DAYO General Ledger (GL) PAYROLL.DBF transaction number. Maintained by DAYO GL at its posting of payroll data TYPE C 3 0 PAYHIST.DBF Employee type. This field is user PAYROLL.DBF defined... PAY.DBF USE_SDI L 1 0 PAY.DBF Flag to denote whether SDI tax will be withheld VAC_DAYS N 7 3 PAY.DBF Total vacation days ACCRUED VAC_PAY N 10 2 QTR_SUM.DBF Total vacation pay paid PAY.DBF Total amount of vacation pay to be paid PAYROLL.DBF Total vacation pay paid PAYHIST.DBF PAY_SUM.DBF VAC_PER N 7 3 PAY.DBF Value to increment the ACCRUED vacation days (VAC_DAYS) field each payroll period VAC_USED N 7 3 PAY.DBF Total vacation days used WITHHOLD L 1 0 PAY.DBF Flag to denote if taxes are to be withheld YTD_DED1 N 10 2 PAY.DBF Year to date deduction #1 total YTD_DED2 N 10 2 PAY.DBF Year to date deduction #2 total YTD_DED3 N 10 2 PAY.DBF Year to date deduction #3 total YTD_DED4 N 10 2 PAY.DBF Year to date deduction #4 total YTD_DED5 N 10 2 PAY.DBF Year to date deduction #5 total YTD_DED6 N 10 2 PAY.DBF Year to date deduction #6 total YTD_DED7 N 10 2 PAY.DBF Year to date deduction #7 total YTD_DED8 N 10 2 PAY.DBF Year to date deduction #8 total YTD_DEDN N 10 2 PAY.DBF Year to date non-exempt tax total YTD_DEDX N 10 2 PAY.DBF Year to date tax-exempt tax total YTD_FED N 10 2 PAY.DBF Year to date federal tax total DAYO PAYROLL, TJS LAB Orlando, Florida Page: 108 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── YTD_MEDI N 10 2 PAY.DBF Year to date Medicare tax total YTD_GROSS N 10 2 PAY.DBF Year to date gross wages YTD_NET N 10 2 PAY.DBF Year to date net wages YTD_OHOUR N 10 3 PAY.DBF Year to date overtime hours total YTD_OPAY N 10 2 PAY.DBF Year to date overtime pay total YTD_OTHER N 10 2 PAY.DBF Year to date other (misc) pay total YTD_PHOUR N 10 3 PAY.DBF Year to date premium hours total YTD_PPAY N 10 2 PAY.DBF Year to date premium pay total YTD_RHOUR N 10 3 PAY.DBF Year to date regular hours total YTD_RPAY N 10 2 PAY.DBF Year to date regular pay total YTD_SDI N 10 2 PAY.DBF Year to date SDI (state tax) total YTD_SICK N 10 2 PAY.DBF Year to date sick pay total YTD_STATE N 10 2 PAY.DBF Year to date state tax total YTD_VAC N 10 2 PAY.DBF Year to date vacation pay total ZIP C 10 0 PAY.DBF Employee's zip code DAYO PAYROLL, TJS LAB Orlando, Florida Page: 109 ■ DAYO PAYROLL MAINTENANCE & QUIRKS - On occasion (maybe an under statement), index files will get corrupted, especially on networks. To 'fix' a corrupted index requires that everyone 'get out of' the DAYO databases, and then perform a reindexing (actually a recreation of the indexes). The reindex is accomplished by running the DAYO PAYROLL program with a parameter of 'INDEX' (or using DAYOX). ie: C:\>DAYOPAY INDEX - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Indexes are recreated once every day. This is automatically performed by the first user to run DAYO PAYROLL. This process will take more time as your files get larger. This process should take place daily, but you can run it at night with a batch file that waits until after midnight (ie: DAYO Clock), or a with most scheduling programs. All other users and computers must be out of the databases, or the procedure will not occur properly. Remember to 'flag' the files sharable, readable and writable. - Backups of your data and configuration files should take place daily! You have no doubt heard many scare stories. They are all true! The key files that need to be backed up all have the extension of .DBF, and .CFG. The .DBF files are your databases. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO PAYROLL, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO PAYROLL, TJS LAB Orlando, Florida Page: 110 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products. TJS LAB, Computer Division In an effort to provide the 'total solution', TJS LAB now offers personal computer systems, printers, software and accessories at a much discounted price. All equipment is warranted by the manufacturer for at least one year. Call or write us for more information...