CustomerAccountValuationUnitType

Entity Definition

Logical Name : CustomerAccountValuationUnitType
Physical Name : CO_CT_ACNT_VLN_UN_TYP

A reference entity that identifies, names and defines the units used to explain what an account accumulation or balance is measuring. By design, this entity stretches the idea that accounts deal only with monetary units. It is used to establish a controlled vocabulary for defining various kinds of customer reward earning and redemption activities which often require different measurement units (along with relevant conversions) Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountValuationUnitTypeCode (PK) A code that identifies a kind of valuation unit. Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer CD_CT_ACNT_VLN_UN_TYP Code varchar(20)
Description A short business description of the AccountingValuationType used for reporting and inquries. DE_DSCR DescriptionShort varchar(255)
NarrativeText A short narrative that explains what the unit measures and how it is to be used. NA_NRTV_TXT DescriptionNarrative varchar(4000)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerAccountValuationUnitType defines valuation units for CustomerRewardLineItem
CustomerAccountValuationUnitType defines units used for CustomerLedgerReportingClassification
CustomerAccountValuationUnitType defines valuation units for RewardDerivationRule

Logical Views containing CustomerAccountValuationUnitType

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 07010 - Customer Account Information Extended