CAP_PLAN_SETTINGS |
Default Table Name | CAP_PLAN_SETTINGS |
Definition |
CAP_PLAN_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
MO_LAST_EXPORT_DTT | DATE | YES | ||
WC_LAST_EXPORT_DTT | DATE | YES | ||
S_REL_DT_CD | VARCHAR2(1) | NO | ||
S_SCHED_MTHD | VARCHAR2(1) | NO | ||
CALC_MATL_AVAIL_FL | VARCHAR2(1) | NO | ||
INCL_REV_FL | VARCHAR2(1) | NO | ||
DFLT_PRIORITY_NO | NUMBER(5, 0) | YES | ||
PLANNER_FLD_NO | NUMBER(5, 0) | YES | ||
INV_ABBRV_FLD_NO | NUMBER(5, 0) | YES | ||
NET_GRP_FLD_NO | NUMBER(5, 0) | YES | ||
ORD_REF_FLD_NO | NUMBER(5, 0) | YES | ||
SERIAL_FLD_NO | NUMBER(5, 0) | YES | ||
S_MO_NOTES_CD | VARCHAR2(1) | NO | ||
S_WC_DEPT_CD | VARCHAR2(1) | NO | ||
DFLT_WC_DEPT_CD | VARCHAR2(20) | NO | ||
DFLT_DIRECTORY_DC | VARCHAR2(254) | NO | ||
S_ASSY_JOB_LINK_CD | VARCHAR2(1) | NO | ||
NEED_DT_NO | NUMBER(5, 0) | YES | ||
S_OP_STATUS_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TIME_STAMP | DATE | NO | ||
S_WC_POOL_SRCE_CD | VARCHAR2(1) | NO |
CAP_PLAN_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6961 | PrimaryKey | COMPANY_ID |
CAP_PLAN_SETTINGS 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 |