2022/5/17 13:44:42 打印sql:select fo.FBILLNO 销售订单号,fo.F_ZZZZ_TEXT7 联系人,fo.FRECEIVEADDRESS 收货方地址,fm1.FOLDNUMBER 销售物料名称,fo.F_ZZZZ_TEXT 包装方式,fu.FDATAVALUE 花型,fu1.FDATAVALUE 墙咔缝,a.HQty 数量,a.HBarCode 箱号,fo.F_ZZZZ_WBBZ 外包备注 from Gy_BarCodeBill a left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID where a.HItemID in ('30983')
|
