276276
276276 - AS-84PBMN/ Dunelm SAP Order EDI Flow
Copyright OBS Logistics © 2011
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
FUNCTIONAL OVERVIEW
Client Requirement
Create a new integration flow to allow order header information from SAP R3 to be uploaded into Calidus TMS.
Upload orders from SAP, validate versus static data and for mandatory fields, hold any errors in interface errors for review and resolution.
Solution
Dunelm will provide order files in XML format. These files will be transmitted or uploaded to ESI probably by ftp but the method and communication transport to be agreed. ESI will validate and transform the SAP XML message into the OBS XML Trip Order Schema. The ESI output files will be pushed via ftp to the C-TMS platform at OBS data centre in Runcorn.
C-TMS will recognise new files as they are created in the designated /in folder. The files will be validated, any errors saved and reported in the C-TMS interface errors form, and where clean, loaded as order headers with C-TMS.
Scope
This change will be applied to C-TMS system version 10.6.
FUNCTIONAL DESCRIPTION
Pre-requisites
Message flow
Note the output files are made unique using date time and a generated 3 digit sequence number.
Data & Mapping
Note that the input status is per order while the output status is per file. ESI will need to create an output file for each group of <status> in the input file. Alternatively, can SAP send separate files of N (new), A (amend) and C (cancel)?
- note that the default collection and delivery window dates/times need to be confirmed by the business.
REFERENCES
Not Available
DOCUMENT HISTORY
| Initial version | ||||
| Correct filenaming and include updated XSD |
AUTHORISED BY
| Matt Crisford | C-TMS Development Manager | |
| Dave Meir | C-TMS Product Manager |
