Home > Technical > Table Definitions > ACHDR

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

LINTACCOUNTCODE

INT

A unique number assigned by the system.

STRLEDGERCODE

VARCHAR(10)

The account ledger to which this account belongs.
ACLEDGER.strLedgerCode

STRACCOUNTCODE

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. 
TRADUNITACCOUNT.strAcTradeCode

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.
ACTERMS.strTermCode

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)