PLANNER |
Default Table Name | PLANNER |
Definition |
PLANNER Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PLANNER_ID![]() |
VARCHAR2(12) | NO | ||
EMPL_ID![]() |
VARCHAR2(12) | YES | ||
PLANNER_NAME | VARCHAR2(25) | NO | ||
ORG_ID![]() |
VARCHAR2(20) | YES | ||
USER_ID | VARCHAR2(20) | YES | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
PLANNER Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6504 | PrimaryKey | PLANNER_ID |
PLANNER Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
EMPL | Non-Identifying | Zero or One to Zero or More | F20756 | EMPL_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20757 | ORG_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
NET_GRP | Non-Identifying | One To Zero or More | F20758 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20765 | NO | NO | NO | |||
RES_HDR | Non-Identifying | One To Zero or More | F20828 | NO | NO | NO | |||
COMM | Non-Identifying | One To Zero or More | F20838 | NO | NO | NO | |||
PART | Non-Identifying | One To Zero or More | F20841 | NO | NO | NO | |||
PROD_CLASSIF | Non-Identifying | One To Zero or More | F20844 | NO | NO | NO | |||
RQ_LN | Non-Identifying | One To Zero or More | F20954 | NO | NO | NO | |||
PO_LN_CHNG | Non-Identifying | One To Zero or More | F20956 | NO | NO | NO | |||
PO_LN | Non-Identifying | One To Zero or More | F20957 | NO | NO | NO | |||
MRP_SETTINGS | Non-Identifying | One To Zero or More | F21094 | NO | NO | NO | |||
RES_LN | Non-Identifying | One To Zero or More | F21162 | NO | NO | NO | |||
SO_LN | Non-Identifying | One To Zero or More | F21216 | NO | NO | NO | |||
MPS_FORECAST_RQMT | Non-Identifying | One To Zero or More | F21641 | NO | NO | NO | |||
MPS_MESSAGE | Non-Identifying | One To Zero or More | F21646 | NO | NO | NO | |||
PC_SETTINGS | Non-Identifying | One To Zero or More | FK_PC_SETTINGS_DF_IDX | NO | NO | NO |