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_EXPENDITURE_ITEMS_ALL

Product:	PA - Projects
Description:	The smallest units of expenditure charged to projects and tasks
Implementation/DBA Data:	PA.PA_EXPENDITURE_ITEMS_ALL

Primary Key: PA_EXPENDITURE_ITEMS_PK

EXPENDITURE_ITEM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_EXPENDITURE_ITEMS_ALL	PA_TASKS	PA_EXPENDITURE_ITEMS_ALL.TASK_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_PROJECTS_ALL	PA_EXPENDITURE_ITEMS_ALL.PROJECT_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_SYSTEM_LINKAGES	PA_EXPENDITURE_ITEMS_ALL.SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_TYPES	PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_TYPE
PA_EXPENDITURE_ITEMS_ALL	PER_JOBS	PA_EXPENDITURE_ITEMS_ALL.JOB_ID
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.RECEIPT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.DENOM_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.PROJECT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.DENOM_TP_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.ACCT_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURES_ALL	PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.PROJECT_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.ACCT_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	HR_ALL_ORGANIZATION_UNITS	PA_EXPENDITURE_ITEMS_ALL.CC_PRVDR_ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL	HR_ALL_ORGANIZATION_UNITS	PA_EXPENDITURE_ITEMS_ALL.CC_RECVR_ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.PROJECT_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	GL_DAILY_CONVERSION_TYPES	PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_COST_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL	PA_PROJECT_ASSIGNMENTS	PA_EXPENDITURE_ITEMS_ALL.ASSIGNMENT_ID
PA_EXPENDITURE_ITEMS_ALL	PA_WORK_TYPES_B	PA_EXPENDITURE_ITEMS_ALL.WORK_TYPE_ID
PA_EXPENDITURE_ITEMS_ALL	PA_NON_LABOR_RESOURCE_ORGS	PA_EXPENDITURE_ITEMS_ALL.ORGANIZATION_ID PA_EXPENDITURE_ITEMS_ALL.NON_LABOR_RESOURCE
PA_EXPENDITURE_ITEMS_ALL	FND_CURRENCIES	PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL	PA_CAPITAL_EVENTS	PA_EXPENDITURE_ITEMS_ALL.CAPITAL_EVENT_ID
PA_EXPENDITURE_ITEMS_ALL	BOM_RESOURCES	PA_EXPENDITURE_ITEMS_ALL.WIP_RESOURCE_ID
PA_EXPENDITURE_ITEMS_ALL	PA_LABOR_COST_MULTIPLIERS	PA_EXPENDITURE_ITEMS_ALL.LABOR_COST_MULTIPLIER_NAME
PA_EXPENDITURE_ITEMS_ALL	PA_TRANSACTION_SOURCES	PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE
PA_EXPENDITURE_ITEMS_ALL	PER_JOBS	PA_EXPENDITURE_ITEMS_ALL.BILL_JOB_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURES_ALL	PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID
GMS_ENCUMBRANCE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	GMS_ENCUMBRANCE_ITEMS_ALL.PEL_EXPENDITURE_ITEM_ID
GMS_BURDEN_COMPONENTS	PA_EXPENDITURE_ITEMS_ALL	GMS_BURDEN_COMPONENTS.EXPENDITURE_ITEM_ID
GMS_EVENT_INTERSECT	PA_EXPENDITURE_ITEMS_ALL	GMS_EVENT_INTERSECT.EXPENDITURE_ITEM_ID
PA_ALLOC_TXN_DETAILS	PA_EXPENDITURE_ITEMS_ALL	PA_ALLOC_TXN_DETAILS.EXPENDITURE_ITEM_ID
PA_AUD_COST_DIST_LINES	PA_EXPENDITURE_ITEMS_ALL	PA_AUD_COST_DIST_LINES.EXPENDITURE_ITEM_ID
PA_CC_DIST_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID
PA_CUST_REV_DIST_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_DRAFT_INVOICE_DETAILS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_DRAFT_INVOICE_DETAILS_ALL.EXPENDITURE_ITEM_ID
PA_EXPEND_ITEM_ADJ_ACTIVITIES	PA_EXPENDITURE_ITEMS_ALL	PA_EXPEND_ITEM_ADJ_ACTIVITIES.EXPENDITURE_ITEM_ID
PA_EXPENDITURE_COMMENTS	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_COMMENTS.EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID
PA_MC_CC_DIST_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_MC_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_MC_COST_DIST_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_MC_COST_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_MC_EXP_ITEMS_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_MC_EXP_ITEMS_ALL.EXPENDITURE_ITEM_ID