VIEW prodview WITH transid detnum custid empid tdate model units +
price extprice netamt fgt tax invtotal company frname laname +
address city state zipcode phone frstname lastname prodname +
FROM transd transx custlist salesrep product
 
