GSE Scale Systems - 201
Chapter 20 Database (OPTION) Technical Reference Manual
Chapter 20 Database (OPTION)
20.1 Database Option
(24K Module, GSE Part #: 200550-00TD1)
(120K Module, GSE Part#: 200550-00TD2)
This section describes what applications can be
accomplished with the Database Option, Installation of
this option, and Operation of the Database Option once it
has been installed.
The 574 will accept a 24K or 120K RAM data storage
module. The GSE part numbers are 200550-00TD1 and
200550-00TD2 for the 24K RAM and 120K RAM
respectively. Each of these modules has the battery
backed Time / Date feature.
20.2 Database Applications
DATABASES may be used for several different reasons.
Some of the most popular weighing applications include
use as a Transaction Recorder, Part Number Look-Up,
Quantity on Hand, and Batch Formula Lookup.
Transaction Recorder
Every weighing operation which occurs on the scale is
stored to memory with information regarding other
pertinent data. This may include time / date, employee
ID, job number, part number, nubmer of boxes, customer
number, etc...
Normally this type of application would "Make Rows"
only. Data would never be recalled. A report would be
sent to a computer or printer at the end of the shift, day
or week. Then the data would be deleted.
Part Number Look-Up
When a part is weighed, the part number is keyed in.
Information about the part such as description, bin
location, etc ... is recalled from the DATABASE. The
information is used to print a label which is placed on the
part. This same concept can be used to recall name and
address based upon customer ID.
Quantity On Hand
The DATABASE can be used to keep track of inventory
levels of various products which are based on weight (or
quantity with the Model 570/574 units). When an item
number is keyed in, the current amount on hand is
recalled into the Gross or Net total register. Then an add
or subtract accumulation operation is performed,
depending on whether an amount is being taken from or
added to stock. Then the row is updated with the revised
amount on hand. Using a Var for a “safety stock level” a
buy report could be generated based on the amount on
hand compared to the safety stock amount. Another
DATABASE could also be used to keep track of the
amounts on order.
Batch Formula Lookup
Many applications require that certain proportions of
various ingredients be mixed together when mixing a
batch or formula. The DATABASE can store the
amounts of each ingredient for a formula, either in terms
of a fixed amount or as a percentage of the total batch
size. One column of the database could contain the
number of the setpoint which needs to be activated to
supply the required ingredient.
Certainly there are many other possible uses for the
DATABASE option. And since up to 16 DATABASES
may be used, several different uses may be combined in
one installation.
20.3 What is a Database?
A database is a collection of useful information
organized in a specific manner. For instance you can
view a telephone directory as a database:
Name Telephone Number Address
Name 1 Telephone Number 1 Address1
Name 2 Telephone Number 2 Address2
Name 3 Telephone Number 3 Address3
Name 4 Telephone Number 4 Address4
Several terms used in this section on Database are
defined below:
FIELD: A parameter type, or column name.
For instance the field "Name 1" or
"Name 2" refers to the data stored in
the column defined as Name in the
above example.
RECORD: One row of a database. A collection of
fields as defined by the columns of a
database. In the above example, one of
the four records shown includes Name
2, Telephone Number 2 and Address 2
fields.
SECTION - 20.3
To Next Page
Loading...