Casio V-REGI Series Reference Manual

Standard package Sales management Time card System Reference Manual V-R7000 V-R100 1

1.1. .................................................................................................................... 5 Outline of the system 1.2. ......................................................................................................... 6 System data configuration 1.3. ........................................................................................................................... 7 System Operation 1.4. ...................................................................................... 8 Caution for using System Operation 2. .................................................................................................... 10 Setting time card system 2.1. ............................................................................................................. 10 About Employee setting 2.2. ...........................................................................................................................11 Time card setting 2.3. ................................................................................................................................. 12 Time card key 2.4. ........................................................................................................... 14 Time card device setting 3. .............................................................................................. 17 Operation time card system 3.1. .............................................................................................................................. 17 Enter time card 3.2. ........................................................................................................................... 18 Time card report 3.3. .................................................................................................................... 19 Move time card data 4. ........................................... 21 Relationship with your Time and Attendance system 4.1. ............................................................................................................................................... 21 Outline 4.2. ..................................................................................................................... 21 TIMECARDBACK.DB 4.3. ................................................................................................................................... 21 Convert data

Take advance notice The copyrights for this manual, as well as all rights related to the software noted in this manual are the property of CASIO Computer Co., Ltd. The unauthorized reproduction of this manual in whole or part is prohibited without the express, written permission of CASIO The content of this manual may change without prior notice due to improvements to the product and/or changes in their specifications.

1.1. Outline of the system V-REGI Time card System offer management of employee IN/OUT information. Move the detail to internal storage or SD card. Move detail The database which has time card operational detail. Time card detail Report current status and time card operational detail. Time card report Enter and update time card. Enter Time card Set the Employee and Time card system settings. Time card setting V-REGI Time card System works only for stand-alone. V-REGI Time card System logs time card operation and can send to your time and attendance system or software. 5

Time card settings: CKA001 (Time and Attendance master) has setting of employee code and name. CKB001 (Time & Attendance setting) has setting for Time card system. Time card status: CKT001 (Time & Attendance status) has current employee status for time card operation. Time card detail: CKT002 (Time & Attendance detail) has operational detail of time card operation. CKT012 (Time & Attendance backup) is backup inside internal storage (or SD card). Also can be printed Time card status and detail. CKA001 CKB001 CKT002 CKT001 CKT012 Time card status inside Time card setting Move detail operation Time card operation Backup internal storage or SD card 6

Time card operation flow is as below. Set employee code and name by Time and Attendance master. Set time card system by Time & Attendance setting. Set time card key, time card setting and time card report on keyboard. Open time card and set IN. Also can be used scanner. < When employee OUT> Open time card and set OUT. Also can be used scanner. Use time card report and print current status. Operate move detail for move inside time card operation detail to outside internal storage or SD card. Get detail data from internal storage or SD card and send to your time and attendance system. Before send to your system normally need to convert format adjust your system. Casio does not have time and attendance system then please prepare by yourself.

Target of employee: Target of employee is worker of shop, not only cash register operator. V-REGI Time card system now has no relationship to cash register clerk. About work type: Work time is used for your time and attendance system. V-REGI Time card system has no relationship to work type. Operation of time card: Operation types of time card are not only IN/OU but also BREKA-IN/OUT and OUTSIDE/BACK. These operations do not check the integrity so can be operated at any situation. About move detail: Move detail can be operated by manually. Also it can be operated by Open or Z automatically.

2.1. About Employee setting Before using time card system, please set time card settings. All of time card settings are located at time card setting menu. First, please set target employee at Employee setting. The employee and cash register clerk has no relationship. 10

Before using time card system, please set time card setting. Time card stock has some menu and select contents. NO. Menu Contents 1 Time card screen type. Preset time card screen style. 0: Enter by employee code. 1: Show touch key (Automatic layout) 2: Show touch key (Manual layout) 3: Use barcode system Using “Show touch key (Manual layout)” and “Use barcode system” need preset of CKB003 (Time and attendance device setting) by DB settings. 2 Time card receipt. Preset time card operation receipt. 0: Not issue receipt. 1: Issue receipt. Any setting logs to EJ. 3 Write to time card detail. Preset as logs detail or not for time card operation. 0: Log detail. 1: Not log detail. In case of Log detail, also move detail operation is needed. 4 Time card data move timing. Preset timing of move detail. 0: Not move automatically. 1: Move to internal storage (SD) when open. 2: Move to internal storage (SD) when Z. 5 Use break-IN/OUT. Preset using break-in/out system. 0: Invalid (not use break-in/out) 1: Valid (use break-in/out) 6 Use Outside/Back. Preset using outside/back system. 0: Invalid (not use outside/back) 1: Valid (use outside/back) 11

