Entity Definition

Logical Name : RetailTransaction
Physical Name : TR_RTL

A type of Transaction that records the business conducted between the retail enterprise 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)
LocationID (FK) A unique system assigned identifier for the SellingLocation. ID_LCN Identity integer SellingLocation(LO_LCN_SL)
RetailTransactionTypeCode (FK) A retailer assigned code denoting a type of RetailTransaction. CD_TYP_TRN_RTL Code2 char(2) RetailTransactionType(CO_TYP_TRN_RTL)
TillID (FK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
RingElapsedTime The total time elapsed between commencement of the RetailTransaction and the commencement of the transaction tendering process. IN_RNG_ELPSD QuantityShortCountSeconds decimal(5,0)
TenderElapsedTime The total time taken to receive all the tender and complete the RetailTransaction. IN_TND_ELPSD QuantityShortCountSeconds decimal(5,0)
IdleElapsedTime The total time taken that a particular Workstation was idle between completion of the previous and commencement of the current RetailTransaction IN_ELPSD_IDL QuantityShortCountSeconds decimal(5,0)
LockElapsedTime The total time the workstation is in lock mode, ie securement of the WORKSTATION to prevent misuse by another party, between the previous and current RetailTransactions. IN_LCK_ELPSD QuantityShortCountSeconds decimal(5,0)
UnitCount The total number of individual ITEMs (SKU's) which are sold in the transaction QU_UN_RTL_TRN QuantityTransactionCount decimal(7,0)
LineItemsScannedCount The total number of individual ITEMs which are scanned at the point of sale, in comparison to those keyed. QU_ITM_LN_SC QuantityTransactionCount decimal(7,0)
LineItemsScannedPercent The total number of individual ITEMs which are scanned at the point of sale, as a percentage of the total data capture time. PE_ITM_LN_SC Percent decimal(7,4)
LineItemsKeyedCount the total number of ITEMs which are keyed at the point of sale in comparison to scanned. QU_ITM_LN_KY QuantityTransactionCount decimal(7,0)
LineItemsKeyedPercent The total number of individual ITEMs which are keyed at the point of sale, as a percentage of the total data capture time. PE_ITM_LN_KY Percent decimal(7,4)
KeyDepartmentCount The total number of ITEMs which are keyed by department at the point of sale. QU_DPT_KY QuantityTransactionCount decimal(7,0)
KeyDepartmentPercent The total number of individual ITEMs which are keyed by department at the point of sale, as a percentage of the total data capture time. PE_DPT_KY Percent decimal(7,4)
ReceiptDateTime The date and time that was printed on the receipt for this transaction. TS_TRN_RCP AuditDateTime datetime
CustomerID (FK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
CustomerIDEntryMethodCode Standardized code denoting how the CustomerID was captured for this RetailTransaction. Examples include: SCANNED - scanned from loyalty card or other retailer issued customer ID KEYED - manually entered from loyalty card ALT_ID_PHONE - no card presented, used phone number as alternate ID CD_CT_ID_ENR_MTH EntryMethodCode varchar(20)
CustomerIDTypeCode Designates the type of identification documentation provided by a customer for this retail transaction. This is used to tell how a customer verifies their identity to a retailer to establish an association between the retail transaction and a customer account. This provides a place to indicate that a customer identification action was taken independent of a tender or other mechanism to associate a customer with an account (and make them an identified customer). This helps for loyalty customers that pay in cash or other tender that has no retailer based account associated with it. The following codes are examples: ANONYMOUS - no ID, anonymous customer this means that there is no cust account relationship recorded for this retail transaction. LOYALTY_CARD - Loyalty membership card PHONE_NBR - phone number (to look up acct when a customer forgot their card CUST_CHG - Customer's retailer-provided charge card (not a bank card) CUST_LAYAWAY - Layaway receipt (or other evidence of a layaway acct) RENTAL - rental receipt or other evidence of a rental account CD_CT_ID_TYP Code varchar(20)
ChannelID (FK) Token Identifier for a channel instance ID_CHNL Identity integer Channel(CO_CHNL)
RetailShoppingTripTypeCode (FK) A code designating the purpose of the shopping trip that is related to a RetailTransaction. Examples: QUICKSTOP FILLIN STOCKUP CD_RTL_SHPPG_TRP_TYP Code varchar(20) RetailShoppingTripType(CO_RTL_SHPPG_TRP_TYP)
TransactionEntryModeCode 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_TRN_ENR_MOD Code varchar(20)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)
CustomerSurveyID (FK) A unique retailer assigned identifier for the CustomerSurvery. ID_SRVY_CT Identity integer CustomerSurvey(DO_SRVY_CT)


Parent Entity Verb Phrase Child Entity
SellingLocation is credited with RetailTransaction
RetailTransactionType classifies RetailTransaction
ISO4217-CurrencyType is used in RetailTransaction
CustomerSurvey may reference RetailTransaction
RetailShoppingTripType defines purpose of RetailTransaction
Till was involved in RetailTransaction
Customer is a party to RetailTransaction
Channel defines how, when and where RetailTransaction
RetailTransaction is subject to RetailTransactionRestrictionValidation
RetailTransaction has RetailTransactionTotal
RetailTransaction renders receipt for RetailTransactionReceiptImage
RetailTransaction is extended by RetailTransactionRentalModifier
RetailTransaction image rendered as RetailTransactionSalesReceiptImage
RetailTransaction contains RetailTransactionLineItem
RetailTransaction contains RetailTransactionLineItemGroup
RetailTransaction marks occurence of ConversionEvent
Transaction can be a RetailTransaction
RetailTransaction can be a FoodServiceTransaction

Logical Views containing RetailTransaction

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 01500 - Item Supplier View
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 07017 - Consumer-Customer Lifecycle Context View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View
Logical 10102 - EnterpriseWeather
Logical 10104 - Enterprise Currency
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