FND Design Data [Home] [Help]

Table: PA_PROJECT_EXP_ITEM_ACCUM

Product: PA - Projects
Description: Accumulated revenue, costs, and quantities from expenditure items (used only when running in Dual Accumulation Mode).
Implementation/DBA Data: TablePA.PA_PROJECT_EXP_ITEM_ACCUM
Primary Key: PA_PROJECT_EXP_ITEM_ACCUM_PK
  1. ColumnPROJECT_ID
  2. ColumnPA_PERIOD
  3. ColumnGL_PERIOD
  4. ColumnEXPENDITURE_TYPE
  5. ColumnTASK_ID
  6. ColumnEXPENDITURE_ORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJECT_EXP_ITEM_ACCUM FK Joins to TablePA_PROJECTS_ALL PA_PROJECT_EXP_ITEM_ACCUM.PROJECT_ID
PA_PROJECT_EXP_ITEM_ACCUM FK Joins to TablePA_TASKS PA_PROJECT_EXP_ITEM_ACCUM.TASK_ID
PA_PROJECT_EXP_ITEM_ACCUM FK Joins to TablePA_EXPENDITURE_TYPES PA_PROJECT_EXP_ITEM_ACCUM.EXPENDITURE_TYPE
PA_PROJECT_EXP_ITEM_ACCUM FK Joins to TablePA_EXPENDITURE_CATEGORIES PA_PROJECT_EXP_ITEM_ACCUM.EXPENDITURE_CATEGORY