Entity Definition

Logical Name : Transaction
Physical Name : TR_TRN

A record of business activity that involves a financial and/or merchandise unit exchange or the granting of access to conduct business at a specific device, at a specific point in time for a specific employee.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
WorkstationID (AK)(FK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
BusinessUnitID (AK)(FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
BusinessDayDate (AK)(FK) The calendar date of the BusinessDay. DC_DY_BSN DateCalendar date BusinessDay(CA_DY_BSN)
SequenceNumber (AK) SequenceNumber is a counter used to uniquely identify individual transaction within a transaction set identified by: BusinessUnit (store or channel location), BusinessDayDate (day this sale/return is attributed to for accounting purposes), WorkstationID (terminal, register where transaction was entered), OperatorID (the cashier or sales associate entering the transaction) and sequence number which exists only to distinguish each transaction. With this in mind, the sequence number is a counter and IS RESET to 1 when a BusinessUnit, BusinessDayDate, WorkstationID, OperatorID control break is encountered. AI_TRN Number integer
TransactionTypeCode (FK) A code to denote the type of Transtion. e.g. RetailTransaction, ControlTransaction, TenderControlTrnsaction, etc... TY_TRN Code6 char(6) TransactionType(CO_TYP_TRN)
BeginDateTimestamp The time and date a transaction is initiated. TS_TRN_BGN EffectiveDateTime datetime
EndDateTimestamp The time and date stamp a transaction is completed. TS_TRN_END ExpirationDateTime datetime
CancelledFlag A flag denoting that this entire transaction has been cancelled before it was completed at the POS. FL_CNCL Flag integer
VoidedFlag A flag denoting that this entire transaction has been voided (and reversed) after it was completed at the POS via a PostVoidTransaction. FL_VD Flag integer
SuspendedFlag A flag denoting that this entire transaction has been suspended before it was completed at the POS. FL_SPN Flag integer
TrainingFlag A flag to signify whether the workstation is in training mode. FL_TRG_TRN Flag integer
KeyedOfflineFlag A code that indiates the online/offline state of how a transaction and its components was entered at a work station. Valid values include 'OL' online, 'SA' Standalone (offline), and 'BO' both online and offline. BO means that some line items (e.g. payment authorizations) were processed online while some (e.g. item scanning/key entry) were done offline. FL_KY_OFL Code2 char(2)
RevenueCostCenterID (FK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer RevenueCostCenter(CO_CTR_RVN_CST)
METARWeatherCondiitionID (FK) Token ID for each METAR Weather condition row. Typically METAR reports are made once per hour per ICAO location. Only locations tied to retailer Sites will have weather conditions reported. Also, retailers may choose to limit the forecasts to once or twice a day. The granularity of weather tracking for retail sales analysis and reporting is less rigorous thant for flight safety and control. ID_METAR_WTHR_CN Identity integer METARWeatherCondition(CO_METAR_WTHR_CN)
METARWeatherForecastID (FK) Token identifier for each instance of a METAR weather forecast entity. Forecast periods, unlike METARWeatherCondition (which are done on an hourly basis or more in volatile weather situations) these cover peirods of multiple days. ID_METAR_WTHR_FRCST Identity integer METARWeatherForecast(CO_METAR_WTHR_FRCST)
ForceFlag A boolean indicator that if set to YES tells the retailer that this ControlTransaction was used to override a standard operating procedure and set a state/status to a desired value. Examples of forced control transactions include: FORCED_SIGNOFF FORCED_SIGNON FORCED_ENDOFDAY_CLOSE etc. The ForceFlag, when set to YES indicates an exception condition that should be reviewed by store operations and internal auditing. FL_FRCD Flag integer
LogoID (FK) A unique, token identifier for a Logo instance. ID_LGO Identity integer Logo(CO_LGO)
BatchID A retailer defined and managed reference to a BATCH used to group transactions for processing purposes. This is an analog for POSLOG6 Batch ID. It is an owned attribute and does not reference another entity. ID_BTCH DescriptionShort varchar(255)
SessionID (FK) A unique token ID for a Session instance. ID_SSN Identity integer Session(CO_SSN)


Parent Entity Verb Phrase Child Entity
BusinessDay is credited with Transaction
Session contains Transaction
BusinessUnit records business via Transaction
METARWeatherForecast forecasts weather conditions for Transaction
TransactionType classifies Transaction
METARWeatherCondition defines weather conditions for Transaction
RevenueCostCenter defines accounting disposition of Transaction
Logo decorates Transaction
Workstation records Transaction
Transaction audited by WorkstationRuleOverrideHistory
Transaction refers to TransactionAssociation
Transaction is referred to TransactionAssociation
Transaction was caused by VoidTransaction
Transaction was cancelled by VoidTransaction
Transaction had access overrides recorded by TransactionResourceOverride
Transaction was performed by TransactionAssociate
Transaction can be a ControlTransaction
Transaction can be a CustomerOrderControlTransaction
Transaction can be a ForecourtTransaction
Transaction can be a InventoryControlTransaction
Transaction can be a ItemProcessingTransaction
Transaction can be a RetailTransaction
Transaction can be a TenderControlTransaction

Logical Views containing Transaction

Logical View
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 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 02400 - Control Transaction Macro View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02420 - Control Transaction - Till Movement View
Logical 02430 - Control Transaction - Period Open Close View
Logical 02440 - Control Transaction - Voids View
Logical 02450 - Control Transaction - Drawer Limit
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 02600 - Inventory Control Transaction View
Logical 03130 - Reporting - Store Operations - Session View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 03160 - Reporting - Store Operations - Till View
Logical 04000 - Financial Ledger - Macro View
Logical 04200 - Financial Ledger - Tender Ctrl Transaction View
Logical 06100 - Calendar View
Logical 06220 - Access Control - Overrides View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07610 - Customer Order - Maintenance View
Logical 10102 - EnterpriseWeather
Logical 10400 - Enterprise - Channels
Logical 11140 - Worker - Retail Transaction View
Logical 11150 - Worker - Time Punch View
Logical 20000 - Forecourt Macro View
Logical 20030 - Forecourt Transaction View
Logical 21000 - Fresh Item Management Macro View