Probably a silly question but which table stores the time periods for Financial Plans (likely among other things)? I know that PRTIMEPERIOD stores the values for the timesheet periods, but I don't think that's where I need to be looking for this. I'm trying to query out the End Dates of all the Cost Plans in projects, which is usually just month/year (i.e. 2015 06 June).
If you look at the tech ref, it clearly states the table (I've highlighted in BOLD for your reference - BIZ_COM_PERIODS)
This table stores the properties of the plans in the system.
This numeric column represents the total actual benefit of a benefit plan.
This column is not used.
The time-sliced value of planned benefit amount.
The benefit plan ID with which this plan is associated. This refers to the internal ID of the table FIN_PLANS.
The ID of the financial plan.
The time-scaled value of the planned cost amount.
This column refers to the resource (CMN_SEC_USERS.ID) that created this row.
This column refers to the date and time this row was created.
The description of the financial plan.
The end time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table.
This column refers to the internal ID of the plan.
This column indicates if the plan is the plan of record.
The resource that last updated this row. This refers to CMN_SEC_USERS.ID.
The date and time this row was last updated.
The name of the financial plan.
The object ID for which the plan was created.
The object for which the plan was created. This refers to the internal ID of the object instance.
This column indicates the plan period type. It is one of the values from the lookup type "PERIOD_TYPE."
This column indicates the first plan by option. Values are:
This column indicates the second plan by option. Value are:
This column indicates the plan type. Values can be either budget or forecast. These are the lookup values from lookup type FIN_PLAN_TYPE.
The time-scaled value of the planned revenue amount.
The plan revision.
The starting time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table.
The status of the plan. Values are:
The sub type of the plan. This indicates if the plan is a cost plan or a benefit plan.
This numeric column represents the total actual benefit for a line item of a benefit plan.
The total planned benefit amount.
The total benefit amount in billing currency.
The total planned cost amount.
The total planned revenue amount.
The total planed units.
The time-scaled value of the plan units.