FND Design Data [Home] [Help]

Table: PA_TRANSACTION_CONTROLS

Product: PA - Projects
Description: Transaction controls of chargeable and billable status for projects and tasks
Implementation/DBA Data: TablePA.PA_TRANSACTION_CONTROLS
Primary Key: PA_TRANSACTION_CONTROLS_PK
  1. ColumnPROJECT_ID
  2. ColumnTASK_ID
  3. ColumnEXPENDITURE_CATEGORY
  4. ColumnSTART_DATE_ACTIVE
  5. ColumnPERSON_ID
  6. ColumnEXPENDITURE_TYPE
  7. ColumnNON_LABOR_RESOURCE
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_TRANSACTION_CONTROLS FK Joins to TablePA_PROJECTS_ALL PA_TRANSACTION_CONTROLS.PROJECT_ID
PA_TRANSACTION_CONTROLS FK Joins to TablePA_TASKS PA_TRANSACTION_CONTROLS.TASK_ID
PA_TRANSACTION_CONTROLS FK Joins to TablePA_EXPENDITURE_CATEGORIES PA_TRANSACTION_CONTROLS.EXPENDITURE_CATEGORY
PA_TRANSACTION_CONTROLS FK Joins to TablePA_EXPENDITURE_TYPES PA_TRANSACTION_CONTROLS.EXPENDITURE_TYPE
PA_TRANSACTION_CONTROLS FK Joins to TablePA_NON_LABOR_RESOURCES PA_TRANSACTION_CONTROLS.NON_LABOR_RESOURCE