Bookshelf v7.7: Denormalized Columns for 6.3 Siebel Industry Solutions

Table 44 lists columns that are denormalized during upgrades from Release 6.3 Siebel Industry Solutions to Release 7.7 Siebel Industry applications.

Table 44. Columns Denormalized During Upgrades from Release 6.3 Siebel Industry Solutions
Target Table	Target Column	Denorm Path	Source Table	Source Column
`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`