Entity Definition

Logical Name : ItemTenderRestrictionRule
Physical Name : RU_RST_ITM_TND

An association between ITEM TENDER RESTRICTION GROUP and TENDER which constrains the use of a specific type of tender in the settlement of a sale for a specific ITEM.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
ItemTenderRestrictionGroupCode (FK)(PK) A retailer assigned code to denote a specific group of ItemTenderRestrictions. LU_GP_TND_RST Code2 char(2) ItemTenderRestrictionGroup(CO_RST_ITM_TND)
Name The rule that prohibits the purchase of certain Items by certain tender types. NM_RU_TND_RST Name varchar(40)
Description A description of the rule that prohibits the purchase of specific Items with certain tender types. DE_RU_TND_RST DescriptionShort varchar(255)
ThresholdAmount A monetary amount at which this restriction tender rule applies. MO_AMT_THRSH MoneyShortRetail decimal(7,2)
EffectiveDate The date from which the restriction rule applies. DC_RST_TND_EF EffectiveDate date
ExpirationDate The date until which the restriction rule applies. DC_RST_TND_EP ExpirationDate date
StatusCode A code to indicate whether the restriction rule applies to a certain Item or not. SC_RU_TND_RST Code2Status char(2)


Parent Entity Verb Phrase Child Entity
Tender is restricted through ItemTenderRestrictionRule
ItemTenderRestrictionGroup is subject to ItemTenderRestrictionRule

Logical Views containing ItemTenderRestrictionRule

Logical View
Logical 01100 - Item Selling Rules - Macro View
Logical 01110 - Item Selling Rules - Restrictions View