SETIDDefault Value: PROD_ITEM.SETID
PRODUCT_IDPRODUCT_ID_ALTPrompt Table: PRODREL_SRCH_VW
PROD_REL_TYPEPrompt Table: RB_RELATIONS
START_DTDefault Value: %date
END_DTPRIORITY_NBRDefault Value: 0
N=No
Y=Yes
Y/N Table Edit
Y/N Table Edit
RO_PROD_REL_VW(SQL View) |
Index Back |
|---|---|
Product RelationsProduct relations table. used to create prod Relationships. |
| SELECT SETID ,PRODUCT_ID , PRODUCT_ID_ALT , PROD_REL_TYPE , START_DT , END_DT , PRIORITY_NBR , QTY , PRIORITY , PROD_DISPLAY_ORDER , REQUIRED_FLAG , CATALOG_FLG FROM PS_PROD_RELATIONS WHERE START_DT <= %CurrentDateIn AND (END_DT >= %CurrentDateIn OR END_DT IS NULL) |
| # | 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: PROD_ITEM.SETID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | PRODUCT_ID_ALT |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID Alternate
Prompt Table: PRODREL_SRCH_VW |
| 4 | PROD_REL_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Product Relationship Type
Prompt Table: RB_RELATIONS |
| 5 | START_DT |
Date(10) | DATE |
Start date field to store start date value.
Default Value: %date |
| 6 | END_DT |
Date(10) | DATE | This field stores the end date values. |
| 7 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 0 |
| 8 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 9 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 10 | PROD_DISPLAY_ORDER | Number(2,0) | SMALLINT NOT NULL | We (PeopleSoft) plan on setting a 'Display Order' on the service features in a product. That is how we would decide the order to show the service features. Instead of just doing it alphabetically. |
| 11 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes Y/N Table Edit |
| 12 | CATALOG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Catalog
Y/N Table Edit |