SETIDPrompt Table: SP_SETID_NONVW
PRODUCT_IDPURCHASE_OPTNFLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material
RF_AG_PURCHP_VW(SQL View) |
Index Back |
|---|---|
Agreement Purchase PromptAgreement Purchase Option prompt view for product prices |
| SELECT DISTINCT A.SETID , A.PRODUCT_ID , A.PURCHASE_OPTN , B.XLATSHORTNAME FROM PS_RF_SVC_PRICE A , PS_RF_XLAT_VW B WHERE B.FIELDVALUE = A.PURCHASE_OPTN AND B.FIELDNAME = 'PURCHASE_OPTN' AND A.RATE_APPLIES_TO IN ('AGRT') AND A.SERVICE_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 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product 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 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |