MRP_SETTINGS |
Default Table Name | MRP_SETTINGS |
Definition |
MRP_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ALLOW_MO_MAINT_FL | VARCHAR2(1) | NO | ||
ALLOW_PO_MAINT_FL | VARCHAR2(1) | NO | ||
ALLOW_RES_MAINT_FL | VARCHAR2(1) | NO | ||
CALC_EST_CST_FL | VARCHAR2(1) | NO | ||
COMBINE_ORD_BUY_FL | VARCHAR2(1) | NO | ||
COMBINE_ORD_MK_FL | VARCHAR2(1) | NO | ||
DFLT_PLANNER_ID![]() |
VARCHAR2(12) | YES | ||
EARLY_FILTER_MO_NO | NUMBER(5, 0) | NO | ||
EARLY_FILTER_PO_NO | NUMBER(5, 0) | NO | ||
EXCL_CUST_REP_FL | VARCHAR2(1) | NO | ||
INCL_PEND_RQST_FL | VARCHAR2(1) | NO | ||
INCL_PEND_SO_FL | VARCHAR2(1) | NO | ||
INCL_SAFETY_STK_FL | VARCHAR2(1) | NO | ||
LATE_FILTER_MO_NO | NUMBER(5, 0) | NO | ||
LATE_FILTER_PO_NO | NUMBER(5, 0) | NO | ||
PARTL_REL_PLN_FL | VARCHAR2(1) | NO | ||
RQ_APPR_PROC_CD![]() |
VARCHAR2(8) | YES | ||
S_BUY_MIN_ALLOC_CD | VARCHAR2(1) | NO | ||
S_END_OF_WK_CD | VARCHAR2(1) | NO | ||
S_MK_MIN_ALLOC_CD | VARCHAR2(1) | NO | ||
S_MRP_OPTION_CD![]() |
VARCHAR2(1) | NO | ||
S_MRP_ORD_POL_CD | VARCHAR2(1) | NO | ||
S_TRNSF_TYPE | VARCHAR2(1) | NO | ||
SO_PACKING_LT_NO | NUMBER(5, 0) | NO | ||
SUM_MNTHS_NO | NUMBER(5, 0) | NO | ||
SUM_WKS_NO | NUMBER(5, 0) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
S_WHSE_ASSGN_CD | VARCHAR2(1) | NO | ||
S_PLANNER_ASSGN_CD | VARCHAR2(1) | NO | ||
MATCH_SUP_DEM_DT | VARCHAR2(1) | NO | ||
PLAN_SUBST_PARTS_FL | VARCHAR2(1) | NO | ||
S_SUBST_OPTION_CD | VARCHAR2(2) | NO | ||
INTERCH_SUBST_FL | VARCHAR2(1) | NO | ||
USE_PART_PLAN_FL | VARCHAR2(1) | NO | ||
S_PLAN_ORDER_CD | VARCHAR2(2) | NO | ||
S_PROJ_PRIOR_CD | VARCHAR2(1) | NO | ||
INCL_MO_FL | VARCHAR2(1) | NO | ||
INCL_SO_FL | VARCHAR2(1) | NO | ||
INCL_IN_FL | VARCHAR2(1) | NO | ||
INCL_RR_FL | VARCHAR2(1) | NO | ||
CREATE_TRANSF_FL | VARCHAR2(1) | NO |
MRP_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6669 | PrimaryKey | COMPANY_ID |
MRP_SETTINGS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
PLANNER | Non-Identifying | Zero or One to Zero or More | F21094 | DFLT_PLANNER_ID | NO | NO | NO | ||
RQ_APPRVL_PROC | Non-Identifying | Zero or One to Zero or More | F21095 | RQ_APPR_PROC_CD, COMPANY_ID | NO | NO | NO | ||
S_MRP_OPTION_CD | Non-Identifying | One To Zero or More | F21096 | S_MRP_OPTION_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |