Home > Technical > Table Definitions > ACHEADER
Column |
Type |
Description |
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. |
|
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:
|
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. |
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. |
VARCHAR(50) |
The first name of the account. This is maintained by the system when the supplier or customer names are changed. |
|
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. |
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. |
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) |