General Ledger Delete GLTFSDEF Records for Missing Groups

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
delete from gltfsdef fs
 WHERE CMDNO IN (1,3) AND PARAM1_TYPE=3 AND NOT EXISTS ( SELECT GROUP_ID FROM  gltacgrp  g WHERE g.group_id=fs.param1)