Entity Definition

Logical Name : CustomerDonationAccount
Physical Name : LE_CT_DNTN_ACNT

A type of account used to aggregate customer donations made through the change for charity retail transaction line items. This subtype of account may or may not be used by a retailer. It provides an additional value-add for retailers that want to provide customers with an annual summary of donations receipt that can be used for income tax reporting purposes.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer


Parent Entity Verb Phrase Child Entity
CustomerDonationAccount aggregates for reporting Contribution

Logical Views containing CustomerDonationAccount

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 07010 - Customer Account Information Extended