database_views

Cyrious Control uses pre-defined views or creates them for the use of reporting.

The purpose of this document is to record these views and their current SQL.

Accounting

GL View - Display all real (on-balance sheet) entries in the ledger table.

Products

cv_ProductTree View - Display the view of products as a tree.

User Defined Fields

cv_partudfbyrow_view - Generate a view of UDFs (one per row) for Parts.
cv_productudfbyrow_view - Generate a view of UDFs (one per row) for Products.