Entity Definition

Logical Name : ItemLot
Physical Name : AS_ITM_LOT

A batch or group of items, often grouped because they were produced or processed at the same time or location. The identification of this grouping may come from the manufacturer. Lots and Batches may also be assigned by the retailer, especially for items produced by the retailer. Examples include dy lots, pharmaceutical lots, bakery batches, fabric lots/bolts.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
ItemLotID (PK) An identifier for a LOT of specific ITEMs. ID_ITM_LOT Identity integer
LotNumber A number or code associated with an item lot. In some cases, the lot number will be populated with a date (common in grocery and deli). A lot number may be assigned by a manufaturer or retailer. Lot numbers may be quite long and are treated here as descriptions to accomodate any length of alphanumeric lot number. DE_NMB_LT DescriptionShort varchar(255)
IssuedByPartyID (FK) A unique, system assigned identity for the Party that issed this particular ItemLot. ID_PRTY_ISS Identity integer Party(PA_PRTY)


Parent Entity Verb Phrase Child Entity
Item is tracked via ItemLot
Party issues ItemLot
ItemLot describes ItemTraceableUnit

Logical Views containing ItemLot

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 02110 - Item Inventory - Location View
Logical 21000 - Fresh Item Management Macro View