FS 304709 Partnerlink POD Format - Revision history

Anw: v0.2 - Added phase 2 change details.

2013-08-27T08:46:04Z

v0.2 - Added phase 2 change details.

← Older revision		Revision as of 10:46, 27 August 2013
Line 4:		Line 4:
	{{#vardefine:System\|''CALIDUS'' ePOD}}		{{#vardefine:System\|''CALIDUS'' ePOD}}
	{{#vardefine:Doc_Title\|Partnerlink POD Format}}		{{#vardefine:Doc_Title\|Partnerlink POD Format}}
	{{#vardefine:Version\|0.1}}		{{#vardefine:Version\|0.2}}
	{{#vardefine:Date\|~~19th~~ August 2013}}		{{#vardefine:Date\|27th August 2013}}
	{{#vardefine:Reference\|304709}}		{{#vardefine:Reference\|304709}}
	{{#vardefine:Year\|2013}}		{{#vardefine:Year\|2013}}
Line 52:		Line 52:
	= Functional Description =		= Functional Description =
	== Database Changes ==		== Database Changes ==
			As a phase 2 development, the following files should be changed:

	== DAL ~~Changes ==~~		EPOD_JOB:
			* Add EPL_COL_DATE (numeric).
			Existing packages will be modified to allow the creating, editing and selecting of the new field, including but not limited to:
			* EPOD_JOB_INSERT
			* EPOD_JOB_SEARCH
			* EPOD_JOB_SELECT
			* EPOD_JOB_SELECT_DATE_RANGE
			* EPOD_JOB_UPDATE
			The existing EPOD_JOB DAL object will be changed to:
			* Export the new field in XML requests
			* Read the new field
			{{Note}} It is not necessary to add this flag as a searchable item. However, if allowing this keeps the packages and DAL objects standard in design, then this can also be done, within the DAL and the packages.

			EPOD_JOB_ADDRESS:
			Existing packages will be modified to allow the creating, editing and selecting of the new field, including but not limited to:
			* Add EPL_JOB_TYPE (nvarchar(1)) to the table and to the primary key.
			* EPOD_JOB_ADDRESS_INSERT
			* EPOD_JOB_ADDRESS_DELETE
			* EPOD_JOB_ADDRESS_SELECT
			* EPOD_JOB_ADDRESS_UPDATE
			The existing EPOD_JOB DAL object will be changed to:
			* Allow creation of EPOD_JOB_ADDRESS objects using EPL_JOB_TYPE
			* Allow deletion of specific EPOD_JOB_ADDRESS objects, or all for an EPL_JOB_ID.

	== Partnerlink File Import Changes ==		== Partnerlink File Import Changes ==
			The following fields will be populated from the incoming file:
			* EPL_TRAILER_ID of EPOD_JOB - column 59 Trailer Number
			* EPL_SERVICE of EPOD_JOB - column 38 Service

			As a phase 2 development, the following fields will be populated:
			* EPL_COL_DATE of EPOD_JOB - column 16 Col Date
			* EPOD_JOB_ADDRESS - Collection and Delivery addresses will be populated, regardless of job type, identifying the job type in the new field EPL_JOB_TYPE of EPOD_JOB_ADDRESSES.
			{{Note}} All associated EPOD_JOB_ADDRESS functionality must change to identify that this new field EPL_JOB_TYPE is required at all times. This includes but is not limited to the existing Admin Job screen - developers should check the source code for any reference of EPOD_JOB_ADDRESSES and ensure that it is changed to require the Job Type.

	== POD Report Format ==		== POD Report Format ==
Line 111:		Line 140:
	* The Container list should be recognised as the Detail portion of the document, the rest seen as the header.		* The Container list should be recognised as the Detail portion of the document, the rest seen as the header.
	* The header should be shown on each page, ensuring that the signature is shown at all times.		* The header should be shown on each page, ensuring that the signature is shown at all times.

			{{Note}} Sample code exists for the new format, so please chech with the designer for details. Sample code of how multi-page reports work (for example the standard Container-based POD report) - please use this for code reference.

	<!-- MEDIA LANDSCAPE NO -->		<!-- MEDIA LANDSCAPE NO -->

Anw: Added and updated images

2013-08-22T08:44:49Z

Added and updated images

← Older revision		Revision as of 10:44, 22 August 2013
Line 25:		Line 25:
	Produce a POD format that is based closely on the following format. Ensure that the pallets delivered are shown on the report.		Produce a POD format that is based closely on the following format. Ensure that the pallets delivered are shown on the report.

	[[File:~~FS_304709_1~~.~~tif~~\|600px\|border]]		[[File:FS_304709_4.PNG\|600px\|border]]

	== Solution Overview ==		== Solution Overview ==

Anw: v0.1 - Initial Creation - still requires completion

2013-08-19T14:09:15Z

v0.1 - Initial Creation - still requires completion

New page

<div class="noprint">
{{#vardefine:Client|PART}}
{{#vardefine:ClientName|PartnerLink}}
{{#vardefine:System|''CALIDUS'' ePOD}}
{{#vardefine:Doc_Title|Partnerlink POD Format}}
{{#vardefine:Version|0.1}}
{{#vardefine:Date|19th August 2013}}
{{#vardefine:Reference|304709}}
{{#vardefine:Year|2013}}
</div>
{{Doc_Title
|Client={{#var:ClientName}}
|System={{#var:System}}
|Title={{#var:Doc_Title}}
|Reference=FS {{#var:Reference}}
|Version={{#var:Version}}
|Date={{#var:Date}}
|Year={{#var:Year}}
}}


<div class="noprint">
= Functional Overview =
== Client Requirement ==
Produce a POD format that is based closely on the following format. Ensure that the pallets delivered are shown on the report.

[[File:FS_304709_1.tif|600px|border]]

== Solution Overview ==
A POD report format will be produced.

This format will be configurable against the Partners.

== Scope ==
* These changes will be made in the latest version of the {{#var:System}} system.
* It is noted that this change will be split into two phases.
** Phase 1 will include all except the Consignee address and Collection Date.
** Phase 2 will complete the delivery.


= Set-up =

== Pre-requisites ==

== Menu Structure ==
None

== Data ==


= Functional Description =
== Database Changes ==

== DAL Changes ==

== Partnerlink File Import Changes ==

== POD Report Format ==
Fields on the POD report:
* Partnerlink Logo - removed if this is a Palletforce job (EPL_JOB_GROUP = "PALLET")
* Customer - EPL_CUSTOMER_CODE
* Consignment Details - EPL_JOB_CODE
* Consignor - the address of the consignor (collection address). For Phase 1, this will be labelled as "By" and will show the Site address (operating partner).
** Company - EPL_CUSTOMER_NAME of EPL_CUSTOMER
** Address - EPL_ADDRESS_LINE_1/2/3/4/5 of EPL_CUSTOMER
** Postcode - EPL_POST_CODE of EPL_CUSTOMER
** Phone - EPL_PHONE_NO of EPL_CUSTOMER
* Deliver To - the delivery address.
** Company - EPL_CUSTOMER_NAME of EPL_CUSTOMER
** Address - EPL_ADDRESS_LINE_1/2/3/4/5 of EPL_JOB_ADDRESS (or EPL_CUSTOMER if this does not exist)
** Postcode - EPL_POST_CODE of EPL_JOB_ADDRESS (or EPL_CUSTOMER if this does not exist)
** Phone - EPL_PHONE_NO of EPL_JOB_ADDRESS (or EPL_CUSTOMER if this does not exist)
* Driver - EPL_DRIVER_NAME of EPOD_DRIVER
* Vehicle - EPL_VEHICLE_REG of EPOD_VEHICLE
* Track Num - EPL_EXT_REF
* Trailer Number - EPL_TRAILER_ID
* Col Date - New field - excluded in phase 1
* Manifest Title - removed
* Manifest Number - EPL_LOAD_ID
* Del Date - EPL_START_PLANNED_DATE
* Service - EPL_SERVICE
* Del Time - EPL_START_PLANNED_TIME
* Conditions - Hard-coded
* Customer Ref - EPL_CUST_REF
* Customer Ref2 - EPL_SO_REF
* Barcode - removed
* Consignment Instructions - EPL_JOB_INSTRUCTION
* Total Packs - Calculated from number of the job's container records (not including loose products)
* Total Weight - subtotalled from EPL_GROSS_WEIGHT of the job's container records (not including loose products)
* Cubic - removed
* Consignee Signature - EPL_SIGNATURE
* Printed Name - EPL_SIGNATORY
* Date - EPL_END_ACTUAL_DATE
* Arrival Time - EPL_ARRIVAL_TIME
* Departure Time - EPL_END_ACTUAL_TIME
{{Note}} All fields are from EPOD_JOB unless otherwise specified.

The customer also required that the status of the pallets delivered should be shown on the note. Due to this, and the slight changes to the content of the note shown above, the note has been redesigned as a A4 document, where the existing format (slightly modified for space) is the header of the document, followed by a list of pallets, their status and and descriptive text associated to them, as in the prototype shown.

[[File:FS_304709_2.PNG|600px|border]]
* Item - EPL_CONTAINER_ID
* Status - EPL_STATUS (translated)
* Notes - EPL_USER_NOTES (if claused) else EPL_REASON_CODE and EPL_DESCRIPTION of EPOD_REASON_CODE
{{Note}} All fields are from EPOD_CONTAINER unless otherwise specified.
Developer Notes:
* As there is a possibility that the number of containers will exceed that allowable on a page, the format should be written as a paginated document. The style of this should be copied from previous examples (e.g. ALS.aspx.cs).
* 30 lines should be allowed per page.
* The Container list should be recognised as the Detail portion of the document, the rest seen as the header.
* The header should be shown on each page, ensuring that the signature is shown at all times.


{{Doc_Appendix
|Appendix=A
|Estimate=N
|Glossary=EPOD
|Ref1= 
|RefV1= 
|RefDate1= 
|REQ=0
|EST=0
|FS=0
|TS=0
|DEV=0
|ST=0
|IMP=0
|Client={{#var:Client}}
|Year={{#var:Year}}
|FSEST=Y
|Rev1=Phil Harding
|Rev1Title=OBS Project Manager
|Rev1=Andrew Allison
|Rev1Title=Client Representative
}}</div>
[[Category:{{#var:Client}} FS]]