Product

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
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_SYS_KEY_C	PSET CLASS SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_BUS_KEY_C	PSET CLASS BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_TYPE_CD_C	PSET CLASS TYPE CD C	3	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_NM_C	PSET CLASS NM C	4	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_DESC_C	PSET CLASS DESC C	5	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	PSET_CLASS_LEVEL_NBR	PSET CLASS LEVEL NBR	6	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	CTRY_CD_C	CTRY CD C	7	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_CRT_DTT_C	SYS CRT DTT C	8	DATE			NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_CRT_BY_C	SYS CRT BY C	9	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_EFF_DTT_C	SYS EFF DTT C	10	DATE			NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_UPDT_DTT_C	SYS UPDT DTT C	11	DATE			NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_UPDT_BY_C	SYS UPDT BY C	12	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_CLASS_REF_C	Product Classification Reference	Product Classification Reference	SYS_END_DTT_C	SYS END DTT C	13	DATE			NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	PSET_EXT_ATTR_SYS_KEY_C	PSET EXT ATTR SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	PSET_EXT_ATTR_BUS_KEY_C	PSET EXT ATTR BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	PSET_SYS_KEY_C	PSET SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	EXT_ATTR_TYPE_TXT_C	EXT ATTR TYPE TXT C	4	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	EXT_ATTR_TYPE_VAL_C	EXT ATTR TYPE VAL C	5	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	ACTV_IND_C	ACTV IND C	6	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_CRT_DTT_C	SYS CRT DTT C	7	DATE			NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_CRT_BY_C	SYS CRT BY C	8	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_EFF_DTT_C	SYS EFF DTT C	9	DATE			NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_UPDT_DTT_C	SYS UPDT DTT C	10	DATE			NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_UPDT_BY_C	SYS UPDT BY C	11	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_EXT_ATTR_C	Product External Attribute	Product External Attribute	SYS_END_DTT_C	SYS END DTT C	12	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	PSET_HIER_SYS_KEY_C	PSET HIER SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	PSET_HIER_BUS_KEY_C	PSET HIER BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	PRNT_PSET_SYS_KEY_C	PRNT PSET SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	PRNT_PSET_TYPE_CD_C	PRNT PSET TYPE CD C	4	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	CHLD_PSET_SYS_KEY_C	CHLD PSET SYS KEY C	5	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	CHLD_PSET_TYPE_CD_C	CHLD PSET TYPE CD C	6	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	HIER_TYPE_CD_C	HIER TYPE CD C	7	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	HIER_ID_C	HIER ID C	8	VARCHAR	16777216		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	HIER_NM_C	HIER NM C	9	VARCHAR	500		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	KEY_COMP_IND_C	KEY COMP IND C	10	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	CTRY_CD_C	CTRY CD C	11	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_CRT_DTT_C	SYS CRT DTT C	12	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_CRT_BY_C	SYS CRT BY C	13	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_EFF_DTT_C	SYS EFF DTT C	14	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_UPDT_DTT_C	SYS UPDT DTT C	15	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_UPDT_BY_C	SYS UPDT BY C	16	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	SYS_END_DTT_C	SYS END DTT C	17	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	HIER_STRT_DTT_C	HIER STRT DTT C	18	DATE			NO	YES	FALSE	FALSE
PSET_HIER_C	ProductHierarchy	ProductHierarchy	HIER_END_DTT_C	HIER END DTT C	19	DATE			NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	PSET_MFR_CORP_SYS_KEY	PSET MFR CORP SYS KEY	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	PSET_MFR_CORP_BUS_KEY_C	PSET MFR CORP BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	MFR_CD_C	MFR CD C	3	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	MFR_SHRT_NM_C	MFR SHRT NM C	4	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	MFR_NM_C	MFR NM C	5	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	CORP_CD_C	CORP CD C	6	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	CORP_SHRT_NM_C	CORP SHRT NM C	7	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	CORP_NM_C	CORP NM C	8	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	ACTV_IND_C	ACTV IND C	9	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	INTL_MFR_NM_C	INTL MFR NM C	10	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	CORP_NATLTY_NM_C	CORP NATLTY NM C	11	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	MFR_OWNSHP_NM_C	MFR OWNSHP NM C	12	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	MFR_PLUS_NM_C	MFR PLUS NM C	13	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_CRT_DTT_C	SYS CRT DTT C	14	DATE			NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_CRT_BY_C	SYS CRT BY C	15	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_EFF_DTT_C	SYS EFF DTT C	16	DATE			NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_UPDT_DTT_C	SYS UPDT DTT C	17	DATE			NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_UPDT_BY_C	SYS UPDT BY C	18	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_MFR_DTL_C	Product Manufacturer Detail	Product Manufacturer Detail	SYS_END_DTT_C	SYS END DTT C	19	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	PSET_MSG_SYS_KEY_C	PSET MSG SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_MSG_C	Product Message	Product Message	PSET_MSG_BUS_KEY_C	PSET MSG BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_MSG_C	Product Message	Product Message	SRC_ENT_ID_C	SRC ENT ID C	3	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	PSET_SYS_KEY_C	PSET SYS KEY C	4	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_MSG_C	Product Message	Product Message	PSET_MSG_PRTY_C	PSET MSG PRTY C	5	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SRC_EFF_DTT_C	SRC EFF DTT C	6	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SRC_END_DTT_C	SRC END DTT C	7	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SRC_UPDT_DTT_C	SRC UPDT DTT C	8	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_CRT_BY_C	SYS CRT BY C	9	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_CRT_DTT_C	SYS CRT DTT C	10	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_EFF_DTT_C	SYS EFF DTT C	11	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_UPDT_DTT_C	SYS UPDT DTT C	12	DATE			NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_UPDT_BY_C	SYS UPDT BY C	13	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_MSG_C	Product Message	Product Message	SYS_END_DTT_C	SYS END DTT C	14	DATE			NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	PSET_PRC_SYS_KEY_C	PSET PRC SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	PSET_PRC_BUS_KEY_C	PSET PRC BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	PSET_SYS_KEY_C	PSET SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	PRC_TYPE_TXT_C	PRC TYPE TXT C	4	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	CURR_NM_C	CURR NM C	5	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	PSET_PRC_AMT_VAL_C	PSET PRC AMT VAL C	6	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	ACTV_IND_C	ACTV IND C	7	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_CRT_DTT_C	SYS CRT DTT C	8	DATE			NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_CRT_BY_C	SYS CRT BY C	9	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_EFF_DTT_C	SYS EFF DTT C	10	DATE			NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_UPDT_DTT_C	SYS UPDT DTT C	11	DATE			NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_UPDT_BY_C	SYS UPDT BY C	12	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_PRC_DTL_C	Product Price Detail	Product Price Detail	SYS_END_DTT_C	SYS END DTT C	13	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_SYS_KEY_C	PSET SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_REF_C	Product Reference	Product Reference	PSET_BUS_KEY_C	PSET BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_REF_C	Product Reference	Product Reference	SRC_SYS_CD_C	SRC SYS CD C	3	VARCHAR	20		NO	NO	FALSE	TRUE
PSET_REF_C	Product Reference	Product Reference	PSET_SRC_ENT_ID_C	PSET SRC ENT ID C	4	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_SRC_ENT_CD_C	PSET SRC ENT CD C	5	VARCHAR	16777216		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_TYPE_CD_C	PSET TYPE CD C	6	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_LVL_NBR_C	PSET LVL NBR C	7	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_NM_C	PSET NM C	8	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	CTRY_CD_C	CTRY CD C	9	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_BRND_NM_C	PSET BRND NM C	10	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_FORM_NM_C	PSET FORM NM C	11	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_STRN_NM_C	PSET STRN NM C	12	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_SKU_NM_C	PSET SKU NM C	13	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_MLCL_NM_C	PSET MLCL NM C	14	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_SMPL_IND_C	PSET SMPL IND C	15	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_LNCH_DT_C	PSET LNCH DT C	16	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_STRN_UNITS_C	PSET STRN UNITS C	17	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_STRN_MEAS_C	PSET STRN MEAS C	18	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	ROUTE_ADM_CD_C	ROUTE ADM CD C	19	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	ACTV_IND_C	ACTV IND C	20	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	BIOL_MLCL_NM_C	BIOL MLCL NM C	21	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	LCL_RX_STAT_CD_C	LCL RX STAT CD C	22	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_BRAND_NM_C	INTL BRAND NM C	23	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_PACK_NM_C	INTL PACK NM C	24	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_PROD_NM_C	INTL PROD NM C	25	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_PSET_LNCH_DT_C	INTL PSET LNCH DT C	26	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_REIMBMNT_STAT_CD_C	INTL REIMBMNT STAT CD C	27	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_SIZE_C	INTL SIZE C	28	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_STRNT_C	INTL STRNT C	29	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	INTL_VOL_C	INTL VOL C	30	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	LCL_REIMBMNT_STAT_CD_C	LCL REIMBMNT STAT CD C	31	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	MLCL_LIST_C	MLCL LIST C	32	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PAR_IMP_STAT_CD_C	PAR IMP STAT CD C	33	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PATN_EXPRY_DT	PATN EXPRY DT	34	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	ETHCL_PROPTRY_CD_C	ETHCL PROPTRY CD C	35	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	DLVR_SYS_CD_C	DLVR SYS CD C	36	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	ORIGNTR_NON_ORIGNTR_CD_C	ORIGNTR NON ORIGNTR CD C	37	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	GENERIC_ORIGNTR_CD_C	GENERIC ORIGNTR CD C	38	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	GENERIC_TRADE_NM_C	GENERIC TRADE NM C	39	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	GENERIC_PATN_CD_C	GENERIC PATN CD C	40	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	GENERIC_SRC_CD_C	GENERIC SRC CD C	41	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	NDC_CD_C	NDC CD C	42	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	NDC_CMF_BRDG_CD_C	NDC CMF BRDG CD C	43	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	NDC_PRNT_CD_C	NDC PRNT CD C	44	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	CMF_PRNT_CD_C	CMF PRNT CD C	45	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	GENERIC_PSET_IND_C	GENERIC PSET IND C	46	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_STAT_CD_C	PSET STAT CD C	47	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PSET_CLASS_SYS_KEY_C	PSET CLASS SYS KEY C	48	VARCHAR	16777216		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	CLIENT_PSET_IND	CLIENT PSET IND	49	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	KEYCOMP_PROD_IND_C	KEYCOMP PROD IND C	50	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	CNTRL_SBS_IND_C	CNTRL SBS IND C	51	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	COPROMOTE_PROD_IND_C	COPROMOTE PROD IND C	52	VARCHAR	1		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	FRM3_CD	FRM3 CD	53	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	TLC3_CD	TLC3 CD	54	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE1_NUM_C	PDE1 NUM C	55	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE2_NUM_C	PDE2 NUM C	56	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE3_NUM_C	PDE3 NUM C	57	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE4_NUM_C	PDE4 NUM C	58	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE5_NUM_C	PDE5 NUM C	59	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_CRT_DTT_C	SYS CRT DTT C	60	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_CRT_BY_C	SYS CRT BY C	61	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_EFF_DTT_C	SYS EFF DTT C	62	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_UPDT_DTT_C	SYS UPDT DTT C	63	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_UPDT_BY_C	SYS UPDT BY C	64	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	SYS_END_DTT_C	SYS END DTT C	65	DATE			NO	YES	FALSE	FALSE
PSET_REF_C	Product Reference	Product Reference	PDE1_NUM_C_5	PDE1 NUM C 5	66	NUMERIC	38	0	NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	PSET_REL_SYS_KEY_C	PSET REL SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_REL_C	Product Relation	Product Relation	PSET_REL_BUS_KEY_C	PSET REL BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	FRM_PSET_SYS_KEY_C	FRM PSET SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	FRM_PSET_TYPE_CD_C	FRM PSET TYPE CD C	4	VARCHAR	20		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	TO_OBJ_TYPE_NM_C	TO OBJ TYPE NM C	5	VARCHAR	100		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	TO_GENERIC_SYS_KEY_C	TO GENERIC SYS KEY C	6	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	TO_GENERIC_TYPE_CD_C	TO GENERIC TYPE CD C	7	VARCHAR	20		NO	NO	FALSE	TRUE
PSET_REL_C	Product Relation	Product Relation	REL_TYPE_CD_C	REL TYPE CD C	8	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_CRT_DTT_C	SYS CRT DTT C	9	DATE			NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_CRT_BY_C	SYS CRT BY C	10	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_EFF_DTT_C	SYS EFF DTT C	11	DATE			NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_UPDT_DTT_C	SYS UPDT DTT C	12	DATE			NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_UPDT_BY_C	SYS UPDT BY C	13	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_REL_C	Product Relation	Product Relation	SYS_END_DTT_C	SYS END DTT C	14	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_XREF_SYS_KEY_C	PSET XREF SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_XREF_BUS_KEY_C	PSET XREF BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_SYS_KEY_C	PSET SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_XREF_SRC_NM_C	PSET XREF SRC NM C	4	VARCHAR	100		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_XREF_SRC_VAL_C	PSET XREF SRC VAL C	5	VARCHAR	200		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	PSET_XREF_SRC_TYPE_C	PSET XREF SRC TYPE C	6	VARCHAR	50		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SRC_CTRY_CD_C	SRC CTRY CD C	7	VARCHAR	20		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SRC_EFF_DTT_C	SRC EFF DTT C	8	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SRC_END_DTT_C	SRC END DTT C	9	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SRC_UPDT_DTT_C	SRC UPDT DTT C	10	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_CRT_BY_C	SYS CRT BY C	11	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_CRT_DTT_C	SYS CRT DTT C	12	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_EFF_DTT_C	SYS EFF DTT C	13	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_UPDT_DTT_C	SYS UPDT DTT C	14	DATE			NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_UPDT_BY_C	SYS UPDT BY C	15	VARCHAR	255		NO	YES	FALSE	FALSE
PSET_XREF_C	Product Cross Reference	Product Cross Reference	SYS_END_DTT_C	SYS END DTT C	16	DATE			NO	YES	FALSE	FALSE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_SYS_KEY_C

