Table of content
Inhalt | ||
---|---|---|
|
...
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 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 |
---|
From
To
comment | |||
---|---|---|---|
1 | Record Type | cKontenArt | A |
1
-
"K" (for customer), "L" for supplier | |||
2 | Company number | cFirma | N |
2
2
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
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 |
74
95
Kundat: City | |||
8 | Street | cStrasse | A |
30
96
Kundat: Street | |||
9 | phone | cTelefon | A |
20
126
145
Kundat: Tel_buero or Tel_privat | |||
10 | short name | cKurzName | A |
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 |
165
194
Kundat: Tel_mobil | |||
15 | fax | cTeleFax | A |
30
195
Kundat: Fax | |||
16 | cEMail | A |
225
274
Kundat: Email | |||
17 | uid | Cuid | A |
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 |
375
424
Kundat: Name2 LANG | |||
21 | first name | cVorname | A |
50
425
474
Kundat: First name_AB LANG | |||
22 | place | cOrtLang | A |
50
475
Kundat: Location LANG | |||
23 | Street | cStrasseLang | A |
525
574
Kundat: Street LANG | |||
24 | ZIP Code | cPLZLang | N |
8th
575
582
Kundat: Plz LANG | |||
25 | net days | nNettoTage | N |
3
583
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
618
bank code | |||
29 | Bank Account | cBankKonto | A |
40
619
658
bank account | |||
30 | debit | cBankeinzug | A |
659
660
Direct debit registration | |||
31 | Customer revenue group | cKundenerloes | A |
6
661
Customer revenue group (eg EXTSTD) | |||
32 | sales consultant | cLtz_Verk | A |
5
667
671
Kundat.Ltz_Verk | |||
33 | Customer Service Advisor | cKdBerater | A |
5
676
Kundat.KdBerater | |||
34 | parts seller | cEtVerkaeufer | A |
5
677
681
Kundat.EtVekaeufer | ||||
35 | nationality | cKundenKzLand | N | 1 |
682
682
= Austria, 2 = EU, 3 = third country | |||
36 | bank code | cBankleitzahlLang | C |
683
702
Only available as an option, format 6.4.x! | |||
37 | cash discount deadline | nSkontoTage | N |
3
705
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 Record format, the first line may contain the column names depending on the MD setting.
# | field name | Internal name | Type | M / V / K |
---|
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
1 |
8th
-
blanks
3
company | cFirma | N | M |
2
9
10
z. Eg "01" |
2 | booking text | cBuchText1 | A | K |
20
11
30
Booking text 1st line → order number + "" + invoice code + "-" + invoice no. |
3 | Fremdbelegnr | cFremdBeleg | A | K |
31
50
blanks |
4 | tax code | cSteuerCd | A | K |
3
53
7
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 |
3
54
56
Terms of payment according to MD (Zkond_cd) |
6 | net payment | nNettoTage | N | V |
57
59
Will only be turned off when advanced payment terms are enabled in the MOTIONDATA communication settings |
7 | cash discount deadline | nSkontoTage | N | V |
3
60
62
|
8 | Skontoproz. | nSkontoPro | N | V |
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
9 | booking date | dBuchDatum | D | M |
75
80
DDMMYY - is filled with the date of the day |
10 | document date | dBelegDatum | D | M |
6
81
86
DDMMYY - will be filled with invoice date |
11 | OP-due date | dFaellDatum | D | V |
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 |
12 | Discount due date | dSkontoDatum | D | V |
6
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 |
13 | Cost centre | cKostenStelle | N | K |
99
105
Cost centre |
14 | document number | cBelegNr | N | M |
7
106
112
Invoice number for orders |
15 | Have an account | cKontoHaben | N | M / K |
7
113
|
16 | Account debit | cKontoSoll | N | M / K |
7
120
|
17 | Voucher Account | cBelegHaben | N | M / K |
7
127
133
For cash book entries from the procurement system, the original invoice number |
18 | Voucher Account Target | cBelegSoll | N | M / K |
7
134
140
For cash book entries from the procurement system, the original invoice number |
19 | amount | nBuchBetrag | N | M |
12
141
22
2 decimal places with "." separate |
-
sign
A
K
1
153
-
Sign of the amount (+/-)
20 | VAT ID Account | cUIDKonto | N | K |
154
160
zero |
21 | Tax ID number | Cuid | A | K |
161
175
Will be filled with the customer's VAT number (if available) |
22 | accounting formula text 2 | cBuchText2 | A | K |
176
195
Posting text 2nd line → blanks or vehicle information or customer number for postings to the cash account |
23 | currency | cWaehrung | A | K |
3
198
currency code |
24 | Standard fuel consumption tax | nNova | N | K |
2
199
200
Nova in% (integer!) Only for Austria! |
25 | tax amount | nSteuerBetrag | N | K |
12
212
tax amount |
26 | completion | dFertigDatum | D | K |
6
213
Completion date |
27 | currency translation | nKurs | N | K |
12
219
230
4 decimal places (only if 2 currencies are kept in the MD) |
28 | accounting formula code | cBuchKz | C | K |
2
231
232
Transaction codes: |
29 | EU re-Kz. | cEUKz | C | K |
2
233
IR → Intra-Community service |
30 | Tax special case | Special tax case | C | K |
1
235
T → Not controllable |
31 | order type | cAufArt | C | K |
236
238
MD Order type |
32 | Standard fuel consumption tax | lNovaPosition | C | K |
1
239
T → Nova position (Only for Austria) |
33 | particulate Filter | lPartikelFilter | C | K |
240
T → Diesel with particle filter |
34 | operation number | nBetriebsNr | N | K |
241
243
Number of the invoicing company with leading zeros |
35 | Original tax code | cOrigSteuerCd | C | K |
1
Original tax code |
36 | cash desk number | nKassenNr | N | K |
3
245
247
Cash desk number. (only for cash bookings) |
37 | cash code | cKassenKz | C | K |
1
248
H: Cash booking with customer number in the credit |
38 | customer | cKunde | A | MD |
50
298
Customer name (last name + first name) |
39 | make | cFabrikat | A | MD |
50
299
348
Brand + model text |
40 | matchcode | cMatchCode | A | MD |
20
349
Vehicle matchcode |
41 | Int. Car Nr. | cIntFzNr | A | MD |
20
369
388
Internal vehicle number |
42 | Off. Ref. | cAmtKz | A | MD |
10
389
License number |
43 | recession code | lZession | A | K |
1
399
399
(0 ... false, 1 ... true) |
44 | Customer Type Code | cKundenTyp | A | K |
400
402
Customer type per invoice recipient (only filled for billing documents, not for cash bookings, etc.) |
45 | quantity indicator | nMengenKz | A | K |
1
403
For vehicle entries, quantity 1 is entered here (HS-Finanzwesen), otherwise → Blank |
46 | Value Plate | lWarenKz | A | K |
404
404
T → Invoice also contains goods; otherwise → F |
47 | Customer number Customer | cAuftragGeber | A | K |
405
411
Debitornummer of the client, if this deviates from the invoice recipient |
48 | Account type debit account | SollKontenArt | A | K |
412
Type of debit account |
49 | Account type Habenk. | HabenKontenArt | A | K |
1
Type of credit account |
-
Quantity field long
A
K
11
414
424
9999999.99+ Quantity field (For vehicle entries, quantity 1 is entered here (HS-Finanzwesen))
52
50 | Vehicle Docket | cFzgAktenNr | A | K |
20
425
Vehicle File number |
51 | Extended cash register indicator | cKassenKzExt | A | K |
3
445
447
AZ + → |
52 | 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) |
53 | Vehicle type | cFahrzeugArt | A | K |
10
449
458
Vehicle type Order header / vehicle's trunk |
54 | External ID | cExterneID | A | K |
50
459
508
External ID for incoming invoices |
55 | stack Plate | nStapelKz | N | K | Used to differentiate or group the respective booking stacks |