OPP_ASSESS_FORMAT |
Default Table Name | OPP_ASSESS_FORMAT |
Definition |
OPP_ASSESS_FORMAT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OA_FORMAT_ID![]() |
VARCHAR2(10) | NO | ||
OA_FORMAT_NAME | VARCHAR2(60) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
OA_FORMAT_DFLT_FL | VARCHAR2(1) | NO | ||
SHOW_LOOKUP_FL | VARCHAR2(1) | NO | ||
S_SOURCE_CD | VARCHAR2(1) | NO | ||
OA_CODE_01![]() |
VARCHAR2(15) | NO | ||
OA_CODE_02![]() |
VARCHAR2(15) | YES | ||
OA_CODE_03![]() |
VARCHAR2(15) | YES | ||
OA_CODE_04![]() |
VARCHAR2(15) | YES | ||
OA_CODE_05![]() |
VARCHAR2(15) | YES | ||
OA_CODE_06![]() |
VARCHAR2(15) | YES | ||
OA_CODE_07![]() |
VARCHAR2(15) | YES | ||
OA_CODE_08![]() |
VARCHAR2(15) | YES | ||
OA_CODE_09![]() |
VARCHAR2(15) | YES | ||
OA_CODE_10![]() |
VARCHAR2(15) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
OPP_ASSESS_FORMAT Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_OPP_ASSESS_FORMAT_IDX | PrimaryKey | OA_FORMAT_ID, COMPANY_ID |
OPP_ASSESS_FORMAT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O10_IDX | OA_CODE_10 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | One To Zero or More | FK_OPP_ASSESS_FORMAT_O1_IDX | OA_CODE_01 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O2_IDX | OA_CODE_02 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O3_IDX | OA_CODE_03 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O4_IDX | OA_CODE_04 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O5_IDX | OA_CODE_05 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O6_IDX | OA_CODE_06 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O7_IDX | OA_CODE_07 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O8_IDX | OA_CODE_08 | NO | NO | NO | ||
OPP_RATE_DESC | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESS_FORMAT_O9_IDX | OA_CODE_09 | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
OPP_ASSESSMENT | Non-Identifying | One To Zero or More | FK_OPP_ASSESSMENT_OACO_IDX | NO | NO | NO |