291359 - Revision history

Admin: /* Manual Order Entry */

2012-05-03T11:41:47Z

Manual Order Entry

← Older revision		Revision as of 13:41, 3 May 2012
Line 152:		Line 152:

	Once the product/commodity has been selected from the drop down list the DU type should automatically be populated. The product type should then be used to construct a list of values for the item identifier field from the PRD_PRODUCT_ITEM table and a valid record must be selected from this list. Order items are connected to the order lines a combination of Product and du type and validation should be performed to ensure that no order items can be entered for a product and du type combination which does not already exist for this order. If invalid entries are found then an appropriate error message should be displayed. The item identifier must be unique within the OMS ref and therefore no duplicate identifiers are allowed within an order. If duplicates are entered an appropriate error will be displayed. All input errors should be corrected before the order items are committed.		Once the product/commodity has been selected from the drop down list the DU type should automatically be populated. The product type should then be used to construct a list of values for the item identifier field from the PRD_PRODUCT_ITEM table and a valid record must be selected from this list. Order items are connected to the order lines a combination of Product and du type and validation should be performed to ensure that no order items can be entered for a product and du type combination which does not already exist for this order. If invalid entries are found then an appropriate error message should be displayed. The item identifier must be unique within the OMS ref and therefore no duplicate identifiers are allowed within an order. If duplicates are entered an appropriate error will be displayed. All input errors should be corrected before the order items are committed.

	''Developer Note – This will be achieved by setting the x and y co-ordinates of the items and attaching an LOV to the item_identifier field based on the value of the system parameter at runtime. Using the system parameter as opposed to the customer flag will allow all types of orders (i.e. heavy non-heavy and Ad Hoc) to be validated in this way.''

	== Order Import ==		== Order Import ==

Admin: /* Manual Order Entry */

2012-05-03T11:40:49Z

Manual Order Entry

← Older revision		Revision as of 13:40, 3 May 2012
Line 144:		Line 144:


	[[Image:]]		[[Image:291359_7.png]]

	If the parameter value is not set or set to “N” no change to the entry sequence or additional validation will be required and records should be processed in the existing manner. If the value of the parameter is set to “Y” then the entry sequence for order items will be amended to enter the product and du type information before the item identifier. A suggested layout is shown below.		If the parameter value is not set or set to “N” no change to the entry sequence or additional validation will be required and records should be processed in the existing manner. If the value of the parameter is set to “Y” then the entry sequence for order items will be amended to enter the product and du type information before the item identifier. A suggested layout is shown below.


	[[Image:]]		[[Image:291359_8.png]]

	Once the product/commodity has been selected from the drop down list the DU type should automatically be populated. The product type should then be used to construct a list of values for the item identifier field from the PRD_PRODUCT_ITEM table and a valid record must be selected from this list. Order items are connected to the order lines a combination of Product and du type and validation should be performed to ensure that no order items can be entered for a product and du type combination which does not already exist for this order. If invalid entries are found then an appropriate error message should be displayed. The item identifier must be unique within the OMS ref and therefore no duplicate identifiers are allowed within an order. If duplicates are entered an appropriate error will be displayed. All input errors should be corrected before the order items are committed.		Once the product/commodity has been selected from the drop down list the DU type should automatically be populated. The product type should then be used to construct a list of values for the item identifier field from the PRD_PRODUCT_ITEM table and a valid record must be selected from this list. Order items are connected to the order lines a combination of Product and du type and validation should be performed to ensure that no order items can be entered for a product and du type combination which does not already exist for this order. If invalid entries are found then an appropriate error message should be displayed. The item identifier must be unique within the OMS ref and therefore no duplicate identifiers are allowed within an order. If duplicates are entered an appropriate error will be displayed. All input errors should be corrected before the order items are committed.

	''Developer Note – This will be achieved by setting the x and y co-ordinates of the items and attaching an LOV to the item_identifier field based on the value of the system parameter at runtime. Using the system parameter as opposed to the customer flag will allow all types of orders (i.e. heavy non-heavy and Ad Hoc) to be validated in this way.''		''Developer Note – This will be achieved by setting the x and y co-ordinates of the items and attaching an LOV to the item_identifier field based on the value of the system parameter at runtime. Using the system parameter as opposed to the customer flag will allow all types of orders (i.e. heavy non-heavy and Ad Hoc) to be validated in this way.''


	== Order Import ==		== Order Import ==

Admin: /* Customer Data */

2012-05-03T11:38:17Z

Customer Data

← Older revision		Revision as of 13:38, 3 May 2012
Line 95:		Line 95:


	[[Image:]]		[[Image:291359_6.png]]

	The default value for this field will be null. If the box is checked for a given customer the VALIDATE_PROD column will be set to “Y” this will indicate that order items for this customer should have the product and item identifier validated from the master list. If the box is unchecked this value should be set to “N”.		The default value for this field will be null. If the box is checked for a given customer the VALIDATE_PROD column will be set to “Y” this will indicate that order items for this customer should have the product and item identifier validated from the master list. If the box is unchecked this value should be set to “N”.

Admin: /* Product item Maintenance */

2012-05-03T11:37:23Z

Product item Maintenance

