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;