【应用场景】

查阅仓位相关的数据表格。

【操作步骤】

登录星空数据中心所在数据库服务器，执行SQL进行查询。

<1>仓库

/*仓库*/

SELECT b.FNAME AS 仓库名称,a.FNUMBER AS 仓库编码,a.FSTOCKID AS 仓库内码,* 

FROM T_BD_STOCK a

LEFT JOIN T_BD_STOCK_L b ON a.FSTOCKID=b.FSTOCKID AND b.FLOCALEID=2052

<2>仓库的仓位值集

/*仓库已启用仓位值集*/

SELECT b.FNAME AS 仓库名称,d.FNAME AS 仓位值集名称,* 

FROM T_BD_STOCK a

LEFT JOIN T_BD_STOCK_L b ON a.FSTOCKID=b.FSTOCKID AND b.FLOCALEID=2052

LEFT JOIN T_BD_STOCKFLEXITEM c ON a.FSTOCKID=c.FSTOCKID

LEFT JOIN T_BAS_FLEXVALUES_L d ON c.FFLEXID=d.FID AND d.FLOCALEID=2052

WHERE b.FNAME='仓位仓'

<3>仓位值集类型

/*仓位值集类型*/

SELECT b.FNAME AS 仓位值集名称,a.FNUMBER AS 仓位值集编码,a.FID AS 仓位值集内码,* 

FROM T_BAS_FLEXVALUES a

LEFT JOIN T_BAS_FLEXVALUES_L b ON a.FID=b.FID AND b.FLOCALEID=2052

<4>仓位值集维度数据

/*仓位值集维度数据*/

SELECT * FROM T_BAS_FLEXVALUESDETAIL

---------------------------------------------------------------------------------------------------------

【金蝶云星空BOS二次开发案例演示】https://vip.kingdee.com/article/94751030918525696