CP_RULE_DETL_AD (SQL Table)	Index Back
CP Rule Header This table contains all rules to be used during the execution of the product configurator.

CP_RULE_DETL_AD

(SQL Table)

CP Rule Header

This table contains all rules to be used during the execution of the product configurator.

# 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 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production

3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

4 RULE_SEQUENCE Number(5,0) INTEGER NOT NULL Sequence
Default Value: 1

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

6 CP_ITEM_EXPR Character(18) VARCHAR2(18) NOT NULL Component Item ID Syntax Field
Prompt Table: CP_EXPR

7 CP_QTY_EXPR Character(18) VARCHAR2(18) NOT NULL Quantity Expression Syntax Field
Prompt Table: CP_EXPR

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	CP_AREA	Character(1)	VARCHAR2(1) NOT NULL	Functional Area Field 0=Distribution 1=Production
3	RULE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Rule
4	RULE_SEQUENCE	Number(5,0)	INTEGER NOT NULL	Sequence Default Value: 1
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
6	CP_ITEM_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Component Item ID Syntax Field Prompt Table: CP_EXPR
7	CP_QTY_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Quantity Expression Syntax Field Prompt Table: CP_EXPR
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.