EULANDA® ERP System Head Start thru Technology
Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us
Password needed Newsgroup
EXPORT_VLOG_SendungPaket_Alle (SQL API)
This view contains package data to the transmissions, which are particularly for the subsequent treatment of the dispatch often commodity VLOG prepared. The data are not filtered, that means that all packages are specified to all transmissions here, independently whether these are intended for VLOG or whether these have a dispatch delivery status set by VLOG.
Fields
| PaketID (int, Not Null) |
| This field contains the ID to data record
of the table package.
|
| TransmissionID (int, Not Null) |
| This field contains the ID to data record
of the table transmission.
|
| Mandator (varchar(40), Not Null) |
| The mandator name results from the name
of the data base. It does not contain the prefix "EULANDA_ in
contrast to the data base name_". a data base name with name "EULANDA_Mustermann“
has according to the mandator names "Mustermann“.
|
| Nr (int, Not Null) |
| The current package number contains of a
transmission. The "NR" always begins per transmission with 1. The
highest number is always the number of package per transmission.
|
| Weight (numeric(18,4), Not Null) |
| The packet weight in kg.
|
| Volume (numeric(18,4), Null) |
| The package volume in litres.
|
| Length (int, Null) |
| Length of the package in cm. |
| Width (int, Null) |
| Width of the package in cm. |
| Height (int, Null) |
| Height of the package in cm. |
| The description of the goods (varchar(128), Not Null) |
| A description contains of transmission. The description of goods is taken over from the object field of the EULANDA® order. |