Relación Deposito-Pago Recibido-Factura

[former_member1188611]

Buen día.

Como puedo relacionar la tablas de Deposito, Pago recibido y Factura?, creo que son: ODPS, ORCT y OINV respectivamente, pero no encuentro el id con el que los pueda relacionar.

Saludos.

[former_member312729 · Accepted solution]

Hi ,

Check on this

SELECT
T0.[DeposDate] ,
T3.CardName AS 'Customer Name',
T3.CardCode AS 'Customer Code',
T1.CheckNum ,
T3.DocNum ,
T1.[DpstAbs] AS 'Deposit No',
T1.BankCode ,
T2.DocNum AS 'Inc Payment'
T0.[DeposNum] 
FROM ODPS T0
INNER JOIN OCHH T1 ON T0.DeposId = T1.DpstAbs
LEFT OUTER JOIN RCT2 T2 ON T1.RcptNum = T2.DocNum
LEFT OUTER JOIN OINV T3ON T2.DocEntry = T3.DocEntry
ORDER BY T3.CardCode

Regards:

Balaji.S

[former_member1188611 · Accepted solution]

Thank you, help me a lot your response. I'm a noob.

[former_member312729]

Hi ,

Check on this

SELECT
T0.[DeposDate] ,
T3.CardName AS 'Customer Name',
T3.CardCode AS 'Customer Code',
T1.CheckNum ,
T3.DocNum ,
T1.[DpstAbs] AS 'Deposit No',
T1.BankCode ,
T2.DocNum AS 'Inc Payment'
T0.[DeposNum] 
FROM ODPS T0
INNER JOIN OCHH T1 ON T0.DeposId = T1.DpstAbs
LEFT OUTER JOIN RCT2 T2 ON T1.RcptNum = T2.DocNum
LEFT OUTER JOIN OINV T3ON T2.DocEntry = T3.DocEntry
ORDER BY T3.CardCode

Regards:

Balaji.S