Entity Definition

Logical Name : CustomerAccountLinkage
Physical Name : LE_CT_ACNT_LNKG

A general purpose join entity that allows retailers to link CustomerAccount instances together. This needs to be used thoughtfully and carefully. A sample scenario for using CustomerAccountLinkage is associating a CustomerMembershipAccount with CustomerInstalllmentPaymentAccount. This enables a retailer to tie multiple installment purchases to a club member. Another scenario is where a retailer wants to tie CustomerRevolvingChargeAccount with a RebateAccount for customer valuation purposes. While CustomerAccounts are typically tied to KeyCustomers it is not a required relationship. Also, the ability to connect specific kinds of accounts for a given customer (like CustomerMembership and Rebate accounts) may be easier to implement with this kind of join entity.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountLinkageID (PK) Token ID for a CustomerAccountLinkage instance. ID_CT_ACNT_LNKG Identity integer
To (FK) A unique identifier for a customer account. ID_CTAC_TO Identity integer CustomerAccount(LE_CTAC)
From (FK) A unique identifier for a customer account. ID_CTAC_FR Identity integer CustomerAccount(LE_CTAC)
AccountLinkageTypeCode Defines a category or type of linkage created to tie two different instances of CustomerAccounts together. This is a retailer defined code. Its intent is to allow retailers to link different kinds of customer accounts together. For example they can link a customer membership account to an installment payment account. By design, this is a very open ended association so retailers can establish linkages that are appropriate for their business. CD_ACNT_LNKG_TYP Code varchar(20)
AccountLinkagePurposeNarrative A short description of how a customer account linkage (basically a join between two customer account types) is to be used. NA_ACNT_LNKG_PRPS DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
CustomerAccount is associated with CustomerAccountLinkage
CustomerAccount is associated with CustomerAccountLinkage

Logical Views containing CustomerAccountLinkage

Logical View
Logical 07010 - Customer Account Information Extended