This view does not represent data actually stored on the database. It constitutes a conceptual table that enumerates all possible values of some other column.
This conceptual table can be used to:
Translate a value into its human readable description
Cross join other tables to ensure that all combinations are present in a result set
This particular view maps posting types on the fees ledger (see function idvFeesPostingType).
Type = Enumeration of constants view for use in cross joins - suitable for advanced user use only
Type | The fees posting type as it appears in other fees ledger views |
Category | The corresponding fees ledger posting category as it appears in other fees ledger views |
Description | Human readable description of the value |
This view is directly inherited by the following views: