EOEP_PRICER_AET

(SQL Table)
 Index Back

Pricing State Record

Pricing State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CHAR_VALUE Character(30) VARCHAR2(30) NOT NULL Old Edit Value
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

4 END_DATE Date(10) DATE End Date
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 PPRC_RECUR_FREQ Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually
7 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

Prompt Table: EOEP_PRICE_LIST

8 PRICE_SET_ID Character(10) VARCHAR2(10) NOT NULL Price Set ID
9 PRICE_SET_ID_CUR Character(10) VARCHAR2(10) NOT NULL Price Set ID
10 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
11 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PRICSET_PROD_VW

12 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCD_VW

13 EOEP_APP_CD_PREV Character(4) VARCHAR2(4) NOT NULL Transaction Code
BA=Buying Agreement
LP=Weight & Volume Pricing
OC=Order Capture
SO=Sales Order
14 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
15 EOEP_ARB_ID_PREV Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
16 EOEP_ARB_TYPE Character(2) VARCHAR2(2) NOT NULL Arbitration Type
1=Action Type
2=Price Type
3=Decision
4=Pricing Key
5=Price Rule
6=Cascading/Summed
7=Date Range
8=Price Rule Source
9=Price Rule Type
F=[Folder]
17 EOEP_ARB_VALUE Character(30) VARCHAR2(30) NOT NULL Arbitration Value
18 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field
19 EOEP_CHAR_LONG Long Character CLOB EOEP Character Long
20 EOEP_COND_SEQ Number(10,0) DECIMAL(10) NOT NULL Price Condition Sequence
21 EOEP_CONDCONJ_ID Number(10,0) DECIMAL(10) NOT NULL Condition Conjunction ID
22 EOEP_CUR_CD_PREV Character(3) VARCHAR2(3) NOT NULL Currency Code
23 EOEP_KEY_CD Character(50) VARCHAR2(50) NOT NULL Price Rule Key Code
24 EOEP_KEY_FLD_CD Character(3) VARCHAR2(3) NOT NULL Key field code
25 EOEP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Operator
<=Less than
<==Less than or equal to
<>=Not equal to
==Equal to
>=Greater than
>==Greater than or equal to
IN=Includes
NI=Does not include
26 EOEP_PRCLST_IDPREV Character(10) VARCHAR2(10) NOT NULL Price List ID
27 EOEP_PROD_ID_PREV Character(18) VARCHAR2(18) NOT NULL Product ID
28 EOEP_RCR_FLG_PREV Character(1) VARCHAR2(1) NOT NULL Recurring
29 EOEP_RCR_FREQ_PREV Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
30 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
31 EOEP_RULE_ID_CUR Character(30) VARCHAR2(30) NOT NULL Price Rule
32 EOEP_RULE_ID_PREV Character(30) VARCHAR2(30) NOT NULL Price Rule
33 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
D=Deployed
I=Inactive
P=Pending
R=Ready To Test
34 EOEP_SETID_PREV Character(5) VARCHAR2(5) NOT NULL SetID
35 EOEP_START_DT_PREV Date(10) DATE Start Date
36 EOEP_UOM_PREV Character(3) VARCHAR2(3) NOT NULL Unit of Measure
37 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
38 RECURRING_FLG Character(1) VARCHAR2(1) NOT NULL Recurring Flag
N=No
Y=Yes
39 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
40 SETID Character(5) VARCHAR2(5) NOT NULL SetID
41 SETID_CUR Character(5) VARCHAR2(5) NOT NULL SetID
42 SETID_PREV Character(5) VARCHAR2(5) NOT NULL SetID
43 START_DT Date(10) DATE Start Date
44 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
45 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: PROD_UOM