Micros Systems 3700 POS User's Guide Page 28
- Page / 252
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
2-2
Creating a Database
Overview
Overview
Programming a new database requires you to do some planning.
Use the 3700 Site Survey to gather information about the
restaurant and its operation before you attempt to program a
database.
Read this chapter for information about the following
programming topics:
❏ Pre-programming steps
❏ Programming methods
❏ Introduction to the programming process
❏ What to do after you complete programming
- 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.com. All rights reserved. | 0.028 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals