RF_IPRD_ML_VW

(SQL View)
 Index Back

Installed Product

Installed Product web service view (contains header level and status child level data)

SELECT A.SETID , A.INST_PROD_ID , A.INST_PROD_TYPE , A.ASSET_OWNER , A.AM_ASSET_TYPE , A.ASSET_SUBTYPE , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , E.BO_NAME , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , F.FIRST_NAME , F.LAST_NAME , A.BO_ID_ASSET_CONT , A.PRODUCT_GROUP , A.PRODUCT_ID , H.DESCR , 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.DEPTID , A.LOCATION , A.PROD_OWNERSHIP , A.DISTRIBUTOR_ID , A.DISTCONTACT , A.PO_ID , A.CAPTURE_ID , A.EXTERNAL_ID , A.LINE_NBR , A.CONFIG_CODE , A.ENVIRONMENT , A.PLATFORM , A.NETWORK , A.OS , A.UI , A.OS_VERSION , A.MFG_ID , A.MODEL , A.PARENT_INST_PRODID , A.AUTHCODE , A.REGISTERED_DATE , A.COMMENTS254 , A.RBTACCTID , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTEXTERNAL_ID , A.RBTLINE_NBR , A.SVC_END_DATE , A.SCHEDULE , A.AGREEMENT_CODE , A.BO_ID_PTNR_CMP , A.BO_ID_PTNR_CNT , A.ROLETYPE_PTNR_CMP , A.ROLETYPE_PTNR_CNT , A.TMP_SERVICE , A.RESUME_DATE , A.RBTNUMBER , A.PHONE_TEMP , A.PAC_CODE , A.PAC_DATE , A.PORTIN_DATE , A.DISCONNECT_DATE , A.SUSPEND_DATE , B.INST_PROD_STATUS , G.RB_XLATLONGNAME , B.QUANTITY , A.TOPLVL_INSTPROD_ID , C.RBTACCTID , C.RBTEXTERNAL_ID , D.RB_HLEV_ID FROM PS_RF_INST_PROD A LEFT OUTER JOIN PS_BO_NAME F ON F.BO_ID = A.BO_ID_CONTACT , PS_RF_INST_PROD_ST B , PS_RF_INST_PROD C , PS_PROD_MLPB_ITEM D , PS_BO_NAME E , PS_RF_ISTATXLAT_VW G , PS_PROD_ITEM H WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND A.SETID = C.SETID AND A.TOPLVL_INSTPROD_ID = C.INST_PROD_ID AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND A.BO_ID_CUST = E.BO_ID AND A.SETID = G.SETID AND A.INST_PROD_TYPE = G.INST_PROD_TYPE AND B.INST_PROD_STATUS = G.FIELDVALUE AND A.SETID = H.SETID AND A.PRODUCT_ID = H.PRODUCT_ID UNION SELECT A.SETID , A.INST_PROD_ID , A.INST_PROD_TYPE , A.ASSET_OWNER , A.AM_ASSET_TYPE , A.ASSET_SUBTYPE , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , E.BO_NAME , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , F.FIRST_NAME , F.LAST_NAME , A.BO_ID_ASSET_CONT , A.PRODUCT_GROUP , A.PRODUCT_ID , H.DESCR , 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.DEPTID , A.LOCATION , A.PROD_OWNERSHIP , A.DISTRIBUTOR_ID , A.DISTCONTACT , A.PO_ID , A.CAPTURE_ID , A.EXTERNAL_ID , A.LINE_NBR , A.CONFIG_CODE , A.ENVIRONMENT , A.PLATFORM , A.NETWORK , A.OS , A.UI , A.OS_VERSION , A.MFG_ID , A.MODEL , A.PARENT_INST_PRODID , A.AUTHCODE , A.REGISTERED_DATE , A.COMMENTS254 , A.RBTACCTID , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTEXTERNAL_ID , A.RBTLINE_NBR , A.SVC_END_DATE , A.SCHEDULE , A.AGREEMENT_CODE , A.BO_ID_PTNR_CMP , A.BO_ID_PTNR_CNT , A.ROLETYPE_PTNR_CMP , A.ROLETYPE_PTNR_CNT , A.TMP_SERVICE , A.RESUME_DATE , A.RBTNUMBER , A.PHONE_TEMP , A.PAC_CODE , A.PAC_DATE , A.PORTIN_DATE , A.DISCONNECT_DATE , A.SUSPEND_DATE , B.INST_PROD_STATUS , G.RB_XLATLONGNAME , B.QUANTITY , A.TOPLVL_INSTPROD_ID , ' ' , ' ' , D.RB_HLEV_ID FROM PS_RF_INST_PROD A LEFT OUTER JOIN PS_BO_NAME F ON F.BO_ID = A.BO_ID_CONTACT , PS_RF_INST_PROD_ST B , PS_PROD_MLPB_ITEM D , PS_BO_NAME E , PS_RF_ISTATXLAT_VW G , PS_PROD_ITEM H WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND A.TOPLVL_INSTPROD_ID = ' ' AND A.BO_ID_CUST = E.BO_ID AND A.SETID = G.SETID AND A.INST_PROD_TYPE = G.INST_PROD_TYPE AND B.INST_PROD_STATUS = G.FIELDVALUE AND A.SETID = H.SETID AND A.PRODUCT_ID = H.PRODUCT_ID

