Home > Technical > Table Definitions > ACMOVEMENT

ACMOVEMENT

These records record the nett value of transactions for an account during a specific period. They are used to obtain the balance of an account as of a certain period.

Column

Type

Description

STRLEDGERCODE

VARCHAR(10)

The account ledger to which this account belongs.
ACLEDGER.strLedgerCode

STRACCOUNTCODE

VARCHAR(20)

The account this record belongs to.

ACHEADER.strAccountCode

STRPERIOD

VARCHAR(7)

The period the movement value belongs to.

STATSPER.strYearWeek

CURMOVEMENT

DECIMAL(19,4)

The total nett value of transactions for the account within the period.

 

Primary Key: STRLEDGERCODE+STRACCOUNTCODE+STRPERIOD

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