Difference between revisions of "Order Express - How To Data"
From eVision
(→Setting up Price Freeze) |
(→Setting up Price Freeze) |
||
| Line 12: | Line 12: | ||
* | * | ||
* | * | ||
| + | |||
| + | == 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 | ||
Revision as of 11:31, 2 March 2021
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
