EC_SETTINGS |
Default Table Name | EC_SETTINGS |
Definition |
EC_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
LAST_ECN_ID | VARCHAR2(15) | YES | ||
PHONE_TYPE_DC | VARCHAR2(6) | YES | ||
S_CLASS_I_CD | VARCHAR2(1) | NO | ||
S_CLASS_15_CD | VARCHAR2(1) | NO | ||
S_CLASS_II_CD | VARCHAR2(1) | NO | ||
S_APPR_PROC_ASG_CD | VARCHAR2(1) | NO | ||
EC_APP_PROC_CD | VARCHAR2(8) | YES | ||
S_CUST_APPR_CD | VARCHAR2(1) | NO | ||
PENDING_ECN_FL | VARCHAR2(1) | NO | ||
S_EC_WF_CD | VARCHAR2(1) | NO | ||
WORKFLOW_KEY![]() |
NUMBER(10, 0) | YES | ||
PRINT_ECN_TX_FL | VARCHAR2(1) | NO | ||
PRINT_STD_TXT_FL | VARCHAR2(1) | NO | ||
PRINT_TECH_TX_FL | VARCHAR2(1) | NO | ||
PRINT_IMPL_TX_FL | VARCHAR2(1) | NO | ||
PRINT_ECN_PROJ_FL | VARCHAR2(1) | NO | ||
PRINT_ECN_ORG_FL | VARCHAR2(1) | NO | ||
PRINT_IMP_GRP_FL | VARCHAR2(1) | NO | ||
PRINT_PARTS_FL | VARCHAR2(1) | NO | ||
PRINT_DOCS_FL | VARCHAR2(1) | NO | ||
PRINT_MBOM_COMP_FL | VARCHAR2(1) | NO | ||
PRINT_MBOM_ASY_FL | VARCHAR2(1) | NO | ||
PRINT_EBOM_COMP_FL | VARCHAR2(1) | NO | ||
PRINT_EBOM_ASY_FL | VARCHAR2(1) | NO | ||
PRINT_ROUTINGS_FL | VARCHAR2(1) | NO | ||
PRINT_CUST_FL | VARCHAR2(1) | NO | ||
PRINT_UDEF_FL | VARCHAR2(1) | NO | ||
PRINT_ECN_CST_FL | VARCHAR2(1) | NO | ||
PRINT_CHG_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
EC_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6641 | PrimaryKey | COMPANY_ID |
EC_SETTINGS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
WF_WORKFLOW | Non-Identifying | Zero or One to Zero or More | F21034 | WORKFLOW_KEY, COMPANY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |