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. XL Database
M.O.M.XL
is a database application utilizing a
Microsoft SQL Server. In simple terms, that means that all of the
information created and used in the system is stored in a system
that can only be accessed using software fully compatible with
Microsoft's SQL Server and/or utilizing Standard English Query
Language (SQL).
The Files
in the Dictionary
Definitions for fields in the following files of information are
included in the dictionary.
-
CMS - information about each
order.
-
CUST - information about each
customer and prospect.
-
ITEMS - information about each
line item contained on each customer order.
-
JOURNAL - information about the
accounting entries related to orders.
-
ADCOSTS - information about
each advertising source key.
-
STOCK - information about each
stock item and its inventory.
-
PRICE - information about the
retail selling prices for each stock item.
-
BUYPRICE - information about
the buying prices for each stock item.
-
INVOICE - information about
each invoice for each order.
-
SUPPLIER - information about
each vendor for products.
-
TELEMARK - information about
each scheduled or completed telemarketing call.
-
NEW - information about the
associations between composite items (kits) and their composing
items.
-
SUBSCRIP - information about
subscriptions for customers.
-
IMPORT - information
about imported orders.
Element
Definitions
The column
headings in the table include the following:
|
