GL_DRM_SEGVALUES_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 | Oracle internal use only. |
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). | |
STATUS | VARCHAR2 | 30 | Segment value status code. | |
START_DATE_ACTIVE | DATE | Oracle internal use only. | ||
END_DATE_ACTIVE | DATE | Oracle internal use only. | ||
SUMMARY_FLAG | VARCHAR2 | 30 | Oracle internal use only. | |
SORT_ORDER | NUMBER | Oracle internal use only. | ||
ENABLED_FLAG | VARCHAR2 | 10 | Oracle internal use only. | |
ACCOUNT_TYPE | VARCHAR2 | 64 | Oracle internal use only. | |
ALLOW_POSTING | VARCHAR2 | 10 | Oracle internal use only. | |
ALLOW_BUDGETING | VARCHAR2 | 10 | Oracle internal use only. | |
THIRD_PARTY_CTRL_ACCT | VARCHAR2 | 64 | Oracle internal use only. | |
RECONCILE | VARCHAR2 | 10 | Oracle internal use only. | |
FINANCIAL_CATEGORY | VARCHAR2 | 256 | Oracle internal use only. | |
DESC_AR | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_CS | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_D | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_DK | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_E | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_EL | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_ESA | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_F | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_FRC | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_HR | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_HU | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_I | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_IS | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_IW | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_JA | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_KO | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_NL | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_LT | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_PL | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_PT | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_PTB | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_N | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_RO | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_RU | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_S | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_SF | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_SK | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_SL | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_TH | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_TR | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_US | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_ZHS | VARCHAR2 | 240 | Oracle internal use only. | |
DESC_ZHT | VARCHAR2 | 240 | Oracle internal use only. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
GL_DRM_SEGVALUES_INTERFACE_N1 | Non Unique | Default | VALUE_SET_CODE |