Modifying Formats for Duplicated Reports

The Duplicate Report Transformation options enables you to display number prefixes and suffixes, as well as thousands and decimal separators for Microsoft Word document numerical data when performing mapping. Microsoft Excel is not affected because underlying Microsoft Excel numerical data is not formatted.

To display the number format:

From the Disclosure Management ribbon, select Duplicate Report,
Select Transformation.

Table 22. Positive Number Symbols Fields and Descriptions

Field	Description
Prefix	Displays the positive number prefix symbol, which is placed to the left of each positive value. Symbol options are: None $ % [ ] The default prefix symbol is None.
Suffix	Displays the positive number suffix symbol, which is placed to the right of each positive value. Symbol options are: None $ % [ ] The default prefix symbol is None.

Table 23. Negative Number Symbols Fields and Descriptions

Field	Description
Prefix	Displays the negative number prefix symbol, which is placed to the left of each negative value. Symbol options are: - (negative symbol) None $ % [ ] The default prefix symbol is - . Alternatively, you can specify another symbol in the list by highlighting the field and entering another symbol.
Suffix	Displays the negative number suffix symbol which is placed to the right of each negative value. Symbol options are: None $ % [ ] The default prefix symbol is None.

Table 24. Separator Character Fields and Descriptions

Field	Description
Separator Character	Displays the thousands and decimal separator character format for numeric value.
Thousands Separator	Displays the character for separating thousands.
Decimal Separator	Displays the character that represent decimal points.

Table 25. General Information about the Decimal, Precision, and Scale Attributes

Field	Description
General Information about the Decimal, Precision, and Scale Attributes	When instance documents are generated, numeric values mapped to XBRL line items are saved with their raw data values. Any formatting or rounding is removed from numeric values. To report values correctly, you need to apply both accuracy and scaling properties. For example, if you map an item to “30” but intend to represent this value in the millions, two attributes must be supplied. First, you must specify that the decimal attribute is set to “6” to indicate that the number is accurate to the millions. Secondly, you need to specify that the scale factor equals 6, which add 6 zeros to the mapped value 30 and report the value 30000000 in the instance document. Since every numeric value in an instance document must have either a decimal or a precision attribute, Disclosure Management enables you to specify accuracy settings for all numeric data that is persisted to an instance document. In addition, you can specify a scale attribute to determine the correct zero values to include in the instance document. Decimal—The decimals attribute states how accurate a number is to the X position with respect to the decimal place. For example, a decimal attribute of ”0” means that the number is accurate to the whole number. A decimal attribute of ”2” means the number is accurate to the hundredths, and so on. The decimal attribute is required for SEC filers. Precision—The precision attribute indicates how many digits in the numeric value are accurate. This means that the number mapped to the line item is the exact value shown in the instance document (no rounding). By default, Disclosure Management uses the precision setting. This option is set to “INF.” If values stored in a data source are already scaled (for example, the stored value of 250 may actually be 250,000), it may be necessary to manually adjust the precision attribute in the resulting XML file after an instance document is created. For more information regarding the precision attribute, see the XBRL 2.1 specification. Scale By—The scaling attribute enables you to indicate a factor whereby units of values are multiplied by a scale factor to determine the correct value to include in the instance document. Scaling eliminates the need to enter zeros in Microsoft Word or Excel when mapping large numeric values. For example, if you map the value $30, and the value actually represents "30 million", it is necessary to set the scaling factor to "6". This adds 6 zeros to the mapped value 30, and reports the value 30000000 in the instance document. If you apply a scale factor of ”-2” to “30”, this means to subtract 2 zeros, i.e. “0.3”. (This is often used when reporting percentages. The report says 30% which is actually the number 0.3). Scaling is not mandatory. If a factor is not used, the scaling automatically defaults to 0, meaning that no scale is applied. The number “30” with scale=”0” is still “30”.
Decimal	Enter the number of decimal places to which the given value is accurate. This setting is required for SEC filers. Enter the setting as a positive whole number to denote the accuracy of the value to the right of the decimal point. For example, enter “3” to specify that the numeric fact is accurate to three digits right of the decimal point. In another example, if $42.38 is reported, then the decimals should be set to 2. If the number is 36.69%, the decimals should be set to 4. You can also enter the number as a negative “-” number to denote the accuracy of the value to the left of the decimal point. For example if you assign decimals to be “-3”, the amount $30,000 is said to be accurate to the thousands. If decimals are "-6", the number is accurate to the millions. Note: It is often important to complement the decimals setting with the scaling property. For example, if you map the value $30 and it represents "30 million", it is necessary to set the scaling property to "6". This attribute adds 6 zeros to the mapped value 30 and report the value 30000000 in the instance document.
Precision	Select to use a precision setting and choose the number of digits of a numeric value that are accurate. For example, if you enter “7”, the first seven digits counting from the left, starting at the first nonzero digit is correct to the seventh place. By default, Disclosure Management uses the precision setting. This option is set to “INF.

Field

Description

General Information about the Decimal, Precision, and Scale Attributes

When instance documents are generated, numeric values mapped to XBRL line items are saved with their raw data values. Any formatting or rounding is removed from numeric values. To report values correctly, you need to apply both accuracy and scaling properties. For example, if you map an item to “30” but intend to represent this value in the millions, two attributes must be supplied. First, you must specify that the decimal attribute is set to “6” to indicate that the number is accurate to the millions. Secondly, you need to specify that the scale factor equals 6, which add 6 zeros to the mapped value 30 and report the value 30000000 in the instance document.

Since every numeric value in an instance document must have either a decimal or a precision attribute, Disclosure Management enables you to specify accuracy settings for all numeric data that is persisted to an instance document. In addition, you can specify a scale attribute to determine the correct zero values to include in the instance document.

Decimal—The decimals attribute states how accurate a number is to the X position with respect to the decimal place. For example, a decimal attribute of ”0” means that the number is accurate to the whole number. A decimal attribute of ”2” means the number is accurate to the hundredths, and so on. The decimal attribute is required for SEC filers.
Precision—The precision attribute indicates how many digits in the numeric value are accurate. This means that the number mapped to the line item is the exact value shown in the instance document (no rounding). By default, Disclosure Management uses the precision setting. This option is set to “INF.” If values stored in a data source are already scaled (for example, the stored value of 250 may actually be 250,000), it may be necessary to manually adjust the precision attribute in the resulting XML file after an instance document is created. For more information regarding the precision attribute, see the XBRL 2.1 specification.
Scale By—The scaling attribute enables you to indicate a factor whereby units of values are multiplied by a scale factor to determine the correct value to include in the instance document. Scaling eliminates the need to enter zeros in Microsoft Word or Excel when mapping large numeric values.
For example, if you map the value $30, and the value actually represents "30 million", it is necessary to set the scaling factor to "6". This adds 6 zeros to the mapped value 30, and reports the value 30000000 in the instance document. If you apply a scale factor of ”-2” to “30”, this means to subtract 2 zeros, i.e. “0.3”. (This is often used when reporting percentages. The report says 30% which is actually the number 0.3).
Scaling is not mandatory. If a factor is not used, the scaling automatically defaults to 0, meaning that no scale is applied. The number “30” with scale=”0” is still “30”.

Decimal

Enter the number of decimal places to which the given value is accurate. This setting is required for SEC filers.

Enter the setting as a positive whole number to denote the accuracy of the value to the right of the decimal point.

For example, enter “3” to specify that the numeric fact is accurate to three digits right of the decimal point. In another example, if $42.38 is reported, then the decimals should be set to 2. If the number is 36.69%, the decimals should be set to 4.

You can also enter the number as a negative “-” number to denote the accuracy of the value to the left of the decimal point. For example if you assign decimals to be “-3”, the amount $30,000 is said to be accurate to the thousands. If decimals are "-6", the number is accurate to the millions.

Note:

It is often important to complement the decimals setting with the scaling property. For example, if you map the value $30 and it represents "30 million", it is necessary to set the scaling property to "6". This attribute adds 6 zeros to the mapped value 30 and report the value 30000000 in the instance document.

