MYOB Exo Business Debtors
List of entities
Entity details
NamePrimary key columnsNumber of columnsComment
CAMPAIGN_WAVESEQNO19This table contains details of all campaign waves setup in EXO Business CRM.
CONTACTSSEQNO68This table contains information about Contacts.
CURRENCIESCURRENCYNO10This table contains details of all currencies used in the EXO Business system.
DR_ACCGROUP2SACCGROUP3This table stores the Secondary Groups for Debtors (a grouping on top of the primary grouping - see DR_ACCGROUPS).
DR_ACCGROUPSACCGROUP3This table stores the Primary Groups for Debtors (the finer level of grouping - compare DR_ACCGROUP2S).
DR_ACCSACCNO90This table contains information about Debtor accounts.
DR_ADDRESSESSEQNO9This table stores the additional delivery addresses for a Debtor account. These are used in places like Sales Orders, where the user can select a delivery address for the order.
DR_ALLOCATIONSSEQNO, ALLOCNO11This table stores details of Debtor allocations.
DR_CONTACTSSEQNO56This table contains details of Contact records that are associated with Debtor accounts. Contact details are taken from the relevant entry in the CONTACTS table.
DR_CONT_HISTSEQNO14This table contains information about the History Notes attached to Debtor accounts.
DR_INVLINES56This table contains line information for all Debtor transactions.
DR_INVLINES_SERIALSSEQNO4This table contains details of serial numbers on Debtor Invoice lines.
DR_PRICEGROUPSGROUPNO3This table stores details of all Debtor Price Policy Groups. These are set up in the EXO Business Configurator at Admin > Debtors > Debtor Price Policy Groups.
DR_PRICESSEQNO16This table contains information on Debtor price rules.
DR_PRICE_POLICYPOLICY_HDR11This table contains information on Debtor price policies.
DR_PRICE_POLICY_ACCSEQNO4This table defines the members of Debtor price policies.
DR_TRANSSEQNO78This table contains header information for all Debtor transactions.
GLACCSACCNO20This table contains details of all General Ledger accounts.
NARRATIVESSEQNO2This table contains the narratives attached to transactions.
OPPORTUNITYSEQNO30This table contains details of all Opportunities used by the EXO CRM module.
PAYMENT_TYPESPTNO43This table contains details of all Payment Types.
PERIOD_STATUSSEQNO18This table contains details of the age periods set up in the system.
SALESORD_HDRSEQNO55This table contains header information for all Sales Orders.
STAFFSTAFFNO39This table stores details of all EXO Business staff members. These are the people who are authorised to log in to and use the EXO Business system.
STOCK_ITEMSSTOCKCODE85This table contains details of all stock items.
TAX_RATESSEQNO8This table contains all tax rates used by the system.