Entity Definition

Logical Name : RetailTransactionLineItemGroupTotal
Physical Name : TR_TOT_RTL_LTMGP

A total monetary value of a group of line items within a RetailTransaction that are processed together. e.g. value of an individual meal tray at Wendy's

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) RetailTransactionLineItemGroup(TR_RTL_LTMGP)
LineItemGroupID (FK)(PK) The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. ID_TRN_LTMGP LineNumber smallint RetailTransactionLineItemGroup(TR_RTL_LTMGP)
TransactionTotalTypeCode (FK)(PK) A unique assigned mnemonic identifier that identifies the TransactionTotalType TY_TRN_TOT Code varchar(20) TransactionTotalType(TR_TOT_TYP)
SubtotalAmount The monetary value of the transaction line item subtotal group. MO_TOT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
RetailTransactionLineItemGroup has RetailTransactionLineItemGroupTotal
TransactionTotalType defines RetailTransactionLineItemGroupTotal

Logical Views containing RetailTransactionLineItemGroupTotal

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View
Logical 02309 - Retail Transaction Delivery
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02316 - Distributed Order Management View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 02360 - Retail Transaction - Food Service View
Logical 02380 - Retail Transaction - Total View
Logical 10400 - Enterprise - Channels