Entity Definition

Logical Name : TenderLineItemDenomination
Physical Name : CO_LTM_TND_DNM

Records the Denominations used in a particular TenderLineItem

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) TenderLineItem(TR_LTM_TND)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint TenderLineItem(TR_LTM_TND)
DenominationID (FK)(PK) An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, etc. ID_DNM Identity integer Denomination(CO_DNM)
ISOCurrencyCode (FK)(PK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) Denomination(CO_DNM)
DenominationQuantity The number of the Denomination units used by the TenderLineItem. QY_DNM Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
TenderLineItem uses TenderLineItemDenomination
Denomination is part of TenderLineItemDenomination

Logical Views containing TenderLineItemDenomination

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 02336 - Retail Transaction - Tender - Authorization View