FS 351399 Decimal Pack Size
Marshalls Stone
Decimal Pack Size
CALIDUS ePOD
26th June 2018 - 0.1
Reference: FS 351399
Contents
Functional Overview
Client Requirement
Marshalls uses decimal quantities in pack size, for example, when the product is measured in Area (m2), a standard pack may cover 2.2m2. Therefore the pack size within CALIDUS ePOD must be decimal.
Solution Overview
The standard XML import will be modified to receive decimal pack size and store the value on the database.
The entry and amendment of pack size in the Admin screen will be modified to allow decimal values.
The Admin Products and Containers screen will allow amenment and creation of products with a decimal pack size.
The POD report will use this value to calculate the number of packs.
Scope
Changes will be made to latest version of CALIDUS ePOD only.
It is expected that only the server-side components will require updating, but changes to the device may be necessary at the time of release to bring the product versions up to the latest compatible version.
Set-up
Pre-requisites
Menu Structure
Data
Functional Description
Database & DAL
Change EPL_PRODUCT_QTY_CASE on EPOD_PRODUCT to be a float type.
Change XMLUpload.xsd to change EPL_PRODUCT_QTY_CASE to xsd:float in EPOD_JOB and EPOD_LOAD tags.
Change EPOD_JOB.xsd to change EPL_PRODUCT_QTY_CASE to xsd:float.
Update export and import documentation to reflect this.
Change EPOD_PRODUCT DAL object EPOD_PRODUCT method to cast the XML value as a float rather than as an int when converting the value or when receiving this as a parameter.
Change EPOD_PRODUCT DAL object PopulateFromReader method to convert to Double and cast to float rather than int. See code for EPL_PRODUCT_QTY_PLANNED for details.
Change EPOD_PRODUCT DAL object GetParameters and GetParametersForSelect methods to set the pEPL_PRODUCT_QTY_CASE parameter type to type string, and convert the value to string.
The EBB Paper Import uses the pack size to determine the number of cases. This must be checked to ensure that the case and units values still calculate correctly.
Admin
The Container/Products screen (products_containers.aspx) will be modified to allow entry or amendment of the Pack Size field as a decimal value. See code for EPL_PRODUCT_QTY_PLANNED for details.
- epdSaveBtn_Clicked will convert txtCaseQty to float rather than int.
- TextBox ID txtCaseQty will have a field validator, regex validator and callout extended added to validate the entry as a decimal value. The existing mask will be removed.
Configurable POD Report
The configurable POD report (ConfigPOD.aspx) uses the pack size to determine the number of cases in the Marshalls format. This must be checked to ensure that the case and units values still report correctly.
Mobile Device Application
The Mobile Device application uses the pack size to determine the number of cases in the Marshalls format. This must be checked to ensure that the case and units values still calculate and display correctly.
Appendix A: Quote & Document References
| Cost Details | ||||
| Activity | Estimate No. of Days |
No. of Days | Rate per Day (£) | Cost (£ Exc. VAT) |
| Requirements | 0.00 | 0.00 | 750 | £0.00 |
| Change Request Evaluation | 0.00 | 0.00 | 750 | £0.00 |
| Functional Specification | 0.25 | 0.25 | 750 | £187.50 |
| Technical Specification | 0.00 | 0.00 | 750 | £0.00 |
| Development | 2.75 | 2.75 | 750 | £2,062.50 |
| Testing and Release | 0.50 | 0.50 | 750 | £375.00 |
| Implementation | 0.25 | 0.25 | 750 | £187.50 |
| Project Management | 0.50 | 0.50 | 750 | £375.00 |
| TOTAL | 4.25 | 4.25 | £3,187.50 | |
| Estimate excludes training, release to live and go live support. |
A.1 References
| Ref No | Document Title & ID | Version | Date |
| 1 |
A.2 Glossary
| Term | Definition |
|---|---|
| EPOD | Electronic Proof of Delivery. The OBS EPOD system is CALIDUS ePOD. |
| CALIDUS eSERV | The OBS mobile system to complete Service functionality in the field. This is part of the CALIDUS ePOD system. |
| PDA | The mobile device on which the C-ePOD system will run in the field. This can be a Phone, EDA or industrial PDA, running Android. |
| DAL | Data Access Layer. A mechanism for accessing data by the system that is removed from the application, allowing for simplified access and providing protection to the data, as only approved DAL methods can be used to modify it. |
| GPS | Global Positioning System. A mechanism of retrieving accurate positioning information in the form of Latitude and Longitude (Lat-Long) co-ordinates from a device. |
| GPRS, 3G, HSDPA, Data Service | All terms referring to mobile device network connectivity, and the speed at which the device connects to the internet. |
A.3 Authorised By
Matt Turner | OBSL Account Manager | _____________________________ |
Simon Martin | Customer Representative | _____________________________ |
