Home > Technical > Table Definitions > ACTRANSCODE

ACTRANSCODE

This table is used to record the reasons for account adjustments. Various indicate whether the amount the user enters should debit or credit the account and whether the adjustment needs to be allocated against other transactions.

Column

Type

Description

STRLEDGERCODE

VARCHAR(10)

The ledger this account reason is for. This allows different reasons to be set up for different ledgers.

ACHDR.strLedgerCode

STRCODE

VARCHAR(10)

A unique code identifying the adjustment reason. The same code can be used for different ledgers.

STRDESCRIPTION

VARCHAR(20)

A unique number assigned by the system.

YSNALLOCATE

VARCHAR(1)

If 'T' then adjustment must be allocated against other existing transactions. If 'F' then no allocation is required.

YSNDEBIT

VARCHAR(1)

If 'T', the adjustment amount entered by the user will debit the account, otherwise it will credit the account.

STRGLCODE

VARCHAR(20)

Reserved for future use.

STRTAXCODE

VARCHAR(10)

The tax code which represents the tax included in this transaction reason, for example GST. If left empty then no tax is included.

TAX.strTaxCode

YSNADJTODATEVALUE

VARCHAR(1)

 

 

Primary Key: STRLEDGERCODE+STRCODE

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