Xponent Sales

Entity Relationship Diagram

Tip:	Right click the attachment to view Entity Relationship Diagram for Xponent Sales in a new tab.

List of Objects

DB Object Name	Object Business Name	Object Description	DB Attribute Name	Attribute Business Name	Ordinal Position	Data Type Name	Data Type Size	Numeric Scale	Is Identity	Is Nullable	Primary Key	Mandatory
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	RXER_SYS_KEY_C	RXER SYS KEY C	1	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	PRD_DT_SYS_KEY_C	PRD DT SYS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	PSET_MKT_SYS_KEY_C	PSET MKT SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	PSET_GRP_SYS_KEY_C	PSET GRP SYS KEY C	4	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	PSET_SYS_KEY_C	PSET SYS KEY C	5	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	PLN_SYS_KEY_C	PLN SYS KEY C	6	VARCHAR	16777216		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	XPT_CHNL_CD_C	XPT CHNL CD C	7	VARCHAR	20		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	XPT_AGE_GRP_CD_C	XPT AGE GRP CD C	8	VARCHAR	20		NO	NO	FALSE	TRUE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_RXER_KEY_C	SRC RXER KEY C	9	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_PRD_KEY_C	SRC PRD KEY C	10	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_PGN_KEY_C	SRC PGN KEY C	11	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_PERIOD_KEY_C	SRC PERIOD KEY C	12	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_MKT_KEY_C	SRC MKT KEY C	13	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_PLN_KEY_C	SRC PLN KEY C	14	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_CHNL_CD_C	SRC CHNL CD C	15	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	SRC_AGE_GRP_CD_C	SRC AGE GRP CD C	16	VARCHAR	20		NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	NRX_CNT_VAL_C	NRX CNT VAL C	17	NUMERIC	18	3	NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	NRX_CONV_CNT_VAL_C	NRX CONV CNT VAL C	18	NUMERIC	18	3	NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	NRX_QTY_VAL_C	NRX QTY VAL C	19	NUMERIC	18	3	NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	TRX_CNT_VAL_C	TRX CNT VAL C	20	NUMERIC	18	3	NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	TRX_CONV_CNT_VAL_C	TRX CONV CNT VAL C	21	NUMERIC	18	3	NO	YES	FALSE	FALSE
XPO_WKLY_SLS_FACT_C	XPO Weekly Sales Fact	XPO Weekly Sales Fact	TRX_QTY_VAL_C	TRX QTY VAL C	22	NUMERIC	18	3	NO	YES	FALSE	FALSE