PSET CLASS SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_BUS_KEY_C

PSET CLASS BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_TYPE_CD_C

PSET CLASS TYPE CD C

3

VARCHAR

20

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_NM_C

PSET CLASS NM C

4

VARCHAR

100

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_DESC_C

PSET CLASS DESC C

5

VARCHAR

255

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

PSET_CLASS_LEVEL_NBR

PSET CLASS LEVEL NBR

6

NUMERIC

38

0

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

CTRY_CD_C

CTRY CD C

7

VARCHAR

20

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_CRT_DTT_C

SYS CRT DTT C

8

DATE

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_CRT_BY_C

SYS CRT BY C

9

VARCHAR

255

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_EFF_DTT_C

SYS EFF DTT C

10

DATE

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_UPDT_DTT_C

SYS UPDT DTT C

11

DATE

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_UPDT_BY_C

SYS UPDT BY C

12

VARCHAR

255

NO

YES

FALSE

PSET_CLASS_REF_C

Product Classification Reference

SYS_END_DTT_C

SYS END DTT C

13

DATE

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

PSET_EXT_ATTR_SYS_KEY_C

PSET EXT ATTR SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_EXT_ATTR_C

Product External Attribute

PSET_EXT_ATTR_BUS_KEY_C

PSET EXT ATTR BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_EXT_ATTR_C