Precision

Select to use a precision setting and choose the number of digits of a numeric value that are accurate.

For example, if you enter “7”, the first seven digits counting from the left, starting at the first nonzero digit is correct to the seventh place.

By default, Disclosure Management uses the precision setting. This option is set to “INF.

Table 26. Scaling Fields and Descriptions

Field	Description
Scale By	Select the initial global Scale by factor. Scaling is a method whereby units of values are multiplied by a scale factor to determine the correct value to include in the instance document. Scaling eliminates the need to enter zeros in Microsoft Word or Excel when mapping large numeric values. Scaling factors are defined as an exponent of 10. For example if the document has a mapped value of "2" and the scale factor is "3", then the value in the instance document is 2000. The default scaling factor is 0, which does not scale values. Negative scale factors such as "-1" or "-2" are also supported. For example, if you map the value $30, and the value actually represents "30 million", it is necessary to set the scaling factor to "6". This adds 6 zeros to the mapped value 30, and reports the value 30000000 in the instance document. If you apply a scale factor of ”-2” to “30”, this means to subtract 2 zeros, i.e. “0.3”. (This is often used when reporting percentages. The report says 30% which is actually the number 0.3). Scaling is not mandatory. If a factor is not used, the scaling automatically defaults to 0, meaning that no scale is applied. The number “30” with scale=”0” is still “30”.

Field

Description

Scale By

Select the initial global Scale by factor.

Scaling is a method whereby units of values are multiplied by a scale factor to determine the correct value to include in the instance document. Scaling eliminates the need to enter zeros in Microsoft Word or Excel when mapping large numeric values. Scaling factors are defined as an exponent of 10. For example if the document has a mapped value of "2" and the scale factor is "3", then the value in the instance document is 2000. The default scaling factor is 0, which does not scale values. Negative scale factors such as "-1" or "-2" are also supported.

For example, if you map the value $30, and the value actually represents "30 million", it is necessary to set the scaling factor to "6". This adds 6 zeros to the mapped value 30, and reports the value 30000000 in the instance document. If you apply a scale factor of ”-2” to “30”, this means to subtract 2 zeros, i.e. “0.3”. (This is often used when reporting percentages. The report says 30% which is actually the number 0.3).

Scaling is not mandatory. If a factor is not used, the scaling automatically defaults to 0, meaning that no scale is applied. The number “30” with scale=”0” is still “30”.

Table 27. Date Format Fields and Descriptions

Field	Description
Date Format	Displays the date format from the Date format drop down. Valid options are: None DD.MM.YY(YY) MM.DD.YY(YY) DD Month, YY(YY) Month DD, YY(YY) DD Mon YY(YY) Mon DD, YY(YY) DD/MM/YY(YY) MM/DD/YY(YY) Custom (date format must be specified in Custom format field)
Custom Format	Displays the custom date format.

Table 28. String Format Fields and Descriptions

Field	Description
String	Displays the format of string values. Formatting options are available for nonnumeric XBRL mappings in which the string is based on concepts of the “xbrl.us:TextBlockItemType” type and its derivatives. The available formatting options include: Rich text—Disclosure Management extracts the HTML formatted content from Office document and applies this formatting to the nonnumeric item. Plain text—Disclosure Management uses the formatting value of the corresponding fact and applies the formatting to the nonnumeric item. Default—A plain text format is applied to nonnumeric items by default. However the default configuration can be set to use the rich text format for certain string types and their derivatives.

Field

Description

String

Displays the format of string values.

Formatting options are available for nonnumeric XBRL mappings in which the string is based on concepts of the “xbrl.us:TextBlockItemType” type and its derivatives. The available formatting options include:

Rich text—Disclosure Management extracts the HTML formatted content from Office document and applies this formatting to the nonnumeric item.
Plain text—Disclosure Management uses the formatting value of the corresponding fact and applies the formatting to the nonnumeric item.
Default—A plain text format is applied to nonnumeric items by default. However the default configuration can be set to use the rich text format for certain string types and their derivatives.