SETIDCUST_IDPRODCTLG_IN2_VW(SQL View) |
Index Back |
|---|---|
Prod Catlg inclusive (prod) |
| SELECT c.setid , c.cust_id , pi.setid , pi.product_id , pi.descr , pct.setid , pct.catalog_nbr , ' ' , ' ' FROM PS_PROD_ITEM pi , ps_prodctlg_prod prc , ps_prodctlg_tbl pct , ps_prodctlg_cust c WHERE pct.setid = ( SELECT setid FROM ps_set_cntrl_rec sc WHERE sc.setcntrlvalue = c.setid AND sc.recname = 'PRODCTLG_TBL') AND pct.catalog_nbr = c.catalog_nbr AND pct.eff_status = 'A' AND %EffdtCheck(prodctlg_tbl pct2, pct, %CurrentDateIn) AND pct.incl_excl_type = 'I' AND prc.setid = pct.setid AND prc.catalog_nbr = c.catalog_nbr AND prc.effdt = pct.effdt AND pi.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue = pct.setid AND recname = 'PRODCTLG_P_SRCH') AND pi.product_id = prc.product_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 4 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SETID_CATALOG | Character(5) | VARCHAR2(5) NOT NULL | Catalog SetID |
| 7 | CATALOG_NBR | Character(18) | VARCHAR2(18) NOT NULL | Catalog Number |
| 8 | SETID_PROD_GRP | Character(5) | VARCHAR2(5) NOT NULL | Product Group SetID |
| 9 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |