Entity Definition

Logical Name : DepositRule
Physical Name : RU_DS

An association of a StockItem and a ReturnAgent that defines the rules governing the deposit payment that must be paid by the customer at the time the item is purchased and the refund that must be made to the customer upon return of the item package or container. This rule is most often related to bottles, aluminum cans, crates and other containers which must be returned for reuse or recycling.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
DepositRuleID (PK) A unique system assigned identifier for the deposit rule ID_RU_DS Identity integer
ReturnAgentID (FK) A unique system assigned identifier for the Return Agent. ID_AGNT_RTN Identity integer ReturnAgent(PA_AGNT_RTN)
DepositAmount The monetary amount of the Deposit that is paid to or collected from the Customer at purchase and return. MO_DS MoneyShortRetail decimal(7,2)
DepositPaidOnUnitOfMeasureCode The unit of measure (e.g. each bottle, each case, each rack, etc.) that the customer pays a deposit on at the time of a sale. LU_UOM_DS_PD Code2 char(2)
DepositPaidPerUnitOfMeasureAmount Th deposit amount paid for each deposit-paid-on-unit-of-measure-code by the consumer at the time an item is purchased. MO_UOM_DS_PD Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
ReturnAgent is part of DepositRule
DepositRule is part of ItemSellingRule

Logical Views containing DepositRule

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 01100 - Item Selling Rules - Macro View
Logical 02395 - Retail Transaction - Deposit Redemption View