Table 43. Columns Denormalized During Upgrades from Release 6.2.1 Siebel eBusiness Applications
|
|
|
|
|
S_ACCNT_POSTN
|
ORG_REF_CUST_FLG
|
[OU_EXT_ID].[REFERENCE_CUST_FLG] |
S_ORG_EXT
|
REFERENCE_CUST_FLG
|
S_ACT_CAL_RSRC
|
ACT_APPT_REPT_FLG
|
[ACTIVITY_ID].[APPT_REPT_FLG] |
S_EVT_ACT
|
APPT_REPT_FLG
|
S_ACT_CAL_RSRC
|
ACT_APPT_RPTEND_DT
|
[ACTIVITY_ID].[APPT_REPT_END_DT] |
S_EVT_ACT
|
APPT_REPT_END_DT
|
S_ACT_CAL_RSRC
|
ACT_CAL_TYPE_CD
|
[ACTIVITY_ID].[CAL_TYPE_CD] |
S_EVT_ACT
|
CAL_TYPE_CD
|
S_ACT_CAL_RSRC
|
ACT_TEMPLATE_FLG
|
[ACTIVITY_ID].[TEMPLATE_FLG] |
S_EVT_ACT
|
TEMPLATE_FLG
|
S_ACT_CAL_RSRC
|
ACT_TODO_PLNEND_DT
|
[ACTIVITY_ID].[TODO_PLAN_END_DT] |
S_EVT_ACT
|
TODO_PLAN_END_DT
|
S_ACT_CAL_RSRC
|
ACT_TODO_PLNSTRTDT
|
[ACTIVITY_ID].[TODO_PLAN_START_DT] |
S_EVT_ACT
|
TODO_PLAN_START_DT
|
S_ACT_EMP
|
ACT_ALARM_FLG
|
[ACTIVITY_ID].[ALARM_FLAG] |
S_EVT_ACT
|
ALARM_FLAG
|
S_ACT_EMP
|
ACT_APPT_REPT_FLG
|
[ACTIVITY_ID].[APPT_REPT_FLG] |
S_EVT_ACT
|
APPT_REPT_FLG
|
S_ACT_EMP
|
ACT_APPT_RPTEND_DT
|
[ACTIVITY_ID].[APPT_REPT_END_DT] |
S_EVT_ACT
|
APPT_REPT_END_DT
|
S_ACT_EMP
|
ACT_APPT_START_DT
|
[ACTIVITY_ID].[APPT_START_DT] |
S_EVT_ACT
|
APPT_START_DT
|
S_ACT_EMP
|
ACT_CAL_DISP_FLG
|
[ACTIVITY_ID].[CAL_DISP_FLG] |
S_EVT_ACT
|
CAL_DISP_FLG
|
S_ACT_EMP
|
ACT_EVT_STAT_CD
|
[ACTIVITY_ID].[EVT_STAT_CD] |
S_EVT_ACT
|
EVT_STAT_CD
|
S_ACT_EMP
|
ACT_TEMPLATE_FLG
|
[ACTIVITY_ID].[TEMPLATE_FLG] |
S_EVT_ACT
|
TEMPLATE_FLG
|
S_ACT_EMP
|
ACT_TODO_PLNEND_DT
|
[ACTIVITY_ID].[TODO_PLAN_END_DT] |
S_EVT_ACT
|
TODO_PLAN_END_DT
|
S_ACT_EMP
|
ACT_TODO_PLNSTRTDT
|
[ACTIVITY_ID].[TODO_PLAN_START_DT] |
S_EVT_ACT
|
TODO_PLAN_START_DT
|
S_ACT_EMP
|
ACT_CAL_TYPE_CD
|
[ACTIVITY_ID].[CAL_TYPE_CD] |
S_EVT_ACT
|
CAL_TYPE_CD
|
S_AGREE_POSTN
|
AGREE_NAME
|
[AGREE_ID].[NAME] |
S_DOC_AGREE
|
NAME
|
S_AGREE_POSTN
|
AGREE_STAT_CD
|
[AGREE_ID].[STAT_CD] |
S_DOC_AGREE
|
STAT_CD
|
S_AGREE_POSTN
|
AGREE_VALID_FLG
|
[AGREE_ID].[VALID_FLG] |
S_DOC_AGREE
|
VALID_FLG
|
S_CONTACT_BU
|
CON_FST_NAME
|
[CONTACT_ID].[FST_NAME] |
S_CONTACT
|
FST_NAME
|
S_CONTACT_BU
|
CON_LAST_NAME
|
[CONTACT_ID].[LAST_NAME] |
S_CONTACT
|
LAST_NAME
|
S_CONTACT_BU
|
CON_MID_NAME
|
[CONTACT_ID].[MID_NAME] |
S_CONTACT
|
MID_NAME
|
S_CONTACT_BU
|
CON_EMP_FLG
|
[CONTACT_ID].[EMP_FLG] |
S_CONTACT
|
EMP_FLG
|
S_CTLG_CAT_AUC
|
AUC_AUC_LOT_NUM
|
[AUC_ITEM_ID].[AUC_LOT_NUM] |
S_AUC_ITEM
|
AUC_LOT_NUM
|
S_CTLG_CAT_CRSE
|
CRSE_NAME
|
[CRSE_ID].[NAME] |
S_CRSE
|
NAME
|
S_CTLG_CAT_CRSE
|
CRSE_SUB_TYPE
|
[CRSE_ID].[SUB_TYPE] |
S_CRSE
|
SUB_TYPE
|
S_CTLG_CAT_DFCT
|
DFCT_DFCT_NUM
|
[PROD_DEFECT_ID].[DEFECT_NUM] |
S_PROD_DEFECT
|
DEFECT_NUM
|
S_CTLG_CAT_ISS
|
ISS_NAME
|
[ISS_ID].[NAME] |
S_ISS
|
NAME
|
S_CTLG_CAT_LIT
|
LIT_NAME
|
[LIT_ID].[NAME] |
S_LIT
|
NAME
|
S_CTLG_CAT_ORG
|
ORG_CMPT_FLG
|
[ORG_ID].[CMPT_FLG] |
S_ORG_EXT
|
CMPT_FLG
|
S_CTLG_CAT_ORG
|
ORG_LOC
|
[ORG_ID].[LOC] |
S_ORG_EXT
|
LOC
|
S_CTLG_CAT_ORG
|
ORG_NAME
|
[ORG_ID].[NAME] |
S_ORG_EXT
|
NAME
|
S_CTLG_CAT_ORG
|
ORG_PRTNR_FLG
|
[ORG_ID].[PRTNR_FLG] |
S_ORG_EXT
|
PRTNR_FLG
|
S_CTLG_CAT_PROD
|
PROD_EFF_END_DT
|
[PROD_ID].[EFF_END_DT] |
S_PROD_INT
|
EFF_END_DT
|
S_CTLG_CAT_PROD
|
PROD_EFF_START_DT
|
[PROD_ID].[EFF_START_DT] |
S_PROD_INT
|
EFF_START_DT
|
S_CTLG_CAT_PROD
|
PROD_NAME
|
[PROD_ID].[NAME] |
S_PROD_INT
|
NAME
|
S_CTLG_CAT_SR
|
SR_SR_NUM
|
[SRV_REQ_ID].[SR_NUM] |
S_SRV_REQ
|
SR_NUM
|
S_CTLG_CAT_SRC
|
SRC_NAME
|
[SRC_ID].[NAME] |
S_SRC
|
NAME
|
S_CTLG_CAT_SRC
|
SRC_SRC_NUM
|
[SRC_ID].[SRC_NUM] |
S_SRC
|
SRC_NUM
|
S_CTLG_CAT_SRC
|
SRC_SUB_TYPE
|
[SRC_ID].[SUB_TYPE] |
S_SRC
|
SUB_TYPE
|
S_CTLGCAT_ASSET
|
ASSET_ASSET_NUM
|
[ASSET_ID].[ASSET_NUM] |
S_ASSET
|
ASSET_NUM
|
S_CTLGCAT_ASSET
|
ASSET_SERIAL_NUM
|
[ASSET_ID].[SERIAL_NUM] |
S_ASSET
|
SERIAL_NUM
|
S_CTLGCAT_PATH
|
CS_PATH_NAME
|
[CS_PATH_ID].[NAME] |
S_CS_PATH
|
NAME
|
S_CTLGCT_RESITM
|
RI_INTR_PUBL_FLG
|
[RES_ITEM_ID].[INTR_PUBLISH_FLG] |
S_RESITEM
|
INTR_PUBLISH_FLG
|
S_CTLGCT_RESITM
|
RI_NAME
|
[RES_ITEM_ID].[NAME] |
S_RESITEM
|
NAME
|
S_CTLGCT_RESITM
|
RI_TYPE_CD
|
[RES_ITEM_ID].[TYPE_CD] |
S_RESITEM
|
TYPE_CD
|
S_DOC_AGREE_BU
|
AGREE_NAME
|
[AGREEMENT_ID].[NAME] |
S_DOC_AGREE
|
NAME
|
S_DOC_AGREE_BU
|
AGREE_STAT_CD
|
[AGREEMENT_ID].[STAT_CD] |
S_DOC_AGREE
|
STAT_CD
|
S_DOC_AGREE_BU
|
AGREE_VALID_FLG
|
[AGREEMENT_ID].[VALID_FLG] |
S_DOC_AGREE
|
VALID_FLG
|
S_DOC_PPSL_BU
|
PPSL_DFLT_TMPL_FLG
|
[DOC_PPSL_ID].[DFLT_TEMPLATE_FLG] |
S_DOC_PPSL
|
DFLT_TEMPLATE_FLG
|
S_DOC_PPSL_BU
|
PPSL_NAME
|
[DOC_PPSL_ID].[NAME] |
S_DOC_PPSL
|
NAME
|
S_DOC_PPSL_BU
|
PPSL_TEMPLATE_FLG
|
[DOC_PPSL_ID].[TEMPLATE_FLG] |
S_DOC_PPSL
|
TEMPLATE_FLG
|
S_DOC_PPSL_BU
|
PPSL_TYPE_CD
|
[DOC_PPSL_ID].[PPSL_TYPE_CD] |
S_DOC_PPSL
|
PPSL_TYPE_CD
|
S_DOC_QUOTE_BU
|
DOC_QTE_NUM
|
[DOC_QUOTE_ID].[QUOTE_NUM] |
S_DOC_QUOTE
|
QUOTE_NUM
|
S_DOC_QUOTE_BU
|
DOC_QTE_REV_NUM
|
[DOC_QUOTE_ID].[REV_NUM] |
S_DOC_QUOTE
|
REV_NUM
|
S_DOC_QUOTE_BU
|
DOC_QUOTE_NAME
|
[DOC_QUOTE_ID].[NAME] |
S_DOC_QUOTE
|
NAME
|
S_INV_TXN_BU
|
INV_TXN_NUM
|
[INV_TXN_ID].[INV_TXN_NUM] |
S_INV_TXN
|
INV_TXN_NUM
|
S_ISS_BU
|
ISS_LANG_ID
|
[ISS_ID].[LANG_ID] |
S_ISS
|
LANG_ID
|
S_ISS_BU
|
ISS_NAME
|
[ISS_ID].[NAME] |
S_ISS
|
NAME
|
S_MDF_BU
|
MDF_UID
|
[MDF_ID].[MDF_UID] |
S_MDF
|
MDF_UID
|
S_OPTY_BU
|
OPTY_NAME
|
[OPTY_ID].[NAME] |
S_OPTY
|
NAME
|
S_OPTY_BU
|
SUM_CLASS_CD
|
[OPTY_ID].[SUM_CLASS_CD] |
S_OPTY
|
SUM_CLASS_CD
|
S_OPTY_BU
|
SUM_COMMIT_FLG
|
[OPTY_ID].[SUM_COMMIT_FLG] |
S_OPTY
|
SUM_COMMIT_FLG
|
S_OPTY_BU
|
SUM_COST_AMT
|
[OPTY_ID].[SUM_COST_AMT] |
S_OPTY
|
SUM_COST_AMT
|
S_OPTY_BU
|
SUM_DOWNSIDE_AMT
|
[OPTY_ID].[SUM_DOWNSIDE_AMT] |
S_OPTY
|
SUM_DOWNSIDE_AMT
|
S_OPTY_BU
|
SUM_EFFECTIVE_DT
|
[OPTY_ID].[SUM_EFFECTIVE_DT] |
S_OPTY
|
SUM_EFFECTIVE_DT
|
S_OPTY_BU
|
SUM_MARGIN_AMT
|
[OPTY_ID].[SUM_MARGIN_AMT] |
S_OPTY
|
SUM_MARGIN_AMT
|
S_OPTY_BU
|
SUM_REVN_AMT
|
[OPTY_ID].[SUM_REVN_AMT] |
S_OPTY
|
SUM_REVN_AMT
|
S_OPTY_BU
|
SUM_TYPE_CD
|
[OPTY_ID].[SUM_TYPE_CD] |
S_OPTY
|
SUM_TYPE_CD
|
S_OPTY_BU
|
SUM_UPSIDE_AMT
|
[OPTY_ID].[SUM_UPSIDE_AMT] |
S_OPTY
|
SUM_UPSIDE_AMT
|
S_OPTY_BU
|
SUM_WIN_PROB
|
[OPTY_ID].[SUM_WIN_PROB] |
S_OPTY
|
SUM_WIN_PROB
|
S_OPTY_POSTN
|
OPTY_NAME
|
[OPTY_ID].[NAME] |
S_OPTY
|
NAME
|
S_OPTY_POSTN
|
SUM_CLASS_CD
|
[OPTY_ID].[SUM_CLASS_CD] |
S_OPTY
|
SUM_CLASS_CD
|
S_OPTY_POSTN
|
SUM_COMMIT_FLG
|
[OPTY_ID].[SUM_COMMIT_FLG] |
S_OPTY
|
SUM_COMMIT_FLG
|
S_OPTY_POSTN
|
SUM_COST_AMT
|
[OPTY_ID].[SUM_COST_AMT] |
S_OPTY
|
SUM_COST_AMT
|
S_OPTY_POSTN
|
SUM_DOWNSIDE_AMT
|
[OPTY_ID].[SUM_DOWNSIDE_AMT] |
S_OPTY
|
SUM_DOWNSIDE_AMT
|
S_OPTY_POSTN
|
SUM_EFFECTIVE_DT
|
[OPTY_ID].[SUM_EFFECTIVE_DT] |
S_OPTY
|
SUM_EFFECTIVE_DT
|
S_OPTY_POSTN
|
SUM_MARGIN_AMT
|
[OPTY_ID].[SUM_MARGIN_AMT] |
S_OPTY
|
SUM_MARGIN_AMT
|
S_OPTY_POSTN
|
SUM_REVN_AMT
|
[OPTY_ID].[SUM_REVN_AMT] |
S_OPTY
|
SUM_REVN_AMT
|
S_OPTY_POSTN
|
SUM_TYPE_CD
|
[OPTY_ID].[SUM_TYPE_CD] |
S_OPTY
|
SUM_TYPE_CD
|
S_OPTY_POSTN
|
SUM_UPSIDE_AMT
|
[OPTY_ID].[SUM_UPSIDE_AMT] |
S_OPTY
|
SUM_UPSIDE_AMT
|
S_OPTY_POSTN
|
SUM_WIN_PROB
|
[OPTY_ID].[SUM_WIN_PROB] |
S_OPTY
|
SUM_WIN_PROB
|
S_ORDER_BU
|
ORDER_CAT_CD
|
[ORDER_ID].[ORDER_CAT_CD] |
S_ORDER
|
ORDER_CAT_CD
|
S_ORDER_BU
|
ORDER_DT
|
[ORDER_ID].[ORDER_DT] |
S_ORDER
|
ORDER_DT
|
S_ORDER_BU
|
ORDER_NUM
|
[ORDER_ID].[ORDER_NUM] |
S_ORDER
|
ORDER_NUM
|
S_ORDER_POSTN
|
ORDER_CAT_CD
|
[ORDER_ID].[ORDER_CAT_CD] |
S_ORDER
|
ORDER_CAT_CD
|
S_ORDER_POSTN
|
ORDER_DT
|
[ORDER_ID].[ORDER_DT] |
S_ORDER
|
ORDER_DT
|
S_ORDER_POSTN
|
ORDER_NUM
|
[ORDER_ID].[ORDER_NUM] |
S_ORDER
|
ORDER_NUM
|
S_ORG_BU
|
ORG_CMPT_FLG
|
[ORG_ID].[CMPT_FLG] |
S_ORG_EXT
|
CMPT_FLG
|
S_ORG_BU
|
ORG_LOC
|
[ORG_ID].[LOC] |
S_ORG_EXT
|
LOC
|
S_ORG_BU
|
ORG_NAME
|
[ORG_ID].[NAME] |
S_ORG_EXT
|
NAME
|
S_ORG_BU
|
ORG_PRTNR_FLG
|
[ORG_ID].[PRTNR_FLG] |
S_ORG_EXT
|
PRTNR_FLG
|
S_ORG_BU
|
ORG_REF_CUST_FLG
|
[ORG_ID].[REFERENCE_CUST_FLG] |
S_ORG_EXT
|
REFERENCE_CUST_FLG
|
S_ORG_GROUP_BU
|
OG_GROUP_NAME
|
[ORG_GROUP_ID].[GROUP_NAME] |
S_ORG_GROUP
|
GROUP_NAME
|
S_ORG_GROUP_BU
|
OG_NAME
|
[ORG_GROUP_ID].[NAME] |
S_ORG_GROUP
|
NAME
|
S_ORGGRP_POSTN
|
GRP_NAME
|
[ORGGRP_ID].[NAME] |
S_ORG_GROUP
|
NAME
|
S_ORGGRP_POSTN
|
GRP_GROUP_NAME
|
[ORGGRP_ID].[GROUP_NAME] |
S_ORG_GROUP
|
GROUP_NAME
|
S_PARTY_GRP_BU
|
PG_NAME
|
[PARTY_GROUP_ID].[NAME] |
S_PARTY_GROUP
|
NAME
|
S_PERIOD_BU
|
PERIOD_NAME
|
[PERIOD_ID].[NAME] |
S_PERIOD
|
NAME
|
S_PRIFCTR_ITM
|
PRIMDL_ID
|
[PRIMDL_FCTR_ID].[PRIMDL_ID] |
S_PRIMDL_FCTR
|
PRIMDL_ID
|
S_PROD_DFCT_BU
|
DEFECT_NUM
|
[PROD_DEFECT_ID].[DEFECT_NUM] |
S_PROD_DEFECT
|
DEFECT_NUM
|
S_PROD_INT_BU
|
PROD_EFF_END_DT
|
[PROD_INT_ID].[EFF_END_DT] |
S_PROD_INT
|
EFF_END_DT
|
S_PROD_INT_BU
|
PROD_EFF_START_DT
|
[PROD_INT_ID].[EFF_START_DT] |
S_PROD_INT
|
EFF_START_DT
|
S_PROJ_BU
|
PROJ_NAME
|
[PROJ_ID].[NAME] |
S_PROJ
|
NAME
|
S_PROJ_BU
|
PROJ_TYPE_CD
|
[PROJ_ID].[PROJ_TYPE_CD] |
S_PROJ
|
PROJ_TYPE_CD
|
S_PROJ_BU
|
PROJ_STATUS_CD
|
[PROJ_ID].[STATUS_CD] |
S_PROJ
|
STATUS_CD
|
S_PSP_PROC_BU
|
VOD_NAME
|
[VOD_ID].[VOD_NAME] |
S_VOD
|
VOD_NAME
|
S_QUOTE_POSTN
|
QUOTE_NUM
|
[QUOTE_ID].[QUOTE_NUM] |
S_DOC_QUOTE
|
QUOTE_NUM
|
S_SALES_MTHD_BU
|
SALES_METHOD_NAME
|
[SALES_METHOD_ID].[NAME] |
S_SALES_METHOD
|
NAME
|
S_SRC_BU
|
SRC_NAME
|
[SRC_ID].[NAME] |
S_SRC
|
NAME
|
S_SRV_REQ_BU
|
SR_TITLE
|
[SRV_REQ_ID].[SR_TITLE] |
S_SRV_REQ
|
SR_TITLE
|
S_SRV_REQ_BU
|
SR_SUB_STAT_ID
|
[SRV_REQ_ID].[SR_SUB_STAT_ID] |
S_SRV_REQ
|
SR_SUB_STAT_ID
|
S_SRV_REQ_BU
|
SR_STAT_ID
|
[SRV_REQ_ID].[SR_STAT_ID] |
S_SRV_REQ
|
SR_STAT_ID
|
S_SRV_REQ_BU
|
SR_SEV_CD
|
[SRV_REQ_ID].[SR_SEV_CD] |
S_SRV_REQ
|
SR_SEV_CD
|
S_SRV_REQ_BU
|
SR_NUM
|
[SRV_REQ_ID].[SR_NUM] |
S_SRV_REQ
|
SR_NUM
|
S_SRV_REQ_BU
|
SR_CST_NUM
|
[SRV_REQ_ID].[SR_CST_NUM] |
S_SRV_REQ
|
SR_CST_NUM
|
S_SRV_REQ_BU
|
SR_AREA
|
[SRV_REQ_ID].[SR_AREA] |
S_SRV_REQ
|
SR_AREA
|
S_SRV_REQ_BU
|
SR_TYPE_CD
|
[SRV_REQ_ID].[SR_TYPE_CD] |
S_SRV_REQ
|
SR_TYPE_CD
|
S_TMPL_PLNIT_BU
|
PLANITEM_NAME
|
[TMPL_PLANITEM_ID].[NAME] |
S_TMPL_PLANITEM
|
NAME
|
S_TMPL_PLNIT_BU
|
PLANITEM_TYPE_CD
|
[TMPL_PLANITEM_ID].[TYPE_CD] |
S_TMPL_PLANITEM
|
TYPE_CD
|
S_TMPL_PLNIT_BU
|
PLNIT_TMPL_TYPE_CD
|
[TMPL_PLANITEM_ID].[TMPL_TYPE_CD] |
S_TMPL_PLANITEM
|
TMPL_TYPE_CD
|
S_USERLIST_BU
|
UL_NAME
|
[USERLIST_ID].[NAME] |
S_USERLIST
|
NAME
|
S_WRNTY_CVRG_BU
|
WRNTY_CVRG_NAME
|
[WRNTY_CVRG_ID].[WRNTY_NAME] |
S_WRNTY_CVRG
|
WRNTY_NAME
|
T_MASTER_BU
|
MASTER_ALIAS
|
[MASTER_ID].[ALIAS] |
T_MASTER
|
ALIAS
|
T_MASTER_BU
|
MASTER_NAME
|
[MASTER_ID].[NAME] |
T_MASTER
|
NAME
|
T_MASTER_DETAIL
|
DETAIL_SX2_NAME
|
[DETAIL_SX2_ID].[SX2_NAME] |
T_DETAIL_SX2
|
SX2_NAME
|
T_MASTER_DETAIL
|
MASTER_NAME
|
[MASTER_ID].[NAME] |
T_MASTER
|
NAME
|
T_MASTER_PER
|
MASTER_ALIAS
|
[MASTER_ID].[ALIAS] |
T_MASTER
|
ALIAS
|
T_MASTER_POSTN
|
MASTER_NAME
|
[MASTER_ID].[NAME] |
T_MASTER
|
NAME
|