Table of content
Inhalt | exclude | Inhaltsverzeichnis
---|
General
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 |
---|---|
M | Must contain |
information | |
K | May contain |
information | |
V | Field takes precedence over another specially marked field |
MD | Additional 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 |
---|---|
M | value added tax |
V | pilot |
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
structure.
# | field name | Internal name | Type |
---|
From
To
comment | |||
---|---|---|---|
1 | Record Type | cKontenArt | A |
1
1
-
"K" (for customer), "L" for supplier | |||
2 | Company number | cFirma | N |
2
3
Company number, which can be entered in the interface main menu | |||
3 | account number | cKontoNr | N |
7
4
Customer Account Group + Kundat: Persnr | |||
4 | name1 | cName1 | A |
30
11
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 |
96
125
Kundat: Street | |||
9 | phone | cTelefon | A |
20
126
Kundat: Tel_buero or Tel_privat | |||
10 | short name | cKurzName | A |
8th
153
Kundat: Name1 from 1 - 8 (mandatory field in the IBM financial system !!!) |
11 |
ZIP Code | cPLZ | N |
5
154
Kundat: Plz (Without blanks and hyphens; Attention: With Austrian adaptations the HS automatically takes only 4 places!) | |||
12 | Terms of payment | cZahlBed | A |
3
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 | cEMail | A |
50
225
Kundat: Email | |||
17 | uid | Cuid | A |
15
275
289
Kundat: uid | |||
18 | address text | cAnredeText | A |
35
290
Conversion from Anredecode | |||
19 | name1 | cName1Lang | A |
50
325
Kundat: Name1 LANG | |||
20 | name2 | cName2Lang | A |
50
424
Kundat: Name2 LANG | |
21 | first |
name | cVorname | A |
50
474
Kundat: First name_AB LANG | |||
22 | place | cOrtLang | A |
50
475
524
Kundat: Location LANG |
23 |
Street | cStrasseLang | A |
525
574
Kundat: Street LANG |
24 |
ZIP Code | cPLZLang | N |
8th
575
Kundat: Plz LANG | |||
25 | net days | nNettoTage | N |
583
585
due date | |||
26 | Zessionscode | cZessionsCode | A |
3
586
588
Zessionstextcode | |||
27 | tax number | cSteuerNr | A |
20
608
Personal tax number (eg Italy, Poland) | |||
28 | bank code | cBankleitzahl | A |
10
609
bank code | |||
29 | Bank Account | cBankKonto | A |
40
619
EL
bank account | |||
30 | debit | cBankeinzug | A |
2
659
660
Direct debit registration | |||
31 | Customer revenue group | cKundenerloes | A |
6
661
666
Customer revenue group (eg EXTSTD) | |||
32 | sales consultant | cLtz_Verk | A |
5
667
671
Kundat.Ltz_Verk | |||
33 | Customer Service Advisor | cKdBerater | A |
5
672
Kundat.KdBerater | |||
34 | parts seller | cEtVerkaeufer | A |
5
677
681
Kundat.EtVekaeufer | |||
35 | nationality | cKundenKzLand | N |
1
682
1 = Austria, 2 = EU, 3 = third country | |||
36 | bank code | cBankleitzahlLang | C |
20
683
Only available as an option, format 6.4.x! | |||
37 | cash discount deadline | nSkontoTage | N |
3
703
Only available as an option, format 6.4.x! | |
38 |
Discount (Percentage) | nSkontoProzent | N |
5
706
710
2 preamble 2 decimal |
...
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
- 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 |
---|
L
From
To
comment |
---|
1 |
company |
cFirma |
N | M |
L
From
To
comment
1
z. Eg "01" | |||
2 | booking text | cBuchText1 | 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
N
M
2
9
10
z. Eg "01"
4
booking text
A
K
20
11
30
Booking text 1st line → order number + "" + invoice code + "-" + invoice no.
5
Fremdbelegnr
A
K
20
31
50
blanks
6
tax code
A
K
3
51
53
VAT code as in MD for the booking codes; ("M" + 20% Ust → "M20"); Blank for customer header posting
7
Terms of payment
A
M
3
54
56
Terms of payment according to MD (Zkond_cd)
8th
net payment
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
N
V
3
60
62
10
Skontoproz.
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
N
K
7
68
74
zero
11
booking date
D
M
6
75
80
DDMMYY - is filled with the date of the day
12
document date
D
M
6
81
86
DDMMYY - will be filled with invoice date
13
OP-due date
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
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
N
K
7
99
105
Cost centre
16
document number
N
M
7
106
112
Invoice number for orders
17
Have an account
N
M / K
7
113
119
18
Account debit
N
M / K
7
120
126
19
Voucher Account
N
M / K
7
127
133
For cash book entries from the procurement system, the original invoice number
20
Voucher Account Target
N
M / K
7
134
140
For cash book entries from the procurement system, the original invoice number
21
booking amount
N
M
12
141
152
2 decimal places with "." separate
-
sign
A
K
1
153
-
Sign of the amount (+/-)
22
VAT ID Account
N
K
7
154
160
zero
23
Tax ID number
A
K
15
161
175
Will be filled with the customer's VAT number (if available)
24
Booking text 2
A
K
20
176
195
Posting text 2nd line → blanks or vehicle information or customer number for postings to the cash account
25
currency
A
K
3
196
198
currency code
26
nova
N
K
2
199
200
Nova in% (integer!)
27
tax amount
N
K
12
201
212
tax amount
28
completion
D
K
6
213
218
Completion date
29
currency translation
N
K
12
219
230
4 decimal places (only if 2 currencies are kept in the MD)
30
Buchungskennz.
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.
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
C
K
1
235
T → Not controllable
M → Reduced revenue
33
order type
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
C
K
1
239
T → Nova position
35
particulate Filter
C
K
1
240
T → Diesel with particle filter
F → Diesel without particle filter
36
operation number
N
K
3
241
243
Number of the invoicing company with leading zeros
37
Original tax code
C
K
1
244
Original tax code
38
machine number
N
K
3
245
247
Kassennr. (only for cash bookings)
39
cash mark
C
K
1
248
H: Cash booking with customer number in the credit
S: Cash booking with customer number in the debit
40
customer
A
MD
50
249
298
Customer name (last name + first name)
41
make
A
MD
50
299
348
Brand + model text
42
matchcode
A
MD
20
349
368
Vehicle matchcode
43
Int. Car Nr.
A
MD
20
369
388
Internal vehicle number
44
Off. Ref.
A
MD
10
389
398
License number
45
Zessionskennzeichen
A
K
1
399
399
(0 ... false, 1 ... true)
46
Customer Type Code
A
K
3
400
402
Customer type per invoice recipient (only filled for billing documents, not for cash bookings, etc.)
47
quantity indicator
A
K
1
403
For vehicle entries, quantity 1 is entered here (HS-Finanzwesen), otherwise → Blank
48
Value Plate
A
K
1
404
404
T → Invoice also contains goods; otherwise → F
49
Customer number Customer
A
K
7
405
411
Debitornummer of the client, if this deviates from the invoice recipient
50
Account type debit account
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.
A
K
1
413
Type of credit account
See above
-
Quantity field long
A
K
11
414
424
9999999.99+ Quantity field (For vehicle entries, quantity 1 is entered here (HS-Finanzwesen))
52
Vehicle Docket
A
K
20
425
444
Vehicle File number
53
Extended cash register indicator
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.
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
A
K
10
449
458
Vehicle type Order header / vehicle's trunk
56
External ID
A
K
50
459
508
External ID for incoming invoices
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
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: |
29 | EU re-Kz. | cEUKz | C | K | IR → Intra-Community service |
30 | Tax special case | Special tax case | C | K | T → Not controllable |
31 | order type | cAufArt | C | K | MD Order type |
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 |
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 |
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 |
49 | Account type Habenk. | HabenKontenArt | A | K | Type of credit account |
50 | Vehicle Docket | cFzgAktenNr | A | K | Vehicle File number |
51 | Extended cash register indicator | cKassenKzExt | A | K | AZ + → |
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 |
55 | stack Plate | nStapelKz | N | K | Used to differentiate or group the respective booking stacks |