SubInventory Locator Tables

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

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_TYPE	LOOKUP_CODE	MEANING
MTL_LOCATION_CONTROL	3	Dynamic entry locator control
MTL_LOCATION_CONTROL	5	Locator control determined at item level
MTL_LOCATION_CONTROL	4	Locator control determined at subinventory level
MTL_LOCATION_CONTROL	1	No locator control
MTL_LOCATION_CONTROL	2	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

 

 

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow