Versionen im Vergleich

Schlüssel

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

Table of content

Inhalt
excludeInhaltsverzeichnis

...

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)

...

Legend - Mandatory Fields

field

information

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

...

DMS

Control Codes in 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 structure.

#

field name

Internal name

Type

comment

1

Record Type

cKontenArt

A

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

2

Company number

cFirma

N

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

3

account number

cKontoNr

N

Customer Account Group + Kundat: Persnr

4

name1

cName1

A

Kundat: name1

5

name2

cName2

A

Kundat: name2

6

country

Cland

A

Kundat: Country

7

place

Cort

A

Kundat: City

8

Street

cStrasse

A

Kundat: Street

9

phone

cTelefon

A

Kundat: Tel_buero or Tel_privat

10

short name

cKurzName

A

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

11

ZIP Code

cPLZ

N

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

12

Terms of payment

cZahlBed

A

Kundat: Zkond_cd

13

Title code

cAnredeCd

A

Kundat: Title

14

mobile phone

cTelMobil

A

Kundat: Tel_mobil

15

fax

cTeleFax

A

Kundat: Fax

16

E-mail

cEMail

A

Kundat: Email

17

uid

Cuid

A

Kundat: uid

18

address text

cAnredeText

A

Conversion from Anredecode

19

name1

cName1Lang

A

Kundat: Name1 LANG

20

name2

cName2Lang

A

Kundat: Name2 LANG

21

first name

cVorname

A

Kundat: First name_AB LANG

22

place

cOrtLang

A

Kundat: Location LANG

23

Street

cStrasseLang

A

Kundat: Street LANG

24

ZIP Code

cPLZLang

N

Kundat: Plz LANG

25

net days

nNettoTage

N

due date

26

Zessionscode

cZessionsCode

A

Zessionstextcode

27

tax number

cSteuerNr

A

Personal tax number (eg Italy, Poland)

28

bank code

cBankleitzahl

A

bank code

29

Bank Account

cBankKonto

A

bank account

30

debit

cBankeinzug

A

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

31

Customer revenue group

cKundenerloes

A

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

32

sales consultant

cLtz_Verk

A

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

33

Customer Service Advisor

cKdBerater

A

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

34

parts seller

cEtVerkaeufer

A

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

35

nationality

cKundenKzLand

N

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

36

bank code

cBankleitzahlLang

C

Only available as an option, format 6.4.x!

37

cash discount deadline

nSkontoTage

N

Only available as an option, format 6.4.x!

38

Discount (Percentage)

nSkontoProzent

N

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 structure;
  • Amount fields always have their sign directly in the variable sentence structure.
  • 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

comment

1

company

cFirma

N

M

z. Eg "01"

2

booking text

cBuchText1

A

K

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

3

Fremdbelegnr

cFremdBeleg

A

K

blanks

4

tax code

cSteuerCd

A

K

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

5

Terms of payment

cZahlBed

A

M

Terms of payment according to MD (Zkond_cd)

6

net payment

nNettoTage

N

V

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

7

cash discount deadline

nSkontoTage

N

V

 

8

Skontoproz.

nSkontoPro

N

V

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

9

booking date

dBuchDatum

D

M

DDMMYY - is filled with the date of the day

10

document date

dBelegDatum

D

M

DDMMYY - will be filled with invoice date

11

OP-due date

dFaellDatum

D

V

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

12

Discount due date

dSkontoDatum

D

V

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

13

Cost centre

cKostenStelle

N

K

Cost centre

14

document number

cBelegNr

N

M

Invoice number for orders

15

Have an account

cKontoHaben

N

M / K

 

16

Account debit

cKontoSoll

N

M / K

 

17

Voucher Account

cBelegHaben

N

M / K

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

18

Voucher Account Target

cBelegSoll

N

M / K

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

19

amount

nBuchBetrag

N

M

2 decimal places with "." separate

20

VAT ID Account

cUIDKonto

N

K

zero

21

Tax ID number

Cuid

A

K

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

22

accounting formula text 2

cBuchText2

A

K

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

23

currency

cWaehrung

A

K

currency code

24

Standard fuel consumption tax

nNova

N

K

Nova in% (integer!) Only for Austria!

25

tax amount

nSteuerBetrag

N

K

tax amount

26

completion

dFertigDatum

D

K

Completion date

27

currency translation

nKurs

N

K

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

28

accounting formula code

cBuchKz

C

K

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

29

EU re-Kz.

cEUKz

C

K

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

30

Tax special case

Special tax case

C

K

T → Not controllable 
M → Reduced revenue

31

order type

cAufArt

C

K

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

32

Standard fuel consumption tax

lNovaPosition

C

K

T → Nova position (Only for Austria)

33

particulate Filter

lPartikelFilter

C

K

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

34

operation number

nBetriebsNr

N

K

Number of the invoicing company with leading zeros

35

Original tax code

cOrigSteuerCd

C

K

Original tax code

36

cash desk number

nKassenNr

N

K

Cash desk number. (only for cash bookings)

37

cash code

cKassenKz

C

K

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

38

customer

cKunde

A

MD

Customer name (last name + first name)

39

make

cFabrikat

A

MD

Brand + model text

40

matchcode

cMatchCode

A

MD

Vehicle matchcode

41

Int. Car Nr.

cIntFzNr

A

MD

Internal vehicle number

42

Off. Ref.

cAmtKz

A

MD

License number

43

recession code

lZession

A

K

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

44

Customer Type Code

cKundenTyp

A

K

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

45

quantity indicator

nMengenKz

A

K

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

46

Value Plate

lWarenKz

A

K

T → Invoice also contains goods; otherwise → F

47

Customer number Customer

cAuftragGeber

A

K

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

48

Account type debit account

SollKontenArt

A

K

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)

49

Account type Habenk.

HabenKontenArt

A

K

Type of credit account 
See above

50

Vehicle Docket

cFzgAktenNr

A

K

Vehicle File number

51

Extended cash register indicator

cKassenKzExt

A

K

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

52

spare parts invoice code

nTeilrechnungKz

N

K

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

53

Vehicle type

cFahrzeugArt

A

K

Vehicle type Order header / vehicle's trunk

54

External ID

cExterneID

A

K

External ID for incoming invoices

55stack PlatenStapelKzNKUsed to differentiate or group the respective booking stacks