Skip to Content
0
Jul 21, 2016 at 06:37 AM

Sp Transaction Notification

89 Views

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