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.
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: