PRD_SRCH_CUNAUD

(SQL Table)
Index Back

Product Catalog by UPN

Customer Product Catalog by UPN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
3 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
4 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
8 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number