This set of views expose the Shipment-related data. The set consists of the views described in the following table.
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 |
|
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. |
|
YNA_SHIPMENT_VW | This view exposes the data in the YFS_SHIPMENT table. |
None |
|
YNA_SHIPMENT_ADD_VW | This view exposes limited columns from YFS_SHIPMENT table | None |
|
YNA_SHIPMENT_CONTAINER_VW | This view exposes the data in the YFS_SHIPMENT_ CONTAINER table. |
None |
|
YNA_SHIPMENT_CONTAINER_ DTL_VW |
This view exposes the data in the YFS_CONTAINER _DETAILS table. |
None |
|
YNA_SHIPMENT_LINE_NL_VW | This view exposes limited columns from the YFS_SHIPMENT_LINE table |
None |
|
YNA_SHIPMENT_LINE_ REQ_TAG_VW |
This view exposes the data in the YFS_SHIPMENT_ LINE_REQ_TAG table. |
None |
|
YNA_SHIPMENT_STATUS _AUDIT_VW |
This view exposes the data in the YFS_SHIPMENT _STATUS_AUDIT table. |
None |
|
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. |
|
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. |
|
YNA_CONTAINER_INNER_PACK _VW |
This view exposes data from the YFS_CONTAINER _INNER_PACK table. |
None |
|
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 |
|
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. |
|
YNA_DAILY_SHIPMENT_VW | This view retrieves the data required for Daily Shipment Report from the YFS_Shipment table. |
None |
|
YNA_SHIPMENT_DISCREPANCY_VW | This view retrieves the data required for Vendor Non-Compliance Report from the YNW_Shipment_Discrepancy table. |
None |
|
YNA_WAVE_VW | This view exposes data from the YFS_WAVE table. | None |
|