Micros Systems 3700 POS Guide de l'utilisateur Page 20
- Page / 252
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
1-6
The 3700 System Database
Types of Database Tables
Some of the other definition tables in the 3700 database include:
Class Definition Tables
This specialized type of definition table plays an important role
in a 3700 database. Class definition tables impact:
Each class defines a set of identical characteristics. The class
can then be shared by many different items that use these
characteristics.
Advantages of Class Definition Tables
The advantages of class definition tables in the database
include:
❏ Simplifying database programming and maintenance
❏ Reducing the total disk space required to store a complete
set of definitions
Simplifying the Programming Process
Classes simplify database programming and maintenance. For
example, assume that you define a menu item class called
“Appetizers”.
❏ Employee
❏ Order Type
❏ Menu Item
❏ Touchscreen Style
❏ Reason
❏ Help Screen
❏ Menu Item Group
❏ Tax
❏ Table
❏ Revenue Center
❏ Tender Media
❏ Tax Class
❏ Order Device
❏ Color Combo
❏ menu items
❏ condiments
❏ fixed price meal courses
❏ historical totals
❏ printers
❏ menu levels
❏ employees
- POS Configurator User’s 1
- Declarations 2
- Table of Contents 3
- Chapter 4: Devices 4
- Chapter 5: System 4
- Chapter 6: Sales 4
- Chapter 7: Revenue Centers 5
- Chapter 8: Employees 5
- Chapter 9: Reporting 5
- Appendix A: For 2700 Users 5
- POS Configurator 7
- +RZ7KLV0DQXDOLV2UJDQL]HG 8
- Related Manuals 10
- Conventions 11
- What’s new in v1.01 12
- What’s new in v1.02 12
- What’s new in v2.00 12
- How to reach us 13
- Postal Address 13
- E-mail Address 13
- Reader Response 14
- The 3700 System Database 15
- A Database System 17
- An SQL Database 17
- Database Tables 18
- Types of Database Tables 19
- Class Definition Tables 20
- Reducing Disk Space 21
- Totals Tables 22
- Detail Tables 23
- Status Tables 23
- Linking Forms 24
- Sequence and Object Numbers 25
- ❏ for a revenue center 26
- ❏ for the entire system 26
- Creating a Database 27
- Using the Site Survey 29
- Completing the Site Survey 29
- Adapting the Sample Database 29
- Adapting a Similar Database 29
- Converting a 2700 Database 30
- Programming a Shell Database 30
- Blank Forms 30
- Programming by Feature 31
- Programming by Form 32
- Suggested Programming Order 33
- Back Up the Database 36
- Review the Site Survey 36
- Test the Database 36
- Clear Totals 37
- Wrapping Up 38
- Using POS Configurator 39
- Starting the Control Panel 41
- Control Panel 42
- Opening POS Configurator 43
- The Main Window 45
- The Options Menu 46
- The Help Menu 46
- Tool Tips 49
- Special Tools 49
- Working in Record View 52
- Selecting Options 53
- Sort By 53
- Folder Links 54
- Context-sensitive Help 54
- Working in Table View 55
- To add a record 56
- To copy and paste a field 57
- To find a record 59
- To edit a record 60
- To clear a field 60
- To delete a record 61
- To delete a block of records 62
- To save a change 63
- Employee Definition Report 64
- Menu Item Definition Report 65
- Using Touchscreen Designer 66
- Changing the default key size 67
- Right-click touchscreen key 68
- Right-click touchscreen 68
- Multiple Select 68
- Drag and Resize 68
- The Key Palette 69
- Chapter 4 71
- COM Ports 74
- Printer Definition 76
- Printer Interface 77
- Using Logical Order Devices 78
- **HOT** 80
- SEAT 1 80
- BUFFALO WINGS 80
- Assigning Default Screens 81
- Cash Drawer Assignments 81
- To assign cash drawers by UWS 81
- UWS Options 83
- Order Devices 85
- Printers 86
- Peripherals 87
- Interface 89
- Settlement 93
- Touchscreens 94
- Programming 95
- Touchscreen Designer 98
- Chapter 5 99
- Overview 100
- Programming 101
- Business Settings 102
- Information Screens 105
- Licensing 114
- In this chapter 115
- Chapter 6 115
- Tax Rates 117
- Breakpoints 119
- Canadian Tax 120
- Selecting a Print Class 122
- Menu Levels 124
- Example (Main) 125
- Example (Sub) 125
- Automatic Menu Levels 126
- Discount/Service Charge 129
- Organizing Tender/Media 130
- Types of Tender/Media 130
- Preset Tender Keys 133
- Credit Card Tender 134
- Authorization 135
- Preambles 136
- Service Total Options 138
- Printing 139
- Course Membership 143
- Course Selection 144
- Menu Item SLU 146
- Tender/Media SLU 147
- Sales Itemizers 148
- Headers and Trailers 149
- Condiment Membership 151
- Condiment Selection 152
- General Options 154
- Print/Display Options 155
- Price/Totals 156
- Menu Items 157
- Naming Menu Items 158
- SLU Priorities 158
- Definition/Groups 160
- Definition/Options 161
- Revenue Centers 165
- Headers/Trailers 168
- Floor Limits 169
- Parameters 178
- Guest Checks 179
- RVC Interfaces 183
- Table Names 185
- Value Added Tax (VAT) 187
- RVC Touchscreens 191
- Checks/Receipts 193
- Security 195
- RVC Transactions 197
- Employees 199
- Privileges 202
- Procedures 203
- Transactions 204
- Void/Return 207
- Job Categories 211
- Employee Status 214
- Job Rates 215
- Time Clock Schedule 217
- Overtime 218
- Reporting 221
- Report Templates 223
- Days/Months 228
- Descriptor 231
- Family Groups 233
- Menu Item Groups 234
- Using Subtotals 235
- Error Actions 239
- Call/Ext. Prog 240
- Stored Procedures 242
- For 2700 Users 243
- Broadcasting the Database 244
- File Configuration 245
- Hexadecimal Type Fields 245
- Report Options 246
- MAP Characters 246
- Numerics 247
- Index 2 248
- Index 4 250
- Index 6 252
© 2020, manymanuals.fr. Tous droits réservés | 0.026 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels