SANDMAR
RM6000 Database Manager
Authorised access
to add, enquire, delete or amend all principle information within
the system is achieved via DataBase Manager. Data entry forms are
designed to be secure, fast, flexible and efficient, with helpful
prompts to aid the occasional system user.
The database
software used by RM6000 is Sybase SQL
Anywhere. This relational database system offers full client / server
operations.
The product
database can be designed by the user to meet the organisational
needs of the business environment, thereby enabling meaningful information
to be retrieved to monitor company performance. To assist in configuring
the database and reporting information quickly, a user defined product
classification system can be employed. Up to 24 levels are permitted
within the classification system for a single company. The classification
system provides 6 levels to define a business structure such as
department and group; 12 levels to define the unique characteristics
of the product such as style, colour, size and a further 6 areas
to cover additional information such as Season, fabric or country
of origin. Where multiple companies exist within the organisation,
then different product classifications can be classified enabling
reports to be produced based upon common characteristics. The number
of levels used within the classification can be determined by the
user, thereby enabling a simple, or complex product database to
be created. This level of classification allows the ability to monitor
stock valuation, sales performance etc. within very flexible, user
defined categories. The RM6000 system
can contain unlimited classification systems.
RM6000
can be installed using the Classification Wizards to aid in the
initial set-up, for example, countries, colours, sizes, weights
etc.
To assist in
the speedy entry of product details, a Rapid Data Entry module is
available which enables pre-defined data to be duplicated between
product records. Data can also be input via a GRID where the majority
of product details are common. This is typically useful in the Fashion
environment where colour and size vary by Style number. The Rapid
Data Entry system can automatically create product codes based upon
pre-set configurations, or by combinations of colour, size etc.
Database Manager
offers a wide variety of screen based information to aid in management
decision making. Information such as, sales history on any product,
or sales assistant performance is available at all times.
Database Manager
holds all current files on magnetic disk. The disk can either be
an integral component of the computer being used to run the RM6000
software, or
files can be held on a Database Server attached to the user's computer
or terminal, via a Local Area Network.
At a Head Office
system, data for all locations is available.
Details of Principle
Files held within Database Manager
The following
list details the key base data tables which are maintained through
Database Manager.
|
|
Customer account data. An account customer
can be assigned to several accounts and several account customers
can be assigned to a single account.
|
|
|
Budgets can be maintained to control
purchasing expenditure. Full ‘Open to Buy’ facilities
are maintained.
|
|
|
Cost prices can be based on an average
cost, or last cost. Cost prices may be adjusted to account
for import cost using the Shipment module.
|
|
|
There is no limit to the number of currencies
that can be in operation throughout the system. All historic
data can be stored in up to three currencies.
|
|
|
Four types of customer are recognised
by the system. Cash customers, Credit Account customers, Cash
on Delivery and Corporate Entities. Customers can be members
of corporate groups such as clubs, or loyalty schemes. Historic
information such as what each customer, or corporate group
have purchased and the level of sales revenue are maintained.
|
|
|
Discounts can be applied to specific
customers, or corporate groups of customers. Discounts can
apply to specific products, or product categories
|
|
|
Currency exchange rates can apply to
both purchases and sales.
|
|
|
Inventory information relating to the
current stock holding is stored.
|
|
|
The location of inventory is monitored
from a corporate position, down to a specific bin location.
|
|
|
RM6000
Business location data is held differentiating the role of
locations, E.G. Sales Branches, Warehouses, Regional Offices
etc.
|
|
|
Customer loyalty schemes can be created
& customers attached to them. Loyalty can be based upon
points or spend discounts.
|
|
|
Manufacturer data is held to identify
who produces the specific products.
|
|
|
Credit / Debit Cards data. Uplift surcharges
and floor limits can be determined for each card, or sales
location.
|
|
|
Base product data. All known information
can be stored about a product. The historic data can be stored
indefinitely.
|
|
|
Each product can have many alternative
descriptions. This data is used where a product is sold in
different countries and different descriptions are required
at the Point of Sale.
|
|
|
Discounts can be applied to products
as Quantity Breakpoints, Value Breakpoints and Multi-Buys.
|
|
|
Product component data can identify
products that can be sold as a complete unit, or individually.
|
|
|
Product information can be stored in
comprehensive user defined classification systems. This system
enables users to identify a product by several alternative
descriptors. E.G. Style, model etc.
|
|
|
Product selling price data including
pending price changes, or promotions.
|
|
|
Suppliers source data is held to identify
who can supply the specific products. A product can be supplied
by multiple suppliers.
|
|
|
Sales tax type and values. The system
will hold multiple sales taxation models, which may apply,
in different countries.
|
|
|
Time periods data. Many time periods
can be established for different users. E.G. Accounting periods,
Merchandising Seasons, Sales periods etc.
|
|
|
All transactions including: Sales, inventory
movements, purchases price changes etc., are recorded throughout
the system and stored within an audit table.
|
|
|
Products can be measured in single units,
or any range of weights, lengths etc.
|
|
|
Unique identity numbers can to be stored
with a product. E.G. Electrical goods can have serial numbers
registered at the goods received location and at the point
of sale. The specific product can then be tracked throughout
its time within the business.
|
|
|
Multiple bar codes can be held against
a single product.
|
|