# 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 INST_PROD_TYPE Character(3) VARCHAR2(3) NOT NULL This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset
002=Product
003=Service
004=Agreement
005=Commitment

Default Value: 002

4 ASSET_OWNER Character(1) VARCHAR2(1) NOT NULL This field is used by the Installed Product component for product type `Asset� to determine the Owner of the Asset. There are four allowable types: 1) Department, which designates an asset owned by department; 2) Employee, which designates an asset owned by employee, 3) Location, which designates an asset owned by location and 4) None, which designates an asset is created with out any employee/department/location.
D=Department
E=Employee
L=Location
N=None
5 AM_ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL This field defines the asset types that are available
010=IT Hardware
020=IT Software
030=Plant
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
999=Other
6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL This field is used in the problem tree in work management.

Prompt Table: AM_SUBTYPE

7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
8 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
9 CUST_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to represent the customer name
10 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
11 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
12 FIRST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL First Name Contact
13 LAST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL Last Name
14 BO_ID_ASSET_CONT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

Prompt Table: RF_BO_WORKER_VW

15 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

Prompt Table: RF_PRDGRP_VW

16 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: RF_PROD_PMPT_VW

17 PROD_NAME Character(30) VARCHAR2(30) NOT NULL Product Name
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE4

19 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
20 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
21 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
22 SHIP_DATE Date(10) DATE Item Shipping Date
23 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
24 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: %EDITTABLE5

25 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
26 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

Prompt Table: RF_DEPT_TBL_VW

27 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

Prompt Table: LOCATION_VW1

28 PROD_OWNERSHIP Character(3) VARCHAR2(3) NOT NULL Product Ownership
L=Leased
P=Purchased
R=Rented
29 DISTRIBUTOR_ID Character(30) VARCHAR2(30) NOT NULL Purchased From
30 DISTCONTACT Character(15) VARCHAR2(15) NOT NULL Purchased From Contact
31 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
32 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
33 EXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL External ID
34 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
35 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
36 ENVIRONMENT Character(3) VARCHAR2(3) NOT NULL Environment
DB2=DB2
INF=Informix
MSS=MS SQLServer
ORA=Oracle
SQL=SQL Anywhere
SYB=Sybase
37 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
38 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
39 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
40 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
41 OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
42 MFG_ID Character(50) VARCHAR2(50) NOT NULL Key field to represent Manufacturer Identification number

Prompt Table: MANUFACTURER

43 MODEL Character(30) VARCHAR2(30) NOT NULL Model
44 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: %EDITTABLE30

45 AUTHCODE Character(10) VARCHAR2(10) NOT NULL Authorization Code
46 REGISTERED_DATE Date(10) DATE Date of registration for installed products.
47 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)
48 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
49 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id
50 RBTSPONSOREDACCTID Character(15) VARCHAR2(15) NOT NULL Sponsored Account Id
51 RBTEXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.
52 RBTLINE_NBR Number(5,0) INTEGER NOT NULL rbtline_nbr
53 SVC_END_DATE Date(10) DATE This field is used by the Installed Product component to designate the date that the Service was terminated or suspended.
54 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.

Prompt Table: RF_SCHED_TBL_VW

55 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
56 BO_ID_PTNR_CMP Signed Number(32,0) DECIMAL(31) NOT NULL Partner Company Business Object ID.

Prompt Table: RF_PTNR_SRCH_VW

57 BO_ID_PTNR_CNT Signed Number(32,0) DECIMAL(31) NOT NULL Partner Contact Business Object ID.

Prompt Table: RF_PTNR_REPS_VW

58 ROLETYPE_PTNR_CMP Number(12,0) DECIMAL(12) NOT NULL Role Type Partner Company
59 ROLETYPE_PTNR_CNT Number(12,0) DECIMAL(12) NOT NULL Role Type Partner Contact
60 TMP_SERVICE Character(1) VARCHAR2(1) NOT NULL Indicates if the Service is temporary

Default Value: N

61 RESUME_DATE Date(10) DATE Temporary Suspension Resumption date
62 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
63 PHONE_TEMP Character(24) VARCHAR2(24) NOT NULL Temporary phone number used when transferring service
64 PAC_CODE Character(9) VARCHAR2(9) NOT NULL PAC Code issues by wireless carriers for transferring phone numbers.
65 PAC_DATE Date(10) DATE PAC Date for wireless carriers for transferring phone numbers.
66 PORTIN_DATE Date(10) DATE PortIn Date for wireless carriers for transferring phone numbers.
67 DISCONNECT_DATE Date(10) DATE Disconnect Date
68 SUSPEND_DATE Date(10) DATE Suspend Date
69 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
70 STATUSDESCR Character(30) VARCHAR2(30) NOT NULL Status Description
71 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
72 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id
73 RBT_TOP_ACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
74 RBT_TOP_EXT_ID Character(20) VARCHAR2(20) NOT NULL Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.
75 RB_HLEV_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing multilevel structure level id information