Data Dictionary (DICT) page

Article • 4/10/2026 • 4 min read

The Data Dictionary page enables users to view and manage the structure of database tables, including their fields, data types, descriptions, and other related attributes such as indexes and display settings. Users can view, edit, and configure key information about tables, including fields, data types, captions, browse and look-up order, display settings, and descriptive attributes.

It shows the following key information:

Section	Definition	Example
User Group	Allows for custom settings by group for the table. For example, you can change the captions or browse/lookup order for the Accounting group to be different than the Sales group when viewing the Sales Orders.	EVERYONE, ACCOUNTS
Group Description	Allows the User to understand the specific purpose or role of the user group in relation to the table. It clarifies how the group interacts with or uses the table data.	Accounting team responsible for reviewing financial entries.
Table Name	Internal database table or view name.	INVONHANDLOC
Description	A short explanation of what the table or view represents.	Inventory by Location

Tabs Available:

Tables Tab:

Displays a Notes field for the user to add any information or additional notes about the specific table or view currently selected on the screen.

Fields Tab:

Lists every field (or column) within the selected table.
Displays details about each field in the table or view and allows edits to information about the field.

Field Name	Definition
Field Name	The technical name used by the database. This field is read only.
Type	Data type assigned to the field (Character, Number, Date, etc.). This field is read only.
Length	Maximum allowable size of the data, if applicable. This field is read only.
Caption	A user-friendly display name seen in the UI.
Browse Order	Determines the order of the fields in browsing and list view.
Lookup Order	Sets the order for lookup results.
Case	Defines if the field value must be stored in UPPERCASE or Mixed Case.
Memo	Stores additional notes or detailed descriptions for the field.

Tags Tab:

The Tags Tab is designed to list the primary keys and indexes associated with a specific table or view in Made2Manage (M2M). This information is essential for understanding how the system uniquely identifies and interacts with records across modules.

Field	Definition
Tag Name	A label or identifier used to categorize or group the tag definition.
Key Expression	The actual field(s) or formula used to define the key/index. (Required)
For	Indicates the target object (table or view) the key applies to.
Recovery Tag	Indicates that the tag is used for data recovery purposes. Only one tag should be flagged as recovery.
Type	Classifies the key as Primary, Candidate, or Regular.
Status Bar Description	Text shown on the status bar to describe the purpose or meaning of the key.
Selection Description	A friendly description used when selecting this key in the UI.
Only Show In Screens	Restricts this key to be visible only on specific screens.
Don’t Show In Screens	Prevents this key from appearing on specified screens.

Browse and Lookup Relationships to Database Views

In the ERP system, Views serve as predefined queries or filters that present data from one or more database tables. They simplify data access by allowing users to interact with a consolidated view of data without directly querying tables.

Below is a list of the relevant Views tied to specific Browse Screens and Lookup Behaviors in your system. This relationship clarifies how users interact with data on the front-end (UI) where look-ups and browsing happen within the system.

Browse and Lookup Relationships to Views:

Database View	Associated Screen	Browse and Lookup Configuration
APITEMVIEW	Vendor Invoice & Debit Memo > Item Details [APINV]	View for browsing item details in the Item Details page of Vendor Invoice & Debit Memo [APINV].
APVEND	Vendors [VEND]	View for browsing vendor master.
AYRSVIEW	Accounting Years [AYRS]	View for browsing and selecting accounting years in the system.
FSKITTBLVIEW	Field Kit [KITTBL]	View used to browse and select field kit items for inventory in the Field Service module.
GLCSHMVIEW	Cash Receipts [CASH]	View for browsing cash receipt details in the Accounts Receivable module.
INMAST	Item Master [INV]	View for browsing item master data.
INVONHANDLOC	Inventory OnHand by Location [INVOH]	View used to browse inventory on hand balances by location.
PROBABILITY	Opportunity Management > Probability Lookup [COPP]	View for browsing and selecting opportunity probabilities.
SLCDPM	Accounts [CUST]	View for browsing customer master.
STAGE	Opportunity Management > Stage Lookup [COPP]	View for browsing and selecting opportunity stages.