Shipment Views

This set of views expose the Shipment-related data. The set consists of the views described in the following table.

Table 1. Shipment Views
View Description Interpreted Columns SQL Filename
YNA_ORDER_SHIPMENT_VW

This view exposes data from the YFS_SHIPMENT, YFS_SHIPMENT_LINE, YFS_ORDER_HEADER, and YFS_ORDER_LINE tables.

None
TRANSACTION/
Order_Shipment.sql

YNA_PACK_HOLD_SHIPMENTS

_VW

This view obtains detail of pack and hold shipments from the YNA_SHIPMENT_VW

DOCK_LOCAION_ID = The

dock door from which the

pack-and-hold shipment is

scheduled to be shipped.

TRANSACTION/
Pack_and_Hold.sql
YNA_SHIPMENT_VW

This view exposes the data in the YFS_SHIPMENT table.

None
TRANSACTION/
shipment_vw.sql
YNA_SHIPMENT_ADD_VW This view exposes limited columns from YFS_SHIPMENT table None
TRANSACTION/
Shipment.sql
YNA_SHIPMENT_CONTAINER_VW

This view exposes the data in the YFS_SHIPMENT_

CONTAINER table.

None
TRANSACTION/
Shipment_Container.sql

YNA_SHIPMENT_CONTAINER_

DTL_VW

This view exposes the data in the YFS_CONTAINER

_DETAILS table.

None
TRANSACTION/Shipment_
Container_Detail.sql
YNA_SHIPMENT_LINE_NL_VW

This view exposes limited columns from the YFS_SHIPMENT_LINE table

None
TRANSACTION/
Shipment_LineNL.sql

YNA_SHIPMENT_LINE_

REQ_TAG_VW

This view exposes the data in the YFS_SHIPMENT_

LINE_REQ_TAG table.

None
TRANSACTION/Shipment_
Line_Req_Tag.sql

YNA_SHIPMENT_STATUS

_AUDIT_VW

This view exposes the data in the YFS_SHIPMENT

_STATUS_AUDIT table.

None
TRANSACTION/Shipment_
Status_Audit.sql
YNA_SHIPMENT_TAG_SERIAL

This view exposes the data in the YFS_SHIPMENT

_TAG_SERIAL table.

None TRANSACTION/Shipment_Tag_Serial.sql
YNA_PACK_HOLD_VW

This view obtains details of pack-and-hold shipments from the YNA_SHIPMENT_VW.

DOCK_LOCATION_ID = The dock

door from which the pack-and-hold

shipment is scheduled to be shipped.

TRANSACTION/
Pack and Hold.sql
YNA_BOL_REPORT_VW

This view obtains the summary of all loads by joining the YFS_LOAD, YFS_LOAD_SHIPMENT, and YFS_SHIPMENT tables.

NO_OF_CASES = total number of containers

of type 'Case' included in the load.

NO_OF_PALLETS = total number of

containers of type 'Pallet' included

in the load.

TRANSACTION/BOL_
Report.sql

YNA_CONTAINER_INNER_PACK

_VW

This view exposes data from the YFS_CONTAINER

_INNER_PACK table.

None
TRANSACTION/
ContainerInnerPack.sql
YNA_CONTAINER_STG_LOCN_VW

This view obtains the details of containers in the shipment sort location by joining YNA

_LPN_LOCATION_VW, YNA_

SHIPMENT_CONTAINER_VW,

YNA_SHIPMENT_CONTAINER

_VW, and YNA_SHIPMENT_

CONTAINER_DTL_VW.

None
TRANSACTION/Container_
Staging_Locn.sql

YNA_SHIP_LOAD_CNTR_

SUMMARY_VW

This view returns the number of cases and pallets for a shipment by joining the YNA_SHIPMENT_VW, YNA_LOAD_SHIPMENT

_VW, and YNA_LOAD

_STOP_VW views.

NO_OF_CASES = The total number of cases

without any parent container.

NO_OF_PALLETS = The total number of pallets

without any parent container.

TRANSACTION/Shipment_
Load__Cntr_Summary.sql
YNA_DAILY_SHIPMENT_VW

This view retrieves the data required for

Daily Shipment Report from the YFS_Shipment table.

None
TRANSACTION/Daily_
Shipment.sql
YNA_SHIPMENT_DISCREPANCY_VW

This view retrieves the data required for Vendor Non-Compliance

Report from the YNW_Shipment_Discrepancy table.

None
TRANSACTION/Vendor_
Compliance.sql
YNA_WAVE_VW This view exposes data from the YFS_WAVE table. None
TRANSACTION/Wave.sql