RF_INSPRDORD_VW(SQL View) |
Index Back |
|---|---|
Installed Service to OrderThis record is created for fixing pricing issues in installed product |
| SELECT A.SETID , A.INST_PROD_ID , A.CAPTURE_ID , A.PARENT_INST_PRODID , A.RECUR_PRICE , A.PRICE , B.INST_PROD_STATUS , C.UID20 , C.BUSINESS_UNIT , C.PPRC_RECUR_FREQ FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_RO_LINE C WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND A.CAPTURE_ID = C.CAPTURE_ID AND A.LINE_NBR = C.LINE_NBR |
| # | 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 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 3 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 4 | PARENT_INST_PRODID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to store the installed product ID of the parent installed product |
| 5 | RECUR_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Recurring Price |
| 6 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 7 | INST_PROD_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Status of an installed product. |
| 8 | UID20 | Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | PPRC_RECUR_FREQ | Character(2) | VARCHAR2(2) NOT NULL |
Field used to store the recurring frequency.
00=Daily 05=Weekly 10=Monthly 15=Quarterly 20=Annually |