Transcript
DEALER'S MANUAL Business Support Terminal VX-100 Sales Management Application
Standard Style CASIO COMPUTER Co.,Ltd.
INTRODUCTION Thank you very much for purchasing Business support terminal CASIO VX－100. This manual is CASIO VX－100 Dealer’s Manual explaining principles and detail settings of each function of the unit. In the explanations of each function, technical terms for system engineers are used. For general operations of the terminal, please see the CASIO VX-100 User's Manual.
NOTICE Any copying of the contents of this dealer's manual, either in part or its entirety without the permission of CASIO COMPUTER CO., LTD is prohibited under copyright laws. The contents of this manual and specifications of this unit are subject to change without prior notice. In case the terminal malfunctions or for any question about the contents of this manual, please contact your local CASIO service center or CASIO COMPUTER CO., LTD. Due to the stage of issuing this manual or shipping period of the terminal, some features may not be described in this manual. Please update or obtain the latest system version.
SD and SDHC Logos are trademarks of SD-3C, LLC.
Copyright © CASIO COMPUTER Co.,Ltd. 2011-2012 All Right Reserved.
SHOP SUPPORTIVE TERMINAL VX-100 DEALER'S MANUAL
Contents SECTION 1 INTRODUCING VX-100 ........................................................................................................................... 2 1
OUTLINE OF THE SYSTEM.................................................................................................................................. 2 1.1 CONCEPTUAL DIAGRAM ........................................................................................................................................ 3 2 INTRODUCTION TO THE SALES MANAGEMENT SYSTEM .............................................................................. 4 2.1 SALES REGISTRATION ........................................................................................................................................... 4 2.2 SIGN ON............................................................................................................................................................... 5 2.3 WORK ＭENU ....................................................................................................................................................... 5 2.4 OPENING FOR BUSINESS ....................................................................................................................................... 6 2.5 MONEY DECLARATION .......................................................................................................................................... 7 2.6 FLASH REPORT .................................................................................................................................................... 7 2.7 X REPORT (PRESENT SALES CHECK) ..................................................................................................................... 8 2.8 Z REPORT(RESET SALES) ..................................................................................................................................... 8 2.9 INLINE FUNCTION .................................................................................................................................................. 9 2.10 ELECTRONIC JOURNAL ......................................................................................................................................... 9 2.11 CUSTOMER/RESERVATION MANAGEMENT .............................................................................................................. 9 2.12 SETTING .............................................................................................................................................................. 9 2.13 SYSTEM ............................................................................................................................................................... 9 3 BASIC SPECIFICATIONS OF VX-100 ................................................................................................................ 10 4 VX-100 DATABASE ................................................................................................................................................ 12 4.1 STRUCTURE DIAGRAM OF DATABASES ................................................................................................................ 13 4.2 DATABASE LIST.................................................................................................................................................. 14 SECTION 2 OPERATIONS OF THE BUSINESS MANAGEMENT SYSTEM ............................................................. 20 Task List ..................................................................................................................................................................... 21 1. SALES REGISTRATION ............................................................................................................................................ 27 1.1 Check operation (for restaurants) ............................................................................................................ 29 1.1.1 Check operation settings .......................................................................................................................... 29 1.1.2 About check tracking system.................................................................................................................... 30 1.1.3 About shared check tracking system ....................................................................................................... 30 1.2 Check registration (Sales registration) .................................................................................................... 31 1.2.1 Settings for check registration .................................................................................................................. 31 1.2.2 Features of the Cash register (Sales registration) operation ................................................................... 32 1.2.3 Operations of Item .................................................................................................................................... 34 1.3 Closing a check (Sales registration) ........................................................................................................ 36 1.3.1 Function of sales registration ................................................................................................................... 36 1.4 Completion of a transaction...................................................................................................................... 37 1.4.1 Function of completion of transaction ...................................................................................................... 37 2. SIGN ON ................................................................................................................................................................ 38 2.1 CLERK SIGN ON DATABASE STRUCTURE............................................................................................................... 38 2.2 ABOUT USER AUTHORITY .................................................................................................................................... 38 2.3 Sign on function ......................................................................................................................................... 39 3. WORK ＭENU ......................................................................................................................................................... 41 3.1 STRUCTURE OF WORK ＭENU ............................................................................................................................. 41
i
3.2 Work ｍenu function ................................................................................................................................. 43 4. REFUND AND REG MINUS ...................................................................................................................................... 44 4.1 Refund ......................................................................................................................................................... 44 4.2 Cancellation of sales registration (Reg Minus) ..................................................................................... 45 4.3 Registration calculation ............................................................................................................................ 46 5. OPEN FOR BUSINESS ............................................................................................................................................. 50 5.1 “OPEN FOR BUSINESS” OPERATION..................................................................................................................... 50 6. MONEY DECLARATION ............................................................................................................................................ 51 6.1 Preparing change ....................................................................................................................................... 51 6.2 Money received .......................................................................................................................................... 51 6.3 Money paid.................................................................................................................................................. 51 6.4 Money declaration report .......................................................................................................................... 52 6.4.1 Features of money declaration ............................................................................................................. 52 6.4.2 Money declaration settings....................................................................................................................... 55 6.4.3 CSM003 (Denomination master) .............................................................................................................. 56 7. FLASH REPORT ...................................................................................................................................................... 57 7.1 Data to be printed ....................................................................................................................................... 57 7.2 Output forms of the flash report ............................................................................................................... 57 8 X REPORT (READ REPORT) ..................................................................................................................................... 59 8.1 VIEW FILES TO BE PRINTED ................................................................................................................................. 59 8.2 Output forms of read report ...................................................................................................................... 59 8.3 X Report (Read report) screen operations .............................................................................................. 67 8.3.1 X report screen ......................................................................................................................................... 67 8.3.2 X report (inlin)screen ................................................................................................................................ 68 8.3.3 Default X report settings ........................................................................................................................... 69 8.4 Open check report (X report) .................................................................................................................... 70 9. Z(RESET SALES) REPORT ....................................................................................................................................... 72 9.1 Creating the reset sales report data ......................................................................................................... 72 9.1.1 Structure of reset sales report database .................................................................................................. 72 9.1.2 Cumulative sales data .............................................................................................................................. 74 9.1.3 Storing reset sales data in an SD card ..................................................................................................... 75 9.1.4 Rest sales data to be printed.................................................................................................................... 75 9.2 Output forms of reset sales report ........................................................................................................... 76 9.3 Z (Reset sales) report screen operations ................................................................................................ 84 9.4 Periodic report ............................................................................................................................................ 87 9.5 Transaction report ..................................................................................................................................... 88 9.6 Open check report (Z report) .................................................................................................................... 89 10. INLINE FUNCTIONS .............................................................................................................................................. 91 10.1 DEFINITION OF INLINE ENVIRONMENT ................................................................................................................... 91 10.2 CHECK SHARING ................................................................................................................................................ 91 10.3 COLLECTING SALES DATA AND PRINTING X/Z (INLINE) REPORTS ........................................................................... 92 10.4 SHARING SET DATA (INLINE) ................................................................................................................................ 92 11. ELECTRONIC JOURNAL ....................................................................................................................................... 93 SECTION 3 TASK SETTINGS .................................................................................................................................. 96 1.
ii
CLERK SETTING ..................................................................................................................................................... 98 1.1. CLERK SETTING SCREEN .................................................................................................................................... 98 1.2. Relevant tables ........................................................................................................................................... 99 1.2.1. CSB004 (Clerk setting) ........................................................................................................................... 99 1.2.2. CSB005 (Clerk group ) ......................................................................................................................... 100 1.2.3. CSB010 (Dallas key (i-Button) setting ................................................................................................ 101 1.2.4. CSB006 (Clerk group settings) ........................................................................................................... 101
1.2.5. Menu application function code list ................................................................................................... 102 1.3 ABOUT IMAGE GRAPHIC SETTINGS..................................................................................................................... 103 2. ITEM SETTINGS..................................................................................................................................................... 104 2.1 Item setting screen .................................................................................................................................. 104 2.2 Database structure for item settings ..................................................................................................... 105 2.3 Relevant tables for item settings ................................................................................................................. 107 2.3.1 CIA001 (Item master) ............................................................................................................................. 107 2.3.2 CIA002 (Item department master) ......................................................................................................... 112 2.3.3 CIA003 (Item group master) .................................................................................................................. 113 2.3.4 CSA001 (Item setting group) ................................................................................................................. 113 2.3.5 CIB001 (Set item master) ...................................................................................................................... 116 2.3.6 CIB002 (Set item composition master) .................................................................................................. 117 3. Transaction settings .................................................................................................................................... 119 3.1 Function of transaction (Function) buttons ............................................................................................. 119 3.2 Relevant table ................................................................................................................................................ 123 3.2.1 CSB002 (Function button settings) ........................................................................................................ 123 3.2.2 CSB003 (Function button parameter settings)....................................................................................... 124 4. Arrangement of Function button ....................................................................................................................... 127 4.1 Position and range of Function buttons ..................................................................................................... 127 4.2 Relevant table ............................................................................................................................................... 129 4.2.1 CSB011 (Layout settings) ...................................................................................................................... 129 5. Print settings ........................................................................................................................................................ 133 5.1 About receipts .............................................................................................................................................. 133 5.2 Hold receipt .............................................................................................................................................. 142 5.3 Guest receipt ............................................................................................................................................ 144 5.4 Setting a message .................................................................................................................................... 145 5.4.1 CSB007 (Character setting) ................................................................................................................... 146 5.5 ABOUT XML FORMATTING OF RECEIPT PRINTING ............................................................................................... 148 5.5.1 CSM012 (PRINT FORM MASTER) .................................................................................................................. 148 5.6 About logo image ..................................................................................................................................... 150 6. General feature .................................................................................................................................................... 151 6.1 Relevant table ........................................................................................................................................... 152 6.6.1 CSB001 (OPERATION SETTING) .................................................................................................................. 152 6.2 General feature codes ............................................................................................................................. 153 7 Set data transmission ........................................................................................................................................ 157 SECTION 4 SYSTEM MAINTENANCE ................................................................................................................... 160 1. Android settings .............................................................................................................................................. 161 2. VX-100 settings ............................................................................................................................................ 162 2.1 FLOWCHART FOR SETTING VX-100 ................................................................................................................. 162 2.2 Device setting tables ............................................................................................................................... 163 2.2.1 CTN003 (Local device settings) ............................................................................................................ 163 2.2.2 CTN002 (Printer settings) ..................................................................................................................... 166 2.2.3 CTN004 (Network device settings) ................................................................................................... 167 3. Database setting tool ................................................................................................................................... 169 3.1 Item setting table ....................................................................................................................................... 169 3.1.1CSA002 (Item classification table) ......................................................................................................... 169 3.1.2 CSA003 (Selective item classification) ................................................................................................. 169 3.1.3 CSA004 (Item discount settings) .......................................................................................................... 170 3.2 Various settings ....................................................................................................................................... 173 3.2.1 CSB008 (Graphic settings) ................................................................................................................... 173 3.2.2 CSB012 (Layout image settings) .......................................................................................................... 174
iii
3.2.2 CSB009 (Customer group settings) ...................................................................................................... 175 3.2.3 CSB010 (Dallas key settings) ............................................................................................................... 175 3.2.4 CSB013 (Clerk sum settings) ................................................................................................................ 176 3.3 System settings table ................................................................................................................................ 177 3.3.1 CSM001 (Tax master)......................................................................................................................... 177 3.3.2 CSM002 (Currency master) .................................................................................................................. 179 3.3.3 CSM003 (Denomination master) .......................................................................................................... 180 3.3.4 CSM007 (Numbering counter) .............................................................................................................. 181 3.3.5 CSM008 (Bar code settings) ................................................................................................................. 182 3.3.6 CSM009 (Function button master) ........................................................................................................ 184 3.3.7 CSM010 (Function button setting master) ........................................................................................ 184 4. Database Management tool ........................................................................................................................ 185 4.1 Database backup/Database reload/ Script execution .......................................................................... 186 4.1.1 Database Backup ............................................................................................................................... 187 4.1.2 Database Reload ................................................................................................................................ 189 4.2 INITIALIZE ....................................................................................................................................................... 190 4.3 CHECK BUSY RESET ....................................................................................................................................... 191 5 Control panel ................................................................................................................................................ 192 5.1 TERMINAL NUMBER FUNDAMENTAL SETTING ................................................................................. 193 5.2 TERMINAL NETWORK SETTING .......................................................................................................... 194 5.3 PRINTER CONNECTION SETTING ....................................................................................................... 195 5.4 TERMINAL NETWORK CONFIRMATION .............................................................................................. 196 5.5 SETTING LOGO IMAGE DATA IN BUILT-IN PRINTER .......................................................................... 197 5.6 APPLICATION VERSION ....................................................................................................................... 198 5.7 DEVICE TOOL ....................................................................................................................................... 199 5.8 CASH REGISTER SYSTEM SETTINGS ................................................................................................. 200 6
Restart ........................................................................................................................................................... 202
APPENDIX ............................................................................................................................................................. 204 ABOUT SD ERRORS ..................................................................................................................................................... 204 SD Error 1 ............................................................................................................................................................. 204 SD Error 2 ............................................................................................................................................................. 205 SD Error 3 ............................................................................................................................................................. 206 ERROR MESSAGES ...................................................................................................................................................... 207 INDEX .................................................................................................................................................................... 210
iv
SECTION 1 INTRODUCTION TO THE BUSINESS SUPPORT TERMINAL VX-100
SECTION 1 INTRODUCING VX-100 1 OUTLINE OF THE SYSTEM The operations of the VX-100's application consists of 11 working categories for sales management. The following shows the working categories of the VX-100. Business Support Terminal VX-100 Sales Management Outline
Registration Open Business Operation
Registers the opening date and
Money Declaration
Manages the money in the cash drawer.
Flash Report X Report Z Report
Reports the present sales amount.
Reports the details of present sales.
Reports the day’s total sales at the end of the business day.
Inline Function
Totalizes the sales amount of Vertex terminals in the network.
Customer/Reservation
Manages the customers and reservations control notebooks
Electronic Journal
Task Setting
Maintenance
2
Registers transactions of sales on order or store selling.
Stores data to observe past operations, modifications, or transactions. Sets data for daily tasks such as details of goods or adding new clerk. Performs database settings, or maintenance of the system.
1.1 Conceptual diagram The following figure shows the overall conceptual diagram of the VX-100.
3
2 INTRODUCTION TO THE SALES MANAGEMENT SYSTEM 2.1 Sales registration Sales registration manages the sales and payments. ・
4
“Sales registration” features check operation, check registration, receiving payments, check calculation, and check printing functions.
2.2 Sign on The sign on operation identifies, authorizes, and limits the clerk.
・
A clerk can be selected on the sign on screen shown at boot up. To limit a clerk, you can set a password so that the terminal requires it whenit is operated.
2.3 Work ｍenu Normally, the display shows sales registration screen. For opening for business, correction, X report, Z report, or setting operations, touch the mode button to change the screen to the Work ｍenu. The operations on the Work ｍenu can be restricted in accordance with the authorities of operators.
5
2.4 Opening for business “Opening for business” is for starting the day This terminal manages the sales in the unit of one day, from ““Open for business”“ to “ Reset sales”.
6
2.5 Money declaration The “Money declaration” manages and reports the amount of money stored in the cash drawer.
・
2.6
“Money declaration” function consists of five operations which are preparingcoins for change, registration of money received and paid, registration of money changed, and reporting the amount in the cash drawer.
Flash report Flash report prints and displays the present status of sales amount and number of customers.
7
2011/12/13 CLERK 1234567890
11:01 PM AB 123456
FLASH X REPORT -------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 COVER 12,345 CASHINDRAWER $1,234,567,890,123 $1,234,567,890,123 12,345
COVER
2.7
X report (present sales check) Read report displays and prints the present sales in detail. ・
Read report displays and prints seven kinds of reports. ① ② ③ ④ ⑤ ⑥ ⑦
Total amount in the cash drawer Sum of each transaction Sum of each item Sum of each department Sum of each group Sum of each clerk Sum of hourly sales
2.8 Z report(Reset sales) “Reset sales” closes daily business which starts from the “Opening for business”. “Reset sales” prints total sales sum of the day and retains the sales records. ・
Reset sales report prints seven kinds of reports. ① ② ③ ④ ⑤ ⑥
Total amount in the cash drawer Sum of each transaction Sum of each item Sum of each department Sum of each group Sum of each clerk
⑦ Sum of hourly sales 8
2.9 Inline function Inline function interacts with other cash VX-100 in the network. Check Sharing Read report Sales reset Receive Sales data
: Shares the same sales check. : Reads the other cash register’s sales data by remote control. : Reads and resets the other cash register’s sales data by remote control. : Reads the other cash register’s present sales amount by remote control.
2.10 Electronic Journal Electronic journal stores operation logs and manages the accumulated journal.
2.11 Customer/Reservation management The function manages the customers’ data, purchasing analysis, and reservation statuses.
2.12 Setting The function sets the following items for daily operations. ・ ・ ・
Clerk setting:
Adds, changes, and deletes clerks
Item setting:
Adds, changes, and deletes items
Customer/Reservation settings: Sets data relevant to customers and reservation managements.
2.13 System In this mode, you can set and maintain the system of the terminal.
9
3 BASIC SPECIFICATIONS OF VX-100 BASIC SPECIFICATION SPCIFICATIONS Model
Connectable Device Languages
VX-100
Inline connection 2
Maximum number of terminal: 4
(The shared check tracking is available)
Maximum number of prenter:8
Japanese English German French Spanish
Available
Cash drawer
devices
CASIO DL-2533 CASIO DL-2814 CASIO DL-2815 CASIO DL-2436 CASIO DL-3624 CASIO DL-3625
Display
CASIO VX-100 (built in)
Printer
CASIO VX-100 (built in) CASIO UP-370 （COM connection） CASIO UP-400 （COM connection） CASIO UP-400 （COM connection）
Scanner
CASIO HHS-18 （COM connection） PSC QuickScan 6500 （COM connection）
Magnetic card reader
10
CASIO VX-100 (Export model only)
iButton
CASIO QT-6011DLS
Order controller
CASIO QF-11CB
Fuji electric ECS-07 （COM connection） Automatic coin dispenser
Laurel bank machines （COM connection）
CASIO KT-10 （COM connection） Electronic liquidation terminal Environments Database
SQLite
Code set
UTF-8
Memory
Built-in memory SD card
Device font
Japanese font English font European font Simplified Chinese character font
11
4 VX-100 Database The VX-100 employs an application incorporating SQ-Lite database system for controlling, searching, storing, and retrieving data. This section explains the structure of the databases.
Database structure The system mainly consists of five databases. ● System management database; Manages the system operations such as user master or system settings of connected devices.
Items database; Manages the basic information of items such as details of the goods or processing method of items.
Sales management database; Manages the operations, settings, or calculations of the sales.
Task database; Manages the operations of a shop such as opening or closing histories.
Customer/Reservation database Manages and analyzes the customers’ information, purchase history, and reservation statuses. ※Refer to the relevant manual for Customer/Reservation managements.
12
4.1
Structure Diagram of Databases The following figure shows the structure of the databases.
13
4.2 Database List Database
Table ID
Table Name
Function
System management
CTN002
Printer setting
Stores printer settings.
database
CTN003
Local device setting
Stores local devices settings.
CTN004
Network device setting
Stores network devices settings.
CTT001
Table information
Stores table information.
CTT002
Column information
Stores column information.
CTT003
Index information
Stores index information
CTR001
Center connection setting
Stores center connections.
CTR002
Service contract setting
Stores service contract settings
CTR003
Settlement terminal setting
Stores the settlement terminal settings.
CIA001
Item master
Stores definitions of items.
CIA002
Item department master
Stores definitions of item department.
CIA003
Item group master
Stores definitions of item groups.
CIB001
Set item master
Stores definitions of set items.
CIB002
Set item composition master
Stores definitions of set item compositions.
Commodity database
Sales management
【Item Settings】
database
CSA001
Item setting group
Stores item setting groups.
CSA002
Item classification
Stores item classifications.
CSA003
Item selection classification
Stores item selection classifications.
CSA004
Item discount setting
Stores settings for discounts.
CSM001
Tax master
Stores definitions of tax rate.
CSM002
Currency master
Stores definitions of currencies.
CSM003
Currency denomination
Stores definitions of currency denomination.
【System】
master CSM006
Current date
Stores current date.
CSM007
Consecutive number
Stores consecutive number counter
counter
information.
CSM008
Bar code setting
Stores bar code settings.
CSM009
Function master
Stores definitions of Function buttons.
CSM010
Function setting items
Stores settings of Function buttons.
master
14
CSM011
Clerk setting master
Stores clerk settings.
CSM012
Print form master
Stores definitions of printing forms.
CSM013
Login information
Stores clerk's sign on information.
【Operation Settings】 CSB001
Operation setting
Stores operation settings.
CSB002
Transaction (Function)
Stores Transaction (Function) buttons
button setting
settings.
Transaction (Function)
Stores the details of the transaction button
button parameter settings
settings.
CSB004
Clerk setting
Stores the clerk settings
CSB005
Clerk group
Stores clerk group definition.
CSB006
Clerk group settings
Stores clerk group settings.
CSB007
Character settings
Stores character settings.
CSB008
Print image setting
Stores print image settings.
CSB009
Customer stratum settings
Stores customer stratums
CSB010
Dallas key settings
Stores Dallas key settings.
CSB011
Layout settings
Stores layout settings.
CSB012
Layout image settings
Stores layout image settings.
CSB013
Clerk sum settings
Stores individual clerk’s sales sum.
CST001
Order sum
Calculates and stores the sum of orders.
CST002
New balance
Calculates and stores new balance
CST003
Detailed order
Calculates and stores itemized order checks.
CST004
Today’s sales
Calculates and stores today's sales.
CST005
Details of today’s sales
Calculates and stores details of today’s sales.
CST011
Total sales amount
Calculates and stores total sales amount.
CST012
Details of sales
Calculates and stores details of sales.
CST021
Open business history
Calculates and stores open business history.
CST022V
Open and close business
Reference table for the store’s open and
view
close statuses.
CSB003
【Transaction】
【Tantalization Files】 CSS001V
Flash report view
Reference table for flash report.
CSS002V
Flash report for item and
Reference table for each item and hourly
hourly sales view
sales for flash report.
CSS011
Total sales amount
Stores the total sales amount.
CSS012
Money declaration
Stores total amount of money in the cash drawer.
CSS013
CSS014
Transaction (Function)
Calculates and stores total amount for each
button total
Transaction (Function) button.
Each item total
Calculates and stores total amount for each
15
item. CSS015
Department total
Calculates and stores total amount for each department.
CSS016
Item group total
Calculates and stores total amount for each item group.
CSS017
Individual clerk total
Calculates and stores total amount for each clerk.
CSS018
customer stratum total
Calculates and stores total amount for each stratum.
CSS019
Hourly sales total
Calculates and stores total amount for each time zone.
CSS021V
CSS023V
CSS024V
CSS025V
CSS026V
CSS028V
CSS029V
Total sales amount for Read
Reference table for total sales amount for
Report view
Read report.
Transaction button for Read
Reference table for individual Transaction
report view
(Function) button for Read report.
Individual item for Read
Reference table for individual item for Read
report view
report.
Individual department for
Reference table for individual department for
Read report view
Read report.
Individual item group for
Reference table for individual item group for
Read report
Read report.
Individual customer stratum
Reference table for individual customer
for Read report view
stratum for Read report.
Individual hourly sales for
Reference table for individual time zone for
Read report view
Read report.
Customer/Reservation
【Customer managements】
database
CMA001
Customer master
Stores the basic information of customers.
CMA002
Customer item setting
Stores data concerning customer settings..
CMA003
Customer item list
Stores
customers
to
be
listed
in
the
customer master. CMT001
Customer RFM total1
Stores customers’ accumulated purchase amount.
CMT002
Customer RFM total2
Stores customers’ purchase information for purchase analysis.
CMR001
Customer privilege
Stores
purchasing
privileges
customers. CMB001
Customer setting)
Stores setting values of customer management components.
16
given
to
CMM001
Error code master
Stores error codes information.
CMM002
Print form master
Stores print form data (XML).
【Reservation managements】 CRT001
Reservation
master
Stores reservation slips.
CRT002
Reservation
Order
Stores reserved order slips.
CRA001
Reservation item Setting
CRA002
Reservation item list
Stores reservation slip items. Stores reservation slip to be listed on the screen.
CRB001
Reservation Setting
Stores reservation management components.
CRM001
Error code master
Stores error codes.
CRM002
Print form master
Stores print form (XML).
17
18
SECTION 2 OPERATIONS OF THE BUSINESS MANAGEMENT SYSTEM
SECTION 2 OPERATIONS OF THE BUSINESS MANAGEMENT SYSTEM This section explains the functions of each category.
20
Task List The following shows the structure of the tasks and the functions of the system. Task 1
Registration
1
Function
Sales registration / Check operation
New check 1 Issues new check.
Check call 2 Calls the check now issuing.
Screen switching (to table display) 3 Screen changes to table display.
Call other clerk's check 4 Calls other clerk's check.
Change table clerk 5 Changes the table clerk. ST %-
6
Percentage discount from subtotal amount. ST -
7 Subtracts from subtotal amount. ST %+
8
Percentage increase to subtotal amount. ST +
9 Adds to subtotal amount. ST House
10 Registers the subtotal amount as house bon.
2
Sales registration /Sales registration operation
Sales registration 1 Registers sales of items.
Scanning registration 2 Registers bar coded items.
Number of customer entry 3 Enters the number of customers.
Holding order 4 Holds an order.
5
%-
21
Discounts the price at a rate.
6 Discounts the price in amount.
%+ 7 Price an item at a premium.
+ 8 Raises the price of an item.
9
House Bon Use a HouseBon.
Tax calculation 10 Performs tax-inclusive and exclusive calculations for each country.
Rounding calculation 11 Performs rounding calculation for each country.
Last operation correction 12 Corrects the last operation before selecting an item.
Line deletion 13 Deletes an item after registration.
Issuing receipt 14 Prints a receipt.
Meal ticket printing 15 Prints meal tickets.
Order to the kitchen 16 Prints orders to the kitchen.
Cancelling transaction 17 Cancels a sales registration.
3
Sales registration / Tendered amount registration operation
Cash 1 Paid in cash.
Credit card 2 Paid by a credit card.
Voucher 3 Paid by a voucher.
Credit 4 Selling on credit.
22
4
Sales registration / Completion of transaction
Receipt printing 1 Prints a receipt.
Clerk sign off 2 Features automatic sign off function.
5
Sales registration / Sign on
Clerk sign on 1 Select a clerk to sign on.
Switching to direct clerk input 2
Display changes to clerk number input screen.
Clerk sign on 3 Signs on by inputting the clerk number.
Clerk password input 4 Enter a password.
i-Button login 5 Logs in by the
.
6
Sales registration / Mode
Mode 1
2
Refund
1
Refund
Call the Work ｍenu.
Refund 1 Registers refunded items.
3
Cancellation
1
(Reg-) 4
Open
Cancellation of sales (Reg minus)
1
Cancellation 1 Cancels registered sales.
Open / Open screen
Open / Changing business day 1
Changes the date for 24-hour-open stores.
5
Money declaration
1
Money declaration / Set coin
Cash / Coin type Set coin 1
Registers the amount of prepared coins.
2
Money declaration / Received money registration
Received cash registration 1
Registers the amount of cash put in the cash drawer.
3
Money declaration / Paid money registration
Paid cash registration 1
Registers the amount of cash withdrawn from the cash drawer.
4
Money declaration / Amount declaration
Cash / Bill type declaration 1
Registers amount in cash in the cash drawer.
23
Credit card declaration 2
Registers credit card slips in the cash drawer.
Voucher declaration 3
Registers the amount of vouchers in the cash drawer.
Credit declaration 4
Registers the amount of credits in the cash drawer.
6
Electronic Journal
1
Electronic journal
Date selection 1
Searches and displays the electronic journal by date.
Electronic journal display 2 Displays the electronic journal.
7
Flash report
1
Flash report / Flash report screen
8
X report
1
Flash report 1 Prints flash report.
X report /X report screen
Read report 1 Prints read report.
Read report (inline) 2
Outputs read report of inline connected terminal.
Open check report 3 Prints unfinished transactions.
9
Z report
1
Z report /Z report screen
Z(Reset sales) 1 Executes Reset sales
Z(Reset sales) report 2 Prints a Reset sales report.
Inline Z (Inline reset sales) 3
Prints reset sales report of inline connected terminals.
Periodic report 4
Prints reset sales report of assigned period.
Transaction report 5 Outputs details of sales checks.
Open check report 6 Prints unclosed checks.
24
10
Customer/
1
Reservation
Customer management/ Customer note
Customer note 1
Registers and manages customers’ information.
2
Customer management/ Purchase analysis
3
Customer analysis 2 Analyzes customers’ purchase history.
Reservation management/ Reservation note
Reservation note 1
Analyzes and manages reservations information.
11
settings
1
Clerk setting
Clerk setting 1 Sets clerks’ information.
2
Item setting
Item settings 1 Sets information of items.
3
Settings transmission
Settings transmission 1
Transmits settings data to connected terminals.
4
Customer management settings
Customer management settings 1
Sets necessary factors for customer management.
5
Reservation settings
Reservation management settings 2
Sets necessary factors for reservation management.
6
Email Remote control
Email Remote control setting 3
Sets necessary information for Emailing.
12
System
1
System setting
System setting 1 Calls the system setting screen.
2
Data Settings
Database operation 1
Operates the databases for the terminal’s settings.
Text data reading 2 Imports text data.
Text data writing 3 Exports text data.
3
Data management
Database backup 1 Backs up the database.
2
Reloading database
25
Reloads a database.
Execution of script 3 Executes a SQL script file.
Initialize 4 Initializes the database.
Check busy reset 5
Release the inline connected terminal’s check read busy lock forcibly.
4
Control panel
Local device terminal information 1 Verifies connected terminal.
Printer information 2 Verifies connectable printer.
5
Restart
Restart 1
Restarts the terminal and reflects the changes of settings.
6
Operation log
Operation log 1 Verifies Operation log.
26
1. Sales registration Sales registration screen is the main screen in the sales management system and calculates and registers the sales.
NO
Screen parts
Items
Functions
1
Clerk name
Clerk name
Indicates clerk names who signed on.
2
Check operation
Check No.
Indicates the check numbers.
part
Table
Indicates the table numbers.
Covers
Indicates the number of customers.
Clerk
Indicates the clerk name who registers the transaction.
Registered item
Indicates the list of registered items.
3
Registered items
4
Total part
Total
Indicates total sales amount.
5
Change part
Change
Indicates amount of changes.
6
Number display
Number
Indicates number of items or amount.
7
Ten-key
Numeral entry
Used for inputting number of items or amount.
8
Function keys
Void
Is used for void calculations.
X
Is used for multiplications.
Sign on
Is used when clerks sign on.
list
27
Mode
X or Z reports.
Clear
Is used for clearing the displayed numbers.
Charge
Is used when selling on credit.
Subtotal
Is used for calculating a subtotal and displaying amounts on customer screen.
Cash
Is used for cash sales and change calculation.
Credit
Is used for sales on credit cards.
Hold
Is used for holding the check temporarily.
Receipt
Is used for issuing post receipts or guest receipts.
NS
New/Old
28
Is used for assigning operation modes such as refund,
Is used for exchanging money or opening the cash drawer. Is used when registering new check or calling another check.
Table
Is used when assigning a table number.
Covers
Is used when entering number of customers.
Others
Is used for calling another function buttons.
9
Item selection part
Item
Selects items.
10
Item tab
Item tab
Changes item selection screen.
This part explains four features of sales registration. 1.1 Check operation (for restaurants) As many restaurants manage business by checks (order slip), the “Check operation” controls the business by using “check tracking system”. ※For check tracking system, please refer to 1.1.2 “About check tracking system”.
Check operation includes two operations, check issuing (check number assignment) and table number assignment.
1.1.1 Check operation settings The following shows the setting items of check operation. 【Operation setting】 5. Settings for application (UI) Check screen style Determines the style of check operation. 0: Table number entry 1: Check number entry 2: No table number nor check number (call the terminal directly)
Check screen button size Selects the sizes of check selection button or table selection button. 0: Normal size Displays 10 buttons in one tab.
1: Half size Displays 20 buttons in one tab.
29
Check screen time display type Selects the time display type shown on check selection buttons or table selection buttons.
0: Elapsed time since the check is held 1: Elapsed time since the check is issued.
1.1.2 About check tracking system By assigning check numbers on all the tables, you can call the assigned check number when an additional order is placed from a table so that you can register the additional order without closing transactions. This system is performed by registering orders and issue temporary check and holds the transaction until the payment is made. .
1.1.3 About shared check tracking system Shared check tracking system is for sharing the same check with another VX-100 in the network.
30
1.2 Check registration (Sales registration) Check registration (sales registration) registers sold items. 1.2.1 Settings for check registration The following shows the setting items for the check registration. 【Operation setting】 ① Regional settings Tax System Determines the tax system. 0: Standard 1: US Food stamp 2: Canada, 3: Singapore
Country Rounding Determines the rounding method for each country. 0: Normal 1: IF1 2: IF2 3: Australia 4: Danish 5: Finland 6: Malaysia 7: New Zealand (A) 8: New Zealand (B) 9:Sweedish 10:South Africa 11: Japanese 5 yen rounding 12: Japanese 10 yen rounding
Baked Goods Tax Exempt Qty Determines baked goods’ tax exemption quantity in Canada. （0～9）
Prepared Maximum Amount Limit Determines the limitation of maximum amount in Canada.
②
Settings for sales
Rounding for rate calculation Determines the rounding in rate calculations. 0: Round off 1: Round down 2: Round up 31
1.2.2
Features of the Cash register (Sales registration) operation The Cash register (Sales registration) function includes various features. This part of the section explains four main functions of Check registration (Sales registration) screen. The followings explain the features of sales operations in the sales registrations.
Check number For confirming a check number already issued.
Table number Record the table number.
Number of customers Registers number of customers. Initial value of the number of the customers is 1. You need to enter the number if customers are more than 1.
Customer number Calls registered customers’ information. Use Transaction (Function) button. (default feature of VX-100)
Holding the check Holds the transaction when the order is not completed, Holding a check enables to correct or change the contents of the check Also, you can recall the held check and shift it to transaction stage. Use Transaction (Function) button. (default setting of the unit)
Slip unification Combines checks. Present check can be put together with another check. Use Transaction (Function) button. (default feature of VX-100)
32
ST%Percentage discount from subtotal amount. Use Transaction (Function) button. (default feature of VX-100)
ST%+ Percentage add on to subtotal amount. Use Transaction (Function) button. (default feature of VX-100)
STSubtracts in amount from subtotal. Use Transaction (Function) button. (default feature of VX-100)
ST+ Adds premium amount to subtotal. Use Transaction (Function) button. (default feature of VX-100)
ST House Transacts the check as house bon. Non sales items such as meals for staffs are registered as zero amount sales.. Use Transaction (Function) button. (default feature of VX-100)
Transaction cancel (for present transaction) Registering transaction cancel disables the present operation’s check operation library. Cancelling added orders on held check cancels the added order and returns to the held check so that you can add additional order from the beginning. To utilize the feature, it is necessary to prepare Transaction (Function) button. (default feature of VX-100)
33
1.2.3
Operations of Item The following explains the functions of Item.
Item quantity entry Normally, when an item is chosen, quantity of the item is one automatically. If you wish to register multiple quantity, use X (multiplication) button.
For an item priced 0 (zero) Basically, items priced zero cannot be registered. If you wish to register a zero priced item, set the value in the ITEM TYPE in the item setting database beforehand.
%You can discount after selecting an item.
Use Transaction (Function) button. (default feature of VX-100)
%+ You can increase the price at a rate after selecting an item.
Use Transaction (Function) button. (default feature of VX-100)
You can reduce the price after selecting an item.
Use Transaction (Function) button. (default feature of VX-100)
+ You can increase the price after selecting an item.
Use Transaction (Function) button. (default feature of VX-100)
House bon Assigns internally consumed items. Items which are internally consumed and registered as ¥0 as sales amount such as meals for staffs should be assigned as house bon items. Use Transaction (Function) button. (default feature of VX-100)
Bar code reading Reads bar coded items. Some settings are necessary for reading bar codes.
34
[Setting item parameters] The following explains the features of item parameters. Item parameters should be set in the item setting database. The followings are the optional feature of the parameters.
SINGLEITEMFLG (Single-item-in-cash flag) This flag enables to assign an item that is sold singly in cash. If this item is selected first, the unit automatically closes the transaction in cash. (1 item, 1 receipt, tendered in cash)
HASHITEMFLG (Items-excluded-from-total flag) This flag assigns an item that is excluded from total sales amount. The item that is not included in total sales amount is so called “hash item”. The hash item will be excluded from total sales amount although it is included in the net sales amount.
OPENPLUFLG (Open-price-item flag) This flag assigns an open-priced item (unit price can be entered directly). After selecting an open-priced item, the screen moves to price entry screen so that you can enter the price you wish.
NONSRCVCHARGEFLG (Non-service-charge flag) This flag is assigned when the item is not subject to a service charge.
Set menu Set menu combines several items and counts the set as one item. Example of a set menu Set menu name: Cheese hamburger set 1. Cheese hamburger Item 2. Salad Item 3. Rice Item 4. Coffee Item
$17.54
Item departments Item departments classify items to enable the following features. 35
① Totalize the classified items ② Aligns items of each department on the Item screen in Check registration (Sales registration) screen.
Item group management Item group classifies item department. By managing the item departments and item groups, the following feature will be available. 1.
Totaling the results of each item department.
Guest receipt print Prints guest receipts for informing the kitchen of the customer order.
Meal ticket printing Prints meal tickets for individual order.
1.3 Closing a check (Sales registration) Sales registration operation registers details of a transaction. This operation calculates and registers the amount of sales by touching button on Sales registration screen.
1.3.1 Function of sales registration Sales registration function registers total sales amount. The following explains each function of the sales registration operations.
36
Paid in cash Registers the amount tendered in cash. After you received the amount in cash, touch button.
Credit sales Registers the amount tendered in Credit card.
Paid by a voucher You can register sales paid by a voucher such as gift certificate or service coupons.
1.4
Completion of a transaction After a payment is made in cash or by credit, the unit opens the cash drawer. If the payment is done in cash, the unit calculates and displays the change.
1.4.1 Function of completion of transaction The following explains the function of transaction completion. Opening of cash drawer You can set the cash drawer to open even other payment than in cash such as by credit or by a voucher is made.
37
2. Sign on This operation executes clerk’s signing on and off to authenticate the user to operate the terminal.
2.1 Clerk sign on database structure The following figure shows the structure of database for clerk’s sign on.
Sign on Authentication
CSB004
Clerk setting
Manages clerks’ information and attributes to authenticate users. CSB006
CSB005
Clerk group setting
Clerk group
Manages parameter values for the clerk group settings.
Manages the attributes of authenticated clerk groups.
2.2 About user authority User authority is to determine clerks’ tasks in accordance with their authorities. For details about user authority, please refer to "Clerk group setting". Clerks defined in the user master have clerk group code such as cashier, clerk, and manager in accordance with their clerk code. A clerk's group code is linked to the clerk's parameter that is set by clerk group setting.
38
CSB004 (Clerk setting) Clerk code 1
Clerk group code 1
Clerk code 2
Clerk group code 1
Clerk code 3
Clerk group code 4
::: ::: :::
Manages the parameters for the limitation of the usage.
CSB006（Clerk group setting） Limitation of operation after sign on Set value 1
Clerk group code 1
Limitation for credit Clerk group code 4
Set value 1
Limitation of operation after sign on Set value 2
Please refer to SECTION 3, 1. Clerk setting for details of the setting.
CSB005 (Clerk group)
Clerk group code 1
Cashier
Clerk group code 4
Chief clerk
About the usage of user authority User authority limits operations such as execution of the Work ｍenu or usage of a Transaction (Function) button on the work screen. User authority manages the work effectively by limiting operations for each clerk group.
2.3 Sign on function Sign on operation compares clerks’ information and authority to limit the each clerk’s operations. There are three methods for signing on, choosing a clerk from clerk list, inputting clerk code directly, or using iButton device’s option.
Check
About iButton When logged in by iButton device, the application converts the device information to a user code and you can sign on using the user code as the parameter. 39
Clerks’ settings are also necessary to sign on by iButton devices. ※VX-100 supporting iButton (factory option) is necessary.
Settings for signing on are as follows; 【Operation Setting】 5. Application (UI) setting ・Login screen style Determines the sign on screen style. 0: Clerk selection screen 1: Clerk code input scree 2:iButton
Refer to “6.2 General featurecode”, “5. Screen style
setting (UI)” in section 3.
40
3. Work ｍenu Work menu displays a list of available task applications to be executed.
3.1
Structure of Work ｍenu The following table shows the structure of Work ｍenu.
TAB
Work ｍenu
Registration Registration
X report
Z report
Launches sales registrations,
Refund
Launches refund registrations.
Cancel
Launches sales cancelling registrations.
Open
Launches open-for-business operations.
Set coin
Launches set coin registrations.
Electronic journal
Launches the electronic journal.
Money received
Launches money received screen.
Money paid
Launches money paid screen.
Operation manual
Launces the operation manual.
Flash report
Launches flash report.
X report
Launches read report.
X report (inline)
Launches read report of inline connected terminal.
Open check report
Launches open check X operation.
Z (Reset sales)
Launches the reset sales operation.
Z report
Launches reset sales report.
Z report (inline)
Launches reset sales report of inline connected terminal.
Notes
Money declaration
Launches money declaration registration.
Periodic report
Launches periodic sales report.
Transaction report
Launches sales check inquiry.
Open check report
Launches open check Z operation.
Customer note
Launches customer notebook. ※1
Purchase analysis
Launches customers’ purchase analysis. ※1
Reservation note
Launches reservation notebook registration. ※1
41
Settings
Clerk settings
Launches clerk setting operations.
Item settings
Launches item setting operations.
Set data transmission
Launches inline function setting data transmission.
Customer management
Launches customer management setting operations.
settings
※1
Reservation management
Launches reservation management setting
settings
operations. ※1
Email remote control
Launches Email transmission settings. ※1
settings
System
Web
Android settings
Launches Android settings.
DB settings
Launches database setting operations.
DB management
Launches database management.
Control panel
Launches control panel.
Register restart
Restarts register (sales management) software.
Operation log
Launches Operation log.
Browser
Launches WEB browser.
mail
Launches the mailer.
※1 Please refer to the relevant manual for the customer and reservation managements.
42
3.2
Work ｍenu function The contents of the display and operations can be limited by the user authority of the clerk who signed on. Please refer to “1. Clerk setting” in section 3. The followings explain the functions of user authority on the Work ｍenu. 【Clerk setting code】
SCREEN.AFTERLOGIN Limits the operations after signing on. 0: Registration screen (Sales registration menu will be launched instead of the Work ｍenu.) 1: Operational management screen (Launches the Work ｍ enu.)
SCREEN.AFTERLOGIN.TOPMENU.XXXXXX Limits the display of execution menu on the Work ｍenu. ※ XXXXXX corresponds to application function code. For the application function code, please refer to “1.2.5 Menu application function code list” in section 3. 0: Display (Displays execution menu.) 1: Hide (Does not display execution menu.)
OPERATION.MODE.TRAINING Operates in training clerk mode. 0: No (Not training clerk) 1: Yes (Training clerk) Sign on by training clerk mode. ※ Work menu in training clerk mode indicates normal Work menu. In the training clerk mode, the sales registration operations can be done but the sales results are not registered in the database. However, other operations than the sales registration are stored in the database. Please use the training clerk mode for sales registration practice for new clerks.
OPERATION.AUTOSIGNOFF Determines automatic signing off after a transaction is completed. 0：No (does not sign off automatically) 1：Yes (Signs off automatically)
43
4. Refund and REG Minus 4.1 Refund Refund operation registers the returned goods.
To refund an item, select the returned item then register it as normal sales registration operation on Refund screen.
44
4.2 Cancellation of sales registration (Reg Minus) Refund operation registers the subtraction of returned item. Instead, cancellation of sales registration (Reg-) operation deletes the transaction itself. Namely, the operation invalidates registered item. You can cancel an incorrectly registered item and then re-register the correct item.
To cancel an item, select the item then register it as normal sales registration operation on Reg - screen.
45
4.3
Registration calculation In accordance with the type of transactions such as sales registration (REG), refund (REF), or sales cancellation (REG －),the terminal executes corresponding calculations. The following table explains the calculations for each transaction.
Item
Symbol
Calculation ＋ Registered quantity of PLU and scanning PLU (except hash sales)
Total sales quantity
REG‥＋
‥
REF‥－
Multiplication, unit multiplication, square, cube: ＋ multiplied
REG － ‥－
quantity
Single registration：＋１
－‥Correction of above registrations －‥Cancellation of above registrations ＋ Registered quantity of PLU and scanning PLU (except hash sales)
Total sales amount
REG‥＋
(Reflects the results of price reductions, discounts, price
REF‥－
raisings, premium prices, and Mix & Match calculations in
REG －‥－
net sales mode. ) －‥Correction of above registrations －‥Cancellation of above registrations‥
REG‥＋ Number of net sales
REF‥＋ REG －‥－
＋ When registering transactions in cash, credit, voucher, and card. ：＋１ ＋ Registered amount of PLU and scanning PLU －‥Refund operation of above registrations －‥Correction of above registrations －‥Cancellation of above registration ＋ Raising price, premium price
REG‥＋ Total net sales REF‥－ amount
REG －‥－
－‥Correction of above registrations －‥Cancellation of above registrations －‥Price reduction, discount, and Mix & Match ＋‥Correction of above registrations ＋‥Cancellation of above registrations ＋ Tax-exclusive amount（※１） －‥Cancellation of above registration（※１）
46
－‥ Tax-inclusive price（※２） ＋‥Cancellation of above registration（※２） (※１：Calculates when consumption tax is included in the net sales amount. ※２：Calculates when consumption tax is excluded in the net sales amount) ＋ Total received amount of assigned bill or coin (Received amount when paid by voucher) ＋ Partially received amount of assigned currency when the payment is done by several types of money. Calculated amount in
REG‥＋
cash drawer (cash,
REF‥－
credit, voucher, and
REG －‥－
－‥Correction of above registration ＋ Received amount (cash in drawer only) －‥Paid amount (only cash withdrawn from drawer)
card) ＋‥Total amount of assigned currency prepared for change －‥Total amount of returned money in assigned currency －‥Amount of change in voucher sales (money declaration in cash only) ＋ Total amount of assigned foreign currency (received amount Calculated amount of
REG‥＋
foreign currency 1～
REF‥－
4 in cash drawer
REG －‥－
when paid in voucher) ＋ Partially received amount of assigned foreign currency －‥Correction of above registration
Total declared
REG‥＋
amount (cash, credit,
REF‥－
voucher, and card)
REG －‥－
Number of refunds
＋ Declared amount of assigned currency
REF‥＋
＋ When registering transaction (in cash, credit , voucher, or card)：
REG ―‥＋
＋１ ＋ Registered amount of PLU and scanning PLU －‥Correction of above registrations －‥Cancellation of above registration ＋ Raising price, premium price －‥Correction of above registrations
REF‥＋ Refunded amount
REG ―‥＋
－‥Cancellation of above registrations －‥Price reduction, discount, and Mix & Match ＋‥Correction of above registrations ＋‥Cancellation of above registrations ＋ Tax-exclusive amount －‥Cancellation of above registration
47
REG‥＋ Total number of REF‥－ customers
REG ―‥－ REG‥＋
Discounted amount
＋ Number of customers
REF‥－
＋ Amount of reduced price, discount, coupon, and Mix & Match. －‥Undoing operation at above registrations.
REG ―‥－ Number of issued REG‥＋
＋ When issuing a service coupon：＋１
REG‥＋
＋ Total net sales amount when issuing service coupon
service coupons Total amount of issued service coupon REG‥＋ Number of $100 bill
REF‥－
＋ Registered number of $100 bill
REG －‥－ REG‥＋ Total amount of
＋ Net sales amount before round calculation‥－‥Rounded net
REF‥－ rounding calculation
REG ―‥－
sales amount
REG‥＋ Number of REF‥＋ cancellation
＋ When a transaction is cancelled：＋１
REG ―‥－ REG‥＋
Amount of cancelled REF‥－ items
＋ Total net amount of cancelled items
REG ―‥－ REG‥＋
Number of receipts REF‥＋ with revenue stamp
＋ When issuing a receipt with revenue stamp space：＋１
REG ―‥－ REG‥＋
Amount of receipts REF‥－ with revenue stamp
48
＋ Amount of receipts with revenue stamp
REG －‥－
Number of receipts
REG‥＋
without revenue
REF‥＋
stamp
REG ―‥－
Amount of receipts
REG‥＋
without revenue
REF‥－
stamp
REG －‥－
Number of service
REG‥＋
point issued
REF‥＋
＋ When issuing a receipt without revenue stamp space：＋１
＋ Amount of receipts without revenue stamp
＋ When a service point coupon is issued：＋１
REG ―‥－
REG‥＋ Number of customer REF‥－ service point
＋ Number of customer point
REG －‥－
Taxable item １〜4
＋ Amount of taxable items
amount Tax１〜４amount
＋ Amount of tax
Tax exemption １〜
＋ Amount of exempted taxable items
４amount
REG‥＋
Total amount
REF‥－
Consumption tax
REG －‥－
Total amount of
＋ Tax１〜４amount
＋ Total sales amount of tax exempted items
Tax exempted items Service charge
＋ Amount of service charge
49
5. Open for Business “Open for business” operation is executed at the time of starting daily business. The execution of the “Open for business” screen determines the date of the business. Such shops as 24-hour-operated stores, the date of business and the date of booting terminal may differ. In such a case, you can use the Date Change button.
5.1 “Open for business” operation “Open for business” operation is for starting daily business of a store whereas the “Reset sales” is for closing. Therefore, the business of one day is managed and reported by counting from the “Open for business” operation to the “Reset sales” operation.
The following shows the setting items of “Open for business”. 【Operation setting】 2. Settings for opening and closing time and business hours. Today’s start time Sets the time for changing the business date for such shops as 24-hour-operated stores. Normally, the date changes at 12:00 midnight but you can set the time for date changing.
50
6. Money Declaration Money declaration feature manages the money stored in the cash drawer. The money declaration screen consists of four displays.
6.1 Preparing change This operation registers money prepared in the cash drawer for the change. You can register the amount of the change either by the total amount or by the type of bill or coin.
6.2 Money received This operation registers money received and put in the cash drawer without a sales transaction. The received money should be registered by the total amount received.
6.3 Money paid This operation registers money withdrawn from the cash drawer without a sales transaction.The paid money should be registered by the total amount.
51
6.4
Money declaration report By declaring the amount in the cash drawer when closing a day’s business or when the clerk is changed, the unit validates the amount to prevent wrong withdrawal from the drawer.
6.4.1 Features of money declaration Species of money You can declare the amount in the drawer in cash, credit card, voucher, or credit individually. 【Cash: By types of bills and coins】
Cash
Number
$100Bill
5
$500.00
$50Bill
7
$350.00
$20Bill
0
$0.00
$10Bill
13
$130.00
$5 Bill
7
$35.00
$2 Bill
23
$46.00
$1 Bill
6
$6.00
$1 coin
18
$18.00
50c coin
0
$0.00
25c coin
0
$0.00
Total
Subtotal
$1,085.00
Operation: Enter the number of each bill and coin.
52
【Cash: By total amount】
Cash
Subtotal
Total amount in cash
$94.378
Total
$94.378
Operation: Enter the total amount of cash.
【Credit card: By card issuer】
Card issuer
Number
Master Card
3
$25.00
VISA Card
4
$35.60
AMEX Card
1
$13.00
UC Card
1
$5.00
JCB Card
3
$17.00
Total
Subtotal
$95.60
Operation: Enter the amount by each card issuer. 【Credit card: Total amount】
Credit card
Subtotal
Total amount of credit
$95.60
card
Total
$95.60
Operation: Enter the total amount paid by credit card.
53
【Charge: By species of Charge】
Charge
Number
Next month payment
2
$138.00
1
$52.00
End of this month payment
Subtotal
Total
$190.00
Operation: Enter the charge amount in each species.
【Charge: Total amount】
Loan
Subtotal
Total amount of charge
$190.00
Total
$190.00
Operation: Enter the total amount of charge. Declaration difference in read report and reset report You can check the difference between the declared amount and the registered amount in read report and reset sales.
GROSS NET
CHARG IN DRAWER
289 $283.50 120 $297.67
$355.85 -Registered amount in cash drawer CHARG DECLARATION $354.85--Declared amount CHARG DECLARATION+/- -1.00--Registered amount –declared amount TAX $14,17
54
6.4.2
Money declaration settings In money declaration function, it may necessary to set denomination of money, reason for credit sales, or approval of credit card usage in accordance with regional or the stores’ rule. The followings explain the database operations for the denomination, species of credit card, and reason of credit sales.
Money declaration
CSM003 Denomination master
Manages denomination, reason for credit etc.
Money declaration displays denomination of money or species of payment in accordance with the definition in the denomination master (CSM003).
55
6.4.3 CSM003 (Denomination master) ・Denomination master is a table that sores types of bills and coins. Column Name
Name
CURRENCYCODE BILLCOINCODE BILLCOINNAME BILLCOINAMT REMARKS CREATEDATETIME UPDATEDATETIME
of column
Currency code Denomination code Money name Amount Remarks Created date Updated date
Type
Size
C C C N C C C
6 6 24 10 30 14 14
Scale
Possibility of NULL □ □ □ □ ■ □ □
Default value
CURRENCYCODE (Currency code); Six-digit alpha-numeric string defining a code for currency. BILLCOINCODE (Denomination code); Six-digit alpha-numeric string defining a code for denomination. BILLCOINNAME (Denomination name); Character string defining the unit of money. BILLCOINAMT (Amount); Numeral string defining the amount.
Example of a table Currency code 000001 Yen
000002
US$
Denomination code 000001 (Denomi. #1) 000002 (Denomi. #2)
Unit of currency 10,000 Yen bill 5,000 Yen bill
Amount 10000 5000
000003
(Denomi. #3)
2,000 Yen bill
2000
000004
(Denomi. #4)
1,000 Yen bill
1000
000005 (Denomi. #5) 000006 (Denomi. #6) 000007 (Denomi. #7) 000008 (Denomi. #8) 000009 (Denomi. #9) 000010 (Denomi. #10) 000001 (Denomi. #1) 000002 (Denomi. #2) :
500 Yen coin 100 Yen coin 50 Yen coin 10 Yen coin 5 Yen coin 1 Yen coin $100 $50
500 100 50 10 5 1 100.00 50.00
REMARKS (Remarks) ; Strings for storing any character or word. CREATEDATETIME (Created date) ; 14-digits alpha-numeric YYYYMMDDhhmmss.
r
storing
created
date
and
time
in
the
form
of
UPDATEDATETIME (Updated date) ; 14-digits alpha-numeric string defining updated date and time in the form of YYYYMMDDhhmmss.
The settings can be changed by changing the database explained in”Database Setting tools”.
As to the operational settings of money declaration controls, please refer to “6. Managing money declaration” in “6.2 Money declaration management” of Section 3.
56
7. Flash report Flash report prints the total sales amount from open to the present time.
7.1 Data to be printed Flash report prints out the following data from the flash report view table (CSS001V (Flash report view)).
・GROSSQTY (Gross sales quantity) ・GROSSAMT (Gross sales amount) ・SHEETCT (Number of sales sheets) ・NETAMT (Net sales amount) ・NETCOVER (Number of covers) ・CASH (Present amount in cash in the cash drawer)
7.2 Output forms of the flash report There are two types of the flash report form, 58mm width form and 80mm width form. The followings show the flash report forms. 【58mm width form】 1234567890123456789012345678901 2011/12/13 CLERK 1234567890
11:01 PM AB 123456
FLASH X REPORT -----------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 COVER 12,345 CASH IN DRAWER $1,234,567,890,123
←Date and time ←Clerk code (C10), Terminal #(C2), Consecutive number(C6) ←One line feed ←Report header (C14) , Report (C9) ←Dotted line printing ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales quantity (N5) ←Net sales amount (N13) ←Number of covers (N5) ←Present amount in the cash drawer (N13)
1234567890123456789012345678901
57
【80mm width form】 1234567890123456789012345678901234567890 2011/12/13 CLERK 1234567890
11:01 PM AB 123456
FLASH X REPORT ---------------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 COVER 12,345 CASH IN DRAWER $1,234,567,890,123
58
←Date and time ←Clerk code (C10),Terminal code (C2),Consecutive # (C6) ←One line feed ←Report header (C20), Report (C9) ←Dotted line printing ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales quantity (N5) ←Net sales amount (N13) ←Number of covers (N5) ←Present amount in cash in the cash drawer (N13)
8 X report (Read report) X report prints out sales amount in detail from the opening to the present time.
8.1 View files to be printed Read report retrieves the sales data from the view table of read report. ･CSS021V (Read report total sales view file) ･CSS023V (Read report individual Transaction (Function) button view file) ･CSS024V (Read report individual item view file) ･CSS025V (Read report individual department view file) ･CSS026V (Read report individual item group view file) ･CSS029V (Read report individual time zone view file)
8.2 Output forms of read report 8.2.1 Output forms of total sales read report There are two types of the total sales read report form, 58mm width form and 80mm width form. The followings show the total sales read report forms. 【58mm width form】 1234567890123456789012345678901 FIXED TOTAL CONSOLIDATION X REPORT ------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 CASH IN DRAWER $123,456 $1,234,567,890,123 CASH DECLARATION $1,234,567 CASH DECLARATION +/$123,456 $1,234,567 CHECK IN DRAWER $123,456 $1,234,567,890,123 CHECK DECLARATION $1,234,567 CHECK DECLARATION +/$123,456 $1,234,567 CREDIT IN DRAWER $123,456 $1,234,567,890,123 CREDIT DECLARATION $1,234,567 CREDIT DECLARATION +/- $123,456 $1,234,567
←Report header ((C20), Read (C9) ←Prints dotted line ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales frequency (N5) ←Net sales amount (N13) ←Present amount of cash in the drawer ※If the title and amount touch together in the same line, the amount will be printed in the next line ←Declared amount in cash ←Declared cash amount – Present cash amount ※ ←Present amount of credit ※ ←Declared amount of credit ←Declared credit amount – present credit amount ※ ←Present amount of credit card sales ※ ←Declared amount of credit card sales ←Declared credit card amount – present credit card amount ※
59
COVER DISCOUNT SERVICE(ROUNDING) CANCEL TA1 TAX1 TA2 TAX2 : TA10 TAX10 EXEMPT TOTAL
123 $1,234 123 $1,234 $1,234,567 123 $1,234 $123,456 $1,234,567 $123,456 $1,234,567
←Number of customers ←Amount per customer ←Frequency of discount ←Amount of discount ←Amount of rounded service charge ←Frequency of cancellation ←Amount of cancellation ←Amount of tax 1 ←Amount of taxable items 1 ←Amount of tax 2 ←Amount of taxable items 2
$123,456 $1,234,567 $123,456
←Amount of tax 10 ←Amount of taxable items 10 ←Total of tax-exempt
【80mm width form】 1234567890123456789012345678901234567890 FIXED TOTAL CONSOLIDATION X REPORT ---------------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 CASH IN DRAWER $1,234,567,890,123 CASH DECLARATION $1,234,567,890,123 CASH DECLARATION +/($1,234,567.123) ($1,234,567,890,123) CHECK IN DRAWER $1,234,567,890,123 CHECK DECLARATION $1,234,567,890,123 CHECK DECLARATION +/($1,234,567.123) ($1,234,567,890,123) CREDIT IN DRAWER $1,234,567,890,123 CREDIT DECLARATION $1,234,567,890,123 CREDIT DECLARATION +/- ($1,234,567.123) ($1,234,567,890,123) COVER 123 $1,234 DISCOUNT 123 $1,234 SERVICE(ROUNDING) $1,234,567 CANCEL 123 $1,234 TA1 $123,456 TAX1 $1,234,567 TA2 $123,456 TAX2 $1,234,567 : TA10 $123,456 TAX10 $1,234,567 EXEMPT TOTAL $123,456
60
←Report header ((C20), Read (C9) ←Prints dotted line ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales frequency (N5) ←Net sales amount (N13) ←Present amount of cash in the drawer ←Declared amount in cash ←Declared cash amount – Present cash amount ※If the title and amount touch together in the same line, the amount will be printed in the next line ←Present amount of credit ←Declared amount of credit ←Declared credit amount – present credit amount ※ ←Present amount of credit card sales ←Declared amount of credit card sales ←Declared credit card amount – present credit card amount ※ ←Number of customers ←Amount per customer ←Frequency of discount ←Amount of discount ←Amount of rounded service charge← ←Frequency of cancellation ←Amount of cancellation ←Amount of tax 1 ←Amount of taxable items 1 ←Amount of tax 2 ←Amount of taxable items 2 ←Amount of tax 10 ←Amount of taxable items 10 ←Total of tax-exempt
8.2.2 Output format of Transaction (Function) button operations report There are two types of the transaction (Function) button operations report form, 58mm width form and 80mm width form. The followings show the transaction (Function) button operations report forms. 【58mm width form】 1234567890123456789012345678901 TRANSACTION CONSOLIDATION X REPORT ------------------------------Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 :
←Report header(C20),Read (C9) ←Prints dotted line ← button name 1 (C24), Transaction code(C6) ←Frequency of the transaction 1 (N10) ←Amount of the transaction 1 (N13) ← button name 2 (C24), Transaction code(C6) ←Frequency of the transaction 2 (N10) ←Amount of the transaction 2 (N13)
【80mm width form】 1234567890123456789012345678901234567890 TRANSACTION CONSOLIDATION X REPORT ---------------------------------------Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 :
←Report header (C20), Read (C9) ←Prints dotted line ← button 1 name(C24),Transaction code(C6) ←Frequency of transaction (N10) ←Amount of transaction 1 (N13) ← button 2 name(C24),Transaction code(C6) ←Frequency of transaction (N10) ←Amount of transaction 2 (N13)
61
8.2.3 Output format of individual item sales report There are two types of individual item sales report form, 58mm width form and 80mm width form. The followings show the individual item sales report forms. 【58mm width report】 1234567890123456789012345678901 PLU CONSOLIDATION X REPORT ------------------------------PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Item #1 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted item (N10) ←Amount of discounted item (N13) ※ ←Item #2 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted item (N10) ←Amount of discounted item (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discounted item ←Amount of discounted item ※
【80mm width form】 1234567890123456789012345678901234567890 PLU CONSOLIDATION X REPORT ---------------------------------------PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
62
←Report header (C14), Read (C9) ←Prints dotted line ←Item #1 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted items (N10) ←Amount of discounted items (N13) ←Item #2 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted items (N10) ←Amount of discounted items (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discounted items ←Amount of discounted items
8.2.4 Output format of individual department sales report There are two types of individual department sales report form, 58mm width form and 80mm width form. The followings show the individual department sales report forms. 【58mm width report】 1234567890123456789012345678901 DEPT CONSOLIDATION X REPORT ------------------------------DEPT NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 DEPT NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Dept. #1 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept. #1 discount (N10) ←Amount of dept.1 discount (N13) ※ ←Dept. #2 name (C24), Dept. #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept. #2 discount (N10) ←Amount of dept. #2 discount (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount ※
【80mm width form】 1234567890123456789012345678901234567890 DEPT CONSOLIDATION X REPORT ---------------------------------------DEPT NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 DEPT NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Dept. #1 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept.#1 discount (N10) ←Amount of dept. #1 discount (N13) ←Dept. #2 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept.#2 discount (N10) ←Amount of dept. #2 discount (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount
63
8.2.5 Output format of individual group’s sales report There are two types of individual group’s sales report form, 58mm width form and 80mm width form. The followings show the individual group’s sales report forms. 【58mm width report】 1234567890123456789012345678901 GROUP CONSOLIDATION X REPORT ------------------------------GROUP NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 GROUP NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Group #1 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #1 discount (N10) ←Amount of group #1 discount (N13) ※ ←Group #2 name (C24), Group #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #2 discount (N10) ←Amount of group #2 discount (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount ※
【80mm width report】 1234567890123456789012345678901234567890 GROUP CONSOLIDATION X REPORT ---------------------------------------GROUP NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 GROUP NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
64
←Report header (C14), Read (C9) ←Prints dotted line ←Group #1 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #1 discount (N10) ←Amount of group #1 discount (N13) ←Group #2 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #2 discount (N10) ←Amount of group #2 discount (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount
8.2.6
Output format of individual clerk’s sales report There are two types of individual clerk’s sales report form, 58mm width form and 80mm width form. The followings show the individual clerk’s sales report forms.
【58mm width report】 1234567890123456789012345678901 CLERK CONSOLIDATION X REPORT ------------------------------CLERK NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AM $1,234 $1,234,567,890,123 CLERK NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Clerk #1 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #1 discount (N10) ←Amount of clerk #1 discount (N13) ※ ←Clerk #2 name (C24), Clerk #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #2 discount (N10) ←Amount of clerk #2 discount (N13) ※
【80mm width report】 1234567890123456789012345678901234567890 CLERK CONSOLIDATION X REPORT ---------------------------------------CLERK NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 CLERK NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
←Report header (C14), Read (C9) ←Prints dotted line ←Clerk #1 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #1 discount (N10) ←Amount of clerk #1 discount (N13) ←Clerk #2 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #2 discount (N10) ←Amount of clerk #2 discount (N13)
65
8.2.7 Output format of hourly sales report There are two types of hourly sales report form, 58mm width form and 80mm width form. The followings show the hourly sales report forms. 【58mm width report】 1234567890123456789012345678901 HOURLY CONSOLIDATION X REPORT ------------------------------0:00->01:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 01:00->02:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 ------------------------------TOTAL ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345
←Report header (C14), Read (C9) ←Prints dotted line ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers(N5) ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers(N5) ←Prints dotted line ←Total ←Ordered quantity ←Ordered amount ←Sold quantity ←Sold amount ←Number of customers
【80mm width form】 1234567890123456789012345678901234567890 HOURLY CONSOLIDATION X REPORT ---------------------------------------0:00->01:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 01:00->02:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 -----------------------------------------TOTAL ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345
66
←Report header (C14), Read (C9) ←Prints dotted line ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers (N5) ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers (N5) ←Prints dotted line ←Total ←Ordered quantity ←Ordered amount ←Sold quantity ←Sold amount ←Number of customers
8.3
X Report (Read report) screen operations This clause explains features you should know about X report (read report) printing. On the following two screens, reports subject to be printed are marked as ✔.You can preset ✔ marks as default setting. For details, please refer to “8.3.3 X report settings”.
8.3.1 X report screen
To print X report (read report), select reports you require (multiple reports can be selected) and touch button then touch button.
67
8.3.2 X report (inlin)screen [Terminal selection]
Select inline connected terminals you wish to collect data. Sales data are collected from the selected VX-100 terminals. You can select multiple terminals.
68
[X report printing] The following screen is for printing X report.
8.3.3 Default X report settings The following setting defines reports to be printed or not at default. 【Flag to be set】 Default X Repor Defaultt flag The flag sets sum reports whether they are printed or not at default.
0: Non print 1: Print
The reports set as “1” will be marked as ✔ on the X Report and X Report (Inline) screens at default. 69
8.4
Open check report (X report) Open check report prints checks which are registered but not completed the transaction. ※Open check report prints uncompleted checks but it does not delete them.
8.4.1 Data to be reported Open check report prints registration mode, terminal name, clerk name, date, time,check number, number of customers, table number, and subtotal amount.
8.4.2 Output forms of open check report (X report)
There are two types of open check report form, 58mm width form and 80mm width form. The followings show the report forms.
【58mm width report】
1234567890123456789012345678901 2011/12/14
11:01 PM
OPEN CHECK ------------------------------REG 01 CLERK 2011/12/14 10:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL $1,234,567,890,123 REG 02 CLERK 2011/12/14 11:15 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL $1,234,567,890,123
70
←Date and time ←One line feed ←Title of the report ←Dotted line print ←Registration mode (C4), Terminal No. (C2), Clerk name (C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number(C12) ←Subtotal ←Registration mode (C4), Terminal No. (C2), Clerk name (C24) ←Date and time ←Check number (C6) ←Number of customers(N5) ←Table number(C12) ←Subtotal
【80mm width report】 1234567890123456789012345678901234567890 2011/12/14
11:01 PM
OPEN CHECK ---------------------------------------REG 01 CLERK 2011/12/14 10:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL $1,234,567,890,123 REG 02 CLERK 2011/12/14 11:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL $1,234,567,890,123
←Date and time ←One line feed ←Title of the report ←Dotted line print ←Registration mode (C4),Terminal number(C2),Clerk name(C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal ←Registration mode (C4),Terminal number(C2),Clerk name(C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal
Open check report will not be printed if there is no uncompleted check.
71
9. Z(Reset sales) report The reset sales report function calculates and prints out the total sales of the day
9.1
Creating the reset sales report data Reset sales report data is created by accumulating the information and amounts of the checks of the day.
9.1.1 Structure of reset sales report database In reset sales, today’s total sales file is created by accumulating sales database files (CST004 and CST005). When reset sales data is created, accumulated data of the day’s check will be deleted.
72
The following shows the structure of the reset sales database.
CST004
CST005
Total amount
Specifics of check
This database file manages the total sales amount of the checks.
This database file manages the specifics of the checks.
Reset sales
After reading, total amount and specifics of the checks will be deleted.
Reading today’s data
Database update (adding or correcting)
Data files for totaling day’s sales CSS011 Total amount of sales
CSS014 Sum of each item
CSS017 Sum of each clerk
Check
CSS012 Fixed adder
CSS015 Sum of Individual dept.
CSS018 Customer stratum sum
CSS013 Sum of each Function b
CSS016 Sum of each item group
CSS019 Sum of hourly sales
An error occurs at Z (reset sales) report if there is any uncompleted check. In such a case, complete the check or perform the open check report (Z report).
73
9.1.2 Cumulative sales data The data for reset sales is created by accumulating the amount and specifics of the day’s checks.
The accumulated data can be also printed in read report.
74
9.1.3 Storing reset sales data in an SD card You can store the reset sales data in an SD card.
To store reset sales data in an SD card, it is necessary to enable SD card usage in operation settings. Please refer to “9.3.3 Z report settings”
9.1.4
Rest sales data to be printed The data accumulated in the following data files will be printed at the reset sales. ・CSS011 (Total sales amount) ・CSS012 (Total money in drawer) ・CSS013 (Total amount of transactions using transaction (Function) button) ・CSS014 (Total amount of individual item) ・CSS015 (Total amount of individual department) ・CSS016 (Total amount of individual item group)
75
・CSS017 (Total amount of individual clerk) ・CSS019 (Total amount of hourly sales)
9.2 Output forms of reset sales report 9.2.1 Output forms of total sales reset sales report There are two types of total sales reset report form, 58mm width form and 80mm width form. The followings show the report forms. 【58mm width report】 1234567890123456789012345678901 FIXED TOTAL CONSOLIDATION 123456 Z REPORT ------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 CASH IN DRAWER $123,456 $1,234,567,890,123
←Report header ((C25) ←Reset No. (C6) Reset (C9) ←Prints dotted line ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales frequency (N5) ←Net sales amount (N13) ←Present amount of cash in the drawer ※If the title and amount touch together in the same line, the amount will be printed in the next line
CASH DECLARATION $1,234,567 CASH DECLARATION +/$123,456 $1,234,567 CHECK IN DRAWER $123,456 $1,234,567,890,123 CHECK DECLARATION $1,234,567 CHECK DECLARATION +/$123,456 $1,234,567 CREDIT IN DRAWER $123,456 $1,234,567,890,123 CREDIT DECLARATION $1,234,567 CREDIT DECLARATION +/- $123,456 $1,234,567 COVER 123 $1,234 DISCOUNT 123 $1,234 SERVICE(ROUNDING) $1,234,567 CANCEL 123 $1,234 TA1 $123,456 TAX1 $1,234,567 TA2 $123,456 TAX2 $1,234,567 : TA10 $123,456 TAX10 $1,234,567 EXEMPT TOTAL $123,456
76
←Declared amount in cash ←Declared cash amount – Present cash amount ※ ←Present amount of credit ※ ←Declared amount of credit ←Declared credit amount – present credit amount ※ ←Present amount of credit card sales ※ ←Declared amount of credit card sales ←Declared credit card amount – present credit card amount ※ ←Number of customers ←Amount per customer ←Frequency of discount ←Amount of discount ←Amount of rounded service charge← ←Frequency of cancellation ←Amount of cancellation ←Amount of tax 1 ←Amount of taxable items 1 ←Amount of tax 2 ←Amount of taxable items 2 ←Amount of tax 10 ←Amount of taxable items 10 ←Total of tax-exempt
【80mm width report】 1234567890123456789012345678901234567890 FIXED TOTAL CONSOLIDATION 123456 Z REPORT ---------------------------------------GROSS 123456.789 $1,234,567,890,123 NET 12,345 $1,234,567,890,123 CASH IN DRAWER $1,234,567,890,123
←Report header (C20) ←Reset No.(C6),Reset (C9) ←Prints dotted line ←Gross sales quantity (N10) ←Gross sales amount (N13) ←Net sales frequency (N5) ←Net sales amount (N13) ←Present amount of cash in the drawer
CASH DECLARATION $1,234,567,890,123 CASH DECLARATION +/($1,234,567.123) ($1,234,567,890,123)
←Declared amount in cash ←Declared cash amount – Present cash amount ※If the title and amount touch together in the same line ,the amount will be printed in the next line ←Present amount of credit ←Declared amount of credit ←Declared credit amount – present credit amount ※ ←Present amount of credit card sales ←Declared amount of credit card sales ←Declared credit card amount – present credit card amount ※ ←Number of customers ←Amount per customer ←Frequency of discount ←Amount of discount ←Amount of rounded service charge← ←Frequency of cancellation ←Amount of cancellation ←Amount of tax 1 ←Amount of taxable items 1 ←Amount of tax 2 ←Amount of taxable items 2
CHECK IN DRAWER $1,234,567,890,123 CHECK DECLARATION $1,234,567,890,123 CHECK DECLARATION +/($1,234,567.123) ($1,234,567,890,123) CREDIT IN DRAWER $1,234,567,890,123 CREDIT DECLARATION $1,234,567,890,123 CREDIT DECLARATION +/- ($1,234,567.123) ($1,234,567,890,123) COVER 123 $1,234 DISCOUNT 123 $1,234 SERVICE(ROUNDING) $1,234,567 CANCEL 123 $1,234 TA1 $123,456 TAX1 $1,234,567 TA2 $123,456 TAX2 $1,234,567 : TA10 $123,456 TAX10 $1,234,567 EXEMPT TOTAL $123,456
←Amount of tax 10 ←Amount of taxable items 10 ←Total of tax-exempt
77
9.2.2 Output format of Transaction (Function) button operations report There are two types of the Transaction (Function) button operations report form, 58mm width form and 80mm width form. The followings show the Transaction (Function) button operations report forms. 【58mm width form】 1234567890123456789012345678901 TRANSACTION CONSOLIDATION 123456 Z REPORT ------------------------------Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123
←Report header(C20) ←Reset No. (C6), Reset (C9) ←Prints dotted line ← button name 1 (C24), Transaction code(C6) ←Frequency of the transaction 1 (N10) ←Amount of the transaction 1 (N13) ← button name 2 (C24), Transaction code(C6) ←Frequency of the transaction 2 (N10) ←Amount of the transaction 2 (N13)
【80mm width form】 1234567890123456789012345678901234567890 TRANSACTION CONSOLIDATION 123456 Z REPORT ---------------------------------------Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123 Function Button Name 123456 COUNT 123456.789 AMT $1,234,567,890,123
78
←Report header (C20) ←Reset No. (C6), Reset (C9) ←Prints dotted line ← button 1 name (C24), Transaction code (C6) ←Frequency of transaction (N10) ←Amount of transaction 1 (N13) ← button 2 name (C24), Transaction code (C6) ←Frequency of transaction (N10) ←Amount of transaction 2 (N13)
9.2.3 Output format of individual item sales report There are two types of individual item sales report form, 58mm width form and 80mm width form. The followings show the individual item sales report forms. 【58mm width report】 1234567890123456789012345678901 PLU CONSOLIDATION 123456 Z REPORT ------------------------------PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14) ←Reset No. (C6), Reset (C9) ←Prints dotted line ←Item #1 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted item (N10) ←Amount of discounted item (N13) ※ ←Item #2 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted item (N10) ←Amount of discounted item (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discounted item ←Amount of discounted item ※
【80mm width form】 1234567890123456789012345678901234567890 PLU CONSOLIDATION 123456 Z REPORT ---------------------------------------PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 PLU NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
←Report header (C14), Reset No. (C6), Reset (C9) ←Prints dotted line ←Item #1 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted items (N10) ←Amount of discounted items (N13) ←Item #2 name (C24), Item code (C16) ←Quantity (N10) ←Amount (N13) ←Quantity of discounted items (N10) ←Amount of discounted items (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discounted items ←Amount of discounted items
79
9.2.4 Output format of individual department sales report There are two types of individual department sales report form, 58mm width form and 80mm width form. The followings show the individual department sales report forms. 【58mm width report】 1234567890123456789012345678901 DEPT CONSOLIDATION 123456 Z REPORT ------------------------------DEPT NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 DEPT NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14) ←Reset No. (C6), Reset (C9) ←Prints dotted line ←Dept. #1 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept. #1 discount (N10) ←Amount of dept.1 discount (N13) ※ ←Dept. #2 name (C24), Dept. #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept. #2 discount (N10) ←Amount of dept. #2 discount (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount ※
【80mm width form】 1234567890123456789012345678901234567890 DEPT CONSOLIDATION 123456 Z REPORT ---------------------------------------DEPT NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 DEPT NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
80
←Report header (C14), Reset No. (C6), Reset (C9) ←Prints dotted line ←Dept. #1 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept.#1 discount (N10) ←Amount of dept. #1 discount (N13) ←Dept. #2 name (C24), Dept. code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of dept.#2 discount (N10) ←Amount of dept. #2 discount (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount
9.2.5 Output format of individual group’s sales report There are two types of individual group’s sales report form, 58mm width form and 80mm width form. The followings show the individual group’s sales report forms. 【58mm width report】 1234567890123456789012345678901 GROUP CONSOLIDATION 123456 Z REPORT ------------------------------GROUP NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 GROUP NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123 ------------------------------TOTAL QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14) ←Reset No. (C6), Reset (C9) ←Prints dotted line ←Group #1 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #1 discount (N10) ←Amount of group #1 discount (N13) ※ ←Group #2 name (C24), Group #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #2 discount (N10) ←Amount of group #2 discount (N13) ※ ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount ※
【80mm width form】 1234567890123456789012345678901234567890 GROUP CONSOLIDATION 123456 REPORT ---------------------------------------GROUP NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 GROUP NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 ---------------------------------------TOTAL QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
←Report header (C20),Reset No. (C6), Reset (C9) ←Prints dotted line ←Group #1 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #1 discount (N10) ←Amount of group #1 discount (N13) ←Group #2 name (C24), Group code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of group #2 discount (N10) ←Amount of group #2 discount (N13) ←Prints dotted line ←Total ←Quantity ←Amount ←Quantity of discount ←Amount of discount
81
9.2.6 Output format of individual clerk’s sales report There are two types of individual clerk’s sales report form, 58mm width form and 80mm width form. The followings show the individual clerk’s sales report forms. 【58mm width report】 1234567890123456789012345678901 CLERK CONSOLIDATION 123456 Z REPORT ------------------------------CLERK NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AM $1,234 $1,234,567,890,123 CLERK NAME 1234567890123456 QYT 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234 $1,234,567,890,123
←Report header (C14) ←Reset No. (C6), Reset (C9) ←Prints dotted line ←Clerk #1 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #1 discount (N10) ←Amount of clerk #1 discount (N13) ※ ←Clerk #2 name (C24), Clerk #2 code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #2 discount (N10) ←Amount of clerk #2 discount (N13) ※
【80mm width form】 1234567890123456789012345678901234567890 CLERK CONSOLIDATION 123456 Z REPORT ---------------------------------------CLERK NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123 CLERK NAME 123456 QTY 123456.789 AMT $1,234,567,890,123 DISCOUNT QYT 123456.789 DISCOUNT AMT $1,234,567,890,123
82
←Report header (C20), Reset No. (C6), Reset (C9) ←Prints dotted line ←Clerk #1 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #1 discount (N10) ←Amount of clerk #1 discount (N13) ←Clerk #2 name (C24), Clerk code (C6) ←Quantity (N10) ←Amount (N13) ←Quantity of clerk #2 discount (N10) ←Amount of clerk #2 discount (N13)
9.2.7 Output format of hourly sales report There are two types of hourly sales report form, 58mm width form and 80mm width form. The followings show the hourly sales report forms. 【58mm width report】 1234567890123456789012345678901 HOURLY CONSOLIDATION 123456 Z REPORT ------------------------------0:00->01:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 01:00->02:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 ------------------------------TOTAL ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345
←Report header (C14) ←Reset No. (C6), Reset (C9) ←Prints dotted line ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers(N5) ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers(N5) ←Prints dotted line ←Total ←Ordered quantity ←Ordered amount ←Sold quantity ←Sold amount ←Number of customers
【80mm width form】 HOURLY CONSOLIDATION 123456 Z REPORT ---------------------------------------0:00->01:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 01:00->02:00 ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345 -----------------------------------------TOTAL ORDER QTY 123456.789 ORDER AMT $1,234,567,890,123 QTY 123456.789 AMT $1,234,567,890,123 COVER 12,345
←Report header (C20), Reset No. (C6), Reset (C9) ←Prints dotted line ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers (N5) ←Time zone ←Ordered quantity (N10) ←Ordered amount (N13) ←Sold quantity (N10) ←Sold amount (N13) ←Number of customers (N5) ←Prints dotted line ←Total ←Ordered quantity ←Ordered amount ←Sold quantity ←Sold amount ←Number of customers
83
9.3
Z (Reset sales) report screen operations This clause explains features you should know about Z report (reset sales) printings. On the following two screens, reports subject to be printed are marked as ✔. You can preset ✔ marks as default setting. Please refer to” 9.3.3 Z report settings”.
9.3.1
Z report screen
To print Z (reset sales) report, select reports you require (multiple reports can be selected) and touch button then touch button.
84
9.3.2
Z report (inline) screen
[Terminal selection]
Select inline connected terminals you wish to collect data. Sales data are collected from the selected VX-100 terminals. You can select multiple terminals.
85
[Z report printing] The following screen is for printing Z report.
9.3.3
Default Z report settings The following setting defines reports to be printed or not at default. 【Flags to be set】 1. Default Z Report Default
Flag
The flag sets sum reports whether they are printed or not at default.
0: Non print 1: Print
The reports set as “1” will be marked as ✔ on the Z Report, Z Report (Inline) and periodic sales report screens at default.
86
2. Use SD This flag defines the usage of SD card in Z mode. 0: SD card is used 1: SD card is not used
9.4 Periodic report Periodic report provides sums of selected categories in assigned period.
9.4.1 Periodic report screen
87
9.5 Transaction report Transaction report enables to confirm the details of assigned transaction. Unfinished transaction data cannot be reported.
88
9.6
Open check report (Z report) Open check report prints checks that the transaction is uncompleted. After printing the open check report, the terminal deletes the uncompleted checks ompulsively.
9.6.1 Data to be reported Open check report prints registration mode, terminal name, clerk name, date, time, check number, number of customers, table number, and subtotal amount.
9.6.2 Output forms of open check report There are two types of open check report form, 58mm width form and 80mm width form. The followings show the report forms. 【58mm width report】 1234567890123456789012345678901 2011/12/14
11:01 PM
OPEN CHECK ------------------------------REG 01 CLERK 2011/12/14 10:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL \1,234,567,890,123 REG 02 CLERK 2011/12/14 11:15 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL \1,234,567,890,123
←Date and time ←One line feed ←Title ←Dotted line print ←Registration mode (C4), Terminal number (C2) Clerk name (C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal ←Registration mode (C4), Terminal number (C2) Clerk name (C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal
89
【80mm width report】 1234567890123456789012345678901234567890 2011/12/14
11:01 PM
OPEN CHECK ---------------------------------------REG 01 CLERK 2011/12/14 10:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL \1,234,567,890,123 REG 02 CLERK 2011/12/14 11:00 PM INVOICE NUMBER 000001 COVER 12345 TABLE NUMBER 0123456789AB SUBTOTAL \1,234,567,890,123
←Date and time ←One line feed ←Title ←Dotted line print ←Registration mode(C4),Terminal number(C2),Clerk name(C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal ←Registration mode(C4),Terminal number(C2),Clerk name(C24) ←Date and time ←Check number (C6) ←Number of customers (N5) ←Table number (C12) ←Subtotal
Open check report will not be printed if there is no uncompleted check.
90
10. Inline functions Inline function collects connected VX-100 terminals’ X (read report) data or Z (reset sales report) data to a VX-100 terminal so that total of connected terminals’ X or Z report data can be printed. The followings are the features of inline functions.
Check sharing (inline) Sales data collection (inline) X report (inline) Z report (inline) Set data sharing (inline)
10.1 Definition of inline environment To utilize the inline features of VX-100, it is necessary to define information of connected inline devices. For details, please refer to “2.1.3 CTN004 (Network device settings) in section 4.
10.2 Check sharing
In the inline environment, the check tracking system which enables features such as check sharing can be utilized. The figure shown above indicates collecting data of shared checks from satellite VX-100s to the master VX-100. Available features of the check tracking system are as follows. ･Issuing new check ･Holding order ･Calling checks ･Closing checks ･Present check list display ･Open check (Z report) 91
Check
It may occur that shared check cannot be called due to a network failure. In such a case, error code E052 “Check/table is busy” will be shown. Please refer to 4.3 “Check busy reset” in section 4.
10.3 Collecting sales data and printing X/Z (inline) reports In the inline environment, you can collect sales data from the connected VX-100s and print X (read report) or Z (Reset sales) reports. Please refer to 8.3 “X (Read data) screen operations” and 9.3 “Z (Reset sales) screen operations” for more details.
10.4 Sharing set data (inline) This feature forwards the setup data to other VX-100s on the network. Data to be forwarded are changed item’s data, added new clerks, or definition of device’s environment etc. Please refer to “7. Set data transmission” in section 3.
92
11. Electronic Journal The electronic journal stores sales transactions and displays designated transaction on the screen.
Basic usage: Select a date you wish to check from the left half of the screen. The selected journal will be shown on the right half of the screen. Page print: Prints the contents of the right half of the screen. Print: Prints all the journals listed on the left half of the screen.
93
94
SECTION 3 TASK SETTINGS
SECTION 3 TASK SETTINGS This section explains the preparations and settings to operate the terminal. Task settings consists of Seven settings for daily work. TASK SETTINGS 01
Clerk setting
02
Item setting
03
Transaction setting
04
Button setting
05
Print setting
06
Operation setting
07
Set data transmission
Task settings are for daily operations and managements. The settings which are not prepared in Work ｍenu can be set by entering set data directly in a table using Database setting tool. This section explains which data should be entered in which table, rather than how to use DB management tool.
96
About the table definition As it is important to know the functions of table contents, this section explains basic functions of the table definitions. A table definition is composed of column code, column name, column type, size, possibility of Null setting, and default value. The followings explain the meanings of each item. Column code
Column Name
Type
SIZE
NULL
CLKCODE
Clerk code
C
10
□
CLKNAME
Clerk name
C
24
□
CLKFULLNAME
Clerk’s full name
C
36
■
PASSWORD
Password
C
20
■
CLKGRPCODE
Clerk group code
C
6
□
DRAWERNUMBER C
Cash drawer number
C
1
□
Default value
o lumn code Data string in the table definition. The column code will be shown in database operations. Column name Name of each column. Type Indicates data type of the table definition. C:Character・・・Numbers and characters can be set. If the column code is “xx code” or “xx number”, numerals should be stored. Numeral strings are justified on the right. e.g.) Setting numeral: 123→ Set value in a table will be; 0000000123 N: Only numerals can be set. Used for numeral values such as amount of money. SIZE Indicates the maximum digit. Null □：Inhibits to set null value. A value must be appended. ■：Null value can be set. Default value The initial value for newly added column. If the value is unset, the default value will be set in the column.
97
1. Clerk setting It is necessary to set information for clerks for authenticating the clerk when the person signs on to operate the VX-100.
This setting prepares basic attributes for newly added clerks. In normal use, it sets attributes such as clerk code, and name for newly hired person.
1.1.
Clerk setting screen
Please refer to 1.2.1 “CSB004 (Clerk setting)” for setting basic information of clerks. Dallas key ID is i-Button information data. Please refer to 1.2.3 CSB010 “Dallas key (i-Button) setting”.
98
1.2. Relevant tables The tables for setting basic information for a clerk are CSB004 (Clerk setting) and CSB005 (Clerk group setting). The followings explain the contents of the tables for setting a clerk.
1.2.1.
CSB004 (Clerk setting) This table stores the basic information for a clerk. Column code
Column Name
Type
SIZE
NULL
CLKCODE
Clerk code
C
10
□
CLKNAME
Clerk name
C
24
□
CLKFULLNAME
Clerk’s full name
C
36
■
PASSWORD
Password
C
20
■
CLKGRPCODE
Clerk group code
C
6
□
DRAWERNUMBER
Cash drawer number
C
1
□
CLKINTCODE
Clerk’s order check number
C
6
□
NBCHKNUMFROM
Usable order number range
C
6
□
C
6
□
Default value
1 NBCHKNUMTO
Usable
order
number
range2 UNUSABLE
Unusable flag
C
1
□
REMARKS
Remarks
C
30
■
CLKCODE（Clerk code） Stores 10-digit alpha-numeric string to identify individual clerk. CLKNAMENAME (User name) A character string for the name of a clerk. The set name will be displayed on the screen. CLKFULLNAME (Clerk’s full name) A character string of full name of a clerk. PASSWORD (Password) An alpha-numeric string for storing a password. You can use alphabets for a password however, you cannot use double bytes characters or specific symbols such as *, /,?. CLKGRPCODE (Clerk’s group code) A six-digit alpha-numeric string indicating the attribution of a clerk’s group. Please set the same clerk group code as CSB005 (Clerk group) table. DRAWERNUMBER (Cash drawer number) A one-digit number storing the cash drawer number that the clerk uses. ※
The drawer number 1 is assigned if cash drawer number is set as “0”. The cash drawer number setting is necessary only when you use more than two drawers. If only one drawer is used, you do not have to set this column
99
The following three columns are not necessary for the clerk setting. CLKINTCODE (Clerk’s order check number) BCHKNUMFROM (Usable order check number range 1) BCHKNUMTO (Usable order check number range 2)
UNUSABLE (Unusable flag) A flag that permits or prohibits a clerk to use the unit.
Unusable Flag
Definition
0
Permission
1
Prohibition
REMARKS (Remarks) You can store any character string.
1.2.2.
CSB005 (Clerk group ) This table manages the attribution of grouped clerks. Column code
Column Name
Type
SIZE
NULL
CLKGRPCODE
Clerk group code
C
6
□
CLKGRPNAME
Clerk group name
C
40
■
REMARKS
Remarks
C
30
■
CLKGRPCODE (Clerk group code) An alpha-numeric string that defines six-digit clerk group code. CLKGRPNAME (Clerk group name) An alpha-numeric string that stores a name of a clerk group. REMARKS (Remarks) You can store any character string.
100
Default value
1.2.3.
CSB010 (Dallas key (i-Button) setting This table stores Dallas key (i-Button) data.
Column code
Column Name
Type
SIZE
NULL
DALLASKEYID
Dallas key ID
C
12
□
CLKCODE
Clerk code
C
10
□
REMARKS
Remarks
C
30
■
CREATEDATETIME
Created date and time
C
14
□
UPDATEDATETIME
Updated date and time
C
14
□
Default value
DALLASKEYID（Dallas key ID：iButton ID） A 12-digit character string storing Dallas key ID. CLKCODE（Clerk code） A character string storing signing in clerk’s code. REMARKS（Remarks） You can store any character or number in this column.
1.2.4.
CSB006 (Clerk group settings)
The table stores parameter data of clerk groups.
Column code
Column Name
CLKGRPCODE C L CLKSETCODE K G VALUE R P REMARKS C O CREATEDATETIME D E
（
UPDATEDATETIME C l e rk group code）
Type
SIZE
NULL
Clerk group code
C
6
□
Clerk setting code
C
80
□
Set value
C
20
□
Remarks
C
30
■
Created
date
and
C
14
□
date
and
C
14
□
Default value
time Updated time
A 6-digit alpha-numeric string storing clerk group code. CLKSETCODE (Clerk set code) A character string storing following clerk set code. CLKSETCODE SCREEN.AFTERLOGIN
SCREEN.AFTERLOGIN.TOPMENU.
VALUE 0
0
Description Controls the Work ｍenu after signing on. 0: Boots the Work ｍenu 1: Sales registration screen (Boots the sales registration screen without booting Work ｍenu. The startup screen corresponds to the screen set in “5. Screen style setting) in clause 6.2. Determines the execution menu in Work ｍenu.
101
XXXXXX
XXXXXX corresponds to menu application function code. Please refer to the next page for menu application function code. 0: Display (Displays corresponding execution menu) 1: Not display (Corresponding execution menu is not displayed)
OPERATION.MODE.TRAINING
0
OPERATION.AUTOSIGNOFF
0
e.g.) In case inhibiting refund operations on a clerk group. CLKSETCODE=SCREEN.AFTERLOGIN.TOPMENU.100322 VALUE=1 Determines trainee clerk operation. 0: No (operated by a normal clerk) １: Yes (Operated by a trainee clerk) Sign-off automatically when finalized.(Standard style model only) 0:No(invalid) 1:Yes(Automatic sign-off)
VALUE (Set value) For setting values explained in the above table. The default value is “0”. REMARKS（Remarks） You can store any character or number in this column.
1.2.5.
Menu application function code list
The list below explains the function codes of menu applications. Menu application function code Function code
102
Menu name
Function
100304
Registration
Starts sales registrations
100322 200300 200301 200302 200303 200309 200310 200311 200312 200313 200314 200315 200316 300300 300302 300303 300305 300306 300307 300308 300309 300310 300311 300312 300313
Refund
Starts refund operations Starts flash reporting Starts Z (reset sales) reporting Starts open for business operation Starts reset sales operation Starts money declaration Starts X (read report) reporting Starts X report (inline) Starts X report of open checks Starts Z report (inline) Starts periodic sales reporting Starts Z report for open checks Starts transaction report Starts change preparation operation Starts money received operation Starts money paid operation Starts Android settings Boots the browser Starts Emailing Starts electronic journal Starts database settings Boots the manual Boots the customer notes Starts customer’s purchase analysis Boots reservation note
Flash Report Z Report Open Z Money Declaration X Report X Report (Inline) Open Check X Z Report (Inline) Transaction Report Open Check Z Periodic Report Loan RC PD Android Settings Browser Mail EJ Data Settings Manual Customer Note Customer Analysis Reservation Not
300314 300315 300316 300317 300318 300319 300320 300321 300322 300323
1.3
Clerk Settings Item Settings Settings Trans Customer Settings Reservation Setting Email Remote Data Management Control Panel Restart Operation Log
Starts clerk settings Starts item settings Starts set data transmission Starts customer management settings Starts reservation management settings Starts Email remote control settings Starts database management Boots the control panel Boots restart operation Starts Operation log
About image graphic settings The business support terminal VX-100 is able to display photographic portraits of clerks or pictures of items on the screen. Please refer to “3.2.2 CSB012 Image layout settings” for storing image graphics.
103
2. Item settings Item settings define the information of commodities. In these settings, you can set various parameters such as name, unit price, quantity, or sales limitation.
2.1
Item setting screen
Please refer to “2.3.4 CSA001 (Item setting group)” for the contents of the item settings.
104
2.2
Database structure for item settings The following figure shows the database structure for item settings. Sales of items
CIA001 Item master
CIA002 Department master
CIB002 Set item composition master
Manages basic data for items such as item code, item name and unit price.
Manages the information of items that are composed in a set item.
CIA003
CSA001
CIB001
Item group master
Item setting group master
Set item master
Manages department code and department name for grouped items
Manages item code and item name for item departments
Manages setting parameters of items such as order output, not subject for service point, number of food coupon, item classification, or selection or classification of item selection.
Manages code and name of set (combined) items.
【Item settings and sales management】 Item settings are very important process as they control sales operations and sales managements. Item names, unit prices, or item’ departments are not set on the item codes at the initial stage. The terminal does not indicate item names or unit prices if item information is not set, and you cannot analyze tendencies of sales. Therefore, item settings are very important process for sales managements.
105
【Item settings and sales registrations】 When you register a sold item, the information stored in the table for the item will show up on the sales registration screen automatically. The following figure is an example screen of registering a sold item.
Screen switching Tab button
There is a close relationship between item department master and item master On the above screen, items change by touching the screen switching tab buttons. On each item department tab, you can set items up to five screens. If you set items in an item department for more than five screens, exceeded items will not be shown on the screen.
106
2.3 Relevant tables for item settings Relevant tables for item settings are CIA001 (Item master), CIA002 (Item department master), CIA003 (Item group master), CSA001 (Item setting group), CIB001 (Set item master) and CIB002 (Set item composition master). The followings are the functions of each table.
2.3.1 CIA001 (Item master) The item master stores the fundamental information for each item.
Column code
Column Name
Type
SIZE
NULL
Default value
ITEMCODE
Item code
C
16
□
SCANCODE1
Scanning code 1
C
16
■
SCANCODE2
Scanning code 2
C
16
■
ITEMNAME
Item name
C
24
■
ITEMNAME2
Item name 2
C
24
■
ITEMNAME3
Item name 3
C
24
■
ITEMNAME4
Item name 4
C
24
■
ITEMDEPTCODE
Item department code
C
6
□
000001
ITEMPARMCODE
Item parameter code
C
6
□
000001
SETITEMCODE
Set item code
C
6
■
BOTTLERETURN
Set item for bottle returnable
C
6
■
code UNITWEIGHT
Unit weight
N
10
□
0
UNITQTY
Unit quantity
N
10
□
0
UNITPRICE
Unit price
N
13
□
0
UNITPRICENAME
Unit price name
C
20
■
TAXCODE_1
Tax code_1
C
2
□
TAXCODE_2
Tax code_2
C
2
■
TAXCODE_3
Tax code_3
C
2
■
TAXCODE_4
Tax code_4
C
2
■
TAXCODE_5
Tax code_5
C
2
■
UNITQTY2
Unit quantity 2
N
10
□
0
UNITPRICE2
Unit price 2
N
13
□
0
UNITPRICENAME2
Unit price name 2
C
20
■
TAXCODE2_1
Tax code 2_1
C
2
■
TAXCODE2_2
Tax code 2_2
C
2
■
TAXCODE2_3
Tax code 2_3
C
2
■
TAXCODE2_4
Tax code 2_4
C
2
■
01
107
TAXCODE2_5
Tax code 2_5
:
C
2
■
:
UNITQTY10
Unit quantity 10
N
10
□
0
UNITPRICE10
Unit price 10
N
13
□
0
UNITPRICENAME10
Unit price name 10
C
20
■
TAXCODE10_1
Tax code 10_1
C
2
■
TAXCODE10_2
Tax code 10_2
C
2
■
TAXCODE10_3
Tax code 10_3
C
2
■
TAXCODE10_4
Tax code 10_4
C
2
■
TAXCODE10_5
Tax code 10_5
C
2
■
ITEMCOST
Buying price (not used)
N
13
□
0
PROFITCOST
Gross price
N
13
□
0
AUTOUPFLG
Automatic learning flag
C
1
■
UNUSABLEFLG
Unusable flag
C
1
□
REMARKS
Remarks
C
30
■
CREATEDATETIME
Create date and time
C
14
□
UPDATEDATETIME
Update date and time
C
14
□
profit
calculation
0
ITEMCODE (Item code) An alpha-numeric string storing item code. You can set within 4 to 1six-digits one byte characters. SCANCODE1 (Scanning code 1) A numeral string storing the following scanned bar code data. JAN/EAN code: 13 or 8 digits numeral value UPC-A code: 12 digits numeral value beginning from 0 UPC-E code: 7 digits numeral value beginning from 0 except check digit SCANCODE2 (Scanning code 2) A numeral string storing the lower part of two tiered bar codes. ITEMNAME (Item name) An alpha-numeric string storing the name of an item. ITEMNAME2 (Item name 2) An alpha-numeric string which stores the item name 2. e.g.) for naming the item in a foreign language. ITEMNAME3 (Item name 3) An alpha-numeric string storing the item name 3. e.g.) for naming the item in the second foreign language. ITEMNAME4 (Item name 4) An alpha-numeric string storing the item name 4) e.g.) for storing a keyword to search the item. ITEMDEPTCODE (Item department code) A six-digit one byte alpha-numeric string which stores a department code. If you do not set this column, a six digit number 000001 will be set. The relationship between the item code and the item department code is very important.
108
Please refer to the “Point” on the previous page. ITEMPARMCODE (Item parameter group code) A six-digit alpha-numeric string which stores an item parameter group code. column, a six-digit number 000001 will be set.
If you do not set this
Item parameter group code is for managing the definition of a group of items. Please refer to 2.1.4 CSA001 (Item parameter group). SETITEMCODE (Set item code) A six-digit alpha-numeric string storing set item code. You need to set CIB001 (Set item master) and CIB002 (Set item composition master) beforehand. Refer to 2.1.5 CIB001 (Set item master) BOTTLERETURN (Bottle returnable set item code) A six-digit alpha-numeric string which stores bottle returnable set item. UNITWEIGHT (Unit weight) A numeral string storing a unit weight. UNITQTY (Unit quantity) A numeral string storing unit quantity. UNITPRICE (Unit price) A numeral string storing a unit price. UNITPRICENAME (Unit price name) An alpha-numeric string which stores a name of unit price. TAXCODE_1～_5（Tax code _1～_5） A numeral string which stores tax code for items objected of taxation. Up to five tax rates can be stored. Tax code 01 02 03 04 05 06 07 08 09 10 21 22 23 31
Definition Consumption tax (for tax-inclusive price) Consumption tax (for tax-exclusive price) Tax rate 3 Tax rate 4 Tax rate 5 Tax rate 6 Tax rate 7 Tax rate 8 Tax rate 9 Tax rate10 Prepared Tax(Canada) Baked Tax(Canada) Prepared & Baked Tax(Canada) US Food stamp
109
UNITQTY2 Unit quantity 2) A numeral string storing unit quantity 2. UNITPRICE2 (Unit price 2) A numeral string storing unit price 2. UNITPRICENAME2 (Unit price name 2) An alpha-numeric string storing unit price 2. TAXCODE2_1～2_5（Tax code 2_1～2_5） A numeral string which stores tax code for items objected of taxation. Up to five tax rates can be stored. Tax code 01
Definition Consumption tax (for tax-inclusive price) Consumption tax (for tax-exclusive price) Tax rate 3
02 03 04
Tax rate 4
05
Tax rate 5
06
Tax rate 6
07
Tax rate 7
08
Tax rate 8
09
Tax rate 9
10
Tax rate10
21
Prepared Tax(Canada)
22
Baked Tax(Canada)
23
Prepared & Baked Tax(Canada)
31
US Food stamp
： UNITQTY10 Unit quantity 10) A numeral string storing unit quantity 10. UNITPRICE10 (Unit price 10) A numeral string storing unit price 10. UNITPRICENAME10 (Unit price name 10) An alpha-numeric string storing unit price 10. TAXCODE10_1～10_5（Tax code 10_1～10_5） A numeral string which stores tax code for items objected of taxation. Up to five tax rates can be stored.
110
Tax code 01 02 03 04 05 06 07 08 09 10 21 22 23 31
Definition Consumption tax (for tax-inclusive price) Consumption tax (for tax-exclusive price) Tax rate 3 Tax rate 4 Tax rate 5 Tax rate 6 Tax rate 7 Tax rate 8 Tax rate 9 Tax rate10 Prepared Tax(Canada) Baked Tax(Canada) Prepared & Baked Tax(Canada) US Food stamp
ITEMCOST (Buying-in cost) not used. A numeral string which stores buying price of an item. PROFITCOST (Gross profit calculation price) A numeral string which stores sales price for gross profit calculation. ※Gross profit price is calculated by the following calculation. Gross profit price = “Unit price” – “Gross profit calculation price) If this file is not defined, the gross profit will be calculated by “Unit price” – “Buying-in cost”. AUTOUPFLG (Automatic learning flag) One digit number which indicates if the item is automatically added by bar code scanning. Automatically Definition added item 0 Not automatically added item 1 Automatically added flag UNUSABLEFLG（Unusable flag） One digit number which indicates whether the item is usable or not. Usable Flag Definition 0 Effective (in use) 1 Ineffective (not used) REMARKS（Remarks） You can set any character or number in this column.
111
2.3.2 CIA002 (Item department master) Item department master is the table for item departments. Item department is a collection of items in the same group. SIZE
NULL
C
6
□
Item department name
C
24
■
ITEMGRPCODE
Item group code
C
6
■
LAYER
Layer number (not used)
N
1
□
0
UPPERDEPTCODE
Upper department code (not
C
6
□
‘000000’
C
30
■
Column code
Column Name
ITEMDEPTCODE
Item department code
ITEMDEPTNAME
Type
Default value
used) REMARKS
Remarks
ITEMDEPTCODE（Item department code） A six-digit alpha-numeric string which stores item department code. ITEMDEPTNAME（Item department name） A character string storing item department name. ITEMGRPCODE（Item group code） A six-digit numeral string storing item group code. Item group is a collection of item departments. LEYER（Layer number） ・・・Not used. This column does not function right now. A number that indicates the layer of an item department. e.g.) 0: The 1st layer, 1: The 2nd layer, 3: The 3rd layer, ・・・、9: 10th layer UPPERDEPTCODE（Upper item department code） If an item department belongs to a superior department, this column indicates the higher department code. If there is no higher department, “000000” should be stored. REMARKS（Remarks） You can store any character in this column
112
2.3.3 CIA003 (Item group master) This table stores definitions of an item department group which is a collection of item department. Column code
Column Name
Type
SIZE
NULL
ITEMGRPCODE
Item group code
C
6
□
ITEMGRPNAME
Item group name
C
24
■
REMARKS
Remarks
C
30
■
Default value
ITEMGRPCODE (Item group code） An alpha-numeric string storing item group code. ITEMGRPNAME (Item group name) A character string which stores item group name. REMARKS (Remarks) You can store any character in this column.
2.3.4 CSA001 (Item setting group) This table defines and stores parameters of items.
The ratio of numbers of item and item setting group is; Number of item code: 1 item setting group. You can also set one item code in one item setting group. Column code
Column Name
Type
SIZE
NULL
Default value
ITEMPARMCODE
Item setting group code
C
6
□
ITEMPARMNAME
Item setting group name
C
40
■
ITEMTYPE
Item type
C
1
□
0
ITEMCLASSCODE
Item classification code
C
6
□
000000
SELECTIVEITEM1
Selective item 1
C
1
□
0
SELECTIVEITEM2
Selective item 2
C
1
□
0
SELECTIVEITEM3
Selective item 3
C
1
□
0
SELECTIVEITEM4
Selective item 4
C
1
□
0
SELECTIVEITEM5
Selective item 5
C
1
□
0
SELECTIVEITEM6
Selective item 6
C
1
□
0
SELECTIVEITEM7
Selective item 7
C
1
□
0
SELECTIVEITEM8
Selective item 8
C
1
□
0
SELECTIVEITEM9
Selective item 9
C
1
□
0
SELECTIVEITEM10
Selective item 10
C
1
□
0
ORDER1
Order output 1
C
2
□
00
ORDER2
Order output 2
C
2
□
00
ORDER3
Order output 3
C
2
□
00
ORDER4
Order output 4
C
2
□
00
ORDER5
Order output 5
C
2
□
00
113
BONNUMS
Number of meal ticket
N
2
□
0
SINGLEITEMFLG
Single item sales in cash
C
1
□
0
NONPOINTFLG
Non-service point flag
C
1
□
0
HASHITEMFLG
Non-gross sales item flag
C
1
□
0
PRHRFFLG
Non-returnable flag
C
1
□
0
NONSRVCHARGEF
Non-service charge flag
C
1
□
0
OPENPLUFLG
Open price flag
C
1
□
0
REMARKS
Remarks
C
30
■
LG
ITEMPARMCODE（Item setting group code） A six-digit numeral string which stores the item setting group code. ITEMPARMNAME (Item setting group name) A character string storing item setting group name. ITEMTYPE (Item type) One digit numeral column indicating the type of an item. Item type number 0 1 2 3 4
Item type NORMAL ITEM (Standard item) CONDIMENT (Condiments) PREPARATION (Preparation for meal) SHORT PREPARATION (Short preparation for meal) For any message
※0： It is necessary to enter the unit price for NORMAL ITEM (Standard item). For open priced items, it is necessary to set it in the OPENPLUFLG (Open price flag). ITEMCLASSCODE (Item classification code) A six-digit numeral string storing item classification code. You need to set the classification code in CSA002 (Item classification) table. SELECTIVEITEM1～10 (Selective item 1～10) One digit number which select items to be grouped or not. Selective item flag Definition (to be grouped or not) 0 Not grouped 1 Grouping is possible To set several item group, use selective item 2～10. ORDER1～5 (Order output 1～5) A two-digit numeral string which stores the destination printer for order printing. If you wish to output order printings from PRTTYPE (printer type) 21 of table CTN002 (Printer settings), set this column as “01”. In the same way, setting “15” in this column assigns printer type 35 as the print destination. Order output 1-5 Definition 00 Not using the Order print 01 Order1（Output CTN002 Printer type21） 02 Order2（Output CTN002 Printer type22） ： ： 15 Order15（Output CTN002 Printer type35） If it is not set, “00” will be stored. BONNUMS (Number of meal ticket) A string which stores number of meal ticket. SINGLEITEMFLG (Single item sold in cash)
114
One digit number which selects an item to be sold in cash or not. (Single item sold in cash; by one operation, the transaction in cash will be completed. (One receipt for one item) Single item sold in cash Definition flag 0 Not to be sold singly in cash 1 Single item sold in cash NONPOINTFLG (Non-pointing flag) One digit number which define items to add a service point or not. Non-pointing flag 0 1
Definition Add to service point Not added to service point
HASHITEMFLG (Non gross sales flag) One digit number which defines the item to be calculated in the gross sales amount. (An item that is not added to gross amount is so called “hash item”. A hash item is not added to the gross sales amount although it is added to the net sales amount.) Non gross sales flag 0 1
Definition Added to the gross sales amount Not added to the gross sales amount
PRHRFFLG (Non-returnable flag) One digit number which defines an item to permit to be returned or not in the “Return mode” (registration for returned item). Non-returnable flag 0 1
Definition Permits to be returned Prohibits to be returned
NONSRVCHARGEFLG (Non-service charge flag) One digit number which defines an item to be calculated in the service charge or not. Non-service charge flag 0 1
Definition Calculated in service charge Not calculated in service charge
OPENPLUFLG (Open price flag) One digit number which permits an item’s price to be inputted or not. If an item is permitted to enter the unit price, the screen automatically shows pop-up ten-key when the item is registered. Open price flag 0 1
Definition Not permitted to enter the price Permitted to enter the price
REMARKS (Remarks) You can store any character in this column.
115
2.3.5 CIB001 (Set item master) Set items are named in CIB001 (Set item master) and defined the contents in CIB002 (Set item composition master) Set item master defines and stores the names of set items.
Column code SETITEMCODE SETITEMNAME SETITEMNAME2 SETITEMNAME3 SETITEMNAME4 SETTYPE LISTMIN LISTMAX REMARKS
Column Name Set item code Set item name Set item name 2 Set item name 3 Set item name 4 Set type Minimum item quantity Maximum item quantity Remarks
Type
SIZE
NULL
Default value
C C C C C C N
6 24 24 24 24 1 2
□ ■ ■ ■ ■ □ □
0
N
2
□
9
C
30
■
SETITEMCODE (Set item code) A six-digit numeral string for storing set item code. The set item code defined here should also be defined in CIA001 (Item master) and CIB002 (Set item combination master. SETITEMNAME (Set item name) A character string which stores set item name. SETITEMNAME2 (Set item 2 name) A character string which stores set item 2 name. SETITEMNAME3 (Set item 3 name) A character string which stores set item 3 name. SETITEMNAME4 (Set item 4 name) A character string which stores set item 4 name. SETTYPE (Set type) One digit number defining the set type. Set type 0: Registers the sold set item. Set type 1 and 2 are not used. Set type 0 1 2
Definition Registers the sold set item Select one item from the set item (Not used) Select several items from the set item (Not used)
LISTMIN (Minimum item quantity) / Not used. This column defines the minimum number of selected items from the set item in the set type 2. LISTMAX (Maximum item quantity) / Not used. This column defines the maximum number of selected items from the set item in the set type 2. REMARKS (Remarks) You can store any character in this column.
116
2.3.6 CIB002 (Set item composition master) This table defines and stores the contents of set item. Column code SETITEMCODE LISTNUMBER ITEMCODE ITEMCODETYPE UNITPRICECODE REMARKS
Column Name Set item code List number Item code Item code type Unit price code Remarks
Type C C C C C C
SIZE
NULL
6 2 16 1 2 30
□ □ □ □ □ ■
Default value
00
SETITEMCODE (Set item code) A six-digit numeral string which stores set item code. Set item code defined in CIB001 (Set item master) should be set. LISTNUMBER (List number) A two-digit numeral string that stores the set item number. “01”~”99” ITEMCODE (Item code) An alpha-numeric string which stores set item code or item code composed in a set item. In case you set item code, use the same item code defined in CIA001 (Item master). An item code is six-digit numeral string. If you are setting a set item, use a different set item code from the definition in CIB001 (Set item master) Set item code to be set is a six-digit left justified numeral string.
117
ITEMCODETYPE (Item code type) One digit number which defines the code whether it is an item code or set item code. Item code type 0 1
Definition Item code Set item code
UNITPRICECODE (Unit price code) Two digits number which defines unit price to be used or not. Should be set as “00; Not using unit price”. Unit price code Definition 00 Not using unit prices 01 Use unit price 1 (Not used) : : (Not used) 10 Use unit price 10 (Not used) REMARKS (Remarks) You can store any character string in this column.
118
3. Transaction settings The business management system of VX-100 provides various transaction (Function) buttons. Functions of transaction (Function) buttons are set at default but you can change the function as you like.
3.1 Function of transaction (Function) buttons The following table explains the function codes and functions of transaction (Function) buttons.
Function code
Button name
Set character
Function
System Style model
Use this button when the payment is done in cash or when calculating the change. Use this button when the payment is made on credit. Use this button when the payment is made by a voucher. Use this button when the payment is made by a credit card Use this button when an order is held.
･Standard Style ･New Style
･New Style
000001
Payment in cash
Cash
000002
Payment on credit
Charge
000003
Payment by voucher
Check
000004
Payment by credit card
Credit
000006
Holding a check
Hold
000014
Changing table
Table change
000027
Reduction（-）
-
Use this button for changing (adding) to another check. Use this button when reducing price.
000028
Discount（%-）
%-
Use this button when a price is discounted in rate.
･Standard Style ･New Style
000029
Price raising（＋）
+
Use this button when you raise the price.
･Standard Style ･New Style
000030
Premium（％＋）
%+
Use this button when you raise the price at a premium.
･Standard Style ･New Style
Undoing an operation
Void
Use this button when undoing the last operation.
･Standard Style
000034 000038
Issuing a receipt
Receipt
Use this button when issuing a receipt later on or issuing guest receipt. You can enter any number. Touch this button before entering a number. Entered number will be printed on the receipt. Use this button for changing money.
･Standard Style ･New Style
000040
Number entry (#)
＃
000042
Change/NS
Change/NS
･Standard Style ･New Style ･Standard Style ･New Style ･Standard Style ･New Style ･Standard Style ･New Style
･Standard Style ･New Style
･Standard Style ･New Style
･Standard Style ･New Style
119
Use this button for entering number of customers.
･Standard Style
Covers Bill
Issues Japanese receipt.
･New Style
Table
Use this button when assigning a table number.
･Standard Style
Signon
Use this button for signing on.
･Standard Style
Use this button when calculating subtotal (tax inclusive) amount or for indicating on the customer screen. Use this button for multiplication calculation.
･Standard Style
000043
Covers
000047
Bill Copy
000058
Table number /Table#
000073
Clerk /CLK#
000075
Subtotal
Subtotal
000082
X (Multiplication)
X
000091
New check
NEW CHK
Use this button when registering a new check.
･Standard Style ･New Style
000092
Call a check
OLD CHK
Use this button when calling an existing check.
･Standard Style ･New Style
000093
New & Old
000103
OBR
NEW OLD
Use this button for issuing new check or calling already issued check. Use this button for inputting a bar code manually.
･Standard Style
･Standard Style
･Standard Style ･New Style
OBR
000114
Housebon
Housebon
000124
Mode
000148
CUST
000392
OESOLD
001027
ST
ST-
001028
ST (%-)
ST%-
001029
ST(+)
ST+
001030
ST(%+)
ST％＋
MODE CUST OES
Using this button registers zero amount. Use this button for internally consumed items such as meals for staffs. Use this button for changing to Refund, X report, Z report or setting modes. Use this button for entering a customer number. Use this button for calling OES slip. Use this button to reduce amount from a check’s subtotal... Use this button to give a discount in rate on subtotal amount. Use this button to add an amount to the check’s subtotal. Use this button to add a premium in rate to the
･Standard Style ･New Style
･Standard Style
･Standard Style ･New Style ･New Style
･Standard Style
･Standard Style
･Standard Style
･Standard Style
check’s subtotal 001114
ST Housebon
100236
Cancel
100300
120
Back
Cancel
Use this button for registering zero amount for such cases as staff meals. Use this button when cancelling a transaction.
Back
Use this button to go back to the last screen.
ST House
･Standard Style
･Standard Style ･New Style ･Standard Style ･New Style
100301
100302
Payment
Payment
Select Check
Select Check
100303
Signoff
Signoff
100401
00
00
100402
000
000
Use this button to change to “Sales Registration / Payment registration screen”. Use this button to change to “Sales registration / Check operation screen” Use this button when you logout. The screen changes to “Clerk selection screen”.
･New Style
･New Style ･New Style
Enters two zeroes.
･Standard Style ･New Style
Enters three zeroes.
･Standard Style ･New Style
121
【The database structure for transaction (Function) buttons】 The following figure shows the structure of databases relevant to the transaction (Function) buttons.
Function buttons information
CSB002 Function button settings
Manages function codes and button names of buttons.
122
CSB003 Details of Function button settings
Manages the function setting codes and parameters for set values of button.
3.2 Relevant table Tables relevant to the settings for transactions are CSB002 (Function button settings) and CSB003 (Function button parameter settings) The following explains the table settings for transaction (Function) buttons.
3.2.1 CSB002 (Function button settings) This table stores and defines the fundamental information for transaction (Function) buttons. Column code
Column Name
Type
SIZE
NULL
FUNCKEYCODE
Function button code
C
6
□
FUNCKEYNAME
Function button name
C
24
□
FUNCTIONCODE
Function code
C
6
□
REMARKS
Remarks
C
30
■
CREATEDATETIME
Created date and time
C
14
□
UPDATEDATETIME
Updated date and time
C
14
□
Default value
FUNCKEYCODE (Function button code) A six-digit numeral string which stores a Function button code. You can set any Function code number as you like. FUNCKEYNAME (Function button name) An alpha-numeric string which stores names of Function buttons. FUNCTIONCODE (Function code) A six-digit numeral string which stores function codes of Function buttons. Please set the function code listed in “The function of transaction (Function) buttons”. REMARKS (Remarks) You can store any character string in this column.
123
3.2.2 CSB003 (Function button parameter settings) CSB003 stores parameters for Function buttons’ transaction.
Column code
Column Name
FUNCKEYCODE
Function button code
FUNCSETCODE
Type
SIZE
NULL
C
6
□
Function set code
C
80
□
VALUE
Value
C
20
□
REMARKS
Remarks
C
30
■
Default value
FUNCKEYCODE (Function button code) A six-digit numeral string which stores Function button code. Please assign the same code set in CSB002 (Function button settings). FUNCSETCODE (Function set code) An alpha-numeric string storing function setting code. Please refer to “Function button settings” on the next page. VALUE (Value) An alpha-numeric string which stores the set values. REMARKS (Remarks) You can store any character in this column.
【Function button settings】 The following tables explain the definitions and values for each function in CSB003 (Function button parameter settings).
FUNCTION SET CODE
Setting a Function button as , < Charge>, < Check>, or button VALUE
EXPLANATION
VALUE
Input unit price or unit value.
Sets preset value. You can use this function as unit price or unit value preset button.
FIN...TENDER.TYPE
0: Permits the payment 1: Prohibits the payment 2: Limits to be paid in cash 3: Permits to be paid in cash but no partial payment 4: Limits to be paid in cash but no partial payment. Input the amount. No limitation if you set “0”.
Limits any type of payment.
FIN.TENDER.LIMIT
124
Sets the maximum amount of the change.
EXAMPLE Setting <€100> button using . FUNCKEYCODE： 000001 FUNCSETCODE：VALUE VALUE:100 REMARKS：€100 Prohibit tendering. FUNCKEYCODE： 000004 FUNCSETCODE： FIN..TENDER.TYPE VALUE：1 REMARKS：Credit Setting the maximum amount of change to ¥9,000. FUNCKEYCODE： 000003 FUNCSETCODE： FIN.TENDER.LIMIT VALUE：9000
REMARKS：MAX
FIN.TENDER.ROUND
Sets the flag to limit the last Two digits of received amount. 0: No limitation 1: 5 2: 10 3: 50
DRAWER.OPEN
Set the flag which controls The cash drawer. 0: Default (functions in accordance with “Operation settings”. 1: Opens the drawer 2: Does not open the drawer
FUNCTION SET CODE
VALUE
EXPLANATION
Set the flag which controls The cash drawer. 0: Default (functions in accordance with “Operation settings”. 1: Opens the drawer 2: Does not open the drawer
Assigns the cash drawer to be opened or not when corresponding button is touched.
EXAMPLE
Setting a Function button as < %- >, or <% + > button VALUE
VALUE
Input unit price or unit value.
TENKEY.ENTER
Limits the numeral entry from the ten-key. 0: Permits numeral entry 1: Prohibits numeral entry A flag that assigns rounding. 0: Round off 1: Discard, 2: Rounding upwards
ROUNDING
Prohibit opening the drawer when button is touched. FUNCKEYCODE： 000002 FUNCSETCODE： DRAWER.OPEN VALUE:2 REMARKS：Don't Open
Setting a Function button as button
FUNCTION SET CODE DRAWER.OPEN
Limits the last two digits of receiving amount. Set value 1: The last digit must be the unit of ¥5 or ¥0. 2：The last two digits must be the unit of ¥10. 3: The last two digit must be the unit of ¥50 or ¥100. Assigns the cash drawer to be opened or not when corresponding button is touched.
¥9000
EXPLANATION
EXAMPLE
Sets preset value. You can use this function as unit price or unit value preset button.
Setting <10%off> button using <%->. FUNCKEYCODE：000028 FUNCSETCODE：VALUE VALUE:10 REMARKS：10%off You can use this function when you set <10%off> button and you do not want to enter a discount percentage from the ten-key.
Assigns rounding.
125
FUNCTION CODE
Setting a Function button as < - > or < + > button VALE
VALUE
Input unit price or unit value.
TENKEY.ENTER
Limits the numeral entry from the ten-key. 0: Permits numeral entry 1: Prohibits numeral entry
FUNCTION CODE E VALUE
126
EXPLANATION Sets preset value. You can use this function as unit price or unit value preset button.
EXAMPLE Setting <¥100 off> button using < - >. FUNCKEYCODE： 000027 FUNCSETCODE：VALUE VALUE:100 REMARKS：-100yen
Setting a Function button asbutton VALE Clerk code
EXPLANATION Sets preset value of Function button. You can use this as clerk’s sign on button. ※For standard style
EXAMPLE
4. Arrangement of Function button You can place Function buttons anywhere you like on the screen.
4.1 Position and range of Function buttons Function buttons can be placed on the sales registration screen (check registration screen, payment registration screen, and payment completion screen). However, certain Transaction (Function) buttons cannot place on certain screens due to the function of the button. Please arrange Transaction (Function) button on correct screen. The following figures show the positions and ranges of Transaction (Function) buttons on each screen. ＜Check registration screen＞
You can arrange Transaction (Function) buttons in these areas.
127
【Database structure for arranging Transaction (Function) buttons】 The following figure shows the database structure for arranging Transaction (Function) buttons on a screen.
Function button settings
CSB011
Layout setting
Manages the information and attributes of the screen layouts.
Transaction (Function) buttons are displayed on a screen in accordance with the layout information defined in the table CSB011 (Layout settings).
128
4.2 Relevant table The table relevant to Transaction (Function) buttons arrangement is CSB011 (Layout settings) The followings explain the functions of the table.
4.2.1 CSB011 (Layout settings) The table CSB011 stores set values of screen settings.
Column code
Column Name
Type
SIZE
NULL
VIEWID
View ID
PARENTVIEWID
Default value
N
10
□
Parent view ID
N
10
□
CONTROLTYPE
Control type
C
64
□
THEME
Theme
C
16
□
CODE
Code
C
16
□
0
USECOORDINATE
Use coordinate
C
1
□
0
POSITIONX
Position X
N
10
□
0
POSITIONY
Position Y
N
10
□
0
WIDTH
Width
N
10
□
0
HEIGHT
Height
N
10
□
0
LABEL
Label
C
128
■
FOREGROUNDCOL
Foreground
N
10
■
OR
color
BACKGROUNDCOL
Background
N
10
■
OR
color
OPTIONCOLOR
Option color
N
10
■
IMAGEFLAG
Image flag
C
1
□
REMARKS
Remarks
C
30
■
0
0
VIEWID (View ID) A string which stores the layout information at the first place. This column is used for establishing the relationship with the parent view. PARENTVIEWID (Parent view ID) A string storing the parent view ID CONTROLTYPE (Control type) A string which stores the control class name of the source image. THEME (Theme) An alpha-numeric string storing a theme. e.g.) Standard, Exotic, Pop, or User CODE (Code） An alpha-numeric string that stores item code or Transaction (Function) button code. USECOORDINATE (Use coordinate)
129
A flag that defines the usage of coordinate for arranging Function buttons. Coordinate flag 0 1
Definition Coordinate not used Use coordinate
POSITIONX (Position X) This column stores the x-axis number of Transaction (Function) button position. POSITIONY (Position Y) This column stores the y-axis number of Transaction (Function) button position. WIDTH (Width) This column stores the horizontal position on the screen. HEIGHT (Height) This column stores the vertical position on the screen. LABEL (Label) This column stores character string of a label. FOREGROUNDCOLOR (Foreground color) A string that stores foreground color number. e.g.) 0x00FFFFFF BACKGROUNDCOLOR (Background color) A string which stores background color number. e.g.) 0x00FFFFFF OPTIONCOLOR (Option color) A string which stores optional color number. e.g.) 0x00FFFFFF IMAGEFLAG (Image flag) A flag that defines the image’s priority in usage. Image flag Definition 0 Not using any image 1 Priority to the image size 2 Priority to the layout (enlarging the image) 3 Priority to the layout (upper left justification) 4 Priority to the layout (center justification) 5 Priority to the layout (lower right justification) REMARKS (Remarks) Any character can be stored in this column.
130
Setting example of CSB011 (Layout setting) The following screen shows an example of CSB011 (Layout setting) using database settings. Example of setting “Sirloin steak”.
131
CSB011 (Layout setting)
132
5. Print settings This setting is done when you change the printing form of receipt.
5.1 About receipts There are two types of receipt format, 58mm wide and 80mm wide. The following shows the format of a receipt.
133
**************************************** * LOGO MESSAGE 1 *********************** ****************************************
Header: Prints assigned multiple logo messages, graphic logos, or messages.
**************************************** * LOGO MESSAGE 2 *********************** ****************************************
Graphic Logo 1
Body: Prints sold items or table numbers.
Graphic Logo 2
Slip discount part: Prints slip discount amount
REG 01 MORIA July/08/2011(Fri) 11:59 AM CHECK No._1_2_3_4_5_6 12CT
001234 #009999
Number of sold items 1 2 1 1 1
Lemon Tea $1.20 T1 Coffee $2.00 T1 Hamburg $5.00 T1 Tomato spaghetti $5.00 T1 special pizza (standard set) $7.00 T1 DISCOUNT
-5.00
3 No Service $3.20 TA1 $17.20 TX1 $1.72 TL _$_1_8_._9_2 ROUND 0.02 CASH $20.00 CG $1.10 Invoice/No. 123456 **************************************** * BOTTOM MESSAGE 1 ********************* **************************************** **************************************** * BOTTOM MESSAGE 2 ********************* ****************************************
Barcode
134
Tax part: Prints tax amounts.
Total part: Prints total amount.
Rounding part: Prints rounded amount Tendered amount and change part: Prints tendered amount and change. Invoice No.: Prints an invoice number.
Footer: Prints assigned multiple logo messages, graphic logos, or messages.
5.1.1 Header Header composes the following information. Name
Contents
Logo message
Mode
Multiple messages such as logo messages and advertising messages. Graphic logo. It is necessary for the logos to discriminate the usage such as for receipt logo or address on the receipt. Mode information
Terminal name
Terminal name, terminal number
Clerk name
Clerk name who operated
Date
Operated date
Time
Operated time
Consecutive number
Consecutive number or invoice number. Assigned number defined as COUNTER NUMBER 01 (Consecutive number) or 03 (Check number) in CSM007 (Numbering counter) table. Check number and title
Graphic logo
Check number Number of customers Table number
Number of customers and footer
Order number
Order number only on an guest receipt
Table number and a title
|************ logo message 1 ************| <･･Logo message 1
Value
Assigns a character string including line feeding. Assigns graphic logo. Graphic image data Assigns mode’s character string. Assigns the character string of terminal name. Assigns the character string of the clerk. Assigns long type numeral of date class. Assigns long type numeral of date class. Assigns the character string of consecutive number or invoice number.
Assigns the character string of check number. Assigns the number of customers and character string. Assigns the character string of table number. Assigns the character string of order number.
(Guest receipt / receipt / order)
|****************************************| |************ logo message 2 ************| <･･Logo message 2
(Guest receipt / receipt / order)
|****************************************| |
Graphic logo 1
| <･･Graphic logo 1
|
|
|
|
|
Graphic logo 2
| <･･Graphic logo 2
|
|
|
|
|REG
01
MORIA
|Mon, 31/10/2011 |CHECK No._1_2_3_4_5_6
| <･･Mode, Terminal name, Clerk name
11:59AM 12CT
001234| <･･Date, Time, Consecutive number #000013| <･･Check number, Number of customers, Table number
| _O_R_D_E_R_# _0_0_1_2_3_4 | <･･Order number | _*_*_*_*_* _T_R_A_I_N_I_N_G _*_*_*_*_* | <･･Training message
135
【Example receipt giving weight to the check number (like in USA)】 |REG
01
Edwards
|July/08/2011(Fri)
|
11:59AM
|CHECK No._1_2_3_4_5_6
12CT
001234 | #000013 |
Registration mode, Terminal name, Clerk name Date, Time, Consecutive number Check #, Number of customers, Table #
【Example receipt in Japanese】 |登録 01
田中太郎
|
|2011 年 07 月 08 日(金) 11:59
001234 |
|伝票番号_1_2_3_4_5_6
12 名 #000013 |
Registration mode, Terminal name, Clerk name Date, Time, Consecutive number Check #, Number of customers, Table #
【Example receipt giving weight to the table number (like in Europe countries)】 |REG
01
Cowell
|07-02-2001
11:59
|TABLE _1_3
12CT
| 001234 | #123456 |
Registration mode, Terminal name, Clerk name Date, Time, Consecutive number Table #, Number of customers, Check #
5.1.2 Body Body is composed of the following information. Name
Contents
Value
Seat line
Seat number and title
Assign seat number value.
Multiplication line
Multiplier and footer.
Assign multiplier and unit
Unit price and @ mark.
price.
Status information
Assign character strings of
Status line
status name, and center dot symbol... Items line (Parent
Registered quantity
Assign quantity
Item,
Item name
Assign item name string
Amount.
Assign amount
Second
level item / third level
Add mode, currency symbol, thousand
item)
separator, are defined separately by orXML. Tax symbol
Assign character string of tax symbol
Item number line
Item number and title
Assign item number value.
Separator line
Separator symbol
Assign separator symbol character string.
136
Rate line
Rate
Assign rate value.
Transaction line
Button character name, transaction
Assign transaction name
name, and amount.
and
amount
character
Add mode, currency symbol, thousand
strings.
separator, and decimal point symbols are defined separately by orXML. Tax symbol Assign
tax
symbol
character string. Order
character
Order character
Order character string
line 0123456789012345678901234567890123456789 | SEAT# 1 |
HOUSE BON
|
Seat line
**************
|
Status line (* are center dots)
@1.00
|
Multiplication line
|
2X
|
2 PLU0001
$1.00 T1 |
|
#123456
|
| |
1 Cake 1
Chocolate
Item line (Parent item) Item number line
$2.00 T1 |
Item line (second level item)
$2.00 T1 |
Item line (third level item)
|----------------------------------------|
Separator line
|
7.5%
Rate line
|
%-
|
| -1.00 T1 |
_*_*_S_o_f_t_ D_r_i_n_k_s_*_*_*
|
Transaction line Order character line
137
5.1.3 Slip discount part Slip discount part consists of the following information. Name
Contents
Value
Rate line
Rate value and symbol
Rate vale
Transaction
Transaction name
Assign transaction
Amount
name
Add mode, currency symbol, thousand
and amount character
separator, and decimal point symbol
strings.
are defined separately by orXML. Tax symbol Assign tax symbol character string.
0123456789012345678901234567890123456789
138
|
7.5%
|
%-
| -1.00 T1 |
Rate line Function line
5.1.4
Number of sold items
Number of sold items part consists of the following information.
Name
Contents
Value
Sold item quantity
Sold item quantity and title
Assign
line
sold
item
quantity.
0123456789012345678901234567890123456789 |
3 No
|
Sold item quantity line
5.1.5 Tax part The tax part consists of the following information. Name Service
charge
Contents
Value
Service charge title and amount
Assign service charge
line
value.
Tax print line
Multiple tax information
Assign tax value.
0123456789012345678901234567890123456789 |
Service
$3.20
|
Service charge title, Amount of service charge
|
TA1
$3.20
|
Type of tax, taxable amount
|
TX1
$0.32
|
Type of tax, amount of tax
5.1.6 Total part Total part consists of following information.
Name
Contents
Value
Total line
Total amount and title
Assign total amount.
0123456789012345678901234567890123456789 |
SRVC TL
_$_2_3_._0_0
|
Total line
139
5.1.7
Rounding part
Rounding part consists of the following information.
Name
Contents
Value
Rounding line
Rounded amount and title
Assign rounded amount value.
0123456789012345678901234567890123456789 |
ROUND
0.02
|
Rounding line
5.1.8 Tendered amount / change part The final portion of tendered amount and change part consists of the following information.
Name
Contents
Value
Tendered
Type of payment
amount/Change line Change line
Change and title
Assign change amount.
0123456789012345678901234567890123456789 |
CASH
$5.00
|
Type of payment, Tendered amount
|
CG
$1.20
|
Title, Amount of change
5.1.9 Invoice number part Invoice number part consists of following information.
Name
Contents
Value
Invoice No. line
Invoice number and title
Assign invoice number value.
0123456789012345678901234567890123456789 |
140
Invoice/No.
123456
|
Invoice number line
5.1.10 Footer Footer consists of the following information.
Name
Contents
Value
Bottom message
Multiple messages such as logo message
Assign a character string
and advertising message.
containing line feeding.
Bar code image
Assign bar code data.
Bar code
0123456789012345678901234567890123456789 |*********** bottom message 1 ***********| |****************************************| |*********** bottom message 2 ***********| |****************************************| Bar Code | | |
|
|
|
Bottom message 1 (Guest receipt / Receipt / Order) Bottom message 2 (Guest receipt / Receipt / Order) Bar code
Bar code printing Built-in printer is able to print JAN/EAN13 bar codes. UPC-A/UPC-E/JAN8/EAN8/JAN13/EAN13/ITF/Codabar/Code39/Code93 bar codes will be printed on external printers.
The following table shows the contents of the bar code. Bar code print data Name
Contents
Value
Bar code value
Assigns 13 digits of JAN/ENA code
Assign13 digits code.
including C/D. Bar code size
Assigns the size of bar code.
Assign the bar code size value.
141
5.2
Hold receipt Hold receipt is issued when button is touched or touching button during a registration. A held receipt consists of the following parts.
142
Header Body Slip discount part Sold quantity part Tax part Total part Footer
|0123456789012345678901234567890123456789| |****************************************| |Grafic logo 1***************************| |****************************************| |****************************************| | ｜ |****************************************| |Graphic logo 2**************************| |****************************************| |****************************************| | ｜ |****************************************| |Order receipt top message 1*************| |****************************************| |****************************************| | ｜ |****************************************| |Order receipt top message 2*************| |****************************************| |****************************************| | ｜ | REG 01 MORIA | |July/08/2011(Fri) 11:59AM 001234| |CHECK No._1_2_3_4_5_6 12CT #000013| | ｜ | _*_*_*_*_* _T_R_A_I_N_I_N_G _*_*_*_*_* | | ｜ | SEAT# 1 | | HOUSE BON ･･････････････ | | 2X @1.00 | | 2 PLU0001 $1.00 T1 | | #123456 | | 1 Cake ･2.00 T1 | | 1 Cake ･2.00 T1 | |----------------------------------------| | 4 Drink ･5.00 T1 | | | | 1 Lemon Tea ･1.00 T1 | | 7.5% | | %-1.50 T1 | | 1 Lemon Tea ･1.00 T1 | | | | 7.5% | | %-1.50 T1 | | 4 No | | TA1 ･20.00 | | TX1 ･2.00 | | SRVC TL _$_5_._0_0 | | ｜ |****************************************| |Order bottom message 1******************| |****************************************| |****************************************| | ｜ |****************************************| |Order bottom message 2******************| |****************************************| |****************************************| | ｜ |========================================| |Bar code ===============================| |========================================| |========================================| |========================================|
Header
Body
Slip discount part
Sold quantity part
Tax part Total part
Footer
143
5.3
Guest receipt Guest receipt Guest receipt informs the customers’ orders to the kitchen.
|0123456789012345678901234567890123456789| |****************************************| |Graphic logo 1**************************| |****************************************| |****************************************| | ｜ |****************************************| |Grakoguc logo 2*************************| |****************************************| |****************************************| | ｜ |****************************************| |*****Order top message 1****************| |****************************************| |****************************************| | ｜ |****************************************| |*****Order top message 2 ***************| |****************************************| |****************************************| | ｜ |REG 01 MORIA | |July/08/2011(Fri) 11:59AM 001234| |CHECK No._1_2_3_4_5_6 12CT #000013| | ｜ | _*_*_S_o_f_t_ _D_r_i_n_k_s_*_*_* | | ｜ | SEAT# 1 | | HOUSE BON ･･････････････ | | 2X @1.00 | | 2 PLU0001 $1.00 T1 | | #123456 | | 1 Cake ･2.00 T1 | | 1 Cake ･2.00 T1 | |----------------------------------------| | ｜ |****************************************| |***Order bottom message 1***************| |****************************************| |****************************************| | ｜ |****************************************| |***Order bottom message 2***************| |****************************************| |****************************************| | ｜
144
Header
Body
Footer
5.4
Setting a message On a receipt, a message can be printed and a user can set or change the message. The followings explain the way to change messages.
【Database structure for message print】 The following figure shows the database structure for message print.
Receipt print
CSB007
Character settings
Stores symbols and characters printed on receipts.
The followings are the contents of the table CSB007 (Character setting).
145
5.4.1 CSB007 (Character setting) The table stores set value for printing layout on a receipt.
Column code
Column Name
CHARSETCODE
Character set code
CHARDATA REMARKS
Type
SIZE
NULL
C
80
□
Character data
C
512
■
Remarks
C
30
■
Default value
CHARSETCODE (Character set code) A character string which stores character set codes. The followings are the utilities of character set codes.
Character set code CHARSETCODE MESSAGE.ORDER.TOP1.L
Guest receipt top message 1 for 80 mm width form.
MESSAGE.ORDER.TOP1.S
Guest receipt top message 1 for 58 mm width form.
MESSAGE.ORDER.TOP2.L
Guest receipt top message 2 for 80 mm width form.
MESSAGE.ORDER.TOP2.S
Guest receipt top message 1 for 58 mm width form.
MESSAGE.ORDER.BOTTOM1.L
Guest receipt bottom message 1 for 80 mm width form.
MESSAGE.ORDER.BOTTOM1.S
Guest receipt bottom message 1 for 58 mm width form.
MESSAGE.ORDER.BOTTOM2.L
Guest receipt bottom message 2 for 80 mm width form.
MESSAGE.ORDER.BOTTOM2.S
Guest receipt bottom message 2 for 58 mm width form.
MESSAGE.ORDER.TOP1.L
Order top message 1 for 80 mm width form
MESSAGE.ORDER.TOP1.S
Order top message 1 for 58 mm width form
MESSAGE.ORDER.TOP2.L
Order top message 2 for 80 mm width form
MESSAGE.ORDER.TOP2.S
Order top message 2 for 58 mm width form
MESSAGE.ORDER.BOTTOM1.L
Order bottom message 1 for 80 mm width form
MESSAGE.ORDER.BOTTOM1.S
Order bottom message 1 for 58 mm width form
MESSAGE.ORDER.BOTTOM2.L
Order bottom message 2 for 80 mm width form
MESSAGE.ORDER.BOTTOM2.S
Order bottom message 2 for 58 mm width form
MESSAGE.MODE.TRAINING.L
Training message for 80 mm width form.
MESSAGE.MODE.TRAINING.S
Training message for 58 mm width form.
AMT.SYMBOL.CURRENCY.PLUS
Currency symbol (plus) when locale feature is not used. *1
AMT.SYMBOL.CURRENCY.MINUS
Currency symbol (minus) when locale feature is not used *1 Amount ADD character when locale feature is not used. *1
AMT.SYMBOL.ADD.MINUS
GENERAL.SYMBOL.DECIMALPOINT
Thousand separator symbol for amount when locale feature is not used *1. Decimal point symbol
GENERAL.MODE.REG
Registration mode symbol
GENERAL.MODE.RF
Refund mode symbol
AMT.SYMBOL.SEPARATER
146
Use
GENERAL.MODE.REGMINUS
Delete mode symbol
GENERAL.CHARACTER.CHANGE
Change
GENERAL.CHARACTER.TOTAL
Total
GENERAL.CHARACTER.CHECKNO
Check number
GENERAL.CHARACTER.COVERS
Number of customers
GENERAL.CHARACTER.ITEMCT
Number of registered items
GENERAL.STATUS.HOUSEBON
House bon status character for printing and displaying
GENERAL.STATUS.SEATNO
Seat number character for printing and displaying
GENERAL.CHARACTER.SERVICE_CHG
Service charge character
GENERAL.CHARACTER.REMAIN_ST
Indicates the remaining amount while paying partially.
GENERAL.CHARACTER.HOLD
Character for held check (for display)
・ ・ ・ ・
Any number of line feed can be assigned on each message. *1 About currency symbol; In normal use, currency symbol is automatically formatted by using the locale feature in Android system. 80 mm width form prints 80 single byte characters in one line for built-in or external printers using 80 mm width paper. 58 mm width form prints 31 single byte characters in one line for built-in printer using 58 mm width paper.
REMARKS (Remarks) You can set any character in this column.
147
5.5
About XML formatting of receipt printing Printing data of receipt is formatted as XML documents. Printings explained in clauses 5.1 to 5.3 are defined as XML documents and stored in the database. The followings explain the table CSM012 (Print form master) which stores XML print form data.
5.5.1 CSM012 (Print form master) Column code
Column Name
Type
SIZE
NULL
PRTFORMCODE
Print form code
C
80
□
PRTFORMNAME
Print form name
C
40
■
PRTFORMDATA
Print form data
B
■
DEFAULTFORM
Default print form
B
■
REMARKS
Remarks
C
30
■
CREATEDATETIME
Created date
C
14
□
UPDATEDATETIME
Updated date
C
14
□
Default value
PRTFORMCODE（Print form code） Character string which stores print form codes.
Print form code RCT_GENERAL_80
Purpose For 80 mm width general receipt
RCT_GENERAL_58
For 58 mm width general receipt
RCT_HOLD_80
For 80 mm width held receipt
RCT_HOLD_58
For 58mm width held receipt
ORD_GENERAL_80
For 80 mm guest receipt
ORD_GENERAL_58
For 58 mm guest receipt
PRTFORMNAME（Print form name） Character string which stores a print form name. PRTFORMDATA (Print form data) Strings for defining print form data (XML).
148
【XML tag definition】
Name
Tag
Forming type
80 mm width guest receipt logo message 1
order_receipt_logo1_long
character
58 mm width guest receipt logo message 2
order_receipt_logo1_short
character
80 mm width guest receipt logo message 2
order_receipt_logo2_long
character
58 mm width guest receipt logo message 2
order_receipt_logo2_short
character
80 mm width order logo message1
order_logo1_long
character
58 mm width order logo message1
order_logo1_short
character
80 mm width order logo message2
order_logo2_long
character
58 mm width order logo message2
order_logo2_short
character
80 mm receipt logo message 1
order_receipt_logo1_long
character
58 mm receipt logo message 1
order_receipt_logo1_short
character
80 mm receipt logo message 2
order_receipt_logo2_long
character
58 mm receipt logo message 2
order_receipt_logo2_short
character
Graphic logo 1
graphic_logo1
graphic
Graphic logo 2
graphic_logo2
graphic
DEFAULTFORM (Default print form data) A character string which stores default data of XML print form data. REMARKS（Remarks） Any character string can be stored.
149
5.6
About logo image Logo images printed on receipts should be prepared by the following procedures.
1) Create a logo image
Prepare a logo image. Format: bitmap bitmap size: 576 x 168 dots(for 58mm,80mm) availability size: 576 x 168 dots for 80 mm width :384 x 168 dots for 58 mm width (left justify) ※The 192 dots of right side of a logo for 58 mm width format should be filled in white.
2) Set the logo image in the database
Refer to 3.2.1 CSB008 (Graphic setting) in section 4.
3) Set logo data in the built-in printer
Store the logo data in built-in printer’s ROM. Refer to “5.5 Setting logo image data in built—in printer” in section 4.
4) XML tag definition
150
Set CSM012 (Print form master) ‘s XML tag definition as graphic logo 1.
6. General feature The fundamental settings define the tax rates, rounding, and business dates.
【Database structure of
General feature】
The following figure shows the database structure for managing fundamental settings.
General feature
CSB001
General feature
Manages and stores fundamental settings data
151
6.1 Relevant table The table relevant to the fundamental settings is CSB001 (General feature) table. The followings explain the contents of the table.
6.6.1
CSB001 (Operation setting)
Column code
Column Name
Type
SIZE
NULL
OPSETCODE
Fundamental setting code
C
80
□
TITLE
Set title
C
40
□
VALUE
Set value
C
20
□
DEFAULTSET
Default value for setting
C
20
□
EXPLANATION
Explanation of setting
C
120
■
REMARKS
Remarks
C
30
■
OPSETCODE (Fundamental setting code) A character string that stores fundamental setting code. Please refer to the next clause “6.2 Fundamental setting codes”. TITLE (Set title) A character string which stores a title of a settings. VALUE (Set value) A character string storing a value of settings. DEFAULTSET (Default value for settings) A character string storing the default value for the settings. EXPLANATION (Explanation of settings) A character string which stores the explanation of set values. REMARKS (Remarks) You can set any characters in this column.
152
Default value
6.2
General feature codes It is necessary to set fundamental setting codes to operate the Business Support System VX-100. Fundamental settings are categorized as follows.
【Categories of fundamental settings】 1.Areal settings These settings manage the regulations and restrictions in accordance with the area where the terminal is used.
Key code AREA.TAX.SYSTEM
Tax System
Title
Default value 0
AREA.TAX.ROUNDING
Country Rounding
0
AREA.TAX.BAKEDGOODQTY
Baked Goods Tax Exempt Q’ty
6
AREA.TAX.PREPAREDMAL
Prepared Limit
400
Maximum
Amount
Set value Tax system per country 0:Standard, 1:US FS, 2:Canada, 3:Singapore Rounding system per country 0:No rounding 1: IF1 2: IF2 3: Australia 4: Danish 5: Finland 6: Malaysia 7: New Zealand (A) 8: New Zealand (B) 9: Sweedish 10:South Africa 11: Japanese 5yen rounding 12: Japanese 10yenrounding Canada Baked Good Quantity （0～9） Canada Prepared TAX MALAmount
153
1-1 Rounding system per country Country IF 1 rounding
Calculation method Last 1 digit of
Result
subtotal.
New Zealander (A) rounding
Calculation method Last 1 digit of
Result
subtotal/cash change.
0~2
0
0~4
0
3~7
5
5~9
10
8~9
10
IF 2
Last 1 digit of
rounding
subtotal. 0~4 5~9
154
Country
Result
0 10
New
Last 1 digit of
Zealander
subtotal/cash change.
(B) rounding
Australian
Last 1 digit of
rounding
subtotal/cash
Swedish
change.
rounding
Result
Result
0~5
0
6~9
10
Norwegian/
Result Last 2 digit of subtotal.
0~2
0
00 ~ 24
0
3~7
5
25 ~ 74
50
8~9
10
75 ~ 99
100
Danish
Last 1 digit of
rounding
subtotal/cash
African
change.
rounding
Result
South
Last 1 digit of
Result
subtotal.
00 ~ 24
0
0~4
0
25 ~ 74
50
5~9
5
75 ~ 99
100
Finnish
Last 1 digit of
rounding
subtotal/cash
5yen
change.
rounding
Result
Japanese
Last 1 digit of
Result
subtotal.
0~2
0
0~4
0
3~7
5
5~9
5
8~9
10
Malaysian
Last 1 digit of
rounding
subtotal/cash
10yen
change.
rounding
Result
0~2
0
3~7
5
8~9
10
Japanese
Last 1 digit of
Result
subtotal. 0~9
0
2.Setting for open, close and business hours This setting manages the date changing time for 24-hour operated stores. Key code BIZ.DATE.STARTTIME
Title Today start time
Default value 0000
Set value Date changing time （0000～2359）
3.Settings for sales registration These settings manage the rounding in calculations and printing orders on the receipt. Key code SALES.REG.RATE.ROUND0
Title Rounding
for
Default value rate
0
calculation
SALES.RECEIPT.OFF
No receipt print
0
SALES.REG.SERVICECHG.R
Service change rate
0
ATE
Set value Determines the rounding in rate calculations. 0: Round off 1: Round down 2: Round up Receipt printing 0: Yes，1:No Service charge rate (2-digit integer and 2-digit decimal)
0
Receipt or Official receipt 0: Receipt 1: Official receipt
Roundings print
0
Quantity extension
0
Rounding print method (hidden setting) 0: New method 1: Old method Numeral entry at touch PLU registration. 0: Unit price 1: Quantity (Quantity extension) ※For standard style.
SALES.REG.JPRYOUSHUU.
Receipt/
Official
receipt
SYO
selection (Japanese model only)
SALES.COUNTRYROUNDIN G.TYPE SALES.REG.QTYEXTENSIO N
155
4.Settings for the Z report for the total sales This setting determines the usage of the Z report for the total sales. Key code REPORT.Z.USERSD
Title
Default value
Z Use SD
0
Set value Usage of SD card in Reset Sales 0: SD card will be used 1: SD card will not be used
5．Screen style setting (UI) These settings determine the selection methods on the screen. Key code
Title
Default value
APP.USER.STYLE
Login screen style
0
APP.CHECK.STYLE
Check screen style
0
APP.CHECK.SIZE
Check screen button size
0
APP.CHECK.TIME
Check screen time type
0
APP.REG.STYLE
Register Style
0
Set value Sign on screen style 0: By a button 1: By entering number 2: By iButton Check selection screen style 0: By table number 1: By check number 2: No selection (Call Sales registration screen) 0: Normal size 1: Half size 0: Elapsed time from Held Check 1: Elapsed time from check operation Select Register Style 0:New Style 1:Standard Style
6．Money declaration setting The setting manages money declaration. Key code INDRAWER.ENTSTYLE
156
Title Enter amount style
Default value 0
Set value Input mode of quantity of currency and amount 0: Add 1: Overwriting
7 Set data transmission This feature transmits the set data of a VX-100 to another VX-100 on the network.
This feature enables to share the set data among network connected VX-100s.
Check
After sending set data, please restart the receiving VX-100. Refer to “6. Restart” in Section４．
157
158
SECTION 4 System Maintenance
SECTION 4 SYSTEM MAINTENANCE This section explains the maintenances of the system of VX-100. System maintenance executes VX-100’s hardware definition, reloading database backup, and various settings for the sales management. System maintenance
160
1
Android settings
2
VX-100 settings
3
Database settings tool
4
Database Management tool
5
Control panel
6
Restart
7
Operation log
1. Android settings The Android settings are done by calling standard screen of Android platform. Settings should be done in accordance with the usage and installment environments. 【Fundamental setting items】
Network
Sound
Screen
Language and input
Date and time
161
2. VX-100 settings It is necessary to set the operational environments of VX-100 when it is newly installed or new devices are added.
2.1 Flowchart for setting VX-100
162
2.2 Device setting tables 2.2.1 CTN003 (Local device settings) The table stores the definition of devices connected to VX-100 directly.
Column code
Column Name
Type
SIZE
NULL
LDEVID
Local device ID
C
2
□
LDEVNAME
Local device name
C
40
■
LDEVTYPE
Device type
C
2
□
LDEVMODEL
Device model
C
2
□
CONNECTTYPE
Connection type
C
1
□
COMPORT
COM port number
C
1
□
IPADDR
IP address
C
40
□
LDEVPROP
Local device property
C
20
□
REMARKS
Remarks
C
30
■
Default value
LDEVID (Local device ID) A two-digit numeral string which defines the local device ID. If “08 (Printer)” is defined in the LDEVTYPE (Device type) column, define LDEVID (Local device ID) as follows. Local device ID 00 01 : 03 11 : 25 30 40
Definition Built-in printer COM connected printer 1 : COM connected printer 3 LAN connected printer 1 : LAN connected printer 15 Scanner OES
A character string which defines a name of local device. LDEVTYPE (Device type) A two-digit numeral string which defines device types. Device type 01 02 03 04 05 06 07 08
Definition Liquidation terminal Scanner Service point terminal Customer display Coin dispenser Electronic scale Liquor dispenser Printer
LDEVMODEL (Device model) A two-digit numeral string which defines models of devices.
163
Device type 01 (Liquidation terminal)
02 (Scanner) 03 (Service point terminal)
04 (Customer display) 05 (Coin dispenser)
Model type 01 02 03 01 01 02 01 01 02 01 01 01 03
06 (Electronic scale) 07 (Liquor dispenser) 08 (Printer)
Definition KT-10 INFOX terminal PASMO terminal HHS-17 or HHS-18 only General service point terminal Service point terminal with cash back function BT-6060D Glory RT-10B-C Fuji electric ECS-07
UP-370 UP-400
CONNECTTYPE (Connect type) One digit number defining connection types. Connection type 0 1 2 3
Definition Built in COM connection USB connection LAN connection
COMPOPT (COM port number) One digit number which defines the COM port number. If not defied, “0” will be defined. IPADDR (IP address) A 15-digit character string defining IP address of LAN connected printer. If undefined, “0.0.0.0” will be stored. LDEVPROP (Local device property) A character string which defines the property of a local device. The definition of each digit in the string is as follows. 1st digit (The head of the string); This digit defines the portrait’s setting type. Portrait type code Definition 0 2400 1 4800 2 9600 3 19200 4 38400 5 115000 2nd digit; Defines the bit length. Bit length code 0 1
Definition 7 bits 8 bits
3rd digit; Defines the parity type. Parity type code 0 1 2
Definition None Odd Even
4th digit; Defines the type of stop bit.
164
Type of stop bit code 0 1 2
Definition 1 bit 1.5 bits 2 bits
5th digit; Stores the definition of flow control. Flow control type code Definition 0 None 1 X control(X on/Xoff) 2 S control (RS/CS)
6th digit ～ 14th digit The preliminary bits for storing properties. One “0” is stored.
15th digit ～ 16th digit Two-digit number which defines the international character for the printer. International character code Definition 00 English (USA) 01 French 02 German 03 England (UK) 04 Danish 05 Swedish 06 Italian 07 Spanish 08 Japanese 09 Norwegian 10 Danish 2 11 Spanish 2 12 Latin American 13 Korean 17th digit ～ 20th digit; Four-digit number which defines printers’ page number. Page number Definition 0000 PC437(USA: Standard Europe) 0001 Katakana (Japanese character) 0002 PC850 (Multilingual) 0003 PC860 (Portuguese) 0004 PC863 (Canadian-French) 0005 PC865 (Nordic) 0017 CP866(Cyrillic) 0018 PC852 (Latin2) 0019 PC858 (Euro) 0024 Win1253( Greek) 0029 CP737 (Greek) 0032 CP862 (Hebrew) 0046 WPC1257 (Baltic) 0047 771(Baltic for DOS) 0050 Arabic 0255 User definition REMARKS (Remarks) You can store any character here.
165
2.2.2 CTN002 (Printer settings) The table stores the information of printers connected to the VX-100 by COM connection. Column code
Column Name
Type
SIZE
NULL
Default value
PRTTYPE
Printer type
C
2
□
00
TERMINALNUMBER
Terminal number
C
2
□
00
LDEVID
Printer ID
C
2
□
00
BKUPTERMINALNUMBER
Backup terminal number
C
2
□
00
BKUPLDEVID
Backup printer ID
C
2
□
00
REMARKS
Remarks
C
30
■
PRTTYPE (Printer type) A two-digit numeral string which defines the type of printer. Printer type 00 10 21 : 35
Definition Receipt Report Order 1 : Order 15
ERMINALNUMBER（Terminal number） This column defines the terminal number in which LDEVID exists. Setting “00” defines the terminal itself. LDEVID (Printer ID) A two-digit numeral string which defines the printer ID. Should be corresponded with DEVIC (Local device) column in the table CTN003 (Local device settings). ID of local connected device 00 01 : 03 11 : 25
Definition Built-in printer COM connected printer 1 : COM connected printer3 LAN connected printer 1 : LAN connected printer 15
BKUPTERMINALNUMBER（Backup terminal number） This column defines the terminal number in which BKUPLDEVID exists. Setting “00” defines the terminal itself. BKUPLDEVID (Backup printer ID) A two-digit numeral string which defines the backup printer ID. If undefined, “00” will be set. Should be corresponded with LDEVID (Local device ID) column in the table CTN003 (Local device settings). REMARKS (Remarks)
166
You can set any character in this column.
2.2.3
CTN004 (Network device settings) The table defines the information of network devices connected to the VX-100. ※ Printers are excluded.
Column code
Column Name
Type
SIZE
NULL
NDEVID
Network device ID
C
2
□
NDEVNAME
Network device name
C
40
■
NDEVTYPE
Network device type
C
2
□
TERMINALNUMBER
Terminal number
C
2
□
IPADDR
IP address
C
40
□
NDEVPROP
Property
C
20
□
REMARKS
Remarks
C
30
■
Default value
00
NDEVID (Network device ID) Two-digit number which defines the network device ID. NDEVNAME (Network device name) A character string which defines the network device name. NDEVTYPE (Network device type) Two-digit number which defines types of network device. Network
device
Definition
code 01
Cash register (sales management) application
02
Not used
03
Not used
04
Not used
05
Not used
06
Not used
07
Not used
TERMINALNUMBER (Terminal number) Defines the terminal number which is used in the sales management application. (01～99) Other than the sales management application, “00 (not used)” will be stored. IPaddr (IP address) A numeral string which defines the IP address including three periods. If this column is not defied, fixed 12-digit formatted numeral string “0.0.0” will be stored.
167
NDEVPROP (Property) A character storing which defines a property. The first digit of the property indicates the role of check tracking. 1st digit：Check tracking m/s. 1：Check tracking master 0：Check tracking satellite REMARKS (Remarks) You can store any characters in here.
168
3. Database setting tool Database setting tool sets sales management system’s database definition values directly in the tables. Initial password for database setting tool: VEsTreg To change the password, log in by “VEsTadm”.
The followings explain the details of the tables for setting the sales management system.
3.1 Item setting table 3.1.1CSA002 (Item classification table) This table stores data for classifying items.
Column code
Column Name
Type
SIZE
NULL
ITEMCLASSCODE
Item classification code
C
6
□
ITEMCLASSNAME
Item classification name
C
40
■
REMARKS
Remarks
C
30
■
Default value
ITEMCLASSCODE (Item classification code) A six-digit numeral string which defines the item classification code. ITEMCLASSNAME (Item classification name) A character string which stores the item classification name. REMARKS (Remarks) You can store any character here.
3.1.2 CSA003 (Selective item classification) This table stores selective item classifications.
Column code
Column Name
Type
SIZE
NULL
S SELECTIVEITEM
Selective item classification
C
2
□
E SELECTIVEITEMNAM
Selective
C
40
■
C
30
■
E
L
name
REMARKS
E
Remarks
item
classification
Default value
C TIVEITEM (Selective item classification) Two-digit number defining the selective item classification (01 ～ 10 fixed).
169
SELECTIVEITEMNAME (Selective item classification name) A character string which defines a selective item classification name. REMARKS (Remarks) You can store any characters here.
3.1.3 CSA004 (Item discount settings) CSA004 table stores discount amount, discount rate, and Mix & Match (combined items) discount etc. Column code
Type
SIZE
NULL
MMCODE
Mix & Match code
C
6
□
MMNAME
Mix & Match name
C
24
■
DISCOUNTTYPE
Discount type
C
1
□
DISCOUNTAMT
Discount amount
N
13
□
DISCOUNTRATE
Discount rate
N
6
□
QTY
Necessary quantity for Mix & Match
N
10
□
CONDITION
Repeat control
C
1
□
TAXCODE_1
Tax code_1
C
2
□
TAXCODE_2
Tax code_2
C
2
■
TAXCODE_3
Tax code_3
C
2
■
TAXCODE_4
Tax code_4
C
2
■
TAXCODE_5
Tax code_5
C
2
■
TAXCODE2_1
Tax code_2-1
C
2
■
TAXCODE2_2
Tax code_2-2
C
2
■
TAXCODE2_3 M
Tax code_2-3
C
2
■
TAXCODE2_4 M
Tax code_2-4
C
2
■
TAXCODE2_5 C
Tax code_2-5
C
2
■
TAXCODE10_1 D
Tax code_10-1
C
2
■
E TAXCODE10_2
Tax code_10-2
C
2
■
TAXCODE10_3
Tax code_10-3
C
2
■
( TAXCODE10_4
Tax code_10-4
C
2
■
M TAXCODE10_5
Tax code_10-5
C
2
■
i SERVCHARGETYPE
Service charge type
C
1
□
x POINTABLETYPE
Service point type
C
1
□
REMARKS
Remarks
C
30
■
:
O
&
170
Column Name
Default value
Match code) A six-digit numeral string which defines Mix & Match code. MMNAME (Mix & Match name) A character string which defines Mix & Match name. DISCOUNTTYPE (Discount type) One digit number which defines the type of discount. Discount type code
Definition
0
Discount in amount
1
Discount at a rate
2
Free item
DISCOUNTAMT (Discount amount) A numeral string storing a discount amount. DISCOUNTRATE (Discount rate) A numeral string which stores a discount rate. QTY (Quantity) A character string which defines the minimum quantity of Mix & Match discount. CONDITIONTYPE (Repeat control) One digit number which determines the discount method. Repeat code
Definition
0
Repeatable
1
Only once
2
In a unit
Repeatable: Each item exceeding a certain quantity will be discounted in a certain amount. e.g.) ¥100 discount for five and ¥200 for six, ¥300 for seven items…so on. Only once: Without regard to the quantity, discount amount would be the same. e.g.) ¥100 discount for five but even for ten items, discount price would be ¥100. In a unit: Discount price increases in a unit of the purchased quantity. e.g.) ¥100 discount for five items, ¥200 for ten, ¥300 for fifteen items. TAXCODE_1～_5 (Tax code _1 ～ _5) ～ Tax code 10_1 ～ 10_5) A numeral string which defines types of taxes. Stores up to five tax types. Tax code
Definition
01
Consumption tax (tax-inclusive pricing)
02
Consumption tax (tax-exclusive pricing)
03
Tax type 3
04
Tax type 4
171
05
Tax type 5
SERVCHARGETYPE (Service charge type) One digit number determining whether the item is object of the service charge or not. Service charge code
Definition
0
Not chargeable
1
Chargeable
POINTABLETYPE (Service point type) One digit number determining whether the item is object of the service point. Service point code
Definition
0
Not chargeable
1
Chargeable
REMARKS (Remarks) You can store any character here.
172
3.2 Various settings 3.2.1 CSB008 (Graphic settings) This table is for storing graphics such as a shop logo printed on a receipt. Column code
Column Name
Type
SIZE
NULL
6
□
GRAPHICCODE
Graphic code
C
GRAPHICDATA
Graphic data
B
FILENAME
Graphic data file name
C
40
□
REMARKS
Remarks
C
30
■
Default value
■
GRAPHICCODE (Graphic code) A six-digit numeral string which stores graphic codes. Graphic code
Definition
00001
Built-in printer logo 1
00002
Built-in printer logo 2
00003
Shop name on the receipt
00004
Address on the receipt
00005
Built-in printer background 1
00006
Built-in printer background 2
00011
External printer logo 1
00012
External printer logo 2
00013
External printer logo 3
00014
External printer logo 4
00015
External printer logo 5
GRAPHICDATA (Graphic data) A string which stores binary data for a graphic logo. Graphic data code
Data format and size
00001
Bitmap（576×168 dots）*1
00002
Bitmap（576×168 dots）*1
00003
Bitmap（448×128 dots）
00004
Bitmap（448×96 dots）
00005
Bitmap（576×168 dots）*1
00006
Bitmap（576×168 dots）*1
00011
Bitmap（576×168 dots recommended）
00012
Bitmap（576×168 dots recommended）
00013
Bitmap（576×168 dots recommended）
00014
Bitmap（576×168 dots recommended）
173
00015
Bitmap（576×168 dots recommended）
*1 The data sizes in the above table are for 80mm wide paper. The same size will be necessary for 58mm paper. Valid size for 58mm paper is 384 x 168 dots (left justified). FILENAME (Graphic data file name) A character string which stores a file name with the identifier of graphic data. e.g.) LOGO.jpg、LOGO.gif REMARKS (Remarks) You can store any character here.
3.2.2 CSB012 (Layout image settings) The CSB012 stores data for tabs and buttons that the user selected. Column code
Column Name
Type
SIZE
NULL
CONTROLTYPE
Control type
C
64
□
THEME
Theme
C
16
□
CODE
Code
C
16
□
GRAPHICDATA
Graphic data
B
□
NINEPATCHCHUNK
9 patch chunk
B
■
FILENAME
File name of the graphic
C
40
□
REMARKS
Remarks
C
30
■
Default value
0
CONTROLTYPE (Control type) A character string storing control class name which the graphic is used. e.g.) ItemButton、ExtendedTabLayout
THEME (Theme) A character string which stores a theme. e.g.) Standard, Exotic, Pop or User For graphics of clerks and items, assign “User”.
CODE (Code) A character string which stores codes such as clerk, item, or Transaction (Function) button codes. For clerks, assign clerk code and for items, assign item code. GRAPHICDATA (Graphic data) This column stores the graphic’s binary data. NINEPATCHCHUNK (9 patch chunk) Binary data for 9 patch information is stored in this column
174
FILENAME（Graphic data file name） A character string which stores a file name with the identifier of graphic data. e.g.) PLU0001.png、PLU0001.9.png REMARKS (Remarks) You can store any character here.
3.2.2 CSB009 (Customer group settings) The table CSB009 stores customer stratum parameters for sales management.
Column code
Column Name
Type
SIZE
NULL
CUSTGPCODE
Customer group code
C
2
□
CUSTGPNAME C
Customer group name
C
24
■
Remarks
C
30
■
U
REMARKS
Default value
S TGPCODE (Customer group code) Two-digit number for storing customer stratum codes. CUSTGPNAME (Customer group name) A character string which defines customer group name. REMARKS (Remarks) You can store any character here.
3.2.3 CSB010 (Dallas key settings) The CSB010 table sores Dallas key data.
Column code
Column Name
Type
SIZE
NULL
DALLASKEYID
Dallas key ID
C
12
□
CLKCODE
Clerk code
C
10
□
REMARKS
Remarks
C
30
■
Default value
DALLASKEYID (Dallas key ID) A 1two-digit character string which defines the Dallas key ID. CLKCODE (Clerk code) A character string which stores codes of signed in clerk. REMARKS (Remarks) You can set any characters here.
175
3.2.4 CSB013 (Clerk sum settings) The CSB013 stores the information for the each clerk’s sales sum.
Column code
Column Name
Type
SIZE
NULL
CLKSUMCODE
Clerk sum code
C
6
□
CLKSUMNAME
Clerk sum name
C
24
■
SUMTARGETTYPE
Sum target type
C
2
□
C SUMTARGETCODE
Sum target code
C
16
□
Remarks
C
30
■
REMARKS
L
Default value
K SUMCODE (Clerk sum code) A six-digit numeral string which defines category code for each clerk’s sales sum. CLKSUMNAME (Clerk sum name) This column defines the name of the category for each clerk’s sales sum. SUMTARGETTYPE (Sum target type) This column defines the target type to be summed. Target type
Definition
12
Total adder
13
Total of Transaction (Function) buttons
14
Total of each item
15
Total of each department
16
Total of each item group
SUMTARGETCODE (Sum target code) This column defines the target code to be summed. Target code
Sum target code
Data to be summed (quantity/amount)
12
Total adder code
Same as quantities and amounts of the total adder
13
Transaction
(Function)
button
Same as quantities and amounts of Function buttons total.
code 14
Item coed
Same as quantities and amounts of items total.
15
Item department code
Same as quantities and amounts of item department total.
16
Item group code
Same as quantities and amounts of item group total.
REMARKS (Remarks) You can store any character here.
176
3.3 System settings table 3.3.1 CSM001 (Tax master) The table CSM001 stores the types of taxes.
Column code
Column Name
Type
SIZE
NULL
Default value
TAXCODE
Tax code
C
2
□
TAXNAME
Tax name
C
24
■
TAXABLEAMTNAME
Taxable amount name
C
10
■
TAXAMTNAME
Tax amount name
C
10
■
TAXTYPE
Tax calculation type
C
1
□
TAXRATE
Tax rate
N
6
□
TAXROUNDTYPE
Tax rounding type
C
1
□
VATLINK1
Tax code link 1
C
2
■
VATLINK2
Tax code link 2
C
2
■
MAXTABLEAMT
Maximum table amount
N
4
□
0
SUMCYCLICPATT
Sum cyclic amount
N
4
□
0
CYCLICNUMBER
Cyclic number
N
2
□
0
NONCYCLICAMT
Non cyclic amount
N
4
□
0
BREAKPOINT1
Breakpoint 1
N
2
□
0
BREAKPOINT2
Breakpoint 2
N
2
□
0
0
:
0
:
BREAKPOINT60
Breakpoint 60
N
2
□
REMARKS
Remarks
C
30
■
TAXCODE (Tax code) Two-digit character string which defines the tax code. TAXNAME (Tax name) A character string which stores tax names. e.g.) “CONSUMPTION TAX” TAXABLEAMTNAME (Taxable amount name) A character string which stores a taxable amount name. e.g.) “TAXABLE AMOUNT” TAXAMTNAME (Tax amount name) A character string which stores a tax amount name. e.g.) “CONSUMPTION TAX AMOUNT” TAXTYPE (Tax calculation type) One-digit character string which defines the tax calculation type. Tax type code
Definition
0
None
1
Tax-inclusive price
177
2
Tax-exclusive price
3
Table
4
TAX on TAX
5
VAT & VAT
6
VAT & VAT2
TAXRATE (Tax rate) A numeral string which stores the tax rate in the form of “999.999%”. TAXROUNDTYPE (Tax rounding type) One digit character string which defines the rounding in tax calculation. Tax rounding type
Definition
0
Round down
1
Round off
2
Round up
3
Round up for the fraction after two decimal places
4
Singaporean rounding system
VATLINK1 (Tax code link) A two-digit alpha-numeric string which defines linking tax code. VATLINK2 (Tax code link 2) A two-digit alpha-numeric string which defines linking tax code. MAXTABLEAMT (Maximum table amount) A string which defines the maximum table amount. SUMCYCLICPATT (Sum cyclic amount) A string which defines repeated total amount. CYCLICNUMBER (Cyclic number) A numeral string which stores the number of repetition. NONCYCLICAMT (Non cyclic amount) A numeral string which sores non-cyclic amount. BREAKPOINT1 (Breakpoint 1) A numeral string which stores the U.S. taxation breakpoint 1. BREAKPOINT60 (Breakpoint 60) A numeral string which stores the breakpoint 60. REMARKS (Remarks) You can store any character in this column.
178
3.3.2 CSM002 (Currency master) The table CSM002 stores the currency names.
Column code
Column Name
Type
SIZE
NULL
CURRENCYCODE
Currency code
C
6
□
CURRENCYNAME
Currency name
C
24
■
CURRENCYSIGN
Currency symbol
C
10
■
SUBCURRENCYSIGN
Sub currency sign
C
10
■
ADDMODE
Add mode
C
1
■
ADDCHAR
Decimal fraction character
C
2
■
SEPCHAR
Digit separator character
C
2
■
REMARKS
Remarks
C
30
■
Default value
CURRENCYCODE (Currency code) A six-digit alpha-numeric string which defines the currency code CURRENCYNAME (Currency name) A character string which defines the currency name. CURRENCYSIGN (Currency symbol) A character string which defines the currency symbol. SUBCURRENCYSIGN (Sub currency symbol) A character string which specifies the sub currency symbol. ADDMODE (Add mode) A one-digit number which specifies the number of decimal fraction digits ADDCHAR (Decimal fraction character) A character string which specifies the decimal fraction character. SEPCHAR (Digit separator character) A character string which defines the digit separator character. REMARKS (Remarks) You can store any character in this column.
179
3.3.3 CSM003 (Denomination master) The table CSM003 stores the denominations of currencies.
Column code
Column Name
Type
SIZE
NULL
CURRENCYCODE
Currency code
C
6
□
BILLCOINCODE
Bill and coin code
C
6
□
BILLCOINNAME
Bill and coin name
C
24
□
BILLCOINAMT
Bill and coin amount
N
10
□
REMARKS
Remarks
C
30
■
Default value
CURRENCYCODE (Currency code) A six-digit alpha-numeric string which defines the currency code. BILLCOINCODE (Bill and coin code) A six-digit alpha-numeric string which defines the denomination code. BILLCOINNAME (Bill and coin name) A character string which stores bill and coin names. BILLCOINAMT (Bill and coin amount) A numeral string which defines the amount of bills and coins. Example of a table Bill and coin code Currency code
Bill and coin name
Bill and coin amount
(meaning) 000001
000002
Yen
US$
000001 (Denomination 1)
Ten thousand yen bill
10000
000002 (Denomination 2)
Five thousand yen bill
5000
000003 (Denomination 3)
Two thousand yen bill
2000
000004 (Denomination 4)
One thousand yen bill
1000
000005 (Denomination 5)
Five hundred yen coin
500
000006 (Denomination 6)
One hundred yen coin
100
000007 (Denomination 7)
Fifty yen coin
50
000008 (Denomination 8)
Ten yen coin
10
000009 (Denomination 9)
Five yen coin
5
000010 (Denomination 10)
One yen coin
1
000001 (Denomination 1)
$500
50000
000002 (Denomination 2)
$200
20000
: REMARKS (Remarks) You can store any character in this column.
180
3.3.4 CSM007 (Numbering counter) The table CSM007) stores columns relevant to the numbering counter.
Column code
Column Name
Type
SIZE
NULL
Default value
COUNTERTYPE
Counter type
C
2
□
TERMINALNUMBER
Terminal number
C
2
□
COUNTERNUMBER
Counter number
C
6
■
RANGESTART
Counter range start
C
6
□
000001
RANGEEND
Counter range end
C
6
□
999999
REMARKS
Remarks
C
30
■
COUNTERTYPE (Counter type) A two-digit numeral string which defines the counter type. Counter type code Counter code 01 Consecutive number 02 Order check number 03 Check number 04 Transaction number 05 Receipt number 06 Money declaration number 07 08 09 10 TERMINALNUMBER (Terminal number) An alpha-numeric string which specifies the terminal number. If you use the same counter for several terminals, please set “00” in this column. COUNTERNUMBER(Counter number) A six-digit alpha-numeric string which specifies the present counter number. “NULL” is stored before usage. RANGESTART (Range start) A six-digit alpha-numeric string which defines the minimum number of the counter. RANGEEND (Range end) A six-digit alpha-numeric string which defines the maximum number of the counter. REMARKS (Remarks) You can store any character in this column.
181
3.3.5 CSM008 (Bar code settings) This table stores the columns relative to bar code settings.
Column code
Column Name
Type
SIZE
NULL
Default value
BARCODETYPE
Bar code type
C
2
□
CHECKDIGITFLG
Check digit flag
C
1
□
SHIFTLENGTH
Shift length
N
1
□
0
LENGTH
Length
N
1
□
0
TAXRATE
Tax rate
N
6
□
0
TAXROUNDTYPE
Tax rounding type
C
1
□
0
SEARCHLENGTH
Search code length
N
1
□
0
HEADFLGLENGTH
Head flag length
N
1
□
0
HEADFLGVALUE
Head flag value
C
4
■
REMARKS
Remarks
C
30
■
BARCODETYPE (Bar code type) A two-digit alpha-numeric string which defines the bar code type.
Bar code type
Definition
01
8-digit bar code
02
13-digit bar code
03
Magazines (tax included)
04
Magazines (Re-calculation of tax)
05
Books, the upper part
06
Book, the lower part
07
Books, the lower part (re-calculation of tax)
08
Magazines (with add-on tax)
09
Journalizing
10
Customer
CHECKDIGITFLG (Check digit flag) One-digit flag which defines whether the price code includes a check bit or not.
182
Check digit flag code
Check digit flag
0
Without check digit
1
With check digit
SHIFTLENGTH (Shift length) A one-digit number which specifies the number of shift digits. Shift digits (n) Price = Price code× 10
n
LENGTH (Length) A numeral string which stores the number of price code digits. TAXRATE (Tax rate) A numeral string which stores the tax rate for tax-included items.
TAXROUNDTYPE (Tax rounding type) One-digit number which defines the rounding for a tax calculation in set rate. Tax rounding type code
Definition
0
Round down
1
Round off
2
Round up
3
Round up for the fraction after two decimal places
4
Singaporean rounding system
SEARCHLENGTH (Search length) A numeral string which specifies the number of the digits in the search code. ※ The digits of a search code is counted from the most significant digit. HEADFLGLENGTH (Head flag length) A numeral string which specifies the significant digits of a head flag. HEADFLGVALUE (Head flag value) A four-digit alpha-numeric string which specifies the set value of a head flag. ※ Set values should be described as 0000～9999. REMARKS (Remarks) You can store any character in this column.
183
3.3.6 CSM009 (Function button master) The CSM009 stores columns relative to Transaction (Function) buttons.
Column code
Column Name
Type
SIZE
NULL
FUNCTIONCODE
Function code
C
6
□
FUNCTIONNAME
Function name
C
24
□
REMARKS
Remarks
C
30
■
Default value
FUNCTIONCODE (Function code) A six-digit alpha-numeric string which defines Transaction (Function) codes. FUNCTIONNAME (Function name) A character string which stores the names of the Transaction (Function) buttons. REMARKS (Remarks) You can store any character in this column.
3.3.7 CSM010 (Function button setting master) The CSM010 stores columns relative to Transaction (Function) buttons settings.
Column code
Column Name
Type
SIZE
NULL
FUNCTIONCODE
Function code
C
6
□
FUNCSETCODE
Function setting code
C
80
□
TITLE
Set title
C
40
□
DEFAULTSET
Default setting
C
20
□
EXPLANATION
Explanation of setting
C
120
■
REMARKS
Remarks
C
30
■
Default value
FUNCTIONCODE (Function code) A six-digit alpha-numeric string which specifies the function code of Function buttons. FUNCSETCODE (Function setting code) A character string which defines Function setting code. Please refer to “3.2.1 Function button settings”. TITLE (Set title) A character string which stores the title name of the setting. DEFAULTSET (Default set) A character string which stores the set value. EXPALNATION (Explanation of setting) A character string which stores the explanations of the settings. REMARKS (Remarks) You can store any character in this column.
184
4.
Database Management tool The database management tool executes backups and reloading of the database data by using an SD card.
Check
After executions of “Database reload”, “Script Execution”, “INIT” or “Check Busy Reset”,restart the VX-100 as described in “6. Restart”.
185
4.1 Database backup/Database reload/ Script execution
【Functions】 Database Backup Backs up the VX-100 database in an SD card.
186
Database Reload Reloads the backed up data in an SD card to the VX-100.
Script Execution Executes SQL script files saved in an SD card.
4.1.1 Database
Backup
Database Backup Insert an SD card in the VX-100. ※Recommended SD/SDHC cards: (4/8/16/32)GB Class 4
Select Data file Select a database.
① COMMON.DB
Database for common items of the system
② CUSTOMOER.DB Database for the customer management
③ INLINE_X_SUMMARY.DB Database for results of inline data summary
④ RESERVATION.DB Database for the reservation management
⑤ SALESBACK.DB
Database for storing sales checks in a certain period
⑥ SALESWORK.DB
Database for today’s order slips and sales checks
⑦ SETTING.DB
Database for settings of cash register such as CIA001 (Item master).
⑧ SUMMARYBACK.DB
Database for summary of sales in a certain period
187
Select Data file Select a table to be backed up.
Backup file name Enter a backup file name.
188
4.1.2 Database
Reload
Database Reload Insert an SD card in the VX-100. ※Please insert before booting the above screen. Select a file name to be reloaded.
189
4.2
Initialize Initializes the contents of the database. Selection of initializing type.
① INIT Initialize the contents of all databases. ② INIT2 (Except register settings) Initializes the databases such as sales reset, read report, customer management and reservation management data except the VX-100’s settings.
Check
Data written in SD card is not initiallized in INT operation. To delete accumulated data in an SD card, use the file manager of Android or delete it directly by using a PC. Folder in the SD card ・DataBase：¥jp.co.casio.caios.framework.database ・Electronic journal：¥ej In an SD card, user’s past data are accumulated and all of the data will be cleared if you do the delete operation. You cannot delete data partially.
190
4.3
Check busy reset In inline environment, it may occur that check call status is busy and continuously calling a check. “Check busy rese” releases this status by compulsion.
Check
Execute this operation by the VX-100 assigned as the “check tracking master”. Other inline connected VX-100s cannot operate this feature. After the execution, restart the VX-100 as described “6. Restart” in this section.
191
5
Control panel Control panel defines and confirms the settings of VX-100 to operate in a network.
【Features】 Local Device Terminal Information Defines and sets the fundamental information of the unit. Terminal network setting(CTN004) Defines and sets the network configuration of VX-100 business support system. Printer connection setting (CTN003) Defines and sets connected printers.
Terminal network Check Checks the network information as defined in "Terminal network setting(CTN004)" Logo Data(CSB008)Load to Build-IN printer Writes the logo image data to the built-in printer’s ROM.
Application version List Shows the version information of the application.
Device Tool Check the device status and OS/Operation log .
192
Cash Register System Settings Cash Register system can be switched.
5.1 Terminal number fundamental setting
Revises the table CTN004 (Network device settings). ・ ・ ・
Device classification Terminal number Property ※Set value of property determines the functions of the inline connected or check tracking master VX-100.
・
Remarks ※ Refer to “2.2.3 CTN004 (Network device settings).
193
5.2 Terminal network setting
Touching button shows connected VX-100s. By touching button registers the terminal in the network. The selected terminal is registered in CTN004 (Network device settings) table. ※The selected terminal is able to send X report (inline) and Z report (inline) .
194
5.3
Printer connection setting
Touching button shows connected printers. By touching button, the selected printer’s information is stored in CTN002 (Printer setting) table.
195
5.4
Terminal network confirmation
Checks connection responses of registered terminals registered in “5.2 Network terminal setting”.
196
5.5 Setting logo image data in built-in printer
This feature sends and writes the image data in CSB008 (Graphic settings) table in the built-in printer’s ROM. The image data storage in CSB008 table is done by database setting tool. The image data must be bitmap formatted.
197
5.6 Application version
This feature indicates the version number of application software.
198
5.7
Device Tool
You can confirm the connection statuses of devices. You can also check daemon logs in the OS or operation logs. The logs can be backed up in an SD card.
199
5.8 Cash Register System Settings
Cash Register system can be switched.
200
(New Style)
(Standard Style)
Please determine the style before setting data or starting operations. We do not recommend changing the style after setting data or operation started. As styles’ screen or operation method differ, please refer to the corresponding manual.
201
6 Restart
When item settings, operation settings, or inline terminal settings are changed, it is necessary to restart the sales management application. After the restart, the changes become effective.
Check
202
If other application than sales management software is running, terminate it before restarting. Using open check tracking system, find if there is any held (uncompleted) check. and if there is any, complete the check.
APPENDIX
APPENDIX About SD errors The followings explain the causes and solutions of SD memory card errors.
SD Error 1
When this message shows up during reset sales operation; 【Cause】 ・Reset sales data cannot be stored due to no SD memory card. 【Solution】 ・Insert an SD memory card and select [Use SD] then execute reset sales reporting again. ・If you are not using SD memory cards for storing reset sales report, select [Not using SD] then reset sales reporting continues.
204
SD Error 2
When this message is displayed; 【Cause】 ・Capacity of SD memory card is nearly full and when it is full, the SD memory card cannot store reset sales data.. As the data are temporarily stored in the hard disc, you can continue the reset sales reporting however; reserve enough space by undermentioned solution within one week. 【Solution】 ・Turn the VX-100 and remove the SD memory card. ・Insert the SD memory card in a PC. ・ Under the SD memory card’s registry ¥jp.co.casio.caios.framework.database¥databases, there are several SALES_yyyymmDB fukes (yyyymm corresponds to year and month) files. Copy the files older than one year to the PC. However, retain files of recent one year record. ※Please retain the following files in the SD memory card. 1)SALES_yyyymm.DB (Latest one year data) 2)SUMMARY.DB 3)INLINE_Z_SUMMARY.DB (This file is not existed if inline feature is not used.)
・Make sure that there is enough space in the SD memory card. ・Turn the VX-100 off then insert the SD memory card. ・Boot the sales management system of the VX-100. 205
SD Error 3
When this message is displayed; 【Cause】 ・SD memory card is full and reset sales report data cannot be stored Follow the undermentioned procedures to free up the space in the SD memory card. 【Solution】 ・Turn the VX-100 off and disconnect the SD memory card. ・Insert the SD memory card in a PC. ・ Under the SD memory card’s registry ¥jp.co.casio.caios.framework.database¥databases, there are several SALES_yyyymmDB fukes (yyyymm corresponds to year and month) files. Copy the files older than one year to the PC. However, retain files of recent one year record. ※Please retain the following files in the SD memory card. 1)SALES_yyyymm.DB (Latest one year data) 2)SUMMARY.DB 3)INLINE_Z_SUMMARY.DB (This file is not existed if inline feature is not used.)
・Make sure that there is enough space in the SD memory card. ・Turn the VX-100 off then insert the SD memory card. ・Boot the sales management system of the VX-100.
206
Error messages Error code
Error message
Sollution
000
E000 Operator mistake.
001
E001 Wrong mode operation.
003
E003 Wrong operator.
Your operation/sequence is not correct. Please check your operation and try again. Specified check/table is hold wrong mode. Once changed to check/table original mode and use it. You are not allowed to operate the check/table.
008
E008 Please sign on.
This operation needs to be signed on.
013
E013 Printer error.
Check the cable connection, power supply or paper jam.
E015 Printer error.
Check auto cutter unit.
017
E017 Check No. compulsory
Enter check/table number.
018
E018 Table No. compulsory
Enter table number.
019
E019 No. of covers compulsory
Enter number of covers.
026
E026 Item selection error.
029
E029 Error in finalize.
Selected item(s) are not enough. You need to enter more items. Finalize the payment.
031
E031 ST compulsory
Press key before finalization.
035
Enter tendered amount again.
040
E035 Change amount exceeds the limit. E040 No receipt data
046
E046 REG buffer full.
Finalize or cancel the transaction.
051
E051 Check/table is exist
052
E052 Check/table is busy
053
E053 CHK/TBL No. is not opened.
Specified check/table is already exist. Use other check/table number. Specified check/table is now using on another terminal. Please wait until close. If wrong to keep busy the check, the busy stats can be reset by special operation. Check the number and specify it again properly.
054
E054 Out of CHK/TBL No. range.
060
E060 Printer offline.
Option Printer 015 Built-in Printer
Option Printer E061 Printer communication error.
061 Option Printer 062
Built-in
E062 Printer paper end.
Receipt print is allowed when receipt data exist.
Current operator cannot access to the CHK/TBL. Check the number and specify it again properly. If the printer cover of the external printer is opened, then close it. If the ONLINE indicator is off, then press ONLINE key of the printer. Check the cable connection and power supply of the external printer, or check the setting of printer connection table. Set new paper.
Printer Or Option
Printer 063
E063 Printer busy.
Wait till external printer accept new data and try again.
207
Option Printer 070
E070 Printer server error.
Terminal out of action. Cannot print.
073
E073 Printer server error.
Your receipt/order may not be issued.
075
E075 Negative balance cannot be finalized. E081 No main item is selected.
Register item(s) until the balance becomes positive amount, or cancel the transaction. Select main item. Cannot move this transaction key. This operation is not allowed while separate payment.
084
E082 Transaction key selection error. E083 Can not operate while separate payment. E084 Bill copy issuer error.
103
E103 Item code is not exist.
Check the setting of the item code.
105
E105 Cannot access check tracking server
114
E114 Close the platen arm of the printer.
Please check terminal and connection, and retry. If still error, remove and use for standalone. OR check Network setting (CTN004) after remove operation. Check the platen arm is closed firmly.
081 082 083
This transaction is not allowed issuer Bill copy.
Built-in Printer 137
E137 Cannot operate while Registration
139
E139 Discount amount error
242
E242 Customer not found.
276
E276 No main item is registered.
Specified customer does not exist. Enter correct customer code or check customer data. Register main item.
301
E301 Operator No. is not exist.
Check the operator No.
302
E302 Wrong password.
Enter correct password.
303
E303 Sign on is not allowed.
Check the setting of the operator.
304
E304 No registration.
Items are not registered.
310
E310 Discount operation error
311
E311 Double discount error
312
E312 Void error.
313
E313 Quantity change error.
This discount operation is not allowed. Please check operation. Double discount is not allowed. Please check operation. Void operation is not allowed for specified item. If void is needed, then cancel the transaction and register items again. Changing quantity operation is not allowed for specified item.
318
E318 Not permit amount entry
Please use without amount entry.
319
E319 Partial tender is not allowed.
320
E320 No target item is exist
Tendered amount must be bigger or quall to subtotal, or finalize without amount tender. Please check the operation.
321
E321 i-Button key Error
Please attach a correct i-Button key.
322
E322 i-Button key Error
Please remove an i-Button key.
208
This operation is not allowed while registration. Please cancel or finalize registration and re-operation it. Not allowed to be negative.
900
E900 Error input value.
Check input value.
910
E910 Database access error.
990
E990 Data mismatch error
If this error is shown when installation, please check database setup. If already using, please call manager. Some data has mismatch. Please check settings around this operation.
209
INDEX - 22, 34, 119, 126
Control panel ... 26, 42, 103, 160, 192
General featurecode ...................... 40
Cover ............................... 27, 28, 120
group ............................. 99, 100, 101
Credit .............. 22, 24, 28, 36, 53, 119
Guest receipt . 36, 135, 141, 144, 146
Customer........ 9, 12, 25, 41, 42, 102 Customer number .................. 32, 120
H
% HASHITEMFLG .............. 35, 114, 115
D
Hold ............................ 28, 32, 91, 119
%-21, 32, 34, 119, 120, 125, 137, 138 %+ .............. 22, 32, 34, 119, 120, 125
Dallas key .................................... 175
House bon ....................... 22, 34, 120
Data management ................. 25, 103 Data Setting................................... 25 +
I
data sharing................................... 91
+ 22, 34, 119, 126
A
data transmission ................ 103, 157
i-Button ............... 11, 39, 98, 101, 208
Database .. 11, 12, 13, 14, 25, 43, 103
Initialize ................................. 26, 190
Database backup........... 25, 186, 187
Inline 9, 24, 26, 41, 68, 69, 85, 91, 92,
Database Management ....... 160, 185
Application version .............. 192, 198
B Bar code .......................... 14, 34, 182
C
102, 191, 194, 202
Database reload .................. 186, 189
Item ............................. 14, 28, 34, 35
Database setting ................. 160, 169
Item department .............35, 107, 112
DB management ........................... 42
Item department master ...............112
DB setting ...................................... 42
Item group ................ 16, 36, 112, 113
Denomination master .................. 180
Item group master ........................113
Device setting ............................ 163
Item master ................................. 107
Device Tool .......................... 192, 199
Item parameter code ........... 107, 109
Discount .......................................119
Item setting9, 14, 25, 42, 96, 103, 104,
drawer ...7, 10, 23, 37, 51, 52, 57, 75,
Cancel ............................. 33, 41, 120 Cancellation................................... 23 cash ...7, 9, 22, 23, 28, 35, 36, 37, 51,
105, 113, 169
99, 125 L E
52, 57, 114, 119
Loan ............................................ 102
Change ...................................27, 119
Electronic journal ... 9, 24, 41, 93, 102
Character setting ......................... 146
Email remote ........................... 25, 42
Charge.............................. 28, 54, 119
Error ........................ 17, 73, 204, 207
logo image ................................. 150
M
Check .....................................27, 119 Check busy reset ....................... 191
F
Check number ......................... 29, 32
Meal ticket ............................... 22, 36 menu application function ............ 101
Check operation setting.............. 29
Flash report ..... 7, 15, 24, 41, 57, 102
Menu application function ........ 102
Check screen .......................... 29, 30
Function.... 14, 28, 32, 36, 37, 39, 119
Mode ....................... 28, 43, 102, 120
Check sharing ............................... 91
Function button ................. 127, 184
Money declaration .. 7, 23, 41, 51, 52,
check tracking system ........... 91, 202
Function button settings .............. 124
Clear .............................................. 28
Function key .................................. 27
Clerk ..5, 14, 23, 27, 38, 43, 100, 101, 120, 126
210
Money paid .............................. 41, 51 Money received ....................... 41, 51
G
Clerk setting 9, 15, 25, 42, 43, 96, 98, 99, 103
55, 156
General feature .... 40, 151, 152, 153
N
R
T
network Check............................. 192
Receipt .............................23, 28, 119
Table ....................................... 27, 28
Network device setting ................ 167
received ....................................... 102
Table number................................. 32
NONPOINTFLG ...........................114
Reduction .....................................119
Task List ....................................... 21
NONSRCVCHARGEFLG .............. 35
Refund ................. 23, 41, 44, 46, 102
Tax .................................... 14, 22, 31
NS ................................................. 28
Reg minus ......................... 23, 45, 46
Tax code ...................................... 109
Number of customers .................... 32
Registration ................................... 41
Tax master ................................... 177
Reload ........................................... 26
Tax System .................................... 31
remote control ................................. 9
Ten-key ......................................... 27
Reservation .... 9, 12, 25, 41, 42, 102
Terminal network confirmation 196
OBR ............................................ 120
Restart ............. 26, 42, 103, 160, 202
Terminal network setting ...... 192, 194
Open................................ 23, 41, 102
Round .............................. 22, 31, 155
Text ............................................... 25
Open check ........................... 91, 102
Rounding system ......................... 154
TRAINING ..................................... 43
O
Transaction report ........... 41, 88, 102
Open check report ....... 24, 41, 70, 89 Open for business ......................... 50
Transaction setting .................96, 119
S
OPENPLUFLG ............... 35, 114, 115 Operation....................................... 43
Sales data collection...................... 91
Operation log ........... 26, 42, 103, 160
Sales registration . 4, 21, 27, 31, 32,
Operation setting .. 15, 29, 31, 40, 50, 96, 125, 152 Order .............................. 11, 113, 114 Others............................................ 28
36, 155 SD card ..... 11, 75, 87, 156, 185, 186, 187, 189, 190, 199
Password....................... 5, 23, 97, 99 Payment ................. 37, 119, 124, 127 POINTFLG ...................................115 Premium .......................................119 Preparing change ........................ 51 Price raising..................................119 Print setting ........................... 96, 133 Printer connection setting .... 192, 195 Printer setting .............................. 166 Purchase analysis ......................... 41
Voucher ................................... 22, 36 VX-100 setting ..................... 160, 162
W
Setting ............................................ 9 Setting a message ..................... 145
paid.............................................. 102
Void ........................................27, 119
Set item .......... 14, 107, 109, 116, 117 Set menu ....................................... 35
P
V
Work ｍenu ......................... 5, 41, 43
Setting item .................................. 35 Setting logo................................ 197 Settings for sales ........................... 31
X
Settings transmission .................... 25 Sharing ......................................... 92 Signon 5, 23, 27, 38, 39, 43, 120, 126
X 27, 120 X report..8, 24, 41, 59, 67, 68, 69, 70, 91, 92, 102
SINGLEITEMFLG ...................35, 114 ST- ................................... 21, 33, 120 ST %- ............................................ 21
Z
ST %+ ........................................... 21 ST House ........................ 21, 33, 120 ST+ .................................. 21, 33, 120
Z report ..8, 24, 41, 72, 73, 84, 85, 86, 89, 91, 92, 102, 156
Subtotal ................................. 28, 120 System ............................................ 9 System setting ............................... 25
211
CASIO COMPUTER
CO. ， LTD.
6-2 ，Hon-machi 1-chome Shibuya-ku， Tokyo 151-8543， Japan
Business Support Terminal VX-100 Sales Management Application VR-100-DLR*E Ver. 1.3.0.F Standard Style Printed in Japan
