PV_CATMAPUNS_VW (SQL View)	Index Back
UNSPSC code from mapping table Get UNSPSC codes from Category Code mapping table

PV_CATMAPUNS_VW

(SQL View)

UNSPSC code from mapping table

Get UNSPSC codes from Category Code mapping table

SELECT PV_UNSPSC_CODE , CATEGORY_CD FROM PS_PV_CAT_MAP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PV_UNSPSC_CODE Character(18) VARCHAR2(18) NOT NULL UNSPSC Code

2 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PV_UNSPSC_CODE	Character(18)	VARCHAR2(18) NOT NULL	UNSPSC Code
2	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code