EOEP_ARBDEC_VW (SQL View)	Index Back
Arb decision by trans Arb decision by trans

EOEP_ARBDEC_VW

(SQL View)

Arb decision by trans

SELECT DISTINCT D.EOEP_APP_CD , %Substring(X.FIELDVALUE ,1 ,2) , X.EFFDT , X.EFF_STATUS , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEM X WHERE D.EOEP_APP_CD_FIELD = 'ACTION_TYPE' AND X.FIELDNAME = 'EOEP_ARB_DECISION' AND ( (X.FIELDVALUE IN ('2','3','5','6') AND D.EOEP_TRANS_VALUE IN ('1','4')) OR (X.FIELDVALUE IN ('7','8') AND D.EOEP_TRANS_VALUE = '2') OR (X.FIELDVALUE IN ('11','12','13','14','15') AND D.EOEP_TRANS_VALUE = '12') OR (X.FIELDVALUE IN ('9','10') AND D.EOEP_TRANS_VALUE IN ('1','2','4')) OR (X.FIELDVALUE IN ('1' ,'4')))

Related Language Record: EOEP_ARBDEC_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EOEP_ARB_DECISION Character(2) VARCHAR2(2) NOT NULL Pricing arbitration decision
1=Rule Name in Ascending Order
10=Lowest Price First
11=Use Highest Base
12=Use Lowest Base
13=Use Cost as Base
14=Use List Price as Base
15=Use Alternate Cost as Base
2=Highest Discount First
3=Highest Surcharge First
4=Rule Name in Descending Order
5=Lowest Discount First
6=Lowest Surcharge First
7=Highest Price Override First
8=Lowest Price Override First
9=Highest Price First

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEP_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code
2	EOEP_ARB_DECISION	Character(2)	VARCHAR2(2) NOT NULL	Pricing arbitration decision 1=Rule Name in Ascending Order 10=Lowest Price First 11=Use Highest Base 12=Use Lowest Base 13=Use Cost as Base 14=Use List Price as Base 15=Use Alternate Cost as Base 2=Highest Discount First 3=Highest Surcharge First 4=Rule Name in Descending Order 5=Lowest Discount First 6=Lowest Surcharge First 7=Highest Price Override First 8=Lowest Price Override First 9=Highest Price First
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
6	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name