Product External Attribute

PSET_SYS_KEY_C

PSET SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

PSET_EXT_ATTR_C

Product External Attribute

EXT_ATTR_TYPE_TXT_C

EXT ATTR TYPE TXT C

4

VARCHAR

20

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

EXT_ATTR_TYPE_VAL_C

EXT ATTR TYPE VAL C

5

VARCHAR

100

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

ACTV_IND_C

ACTV IND C

6

VARCHAR

1

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_CRT_DTT_C

SYS CRT DTT C

7

DATE

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_CRT_BY_C

SYS CRT BY C

8

VARCHAR

255

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_EFF_DTT_C

SYS EFF DTT C

9

DATE

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_UPDT_DTT_C

SYS UPDT DTT C

10

DATE

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_UPDT_BY_C

SYS UPDT BY C

11

VARCHAR

255

NO

YES

FALSE

PSET_EXT_ATTR_C

Product External Attribute

SYS_END_DTT_C

SYS END DTT C

12

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

PSET_HIER_SYS_KEY_C

PSET HIER SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_HIER_C

ProductHierarchy

PSET_HIER_BUS_KEY_C

PSET HIER BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_HIER_C

ProductHierarchy

PRNT_PSET_SYS_KEY_C

PRNT PSET SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

PSET_HIER_C

ProductHierarchy

PRNT_PSET_TYPE_CD_C

PRNT PSET TYPE CD C

4

VARCHAR

255

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

CHLD_PSET_SYS_KEY_C

CHLD PSET SYS KEY C

5

VARCHAR

16777216

NO

FALSE

TRUE

PSET_HIER_C

ProductHierarchy

CHLD_PSET_TYPE_CD_C

CHLD PSET TYPE CD C

6

VARCHAR

255

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

HIER_TYPE_CD_C

HIER TYPE CD C

7

VARCHAR

255

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

HIER_ID_C

HIER ID C

8

VARCHAR

16777216

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

HIER_NM_C

HIER NM C

9

VARCHAR

500

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

KEY_COMP_IND_C

KEY COMP IND C

10

VARCHAR

1

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

CTRY_CD_C

CTRY CD C

11

VARCHAR

20

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_CRT_DTT_C

SYS CRT DTT C

12

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_CRT_BY_C

SYS CRT BY C

13

VARCHAR

255

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_EFF_DTT_C

SYS EFF DTT C

14

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_UPDT_DTT_C

SYS UPDT DTT C

15

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_UPDT_BY_C

SYS UPDT BY C

16

VARCHAR

255

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

SYS_END_DTT_C

SYS END DTT C

17

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

HIER_STRT_DTT_C

HIER STRT DTT C

18

DATE

NO

YES

FALSE

PSET_HIER_C

ProductHierarchy

HIER_END_DTT_C

HIER END DTT C

19

DATE

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

PSET_MFR_CORP_SYS_KEY

PSET MFR CORP SYS KEY

1

VARCHAR

16777216

NO

TRUE

PSET_MFR_DTL_C

Product Manufacturer Detail

PSET_MFR_CORP_BUS_KEY_C

PSET MFR CORP BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_MFR_DTL_C

Product Manufacturer Detail

MFR_CD_C

MFR CD C

3

VARCHAR

20

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

MFR_SHRT_NM_C

MFR SHRT NM C

4

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

MFR_NM_C

MFR NM C

5

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

CORP_CD_C

CORP CD C

6

VARCHAR

20

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

CORP_SHRT_NM_C

CORP SHRT NM C

7

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

CORP_NM_C

CORP NM C

8

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

ACTV_IND_C

ACTV IND C

9

VARCHAR

1

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

INTL_MFR_NM_C

INTL MFR NM C

10

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

CORP_NATLTY_NM_C

CORP NATLTY NM C

11

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

MFR_OWNSHP_NM_C

MFR OWNSHP NM C

12

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

MFR_PLUS_NM_C

MFR PLUS NM C

13

VARCHAR

100

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_CRT_DTT_C

SYS CRT DTT C

14

DATE

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_CRT_BY_C

SYS CRT BY C

15

