RF_IPRD_STAT_VW

(SQL View)
 Index Back

Inst Prod non 'Uni' status vw

Installed products that are not completely in "Uninstalled" status

SELECT DISTINCT A.SETID , A.INST_PROD_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.PRODUCT_ID , A.INV_ITEM_ID , A.SERIAL_ID , A.ASSETTAG , A.ORDER_DATE , A.SHIP_DATE , A.INSTALLED_DATE , A.SITE_ID , A.PERSON_ID , A.NODE_ID , A.DEPTID , A.PROD_OWNERSHIP , A.LOCN , A.DISTRIBUTOR_ID , A.DISTCONTACT , A.SALES_USER_ID , A.INSTALL_TYPE , A.PO_ID , A.CAPTURE_ID , A.EXTERNAL_ID , A.LINE_NBR , A.BUSINESS_UNIT_OM , A.CONFIG_CODE , A.ENVIRONMENT , A.PLATFORM , A.NETWORK , A.OS , A.UI , A.OS_VERSION , A.TOPLEVELPOSITION , A.LEVEL1 , A.POSITION , A.ORDERBY1 , A.PARENT_INST_PRODID , A.AUTHCODE , A.COMMENTS254 FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND B.INST_PROD_STATUS <> 'UNI' AND (EXISTS ( SELECT 'X' FROM PS_BC_FLAGS_VW C WHERE C.BO_ID = A.BO_ID_CUST AND C.SOLD_TO_FLG = 'Y') OR (A.SITE_ID <> ' ' AND (A.BO_ID_CUST = 0 OR A.BO_ID_CUST = ( SELECT D.BO_ID FROM PS_RB_ANON_BO_ID D WHERE D.ROLE_TYPE_ID = 9))))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

Default Value: NEXT

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: RF_PROD_PMPT_VW

8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE4

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
10 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
11 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
12 SHIP_DATE Date(10) DATE Item Shipping Date
13 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
14 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: RF_COMPSITE3_VW
Set Control Field: SETID

15 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
16 NODE_ID Number(8,0) INTEGER NOT NULL Installed Node
17 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

Prompt Table: DEPT_TBL

18 PROD_OWNERSHIP Character(3) VARCHAR2(3) NOT NULL Product Ownership
L=Leased
P=Purchased
R=Rented
19 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location
20 DISTRIBUTOR_ID Character(30) VARCHAR2(30) NOT NULL Purchased From
21 DISTCONTACT Character(15) VARCHAR2(15) NOT NULL Purchased From Contact
22 SALES_USER_ID Character(15) VARCHAR2(15) NOT NULL Sales User ID

Prompt Table: RF_SUSER_VW

23 INSTALL_TYPE Character(3) VARCHAR2(3) NOT NULL Type of installation that the installed product is used for (beta, demo, etc.).
B=Beta
D=Demo
E=Evaluation
L=Loan
S=Sold

Default Value: S

24 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
25 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
26 EXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL External ID
27 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
28 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
29 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
30 ENVIRONMENT Character(3) VARCHAR2(3) NOT NULL Environment
DB2=DB2
INF=Informix
MSS=MS SQLServer
ORA=Oracle
SQL=SQL Anywhere
SYB=Sybase
31 PLATFORM Character(3) VARCHAR2(3) NOT NULL Platform
390=IBM S/390
ACN=Acorn
AG4=Apple G4 Server
AIB=Apple iBook
AS4=AS400
DPD=Digital PDP
DVX=Digital VAX
HP3=Hewlett-Packard 3000
HP9=Hewlett-Packard 9000
MAC=Macintosh
PEN=IBM Pentium
SNF=Sun Fire
SNX=Sun Enterprise
32 NETWORK Character(3) VARCHAR2(3) NOT NULL Network
BVN=Banyan Vines
N21=Netware 2.1
N31=Netware 3.1
OTC=Other TCP/IP
TCP=Winsock TCP/IP
33 OS Character(3) VARCHAR2(3) NOT NULL Operating System
390=S/390
DOS=DOS
DUX=Digital Unix
HPU=HP-UX
LNX=Linux
OS2=OS2
SUN=Solaris
VMS=VMS
W2K=Windows 2000
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
WME=Windows ME
WNT=Windows NT
WXP=Windows XP
34 UI Character(3) VARCHAR2(3) NOT NULL User Interface
A08=Apple OS 8
AOX=Apple OS X
MIF=Motif
OS2=OS/2 PM
PM=Presentation Manager
W2K=Windows 2000
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
WNT=Windows NT
35 OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
36 TOPLEVELPOSITION Character(10) VARCHAR2(10) NOT NULL Top Level Position
37 LEVEL1 Character(10) VARCHAR2(10) NOT NULL Level
38 POSITION Character(70) VARCHAR2(70) NOT NULL Position
39 ORDERBY1 Number(3,0) SMALLINT NOT NULL Order
40 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product

Prompt Table: RF_IPRD_CUST_VW

41 AUTHCODE Character(10) VARCHAR2(10) NOT NULL Authorization Code
42 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)