Name | Primary key columns | Number of columns | Comment |
BILLOMAT_HDR | BILLCODE | 23 | This table contains header information for Bills of Materials (BOMs). |
BILLOMAT_LINES | SEQNO | 6 | This table contains line-level information for Bills of Materials (BOMs). |
BILLOMAT_TEMP | SEQNO | 13 | This table is used in Bill of Materials batch entry. |
CR_INVLINES | SEQNO | 53 | This table contains line information for all Creditor transactions. |
DR_INVLINES | | 56 | This table contains line information for all Debtor transactions. |
GLACCS | ACCNO | 20 | This table contains details of all General Ledger accounts. |
INWARDS_GOODS | SEQNO | 18 | This table contains header information on Inwards Goods transactions. |
INWARDS_GOODS_COSTS | SEQNO | 23 | This table contains information on Inwards Good Costing. |
INWARDS_GOODS_LINES | SEQNO | 48 | This table contains line-level information on Inwards Goods transactions. |
STAFF | STAFFNO | 37 | 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. |
STOCKREQUIREMENT | | 26 | This table contains the data used by the Forecast Based Purchasing feature. |
STOCKTAKE_CTRL | LOCNO | 8 | This table contains information on the status of stocktake locations. |
STOCKTAKE_TOTALS | SEQNO | 21 | This table contains the stock totals entered as part of a stocktake. |
STOCK_CLASSIFICATIONS | CLASSNO | 2 | This table stores the Stock Classifications that are assigned to stock items. |
STOCK_COLOUR | COLOURID | 6 | This table contains details of the colours used by the Style, Colour, Size feature. |
STOCK_GROUP2S | GROUPNO | 12 | This table contains details of Alternate (Coarse) Stock Groups. |
STOCK_GROUPS | GROUPNO | 39 | This table contains details of Primary (Fine) Stock Groups. Note: All fields prefixed with X_ relate to the Style, Colour, Size feature. |
STOCK_ITEMS | STOCKCODE | 85 | This table contains details of all stock items. |
STOCK_LOCATIONS | LOCNO | 14 | This table contains details of all stock locations. |
STOCK_LOC_INFO | STOCKCODE | 6 | This table records stock levels at various locations. |
STOCK_PRICEGROUPS | GROUPNO | 2 | This table stores the Price Groups that are assigned to stock items. |
STOCK_REQUESTLINES | SEQNO | 23 | This table is used by the Stock Transfer Requests feature of the Distribution Advantage module. |
STOCK_REQUESTS | SEQNO | 11 | This table is used by the Stock Transfer Requests feature of the Distribution Advantage module. |
STOCK_REQUESTTYPES | SEQNO | 2 | This table is used by the Stock Transfer Requests feature of the Distribution Advantage module. It stores the Stock Request Types used by stock transfer requests. |
STOCK_SERIALNOS | SEQNO | 45 | This table contains details of serialised stock items. |
STOCK_SIZE | SIZEID | 5 | This table contains details of the sizes used by the Style, Colour, Size feature. |
STOCK_TRANS | SEQNO | 51 | This table records details of all stock transactions. |
STOCK_TRANS_ARCHIVE | SEQNO | 41 | This table is used for archived stock transactions. |
STOCK_TRANS_HDR | SEQNO | 9 | This table contains header information for stock transactions. |
STOCK_WEB | | 3 | This table stores information relating to how stock items should appear on a website, as displayed on the Web tab of the Stock Item Details window. |
SUPPLIER_STOCK_ITEMS | SUPPLIERCODE, ACCNO | 12 | This table contains details of any Alternate Suppliers/Stock Codes set up for stock items. |