GL_DRM_HIERARCHY_INTERFACE
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| VALUE | VARCHAR2 | 150 | Yes | Value represents a segment value in the hierarchy being interfaced to General Ledger. |
| VALUE_SET_CODE | VARCHAR2 | 60 | Internal unique identifier for a value set. Value set is a group of values and related attributes assigned to a key flexfield segment (account). | |
| TREE_NAME | VARCHAR2 | 80 | The name given to the account hierarchy. | |
| TREE_VERSION_NAME | VARCHAR2 | 80 | The name given to an account hierarchy version for deriving the applicable descendants. | |
| PARENT_VALUE | VARCHAR2 | 150 | Parent Value represents the value's parent in the hierarchy being interfaced to General Ledger. | |
| DEPTH | NUMBER | Depth represents how many ancestors a value has in the hierarchy. This information is used by the consuming program to make the processing more efficient. | ||
| STATUS_CODE | VARCHAR2 | 30 | Segment value status code. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_DRM_HIERARCHY_INTERFACE_N1 | Non Unique | Default | VALUE_SET_CODE |