DonationLineItem

Entity Definition

Logical Name : DonationLineItem
Physical Name : TR_LTM_CHRTY_DNTN

A line item that captures a monetary value that a customer donates to a charity within a RetailTransaction. This line item type is created to support change for charity. As modeled, it provides a place to assign a customer designated donation. Retailers may choose to implement logic to limit this to change or to treat it as an additional credit type of line item. The constraints and use of this entity type will be determined by the retailer application logic.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
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
ContributionID (AK)(FK) Token ID for a instance of a ContributionLineItem. ID_CNTRBTN Identity integer Contribution(TR_CNTRBTN)
CharityID (FK) Token ID for a charity recipient. ID_DNTN_RCPNT Identity integer Charity(PA_DNTN_RCPNT)
DonationAmount The monetary value of a customer contribution line item which may be allocated to ONE or MORE contribution entity types through the DonationLineItemContribution join table. MO_DNTN Money decimal(16,5)
DonationPointsCount The value of a contribution expressed in customer loyalty points. This is used to update a customer loyalty account points balance when a customer chooses to redeem points and donate their monetary equivalent value to a charity. QU_DNTN_PT Quantity DECIMAL(9,3)
DonationTriggerType DonationTriggerType indicates the kind of condition which caused the creation of this ContributionLineItem entity instance. Sample Values: CustomerGift - outright contribution no conditions ItemsPurchased - contribution predicated on one or more specific items purchased. Use RetailTransactionLineItemAssociation or RetailTransactionLineItemGroupAssignment AmountSpent - total value of retail transaction or some group of line items Coupon - contribution predicated on specific coupon tendered You may want to add tender type and tender media brand. Credit card companies sometimes offer to donate money to charities based on using their branded credit/debit card to purchase items. CD_DNTN_TYP Code varchar(20)
DonationMatchAmount A contribution monetary value that is provided by the retailer based on the monetary value of the the customer contribution(ContributionAmount). This value is assigned by retailer application logic. MO_DNTN_MTCH MoneyShortRetail decimal(7,2)
MessageText Short narrative text of thanks (or other content) to the contributor. DE_MSG_TXT DescriptionShort varchar(255)
DonationMatchingSourceName Name of the matching contribution source. For now this is represented as a simple owned attribute. NM_SRC_DNTN_MTCH DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
Contribution is recorded through DonationLineItem
Charity is intended recipient of DonationLineItem
RetailTransactionLineItem can be a DonationLineItem

Logical Views containing DonationLineItem

Logical View
Logical 02341 - Retail Transaction - Change for Charities View