CONPRD Release - 27/05/2011 - Revision history

DuttonT: Replacing page with '=Requested Developements= None for this release =Programs Released= {| border="1" !Program||Version |- |RATE.sql||5.41.1.1 |- |} =Dependency RIO'S Released= N/A for th...'

2011-06-28T09:52:53Z

Replacing page with '=Requested Developements= None for this release =Programs Released= {| border="1" !Program||Version |- |RATE.sql||5.41.1.1 |- |} =Dependency RIO'S Released= N/A for th...'

Show changes

DuttonT at 09:51, 28 June 2011

2011-06-28T09:51:11Z

@@ Line 2: / Line 2: @@
-'''[[286581 | 286581  (JC-8EKD99) - Internal Charge via Cross Dock''']]
+None for this release
@@ Line 11: / Line 10: @@
 !Program||Version
 |-
-|[[TRIPDTL]].fmx||2.90
+|RATE.sql||5.41.1.1
 |-
 |}
@@ Line 50: / Line 18: @@
 =Dependency RIO'S Released=
-'''[[285511  | 285511 (RB-8DHFSM) -  Revised Invoicing and Rev Detail Extract''']]
+N/A for this release
 =Dependency EARS/TIDS=
-'''282967  | 282967 (SD-8AVQKK) -  Outbound Interface Message from TMS'''
+'''288474  | 288474 (EARS00030835826) -  CTMS - Error message'''

DuttonT at 09:43, 28 June 2011

2011-06-28T09:43:42Z

← Older revision		Revision as of 11:43, 28 June 2011
Line 1:		Line 1:
			=Requested Developements=


			'''[[286581 \| 286581 (JC-8EKD99) - Internal Charge via Cross Dock''']]



			=Programs Released=

			{\| border="1"
			!Program\|\|Version
			\|-
			\|[[TRIPDTL]].fmx\|\|2.90
			\|-
			\|[[INVOICES]].fmx\|\|2.21
			\|-
			\|[[CUST_COST]].fmx\|\|2.52
			\|-
			\|[[ACC_MAINT]].fmx\|\|2.38
			\|-
			\|RATE.sql\|\|5.39
			\|-
			\|INT_XML_OUT2.sql\|\|5.74
			\|-
			\|NAVTEQ.sql\|\|5.13
			\|-
			\|ACC.sql\|\|5.9
			\|-
			\|CNT.sql\|\|5.11
			\|-
			\|INV.sql\|\|5.10
			\|-
			\|OF_INT.sql\|\|5.5
			\|-
			\|UTL.sql\|\|5.2
			\|-
			\|DATABASE_CHANGES_286581.sql\|\|1.1
			\|-
			\|285511_CT_TABLES.sql\|\|1.1
			\|-
			\|ADM_SYS_280855.sql\|\|1.1
			\|-
			\|Sequence_280855.sql\|\|1.1
			\|-
			\|

			\|}


			=Dependency RIO'S Released=

			'''[[285511 \| 285511 (RB-8DHFSM) - Revised Invoicing and Rev Detail Extract''']]

			'''[[280855 \| 280855 (AS-882D8G) - Invoice Generation CR020''']]

			'''[[276280 \| 276280 (AS-84PEAN) - Rating + Invoicing for Supp Billing''']]

			=Dependency EARS/TIDS=

			'''282967 \| 282967 (SD-8AVQKK) - Outbound Interface Message from TMS'''

			'''287265\| 287265 - (CTMS-OBS-PM): Navteq issue'''

			'''286332\| 286332 - (EARS00030461053): CTMS - Debrief issue'''

			'''285900\| 285900 - (TID-4153): CTMS - Debrief issue'''

			'''287509\| 287509 - (TID 4258): Internal charges consolidation'''

			'''287876\| 287876 - (TID-4282): Rate generated incorrectly'''












































	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= Setup Interface Flows for Unilever\|Reference=287105 NA-8F5HA6 \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= Setup Interface Flows for Unilever\|Reference=287105 NA-8F5HA6 \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}

DuttonT at 15:00, 27 June 2011

2011-06-27T15:00:23Z

← Older revision		Revision as of 17:00, 27 June 2011
Line 1:		Line 1:
	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= ~~FS 287105 NA-8F5HA6~~ Setup Interface Flows for Unilever= \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= Setup Interface Flows for Unilever\|Reference=287105 NA-8F5HA6 \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}

