Definitions of Conversion Setups (ecedi5111s000)

supported EDI messages

The direction of the EDI message.

The ASCII file format.

Note: A conversion setup can be created for files in which the fields are separated by a field separator, or that have a fixed length.

The code that identifies the conversion setup.

The destination of the field in the incoming message, as defined in the Conversion Setups (Relationships) (ecedi5112m000) session.

The name of the field, for example, tdsls400.ofbp.

The sequence number of the field. The same field can be included more than once. If the field appears only once within the conversion setups, you can set this field to 0 or 1. If the field appears more than once in the conversion setup definition, the sequence number can be increased by an increment of 1 for each occurrence of the field within the conversion setup definition.

The sequence in which the field will be processed.

The level defined in the Conversion Setups (Relationships) (ecedi5112m000) session.

The position of the field in the line.

Note: If the Field Type field in the Networks (ecedi0120s000) session is Fixed Length, you must enter the physical starting position of the field. If the Field Type field in the Networks (ecedi0120s000) session is Delimited, you must enter the field number, starting with number 1.

The index element for an index field or the start position in a string for a string variable.

Index field example

In the case of a string variable, the start position in the string can be specified. This field, in combination with the Length field, allows you to specify a substring (for example: for string "ABCDEFGHIJKLMNOP", the value 3 with a length of 5 produces the following output: "CDEFG").


Field tdsls400.disc (standard depth = 5 levels)
Level	1	10
	2	15
	3	8
	4	5
	5	7

The value 0 outputs the entire field: 010015008005007. This option is only used for internal communication. The values 1 and 3 produce only the following elements: 010 and 008. This output means that the field can also be used for external communication.

The physical length of the field.

If this check box is selected, a new record will be read at this level for incoming messages, and a new record of the table that belongs to the field will be read for outgoing messages. If this check box is cleared, new records will not be read, but the current records remain active.

Note: This field indicates whether a new record must be read in order to process the contents of the field. Based on the value of this field, you can determine when a new line is ready to be read from the same file.

The sequence number that indicates where the cursor must move after processing the field. This field is only used if this record is for the last field of an iterative level or for the last field of the conversion setup.

Example

For example: You want to enter a text field that contains data from an ASCII file in an order header, that is performed iteratively. Once the last text field is filled, the cursor is returned to the field with sequence number 3, by using the Sequence Number field. The key and three text fields are included in each line of level 2.


Field	Level	Sequence Number	Iterative Level
Order No.	1	1
Reference	1	2
Text Field	2	3
Text Field	2	4
Text Field	2	5	3

The sequence number that indicates where the cursor must move if the key is not valid or the key changes. This field only needs to be filled in if the New record is Yes.

Example 1 - Iterative processing

After all text fields have been processed, the customer number is read. Level 2 is iterative.


Field	Level	Sequence in	Back	Back	New
Iter.	Key record
Order No.	1	1
Reference	1	2
Text Field	2	3		6	yes
Text Field	2	4
Text Field	2	5	3
Customer	1	6

Example 2 - Sequential processing

When all order lines have been filled (level 2) a new order can be introduced (level 1).


Field	Level	Sequence in	Back	Back	New
Iter.	Key record
Order No.	1	1			yes
Reference	1	2
Customer	1	3
Item	2	4		1	yes
Quantity	2	5
Delivery Date	2	6	4

If this check box is selected, a record must be added to the relevant table after a field for an incoming message has been processed, depending on the result of the output expression. The destination of the field (overhead, header, or line) determines the table where messages will be saved.

Example 1


Field	Destination	Write record
Order No.	header
Reference	header
Customer	header	yes
Item	line
Quantity	line
Delivery Date	line	yes

Fields processed after a write action for the same destination are not added to the relevant table. You cannot start several write actions for the same record (for example: order line). Due to the hierarchy of destinations, LN checks whether or not all higher destinations have been written. If the higher destination has not been written, the relevant destinations are written before the specified destination is written. The hierarchy is:

Overhead
Header
Line

Example 2


Field	Destination	Write record
Order No.	header
Reference	header
Customer	header
Item	line
Quantity	line
Delivery Date	line	yes

Because no header has been written yet, the header is written first, followed by the line. If there is no overhead, the line is written before the header.

