# Schnittstelle Lobster

##### **Profilvariablen**

<table border="1" id="bkmrk-variablenname-datent" style="border-collapse: collapse; width: 99.9683%; height: 2199.56px;"><colgroup><col style="width: 32.7617%;"></col><col style="width: 16.0756%;"></col><col style="width: 51.2114%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**Variablenname**</td><td style="height: 29.7969px;">**Datentyp**</td><td style="height: 29.7969px;">**Verwendung**</td></tr><tr style="height: 46.5938px;"><td style="height: 46.5938px;">VAR\_SHIPMENT\_TRACEID</td><td style="height: 46.5938px;">String</td><td style="height: 46.5938px;">Eindeutige ID für das tracing in VCE. Zusammengesetzt aus Prozessid der Sendung und Prozessid des Packstücks</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_BASE\_SERVICE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die VCE-Interne Bezeichnung des Basis-Frachtservice</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_BASE\_ADDITIONAL\_SERVICE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Optionaler Standard-Zusatzservice auf Basis-Ebene</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_CARRIER\_NAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Der VCE-Interne Frachtführername</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_RETURN\_CARRIER\_NAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Der VCE-Interne Frachtführername für den returnRequest</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_OUTBOUND\_LABEL\_TYPE\_NAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Labeltyp-Name in VCE-Response für Outbound-Label</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_RETURN\_LABEL\_TYPE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Drucktyp für Retourenlabel</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_RETURN\_LABEL\_TYPE\_NAME</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">Labeltyp-Name in VCE-Response für Outbound-Label</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_CARRIER\_CONTRACT</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Der Contract Code für den Outbound-Carrier</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_RETURN\_CARRIER\_CONTRACT</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Der Contract Code für den Retouren-Carrier</td></tr><tr style="height: 46.5938px;"><td style="height: 46.5938px;">VAR\_VCE\_INCOTERM</td><td style="height: 46.5938px;">String</td><td style="height: 46.5938px;">Gemappter Incoterm (aus Sendung oder aus get\_incoterm\_fallback() aka. MAP\_INCOTERM\_FALLBACK)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_REGION</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Empfänger-Region der Sendung (national, eu, worldwide)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_USE\_IMPORTER\_OF\_RECORD</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob ein (abweichender) Importer of Record anzugeben ist</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_AGE\_CHECK</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob für die Sendung eine Alterssichtprüfung nötig ist (und ob 16/18 Jahre)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_CASH\_ON\_DELIVERY</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob für die Sendung Cash on delivery gebucht werden muss</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_IDENTITY\_CHECK</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob für die Sendung ein Ident-Check nötig ist</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_INSURANCE</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob die Sendung zusätzlich versichert werden soll</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_INSURANCE\_VALUE</td><td style="height: 29.7969px;">Integer</td><td style="height: 29.7969px;">Gibt den Versicherungsbetrag an</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SERVICE\_INSURANCE\_CURRENCY</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Gibt die Währung der Versicherung an</td></tr><tr style="height: 46.5938px;"><td style="height: 46.5938px;">VAR\_SHIPMENT\_SERVICE\_MIN\_DAYS\_FUTURE</td><td style="height: 46.5938px;">Integer</td><td style="height: 46.5938px;">Mindestanzahl an Tagen, welche das Lieferdatum in der Zukunft liegen muss (sofern der Service dies verlangt)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_IS\_PACKSTATION</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob eine Sendung an eine Packstation (in DE) verschickt wird</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SUPPRESS\_MAIL\_TO\_CARRIER</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob die E-Mail Adresse beim Carrier unterdrückt wird</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SUPPRESS\_PHONE\_TO\_CARRIER</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob die Telefonnummer beim Carrier unterdrückt wird</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SUPPRES\_EMAIL\_NOTIFICATION</td><td style="height: 29.7969px;">Boolean</td><td style="height: 29.7969px;">Gibt an ob E-Mail Benachrichtigung vom Carrier unterdrückt wird</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 46.5938px;"><td style="height: 46.5938px;">VAR\_SHIPMENT\_VERSANDKOSTEN</td><td style="height: 46.5938px;">BigDecimal</td><td style="height: 46.5938px;">Die Versandkosten der Sendung, aus Versandkostenposition - Fallback: SendungsKopf Extra18</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_ANZAHL\_PAKETE</td><td style="height: 29.7969px;">BigInteger</td><td style="height: 29.7969px;">Anzahl der Pakete in der Sendung</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_ANZAHL\_PAKETE</td><td style="height: 29.7969px;">BigInteger</td><td style="height: 29.7969px;">Anzahl der Pakete im VCE Response</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_ANZAHL\_PAKETE\_RETOURE</td><td style="height: 29.7969px;">BigInteger</td><td style="height: 29.7969px;">Anzahl der Retourenpakete im VCE Response</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_VERSANDKOSTENANTEIL\_PAKET</td><td style="height: 29.7969px;">BigDecimal</td><td style="height: 29.7969px;">Versandkostenanteil pro Paket (Versandkosten / Anzahl Pakete)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_VERSANDKOSTENANTEIL\_ARTIKEL</td><td style="height: 29.7969px;">BigDecimal</td><td style="height: 29.7969px;">Versandkostenanteil pro Stück (Versandkosten / Anzahl Teile)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SENDER\_STREET</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Straße des Absenders (aus VLOG-Mandant xStorage)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_SENDER\_HOUSENUMBER</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Hausnummer des Absenders (aus VLOG-Mandant xStorage)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_FIRSTNAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Vorname des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_LASTNAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Nachname des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_BIRTHDATE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Geburtsdatum des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_NAME1</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Name1 des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_NAME2</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Name2 des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_NAME3</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Name3 des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_NAME4</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Name4 des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_STREET</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Straße des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_HOUSENUMBER</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Hausnummer des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_POSTCODE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Postleitzahl des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_CITY</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Stadt des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_STATE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Staatenkürzel des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_COUNTRY</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Landkürzel des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_MAIL</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Mailadresse des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_RECEIVER\_PHONE</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Telefonnummer des Empfängers</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_BILLING\_STREET</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Straße der Rechnungsadresse</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_SHIPMENT\_BILLING\_HOUSENUMBER</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Die Hausnummer der Rechnungsadresse</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_SHIPMENT\_REQUEST\_PAYLOAD</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">JSON-Payload für den Shipment Request</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td><td style="height: 29.7969px;">  
</td></tr><tr style="height: 46.5938px;"><td style="height: 46.5938px;">LIST\_ERROR\_LABEL\_MESSAGES</td><td style="height: 46.5938px;">LIST</td><td style="height: 46.5938px;">Liste mit Fehlermeldungen für Fehleretikett (aus LIST\_VALIDATION\_ERRORS und LIST\_VCE\_ERRORS)</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_SERIALIZED\_LABEL\_MESSAGES</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Variable mit Liste der Fehlerlabel</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">MAP\_ERROR\_LABEL\_META</td><td style="height: 29.7969px;">MAP</td><td style="height: 29.7969px;">Map mit Metainfos für Fehleretikett</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_SERIALIZED\_LABEL\_META</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Variable mit Metainfos zum Label</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_ERRORLABEL\_FILENAME</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Dateiname des Fehlerlabels</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">VAR\_VCE\_SHIPMENT\_ERRORTEXT</td><td style="height: 29.7969px;">String</td><td style="height: 29.7969px;">Fehlertext für Rückgabe an xStorage</td></tr></tbody></table>

