Home > Technical > Table Definitions > ACLEDGER

ACLEDGER

The account structure within the system allows various financial details to be recorded. Currently member sales (for debit/credit cards) are stored as well as supplier credits (invoices owed) and debits (rebates). Each set of accounts is recorded in a ledger, for example member debit cards. There is a ledger record set up for each ledger in the system. Current ledgers are MEMCR (Member’s Credit Sales), MEMDR (Member’s Debit Sales), SUPPCR (Supplier's Credits, that is Invoices), SUPPDR (Supplier's Debits, that is Rebates) and GIFTAC (Gift Accounts). These values should not be altered. You can add additional member ledgers, if required.

Column

Type

Description

STRLEDGERCODE

VARCHAR(10)

A code identifying the ledger.

STRLEDGERDESCRIPTION

VARCHAR(50)

The ledger’s description.

STRSHORTLEDGERDESCRIPTION

VARCHAR(20)

A short description for use at the POS.

STRTERMCODE

VARCHAR(10)

The default term code for this type of account ledger.

ACTERMS.strTermCode

STRSHOWBALANCEINPOS

VARCHAR(1)

'T' if the account balance should be shown at the POS and printed on the POS receipt, 'F' otherwise. Applies to customer account types - MEMxx ledger codes only.

YSNPRINTBALANCEONRECEIPT

VARCHAR(1)

'T' if the account balance should be printed on the POS's receipt, 'F' otherwise. Applies to customer account types - MEMxx ledger codes and for gift account tenders only.

YSNINCBALANCEINTOTAL

VARCHAR(1)

This flag is only used if using MultiAccountStatements, to print multiple ledgers for a member on one statement. At the end of the statement for each member is a total owed, which is the sum of the balances for each ledger printed. You can use this flag to indicate whether this particular ledger's balance should be included in the reported total. 'T' if balance should be included in the total, 'F' otherwise. No longer used.

YSNGIVECHANGEONPAYMENT

VARCHAR(1)

Normally when a payment is made on account, the account will be adjusted by the full amount of the payment. However, if someone is paying $100 on a $60 account at the POS, they may expect to get $40 change. If this is set to 'T', the operator will be prompted to give change or to accept the full amount. The flag defaults to 'F'. Applies to customer account types - MEMxx ledger codes only.

YSNPRINTZEROBALANCESTATEMENTS

VARCHAR(1)

T' if accounts with a zero balance should be printed, 'F' otherwise. Note, that just because an account balance is zero, there may have been some transactions during the period so a statement should still be printed. If this option is 'F', no statement would be printed even if there was activity during the period. No longer used.

YSNSHOWAVAILABLE

VARCHAR(1)

If 'T', DynaPOSTouch will show the amount available to spend on the account. If 'F', DynaPOSTouch will show the amount outstanding on the account.

 

INTTENDERCODE

INT

No longer used.

INTFUNCTION

INT

No longer used.

 

Primary Key: STRLEDGERCODE

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