PRD_SRCH_CCSTMP

(SQL Table)
Index Back

Catalog by Cust Prod alias

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 PRODUCT_ALIAS Character(18) VARCHAR2(18) NOT NULL Product Alias
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.