Entry Module, Report System 145 | Toshiba Electric Keyboard specification

Report System

145

The SQL editor window is divided into four (4) parts:

·The SQL editor is the top left portion of the screen, and contains the commands for the report. ·The tool bar.

·The upper right of the window shows the prompts used in the Report SQL file to collect the language, start and end dates, period type, store number and cashier number from the user. The editor reads the code at load time and displays all prompts it finds in the report file when you open the Editor.

·The bottom portion of the editor window is empty when first opened. It is used to view the results of the SQL commands in table format with the field numbers as column headers (not as a formatted report) after pressing the "Test" toolbar button.

Tool Bar Tools

Test: tests the currently loaded query and displays the results in table format. Use this to test changes to the query and get immediate results.

View Qry: Opens a panel displaying the current version of the loaded report query. The panel also contains an "execute" option that runs the query displaying the results in table format (like the test option).

Re-Read:If you make changes to the report file, for example adding new prompts, this forces the editor to re-read the code and refresh the upper right pane that shows the prompts used in the code.

Save: The save button is "greyed out" until you actually change the loaded query. This saves the modifications in the .sql file.

Close: Closes the Report SQL Editor window. If changes were made to the query, the close process will prompt to save the modifications.

NOTE: The editor has a "SIL field decoder" feature (field numbers like F1024). While editing the code, if the cursor is anywhere in a field number, the field's description is displayed in the Editor window's top bar beside the report file name. Click any "F" field in the query to see which field is referenced.

This example shows the Editor's SIL field decode feature. The cursor is on the first field in the query - (F1185)

6 Entry Module

Entry Module Overview

© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a

Image 147

Toshiba Electric Keyboard owner manual Report System 145, Tool Bar Tools, Entry Module Overview

Contents

