Entity Definition

Logical Name : RetailTransactionLineItem
Physical Name : TR_LTM_RTL_TRN

A detail line item of a RetailTransaction that records the business conducted between the retail store and another party involving the exchange in ownership and/or accountability for merchandise and/or tender or involving the exchange of tender for services.

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)
RetailTransactionLineItemSequenceNumber (PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
CustomerOrderID (FK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer CustomerOrderLineItem(DO_CTOLTM)
CustomerOrderLineItemSequenceNumber (FK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderLineItem(DO_CTOLTM)
BeginDateTimestamp The start time of the RETAIL TRANSACTION line item. TS_LN_ITM_BGN EffectiveDateTime datetime
VoidFlag :A boolen indicator that tells if this line item is VOIDED or not. A line item may be voided "in place" or voided "by reference". Voiding in place means that the line item is negated without requiring a separate void line item to reverse it (hence the term "in place). Voiding by reference means that the item is voided by a second void line item that reverses it. So the voided line item is supplemented by a voiding line item (by reference). Voiding by reference is currently handled through an optional VoidsLineItem entity type. Because the relationship is optional we can represent voiding in place and voiding by reference. While this works it needs to be modified. As modeled, this attribute is NOT A COMPLETE treatment of void and cancellation. It will be modifed in the next data model version. . FL_VD_LN_ITM Flag integer
EndDateTimestamp The end time of the RETAIL TRANSACTION line item. TS_LN_ITM_END ExpirationDateTime datetime
EntryMethodCode A retailer assigned code to denote how the RetailTransactionLineItem was entered at the Workstation. LU_MTH_LTM_RTL_TRN EntryMethodCode varchar(20)
RetailTransactionLineItemTypeCode (FK) A code to denote the type of retail transaction line item, such as Sale/Return, Void, miscellaneous fee, etc. CD_TYP_LTM_TRN_RTL Code varchar(20) RetailTransactionLineItemType(CO_TYP_LTM_TRN_RTL)
RetailTransactionLineItemEntryModeCode A code that designates the privlege mode or level that the individual creating this transaction used. The purpose is to track illicit uses of manager and maintenance modes that might be used to circumvent normal operational and financial controls Sample values: NORMAL - lowest privilege level for cashiers MANAGER - intermeidate privilege level fo rmanagers MAINTENANCE - highest leve privilege for auditors, tax authorities and authorized POS maintenance indiviuals. CD_RTL_TRN_LN_ITM_ENR_MOD Code varchar(20)


Parent Entity Verb Phrase Child Entity
RetailTransaction contains RetailTransactionLineItem
CustomerOrderLineItem was source for RetailTransactionLineItem
RetailTransactionLineItemType classifies RetailTransactionLineItem
RetailTransactionLineItem is posted to CustomerAccountJournal
RetailTransactionLineItem is posted by FinancialLedgerJournalEntry
RetailTransactionLineItem is associated with RetailTransactionLineItemAssociation
RetailTransactionLineItem is summed into RetailTransactionLineItemGroupAssignment
RetailTransactionLineItem effects VoidsLineItem
RetailTransactionLineItem is overridden by RetailTransactionLineItemResourceOverride
RetailTransactionLineItem originated in CustomerOrderLineItem
RetailTransactionLineItem is linked to RetailTransactionLineItemAssociation
RetailTransactionLineItem can be a PriceModificationLineItem
RetailTransactionLineItem can be a VoidsLineItem
RetailTransactionLineItem can be a Z_RaincheckLineItem
RetailTransactionLineItem can be a CustomerInformationLineItem
RetailTransactionLineItem can be a DonationLineItem
RetailTransactionLineItem can be a DepositRedemptionLineItem
RetailTransactionLineItem can be a ZCustomerRewardEarnedLineItem
RetailTransactionLineItem can be a SaleReturnLineItem
RetailTransactionLineItem can be a ZCustomerRewardRedemptionLineItem
RetailTransactionLineItem can be a ZCustomerRewardLineItem
RetailTransactionLineItem can be a TenderLineItem
RetailTransactionLineItem can be a RoundingLineItem
RetailTransactionLineItem can be a TaxLineItem
RetailTransactionLineItem can be a
RetailTransactionLineItem can be a MiscellaneousFeeLineItem
RetailTransactionLineItem can be a GiftCertificateLineItem
RetailTransactionLineItem can be a PaymentOnAccountLineItem
RetailTransactionLineItem can be a WriteoffLineItem

Logical Views containing RetailTransactionLineItem

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02020 - Item Inventory - Selling View
Logical 02200 - Transaction Macro View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02309 - Retail Transaction Delivery
Logical 02310 - Retail Transaction - Item Sale 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 02320 - Retail Transaction - Taxation View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 02336 - Retail Transaction - Tender - Authorization View
Logical 02339 - Retail Transaction - Tender - Account View
Logical 02340 - Retail Transaction - Shipping View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 02360 - Retail Transaction - Food Service View
Logical 02370 - Retail Transaction - Rental View
Logical 02380 - Retail Transaction - Total View
Logical 02390 - Retail Transaction - Stored Value Instrument
Logical 02395 - Retail Transaction - Deposit Redemption View
Logical 02440 - Control Transaction - Voids View
Logical 02600 - Inventory Control Transaction View
Logical 04000 - Financial Ledger - Macro View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 05000 - Taxation - Macro View
Logical 05200 - Taxation - Retail Transaction View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 06220 - Access Control - Overrides View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View
Logical 07600 - Customer Order - Macro View
Logical 10400 - Enterprise - Channels
Logical 11140 - Worker - Retail Transaction View
Logical 20000 - Forecourt Macro View
Logical 20030 - Forecourt Transaction View
Logical 21000 - Fresh Item Management Macro View