A useful BaaN Query on BOM(BaaN一个有用的Bom查询)

BaaN里面涉及到Bom的模块为tibom和tcibd(物料基本信息),主要用到的表为:

tibom000 ti bom BOM Parameters
tibom010 ti bom Production BOMs
tibom020 ti bom Reference Designators
tibom030 ti bom Locations
tcibd000 tc ibd Segmentation Parameters
tcibd001 tc ibd General Item Data
tcibd002 tc ibd General Item Data (Defaults)
tcibd003 tc ibd Conversion Factors
tcibd007 tc ibd Item Costing Data
tcibd008 tc ibd Item Costing Data (Defaults)
tcibd011 tc ibd Cost-Component Structure by Item
tcibd012 tc ibd Effective Cost-Component Structure by Item
tcibd099 tc ibd Item Base Parameters
tcibd100 tc ibd Item Inventory
tcibd200 tc ibd Item Ordering Data
tcibd201 tc ibd Item Ordering Data (Defaults)

Multi Level BOM

       select
       tibom010.mitm,         | Manufactured Item
       tibom010.sitm,         | Item
       tibom010.pono,         | Position
       tibom010.seqn,         | Sequence Number
       tibom010.qana,         | Net Quantity
       tibom020.mitm,         | Manufactured Item
       tibom020.pono,         | Position
       tibom020.seqn,         | Sequence Number
       tibom020.lcid,         | Location
       tibom020.qana          | Net Quantity
from
       tibom010,              | Production BOMs
       tibom020               | Reference Designators
where
       tibom010.mitm >= tibom010.mitm.f and
       tibom010.mitm <= tibom010.mitm.t
order by
       tibom010.pono,
       tibom010.seqn

Sigle Level BOM

正在整理中!

发表评论

电子邮件地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据