FND Design Data [Home] [Help]

Table: PA_EXPENDITURE_ITEMS_ALL

Product: PA - Projects
Description: The smallest units of expenditure charged to projects and tasks
Implementation/DBA Data: TablePA.PA_EXPENDITURE_ITEMS_ALL
Primary Key: PA_EXPENDITURE_ITEMS_PK
  1. ColumnEXPENDITURE_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_TASKS PA_EXPENDITURE_ITEMS_ALL.TASK_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_PROJECTS_ALL PA_EXPENDITURE_ITEMS_ALL.PROJECT_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_SYSTEM_LINKAGES PA_EXPENDITURE_ITEMS_ALL.SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURE_TYPES PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePER_JOBS PA_EXPENDITURE_ITEMS_ALL.JOB_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.RECEIPT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.DENOM_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.PROJECT_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.DENOM_TP_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.ACCT_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURES_ALL PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.PROJECT_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.ACCT_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_EXPENDITURE_ITEMS_ALL.CC_PRVDR_ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_EXPENDITURE_ITEMS_ALL.CC_RECVR_ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.PROJECT_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_TP_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_COST_RATE_TYPE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_PROJECT_ASSIGNMENTS PA_EXPENDITURE_ITEMS_ALL.ASSIGNMENT_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_WORK_TYPES_B PA_EXPENDITURE_ITEMS_ALL.WORK_TYPE_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_NON_LABOR_RESOURCE_ORGS PA_EXPENDITURE_ITEMS_ALL.ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL.NON_LABOR_RESOURCE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableFND_CURRENCIES PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_CURRENCY_CODE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_CAPITAL_EVENTS PA_EXPENDITURE_ITEMS_ALL.CAPITAL_EVENT_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TableBOM_RESOURCES PA_EXPENDITURE_ITEMS_ALL.WIP_RESOURCE_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_LABOR_COST_MULTIPLIERS PA_EXPENDITURE_ITEMS_ALL.LABOR_COST_MULTIPLIER_NAME
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_TRANSACTION_SOURCES PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePER_JOBS PA_EXPENDITURE_ITEMS_ALL.BILL_JOB_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_ALL FK Joins to TablePA_EXPENDITURES_ALL PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID
TableGMS_ENCUMBRANCE_ITEMS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL GMS_ENCUMBRANCE_ITEMS_ALL.PEL_EXPENDITURE_ITEM_ID
TableGMS_BURDEN_COMPONENTS FK Joins to PA_EXPENDITURE_ITEMS_ALL GMS_BURDEN_COMPONENTS.EXPENDITURE_ITEM_ID
TableGMS_EVENT_INTERSECT FK Joins to PA_EXPENDITURE_ITEMS_ALL GMS_EVENT_INTERSECT.EXPENDITURE_ITEM_ID
TablePA_ALLOC_TXN_DETAILS FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_ALLOC_TXN_DETAILS.EXPENDITURE_ITEM_ID
TablePA_AUD_COST_DIST_LINES FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_AUD_COST_DIST_LINES.EXPENDITURE_ITEM_ID
TablePA_CC_DIST_LINES_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
TablePA_COST_DISTRIBUTION_LINES_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID
TablePA_CUST_REV_DIST_LINES_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
TablePA_DRAFT_INVOICE_DETAILS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_DRAFT_INVOICE_DETAILS_ALL.EXPENDITURE_ITEM_ID
TablePA_EXPEND_ITEM_ADJ_ACTIVITIES FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_EXPEND_ITEM_ADJ_ACTIVITIES.EXPENDITURE_ITEM_ID
TablePA_EXPENDITURE_COMMENTS FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_COMMENTS.EXPENDITURE_ITEM_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID
TablePA_MC_CC_DIST_LINES_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_MC_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
TablePA_MC_COST_DIST_LINES_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_MC_COST_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
TablePA_MC_EXP_ITEMS_ALL FK Joins to PA_EXPENDITURE_ITEMS_ALL PA_MC_EXP_ITEMS_ALL.EXPENDITURE_ITEM_ID