Options file
The Options settings control how the application functions: what views are used, what graphics it uses in the interface, and other options. When you make changes to these settings, the changes are not reflected in the interface until IIS is restarted and all application objects are unloaded. Unload the application objects through the Monitor views page.
The settings are in the OptionsSource.txt and Options.txt files. You can modify the settings in the Options.txt file. Do not modify the OptionsSource.txt file. The Options.txt file is in the \ProgramData\Infor\CPM\Workstation directory on the CPM Server computer.
| Setting | Description |
|---|---|
| Data source | This setting maps the database to the data
source. The syntax is:
This setting must be added manually to the Options.txt file after the data source has been added through the Manage Data Sources page. |
| DisplayScrollbars | [Auto | On | Off] This setting controls the display of horizontal and vertical scroll bars on data entry and reporting grids. Specify Auto to display the scroll bars when both the contents of the grid do not fit in the viewable area and the grid is in focus. Specify On to always display the scroll bars regardless of content and focus. Specify Off to never display the scroll bars regardless of content and focus. The default is Auto. |
| Image_Loc | This setting specifies the path from the Web folder to the folder containing the images used in the Workstation interface. The default is /Workstation/Images. |
| OWCCodebase | [blank | file path of the Microsoft Office
installation image] This setting is provided for backward compatibility. If you
are an existing customer and you install to a new server, you may still need
this setting.
OWCCodebase=File:\\<YourServerName>\<YourOfficePath>\msowc.cab If you do not have Office Web Components 2000 installed, make sure this setting is commented out. |
| DetBud_WriteBackView | This setting specifies the name of the view to use for Worksheet Detail data entry for relational. The default is DetBud_WriteBack. |
| DetBud_SaveOption | [Save | Submit | Both] This setting controls which of the Save/Submit buttons appear and whether Detail Budgeting data is saved. Save and Submit save data. The default is Save. |
| DetBud_AssetsPerPage | This setting specifies the number of assets to display per page on data entry form. The default is 10. |
| DetBud_Frame_Width_ | This setting specifies the percentage of the browser window width that the tree control frame should use. The default is 25. |
| DetBud_Frame_BGColor | This setting specifies the background color to use for the left-side (member selection and tree control) frames of Detail Budgeting. The default is white. |
| DetBud_TopFrame_Height | This setting specifies the percentage of the browser window height that the member selection frame should use. The default value 15. |
| DetBudTree_SelectColor | This setting specifies the color of the text in the Detail Budgeting tree control when an item is selected. The default is red. |
| DetBudTree_HoverColor | This setting specifies the color of the text in the Detail Budgeting tree control when the mouse hovers over the text. The default is black. |
| DetBud_ShowGuidelines | [Yes | No] This setting controls whether the Guideline report is included in the Detail Budgeting tree options. This report displays definitions for Employee Types, Asset Types, and Schedule Line Mappings being used for Detail Budgeting. The default is Yes. |
| DetBud_ShowEvtGenerator | [Yes | No] This setting controls whether the Event Generator is included in the Detail Budgeting tree options. The default is Yes. |
| DetBud_ShowEmplyeeSummary | [Yes | No] This setting controls whether the Employee Summary page is displayed. The default is Yes. |
| DetBud_RptFontName | This setting specifies the font to use for Detail Budgeting reports. The default is Arial. |
| DetBud_RptFreezeCols | [Yes | No | Number] The default is Yes.
Specifies whether non-data columns on Detail Budgeting reports should be frozen
when scrolling horizontally. Yes causes all non-data columns to be frozen. No
causes no columns to be frozen. Number causes that number of columns to be
frozen, up to the maximum non-data columns for that report. For example:
causes 3 columns to be frozen. |
| DetBud_RptGridHdrBGColor | This setting specifies the background color to be used for the first header line in Detail Budgeting reports. The default is F0F0F0. |
| FinConRpt_DefaultPrecision | This setting specifies the decimal precision to use in the journal entry grid. The default is 2. |
| ICDE_Left_Frame_Width | This setting specifies the percentage of the browser window width that the tree control frame should use. The default is 25. |
| JEGrid_FontName | This setting specifies the font to use in the journal entry grid. The default is Arial. |
| JEGrid_FontSize | This setting specifies the font size to use in the journal entry grid. The default is 8. |
| JEGrid_ForeColor | This setting specifies the text color for the journal entry grid. The default is 000000. |
| JEGridBGColor | This setting specifies the background color for the journal entry grid. The default is ffffff. |
| JEGridHeader_FontName | This setting specifies the font to use for the header in the journal entry grid. The default is Arial. |
| JEGridHeaderFontSize | This setting specifies the font size to use in the journal entry grid. The default is 8. |
| JEGridHeader_BGColor | This setting specifies the background color for the header in the journal entry grid. The default is F0F0F0. |
| JEGridHeader_Forecolor | This setting specifies the text color for the header in the journal entry grid. The default is 000000. |
| JEGrid_LockedCellBGColor | This setting specifies the background color for a locked cell in the journal entry grid. The default is F0F0F0. |
| JEGrid_GrayAreaBGColor | This setting specifies the background color for the area between the grid and its container. The default is FFFFFF. |
| JEGrid_HideRowHeaders | [True | False] This setting turns the display of the row headers on and off. The default is false. |
| JEGrid_HideColHeaders | This setting turns the display of the column headers on and off. The default is false. |
| JEGrid_DisplayScrollBars | [Auto | On | Off] This setting controls the display of horizontal and vertical scroll bars on journal entry grids. Specify Auto to display the scroll bars when both the contents of the grid do not fit in the viewable area and the grid is in focus. Specify On to always display the scroll bars regardless of content and focus. Specify Off to never display the scroll bars regardless of content and focus. The default is Auto. |
| ODEGrid_BGColor | This setting specifies the background color for the ownership grid display area. The default is ffffff. |
| ODEGrid_Forecolor | The setting specified the text color for the grid display area. The default is 000000. |
| ODEGridLines_Color | This setting specifies the color of the grid lines for the grid display area. The default is 808080. |
| ODEGridHeader_BGColor | This setting specifies the background color for the header for the grid display area. The default is F0F0F0. |
| ODEGridHeader_Forecolor | This setting specifies the text color for the header for the grid display area. The default is 000000. |
| ODEGridHeader_LockedCellBGColor | This setting specifies the background color for the locked cells in the grid display area. The default is F0F0F0. |
| ODEGridHeader_RowHeight | This setting specifies the row height for the header in the grid display area. The default is 20 pixels. |
| ODEGrid_RowHeight | This setting specifies the row height for the grid display area. The default is 20 pixels. |
| ODEGrid_Period_ColWidth | This setting specifies the column width for the grid display area. The default is 100 pixels. |
| ODEGrid_SpanCells | The default is Y. |
| ODEGrid_Properties_FontSize | This setting specifies the font size to use in the data entry grid. The default is 8. |
| ODEGrid_Properties_FontName | This setting specifies the font to use in the data entry grid. The default is Arial. |
| CSM_BGColor | This setting specifies the background color for the grid display area. The default is white. |
| CSM_CurrentStatusColor | This setting specifies the color for cells and nodes when the consolidation status is current. The default is abc28a. |
| CSM_ImpactedStatusColor | This setting specifies the color for cells and nodes where the consolidation status is impacted. The default is db0000. |
| CSM_NoStatusColor | This setting specifies the color for cells and nodes when the consolidation status is not known. The default is F0F0F0. |
| CSM_FontColor | This setting specifies the font color for the grid. The default is black. |
| CSM_FontName | This setting specifies the font to use in the grid object. The default is Arial. |
| CSM_FontSize | This setting specifies the font size to use in the grid. The default is 8. |
| CSMGridHeader_FontName | This setting specifies the font to use in the header area of the grid. The default is Arial. |
| CSMGridHeader _FontSize | This setting specifies the font size to use in the header area of the grid. The default is 8. |
| CSMGridHeader_FontColor | This setting specifies the font color to use in the header area of the grid. The default is black. |
| CSMGridHeader _BGColor | This setting specifies the background color for the header area of the grid. The default is F0F0F0. |
| CSMGrid _DisplayScrollBars | [Auto | On | Off] This setting controls the display of horizontal and vertical scroll bars on the grid. Specify Auto to display the scroll bars when both the contents of the grid do not fit in the viewable area and the grid is in focus. Specify On to always display the scroll bars regardless of content and focus. Specify Off to never display the scroll bars regardless of content and focus. The default is Auto. |
| MPCW_ BGColor | This setting specifies the background color for the grid display area. The default is ffffff. |
| MPCW_ Font_Color | This setting specifies the font color for the grid. The default is black. |
| MPCW_ FontName | This setting specifies the font to use in the grid object. The default is Arial. |
| MPCW_ FontSize | This setting specifies the font size to use in the grid. The default is 8. |
| MPCWGridHeader_FontName | This setting specifies the font to use in the header area of the grid. The default is Arial. |
| MPCW GridHeader_FontSize | This setting specifies the font size to use in the header area of the grid. The default is 8. |
| MPCW GridHeader_FontColor | This setting specifies the font color to use in the header area of the grid. The default is black. |
| MPCW GridHeader_BGColor | This setting specifies the background color for the header area of the grid. The default is F0F0F0. |
| MPCW_ DisplayScrollBars | [Auto | On | Off] This setting controls the display of horizontal and vertical scroll bars on the grid. Specify Auto to display the scroll bars when both the contents of the grid do not fit in the viewable area and the grid is in focus. Specify On to always display the scroll bars regardless of content and focus. Specify Off to never display the scroll bars regardless of content and focus. The default is Auto. |
| MPCW_ LinesColor | This setting specifies the line color. |
| MPCW_ LockedCellBGColor | This setting specifies the background color for the locked cells in the grid display area. The default is F0F0F0. |
| JRTimeOut | This setting specifies the number of seconds to wait while generating audit reports. The default is 600 seconds. |
| WSLines_GridFont | This setting specifies the font name for the worksheet lines grid. The default is Arial. |
| WSLines_NoFreeze | [True | False] The default is false. |
| MAXWhereIDsChunkSize | The default is 1000. |
| JRDefReport | This setting specifies the file name for the Journal Definition report. The default is CPJrnlDefRpt.xsl. |
| JRAuditReport | This setting specifies the file name for the Journal Audit report. The default is CPAudByNameRpt.xsl. |
| JRReconReport | This setting specifies the file name for the Journal Reconciliation report. The default is CPReconRpt.xsl. |
| MatchReport | This setting specifies the file name for the Consolidation Elimination report. The default is CPElimRpt.xsl. |
| ICTransReport | This setting specifies the file name for the Intercompany Transaction Detail report. The default is ICTransactionDetailRpt.xsl. |
| IMG_FolderClosed | This setting specifies the path and name of the file containing the image used in the Journals list to represent a collapsed list. The default is Images\icn-tree_folderFolderClosed.png. |
| IMG_FolderOpen | This setting specifies the path and name of the file containing the image used in the Journals list to represent an expanded list. The default is Images\icn-tree_FolderOpen.png. |
| IMG_PostJrnCk | This setting specifies the path and name of the file containing the image used in the Journals list to represent a selected, posted journal. The default is Images\PostJrnCk.gif. |
| IMG_PostJrn | This setting specifies the path and name of the file containing the image used in the Journals list to represent a posted journal. The default is Images\PostJrn.gif. |
| IMG_UnpostJrnCk | This setting specifies the path and name of the file containing the image used in the Journals list to represent a selected, unposted journal. The default is Images\UnpostJrnChk.gif. |
| IMG_UnpostJrn | This setting specifies the path and name of the file containing the image used in the Journals list to represent an unposted journal. The default is Images\UnpostJrn.gif. |
| IMG_WorkingJrnCk | This setting specifies the path and name of the file containing the image used in the Journals list to represent a selected working, unposted journal. The default is Images\WorkJrnCk.gif. |
| IMG_WorkingJrn | This setting specifies the path and name of the file containing the image used in the Journals list to represent a working, unposted journal. The default is Images\WorkJrn.gif. |
| Tree_Spacing | This setting specifies the vertical spacing between the members of the Journals tree list on the Journal Entry tab. The value must be entered in pixels. |