PV_VNDSRCH_DTTM(SQL View) |
Index Back |
---|---|
SupplierLast Updated dttmSupplier 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 |