CTMS 11.0 ER020-086
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER020-086
Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
CT_INT_BNL_ORDERS_HEADER_336655.sql | Create Table Script | 1.1 | 336655 | SCR-336807-1 | 3 | A new EDI process will need to be setup as follows:
Process Name: BNLMLS_ORDERS Filename Format: tms_sscc_CRE_*.dat Customer: As Customer (see FS) Cost Centre Code: As Cost Centre (see FS) Location: As Depot (see FS) Direction: Inbound Flow Type: PROCESS Frequency Type: Interval Interval Length: 2 Minutes
Archive Folder: /webint/{DATABASE}/interface/BNLMLS/IN/archive Failures Folder: /webint/{DATABASE}/interface/BNLMLS/IN/failures Parameters: DEFAULT_DEL_TYPE: Standard DEFAULT_GROUP_NAME: As Group Name (see FS) DEFAULT_PROD_TYPE_ID: AMBIENT DEFAULT_SRCE_SYSTEM: As Source System (see FS) DELIMITER: EARLY_AVAILABLE_TIME: 0000 LATE_AVAILABLE_TIME: 1200 USE_DIMENSIONS: Y Report Values: Title: Package Name Name: PROCESS Value: DP_BNL_EDI_IN.P_PROCESS_FILES Title: Process Name Name: pi_proc_name Value: BNLMLS_ORDERS The following static data will need to be setup: Locations: Depot, Stores and Suppliers (see FS) Product Types: Ambient Despatch Unit Types: For Pallet Types (see FS) Source System: For Source System (see FS) Delivery Types: Standard Group Names: As Customer Group (see FS) Import Decodes: BNLDIY_LOCATIONS: As Stores and Suppliers from Source System (see FS) BNLDIY_XDOCK: Source Value: XD Target Value: As Depot (see FS) The following tab page will beed to be authorised for the appropriate user groups: Form: Interface Errors Tab: BNL Orders In The following directory structure will need to be setup: /webint/{DATABASE_NAME}/interface/BNLMLS/IN /webint/{DATABASE_NAME}/interface/BNLMLS/IN/archive /webint/{DATABASE_NAME}/interface/BNLMLS/IN/failures The OBS FTP Server will need to be setup to transfer the 'Ship' files to CTMS. The external systems will need to be setup to transfer the 'Ship' files to the OBS FTP Server. |
Julie Scott |
CT_INT_BNL_ORDERS_DETAIL_336655.sql | Create Table Script | 1.1 | " | " | " | " | " |
CT_SEQ_INT_BNL_ORDERS_336655.sql | Create Table Script | 1.1 | " | " | " | " | " |
TRG_INT_BNL_ORDERS_DETAIL_BIU.sql | Trigger | 1.1 | " | " | " | " | " |
TRG_INT_BNL_ORDERS_HEADER_BIU.sql | Trigger | 1.1 | " | " | " | " | " |
DATA_ADM_FORM_TAB_336655.sql | Data Script | 1.1 | " | " | " | " | " |
DATA_ADM_LOG_PROG_NAME_336655.sql | Data Script | 1.1 | " | " | " | " | " |
DP_BNL_EDI_IN.sql | Inbound EDI Package | 1.1 | " | " | " | " | " |
INT_ERR.fmx | Interface Errors Form | 1.90 | " | " | " | " | " |
New Access | ||
Access Tab | Name | Description |
BNL_ORDER_IN | Interface Errors/BNL Orders In | A new tab page for the 'BNL' orders received in the 'Ship' file for review and reprocessing |
![]() | An EDI Change is required with this release. |