Numeric Values

You do not have to pad numeric values with zeros. If the value is a decimal value, it should be placed in the field with the decimal present. If the value is a whole number, no decimal is required. The Inbound Flat File Conversion program (R47002C) validates the value in the field and adjusts the value based on the data dictionary. For example, line number (EDLN) typically has three display decimals. If the value in the flat file is 1, the Inbound Flat File Conversion program converts it to 1000 so that it appears as 1.000 in an application. If no value must be mapped to the field, either a blank or a 0 is converted to a 0 in the EDI inbound interface tables.

This table shows how the system converts values for the data dictionary item EDI Line Number (EDLN) from the flat file into the EDI inbound interface tables:

Value in Flat File	Converted Value in Interface Table	Value Displayed with Three Display Decimals	Attribute of Field in Interface Table
1	1000	1.000	Numeric 7, 3 Display
1.	1000	1.000	Numeric 7, 3 Display
1.0	1000	1.000	Numeric 7, 3 Display
1.00	1000	1.000	Numeric 7, 3 Display
1.000	1000	1.000	Numeric 7, 3 Display

This table shows how the system converts values for the data dictionary item Units, Transaction/Quantity (UORG) from the flat file into the EDI inbound interface tables:

Value in Flat File	Converted Value in Interface Table	Value Displayed with Three Display Decimals	Attribute of Field in Interface Table
123	123	123	Numeric 9
123	123	123	Numeric 9
-123	-123	123-	Numeric 9
123-	-123	123-	Numeric 9
	0	0	Numeric 9
0	0	0	Numeric 9
000000000	0	0	Numeric 9

When you send or receive documents with decimal numbers, you must use a placeholder, such as a period (.), to indicate the position of the decimal. You define the placeholder in the use preference table.