Entity Definition

Logical Name : CustomerRebateAccountProgram
Physical Name : CO_CT_RBT_ACNT_PRGM

Optional entity that allows a given CustomerrRebateAccount to be associated with more than one RebateProgram. An example of using this entity is where a manufacturer maintains a rebate program that is supplemented by a separate retailer sponsored program.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerRebateAccountProgramID (PK) A token ID for a CustomerRebateAccountProgram ID_CT_RBT_ACNT_PRGM Identity integer
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerRebateAccount(LE_CT_RBT_ACNT)
EffectiveDate Date when a CustomerRebateAccount may actively participate in a RebateProgram. DC_EF_DT EffectiveDate date
ExpirationDate Date when a CustomerRebateAccount may no longer participate in a RebateProgram. DC_EP_DT ExpirationDate date
StatusCode Status of the CustomerRebateAccountProgram association. Valid values are: A - ACTIVE I - INACTIVE CD_STS Code2Status char(2)
RebateProgramID (FK) A token identifier for RebateProgram entity type instances. ID_RBT_PRGM Identity integer RebateProgram(RBT_PRGM)


Parent Entity Verb Phrase Child Entity
CustomerRebateAccount is enrolled in CustomerRebateAccountProgram
RebateProgram enrolls CustomerRebateAccountProgram
CustomerRebateAccountProgram defines basis for CustomerReward
CustomerRebateAccountProgram earns or redeems CustomerRewardRebateLineItem

Logical Views containing CustomerRebateAccountProgram

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