##### **Notizen**

- TraceID manuell vergebbar? Wenn nicht, von VCE erzeugte TraceID an Sendung in Tournummer schreiben
- DHL Postnummer Packstationsversand?

##### **Pfadfernsteuern-Konfiguration für Etikett-Export Aktion**

```sql
select * from pfadfernkonfig where pfadliste = 'ProzessPosition.Prozess.ProzessPositionListe333'

select * from pfadfernkonfigakti where pfadfernkonfigaktiA = 150

insert into pfadfernkonfigakti values(3737,846);
insert into pfadfernkonfigakti values(3737,21311);
insert into pfadfernkonfigakti values(3737,31512);
```

##### **Alles Verpackt (AllesVerpackt)-Eigenschaftsprüfung in Bedingung für Etikett-Export aktion**

```sql
--herausfinden welche entscheidungsbedingung für "AllesVerpackt" zuletzt hinzugefügt wurde, dort muss der "wert" angepasst werden
--damit die Attribute am Bestand korrekt ausgewertet werden und die Bedingung auch funktioniert
select * from entsch_bedingung where eigenschaft like '%AllesVerpackt%' order by datumerfassung desc

--Den Wert der entsprechenden bedingung anpassen auf 111 = Kommissioniert UND 112 = Verpackt
--update entsch_bedingung set wert = '607|112' where bedingungid = 31209
```