Home > Technical > Table Definitions > ACSTATEMENTBALANCE

ACSTATEMENTBALANCE

Not currently used.

Column

Type

Description

STRLEDGERCODE

VARCHAR(10)

The ledger of the account that this record is for

ACHEADER.strLedgerCode

STRACCOUNTCODE

VARCHAR(20)

The account code of the account that this record is for

ACHEADER.strAccountCode

STRTERMCODE

VARCHAR(10)

The payment term of the account.

ACHEADER.strTermCode

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. When the statement is accepted, this value will be moved to the corresponding field in ACHEADER.

ACDETAIL.ctrTransNumber

CURCLOSESTATEMENT

DECIMAL(19,4)

The closing balance of the statement. This will be used as the opening balance of the next statement. When the statement is accepted, this value will be moved to the corresponding field in ACHEADER.

DTMLASTSTATEMENT

DATETIME

The date the statement was generated. When the statement is accepted, this value will be moved to the corresponding field in ACHEADER.

STRFIRSTNAME

VARCHAR(50)

The first name of the account.

ACHEADER.strFirstName

STRLASTNAME

VARCHAR(50)

The last name of the account.

ACHEADER.strLastName

STRTITLE

VARCHAR(10)

The title of the account.

ACHEADER.strTitle

STRSORTACCOUNTNAME

VARCHAR(100)

The name used to sort the accounts for the purpose of reporting. If strFirstName iis empty then would just be strLastName otherwise strLastName+' '+strFirstName

CUROVERDUE

DECIMAL(19,4)

The amount which is overdue for this account.

 

Primary Keys: STRLEDGERCODE+STRACCOUNTCODE

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