IBM Sterling Warehouse Management System Views

This set of views expose IBM® Sterling Warehouse Management System-related data. The set consists of the views described in the following table.

Table 1. Sterling Warehouse Management System Views
View Description Interpreted Columns SQL Filename
YNA_DOCK_APPOINTMENT_VW This view exposes data from the YFS_DOCK_APPOINTMENT table None
TRANSACTION/dock_
appointment_vw.sql
YNA_TRAN_LOCN_ATTRS_VW This view exposes the data in the YFS_TRAN_LOCN_ATTRS table None
TRANSACTION/tran_
locn_attrs_vw.sql
YNA_SKU_DEDICATION_VW This view exposes data from the YFS_SKU_DEDICATION table None
MASTER/sku_
dedication_vw.sql
YNA_COUNT_RESULT_VW This view exposes data from the YFS_COUNT_RESULT table None
TRANSACTION/count_result
_vw.sql
YNA_COUNT_REQUEST_VW This view exposes data from the YFS_COUNT_REQUEST table None
TRANSACTION/count_request
_vw.sql
YNA_USER_VW This view exposes data from the YFS_USER table None
MASTER/user_vw.sql
YNA_SCAC_EX_VW This view exposes data from YFS_SCAC_EX table. None
CONFIGURATION/Scac_Ex.sql
YNA_SCAC_VW This view exposes data from YFS_SCAC table None
CONFIGURATION/
Scac.sql
YNA_SKU_DEDICATION_VW This view exposes data from the YFS_SKU_DEDICATION table None
MASTER/sku_dedication_
vw.sql
YNA_MANIFEST_VW This view exposes data from the YFS_Manifest table None
TRANSACTION/Manifest.sql
YNA_MOVE_REQUEST_VW This view exposes data from YFS_MOVE_REQUEST table None
TRANSACTION/Move_Request.sql

YNA_MOVE_REQ_STATUS_

AUDIT_VW

This view exposes data from YFS_MOVE_

REQ_STATUS_AUDIT table

None
TRANSACTION/Move_
Request_Status_Audit.sql
YNA_TASK_VW This view exposes data from the YFS_TASK table None
TRANSACTION/task_vw.sql
YNA_TASK_STATUS_AUDIT_VW This view exposes data from YFS_TASK_STATUS_AUDIT table None
Task Status Audit.sql
YNA_UOM_CONVERSION_VW This view exposes the data from YFS_UOM_CONVERSION table. None
CONFIGURATION/UOM_
Conversion.sql
YNA_LOCATION_VW This view exposes data from the YFS_LOCATION table None
MASTER/location_vw.sql
YNA_LOCATION_INVENTORY_VW This view exposes data from the YFS_LOCATION_INVENTORY table None
TRANSACTION/
location_inventory_vw.sql
YNA_LOCATION_SIZE_VW This view exposes data from the YFS_LOCATION_SIZE table None
MASTER/location_size_
vw.sql

YNA_LOCN_INVENTORY_

AUDIT_VW

This view exposes data from the YFS_LOCN_

INVENTORY_AUDIT table

None
TRANSACTION/locn_inventory_
audit_vw.sql
YNA_LPN_DTL_VW This view exposes data from the YFS_LPN_DTL table None
TRANSACTION/lpn_dtl_vw.sql
YNA_LPN_HDR_VW This view exposes data from the YFS_LPN_HDR table None
TRANSACTION/lpn_hdr_vw.sql
YNA_LPN_HEADER_VW This view exposes data from the YFS_LPN_HEADER table None
TRANSACTION/Lpn_
Header.sql
YNA_LPN_LOCATION_VW This view exposes data from the YFS_LPN_LOCATION table None
TRANSACTION/LPN_Location.sql

YNA_INVENTORY_BAL_NL

_INNER_VW

This view exposes data from the YFS_INVENTORY_AUDIT table. None
TRANSACTION/Inventory_
Balance_Inner.sql
YNA_ITEM_UOM_VW This view exposes data from the YFS_ITEM_UOM table None
MASTER/Item_UOM.sql
YNA_ENTERPRISE_NODE_VW This view obtains all nodes for an enterprise by joining the YFS_ORG_ENTERPRISE and YFS_ORGANIZATION tables None
CONFIGURATION/Enterprise_
Node.sql
YNA_PRODUCTIVITY_TYPE_VW

This view exposes data by joining the YNA_

PRODUCTIVITY_TYPE_NL_VW and

YNA_LOCALIZED_

DESCRIPTIONS_VW views

None
CONFIGURATION/productivity_
type_vw.sql

YNA_MODULE_DOCUMENT_

TYPE_VW

This view exposes data from the YFS_MODULE

_DOCUMENT_TYPE table

None
CONFIGURATION/Module
_Document_Type.sql

YNA_PROCESS_TYPE_

STAT_NL_VW

This view obtains statuses and processes obtained from each document type None
CONFIGURATION/Process_
Type_StatusNL.sql

YNA_PRODUCTIVITY_TYPE

_NL_VW

This view exposes data from the YFS_PRODUCTIVITY_TYPE table None
CONFIGURATION/Productivity
_TypeNL.sql

YNA_DOCUMENT_PARAMS

_NL_VW

This view exposes the data in YFS_DOCUMENT_PARAMS table None
CONFIGURATION/Document_
ParamsNL.sql

YNA_LOCATION_SIZE

_NL_VW

This view exposes the data in the YFS_LOCATION_SIZE table. None
MASTER/Location_SizeNL.sql
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.

MASTER/LocationNL.sql

YNA_SCAC_AND_SERVICE

_NL_VW

This view exposes data from YFS_SCAC_AND_SERVICE and YFS_CARRIER_SERVICE tables. None
CONFIGURATION/Scac_
And_ServiceNL.sql
YNA_TASK_ADD_VW This view exposes limited columns from the YFS_TASK table. None
TRANSACTION/Task.sql

YNA_TASK_STATUS_

AUDIT_VW

This view exposes data from the YFS_TASK_STATUS_AUDIT table. None
TRANSACTION/Task_
Status_Audit.sql

YNA_TASK_TYPE

_VW

This view exposes data from the YFS_TASK_TYPE table None
CONFIGURATION/task_
type_vw.sql

YNA_TASK_TYPE_NL_VW

This view exposes data from the YFS_TASK_TYPE table None
CONFIGURATION/Task
_TypeNL.sql
YNA_ZONE_VW This view exposes data from the YFS_ZONE table None
MASTER/zone_vw.sql

YNA_ZONE_MASTER_DATA

_NL_VW

This view exposes the data in YFS_ZONE table for the User's Node None
MASTER/Zone_Master_
DataNL.sql
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
Shipment Dashboard 
Helper.sql