TR_BANKACCOUNT_PDACCOUNTSEGMENTVALUEID_ISACCOUNTCODE (Trigger)

        
CREATE trigger dbo.TR_BANKACCOUNT_PDACCOUNTSEGMENTVALUEID_ISACCOUNTCODE on BANKACCOUNT for INSERT, UPDATE not for replication as
begin
  set nocount on;
  
  if exists(
    SELECT I.ID
    FROM INSERTED I
    INNER JOIN dbo.PDACCOUNTSEGMENTVALUE V ON V.ID = I.PDACCOUNTSEGMENTVALUEID
    INNER JOIN dbo.PDACCOUNTSTRUCTURE S ON S.ID = V.PDACCOUNTSTRUCTUREID
    WHERE S.SEGMENTTYPE <> 1)
  BEGIN
    RAISERROR ('The cash code must be a GL account code', 16, 1)
    ROLLBACK
  END
end