33 lines
906 B
SQL
33 lines
906 B
SQL
SELECT * FROM OPENQUERY(usavmsql01, '
|
|
SELECT
|
|
d.[DOCTYPE] AS doctype,
|
|
RTRIM(d.[VCHRNMBR]) AS vchrnmbr,
|
|
d.[DSTSQNUM] AS dstsqnum,
|
|
d.[CNTRLTYP] AS cntrltyp,
|
|
d.[CRDTAMNT] AS crdtamnt,
|
|
d.[DEBITAMT] AS debitamt,
|
|
d.[DSTINDX] AS dstindx,
|
|
d.[DISTTYPE] AS disttype,
|
|
d.[CHANGED] AS changed,
|
|
RTRIM(d.[USERID]) AS userid,
|
|
d.[PSTGSTUS] AS pstgstus,
|
|
RTRIM(d.[VENDORID]) AS vendorid,
|
|
RTRIM(d.[TRXSORCE]) AS trxsorce,
|
|
d.[PSTGDATE] AS pstgdate,
|
|
RTRIM(d.[CURNCYID]) AS curncyid,
|
|
d.[CURRNIDX] AS currnidx,
|
|
d.[ORCRDAMT] AS orcrdamt,
|
|
d.[ORDBTAMT] AS ordbtamt,
|
|
RTRIM(d.[APTVCHNM]) AS aptvchnm,
|
|
d.[APTODCTY] AS aptodcty,
|
|
d.[SPCLDIST] AS spcldist,
|
|
RTRIM(d.[DistRef]) AS distref,
|
|
d.[DEX_ROW_ID] AS dex_row_id
|
|
FROM CHG.dbo.PM30600 d
|
|
WHERE EXISTS (
|
|
SELECT 1 FROM CHG.dbo.PM30200 p
|
|
WHERE p.VCHRNMBR = d.VCHRNMBR AND p.DOCTYPE = d.DOCTYPE
|
|
AND p.[DEX_ROW_TS] > ''{pm30600_ts}''
|
|
)
|
|
')
|