Entities

These are any metadata objects that return a dataset and can include Tables, Views, Table Functions, and Stored Procedures.

The entities required for a standard install of all DUO modules are predefined. Entities have an ID which starts with ept (e.g. eptStock defines access to table STOCK_ITEMS).

 

Note that DUO replaces some MYOB Exo views with its own (e.g. DUO_COMPANIES rather than COMPANIES. 

The MYOB Exo sources are listed first, then the DUO custom sources.

For databases with a designer licence they can source their own custom tables in the USR entity slots.

 The entity properties are shown here using the eptStock example. 

Field

Description

Class

This is the ID used elsewhere to refer to the Entity Class.

The field is pre-defined and non-editable.

Parent Class

Optionally points at another Entity Class

  e.g. eptSaleOrd points at eptDebtor

Description

A user friendly verbose name

Caption

An abbreviated name

Source

A table, view, table function, or stored procedure name

Alias

An alias used in constructing joins in SQL statements

Filter

Optional WHERE clause to apply to the data source

  e.g. eptDebtor has Source DUO_COMPANIES and filter ACCTYPE=1

Primary Key

The key field(s) used to ID the record

Link To Key

The field other data sources use to kink to this record

  Usually the same as Primary key

  e.g. eptSaleLine has Primary set to SEQNO but Link To set to SOLINEID 

Display Name

The description field used in combo-boxes etc

Param Name

The name used as an SQL parameter in grid  widgets etc

  e.g. WHERE STOCKCODE = @CURRENT_STOCKCODE

Form

Specifies the form definition used when searching (i.e. Select and Close)

Variant

Specifies the variant of the above form {default 0}

Filter

Specifies the filter ComboBox selection in the search form

Obj Lock

The name used for object locks (blank means no lock)

e.g. eptSaleOrd has Order, eptInwardStock has Inwards Goods

Alert Class

The Exo Business Alert Class

  e.g. eptPurchOrd has 5. Save Purchase Order

App ID

The AppID of the DUO or Exo module

Print

A comma separated list of Clarity classes offered on the Print button

Preview

A comma separated list of Clarity classes offered on the Preview button

 

At time of writing the Exo Business Alert Classes are:

Class No

Description

1

Save Sales Order

2

Save Opportunity

3

Save Job Cost Quote

4

Save Job Cost Transactions

5

Save Purchase Order

6

Save Creditor Invoice

7

Save Debtor Invoice

8

Supply Sales Order

9

Save Stock Item

10

Save Debtor Account

11

Save Creditor Account

12

Save GL Account

13

Save Non Account

14

Save Contact

15

Save Servicable Unit

 

The Clarity Classes are listed in MYOB Exo Business Clarity User Guide.pdf. See Command line launch parameter definitions and the /I= parameter.

DUO for EXO     DUO for EXO     © Dyameta Technology Ltd                     Previous Topic           Next Topic           Home