Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

cn_VLOG_Sendung (SQL API)

Back | Level back

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

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

In this way e.g. a status also only one Tracking number or determined forwarding expenses can be transferred, as soon as this admits to the program is. As soon as the transmission arrived with the receiver, a transmission of this information can likewise take place.

Apart from the transmission of the transmission data over the procedure cn_VLOG_Sendung, additionally the package information can take place over cn_VLOG_SendungPaket.

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

Syntax

cn_VLOG_Sendung
  @TransmissionID (int, Input)
  @Mandator (varchar(40), Input)
  @DispatchDelivery Status(int, Input)
  @DispatchDate (datetime,  Input)
  @DispatchCosten (numeric(18,2), Input)
  @TrackingNr (varchar(50), Input)
  @FeedDate (datetime, Input)
  @SignatureReceiver (varchar(40), Input)
  @ErrorMessage (varchar(1000), Input)
  @Infotext(varchar (1000, Input) 

Argument

@TransmissionID (int, Input)

Correspond to the ID field "transmission" on the table. This ID must to be transferred to the appropriate transmission be able to assign in each case and the data.

@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 this procedure belongs.

@DispatchDeliveryStatus (int, Input)

This value serves for the transmission of the delivery status. The possible values are described in the view EXPORT_VLOG_Sendung_Alle.

@DispatchDate (datetime, Input)

The date indicates, at which the transmissions is handed over to the mail-order house , thus the collection effected. 

@DispatchCost(numeric(18,2), Input)

Indicates forwarding expenses of the transmission, which were determined from the dispatch often commodity to the carrier. 

@TrackingNr (varchar(50), Input)

The Tracking-Number contains of the transmission. A transmission consists of several packages can the main tracking-number or the tracking-number of the guidance package be handed over there. If here nothing is handed over, then when setting a package-tracking-number automatically the tracking number of the guidance package (1. Package) is taken over.

@FeedDate(datetime, Input)

The date at that contains the receiver the transmission in receipt took. A transmission does not consists of several packages needs the field in such a way will transfer, there the value by the guidance package (1. Package) is then taken over.

@SignatureReceiver (varchar(40), Input)

Contains the name of that, which took the transmission in receipt. A transmission does not consists of several packages needs the field in such a way will transfer, there the value y the guidance package (1. Package) is then taken over.

@ErrorMessage (varchar(1000), Input)

If an error arose, then is @DispatchDeliveryStatus to a negative value to set (s.o.). A description of the error can be handed over this text. 

@InfoText (varchar(1000), Input)

This text can be set with each transmissions and contained arbitrary information.

Example

declare @e int
exec @e = cn_VLOG_Sendung @TransmissionID=136, @DispatchDeliveryStatus=2
Select @e [Exec]

In this example the delivery status is set to the value 2, which means that the data were accepted by the dispatch program.