CNT_UPN_CD_VW

(SQL View)
Index Back

UPN Type Codes

UPN Type codes

SELECT DISTINCT SETID , UPN_TYPE_CD FROM PS_UPN_TYPE_FS WHERE UPN_TYPE_CD <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type

Default Value: MANUFACTURER.UPN_TYPE_CD

Prompt Table: UPN_TYPE_FS