EOEP_APP_OPT_VW (SQL View)	Index Back
Application Code Options

EOEP_APP_OPT_VW

(SQL View)

Application Code Options

SELECT eoep_app_cd , eoep_app_cd_field , %Substring(eoep_trans_value, 1, 1) FROM PS_EOEP_APP_CD_DTL WHERE eoep_app_cd_field = 'APP_CD_OPTIONS'

# 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_APP_CD_OPTION Character(1) VARCHAR2(1) NOT NULL Pricer application code option
1=Use Rule Distribution Accounts
2=Use Payment Terms on Formula
3=Use Period-to-date
4=Use Trade Promotion
5=Use Exclusive Pricing
6=Use One-Time Only Price Rule
7=Use Cost Based Pricing
8=Use Tiered Pricing
9=Use Mutually Exclusive Rule
A=Use Maximum Quantity
B=Use KVI/NDP Products
C=Use Quantity in Price List
D=Use Buying Agreement
E=Use Mathematic Expression
F=Use External Application Class
G=Use Price Index
H=Use Alter Cost Based Pricing

#	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_APP_CD_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Pricer application code option 1=Use Rule Distribution Accounts 2=Use Payment Terms on Formula 3=Use Period-to-date 4=Use Trade Promotion 5=Use Exclusive Pricing 6=Use One-Time Only Price Rule 7=Use Cost Based Pricing 8=Use Tiered Pricing 9=Use Mutually Exclusive Rule A=Use Maximum Quantity B=Use KVI/NDP Products C=Use Quantity in Price List D=Use Buying Agreement E=Use Mathematic Expression F=Use External Application Class G=Use Price Index H=Use Alter Cost Based Pricing