从金蝶EAS系统库存台账中查询即时库存数据,包含信息:物料编码、物料名称、基本单位、基本数量、库存组织编码、库存组织名称。
/**
* 拼接库存查询脚本(物料表别名mater)
* @param orgNumber 库存组织编码
* @param filters 查询条件部分(where)
* @return 返回完整的查询语句
*
*/
private String getInventorySql(String orgNumber, String filters) {
StringBuffer sql = new StringBuffer();
sql.append("select mater.FNumber, mater.FName_L2 FMaterialName,").append("\n");
sql.append("unit.FName_L2 FUnit, inv.FBaseQty FQuantity,").append("\n");
sql.append("org.FNumber FOrgNumber, org.FName_L2 FOrgName").append("\n");
sql.append("from T_IM_Inventory inv").append("\n"); //库存台账
sql.append("inner join T_BD_Material mater on inv.FMaterialID = mater.FID").append("\n"); //物料
sql.append("inner join T_BD_MeasureUnit unit on inv.FBaseUnitID = unit.FID").append("\n"); //计量单位
sql.append("inner join T_ORG_Storage org on inv.FStorageOrgUnitID = org.FID").append("\n"); //库存组织
sql.append(filters).append("\n"); //物料编码
sql.append("and org.FNumber = '").append(orgNumber).append("'"); //库存组织
return sql.toString();
}