IBM Sterling Warehouse Management System Business Intelligence Views

IBM® Sterling Warehouse Management System Business Intelligence Views are a layer of abstraction on the YFS tables. Most of these views are straight select statements from the table, having a UNION with its history (archived) table, if it exists. The fields in these views are derived directly from the underlying table, without any calculations. These views are not described in detail in this appendix. For their descriptions, see the Entity Relationship Diagrams.html. For a complete list of the view SQL and the join where clause, see the corresponding.sql files located in:

For more information about WithHistory and WithoutHistory views, see the topic, The IBM Sterling Warehouse Management System Business Intelligence Framework"IBM Sterling Warehouse Management System: Business Intelligence Framework Views.

Note: Views to query Resource Pool capacity across service lines currently are NOT provided. This is due to bandwidth limitations
Note: Views created directly on, or joined to, the YFS_ORDER_HEADER table exclude draft order records (specifically: YNA_ORDER_HEADER_VW, YNA_ORDER_LINE_VW, YNA_ORDER_HEADER_ADD_VW, and YNA_INV_COST_SHIPMENT_VW). Therefore, reports based on, or joined with, these views will not show draft order data.

To include such records, remove this SQL clause from the views mentioned above:

OH.DRAFT_ORDER_FLAG = 'N'

To exclude such records in views that you create or modify, append this SQL clause to the view definition:

YFS_ORDER_HEADER.DRAFT_ORDER_FLAG = 'N'

The following sets of views are described in this topic: