Zum Ende der Metadaten springen
Zum Anfang der Metadaten

Sie zeigen eine alte Version dieser Seite an. Zeigen Sie die aktuelle Version an.

Unterschiede anzeigen Seitenhistorie anzeigen

Version 1 Nächste Version anzeigen »

Table of content


GENERAL

Customer and invoice data can be stored in an ASCII file or split into two files; If only one file is created, then there are also own record identifiers which organizationally separate the data.

The variable record format will also receive additional fields in the future, ie a third party based on this format should develop its converter so that not every newly added field causes incompatibilities.

LINE SEPARATOR:

chr (13) + chr (10) (Hex: 0D0A)

FIELD TYPE

grade

description

A

alpha

N

Numeric (with leading zeros)

D

Date (ddmmyy)

MANDATORY LEGEND

field

information

MMust contain an indication
KMay contain an indication
VField takes precedence over another specially marked field
MDAdditional fields from MOTIONDATA

CONTROL CODES IN THE MOTIONDATA / TAX CODES IN MOTIONDATA (ONLY FOR INFORMATION):

Motion data code

Type *

definition

0

U

VAT 0%

1

U

VAT 10%

2

U

VAT 20% (standard)

5

V

Input tax 20%

6

V

Input tax 0%

7

V

Input tax 10%

A

U

Export - Third countries 0%

L

U

Export EU IL 0%

M

U

VAT not taxable 0%

P

U

Tax exempt according to. A6 / 1 0

R

U

Income tax EU IR 0%

U

V

Import EU 0%

V

V

VAT not taxable 0%

X

U

VAT exchange parts 10% (Germany)


Type *

information

Mvalue added tax
Vpilot

Fields without information must be filled with spaces.


RECORD DESCRIPTION OF CUSTOMER / CUSTOMER INFORMATION

The number column indicates the field index for the variable sentence structure; in this case, the lengths are also irrelevant, they only apply to the format with the fixed sentence length.

#

field name

Internal name

Type

Lng.

From

To

comment

1

Record Type

cKontenArt

A

1

1

-

"K" (for customer), "L" for supplier

2

Company number

cFirma

N

2

2

3

Company number, which can be entered in the interface main menu

3

account number

cKontoNr

N

7

4

10

Customer Account Group + Kundat: Persnr

4

name1

cName1

A

30

11

40

Kundat: name1

5

name2

cName2

A

30

41

70

Kundat: name2

6

country

Cland

A

3

71

73

Kundat: Country

7

place

Cort

A

22

74

95

Kundat: City

8th

Road

cStrasse

A

30

96

125

Kundat: Street

9

phone

cTelefon

A

20

126

145

Kundat: Tel_buero or Tel_privat

10

short name

cKurzName

A

8th

146

153

Kundat: Name1 from 1 - 8 (mandatory field in the IBM financial system !!!)

11

Post Code

cPLZ

N

5

154

158

Kundat: Plz (Without blanks and hyphens; Attention: With Austrian adaptations the HS automatically takes only 4 places!)

12

Terms of payment

cZahlBed

A

3

159

161

Kundat: Zkond_cd

13

Title code

cAnredeCd

A

3

162

164

Kundat: Title

14

mobile phone

cTelMobil

A

30

165

194

Kundat: Tel_mobil

15

fax

cTeleFax

A

30

195

224

Kundat: Fax

16

E-mail

cEMail

A

50

225

274

Kundat: Email

17

uid

Cuid

A

15

275

289

Kundat: uid

18

address text

cAnredeText

A

35

290

324

Conversion from Anredecode

19

name1

cName1Lang

A

50

325

374

Kundat: Name1 LANG

20

name2

cName2Lang

A

50

375

424

Kundat: Name2 LANG

21

first given name

cVorname

A

50

425

474

Kundat: First name_AB LANG

22

place

cOrtLang

A

50

475

524

Kundat: Location LANG

23

Road

cStrasseLang

A

50

525

574

Kundat: Street LANG

24

Post Code

cPLZLang

N

8th

575

582

Kundat: Plz LANG

25

net days

nNettoTage

