Field help (TYC1FRM) @ L.V. Expertise X3

With each part of the structured communication, the data format can vary.
The formula field is used to define the format of each part of the communication.
For alphanumeric fields, it is not necessary that this formula field be entered.

Formula fields must be entered as follows:

Example - 105: Initial amount of the Translation operation in the X3 format:

105	Gross amount expressed in the account currency	15N: 12 positions + 3 decimals
	Gross amount expressed in the initial currency	15N: 12 positions + 3 decimals
	Exchange rate	12N: 4 positions + 8 decimals
	Currency	3AN ISO Currency Code
	Structured Communication	12AN
	Country code of the order giver	2AN ISO Country Code
	Amount of the counter value in EURO	12N: 12 positions + 3 decimals

Translation in the X3 format:

Title	Pos	Long	formula
Gross amount expressed in the account currency	1	15	format$("N:12.3", val(mid$(TCOMDT,1,15))/1000)
Gross amount in the initial currency	16	15	format$("N:12.3", val(mid$(TCOMDT,16,15))/1000)
Exchange rate	31	12	format$("N:4.8", val(mid$(TCOMDT,31,12))/100000000)
Currency	43	3
Structured Communication	46	12	format$("N:12", mid$(TCOMDT,46,12))
Country code of the order giver	58	2
Amount of the counter value in EURO	60	15	format$("N:12.3", val(mid$(TCOMDT,60,15))/1000)

Example - 108: Closing

108	Counter value expressed in the account currency	15 N: 12 positions + 3 decimals
	Rate number, calculation basis	15N
	Rate	12 N: 4 positions + 8 decimals
	period from...to	12N: DDMMYYYY DDMMYYYY

Translation in the X3 format:

Title	Pos	Long	formula
Counter value in the account currency	1	15	format$("N:12.3", val(mid$(TCOMDT,1,15))/1000)
Rate number, calculation basis	16	15	format$("N:15", val(mid$(TCOMDT,16,15)))
Rate	31	12	format$("N:4.8", val(mid$(TCOMDT,31,12))/100000000)
Period from	43	6	format$("D:DD[/]MM[/]YY[ ]", mid$(TCOMDT,43,6))
Period to	49	6	format$("D:DD[/]MM[/]YY", mid$(TCOMDT,49,6))