Please try to interpret the following mapping description:
if (substring-before(NET__SALES__VALUE(L1),'.')="-0") then
pad-front(concat('-',pad(trim(substring-after(NET__SALES__VALUE(L1),'.')),'2','0')),10,0)
else
pad-front(concat(substring-before(NET__SALES__VALUE(L1),'.'),pad(trim(substring-after(NET__SALES__VALUE(L1),'.')),'2','0')),10,0)
Thanks,
Ramya