E
Enactor Platform
Releases > Q1 26 > Schema Changes
Schema Changes
Q1 26 Schema Changes
Database table schema version changes between 2.7.1331.267 and 2.7.1784.39. Most changes add indexes for report optimisation; a small number add functional columns.
Schema Changes from previous release
| Table Name | Schema Version (2.7.1784.39) | Previous Schema Version (2.7.1331.267) | Changes |
|---|---|---|---|
accountCredentials | 1.4 | 1.3.1 | No difference in mappings; only the version has changed. |
additionalItemDetail | 1.1 | - | New table. |
cashManagementTender | 1.21 | 1.18 | 3 new columns and 2 new indexes for reports optimisation (TradingSummary, ReasonCodeByWeekday, CashOnHand). Columns: Location_Id, Tender_Description, Completed_Date_Time. Indexes: CMTDateKeyIndex, CMTTransReasonIndex. |
cmSession | 1.14 | 1.13 | One new index for reports optimisation (CashOnHand). Index: CashSessionsLocDateTypeOwnId. |
cmTransaction | 1.60 | 1.57.2 | 4 new indexes for reports optimisation (CashManagement, DailySalesSummary). Indexes: CashTransactionsCompoIdx, CashTxnsVoidedLocCurrTypeDt, CashTxnsOrigEffDateIdx, CTranItms_Item_Type. |
customer | 1.59 | 1.56.1 | One new column and index for the webshop customer create/login. Column: Login_Id. Index: CustomerLoginIdIndex. |
document | 1.19 | 1.18 | One new column timestamp. No functional dependencies. |
inventoryDispatchHeader | 1.31.3 | 1.31.2 | — |
inventoryType | 1.12 | 1.11 | One new column Security_Clearance_Required. The new field "Requires Security Clearance" has been added to Inventory Type Maintenance based on this column. Required by the Serial Number Security API. |
itemInventorySerialNumber | 1.3 | 1.2 | Two new columns: Last_Transaction_Type, Last_Updated_By_User. No functional dependencies. |
merchandiseTransaction | 1.9.3 | 1.9.2 | New index Merchandisetrs_YDH to optimise the SalesAnalysisByHour report. |
nonMerchandiseTransaction | 1.9.2 | 1.9.1 | New index Nonmerchandisetrs_YDH to optimise the SalesAnalysisByHour report. |
productFilterMetadata | 1 | - | New table. |
productSale | 1.20 | 1.16 | 9 new columns and 3 indexes. Columns: Device_Id, Location_Id, Base_Currency_Id, Completed_Date_Time, Serial_Number, Style_Id, Colour_Description, Size_Description, MMGroup_Name. Indexes: ProductSalesLocDate, ProductSalesUDLTIndex, ProdSalesProdDetailsIdx. The Serial_Number column has no functional dependencies; the rest optimise the ProductSales, TransactionTotals, and Replenishment reports. |
regionalProduct | 1.5 | 1.4.1 | Two column properties were changed; no functional dependencies. |
retailTransactionArchive | 3.37.5 | 3.37.4 | — |
supplementaryTransactionReference | 1.1 | - | New table for the Supplementary Transaction Reference feature. |
tenderTransaction | 1.27 | 1.25.2 | 4 new columns and one index for reports optimisation (TradingSummary, TerminalX). Columns: Base_Currency_Id, Day_Of_Week, Card_Description, Owner_Id. Index: TenderTxCashOwnerIdx. |
terminalException | 1.21.6 | 1.21.5 | One new index for reports optimisation (ReasonCodeByWeekday). Index: TerminalExceptTypeReasonIdx. |
updateDetail | 1.2 | 1.1 | One new column Type to distinguish between Application Update Details and Payment Device Update Details. |