RA_PRCBRK_UM_VW (SQL View)	Index Back
Marketing Price break View Marketing Price break Unit Of Measure View, used as drop down in Marketing Offers

RA_PRCBRK_UM_VW

(SQL View)

Marketing Price break View

Marketing Price break Unit Of Measure View, used as drop down in Marketing Offers

SELECT A.SETID ,A.UNIT_OF_MEASURE ,B.DESCR FROM PS_RA_PRD_UOM_VW A ,PS_UNITS_TBL B WHERE A.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE

Related Language Record: RA_PRCBK_UM_LNV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description