Document Properties

Use Document Properties options to add and modify global settings for:

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:

From the Disclosure Management ribbon, select Document Properties.
Select Transformation.
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 Character list, select the character format to represent thousands and decimal separators for the current report.
To specify a custom thousand separator character format, select Custom from the Separator Character list, and then select the thousand separator character format from the Thousand Separator list.
To specify a custom decimal separator form, select Custom from the Separator Character list, and then select the decimal separator character format from the Decimal Separator list.
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 specify the date format in the Custom Format.
Click OK.
To return to the original default values, click Reset.

Note:

View the results of your number format option selections in the Sample section.

Table 29. 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.

Table 30. 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.

Table 31. 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, specify another symbol in the list by highlighting the field and entering another symbol.

Table 32. Decimal and Precision Format Fields and Descriptions

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 33. 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 34. Date Format Fields and Descriptions

Field	Description
Date Format	Select 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	To specify a custom date format, specify the custom date format.
String Format	n/a