289163 - Revision history

DuttonT: /* ‘Web Service Audit Enquiry’ Screen */

2012-03-27T12:38:20Z

‘Web Service Audit Enquiry’ Screen

@@ Line 977: / Line 977: @@
-[[Image:]][[Image:]]
+create table WEB_SERVICE_AUDIT
@@ Line 983: / Line 1,016: @@
-[[Image:]]
+alter table SCH_ORD_NON_CONFORM add (DU_TYPE VARCHAR2(12),PRODUCT_TYPE VARCHAR2(12));
@@ Line 989: / Line 1,023: @@
-[[Image:]]
+-- Create sequence
+create sequence SEQ_WEB_SERVICE_AUDIT
 A new trigger for ‘WEB_SERVICE_AUDIT’ may be created using the following script:
-[[Image:]]
+CREATE OR REPLACE TRIGGER TRG_WEB_SERVICE_AUDIT_BIU
-The new ‘WEB_SERV_AUDIT’ form may be made available for use using the following scripts:
-[[Image:]][[Image:]]
+-- Update table
@@ Line 1,007: / Line 1,070: @@
-[[Image:]]
+INSERT INTO ADM_SYSTEM_PARAM
+(PARAM_NAME,VALUE,DATA_TYPE,MAX_LENGTH,DISPLAYED,USER_MODIFIABLE,DESCRIPTION,CREATED_BY,CREATED_DATE,UPDATED_BY,UPDATED_DATE,CONFIG_BY,CONFIG_BY_VALUE)
@@ Line 1,145: / Line 1,215: @@
 |}
 =AUTHORISED BY=

DuttonT at 12:30, 27 March 2012

2012-03-27T12:30:24Z

← Older revision		Revision as of 14:30, 27 March 2012
Line 53:		Line 53:

	Location Name		Location Name

	~~<nowiki>Postcode of Collection [or of delivery if a delivery order]</nowiki>~~

	~~<nowiki>Trip number of Collection (if planned) [or of delivery if a delivery order]</nowiki>~~

	~~<nowiki>Planned Date and Time of Collection (if planned) [or of delivery if a delivery order]</nowiki>~~

	Driver Name (if resource allocated)		Driver Name (if resource allocated)
Line 87:		Line 81:

	Debrief Notes of order line (if debriefed)		Debrief Notes of order line (if debriefed)



	The Order Status will be one of the following values;		The Order Status will be one of the following values;


	NOTFOUND – no order retrieved for the query in C-TMS		NOTFOUND – no order retrieved for the query in C-TMS
Line 214:		Line 208:

	\|}		\|}



Line 221:		Line 214:

	A new sequence number will be created to set a unique audit number for each transaction recorded via a trigger on the database table.		A new sequence number will be created to set a unique audit number for each transaction recorded via a trigger on the database table.


	The system time of the audit transaction will be set from the system date and time via the same trigger.		The system time of the audit transaction will be set from the system date and time via the same trigger.
Line 280:		Line 272:

	\|}		\|}




Line 332:		Line 322:

	\|}		\|}


	== Microlise XML Flow ==		== Microlise XML Flow ==
Line 387:		Line 378:
	* ORDER_STATUS_REQUEST		* ORDER_STATUS_REQUEST

	[[Image:]]		[[Image:289163_1.png]]

	=== OrderStatusResp ===		=== OrderStatusResp ===
Line 424:		Line 415:
	* ORDER_STATUS_RESPONSE		* ORDER_STATUS_RESPONSE

	[[Image:]]		[[Image:289163_2.png]]


Line 432:		Line 423:
	* ORDER_LINES_RESPONSES		* ORDER_LINES_RESPONSES

	[[Image:]]		[[Image:289163_3.png]]


Line 440:		Line 431:
	* REASON_CODES_RESPONSES		* REASON_CODES_RESPONSES

	[[Image:]]		[[Image:289163_4.png]]


Line 915:		Line 906:


	[[Image:]]		[[Image:289163_5.png]]

DuttonT: /* OrderStatusReq */

2012-03-27T12:26:46Z

OrderStatusReq

← Older revision		Revision as of 14:26, 27 March 2012
Line 368:		Line 368:

	\|}		\|}



	=== OrderStatusReq ===		=== OrderStatusReq ===
Line 386:		Line 388:

	[[Image:]]		[[Image:]]


	=== OrderStatusResp ===		=== OrderStatusResp ===

DuttonT: /* ‘TRG_WEB_SERVICE_AUDIT_BIU’ Trigger */

2012-03-27T12:26:28Z

‘TRG_WEB_SERVICE_AUDIT_BIU’ Trigger

← Older revision		Revision as of 14:26, 27 March 2012
Line 214:		Line 214:

	\|}		\|}




	=== ‘TRG_WEB_SERVICE_AUDIT_BIU’ Trigger ===		=== ‘TRG_WEB_SERVICE_AUDIT_BIU’ Trigger ===
Line 221:		Line 224:

	The system time of the audit transaction will be set from the system date and time via the same trigger.		The system time of the audit transaction will be set from the system date and time via the same trigger.


	=== ‘SEQ_WEB_SERVICE_AUDIT’ Sequence Number ===		=== ‘SEQ_WEB_SERVICE_AUDIT’ Sequence Number ===

DuttonT: /* ‘AUTHENTICATION_KEYS’ Table */

2012-03-27T12:26:11Z

‘AUTHENTICATION_KEYS’ Table

← Older revision		Revision as of 14:26, 27 March 2012
Line 278:		Line 278:

	\|}		\|}





	== ‘AUTHENTICATION_KEYS’ Table ==		== ‘AUTHENTICATION_KEYS’ Table ==

DuttonT: New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Web Service Functionality|Reference=FS 289163 PM-8HMA5K |Version=3.1|Date=15/08/2011|Sysver=10.6|Client=DHL C-TMS}} = Functional Overview...

2012-03-27T12:25:38Z

New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Web Service Functionality|Reference=FS 289163 PM-8HMA5K |Version=3.1|Date=15/08/2011|Sysver=10.6|Client=DHL C-TMS}} = Functional Overview...

Show changes