Orders Interface

An FTP process has been created to transfer Order information from a source system into C-TMS. The orders arrive in CSV files and are processed into C-TMS with errors being reported to a new C-TMS screen for manual administration by the users.

Interface Errors screen (a new tab will be added for each new interface).

The Interfacing team should provide the interface data, extracting the necessary order data from the source system, constructing it into a CSV format consisting of a record header, order header and order detail or details lines and forward it to C-TMS where its arrival triggers an upload process. Each file contains exactly one order and is validated for structure on arrival to the server before invoking the appropriate C-TMS operation (DB) to process it.

The interface is designed to be generic. C-TMS reads the header to determine the interface type before channelling it for processing. The CSV format is extracted into interface order header and interface order details tables. Errors during this upload halt processing and result in the error being written to the tables for viewing in the C-TMS Interface Errors screen. If successfully extracted, the order is validated for loading into the C-TMS orders tables. Errors are written to the interface table for viewing and the order is rolled back. Successes are committed to the orders tables and are available for normal C-TMS orders / trip processing etc.

The FTP interface is one way (from an external source to C-TMS). Errors displayed on the error screen are administered manually via contact between C-TMS and external systems and will either result in data changes or a resend of a corrected FTP file. The FTP file name is used as the interface identifier (int_record_id) enabling order records, interface table records and files to be traced back to their origins.