Home > Technical > Table Definitions > ACHDR
This table contains a record for every customer account, supplier account and gift account. The individual transactions are stored in ACDTL.
Column |
Type |
Description |
INT |
A unique number assigned by the system. |
|
VARCHAR(10) |
The account ledger to which this account belongs. |
|
VARCHAR(20) |
The code of the original record for which this account was created. If this is a customer account, it will be the customer number. If this is a supplier account, this will be the supplier code. You can consider STRLEDGERCODE + STRACCOUNTCODE to be unique. For a gift account, the value that is to be entered at POS when redeeming the gift account. |
|
STRTRADECODE |
VARCHAR(10) |
The location to which this account belongs. |
STRFIRSTNAME |
VARCHAR(50) |
The first name of the account. This is maintained by the system when the supplier or customer names are changed. |
STRLASTNAME |
VARCHAR(50) |
The last name of the account. This is maintained by the system when the supplier or customer names are changed. |
MEMCOMMENTS |
TEXT |
A comment about the account. |
STRTERMCODE |
VARCHAR(10) |
The term code which indicates when an account is due. It is used
for calculating due dates of sales. |
CURCREDITLIMIT |
DECIMAL(19,4) |
The credit limit of this account. Debit accounts would usually have a limit of $0. |
CURBALANCE |
DECIMAL(19,4) |
The current balance of the account. This is maintained by an insert trigger on the ACDTL table. For gift accounts this represents the amount (expressed as negative) outstanding on the gift account. |
CUROPENBALANCE |
DECIMAL(19,4) |
The opening balance of the account. This will usually be $0. |
CURTOTALDR |
DECIMAL(19,4) |
The total debits on this account. This is maintained by an insert trigger on the ACDTL table. For gift accounts this is the total amount redeemed. |
CURTOTALCR |
DECIMAL(19,4) |
The total credits on this account. This is maintained by an insert trigger on the ACDTL table. For gift accounts this is the total amount issued. |
STRREF1 |
VARCHAR(30) |
Not currently used. |
STRREF2 |
VARCHAR(30) |
Not currently used. |
YSNACTIVE |
VARCHAR(1) |
'T' if the account is active. This simply indicates there has been an account transaction made on the account. |
YSNDISABLE |
VARCHAR(1) |
'T' if the account has been disabled. Use this flag to stop transactions appearing on an account. |
STRGLACCOUNTCODE |
VARCHAR(30) |
The G/L account code that is used for this account. |
CURTODATEVALUE |
DECIMAL(19,4) |
The value of sales and adjustments on the account, since DTMTODATEVALUEFROM. The value is reset to zero when a customer is upgraded/downgraded. |
DTMTODATEVALUEFROM |
DATETIME |
The date the customer was last upgraded/downgraded. |
Primary Key: LINTACCOUNTCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |