PC_SETTINGS |
Default Table Name | PC_SETTINGS |
Definition |
PC_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
S_MO_AUTO_NUM_TYPE | VARCHAR2(1) | NO | ||
S_PLANNER_ASSGN_CD | VARCHAR2(1) | NO | ||
S_BKFLSH_TIMING_CD | VARCHAR2(1) | NO | ||
S_DT_EFF_OPT_CD | VARCHAR2(1) | NO | ||
S_RELIEF_OPT_CD | VARCHAR2(1) | NO | ||
CLSD_TIMESHEET_FL | VARCHAR2(1) | NO | ||
CLSD_ISSUE_FL | VARCHAR2(1) | NO | ||
CLSD_SUBCT_FL | VARCHAR2(1) | NO | ||
CMPLT_TIMESHEET_FL | VARCHAR2(1) | NO | ||
CMPLT_ISSUE_FL | VARCHAR2(1) | NO | ||
CMPLT_SUBCT_FL | VARCHAR2(1) | NO | ||
OPER_NO_REQD_FL | VARCHAR2(1) | NO | ||
WORKCENTER_REQD_FL | VARCHAR2(1) | NO | ||
MULT_ALLOC_FL | VARCHAR2(1) | NO | ||
ALLOW_UNREL_FL | VARCHAR2(1) | NO | ||
ALLOW_UNREL_RT_FL | VARCHAR2(1) | NO | ||
ALLOW_ROUT_CHG_FL | VARCHAR2(1) | NO | ||
ALLOW_BOM_CHG_FL | VARCHAR2(1) | NO | ||
ALLOW_ALLOC_CHG_FL | VARCHAR2(1) | NO | ||
STATUS_UPD_FL | VARCHAR2(1) | NO | ||
ASSIGN_RES_FL | VARCHAR2(1) | NO | ||
INCL_SCRAP_YLD_FL | VARCHAR2(1) | NO | ||
PLAN_SCRAP_YLD_FL | VARCHAR2(1) | NO | ||
INCL_MRB_FL | VARCHAR2(1) | NO | ||
DISPL_EMPL_NAME_FL | VARCHAR2(1) | NO | ||
PRINT_PL_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_SHEET_FL | VARCHAR2(1) | NO | ||
PRINT_TRVLR_FL | VARCHAR2(1) | NO | ||
PRINT_AB_CONFIG_FL | VARCHAR2(1) | NO | ||
PRINT_COMP_LBL_FL | VARCHAR2(1) | NO | ||
PRINT_PL_NOTES_FL | VARCHAR2(1) | NO | ||
PRINT_PL_TEXT_FL | VARCHAR2(1) | NO | ||
PRINT_PL_TOOL_FL | VARCHAR2(1) | NO | ||
PRINT_PL_REF_FL | VARCHAR2(1) | NO | ||
PRINT_PL_BKFLS_FL | VARCHAR2(1) | NO | ||
PRINT_PL_FS_FL | VARCHAR2(1) | NO | ||
PRINT_PL_MAKE_FL | VARCHAR2(1) | NO | ||
S_PL_SORT_CD | VARCHAR2(1) | NO | ||
PRINT_ASY_NOTES_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_H_TXT_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_L_TXT_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_TOOL_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_REF_FL | VARCHAR2(1) | NO | ||
S_ASY_SORT_CD | VARCHAR2(1) | NO | ||
PRINT_TR_NOTES_FL | VARCHAR2(1) | NO | ||
PRINT_TR_H_TXT_FL | VARCHAR2(1) | NO | ||
PRINT_TR_L_TXT_FL | VARCHAR2(1) | NO | ||
PRINT_TR_TOOL_FL | VARCHAR2(1) | NO | ||
PRINT_TR_REF_FL | VARCHAR2(1) | NO | ||
PRINT_TR_LC_FL | VARCHAR2(1) | NO | ||
PRINT_TR_EQUIP_FL | VARCHAR2(1) | NO | ||
PRINT_TR_ALT_FL | VARCHAR2(1) | NO | ||
AUTO_ASSGN_COMP_FL | VARCHAR2(1) | NO | ||
S_AB_CONFG_SORT_CD | VARCHAR2(1) | NO | ||
DF_SUN_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_MON_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_TUE_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_WED_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_THU_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_FRI_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
DF_SAT_SHIFTS_QTY | NUMBER(5, 2) | NO | ||
S_DFLT_MO_STAT_CD | VARCHAR2(1) | NO | ||
DFLT_CS_IN_ABBR_CD | VARCHAR2(20) | YES | ||
S_DFLT_ALLOC_CD | VARCHAR2(1) | NO | ||
S_LT_CAL_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
LOAD_CAP_PLN_LN_FL | VARCHAR2(1) | YES | ||
S_QC_INSP_OPT_CD | VARCHAR2(1) | NO | ||
S_OPN_RQMTS_CD | VARCHAR2(1) | NO | ||
APPLY_STD_RT_FL | VARCHAR2(1) | NO | ||
PRT_TR_RT_NOTES_FL | VARCHAR2(1) | NO | ||
DFLT_ISS_LOC_FL | VARCHAR2(1) | NO | ||
ALLOW_NEG_CST_AMT | NUMBER(17, 2) | NO | ||
SUPP_FIND_NO_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_RQLN_NOTE_FL | VARCHAR2(1) | NO | ||
S_NEG_AMT_CD | VARCHAR2(1) | NO | ||
ALLOW_DI_QTYRLF_FL | VARCHAR2(1) | NO | ||
S_BKFLSH_RQMTS_CD | VARCHAR2(1) | NO | ||
DFLT_PLANNER_ID![]() |
VARCHAR2(12) | YES | ||
EXCL_RQMT_VAL_FL | VARCHAR2(1) | NO | ||
SUPP_MO_COMP_FL | VARCHAR2(1) | YES | ||
ETC_PCT_RT | NUMBER(5, 4) | NO | ||
PRINT_DPAS_FL | VARCHAR2(1) | YES |
PC_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6506 | PrimaryKey | COMPANY_ID |
PC_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 | FK_PC_SETTINGS_DF_IDX | DFLT_PLANNER_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |