eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_PROJ_FP_OPTIONS

Product:	PA - Projects
Description:	This table stores the default financial planning options for a project, plan type or plan version.
Implementation/DBA Data:	PA.PA_PROJ_FP_OPTIONS

Primary Key: PA_PROJ_FP_OPTIONS_PK

PROJ_FP_OPTIONS_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_PROJ_FP_OPTIONS	PA_PERIOD_MASKS_B	PA_PROJ_FP_OPTIONS.ALL_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS	PA_PROJECTS_ALL	PA_PROJ_FP_OPTIONS.PROJECT_ID
PA_PROJ_FP_OPTIONS	GL_DAILY_CONVERSION_TYPES	PA_PROJ_FP_OPTIONS.PROJFUNC_COST_RATE_TYPE
PA_PROJ_FP_OPTIONS	GL_DAILY_CONVERSION_TYPES	PA_PROJ_FP_OPTIONS.PROJFUNC_REV_RATE_TYPE
PA_PROJ_FP_OPTIONS	GL_DAILY_CONVERSION_TYPES	PA_PROJ_FP_OPTIONS.PROJECT_COST_RATE_TYPE
PA_PROJ_FP_OPTIONS	GL_DAILY_CONVERSION_TYPES	PA_PROJ_FP_OPTIONS.PROJECT_REV_RATE_TYPE
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_TYPES_B	PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_TYPES_B	PA_PROJ_FP_OPTIONS.GEN_SRC_REV_PLAN_TYPE_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_REV_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_TYPES_B	PA_PROJ_FP_OPTIONS.GEN_SRC_ALL_PLAN_TYPE_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_ALL_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_TYPES_B	PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.COST_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_AMOUNT_SETS	PA_PROJ_FP_OPTIONS.ALL_AMOUNT_SET_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.REV_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.ALL_PERIOD_MASK_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_AMOUNT_SETS	PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID
PA_PROJ_FP_OPTIONS	PA_PROJ_ELEMENT_VERSIONS	PA_PROJ_FP_OPTIONS.RBS_STRUCT_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_REV_WP_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.GEN_SRC_ALL_WP_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_FIN_PLAN_AMOUNT_SETS	PA_PROJ_FP_OPTIONS.REVENUE_AMOUNT_SET_ID
PA_PROJ_FP_OPTIONS	PA_RESOURCE_LISTS_ALL_BG	PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID
PA_PROJ_FP_OPTIONS	PA_RESOURCE_LISTS_ALL_BG	PA_PROJ_FP_OPTIONS.COST_RESOURCE_LIST_ID
PA_PROJ_FP_OPTIONS	PA_RESOURCE_LISTS_ALL_BG	PA_PROJ_FP_OPTIONS.REVENUE_RESOURCE_LIST_ID
PA_PROJ_FP_OPTIONS	PA_BUDGET_VERSIONS	PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID
PA_PROJ_FP_OPTIONS	PA_RBS_VERSIONS_B	PA_PROJ_FP_OPTIONS.RBS_VERSION_ID
PA_FP_ELEMENTS	PA_PROJ_FP_OPTIONS	PA_FP_ELEMENTS.PROJ_FP_OPTIONS_ID
PA_FP_EXCLUDED_ELEMENTS	PA_PROJ_FP_OPTIONS	PA_FP_EXCLUDED_ELEMENTS.PROJ_FP_OPTIONS_ID
PA_FP_TXN_CURRENCIES	PA_PROJ_FP_OPTIONS	PA_FP_TXN_CURRENCIES.PROJ_FP_OPTIONS_ID
PA_FP_UPGRADE_AUDIT	PA_PROJ_FP_OPTIONS	PA_FP_UPGRADE_AUDIT.PROJ_FP_OPTIONS_ID