Customer Sales Targets

Entity Relationship Diagram

Tip:	Right click the attachment to view Entity Relationship Diagram for Customer Sales Targets 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
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	GORG_SYS_KEY_C	GORG SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	PRD_DT_SYS_KEY_C	PRD DT SYS KEY C	2	VARCHAR	16777216		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SORG_SYS_KEY_C	SORG SYS KEY C	3	VARCHAR	16777216		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SF_SYS_KEY_C	SF SYS KEY C	4	VARCHAR	16777216		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	PSET_SYS_KEY_C	PSET SYS KEY C	5	VARCHAR	16777216		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	FACT_TYPE_CD_C	FACT TYPE CD C	6	VARCHAR	20		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	GOAL_TYPE_CD_C	GOAL TYPE CD C	7	VARCHAR	20		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	CNTRY_CD_C	CNTRY CD C	8	VARCHAR	20		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	CURR_ISO_CD_C	CURR ISO CD C	9	VARCHAR	20		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SRC_GORG_KEY_C	SRC GORG KEY C	10	VARCHAR	50		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SRC_PRD_KEY_C	SRC PRD KEY C	11	VARCHAR	20		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SRC_SORG_KEY_C	SRC SORG KEY C	12	VARCHAR	20		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SRC_SF_KEY_C	SRC SF KEY C	13	VARCHAR	20		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	SRC_PERIOD_KEY_C	SRC PERIOD KEY C	14	VARCHAR	20		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	GOAL_PD_C	GOAL PD C	15	VARCHAR	100		NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	GOAL_PD_STRT_DT_C	GOAL PD STRT DT C	16	DATE			NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	GOAL_PD_END_DT_C	GOAL PD END DT C	17	DATE			NO	YES	FALSE	FALSE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	METRIC_TYPE_CD_C	METRIC TYPE CD C	18	VARCHAR	20		NO	NO	TRUE	TRUE
SLS_TRGT_FACT_C	Sales Target Fact	Sales Target Fact	TRGT_AMT_VAL_C	TRGT AMT VAL C	19	NUMERIC	18	3	NO	YES	FALSE	FALSE