EULANDA® ERP System Head Start thru Technology

Views (SQL API)

Back | Level back

Here are only a small excerpts of listed views from EULANDA® contained views.

User Views

In EULANDA® among other things following views are used:

EXPORT_VLOG_Sendung

Contains delivery notes, which are to wait for the dispatch and be handed over to the dispatch often commodity VLOG. This view is filtered over the field VersandUbergabeStatus and indicates only entries, with which this field has the value "1“. An appropriate view, however without this is present as EXPORT_VLOG_Sendung_Alle.

EXPORT_VLOG_Sendung_Alle

Contains delivery note data, which are particularly for the dispatch often commodity VLOG prepared. The view is not filtered and indicates also delivery notes, which are not intended for VLOG. The view EXPORT_VLOG_Sendung should be used for reading from this reason.

EXPORT_VLOG_SendungPaket

Contains packages, which are to wait for the dispatch and be handed over to the dispatch often commodity VLOG. This view is filtered over the field VersandUbergabeStatus, which is linked with the table delivery note, and indicates only entries, which this field has the value "1“. An appropriate view, however without this filter is present as EXPORT_VLOG_SendungPaket_Alle.

EXPORT_VLOG_SendungPaket_Alle

Contains delivery note package data, which are particularly for the dispatch oftern commodity VLOG prepared. The view is not filtered and indicates also packages which are not intended for VLOG. The view EXPORT_VLOG_SendungPaket should be used for reading from this reason.

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.