BaaN Tools Architecture and Features ? Tools is BaaN IV’s Foundation ? State-of-the-Art 4GL Development Environment ? Application Installation & Administration ? Application Customization & Development ? Secure BaaN’s Open System Policy & Client/Server Strategy BaaN Tools Architecture and Features ? Repository ? Database Independent ? Logical Data Model ? Menus, Forms, Reports ? Session Generator ? Program Scripts ? Programming ? 4-GL Procedure language ? Event Oriented language (4GL) ? Includes procedural language features BaaN Tools Architecture and Features ? FOUNDATION PACKAGE ? User Management ? Print Management ? Menu Management ? Job Management ? Text Management ? Database Management BaaN Tools Architecture and Features ? CUSTOMIZATION PACKAGE ? Query Management ? Report Management ? Form Management ? DEVELOPMENT PACKAGE ? Data dictionary Management ? Programming Facilities BaaN Tools Architecture and Features ? Operating Systems ? All UNIX variants ? OSF/1 e.g. Alpha ? Communication ? Berkeley Sockets (TCP/IP) ? Message Queues ? Pipes BaaN Tools Architecture and Features ? Database Drivers ? BaaN/Triton Base ? Oracle ? Informix ? Sybase ? DB2/6000 ? SQL/Server BaaN Tools Architecture and Features Multi Tasking BaaN Tools Architecture and Features ? Tools 6.1 Features ? Chart Manager ? Easy SQL ? Embedded SQL ? Query by Forms ? Exchange Module ? Audit ? Multi Company Logical BaaN Tools Architecture and Features ? Usage of Tools ? Installation ? Administration ? Customization ? Development ? Translation ? Distribution ? VRC ? Easy SQL ? Text Manager BaaN Tools Architecture and Features ? Application administration Facility ? Security Management ? Job Management ? Print Management ? Database Management ? Text Management ? Basic Data Management ? Query Management BaaN Tools Architecture and Features Data Dictionary BaaN Tools Architecture and Features Session Structure BaaN Tools User Interface ? Character Based Terminals ? UI Driver - BA ? ASCII ? vtxxx ? X-Windows Station ? UI Driver - BX ? PCs ? UI Driver - BW ? MS-Windows Interface BaaN Tools User Interface ? Easy to Use ? “Look and Feel” of MS-Windows Application ? Run on ASCII / X and MS-Windows Platforms ? MS-Windows UI Driver resides on the PC. Developed under Windows 95 / NT (32 Bit) ? Seamless Portability across operating systems ? Additional functions available in MS-Windows driver BaaN Tools User Interface ? MS Windows Configuration ? BW.EXE : Executable on Client ? “.BWC” Configuration files for connections ? Different “.BWC” files for different connections ? Hostname, BSE ? Login prompt: Give the OS logon ? Identify the BaaN User by “-- -set USER=” command BaaN Tools User Interface ? Unix Configuration ? User is logged in as per the Unix Login ? BSE, BSE_TMP, PATH, TERM environment variables to be set properly (.profile) ? To log on to another BaaN user, set environment variable USER to the desired username ? Corresponding record must exist in BaaN ? F6 Key: Map properly in Terminal Emulator ? F7 Key: Compose for Special Chars (Ÿ, ¥, é) ? $BSE/lib/terminf directory BaaN Tools User Interface ? Menu Types ? Startup ? Submenu / Follow-up menu ? Parallel ? Zoom ? Menu Components (ASCII) ? Status line, Menu Number, Company, Date ? Package, Choice Field ? Option Dialog, Help BaaN Tools User Interface ? Types ? Type 1: Single Occurrence ? Type 2: Multi-Occurrence ? Type 3: Multi-Occurrence with view field ? Type 4: Single Occurrence (without main table) ? Form Components ? Name, Company Number, date, Type ? No. of Forms, Special keystrokes, Choice ? Zoom, Shell Command (<) BaaN Tools User Interface ? Others ? Field Help ? Enum Fields ? Date Fields: Can enter dates w.r.t. system date ? Help Viewer ? Report Viewer ? Text Editor ? Windows Help ? Desktop Management BaaN Tools Directory Structure ? BSE directory: Software Environment ? Executables & Shell Scripts ? Supporting Software ? Package Software ? Settings & Defaults ? dict: ? Tables / Domains for packages ? tables: ? Triton Base data BaaN Tools Directory Structure ? bin ? ba6.1 / bx6.1 ? shmmanager6.1: Shared Memory Manager ? licd6.1, licmon6.1 ? tbase6.1, tmanager6.1 ? bdbpost6.1, bdbpre6.1, bdbreconfig6.1 ? ora7_admin6.1, ora7_inst6.1, ora7_maint6.1 ? etc ? rc.start, rc.stop ? rc.startjob, rc.startjobdm, rc.stopjobdm BaaN Tools Directory Structure ? api: C language interface files ? audit: Audit logging ? gif: Icons for GUI ? mswindows: zip file for MS-Windows client S/w ? ps: Postscript files ? sec: BaaN security information (licensing) ? log: error logs ? include6.1: used by BaaN compilers ? tmp: Temporary files, locks ? doc: Release notes for BaaN installation BaaN Tools Directory Structure ? application ? Forms: f (ftccom2) ? Menus: m (mtccom2) ? Report Objects: o (otccom2) ? Program Objects: o (otccom) ? Program Scripts: p (ptccom) ? Report Scripts: r (rtccom) ? Include Files: i (itccom2) ? tools ? dtt.pd, dtt : Domain / Table defs of Tools BaaN Tools Directory Structure ? $BSE/lib directories ? locale, nlsinf, BSFfonts, barcode ? install: installation defaults ? printinf: Printer information files ? terminf: Terminal Information files ? textinf: Window messages ? patches: BaaN patches (bug fixes) ? edi: Standard edi setups (EDIFACT / X-12) ? informix, ora, sybase, db2, tbase ? user: u, p, r BaaN Tools Directory Structure ? $BSE/lib files ? audit_spec, auditdef6.1: Auditing Setup ? datecurr: Company / Date / Currency formats ? fd6.1: locations for package combns. ? ipc_info: tech. info. for display / db drivers ? isam_def6.1: addresses for TBase tables ? srdd_tab6.1: components in shared memory ? tabledef6.1: database types for tables / company ? xchdef6.1: Exchange based on audit definition ? kernel_cfg, shm_param BaaN Tools Directory Structure ? dict files ? ttt: tables of BaaN IV Tools ? dd: Data Dictionary for Package Combination ? d.pd: Domain Definitions ? d: Tables of Modules ? Table Definitions: Runtime file formats ? d BaaN Tools Directory Structure ? tables directory ? Stored by Company number ? t directories ? t
files ? Data files: .bdt ? Index files: .bid BaaN Tools License Management ? System Configuration ? Start / End Dates ? Development Tools licensing ? BA/BX users, Database selection ? RDBMS licensing ? Print System Configuration: generates the security key - use Only Once ? Insert Validation Key ? Validate Tools Set: Starts licensing daemon ? Configure Application: patches code to software BaaN Tools License Management ? Unix: Licd6.1 daemon ? NT: BaaN Licensing Service ? $BSE/sec/standard.secu ? $BSE/lib/licence6.1 ? License file: No relocation / restore / touch ? Unix: /.brand/.brand6.1 ? NT: \WINNT\baan6.1.lic ? hostid6.1 program ? licmon6.1 : License Monitoring utility BaaN Tools License Management ? Critical Files ? Unix: Licd6.1 daemon ? NT: BaaN Licensing Service ? $BSE/sec/standard.secu ? $BSE/lib/licence6.1 ? License file: No relocation / restore / touch ? Unix: /.brand/.brand6.1 ? NT: \WINNT\baan6.1.lic ? hostid6.1 program ? licmon6.1 : License Monitoring utility BaaN Tools License Management ? Hard System Crash, to restore to another system ? Restore $BSE from backup on another system ? Remove .brand6.1 file and startup BaaN ? Patch Objects after System Crash ? Patch the objects and relicense ? Can continue working in production mode for 15 days ? Procedure applies even for motherboard change BaaN Tools License Management ? Soft System Crash, to restore to same system ? Restore $BSE from backup on another system ? Remove .brand6.1 file and startup baan ? Validate Tools set ? Configuration Application BaaN Tools User Management ? Unix User and login group (bsp) ? Setup BSE variables in .profile ? Maintain User Data ? Convert to Runtime Data Dictionary ? If superuser, then this will login on to user ? If BaaN user and OS user are different then you must set the USER environment variable ? .BWC setup ? -- -set USER=wrkshp9 BaaN Tools User Management ? BaaN User / System User / Name ? User Type: Superuser or Normal User ? Package Combination / Company / Language ? Application System / Startup System ? Startup Program / Desktop / Menu Browser ? Start / End Time, Max. Processes ? Shell Command, Auth. for all devices ? Delete Delay Time, Refresh Interval, History ? Screensaver Password option(ASCII) BaaN Tools User Management ? User History ? $BSE/lib/TIME.HIS ? Session Usage by user, Date, Time ? Print User History ? Delete User History regularly BaaN Tools Authorizations ? Authorizations are applicable to “Normal” Users ? Following are the types of authorizations ? Module Authorization ? Session Authorization ? Database Authorization ? Company Authorization BaaN Tools Authorizations ? Session Authorizations by Session (ttaad2131m000) ? User ? the BaaN Normal user to whom the access is to be given ? Package ? the package in which the session exists ? Session ? the Session for which the access is to be given ? Start time ? the start time for the access e.g. 9:00am ? End time ? the end time for the access e.g. 5:30pm BaaN Tools Authorizations ? Session Authorizations by Module (ttaad2130m000) ? User ? the BaaN Normal user to whom the access is to be given ? Package ? the package in which the session exists ? Module ? the module for which the access is to be given ? Start time ? the start time for the access e.g. 9:00am ? End time ? the end time for the access e.g. 5:30pm BaaN Tools Authorizations ? Table Authorizations by Package (ttaad4130m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Package ? indicates the package for which the Authorization is to be given ? Authorization Indicator ? indicates the Type of authorization that the User has ? Delete/inset/modify/read ? Inset/modify/read ? Modify/read ? Read ? Not authorized BaaN Tools Authorizations ? Table Authorizations by Module (ttaad4131m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Package ? indicates the package for which the Authorization is to be given ? Module ? indicates the Module within the above mentioned package for which the authorization is to be given ? Authorization Indicator ? indicates the Type of authorization that the User has ? Delete/inset/modify/read ? Inset/modify/read ? Modify/read ? Read ? Not authorized BaaN Tools Authorizations ? Table Authorizations by Table (ttaad4132m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Package ? indicates the package for which the Authorization is to be given ? Table ? indicates the Table for which the authorization is to be given ? Authorization Indicator ? indicates the Type of authorization that the User has ? Delete/inset/modify/read ? Inset/modify/read ? Modify/read ? Read ? Not authorized BaaN Tools Authorizations ? Table Data Authorizations (ttaad4134m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Table ? indicates the Table for which the authorization is to be given ? Data Authorization ? indicates the Type of authorization that the User has ? Delete/inset/modify/read ? Inset/modify/read ? Modify/read ? Read ? Not authorized BaaN Tools Authorizations ? Cond. ? the sequence number of the condition if the expression consists of multiple condition ? Sern ? the sub-expression number within the condition ? Field ? the field name used in the condition ? Operator ? the operands which can be used in the condition ? Value 1 ? the value of the field for which the condition will be applicable BaaN Tools Authorizations ? Value 2 ? the value of the field for which the condition will be applicable ? this field will be used only if a range of values are to be specified ? And/Or/End ? indicates the operator linking two conditions BaaN Tools Authorizations ? Table Field Authorizations (ttaad4133m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Field Name ? indicates the field name in a Table for which the authorization is to be given ? Authorization Indicator ? indicates the Type of authorization that the User has ? Write/read ? Read ? Not authorized BaaN Tools Authorizations ? Table Field Data Authorizations (ttaad4135m000) ? User ? the BaaN Normal user to whom the access is to be given ? All Companies ? indicates if the Authorization is applicable for all the Companies ? Company ? indicates the Company to which the Authorization is to be given ? this field is to be used only when the authorization has to be given to a particular Company BaaN Tools Authorizations ? Table Field ? indicates the field name in a Table for which the authorization is to be given ? Data Authorization ? indicates the Type of authorization that the User has ? Write/read ? Read ? Not authorized BaaN Tools Authorizations ? Cond. ? the sequence number of the condition if the expression consists of multiple condition ? Sern ? the sub-expression number within the condition ? Field ? the field name used in the condition ? Operator ? the operands which can be used in the condition ? Value 1 ? the value of the field for which the condition will be applicable BaaN Tools Authorizations ? Value 2 ? the value of the field for which the condition will be applicable ? this field will be used only if a range of values are to be specified ? And/Or/End ? indicates the operator linking two conditions BaaN Tools Authorizations ? User Authorizations by Company (ttaad2120m000) ? Company ? indicates the Company on which the Authorization is to be given to different Users ? User ? the BaaN Normal user to whom the access is to be given BaaN Tools Authorizations ? Company Authorizations by User (ttaad2121m000) ? User ? the BaaN Normal user for whom the Company authorizations are to be given ? Company ? indicates the Company number to which the user will have access BaaN Tools Version Release Customization V-Version, R-Release, C-Customization ? Version Important functional changes ? Release Enhancements & changes to previous release ? Customization Company initials with phase indications BaaN Tools Version Release Customization ? BaaN 4GL - Event Driven language ? Develop Complete New Applications ? New Tables and Sessions ? Customize the BaaN Applications ? Company-specific Terminology ? Company-specific Layouts of Screens and Prints BaaN Tools Version Release Customization ? VRC Concepts ? VRCs are as per Packages (tc B40 b2) ? Software Components: Forms/Reports/Menus/Scripts ? Session Coding: ? m000 ? abc forms table number ? x: 1=Maintain, 4=Print, 5=Display, 2=Processing ? VRC Coding: ? BaaN Tools Version Release Customization ? Benefits of VRC ? Standard VRC remains unchanged ? Component duplication is avoided ? Same BaaN IV environment for developing, testing, installing, and running an application ? Company defined forms, menus, reports, etc. ? User authorizations per VRC ? Customization retained after upgrade BaaN Tools Version Release Customization BaaN Tools Version Release Customization BaaN Tools Version Release Customization BaaN Tools Version Release Customization BaaN Tools Version Release Customization Package Combination & Company BaaN Tools Version Release Customization Package Combination & Company BaaN Tools Version Release Customization ? Consists of several packages but only one VRC of a particular package Package Combination: 30Obcus Pack. Ver. Rel. Cus. Description td B4.0 b BaaN IV Distribution ti B4.0O b cus BaaN IV Manufacturing tf B4.0O b BaaN IV Finance BaaN Tools Version Release Customization ? VRC Procedure Steps ? Step 1: Specify the packages ? Step 2: Specify the VRCs ? Step 3: Specify the package combination ? Step 4: Combine VRCs into the package combination ? Step 5: Review the result BaaN Tools Version Release Customization ? Package combination Creation ? Maintain Package VRC ? Maintain Directories of Software Components ? Maintain Package Combinations ? Maintain Packages by Package Combination ? Maintain Companies BaaN Tools Version Release Customization BaaN Tools Version Release Customization Maintain Package VRC’s (ttadv1111m000) ? Package ? the Package whose VRC is to be made ? Version ? identifies the upgrade of the package ? each change in the functionality results in a new version ? Release ? this indicates an update within the version ? Customer ? the required customer extension ? this field is used when customizations are made to the package BaaN Tools Version Release Customization Maintain Package VRC’s (ttadv1111m000) ? Description ? the description of the Package VRC ? Status ? indicates whether the VRC is being developed/released/expired ? Derived from Version, Release, Customer ? specify the VRC from which the current VRS is being derived ? Integration with Package VRCs in Pack.Combination ? indicates the Package Combination to which this VRC is linked BaaN Tools Version Release Customization Maintain Directories of Software Components (ttadv1115m000) ? Package ? the Package whose VRC is to be made ? VRC ? the VRC of the Package listed above ? Software comp. ? the software components for which a directory is to be created ? Forms, Menus, Objects, Program Scripts, Functions, Report Scripts ? Path on System ? the path where the directory will be made BaaN Tools Version Release Customization Maintain Package Combination (ttaad1120m000) ? Package Combination ? the name of the Package Combination in which the Package VRCs will be linked ? Description ? the description of the Package Combination ? Table Definition Path ? the path of the Data Dictionary where the table definitions will be stored ? Table Def. In Shared Memory ? indicates whether the table definitions and the domains should be loaded in shared memory BaaN Tools Version Release Customization Maintain Packages by Package Combination (ttaad1121m000) ? Package Combination ? the name of the Package Combination in which the Package VRCs will be linked ? Package ? the name of the Package ? Version ? the version of the Package ? Release ? identifies the upgrade of the package ? Customer ? the required customer extension BaaN Tools Job Management Maintain Job Data (ttaad5100m000) ? Job ? indicates the code of the Job ? Description ? the description of the Job ? User ? indicates the BaaN user who has created the Job ? Creation date ? indicates the date of creation of Job ? Periodical ? indicates whether the Job is executed repeatedly or one-time BaaN Tools Job Management Maintain Job Data (ttaad5100m000) ? Job waiting after Execution ? indicates if the Job has to be activated manually or automatically at the next execution preiod ? Calendar ? indicates the code of the Calendar which is attached to the Job ? Period ? indicated the period unit for the Job ? Minutes, Hours, Days, Weeks, Months ? Finish Date ? indicates the last date of execution of the Job BaaN Tools Job Management Maintain Job Data (ttaad5100m000) ? Next Execution Date ? indicates the date and time when the Job has to be executed ? Maximum Duration ? the maximum duration of execution of the Job ? Status ? indicates whether the Job is Free / Blocked / Waiting BaaN Tools Job Management Maintain Calendars (ttaad5106m000) ? Calendar ? the code of the Calendar ? Description ? the description of the Calendar BaaN Tools Job Management Maintain Dates by Calendars (ttaad5107m000) ? Calendar ? the code of the Calendar ? Date ? the date for Execution of the Job ? Time ? the time for Execution of the Job BaaN Tools Database Management Maintain Database Definition (ttaad4110m000) ? Database ? indicates the code of the database ? Description ? indicates the description of the database ? System Name ? the name of the system where the database has been located ? Database Type ? indicates the type of the database ? BaaN Base, Informix, Oracle7, DB2/6000 BaaN Tools Database Management Maintain Database Definition (ttaad4110m000) ? Parameter ? the parameter(s) required if the database is other than BaaN Base ? e.g. ORACLE_HOME, ORACLE_SID ? Force to Read ? to be used in case of another database or database type ? Audit Trail ? indicates whether an Audit Trail is applicable to the database BaaN Tools Database Management Maintain Table Directories (ttaad4115m000) ? Table Selection ? Specified tables/Tables in Module/All (other) tables ? Table ? the name of the table ? All Comp ? indicates if the selection is done for all the companies ? Company ? indicates the company number ? Path Name ? indicates where the table definitions will be stored in the system BaaN Tools Database Management Create Sequential Dump of Tables (ttaad4226m000) ? Company, From To ? the range of the companies whose data is to be dumped ? Package, from To ? the range of the packages whose dump is to be taken ? Table, From To ? the range of the tables whose data is to be dumped ? Basic Name for Dump Files ? indicates the name of the file which wil be created after the dump ? Name of the Error File ? name of the error file, if errors occur during dumping BaaN Tools Database Management Create Table from Sequential Dump (ttaad4227m000) ? Create Tables for Different Company ? indicated the company for which the tables are to be created ? Create Rows before Index ? indicates if the rows are to be created first and then the indices ? Ignore Referential Integrity Constraints ? this will indicate whether to ignore any tables which will be created at a later instance of the dump ? Name of the Dump file ? indicates the name of the file from which the tables will be created BaaN Tools Audit Management Assign Tables to Database (ttaad4111m000) ? Table selection ? Specified table/Tables in module/all (other)tables ? Table/Module ? enter the Table/Module name here ? All Comp ? indicates if the Audit Trail is applicable to all the companies or not ? Company ? if All Comp is not specified then enter the Company number to which the Audit Trail is applicable ? Database ? the database where the Audit Trail is applicable BaaN Tools Audit Management Maintain Audit Information File (ttaad4160m000) ? Table ? the table which is to be Audited ? Company ? the company for which the Audit Trail is applicable ? From Seq Curr Seq To Seq ? indicates the sequence number of the Audit file ? Security ? Print/Purge/Maintain/Application Defined ? Max file size ? the size of the Audit File (1048576 - 20971520) ? Terminate current sequence ? indicated whether the current seq. is to be terminated BaaN Tools Audit Management Further Steps ? Exit out of the System ? Login in to the system ? Make Change to the Table specified in the Audit Trail ? Print Range of Audit Files (ttaad4461m000) BaaN Tools Maintain Menus (ttadv3160m000) ? Language ? the language of the Menu ? Package ? the package in which the Menu will be modified ? Module ? the module in which the Menu will be modified ? Sequence Number ? the sequence number the Menu ? Description ? the description of the Menu BaaN Tools Maintain Menus (ttadv3160m000) ? User ? the user who has modified the Menu ? Expired ? indicates if the validity of the Menu has expired ? Help Text Code ? the code of the help text to be attached to the Menu ? Edit (button) ? used for editing the Menu ? Dump Menu (button) ? used for dumping the modified Menu BaaN Tools Maintain Forms(ttadv3100m000) ? Language ? the language of the Form ? Package ? the package in which the Form will be modified ? Module ? the module in which the Form will be modified ? Form ? the code of the report ? Description ? the description of the report BaaN Tools Maintain Forms(ttadv3100m000) ? Short Descript. ? a short description for the Form ? Form Type ? the type of Form ? the following four types are possible ? single-occurrence with main table ? multi-occurrence with main table ? multi-occurrence with view fields ? single occurrence ? Option set ? indicates the sequence within the type BaaN Tools Maintain Forms(ttadv3100m000) ? User ? the user who has modified the Form ? Help Text Code ? the code of the help text to be attached to the report ? Date ? the date on which the modification was made ? Graphical Form ? indicates if the form will be used in a graphical environment BaaN Tools Maintain Forms(ttadv3100m000) ? Edit Form (button) ? used to activate the Form Editor ? Dump (button) ? used for dumping the form definition in the database after modification ? a modified form has to be dumped in order to replace the existing changes BaaN Tools Maintain Reports (ttadv3130m000) ? Language ? the language of the report ? Package ? the package in which the report will be modified ? Module ? the module in which the report will be modified ? Report ? the name of the report ? Description ? the description of the report BaaN Tools Maintain Reports (ttadv3130m000) ? User ? the user who has modified the report ? Date ? the date on which the modification was made ? Report size ? the layout size of the report ? Script Present ? indicates if any report script exists for the report ? Help Text Code ? the code of the help text to be attached to the report BaaN Tools Reports - Input Fields ? Field Name ? the name of the field which is to be printed on the report ? Depth ? the height of the field in terms of lines ? Domain ? the domain in the database to which this field belongs ? Sort Mode ? indicates how the field will be sorted while generating the report ? Sort seq ? the sorting sequence of the fields in the report BaaN Tools Reports - Layouts ? Layout ? indicated the area on the report where the field should be printed ? Field Name ? the name of the field which is to be printed on the report ? No. ? the layout number ? Output Expr. ? used for conditional print ? Ft ? font of the report BaaN Tools Reports - Layouts ? Page ? indicates if the report layout has to be printed on a new page or not ? Nd ? how many extra lines are needed for the layout on the same page ? Edit Layout ? used for editing the layouts made for the report BaaN Tools Maintain Queries (ttadv3180m000) ? Query ? the code of the Query ? Owner ? if left blank then any other user can also modify the Query ? Description ? the description of the Query ? Created by ? the User who has created the Query ? Date ? the date on which the Query was made BaaN Tools Maintain Queries (ttadv3180m000) ? Output Type ? the type of Query output ? Report ? the name for the report which will be generated by the Query ? Print Options ? the size of the report to be generated ? Column label ? the width of the column label ? Row label ? the height of the label BaaN Tools Maintain Queries (ttadv3180m000) ? Easy SQL (button) ? used for selecting the tables and table fields for the Query ? Text Manager (button) ? used for entering the SQL Query ? generated automatically ? Run Query (button) ? used for executing the Query