Home > Technical > Table Definitions > 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.![]() |
||||||||||||||
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.![]() |
||||||||||||||
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.
|
||||||||||||||
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.![]() |
||||||||||||||
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) |