<MCX_CONNECT_SERVER maxxprod>
<MCX_QUERY select SUM((ABS(QUANTITY)*UNIT_COST)) from DETAIL,HEADER WHERE DETAIL.ORDER_NUMBER = HEADER.ORDER_NUMBER AND HEADER.ORDER_NUMBER = '<MCX_ENV ONUM>'>
var _ASeventId="<MCX_ENV ONUM>";
var _ASamount="<MCX_RESULT TOTAL>";
var _ASeventType="Sale";
var _ASsourceId="Texas";
<MCX_END_QUERY>