Toshiba TEC America Page Table of Contents 114 106 Part VII View Log Part File Maintenance UtilityPart V Report System Part VI Entry Module 181 Part Phone no 449-3040 FAX 770 Limited WarrantyLimited Warranty Symphony POS Software Security About Symphony Pro applicationOverview Data Storage Printing Help as a Manual Navigating the Symphony Pro Application Using the mouseUsing the keyboard Navigation Understanding Communications To print the entire paper manualPolling Process Controlling Database Size Data MaintenanceDaily Maintenance Process Monthly Maintenance Process Protecting Your Data Backups Are ImportantSymphony Pro Data Backup Physical Backup Main Menu Symphony Pro Main MenusFile Menu Symphony Pro Main Menus Login Symphony Pro File Menu OptionsLogging into the System Logging off the system Setting the LanguageLogout Language Viewer Display View Internal ProcessWhats Happening behind the scenes View internal process Buttons This example shows the Internal Process viewerStatus bar and control buttons Status Bar View menu Files Menu Menu Options View Polling StatusView Polling Process This example shows the Polling Process viewer Execute Command File Forcing CommandsViewer Display windows Deploy Individual File Other TasksSending Information From One Database Table Configuration Panel Basic Symphony Pro Set Up InformationThis example shows the Deploy one file table selection tool Company Company Tab Settings TO=STORE103 System System Tab Settings This example shows the Configuration panels System tab Toshiba TEC America America Retail SYSTEMS, INC. R1.0a This example shows the Configuration panels Misc tab Misc Misc Tab Settings Host Host Tab Settings Host data communications This example shows the Configuration panels Host tab Toshiba TEC America America Retail SYSTEMS, INC. R1.0a Cleanup Cleanup Tab Settings This example shows the Configuration panels Cleanup tabNumber of days to keep individual terminal Number of days to keep processed files Load Files Load Files Tab SettingsNumber of days to keep successful log Number of days to keep all log Because it will be overwritten This example shows the Configuration panels Load Files tab Establishing access levels Security Security Tab Settings Security System Overview This example shows the Configuration panels Security tab To assign security levelsThey can modify, add or delete it Julian Date Send urgent message to Symphony ProDate Conversion Calendar and Date Conversion Utility Messages Utility Using the Messages UtilityMessages Unix Date Exit the Symphony Pro Application Show TipsExit Show Tips Symphony Pro File menu Option Modules Menu Options Modules Menu Symphony Pro Desktop Icon shortcuts Special Menu Options What is it for?Special Help Maintenance Application Symphony Pro Maintenance Application OverviewVersion numbers Maintenance Main Menus This example shows the Maintenance applications DesktopMaintenance Menus and Icons Overview Top Bar Tools Maintenance ApplicationCommon Data Edit Toolbars Common Data Table Toolbar Displaying Data Lists Viewing Data Table Contents Maintenance Application File Menu Overview SQL Command Item Maintenance Utilities Item OptionsItem Table File Menu Options Terminal table help pages in this manual Maintenance Application Other Dynamic File Menu Options Other File Options Edit Menu Edit Menu OverviewEdit Menu Item Options Other Dynamic Edit Menu Options Other Edit Options PLU Menu Option s PLU Menu Item Table Tabs and Fields Item Tables This example shows the Item table editor Quick Tab Item PLU Maintenance Quick T ab This example shows the Item tables Quick tab Editing the Quick Tab Editing the Quick TabMoving existing fields within the quick Object Tab Adding fields to the quick This example shows the Item tables Object tab Item PLU Maintenance Object Tab POS Tab Item PLU Maintenance POS Tab This example shows the Item tables POS tab Maintenance Application Price Tab Item PLU Maintenance Price Tab This example shows the Item tables Price tab Suggested Retail and Sale price Programming Active and Next prices Maintenance Application If you have selected to use Markup Margin vs. Markup Comparison Chart Maintenance Application Margin Markup Toshiba TEC America America Retail SYSTEMS, INC. R1.0a Rental Items Toshiba TEC America America Retail SYSTEMS, INC. R1.0a This example shows the Item tables Cost tab Cost Break Section Regular Cost Section Maintenance Application This example shows the Item tables Inventory tab Sales Tab Item PLU Maintenance Sales Tab Image File Naming Convention This example shows the PLU weekly Sales tab Maintenance Application Image Type and Size Restrictions Required POS SetupECL tab Creating Electronic Coupon links Meal deal or Combo pricing ECL qualifying record Type Kit tab Creating kits Number. not implemented as of JuneCumulative Purchases Method Qualifier Maintenance Application Building the kits Filtering with an Alphanumeric Field Setting a FilterWorking With Items Working with Items Overview This example shows the Filter setting tool Filtering with a Currency FieldFiltering with a Logical Field Combining Filters and Global Modifications Adding New Items by Copying This example shows the item creation optionsOptions Deploying Modified Items Sending Changes to Targets Removing Items Rental Items Controlling Rental Items Rent Tab Symphony POS Setup module showing the Rent Tab Item Label Setup Linking Items with Labels Sub-department Overview Sub-department Table This example shows a Sub-department table record Sub-department ProgrammingSub-Department Table Settings Maintenance Application This example shows a Department table record Department Programming Department Table SettingsDepartment Table Department Table O verview Maintenance Application Other Item Related Tables Table Programming OverviewBottle Link Table Bottle Link Programming Environmental fee This example shows a Bottle Link table record This example shows a Category table record Tare Table Tare Table ProgrammingThis example shows a Tare table record Category Table Category Table Programming This example shows a Price Level table record Mix & Match Table Mix & Match Table ProgrammingThis example shows a Mix & Match table record Scale Table Scalable Item Table Programming Reference field, it does not print on the register receiptVendor Table Vendor Table Programming This example shows a vendor table record Scale Table Fields This example shows a Scale table record 100 Price Modifier Net WeightCreating and Using Batches Batches Maintenance Application 101 Adding new BatchesAdding records items to the batches Posting Batches Setting the Price102 Changing the Field Order Statistics 104 This example shows the Statistics Data testing panel Maintenance Application 105 Customer Account Related Maintenance This example shows a Customer table record Maintenance Application 107 Contact 108 Associating a Photo with a Customer Maintenance Application 109 Customer Level Table Programming Client Level TableRisk Level Table 110 This example shows a Customer Risk Level table record Maintenance Application 111 Account view Discount112 Custom messages Maintenance Application 113 Register Menu Options Register Menu This example shows an Operator table record Maintenance Application 115Operator Table Operator Table Programming Function Table Programming Functions Table116 Information Fields Maintenance Application 117 This example shows a Function table recordAlpha Parameters Totalizer Link List 118 Maintenance Application 119 120 Maintenance Application 121 Totalizer TableTotalizer Table Programming This example shows a Totalizer table record 122 Maintenance Application 123 Terminal TableTerminal Table Programming 124 Terminals and Groups Adding terminals automaticallyAdding terminals manually Maintenance Application 125 126 Terminal groups at Headquarters Maintenance Application 127Gift Certificates Sample terminal list Navigation Menu This example shows a Gift Certificate table recordMemorizing the Item Tables Tab Order Windows Menu Maintenance Application 129Controlling the Maintenance Desktop Transfer Menu Report Types Default Symphony Pro ReportsList of Default Reports Report System Report System 131 Report Selection Utility Report SelectionControlling Reports Right Click Menu Bottom bar Buttons Report System 133This example shows the Report Selection Utility Selecting a Report This example shows the Report Target Selection utility Using ReportsOpening Reports Reports Without Dates Report Periods Report System 135 Report Viewer Viewing ReportsReport Viewer Options Report printing Default report printerSetting a default printer for reports Setting a different printer for specific reports Printing Labels Generating Item or Shelf LabelsSelection prompt window Report System 139 This example shows the Label selection boxFirst Label Selection 140 Other Label Printing OptionsDefining the label printer Report Properties Panel Report Properties Report Properties Panel Options 142 Report Sections Report System 143 Report SQL Editor Modifying Symphony Pro Report SQL CodeReport SQL Editor Window Entry Module Overview Entry ModuleReport System 145 Tool Bar Tools This example shows the Entry applications Desktop 146 This example shows the Purchase Order selection tool Purchase OrdersEntry Module 147 View Menu Options Creating Purchase Orders 148 Automatic Generation of a P/O Entry Module 149 Stock Receiving Without a Purchase Order Receiving Stock This example shows a Manual Receiving screen Entry Module 151 Printing your stock transaction Receiving Stock using a Portable Device152 Receiving Stock from a Purchase Order Counting Inventory Counting and Adjusting StockInventory Adjustments Entry Module 153 Other Entry Options Transfer Pickups and Loans Entry Module 155Working with Cashier Pickups, Loans and Declarations 156 This example shows the System Log viewer View LogEntry Module 157 View Log Utility Viewing Logs and Messages Logs and Messages Viewing Urgent Messages Urgent MessagesUnprocessed Files View Log 159 This example shows the Electronic Journal Basic version Using the Electronic Journal L-TrackerElectronic Journal L-Tracker Electronic Journal Utility Electronic Journal L-Tracker 161 162 Events / Tasks Electronic Journal L-Tracker 163Events / Tasks Utility Navigating Command Directories 164This example shows the Events / Task utility This example shows the Task Editor programming Programming EventsEvents / Tasks 165 Modifying / Adding / Automating Tasks Task Editor Repeating Cycle 166 Changing the Events / Tasks List Order Using Command directoriesEvents / Tasks 167 Adding / Removing Tasks This example shows the stand alone Monitoring utility Monitoring Utility168 Watching the Front End This example shows a sample of Monitor Statistics Form ManagerMonitoring Utility 169 Monitoring Statistics Shelf and Item Labels Template EditorSymphony Pro Report Template Files Symphony POS Form Template Files Template Objects Form Manager 171 Tools Object Right Click MenuTop Bar Tools and Options Form Manager 173 This example shows the Form Managers label page setup MenusForm Manager Main Menus File Menu Records This example shows the Form Managers page setupConfiguration Form Manager 175 This example shows the Form Managers Object Inspector 176 File Maintenance Utility File Maintenance Utility 177Symphony Pro File and Database Maintenance Utility Creating An Automated Backup 178 About Data Table Backups View File Properties and Contents File Maintenance Utility 179When and How to Use the Data Table Backups To restore a file from a backup 180 Re-indexing TablesRe-Indexing Operation Glossary of Terms File Maintenance Utility 181Why and How to use the Pack Command Glossary 182 Glossary 183 Back Cover