VARCHAR

255

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_EFF_DTT_C

SYS EFF DTT C

16

DATE

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_UPDT_DTT_C

SYS UPDT DTT C

17

DATE

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_UPDT_BY_C

SYS UPDT BY C

18

VARCHAR

255

NO

YES

FALSE

PSET_MFR_DTL_C

Product Manufacturer Detail

SYS_END_DTT_C

SYS END DTT C

19

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

PSET_MSG_SYS_KEY_C

PSET MSG SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_MSG_C

Product Message

PSET_MSG_BUS_KEY_C

PSET MSG BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_MSG_C

Product Message

SRC_ENT_ID_C

SRC ENT ID C

3

VARCHAR

20

NO

YES

FALSE

PSET_MSG_C

Product Message

PSET_SYS_KEY_C

PSET SYS KEY C

4

VARCHAR

16777216

NO

FALSE

TRUE

PSET_MSG_C

Product Message

PSET_MSG_PRTY_C

PSET MSG PRTY C

5

NUMERIC

38

0

NO

YES

FALSE

PSET_MSG_C

Product Message

SRC_EFF_DTT_C

SRC EFF DTT C

6

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SRC_END_DTT_C

SRC END DTT C

7

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SRC_UPDT_DTT_C

SRC UPDT DTT C

8

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_CRT_BY_C

SYS CRT BY C

9

VARCHAR

255

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_CRT_DTT_C

SYS CRT DTT C

10

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_EFF_DTT_C

SYS EFF DTT C

11

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_UPDT_DTT_C

SYS UPDT DTT C

12

DATE

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_UPDT_BY_C

SYS UPDT BY C

13

VARCHAR

255

NO

YES

FALSE

PSET_MSG_C

Product Message

SYS_END_DTT_C

SYS END DTT C

14

DATE

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

PSET_PRC_SYS_KEY_C

PSET PRC SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_PRC_DTL_C

Product Price Detail

PSET_PRC_BUS_KEY_C

PSET PRC BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_PRC_DTL_C

Product Price Detail

PSET_SYS_KEY_C

PSET SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

PSET_PRC_DTL_C

Product Price Detail

PRC_TYPE_TXT_C

PRC TYPE TXT C

4

VARCHAR

20

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

CURR_NM_C

CURR NM C

5

VARCHAR

100

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

PSET_PRC_AMT_VAL_C

PSET PRC AMT VAL C

6

NUMERIC

38

0

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

ACTV_IND_C

ACTV IND C

7

VARCHAR

1

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_CRT_DTT_C

SYS CRT DTT C

8

DATE

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_CRT_BY_C

SYS CRT BY C

9

VARCHAR

255

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_EFF_DTT_C

SYS EFF DTT C

10

DATE

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_UPDT_DTT_C

SYS UPDT DTT C

11

DATE

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_UPDT_BY_C

SYS UPDT BY C

12

VARCHAR

255

NO

YES

FALSE

PSET_PRC_DTL_C

Product Price Detail

SYS_END_DTT_C

SYS END DTT C

13

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_SYS_KEY_C

PSET SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_REF_C

Product Reference

PSET_BUS_KEY_C

PSET BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_REF_C

Product Reference

SRC_SYS_CD_C

SRC SYS CD C

3

VARCHAR

20

NO

FALSE

TRUE

PSET_REF_C

Product Reference

PSET_SRC_ENT_ID_C

PSET SRC ENT ID C

4

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_SRC_ENT_CD_C

PSET SRC ENT CD C

5

VARCHAR

16777216

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_TYPE_CD_C

PSET TYPE CD C

6

VARCHAR

255

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_LVL_NBR_C

PSET LVL NBR C

7

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_NM_C

PSET NM C

8

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

CTRY_CD_C

CTRY CD C

9

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_BRND_NM_C

PSET BRND NM C

10

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_FORM_NM_C

PSET FORM NM C

11

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_STRN_NM_C

PSET STRN NM C

12

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_SKU_NM_C

