S_OBJ_TEMPLATES |
Default Table Name | S_OBJ_TEMPLATES |
Definition |
S_OBJ_TEMPLATES Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TMPL_ID | VARCHAR2(30) | NO | ||
DATA_TYPE | VARCHAR2(1) | NO | ||
FORMAT | VARCHAR2(30) | YES | ||
VAL_JS_CLASS | VARCHAR2(90) | YES | ||
VAL_JS_MTHD | VARCHAR2(90) | YES | ||
VAL_CLASS | VARCHAR2(90) | YES | ||
VAL_MTHD | VARCHAR2(90) | YES | ||
ORG_SEC_TYPE_CD | VARCHAR2(1) | NO | ||
LKP_RS_ID | VARCHAR2(30) | YES | ||
LKP_CHILD_NO | NUMBER(14, 0) | YES | ||
LKP_OBJ_ID | VARCHAR2(72) | YES | ||
LKP_SQL | LONG | YES | ||
LKP_VAL_CD | VARCHAR2(1) | YES | ||
LKP_VAL_SEVERE_CD | VARCHAR2(1) | YES | ||
LKP_MSG_ID | VARCHAR2(32) | YES | ||
DFLT_LABEL | VARCHAR2(2000) | YES | ||
LABEL_1 | VARCHAR2(2000) | YES | ||
LABEL_2 | VARCHAR2(2000) | YES | ||
LABEL_3 | VARCHAR2(2000) | YES | ||
LABEL_4 | VARCHAR2(2000) | YES | ||
LABEL_5 | VARCHAR2(2000) | YES | ||
TBL_LABEL_1 | VARCHAR2(2000) | YES | ||
TBL_LABEL_2 | VARCHAR2(2000) | YES | ||
TBL_LABEL_3 | VARCHAR2(2000) | YES | ||
TBL_LABEL_4 | VARCHAR2(2000) | YES | ||
TBL_LABEL_5 | VARCHAR2(2000) | YES | ||
STATUS_TXT_1 | VARCHAR2(2000) | YES | ||
STATUS_TXT_2 | VARCHAR2(2000) | YES | ||
STATUS_TXT_3 | VARCHAR2(2000) | YES | ||
STATUS_TXT_4 | VARCHAR2(2000) | YES | ||
STATUS_TXT_5 | VARCHAR2(2000) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
PRODUCT | VARCHAR2(5) | YES | ||
EDITABLE_CD | VARCHAR2(1) | YES | ||
REQUIRED_CD | VARCHAR2(1) | YES | ||
CNTL_TYPE | VARCHAR2(1) | YES | ||
OBJ_VALUES | VARCHAR2(2000) | YES | ||
DISP_VALUES | VARCHAR2(2000) | YES | ||
COLOR_FRMLA_TXT | VARCHAR2(2000) | YES |
S_OBJ_TEMPLATES Primary and Unique Keys |
Key Name | Key Type | Keys |
SI_0018 | Index | TMPL_ID |
S_OBJ_TEMPLATES Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |