Table of content

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.

LINE SEPARATOR:

chr (13) + chr (10) (Hex: 0D0A)

FIELD TYPE

grade	description
A	alpha
N	Numeric (with leading zeros)
D	Date (ddmmyy)

MANDATORY LEGEND

field	information
M	Must contain an indication
K	May contain an indication
V	Field takes precedence over another specially marked field
MD	Additional fields from MOTIONDATA

CONTROL CODES IN THE 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.

#	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
55	stack Plate	nStapelKz	N	K	Used to differentiate or group the respective booking stacks

Variable Accounting Interface (Standard-Schnittstelle/FiBu/MD.DMS/User Guides)