WHSE |
Default Table Name | WHSE |
Definition |
WHSE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
WHSE_ID![]() |
VARCHAR2(8) | NO | ||
WHSE_DESC | VARCHAR2(40) | NO | ||
LOC_LVLS_NO | NUMBER(5, 0) | NO | ||
PO_RECPT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
QC_REJ_LOC_ID![]() |
VARCHAR2(15) | YES | ||
QC_ACCPT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
WOR_RECPT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
MRB_INVT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
SALES_TAX_CD![]() |
VARCHAR2(6) | YES | ||
LN_1_ADR | VARCHAR2(40) | NO | ||
LN_2_ADR | VARCHAR2(40) | NO | ||
LN_3_ADR | VARCHAR2(40) | NO | ||
CITY_NAME | VARCHAR2(25) | NO | ||
MAIL_STATE_DC![]() |
VARCHAR2(15) | YES | ||
POSTAL_CD | VARCHAR2(10) | NO | ||
COUNTRY_CD![]() |
VARCHAR2(8) | YES | ||
SHIP_ID | VARCHAR2(20) | YES | ||
SHIP_INVT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
PLANT_ID | VARCHAR2(30) | YES | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
CYCLE_COUNT_FL | VARCHAR2(1) | NO |
WHSE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0166 | PrimaryKey | WHSE_ID |
WHSE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05410 | WHSE_ID, PO_RECPT_LOC_ID | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05420 | WHSE_ID, QC_REJ_LOC_ID | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05430 | WHSE_ID, QC_ACCPT_LOC_ID | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05440 | WHSE_ID, WOR_RECPT_LOC_ID | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05450 | WHSE_ID, MRB_INVT_LOC_ID | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F05460 | WHSE_ID, SHIP_INVT_LOC_ID | NO | NO | NO | ||
MAIL_STATE | Non-Identifying | Zero or One to Zero or More | F05470 | MAIL_STATE_DC, COUNTRY_CD | NO | NO | NO | ||
SALES_TAX | Non-Identifying | Zero or One to Zero or More | F05480 | SALES_TAX_CD, COMPANY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
INVT_PROJ | Non-Identifying | One To Zero or More | F01130 | NO | NO | NO | |||
PHYS_COUNT | Identifying | One To Zero or More | F02680 | NO | NO | NO | |||
RES_HDR | Non-Identifying | One To Zero or More | F04480 | NO | NO | NO | |||
RES_HDR | Identifying | One To Zero or More | F04490 | NO | NO | NO | |||
WHSE_LAST_TRANS | Identifying | One To Zero or More | F05500 | NO | NO | NO | |||
WHSE_LOC | Identifying | One To Zero or More | F05520 | NO | NO | NO | |||
WHSE_LOC_STRUC | Identifying | One To Zero or More | F05540 | NO | NO | NO | |||
INVT_TRN | Identifying | One To Zero or More | F08257 | NO | NO | NO | |||
VEND_RTRN_HDR | Non-Identifying | One To Zero or More | F09396 | NO | NO | NO | |||
PHYS_COUNT_DETL | Identifying | One To Zero or More | F09410 | NO | NO | NO | |||
SO_LN | Non-Identifying | One To Zero or More | F10081 | NO | NO | NO | |||
SO_ISSUE_HDR | Non-Identifying | One To Zero or More | F10095 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20769 | NO | NO | NO | |||
MO_RQMT | Non-Identifying | One To Zero or More | F20840 | NO | NO | NO | |||
MPS_FORECAST_RQMT | Non-Identifying | One To Zero or More | F21639 | NO | NO | NO | |||
MPS_MESSAGE | Non-Identifying | One To Zero or More | F21648 | NO | NO | NO | |||
ROUGH_CAP_PLAN | Non-Identifying | One To Zero or More | F21685 | NO | NO | NO | |||
RQ_TYPE | Non-Identifying | One To Zero or More | F21701 | NO | NO | NO | |||
CC_SCH_HDR | Non-Identifying | One To Zero or More | FK_CC_SCH_HDR_WH_IDX | NO | NO | NO | |||
CC_SCH_LN | Non-Identifying | One To Zero or More | FK_CC_SCH_LN_WH_IDX | NO | NO | NO |