SubInventory Locator Tables

               

Relationship


MTL_SECONDARY_INVENTORIES

MTL_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory,

i.e., raw material, finished goods, etc. Subinventories areassigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory.
Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservabletype.
You can also specify whether this subinventory is anexpense or asset subinventory (ASSET_INVENTORY), or whether quantities are tracked (QUANTITY_TRACKED).

 

Locator Control Code

                       
LOOKUP_TYPELOOKUP_CODEMEANING
MTL_LOCATION_CONTROL3    Dynamic entry locator control
MTL_LOCATION_CONTROL5    Locator control determined at item level
MTL_LOCATION_CONTROL4    Locator control determined at subinventory level
MTL_LOCATION_CONTROL1    No locator control
MTL_LOCATION_CONTROL2    Prespecified locator control


MTL_ITEM_SUB_INVENTORIES

MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.

These subinventories make up the list of valid subinventories when transacting this specific item and the user has specified (in the master window) that the item must use subinventories restricted to a pre-defined list.



MTL_ITEM_LOCATIONS

MTL_ITEM_LOCATIONS is the definition table for stock locators. The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc.
.
The locator is a key flexfield. The Flexfield Code is MTLL.

This Table is use to record the definition of Locator(Though this table name is defined so confusing)

 


MTL_SECONDARY_LOCATORS

MTL_SECONDARY_LOCATORS stores all locators within a subinventory for a specific item.
These locators make up the valid list of locators when transacting that specific item to/from the subinventory, and theuser has specified (in the Master Item window) that the item must use locators restricted to a pre-defined list.

This Table is use to record the relation of Item, Subinventory and Locator,U can refer below picture

 

 

1.     Define a subinv,andset locator control to ‘pre-defined’

2.     Define a locator at locatorform

You will find there will generate a newrecord in Table: MTL_ITEM_LOCATIONS

But in table: MTL_SECONDARY_LOCATORS,there still not record about this new locator.


 Define a plain Subinventory,Then check mtl_second_inventory,foundrelated record created.

SELECT * FROM MTL_SECONDARY_INVENTORIES WHERE secondary_inventory_name = 'ptsub_01';

--One record returned

SELECT * FROM MTL_ITEM_SUB_INVENTORIES WHERE secondary_inventory = 'ptsub_01';

--No record returned.


SELECT * FROM MTL_SECONDARY_INVENTORIESWHERE secondary_inventory_name = 'ptsub_01';

--One record returned

SELECT * FROM MTL_ITEM_SUB_INVENTORIESWHERE secondary_inventory = 'ptsub_01';

--One record returned


 

SELECT * FROM MTL_ITEM_LOCATIONS WHERE subinventory_code = 'ptsub_01'

--two records returned(inventory_item_id = null)

 

SELECT * FROM MTL_SECONDARY_LOCATORS WHERE subinventory_code = 'ptsub_01'

--no rows return



SELECT inventory_item_id FROM MTL_ITEM_LOCATIONS WHERE subinventory_code ='ptsub_01'

--two records returned (inventory_item_id = null)

 

SELECT * FROM MTL_SECONDARY_LOCATORS WHERE subinventory_code = 'ptsub_01'

--two records returned

 

 


           

再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值