Structure of the file

<< 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

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.

 


web_zoom18

You would like to know more about dekodi? Please visit our Website!

 

phone_zoom18

Or call us:  +49 911 310 429 - 10

 

mail_zoom18

Alternatively you can send an email to: info@dekodi.de

 

Impressum