291373 - Revision history

Middletong at 14:44, 4 October 2012

2012-10-04T14:44:48Z

← Older revision		Revision as of 16:44, 4 October 2012
Line 414:		Line 414:

	[[Image:291373_27.png]]		[[Image:291373_27.png]]

			Supporting Notes –

			Failure reasons will be reported from the order and if more than one failure code has been entered, the first one will be reported in the output.

			The Order Mileage Override Flag and Order Mileage Override will not be supported by C-TMS. Any changes to the revenue to charge to NR manually input into C-TMS will be qualified by the user by entry of comments in the special Instructions field of the order.

			The Journey Mileage Override Flag and Journey Mileage Override will not be supported by C-TMS. Any changes to the cost to be charged by a carrier manually input into C-TMS will be qualified by the user by entry of comments in the General Comments field for the Trip. (A new column will be included into the definition above to accommodate this field).

			The Raised By, Approver and Cost Centre values will be reported from fields in the additional references found against each order. The Additional References functionality in C-TMS allows dynamic configuration of new fields to store ‘miscellaneous’ or ‘general’ information about an order against a user defined label (rather than developing specific fields in the C-TMS database).

			The extract will be developed into the standard CSV processing package. A new procedure to select the data and a new procedure to write the data to the extract file will be added to the existing program. The extract will have a start and end schedule and a cost centre parameters which must be populated to extract the relevant data. The output will be sorted by trip reference and order reference.


			=REFERENCES=

			{\| Border="1"
			\| <center>'''Ref No'''</center>
			\| <center>'''Document Title & ID'''</center>
			\| <center>'''Version'''</center>
			\| <center>'''Date'''</center>

			\|-
			\| <center>1</center>
			\| EST-291378 –MA-8KNHMH Output Reports and Extracts
			\| <center>1.0</center>
			\| <center>20/10/11</center>
			\|}


			=DOCUMENT HISTORY=

			{\| Border="1"
			\| <center>'''Version'''</center>
			\| <center>'''Date'''</center>
			\| <center>'''Status'''</center>
			\| <center>'''Reason'''</center>
			\| <center>'''Initials'''</center>

			\|-
			\| <center>0.1</center>
			\| <center>24/10/11</center>
			\| <center>Draft</center>
			\| Initial version
			\| <center>CAK</center>

			\|-
			\| <center>1.0</center>
			\| <center>27/10/11</center>
			\| <center>Issued</center>
			\| Reviewed and Issued
			\| <center>MJC</center>

			\|-
			\| <center>1.1</center>
			\| <center>10/11/11</center>
			\| <center>Draft</center>
			\| Revised
			\| <center>CAK</center>

			\|-
			\| <center>2.0</center>
			\| <center>10/11/11</center>
			\| <center>Issued</center>
			\| Reviewed and Issued
			\| <center>MJC</center>

			\|-
			\| <center>2.2</center>
			\| <center>06/12/11</center>
			\| <center>Draft</center>
			\| Revised
			\| <center>CAK</center>

			\|-
			\| <center>3.0</center>
			\| <center>06/12/11</center>
			\| <center>Issued</center>
			\| Reviewed and Issued
			\| <center>DJM</center>

			\|-
			\| <center>3.1</center>
			\| <center>07/12/11</center>
			\| <center>Review</center>
			\| Reviewed by DHL
			\| <center>TG</center>

			\|-
			\| <center>4.0</center>
			\| <center>07/12/11</center>
			\| <center>Issued</center>
			\| Re-issued
			\| <center>DJM</center>

			\|}


			=AUTHORISED BY=



			{\| Border="1"
			\| '''''Matt Crisford'''''
			\| Development Manager
			\|

			\|-
			\| '''''Peter Greer'''''
			\| TMSCC MTS Product Manager
			\|

			\|}

Middletong: /* Additional Reporting Requirements */

2012-10-04T14:34:42Z

Additional Reporting Requirements

← Older revision		Revision as of 16:34, 4 October 2012
Line 404:		Line 404:

	[[Image:291373_22.png]]		[[Image:291373_22.png]]

	[[Image:291373_23.png]]		[[Image:291373_23.png]]

	[[Image:291373_24.png]]		[[Image:291373_24.png]]

	[[Image:291373_25.png]]		[[Image:291373_25.png]]

	[[Image:291373_26.png]]		[[Image:291373_26.png]]

	[[Image:291373_27.png]]		[[Image:291373_27.png]]

Middletong at 14:32, 4 October 2012

2012-10-04T14:32:28Z

← Older revision		Revision as of 16:32, 4 October 2012
Line 402:		Line 402:

	The following information is required in the extract		The following information is required in the extract

			[[Image:291373_22.png]]
			[[Image:291373_23.png]]
			[[Image:291373_24.png]]
			[[Image:291373_25.png]]
			[[Image:291373_26.png]]
			[[Image:291373_27.png]]

Middletong at 14:20, 4 October 2012

2012-10-04T14:20:05Z

Show changes

Middletong: /* Additional Reporting Requirements */

2012-10-04T11:33:07Z

Additional Reporting Requirements

← Older revision		Revision as of 13:33, 4 October 2012
Line 574:		Line 574:
	\| style="border:3px solid darkblue;"\|'''C Contact Name'''		\| style="border:3px solid darkblue;"\|'''C Contact Name'''
	\| style="border:3px solid darkblue;"\|GEO_CONTACT		\| style="border:3px solid darkblue;"\|GEO_CONTACT
	\| style="border:3px solid darkblue;"\|FORENAME \|\| SURNAME		\| style="border:3px solid darkblue;"\|FORENAME / SURNAME
	\| style="border:3px solid darkblue;"\|Use FROM_LOC of SCH_ORD to GC.LOCATION_CODE. If more than one contact display only first contact.		\| style="border:3px solid darkblue;"\|Use FROM_LOC of SCH_ORD to GC.LOCATION_CODE. If more than one contact display only first contact.

Middletong: /* Additional Reporting Requirements */

2012-10-04T11:32:35Z

Additional Reporting Requirements

Show changes

Middletong at 10:27, 4 October 2012

2012-10-04T10:27:51Z

← Older revision		Revision as of 12:27, 4 October 2012
Line 402:		Line 402:

	The following information is required in the extract		The following information is required in the extract

			{\| class="wikitable" align=left width=55% style="background:lightyellow;color:black;"

			\|-
			! style="background:darkblue;color:white;"\| REQUIRED FIELDS
			! style="background:darkblue;color:white;"\| C-TMS TABLE
			! style="background:darkblue;color:white;"\| C-TMS FIELD
			! style="background:darkblue;color:white;"\| CALCULATION / NOTES

			\|-
			\| style="border:3px solid darkblue;"\|'''Date Imported/Created'''
			\| style="border:3px solid darkblue;"\|SCH_ORD
			\| style="border:3px solid darkblue;"\|CREATED_DATE
			\| style="border:3px solid darkblue;"\|

			\|-
			\| style="border:3px solid darkblue;"\|'''Manual order (Y/N)'''
			\| style="border:3px solid darkblue;"\|SCH_ORD
			\| style="border:3px solid darkblue;"\|MANUAL_ORDER
			\| style="border:3px solid darkblue;"\|NVL = "N"
			\|}
			<br/>
			<br/>

Middletong at 10:21, 4 October 2012

2012-10-04T10:21:51Z

← Older revision		Revision as of 12:21, 4 October 2012
Line 394:		Line 394:

	[[Image:291373_20.png]]		[[Image:291373_20.png]]

			==Additional Reporting Requirements==

			An extract will be developed and will be available to be run from the Exports Screen an example of which is shown below

			[[Image:291373_21.png]]

			The following information is required in the extract

Middletong at 10:03, 4 October 2012

2012-10-04T10:03:32Z

← Older revision		Revision as of 12:03, 4 October 2012
Line 384:		Line 384:

	[[Image:291373_18.png]]		[[Image:291373_18.png]]

			==Short Rail Report==

			An extract will be developed and will be available to be run from the Exports Screen an example of which is shown below

			[[Image:291373_19.png]]

			The extract will be developed into the standard CSV processing package. A new procedure to select the data and a new procedure to write the data to the extract file will be added to the existing program. The extract will have SCHEDULE_FROM, SCHEDULE_TO and PRODUCT TYPE as parameters. Only data associated with the cost centre of the user running the report will be selected. The data will be sorted by trip schedule and trip id. The report can be run for any valid product type. The following information is required in the report.

			[[Image:291373_20.png]]

Middletong at 10:00, 4 October 2012

2012-10-04T10:00:36Z

← Older revision		Revision as of 12:00, 4 October 2012
Line 374:		Line 374:

	Report totals will be provided as a footing average of planned distance, actual distance, fuel drawn, hours worked, shipment weight, capacity weight and fill.		Report totals will be provided as a footing average of planned distance, actual distance, fuel drawn, hours worked, shipment weight, capacity weight and fill.

			==Approved Price Report==

			An extract will be developed and will be available to be run from the Exports Screen an example of which is shown below

			[[Image:291373_17.png]]

			The extract will be developed into the standard CSV processing package. A new procedure to select the data and a new procedure to write the data to the extract file will be added to the existing program. The extract will have a “from” and “to” created date range and optionally customer account as parameters. Only data associated with the cost centre of the user running the report will be selected. The output rows will be sorted by created date and then order reference. The following information will be required.

			[[Image:291373_18.png]]

← Older revision		Revision as of 13:33, 4 October 2012
Line 574:		Line 574:
	\| style="border:3px solid darkblue;"\|'''C Contact Name'''		\| style="border:3px solid darkblue;"\|'''C Contact Name'''
	\| style="border:3px solid darkblue;"\|GEO_CONTACT		\| style="border:3px solid darkblue;"\|GEO_CONTACT
	\| style="border:3px solid darkblue;"\|FORENAME \|\| SURNAME		\| style="border:3px solid darkblue;"\|FORENAME / SURNAME
	\| style="border:3px solid darkblue;"\|Use FROM_LOC of SCH_ORD to GC.LOCATION_CODE. If more than one contact display only first contact.		\| style="border:3px solid darkblue;"\|Use FROM_LOC of SCH_ORD to GC.LOCATION_CODE. If more than one contact display only first contact.

← Older revision		Revision as of 12:27, 4 October 2012
Line 402:		Line 402:

	The following information is required in the extract		The following information is required in the extract

			{\| class="wikitable" align=left width=55% style="background:lightyellow;color:black;"

			\|-
			! style="background:darkblue;color:white;"\| REQUIRED FIELDS
			! style="background:darkblue;color:white;"\| C-TMS TABLE
			! style="background:darkblue;color:white;"\| C-TMS FIELD
			! style="background:darkblue;color:white;"\| CALCULATION / NOTES

			\|-
			\| style="border:3px solid darkblue;"\|'''Date Imported/Created'''
			\| style="border:3px solid darkblue;"\|SCH_ORD
			\| style="border:3px solid darkblue;"\|CREATED_DATE
			\| style="border:3px solid darkblue;"\|

			\|-
			\| style="border:3px solid darkblue;"\|'''Manual order (Y/N)'''
			\| style="border:3px solid darkblue;"\|SCH_ORD
			\| style="border:3px solid darkblue;"\|MANUAL_ORDER
			\| style="border:3px solid darkblue;"\|NVL = "N"
			\|}
			<br/>
			<br/>