N

3

583

585

due date

26

Zessionscode

cZessionsCode

A

3

586

588

Zessionstextcode

27

tax number

cSteuerNr

A

20

589

608

Personal tax number (eg Italy, Poland)

28

bank code

cBankleitzahl

A

10

609

618

bank code

29

Bank Account

cBankKonto

A

40

619

658

bank account

30

debit

cBankeinzug

A

2

659

660

Direct debit registration 
EL = Direct debit 
AL = 
Direct debit KL = No direct debit

31

Customer revenue group

cKundenerloes

A

6

661

666

Customer revenue group (eg EXTSTD) 
Only available as an option, format 6.3.x!

32

sales consultant

cLtz_Verk

A

5

667

671

Kundat.Ltz_Verk 
Only available as an option, format 6.3.x!

33

Customer Service Advisor

cKdBerater

A

5

672

676

Kundat.KdBerater 
Only available as an option, format 6.3.x!

34

parts seller

cEtVerkaeufer

A

5

677

681

Kundat.EtVekaeufer 
Only available as an option, format 6.3.x!

35

nationality

cKundenKzLand

N

1

682

682

1 = Austria, 2 = EU, 3 = third country 
Only available as an option, format 6.3.x!

36

bank code

cBankleitzahlLang

C

20

683

702

Only available as an option, format 6.4.x!

37

cash discount deadline

nSkontoTage

N

3

703

705

Only available as an option, format 6.4.x!

38

Skontoproz.

nSkontoProzent

N

5

706

710

2 preamble 2 decimal 
places Only available as an option, format 6.4.x!


RECORD DESCRIPTION BILLING DOCUMENTS / INVOICE INFORMATION

  • The number column indicates the field index for the variable sentence structure; in this case, the lengths are also irrelevant, they only apply to the format with the fixed sentence length.
  • In the variable sentence structure, the first 5 fields are combined into one field information, they have more or less only historical significance.
  • If a field has no number, it does not exist in variable format.
  • Amount fields always have their sign directly in the variable sentence structure.
  • If a field has no length or from / to information, then it does not exist in the fixed sentence format.
  • Decimal separators can vary in variable record format, since they can be set in MD.
  • In variable record format, date fields always have the structure YYYYMMDD.
  • In Variable Record format, the first line may contain the column names depending on the MD setting.

#

field name

Internal name

Type

M / V / K

L

From

To

comment

#

field name

Internal name

Type

M / V / K

L

From

To

comment

1

set mark


A

M

1

1

-

"3"

1

takeover marks


A

M

2

2

3

blanks

1

Record Type


A

M

1

4

-

"B"

1

booking system


A

M

2

5

6

"FI"

1

Actual booking


A

M

1

7

-

"A"

2

tuning


A

M

1

8th

-

blanks

3

company

cFirma

N

M

2

9

10

z. Eg "01"

4

booking text

cBuchText1

A

K

20

11

30

Booking text 1st line → order number + "" + invoice code + "-" + invoice no.

5

Fremdbelegnr

cFremdBeleg

A

K

20

31

50

blanks

6

tax code

cSteuerCd

A

K

3

51

53

VAT code as in MD for the booking codes; ("M" + 20% Ust → "M20"); Blank for customer header posting



nUStProNV2

Created only from the FiBu converter base from the original control code

7

Terms of payment

cZahlBed

A

M

3

54

56

Terms of payment according to MD (Zkond_cd)

8th

net payment

nNettoTage

N

V

3

57

59

Will only be turned off when advanced payment terms are enabled in the MOTIONDATA communication settings

9

cash discount deadline

nSkontoTage

N

V

3

60

62

 

10

Skontoproz.

nSkontoPro

N

V

5

63

67

2 preamble 2 decimal places; is filled with "00.00" or discount percentage according to payment conditions of the operating data.

-

record number

nSatzNr

N

K

7

68

74

zero

11

booking date

dBuchDatum

D

M

6

75

80

DDMMYY - is filled with the date of the day

12

document date

dBelegDatum

D

M

6

81

86

DDMMYY - will be filled with invoice date

13

