CTMS 11.0 ER022-083
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER022-083
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| 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 |
Richard Scaife |
| DATA_IMP_FIELD_337560.sql | Data Script | 1.1 | " | " | " | " | " |
| DP_TOY_EDI_IN.sql | Database Package | 1.6 | " | " | " | " | " |
