290897
DHL C-TMS
Enter & Store Average Weight per DU
FUNCTIONAL SPECIFICATION - 10.7
09/08/2011 - 1.0
Reference: FS 290897 AR-8KCAPM
Functional Overview
Client Requirement
Change Request Summary:
Include average weight and calculate weight of order for planning (suggested RIO #2)Paul McGoran/Manchester/UK/NFC
Change Request Details:
Provide a mechanism to enter & store average weight per DU. Use the DU average weight to calculate weight per order, so that this is available to hand off in the Paragon interface.Consider this as a 4th priority in total RIOs for this project.
Benefits identified as a result of the change:
Allows Paragon to more accurately calculate the insertion of scrap unload sites based on vehicle fill
Solution
A new data column will be added to the table RES_DESPATCH_UNIT_TYPE called AVG_WEIGHT. The new data item will be displayed and maintained from the Resources screen under the Maintenance Menu, in the Despatch Unit Type tab page.
A cost centre parameter will be created called OMS_AVG_WEIGHT and will be populated with the value Y or N. If this cost centre parameter has been set to Y, the weight field held against the order line (SCH_ORDER_LINE.WEIGHT) will be populated using a calculation of the average weight for the DU type multiplied by the planned quantity.
Additionally, if the cost centre parameter has been set, the user will not be able to manually enter the weight against the order lines.
The total weight against the order will be calculated using a total of the weight at the order line level.
Scope
This change will be applied to system version 10.7.
Set-up
Pre-requisites
None
Menu Structure
Unchanged
Data
A new record will be added to the ADM_SYSTEM_PARAM table:
Param_nameOMS_AVG_WEIGHT
Config_byCOST_CENTRE
Config_by_valueBGWCC
ValueY
DescriptionUses average weight to calculate the weight against an order.
Implementation Advice
A new cost centre parameter will be added and can be edited from the System Parameter Maintenance screen. The new parameter will be called OMS_AVG_WEIGHT and will be created specifically for the British Gas Waste Cost Centre.
Functional Description
A new field will be added to the RES_DESPATCH_UNIT_TYPE table, called AVG_WEIGHT. The new field will be viewable via the Resources maintenance screen as displayed below:
The field will be displayed in the Edit Despatch Unit Type screen, where users will be able to update the value.
When an order line is added, the weight field will be populated based on the average weight assigned to the DU_TYPE and the quantity. This calculation will only be triggered if the cost centre parameter has been set as required and will be performed as part of the Order validation functionality.
If the parameter has been set, triggering the calculation, users will be unable to manually enter any values in the weight field. If an average weight has not been entered for a DU_TYPE and the parameter has been set to Y, a value of 1 will be used in the calculation. In addition to calculating planned weight, if any actual quantities are populated, the system will also calculate the actual weight.
The total weight held against the order will be calculated based on the weight assigned to each order line.
Table Updates Required
A new column will be added to the RES_DESPATCH_UNIT_TYPE table called AVG_WEIGHT.
ALTER TABLE RES_DESPATCH_UNIT_TYPE
ADD COLUMN AVG_WEIGHT NUMBER(5,2);
References
| EST290897 AR-8KCAPM Enter & store average weight per DU v1.0 | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Reviewed and Issued | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
