RF_IPRDVH_CC_VW(SQL View) |
Index Back |
---|---|
Installed Prod Tree Cust NodeThis view is used in the creation of the Installed Product Tree. It returns distinct customers from the Installed Product record meeting the selection criteria. |
SELECT DISTINCT A.BO_ID_CUST ,B.SETID ,B.CUST_ID ,C.BO_NAME_DISPLAY ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CONTACT ,G.BO_NAME_DISPLAY ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,A.DEPTID ,A.RBTACCTID ,A.PARENT_INST_PRODID , A.INST_PROD_TYPE , A.INSTALLED_DATE ,A.RBTNUMBER , A.TOPLVL_INSTPROD_ID , D.CFG_KIT_FLAG , F.RB_FUNCORCOM FROM PS_RF_INST_PROD A LEFT OUTER JOIN PS_BO_NAME G ON G.BO_ID = A.BO_ID_CONTACT , PS_BC B , PS_BO_NAME C , PS_PROD_ITEM D , PS_PROD_MLPB_ITEM E LEFT OUTER JOIN PS_RB_HLEV_DFN_TBL F ON F.RB_HLEV_ID = E.RB_HLEV_ID WHERE B.BO_ID = A.BO_ID_CUST AND C.BO_ID = B.BO_ID AND C.PRIMARY_IND = 'Y' AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND A.SETID = E.SETID AND A.PRODUCT_ID = E.PRODUCT_ID AND E.PROD_MLPB_HINS_FLG <> 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
2 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
3 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
4 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
6 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
7 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
8 | BO_NAME_DISPLAY_1 | Character(80) | VARCHAR2(80) NOT NULL | This field represents the Display Name for a business object |
9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
10 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
11 | ASSETTAG | Character(40) | VARCHAR2(40) NOT NULL | Asset Tag |
12 | 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. |
13 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
14 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
15 | PARENT_INST_PRODID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to store the installed product ID of the parent installed product |
16 | 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 |
17 | INSTALLED_DATE | Date(10) | DATE | Field used for storing Installed Date of Installed product |
18 | RBTNUMBER | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
19 | TOPLVL_INSTPROD_ID | Character(20) | VARCHAR2(20) NOT NULL | Top Level Installed Product Id |
20 | CFG_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Configured Kit Package
M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled |
21 | RB_FUNCORCOM | Character(4) | VARCHAR2(4) NOT NULL |
Functional/Commercial' flag used by Multilevel Component Types definition page
COM=Commercial EXT=External FUNC=Functional |