Home > Technical > Table Definitions > ACDTL

ACDTL

This table stores a record for every account transaction. An insert trigger on the table will automatically update the balances on the ACHDR record to which these transactions belong. The ACALLOCATE table records how transactions are allocated to other transactions.

Column Type Description
LINTACCOUNTCODE INT The account to which this transaction belongs.
ACHDR.lintAccountCode
CTRTRANSNUMBER BIGINT A unique, incrementing number assigned by the system.
STRTRADECODE VARCHAR(10) The location where the transaction was originally made or where the gift account was issued.
TRADUNIT.strTradeCode
DTMTRANS DATETIME Current trading date.
STRREFERENCE VARCHAR(50) A reference number for the transaction.
CURAMOUNT DECIMAL(19,4) The amount of the transaction or for gift accounts the amount (expressed as negative) outstanding on the gift account.
CURDEBIT DECIMAL(19,4) The debit value of the transaction or for gift accounts the amount redeemed in the transaction.
CURCREDIT DECIMAL(19,4) The credit value of the transaction or for gift accounts the amount issued in this transaction.
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) The amount of the transaction that has been allocated to other transactions.
LINTSOURCE BIGINT The code of the original record for which this account transaction was created. If this was created from an invoice, this would be the invoice number. If it was created from a sale, this would be the DAILYSALES.intOrderCode.
INTTENDERCODE INT The tender code used for payments.
STRCOMMENT TEXT Comment on the account transaction.
STRPAYMENTREF1 VARCHAR(50) A payment reference for the account transaction (if its a payment).
STRPAYMENTREF2 VARCHAR(50) A payment reference for the account transaction (if its a payment).
DTMDUE DATETIME The date the transaction is due. This is mainly for sale type transactions, not payments.
STRADJCODE VARCHAR(10) The code of the adjustment.
ACTRANSCODE.strCode
STRMONEYINTILL VARCHAR(10) The till to which this payment was made. Not currently used.
DTMPOSTED DATETIME The date the transaction was recorded.
CURTAXAMT DECIMAL(19,4) The amount of tax on the transaction.
STRWHO VARCHAR(20) The code of the user who made this transactions.
DTMWHEN DATETIME The date/time when the transaction was made or the account was issued.
DTMTAXINVOICE DATETIME The date of any associated tax invoice.

DTMTAXCLAIMED

DATETIME

The date the tax was processed and claimed.

STRROUTECODE

VARCHAR(10)

 

 

Primary Key: LINTACCOUNTCODE + CTRTRANSNUMBER

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