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