Table Maintenance functions allow you to control
settings related to the operation of RASWIN.
Each system table is described in detail in the following sections
of the manual.
A list of tables will be displayed showing all the tables which
your
security level allows you to maintain.
The example below shows many of the tables in the system.
Your location may have all of these, or additional ones,
or may have just some of them depending on your particular
installation configuration.
Proper setting of the security level
in the table names table permits you to
maintain those
tables that should be changed but will prevent you from changing
those
that should not be changed.
Click on the line containing the specific table you wish to
maintain. RASWIN will load the existing data from that table
into
a spread-sheet type grid which you can use to edit the existing
data or to
add or delete records from the table, for example:.
RASWIN tables are listed in the
Index.
You can click on any of the specific tables shown there and see a description of the information contained in
the
table and the purpose for each field.
This option will display a screen that details the fields and properties of each data element in each RASWIN
table.
The screen will look like this:
The left side of the screen will show the tables in the database. When you click on one of these, the fields and
their properties will show on the right side. This information can be useful if you are creating your own
reports with Crystal Reports or some other reporting writing tool.
Scheduled Maintenance Setup
There will be times when you need to make adjustments to certain table values such as preset prices associated
with
specific trancodes, account numbers, etc., on a given date. For example, suppose the price of photocopies is due
to
increase on July 1st, going from 20 cents per page to 25 cents per page. By setting up a SCHEDULED MAINTENANCE
action in advance you can make this happen automatically on the effective date.
The screen will look like this:
SCHEDULED MAINTENANCE only allows updating of existing records.
It contains safeguards against certain SQL functions, such as CREATING, ALTERING or DROPPING
tables or views, DELETING data, etc.
It is not complicated to use, but it can be a bit confusing at first. If you need to know more about how to use
this
screen, please contact Quadrant support for details.
This function allows you to run short SQL scripts to update the database. These might include creating or
adjusting existing tables, views, or stored procedures and loading data from an external source. Normally,
Quadrant Support will provide you with the required script file, or may direct you where to go on our web
site
to download the file. Once the file is available to you, importing it is a simple matter of using the
Update Database Structure function. Watch the video below for instructions on how to use this function.
A list of tables will be displayed showing all the tables which
your
security level allows you to maintain.
The example below shows many of the tables in the system.
Your location may have all of these, or additional ones,
or may have just some of them depending on your particular
installation configuration.
Proper setting of the security level
in the table names table permits you to
maintain those
tables that should be changed but will prevent you from changing
those
that should not be changed.
RASWIN tables are listed in the
Index.
You can click on any of the specific tables shown there and see a description of the information contained in
the
table and the purpose for each field.
The left side of the screen will show the tables in the database. When you click on one of these, the fields and
their properties will show on the right side. This information can be useful if you are creating your own
reports with Crystal Reports or some other reporting writing tool.
