Table

Description

ACCPAY

Supplier transaction records, such as supplier invoices and payments.

ALLOC_1

Supplier payment and credit allocations.

ALLOC_2

Customer payment and credit allocations.

ALLOC_3

Supplier expense allocations.

APPOINT

Appointment and to-do list scheduler.

ASROUTE

Assembly routing tasks.

ASSEMBLE

Assembly record details.

ASSHEAD

Assembly parent records.

ASTASK

Assembly standard tasks.

AUDIT_1

Stock item movements audit trail.

AUDIT_2

Delivery docket stock movements audit trail.

AUDIT_3

Transaction audit trail.

AUDIT_4

Stock kits component movements audit trail.

AUDIT_5

Stock delivery/receipt audit trail.

AUDIT_6

Hire manager stock movements audit trail.

BAS

BAS categories.

BONOTES

Back order delivery/shipping notes.

BORDERS

Back Order Control Centre orders undelivered/uninvoiced.

CARRIERS

Shipping carriers.

CENTRE

Cost centres.

CLERKS

Clerk codes.

CMALLOC

Cash management dissections.

CMAUTO

Cash management automatic transactions.

CMBANK

Cash management bank list.

CMDEPLST

Cash management bank deposit list.

CMRECON

Cash management bank reconciliation summaries.

CMTRAN

Cash management transactions.

COMRATE

Staff profiles and commissions.

CONTENTS

Invoice/credit/adjustment/transfer, etc., line item contents.

CQLIST

Cheque run statement batch parent records.

CQLIST_T

Cheque run statement batch transaction details records.

CURRENCY

Currencies and exchange rates.

CUSCAT

Customer categories (Card file/optional).

CUSTREC

Customer master records.

DELZONES

Delivery zones.

DIMCON

Dimension conversions.

EVENTS

Event manager records.

EXPENSE

Expense listing.

HIALLOC

Hire manager transaction allocations.

HIJOBS

Hire manager job card records.

HISTOCK

Hire manager stock item assignments.

INVOICE

Invoices, transfers, credit notes, discounts and adjustment parent records. (Child/line item records are stored in CONTENTS.)

KITMAST

Kit parent records.

KITS

Kit component records.

LAYBY

Lay-by records.

LISTMAN

General list storage.

LLISTMAN

The list of lists. The list of all standard and user definable lists in the system.

LPAYMENT

Lay-by payment records.

MATCH

Stock item cross-references.

MATRIX

Customer special pricing rules.

MATRIXSU

Supplier special pricing rules.

MESSAGES

Bulletin board messages.

NOTEPAD

System note information. Holds note information for various areas of the system such as customer notes, supplier notes, job card notes, transaction note, card file notes and so on.

ORDERS

Sales orders parent records.

OSTOCK

Sales order line item details.

OVLIST

Overdue letters parent transaction batch.

OVLIST_T

Overdue letters transaction details batch.

PSCALE

Stock price scale records. Contains automatic pricing calculations and rounding information for product items and product groups.

PICKLIST

Invoice and sales order pick lists for items undelivered/uninvoiced.

QSTOCK

Quotation line item details.

QUOTES

Quotation parent records.

RELIST

Remittance advise parent transaction batch.

RELIST_T

Remittance advise transaction details batch.

REMIND

System control file.

RETURNS

Stock returns and receipts parent records.

RSTOCK

Stock returns and receipt line item details.

SMALLOC

Service manager transaction allocations.

SMJOBS

Service manager job cards.

SMRATES

Service manager rates.

SMSTATS

Service manager job statistics.

SMSTOCK

Service manager stock item assignments.

SMTIME

Service manager labour assignments.

SNASSIGN

Serial number and unique stock tracing item assignments.

SNHISTRY

Serial number and unique stock tracing item movement history.

SNPICK

Serial number and unique stock tracing item qualification lists.

SNSPEC

Serial number and unique stock tracing types and definitions.

SNSTOCK

Serial number and unique stock tracing items held in stock.

SOCOSTS

Special costing job item details.

SOJOBS

Special costing job master records.

SORDERS

Purchase order parent records.

SOSTOCK

Purchase order line item details.

STALTPC

Stock alternate product codes for customers and suppliers. The contains product codes used by your customers and suppliers.

STKTAKE

Last stocktake submitted snapshot.

STLIST

Customer statement parent transaction batch.

STLIST_T

Customer statement transaction details batch.

STOCK

Stock master records.

STOCKEX

Stock extended product descriptions and comments.

SUPCAT

Supplier categories. (Card file/optional).

SUPPLIER

Supplier master file records.

STALTPC

Stock item alternate product codes.

TAXTABLE

Tax rate entries.

TRANSPEC

List of invoice transaction types.

TRSORT

Transaction sorting rules.

TYPE

Stock group information.

WMDTRAIL

Warehouse Manager (internal use).

WMRTRAIL

Warehouse Manager (internal use).