D – Metadata {appendix}

DUO adds metadata to your MYOB Exo database to provide additional functionality in the DUO application. It does this in a way which is consistent with MYOB Exo. Obviously DUO also references standard MYOB Exo metadata as well. DUO ensures following metadata exists in your database and creates it if not.

DUO Tables

Table name

Description {Essentials}

DUO_SECURITY

Licensing and software version information.

DUO_DBUPDATE

A log of metadata changes from DUO DBupdate

DUO_ENTITY

Defines entities (data sources)

DUO_CONTRAINT

Defines column validation constraints

DUO_FORM

Defines a screen in DUO

DUO_FORM_FILTER

Defines search filters for a screen

DUO_FORM_FILTER_GROUP

Groups filters to a single screen control e.g. ComboBox

DUO_FORM_TAB

Page-tabs for a screen

DUO_FORM_WIDGET

Defines the widgets included for a screen

DUO_WIDGET_SECURITY

Defines valid Security Profiles for widget

DUO_HIST_NOTE

Stores History Notes for non-Exo entities

 

Description {Warehouse}

SHIPMENT_HDR_ARCHIVE

Archive of IWG shipment headers

SHIPMENT_COST_DETAILS_ARCHIVE

Archive of IWG shipment cost lines

INWARDS_GOODS_ARCHIVE

Archive for IWG headers

INWARDS_GOODS_COSTS_ARCHIVE

Archive for IWG costs

INWARDS_GOODS_LINES_ARCHIVE

Archive for IWG lines

 

Description {Sales}

DUO_QUOTE_REVISION

Revision headers by quote ID and revision code 

DUO_QUOTE_REVISION_LINES

Revision lines

DUO_STOCK_LOAN

Stock Loan Headers

DUO_STOCK_LOANLINES

Stock Loan Lines

DUO_STOCK_LOANTYPE

Stock Loan Types

DUO_STOCK_LOAN_ARCHIVE

Archive of Stock Loan Headers

DUO_STOCK_LOANLINES_ARCHIVE

Archive of Stock Loan Lines

 

Description {Purchasing}

DUO_STOCKREQUIREMENT_RULES

Defines multiple stock requirement calculations

 

DUO Views

View name

Description {Essentials}

DUO_COMPANIES

A full field view of companies (DR&CR_ACCS+PROSPECTS)

DUO_CONTACTS

A flattened view of contacts by company

DUO_COY_TRANS

A flattened view of DR_TRANS + CR_TRANS by company

DUO_PERIODS

A flattened view of Exo period control info

VW_DUO_CONSTRAINT

Inherits Entity properties for Entities in DUO_CONSTRAINTS


 

DUO Table Columns

Table name

Description {Essentials}

COMPANY_TYPES.DUO_COLOUR

e.g Green or Red for Debtor or Creditor

CONTACTS.ROLES

Indicates if the contact has multiple roles

DR_CONTACTS.TITLE

This is used as a role title (old Exo column)

DR_CONTACTS.DIRECTPHONE

This is used as a role phone (old Exo column)

DR_CONTACTS.EMAIL

This is used as a role email (old Exo column)

DR_CONTACTS.ISACTIVE

Indicates if this role is still active (old Exo column)

CR_CONTACTS.TITLE

This is used as a role title (old Exo column)

CR_CONTACTS.DIRECTPHONE

This is used as a role phone (old Exo column)

CR_CONTACTS.EMAIL

This is used as a role email (old Exo column)

CR_CONTACTS.ISACTIVE

Indicates if this role is still active (old Exo column)

PROSPECT_CONTACTS.TITLE

This is used as a role title (old Exo column)

PROSPECT_CONTACTS.DIRECTPHONE

This is used as a role phone (old Exo column)

PROSPECT_CONTACTS.EMAIL

This is used as a role email (old Exo column)

PROSPECT_CONTACTS.ISACTIVE

Indicates if this role is still active (old Exo column)

LEDGENDS. DUO_BCOLOUR

Background Colour for DUO Grid Legends

LEDGENDS. DUO_FCOLOUR

Foreground Colour for DUO Grid Legends

LEDGENDS. DUO_TCOLOUR

Title Colour for DUO Grid Legends

LEDGENDS. DUO_OBJ_IMGX

