CAPTURE_IDLINE_NBRPrompt Table: RF_IPRD_CUST_VW
Default Value: %date
ROT_LINE(SQL View) |
Index Back |
|---|---|
COM extension to RO_LINECOM extension to RO_LINE used in service management |
| SELECT A.CAPTURE_ID , A.LINE_NBR , A.INST_PROD_ID , C.INST_PROD_ID , D.PRODUCT_ID , A.START_DT , A.END_DT FROM PS_RO_LINE A , PS_RO_LINE C , PS_RF_INST_PROD D WHERE A.CAPTURE_ID=C.CAPTURE_ID AND A.PARENT_LINE_NBR=C.LINE_NBR AND C.INST_PROD_ID=D.INST_PROD_ID AND D.SETID =( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE=C.BUSINESS_UNIT AND RECNAME='RF_INST_PROD') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 3 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 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
Prompt Table: RF_IPRD_CUST_VW |
| 5 | RBTSERVICE_ID | Character(18) | VARCHAR2(18) NOT NULL | Service ID used in product model |
| 6 | START_DT | Date(10) | DATE |
Start date field to store start date value.
Default Value: %date |
| 7 | END_DT | Date(10) | DATE | This field stores the end date values. |