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
...
Lng.
...
From
...
# | field name | Internal name | Type | comment |
---|---|---|---|---|
1 | Record Type | cKontenArt | A |
1
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
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
73
Kundat: Country | |||
7 | place | Cort | A |
22
74
Kundat: City |
8 | Street | cStrasse | A |
30
125
Kundat: Street | |||
9 | phone | cTelefon | A |
20
126
Kundat: Tel_buero or Tel_privat | |||
10 | short name | cKurzName | A |
8th
146
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
159
Kundat: Zkond_cd | |||
13 | Title code | cAnredeCd | A |
162
164
Kundat: Title | |||
14 | mobile phone | cTelMobil | A |
30
165
194
Kundat: Tel_mobil | |||
15 | fax | cTeleFax | A |
30
224
Kundat: Fax | |||
16 | cEMail | A |
50
225
Kundat: Email | |||
17 | uid | Cuid | A |
15
275
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
375
Kundat: Name2 LANG | |||
21 | first name | cVorname | A |
50
474
Kundat: First name_AB LANG | |||
22 | place | cOrtLang | A |
50
524
Kundat: Location LANG | |||
23 | Street | cStrasseLang | A |
50
525
574
Kundat: Street LANG | |||
24 | ZIP Code | cPLZLang | N |
8th
582
Kundat: Plz LANG | |||
25 | net days | nNettoTage | N |
3
583
due date | |||
26 | Zessionscode | cZessionsCode | A |
3
586
Zessionstextcode | |||
27 | tax number | cSteuerNr | A |
20
589
Personal tax number (eg Italy, Poland) | |||
28 | bank code | cBankleitzahl | A |
10
609
bank code | |||
29 | Bank Account | cBankKonto | A |
40
619
bank account | |||
30 | debit | cBankeinzug | A |
2
660
Direct debit registration | |||
31 | Customer revenue group | cKundenerloes | A |
6
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
676
Kundat.KdBerater | |||
34 | parts seller | cEtVerkaeufer | A |
5
677
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
2 preamble 2 decimal |
...
Record description billing documents / invoice information
...
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
...
- 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
...
1
...
set mark
...
A
...
M
...
1
...
1
...
-
...
"3"
- 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 |
2
10
z. Eg "01" |
2 | booking text | cBuchText1 | A | K |
20
30
Booking text 1st line → order number + "" + invoice code + "-" + invoice no. |
3 | Fremdbelegnr | cFremdBeleg | A | K |
20
31
blanks |
4 | tax code | cSteuerCd | A | K |
3
51
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
56
Terms of payment according to MD (Zkond_cd) |
6 | net payment | nNettoTage | N | V |
3
57
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
|
8 | Skontoproz. | nSkontoPro | N | V |
5
63
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
9 | booking date | dBuchDatum | D | M |
6
75
DDMMYY - is filled with the date of the day |
10 | document date | dBelegDatum | D | M |
6
81
DDMMYY - will be filled with invoice date |
11 | OP-due date | dFaellDatum | D | V |
6
87
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
93
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 |
7
105
Cost centre |
14 | document number | cBelegNr | N | M |
7
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
For cash book entries from the procurement system, the original invoice number |
18 | Voucher Account Target | cBelegSoll | N | M / K |
7
134
For cash book entries from the procurement system, the original invoice number |
19 | amount | nBuchBetrag | N | M |
12
141
152
2 decimal places with "." separate
-
sign
A
K
1
153
-
Sign of the amount (+/-)
2 decimal places with "." separate | ||||
20 | VAT ID Account | cUIDKonto | N | K |
7
154
zero |
21 | Tax ID number | Cuid | A | K |
15
161
Will be filled with the customer's VAT number (if available) |
22 | accounting formula text 2 | cBuchText2 | A | K |
20
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
Nova in% (integer!) Only for Austria! |
25 | tax amount | nSteuerBetrag | N | K |
12
201
tax amount |
26 | completion | dFertigDatum | D | K |
6
213
Completion date |
27 | currency translation | nKurs | N | K |
12
219
4 decimal places (only if 2 currencies are kept in the MD) |
28 | accounting formula code | cBuchKz | C | K |
2
231
Transaction codes: |
29 | EU re-Kz. | cEUKz | C | K |
2
234
IR → Intra-Community service |
30 | Tax special case | Special tax case | C | K |
1
T → Not controllable |
31 | order type | cAufArt | C | K |
3
236
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 |
1
240
T → Diesel with particle filter |
34 | operation number | nBetriebsNr | N | K |
3
241
Number of the invoicing company with leading zeros |
35 | Original tax code | cOrigSteuerCd | C | K |
1
244
Original tax code |
36 | cash desk number | nKassenNr | N | K |
3
247
Cash desk number. (only for cash bookings) |
37 | cash code | cKassenKz | C | K |
1
H: Cash booking with customer number in the credit |
38 | customer | cKunde | A | MD |
50
249
Customer name (last name + first name) |
39 | make | cFabrikat | A | MD |
50
299
Brand + model text |
40 | matchcode | cMatchCode | A | MD |
20
349
Vehicle matchcode |
41 | Int. Car Nr. | cIntFzNr | A | MD |
20
369
Internal vehicle number |
42 | Off. Ref. | cAmtKz | A | MD |
10
389
License number |
43 | recession code | lZession | A | K |
1
399
(0 ... false, 1 ... true) |
44 | Customer Type Code | cKundenTyp | A | K |
3
402
Customer type per invoice recipient (only filled for billing documents, not for cash bookings, etc.) |
45 | quantity indicator | nMengenKz |
A
K
1
403
A | K | For vehicle entries, quantity 1 is entered here (HS-Finanzwesen), otherwise → Blank |
46 | Value Plate | lWarenKz | A | K |
1
404
T → Invoice also contains goods; otherwise → F |
47 | Customer number Customer | cAuftragGeber | A | K |
7
411
Debitornummer of the client, if this deviates from the invoice recipient |
48 | Account type debit account | SollKontenArt | A | K |
1
412
Type of debit account |
49 | Account type Habenk. | HabenKontenArt |
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))
Type of credit account | ||||
50 | Vehicle Docket | cFzgAktenNr | A | K |
20
444
Vehicle File number |
51 | Extended cash register indicator | cKassenKzExt | A | K |
3
445
AZ + → |
52 | spare parts invoice code | nTeilrechnungKz | N |
K
1
448
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 |
10
449
Vehicle type Order header / vehicle's trunk |
54 | External ID | cExterneID | A | K |
50
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
External ID for incoming invoices | |||||
55 | stack Plate | nStapelKz | N | K | Used to differentiate or group the respective booking stacks |