Entity Definition

Logical Name : CustomerRewardLineItem
Physical Name : TR_CT_RWD_LN_ITM

A type of retail transaction line item used to record the earning, redemption and adjustment of DEFERRED rewards like points, mile or other non-monetary values that may be accumulated for subsequent redemption in the form of discounts, free gifts, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardID (FK) A token identifier for a Reward instance. ID_RWD Identity integer RewardDerivationRule(RU_RWD_DRVN_RU)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
CustomerMembeshiprProgramAccountID (FK) Token ID for a CustomerMemberProgramAccount. ID_CT_MBR_PRGM_ACNT Identity integer CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS)
CustomerRewardProgramTierCode (FK) A code that represents the relative value of a given CustomerRewardProgramTier CD_CT_RWD_PRGM_TIER Code varchar(20) CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS)
MembershipProgramID (FK) Token ID for a CustomerRewardProgram instance. ID_CT_MBRSHP_PRGM Identity integer CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS)
LevelNumber (FK) A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. IC_LV_NMB Number integer CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS)
RewardActionCode A code that defines how deferred rewards are to be processed in this line item. Valid values: EARN - translate sale/return infor into reward currency REDEEM - translate the reward currency into a discount or rebate value (percent off or monetary value) for use in the current transaction ADJUST - add to or subtract from a redeemed currency balance held in the membership program account referenced in this entity type instance. NOTE: Keep in mind that a Reward may be earned and redeemed in the same retail transaction. Instant rebates are one example of this. When a reward is earned AND redeemed in the same retail transaction, there will be TWO CustomerRewardLineItem (and for rebates CustomerRewardRebateLine instances) in that transaction. The first for an earned reward and the second for a redeemed reward. CD_RWD_ACTN Code varchar(20)
RewardID (FK) A token identifier for a Reward instance. ID_RWD Identity integer Reward(TR_RWD)
RewardDerivationSequenceNumber (FK) A sequence number used to specify the order for applying derivation rules tied to a Reward. RewardDerivationSequenceNumber always starts with 1 and is incremented by 1 for each appended derivation step tied to the Reward. AI_RWD_DRVN_SQN_NMB LineNumber integer RewardDerivationRule(RU_RWD_DRVN_RU)
RewardValueAmount The numeric value of a RewardLineItem expressed in reward currency units. Reward currency unit examples include: MONEY (discount amount or pct off) POINTS MILES MEALS Any other units a retailer chooses to reflect a stored, accrued value based on customer purchases as defeined in RewardDerivationRule.CustomerAccountValuationUnitTypeCode. MO_RWD_VL_AMT Money decimal(16,5)
CustomerAccountValuationUnitTypeCode (FK) 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) CustomerAccountValuationUnitType(CO_CT_ACNT_VLN_UN_TYP)
StatusSequencNumber (FK) A sequence number used to capture a customer's program account reward tier status change, This attribute allows multiple occurences of a tier status to be stored over time for time series analysis of customer activity. AI_STS_SQN_NMB Identity integer CustomerAccountRewardTierStatus(CO_CT_ACNT_RWD_TR_STS)


Parent Entity Verb Phrase Child Entity
Reward identifies reward basis of CustomerRewardLineItem
RewardDerivationRule defines derivation of CustomerRewardLineItem
CustomerAccountRewardTierStatus defines level of CustomerRewardLineItem
CustomerAccountValuationUnitType defines valuation units for CustomerRewardLineItem
CustomerRewardLineItem is a CustomerRewardRebateLineItem

Logical Views containing CustomerRewardLineItem

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View
Logical 04100 - Financial Ledger - Retail Transaction View