Home > Technical > Table Definitions > ACHEADER1

ACHEADER1

Column

Type

Description

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.

STRLEDGERCODE

VARCHAR(10)

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

STRACCOUNTNAME

VARCHAR(50)

The name of the account, for member sales this defaults to the cardholder’s name.

MEMCOMMENTS

VARCHAR(2000)

A comment about the account.

STRLEDGERTYPE

VARCHAR(10)

The type of ledger:

  • Asset

  • Liability

  • Expense

  • Income

  • Equity

STRTERMCODE

VARCHAR(5)

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.

 

Primary Key: STRACCOUNTCODE

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