FND Design Data [Home] [Help]

Table: GL_OASIS_SUMMARY_DATA

Product: GL - General Ledger
Description: Summarized financial data needed for Business Intelligence System reports
Implementation/DBA Data: TableGL.GL_OASIS_SUMMARY_DATA
Primary Key: GL_OASIS_SUMMARY_DATE_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnFIN_ITEM_ID
  3. ColumnDRILLDOWN_SEGNUM1
  4. ColumnDRILLDOWN_SEGNUM2
  5. ColumnACTUAL_FLAG
  6. ColumnDRILLDOWN_SEGVAL1
  7. ColumnDRILLDOWN_SEGVAL2
  8. ColumnRELATIVE_PERIOD_POS
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_OASIS_SUMMARY_DATA FK Joins to TableGL_SETS_OF_BOOKS_11I GL_OASIS_SUMMARY_DATA.SET_OF_BOOKS_ID
GL_OASIS_SUMMARY_DATA FK Joins to TableGL_OASIS_FIN_ITEMS_11I GL_OASIS_SUMMARY_DATA.FIN_ITEM_ID