Entity Definition

Logical Name : SupplierItem
Physical Name : AS_ITM_SPR

This entity type assigns a supplier-specific item identifier to a retail item and provides the supplier-specific attributes of the item. The supplier item entity type is used to order merchandise items from a supplier price list, catalogue, etc. It provides the supplier's view of an item and uses the supplier's nomenclature in describing the items attributes.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SupplierID (FK)(PK) A unique system assigned identifier for the Supplier. ID_SPR Identity integer Supplier(PA_SPR)
SupplierItemID (PK) The code assigned by the supplier to uniquely identify the ITEM ID_ITM_SPR Identity integer
SupplierRetailSaleUnitCode (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. LU_UOM_RTL Code varchar(20) UnitOfMeasure(CO_UOM)
SupplierLinearMeasureCode (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. LU_UOM_LNR Code varchar(20) UnitOfMeasure(CO_UOM)
CaseUPCEANNumber The UPC/EAN case code, eg UPC/EAN-14, EAN-128. UC_CS_NMB_UPC_EAN ProductCodeGlobal char(14)
Description The description of the SUPPLIER ITEM. DE_ITM_SPR DescriptionShort varchar(255)
ColorDescription The supplier's color description of the SUPPLIER ITEM. DE_CLR DescriptionShort varchar(255)
SizeDescription The size dimensions of the SUPPLIER ITEM. DE_SZ DescriptionShort varchar(255)
StyleDescription The style description of the SUPPLIER ITEM. DE_STYL DescriptionShort varchar(255)
StoreOrderAllowedFlag A flag to indicate that the RETAIL STORE is permitted to order a particular SUPPLIER ITEM. FL_ORD_STR_ALW Flag integer
StoreReceiptAllowedFlag An indicator to signify whether the RETAIL STORE is permitted to receive the SUPPLIER ITEM. FL_RCV_STR_ALW Flag integer
MarketCostOverrideAllowedFlag A flag that indicates (if true) that this SUPPLIER ITEM catalog cost may be superceded by a market cost (known only when the item is received). This flag is intended to support produce, fresh seafood and other perishable items with market costs that vary with every receipt. FL_OVRD_MRK_CST_ALW Flag integer
AvailabilityStatusCode A code to signify the availability of the SUPPLIER ITEM. SC_AVLB_SPR_ITM Code2 char(2)
ResponsibleBuyerID (FK) The buyer responsible for the procurement of this SUPPLIER ITEM. ID_WRKR_BYR_RSP Identity integer Worker(PA_WRKR)
SaleUnitPerPackUnitCount The number of retail sale units in the supplier item pack. For example 24 cans of Coke (the retail sale units) in a case (supplier item pack) or 4 six packs (the retail sale units) in a case (supplier item pack). QU_UN_SLS_PR_PCK Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
Supplier provides SupplierItem
Worker buys SupplierItem
UnitOfMeasure validates SupplierItem
UnitOfMeasure validates SupplierItem
SupplierItem is part of ItemSupplierItem
SupplierItem is assigned a cost by SupplierItemCatalogBaseCost
SupplierItem is transferred/ordered/received via ICDMerchandiseLineItem
SupplierItem comes from SupplierItemCountryOrigin
SupplierItem is received as SupplierItemReceivingUnit

Logical Views containing SupplierItem

Logical View
Logical 01500 - Item Supplier View
Logical 01501 - Item Unit of Measure Types
Logical 02100 - Item Inventory - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 21000 - Fresh Item Management Macro View