ENUM_LEGAL_ENTITY

4 rows


Description

This is a table for Legal Entity enumeration. Stores Type of Entities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ENUM_LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID LEGAL_ENTITY_ENUM_LEGAL_E_FK1R
PROCESS.ENUM_LEGAL_ENTITY_ID PROCESS_ENUM_LEGAL_ENTITY_FKR
PROCESS_COLLECTION.ENUM_LEGAL_ENTITY_ID PROCESS_COLLECTION_ENUM_L_FK1R
PROCESS_ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID PROCESS_LEGAL_ENTITY_ENUM_FK1R

Field Enumeration Legal Entity ID. Stores primary key for this table.

NAME VARCHAR2 500 null

Field Name. Stores the name given to this record.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

VERSION_ID NUMBER 18 0

Field Version. Stores the version of the record.

CUSER VARCHAR2 75 null

Field Create User. Stores who create the record.

CDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Create Date. Stores when the record was created.

MUSER VARCHAR2 75 null

Field Modified User. Stores who modified the record.

MDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Modified Date. Stores when the record was modified.

Indexes

Constraint Name Type Sort Column(s)
ENUM_ENTITY_PK Primary key Asc ENUM_LEGAL_ENTITY_ID

Relationships