[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_CONSOLIDATION_AUDIT |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_CONSOLIDATION_AUDIT
|
| Subobject Name: | |
| Status: | VALID |
GL_CONSOLIDATION_AUDIT stores consolidation information when you transfer consolidation data in audit mode. You get one row in this table for each consolidation line that is transferred to Journal Import. You can delete rows from this table using the Purge Consolidation Audit Data form. The Segment1 through Segment30 columns store the destination code combination of the consolidation line.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_CONSOLIDATION_AUDIT_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 CONSOLIDATION_ID
TO_PERIOD_NAME
AVERAGE_CONSOLIDATION_FLAG
|
| GL_CONSOLIDATION_AUDIT_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
FROM_CODE_COMBINATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONSOLIDATION_ID | NUMBER | Yes | Consolidation defining column | |
| TO_PERIOD_NAME | VARCHAR2 | (15) | Yes | Parent accounting period name |
| FROM_PERIOD_NAME | VARCHAR2 | (15) | Yes | Subsidiary accounting period name |
| TO_LEDGER_ID | NUMBER | Yes | Parent ledger defining column | |
| REQUEST_ID | NUMBER | (15) | Yes | Consolidation concurrent request defining column |
| ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Balance type lookup (Actual, Budget, or Encumbrance) |
| CONSOLIDATION_TYPE | VARCHAR2 | (4) | Yes | Consolidation type |
| ACCOUNTING_DATE | DATE | Yes | Accounting date | |
| AVERAGE_CONSOLIDATION_FLAG | VARCHAR2 | (1) | Yes | Average consolidation flag |
| FROM_LEDGER_ID | NUMBER | Yes | Subsidiary ledger defining column | |
| FROM_CODE_COMBINATION_ID | NUMBER | (15) | Yes | Subsidiary key flex account defining column |
| ENTERED_DR | NUMBER | Consolidated debit amount | ||
| ENTERED_CR | NUMBER | Consolidated credit amount | ||
| SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT21 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT22 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT23 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT24 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT25 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT26 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT27 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT28 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT29 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT30 | VARCHAR2 | (25) | Key flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT CONSOLIDATION_ID
, TO_PERIOD_NAME
, FROM_PERIOD_NAME
, TO_LEDGER_ID
, REQUEST_ID
, ACTUAL_FLAG
, CONSOLIDATION_TYPE
, ACCOUNTING_DATE
, AVERAGE_CONSOLIDATION_FLAG
, FROM_LEDGER_ID
, FROM_CODE_COMBINATION_ID
, ENTERED_DR
, ENTERED_CR
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM GL.GL_CONSOLIDATION_AUDIT;
GL.GL_CONSOLIDATION_AUDIT does not reference any database object
GL.GL_CONSOLIDATION_AUDIT is referenced by following:
GL
GL_CONSOLIDATION_AUDIT#
|
|
|
|