The code for the evaluation expression. This expression determines whether or not the field is included in the message. The expression is logical and it results in true or false. The default value of this field is 1, true. The expression is carried out before placing the field in the message. In other words, the associated reading and writing actions are always carried out. Actually, the expression is an equation. For example, for the Warehouse field on the purchase order, the expression can be: strip((tdpur400.cwar) <> "" This expression is true if the warehouse field is not filled. In an expression, the following operators can be used:

The following lists the operators in order of priority:

()
- (reverse sign)
* / \
&
+ - (add subtract)
= > < <> <= >=
NOT
AND
OR
?:

An expression can contain the following constants:


PI	3.1415926535..
TRUE	Always true.
FALSE	Always false.

An expression can contain functions.

Numerical ranges can also be used: a IN [10,20] is equal to.a>=20 AND a<=30 a IN [10,20][30,40][50,60] is equal to a>=10 AND a<=20 OR a>=30 AND a<=40 OR a>=50 AND a<=60

Arithmetical Example


()	brackets (priority)
-	reverses sign (requires an argument)	a=-b
*	multiplication	3*5=15
/	division	6/2=3
\	remainder after division	8\3=2
&	linking up strings	"A"&"B"="AB"
+	addition	2+3=5
-	subtraction	3-2=1

Relational (for comparison) Example


= or EQ	is equal to	3=5 is false
<> or NE	is unequal to	3<>5 is true
> or GT	is greater than	3>5 is false
< or LT	is less than	3<5 is true
>= or GE	is greater than or equal to	3>=5 is false
<= or LE	is less than or equal to	3<=5 is true

Logical Example


AND	and (both are true)	a=b AND b=c
OR	or (one of the two is true)	a=b OR a=c
NOT	not (is not true)	NOT (a=b AND b=c)

Others:

condition?true:false if <condition> is true, <true> is executed, otherwise <false> (always place brackets around <condition>, because this has the lowest priority)

Functions


abs(N)	Produces the absolute value of N
acos(N)	Produces the angle (in radials) of which N is the cosine.
asc(S)	Produces the total of the ASCII values of the characters in S, asc("ABC")=65+66+67=198
asin(N)	Produces the angle (in radials) of which N is the sine.
atan(N)	Produces the angle (in radials) of which N is the tangent.
chr(N)	Produces the character of which N is the ASCII value, chr(65)="A"
cos(N)	Produces the cosine for angle N (in radials).
cosh(N)	Produces the hyperbolic cosine for angle N (in radials)
date()	Produces the current day number.
date(J,M,D)	Produces the day number in the date represented by D, M and J.
exp(N)	Produces 2.718128.. to the power of N.
int(N)	Produces the integer of N (rounded down).
len(S)	Produces the number of characters in S, len("ABC")=3.
log(N)	Produces the natural logarithm of N.
log10(N)	Produces the 10-logarithm of N.
max(N,M)	Produces the greater value of N or M.
min(N,M)	Produces the lesser value of N or M.
pos(S,T)	Produces the first position where T occurs in S, pos("ABCDEFEF","EF")=5.
pow(N,M)	Produces N to the power of M.
round(N,D,M)	Produces the value of N rounded to D decimals. If M=0, N is rounded down, round(1.99,2,0)=1.00. If M=1, N is rounded off normally, round(1.49,2,1)=1.00 and round(1.50,2,1)=2.00. If M=2, N is rounded up, round(1.01,2,2)=2.00.
rpos(S,T)	Produces the last position where T occurs in S, rpos("ABCDEFEF,"EF")=7.
sin(N)	Produces the sine of angle N (in radials).
sinh(N)	Produces the hyperbolic sine of angle N (in radials).
sqrt(N)	Produces the non-negative square root of N.
str(N)	Creates a string of N, str(1.04)="1.04"
strip(S)	Returns S without the spaces following it.
tan(N)	Produces the tangent of angle N (in radials).
tanh(N)	Produces the hyperbolic tangent of angle N (in radials).
time()	Produces the current time in UUMM format.
val(S)	Produces the numerical value of S, val("1.04")=1.04.

The code for the assignment expression. The result of the expression is written to the ASCII file (outgoing messages), which is updated into the LN application (incoming messages). For example, if you want to set the Planned Delivery Date to a value two days prior to the Planned Receipt Date, you can assign the following assignment expression to the Planned Delivery Date field: tdsls400.prdt - 172800.

Note:

Days must be represented in seconds because dates are internally handled as UTC dates. So, 172800 represents two days.
Any table fields referenced in an assignment expression must be processed before the field to which that assignment expression is assigned. The field referenced in the assignment expression must have a lower processing sequence, as defined in the conversion setup definitions. For example, in the preceding example, field tdsls400.prdt must have a lower processing sequence than field tdsls400.ddat, as defined in the conversion setup definitions.

If this check box is selected, the relevant conversion table is used to convert the field. If this check box is cleared, the code matches the corresponding code in LN and does not need to be converted.

Note: Any field that can be included on an incoming message, can be converted. If this check box is cleared, the code in the message matches the one in LN and need not be converted.

The action to be taken if an error occurs during the conversion of incoming messages.

Note: The value selected must be supported by the processing sessions.

The code you want included in the message. For example, you want to enter a code into a text field. That table contains code A and the description Surcharge. The text field will read "Description: surcharge". If the code is not found, the text field will contain the code instead of the description.

Note: This field is only accessible if the record is for a text field.

If the field is a text field, enter the text string you want to appear before the actual field content in the text field. For example, if you enter Description in this field and the content of the text field is Diesel Engine Valve, the resulting text field will read "Description: Diesel Engine Valve".

How incoming message fields will be processed.

The value that will be used to replace empty fields in the EDI message.

The starting position of the first qualifier. Some code conversions in ERP EDI require a code ID. Code IDs are qualifiers used in code conversions that allow you to convert additional data specifications and are transferred in the first qualifier position of the conversion setup definitions.

Note: If the Field Type field in the Networks (ecedi0120s000) session is Fixed Length, you must enter the physical starting position of the field. If the Field Type field in the Networks (ecedi0120s000) session is Delimited, you must enter the field number, starting with number 1.

The physical length of the qualifier.

Note: This value can only be entered if the field type is Fixed Length, as defined in the Networks (ecedi0520m000) session.

The qualifier value that will result in no conversion being performed. For example, assume the value SC is specified here. If a message contains the qualifier value SC, no conversion will be performed; if the message contains any other value in the message, the value will be converted.

Note: If the read value is equal to the qualifier value, a conversion table will not be applied; the read file will be used. This situation can occur if both parties are using EAN item codes.

The value to be used if no qualifier is received in the message.

The mapping information for this descriptive field and the corresponding data element in the EDI message. This descriptive field is used only for informational and reporting purposes.

The mapping information for the first qualifier and the corresponding data element in the EDI message.

The mapping information for the second qualifier and the corresponding data element in the EDI message.

Definitions of Conversion Setups (ecedi5111s000)

Field Information