RX_CATSRCH2_VW(SQL View) |
Index Back |
---|---|
Catalog Search ExternalThis record is used for catalog search external |
SELECT A.SETID , A.PRODUCT_ID , A.CATALOG_ID_NUM , A.RO_FLAG , C.DESCR , C.MODEL_NBR , C.PROD_BRAND , C.PROD_CATEGORY , C.DESCR254 , C.ORDERABLE , B.DESCR_EXT , B.DESCRLONG_EXT ,C.PROD_REGION_FLAG ,D.UNIT_OF_MEASURE , %subrec(RB_AUDIT_SBR, B) FROM PS_RO_CATPRD_CACHE A LEFT OUTER JOIN PS_PROD_UOM D ON A.PRODUCT_ID = D.PRODUCT_ID AND A.SETID = D.SETID AND D.DFLT_UOM = 'Y' , PS_PROD_EXT_DESCR B , PS_PROD_ITEM C WHERE A.PRODUCT_ID = B.PRODUCT_ID AND A.SETID = B.SETID AND B.PRODUCT_ID = C.PRODUCT_ID AND B.SETID = C.SETID AND C.ORDERABLE <> 'N' |
# | 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 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
3 | CATALOG_ID_NUM | Number(5,0) | INTEGER NOT NULL | Catalog ID |
4 | RO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This is a Order Capture flag, used in Catalog.
A=Active I=Inactive |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | MODEL_NBR | Character(18) | VARCHAR2(18) NOT NULL | Model number field to store model number value. |
7 | PROD_BRAND | Character(15) | VARCHAR2(15) NOT NULL |
Product Brand
Prompt Table: PROD_BRAND_TBL |
8 | PROD_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL |
Product Category
Prompt Table: PROD_CATGRY_TBL |
9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
10 | ORDERABLE | Character(1) | VARCHAR2(1) NOT NULL |
Orderable By
A=All B=Business C=Consumer N=None |
11 | DESCR_EXT | Character(50) | VARCHAR2(50) NOT NULL | External Description |
12 | DESCRLONG_EXT | Long Character | CLOB | Long External Description |
13 | PROD_REGION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Product Region Flag for PROD_ITEM
A=All Regions E=All except Regions below I=Only in Regions below |
14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage |
15 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
16 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
17 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
18 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
19 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
20 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |