Order Views

This view exposes the Order-related audit data. The set consists of the views described in the following table.

Table 1. Order Views
View Description Interpreted Columns SQL Filename
YNA_ORDER_AUDIT_VW This view exposes the data in the YFS_ORDER_AUDIT_H table. It is provided for backward compatibility.

Important: The changeOrder API creates audit information in a format that is not exposed to the IBM® Sterling Warehouse Management System Business Intelligence Framework.

None TRANSACTION/Order_Audit.sql
YNA_PAYMENT_VW This view exposes the data in the YFS_PAYMENT table filtered for an Order Header. None TRANSACTION/Payment.sql

YNA_ORDER_RELEASE_

STATUS_VW

This view exposes the data in the YFS_ORDER_RELEASE

_STATUS table filtered for an Order Header.

None
TRANSACTION/order_release
_status_vw.sql