CTMS 11.0 ER020-086

From Calidus HUB
Revision as of 12:48, 22 August 2016 by StylesC (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Aptean Logo.png


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


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

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


Warning Warning: An EDI Change is required with this release.