CFG_PRICE_TBL_V (SQL View)	Index Back
CFG Price Table CFG Price Table - Configurator Price Table

CFG_PRICE_TBL_V

(SQL View)

CFG Price Table

CFG Price Table - Configurator Price Table

SELECT CFG_SCHEMA_ID , CFG_OBJECT_TYPE ,CFG_OBJECT_NAME , CFG_ATTRIBUTE ,CFG_OPERATOR ,CFG_OBJECT_TYPE2 ,CFG_OBJECT_NAME2 ,CFG_ATTRIBUTE2 ,CFG_DELTAPRICEONLY ,ROW_ADDED_OPRID ,ROW_LASTMANT_OPRID ,SYNCID FROM PS_CFG_PRICE_TBL

Parent record: CFG_SCHEMA_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator

2 CFG_OBJECT_TYPE Character(2) VARCHAR2(2) NOT NULL Configurator
01=Selection
02=Expression
03=Configuration Attribute
04=External Variable
05=Connections
06=Component
07=Connections
08=Selections Filtered List
09=Selections Filter Where
10=Selections Attributes
11=Package Components
12=Manufactured Components
13=Routing Operations
14=Purchased Components
15=Product Selector
Default Value: 02
Prompt Table: CFG_OBJTYPE_VW1

3 CFG_OBJECT_NAME Character(64) VARCHAR2(64) NOT NULL Attribute name column on Configurator Output tab and Price tabs

4 CFG_ATTRIBUTE Character(64) VARCHAR2(64) NOT NULL Values on Configurator Output tab for selecting attributes

5 CFG_OPERATOR Character(2) VARCHAR2(2) NOT NULL Operator column of the List Price page in Configurator Price tab

6 CFG_OBJECT_TYPE2 Character(2) VARCHAR2(2) NOT NULL Configurator

7 CFG_OBJECT_NAME2 Character(64) VARCHAR2(64) NOT NULL Configurator

8 CFG_ATTRIBUTE2 Character(64) VARCHAR2(64) NOT NULL Attribute column on List Price table used in configurator

9 CFG_DELTAPRICEONLY Character(1) VARCHAR2(1) NOT NULL Check box to indicate display of delta price only in the Configuration List Price group box
0=Yes
1=No

10 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

12 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CFG_SCHEMA_ID	Character(18)	VARCHAR2(18) NOT NULL	Schema ID displayed on several pages of Configurator
2	CFG_OBJECT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Configurator 01=Selection 02=Expression 03=Configuration Attribute 04=External Variable 05=Connections 06=Component 07=Connections 08=Selections Filtered List 09=Selections Filter Where 10=Selections Attributes 11=Package Components 12=Manufactured Components 13=Routing Operations 14=Purchased Components 15=Product Selector Default Value: 02 Prompt Table: CFG_OBJTYPE_VW1
3	CFG_OBJECT_NAME	Character(64)	VARCHAR2(64) NOT NULL	Attribute name column on Configurator Output tab and Price tabs
4	CFG_ATTRIBUTE	Character(64)	VARCHAR2(64) NOT NULL	Values on Configurator Output tab for selecting attributes
5	CFG_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Operator column of the List Price page in Configurator Price tab
6	CFG_OBJECT_TYPE2	Character(2)	VARCHAR2(2) NOT NULL	Configurator
7	CFG_OBJECT_NAME2	Character(64)	VARCHAR2(64) NOT NULL	Configurator
8	CFG_ATTRIBUTE2	Character(64)	VARCHAR2(64) NOT NULL	Attribute column on List Price table used in configurator
9	CFG_DELTAPRICEONLY	Character(1)	VARCHAR2(1) NOT NULL	Check box to indicate display of delta price only in the Configuration List Price group box 0=Yes 1=No
10	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
11	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
12	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.