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 [email protected]_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": "[email protected]_20180117101948",
            "type": "6",
            "__maxrowcount": "1",
            "personal": "Eckert,  Herr Hans",
            "personal_tooltip": {
                "Kontakt": [
                    [
                        {
                            "value": "E-Mail"
                        },
                        {
                            "value": "[email protected]",
                            "link": "mailto:[email protected]"
                        }
                    ]
                ]
            },
            "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"
        }
    }
}