Object Image for DUO Grid Legends

LEDGENDS. DUO_LNK_IMGX

Link Image for DUO Grid Legends

PURCHORD_HIST.NOTE

Adds History Notes to POs and IWGs

PURCHORD_HIST.SUBJECT

Adds History Notes to POs and IWGs

 

Description {Warehouse}

MANIFESTS.DUO_COURNO

Link to the courier definition COURIERS.SEQNO

MANIFESTS.DUO_TERMINAL_ID

Allows a manifest instance for a group of workstations

STOCK_ITEMS.DUO_COURNO

Linked courier for this freight category stock item

COURIER_MANIFEST.ADDRESS6

Delivery address line 6 (missing in Exo)

COURIER_MANIFEST.DUO_DELIVERYCOUNT

Delivery count from SALESORDHIST

COURIER_MANIFEST.DUO_TODEPOT

Destination depot - links to COURIER_DEPOTS

COURIER_MANIFEST.DUO_BOXCODE

Boxcode - Links to COURIER_BOX

SALESORD_LINES. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

SALESORD_LINES_ARCHIVE.    DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

SALESORDHIST. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

BSOLP_LINES. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

PURCHORD_LINES. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

PURCHORD_LINES_ARCHIVE. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

PURCHORD_HIST. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

STOCK_REQUESTLINES. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

STOCK_REQUESTLINES_ARCHIVE. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

STOCK_SERIALNOS. DUO_COUR_MANF_SEQ

Links to COURIER_MANIFEST.SEQNO

STOCK_REQUESTS.DUO_COMPANYID

Links to a Company

STOCK_REQUESTS.DUO_CONTACT_SEQNO

Links to a Contact

STOCK_REQUESTLINES.SUP_NOW

For Picklist

STOCK_REQUESTLINES.SEND_NOW

For Picklist

 

Description {Sales}

STOCK_SERIALNOS. DUO_LOANSEQNO

Links to DUO_STOCK_LOANS.SEQNO

STOCK_SERIALNOS. DUO_LOANLINESEQNO

Links to DUO_STOCK_LOANLINESS.SEQNO

DUO Programability

SP or Function name

Description {Essentials}

SP_DUO_GET_LICENCES

Imports file name licences.xml issued by Dyameta Technology Ltd. This file contains all software licensing applicable to both MYOB Exo and DUO. The file is generated by Dyameta from its own client database.

FN_DUO_ONLINE_USERS

Returns data for online users grid in Help > About

FN_DUO_DECODE_TXID

Decodes column TXID found in some transaction tables

FN_DUO_StringSplit

Inputs a string and delimiter string. Returns string rows.

FN_DUO_ATTRIBUTE

A list of column attributes (constants)

FN_DUO_TYPENAME

A list of descriptions such as statuses etc (constants)

 

Description {Warehouse}

FN_DUO_SALESORD_PICKLIST

Used by DUO Despatch to generate a single row per unit quantity from Exo sales orders.

FN_DUO_INWARDS_PICKLIST

Used by DUO Despatch to generate a single row per unit quantity from Exo sales orders.

FN_DUO_TRANSFER_PICKLIST

Used by DUO Despatch to generate a single row per unit quantity from Exo sales orders.

 

Description {Sales}

SP_DUO_CREATE _REVISION

 

Creates or updates a quote revision from an MYOB Exo quote (Sales Order, CRM  Opportunity, Job).

SP_DUO_RESTORE _REVISION

 

Restores a quote revision overloading the quote type it originated from.

 

Description {Purchasing}

FN_DUO_STOCK_REQUIREMENT

Extended version of FN_STOCK_REQUIREMENT

SP_DUO_CALC_STKREQUIREMENT

Extended version of SP_ CALC_STKREQUIREMENT

 

Description {Production}

FN_DUO_WORKSORD_PICKLIST

Used by DUO Despatch to generate a single row per unit quantity from Exo works orders.

FN_DUO_JOB_PICKLIST

Used by DUO Despatch to generate a single row per unit quantity from Exo jobs.

 

DUO Synonyms

There are no synonyms in the DUO Application at this time.  Some other DUO products (such as application bridges) do use synonyms to control database names etc.

For a new installation please copy (not rename) exoDUOBack.xml to exoDUO.xml


 


 

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