Catalog Views

This set of views expose the Item and Catalog-related data. The set consists of the views described in the following table.

Table 1. Catalog Views
View Description Interpreted Columns SQL Filename
YNA_CATEGORY_ITEM_VW This view exposes the data in the YFS_CATEGORY_ITEM table. None
MASTER/Catalog_Category_
Item.sql
YNA_CATEGORY_VW This view exposes the data in the YFS_CATEGORY table. None
MASTER/
category_vw.sql
YNA_CATALOG_MASTER_VW This view exposes the data in the YFS_CATALOG_MASTER table. None
MASTER/
Catalog_Master.sql
YNA_ITEM_VW This view exposes the data in the YFS_ITEM table. None
MASTER/
item_vw.sql
YNA_ITEM_ALIAS_VW This view exposes the data in the YFS_ITEM_ALIAS table. None
MASTER/
item_alias_vw.sql
YNA_ITEM_TAG_VW This view exposes the data in the YFS_ITEM_TAG table. None
MASTER/
Item_Tag.sql
YNA_ITEM_UOM_MASTER_VW This view exposes the data in the YFS_ITEM_UOM_MASTER table. None
CONFIGURATION/item_uom
_master_vw.sql
YNA_CATEGORY_NL_VW This view exposes the data in the YFS_CATEGORY table. None
MASTER/Catalog_
CategoryNL.sql