287319
DHL MTS
Changes to Location Extract
FUNCTIONAL SPECIFICATION - 10.6
- 0.1
Reference: FS 287319 MW-8BNLRX
Client Requirement
Change Request Summary:
Changes to the Locations extract.
Change Request Details:
Add the 1st 3 contact details to the existing output.
Benefits identified as a result of the change:
Removes the requirement to keep the existing spread sheet supplier contact details.
Solution
The existing location extract includes the following data:
Location_Id, Location_Name, Depot, Address_Line1, Address_Line2, Address_Line3, Town, County, Country, Country_Code, Postcode, Postal_Region, Planning Region, Cost_Centre_Name, Lat., Long., Loading_Rate, Unloading_Rate, Inactive, Created By, Created Date
The following data will be added after ‘Created Date’ for the first three lines displayed in the ‘Contacts’ tab page of the ‘Locations’ screen:
‘Surname’, ‘Forename’, ‘Job Title’, ‘Phone’, ‘Email’.
These contacts will be repeated with the suffix ‘1’, ‘2’ or ‘3’ to indicate which contact information is being displayed.
The first three lines will be taken using the ‘ID’, i.e. the sequence in which the contacts have been added for the location and the sequence in which they are displayed in the screen.
Scope
This change will be applied to system version 10.6.0 on IIBTST and once approved IIBPRD.
Set-up
Pre-requisites
None
Menu Structure
‘Unchanged’
Data
The report parameter for the ‘Location Export’ will need to be updated to run procedure ‘LOCATION_EXPORT’ in package ‘DP_CSV2’.
Functional Description
The database procedure ‘LOCATION_EXPORT’ will be added to package ‘DP_CSV2’ with the same name and parameter list.
The report parameter ‘REP_REPORT.PROC_NAME’ will be changed to run the procedure from the package.
The following data will be added to the ‘Location Export’ after ‘Created Date’ for the first three lines displayed in the ‘Contacts’ tab page of the ‘Locations’ screen:
‘Surname’, ‘Forename’, ‘Job Title’, ‘Phone’, ‘Email’.
These contacts will be repeated with the suffix ‘1’, ‘2’ or ‘3’ to indicate which contact information is being displayed.
The first three lines will be taken using the ‘ID’, i.e. the sequence in which the contacts have been added for the location and the sequence in which they are displayed in the screen.
The data will be obtained as follows:
| Item | Table | Column |
| Surname | GEO_CONTACT | SURNAME |
| Forename | GEO_CONTACT | FORENAME |
| Job Title | GEO_CONTACT | JOB_TITLE |
| Phone | GEO_CONTACT | PHONE |
| GEO_CONTACT |
A new cursor will be created to obtain the 3 contacts for the location in a new loop run within the existing loop that obtains each set of location details.
The headings will now be displayed as follows with commas as delimiters:
| Heading |
| Location_Id |
| Location_Name |
| Depot |
| Address_Line1 |
| Address_Line2 |
| Address_Line3 |
| Town |
| County |
| Country |
| Country_Code |
| Postcode |
| Postal_Region |
| Planning_Region |
| Cost_Centre_Name |
| Lat. |
| Long. |
| Loading_Rate |
| Unloading_Rate |
| Inactive |
| Created By |
| Created Date |
Plus the new items for the contacts:
| Heading |
| Surname1 |
| Forename1 |
| Job Title1 |
| Phone1 |
| Email1 |
| Surname2 |
| Forename2 |
| Job Title2 |
| Phone2 |
| Email2 |
| Surname3 |
| Forename3 |
| Job Title3 |
| Phone3 |
| Email3 |
References
| EST-287319 MW-8BNLRX Changes to Location Extract v1.0.doc | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
