Order Express - How To Data

From eVision
Revision as of 11:31, 2 March 2021 by Ewright (Talk | contribs)

Jump to: navigation, search

Setting up Price Freeze

  • Open SQL Management Studio
  • Find MFG database requesting change/update
  • Find Table: OEAppSettings; Right Click - Edit Top 200 Rows
  • Search for: where SETTINGNAME = 'AUTO_FREEZE_STATUS'
  • Update value for AUTO_FREEZE_STATUS with status tag that MFG wants projects automatically Frozen
           If status tag is not set for Freeze Status; follow the steps below: 
             * 
             *
             *
             *

Update TW Fuel Surcharge

  • SQL database tab – OEVariables
  • Search for variable name – FuelSurchargeMultiplier
  • Update Value within Default Value
  • Value is decimal value. So .10% should be listed as .010. 1% would be listed as .10