Entity Definition

Logical Name : TenderControlTransactionTenderLineItem
Physical Name : TR_LTM_TND_CTL_TND

This is a line item in financial transactions involving tender transfers into or out of the store safe that are NOT part of the pickup and loan tender transfer between tills and the store safe.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the parent TenderControlTransaction ID_TRN IdentityUUID char(32) TenderControlTransaction(TR_CTL_TND)
LineItemID (PK) A sequence numer used to identify unique line item instances within a TenderControlTransaction. IC_LN_ITM LineNumber smallint
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender being moved in the TenderControlTransaction. TY_TND Code varchar(20) Tender(AS_TND)
DenominationID (FK) An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, being moved. Because currency detail is identified by tender type, currency AND denomination, we are adding CurrencyID and Denominator to the primary key for this entity. WIthout these, the entity's unique ID is not adequate to handle detailed tender counts which is part of Tender Control. ID_DNM Identity integer Denomination(CO_DNM)
ForeignCurrencyAmount The monetary value (in currency being moved) of the Tender being moved by the transaction. MO_FRG_CY MoneyShortRetail decimal(7,2)
Amount The monetary value (in the default system currency) of the Tender being moved by the transaction. MO_TND_FN_TRN Money decimal(16,5)
Count The number of tender units being moved. eg 20x$100 bills. QU_TND_FN_TRN QuantityTransactionCount decimal(7,0)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) Denomination(CO_DNM)


Parent Entity Verb Phrase Child Entity
Denomination is recorded in TenderControlTransactionTenderLineItem
Tender is transferred through TenderControlTransactionTenderLineItem
TenderControlTransaction is composed of TenderControlTransactionTenderLineItem
TenderControlTransactionTenderLineItem is posted by FinancialLedgerJournalEntry

Logical Views containing TenderControlTransactionTenderLineItem

Logical View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 03160 - Reporting - Store Operations - Till View
Logical 04000 - Financial Ledger - Macro View
Logical 04200 - Financial Ledger - Tender Ctrl Transaction View