Entity Definition

Logical Name : Brand
Physical Name : ID_BRN

The selling and promotional name used to identify a product for advertising and name recognition purposes.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BrandName (PK) A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. NM_BRN Name varchar(40)
OwningPartyID (FK) A unique, system assigned identity for a Party. ID_PRTY Identity integer Party(PA_PRTY)
Description The description of a class of ITEMs produced by a product of a single supplier or manufacturer. DE_BRN DescriptionShort varchar(255)
BrandGrade A retailer designated code that indicates the relative value of the brand within its portfolio of brands. This is imporant when comparing brands offered by a retailler for sales analytic and customer segmentation purposes. Examples: PREMIUM - high quality brand SUPERIOR - better quality brand REGULAR - middle of the road brand VALUEPACKAGE - inexpensive no frills brand LOWEND - Lowest price brand CD_BRN_GRDG Code varchar(20)


Parent Entity Verb Phrase Child Entity
Party owns Brand
Brand is produced by ManufacturerBrand
Brand includes SubBrand
Brand describes Item
Brand may trigger BrandRewardDerivationRuleEligibility

Logical Views containing Brand

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 07040 - Customer Segment Dependent Behavior