Entity Definition

Logical Name : InventoryAdjustmentLineItem
Physical Name : TR_LTM_INV_ADJ

The detail line item on the INVENTORY ADJUSTMENT DOCUMENT which applies an increment or decrement to the ITEM's unit on hand and /or the 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 InventoryAdjustmentDocument(DO_ADJT_INV)
InventoryAdjustmentDocumentID (FK)(PK) A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts. ID_DCM_INV_ADJT Identity integer InventoryAdjustmentDocument(DO_ADJT_INV)
InventoryAdjustmentLineNumber (PK) The line number for a specific line item adjustment. IC_INV_ADJT LineNumber smallint
SourceLocationID (FK) A unique system assigned identifier for the Location. ID_LCN_SRC Identity integer InventoryLocation(LO_LCN_INV)
DestinationLocationID (FK) A unique system assigned identifier for the Location. ID_LCN_DSTN Identity integer InventoryLocation(LO_LCN_INV)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
ReasonCode The reason code for the line item adjustment. RC_INV_ADJT Code2 char(2)
UnitCount The number of units adjusted on this inventory adjustment line item. QU_ITM Quantity DECIMAL(9,3)
AdjustmentDateTime The date and time an adjustment was made. CNT_ADJT AuditDateTime datetime
EntryMethodCode A code that describes how the count was entered (for example, keyed or scanned). LU_MTH_ID_ENR Code2 char(2)


Parent Entity Verb Phrase Child Entity
InventoryAdjustmentDocument includes InventoryAdjustmentLineItem
InventoryLocation is source for InventoryAdjustmentLineItem
StockItem is transfered via InventoryAdjustmentLineItem
InventoryLocation is destination for InventoryAdjustmentLineItem
InventoryAdjustmentLineItem is posted to ItemInventoryJournalEntry

Logical Views containing InventoryAdjustmentLineItem

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02600 - Inventory Control Transaction View
Logical 04000 - Financial Ledger - Macro View
Logical 04300 - Financial Ledger - Inventory Control View