The changes in database table index columns are listed in this section.
TABLE_NAME |
INDEX_NAME |
POS |
COLUMN_NAME |
Change |
---|---|---|---|---|
M_APPL_LANGUAGES |
AL_UK2 |
1 |
NLS_ID |
NEW |
M_BOS_TO_POS |
BTP_POH_BO_FK_I |
1 |
BO_POH_ID |
NEW |
M_BOS_TO_POS |
BTP_POH_PO_FK_I |
1 |
POH_ID |
NEW |
M_BUSINESS_FUNCTIONS |
BF_UK |
1 |
BF_CODE |
NEW |
M_CLASS_SYSTEMS |
CLS_UK1 |
1 |
GROUP_ID |
NEW |
M_CLASS_SYSTEMS |
CLS_UK1 |
2 |
PART_ID |
NEW |
M_CMS_COMMTEMPLT_DTLS |
CCDL_PK |
1 |
COMMODITY_ID |
NEW |
M_COMPANY_PRICE_TYPES |
CPRT_UK1 |
4 |
SHORT_DESC |
NEW |
M_COMPANY_PRICE_TYPES |
CPRT_UK1 |
3 |
COMPANY_ID |
NEW |
M_COMPANY_PRICE_TYPES |
CPRT_UK1 |
2 |
PRT_ID |
NEW |
M_COMPANY_PRICE_TYPES |
CPRT_UK1 |
1 |
PROJ_ID |
NEW |
M_COMPANY_PRICE_TYPES |
CPRT_UK1 |
5 |
PLC_ID |
NEW |
M_ECO_ACT_STAGING_RAW |
ECOACTRAW_PK |
1 |
ECOACTRAW_ID |
NEW |
M_ECO_ACT_STAGING_RAW |
ECOACTRAW_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_ACT_STAGINGS |
ECOAST_PK |
1 |
ECOAST_ID |
NEW |
M_ECO_ACT_STAGINGS |
ECOAST_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_IVC_STAGINGS |
ECOIVC_PK |
1 |
ECOIVC_ID |
NEW |
M_ECO_IVC_STAGINGS |
ECOIVC_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_PO_HEADER_STAGINGS |
ECOPOHDR_PK |
1 |
ECOPOHDR_ID |
NEW |
M_ECO_PO_HEADER_STAGINGS |
ECOPOHDR_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_PO_LI_STAGINGS |
ECOPOLI_PK |
1 |
ECOPOLI_ID |
NEW |
M_ECO_PO_LI_STAGINGS |
ECOPOLI_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
ECOREQHDR_PK |
1 |
ECOREQHDR_ID |
NEW |
M_ECO_REQ_HEADER_STAGINGS |
ECOREQHDR_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_ECO_REQ_LI_STAGINGS |
ECOREQLI_PK |
1 |
ECOREQLI_ID |
NEW |
M_ECO_REQ_LI_STAGINGS |
ECOREQLI_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
1 |
GN_ID |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
2 |
PROJ_ID |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
9 |
REV_END |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
8 |
INPUT_5 |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
7 |
INPUT_4 |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
6 |
INPUT_3 |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
5 |
INPUT_2 |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
4 |
INPUT_1 |
NEW |
M_GEOM_DETAILS |
GD_IND2 |
3 |
USY_ID |
NEW |
M_INSPECTION_LEVEL_DETAILS |
ILD_ILD_FK_I |
1 |
PREV_ILD_ID |
NEW |
M_INV_ITEMS_SUMS |
IVIS_UK |
1 |
IVI_ID |
NEW |
M_INV_TRANSFERS |
ITR_APOLI_FK_I |
1 |
APOLI_ID |
NEW |
M_MS_SUPPL_PLANS |
MSSP_UK |
1 |
PROJ_ID |
NEW |
M_MS_SUPPL_PLANS |
MSSP_UK |
2 |
ACTUAL_IND |
NEW |
M_MS_SUPPL_PLANS |
MSSP_UK |
3 |
R_SUPP |
NEW |
M_NOTE_COMPANIES |
NCP_C_FK_I |
1 |
COMPANY_ID |
NEW |
M_NOTE_COMPANIES |
NCP_CST_FK_I |
1 |
CONTROL_STATUS |
NEW |
M_NOTE_COMPANIES |
NCP_N_FK_I |
1 |
NOTE_ID |
NEW |
M_NOTE_COMPANIES |
NCP_PK |
1 |
PROJ_ID |
NEW |
M_NOTE_COMPANIES |
NCP_PK |
2 |
NOTE_ID |
NEW |
M_NOTE_COMPANIES |
NCP_PK |
3 |
COMPANY_ID |
NEW |
M_NOTE_COMPANIES |
NCP_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_NOTE_COMPANIES |
NCP_UK |
1 |
PROJ_ID |
NEW |
M_NOTE_COMPANIES |
NCP_UK |
2 |
COMPANY_ID |
NEW |
M_NOTE_COMPANIES |
NCP_UK |
3 |
COMPANY_NOTE_CODE |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_NCP_FK_I |
1 |
PROJ_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_NCP_FK_I |
2 |
NOTE_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_NCP_FK_I |
3 |
COMPANY_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_NLS_FK_I |
1 |
NLS_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_PK |
3 |
COMPANY_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_PK |
2 |
NOTE_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_PK |
1 |
PROJ_ID |
NEW |
M_NOTE_COMPANY_NLS |
NCPN_PK |
4 |
NLS_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_NI_FK_I |
3 |
INTERFACE_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_NI_FK_I |
1 |
PROJ_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_NI_FK_I |
2 |
NOTE_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_NLS_FK_I |
1 |
NLS_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_PK |
2 |
NOTE_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_PK |
3 |
INTERFACE_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_PK |
4 |
NLS_ID |
NEW |
M_NOTE_INTERFACE_NLS |
NIN_PK |
1 |
PROJ_ID |
NEW |
M_NOTE_INTERFACES |
NI_CST_FK_I |
1 |
CONTROL_STATUS |
NEW |
M_NOTE_INTERFACES |
NI_INTF_FK_I |
1 |
INTERFACE_ID |
NEW |
M_NOTE_INTERFACES |
NI_N_FK_I |
1 |
NOTE_ID |
NEW |
M_NOTE_INTERFACES |
NI_PK |
3 |
INTERFACE_ID |
NEW |
M_NOTE_INTERFACES |
NI_PK |
2 |
NOTE_ID |
NEW |
M_NOTE_INTERFACES |
NI_PK |
1 |
PROJ_ID |
NEW |
M_NOTE_INTERFACES |
NI_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_NOTE_INTERFACES |
NI_UK |
2 |
INTERFACE_ID |
NEW |
M_NOTE_INTERFACES |
NI_UK |
1 |
PROJ_ID |
NEW |
M_NOTE_INTERFACES |
NI_UK |
3 |
INTERFACE_NOTE_CODE |
NEW |
M_OPC_SPMAT_MENUS |
OSM_UK1 |
1 |
MENUITEM_ID |
NEW |
M_OPC_SPMAT_PRIVS |
OSP_UK1 |
1 |
PRIV_ID |
NEW |
M_PACKAGE_ITEM_INVOICES |
PII_PCKI_FK_I |
1 |
PCKI_ID |
NEW |
M_PACKAGE_ITEM_INVOICES |
PII_PK |
2 |
PLIN_ID |
NEW |
M_PACKAGE_ITEM_INVOICES |
PII_PK |
1 |
PCKI_ID |
NEW |
M_PACKAGE_ITEM_INVOICES |
PII_PLIN_FK_I |
1 |
PLIN_ID |
NEW |
M_PDS_PROJWIDE_LISTS |
PPWL_UK |
2 |
NAME |
NEW |
M_PDS_PROJWIDE_LISTS |
PPWL_UK |
1 |
PROJ_ID |
NEW |
M_PDS_PROJWIDE_LISTS |
PPWL_UK |
3 |
SEQ |
NEW |
M_PO_LINE_ITEMS |
POLI_UK |
2 |
POH_ID |
NEW |
M_PO_LINE_ITEMS |
POLI_UK |
1 |
PROJ_ID |
NEW |
M_PO_LINE_ITEMS |
POLI_UK |
4 |
POLI_SUB_POS |
NEW |
M_PO_LINE_ITEMS |
POLI_UK |
3 |
POLI_POS |
NEW |
M_QT_PROJ_ADM |
SYS_C0041119 |
1 |
MSGID |
NEW |
M_SAP_CLASS_PROFILES |
SCP_SCP2_UK |
3 |
TAB_GROUP_ID |
NEW |
M_SAP_CLASS_PROFILES |
SCP_SCP2_UK |
2 |
TAB_ID |
NEW |
M_SCHEDULED_MAILS |
SMAIL_PK |
1 |
SMAIL_ID |
NEW |
M_SPW_FILTER_LINES |
SPWFL_P_FK_I |
1 |
PART_ID |
NEW |
M_SPW_FILTER_LINES |
SPWFL_P_FK_I |
2 |
PART_GROUP_ID |
NEW |
M_SP3D_IMP_MAPPINGS |
SP3D_IMM_IDDC_UK_I |
1 |
SYS_NC00021$ |
NEW |
M_SP3D_IMP_MAPPINGS |
SP3D_IMM_IDD_UK_I |
1 |
SYS_NC00020$ |
NEW |
M_SP3D_IMP_MAPPINGS |
SP3D_IMM_TD_FK_I |
3 |
TAB_ID |
NEW |
M_TRIGGER_NOMINAL_VERSIONS |
TNV_UK |
1 |
TRIGGER_NAME |
NEW |
M_USED_FILES |
UF_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
M_USED_FILES |
UF_UK |
6 |
PROJ_ID |
NEW |
M_VENDOR_PROGRESS |
VP_PK |
1 |
VP_ID |
NEW |
M_VENDOR_PROGRESS |
VP_POH_FK_I |
1 |
POH_ID |
NEW |
M_VENDOR_PROGRESS |
VP_UK |
3 |
PK_ID |
NEW |
M_VENDOR_PROGRESS |
VP_UK |
2 |
PK_TYPE |
NEW |
M_VENDOR_PROGRESS |
VP_UK |
1 |
POH_ID |
NEW |
M_VENDOR_PROGRESS |
VP_USR_FK_I |
1 |
APPROVED_BY |
NEW |
MW_API_OPEN_INTERFACES |
AOI_PK |
1 |
AOI_ID |
NEW |
MW_API_OPEN_INTERFACES |
AOI_PROJ_FK_I |
1 |
PROJ_ID |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK1 |
2 |
FILENAME |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK1 |
1 |
PROJ_ID |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK1 |
4 |
VERSION |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK1 |
3 |
TYPE |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK2 |
2 |
REC_ID |
NEW |
MW_API_OPEN_INTERFACES |
AOI_UK2 |
1 |
PROJ_ID |
NEW |
MW_INSTALL_INFOS |
INSI_MW_PK |
1 |
INSI_ID |
NEW |
MW_INSTALL_INFOS |
INSI_MW_UK |
4 |
THIRD_NR |
NEW |
MW_INSTALL_INFOS |
INSI_MW_UK |
3 |
SECOND_NR |
NEW |
MW_INSTALL_INFOS |
INSI_MW_UK |
5 |
FOURTH_NR |
NEW |
MW_INSTALL_INFOS |
INSI_MW_UK |
2 |
MAJOR_NR |
NEW |
MW_INSTALL_INFOS |
INSI_MW_UK |
1 |
INSI_NAME |
NEW |