InventoryAdjustmentDocument

Entity Definition

Logical Name : InventoryAdjustmentDocument
Physical Name : DO_ADJT_INV

A document that captures an increment or decrement to an item's unit on hand count and/or financial valuation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
InventoryAdjustmentDocumentID (PK) A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts. ID_DCM_INV_ADJT Identity integer
CreationTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_CRT IdentityUUID char(32) InventoryAdjustmentTransaction(TR_INV_ADJT)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnit adjusts inventory levels via InventoryAdjustmentDocument
InventoryAdjustmentTransaction creates InventoryAdjustmentDocument
InventoryAdjustmentDocument includes InventoryAdjustmentLineItem

Logical Views containing InventoryAdjustmentDocument

Logical View
Logical 02010 - Item Inventory - Adjustments View
Logical 02600 - Inventory Control Transaction View
Logical 04300 - Financial Ledger - Inventory Control View