GL_COA_MAP_ROLLUP_RULES
GL_COA_MAP_ROLLUP_RULES contains the source segment ranges that you define in the Rollup Rules section of the Segment Rules region of the Chart of Accounts Mappings page. You need one row for each range that you define. Each row contains a range of source segment values and the target segment value they map to. There is a one-to-many relationship between a row in the GL_COA_MAP_SEGMENT_RULES table and the rows in this table.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_COA_MAP_ROLLUP_RULES_PK |
ROLLUP_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEGMENT_RULE_ID | NUMBER | Yes | Chart of accounts mapping segment rule defining column. | ||
| ROLLUP_RULE_ID | NUMBER | 18 | Yes | Unique identifier of the rollup rule. | |
| TO_FLEX_VALUE | VARCHAR2 | 25 | Yes | Target chart of accounts segment value. | |
| FROM_FLEX_VALUE_LOW | VARCHAR2 | 25 | Low range value of the source chart of accounts segment. | ||
| FROM_FLEX_VALUE_HIGH | VARCHAR2 | 25 | Source segment high range value. | ||
| TREE_CODE | VARCHAR2 | 30 | Tree code of source segment parent value. | ||
| TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of source segment parent value. | ||
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | |
| 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_COA_MAP_ROLLUP_RULES | gl_coa_map_segment_rules | SEGMENT_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_COA_MAP_ROLLUP_RULES_U1 | Unique | Default | SEGMENT_RULE_ID, TO_FLEX_VALUE, FROM_FLEX_VALUE_LOW, FROM_FLEX_VALUE_HIGH, TREE_CODE, TREE_VERSION_ID |
| GL_COA_MAP_ROLLUP_RULES_U2 | Unique | Default | ROLLUP_RULE_ID |