SBO发出商品报表

select'正常发货'as[类型],t0.createdby单号,T2.[CANCELED]单据状态,t0.doclinenum行号,t0.docdate日期,t0.cardcode客户编号,t0.cardname客户名称,t0.itemcode料号,t0.dscription品名,t0.Currency币种,t0.rate汇率,t0.OutQty-t0.InQty数量,t0.CalcPrice成本单价,t0.cogsval成本总额,t0.CostAct发出科目,t1.OpenQty[未清数量],t1.OpenQty*t0.CalcPrice[未清金额],t1.basetype上级单据类