CP_RULE_AC_VW

(SQL View)
 Index Back

CP Rule Add Search View

View of CP_RULE_HDR

SELECT SETID , CP_AREA , RULE_NUMBER , ACTION_INTL_CD FROM PS_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.

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production

Default Value: 0

3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
4 ACTION_INTL_CD Character(2) VARCHAR2(2) NOT NULL CP Action International Code Field
01=Condition
02=Secondary Variable
03=Global Variable
04=Option Variable
05=Internal Variable Override
06=Create External Parameter
07=Configuration Detail
08=Start Trace
09=End Trace
20=Page Generation
21=Page Validation
22=Configured Component
23=Purchase Item
24=Finalized Price
25=Finalized Cost
26=Finalized Date
27=Availability Date
28=Workflow
29=Kit Component
30=Component List
31=Operation Sequence
32=Generate Comment
33=Product Selector
34=Kit Generation
35=Finalized Weight
36=Finalized Volume