Entity Definition

Logical Name : TillTenderLimitRuleAssignment
Physical Name : CO_ASGMT_TL_LM_TND

The assigment of a particular DrawerLimitRule to a Till for a nominated type of Tender during particular time periods.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender for which the drawer limit is being imposed. e.g. US Cash, Cheques, CreditCard, etc. TY_TND Code varchar(20) Tender(AS_TND)
TimeGroupID (FK)(PK) A unique identifier for a set of consecutive hours on a set of days of the week during which the given DrawerLimitRule takes effect. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)
EffectiveDateTime (PK) The date and time from which the DrawerLimitRule takes effect. DC_EF EffectiveDateTime datetime
ExpirationDateTime The date and time after which the DrawerLimitRule no longer takes effect. DC_EP ExpirationDateTime datetime
TillLimitRuleID (FK) A unique system assigned identifier for the Drawer Limit Rule. ID_TL_LM_RU Identity integer TillLimitRule(RU_LM_TL)


Parent Entity Verb Phrase Child Entity
Till is assigned TillTenderLimitRuleAssignment
TimeGroup delineates TillTenderLimitRuleAssignment
Tender is assigned TillTenderLimitRuleAssignment
TillLimitRule is assigned TillTenderLimitRuleAssignment

Logical Views containing TillTenderLimitRuleAssignment

Logical View
Logical 02450 - Control Transaction - Drawer Limit
Logical 06500 - Time Groups View