Data
Dictionary
The data
dictionary provides the most complete definitions of every "field"
of information stored in the major files of the M.O.M. system. This
information is particularly helpful when you are creating your own
custom reports outside of the M.O.M. system utilizing R & R
Report Writer.
About the
M.O.M. Database
M.O.M. is
a database application utilizing a FoxPro file structure. In simple
terms, that means that all of the information created and used in
the system is stored in files that can only be accessed using
software fully compatible with Microsoft's Visual FoxPro and/or
utilizing Visual FoxPro ODBC drivers.
The Files
in the Dictionary
Definitions for fields in the following files of information are
included in the dictionary.
-
CMS.DBF
- information about each order.
-
CUST.DBF
- information about each customer and prospect.
-
ITEMS.DBF
- information about each line item contained on each customer
order.
-
JOURNAL.DBF
- information about the accounting entries related to orders.
-
ADCOSTS.DBF
- information about each advertising source key.
-
STOCK.DBF
- information about each stock item and its inventory.
-
PRICE.DBF
- information about the retail selling prices for each stock
item.
-
BUYPRICE.DBF
- information about the buying prices for each stock item.
-
INVOICE.DBF
- information about each invoice for each order.
-
SUPPLIER.DBF
- information about each vendor for products.
-
TELEMARK.DBF
- information about each scheduled or completed telemarketing
call.
-
NEW.DBF
- information about the associations between composite items (kits)
and their composing items.
-
SUBSCRIP.DBF - information about
subscriptions for customers.
-
IMPORT.DBF - information about
imported orders.
Element
Definitions
For each
file, a table is displayed listing each field. The column headings
in these tables are defined as follows.
The column
headings in the table include the following.
-
Position - The numeric
position of the field in the table.
-
Field Name - The XBASE
field name used in programming the information transferred. It
serves to classify data kept in this field.
-
Type - Can be one of 4
types:
Character - Text type data
Numeric - numbers
Date - a date
Logical - True or False
-
Width - The maximum number
of spaces that the field element can occupy.
-
Dec. - For numeric fields
only. The number of decimal places reserved for the numeric value.
This field is not applicable in Comma Delimited format.
-
Description of Field - A
definition of the field's contents. RESERVED signifies for M.O.M.
use only. FUTURE USE signifies that the field may be used in a
future release. UK Only signifies that the field is used for the UK
Edition of M.O.M.
|
