Hello I took your code and made the following changes to it

--Create Temp table to load converted data

Create Table #Temp

(

col1 char(1),

Trans char(3),

Actnumb char(10),

Vchnmbr char(20),

Docamnt int,

Docdate char(8),

Docnumb char(20),

Vndchknm char(64),

Voided int

)

INSERT #Temp

select 'D', '001', '1714827671', b.VCHRNMBR, (b.DOCAMNT * 100), --Remove the Decimal Points

--Convert the date to YYYYDDMM format

CONVERT(VARCHAR(8), CONVERT(VARCHAR(4), YEAR(b.DOCDATE))+ RIGHT( CONVERT(VARCHAR(2), DATEPART(dd, b.DOCDATE)),3) + RIGHT('0' + CONVERT(VARCHAR(2), DATEPART(mm, b.DOCDATE)), 2)) as Docdate,

b.DOCNUMBR, d.VNDCHKNM, b.VOIDED, b.DOCDATE

from CM00100 as a

inner join PM30200 as b

on a.CHEKBKID = b.CHEKBKID

inner join PM00200 as d

on b.VENDORID = d.VENDORID

and a.CHEKBKID = 'USD_RBC_PAY'

Select * from #Temp

Drop Table #Temp