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_EXPENDITURES_ALL

Product:	PA - Projects
Description:	Groups of expenditure items incurred by employees or organizations for an expenditure period
Implementation/DBA Data:	PA.PA_EXPENDITURES_ALL

Primary Key: PA_EXPENDITURES_PK

EXPENDITURE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_EXPENDITURES_ALL	PO_VENDORS	PA_EXPENDITURES_ALL.VENDOR_ID
PA_EXPENDITURES_ALL	FND_CURRENCIES	PA_EXPENDITURES_ALL.DENOM_CURRENCY_CODE
PA_EXPENDITURES_ALL	FND_CURRENCIES	PA_EXPENDITURES_ALL.ACCT_CURRENCY_CODE
PA_EXPENDITURES_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURES_ALL.ACCT_RATE_TYPE
PA_EXPENDITURES_ALL	PA_EXPENDITURE_GROUPS_ALL	PA_EXPENDITURES_ALL.EXPENDITURE_GROUP PA_EXPENDITURES_ALL.ORG_ID
PA_EXPENDITURES_ALL	HR_ALL_ORGANIZATION_UNITS	PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURES_ALL	PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID
PA_ROUTINGS	PA_EXPENDITURES_ALL	PA_ROUTINGS.EXPENDITURE_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURES_ALL	PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID