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_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 |
|
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 |
|
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 |
|