GL_JE_SEGMENT_VALUES

GL_JE_SEGMENT_VALUES contains the balancing and management segment values used in each journal entry. Each row in this table stores the associated journal entry ID, the segment type (balancing or management), and the segment value. There is a one-to-many relationship between the journal entries in the GL_JE_HEADERS table and this table.

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

GL_JE_SEGMENT_VALUES_PK

JE_HEADER_ID, SEGMENT_TYPE_CODE, SEGMENT_VALUE

Columns

Name Datatype Length Precision Not-null Comments
JE_HEADER_ID NUMBER 18 Yes Journal header identifier. Foreign key to GL_JE_HEADERS.
SEGMENT_TYPE_CODE VARCHAR2 1 Yes Segment type (balancing or management).
SEGMENT_VALUE VARCHAR2 30 Yes Balancing or management segment value used in a journal.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of 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.
PARTITION_GROUP_CODE VARCHAR2 15 Partition grouping information which when combined with the period, determines the database partition in which this journal will be stored.
PERIOD_NAME VARCHAR2 15 Accounting period for the journal.

Foreign Keys

Table Foreign Table Foreign Key Column
GL_JE_SEGMENT_VALUES gl_je_headers JE_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
GL_JE_SEGMENT_VALUES_U1 Unique Default JE_HEADER_ID, SEGMENT_TYPE_CODE, SEGMENT_VALUE