Home > Technical > Table Definitions > ACDETAIL

ACDETAIL

Each time an account is modified, a record is written to this table. Triggers on this table will automatically update the balances for the ACHEADER and ACMOVEMENT tables.

Column Type Description

STRLEDGERCODE

VARCHAR(10)

The ledger this account belongs to.

ACHEADER.strLedgerCode

STRACCOUNTCODE

VARCHAR(20)

The account to which this transaction belongs.
ACHDR.lintAccountCode

CTRTRANSNUMBER BIGINT A unique, incrementing number assigned by the system.
DTMTRANS DATETIME The date the transaction was made.
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 credit value of the transaction.

STRPERIOD

VARCHAR(7)

The period the transaction is for. This is important as it will adjust the ACMOVEMENT table used to calculate opening balances.

STRTYPE

VARCHAR(5)

The type of account transaction.

ADJ   Adjustment.
PAY   Payment. Can be manually entered or created automatically when POS transactions are processed.
POS   POS transaction. Created automatically when POS transactions are processed.
PURCH Invoice purchase. Created automatically when an invoice is accepted.
REP   Rebate. Created automatically when rebates is accepted.
RET   Credit Note. Created automatically when a return invoice is accepted.
SALE   POS transaction. Created automatically when gift account transactions are processed.
CURALLOCATED DECIMAL(19,4)

 

LINTSOURCE BIGINT

The unique number of the original transaction. For example if this is a PURCH (generated from an invoice) then this will be the invoice number.

INTTENDERCODE INT

The code of the tender used to make the payment. Only required for PAY types.

TENDER.intTenderCode

STRCOMMENT VARCHAR(1000)

A general comment about the transaction.

STRPAYMENTREF1 VARCHAR(20)

Reference for the payment, for example credit card number.

STRPAYMENTREF2 VARCHAR(20)

Reference for the payment, for example credit card number.

DTMDUE DATETIME

The date the transaction is due for payment.

STRADJCODE VARCHAR(10)

The code of the adjustment. Only required for ADJ types.

ACTRANSCODE.strCode

STRMONEYINTILL VARCHAR(5)

The code of the till a payment will be placed into. This allows a till read to be done to reconcile payments.

TILL.strTillCode

DTMPOSTED DATETIME

The date the transaction was actually entered. This is the date which will be used to determine if the transaction should be printed on statements.

CURTAXAMT DECIMAL(19,4)

The amount of tax on this transaction.

STRTRADECODE

VARCHAR(10)

 

STRWHO

VARCHAR(10)

The user who entered the record.

DTMWHEN DATETIME

The date/time the record was entered.

DTMTAXINVOICE DATETIME

The date the tax invoice was received. If no tax invoice, this will be empty.

DTMTAXCLAIMED DATETIME

The date the tax was actually claimed for taxation purposes.

 

Primary Key: STRLEDGERCODE+STRACCOUNTCODE+CTRTRANSNUMBER

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