MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types

All Views of MIXERP

# View Name Owner Tablespace Description
1 core.account_master_selector_view postgres DEFAULT
2 core.account_scrud_view postgres DEFAULT
3 core.account_selector_view postgres DEFAULT
4 core.account_view postgres DEFAULT
5 core.ageing_slab_scrud_view postgres DEFAULT
6 policy.auto_verification_policy_scrud_view postgres DEFAULT
7 core.bank_account_view postgres DEFAULT
8 core.bonus_slab_detail_scrud_view postgres DEFAULT
9 core.bonus_slab_scrud_view postgres DEFAULT
10 core.bonus_slab_selector_view postgres DEFAULT
11 core.brand_scrud_view postgres DEFAULT
12 core.brand_selector_view postgres DEFAULT
13 core.cash_flow_heading_scrud_view postgres DEFAULT
14 core.cash_flow_setup_scrud_view postgres DEFAULT
15 office.cash_repository_scrud_view postgres DEFAULT
16 office.cash_repository_selector_view postgres DEFAULT
17 core.compound_item_detail_scrud_view postgres DEFAULT
18 core.compound_item_scrud_view postgres DEFAULT
19 core.compound_item_selector_view postgres DEFAULT
20 core.compound_unit_scrud_view postgres DEFAULT
21 scrud.constraint_column_usage postgres DEFAULT Lists all columns having constraints.
22 office.cost_center_scrud_view postgres DEFAULT
23 office.counter_scrud_view postgres DEFAULT
24 core.country_scrud_view postgres DEFAULT
25 core.county_sales_tax_scrud_view postgres DEFAULT
26 core.county_scrud_view postgres DEFAULT
27 core.currency_scrud_view postgres DEFAULT
28 core.currency_selector_view postgres DEFAULT
29 public.db_stat postgres DEFAULT
30 office.department_scrud_view postgres DEFAULT
31 core.entity_scrud_view postgres DEFAULT
32 core.fiscal_year_scrud_view postgres DEFAULT
33 core.fiscal_year_selector_view postgres DEFAULT
34 core.flag_type_scrud_view postgres DEFAULT
35 core.frequency_selector_view postgres DEFAULT
36 core.frequency_setup_scrud_view postgres DEFAULT
37 core.industry_scrud_view postgres DEFAULT
38 core.item_cost_price_scrud_view postgres DEFAULT
39 core.item_group_scrud_view postgres DEFAULT
40 core.item_group_selector_view postgres DEFAULT
41 core.item_scrud_view postgres DEFAULT
42 core.item_selector_view postgres DEFAULT
43 core.item_selling_price_scrud_view postgres DEFAULT
44 core.item_type_scrud_view postgres DEFAULT
45 core.item_view postgres DEFAULT
46 core.late_fee_scrud_view postgres DEFAULT
47 localization.localized_resources_view postgres DEFAULT
48 scrud.mixerp_table_view postgres DEFAULT Lists all schema, table, and columns with associated types, domains, references, and constraints.
49 office.office_scrud_view postgres DEFAULT
50 office.office_selector_view postgres DEFAULT
51 office.office_view postgres DEFAULT
52 core.party_scrud_view postgres DEFAULT
53 core.party_selector_view postgres DEFAULT
54 core.party_type_scrud_view postgres DEFAULT
55 core.party_type_selector_view postgres DEFAULT
56 core.party_user_control_view postgres DEFAULT
57 core.party_view postgres DEFAULT
58 core.payment_term_scrud_view postgres DEFAULT
59 core.price_type_selector_view postgres DEFAULT
60 core.recurring_invoice_scrud_view postgres DEFAULT
61 core.recurring_invoice_setup_scrud_view postgres DEFAULT
62 scrud.relationship_view postgres DEFAULT Lists all foreign key columns and their relation with the parent tables.
63 office.role_scrud_view postgres DEFAULT
64 office.role_view postgres DEFAULT
65 core.rounding_method_selector_view postgres DEFAULT
66 transactions.sales_by_country_view postgres DEFAULT
67 core.sales_tax_detail_scrud_view postgres DEFAULT
68 core.sales_tax_exempt_detail_scrud_view postgres DEFAULT
69 core.sales_tax_exempt_scrud_view postgres DEFAULT
70 core.sales_tax_scrud_view postgres DEFAULT
71 core.sales_tax_selector_view postgres DEFAULT
72 core.sales_tax_type_scrud_view postgres DEFAULT
73 core.sales_team_scrud_view postgres DEFAULT
74 core.sales_team_selector_view postgres DEFAULT
75 core.salesperson_bonus_setup_scrud_view postgres DEFAULT
76 core.salesperson_scrud_view postgres DEFAULT
77 core.salesperson_selector_view postgres DEFAULT
78 core.shipper_scrud_view postgres DEFAULT
79 core.shipping_address_scrud_view postgres DEFAULT
80 core.shipping_address_view postgres DEFAULT
81 core.shipping_mail_type_selector_view postgres DEFAULT
82 core.shipping_package_shape_selector_view postgres DEFAULT
83 office.sign_in_view postgres DEFAULT
84 core.state_sales_tax_scrud_view postgres DEFAULT
85 core.state_scrud_view postgres DEFAULT
86 transactions.stock_transaction_view postgres DEFAULT
87 office.store_scrud_view postgres DEFAULT
88 office.store_selector_view postgres DEFAULT
89 office.store_type_scrud_view postgres DEFAULT
90 office.store_type_selector_view postgres DEFAULT
91 office.store_view postgres DEFAULT
92 core.supplier_selector_view postgres DEFAULT
93 core.supplier_view postgres DEFAULT
94 core.tax_authority_scrud_view postgres DEFAULT
95 core.tax_base_amount_type_selector_view postgres DEFAULT
96 core.tax_exempt_type_scrud_view postgres DEFAULT
97 core.tax_master_scrud_view postgres DEFAULT
98 core.tax_rate_type_selector_view postgres DEFAULT
99 transactions.transaction_view postgres DEFAULT
100 core.unit_scrud_view postgres DEFAULT
101 core.unit_selector_view postgres DEFAULT
102 core.unit_view postgres DEFAULT
103 office.user_selector_view postgres DEFAULT
104 office.user_view postgres DEFAULT
105 transactions.verified_stock_details_view postgres DEFAULT
106 transactions.verified_transaction_view postgres DEFAULT
107 policy.voucher_verification_policy_scrud_view postgres DEFAULT
108 office.work_center_view postgres DEFAULT