EOEP_APP_ACT_VW (SQL View)	Index Back
Application Code Action Types

EOEP_APP_ACT_VW

(SQL View)

Application Code Action Types

SELECT eoep_app_cd , eoep_app_cd_field , %Substring(eoep_trans_value, 1, 2) 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=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=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

#	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=CRM Free Period Promotion 11=CRM Product Add 12=Pricing Base 13=Rollup Only Rule 14=Min/Max Margin 2=Price Override 3=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