CATALOG_ID_NUMPrompt Table: RO_PRD_CATALOG
RO_NEST_CAT_VW(SQL View) |
Index Back |
|---|---|
nested catalog viewnested catalog view |
| SELECT A.catalog_id_num , A.NEST_CAT_ID ,B.DESCR FROM PS_RO_NEST_CAT A ,PS_RO_PRD_CATALOG B WHERE A.SETID=B.SETID AND A.NEST_CAT_ID=B.CATALOG_ID_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CATALOG_ID_NUM |
Number(5,0) | INTEGER NOT NULL | Catalog ID |
| 2 | NEST_CAT_ID | Number(5,0) | INTEGER NOT NULL |
Catalog Identification Number
Prompt Table: RO_PRD_CATALOG |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |