Entity Definition

Logical Name : StockItem
Physical Name : AS_ITM_STK

A unit of merchandise that may be sold to a customer or used by the RETAIL STORE.

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)
SizeFamilyID (FK) A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. ID_SZ_FMY Identity integer Size(CO_SZ)
SizeCode (FK) A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRMA to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. CD_SZ Code6 char(6) Size(CO_SZ)
StyleCode (FK) A code that uniquely identifies the specific appearance type or variety in which an APPAREL ITEM is available. LU_STYL Code4 char(4) Style(CO_STYL)
ColorCode (FK) A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers CD_CLR Code4 char(4) Color(CO_CLR)
Counting (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM_RTL_SL_UN Code varchar(20) UnitOfMeasure(CO_UOM)
StockItemTypeCode A retailer assigned code to indicate the StockItem type, ie ShelfItem, ApparelItem, SerializedItem, etc. TY_ITM_STK Code2 char(2)
SaleWeightOrUnitCountCode A retailer assigned code that indicates whether the StockItem is sold by weight or as an unit. LU_CNT_SLS_WT_UN Code2 char(2)
CustomerPickupTypeCode A retailer assigned code that defines where and how a customer may pickup this item. For examples a refrigerator may have to be picked up at the shipping dock or at the retailers warehouse. TY_PKP_CT_STK_ITM Code2 char(2)
UnitPriceFactor The number of units of measure per selling unit. Used as the divisor when calculating the STOCK ITEM's unit retail price, eg $1.67 per pound or $2.59 for 32 floz. FA_PRC_UN_STK_ITM Quantity DECIMAL(9,3)
AvailableForSaleDate The date when this STOCK ITEM becomes available for sale. For example, certain books have specific publication dates, music entertainment release dates. DC_AVLB_FR_SLS DateCalendar date
EnvironmentTypeCode A retailer assigned code that defines the temperature, relative humidity, lighting and other physical or climatic environmental requirements for storing and displaying the item. TY_ENV_STK_ITM Code2 char(2)
SecurityRequiredTypeCode A retailer assigned code that defines the security environment and procedures required for receiving, displaying and selling the item. This is for high-priced merchandise like jewelry, certain prescription drugs, ordinance, fireworks, etc. TY_SCTY_RQ Code2 char(2)
HazardousMaterialTypeCode A retailer assigned code that defines the relevant hazardous material handling properties of the item. This code is provided for oil products, petsicides, swimming pool suppliers, fertilizers (especially bomb grade), etc. TY_MTR_HZ_STK_ITM Code2 char(2)
InventoryAccountingMethodCode A retailer assigned code that defines the inventory accounting method to be used for the item. Examples of methods include the retail method, cost method, etc. LU_MTH_INV_ACNT Code2 char(2)
SellUnitLastReceivedBaseCostAmount The base cost per sell unit derived from the last receipt of this item. The base cost excludes allowances, discounts, charges and other amounts that may change the item cost. CP_UN_SL_LS_RCV_BS MoneyShortCost decimal(16,5)
SellUnitLastReceivedNetCostAmount The net cost per sell unit derived from the last receipt of this item. The base cost includes allowances, discounts, charges and other amounts that may change the item cost. Where there are no allowances, etc. the net cost will equal the base cost for an item. CP_CST_NT_LS_RCV MoneyShortCost decimal(16,5)
SellUnitLandedCostAmount The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. which add up to the full delivered cost of an imported item to the store. CP_UN_SL_LND MoneyShortCost decimal(16,5)
SellUnitLastReceivedCostsEstablishedDate The date the last received costs (net and base) were established. DC_CST_EST_LS_RCV DateCalendar date
ShrinkFlag A flad to denote if the STOCK ITEM could loose weight from the time of order until the time of receipt. FL_SHRK_SH_ITM Flag integer
SwellFlag A flag used to indicate if the STOCK ITEM may gain weight or swell from time of order to time of receipt. FL_SWL_SH_ITM Flag integer
RetailPackageSize (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM_RTL_PKG_SZ Code varchar(20) UnitOfMeasure(CO_UOM)


Parent Entity Verb Phrase Child Entity
Size defines StockItem
Style defines StockItem
Color defines StockItem
UnitOfMeasure defines retail pkg size units StockItem
UnitOfMeasure defines counting units for StockItem
StockItem isa BulkItem
StockItem is transfered via InventoryAdjustmentLineItem
StockItem isa SerializedItem
StockItem is tracked in ItemInventory
StockItem describes StockItemConsumerProductLabel
StockItem is managed via PhysicalCountLineItem
StockItem isa DisplayUnitItem
StockItem isa ShelfItem
StockItem is actually GiftCertificateClass
StockItem isa ApparelItem
StockItem isa FuelItem
Item can be a StockItem

Logical Views containing StockItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01015 - Item Description - Apparel View
Logical 01020 - Item Description - Enterprise View
Logical 01040 - Item Description - Rental View
Logical 01050 - Item Description - Labelling View
Logical 01100 - Item Selling Rules - Macro View
Logical 01500 - Item Supplier View
Logical 01501 - Item Unit of Measure Types
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02020 - Item Inventory - Selling View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 02395 - Retail Transaction - Deposit Redemption View
Logical 02600 - Inventory Control Transaction View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 07040 - Customer Segment Dependent Behavior
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20050 - Forecourt Tank Gauge View
Logical 21000 - Fresh Item Management Macro View