DuttonT at 14:58, 27 June 2011

2011-06-27T14:58:48Z

← Older revision		Revision as of 16:58, 27 June 2011
Line 1:		Line 1:
	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= Setup Interface Flows for Unilever=~~FS 287105 NA-8F5HA6~~ \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= FS 287105 NA-8F5HA6 Setup Interface Flows for Unilever= \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}

DuttonT at 14:57, 27 June 2011

2011-06-27T14:57:34Z

← Older revision		Revision as of 16:57, 27 June 2011
Line 1:		Line 1:
	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title=Setup Interface Flows for Unilever=FS 287105 NA-8F5HA6 \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title= Setup Interface Flows for Unilever=FS 287105 NA-8F5HA6 \|Version=1.0\|Date=\|Sysver=10.6\|Client=DHL CTMS}}

DuttonT: /* Outbound Flows */

2011-06-27T14:54:34Z

Outbound Flows

← Older revision		Revision as of 16:54, 27 June 2011
Line 88:		Line 88:


	[[Image:~~287105~~.png]]		[[Image:287105_1.png]]

DuttonT: /* Outbound Flows */

2011-06-27T14:52:57Z

Outbound Flows

← Older revision		Revision as of 16:52, 27 June 2011
Line 88:		Line 88:


	[[Image:]]		[[Image:287105.png]]


Line 135:		Line 135:
	The ARR and DEL messages are only required once per order. A new field will be added to SCH_ORD that will contain the messages sent for that particular order. When an ARR or DEL message is sent the field will be updated with ARR or DEL. The values will be separated by a comma. During the processing of the ARR and DEL message it will check if the appropriate value is stored in this field, indicating this message type has previously been sent. If it has then this order will be excluded from the file.		The ARR and DEL messages are only required once per order. A new field will be added to SCH_ORD that will contain the messages sent for that particular order. When an ARR or DEL message is sent the field will be updated with ARR or DEL. The values will be separated by a comma. During the processing of the ARR and DEL message it will check if the appropriate value is stored in this field, indicating this message type has previously been sent. If it has then this order will be excluded from the file.

	As part of this RIO the existing flows that use the UNILEVER messages will be set up in this screen as UNI and GLO which will allow them to carry on processing as they do now.		As part of this RIO the existing flows that use the UNILEVER messages will be set up in this screen as UNI and GLO which will allow them to carry on processing as they do now.


	== Inbound Flows ==		== Inbound Flows ==

DuttonT: /* Inbound Flows */

2011-06-27T14:52:03Z

Inbound Flows

← Older revision		Revision as of 16:52, 27 June 2011
Line 150:		Line 150:
	'''TABLE UPDATES REQUIRED'''		'''TABLE UPDATES REQUIRED'''

	Alter EDI_PROCESS_HEADER Add		*Alter EDI_PROCESS_HEADER Add

	*(FTP_DESTINATION_IP VARCHAR2(20),		*(FTP_DESTINATION_IP VARCHAR2(20)

	*FTP_DESTINATION_PORT VARCHAR2(20),		*FTP_DESTINATION_PORT VARCHAR2(20)

	* FTP_USERNAME VARCHAR2(20),		*FTP_USERNAME VARCHAR2(20)

	*FTP_PASSWORD VARCHAR2(20),		*FTP_PASSWORD VARCHAR2(20)

	*FTP_DIRECTORY VARCHAR2(20))		*FTP_DIRECTORY VARCHAR2(20))

DuttonT: /* Inbound Flows */

2011-06-27T14:51:25Z

Inbound Flows

← Older revision		Revision as of 16:51, 27 June 2011
Line 150:		Line 150:
	'''TABLE UPDATES REQUIRED'''		'''TABLE UPDATES REQUIRED'''

	Alter EDI_PROCESS_HEADER Add(FTP_DESTINATION_IP VARCHAR2(20),		Alter EDI_PROCESS_HEADER Add

			*(FTP_DESTINATION_IP VARCHAR2(20),

	*FTP_DESTINATION_PORT VARCHAR2(20),		*FTP_DESTINATION_PORT VARCHAR2(20),