CP_RULE_DETL_CL (SQL Table)	Index Back
CP Rule Detail-Comp List table The Rule Detail Comp. List table contains the conditions and actions to be performed for a component list that allows multiple components per rule

CP_RULE_DETL_CL

(SQL Table)

CP Rule Detail-Comp List table

The Rule Detail Comp. List table contains the conditions and actions to be performed for a component list that allows multiple components per rule

Parent record: CP_RULE_HDR

# 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 CP_ITEM_EXPR Character(18) VARCHAR2(18) NOT NULL Component Item ID Syntax Field
Prompt Table: CP_EXPR

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

7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

9 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield
Default Value: 100

10 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
Y/N Table Edit
Default Value: N

11 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	CP_ITEM_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Component Item ID Syntax Field Prompt Table: CP_EXPR
6	CP_QTY_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Quantity Expression Syntax Field Prompt Table: CP_EXPR
7	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
8	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
9	YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Component Yield Default Value: 100
10	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o Y/N Table Edit Default Value: N
11	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.