GL_REVAL_ACCOUNT_RANGES
GL_REVAL_ACCOUNT_RANGES contains the account ranges to be processed for a revaluation. Each row includes the revaluation id, the account range and two flags to indicate whether the balancing and natural account segments are parent values that should be expanded within the specified account range. Each account range stored in this table should be related to one and only one revaluation defined in GL_REVALUATIONS.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_REVAL_ACCOUNT_RANGES_PK |
REVAL_ACCOUNT_RANGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| REVAL_ACCOUNT_RANGE_ID | NUMBER | Yes | Revaluation account range defining column. | |||
| REVALUATION_ID | NUMBER | 18 | Yes | Revaluation definition identifier. | ||
| FLEX_FILTER | XMLTYPE | Key flexfield filter defining column. | ||||
| EXPAND_BALANCING_FLAG | VARCHAR2 | 1 | Yes | Indicates if Revaluation should expand the parent value for the balancing segment within the specified account range. | ||
| EXPAND_NATURAL_ACCOUNT_FLAG | VARCHAR2 | 1 | Yes | Indicates if Revaluation should expand the parent value for the natural account segment within the specified account range. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| SEGMENT1_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT1_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT1_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT2_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT2_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT2_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT3_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT3_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT3_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT4_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT4_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT4_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT5_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT5_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT5_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT6_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT6_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT6_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT7_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT7_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT7_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT8_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT8_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT8_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT9_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT9_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT9_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT10_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT10_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT10_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT11_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT11_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT11_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT12_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT12_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT12_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT13_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT13_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT13_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT14_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT14_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT14_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT15_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT15_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT15_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT16_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT16_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT16_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT17_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT17_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT17_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT18_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT18_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT18_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT19_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT19_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT19_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT20_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT20_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT20_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT21_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT21_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT21_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT22_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT22_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT22_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT23_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT23_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT23_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT24_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT24_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT24_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT25_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT25_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT25_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT26_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT26_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT26_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT27_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT27_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT27_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT28_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT28_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT28_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT29_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT29_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT29_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| SEGMENT30_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | |||
| SEGMENT30_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | |||
| SEGMENT30_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Revaluation Account Ranges (GL_REVAL_ACCOUNT_RANGES) | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_REVAL_ACCOUNT_RANGES | gl_revaluations | REVALUATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_REVAL_ACCOUNT_RANGES_U1 | Unique | FUSION_TS_TX_IDX | REVAL_ACCOUNT_RANGE_ID |
| GL_REVEL_ACCOUNT_RANGES_N1 | Non Unique | FUSION_TS_TX_IDX | REVALUATION_ID |