Extracts - Revision history

Anw: Added full extracts and parameters list

2025-04-16T14:35:16Z

Added full extracts and parameters list

← Older revision		Revision as of 16:35, 16 April 2025
Line 128:		Line 128:

	A series of extracts relating to WCS Scanning has been created - these are available in section [[Extracts - WCS Scanning]].		A series of extracts relating to WCS Scanning has been created - these are available in section [[Extracts - WCS Scanning]].

			A list of all extracts including their parameters is shown in section [[Extracts List]].

Anw: Added searchable tables

2024-07-24T08:28:31Z

Added searchable tables

← Older revision		Revision as of 10:28, 24 July 2024
Line 31:		Line 31:
	== Available Extracts ==		== Available Extracts ==
	The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 extracts.		The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 extracts.
	{\| class="wikitable" ~~cellpadding~~="10" ~~cellspacing~~="~~0" border="1~~"		{\| class="wikitable apt-searchable" border="1" id="extracts"
	\|- bgcolor="silver"		\|- bgcolor="silver"
	!Export!!Description		!Export!!Description

Anw: Added details of Equipment Moves Extract

2024-06-28T07:53:29Z

Added details of Equipment Moves Extract

← Older revision		Revision as of 09:53, 28 June 2024
Line 31:		Line 31:
	== Available Extracts ==		== Available Extracts ==
	The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 extracts.		The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 extracts.
			{\| class="wikitable" cellpadding="10" cellspacing="0" border="1"
	{\| cellpadding="10" cellspacing="0" border="1" ~~width~~="~~80%~~"		\|- bgcolor="silver"
	!Export		!Export!!Description
	!Description
	\|-		\|-
	\|Accruals		\|Accruals
Line 68:		Line 67:
	\|Depot Exits by Hour (RPE)		\|Depot Exits by Hour (RPE)
	\|This export shows which products were unloaded – in hourly chunks on a range of dates in RPE		\|This export shows which products were unloaded – in hourly chunks on a range of dates in RPE
			\|-
			\|Equipment Moves
			\|The export extracts all of the equipment (DU Type) despatches, receipts, returns and exchanges.

			You can select by From/To Date/Time, Customer, Carrier and Owning Depot.

			The extract lists the following information: Action Date, Type, Customer, Planned Date, Actual Date, MTS Ref, Cust Ref, Del DU Type, Planned Del Qty, Carrier, Ticket Received, Trip, From Loc, To Loc, Stop, Action DU Type, Prev Qty, New Qty, Move, User
	\|-		\|-
	\|Extract Lane		\|Extract Lane

Anw: Merged from training document

2024-05-17T08:26:11Z

Merged from training document

← Older revision		Revision as of 10:26, 17 May 2024
Line 6:		Line 6:


	== Generating Exports ===		== Generating Exports ==
	Once you click on the Exports option, the form as shown below will be displayed.		Once you click on the Exports option, the form as shown below will be displayed.

Line 30:		Line 30:

	== Available Extracts ==		== Available Extracts ==
			The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 extracts.

	{\| cellpadding="10" cellspacing="0" border="1" width="80%"		{\| cellpadding="10" cellspacing="0" border="1" width="80%"
	!Export		!Export

Anw: Merged from training document

2024-05-17T08:13:40Z

Merged from training document

@@ Line 1: / Line 1: @@
-The Exports module of [[C-TMS]] enables the generation of pre-defined [[CSV]] files.  Requirements for particular exports are defined by the business and once exports have been developed and installed onto [[C-TMS]], they are available to users via the Exports form shown below.
+C-TMS Exports provides the users with Extracts of data that are required for day to day operations, finance and management reporting.
-<center>[[Image:extract_1.jpg]]</center>
+Requirements for particular exports are defined by the business and once exports have been developed and installed onto C-TMS, they are available to users via the Exports form.
 == Available Extracts ==
 {| cellpadding="10" cellspacing="0" border="1" width="80%"
 !Export
@@ Line 97: / Line 121: @@
 A series of extracts relating to WCS Scanning has been created - these are available in section [[Extracts - WCS Scanning]].
 [[Category:C-TMS Admin|110]]
 [[Category:C-TMS User Guide|C-110]]
 [[Category:Interfaces]]

Anw: Updated with link to WCS Scanning extracts

2024-05-09T14:28:02Z

Updated with link to WCS Scanning extracts

← Older revision		Revision as of 16:28, 9 May 2024
Line 95:		Line 95:
	\|}		\|}

			A series of extracts relating to WCS Scanning has been created - these are available in section [[Extracts - WCS Scanning]].

	== User Access ==		== User Access ==

Anw: Categorisation

2024-02-16T09:41:12Z

Categorisation

← Older revision		Revision as of 11:41, 16 February 2024
Line 113:		Line 113:
	[[Category:C-TMS Admin\|110]]		[[Category:C-TMS Admin\|110]]
	[[Category:C-TMS User Guide\|C-110]]		[[Category:C-TMS User Guide\|C-110]]
			[[Category:Interfaces]]

Anw at 13:07, 11 May 2011

2011-05-11T13:07:16Z

← Older revision		Revision as of 15:07, 11 May 2011
Line 110:		Line 110:
	=== User Parameters ===		=== User Parameters ===
	When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.		When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.

			[[Category:C-TMS Admin\|110]]
			[[Category:C-TMS User Guide\|C-110]]

Admin at 10:51, 17 November 2010

2010-11-17T10:51:02Z

← Older revision		Revision as of 12:51, 17 November 2010
Line 1:		Line 1:
	The Exports module of C-TMS enables the generation of pre-defined [[CSV]] files. Requirements for particular exports are defined by the business and once exports have been developed and installed onto C-TMS, they are available to users via the Exports form shown below.		The Exports module of [[C-TMS]] enables the generation of pre-defined [[CSV]] files. Requirements for particular exports are defined by the business and once exports have been developed and installed onto [[C-TMS]], they are available to users via the Exports form shown below.

	<center>[[Image:extract_1.jpg]]</center>		<center>[[Image:extract_1.jpg]]</center>
Line 29:		Line 29:
	\|-		\|-
	\|Commercial		\|Commercial
	\|This provides an extract of orders in C-TMS in a particular format		\|This provides an extract of orders in [[C-TMS]] in a particular format
	\|-		\|-
	\|Contracts		\|Contracts
	\|This export, extracts all contract details within the C-TMS system in a certain format. .		\|This export, extracts all contract details within the [[C-TMS]] system in a certain format. .
	\|-		\|-
	\|Customer Invoice		\|Customer Invoice
Line 98:		Line 98:
	== User Access ==		== User Access ==

	User access to particular exports is controlled by the Administration section of C-TMS and is maintained by administrator users of the system. See the ADM section for further information.		User access to particular exports is controlled by the Administration section of [[C-TMS]] and is maintained by administrator users of the system. See the ADM section for further information.

	== Form Usage ==		== Form Usage ==
Line 106:		Line 106:
	=== Export ===		=== Export ===

	A drop-down list allows the user to choose from the different exports installed on C-TMS.		A drop-down list allows the user to choose from the different exports installed on [[C-TMS]].

	=== User Parameters ===		=== User Parameters ===
	When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.		When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.

Admin at 14:05, 12 November 2010

2010-11-12T14:05:24Z

← Older revision		Revision as of 16:05, 12 November 2010
Line 1:		Line 1:
	The Exports module of ~~MTS~~ enables the generation of pre-defined [[CSV]] files. Requirements for particular exports are defined by the business and once exports have been developed and installed onto ~~MTS~~, they are available to users via the Exports form shown below.		The Exports module of C-TMS enables the generation of pre-defined [[CSV]] files. Requirements for particular exports are defined by the business and once exports have been developed and installed onto C-TMS, they are available to users via the Exports form shown below.

	<center>[[Image:extract_1.jpg]]</center>		<center>[[Image:extract_1.jpg]]</center>
Line 29:		Line 29:
	\|-		\|-
	\|Commercial		\|Commercial
	\|This provides an extract of orders in ~~MTS~~ in a particular format		\|This provides an extract of orders in C-TMS in a particular format
	\|-		\|-
	\|Contracts		\|Contracts
	\|This export, extracts all contract details within the ~~MTS~~ system in a certain format. .		\|This export, extracts all contract details within the C-TMS system in a certain format. .
	\|-		\|-
	\|Customer Invoice		\|Customer Invoice
Line 98:		Line 98:
	== User Access ==		== User Access ==

	User access to particular exports is controlled by the Administration section of ~~MTS~~ and is maintained by administrator users of the system. See the ADM section for further information.		User access to particular exports is controlled by the Administration section of C-TMS and is maintained by administrator users of the system. See the ADM section for further information.

	== Form Usage ==		== Form Usage ==
Line 106:		Line 106:
	=== Export ===		=== Export ===

	A drop-down list allows the user to choose from the different exports installed on ~~MTS~~.		A drop-down list allows the user to choose from the different exports installed on C-TMS.

	=== User Parameters ===		=== User Parameters ===
	When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.		When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.