← Older revision		Revision as of 13:37, 3 May 2012
Line 81:		Line 81:


	[[Image:]]		[[Image:291359_4.png]]

	[[Image:]]		[[Image:291359_5.png]]

	Both tab pages will be amended to allow the display and capture of the larger fields any processing or validation associated with these fields should be amended accordingly to allow the larger field length.		Both tab pages will be amended to allow the display and capture of the larger fields any processing or validation associated with these fields should be amended accordingly to allow the larger field length.
Line 90:		Line 90:

	There are two oracle reports which reference the product item data and these will also be changed to accommodate the new larger field size details of the reports are provided in Appendix B.		There are two oracle reports which reference the product item data and these will also be changed to accommodate the new larger field size details of the reports are provided in Appendix B.


	== Customer Data ==		== Customer Data ==

Admin: /* Implementation Advice */

2012-05-03T11:32:03Z

Implementation Advice

← Older revision		Revision as of 13:32, 3 May 2012
Line 63:		Line 63:


	[[Image:]]		[[Image:291359_1.png]]

	A system super user will be required to grant access to the import functions an example is shown below.		A system super user will be required to grant access to the import functions an example is shown below.


	[[Image:]]		[[Image:291359_2.png]]

	A system super user will be required to ensure the system parameters have been set up correctly an example is shown below		A system super user will be required to ensure the system parameters have been set up correctly an example is shown below


	[[Image:]]		[[Image:291359_3.png]]

	= Functional Description =		= Functional Description =

Admin: /* Latitude Longitude Report */

2012-05-03T11:29:46Z

Latitude Longitude Report

← Older revision		Revision as of 13:29, 3 May 2012
Line 183:		Line 183:

	'''Modules to be changed'''		'''Modules to be changed'''


	{\| style="border-spacing:0;"		{\| style="border-spacing:0;"
Line 339:		Line 338:

	\|}		\|}


	=AUTHORISED BY=		=AUTHORISED BY=

Admin: /* Customer Data */

2012-05-03T11:29:24Z

Customer Data

← Older revision		Revision as of 13:29, 3 May 2012
Line 99:		Line 99:

	The default value for this field will be null. If the box is checked for a given customer the VALIDATE_PROD column will be set to “Y” this will indicate that order items for this customer should have the product and item identifier validated from the master list. If the box is unchecked this value should be set to “N”.		The default value for this field will be null. If the box is checked for a given customer the VALIDATE_PROD column will be set to “Y” this will indicate that order items for this customer should have the product and item identifier validated from the master list. If the box is unchecked this value should be set to “N”.


	== CSV Import ==		== CSV Import ==

Admin: /* Solution */

2012-05-03T11:28:54Z

Solution

← Older revision		Revision as of 13:28, 3 May 2012
Line 24:		Line 24:

	ote that the Identifier is the 20 character ITEM_IDENTIFER field which will cover the ‘structured’ records in the product list provided by Simon Allen.		ote that the Identifier is the 20 character ITEM_IDENTIFER field which will cover the ‘structured’ records in the product list provided by Simon Allen.


	The Product Item screen will be used to store the product master list and will provide the relationship between item (e.g. 0057/007569/0120) and product type (e.g. SHORTRAIL) and item description (e.g. RAIL SHORT, 60E2, ALPHATEK COATED, 18M, UNDRILLED).		The Product Item screen will be used to store the product master list and will provide the relationship between item (e.g. 0057/007569/0120) and product type (e.g. SHORTRAIL) and item description (e.g. RAIL SHORT, 60E2, ALPHATEK COATED, 18M, UNDRILLED).
Line 33:		Line 32:

	The missing Latitude / Longitude from Locations extract will be accommodated from a recent development for BG Waste RIO AR-8KCC3R (OBS Ref 290898) so there is no incremental cost in this RIO for this feature.		The missing Latitude / Longitude from Locations extract will be accommodated from a recent development for BG Waste RIO AR-8KCC3R (OBS Ref 290898) so there is no incremental cost in this RIO for this feature.


	'''This functional specification is provided assuming that the product codes will be maximum 20 characters. If this is insufficient the functional specification will need to be referred and reworked accordingly. '''		'''This functional specification is provided assuming that the product codes will be maximum 20 characters. If this is insufficient the functional specification will need to be referred and reworked accordingly. '''


	== Scope ==		== Scope ==

Admin at 11:28, 3 May 2012

2012-05-03T11:28:17Z

← Older revision		Revision as of 13:28, 3 May 2012
Line 1:		Line 1:
	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title=Master Data Maintenance\|Reference=FS 291359-MS8KNBG7\|Version=2.0\|Date=19/10/11\|Sysver=10.7\|Client=DHL C-TMS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title=Master Data Maintenance\|Reference=FS 291359-MS8KNBG7\|Version=2.0\|Date=19/10/11\|Sysver=10.7\|Client=DHL C-TMS}}
	~~[[Image:]]~~

Admin: New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Master Data Maintenance|Reference=FS 291359-MS8KNBG7|Version=2.0|Date=19/10/11|Sysver=10.7|Client=DHL C-TMS}} Image: == Client Requi...

2012-05-03T11:27:50Z

New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Master Data Maintenance|Reference=FS 291359-MS8KNBG7|Version=2.0|Date=19/10/11|Sysver=10.7|Client=DHL C-TMS}} [[Image:]] == Client Requi...

Show changes