Bestellungen auslesen¶
Die Bestellungen können über einen GET
-Request über die URL /api/legacy/order?oid=1023
geladen werden.
Das Ergebnis wird als Dataset zurückgeliefert.
Parameter¶
Parameter | Beschreibung |
---|---|
oid | Alvine Bestellnummer OID |
billNumber | Rechnungsnummer |
companyOrderID | Bestellnummer Mandant |
Felder¶
Feld | Beschreibung | Beispiel |
---|---|---|
uid | Benutzer UID | |
companyOrderID | Bestellnummer Mandant | |
daid | ID der Lieferadresse | |
aaid | ID der Rechnungsadresse | |
customerIdentCode | ||
shippingDcid | ID der Lieferkondition DCID | |
shippingNotice | Liefernotiz | |
companyOrderData | Original Daten einer externen Bestellung | |
companyOrderState | Status einer externen Bestellung | |
companyOrderDate | Datum einer externen Bestellung | |
p_provider_id | ||
p_provider | ||
p_date | ||
p_intern_state | ||
data | ||
exportFlag | ||
exportDate | ||
fraud | ||
affiliateID | ||
deliveryNotice | ||
oid | Bestellnummer | |
cegReid | ||
ip | ||
ticketIDs | ||
state | ||
date | ||
date_f | 09.10.2017 09:22:12 | |
date_date_f | 09.10.2017 | |
date_timestamp | 1507540932 | |
resubmission_f | 00.00.0000 | |
p_date_f | 09.10.2017 09:27:15 | |
p_state | 15 | |
p_notice | CAPTURED | |
notice | Notiz | |
shid | Mandant ID | 1 |
aid | Adress ID | 38 |
contact | Kontakt | |
company | Firma | schukai GmbH |
address1 | Strasse und Hausnummer | An den Linden 34 |
address2 | Adresszusatz / CO | Max Mustermann |
zipcode | Postleitzahl | 85214 |
city | Stadt | Lindenhain |
country | Land | de |
systemSpecial | Lieferung an eine Packstation (intern) | |
pid | Payment ID | 358 |
personalName | Name | Hans Eckert |
personalFormofaddress | Anrede | Herr |
personal_lt_formofaddress | Briefanrede | Sehr geehrter Herr Eckert |
personalTitle | Titel | Dr. |
personalSurname | Nachname | Eckert |
personalFirstname | Vorname | Hans |
personalBirthday | Geburtstag | 0000-00-00 |
personalCustom1 | Kundenspezifische Daten | |
personalCustom2 | Kundenspezifische Daten 2 | |
username | Benutzername | OL_test3@example.com_20180117101948 |
type | 6 | |
__maxrowcount | 1 | |
personal | Eckert, Herr Hans | |
personal_tooltip | ||
noticeShort | ||
personal_lt | ||
positions | Positionen | |
deliveries | Lieferungen |
Position¶
Feld | Beschreibung | Beispiel |
---|---|---|
scid | Warenkorb ID | 1472 |
pscid | ||
uid | Benutzer ID | 43 |
item_name | Name | Waschmittel |
item_number | Artikelnummer | 10085 |
customer_number | Kundennummer | |
packaging_gift_iid | 0 | |
sid | Session ID | |
iid | Produkt IID | 10085 |
optional | Variante | UNIQUE |
ean | EAN | 3625974522478 |
count | Menge | 1 |
oid | Bestellnummer | 1023 |
reorder | 0 | |
price | Brutto Preis | 1299 |
netto | Netto Preis | 1092 |
did | ID der Lieferung | 1021 |
flag_stockupdated | Bestandsbuchung | 1 |
custom1 | ||
custom2 | ||
custom3 | ||
price_type | 0 | |
description | Beschreibung | |
currency | Währung | EUR |
pdid | 0 | |
lid | Lagerort ID | 0 |
vat | Steuern | 1900 |
data | ||
serialnumber | ||
customertext | ||
price_recommended | 0 | |
netto_recommended | 0 | |
delivery_type | 0 | |
delivery_id | 0 | |
salesman_uid | 0 | |
base_price_net | 0 | |
base_price_gross | 0 | |
base_measure_unit | ||
base_measure_reference | 0 | |
base_measure_value | 0 | |
sales_group | 1 | |
images | Bilder | "main": "/image/alvine/gfx/item/10085/alvine.jpg?time=1522983724" |
Lieferung¶
Feld | Beschreibung | Beispiel |
---|---|---|
did | ID | 1021 |
date | Datum | 2017-10-09 10:27:39 |
picklist_id | ID der Pickliste | 0 |
bill_number | Rechnungsnummer | 1021-1023-43 |
oid | Bestellnummer | 1023 |
fdate | Datum formatiert | 09.10.2017 10:27:39 |
timestamp_unix_date | 1507544859 | |
timestamp_unix_billdate | 1507544859 | |
state | Status | 15 |
servicenumber | ||
servicecompany | 0 | |
deliverydate | Datum der Auslieferung | 2017-10-09 09:27:48 |
fdeliverydate | Datum der Auslieferung formatiert | 09.10.2017 09:27:48 |
receiving_date | 0000-00-00 00:00:00 | |
receiving_date_f | 00.00.0000 | |
packet_number | Paketnummer | |
packet_number_retoure | Paketnummer des Retourenscheines | |
resubmission | 0000-00-00 | |
resubmission_info | ||
flag_ | 0 | |
notice | Notitz | |
address_account | Rechnungsadresse | |
address_delivery | Lieferadresse |
Adresse¶
Feld | Beschreibung | Beispiel |
---|---|---|
aid | 38 | |
uid | 43 | |
company | ||
contact | Herr Hans Eckert | |
address1 | An den Linden 34 | |
address2 | ||
city | Lindenhain | |
state | ||
zipcode | 85214 | |
country | de | |
preset | 1 | |
description | ||
type | 4 | |
system_special | ||
erpid | ||
erpname | ||
erpnumber | ||
additive1 | ||
additive2 | ||
lt_formofaddress | Sehr geehrter Herr Eckert | |
formofaddress | Herr | |
firstname | Hans | |
name | Eckert |
{
"dataset": {
"7d0a1810-472b-42bf-ea1e-4ab16a4ff680": {
"uid": "43",
"company_orderid": "",
"daid": "38",
"aaid": "38",
"customer_identcode": "",
"shipping_dcid": "1",
"shipping_notice": "",
"shipping_data": "",
"company_orderdata": "",
"company_orderstate": "0",
"company_orderdate": "0000-00-00 00:00:00",
"p_provider_id": "0",
"p_provider": "",
"p_date": "2017-10-09 09:27:15",
"p_intern_state": "15",
"data": "",
"exportflag": "0",
"exportdate": "",
"fraud": "0",
"affiliate_id": "0",
"delivery_notice": "",
"oid": "1023",
"ceg_reid": "0",
"ip": "::1",
"ticket_ids": "",
"state": "57",
"date": "2017-10-09 09:22:12",
"date_f": "09.10.2017 09:22:12",
"date_date_f": "09.10.2017",
"date_timestamp": "1507540932",
"resubmission_f": "00.00.0000",
"p_date_f": "09.10.2017 09:27:15",
"p_state": "15",
"p_notice": "CAPTURED",
"notice": "",
"shid": "1",
"aid": "38",
"contact": "",
"company": "",
"address1": "An den Linden 34",
"address2": "",
"zipcode": "85214",
"city": "Lindenhain",
"country": "de",
"system_special": "",
"pid": "358",
"personal_name": "Hans Eckert",
"personal_formofaddress": "Herr",
"personal_lt_formofaddress": "Sehr geehrter Herr Eckert",
"personal_title": "",
"personal_surname": "Eckert",
"personal_firstname": "Hans",
"personal_birthday": "0000-00-00",
"personal_custom1": "",
"personal_custom2": "",
"username": "OL_test3@example.com_20180117101948",
"type": "6",
"__maxrowcount": "1",
"personal": "Eckert, Herr Hans",
"personal_tooltip": {
"Kontakt": [
[
{
"value": "E-Mail"
},
{
"value": "test3@example.com",
"link": "mailto:test3@example.com"
}
]
]
},
"noticeshort": "...",
"personal_lt": "Herr Hans Eckert",
"positions": [
{
"scid": "1472",
"pscid": "",
"uid": "43",
"item_name": "Waschmittel",
"item_number": "10085",
"customer_number": "",
"packaging_gift_iid": "0",
"sid": "",
"iid": "10085",
"optional": "_UNIQUE_",
"ean": "3625974522478",
"count": "1",
"oid": "1023",
"reorder": "0",
"price": "1299",
"netto": "1092",
"did": "1021",
"flag_stockupdated": "1",
"custom1": "",
"custom2": "",
"custom3": "",
"price_type": "0",
"description": "",
"currency": "EUR",
"pdid": "0",
"lid": "0",
"vat": "1900",
"data": "",
"serialnumber": "",
"customertext": "",
"price_recommended": "0",
"netto_recommended": "0",
"delivery_type": "0",
"delivery_id": "0",
"salesman_uid": "0",
"base_price_net": "0",
"base_price_gross": "0",
"base_measure_unit": "",
"base_measure_reference": "0",
"base_measure_value": "0",
"sales_group": "1",
"images": {
"main": "/image/alvine/gfx/item/10085/alvine.jpg?time=1522983724"
}
}
],
"deliveries": [
{
"did": "1021",
"date": "2017-10-09 10:27:39",
"picklist_id": "0",
"bill_number": "1021-1023-43",
"oid": "1023",
"fdate": "09.10.2017 10:27:39",
"timestamp_unix_date": "1507544859",
"timestamp_unix_billdate": "1507544859",
"state": "15",
"servicenumber": "",
"servicecompany": "0",
"deliverydate": "2017-10-09 09:27:48",
"fdeliverydate": "09.10.2017 09:27:48",
"receiving_date": "0000-00-00 00:00:00",
"receiving_date_f": "00.00.0000",
"packet_number": "",
"packet_number_retoure": "",
"resubmission": "0000-00-00",
"resubmission_info": "",
"flag_": "0",
"notice": "",
"address_account": {
"aid": "38",
"uid": "43",
"company": "",
"contact": "Herr Hans Eckert",
"address1": "An den Linden 34",
"address2": "",
"city": "Lindenhain",
"state": "",
"zipcode": "85214",
"country": "de",
"preset": "1",
"description": "",
"type": "4",
"system_special": "",
"erpid": "",
"erpname": "",
"erpnumber": "",
"additive1": "",
"additive2": "",
"lt_formofaddress": "Sehr geehrter Herr Eckert",
"formofaddress": "Herr",
"firstname": "Hans",
"name": "Eckert"
},
"address_delivery": {
"aid": "38",
"uid": "43",
"company": "",
"contact": "Herr Hans Eckert",
"address1": "An den Linden 34",
"address2": "",
"city": "Lindenhain",
"state": "",
"zipcode": "85214",
"country": "de",
"preset": "1",
"description": "",
"type": "4",
"system_special": "",
"erpid": "",
"erpname": "",
"erpnumber": "",
"additive1": "",
"additive2": "",
"lt_formofaddress": "Sehr geehrter Herr Eckert",
"formofaddress": "Herr",
"firstname": "Hans",
"name": "Eckert"
}
}
]
}
}
}
Fehlermeldungen¶
Wenn die Bestellung nicht gefunden wurde wird der Status Code 404 gesendet
{
"sys": {
"error": {
"code": 404,
"message": "404 Not Found"
}
}
}