OP-due date

dFaellDatum

D

V

6

87

92

DDMMYY - Filled if net days are deposited after the payment term (3.2) and in the communication settings of MOTIONDATA the extended payment conditions are activated

14

Discount due date

dSkontoDatum

D

V

6

93

98

DDMMYY - is filled with the invoice date or a "discount date" is determined with the discount days according to the operating data and the invoice date

15

Cost centre

cKostenStelle

N

K

7

99

105

Cost centre

16

document number

cBelegNr

N

M

7

106

112

Invoice number for orders

17

Have an account

cKontoHaben

N

M / K

7

113

119

 

18

Account debit

cKontoSoll

N

M / K

7

120

126

 

19

Voucher Account

cBelegHaben

N

M / K

7

127

133

For cash book entries from the procurement system, the original invoice number

20

Voucher Account Target

cBelegSoll

N

M / K

7

134

140

For cash book entries from the procurement system, the original invoice number

21

booking amount

nBuchBetrag

N

M

12

141

152

2 decimal places with "." separate

-

sign


A

K

1

153

-

Sign of the amount (+/-)

22

VAT ID Account

cUIDKonto

N

K

7

154

160

zero

23

Tax ID number

Cuid

A

K

15

161

175

Will be filled with the customer's VAT number (if available)

24

Booking text 2

cBuchText2

A

K

20

176

195

Posting text 2nd line → blanks or vehicle information or customer number for postings to the cash account

25

currency

cWaehrung

A

K

3

196

198

currency code

26

nova

nNova

N

K

2

199

200

Nova in% (integer!)

27

tax amount

nSteuerBetrag

N

K

12

201

212

tax amount

28

completion

dFertigDatum

D

K

6

213

218

Completion date

29

currency translation

nKurs

N

K

12

219

230

4 decimal places (only if 2 currencies are kept in the MD)

30

Buchungskennz.

cBuchKz

C

K

2

231

232

Transaction codes: 
AR → Invoice 
GA → Warranty 
IN → Internal accounting 
WE → use booking 
TH → P invoice aftermarket 
FH → P invoice Fahrzeughandel 
KB → cash book 
UB → rebooking (eg Betriebsgem..) 
FA → Fahrzeugankauf 
FZ → vehicle Income Statement Position 
FB → vehicle inventory postings int. 
GE → Guarantee 
submission GD → Guarantee 
difference GS → Guarantee 
cancellation GK → Guarantee 
corrective submission GV → Guarantee 
remuneration GL → Cancellation of guarantee guarantee 
AZ → Advance payment transfer 
MB → Manual stock changes 
VA → Takeover of placement
Sales office → Placement 
IV → Inventory 
SB → Annual Accounts (balance carryforward / opening balance postings) 
BW → Depreciation postings

31

EU re-Kz.

cEUKz

C

K

2

233

234

IR → Intra-Community service 
IL → Intra-Community delivery 
DR → Third country Service 
DL → Third country delivery

32

Tax special case

Special tax case

C

K

1

235

 

T → Not controllable 
M → Reduced revenue

33

order type

cAufArt

C

K

3

236

238

MD Order type 
OPEN → Sales Order (Service / Part) 
FGU → Purchase Order 
GAR → Warranty Order CRB 
→ Used Vehicle Order 
GOOD → Credit memo from AUF 
INT → Internal order 
NEW → New vehicle order

34

Nova position

lNovaPosition

C

K

1

239

 

T → Nova position

35

particulate Filter

lPartikelFilter

C

K

1

240

 

T → Diesel with particle filter 
F → Diesel without particle filter

36

operation number

nBetriebsNr

N

K

3

241

243

Number of the invoicing company with leading zeros

37

Original tax code

cOrigSteuerCd

C

K

1

244

 

Original tax code

38

machine number

nKassenNr

N

K

3

245

247

Kassennr. (only for cash bookings)

39

cash mark

cKassenKz

C

K

1

248

 

H: Cash booking with customer number in the credit 
S: Cash booking with customer number in the debit

40

customer

cKunde

A

MD

50

249

298

Customer name (last name + first name)