PSET SKU NM C

13

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_MLCL_NM_C

PSET MLCL NM C

14

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_SMPL_IND_C

PSET SMPL IND C

15

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_LNCH_DT_C

PSET LNCH DT C

16

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_STRN_UNITS_C

PSET STRN UNITS C

17

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_STRN_MEAS_C

PSET STRN MEAS C

18

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

ROUTE_ADM_CD_C

ROUTE ADM CD C

19

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

ACTV_IND_C

ACTV IND C

20

VARCHAR

1

NO

YES

FALSE

PSET_REF_C

Product Reference

BIOL_MLCL_NM_C

BIOL MLCL NM C

21

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

LCL_RX_STAT_CD_C

LCL RX STAT CD C

22

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_BRAND_NM_C

INTL BRAND NM C

23

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_PACK_NM_C

INTL PACK NM C

24

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_PROD_NM_C

INTL PROD NM C

25

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_PSET_LNCH_DT_C

INTL PSET LNCH DT C

26

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_REIMBMNT_STAT_CD_C

INTL REIMBMNT STAT CD C

27

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_SIZE_C

INTL SIZE C

28

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_STRNT_C

INTL STRNT C

29

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

INTL_VOL_C

INTL VOL C

30

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

LCL_REIMBMNT_STAT_CD_C

LCL REIMBMNT STAT CD C

31

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

MLCL_LIST_C

MLCL LIST C

32

VARCHAR

255

NO

YES

FALSE

PSET_REF_C

Product Reference

PAR_IMP_STAT_CD_C

PAR IMP STAT CD C

33

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PATN_EXPRY_DT

PATN EXPRY DT

34

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

ETHCL_PROPTRY_CD_C

ETHCL PROPTRY CD C

35

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

DLVR_SYS_CD_C

DLVR SYS CD C

36

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

ORIGNTR_NON_ORIGNTR_CD_C

ORIGNTR NON ORIGNTR CD C

37

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

GENERIC_ORIGNTR_CD_C

GENERIC ORIGNTR CD C

38

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

GENERIC_TRADE_NM_C

GENERIC TRADE NM C

39

VARCHAR

100

NO

YES

FALSE

PSET_REF_C

Product Reference

GENERIC_PATN_CD_C

GENERIC PATN CD C

40

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

GENERIC_SRC_CD_C

GENERIC SRC CD C

41

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

NDC_CD_C

NDC CD C

42

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

NDC_CMF_BRDG_CD_C

NDC CMF BRDG CD C

43

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

NDC_PRNT_CD_C

NDC PRNT CD C

44

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

CMF_PRNT_CD_C

CMF PRNT CD C

45

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

GENERIC_PSET_IND_C

GENERIC PSET IND C

46

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_STAT_CD_C

PSET STAT CD C

47

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PSET_CLASS_SYS_KEY_C

PSET CLASS SYS KEY C

48

VARCHAR

16777216

NO

YES

FALSE

PSET_REF_C

Product Reference

CLIENT_PSET_IND

CLIENT PSET IND

49

VARCHAR

1

NO

YES

FALSE

PSET_REF_C

Product Reference

KEYCOMP_PROD_IND_C

KEYCOMP PROD IND C

50

VARCHAR

1

NO

YES

FALSE

PSET_REF_C

Product Reference

CNTRL_SBS_IND_C

CNTRL SBS IND C

51

VARCHAR

1

NO

YES

FALSE

PSET_REF_C

Product Reference

COPROMOTE_PROD_IND_C

COPROMOTE PROD IND C

52

VARCHAR

1

NO

YES

FALSE

PSET_REF_C

Product Reference

FRM3_CD

FRM3 CD

53

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

TLC3_CD

TLC3 CD

54

VARCHAR

20

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE1_NUM_C

PDE1 NUM C

55

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE2_NUM_C

PDE2 NUM C

56

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE3_NUM_C

PDE3 NUM C

57

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE4_NUM_C

PDE4 NUM C

58

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE5_NUM_C

