/*----------------------------------------------------------------- /*select FBeginTime,FEndTime from T_LS_Retail 1代表已日结 0代表未日结*/ select FGoodsGroupID from T_RT_AllInventory /*sql.append("SELECT sql.append("DISTINCT STORAGEORGUNIT.FID AS ID, sql.append("STORAGEORGUNIT.Fnumber /r/n"); sql.append("FROM T_ORG_Storage AS STORAGEORGUNIT sql.append("INNER JOIN T_ORG_UnitRelation AS RELATIONA sql.append("ON STORAGEORGUNIT.FID = RELATIONA.FFromUnitID sql.append("LEFT OUTER JOIN T_ORG_TypeRelation AS TYPERELATIONA sql.append("ON RELATIONA.FTypeRelationID = TYPERELATIONA.FID sql.append("WHERE STORAGEORGUNIT.FIsBizUnit = 1 AND TYPERELATIONA.FFromType = 4 AND /r/n"); sql.append("TYPERELATIONA.FToType = 2 and RELATIONA.FTOUNITID = '").append(saleOrgUnitId).append sql.append("order by STORAGEORGUNIT.Fnumber desc"); */ select * from T_ORG_UnitRelation select * from T_ORG_Storage ---------------------------------------------------------- select "SaleOrgUnit".fname_l2 from T_ORG_Sale "SaleOrgUnit" inner join T_ORG_UnitRelation "RELATIONA" on "SaleOrgUnit".FID="RELATIONA".Ftounitid and "RELATIONA".Ftounitid='LptYeuxPQM6fKZmdmZtRMsznrtQ=' LEFT OUTER JOIN T_ORG_TypeRelation "TYPERELATIONA" ON "RELATIONA".FTypeRelationID = "TYPERELATIONA".FID where "SaleOrgUnit".FIsBizUnit = 1 ------1代表实体组织 AND "TYPERELATIONA".FFromType = 4 -------委托组织为库存组织 AND "TYPERELATIONA".FToType = 2----------被委托组织为销售组织 select Fsaleprice,"OrgSale".fname_l2 from T_RT_GoodsSales "GoodsSales" left outer join T_ORG_Sale "OrgSale" on "OrgSale".fid="GoodsSales".FSaleOrgID select "GoodsSales".Fsaleprice from T_RT_GoodsSales "GoodsSales" left outer join T_ORG_Sale "OrgSale" on "OrgSale".fid="GoodsSales".FSaleOrgID
EAS库存台账报表细节
最新推荐文章于 2018-08-29 15:26:10 发布