Entity Definition

Logical Name : RetailTransactionTotal
Physical Name : TR_TOT_RTL

A monetary or unit count total for the RetailTransaction. Ususally TotalTaxableAmount, TotalTaxCollected, TotalAmountPaid, TotalItemCount, etc...

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) RetailTransaction(TR_RTL)
TransactionTotalTypeCode (FK)(PK) A unique assigned mnemonic identifier that identifies the TransactionTotalType TY_TRN_TOT Code varchar(20) TransactionTotalType(TR_TOT_TYP)
Amount The monetary value of the transaction total. MO_TOT_RTL_TRN Money decimal(16,5)
UnitCount A RetailTransaction level count of SKU's, line items, promotions or other kinds of discrete unit counts used to characterize RetailTransactions. Count, like Amount can be trea QU_ITM_CNT Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
TransactionTotalType defines RetailTransactionTotal
RetailTransaction has RetailTransactionTotal

Logical Views containing RetailTransactionTotal

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02360 - Retail Transaction - Food Service View
Logical 02380 - Retail Transaction - Total View
Logical 05200 - Taxation - Retail Transaction View