Versionen im Vergleich

Schlüssel

  • Diese Zeile wurde hinzugefügt.
  • Diese Zeile wurde entfernt.
  • Formatierung wurde geändert.

...

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

#

field name

Internal name

TypeLng.

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

Kundat: name2

6

country

Cland

A

3

71

73

Kundat: Country

7

place

Cort

A

22

74

95

Kundat: City

8

Street

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

ZIP 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

KundatKundat: 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 name

cVorname

A

50

425

474

Kundat: First name_AB LANG

22

place

cOrtLang

A

50

475

524

Kundat: Location LANG

23

Street

cStrasseLang

A

50

525

574

KundatKundat: Street LANG

24

ZIP Code

cPLZLang

N8th

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

A20

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

Discount (Percentage)

nSkontoProzent

N

5

706

710

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

...

112

#

field name

Internal name

Type

M / V / K

L

From

To

comment

1

companyset mark

cFirma

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

10N

M

z. Eg "01"

42

booking text

cBuchText1

A

K

20

11

30

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

53

Fremdbelegnr

cFremdBeleg

A

K20

31

50

blanks

64

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



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

75

Terms of payment

cZahlBed

A

M

3

54

56

Terms of payment according to MD (Zkond_cd)

86

net payment

nNettoTage

N

V

3

57

59

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

97

cash discount deadline

nSkontoTage

N

V

3

60

62

 

108

Skontoproz.

nSkontoPro

N

V

5

63

67

V

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

119

booking date

dBuchDatum

D

M

6

75

80

DDMMYY - is filled with the date of the day

1210

document date

dBelegDatum

D

M

6

81

86

DDMMYY - will be filled with invoice date

1311

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

1412

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

1513

Cost centre

cKostenStelle

N

K

7

99

105

Cost centre

1614

document number

cBelegNr

N

M

7

106

N

M

Invoice number for orders

1715

Have an account

cKontoHaben

N

M / K7

113

119

 

1816

Account debit

cKontoSoll

N

M / K

7

120

126

 

1917

Voucher Account

cBelegHaben

N

M / K

7

127

133

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

2018

Voucher Account Target

cBelegSoll

N

M / K

7

134

140

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

2119

amount

nBuchBetrag

N

M

12

141

152

2 decimal places with "." separate

-

sign


A

K

1

153

-

Sign of the amount (+/-)

2220

VAT ID Account

cUIDKonto

N

K

7

154

160

zero

2321

Tax ID number

Cuid

A

K

15

161

175

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

2422

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

2523

currency

cWaehrung

A

K

3

196

198

currency code

2624

Standard fuel consumption tax

nNova

N

K

2

199

200

Nova in% (integer!) Only for Austria!

2725

tax amount

nSteuerBetrag

N

K

12

201

212

tax amount

2826

completion

dFertigDatum

D

K

6

213

218

Completion date

2927

currency translation

nKurs

N

K

12

219

230

K

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

3028

accounting formula code

cBuchKz

C

K

2

231

232

Transaction codes: 
AR → Invoice 
GA → Warranty 
IN → Internal accounting 
WE → spare part purchase 
TH → P invoice spare parts 
FH → P invoice car sales 
KB → cash book 
UB → rebooking (eg Betriebsgem..) 
FA → used car purchase 
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

3129

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

3230

Tax special case

Special tax case

C

K

1

235

 

T → Not controllable 
M → Reduced revenue

3331

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

3432

Standard fuel consumption tax

lNovaPosition

C

K

1

239

 

T → Nova position (Only for Austria)

3533

particulate Filter

lPartikelFilter

C

K

1

240

 

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

3634

operation number

nBetriebsNr

N

K

3

241

243

Number of the invoicing company with leading zeros

3735

Original tax code

cOrigSteuerCd

C

K

1

244

 

Original tax code

3836

cash desk number

nKassenNr

N

K

3

245

247

Cash desk number. (only for cash bookings)

3937

cash code

cKassenKz

C

K

1

248

 

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

4038

customer

cKunde

A

MD

50

249

298

Customer name (last name + first name)

4139

make

cFabrikat

A

MD

50

299

348

Brand + model text

4240

matchcode

cMatchCode

A

MD

20

349

368

Vehicle matchcode

4341

Int. Car Nr.

cIntFzNr

A

MD

20

369

388

MD

Internal vehicle number

4442

Off. Ref.

cAmtKz

A

MD

10

389

398

License number

4543

recession code

lZession

A

K

1

399

399

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

4644

Customer Type Code

cKundenTyp

A

K

3

400

402

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

4745

quantity indicator

nMengenKz

A

K

1

403

 

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

4846

Value Plate

lWarenKz

A

K

1

404

404

T → Invoice also contains goods; otherwise → F

4947

Customer number Customer

cAuftragGeber

A

K

7

405

411

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

5048

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)

5149

Account type Habenk.

HabenKontenArt

A

K

1

413

 

Type of credit account 
See above

-

Quantity field long

nMengenKzLang

A

K11

414

424

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

5250

Vehicle Docket

cFzgAktenNr

A

K

20

425

444

Vehicle File number

5351

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

5452

spare parts invoice code

nTeilrechnungKz

N

K

1

448

 

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

5553

Vehicle type

cFahrzeugArt

A

K

10

449

458

Vehicle type Order header / vehicle's trunk

5654

External ID

cExterneID

A

K

50

459

508

External ID for incoming invoices

5755stack PlatenStapelKzNKUsed to differentiate or group the respective booking stacks

...