CP_RULE_DETL (SQL Table)	Index Back
CP Rule Detail The Rule Detail table contains the conditions and actions to be performed based on the rule action code defined on the rule header.

CP_RULE_DETL

(SQL Table)

CP Rule Detail

The Rule Detail table contains the conditions and actions to be performed based on the rule action code defined on the rule header.

Related Language Record: CP_RULE_D_LANG

Parent record: CP_RULE_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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 CP_VARIABLE Character(18) VARCHAR2(18) NOT NULL Variable Field
Prompt Table: CP_OPT_VAR_VW

6 CP_LONG_DESCR Character(254) VARCHAR2(254) NOT NULL Long Description Field

7 CP_CONTROL_TYPE Character(1) VARCHAR2(1) NOT NULL Panel Control Type for the Product Configurator
C=Check Box
D=Dropdown List
E=Edit Box
R=Radio Button
T=Text Box
Default Value: E

8 CP_USER_CD Character(10) VARCHAR2(10) NOT NULL Value List Field
Prompt Table: CP_USERCD_VW

9 CP_USER_CD_EXPR Character(18) VARCHAR2(18) NOT NULL Dynamic Value List Expression Syntax Field
Prompt Table: CP_EXPR

10 CP_DEFAULT_EXPR Character(18) VARCHAR2(18) NOT NULL Default Expression Value Field
Prompt Table: CP_EXPR

11 CP_PRINT_CODE Character(4) VARCHAR2(4) NOT NULL Print Code Field
Prompt Table: CP_PRINTCD

12 CP_CONSTRAINT Character(10) VARCHAR2(10) NOT NULL Constraint Field
Prompt Table: CP_CONSTRT_VW1

13 CP_NUMVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Numeric Date Validation Field
D=Date (format: yyyymmdd)
N=None
Y=Numeric/Fractions
Y/N Table Edit
Default Value: N

14 CP_USERCD_DESC Character(1) VARCHAR2(1) NOT NULL Value List Description Field
Y/N Table Edit
Default Value: Y

15 CP_MORE_INFO Long Character CLOB More Information Field Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - More Option Information Enhancement More Option Info field

16 CP_STATUS Character(1) VARCHAR2(1) NOT NULL Option Status Field
0=Required
1=Included
2=Optional
3=Conditional
Default Value: 0

17 CP_CONDITION_EXPR Character(18) VARCHAR2(18) NOT NULL Condition Expression ID Field
Prompt Table: CP_EXPR

18 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	SetID
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	CP_VARIABLE	Character(18)	VARCHAR2(18) NOT NULL	Variable Field Prompt Table: CP_OPT_VAR_VW
6	CP_LONG_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Long Description Field
7	CP_CONTROL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Panel Control Type for the Product Configurator C=Check Box D=Dropdown List E=Edit Box R=Radio Button T=Text Box Default Value: E
8	CP_USER_CD	Character(10)	VARCHAR2(10) NOT NULL	Value List Field Prompt Table: CP_USERCD_VW
9	CP_USER_CD_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Dynamic Value List Expression Syntax Field Prompt Table: CP_EXPR
10	CP_DEFAULT_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Default Expression Value Field Prompt Table: CP_EXPR
11	CP_PRINT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Print Code Field Prompt Table: CP_PRINTCD
12	CP_CONSTRAINT	Character(10)	VARCHAR2(10) NOT NULL	Constraint Field Prompt Table: CP_CONSTRT_VW1
13	CP_NUMVAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Numeric Date Validation Field D=Date (format: yyyymmdd) N=None Y=Numeric/Fractions Y/N Table Edit Default Value: N
14	CP_USERCD_DESC	Character(1)	VARCHAR2(1) NOT NULL	Value List Description Field Y/N Table Edit Default Value: Y
15	CP_MORE_INFO	Long Character	CLOB	More Information Field Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - More Option Information Enhancement More Option Info field
16	CP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Option Status Field 0=Required 1=Included 2=Optional 3=Conditional Default Value: 0
17	CP_CONDITION_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Condition Expression ID Field Prompt Table: CP_EXPR
18	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.