SETIDPrompt Table: SP_SETID_NONVW
SERVICE_IDPURCHASE_OPTNFLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material
CURRENCY_CDPREPAID_QTYCASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
RF_AG_PREPY_VW2(SQL View) |
Index Back |
|---|---|
Agreement Prepaid Opt VwAgreement Prepaid prompt view for Service-only prices (eg without specified Products) |
| SELECT SETID , SERVICE_ID , PURCHASE_OPTN , CURRENCY_CD , PREPAID_QTY , SVC_UNIT_TYPE FROM PS_RF_SVC_PRICE WHERE RATE_APPLIES_TO IN ('AGRT', 'AGSV') AND PURCHASE_OPTN = 'PRPD' AND PRODUCT_ID = ' ' |
| # | 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 |
| 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 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 5 | PREPAID_QTY |
Number(6,0) | INTEGER NOT NULL | This field is used to store the Prepaid Quantity. |
| 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 |