Entity Definition

Logical Name : RetailTransactionLineItemGroupAssignment

This is a join entity/table that enables a given RetailTransactionLineItem to be associated to zero, one or many different RetailTransactionLineItemGroup instances. This allows a retailer to represent a given RetailTransactionLineItem linkage to a RetailTransactionLineItemGroup that reflects the application of a mix and match discount rule AND, through a seperate and disctinct assignment entity tie that same RetailTransactionLineItem to a specific delivery. This upgrades the prior single FK from RetailTransactionLineItem to RetailTransactionLineItemGrouop which limited association instances to one. This new join entity improves flexibility and brings the DM into alignment with the XML POSLOG standard.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransactionLineItem(TR_LTM_RTL_TRN)
RetailTransactionLineItemGroupAssignmentID (PK) Token identifier for a RetailTransactionLineItemGroupAssignment ID_RTL_TRN_LN_ITM_GP_ASGMT Identity integer
TransactionID (FK) 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) The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. ID_TRN_LTMGP LineNumber smallint RetailTransactionLineItemGroup(TR_RTL_LTMGP)
RetailTransactionLineItemSequenceNumber (FK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
RetailUnitQuantity A count of retail selling units from a RetailTransactionLineItem (actually from a SaleReturnLineItem subtype) that is referenced in this associative entity type. CAUTION: The value here is retail selling unit count NOT retail pricing unit count. So exercise caution if you are dealing with items sold 3 for $.49 - their retail selling units are 3 and their RETAIL PRICING is $.49 in a line item. QU_RTL_UN Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
RetailTransactionLineItem is summed into RetailTransactionLineItemGroupAssignment
RetailTransactionLineItemGroup is sum of RetailTransactionLineItemGroupAssignment

Logical Views containing RetailTransactionLineItemGroupAssignment

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 02380 - Retail Transaction - Total View