In this article you will find a complete list of the available fields including a translation of the field names and a description of the contents in English.
XML Tag |
XML Tag Translated |
Required |
Data type |
Business description |
<?xml version="1.0" encoding="UTF-8"?> |
x |
|||
<response> |
x |
|||
<xml> |
x |
|||
<lieferschein_list> |
delivery note list |
x |
||
<lieferschein> |
delivery note |
(x) |
||
<id>68</id> |
id |
(x) |
integer(11) |
Internal ID |
<datum>2020-10-22</datum> |
date |
Date |
Document date in format yyyy-mm-dd |
|
<projekt>6</projekt> |
project |
alphanumeric(222) |
Internal ID of the project the document is assigned to. |
|
<lieferscheinart/> |
delivery note type |
alphanumeric(255) |
Dispatch note type |
|
<belegnr>300065</belegnr> |
voucher number |
alphanumeric(255) |
Document number |
|
<bearbeiter>Firstname Lastname</bearbeiter> |
processor |
alphanumeric(255) |
Accountant |
|
<auftrag>200063</auftrag> |
order |
alphanumeric(255) |
Order number |
|
<auftragid>67</auftragid> |
orderid |
integer(11) |
Internal order number |
|
<freitext/> |
free text |
text |
Free text field |
|
<status>versendet</status> |
status |
alphanumeric(64) |
Status, possible values: versendet, freigegeben |
|
<adresse>47</adresse> |
address |
integer(11) |
Referenced address ID |
|
<name>Test Adresse</name> |
name |
alphanumeric(255) |
Recipient name |
|
<abteilung/> |
department |
alphanumeric(255) |
Recipient department |
|
<unterabteilung/> |
sub department |
alphanumeric(255) |
Recipient sub department |
|
<strasse>Teststraße 11</strasse> |
street |
alphanumeric(255) |
Recipient street |
|
<adresszusatz/> |
address |
alphanumeric(255) |
Recipient address amendment |
|
<ansprechpartner/> |
contact person |
alphanumeric(255) |
Recipient contact person |
|
<plz>86150</plz> |
plz |
alphanumeric(255) |
Recipient ZIP code |
|
<ort>Augsburg</ort> |
location |
alphanumeric(255) |
Recipient city |
|
<land>DE</land> |
country |
alphanumeric(255) |
Recipient country |
|
<ustid/> |
ustid |
alphanumeric(255) |
Recipient vate no. |
|
<email>name@example.com</email> |
|
alphanumeric(255) |
Recipient mail address |
|
<telefon/> |
phone |
alphanumeric(255) |
Recipient phone number |
|
<telefax/> |
telefax |
alphanumeric(255) |
Recipient fax number |
|
<betreff/> |
subject |
alphanumeric(255) |
Recipient subject |
|
<kundennummer>10032</kundennummer> |
customer number |
alphanumeric(64) |
Recipient customer number |
|
<versandart>versandunternehmen</versandart> |
shipping method |
alphanumeric(255) |
Shipping method |
|
<versand>Firstname Lastname</versand> |
shipping |
alphanumeric(255) |
Individual field |
|
<firma>1</firma> |
company |
integer(11) |
Flag, if customer is a company |
|
<versendet>1</versendet> |
shipped |
int(1)/boolean |
Flag, if document was sent via E-Mail/printed |
|
<versendet_am>0000-00-00 00:00:00</versendet_am> |
versendet am |
Datetime |
Document delivery date in format yyyy-mm-dd hh24:MM:SS |
|
<versendet_per/> |
sent by |
alphanumeric(255) |
Delivered with |
|
<versendet_durch/> |
sent by |
alphanumeric(255) |
Delivered by |
|
<inbearbeitung_user>0 </inbearbeitung_user> |
editing user |
int(1)/boolean |
Individual field |
|
<logdatei>2020-10-27 14:56:39</logdatei> |
logdatei |
timestamp |
Date and time of logfile in format yyyy-mm-dd HH24:MI:SS |
|
<vertriebid>10</vertriebid> |
salesid |
integer(11) |
Internal sales ID |
|
<vertrieb>Firstname Lastname</vertrieb> |
sales |
alphanumeric(255) |
Internal sales person |
|
<ust_befreit>0</ust_befreit> |
ust exempt |
int(1)/boolean |
Flag, if customer is VAT-free |
|
<ihrebestellnummer/> |
your order number |
alphanumeric(255) |
Order number of the customer |
|
<anschreiben/> |
letter |
alphanumeric(255) |
title of the person, e.g. Dear Mr. Max Muster |
|
<usereditid>1</usereditid> |
useredit id |
integer(11) |
User ID, who edited the document at last |
|
<useredittimestamp>2020-10-27 14:56:39</useredittimestamp> |
useredit timestamp |
timestamp |
Timestamp of last of last user edit in format yyyy-mm-dd HH24:MI:SS |
|
<lieferantenretoure>0</lieferantenretoure> |
vendor return |
tinyint(1) |
Flag, if it is a return delivery |
|
<lieferantenretoureinfo/> |
vendor return info |
text |
Description of return delivery |
|
<lieferant>0</lieferant> |
vendor |
integer(11) |
Internal distributor ID |
|
<schreibschutz>1</schreibschutz> |
writeprotect |
int(1)/boolean |
Flag, if document is write protected |
|
<pdfarchiviert>0</pdfarchiviert> |
pdf archived |
int(1)/boolean |
Flag, if document Pdf has been archived |
|
<pdfarchiviertversion>0 </pdfarchiviertversion> |
pdf archived version |
integer(11) |
Version number of archived Pdf |
|
<typ>firma</typ> |
type |
alphanumeric(255) |
Type |
|
<internebemerkung/> |
internal note |
alphanumeric(255) |
Internal remark |
|
<ohne_briefpapier>0</ohne_briefpapier> |
without stationery |
int(1)/boolean |
Flag, if document is printed with/without letterhead |
|
<lieferid>0</lieferid> |
delivery id |
integer(11) |
Internal delivery ID |
|
<ansprechpartnerid>0</ansprechpartnerid> |
contact id |
integer(11) |
ID of the contact person |
|
<projektfiliale>0</projektfiliale> |
project branch |
integer(11) |
Project branch |
|
<projektfiliale_eingelagert>0 </projektfiliale_eingelagert> |
project filial stored |
int(1)/boolean |
In stock at project branch |
|
<zuarchivieren>0</zuarchivieren> |
to archive |
int(1)/boolean |
Flag, if to be archived |
|
<internebezeichnung/> |
internal designation |
alphanumeric(255) |
Internal name |
|
<angelegtam/> |
createdon |
datetime |
Document issue date in format yyyy-mm-dd hh24:mi:ss |
|
<kommissionierung>26</kommissionierung> |
picking |
integer(11) |
Commissioning |
|
<sprache>deutsch</sprache> |
language |
alphanumeric(32) |
Language |
|
<bundesland/> |
state |
alphanumeric(64) |
Federal province in Germany |
|
<gln/> |
gln |
alphanumeric(64) |
Global Location Number |
|
<rechnungid>30</rechnungid> |
invoice id |
integer(11) |
Internal invoice ID |
|
<bearbeiterid>10</bearbeiterid> |
agent id |
integer(11) |
Internal accountant ID |
|
<keinerechnung>0</keinerechnung> |
no invoice |
int(1)/boolean |
Invoice / no invoice-Flag |
|
<ohne_artikeltext>0</ohne_artikeltext> |
without itemtext |
int(1)/boolean |
Flag, if article has a name or not |
|
<abweichendebezeichnung>0 </abweichendebezeichnung> |
different name |
int(1)/boolean |
Flag, if article has a divergent name |
|
<kostenstelle/> |
cost center |
alphanumeric(10) |
Cost centre |
|
<bodyzusatz/> |
body addendum |
text |
Amemendment of the body |
|
<lieferbedingung/> |
delivery condition |
text |
Delivery condition |
|
<titel/> |
title |
alphanumeric(64) |
Title |
|
<standardlager>0</standardlager> |
standard warehouse |
int(1)/boolean |
Default warehouse ID |
|
<kommissionskonsignationslager>0 </kommissionskonsignationslager> |
commission consignment warehouse |
int(1)/boolean |
Consignment warehouse ID for commissioning |
|
<bundesstaat/> |
state |
alphanumeric(32) |
Recipient federal state |
|
<teillieferungvon>0</teillieferungvon> |
part deliveryof |
integer(11) |
Partial delivery |
|
<teillieferungnummer>0</teillieferungnummer> |
part deliverynumber |
integer(11) |
Position number of partial delivery |
|
<kiste>1</kiste> |
box |
integer(11) |
Box number |
|
<id_ext/> |
id ext |
alphanumeric |
External ID |
|
<anzahluebertragungen>1</anzahluebertragungen> |
numberofdeliveries |
numeric |
Number of transmissions |
|
<tatsaechlicheslieferdatum/> |
actual delivery date |
date |
Effective delivery date in format yyyy-mm-dd |
|
<lieferdatum/> |
delivery date |
date |
Delivery date in format yyyy-mm-dd |
|
<lieferdatumkw>0</lieferdatumkw> |
delivery datekw |
tinyint(1) |
Calendar week of delivery date |
|
<rechnung_name>HC Test Adresse</rechnung_name> |
invoice name |
alphanumeric(255) |
Invoice name |
|
<auftrag_name>HC Test Adresse</auftrag_name> |
order name |
alphanumeric(255) |
Order name |
|
<rechnung_anrede/> |
invoice address |
alphanumeric(255) |
Invoice salutation |
|
<auftrag_anrede/> |
order address |
alphanumeric(255) |
Order salutation |
|
<rechnung_strasse>Teststraße 11</rechnung_strasse> |
invoice street |
alphanumeric(255) |
Invoice street |
|
<auftrag_strasse>Teststraße 11</auftrag_strasse> |
order street |
alphanumeric(255) |
Order street |
|
<rechnung_adresszusatz/> |
invoice address |
alphanumeric(255) |
Invoice address amendment |
|
<auftrag_adresszusatz/> |
order address address |
alphanumeric(255) |
Order address amendment |
|
<rechnung_ansprechpartner/> |
invoice address address |
alphanumeric(255) |
Invoice contact person |
|
<auftrag_ansprechpartner/> |
order address address |
alphanumeric(255) |
Order contact person |
|
<rechnung_abteilung/> |
invoice department |
alphanumeric(255) |
Invoice department |
|
<auftrag_abteilung/> |
order department |
alphanumeric(255) |
Order department |
|
<rechnung_unterabteilung/> |
invoice subdepartment |
alphanumeric(255) |
Invoice sub department |
|
<auftrag_unterabteilung/> |
order subdepartment |
alphanumeric(255) |
Order sub department |
|
<rechnung_plz>86150</rechnung_plz> |
invoice plz |
alphanumeric(255) |
Invoice ZIP code |
|
<auftrag_plz>86150</auftrag_plz> |
invoice plz |
alphanumeric(255) |
Order ZIP code |
|
<rechnung_ort>Augsburg</rechnung_ort> |
invoice location |
alphanumeric(255) |
Invoice city |
|
<auftrag_ort>Augsburg</auftrag_ort> |
order place |
alphanumeric(255) |
Order city |
|
<rechnung_land>DE</rechnung_land> |
invoice country |
alphanumeric(255) |
Invoice country |
|
<auftrag_land>DE</auftrag_land> |
order country |
alphanumeric(255) |
Order country |
|
<rechnung_gln/> |
invoice gln |
alphanumeric(64) |
Invoice GLN |
|
<auftrag_gln/> |
order gln |
alphanumeric(64) |
Order GLN |
|
<internet/> |
internet |
alphanumeric(255) |
Internet ID, eg. order no. of online shop |
|
<shopextid/> |
shopextid |
alphanumeric(1024) |
External shop ID |
|
<auftragextid/> |
order xtid |
alphanumeric(255) |
Reference of the connected order |
|
<tracking>TESTDN-300065</tracking> |
tracking |
alphanumeric(255) |
Tracking ID of shipment |
|
<lieferschein_position_list> |
delivery note item list |
(x) |
- |
- |
<lieferschein_position> |
delivery note item |
(x) |
- |
- |
<id>74</id> |
id |
(x) |
integer(10) |
Internal dispatch note position ID |
<lieferschein>68</lieferschein> |
delivery note |
integer(11) |
Dispatch note ID |
|
<artikel>17</artikel> |
article |
integer(11) |
Internal article number |
|
<projekt>1</projekt> |
project |
integer(11) |
Internal ID of the project the document is assigned to. |
|
<bezeichnung>MHD/Charge Test</bezeichnung> |
article name |
alphanumeric(255) |
Article name |
|
<beschreibung/> |
article description |
text |
Description |
|
<internerkommentar/> |
internal comment |
text |
Internal comment |
|
<nummer>1000003</nummer> |
nummer |
alphanumeric(255) |
Article number within xentral |
|
<seriennummer/> |
serial number |
alphanumeric(255) |
Serial number |
|
<menge>1.0000</menge> |
quantity |
decimal(14) |
Amount |
|
<lieferdatum>0000-00-00</lieferdatum> |
delivery date |
date |
Delivery date in format: yyyy-mm-dd |
|
<vpe>1</vpe> |
vpe |
int(1)/boolean |
Packing unit |
|
<sort>1</sort> |
sort |
integer(10) |
Sorting number |
|
<status>angelegt</status> |
status |
alphanumeric(64) |
Status: Possible values: |
|
<bemerkung/> |
note |
text |
Remark |
|
<geliefert>1.0000</geliefert> |
delivered |
decimal(14) |
Delivered amount |
|
<abgerechnet>0</abgerechnet> |
accounted |
int(1)/boolean |
Billed-flag |
|
<logdatei>2020-10-22 10:16:08</logdatei> |
logdatei |
timestamp |
Logfile datime |
|
<explodiert_parent_artikel>0</explodiert_parent_artikel> |
exploded parent item |
integer(11) |
Flag if article is a part of a set-article |
|
<einheit/> |
unit |
alphanumeric(255) |
Packaging unit |
|
<zolltarifnummer/> |
customs tariff number |
alphanumeric(128) |
Customs tariff number |
|
<herkunftsland/> |
country of origin |
alphanumeric(128) |
Country of origination |
|
<artikelnummerkunde/> |
article number customer |
alphanumeric(128) |
Customer article number |
|
<freifeld1>1</freifeld1> |
freefield1 |
text |
Free field 1 |
|
<freifeld2>Tsubashi</freifeld2> |
freefield2 |
text |
Free field 2 |
|
<freifeld3/> |
freefield3 |
text |
Free field 3 |
|
<freifeld4/> |
freefield4 |
text |
Free field 4 |
|
<freifeld5/> |
freefield5 |
text |
Free field 5 |
|
<freifeld6/> |
freefield6 |
text |
Free field 6 |
|
<freifeld7/> |
freefield7 |
text |
Free field 7 |
|
<freifeld8/> |
freefield8 |
text |
Free field 8 |
|
<freifeld9/> |
freefield9 |
text |
Free field 9 |
|
<freifeld10/> |
freefield10 |
text |
Free field 10 |
|
<lieferdatumkw>0</lieferdatumkw> |
delivery date week |
tinyint(1) |
Calendar week of delivery date |
|
<auftrag_position_id>143</auftrag_position_id> |
order item id |
integer(11) |
Order position number |
|
<kostenlos>0</kostenlos> |
free |
tinyint(1) |
Free of charge flag |
|
<lagertext>PLANZER (1)</lagertext> |
stock text |
alphanumeric(255) |
Warehouse name |
|
<teilprojekt>0</teilprojekt> |
part project |
integer(11) |
Internal sub project ID |
|
<explodiert_parent>0</explodiert_parent> |
exploded parent |
integer(11) |
Flag if article is a part of a set-article |
|
<freifeld11/> |
freefield11 |
text |
Free field 11 |
|
<freifeld12/> |
freefield12 |
text |
Free field 12 |
|
<freifeld13/> |
freefield13 |
text |
Free field 13 |
|
<freifeld14/> |
freefield14 |
text |
Free field 14 |
|
<freifeld15/> |
freefield15 |
text |
Free field 15 |
|
<freifeld16/> |
freefield16 |
text |
Free field 16 |
|
<freifeld17/> |
freefield17 |
text |
Free field 17 |
|
<freifeld18/> |
freefield18 |
text |
Free field 18 |
|
<freifeld19/> |
freefield19 |
text |
Free field 19 |
|
<freifeld20/> |
freefield20 |
text |
Free field 20 |
|
<freifeld21/> |
freefield21 |
text |
Free field 21 |
|
<freifeld22/> |
freefield22 |
text |
Free field 22 |
|
<freifeld23/> |
freefield23 |
text |
Free field 23 |
|
<freifeld24/> |
freefield24 |
text |
Free field 24 |
|
<freifeld25/> |
freefield25 |
text |
Free field 25 |
|
<freifeld26/> |
freefield26 |
text |
Free field 26 |
|
<freifeld27/> |
freefield27 |
text |
Free field 27 |
|
<freifeld28/> |
freefield28 |
text |
Free field 28 |
|
<freifeld29/> |
freefield29 |
text |
Free field 29 |
|
<freifeld30/> |
freefield30 |
text |
Free field 30 |
|
<freifeld31/> |
freefield31 |
text |
Free field 31 |
|
<freifeld32/> |
freefield32 |
text |
Free field 32 |
|
<freifeld33/> |
freefield33 |
text |
Free field 33 |
|
<freifeld34/> |
freefield34 |
text |
Free field 34 |
|
<freifeld35/> |
freefield35 |
text |
Free field 35 |
|
<freifeld36/> |
freefield36 |
text |
Free field 36 |
|
<freifeld37/> |
freefield37 |
text |
Free field 37 |
|
<freifeld38/> |
freefield38 |
text |
Free field 38 |
|
<freifeld39/> |
freefield39 |
text |
Free field 39 |
|
<freifeld40/> |
freefield40 |
text |
Free field 40 |
|
<zolleinzelwert>0.00000000</zolleinzelwert> |
customs single value |
decimal(18) |
Customs detail value |
|
<zollgesamtwert>0.00000000</zollgesamtwert> |
total customs value |
decimal(18) |
Customs overall value |
|
<zollwaehrung/> |
customs currency |
alphanumeric(3) |
Customs currency |
|
<zolleinzelgewicht>0.00000000</zolleinzelgewicht> |
customs weight |
decimal(18) |
Customs detail weight |
|
<zollgesamtgewicht>0.00000000</zollgesamtgewicht> |
customs total weight |
decimal(18) |
Customs overall weight |
|
<nve/> |
nve |
alphanumeric(255) |
Globally unique Serial Shipping Container Code |
|
<packstueck/> |
package |
alphanumeric(255) |
Packaging item |
|
<vpemenge>0.0000</vpemenge> |
vpe quantity |
decimal(14) |
Amount of packaging units |
|
<einzelstueckmenge>0.0000</einzelstueckmenge> |
item quantity |
decimal(14) |
Amount of individual items |
|
<ausblenden_im_pdf>0</ausblenden_im_pdf> |
hide in pdf |
tinyint1) |
Flag, if article is blanked out on the document Pdf |
|
<id_ext/> |
id ext |
alphanumeric |
External ID |
|
<ean/> |
ean |
alphanumeric(1024) |
EAN |
|
<gewicht/> |
weight |
alphanumeric(255) |
Weight |
|
<herstellernummer/> |
manufacturer number |
alphanumeric(255) |
Manufacturer number |
|
<altersfreigabe/> |
age rating |
alphanumeric(3) |
Age restriction flag (0, 16, 18) |
|
<lagerartikel>1</lagerartikel> |
stock item |
int(1)/boolean |
Flag if article is on stock |
|
</lieferschein_position> |
/delivery note item |
(x) |
||
</lieferschein_position_list> |
/delivery note item list |
(x) |
||
</lieferschein> |
/delivery note |
(x) |
||
</lieferschein_list> |
/delivery note list |
x |
||
</xml> |
x |
|||
<status> |
x |
|||
<action>belege</action> |
x |
alphanumeric |
Static value |
|
<message>OK</message> |
x |
alphanumeric |
Message text: Possible values: OK, |
|
<messageCode>1</messageCode> |
x |
numeric |
Message Code |
|
</status> |
x |
|||
</response> |
x |
Note
Under Transfer specific settings only {BELEGNR}.csv is available for the file name.
XML Tag |
XML Tag Translated |
Required |
Data type |
Business description |
<?xml version="1.0" encoding="UTF-8"?> |
x |
|||
<response> |
x |
|||
<xml> |
x |
|||
<lieferschein_list> |
delivery note list |
x |
||
<lieferschein> |
delivery note |
x |
||
<belegnr>121212</belegnr> |
document number |
x |
alphanumeric(255) |
Document number |
<tracking>1234567890</tracking> |
tracking number |
x |
alphanumeric(255) |
Tracking-Number of the actual carrier |
<tracking_link>http://dhl.de/sendungsverfolgung?tracking=123456</tracking_link> |
tracking link |
alphanumeric(255) |
Tracking-Link |
|
<tracking_sprache>english</tracking_sprache> |
tracking language |
alphanumeric(255) |
language flag of the tracking(number) |
|
<versandart>DPD</versandart> |
carrier or shipment type |
alphanumeric(255) |
Carrier name (Typ) that is used in xentral |
|
<lieferschein_position_list> |
delivery note position list |
(x) |
||
<lieferschein_position> |
delivery note position |
(x) |
||
<id>105</id> |
id |
(x) |
numeric(10) |
Database-ID of the article's position within the document. Needed for pro |
<geliefert>3</geliefert> |
shipped |
decimal(14) |
Amount/pieces |
|
<serial>SN-123456</serial> |
serial |
(x) |
alphanumeric(255) |
Serial number, can be one or multiple lines |
<mhd_charge_block> |
block containing charge or lot |
(x) |
Block containing charge or lot information, can be one or multiple lines |
|
<mhd>2020-12-31</mhd> |
bbd (best before date) |
(x) |
alphanumeric(255) |
Best-Before-Date |
<charge>ABC123</charge> |
charge or lot |
(x) |
alphanumeric(255) |
Batch number |
<menge>2</menge> |
quantity |
decimal(14) |
amount/pieces |
|
</mhd_charge_block> |
/block containing charge or lot |
(x) |
End of block |
|
</lieferschein_position> |
/delivery note position |
x |
||
</lieferschein_position_list> |
/delivery note position list |
x |
||
</lieferschein> |
/delivery note |
x |
||
</lieferschein_list> |
/delivery note list |
x |
||
</xml> |
x |
|||
</response> |
x |
XML Tag |
XML Tag Translated |
Required |
Data type |
Business description |
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> |
x |
|||
<response xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> |
x |
|||
<xml> |
x |
|||
<artikel_list> |
artikel list |
x |
Article list tag open |
|
<artikel> |
artikel |
x |
Article tag open |
|
<nummer>1000012</nummer> |
number |
x |
alphanumeric(255) |
xentral article number |
<lagerzahl>3</lagerzahl> |
stock inventory quantity |
x |
decimal(14) |
Amount of articles picked from the storage location |
<lager_platz>Lagerplatz1</lager_platz> |
stock inventory bin |
(x) |
alphanumeric(255) |
Name of the storage location that is connected with the article |
<mhd>30.10.2018</mhd> |
bbd (best before date) |
alphanumeric(255) |
Use-by date in format dd.mm.yyyy |
|
<charge>TEST1</charge> |
charge or lot |
alphanumeric(255) |
Batch name |
|
</artikel> |
/article |
x |
Article tag close |
|
</artikel_list> |
/article list |
x |
Article list tag close |
|
</xml> |
x |
|||
</response> |
x |
Field Name |
Field Name Translated |
Example Value |
Required |
Business Description |
zeitstempel |
timestamp |
2020-10-10 12:00:00 |
For importers which use the „Ab Datum“ mode this field sets the exact value of the orders date. If the field is missing the process uses the current date as the order date which may cause orders to be skipped |
|
bestelldatum |
order date |
2020-10-10 |
The actual date the order was made in the shop. This gets displayed in the xentral orders as the “ordering date” |
|
lieferdatum |
delivery date |
2020-10-10 |
The (expected) delivery date of the order |
|
auftrag |
order |
100 |
x |
The technical ID (not the number) of the order. This information is relevant for order updates, e.g. by using the functions ImportDeleteAuftrag() or ImportUpdateAuftrag() |
onlinebestellnummer |
online order number |
#UK12345 |
x |
The order number visible in the shop - occasionaly it may be identical to the order ID |
subshop |
subshop |
1 |
The ID of the subshop this order originated from. On occasions it may be a string |
|
useorderid |
useorderid |
1 |
If this field is set and the import mode is set to “Ab Nummer” then the number which gets incremented after an import is not the value in the “auftrag” field but isntead the value in the “onlinebestellnummer” field |
|
onlinebestellnummerueberschreiben |
overwrite online order number |
1 |
Gets used by the process “shopimport_auftragarchiv”. Has the same effect for it as the field “userorderid” for the regular import |
|
benutzergruppe |
user group |
Powerseller |
If the address this order gets mapped to is supposed to be added to a certain group in xentral this field holds the name of the target group |
|
benutzergruppekuerzel |
user group code |
PS |
If the address this order gets mapped to is supposed to be added to a certain group in xentral this field holds the shorthand of the target group |
|
benutzergruppeanlegen |
create user group |
1 |
If the group given in the above fields does not exist a value of 1 in this field will create it in xentral and the cause the address to added to it, 0 otherwise |
|
geburtstag |
birthday |
2000-12-20 |
The buyers birthday |
|
telefon |
phone |
123456789 |
The phone number which is to be saved to the address |
|
name |
name |
Max Power / Compuglobal |
x |
Name of the person who should receive the invoice. If the invoice goes out to a company the company name gets saved in this field |
anrede |
salutation |
firma / herr / frau |
Type of the address, wether it is a company, man, or woman. If more types are defined in the general settings those can be used as well |
|
ansprechpartner |
contact |
Max Mustermann |
if the address is for a company this field holds the information on which person in the company is to receive the invoice. If the order is not made up to a company this field can be left omitted |
|
strasse |
street |
Musterweg 3 |
The street for the invoice address |
|
plz |
zip code |
86111 |
Postal code for the invoice address |
|
ort |
city |
Musterdorf |
City for the invoice address |
|
land |
country |
DE |
Country for the invoice address |
|
|
|
max@muster.mann |
|
|
abteilung |
department |
Vertrieb |
Department of the address |
|
unterabteilung |
subdivision |
Büroartikel |
Subdepartment of the address |
|
adresszusatz |
address addition |
Postfach 17 |
Additional address information for the invoice address |
|
bundesstaat |
state |
Bayern |
State for the invoice address |
|
ustid |
ustid |
DE11001100 |
The VAT ID of the one receiving the invoice |
|
projekt |
project |
9 |
ID of the project |
|
lieferung |
Shipping method |
dhlversenden |
type of shipping method |
|
abweichende_lieferadresse |
different delivery address |
1 |
If both invoice and delivery address are identical for the order this field can be omitted. If they differ this field needs to be filled with a 1 and the field for the delivery address data need to be filled, 0 otherwise |
|
lieferadresse_name |
delivery address name |
Eva Musterfrau |
Name of the person or company receiving the delivery |
|
lieferadresse_ansprechpartner |
delivery address contact |
If the receiver of the delivery is a company this field holds the name of the person in the company receiving it |
||
lieferadresse_strasse |
delivery address street |
Andersstrasse 22b |
Street of the delivery address |
|
lieferadresse_plz |
delivery address plz |
74522 |
Zip code of the delivery address |
|
lieferadresse_ort |
delivery address location |
Andersstadt |
City of the delivery address |
|
lieferadresse_land |
delivery address country |
DE |
Country of the delivery address |
|
lieferadresse_abteilung |
delivery address department |
Vertrieb |
Department of the delivery address |
|
lieferadresse_unterabteilung |
delivery address subdivision |
Büroartikel |
Subdepartment of the delivery address |
|
lieferadresse_adresszusatz |
delivery address addition |
Postfach 17 |
Additional address information of the delivery address |
|
lieferadresse_bundesstaat |
delivery address state |
Bayern |
State of the delivery address |
|
lieferadresse_ustid |
delivery address ustide |
DE11001101 |
The VAT ID of the delivery address |
|
freitext |
freetext |
Beliebiger Text |
A free text which will be saved in the “Freitext” field of the order. Please do not set any preferences on what should happen to the Freitext in the Shop settings in xentral, otherwise this will override the Smarty template information |
|
internebemerkung |
internal remark |
Beliebiger Text |
A free text which will be saved in the “Interne Bemerkung” field of the order. Please do not set any preferences on what should happen to the Freitext in the Shop settings in xentral, otherwise this will override the Smarty template information |
|
gesamtsumme |
grand total |
250.15 |
x |
Gross sum of the order. Is used to countercheck with the total costs of all the positions in the original order. If the total cost of the order gets calculated to a different sum than provided in this field the order protocol will hold the message “Online-Shop Differenz erkannt“ and the autoversand option gets deactivated |
waehrung |
currency |
EUR |
Currency the order is being submitted in |
|
lieferung |
delivery |
dhl_express |
x |
The carrier chosen in the order. Must be mapped in the importer settings |
zahlungsweise |
method of payment |
paypal |
x |
The payment type chosen in the order. Must be mapped in the importer settings |
vorabbezahltmarkieren |
prepaid mark |
1 |
Marks the order as already paid, 0 otherwise |
|
transaktionsnummer |
transaction number |
12 1254215 055421 |
Transaction number for payments made by PayPal |
|
versandkostenbrutto |
shipping cost gross |
11.9 |
Gross delivery cost |
|
versandkostennetto |
shipping cost net |
10.0 |
Net delivery cost. If possbile this field is to beprefered |
|
portosteuersatz |
postage rate |
19.0 |
If the delivery cost has a special tax rat this field holds the information |
|
rabattbrutto |
discount gross |
11.9 |
Gross discount |
|
rabattnetto |
discount net |
10.0 |
Net discount |
|
rabattsteuer |
discount tax |
19.0 |
If the discount has a special tax rat this field holds the information |
|
nachnahmepreisnetto |
cash on delivery net |
10.0 |
gross cash on delivery value |
|
nachnahmepreisbrutto |
cash on delivery price gross |
19.0 |
net cash on delivery value |
|
steuerfrei |
tax exempt |
1 |
Marks the order as tax free, 0 otherwise |
|
ust_befreit |
VAT exempt |
3 |
Marks the order with having a special tax exemption case: 1: tax free EU 2: tax free foreign country 3: tax free within country |
|
steuersatz_normal |
tax rate normal |
20.0 |
Sets the tax rate for “normal” tax rate products |
|
steuersatz_ermaessigt |
tax rate reduced |
10.0 |
Sets the tax rate for “reduced” tax rate products |
|
autoversand |
car shipping |
0 |
Can actively activate or deavticate the autoversand option for orders |
|
fastlane |
fastlane |
1 |
Sets the order to be considered fastlane, 0 otherwise (e.g. for Prime delivery) |
|
auftragsart |
order type |
lieferung |
Controls the way the order is to be processed: standardauftrag - Creates an invoice and delivery note rechnung: Creates just an invoice lieferung: Creates just a delivery note |
|
lastschriftdatenueberschreiben |
overwrite direct debit data |
1 |
This field enables the bank account information to be overwritten by the information in the following fields, 0 otherwise |
|
bankverbindung->inhaber |
bank connection->accountholder |
Max Mustermann |
Name of the account holder |
|
bankverbindung->bank |
bank connection->bank |
Sparkasse Zollernalb |
Name of the Bank |
|
bankverbindung->iban |
bank connection->iban |
DE9715001254451 |
IBAN |
|
bankverbindung->bic |
bank connection->bic |
SOLADESBAL1 |
BIC |
|
bankverbindung->firmensepa |
bank connection->company sepa |
1 |
? |
|
bankverbindung->mandatsreferenzhinweis |
bank connection->mandate reference text |
Hinweis |
||
bankverbindung->mandatsreferenzdatum |
bank connection->mandate reference date |
2020-10-10 |
||
bankverbindung->mandatsreferenz |
bank connection->mandate reference |
123 |
Field Name |
Field Name Translated |
Example Value |
Required |
Business Description |
articlelist |
articlelist |
[] |
x |
An array holding the items of the order |
articleid |
articleid |
Schraube-100 |
x |
Despite the name the field does not hold the ID of the item but instead the SKU |
price |
price |
1.19 |
(x) |
Gross price of the item. Might be used instead of price net. |
price_netto |
price net |
1.0 |
(x) |
Net price of the item. Preferred field to use |
name |
name |
Rote Schraube |
x |
Name of the line item |
quantity |
quantity |
1 |
x |
Quantity |
umsatzsteuer |
sales tax (VAT) |
normal |
Describes which tax rate the product holds: normal, ermaessigt, befreit |
|
steuersatz |
tax rate |
19.0 |
Sets an explicit tax rate for the line item |
|
fremdnummer |
foreign number |
ST-500-100 |
Alternative reference number for which the item is supposed to be searched in the foreign numbers. Mapping occors for the accoring shop only using the shopid as reference |
|
rabatt |
discount (percentage) |
10.0 |
Discount in percent for this line |
|
options |
options |
Schraube mit rotem Kopf und blauem Gewinde |
Description which can be shown in the order, will be interpreted as a single text and added to the PDF output in order and following documents |