GL_BALANCES_CUBES
This table is used for internal processing only
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUBE_ID | NUMBER | 18 | Yes | Hierarchy cube identifier for which balances are stored. | |
| CUBE_NAME | VARCHAR2 | 60 | Yes | Hierarchy cube member name for which balances are stored. | |
| APPLICATION_NAME | VARCHAR2 | 60 | Yes | Fusion application name that owns the balances. | |
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Chart of accounts identifier that identifies the accounts flexfields. | |
| CALENDAR_ID | NUMBER | 18 | Yes | Fusion accounting hub calendar identifier. | |
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Fusion accounting hub period set name. | |
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Fusion accounting hub period type code. | |
| CUBE_TYPE | VARCHAR2 | 10 | Yes | Hierarchy cube type for which balances are stored. | |
| ESSBASE_SERVER_PORT | VARCHAR2 | 1000 | Yes | Hierarchy cube access server port. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| SEGMENT1_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT1. | ||
| SEGMENT2_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT2. | ||
| SEGMENT3_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT3. | ||
| SEGMENT4_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT4. | ||
| SEGMENT5_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT5. | ||
| SEGMENT6_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT6. | ||
| SEGMENT7_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT7. | ||
| SEGMENT8_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT8. | ||
| SEGMENT9_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT9. | ||
| SEGMENT10_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT10. | ||
| SEGMENT11_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT11. | ||
| SEGMENT12_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT12. | ||
| SEGMENT13_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT13. | ||
| SEGMENT14_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT14. | ||
| SEGMENT15_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT15. | ||
| SEGMENT16_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT16. | ||
| SEGMENT17_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT17. | ||
| SEGMENT18_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT18. | ||
| SEGMENT19_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT19. | ||
| SEGMENT20_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT20. | ||
| SEGMENT21_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT21. | ||
| SEGMENT22_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT22. | ||
| SEGMENT23_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT23. | ||
| SEGMENT24_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT24. | ||
| SEGMENT25_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT25. | ||
| SEGMENT26_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT26. | ||
| SEGMENT27_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT27. | ||
| SEGMENT28_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT28. | ||
| SEGMENT29_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT29. | ||
| SEGMENT30_SEQ | NUMBER | 18 | Sequence defining column for SEGMENT30. | ||
| SOURCE_CONFIG_ID | NUMBER | 18 | Source configuration identifier. | ||
| CUBE_CREATION_STATUS_CODE | VARCHAR2 | 20 | Hierarchy cube creation status code. | ||
| QUARTER_NAME | VARCHAR2 | 30 | The name of the quarter for which the cube is created. | ||
| START_PERIOD_NAME | VARCHAR2 | 15 | The starting period of the quarter. | ||
| END_PERIOD_NAME | VARCHAR2 | 15 | The ending period of the quarter. | ||
| START_DATE | DATE | Date when the quarter containing this accounting period starts. | |||
| END_DATE | DATE | Date when the quarter containing this accounting period ends. | |||
| LAST_PUBLISH_DATE | TIMESTAMP | Last date and time on which the publish hierarchies job was run on the cube. | |||
| LAST_BALANCE_SYNC_DATE | TIMESTAMP | Last date and time on which the balances synchronization job was run on the cube. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_BALANCES_CUBES_U1 | Unique | Default | CHART_OF_ACCOUNTS_ID, CALENDAR_ID, CUBE_TYPE, QUARTER_NAME |
| GL_BALANCES_CUBES_U2 | Unique | Default | APPLICATION_NAME, CUBE_TYPE |