Oracle Inventory - Release 11i.4 Logical Data Model has initialization information initialization information for a inventory adjustment

ITEM CATEGORY TYPE

assigned to an item by

ABC ASSIGNMENT GROUP is class for classifies inventory for

ABC CLASS inventory classification for

CYCLE COUNT

results in results from contains

CYCLE COUNT ADJUSTMENT

ITEM CATALOG GROUP

stores count tabulations in

PHYSICAL INVENTORY

SUBINVENTORY REPLENISH COUNT owned by

COST GROUP owns has assigned to it

owned by

EXTERNAL ORGANIZATION has assigned in for groups basis for

assigned to item

categorizes has owned by attributes generates

categorizes

adjusted by

assigned by

derives

counts items for

CUSTOMER

SUPPLIER

for

owns has based on based on belongs to belongs to has

groups basis for

CUSTOMER SITE sells to attributes for adjusts source of results from for generates replenished from assigns derived from assigns

SUPPLIER SITE

assigned to

has class assignment

group assignment for used in compiled for

item assigned to

tabulates count for contained in grouped count for

describe location of

ITEM CATEGORY PO COMMODITY CODE owned by assigned to an item by

ABC ASSIGNMENT GROUP CLASS

ABC ASSIGNMENT

CYCLE COUNT CLASS

CYCLE COUNT ITEM

PHYSICAL INVENTORY ITEM COUNT

PHYSICAL INVENTORY ADJUSTMENT

located

ITEM REPLENISH COUNT

replenished from

COST GROUP ASSIGNMENT

HR LOCATION has source having

is location for is located at

replenishes

replenishes replenishes is destination for

abc assignment for

owned by

effects cycle count for adjusts count of adjusts located at count charges for for adjustment to

owns is source for owns container items for

container items belong to

categorizes located at has default model of assigns category from assigns category type from belongs to has abc assignment is categorized by

is categorized by is cycle counted as on has has primary UOM of is based on has has status is detail container for is sourced from is master container for has model is produced as is issued has from has instance has has revision has has has default container is categorized by catalog group counted by default container for count adjusted by has has is reserved by received on is moved by has owns replenishes has has has owns is of owns owns has inventory classification has assigned to it is source for from distribution source org from distribution org to distribution source org to distribution org is destination for used by uses

has destination

CUSTOMER ITEM

default model for

ITEM CATEGORY ASSIGNMENT categorizes is categorized by

ITEM CONTAINER TYPE

ORGANIZATION ITEM

INTERNAL ORGANIZATION BUSINESS GROUP

owns owns has inventory classified by

owned by customer goes into detail container

INVENTORY ORGANIZATION

INTERORG SHIPPING INFORMATION

has

has source of

INTERORG LEAD TIME

has destination

is associated by

goes into master container

is equivalent to has primary UOM of non-base to base unit

LEGAL ENTITY

has status

revised by

is the source for

of belongs to

OPERATING UNIT referenced purchases from owns owned by owns has reserved manages has

source source used by

has stocking area for is source

SHIP METHOD

stores balance for

is a stocking area within has items counted by has source has source is source for assigned to

records inventory adjustment

associates

item belongs to

converts non-base to base units for is a revision of

uses as source has revision of adjusted count having for for is adjustment account for replenished from

has

for

owned by

supplies replenishes

CUSTOMER ITEM CROSS REFERENCE

UOM CONVERSION is equivalent to based on

ITEM REVISION

ORGANIZATION ITEM REVISION

MATERIAL TRANSACTION HISTORY is reserved by

has has belongs to is referenced by has

MFG MATERIAL TRANSACTION MFG MATERIAL ISSUE TXN results in references

ONHAND MATERIAL COST UPDATE TXN ONHAND MATERIAL STD COST UPDATE TXN

PO RECEIPT MATERIAL TXN

source for

for

INVENTORY ONHAND BALANCE at has

SUBINVENTORY

for

KANBAN LOCATION ITEM

having has for is used by

GL ACCOUNT

LICENSE PLATE TRANSACTION results in

replenish source loc replenish demand loc replenish from replenish to replenish to destination for to

receives cost distribution for

for results from

generated by

INTERNAL RECEIPT

LPN TRANSFER TXN LPN UNPACK TXN located at

is reserved by

has location for location for subject of

transfer source is inventory source for inventory destination receives transfer

replenish has

has alias is distribution account for is transportation dist account for

results from replenishes

has inventory source sends inventory to

designated

MFG ORDER COMPLETION TXN

ONHAND MATERIAL AVG COST UPDATE TXN INTERNAL SHIPMENT

having used by

LPN PACK TXN

has transportation dist account is distributed

has a stock location

MFG SCRAP TXN has for instance of has

of

is has balance at

INVENTORY ADJUSTMENT TXN is generated by

is generated by

LOT MERGE

is transacted located at is a stock location within replenish demand loc has source replenish source loc replenish demand loc replenish source loc for replenish to replensih from

FUTURE EFFECTIVE ITEM STATUS assigns UOM CLASS

of has parent

