Entity Definition

Logical Name : Supplier
Physical Name : PA_SPR

An external party that acts as a source for merchandise and services offered for sale through the RETAIL STORE, or for supplies and services consumed by the store in conducting its business.

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
SupplierIsManufacturerFlag A flag that indicates that this supplier is also the Manufacturer of any items they supply. FL_MF_SPR_IS Flag integer


Parent Entity Verb Phrase Child Entity
Supplier provides SupplierItem
Supplier supplies EquipmentClass
Supplier establishes SupplierPricePromotionZone
Supplier is source for CustomerOrderProductGroup
Supplier defines rules for DiscrepancyToleranceRule
Supplier offers Deal
Vendor can be a Supplier

Logical Views containing Supplier

Logical View
Logical 01500 - Item Supplier View
Logical 01501 - Item Unit of Measure Types
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 06310 - Party - Role View
Logical 06400 - Store Equipment View
Logical 07600 - Customer Order - Macro View