Skip to Content
author's profile photo Former Member
Former Member

Consulta actualización de datos desde OVPM a JDT1

Estimados, buenos dias.

Un gran favor ahora me encuentro realizando una prueba de actualizacion de datos desde la tabla OVPM al detalle de la JDT1, he creado 4 campos de usuario a nivel de PAGOS Y detalle del ASIENTO para el manejo de información requerida por usuarios, estoy realizando las pruebas y esta al parecer no esta aplicando.

mi query lo estoy creando en PostTransaction y esta creado de la sgte. forma. si alguien me pueda apoyar se lo agradeceria..

if @object_type = '46'

begin

Update T0

SET T0.U_CAM_ANOIMPORT= T2.U_CAM_ANOIMP,

T0.U_CAM_NUMIMPORT = T2.U_CAM_NUMIMP,

T0.U_CAM_NUMNACIO = T2.U_CAM_NUMNAC,

T0.U_CAM_NOCSAP = T2.U_DIN_OCSAP

FROM JDT1 T0

INNER JOIN OJDT T1 ON T0.TransId = T1.TransId

INNER JOIN OVPM T2 ON T1.TransId = T2.TransId

INNER JOIN VPM1 T3 ON T2.DocEntry = T3.DocNum --AND T0.Account LIKE '284%'

WHERE T2.DOCENTRY=@list_of_cols_val_tab_del

End

lo que se requiere que los datos llenados en campos de usuario de la tabla OVPM se vean reflejados en la JDT1 solo para una cuenta que es la 28.

quedo a la espera y desde ya gracias por la atención..

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2012 at 05:13 PM

    Hi,

    This is an English forum. Please post is in English.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.