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_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:	PA.PA_PROJECT_EXP_ITEM_ACCUM

Primary Key: PA_PROJECT_EXP_ITEM_ACCUM_PK

PROJECT_ID
PA_PERIOD
GL_PERIOD
EXPENDITURE_TYPE
TASK_ID
EXPENDITURE_ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_PROJECT_EXP_ITEM_ACCUM	PA_PROJECTS_ALL	PA_PROJECT_EXP_ITEM_ACCUM.PROJECT_ID
PA_PROJECT_EXP_ITEM_ACCUM	PA_TASKS	PA_PROJECT_EXP_ITEM_ACCUM.TASK_ID
PA_PROJECT_EXP_ITEM_ACCUM	PA_EXPENDITURE_TYPES	PA_PROJECT_EXP_ITEM_ACCUM.EXPENDITURE_TYPE
PA_PROJECT_EXP_ITEM_ACCUM	PA_EXPENDITURE_CATEGORIES	PA_PROJECT_EXP_ITEM_ACCUM.EXPENDITURE_CATEGORY