GL_ACCOUNT_GROUP_DETAILS
This table stores the individual accounts that comprise each account group. This enables easy monitoring of balances by the accounts in each group.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_ACCOUNT_GROUP_DETAILS_PK |
ACCOUNT_GROUP_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNT_GROUP_DETAIL_ID | NUMBER | 18 | Yes | Account group detail Identifier. | |
| ACCOUNT_GROUP_ID | NUMBER | 18 | Yes | User account group Identifier for account details record. | |
| ALWAYS_DISPLAY | VARCHAR2 | 1 | Specifies if the account should always be displayed on the Account Balances region. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier for account group details. | ||
| ACCOUNT_LABEL | VARCHAR2 | 100 | Account label used in account monitor infolet. | ||
| SEGMENT1_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 1 value. | ||
| SEGMENT2_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 2 value. | ||
| SEGMENT3_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 3 value. | ||
| SEGMENT4_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 4 value. | ||
| SEGMENT5_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 5 value. | ||
| SEGMENT6_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 6 value. | ||
| SEGMENT7_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 7 value. | ||
| SEGMENT8_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 8 value. | ||
| SEGMENT9_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 9 value. | ||
| SEGMENT10_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 10 value. | ||
| SEGMENT11_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 11 value. | ||
| SEGMENT12_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 12 value. | ||
| SEGMENT13_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 13 value. | ||
| SEGMENT14_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 14 value. | ||
| SEGMENT15_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 15 value. | ||
| SEGMENT16_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 16 value. | ||
| SEGMENT17_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 17 value. | ||
| SEGMENT18_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 18 value. | ||
| SEGMENT19_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 19 value. | ||
| SEGMENT20_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 20 value. | ||
| SEGMENT21_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 21 value. | ||
| SEGMENT22_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 22 value. | ||
| SEGMENT23_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 23 value. | ||
| SEGMENT24_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 24 value. | ||
| SEGMENT25_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 25 value. | ||
| SEGMENT26_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 26 value. | ||
| SEGMENT27_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 27 value. | ||
| SEGMENT28_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 28 value. | ||
| SEGMENT29_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 29 value. | ||
| SEGMENT30_MEMBER_ID | VARCHAR2 | 60 | Cube member identifier of the chart of account segment 30 value. | ||
| CHANGE_TYPE_CODE | VARCHAR2 | 10 | Yes | Used to specify the type of balance analysis. It gets value from lookup type 'GL_CHANGE_CODE'. | |
| 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. | ||
| 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. | |
| THRESHOLD_VALUE | NUMBER | Specifies a threshold value for the selected Change Type Code value. | |||
| SEGMENT1_TREE_CODE | VARCHAR2 | 30 | Tree code of the chart of accounts segment1 value. | ||
| SEGMENT2_TREE_CODE | VARCHAR2 | 30 | Tree code of the chart of accounts segment2 value. | ||
| SEGMENT3_TREE_CODE | VARCHAR2 | 30 | Tree code of the chart of accounts segment3 value. | ||
| SEGMENT4_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment4 Value. | ||
| SEGMENT5_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment5 Value. | ||
| SEGMENT6_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment6 Value. | ||
| SEGMENT7_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment7 Value. | ||
| SEGMENT8_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment8 Value. | ||
| SEGMENT9_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment9 Value. | ||
| SEGMENT10_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment10 Value. | ||
| SEGMENT11_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment11 Value. | ||
| SEGMENT12_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment12 Value. | ||
| SEGMENT13_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment13 Value. | ||
| SEGMENT14_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment14 Value. | ||
| SEGMENT15_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment15 Value. | ||
| SEGMENT16_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment16 Value. | ||
| SEGMENT17_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment17 Value. | ||
| SEGMENT18_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment18 Value. | ||
| SEGMENT19_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment19 Value. | ||
| SEGMENT20_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment20 Value. | ||
| SEGMENT21_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment21 Value. | ||
| SEGMENT22_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment22 Value. | ||
| SEGMENT23_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment23 Value. | ||
| SEGMENT24_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment24 Value. | ||
| SEGMENT25_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment25 Value. | ||
| SEGMENT26_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment26 Value. | ||
| SEGMENT27_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment27 Value. | ||
| SEGMENT28_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment28 Value. | ||
| SEGMENT29_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment29 Value. | ||
| SEGMENT30_TREE_CODE | VARCHAR2 | 30 | Tree Code of the COA Segment30 Value. | ||
| SEGMENT1_TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of the chart of accounts segment1 value. | ||
| SEGMENT2_TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of the chart of accounts segment2 value. | ||
| SEGMENT3_TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of the chart of accounts segment3 value. | ||
| SEGMENT4_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment4 Value. | ||
| SEGMENT5_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment5 Value. | ||
| SEGMENT6_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment16 Value. | ||
| SEGMENT7_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment7 Value. | ||
| SEGMENT8_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment8 Value. | ||
| SEGMENT9_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment9 Value. | ||
| SEGMENT10_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment10 Value. | ||
| SEGMENT11_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment11 Value. | ||
| SEGMENT12_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment12 Value. | ||
| SEGMENT13_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment13 Value. | ||
| SEGMENT14_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment14 Value. | ||
| SEGMENT15_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment15 Value. | ||
| SEGMENT16_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment16 Value. | ||
| SEGMENT17_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment17 Value. | ||
| SEGMENT18_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment18 Value. | ||
| SEGMENT19_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment19 Value. | ||
| SEGMENT20_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment20 Value. | ||
| SEGMENT21_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment21 Value. | ||
| SEGMENT22_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment22 Value. | ||
| SEGMENT23_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment23 Value. | ||
| SEGMENT24_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment24 Value. | ||
| SEGMENT25_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment25 Value. | ||
| SEGMENT26_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment26 Value. | ||
| SEGMENT27_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment27 Value. | ||
| SEGMENT28_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment28 Value. | ||
| SEGMENT29_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment29 Value. | ||
| SEGMENT30_TREE_VERSION_ID | VARCHAR2 | 32 | Tree Version of the COA Segment30 Value. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_ACCOUNT_GROUP_DETAILS_U1 | Unique | Default | ACCOUNT_GROUP_DETAIL_ID |