RF_PROD_REG_IPS (SQL Table)	Index Back
Prod Reg - Installed Products Used as a page buffer on RF_PROD_REG_SRCH. Existing installed products for a customer is populates this grid.

RF_PROD_REG_IPS

(SQL Table)

Prod Reg - Installed Products

Used as a page buffer on RF_PROD_REG_SRCH. Existing installed products for a customer is populates this grid.

# 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.

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

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RF_PROD_PMPT_VW

4 DESCR_EXT Character(50) VARCHAR2(50) NOT NULL External Description

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: %EDITTABLE4

6 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

7 REGISTER_PB Character(1) VARCHAR2(1) NOT NULL Register Push Button is used to register a Consumer, Trigger Logic to register Consumer etc.

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
Prompt Table: RF_CNAME_PRM_VW

9 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

10 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

11 REGISTERED_DATE Date(10) DATE Date of registration for installed products.

12 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product

13 MARKET Character(3) VARCHAR2(3) NOT NULL Market

#	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.
2	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RF_PROD_PMPT_VW
4	DESCR_EXT	Character(50)	VARCHAR2(50) NOT NULL	External Description
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE4
6	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
7	REGISTER_PB	Character(1)	VARCHAR2(1) NOT NULL	Register Push Button is used to register a Consumer, Trigger Logic to register Consumer etc.
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID Prompt Table: RF_CNAME_PRM_VW
9	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
10	INST_PROD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of an installed product.
11	REGISTERED_DATE	Date(10)	DATE	Date of registration for installed products.
12	INSTALLED_DATE	Date(10)	DATE	Field used for storing Installed Date of Installed product
13	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market