CP_RULE_T_VW

(SQL View)
 Index Back

CP Rule Trace

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

SELECT business_unit , order_no , order_int_line_no , cp_mode , rule_sequence , cp_comp_seq , setid , cp_area , cp_tree , cp_node , cp_tree_seq , rule_number , inv_item_id , product_id , action_intl_cd , rule_condition , cp_int_cond , rule_result1 , cp_int_result1 , rule_result2 , cp_int_result2 , date_in_effect , date_obsolete FROM PS_CP_RULE_TRACE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

Prompt Table: SP_BU_FS_NONVW

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

Prompt Table: CP_RULE_TRC_VW1

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 CP_MODE Character(1) VARCHAR2(1) NOT NULL Rule Processing Modes Field
A=CRM Internal
C=Model Tester
M=Direct Production Order
R=Direct Requisition Order
S=Sales Order
W=CRM External
5 RULE_SEQUENCE Number(5,0) INTEGER NOT NULL Sequence
6 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production
9 CP_TREE Character(18) VARCHAR2(18) NOT NULL Model Field
10 CP_NODE Number(5,0) INTEGER NOT NULL Node Number Field
11 CP_TREE_SEQ Number(5,0) INTEGER NOT NULL Model Sequence Field
12 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

Prompt Table: CP_RULE_VW

13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
15 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
16 RULE_CONDITION Character(254) VARCHAR2(254) NOT NULL Rule Condition Statement
17 CP_INT_COND Character(1) VARCHAR2(1) NOT NULL Interpreted Condition Field
0=False
1=True
18 RULE_RESULT1 Character(254) VARCHAR2(254) NOT NULL Rule Result Field One
19 CP_INT_RESULT1 Character(50) VARCHAR2(50) NOT NULL Result 1 Field
20 RULE_RESULT2 Character(254) VARCHAR2(254) NOT NULL Rule Result Field Two
21 CP_INT_RESULT2 Character(50) VARCHAR2(50) NOT NULL Result 2 Field
22 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
23 DATE_OBSOLETE Date(10) DATE Obsolete Date