Logistics Views

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

Table 1. Logistics Views
View Description Interpreted Columns SQL Filename
YNA_DELIVERY_PLAN_VW This view exposes the data in the YFS_DELIVERY_PLAN table. None TRANSACTION/Delivery_Plan.sql
YNA_LOAD_ADD_VW This view exposes limited columns from the YFS_LOAD table None
TRANSACTION/Load.sql
YNA_LOAD_VW This view exposes the data in the YFS_LOAD table. None TRANSACTION/load_vw.sql
YNA_LOAD_SHIPMENT_VW This view exposes the data in the YFS_LOAD_SHIPMENT table. None TRANSACTION/load_shipment_vw.sql
YNA_LOAD_SHIPMENT_ADD_VW This view exposes limited columns from YFS_LOAD_SHIPMENT None
TRANSACTION/Load_Shipment.sql

YNA_LOAD_SHIPMENT_CHARGE_

VW

This view exposes the data in the YFS_LOAD_SHIPMENT

_CHARGE table.

None TRANSACTION/Load_Shipment_Charge.sql
YNA_LOAD_STATUS_AUDIT_VW This view exposes the data in the YFS_LOAD_STATUS_AUDIT table. None TRANSACTION/Load_Status_Audit.sql
YNA_LOAD_STOP_VW This view exposes the data in the YFS_LOAD_STOP table. None TRANSACTION/load_stop_vw.sql
YNA_LOAD_STOP_ADD_VW This view exposes limited columns from the YFS_LOAD_STOP table None
TRANSACTION/Load_Stop.sql