EULANDA® ERP System Head Start thru Technology

cn_VLOG_SendungPaket (SQL API)

Back | Level back

Over this procedure a package dispatching program can belong, update such as VLOG, data to packages to a transmission. The actualization is made by the value @PacketID.

The procedure can ber called several times. Only @PacketID and @Mandator must be set with each call.

In this way the tracking number can be supplemented and with another call later the feed date e.g. during a transmission.

Apart from the transmission of the package data also transmission data can be updated over the procedure cn_VLOG_Sendung.

To use it recommended parameters always designated, so that the delivery remains accordingly compatible also when being added further parameters..

Syntax

cn_VLOG_SendungPaket
  @PacketID (int, Input)
  @Mandator (varchar(40), Input)
  @TrackingNr (varchar(50), Input)
  @FeedDate(datetime, Input)
  @SignatureReceiver(varchar(40), Input)

Argument

@PacketID (int, Input)

Package corresponds to the ID field of the table. This ID must be able to assign each case to be transferred around the data to the appropriate package.

@Mandator (varchar(40), Input)

If no mandator name is handed over, then the values which can be changed refer to the main mandator. That is the data base to these procedures belongs.

@TrackingNr (varchar(50), Input)

The Tracking-Number contains the package. If the package ID points to the first package of a transmission (guidance package), also updated the field tracking number of the transmission with this value, if this transmission value is not yet occupied.

@FeedDate(datetime, Input)

The data at that contains the receiver the package in receipt took. If the package ID points to the first package of a transmission (guidance package), also updated the field Tracking-FeedDate of the transmission with this value, if this transmission value is not occupied yet.

@SignatureReceiver(varchar(40), Input)

Contains the name of that, which took the package in receipt. If the package ID points to the first package of a transmission (guidance package), also updated the field signature receiver of the transmission with this value, if this transmission value is not occupied yet.

Example

declare @e int
exec @e = cn_VLOG_SendungPaket @PacketID=251, @TrackingNr='1Z475132'
Select @e [Exec]

In this example in the table "package" the data record with the ID 215 is updated around the indicated tracking number.

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