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 time ledger (see function idvTimePostingType).
Type = Enumeration of constants view for use in cross joins - suitable for advanced user use only
Type | The time ledger posting type as it appears in other time ledger views |
Category | The corresponding time ledger posting category as it appears in other time ledger views |
Description | Human readable description of the value |
This view is directly inherited by the following views: