Entity Definition

Logical Name : CustomerRewardRebateLineItem
Physical Name : TR_CT_RWD_RBT_LN_ITM

A type of CustomerRewardLineItem used to record the earning, redemption and adjustment of REBATES. CUSTOMER REBATES are rewards that a customer earns and may claim after a purchase is completed. Customer rebates may be INSTANT REBATES or DEFERRABLE REBATES. Instant rebates are earned and redeemed within the same transaction. The earning part of an instant rebate is represented by an earn activity code in the parent CustomerRewardLineItem. Instant rebates are subtracted from a purchase price after it is recorded. The rebate value is represented by a redemption/settlement CustomerRewardLineItem. An INSTANT REBATE always has two CustomerRewardLineItem and CustomerRewardRebateLineItem instances for any rebate captured as part of a retail transaction. The first covers the earning of the rebate (which is a rebate claim). The second is a rebate redemption/settlement which is the payment of the rebate value to the customer. To the customer instant rebates are nearly indistinguishable from a discount. Within the ARTS ODM instant rebates and discounts are very different concepts (see the ODM Narrative Section: Understanding Rebates for a detailed explanation). Customer Rebates may be DEFERRABLE rewards. This means that a rebate is earned in a transaction, added to a rebate payable balance and paid to the customer at a future time through a separate transaction. Deferrable rebates will be recorded as two CustomerRewardLineItem - CustomerRewardRebateLineItem entity type instances. The first captures the earning of a rebate. The second captures the posting of the liability established for the future return of the rebate value to the customer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RebateID (PK) Token ID for a CustomerRewardRebate ID_RBT Identity integer
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) CustomerRewardLineItem(TR_CT_RWD_LN_ITM)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint CustomerRewardLineItem(TR_CT_RWD_LN_ITM)
SalesReceiptRequiredFlag Boolean indicator that if YES means that a rebate beneficiary must subit the sales receipt on which the item being claimed for a rebate was sold. If NO the rebate claimant does NOT have to submit the original sales receipt. FL_SLS_RCT_RQ Flag integer
RebateCustomerSettlementModeCode Defines that way customers receive rebates. Used to distinguish between mail in rebates, instant rebates and deferred rebate settlements. Valid Values are: MAILIN (deferred payout ) INSTANT (immediate payout within retail transaction) DEFERRED_SETTLEMENT (aka "dividend") Note does not establish the currency used for rebates (i.e. cash, points, premium gift items, stored value items, etc.) CD_RBT_CT_STLM_MOD Code varchar(20)
RebateCustomerSettlementPaymentTypeCode Designates the way a rebate value is transferred to a beneficiaryr. Enumerated value lists are defined by the retailer. Examples include: CASH SENDCHECK DBCRCARD_CREDIT DISCOUNT PREMIUM_ITEM LOYALTY_POINTS STORED_VALUE STORE_CREDIT For scenarios where a rebate beneficiary is the retailer itself examples include: BILL_BACK (in effect a receivable) PURCHASE_DISCOUNT (take value off next purchase from the sponsor) There are other more esoteric forms of payment like advertising subsidies, jointly sponsored promotional events, etc. CD_RBT_CT_PYM_CNY_TYP Code varchar(20)
EffectiveDate The date a RebateProgram begins. DT_EF EffectiveDate date
ExpirationDate The date a RebateProgram ends DT_EP ExpirationDate date
StatusCode The current state of a RebateProgram. Sample values are: ACTIVE INACTIVE CD_STS_RBT_PRGM Code2Status char(2)
CustomerRebateAccountProgramID (FK) A token ID for a CustomerRebateAccountProgram ID_CT_RBT_ACNT_PRGM Identity integer CustomerRebateAccountProgram(CO_CT_RBT_ACNT_PRGM)


Parent Entity Verb Phrase Child Entity
CustomerRebateAccountProgram earns or redeems CustomerRewardRebateLineItem
CustomerRewardLineItem is a CustomerRewardRebateLineItem

Logical Views containing CustomerRewardRebateLineItem

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