[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_DAILY_BALANCES |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_DAILY_BALANCES
|
| Subobject Name: | |
| Status: | VALID |
GL_DAILY_BALANCES stores daily aggregate balances for detail and summary balance sheet accounts in sets of books with average balances enabled.
This table stores functional currency, foreign entered, statistical, and translated daily aggregate balances for each non-adjusting period that has ever been opened. When journal entries are posted, Oracle General Ledger's Posting program populates this table with aggregate amounts calculated from your journal line amounts. Journal entries posted to adjusting periods will be treated as if they are posted to the corresponding non-adjusting periods which the accounting dates fall into.
Since Oracle General Ledger currently only maintains actual daily aggregate balances, the ACTUAL_FLAG column is always 'A'.
The CURRENCY_TYPE, CURRENCY_CODE, and CONVERTED_FROM_CURRENCY columns serve to identify functional, foreign entered, statistical, and translated balances rows in GL_DAILY_BALANCES. The CURRENCY_TYPE column is 'U' for cumulative functional currency balances or statistical balances; 'E' for foreign entered balances; 'C' for functional currency equivalents of foreign entered balances; 'T' for up to date translated rows; and 'O' for out of date translated rows. The CURRENCY_CODE column contains the currency of the amounts in the row. The CONVERTED_FROM_CURRENCY column contains the functional currency code in the case of functional currency equivalents of foreign entered balances, and null otherwise.
Through the aggregate columns, you can derive the four supported average amount types for non-translated balances, period average to date (PATD), quarter average to date (QATD), year average to date (YATD), and end of date (EOD), using the following formulas:
For a particular accounting date i,
PATD(i) = Period_Aggregate(k) / ( i - Period_Start_Date + 1)
QATD(i) = ( Opening_Quarter_Aggregate + Period_Aggregate(k) ) / ( i - Quarter_Start_Date + 1)
YATD(i) = ( Opening_Year_Aggregate + Period_Aggregate(k) ) / ( i - Year_Start_Date + 1)
EOD(i) = Period_Aggregate(1), for k=1, OR
EOD(i) = Period_Aggregate(k) - Period_Aggregate(k-1), for k>1
where k is the aggregate column index. k is 1 + the offset from the start date of the period that date i is in.
For translated average balances, the aggregates are stored in separate physical columns. The following formulas derive the four average amount types for translated balances:
For a particular accounting date i,
PATD(i) = Period_Aggregate(k) / ( i - Period_Start_Date + 1)
QATD(i) = Quarter_Aggregate(k) / ( i - Quarter_Start_Date + 1)
YATD(i) = Year_Aggregate(k) / ( i - Year_Start_Date + 1)
EOD(i) = End_Of_Day(k)
where k is the aggregate column index. k is 1 + the offset from the start date of the period that date i is in.
For non-translated balances, END_OF_DAY, QUARTER_AGGREGATE, and YEAR_AGGREGATE are always NULL. For translated balances, QUARTER_AGGREGATE or YEAR_AGGREGATE columns are NULL if you choose not to maintain translated QATD or YATD. OPENING_QUARTER_AGGREGATE and OPENING_YEAR_AGGREGATE columns are always NULL for translated balances.
GL_DAILY_BALANCES maintains at the account level each balance sheet account posted to an average balance ledger. For income statement accounts, Oracle General Ledger's Posting program summarizes balances posted into net income account rows on a per balancing segment value basis.
For detail account rows, TEMPLATE_ID is always NULL. For summary account rows, TEMPLATE_ID has ids of the corresponding summary templates.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 25 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_DAILY_BALANCES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 CODE_COMBINATION_ID
PERIOD_NAME
CURRENCY_CODE
|
| GL_DAILY_BALANCES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERIOD_NAME
|
| GL_DAILY_BALANCES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERIOD_YEAR
PERIOD_NUM
|
| GL_DAILY_BALANCES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TEMPLATE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | Key Flexfield combination defining column |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency |
| CURRENCY_TYPE | VARCHAR2 | (1) | Yes | Currency type |
| ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Always 'A' |
| PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting Period |
| PERIOD_START_DATE | DATE | Yes | Start date of the accounting period | |
| PERIOD_END_DATE | DATE | Yes | End date of the accounting period | |
| QUARTER_START_DATE | DATE | Yes | Start date of the quarter containing the accounting period | |
| YEAR_START_DATE | DATE | Yes | Start date of the fiscal year containing the accounting period | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| CONVERTED_FROM_CURRENCY | VARCHAR2 | (15) | Currency the balance was converted from | |
| PERIOD_TYPE | VARCHAR2 | (15) | Accounting period type | |
| PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
| PERIOD_NUM | NUMBER | (15) | Accounting period number | |
| TEMPLATE_ID | NUMBER | (15) | Summary template defining column | |
| OPENING_PERIOD_AGGREGATE | NUMBER | End of day balance of the last day of the previous period | ||
| OPENING_QUARTER_AGGREGATE | NUMBER | Aggregate of the end balances of all days in this quarter before the 1st day of this accounting period. This column is not used for translated balances. | ||
| OPENING_YEAR_AGGREGATE | NUMBER | Aggregate of the end balances of all days in this year before the 1st day of this accounting period. This column is not used for translated balances. | ||
| PERIOD_AGGREGATE1 | NUMBER | End balance of the 1st day of this accounting period | ||
| PERIOD_AGGREGATE2 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 2nd day of this accounting period | ||
| PERIOD_AGGREGATE3 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 3rd day of this accounting period | ||
| PERIOD_AGGREGATE4 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 4th day of this accounting period | ||
| PERIOD_AGGREGATE5 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 5th day of this accounting period | ||
| PERIOD_AGGREGATE6 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 5th day of this accounting period | ||
| PERIOD_AGGREGATE7 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 8th day of this accounting period | ||
| PERIOD_AGGREGATE8 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 8th day of this accounting period | ||
| PERIOD_AGGREGATE9 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 9th day of this accounting period | ||
| PERIOD_AGGREGATE10 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 10th day of this accounting period | ||
| PERIOD_AGGREGATE11 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 11th day of this accounting period | ||
| PERIOD_AGGREGATE12 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 12th day of this accounting period | ||
| PERIOD_AGGREGATE13 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 13th day of this accounting period | ||
| PERIOD_AGGREGATE14 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 14th day of this accounting period | ||
| PERIOD_AGGREGATE15 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 15th day of this accounting period | ||
| PERIOD_AGGREGATE16 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 16th day of this accounting period | ||
| PERIOD_AGGREGATE17 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 17th day of this accounting period | ||
| PERIOD_AGGREGATE18 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 18th day of this accounting period | ||
| PERIOD_AGGREGATE19 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 19th day of this accounting period | ||
| PERIOD_AGGREGATE20 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 20th day of this accounting period | ||
| PERIOD_AGGREGATE21 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 21st day of this accounting period | ||
| PERIOD_AGGREGATE22 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 22nd day of this accounting period | ||
| PERIOD_AGGREGATE23 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 23rd day of this accounting period | ||
| PERIOD_AGGREGATE24 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 24th day of this accounting period | ||
| PERIOD_AGGREGATE25 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 25th day of this accounting period | ||
| PERIOD_AGGREGATE26 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 26th day of this accounting period | ||
| PERIOD_AGGREGATE27 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 26th day of this accounting period | ||
| PERIOD_AGGREGATE28 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 28th day of this accounting period | ||
| PERIOD_AGGREGATE29 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 29th day of this accounting period | ||
| PERIOD_AGGREGATE30 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 30th day of this accounting period | ||
| PERIOD_AGGREGATE31 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 31st day of this accounting period | ||
| PERIOD_AGGREGATE32 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 32nd day of this accounting period | ||
| PERIOD_AGGREGATE33 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 33rd day of this accounting period | ||
| PERIOD_AGGREGATE34 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 34th day of this accounting period | ||
| PERIOD_AGGREGATE35 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 35th day of this accounting period | ||
| END_OF_DAY1 | NUMBER | End of day balance for the 1st day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY2 | NUMBER | End of day balance for the 2nd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY3 | NUMBER | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY4 | NUMBER | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY5 | NUMBER | End of day balance for the 5th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY6 | NUMBER | End of day balance for the 6th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY7 | NUMBER | End of day balance for the 7th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY8 | NUMBER | End of day balance for the 8th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY9 | NUMBER | End of day balance for the 9th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY10 | NUMBER | End of day balance for the 10th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY11 | NUMBER | End of day balance for the 11th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY12 | NUMBER | End of day balance for the 12th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY13 | NUMBER | End of day balance for the 13th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY14 | NUMBER | End of day balance for the 14th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY15 | NUMBER | End of day balance for the 15th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY16 | NUMBER | End of day balance for the 16th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY17 | NUMBER | End of day balance for the 17th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY18 | NUMBER | End of day balance for the 18th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY19 | NUMBER | End of day balance for the 19th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY20 | NUMBER | End of day balance for the 20th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY21 | NUMBER | End of day balance for the 21st day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY22 | NUMBER | End of day balance for the 22nd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY23 | NUMBER | End of day balance for the 23rd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY24 | NUMBER | End of day balance for the 24th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY25 | NUMBER | End of day balance for the 25th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY26 | NUMBER | End of day balance for the 26th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY27 | NUMBER | End of day balance for the 27th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY28 | NUMBER | End of day balance for the 28th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY29 | NUMBER | End of day balance for the 29th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY30 | NUMBER | End of day balance for the 30th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY31 | NUMBER | End of day balance for the 31st day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY32 | NUMBER | End of day balance for the 32nd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY33 | NUMBER | End of day balance for the 33rd day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY34 | NUMBER | End of day balance for the 34th day of this accounting period. This column is only used for translated balances. | ||
| END_OF_DAY35 | NUMBER | End of day balance for the 35th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE1 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 1st day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE2 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 2nd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE3 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 3rd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE4 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 4th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE5 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 5th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE6 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 6th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE7 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 7th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE8 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 8th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE9 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 9th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE10 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 10th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE11 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 11th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE12 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 12th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE13 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 13th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE14 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 13th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE15 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 15th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE16 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 16th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE17 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 17th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE18 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 18th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE19 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 19th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE20 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 20th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE21 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 21st day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE22 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 22nd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE23 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 23rd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE24 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 24th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE25 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 25th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE26 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 26th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE27 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 27th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE28 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 28th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE29 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 29th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE30 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 30th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE31 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 31st day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE32 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 32nd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE33 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 33rd day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE34 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the3 4th day of this accounting period. This column is only used for translated balances. | ||
| QUARTER_AGGREGATE35 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 35th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE1 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 1st day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE2 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 2nd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE3 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 3rd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE4 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 4th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE5 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 5th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE6 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 6th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE7 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 7th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE8 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 7th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE9 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 9th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE10 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 10th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE11 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 11th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE12 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 12th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE13 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 13th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE14 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 14th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE15 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 15th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE16 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 16th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE17 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 17th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE18 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 18th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE19 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 19th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE20 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 19th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE21 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 21st day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE22 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 22nd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE23 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 23rd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE24 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 24th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE25 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 25th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE26 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE27 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE28 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 28th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE29 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 29th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE30 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 30th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE31 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 31st day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE32 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 32nd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE33 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 33rd day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE34 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 34th day of this accounting period. This column is only used for translated balances. | ||
| YEAR_AGGREGATE35 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 35th day of this accounting period. This column is only used for translated balances. |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, CURRENCY_TYPE
, ACTUAL_FLAG
, PERIOD_NAME
, PERIOD_START_DATE
, PERIOD_END_DATE
, QUARTER_START_DATE
, YEAR_START_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CONVERTED_FROM_CURRENCY
, PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, TEMPLATE_ID
, OPENING_PERIOD_AGGREGATE
, OPENING_QUARTER_AGGREGATE
, OPENING_YEAR_AGGREGATE
, PERIOD_AGGREGATE1
, PERIOD_AGGREGATE2
, PERIOD_AGGREGATE3
, PERIOD_AGGREGATE4
, PERIOD_AGGREGATE5
, PERIOD_AGGREGATE6
, PERIOD_AGGREGATE7
, PERIOD_AGGREGATE8
, PERIOD_AGGREGATE9
, PERIOD_AGGREGATE10
, PERIOD_AGGREGATE11
, PERIOD_AGGREGATE12
, PERIOD_AGGREGATE13
, PERIOD_AGGREGATE14
, PERIOD_AGGREGATE15
, PERIOD_AGGREGATE16
, PERIOD_AGGREGATE17
, PERIOD_AGGREGATE18
, PERIOD_AGGREGATE19
, PERIOD_AGGREGATE20
, PERIOD_AGGREGATE21
, PERIOD_AGGREGATE22
, PERIOD_AGGREGATE23
, PERIOD_AGGREGATE24
, PERIOD_AGGREGATE25
, PERIOD_AGGREGATE26
, PERIOD_AGGREGATE27
, PERIOD_AGGREGATE28
, PERIOD_AGGREGATE29
, PERIOD_AGGREGATE30
, PERIOD_AGGREGATE31
, PERIOD_AGGREGATE32
, PERIOD_AGGREGATE33
, PERIOD_AGGREGATE34
, PERIOD_AGGREGATE35
, END_OF_DAY1
, END_OF_DAY2
, END_OF_DAY3
, END_OF_DAY4
, END_OF_DAY5
, END_OF_DAY6
, END_OF_DAY7
, END_OF_DAY8
, END_OF_DAY9
, END_OF_DAY10
, END_OF_DAY11
, END_OF_DAY12
, END_OF_DAY13
, END_OF_DAY14
, END_OF_DAY15
, END_OF_DAY16
, END_OF_DAY17
, END_OF_DAY18
, END_OF_DAY19
, END_OF_DAY20
, END_OF_DAY21
, END_OF_DAY22
, END_OF_DAY23
, END_OF_DAY24
, END_OF_DAY25
, END_OF_DAY26
, END_OF_DAY27
, END_OF_DAY28
, END_OF_DAY29
, END_OF_DAY30
, END_OF_DAY31
, END_OF_DAY32
, END_OF_DAY33
, END_OF_DAY34
, END_OF_DAY35
, QUARTER_AGGREGATE1
, QUARTER_AGGREGATE2
, QUARTER_AGGREGATE3
, QUARTER_AGGREGATE4
, QUARTER_AGGREGATE5
, QUARTER_AGGREGATE6
, QUARTER_AGGREGATE7
, QUARTER_AGGREGATE8
, QUARTER_AGGREGATE9
, QUARTER_AGGREGATE10
, QUARTER_AGGREGATE11
, QUARTER_AGGREGATE12
, QUARTER_AGGREGATE13
, QUARTER_AGGREGATE14
, QUARTER_AGGREGATE15
, QUARTER_AGGREGATE16
, QUARTER_AGGREGATE17
, QUARTER_AGGREGATE18
, QUARTER_AGGREGATE19
, QUARTER_AGGREGATE20
, QUARTER_AGGREGATE21
, QUARTER_AGGREGATE22
, QUARTER_AGGREGATE23
, QUARTER_AGGREGATE24
, QUARTER_AGGREGATE25
, QUARTER_AGGREGATE26
, QUARTER_AGGREGATE27
, QUARTER_AGGREGATE28
, QUARTER_AGGREGATE29
, QUARTER_AGGREGATE30
, QUARTER_AGGREGATE31
, QUARTER_AGGREGATE32
, QUARTER_AGGREGATE33
, QUARTER_AGGREGATE34
, QUARTER_AGGREGATE35
, YEAR_AGGREGATE1
, YEAR_AGGREGATE2
, YEAR_AGGREGATE3
, YEAR_AGGREGATE4
, YEAR_AGGREGATE5
, YEAR_AGGREGATE6
, YEAR_AGGREGATE7
, YEAR_AGGREGATE8
, YEAR_AGGREGATE9
, YEAR_AGGREGATE10
, YEAR_AGGREGATE11
, YEAR_AGGREGATE12
, YEAR_AGGREGATE13
, YEAR_AGGREGATE14
, YEAR_AGGREGATE15
, YEAR_AGGREGATE16
, YEAR_AGGREGATE17
, YEAR_AGGREGATE18
, YEAR_AGGREGATE19
, YEAR_AGGREGATE20
, YEAR_AGGREGATE21
, YEAR_AGGREGATE22
, YEAR_AGGREGATE23
, YEAR_AGGREGATE24
, YEAR_AGGREGATE25
, YEAR_AGGREGATE26
, YEAR_AGGREGATE27
, YEAR_AGGREGATE28
, YEAR_AGGREGATE29
, YEAR_AGGREGATE30
, YEAR_AGGREGATE31
, YEAR_AGGREGATE32
, YEAR_AGGREGATE33
, YEAR_AGGREGATE34
, YEAR_AGGREGATE35
FROM GL.GL_DAILY_BALANCES;
GL.GL_DAILY_BALANCES does not reference any database object
GL.GL_DAILY_BALANCES is referenced by following:
GL
GL_DAILY_BALANCES#
|
|
|
|