辅助属性、仓位的维度关联字段设计规划
--维度
SELECT * FROM T_BD_FLEXSITEMDETAILV t1
INNER join
dbo.T_BD_FLEXAUXPROPERTY_L t2 ON t2.FID = t1.FID AND t2.FLOCALEID=2052
SELECT * FROM dbo.T_BD_FLEXITEMDETAILV WHERE FID=100001
SELECT * FROM dbo.T_BD_FLEXITEMDETAILV WHERE FID=100002
--包装规格
SELECT * FROM dbo.T_BAS_ASSISTANTDATAENTRY t1 WHERE t1.FENTRYID='5eb6092016ad65'
--颜色
SELECT * FROM dbo.T_BAS_ASSISTANTDATAENTRY t1 WHERE t1.FENTRYID='5eb6092016ad6a'
SELECT t3.FNUMBER,t4.FNAME,t1.FFIELDNAME,t2.* FROM dbo.T_BAS_BILLTYPEFLDCTL_L t1
INNER JOIN
T_BAS_BILLTYPEFLDCTL t2 ON t2.FENTRYID = t1.FENTRYID
left JOIN
dbo.T_BAS_BILLTYPE t3 ON t3.FBILLTYPEID = t2.FBILLTYPEID
left JOIN
dbo.T_BAS_BILLTYPE_L t4 ON t4.FLOCALEID=2052 AND t4.FBILLTYPEID=t3.FBILLTYPEID
WHERE t1.FLOCALEID=2052
select * from F_BD_Colour
select * from T_BD_AuxPtyValue
select * from T_BD_AUXPTYVALUEENTITY
select * from T_BD_AUXPTYVALUEENTITY_L
三、 表单引用辅助属性1、 首先在BOS中拖动基础资料字段控件,并把基础资料类型指向物料。2、 BOS中拖动维度关联字段,并把维度关联字段指向当前的物料字段[table]
[tr][td=223] 维度关联字段 [td=537]通常指向"物料"、"仓库"字段
[tr][td=223]维度显示样式[td=537]固定列:物料每一个辅助属性维度都显示一个字段,未启用的不可编辑
弹出列:所有的辅助属性在一个框中显示
[tr][td=223]维度数据表单[td=537]选择维度数据对应的表单:辅助属性
四、 辅助属性表设计