Table 27. Columns Denormalized During Upgrades from Release 6.3 Siebel Industry Solutions
|
|
|
|
|
S_ACCNT_POSTN
|
ACCNT_TYPE_CD
|
[OU_EXT_ID].[ACCNT_TYPE_CD] |
S_ORG_EXT
|
ACCNT_TYPE_CD
|
S_ACCNT_POSTN
|
CLIENT_FLG
|
[OU_EXT_ID].[CLIENT_FLG] |
S_ORG_EXT
|
CLIENT_FLG
|
S_ACCNT_POSTN
|
FACILITY_FLG
|
[OU_EXT_ID].[FACILITY_FLG] |
S_ORG_EXT
|
FACILITY_FLG
|
S_ACCNT_POSTN
|
INVSTR_FLG
|
[OU_EXT_ID].[INVSTR_FLG] |
S_ORG_EXT
|
INVSTR_FLG
|
S_ACCNT_POSTN
|
ORG_REF_CUST_ FLG
|
[OU_EXT_ID].[REFERENCE_CUST_FLG] |
S_ORG_EXT
|
REFERENCE_CUST_FLG
|
S_ACCNT_POSTN
|
SRV_PROVDR_FLG
|
[OU_EXT_ID].[SRV_PROVDR_FLG] |
S_ORG_EXT
|
SRV_PROVDR_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_CAL_TYPE_CD
|
[ACTIVITY_ID].[CAL_TYPE_CD] |
S_EVT_ACT
|
CAL_TYPE_CD
|
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_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_ASSET_BU
|
ASSET_NUM
|
[ASSET_ID].[ASSET_NUM] |
S_ASSET
|
ASSET_NUM
|
S_ASSET_BU
|
TYPE_CD
|
[ASSET_ID].[TYPE_CD] |
S_ASSET
|
TYPE_CD
|
S_ASSET_POSTN
|
ASSET_NUM
|
[ASSET_ID].[ASSET_NUM] |
S_ASSET
|
ASSET_NUM
|
S_ASSET_POSTN
|
TYPE_CD
|
[ASSET_ID].[TYPE_CD] |
S_ASSET
|
TYPE_CD
|
S_CASE_BU
|
CASE_NAME
|
[CASE_ID].[NAME] |
S_CASE
|
NAME
|
S_CASE_BU
|
CASE_STATUS_CD
|
[CASE_ID].[STATUS_CD] |
S_CASE
|
STATUS_CD
|
S_CASE_BU
|
CASE_TYPE_CD
|
[CASE_ID].[TYPE_CD] |
S_CASE
|
TYPE_CD
|
S_CONTACT_BU
|
AGENT_FLG
|
[CONTACT_ID].[AGENT_FLG] |
S_CONTACT
|
AGENT_FLG
|
S_CONTACT_BU
|
CON_EMP_FLG
|
[CONTACT_ID].[EMP_FLG] |
S_CONTACT
|
EMP_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
|
MEMBER_FLG
|
[CONTACT_ID].[MEMBER_FLG] |
S_CONTACT
|
MEMBER_FLG
|
S_CONTACT_BU
|
PROVIDER_FLG
|
[CONTACT_ID].[PROVIDER_FLG] |
S_CONTACT
|
PROVIDER_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_RES_ITEM
|
INTR_PUBLISH_ FLG
|
S_CTLGCT_ RESITM
|
RI_NAME
|
[RES_ITEM_ID]. [NAME] |
S_RES_ITEM
|
NAME
|
S_CTLGCT_ RESITM
|
RI_TYPE_CD
|
[RES_ITEM_ID]. [TYPE_CD] |
S_RES_ITEM
|
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_INSCLM_BU
|
INSCLAIM_NUM
|
[INSCLM_ID]. [INSCLAIM_NUM] |
S_INS_CLAIM
|
INSCLAIM_NUM
|
S_INSCLM_BU
|
REV_NUM
|
[INSCLM_ID]. [REVISION_NUM] |
S_INS_CLAIM
|
REVISION_NUM
|
S_INSCLMEL_BU
|
SEQ_NUM
|
[INSCLM_ELMNT_ ID].[SEQ_NUM] |
S_INSCLM_ ELMNT
|
SEQ_NUM
|
S_INSCLMEL_BU
|
TYPE_CD
|
[INSCLM_ELMNT_ ID].[TYPE_CD] |
S_INSCLM_ ELMNT
|
TYPE_CD
|
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_LOY_MEM_BU
|
MEM_NUM
|
[MEMBER_ID]. [MEM_NUM] |
S_LOY_MEMBER
|
MEM_NUM
|
S_LOY_MEM_BU
|
MEM_TYPE_CD
|
[MEMBER_ID]. [MEM_TYPE_CD] |
S_LOY_MEMBER
|
MEM_TYPE_CD
|
S_LOY_MEM_PSTN
|
MEM_NUM
|
[MEMBER_ID]. [MEM_NUM] |
S_LOY_MEMBER
|
MEM_NUM
|
S_LOY_MEM_PSTN
|
MEM_TYPE_CD
|
[MEMBER_ID]. [MEM_TYPE_CD] |
S_LOY_MEMBER
|
MEM_TYPE_CD
|
S_LOY_PROG_BU
|
PROG_NAME
|
[PROG_ID].[NAME] |
S_LOY_PROG
|
NAME
|
S_LOY_PROMO_BU
|
PROMO_NAME
|
[PROMO_ID]. [NAME] |
S_LOY_PROMO
|
NAME
|
S_LOY_PROMO_BU
|
PROMO_NUM
|
[PROMO_ID]. [PROMO_NUM] |
S_LOY_PROMO
|
PROMO_NUM
|
S_LOY_TXN_BU
|
TXN_NUM
|
[TXN_ID].[TXN_ NUM] |
S_LOY_TXN
|
TXN_NUM
|
S_LOY_TXN_BU
|
TXN_STATUS_CD
|
[TXN_ID].[STATUS_CD] |
S_LOY_TXN
|
STATUS_CD
|
S_LOY_TXN_BU
|
TXN_SUB_TYPE_CD
|
[TXN_ID].[SUB_ TYPE_CD] |
S_LOY_TXN
|
SUB_TYPE_CD
|
S_LOY_TXN_BU
|
TXN_TYPE_CD
|
[TXN_ID].[TYPE_ CD] |
S_LOY_TXN
|
TYPE_CD
|
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
|
CONSUMER_OPTY_ FLG
|
[OPTY_ID].[CONSUMER_OPTY_FLG] |
S_OPTY
|
CONSUMER_OPTY_ FLG
|
S_OPTY_POSTN
|
NEW_LOAN_FLG
|
[OPTY_ID].[NEW_ LOAN_FLG] |
S_OPTY
|
NEW_LOAN_FLG
|
S_OPTY_POSTN
|
OPTY_CLOSED_FLG
|
[OPTY_ID].[CLOSED_FLG] |
S_OPTY
|
CLOSED_FLG
|
S_OPTY_POSTN
|
OPTY_NAME
|
[OPTY_ID].[NAME] |
S_OPTY
|
NAME
|
S_OPTY_POSTN
|
SECURE_FLG
|
[OPTY_ID].[SECURE_FLG] |
S_OPTY
|
SECURE_FLG
|
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_FACILITY_ FLG
|
[ORG_ID].[FACILITY_FLG] |
S_ORG_EXT
|
FACILITY_FLG
|
S_ORG_BU
|
ORG_INVSTR_FLG
|
[ORG_ID].[INVSTR_FLG] |
S_ORG_EXT
|
INVSTR_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_BU
|
ORG_SRV_PROVDR_FLG
|
[ORG_ID].[SRV_ PROVDR_FLG] |
S_ORG_EXT
|
SRV_PROVDR_FLG
|
S_ORG_DIST_LST
|
OU_ID
|
[ORG_PROD_ID]. [OU_ID] |
S_ORG_PROD
|
OU_ID
|
S_ORG_GROUP_BU
|
OG_GROUP_NAME
|
[ORG_GROUP_ID]. [GROUP_NAME] |
S_ORG_GROUP
|
GROUP_NAME
|
S_ORG_GROUP_BU
|
OG_GROUP_TYPE_ CD
|
[ORG_GROUP_ID]. [GROUP_TYPE_CD] |
S_ORG_GROUP
|
GROUP_TYPE_CD
|
S_ORG_GROUP_BU
|
OG_NAME
|
[ORG_GROUP_ID]. [NAME] |
S_ORG_GROUP
|
NAME
|
S_ORGGRP_POSTN
|
GROUP_TYPE_CD
|
[ORGGRP_ID].[GROUP_TYPE_CD] |
S_ORG_GROUP
|
GROUP_TYPE_CD
|
S_ORGGRP_POSTN
|
GRP_GROUP_NAME
|
[ORGGRP_ID]. [GROUP_NAME] |
S_ORG_GROUP
|
GROUP_NAME
|
S_ORGGRP_POSTN
|
GRP_NAME
|
[ORGGRP_ID]. [NAME] |
S_ORG_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_POS_BU
|
POS_NUM
|
[POS_ID].[POS_ NUM] |
S_POS
|
POS_NUM
|
S_POSTN_CON
|
AGENT_FLG
|
[CON_ID].[AGENT_ FLG] |
S_CONTACT
|
AGENT_FLG
|
S_POSTN_CON
|
MEMBER_FLG
|
[CON_ID].[MEMBER_FLG] |
S_CONTACT
|
MEMBER_FLG
|
S_POSTN_CON
|
PROVIDER_FLG
|
[CON_ID]. [PROVIDER_FLG] |
S_CONTACT
|
PROVIDER_FLG
|
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_CD
|
[PROD_INT_ID]. [PROD_CD] |
S_PROD_INT
|
PROD_CD
|
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_PROD_STYL_ TNT
|
SETUP_STYLE_CD
|
[PROP_STYLE_ID]. [SETUP_STYLE_CD] |
S_PROP_STYL_ TNT
|
SETUP_STYLE_CD
|
S_PROJ_BU
|
PROJ_NAME
|
[PROJ_ID].[NAME] |
S_PROJ
|
NAME
|
S_PROJ_BU
|
PROJ_STATUS_CD
|
[PROJ_ID].[STATUS_CD] |
S_PROJ
|
STATUS_CD
|
S_PROJ_BU
|
PROJ_TYPE_CD
|
[PROJ_ID].[PROJ_ TYPE_CD] |
S_PROJ
|
PROJ_TYPE_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_AREA
|
[SRV_REQ_ID].[SR_AREA] |
S_SRV_REQ
|
SR_AREA
|
S_SRV_REQ_BU
|
SR_CST_NUM
|
[SRV_REQ_ID].[SR_CST_NUM] |
S_SRV_REQ
|
SR_CST_NUM
|
S_SRV_REQ_BU
|
SR_NUM
|
[SRV_REQ_ID].[SR_NUM] |
S_SRV_REQ
|
SR_NUM
|
S_SRV_REQ_BU
|
SR_SEV_CD
|
[SRV_REQ_ID].[SR_SEV_CD] |
S_SRV_REQ
|
SR_SEV_CD
|
S_SRV_REQ_BU
|
SR_STAT_ID
|
[SRV_REQ_ID].[SR_STAT_ID] |
S_SRV_REQ
|
SR_STAT_ID
|
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_TITLE
|
[SRV_REQ_ID].[SR_TITLE] |
S_SRV_REQ
|
SR_TITLE
|
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
|