Formatting Documents

You can set global document properties that apply to all documents. In addition, using a different option, you can override global settings for the current document that is selected:

number prefixes and suffixes
thousands and decimal separators for parsing Microsoft Word document numerical data when performing mapping (Document Properties)
decimals or precision settings for all numeric data that is persisted to an instance document
scaling factors
date formats

To apply document properties:

Select an option:
- To set global formatting options - On the Disclosure Management ribbon, click and then select Transformation.
- To set the formatting options for the selected document: On the Disclosure Management ribbon, click .
Optional: From Prefix or Suffix list, specify a prefix or suffix for positive numbers.
Optional: From the Prefix or Suffix list, specify a prefix or suffix for negative numbers.
Optional: From the Separator Characters list, select the character format to represent thousands and decimal separators for the current report.

To specify custom separator character formats, select Custom from the Separator Characters list, and then select a Thousands Separator character and Decimal Separator character.
Optional: Select either Decimal or Precision, and then select a place from the drop down.
Optional: Select Scale By, and then select the factor from the drop down.
Optional: From the Date format list, select a date format for the report.

Alternately, you can specify a Custom date format by selecting Custom from the Date Format list, and enter the date format in the Custom Format field.
In the String Format drop-down, select the format of string values.

Note:

If you are formatting the current document only, you can click the Reset button to revert to the global formatting.
Click OK.

Note:

The Sample section shows the results of your formatting selections.

Table 9-1 Positive Number Symbols Fields and Descriptions

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

Field

Description

Prefix

Sets the symbol, which is placed to the left of each positive value. Symbol options are:

None
$
%
[
]

The default prefix symbol is None.

Alternatively, you can specify another symbol in the list by highlighting the field and typing another symbol.

Suffix

Sets the symbol, which is placed to the right of each positive value. Symbol options are:

None
$
%
[
]

The default prefix symbol is None.

Alternatively, you can specify another symbol in the list by highlighting the field and entering another symbol.

Table 9-2 Negative Number Symbols Fields and Descriptions

Field	Description
Prefix	Sets the 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	Sets the symbol which is placed to the right of each negative value. Symbol options are: None $ % [ ] The default prefix symbol is None. Alternatively, you can specify another symbol in the list by highlighting the field and typing another symbol.

Field

Description

Prefix

Sets the 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

Sets the symbol which is placed to the right of each negative value. Symbol options are:

None
$
%
[
]

The default prefix symbol is None.

Alternatively, you can specify another symbol in the list by highlighting the field and typing another symbol.

Table 9-3 Separator Character Fields and Descriptions

Field	Description
Separator Character	Sets the thousands and decimal separator character format for numeric values from the Separator Characters list. You can specify a custom format by selecting Custom from the Separator Characters list. Next, select a thousands separator from the Thousands Separator list, and a decimal separator format from the Decimal Separator list.
Thousands Separator	Sets the character for separating thousands in values from the Thousands Separator list. For example, you can select comma ( , ) to display a value of 1,000, or you can select period ( . ) to display a value of 1.000. Options are: comma ( , ), period ( . ), underscore ( _ ), and (blank) space. Alternatively, you can specify another symbol in the list by highlighting the field and entering another symbol.
Decimal Separator	Sets the character to represent decimal points (for example, 1,000.06) from the Decimal Separator list. Options are: comma ( , ), period ( . ), underscore ( _ ), and (blank) space. Alternatively, you can specify another symbol in the list by highlighting the field and entering another symbol.

Table 9-4 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 setting 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 setting 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 9-5 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 9-6 Date Format Fields and Descriptions

Field Description

Date Format

Field	Description
Date Format	Select the date format from the Date format drop down. Valid options are: None `"(D)D(M)M"` `"(M)M(D)D"` `"(D)D(Mon)th"` `"(Mon)th(D)D"` `"(Mon)th(Y)YYY"` `"(Y)Y(YY)(Mon)th"` `"(D)D(Mon)th(Y)Y(YY)"` `"(Y)Y(YY)(D)D(Mon)th"` `"(Y)Y(YY)(Mon)th(D)D"` Custom (date format must be specified in Custom format field)
Custom Format	To specify a custom date format, specify the custom date format.

Select the date format from the Date format drop down. Valid options are:

None
"(D)D*(M)M"
"(M)M*(D)D"
"(D)D*(Mon)th"
"(Mon)th*(D)D"
"(Mon)th*(Y)YYY"
"(Y)Y(YY)*(Mon)th"
"(D)D*(Mon)th*(Y)Y(YY)"
"(Y)Y(YY)*(D)D*(Mon)th"
"(Y)Y(YY)*(Mon)th*(D)D"
Custom (date format must be specified in Custom format field)

Custom Format To specify a custom date format, specify the custom date format.

Table 9-7 String Format Fields and Descriptions

Field	Description
String	Specify the format of the string. 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

Specify the format of the string. 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.