Entity Definition

Logical Name : TillLimitExceededTransaction
Physical Name : TR_EXCD_TL_LM

A non-sales Transaction recording the fact that the calculated cash on hand in a particular Till has exceeded a pre-defined limit.

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)
TenderTypeCode (FK) A code which uniquely identifies the type of tender, for which the calculated in drawer figure exceeds the limit in the DrawerLimitRule. TY_TND Code varchar(20) Tender(AS_TND)
TillLimitRuleID (FK) A unique system assigned identifier for the Drawer Limit Rule. ID_TL_LM_RU Identity integer TillLimitRule(RU_LM_TL)
TillID (FK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
LimitTypeCode A mnemonic code that denotes which of the limits in the DrawerLimitRule have been exceeded. e.g. Warning, Lockout. TY_LM Code4 char(4)
InTillAmount The calculated in drawer amount of the Tender that exceeded the limit. MO_TL MoneyShortRetail decimal(7,2)


Parent Entity Verb Phrase Child Entity
TillLimitRule records exceeding TillLimitExceededTransaction
Till is the subject of TillLimitExceededTransaction
Tender delineates TillLimitExceededTransaction
ControlTransaction can be a TillLimitExceededTransaction

Logical Views containing TillLimitExceededTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 02450 - Control Transaction - Drawer Limit