EOEP_APP_ACT_VW

(SQL View)
 Index Back

Application Code Action Types

View for Application Code Action Types.

SELECT eoep_app_cd , eoep_app_cd_field , %Substring(eoep_trans_value, 1, 2) ,EOEP_RECUR_FLG FROM PS_EOEP_APP_CD_DTL WHERE eoep_app_cd_field = 'ACTION_TYPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCD_VW

2 EOEP_APP_CD_FIELD Character(30) VARCHAR2(30) NOT NULL Transaction Code Field
3 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
1=Discount/Surcharge
10=Free Period Promotion
11=Product Add
12=Price Base
13=Rollup Only Rule
14=Min/Max Margin
15=Recurring Discount/Surcharge
2=Price Override
3=Giveaway / Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
4 EOEP_RECUR_FLG Character(1) VARCHAR2(1) NOT NULL Recurring price flag.
N=No
Y=Yes

Default Value: N