Table & Column Reference — Release 26A
326 tables found — showing 151–175
| Table Name | Cols | Description |
|---|---|---|
| GL GL_JE_CATEGORIES_TL | 14 | GL_JE_CATEGORIES_TL contains journal entry categories. Each row includes the category name and descr... |
| GL GL_JE_HEADERS | 123 | GL_JE_HEADERS contains journal entries. There is a one-to-many relationship between journal entry ba... |
| GL GL_JE_LINES | 136 | GL_JE_LINES contains the journal entry lines that you enter in the Enter Journals form. There is a o... |
| GL GL_JE_SOURCES_TL | 14 | GL_JE_SOURCES_TL contains source name in installed languages. Each row includes the user source name... |
| GL GL_LEDGERS | 127 | GL_LEDGERS contains information about the ledgers defined in the Accounting Setup Manager and the le... |
| GL GL_LEDGERS_ALL_V | 0 | Schema: FUSIONObject owner: GL |
| GL GL_LEDGER_SETS | 18 | Stores ledger set definitions in Oracle Fusion General Ledger. A ledger set groups multiple ledgers ... |
| GL GL_LEDGER_SET_ASSIGNMENTS | 11 | GL_LEDGER_SET_ASSIGNMENTS contains information about each ledger or ledger set that is contained wi... |
| GL GL_PERIODS | 72 | GL_PERIODS contains information about the accounting periods that are defined using the Accounting C... |
| GL GL_PERIOD_SETS | 17 | GL_PERIOD_SETS stores the calendars you define using the Accounting Calendar form. Each row includes... |
| GL GL_PERIOD_STATUSES | 42 | GL_PERIOD_STATUSES contains the statuses of your accounting periods. Each row includes the accountin... |
| GL GL_PERIOD_TYPES | 18 | GL_PERIOD_TYPES contains the period types you define using the Period Types form. Each row includes ... |
| GL GL_RECURRING_BATCHES | 21 | Stores journal entry formula batches and budget formula batches in Oracle General Ledger. Each row r... |
| GL GL_RECURRING_HEADERS | 29 | Stores journal entry formula headers and budget formula headers in Oracle General Ledger. Correspond... |
| GL GL_RECURRING_LINES | 30 | Stores journal entry formula lines and budget formula lines in Oracle General Ledger. Each row repre... |
| GL GL_REVALUATIONS | 38 | GL_REVALUATIONS contains the Revaluation definitions. Each row includes a revaluation's identifier, ... |
| GL GL_SEGMENTS_V | 19 | A view that provides segment information for the Oracle General Ledger chart of accounts. Displays s... |
| GL GL_SEGMENT_VALUES | 19 | Stores segment values used in Oracle Fusion General Ledger. Contains the individual values for each ... |
| GL GL_SEGMENT_VALUES_INTERIM | 21 | Staging/interim table used during the loading and processing of segment values into Oracle Fusion Ge... |
| GL GL_SETS_OF_BOOKS | 0 | Schema: FUSIONObject owner: GL |
| GL GL_TRANSLATION_RATES | 22 | |
| GL GL_XCC_JOURNALS_EXTRACT_V | 60 | |
| HR HR_ALL_ORGANIZATION_UNITS_TL | 11 | Translation view for organization units in Oracle Fusion HCM. Provides organization names and titles... |
| HR HR_LOCATIONS_ALL | 42 | View that stores location information for all business groups in Oracle Fusion HCM. Contains address... |
| HR HR_ORGANIZATION_INFORMATION | 32 | View that stores additional information for organizations in Oracle Fusion HCM. Contains classificat... |