Hi Peter,
Thanks for your reply and it's JDE Table trigger.
Please find the below code and let me know if am wrong.
=============================================
TBLE: F0115
Event: Before Record is Deleted
Event GUID: 59425975-4277-455c-ae4e-b5c56e9aaeca
=============================================
----------------------------------------
Event Level Variables
----------------------------------------
evt_szCacheActionCode_CACTN [CACTN]
evt_szUserId_USER [USER]
evt_jdDateUpdated_UPMJ [UPMJ]
evt_szTimeLastUpdated_UPMT [UPMT]
evt_szWorkStationId_JOBN [JOBN]
evt_szPhoneNumber_PH1 [PH1]
----------------------------------------
00001 GetAuditInfo(B9800100.GetAuditInfo)
VA evt_szUserId_USER [USER] <- szUserName [USER]
VA evt_jdDateUpdated_UPMJ [UPMJ] <- jdDate [DTE]
VA evt_szTimeLastUpdated_UPMT [UPMT] <- mnTime [TME0]
VA evt_szWorkStationId_JOBN [JOBN] <- szWorkstation_UserId [JOBN]
00002 VA evt_szCacheActionCode_CACTN [CACTN] = "D"
00003 F0115.FetchSingle [Index 1: Address #, Line #, +]
TK Address Number [AN8] = TK Address Number [AN8]
VA evt_szPhoneNumber_PH1 [PH1] <- TK Phone Number [PH1]
00004 F550115B.Insert [Index 1: AN8,UPMJ,UPMT,CACTN]
TK Address Number [AN8] -> TK Address Number [AN8]
VA evt_szPhoneNumber_PH1 [PH1] -> TK Phone Number [PH1]
VA evt_szUserId_USER [USER] -> TK User ID [USER]
TK Program ID [PID] -> TK Program ID [PID]
VA evt_jdDateUpdated_UPMJ [UPMJ] -> TK Date - Updated [UPMJ]
VA evt_szTimeLastUpdated_UPMT [UPMT] -> TK Time - Last Updated [UPMT]
VA evt_szCacheActionCode_CACTN [CACTN] -> TK Cache Action Code [CACTN]
VA evt_szWorkStationId_JOBN [JOBN] -> TK Work Station ID [JOBN]
The same code is working for F01151,F0116,F0101. I tried passing all TK values into table instead of fetching but no use .
Thanks,
Deva