ITEM UNIT of LOT production batch of

RMA TXN transacted by

OTHER MATERIAL TXN

SALES ORDER SHIPMENT MATERIAL TXN

reserves

is located at

location for

for

orders replenishment from has is owned by

LOT SPLIT

is transacted

is alias for

INVENTORY RESERVATION reserved reserves is at has

location has

INVENTORY LOCATOR

KANBAN CARD GL ACCOUNT ALIAS

has

is parent of has parent

SERIAL NUMBER

is stored at has transacted by having

transacts

reserves supply

is for has reserved against it has history is transportation dist account for

is reserved by

transacts is generated by creates included in

having is located at

built by

is distributed by

for

classified by

has history for transportation generates dist account

reserves

reserves for uom reserved by

referenced is location for for stores inventory for receiving location for

is replenished by

having replenished by

reserves has demand source

is reserved against

primary UOM for

is assigned to

has uom

includes

is demand source for

classifies is for

ix txn type

of txn

is of

is received at

transfer from

history for

has

UNIT OF MEASURE basis for

GENEALOGY is forparent

ITEM MODEL UNIT

is a model of used by

INVENTORY TXN SOURCE

has

INVENTORY TRANSACTION TYPE

MATERIAL MOVE ORDER MTL MOVE ORDER PUTAWAY MTL MOVE ORDER ISSUE MTL MOVE ORDER RECEIPT MTL MOVE ORDER PICK WAVE is source of

INVENTORY SUPPLY transfer uses

KANBAN CARD ACTIVITY HISTORY

for

orders replenishment from managed by has source source from

MANUFACTURING LINE

primary UOM for

SERIAL COMPOSITION

created by generates generates

created by

REQUISITION SUPPLY is of has source

INTRANSIT SHIPMENT SUPPLY

UOM for is the ordering unit for

MTL MOVE ORDER REPLENISHMENT

MTL MOVE ORDER BALANCE RECONCILLIATION

MTL MOVE ORDER MOVE

PO SUPPLY

includes is weight UOM for has source UOM of to organization inventoried in UOM to organization

WIP SUPPLY

supplied from

is gross UOM for

is status of is assigned to is for is status for is for distributes

cost is distributed to

replenishes

has

belongs to has has

ITEM STATUS ATTRIBUTE VALUE

for has

ITEM STATUS

AVAILABLE TO PROMISE RULE

PICK RELEASE RULE

MATERIAL MOVE ORDER LINE MFG/MATERIAL TRANSACTION DISTRIBUTION MATERIAL TRANSACTION DISTRIBUTION MFG TRANSACTION DISTRIBUTION has moves archived as transferred MTL MOVE ORD LINE ACCT TFR

MTL MOVE ORD LINE MOVE

MTL MOVE ORD LINE ISSUE

MTL MOVE ORD LINE SUBASSEMBLY MOVE

has

has designated for it has

MTL MOVE ORD LINE UNPACK CONTAINER

MTL MOVE ORD LINE CROSS DOCK

MTL MOVE ORD LINE FIXED ASSET MOVE

MTL MOVE ORD LINE PICK

has

referenced by

MTL MOVE ORD LINE OWNER CHANGE

MTL MOVE ORD LINE RECEIPT

MTL MOVE ORD LINE PUTAWAY

MTL MOVE ORD LINE PACK CONTAINER

has referenced by

uses

supplies

is reserved by split into has split from orders in has is included in for for reserved for

supply for

a parent of a child of creates

generated

has

source for

PROJECT CONTRACT PROJECT

references

SALES ORDER LINE generates MFG ORDER builds RECEIVING TRANSACTION

INBOUND SHIPMENT INTRANSIT INVENTORY SHIPMENT FROM SUPPLIER SHIPMENT BLANKET RELEASE SHIPMENT DISTRIBUTION source for

PURCHASE ORDER SHIPMENT DISTRIBUTION STANDARD PO SHIPMENT DISTRIBUTION

WIP JOB

REPETITIVE SCHEDULE

FLOW SCHEDULE

RETURN TO RECEIVING

INSPECTION

for

has

CORRECTION

RETURN TO VENDOR

is top task for is for stores inventory at

has weight UOM

has gross

INVOICE PO MATCH

RECEIPT

generated

INTERNAL ORDER SHIPMENT

DELIVERY owned by organization composed of

PROJECT TASK has top task

having is parent of

PLANNED PO SCHEDULED SHIPMENT DIST

has parent

contains

in

PLANNED PO SHIPMENT DISTRIBUTION send to

INBOUND SHIPMENT LINE grouped by references container contains container of has subinventory references to have source for is for

DELIVERY LINE split from includes split into

DELIVERY LINE ITEM packed in

DELIVERY LINE CONTAINER contains Click here for instructions on ordering a printing of the diagram from Kinkos
C o p y r ig h t © 2 0 0 0 , 2 0 0 1 O r a c le C o r p o r a tio n . A ll R ig h ts R e s e r v e d T h is lo g ic a l d a ta m o d e l is s u b je c t to c h a n g e w ith o u t n o tic e .