INSERT payment 
values( - <@WACCOUNTID@>,
339 ,
now(),
<@AMT@>,
'','','',0,
<@PROCESS@>@select substring(IMP_EXTID from 5 for 12) from IMP_LINK where WACCOUNTID = <@WACCOUNTID@> and imp_sourceid =<@SOURCEID@> and IMP_EXTID like 'DEB:%' ## , 
0 , now(),0)
@@GO@@
INSERT INTO paysplit VALUES( - <@WACCOUNTID@>, <@AMT@> ,<@PROCESS@>@select substring(IMP_EXTID from 5 for 12) from IMP_LINK where WACCOUNTID = <@WACCOUNTID@> and imp_sourceid =<@SOURCEID@> and IMP_EXTID like 'DEB:%' ## , 
Now(), - <@WACCOUNTID@>, 0, 0, 1, 0, Now(), 0, Now(), 0, 0)
@@GO@@

INSERT payment 
values( - (1000000 + <@WACCOUNTID@>),
339 ,
now(),
-<@AMT@>,
'','','',0,
<@PROCESS@>@select substring(IMP_EXTID from 5 for 12) from IMP_LINK where WACCOUNTID = <@WACCOUNTID@> and imp_sourceid =<@SOURCEID@> and IMP_EXTID like 'DEB:%' ## , 
0 , now(),0)
@@GO@@
INSERT INTO paysplit VALUES(  - (1000000 + <@WACCOUNTID@>), -<@AMT@> ,<@PROCESS@>@select substring(IMP_EXTID from 5 for 12) from IMP_LINK where WACCOUNTID = <@WACCOUNTID@> and imp_sourceid =<@SOURCEID@> and IMP_EXTID like 'DEB:%' ## , 
Now(),  - (1000000 + <@WACCOUNTID@>), 0, 0, 1, 0, Now(), 0, Now(), 0, 0)
@@GO@@