41

make

cFabrikat

A

MD

50

299

348

Brand + model text

42

matchcode

cMatchCode

A

MD

20

349

368

Vehicle matchcode

43

Int. Car Nr.

cIntFzNr

A

MD

20

369

388

Internal vehicle number

44

Off. Ref.

cAmtKz

A

MD

10

389

398

License number

45

Zessionskennzeichen

lZession

A

K

1

399

399

(0 ... false, 1 ... true)

46

Customer Type Code

cKundenTyp

A

K

3

400

402

Customer type per invoice recipient (only filled for billing documents, not for cash bookings, etc.)

47

quantity indicator

nMengenKz

A

K

1

403

 

For vehicle entries, quantity 1 is entered here (HS-Finanzwesen), otherwise → Blank

48

Value Plate

lWarenKz

A

K

1

404

404

T → Invoice also contains goods; otherwise → F

49

Customer number Customer

cAuftragGeber

A

K

7

405

411

Debitornummer of the client, if this deviates from the invoice recipient

50

Account type debit account

SollKontenArt

A

K

1

412

 

Type of debit account 
Empty, S → G / L account or undefined 
B → Inventory account - 
D → Accounts receivable / Customer account / Accounts payable 
G → P & L account (revenues / expenses) 
K → Cash account (= cash journal) 
Z → Payment account (= non-cash cash flow) 
C → Vendor (ER from 7.0)

51

Account type Habenk.

HabenKontenArt

A

K

1

413

 

Type of credit account 
See above

-

Quantity field long

nMengenKzLang

A

K

11

414

424

9999999.99+ Quantity field (For vehicle entries, quantity 1 is entered here (HS-Finanzwesen))

52

Vehicle Docket

cFzgAktenNr

A

K

20

425

444

Vehicle File number

53

Extended cash register indicator

cKassenKzExt

A

K

3

445

447

AZ + → 
Down Payment AZ- → Down Payment 
KA + → 
Cash Out KA- → Cash Out Cancellation 
KE + → 
Cash Receipt KE- → Cash Receipt Cancellation 
OA + → Credit 
Deposit OA- → Credit Deposit Cancellation 
OAA → Reversal of Down Payment

54

Teilrechnungskz.

nTeilrechnungKz

N

K

1

448

 

> 0 ... posting belongs to a partial invoice process (1 = down payment, 2 = final invoice, 3 = balance down payment)

55

Vehicle type

cFahrzeugArt

A

K

10

449

458

Vehicle type Order header / vehicle's trunk

56

External ID

cExterneID

A

K

50

459

508

External ID for incoming invoices

57stack PlatenStapelKzNK


Used to differentiate or group the respective booking stacks
58
nFzHGesFallN



Fahrzeughandelsgeschäftsfallart:

0 Standard 
1 Sub dealer 
2 Leasing with Nova calculation 
3 Leasing without Nova calculation 
4 Short approval (Nova already paid off) 
5 No NoVA / already paid off 
6 EU private customer without UID 
7 Diplomatic vehicle

59
cDokumentA



For customer posting, the name of the invoice original document is stored here, if the Bmd parameter is activated in the filedistributor.
60
cAnnehmerA



Acquirer / seller in case of AR, purchaser in ER case
61
cAbteilungA



At AR: Department according to order header
62
cUnterAbteilungA



For AR: Subdivision lt. Order header
63
cFaGestNrA



VIN
64
cFabrikatCodeA



Make code
65
cModellGruppeA



model group
66
cModellCodeA



model code
67
cPosArtA



Item type for order items (summarization must not be activated)
68
cWarengruppeA



Department for order items (summarization must not be activated)
69
cHauptgruppeA



Main group / revenue group for order items (summarization must not be activated)
70
cUntergruppeA



Part group / subgroup for order items (summarization must not be activated)
71
cPosMitarbeiterA



Position employee for order items (summarization must not be activated)
72
cKostenartCodeA



Cost element code for internal order items (summarization must not be activated)
73
cBonuscodeA



Manufacturer bonus code for vehicle revenue accounting items
  • Keine Stichwörter