RetailTransactionLineItemAssociation

Entity Definition

Logical Name : RetailTransactionLineItemAssociation
Physical Name : ST_ASCTN_LTM_RTL

Associative entity recording relationships between line items within the same or two different RetailTransaction instances. Examples of usage of this entity include: - Associating an original sales line item to a return line item - Associating an original sales line item to an exchange line item - Associating a sales line item to a fee line item - Associating a raincheck voucher issue line item to a raincheck voucher redemption line item - Associating a rental item with deposit item and where appropriate penalty and other kinds of supplementary charges. - Associating a sale/return line item with the deferred reward line items derived from it (using RewardDerivationRule, RewardEligibilityRule and Rewars information.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
DocumentIssuance (FK) A token identifier for a RetailTransactionDocument instance. ID_RTL_TRN_DCM Identity integer RetailTransactionDocument(DO_RTL_TRN_DCM)
TransactionID (FK)(PK) 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)
LineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LTM LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
ToTransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_TO IdentityUUID char(32) RetailTransactionLineItem(TR_LTM_RTL_TRN)
ToLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LTM_TO LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
LineItemAssociationTypeCode (FK)(PK) A retailer assigned code denoting the relationship between the two items within the same RetailTransaction. CD_TYP_LTM_ASCTN Code4 char(4) RetailTransactionLineItemAssociationType(CO_LTM_ASCTN)
SequenceNumber (PK) A number that indicates the presentation order of RetailTransactionLineItemAssociation entity type instances. The use of this attribute is determined by the application logic used to create and use this association. It may be used to indicate chronological order OR it may be used to establish a precedence in how retail transaction line item associations are to be processed. IC_ASCTN_LTM_RTL_SQN_NMB LineNumber smallint
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
LineItemEntryMethodCode A code to denote how the RetailTransactionLineItem association was entered at the Workstation. CD_MTH_ENR EntryMethodCode varchar(20)
OriginalSourceRetailTransactionLineItemAssociationFlag A boolean indicator that if set to YES or TRUE means that this association instance is the first of multiple associations. Note that this applies primarily where SequenceNumber is used as a precedence determination value NOT a chronological value. This requires some additional discussion and clarification. FL_ORGL_SRC_ASCTN_LTM_RTL Flag integer
LineItemXrefConversionDescription Short narrative specification of the procedure used to translate from line item units into to line item units. This is used to describe how sale/return retail selling unit counts or monetary values are translated into deferred reward currencies like points, miles, etc. May also be used to define how other kinds of fees, penalties and other association types are calaculated. DE_LN_ITM_CVN DescriptionShort varchar(255)
DocumentRedemption (FK) A token identifier for a RetailTransactionDocument instance. ID_RTL_TRN_DCM Identity integer RetailTransactionDocument(DO_RTL_TRN_DCM)

Relationships

Parent Entity Verb Phrase Child Entity
RetailTransactionDocument redemption referenced by RetailTransactionLineItemAssociation
RetailTransactionDocument issuance referenced by RetailTransactionLineItemAssociation
Reason classifies RetailTransactionLineItemAssociation
RetailTransactionLineItem is associated with RetailTransactionLineItemAssociation
RetailTransactionLineItem is linked to RetailTransactionLineItemAssociation
RetailTransactionLineItemAssociationType defines RetailTransactionLineItemAssociation

Logical Views containing RetailTransactionLineItemAssociation

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02312 - Retail Transaction - Item Voids View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 02360 - Retail Transaction - Food Service View
Logical 06220 - Access Control - Overrides View