on 06-21-2013 12:05 AM
Buenas tardes
Alguien a trabajado con TN con determinado usuarios, es decir solo se ejecuten para ciertos usuarios?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gracias por la ayuda Amigo. logre hacer los TNs con la informacion de ese Post. comparto el codigo del TN:
IF @object_type=2 AND @transaction_type in ('A','U')
BEGIN
IF
(SELECT T0.CardType FROM OCRD T0 WHERE T0.CardCode=@list_of_cols_val_tab_del ) <> 'S'
BEGIN
DECLARE @USER as Nvarchar (25)
DECLARE @CPAGO as Nvarchar (25)
DECLARE @LCREDITO Nvarchar (25)
SET @USER = (SELECT T0.userSign FROM OCRD T0 WHERE T0.CardCode = @list_of_cols_val_tab_del)
SET @CPAGO = (SELECT T0.GroupNum FROM OCRD T0 WHERE T0.CardCode = @list_of_cols_val_tab_del)
SET @LCREDITO = (SELECT T0.CreditLine FROM OCRD T0 WHERE T0.CardCode = @list_of_cols_val_tab_del)
END
IF (@USER IN (1)) AND ((@CPAGO <> '-1') OR (@LCREDITO <>'0.000000'))
BEGIN
SET @error = 201
SET @error_message = 'No tiene autorizacion para establecer condicion de pago ni limite de Credito -Feliz da!'
END
END
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.