GL_DAILY_BALANCES
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.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier of daily balance. | Active | |
CODE_COMBINATION_ID | NUMBER | 18 | Yes | Key Flexfield combination defining column. | Active | |
CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of daily balance. | Active | |
CURRENCY_TYPE | VARCHAR2 | 1 | Yes | Currency type code of daily balance. | Active | |
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Actual flag of daily balance. Valid value is 'A'. | Active | |
PERIOD_NAME | VARCHAR2 | 15 | Yes | Accounting period name code of daily balance. | Active | |
PERIOD_START_DATE | DATE | Yes | Start date of the accounting period. | Active | ||
PERIOD_END_DATE | DATE | Yes | End date of the accounting period. | Active | ||
QUARTER_START_DATE | DATE | Yes | Start date of the quarter containing the accounting period. | Active | ||
YEAR_START_DATE | DATE | Yes | Start date of the fiscal year containing the accounting period. | Active | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
CONVERTED_FROM_CURRENCY | VARCHAR2 | 15 | Currency the balance was converted from. | Active | ||
PERIOD_TYPE | VARCHAR2 | 15 | Accounting period type code of daily balance. | Active | ||
PERIOD_YEAR | NUMBER | 18 | Accounting period year code of daily balance. | Active | ||
PERIOD_NUM | NUMBER | 18 | Accounting period number code of daily balance. | Active | ||
TEMPLATE_ID | NUMBER | 18 | Summary template defining column. | Active | ||
OPENING_PERIOD_AGGREGATE | NUMBER | End of day balance of the last day of the previous period. | Active | |||
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. | Active | |||
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. | Active | |||
PERIOD_AGGREGATE1 | NUMBER | End balance of the 1st day of this accounting period. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
PERIOD_AGGREGATE6 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 6th day of this accounting period. | Active | |||
PERIOD_AGGREGATE7 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 7th day of this accounting period. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
PERIOD_AGGREGATE27 | NUMBER | Aggregate of the end balances of all days in this period, up to and including the 27th day of this accounting period. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
END_OF_DAY1 | NUMBER | End of day balance for the 1st day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY2 | NUMBER | End of day balance for the 2nd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY3 | NUMBER | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY4 | NUMBER | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY5 | NUMBER | End of day balance for the 5th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY6 | NUMBER | End of day balance for the 6th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY7 | NUMBER | End of day balance for the 7th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY8 | NUMBER | End of day balance for the 8th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY9 | NUMBER | End of day balance for the 9th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY10 | NUMBER | End of day balance for the 10th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY11 | NUMBER | End of day balance for the 11th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY12 | NUMBER | End of day balance for the 12th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY13 | NUMBER | End of day balance for the 13th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY14 | NUMBER | End of day balance for the 14th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY15 | NUMBER | End of day balance for the 15th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY16 | NUMBER | End of day balance for the 16th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY17 | NUMBER | End of day balance for the 17th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY18 | NUMBER | End of day balance for the 18th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY19 | NUMBER | End of day balance for the 19th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY20 | NUMBER | End of day balance for the 20th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY21 | NUMBER | End of day balance for the 21st day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY22 | NUMBER | End of day balance for the 22nd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY23 | NUMBER | End of day balance for the 23rd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY24 | NUMBER | End of day balance for the 24th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY25 | NUMBER | End of day balance for the 25th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY26 | NUMBER | End of day balance for the 26th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY27 | NUMBER | End of day balance for the 27th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY28 | NUMBER | End of day balance for the 28th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY29 | NUMBER | End of day balance for the 29th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY30 | NUMBER | End of day balance for the 30th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY31 | NUMBER | End of day balance for the 31st day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY32 | NUMBER | End of day balance for the 32nd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY33 | NUMBER | End of day balance for the 33rd day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY34 | NUMBER | End of day balance for the 34th day of this accounting period. This column is only used for translated balances. | Active | |||
END_OF_DAY35 | NUMBER | End of day balance for the 35th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
QUARTER_AGGREGATE14 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 14th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
QUARTER_AGGREGATE34 | NUMBER | Aggregate of the end balances of all days in this quarter, up to and including the 34th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
YEAR_AGGREGATE8 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 8th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
YEAR_AGGREGATE20 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 20th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
YEAR_AGGREGATE26 | NUMBER | Aggregate of the end balances of all days in this year, up to and including the 26th day of this accounting period. This column is only used for translated balances. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
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. | Active | |||
REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
PROGRAM_APPLICATION_ID | NUMBER | This column is used in internal processing only | Active | |||
PROGRAM_ID | NUMBER | This column is used in internal processing only | Active | |||
PROGRAM_UPDATE_DATE | DATE | Last program update date of daily balance. | Active | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which when combined with the period, determines the database partition in which this daily balance will be stored. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
GL_DAILY_BALANCES | gl_code_combinations | CODE_COMBINATION_ID |
GL_DAILY_BALANCES | gl_ledgers | LEDGER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
GL_DAILY_BALANCES_N1 | Non Unique | FUSION_TS_TX_DATA | CODE_COMBINATION_ID, PERIOD_NAME, CURRENCY_CODE | |
GL_DAILY_BALANCES_N2 | Non Unique | FUSION_TS_TX_DATA | PERIOD_NAME | Active |
GL_DAILY_BALANCES_N3 | Non Unique | FUSION_TS_TX_DATA | PERIOD_YEAR, PERIOD_NUM | Active |
GL_DAILY_BALANCES_U1 | Unique | Default | LEDGER_ID, CODE_COMBINATION_ID, CURRENCY_CODE, CURRENCY_TYPE, ACTUAL_FLAG, PERIOD_NAME, CONVERTED_FROM_CURRENCY |