Format options for Real numbers

There are several options for controlling the formatting of output Real numbers in Business Documents for DML. Some of these options are available for XML, X12, EDIFACT, Flat File, and SCRIPT Business Documents only.

The options are located in the Business Document Properties > General tab, as well as in the Attributes > Definition properties for individual nodes.

Parameter Description
Pad Reals with a leading and trailing zero

Ensures Real numbers always have at least one digit before and after the decimal. For example, selecting this option results in the following:

1 becomes 1.0

.6 becomes 0.6

. becomes 0.0

Keep decimal separator character Ensures Real numbers in an output Business-Document use the same character for the decimal separator as the input Business-Document.
Keep decimal separator Ensures that if a Real number in an input Business-Document includes a decimal separator (or not), the output Business-Document also has a decimal separator (or not).

Keep + sign for positive
Real numbers

On the Properties > General tab:

Ensures positive Real numbers in an output Business-Document use the same format to indicate a positive value as the input Business-Document.

For example, if the input Business-Document includes a + sign before the value, then there is + sign before the value in the output Business-Document.

Keep + sign for positive
Integer numbers

On the Properties > General tab:

Ensures positive Real numbers in an output Business-Document use the same format to indicate a positive value as the input Business-Document.

For example, if the input Business-Document includes a + sign before the value, then there is + sign before the value in the output Business-Document.

Keep + sign for positive
numbers, Real or Integer

On the Attributes > Definition tab:

Ensures positive Real numbers in an output Business-Document use the same format to indicate a positive value as the input Business-Document.

For example, if the input Business-Document includes a + sign before the value, then there is + sign before the value in the output Business-Document.

Keep number of fractional digits Ensures that if Real numbers in an input Business-Document includes n fractional digits, then Real numbers in the output Business-Document also have n fractional digits.
Keep number of date characters

Ensures that if the input and output date patterns are the same, then the number of digits in the output remains the same as the number of digits in the input.

Examples

This section shows how selecting or de-selecting these options affects the format of Real numbers in the output Business Document.

Keep decimal separator and fractional digits

Selecting the following check boxes ensures the output format of real numbers is the same as their input format.

The following tables show how the different check boxes impact the output (where T = selected, and F = de-selected).

Input value: 1,990

Check box                
Keep decimal separator Checked box icon Checked box icon Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon

Keep decimal separator

character

Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon Checked box icon Checked box icon
Keep number of fractional digits Checked box icon Unchecked box icon Unchecked box icon Checked box icon Unchecked box icon Checked box icon Checked box icon Unchecked box icon
Output 1,990 1,99 1.99 1.990 1.99 1.990 1,990 1,99
EDIFACT Output same same 1,99 1,990 1,99 1,990 same same

Input value: 1

Check box                
Keep decimal separator Checked box icon Checked box icon Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon
Keep decimal separator character Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon Checked box icon Checked box icon
Keep number of fractional digits Checked box icon Unchecked box icon Unchecked box icon Checked box icon Unchecked box icon Checked box icon Checked box icon Unchecked box icon
Output 1 1 1 1 1. 1. 1. 1.
EDIFACT Output same same same same 1, 1, 1, 1,

Input value: 1.0

Check box                
Keep decimal separator Checked box icon Checked box icon Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon
Keep decimal separator character Checked box icon Checked box icon Unchecked box icon Unchecked box icon Unchecked box icon Unchecked box icon Checked box icon Checked box icon
Keep number of fractional digits Checked box icon Unchecked box icon Unchecked box icon Checked box icon Unchecked box icon Checked box icon Checked box icon Unchecked box icon
Output 1.0 1. 1. 1.0 1. 1.0 1.0 1.
EDIFACT Output same same 1, 1,0 1, 1,0 same same

Keep + sign for positive Real values

Selecting this check box on the Properties > General tab ensures that output positive Real numbers use the same format to denote positive Real numbers as in the input Business Document.

The following tables show how this option impacts the output.

When selected:

Input Output
1.1 1.1
+1.1

+1.1

When de-selected:

Input Output
1.1 +1.1
+1.1 +1.1

Keep + sign for positive Integer values

Selecting this check box on the Properties > General tab ensures that output positive Integer numbers use the same format to denote positive Integer numbers as in the input Business Document.

The following tables show how this option impacts the output.

When selected:

Input Output
1 1
+1

+1

When de-selected:

Input Output
1 1
+1 1

Keep + sign for positive Real or Integer values

Selecting this check box on the Attributes > Definition tab ensures that output positive numbers, either Real or Integer, use the same format to denote positive numbers as in the input Business Document.

The following tables show how this option impacts the output.

When selected:

Input Output Input Output
1.1 1.1 1 1
+1.1

+1.1

+1 +1

When de-selected:

Input Output Input Output
1.1 +1.1 1 1
+1 +1.1 +1 1

Related topics

Business Documents

Business Document structure

Related Links