INVT_ABBRV_CD |
Default Table Name | INVT_ABBRV_CD |
Definition |
INVT_ABBRV_CD Columns |
ColumnName | Domain | Datatype | NULL | Definition |
INVT_ABBRV_CD![]() |
VARCHAR2(20) | NO | ||
PROJ_ID![]() |
VARCHAR2(30) | NO | ||
INVT_ABBRV_NAME | VARCHAR2(25) | NO | ||
S_INVT_ACCT_TYPE![]() |
VARCHAR2(1) | NO | ||
S_INVT_TYPE | VARCHAR2(1) | NO | ||
MATL_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
MATL_ORG_ID![]() |
VARCHAR2(20) | YES | ||
LAB_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
LAB_ORG_ID![]() |
VARCHAR2(20) | YES | ||
SUBCTR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
SUBCTR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
MISC_1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
MISC_1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
MISC_2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
MISC_2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_MATL_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_MATL_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_LAB_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_LAB_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_SUBCTR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_SUBCTR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_MISC_1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_MISC_1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_MISC_2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_MISC_2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
RM_INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
S_ACTIVE_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
SA_INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
UPD_OBD_FL | VARCHAR2(1) | NO | ||
BRDN_ISSUE_FL | VARCHAR2(1) | NO | ||
USE_EXP_WIP_FL | VARCHAR2(1) | NO | ||
POST_PRJWIP_VAR_FL | VARCHAR2(1) | NO |
INVT_ABBRV_CD Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0237 | PrimaryKey | INVT_ABBRV_CD |
INVT_ABBRV_CD Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
INVT_PROJ | Non-Identifying | One To Zero or More | F01090 | PROJ_ID | NO | NO | NO | ||
S_INVT_ACCT_TYPE | Non-Identifying | One To Zero or More | F01095 | S_INVT_ACCT_TYPE | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06245 | MATL_ACCT_ID, MATL_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06260 | LAB_ACCT_ID, LAB_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06280 | SUBCTR_ACCT_ID, SUBCTR_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06300 | MISC_1_ACCT_ID, MISC_1_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06310 | MISC_2_ACCT_ID, MISC_2_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06320 | WIP_MATL_ACCT_ID, WIP_MATL_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06340 | WIP_LAB_ACCT_ID, WIP_LAB_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06360 | WIP_SUBCTR_ACCT_ID, WIP_SUBCTR_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06380 | WIP_MISC_1_ACCT_ID, WIP_MISC_1_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F06390 | WIP_MISC_2_ACCT_ID, WIP_MISC_2_ORG_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
INVT | Identifying | One To Zero or More | F01080 | NO | NO | NO | |||
INVT_TRN_LN | Non-Identifying | One To Zero or More | F01390 | NO | NO | NO | |||
RES_HDR | Non-Identifying | One To Zero or More | F04430 | NO | NO | NO | |||
VEND_RTRN_LN | Non-Identifying | One To Zero or More | F09403 | NO | NO | NO | |||
PROD_PRICE_CATLG | Non-Identifying | One To Zero or More | F09798 | NO | NO | NO | |||
OE_CATLG_SETTINGS | Non-Identifying | One To Zero or More | F10041 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F10066 | NO | NO | NO | |||
SO_LN | Non-Identifying | One To Zero or More | F10080 | NO | NO | NO | |||
SO_ISSUE_LN | Non-Identifying | One To Zero or More | F10187 | NO | NO | NO | |||
PROJ_CLIN | Non-Identifying | One To Zero or More | F20277 | NO | NO | NO | |||
PROJ_CLIN_PROD | Non-Identifying | One To Zero or More | F20279 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20770 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20772 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20773 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20774 | NO | NO | NO | |||
MO_ALLOCATIONS | Non-Identifying | One To Zero or More | F20777 | NO | NO | NO | |||
MO_RQMT | Non-Identifying | One To Zero or More | F20784 | NO | NO | NO | |||
PART | Non-Identifying | One To Zero or More | F21150 | NO | NO | NO | |||
SO_LN_COMP | Non-Identifying | One To Zero or More | F21402 | NO | NO | NO | |||
MPS_FORECAST_RQMT | Non-Identifying | One To Zero or More | F21640 | NO | NO | NO | |||
MPS_MESSAGE | Non-Identifying | One To Zero or More | F21649 | NO | NO | NO | |||
ROUGH_CAP_PLAN | Non-Identifying | One To Zero or More | F21684 | NO | NO | NO | |||
RQ_TYPE | Non-Identifying | One To Zero or More | F21696 | NO | NO | NO | |||
INVT_ABBRV_PEGGING | Identifying | One To Zero or More | FK_INVT_ABBRV_PEGGING_AS_IDX | NO | NO | NO | |||
INVT_ABBRV_PEGGING | Non-Identifying | One To Zero or More | FK_INVT_ABBRV_PEGGING_CO_IDX | NO | NO | NO |