RF_IPRD_WS1_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 , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.BO_ID_ASSET_CONT , A.PRODUCT_GROUP , 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.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 , B.QUANTITY 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

# 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 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
10 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
11 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

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

Prompt Table: RF_PRDGRP_VW

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

Prompt Table: RF_PROD_PMPT_VW

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

Prompt Table: %EDITTABLE4

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

21 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
22 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

Prompt Table: RF_DEPT_TBL_VW

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

Prompt Table: LOCATION_VW1

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

Prompt Table: MANUFACTURER

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

41 AUTHCODE Character(10) VARCHAR2(10) NOT NULL Authorization Code
42 REGISTERED_DATE Date(10) DATE Date of registration for installed products.
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)
44 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
45 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id
46 RBTSPONSOREDACCTID Character(15) VARCHAR2(15) NOT NULL Sponsored Account Id
47 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.
48 RBTLINE_NBR Number(5,0) INTEGER NOT NULL rbtline_nbr
49 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.
50 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.

Prompt Table: RF_SCHED_TBL_VW

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

Prompt Table: RF_PTNR_SRCH_VW

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

Prompt Table: RF_PTNR_REPS_VW

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

Default Value: N

57 RESUME_DATE Date(10) DATE Temporary Suspension Resumption date
58 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
59 PHONE_TEMP Character(24) VARCHAR2(24) NOT NULL Temporary phone number used when transferring service
60 PAC_CODE Character(9) VARCHAR2(9) NOT NULL PAC Code issues by wireless carriers for transferring phone numbers.
61 PAC_DATE Date(10) DATE PAC Date for wireless carriers for transferring phone numbers.
62 PORTIN_DATE Date(10) DATE PortIn Date for wireless carriers for transferring phone numbers.
63 DISCONNECT_DATE Date(10) DATE Disconnect Date
64 SUSPEND_DATE Date(10) DATE Suspend Date
65 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
66 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface