RF_SO_PRICE_VW

(SQL View)
 Index Back

Service Price

This view displays the on-demand service price on the secondary page of Service Order.

SELECT SETID ,SERVICE_ID ,PURCHASE_OPTN ,RATE_APPLIES_TO ,PRODUCT_ID ,SVC_UNIT_TYPE ,ACTIVITY_CODE ,PREPAID_QTY ,CURRENCY_CD ,RATE_AMOUNT FROM PS_RF_SVC_PRICE WHERE RATE_APPLIES_TO = 'DMND'

# 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.

Prompt Table: SP_SETID_NONVW

2 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

Prompt Table: RF_SVC_SRCH_VW

3 PURCHASE_OPTN Character(4) VARCHAR2(4) NOT NULL This field is used to represent the purchase option (used in agreement pricing)
FLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material
4 RATE_APPLIES_TO Character(4) VARCHAR2(4) NOT NULL This field is used to represent what the rate applies to for agreement pricing (i.e. whether the rate is used for agreement transactions, on-demand transactions, etc.)
AGCS=Agreement Case
AGRT=Agreement
AGSV=Agreement Service
DMCS=On Demand Case
DMND=On Demand Service
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: %EDITTABLE

6 SVC_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to represent the transaction price unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
7 ACTIVITY_CODE Character(8) VARCHAR2(8) NOT NULL Activity Code which identifies the specific Activities which will be performed as part of Service Orders.

Prompt Table: RF_ACT_CODE_VW3

8 PREPAID_QTY Number(6,0) INTEGER NOT NULL This field is used to store the Prepaid Quantity.
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

10 RATE_AMOUNT Number(11,4) DECIMAL(10,4) NOT NULL Rate Amount