Home > Technical > Table Definitions > ACDETAIL1

ACDETAIL1

Column Type Description

STRACCOUNTCODE

VARCHAR(20)

The account to which this transaction belongs.
ACHDR.lintAccountCode

STRLEDGERCODE

VARCHAR(10)

The ledger this account belongs to.

ACHDR.strLedgerCode

CTRTRANSNUMBER BIGINT A unique, incrementing number assigned by the system.
DTMTRANS DATETIME The date the transaction was made.

STRCOMMENT

VARCHAR(500)

General comment about the transaction.

STRREFERENCE

VARCHAR(30)

A reference number for the transaction.

CURAMOUNT DECIMAL(19,4) The amount of the transaction.

CURDEBIT

DECIMAL(19,4)

The debit value of the transaction.

CURCREDIT

DECIMAL(19,4)

The amount being credited.

 

Primary Key: CTRTRANSNUMBER

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