View: core.item_group_selector_view

Schema core
Materialized View Name item_group_selector_view
Owner postgres
Tablespace DEFAULT
Description
 CREATE OR REPLACE VIEW core.item_group_selector_view
 AS
 SELECT item_groups.item_group_id,
    item_groups.item_group_code,
    item_groups.item_group_name,
    item_groups.exclude_from_purchase,
    item_groups.exclude_from_sales,
    item_groups.sales_tax_id,
    item_groups.sales_account_id,
    item_groups.sales_discount_account_id,
    item_groups.sales_return_account_id,
    item_groups.purchase_account_id,
    item_groups.purchase_discount_account_id,
    item_groups.inventory_account_id,
    item_groups.cost_of_goods_sold_account_id,
    item_groups.parent_item_group_id,
    item_groups.audit_user_id,
    item_groups.audit_ts
   FROM core.item_groups;