Home > Technical > Table Definitions > ACALLOC


When a payment is made in the accounts system, it is allocated against existing sales/purchases/adjustments. A payment can be allocated against several other transactions. This table records the way one transaction is allocated against another. Triggers on this table will automatically update the outstanding balance of the ACDETAIL records which are effected.

Column Type Description
CTRCODE INT Unique number assigned by the system.
LINTSOURCE INT The code of the source transactions, for example the payment.
LINTDESTINATION INT The code of the transactions allocated to, for example the invoices.
CURAMOUNT DECIMAL(19,4) The amount of the allocation.


Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)