RF_IPRD_VALS_VW

(SQL View)
 Index Back

Current Installed Products

Installed products that are not completely in "Uninstalled" or "Disconnected" or "Pending Deactivation" 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.LOCATION , 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 B.INST_PROD_STATUS <> 'DIS' AND B.INST_PROD_STATUS <> 'PDI'

# 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 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
19 PROD_OWNERSHIP Character(3) VARCHAR2(3) NOT NULL Product Ownership
L=Leased
P=Purchased
R=Rented
20 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location
21 DISTRIBUTOR_ID Character(30) VARCHAR2(30) NOT NULL Purchased From
22 DISTCONTACT Character(15) VARCHAR2(15) NOT NULL Purchased From Contact
23 SALES_USER_ID Character(15) VARCHAR2(15) NOT NULL Sales User ID

Prompt Table: RF_SUSER_VW

24 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

25 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
26 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
27 EXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL External ID
28 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
29 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
30 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
31 ENVIRONMENT Character(3) VARCHAR2(3) NOT NULL Environment
DB2=DB2
INF=Informix
MSS=MS SQLServer
ORA=Oracle
SQL=SQL Anywhere
SYB=Sybase
32 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
33 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
34 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
35 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
36 OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
37 TOPLEVELPOSITION Character(10) VARCHAR2(10) NOT NULL Top Level Position
38 LEVEL1 Character(10) VARCHAR2(10) NOT NULL Level
39 POSITION Character(70) VARCHAR2(70) NOT NULL Position
40 ORDERBY1 Number(3,0) SMALLINT NOT NULL Order
41 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

42 AUTHCODE Character(10) VARCHAR2(10) NOT NULL Authorization Code
43 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)