8AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAAAyFg5oJPZ1ElsANQmDqMNSjVHH4/cCgwmD6DRiMEHikwAAAAAOgAAAAAIAACAAAACG2J5rq29MgOfxkppyBNPq6KBwPiT9nAWzyPzXRUYTqTAAAAB9rCu7jriNcedo/3Zjzb61+AwfZmVp3ok2tIhyPl0unj6zVi9vYhRGWWAbntY6VmNAAAAAtjbtpBPSPELu/enmySzefnUiz6j6t0GEqd+i97Bz/2kj9CxcgMOcbyVSTNGlicNnT+EQHetRqZ7fHxVz2jmFiQ0select a.称重时间,a.渠道名称,a.业务员,a.所属客户,a.分公司名称,sum(b.ShippingFee+b.EUTariff+b.AttachFee )运费
from BaseOrderINfo(nolock)a join Finance_Order_Charges(nolock)b
on a.系统单号 = b.SystemNo and b.Offset =0 and b.ChargeTarget=1
and a.渠道名称 like '%快线' and a.称重时间 between '2022-08-01' and '2022-09-01'
group by a.称重时间,a.渠道名称,a.业务员,a.所属客户,a.分公司名称936false20[BaseETL_KXZB]936false3falsefalseTABLOCK,CHECK_CONSTRAINTS2147483647DataSourceViewIDDataSourceViewIDTableInfoObjectTypeTable]]>