Time card key can be set Top Menu setting of Function key. Time card key: Function code 300340 Time card setting key: Function code 300341 Time card report key: Function code 300342 Time card key is used not only Cash register clerk but also store employee. Some times it is requested locate time card key on sign off screen. Below operation can set key on sign off screen. 1. Create new function key. Locate new time card key by using Function key setting. Check Key Code (Funckeycode) value. 2. Update CSB022 by DB settings. Updating CSB022 can create new key on sign off screen. Updating by DB setting is difficult so please ask SQL professional to create SQL script and use DB management running Script Execution. Sample of setting CSB022 for V-R100 Field name Data example Remarks SHEETTYPE FUNCTION Keyword SHEETNUMBER 2 It means bottom of sign off screen. SHEETARRANGE 1 Any layout SHEETSEQCODE 1 1st key of this area CONTROLTYPE FunctionButton Keyword THEME Standard Keyword CODE (target funckeycode) Same as CSB002 funckeycode USECOORDINATE 1 Use x/y location POSITIONX 250 Any X location inside area POSITIONY 3 Any Y location inside area WIDTH 186 Any key width HEIGHT 54 Any key height LABEL null Use CSB002 label FOREGROUNDCOLOR -1 Any color code BACKGROUNDCOLOR -8413952 Any color code OPTIONCOLOR 0 IMAGEFLAG 1 Not use image BGIMGCONTROLTYPE null BGIMGTHEME null BGIMGCODE null FONTSIZE 22 Any OPERATIONMODE null

INSERT OR REPLACE INTO "CSB022" VALUES('FUNCTION',2,1,1,'FunctionButton','Standard','400001','1',250,3,186,54,NULL,-1,-841 3952,0,'1',NULL,NULL,NULL,22,NULL,NULL,'-','20141118162347','20141118162347'); For more detail, please purchase database kit.

Using “Show touch key (Manual layout)” or “Use barcode system” of Time card screen type, it needs preset CKB004 (Time and attendance device master) or CKB003 (Time and attendance device setting). 1. “Show touch key (Manual layout)” It needs update CKB004 (Time and attendance device master) and recode for each employee touch key on time card screen. CKB004 (Time and attendance device master) for each employee Field name Data Remarks TACODE Full Employee code without zero suppresses. Same code as CKA001 Employee code TADEVTYPE Set 01 01 means touch key TADEVCODE Set TTKK 4 digits value. TT is tab location starting from 00 and goto 01, 02, etc. KK is key location inside tabs. Left-top is 01 and next is 02. Reached to most right goes to next line.

It needs update CKB003 (Time and attendance device setting) for using EAN 13 in-store barcode with employee code inside. Get Employee code from barcode will be expanded as 10 digits employee code and search database. For example, barcode “2000037145734” means employee code “00037” if set as starting from 3 digits and width 5 digits, and search database with “0000000037”. CKB003 (Time and attendance device setting) property value of TADEVTYPE=20. Field name Data Remarks 1 to 2 location Barcode flag value for EAN 13 top 2 digits. Above example is 20 3 to 4 location Offset of employee code location inside barcode. Start of barcode is 1. Above example is 03 5 to 6 location Length of employee code inside barcode. Above example is 05

3.1. Enter time card Entering time card needs to specify employee code and select target operation as IN or OUT. Also can be used touch key or barcode. Entered by code uses employee code and select operation. Touch key type touch target employee key and select operation. Barcode type scans barcode and select operation. After fixed operation, can issue receipt and check it depends on setting. Time card system does not check the integrity so you can operate IN and IN.

Time card report can print time card status and operational detail. Select report type and Enter to show report. Also print key prints report. Report type Report meaning Time card status Print current time card status of CKT001. Time card status is not cleared then print all of employee used past. Time card detail Print all of detail of CKT002 from past moved. Internal storage (SD) detail data CKT012 is not printed.

Time card detail (CKT002) loges inside application and it need to move to internal storage (SD) regularly. How to move detail data is as below types.  Operate manually by using “Move time card data”.  Automatic by Open operation.  Automatic by Z operation. Once move to internal storage (SD), database table becomes CKT012.

system 4.1. Outline V-REGI time card system has time card operation and not has time and attendance system. Your time and attendance system can use V-REGI time card operation detail data. 4.2. TIMECARDBACK.DB Time card detail data is moved to internal storage (SD) as TIMECARDBACK.DB (table is CKT012) by move operation (or automatic) and other application (or FTP) can get it. Target folder is standard mount (/mnt/sdcard). Folder: /jp.co.casio.caios.framework.database/databases File name: TIMECARDBACK.DB 4.3. Convert data Time card detail data (CKT012) format is Casio original then you need to convert as fit to your time and attendance system. Casio does not provide any convert tool. For more detail please check database kit.