Home > Technical > Table Definitions > ACHEADER

ACHEADER

Column

Type

Description

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.

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(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.

CUROPENBALANCE

DECIMAL(19,4)

The opening balance of the account. This will usually be $0.

STRREF1

VARCHAR(10)

Not currently used.

STRREF2

VARCHAR(10)

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.

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.

STRADDR1POST

VARCHAR(50)

The first line of the postal address for the account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

STRADDR2POST

VARCHAR(50)

The second line of the postal address for the account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

STRCITYPOST

VARCHAR(50)

The city of the postal address for the account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

STRSTATEPOST

VARCHAR(20)

The state of the postal address for the account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

STRPOSTCODEPOST

VARCHAR(15)

The postcode of the postal address for the account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

YSNDISABLE

VARCHAR(1)

'T' if the account has been disabled. Use this flag to stop transactions appearing on an account.

DTMLASTSTATEMENT

DATETIME

The date the last statement was generated.

INTLASTCODE

INT

The code of the last ACDETAIL record printed on the statement. When the next statement is generated, only ACDETAIL records greater than this value will be reported.

ACDETAIL.ctrTransNumber

CURCLOSESTATEMENT

DECIMAL(19,4)

The closing balance of the last statement. This will be used as the opening balance of the next statement.

STRGLACCOUNTCODE

VARCHAR(20)

The G/L account code that is used for this account.

STRTITLE

VARCHAR(10)

The title of the account. This is automatically maintained by triggers on CUSTOMER.

STRTAXNUMBER1

VARCHAR(20)

The tax number (ABN) for this account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

STRTAXNUMBER2

VARCHAR(20)

The tax number (BRN) for this account. This is automatically maintained by triggers on CUSTOMER and SUPPLIER (depending on where the account was created).

 

Primary Key: STRLEDGERCODE+STRACCOUNTCODE

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