RPC_PRODUCT

#	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	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PROD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement. AGR=Service Agreement CMT=Commitment Product ENG=Engagement Service PHY=Standard Product PKG=Package Product SUB=Subscription Product SVC=Service Product
5	PROD_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Field used for storing Multileve product type description
6	RB_HLEV_ID	Character(20)	VARCHAR2(20) NOT NULL	Field used for storing multilevel structure level id information
7	RB_CONFIG_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Configurator Component Type ID' field used by Multilevel Component Types definition page TYP1=Type 1 TYP2=Type 2 TYP3=Type 3 TYP4=Type 4 TYP5=Type 5 TYP6=Type 6
8	COMP_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Field used for storing Multileve component type description
9	PROD_MLPB_HCON_FLG	Character(1)	VARCHAR2(1) NOT NULL	Hide in Configurator' flag used bu Product Definition page for defining new Multilevel Product Bundles
10	PROD_MLPB_DISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Disable in Configurator' flag used bu Product Definition page for defining new Multilevel Product Bundles
11	PRICE_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Price Kit Flag C=at Component Level T=at Top Level
12	INSTALLED_PROD	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the product will be tracked as an installed product.
13	OFFER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	New Field added to PROD_MLPB_ITEM table to store information about offer type for given product GRP=Group SHR=Shared
14	BUNDLING_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Field used for storing information about Product Bundling Type of product definition DED=Dedicated IND=Individual
15	OPER_COUNT_FUNC	Character(254)	VARCHAR2(254) NOT NULL	Field used for storing the name of group offer counting function assign to the group offer being exported
16	COMM_RLON_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Faield used for storing commercial relies on flag
17	COMM_RLON_BEGIN_DT	Date(10)	DATE	field used for storing Commercial Relies On begin date
18	COMM_RLON_END_DATE	Date(10)	DATE	field used for storing Commercial Relies On end date
19	RELIES_ON_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing the information flag if any Relies On rule is defined for a product
20	RELIES_ON_BEGIN_DT	Date(10)	DATE	Field used for storing the earlies begin date of a Relies On rule defined for te product
21	RELIES_ON_END_DT	Date(10)	DATE	Field used for storing the latest end date of a Relies On rule defined for te product
22	BRINGS_ON_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing the information flag if any Brings On Creation rule is defined for a product
23	BRINGS_ON_BEGIN_DT	Date(10)	DATE	Field used for storing the earlies begin date of a Brings On Creation rule defined for te product
24	BRINGS_ON_END_DT	Date(10)	DATE	Field used for storing the latest end date of a Brings On Creation rule defined for te product
25	BRING_REM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing the information flag if any Brings and Removes rule is defined for a product
26	BRING_REM_BEGIN_DT	Date(10)	DATE	Field used for storing the earlies begin date of a Brings and Removes rule defined for te product
27	BRING_REM_END_DT	Date(10)	DATE	Field used for storing the latest end date of a Brings and Removes rule defined for te product
28	RBT_ACCOUNT_SEL	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing Billing Account Selectable flag value
29	RBT_ACCOUNT_SBIL	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing Split Billing flag value