Entity Definition

Logical Name : DepositRedemption
Physical Name : TR_DPRD

A DEPOSIT is a monetary amount that is paid to secure an ITEM. The DEPOSIT can be redeemed against the eventual purchase or returned to the CUSTOMER when the ITEM is returned, e.g. bottle or can. DEPOSITs/REDEMPTIONs are very prevalent in Northern European grocery where a DEPOSIT is paid for the container at the time of purchase and a REDEMPTION payment made when returned at a future visit.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
DepositRedemptionTypeCode (PK) Defines the type of deposit or redemption. In addition to distinguishing between deposits (i.e. deposits on bottles, etc.) and redemptions, this code allows the store to establish different categories of deposits and redemptions. Valid DEPOSIT/REDEMPTION types: CONTAINER RENTAL LAYAWAY ORDER other??? LU_RFM_DS Code2 char(2)
FinancialLedgerAccountID (FK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)


Parent Entity Verb Phrase Child Entity
FinancialLedgerAccount defines accounting disposition of DepositRedemption
DepositRedemption defines rules for DepositRedemptionLineItem

Logical Views containing DepositRedemption

Logical View
Logical 02395 - Retail Transaction - Deposit Redemption View
Logical 04100 - Financial Ledger - Retail Transaction View