Treum am 22. April 2020 um 15:11 Uhr

2020-04-22T15:11:08Z

Treum: Die Seite wurde neu angelegt: „de:Statusdaten_Export_Standard_Schnitstelle By default the following fields will be exported. Below this table you can find the practical application for d…“

2019-12-06T07:42:18Z

Die Seite wurde neu angelegt: „de:Statusdaten_Export_Standard_Schnitstelle By default the following fields will be exported. Below this table you can find the practical application for d…“

Neue Seite

[[de:Statusdaten_Export_Standard_Schnitstelle]]
By default the following fields will be exported. Below this table you can find the practical application for different export types (CSV, database, …).

{| class="wikitable"
! Fieldname HVS32
! Data type
! Length
! Description
|-
| FFKURZNAME
| Text
| 10
| Identification of the carrier in the host-system.
|-
| FFSTATUSCODE
| Text
| 10
| Carrier specific status code
|-
| FFSTATUSKLARTEXT
| Text
| 250
| Text which describes the status code
|-
| FFZUSATZCODE
| Text
| 10
| Additional status code from the carrier
|-
| FFZUSATZKLARTEXT
| Text
| 120
| Text which describes the additional status code
|-
| ZUSATZKLARTEXT
| Text
| 80
| Additional information
|-
| STATUSORT
| Text
| 50
| Place where the scan/status has been created. (e.g. number of the depot.)
|-
| EMPFANGSQUITTIERER
| Text
| 100
| Name of the receiver, which accepted the shipment.
|-
| STATUSDATETIME
| Text
| 20
| Date and time of the status. (Format: dd.mm.yyyy hh:mm:ss)
Note: Time may not available depending on the carrier
|-
| DRUCKDATETIME
| Text
| 20
| Date and time of the label was creation (Format: dd.mm.yyyy hh:mm:ss)
|-
| AUSGANGDATETIME
| Text
| 20
| Date and time of the transfer from the sender to the carrier (Format: dd.mm.yyyy)
|-
| TRACKINGNR
| Text
| 35
| Tracking number
|-
| VERSANDSENDUNGSNR
| Text
| 20
| Shipment number
|-
| LIEFERSCHEINNR
| Text
| 40
| Delivery note number
|-
| PackageNo
| Integer
|
| Package number within the delivery note number.
|-
| PACKSTUECKID
| Text
| 20
| Uniqe packageID from your host-system (Polling only)
|-
| STATUSTYP
| Text
| 2
| E = End status, Z = interim status
|-
| FEHLERSTATUS
| Text
| 2
| I = Info, F = Fail/Error
|}

=== CSV ===
The fields will be written in a CSV-file separated by semicolons. The field names will build the definition line.
The given length is only the maximum length. The fields won't fill up to this length.

=== Flat file ===
The fields will be written into a TXT-file. The file won’t have a definition line. The fields will be in the order as in the table.
The given length is the size of the fields. The fields will be padded right up to this length.

=== Database / JDBC ===
The status data will be exported to your database using a JDBC driver (jar-file). The default name for the table is “status” but you can choose whichever name you want for either the table or field name(s).

@@ Zeile 10: / Zeile 10: @@
 | FFKURZNAME
 | Text
-| 10
+| 30
 | Identification of the carrier in the host-system.
 |-
@@ Zeile 40: / Zeile 40: @@
 | STATUSORT
 | Text
-| 50
+| 30
 | Place where the scan/status has been created. (e.g. number of the depot.)
 |-
@@ Zeile 50: / Zeile 50: @@
 | STATUSDATETIME
 | Text
-| 20
+| 25
 | Date and time of the status. (Format: dd.mm.yyyy hh:mm:ss)
 Note: Time may not available depending on the carrier
@@ Zeile 56: / Zeile 56: @@
 | DRUCKDATETIME
 | Text
-| 20
+| 25
 | Date and time of the label was creation (Format: dd.mm.yyyy hh:mm:ss)
 |-
 | AUSGANGDATETIME
 | Text
-| 20
+| 25
 | Date and time of the transfer from the sender to the carrier (Format: dd.mm.yyyy)
 |-
@@ Zeile 76: / Zeile 76: @@
 | LIEFERSCHEINNR
 | Text
-| 40
+| 50
 | Delivery note number
 |-
-| PackageNo
+| PACKSTKNR
 | Integer
+| 3
 | Package number within the delivery note number.
 |-

Statusdata export default interface - Versionsgeschichte

Treum am 22. April 2020 um 15:11 Uhr

Treum: Die Seite wurde neu angelegt: „de:Statusdaten_Export_Standard_Schnitstelle By default the following fields will be exported. Below this table you can find the practical application for d…“