5.1.351 - DWE Enhancements

5.1.351 - DWE Enhancements

Version: 5.1
Patch: 351
Title: DWE Enhancements
Application Category: Other, Reports
Patch Type: Feature


Data Warehouse improvements
1. Allow more than 5 columns in "flattened mode" (new option added in DW config screen)
2. Consolidated some SQL/code used by both DW modes 

Unrelated fix also added: 
Fixed JS issue with Single Job Status component, which could prevent the output from displaying when some jobs run. 

Changes For DWE
  1. Removed redundant item level columns from "tblFlattenedDatawarehouseColumns" as these will get generated dynamically.
  2. Add new field named "shipTransID" to "tblFlattenedDatawarehouseColumns"
  3. Add new configuration named "Items Per line" to other section 


  1. Flattened Export Definitions
    • Related Articles

    • 5.1.264 - Tax System enhancements

      Version: 5.1 Patch: 264 Title: Tax System enhancements Application Category: Other; Payment Processing; Order Entry Patch Type: Feature Description: Enhancements to the Tax Calculator subsystem to support multiple tax service accounts (for ...
    • 5.1.347 - Scheduler_restart_enhancements

      Version: 5.1 Patch: 347 Title: Scheduler_restart_enhancements Application Category: Other, Other Processing Patch Type: Feature Description: Scheduler stability improvements and fixes to multi-server job management features.  Articles:
    • 5.1.260 - Portal Subscription Enhancements

      Version: 5.1 Patch: 260 Title: Portal Subscription Enhancements Application Category: Other; CS Functionality (1) Patch Type: Feature Description: Customer Portal new functionality for autoships/subscriptions, and GUI enhancements.  Information about ...
    • 5.1.20 - RMA Feature Enhancements

      Version: 5.1 Patch: 020 Title: RMA Feature Enhancements Application Category: Other Patch Type: Feature Description: Added [RMA ID] as an alias that can be included in Notifications.  Added feature to add a new product to an order when an RMA is ...
    • 5.1.187 - Order Exception Management Enhancements

      Version: 5.1 Patch: 187 Title: Order Exception Management Enhancements Application Category: Other; Order Entry; API; Import Processing Patch Type: Bug Description: Exception management screen fix. Manual changes to the order details (in the ...