StylesC at 13:56, 18 January 2017

2017-01-18T13:56:04Z

← Older revision		Revision as of 15:56, 18 January 2017
Line 79:		Line 79:
	PROD_TYPE_ID: AMBIENT		PROD_TYPE_ID: AMBIENT
	PROCESS_TYPE: S		PROCESS_TYPE: S
	\|		\|Richard Scaife
	}}		}}
	{{ERTableRow		{{ERTableRow
	\|		\|DATA_IMP_FIELD_337560.sql
	\|		\|Data Script
	\|		\|1.1
			\|"
			\|"
			\|"
			\|"
			\|"
			}}
			{{ERTableRow
			\|DP_TOY_EDI_IN.sql
			\|Database Package
			\|1.6
	\|"		\|"
	\|"		\|"

StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER022-083 }} {{ERTableHeader}} {{ERTableRow |AT_INT_ORD_ITEMS_CSV_337560.s..."

2017-01-18T13:53:23Z

Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER022-083 }} {{ERTableHeader}} {{ERTableRow |AT_INT_ORD_ITEMS_CSV_337560.s..."

New page

{{#vardefine:System|CTMS}}
{{ERHeader
|SystemVersion=CTMS 11.0
|ERNumber=ER022-083
}}

{{ERTableHeader}}
{{ERTableRow
|AT_INT_ORD_ITEMS_CSV_337560.sql
|Alter Table Script
|1.1
|337560
|RS-AD5KU6
|4
|The PROCESS_ITEM import type process will have new fields available to extract the data from the order files:

ITEM_IDENTIFIER
NAME
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
TOWN
COUNTY
POSTCODE
COUNTRY_CODE
PROCESS_TYPE

The PROCESS_TYPE will control the validation that is performed for the order.
The order files for this format may be processed using the import process or an EDI process and the records will be displayed in the 'Order Items' tab page in the 'Interface Errors' screen. The failed records can be reprocessed in that screen.

'''Technical Details:'''
The new order import process will need to be authorised for the appropriate user groups.
A new directory structure is required to store the order files in C-TMS.
The OBS FTP Server will need to be setup to receive the order files from and to transfer them to C-TMS for the EDI process.
A new EDI process will need to be setup to process automatically the order files, for example:

Process Name: {CUSTOMER}_ORDER_ITEMS
Filename Format: As appropriate
Customer: As appropriate
Cost Centre Code: As appropriate
Location: As appropriate
Direction: Inbound
Flow Type: PROCESS

Delivery Folder: /webint/{DATABASE}/interface/SCA/IN

Archive Folder: /webint/{DATABASE}/interface/SCA/IN/archive

Failures Folder: /webint/{DATABASE}/interface/SCA/IN/failures

The EDI parameters will need to be setup, for example:

DEFAULT_PROD_TYPE_ID: AMBIENT
PROCESS_TYPE: S (for the new validation or N for the standard validation)

The EDI report values will need to be setup:

Title: Package Name
Name: PROCESS
Value: DP_TOY_EDI_IN.P_PROCESS_FILES

Title: Process Name
Name: pi_proc_name
Value: {CUSTOMER}_ORDER_ITEMS (i.e. the EDI process
name)

A new import process will need to be setup for the order files, for example:

Format Name: {CUSTOMER}_ORDER_ITEMS (i.e. the EDI process name)
Imp Type: PROCESS_ITEM
Delimiter: ;

The import fields will need to be setup to match the sequence in which the data is provided in the order files but some data will be fixed, for example:

CUSTOMER: As appropriate
COST_CENTRE_CODE: As appropriate
DEPOT: As appropriate
PROD_TYPE_ID: AMBIENT
PROCESS_TYPE: S
|
}}
{{ERTableRow
|
|
|
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}

<noinclude>
[[Category:{{#var:System}} ER]]
</noinclude>

CTMS 11.0 ER022-083 - Revision history

StylesC at 13:56, 18 January 2017

StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER022-083 }} {{ERTableHeader}} {{ERTableRow |AT_INT_ORD_ITEMS_CSV_337560.s..."