Base View idvFeesOptions

Description

This view exposes the options set for the fees ledger for the whole practice. The result set of the view is a singleton.

The 'always' columns are maintained in the view to implement a logical primary key for reporting services.

 

For use by

Base view suitable for advanced end users.

 

Columns

Always6

Always equal to 6 - included to provide a logical prime key

AlwaysZero

Always equal to zero - included to provide a logical prime key

DebtorsControl

Internal identifier of nominal code for debtors control

OutputVATAC

Internal identifier of nominal code for output VAT

VATReservedAC

Internal identifier of nominal code for VAT element of payment request notes

DefaultBankAC

Internal identifier of nominal code for default bank account

ProfessionalFeesAC

identifier of nominal code for default sales code

BadDebtsAC

Internal identifier of nominal code for bad debts written off

DebtorsReservedAC

Internal identifier of nominal code for control account for payment request notes

DiscountsGivenAC

Internal identifier of nominal code for discounts given

VATUninvoicedAC

Internal identifier of nominal code for balancing VAT elements when VAT accounted directly on receipts

PeriodsPerYear

Number of periods in one year

 

  •