DAC Schema Browser

The DAC Schema Browser page displays detailed information about the DAC that is selected on the page, including its relationships with other DACs. The page has a navigation pane with the names of all DACs available in the system, and you can select a DAC to view its details.

If you have the Administrator, Report Designer, or Customizer role, or you have access to the Generic Inquiry (SM208000) form, you can open the DAC Schema Browser by doing one of the following:

Opening a generic inquiry on the Generic Inquiry (SM208000) form and clicking the name of a DAC in the Table Name column on the Tables tab. This opens the DAC Schema Browser for the selected DAC.
Opening an MYOB Advanced form and clicking Tools > DAC Schema Browser on the form title bar. This opens the DAC Schema Browser for the primary DAC of the current form, if the form has one.
Opening the Element Inspector for the needed element and clicking the link in the Data Class box. This opens the DAC Schema Browser for the selected DAC.
Typing <instance_name>/dacBrowser in the address bar of the browser.
Clicking the DAC Schema Browser tile on the main Help Portal page.

The DAC Schema Browser page consists of the following parts, which are shown in the following screenshots:

Search box
DAC navigation menu
Page title bar
Main Information area
Summary and Remarks area
DAC fields
Incoming references
Outgoing references

Figure 1. Parts of the DAC Schema Browser (top of the page)

Figure 2. Parts of the DAC Schema Browser (bottom of the page)

Page Title Bar

The page title bar contains both informational elements and links you can click to quickly navigate to the needed sections of the page. It contains the following elements.


Element	Description
DAC name	The name of the selected DAC.
Tags	Optional. The tags that indicate the properties of the selected DAC (see DAC and Field Tags).
Links to other sections	The Definition, Fields, Incoming References, and Outgoing References links. If you click any of these links, the system scrolls to the corresponding section on the page.
Source Code	A link that you can click to open the source code browser for the selected DAC.
DAC Query	A link that you can click to open a SQL query that the selected DAC executes.
Source Data	A link that you can click to open a new tab with a generic inquiry form showing all the data of the selected DAC. Note: To open this inquiry form, you should have access to the Generic Inquiry (SM208000) form. The columns of the generic inquiry form are displayed on the form in the following order: The identity column of the database table The `DeletedDatabaseRecord` column if it has been added to the database table The key fields The rest of the columns in alphabetical order

Search Box and the DAC Navigation Menu

The left pane of the page contains a Search box and the DAC navigation menu.

The navigation menu has a tree structure in which DACs are listed below their namespaces. Bold type is used for the DAC whose details are being viewed on the page. Initially, all namespaces and DACs defined in the MYOB Advanced instance, including all customization projects published in the instance, are listed, but if you have performed a search, the list includes only the DACs (listed below their namespaces) and namespaces that include the text string you have typed.

You use the Search box to locate a DAC by its name, its display name, or its namespace. You begin typing a text string, and as you type, the system narrows the list in the navigation menu based on the text you have typed. (To view the full navigation menu again, you clear the search box.)

Main Information Area

In this area, you can view the following elements, which may or may not be displayed depending on the type of the selected DAC.


Element	Description
Base DAC	A link to the base data access class. This element appears only if the selected DAC is based on another DAC.
Display Name	The DAC name that is displayed in the error messages and on the forms where user access is managed. This name appears only if an element corresponding to the DAC is displayed on the UI of the current form.
Namespace	The namespace of the selected DAC.
Primary Screens	The list of the forms whose primary view is based on the selected DAC. This element appears only for primary DACs. If you have access to a listed form, its form ID is displayed as a link to the form.
Customization	The customization projects that modify the selected DAC and the links to the customization projects. This element appears for only customized DACs.

Summary and Remarks Area

In this area, you can view a general description of the DAC and remarks about it, if this information has been specified in the XML comments in the code. If a DAC or its field has been added by publishing a customization project, the field description from this project is added under Summary as a separate paragraph, with the link to the customization project.

List of DAC Fields

In the Fields table, you can view the list of all fields of the selected DAC. The fields are sorted alphabetically, except for primary keys, which are always listed at the top of the table. The table contains the following columns.

Note: The elements in these columns may or may not be displayed, depending on the field type.

Table 1. Table Columns
Column	Description
Name	The name of the field, which is also a link that you can click to open the Field Details dialog box. The name may be preceded by a key icon or multiple key icons to indicate that the field is a primary key (yellow key), a foreign key (black key), or both types of keys.
Tag	Optional. The type of the field (see DAC and Field Tags).
Type	The type of the field.
Display Name	The name of the field as it is displayed in MYOB Advanced.
Foreign Reference	The link to the foreign DAC if the current field is a foreign key. When you hover over the link, a tooltip with the full DAC name is displayed.

Table 2. Field Details Dialog Box
If you click a field name in the Fields table, the system opens a dialog box that contains the following elements, which provide details about the field.
Element	Description
Header	A header with the following elements: Field name Type (Field) An optional tag or multiple tags (see DAC and Field Tags)
Display Name	The name of the field as it is displayed in MYOB Advanced.
DAC	The base DAC of the selected field.
Type	The type of the field.
Foreign Reference	The link to the foreign DAC if the current field is a foreign key.
Customization	The customization project or projects that modify the selected DAC. This element appears for only customized DACs.
Summary	A short field description, as specified in the XML comments in the code. For common fields that do not have XML comments specified for them, the system displays annotations.
Remarks	Additional information about the field, as specified in the XML comments in the code.

Incoming References

In this table, you can view the incoming references, which are the DACs that reference the selected DAC.

Table 3. Table Columns
The table with incoming references contains the following columns.
Column	Description
Parent Key Fields	The key field or fields of the selected DAC.
Child DAC	The name of the DAC that references the selected DAC. The name is also a link that you can click to open the page for the child DAC. When you hover over a link, a tooltip with the full DAC name is displayed.
Child Key Fields	The key field or fields that you should use to join the DACs.

Outgoing References

In the Outgoing References table, you can view a list of the outgoing references, which are the DACs that the selected DAC references.

Table 4. Table Columns
The table with outgoing references contains the following columns.
Column	Description
Child Key Fields	The key field or fields of the DAC.
Parent DAC	The name of the DAC that references the selected DAC. The name is also a link that you can click to open the page for the parent DAC. When you hover over a link, a tooltip with the full DAC name is displayed.
Parent Key Fields	The key field or fields that you should use to join the DACs.

DAC and Field Tags

On a DAC Schema Browser page, DACs and their fields can be marked with one tag or multiple tags, which are described in the following table. A tag provides additional information about the type of the DAC or field.


Tag	Description
Obsolete	A deprecated DAC or field.
Nonexistent in DB	A virtual DAC or field (for example, a filter).
Hidden	A hidden DAC or field.
Nested	A nested DAC or field.
Customization	A DAC or field that has been added or modified through the publication of one customization project or multiple projects.
Projection	A projection view DAC.
Accumulator	A DAC with the PXAccumulator attribute.
Cascade Deletion	A field of a DAC with the PXParent attribute.
User-Defined	A user-defined field.
Name-Value	A field of the NameValuePair type that has been added through the publication of any number of customization projects.
Internal	A DAC with the PXInternalUseOnly attribute. Important: Do not use internal DACs in your reports, generic inquiries, or customizations.
Default Navigation	A field with the PXSelector attribute. On a form, the box corresponding to this DAC is displayed as a link that you can click to open the record specified in the attribute.