RO_CP_TRACE_TMP

(SQL Table)
 Index Back

CP Rule Trace

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 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
3 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
4 RULE_SEQUENCE Number(5,0) INTEGER NOT NULL Sequence
5 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field
6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
7 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production
8 CP_TREE Character(18) VARCHAR2(18) NOT NULL Model Field
9 CP_NODE Number(5,0) INTEGER NOT NULL Node Number Field
10 CP_TREE_SEQ Number(5,0) INTEGER NOT NULL Model Sequence Field
11 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

Prompt Table: CP_RULE_VW

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