PROD_UPNCRES2VW

(SQL View)
Index Back

Customer Product by UPN & Type

Customer Product by Customer UPN Type

SELECT ' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
5 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model Number
10 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
11 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
12 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
13 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID