PV_VNDSRCH_DTTM

(SQL View)
Index Back

SupplierLast Updated dttm

Supplier last updated date time consideration for contract update. Used for epro item with vendor Search definition.

SELECT VENDOR_SETID, VENDOR_ID, MAX(LASTSESUPD_DTTM) FROM PS_PV_VNDCNT_UPDTM GROUP BY VENDOR_SETID, VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 LASTSESUPD_DTTM DateTime(26) TIMESTAMP Last Update Datetime