Name | Primary key columns | Number of columns | Comment |
CONTACTS | SEQNO | 68 | This table contains information about Contacts. |
CR_ACCGROUP2S | ACCGROUP | 3 | This table stores the Secondary Groups for Creditors (a grouping on top of the primary grouping - see CR_ACCGROUPS). |
CR_ACCGROUPS | ACCGROUP | 3 | This table stores the Primary Groups for Creditors (the finer level of grouping - compare CR_ACCGROUP2S). |
CR_ACCS | ACCNO | 80 | This table contains information about Creditor accounts. |
CR_ALLOCATIONS | SEQNO, ALLOCNO | 11 | This table stores details of Creditor allocations. |
CR_CONTACTS | SEQNO | 55 | This 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_HIST | SEQNO | 14 | This table contains information about the History Notes attached to Creditor accounts. |
CR_INVLINES | SEQNO | 53 | This table contains line information for all Creditor transactions. |
CR_INVLINES_SERIALS | SEQNO | 4 | This table contains details of serial numbers on Creditor Invoice lines. |
CR_LISTS | LIST_NO, ACCNO | 2 | This table defines the members of the Account Lists used by the Creditors Payment Processor. |
CR_LIST_NAME | LIST_NO | 2 | This table defines the Account Lists used by the Creditors Payment Processor. |
CR_PRICES | SEQNO | 12 | This table contains information on Creditor price rules. |
CR_TRANS | SEQNO | 58 | This table contains header information for all Creditor transactions. |
CURRENCIES | CURRENCYNO | 10 | This table contains details of all currencies used in the EXO Business system. |
GLACCS | ACCNO | 20 | This table contains details of all General Ledger accounts. |
NARRATIVES | SEQNO | 2 | This table contains the narratives attached to transactions. |
PERIOD_STATUS | SEQNO | 18 | This table contains details of the age periods set up in the system. |
PURCHORD_HDR | SEQNO | 38 | This table contains header information for all Purchase Orders. |
STAFF | STAFFNO | 36 | This 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_ITEMS | STOCKCODE | 85 | This table contains details of all stock items. |
TAX_RATES | SEQNO | 8 | This table contains all tax rates used by the system. |