The Type field allows you to specify the type of data the column contains.
The following options are available in the drop-down box for the Type field:
•Balance – This option indicates that the data displayed in this column is balance data for a specific period. Based on the setting in the Value Type field, this can indicate either a normal balance, a beginning balance or a year-to-date balance.
If you have any option other than “Balance” selected in your Type field, the Book Code, Year, Period and Value Type options will not be available.
•Row Segment ID – This option indicates that the data displayed in this column will be the segment identifier, or account code, for the item displayed on a given row in the row definition.
•Row Definition Description – This option indicates that the data displayed in this column will reflect a row description for the item displayed on a given row in the row definition.
•Calculated – This option indicates that the data displayed in this column will be the result of the formula defined in the Formula field.
•Detail – This option indicates that transaction attributes will be available on transaction level drill down. This selection should be used as an additional column in your Column Definition.
When the Detail option is selected it will activate an additional row in your column definition which will allow you to specify the type of transactional attributes shown. The Detail Type field row setting must be used in conjunction with this selection.
•Blank - This option indicates that the column will appear as a blank, or empty, column on the report.
For more information, refer to the Column Definition Prosperities Pane Layout Section.