Entity Definition

Logical Name : RetailTransactionLineItemGroup
Physical Name : TR_RTL_LTMGP

A group of line items within a RetailTransaction that are processed together. e.g. individual meal trays 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) RetailTransaction(TR_RTL)
LineItemGroupID (PK) The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. ID_TRN_LTMGP LineNumber smallint
RetailTransactionLineItemGroupTypeCode (FK) A code that describes a categorization of groups of line items in a RetailTransaction. e.g. Delivery, Pickup, Tray (in food service) TY_TRN_TOT Code varchar(20) RetailTransactionLineItemGroupType(TR_RTL_LTMGP_TYP)
Description A narrative description of the items in this LineItemGroup, or some extra processing to be performed on them. DE_LTMGP DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
RetailTransaction contains RetailTransactionLineItemGroup
RetailTransactionLineItemGroupType classifies RetailTransactionLineItemGroup
RetailTransactionLineItemGroup is sum of RetailTransactionLineItemGroupAssignment
RetailTransactionLineItemGroup has RetailTransactionLineItemGroupTotal

Logical Views containing RetailTransactionLineItemGroup

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