Difference between revisions of "Order Express - How To Data"
From eVision
(→Setting up Price Freeze) |
(→Update TW Fuel Surcharge) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | This page contains answers to a variety of common data updates for Order Express overall and for specific clients. Please review the table of contents below to see if your question has been answered. | ||
| + | |||
| + | __FORCETOC__ <!-- Force the table-of-contents to appear even if there are fewer than 4 categories on this page. --> | ||
| + | |||
== Setting up Price Freeze == | == Setting up Price Freeze == | ||
| − | * Open SQL | + | * Open SQL Management Studio |
| − | * Table: OEAppSettings; Right Click - Edit Top 200 Rows | + | * Find MFG database requesting change/update |
| + | * Find Table: OEAppSettings; Right Click - Edit Top 200 Rows | ||
* Search for: where SETTINGNAME = 'AUTO_FREEZE_STATUS' | * 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: | ||
| + | * | ||
| + | * | ||
| + | * | ||
| + | * | ||
| + | |||
| + | == Updating 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 | ||
Latest revision as of 11:33, 2 March 2021
This page contains answers to a variety of common data updates for Order Express overall and for specific clients. Please review the table of contents below to see if your question has been answered.
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:
*
*
*
*
Updating 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
