<< Klicke um Table of Contents anzuzeigen >> Navigation: Nexus Interfacebook EN > Importinterfaces > dekodi standard format > Structure of the file |
Version 18.12.1
FieldNo |
Area |
Field name |
Content |
Type |
Kann (K) Muss (M) |
---|---|---|---|---|---|
1 |
A |
ShopID |
Unique ID of the shop or platform where the invoice was created.
Can be freely assigned,
The specification is repeated for each line. |
N |
M |
2 |
A |
ShopName |
Unique name of the shop or platform the invoice was created from.
Can be freely assigned,
The specification is repeated for each line. |
AN |
M |
3 |
A |
OrderID |
Unique ID under which all documents are led to a transaction (delivery notes, invoices, credits, etc.) If it is unclear which field can be used as an order ID, please contact the dekodi customer service desk.
The specification is repeated for each line. |
AN |
M |
4 |
A |
PreviousOrderID |
OrderID of the document to which this invoice belongs; e.g. OrderID of the invoice belonging to a credit. |
AN |
K |
5 |
A |
CustomerID |
Unique ID under which the customer is managed in the shop system.
The specification is repeated for each line. |
AN |
M |
7 |
A |
SubShopName |
Unique name / description of the platform managed by the shop
The name can be freely assigned.
The specification is repeated for each line.
|
AN |
K |
8 |
A |
SubShopOrderID |
Unique number under which the order is kept in the managed platform.
The specification is repeated for each line. |
AN |
K |
9 |
K |
CurrencyCode |
Currency in which the invoice was created (ISO-4217), e.g. "EUR"
Only required once per invoice (in the first line).
|
AN |
M |
10 |
K |
DebtorNo |
Debtors number – The customer uses the debtor no. in accounting. Only required once per invoice (in the first line). |
N |
K |
11 |
K |
InvoiceNo |
Number of the Invoice or Credit-Note Only required once per invoice (in the first line). |
AN |
M |
12 |
K |
InvoiceDate |
Billing-/ credit date Only required once per invoice (in the first line). |
T |
M |
13 |
K |
PreviousInvoiceNo |
Invoice / credit memo number of the predecessor document; e.g. the invoice number, if the current document is a credit note. |
AN |
K |
14 |
K |
PreviousInvoiceDate |
Invoice / credit memo number of the predecessor document; e.g. the invoice number, if the current document is a credit note. |
T |
K |
15 |
K |
TotalNetAmount |
Total invoice amount from the invoice items net, i.e. without shipping or CashOnDeliveryAmount For credits negative Only required once per invoice (in the first line). |
D |
M |
16 |
K |
TotalVATAmount |
Total VAT, from the invoice items, i.e. without tax from Shipingamount or CashOnDeliveryAmount. For credits negative Only required once per invoice (in the first line). |
D |
M |
17 |
K |
TotalGrossAmount |
Total gross amount, including ShippingAmount and CashOnDeliveryAmount. For credits negative. Only required once per invoice (in the first line). |
D |
M |
18 |
K |
ShippingAmount |
Shipping costs for credits negative. The shipping cost will be tax separated. |
D |
K |
19 |
K |
CashOnDeliveryAmount |
Fees for cash on delivery etc.. For credits negative. Only required once per invoice (in the first line). The shipping cost will be tax separated |
D |
K |
20 |
K |
CouponAmount |
Voucher amount Only for invoices, negative value not allowed. Specification only required once per invoice (in the first line) |
D |
K |
21 |
K |
CompanyName |
Name of the company Specification only required once per invoice (in the first line). |
AN |
K* |
22 |
K |
FirstName |
First name of the customer Specification required only once per invoice (in the first line). |
AN |
K |
23 |
K |
FamilyName |
Last name of the customer Specification only required once per invoice (in the first line). |
AN |
K* |
24 |
K |
Email address of the customer Specification only required once per invoice (in the first line). |
AN |
K |
|
25 |
K |
VATID |
Sales tax identification number of the bill-recipient Specification required only once per invoice (in the first line). |
AN |
K |
26 |
K |
Country |
Invoice receiving country Country code ISO-3166 (2- or 3-digits) Only required once per invoice(in the first line) |
AN |
M |
27 |
K |
DeliveryCountry |
Supplying country, if different from country Country code ISO-3166 (2- or 3-digits) Specification only required once per invoice(in the first line) |
AN |
K |
28 |
K |
TrackingNumber |
Tracking number Specification only required once per invoice (in the first line). |
AN |
K |
29 |
K |
PaymentTypeID |
Unique number of the means of payment. The ID should match the PaymentTypeIDs specified by dekodi, but can basically be freely assigned. The number must be unique in each case. Only required once per invoice (in the first line). |
N |
K1) |
30 |
K |
PaymentTypeName |
Name of the payment, e.g. "debit", "PayPal", "Amazon" See below Only required once per invoice (in the first line) |
AN |
K1) |
31 |
K |
PaymentTransactionNo1 |
Transaction no. / payment information for means of payment. (Starting with Nexus 19.12.2, you can supply multiple Paypal Transaction IDs, separated by arbitrary characters.) See below Only required once per invoice (in the first line). |
AN |
K |
32 |
K |
PaymentTransactionNo2 |
Transaction no. / payment information for means of payment See below Only required once per invoice (in the first line). |
AN |
K |
33 |
K |
FactoringStatus |
0 = no Factoring 1 = bought 2 = denied Only required once per invoice (in the first line). |
N |
K |
34 |
K |
DocumentLink |
File name or link to download the invoice / credit PDF document Only required once per invoice (in the first line). |
AN |
K |
35 |
P |
DistributionCountry |
Country code ISO-3166 (2- or 3-digits) of supplying country. The field must always be filled, if the country from which the goods are shipped does not correspond to the registered office of the company or if the goods are shipped from different countries. This applies, for example, if the shipment is made within the FBA via Amazon Poland or the Czech Republic. |
AN |
K (M) |
36 |
P |
DistributionCenterID |
ID of the warehouse from which the goods were shipped |
AN |
K |
37 |
P1 |
NetAmount |
Inactive - fill with valid blank value |
D |
M |
38 |
P1 |
VATPercent |
Inactive - fill with valid blank value |
D |
M |
39 |
P1 |
GrossAmount |
Inactive - fill with valid blank value |
D |
M |
40 |
P2 |
ArticleNo |
Number of sold item |
AN |
M |
41 |
P2 |
ArticleDescription |
Name of the sold article |
AN |
K |
42 |
P2 |
ArticleQuantity |
Amount of sold items |
D |
M |
43 |
P2 |
ArticleNetAmount |
Unit price of the item (net) For credits negative |
D |
M |
44 |
P2 |
ArticleVATPercent |
VAT rate of the article in % |
D |
M |
45 |
P2 |
PositionTotalNetAmount |
Total of invoice item (net) |
D |
M |
46 |
P2 |
PositionTotalGrossAmount |
Total of the invoice item (gross) For credits negative |
D |
M |
*) Please note the information in the section "Notes"
To 1: PreviousOrderID, PreviousInvoiceNo, PreviousInvoiceDate
These fields have no function in the current version. If these are filled, there will be no evaluation.
To 2: PaymentTypeID / PaymentTypeName
Ideally, specify PaymentTypeID and PaymentType name. If this is not possible for technical reasons, it is sufficient to specify a unique combination of ID and name of the payment method in the above fields
For example the field PaymentTypeID can always have the value 0 if the name of the means of payment is unique. Conversely, the PaymentTypeName field can be left blank if a unique PaymentTypeID is passed for it.
You would like to know more about dekodi? Please visit our Website!
Or call us: +49 911 310 429 - 10
Alternatively you can send an email to: info@dekodi.de