HI Richard,
USE [TEST]
GO
INSERT INTO [dbo].[PM10200]
([VENDORID]
,[DOCDATE]
,[DATE1]
,[GLPOSTDT]
,[TIME1]
,[APTVCHNM]
,[APTODCTY]
,[APTODCNM]
,[APTODCDT]
,[ApplyToGLPostDate]
,[CURNCYID]
,[CURRNIDX]
,[APPLDAMT]
,[DISTKNAM]
,[DISAVTKN]
,[WROFAMNT]
,[ORAPPAMT]
,[ORDISTKN]
,[ORDATKN]
,[ORWROFAM]
,[APTOEXRATE]
,[APTODENRATE]
,[APTORTCLCMETH]
,[APTOMCTRXSTT]
,[VCHRNMBR]
,[DOCTYPE]
,[APFRDCNM]
,[ApplyFromGLPostDate]
,[FROMCURR]
,[APFRMAPLYAMT]
,[APFRMDISCTAKEN]
,[APFRMDISCAVAIL]
,[APFRMWROFAMT]
,[ActualApplyToAmount]
,[ActualDiscTakenAmount]
,[ActualDiscAvailTaken]
,[ActualWriteOffAmount]
,[APFRMEXRATE]
,[APFRMDENRATE]
,[APFRMRTCLCMETH]
,[APFRMMCTRXSTT]
,[PPSAMDED]
,[GSTDSAMT]
,[TAXDTLID]
,[POSTED]
,[TEN99AMNT]
,[RLGANLOS]
,[APYFRMRNDAMT]
,[APYTORNDAMT]
,[APYTORNDDISC]
,[OAPYFRMRNDAMT]
,[OAPYTORNDAMT]
,[OAPYTORNDDISC]
,[Settled_Gain_CreditCurrT]
,[Settled_Loss_CreditCurrT]
,[Settled_Gain_DebitCurrTr]
,[Settled_Loss_DebitCurrTr]
,[Settled_Gain_DebitDiscAv]
,[Settled_Loss_DebitDiscAv]
,[Revaluation_Status]
,[Credit1099Amount]
,[DEFTEN99TYPE]
,[DEFTEN99BOXNUMBER])
VALUES
( 'ED15 ',
'2022-12-21 00:00:00.000',
'2023-05-31 00:00:00.000',
'2023-05-31 00:00:00.000',
'1',
'00000000000189315',
'1',
'53031933',
'2023-03-03 00:00:00.000',
'2023-03-15 00:00:00.000',
'Z-US$ ',
'1007',
'27',
'0',
'0',
'0',
'27',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'00000000000140374',
'5',
'50665938',
'2023-12-28 00:00:00.000',
'Z-US$ ',
'27',
'0',
'0',
'0',
'27',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
' 0 ',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'0')
GO
Thanks for your response.
Here you go!
