INSERT INTO STOCK (WSTOCKID, SSTOCKCODE, SBARCODENUMBER,
 SDESCRIPTION, WREPORTINGGROUP1ID, WREPORTINGGROUP2ID, WCOSTACCOUNTID,
 WINPUTTAXID, WOUTPUTTAXID, FOPENINGAVECOST, FQTYONHAND, FOPENINGQTY,
 FINVQTYONHAND, FREORDERQTY, WSALESACCOUNTID, BAPPLYINVOICEDISCOUNT,
 WSTOCKACCOUNTID, FSELLINGPRICE1, FSELLINGPRICE2, FSELLINGPRICE3, FUNITAVECOST,
 FUNITCOST, WUNITID, DSYSDATE, BAPPLYTAX, WINPUTTAX2ID, BTAXABLE, WSUPPLIER1ID,
 WSUPPLIER2ID, WSTOCKTYPEID, WOUTPUTTAX2ID, WPROFILEID, BDISABLED, WPERENTID,
 WLOCATIONID, WFILENAMEID, SEXTRADESC, SEXTERNALID, FNETTOWEIGHT, FGROSSWEIGHT,
 FREORDERQTYTRIG, SMANUFACTURER, FMINIMUMQTY, WLOCBATSERTYPEID, SSTOCKCODESUP1, 
SSTOCKCODESUP2)
 VALUES (

gen_id(GEN_STOCKID,1), 
'<@PROCCODE@>', 
'',
'<@DESCRIPT@>',0, 
0, 
<@PROCESS@>@select Waccountid from IMP_LINK where imp_sourceid =<@SOURCEID@> and imp_extid = 'COSTOFS:0' ##, 
0, 
0, 
0, 
0, 
0, 
0, 
0, 
<@PROCESS@>@select Waccountid from IMP_LINK where imp_sourceid =<@SOURCEID@> and imp_extid = 'SALE:0' ##, 
1, 
<@PROCESS@>@select Waccountid from IMP_LINK where imp_sourceid =<@SOURCEID@> and imp_extid = 'STKACC:0' ##, 
<@AMOUNT@>, 
<@AMOUNT@>, 
<@AMOUNT@>,
0, 
0, 
0, 
current_timestamp, 
1, 
0, 
1, 
0, 
0, 
1, 
0, 
0, 
0, 
0, 
0, 
0, 
'', 
'', 
0, 
0, 
0, 
'', 
0, 
0, 
'', 
''
)
@@GO@@