Inventory Views

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

Table 1. Inventory Views
View Description Interpreted Columns SQL Filename
YNA_INVENTORY_AUDIT_VW

This view exposes the data in the YFS_INVENTORY_AUDIT table.

None
TRANSACTION/
inventory_audit_vw
.sql

YNA_INVENTORY_COST_

MATCH_VW

This view exposes the data in the YFS_INVENTORY_MATCH table.

None
TRANSACTION/
Inventory_Cost_Match
.sql
YNA_INV_COST_SHIPMENT_VW

This view exposes the data in the YFS_INVENTORY_SHIPMENT andYFS_ORDER_HEADER tables. In addition to the columns of YFS_INVENTORY_SHIPMENT table, this view also exposes the seller organization on the order where the shipment was made.

None
TRANSACTION/
Inventory_Cost_
Shipment.sql
YNA_INVENTORY_DEMAND_VW

This view exposes the data in the YFS_INVENTORY_DEMAND table.

None
TRANSACTION/
Inventory_
Demand.sql
YNA_INVENTORY_ITEM_VW

This view exposes the data in the YFS_INVENTORY_ITEM table.

None
TRANSACTION/
inventory_item_
vw.sql
YNA_INVENTORY_SUPPLY_VW

This view exposes the data in the INVENTORY_SUPPLY table.

None
TRANSACTION/
inventory_supply_
vw.sql
YNA_INVENTORY_TAG_VW

This view exposes the data in the YFS_INVENTORY_TAG table

.
None
TRANSACTION/
Inventory_
Tag.sql
YNA_INVENTORY_STATUS_VW

This view exposes data from the YFS_INVENTORY_STATUS table

None
CONFIGURATION/
inventory_status_
vw.sql
YNA_INVENTORY_STATUS_NL_VW

This view exposes selected columns from the YFS_INVENTORY_STATUS table.

None
CONFIGURATION/
Inventory_
StatusNL.sql
YNA_GLOBAL_SERIAL_NUM_VW

This view exposes the data in the YFS_GLOBAL_SERIAL_NUM table.

None
TRANSACTION/
Global_Serial_
Num.sql
YNA_INVENTORY_RECEIPT_VW

This view exposes the data in the YFS_INVENTORY_RECEIPT table.

None
TRANSACTION/
inventory_receipt_
vw.sql
YNA_RES_POOL_VW

This view exposes the data in the YFS_RES_POOL table.

None
MASTER/
res_pool_
vw.sql

YNA_RES_POOL_CAPCTY

_CONS_VW

This view exposes data from the YFS_RES

_POOL_CAPCTY_CONSMPTN table.

None
TRANSACTION/
Res_pool_consmptn_
dtls_vw.sq
l

YNA_RES_POOL_

CONSMPTN_DTLS_VW

This view exposes the data in the YFS_RES_

POOL_CONSMPTN_DTLS table.

None
TRANSACTION/
res_pool_consmptn_
dtl_vw.sql

YNA_SERVICE_RESOURCE

_VW

This view exposes the data in the YFS_

SERVICE_RESOURCE table.

None
MASTER/
service_resource_
vw.sql