This set of views expose IBM® Sterling Warehouse Management System-related data. The set consists of the views described in the following table.
View | Description | Interpreted Columns | SQL Filename |
---|---|---|---|
YNA_DOCK_APPOINTMENT_VW | This view exposes data from the YFS_DOCK_APPOINTMENT table | None |
|
YNA_TRAN_LOCN_ATTRS_VW | This view exposes the data in the YFS_TRAN_LOCN_ATTRS table | None |
|
YNA_SKU_DEDICATION_VW | This view exposes data from the YFS_SKU_DEDICATION table | None |
|
YNA_COUNT_RESULT_VW | This view exposes data from the YFS_COUNT_RESULT table | None |
|
YNA_COUNT_REQUEST_VW | This view exposes data from the YFS_COUNT_REQUEST table | None |
|
YNA_USER_VW | This view exposes data from the YFS_USER table | None |
|
YNA_SCAC_EX_VW | This view exposes data from YFS_SCAC_EX table. | None |
|
YNA_SCAC_VW | This view exposes data from YFS_SCAC table | None |
|
YNA_SKU_DEDICATION_VW | This view exposes data from the YFS_SKU_DEDICATION table | None |
|
YNA_MANIFEST_VW | This view exposes data from the YFS_Manifest table | None |
|
YNA_MOVE_REQUEST_VW | This view exposes data from YFS_MOVE_REQUEST table | None |
|
YNA_MOVE_REQ_STATUS_ AUDIT_VW |
This view exposes data from YFS_MOVE_ REQ_STATUS_AUDIT table |
None |
|
YNA_TASK_VW | This view exposes data from the YFS_TASK table | None |
|
YNA_TASK_STATUS_AUDIT_VW | This view exposes data from YFS_TASK_STATUS_AUDIT table | None |
|
YNA_UOM_CONVERSION_VW | This view exposes the data from YFS_UOM_CONVERSION table. | None |
|
YNA_LOCATION_VW | This view exposes data from the YFS_LOCATION table | None |
|
YNA_LOCATION_INVENTORY_VW | This view exposes data from the YFS_LOCATION_INVENTORY table | None |
|
YNA_LOCATION_SIZE_VW | This view exposes data from the YFS_LOCATION_SIZE table | None |
|
YNA_LOCN_INVENTORY_ AUDIT_VW |
This view exposes data from the YFS_LOCN_ INVENTORY_AUDIT table |
None |
|
YNA_LPN_DTL_VW | This view exposes data from the YFS_LPN_DTL table | None |
|
YNA_LPN_HDR_VW | This view exposes data from the YFS_LPN_HDR table | None |
|
YNA_LPN_HEADER_VW | This view exposes data from the YFS_LPN_HEADER table | None |
|
YNA_LPN_LOCATION_VW | This view exposes data from the YFS_LPN_LOCATION table | None |
|
YNA_INVENTORY_BAL_NL _INNER_VW |
This view exposes data from the YFS_INVENTORY_AUDIT table. | None |
|
YNA_ITEM_UOM_VW | This view exposes data from the YFS_ITEM_UOM table | None |
|
YNA_ENTERPRISE_NODE_VW | This view obtains all nodes for an enterprise by joining the YFS_ORG_ENTERPRISE and YFS_ORGANIZATION tables | None |
|
YNA_PRODUCTIVITY_TYPE_VW | This view exposes data by joining the YNA_ PRODUCTIVITY_TYPE_NL_VW and YNA_LOCALIZED_ DESCRIPTIONS_VW views |
None |
|
YNA_MODULE_DOCUMENT_ TYPE_VW |
This view exposes data from the YFS_MODULE _DOCUMENT_TYPE table |
None |
|
YNA_PROCESS_TYPE_ STAT_NL_VW |
This view obtains statuses and processes obtained from each document type | None |
|
YNA_PRODUCTIVITY_TYPE _NL_VW |
This view exposes data from the YFS_PRODUCTIVITY_TYPE table | None |
|
YNA_DOCUMENT_PARAMS _NL_VW |
This view exposes the data in YFS_DOCUMENT_PARAMS table | None |
|
YNA_LOCATION_SIZE _NL_VW |
This view exposes the data in the YFS_LOCATION_SIZE table. | None |
|
YNA_LOCATION_NL_VW | This view obtains data by joining the YNA_DISTNT_DEDICATED_ LOCN_VW, YNA_LOCATION_VW, and YNA_ TRAN_LOCN_ATTRS_VW views. |
ACTIVITY_DAY _DIFF = The difference between the modify date for the location and the current date. |
|
YNA_SCAC_AND_SERVICE _NL_VW |
This view exposes data from YFS_SCAC_AND_SERVICE and YFS_CARRIER_SERVICE tables. | None |
|
YNA_TASK_ADD_VW | This view exposes limited columns from the YFS_TASK table. | None |
|
YNA_TASK_STATUS_ AUDIT_VW |
This view exposes data from the YFS_TASK_STATUS_AUDIT table. | None |
|
YNA_TASK_TYPE _VW |
This view exposes data from the YFS_TASK_TYPE table | None |
|
YNA_TASK_TYPE_NL_VW |
This view exposes data from the YFS_TASK_TYPE table | None |
|
YNA_ZONE_VW | This view exposes data from the YFS_ZONE table | None |
|
YNA_ZONE_MASTER_DATA _NL_VW |
This view exposes the data in YFS_ZONE table for the User's Node | None |
|
Shipment_Dashboard_Helper_VW | This view exposes the data of the YNA_Shipment_VW based on the status comparison with the YFS_Status table. |
None |
|