MYOB Exo Business Creditors
List of entities
Entity details
NamePrimary key columnsNumber of columnsComment
CONTACTSSEQNO68This table contains information about Contacts.
CR_ACCGROUP2SACCGROUP3This table stores the Secondary Groups for Creditors (a grouping on top of the primary grouping - see CR_ACCGROUPS).
CR_ACCGROUPSACCGROUP3This table stores the Primary Groups for Creditors (the finer level of grouping - compare CR_ACCGROUP2S).
CR_ACCSACCNO83This table contains information about Creditor accounts.
CR_ALLOCATIONSSEQNO, ALLOCNO11This table stores details of Creditor allocations.
CR_CONTACTSSEQNO55This table contains details of Contact records that are associated with Creditor accounts. Contact details are taken from the relevant entry in the CONTACTS table.
CR_CONT_HISTSEQNO14This table contains information about the History Notes attached to Creditor accounts.
CR_INVLINESSEQNO53This table contains line information for all Creditor transactions.
CR_INVLINES_SERIALSSEQNO4This table contains details of serial numbers on Creditor Invoice lines.
CR_LISTSLIST_NO2This table defines the members of the Account Lists used by the Creditors Payment Processor.
CR_LIST_NAMELIST_NO2This table defines the Account Lists used by the Creditors Payment Processor.
CR_PRICESSEQNO12This table contains information on Creditor price rules.
CR_TRANSSEQNO58This table contains header information for all Creditor transactions.
CURRENCIESCURRENCYNO10This table contains details of all currencies used in the EXO Business system.
GLACCSACCNO20This table contains details of all General Ledger accounts.
NARRATIVESSEQNO2This table contains the narratives attached to transactions.
PERIOD_STATUSSEQNO18This table contains details of the age periods set up in the system.
PURCHORD_HDRSEQNO38This table contains header information for all Purchase 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.