SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
INST_PROD_IDDefault Value: NEXT
RF_IPRD_QTY_VW2(SQL View) |
Index Back |
|---|---|
Installed Product Qty ViewThis view returns the summed quantity across all status records for a given installed product. |
| SELECT B.SETID , B.INST_PROD_ID , SUM(B.QUANTITY) FROM PS_RF_INST_PROD_ST B GROUP BY B.SETID , B.INST_PROD_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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | INST_PROD_ID |
Character(20) | VARCHAR2(20) NOT NULL |
This field is used to represent the installed product ID (key field)
Default Value: NEXT |
| 3 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |