Hi Everyone,
Can anyone help me in the Sp notification where the condition is "CardName" length should not be greater than 5.
Please find the below Sp Transaction Notification.
If @object_type = '2' and @transaction_type in ( 'A')
BEGIN
If exists (Select I.CardName From OCRD I
Where I.CardFName!=@list_of_key_cols_tab_del AND LEN(I.CardName)<=5)
bEGIN
select @error =12
select @error_message = 'Business Partner Character length is more!!'
END
END
Thanks & regards
Vedanth