FND Design Data [Home] [Help]

Table: PSP_ELEMENT_TYPE_ACCOUNTS

Product: PSP - Labor Distribution
Description: Stores global elements accounts
Implementation/DBA Data: TablePSP.PSP_ELEMENT_TYPE_ACCOUNTS
Primary Key: PSP_ELEMENT_TYPE_ACCOUNTS_PK
  1. ColumnELEMENT_ACCOUNT_ID
Primary Key: PSP_ELEMENT_TYPE_ACCOUNTS_U1
  1. ColumnELEMENT_TYPE_ID
  2. ColumnSTART_DATE_ACTIVE
  3. ColumnGL_CODE_COMBINATION_ID
  4. ColumnPROJECT_ID
  5. ColumnEXPENDITURE_ORGANIZATION_ID
  6. ColumnEXPENDITURE_TYPE
  7. ColumnTASK_ID
  8. ColumnAWARD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TablePSP_ELEMENT_TYPES PSP_ELEMENT_TYPE_ACCOUNTS.ELEMENT_TYPE_ID
PSP_ELEMENT_TYPE_ACCOUNTS.START_DATE_ACTIVE
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TableGL_SETS_OF_BOOKS PSP_ELEMENT_TYPE_ACCOUNTS.SET_OF_BOOKS_ID
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TableGL_CODE_COMBINATIONS PSP_ELEMENT_TYPE_ACCOUNTS.GL_CODE_COMBINATION_ID
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TablePA_PROJECTS_ALL PSP_ELEMENT_TYPE_ACCOUNTS.PROJECT_ID
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_ELEMENT_TYPE_ACCOUNTS.EXPENDITURE_ORGANIZATION_ID
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TablePA_EXPENDITURE_TYPES PSP_ELEMENT_TYPE_ACCOUNTS.EXPENDITURE_TYPE
PSP_ELEMENT_TYPE_ACCOUNTS FK Joins to TablePA_TASKS PSP_ELEMENT_TYPE_ACCOUNTS.TASK_ID
TablePSP_DISTRIBUTION_LINES FK Joins to PSP_ELEMENT_TYPE_ACCOUNTS PSP_DISTRIBUTION_LINES.ELEMENT_ACCOUNT_ID
TablePSP_DISTRIBUTION_LINES_HISTORY FK Joins to PSP_ELEMENT_TYPE_ACCOUNTS PSP_DISTRIBUTION_LINES_HISTORY.ELEMENT_ACCOUNT_ID