PDE5 NUM C

59

NUMERIC

38

0

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_CRT_DTT_C

SYS CRT DTT C

60

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_CRT_BY_C

SYS CRT BY C

61

VARCHAR

255

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_EFF_DTT_C

SYS EFF DTT C

62

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_UPDT_DTT_C

SYS UPDT DTT C

63

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_UPDT_BY_C

SYS UPDT BY C

64

VARCHAR

255

NO

YES

FALSE

PSET_REF_C

Product Reference

SYS_END_DTT_C

SYS END DTT C

65

DATE

NO

YES

FALSE

PSET_REF_C

Product Reference

PDE1_NUM_C_5

PDE1 NUM C 5

66

NUMERIC

38

0

NO

YES

FALSE

PSET_REL_C

Product Relation

PSET_REL_SYS_KEY_C

PSET REL SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_REL_C

Product Relation

PSET_REL_BUS_KEY_C

PSET REL BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_REL_C

Product Relation

FRM_PSET_SYS_KEY_C

FRM PSET SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

PSET_REL_C

Product Relation

FRM_PSET_TYPE_CD_C

FRM PSET TYPE CD C

4

VARCHAR

20

NO

FALSE

TRUE

PSET_REL_C

Product Relation

TO_OBJ_TYPE_NM_C

TO OBJ TYPE NM C

5

VARCHAR

100

NO

FALSE

TRUE

PSET_REL_C

Product Relation

TO_GENERIC_SYS_KEY_C

TO GENERIC SYS KEY C

6

VARCHAR

16777216

NO

FALSE

TRUE

PSET_REL_C

Product Relation

TO_GENERIC_TYPE_CD_C

TO GENERIC TYPE CD C

7

VARCHAR

20

NO

FALSE

TRUE

PSET_REL_C

Product Relation

REL_TYPE_CD_C

REL TYPE CD C

8

VARCHAR

20

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_CRT_DTT_C

SYS CRT DTT C

9

DATE

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_CRT_BY_C

SYS CRT BY C

10

VARCHAR

255

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_EFF_DTT_C

SYS EFF DTT C

11

DATE

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_UPDT_DTT_C

SYS UPDT DTT C

12

DATE

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_UPDT_BY_C

SYS UPDT BY C

13

VARCHAR

255

NO

YES

FALSE

PSET_REL_C

Product Relation

SYS_END_DTT_C

SYS END DTT C

14

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

PSET_XREF_SYS_KEY_C

PSET XREF SYS KEY C

1

VARCHAR

16777216

NO

TRUE

PSET_XREF_C

Product Cross Reference

PSET_XREF_BUS_KEY_C

PSET XREF BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

PSET_XREF_C

Product Cross Reference

PSET_SYS_KEY_C

PSET SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

PSET_XREF_C

Product Cross Reference

PSET_XREF_SRC_NM_C

PSET XREF SRC NM C

4

VARCHAR

100

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

PSET_XREF_SRC_VAL_C

PSET XREF SRC VAL C

5

VARCHAR

200

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

PSET_XREF_SRC_TYPE_C

PSET XREF SRC TYPE C

6

VARCHAR

50

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SRC_CTRY_CD_C

SRC CTRY CD C

7

VARCHAR

20

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SRC_EFF_DTT_C

SRC EFF DTT C

8

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SRC_END_DTT_C

SRC END DTT C

9

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SRC_UPDT_DTT_C

SRC UPDT DTT C

10

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_CRT_BY_C

SYS CRT BY C

11

VARCHAR

255

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_CRT_DTT_C

SYS CRT DTT C

12

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_EFF_DTT_C

SYS EFF DTT C

13

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_UPDT_DTT_C

SYS UPDT DTT C

14

DATE

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_UPDT_BY_C

SYS UPDT BY C

15

VARCHAR

255

NO

YES

FALSE

PSET_XREF_C

Product Cross Reference

SYS_END_DTT_C

SYS END DTT C

16

DATE

NO

YES

FALSE