Home > Technical > Table Definitions > ACALLOCATE

ACALLOCATE

This table records how one account transaction is allocated to other account transactions. For example, if you have a payment for five invoices, you would have five records showing how the payment is allocated to the five invoices.

Column Type Description
LINTACCOUNTCODE INT The account that this transaction belongs.

TRADUNIT.strTradeCode

CTRCODE BIGINT Unique number assigned by the system.
LINTSOURCE BIGINT The code of the source transactions, for example the payment.

ACDTL.ctrTransNumber

LINTDESTINATION BIGINT The code of the transactions allocated to, for example the invoices.

ACDTL.ctrTransNumber

DTMALLOCATED DATETIME The date the allocate was made.
CURAMOUNT DECIMAL(19,4) The amount of the allocation.
 

Primary Key: LINTACCOUNTCODE + CTRCODE

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