FS 304310 EPOD-TTM Interface
OBS Logistics Ltd
EPOD-TTM Interface
CALIDUS EPOD
15th February 2013 - 0.4
Reference: FS 304310
Contents
Functional Overview
Client Requirement
Regarding the projects LF Logistics, Partnerlink and others, it is required to have a stand-alone interface between the two CALIDUS products TTM and EPOD.
Additional requirements from the Partnerlink project:
- TTM to provide ETA information for jobs on loads.
- EPOD to allow resequencing of jobs on a load.
- TTM to show audits of Resequencing.
These will be specified spearately, but the details of the interface will be noted here.
Solution Overview
The solution will be to provide the data and files from EPOD, which will have the responsibility of passing along the information from the clients' TMS systems, acting as a data store for TTM.
All interface actions required are from EPOD to TTM, with the existing systems.
Actions required:
- Initial creation of Trip and Order information - Message type TRP, including full Order details
- Updates of Trip information - Message type TRP, including header Order information
- Updates of Order information - Message type ORD.
- Resequencing of Orders on Trips - Message type RES (based on TRP message).
- Moving Orders from one Trip to another Trip - Message type TRP, including header Order information.
- Order In Progress - Message type OIT, including GPS information (based on existing ALC message)
- Order Complete - Message type DEL
- Order Cancelled - Message type CAN
- Trip Complete (Not required at this stage)
Scope
Set-up
Pre-requisites
- Working versions of CALIDUS ePOD and TTM.
Menu Structure
None
Data
As described
Functional Description
EPOD Changes
EPOD Import and Admin will need to change when amending statuses on orders, to reset XFER flags where necessary, as this is the mechanism by which the messages will be sent.
- Loads and Jobs should be created with an Interface flag set to blank ("")
- Confirmation or Cancellation of a Job or Load requires that the Interface flag be reset to "N"
- Updates of EPL_LOAD_ID on EPOD_JOB should reset the Interface Flag of the Load From and the Load To, if present, to blank. Admin and Import.
- Updates of Load or Job information on Loads or Jobs that are not Cancelled or Completed to reset the Interface Flag on the relevant file to blank. Admin and Import.
- Add Interface Flag to EPOD_USER_AUDIT. Initialise to "N".
- Add new XREF fields on Job Group and Load records, to be sent in the interface. Not user-configurable.
- Import of Jobs should set the Order Date to NOW(), if the Order Date has not been provided.
- Import of Jobs should set the Ordered Qty to Planned Qty, if the Ordered Qty has not been provided.
- A new Interface Flag must be added to copy with the exports both to TTM and through the standard Job/Load interface. This should be updated instead of the normal interface flag when sending DEL or CAN records.
For Partnerlink:
- Add Resequence functionality
- Add EPL_SEQUENCE to EPOD_JOB
- Create EPL_SEQUENCE in Import, initially in order received.
- Flag to control whether Jobs should be in Planned Start D/T Seq - if so, resequence at end.
- Add LOAD_RESEQUENCE message to Server
- Add LOAD_RESEQUENCE send
File Delivery Mechanism
The interface will
- deliver a single message per file
- in flat-file format
- in TTM XML format, all content being HTML-safe-encoded.
- following the standard TTM naming convention (<SysFrom>_<SysTo>_<SourceID>_<EventID>_<UniqueID>.XML)
- <SysFrom> - The system sending the message - always "EPOD"
- <SysTo> - The system receiving the message - always "LOTS"
- <SourceID> - Identifying source ID of the payload - always EPL_SITE_ID
- <EventID> - the message being transmitted. Always one of: "TRIP", "ORD", "OIT", "DEP", "CAN", "DEL"
- <UniqueID> - a unique ID for the file. Always made up of Date/Time stamp in format DDMMYYHHNNSSMM, plus an incremental of the number of files created in the AutoExport run (to ensure uniqueness).
- initially created as .TMP files, then renamed to .XML when complete
All messages will be sent through the existing AutoExport functionality of CALIDUS EPOD, utilising configuration specified within the label EPOD_XF_CONFIG.
Additional fields will be added to this table:
- A new Type "FILE" will be added, to identify that this send is through File-copy Transfer.
- New ID (in addition to the existing standard EPOD message types of LOAD and JOB) will be created to filfil the required actions listed above, as "TTM-IF". This will act for all message types that require sending for TTM.
- Destination will be set to the directory to which the flat files will be copied. This is expected to be a share on the same machine, e.g. "\\127.0.0.1\TTM-IMPORT\"
- A new field will control the filename created. This will be populated with "EPOD_LOTS_<EPL_SITE_ID>_<EPL_XF_ID>_<DTS>.XML". EPL_XF_ID will be set to the message type being sent (DEP, TRP, OIT, etc), the other "tags" will be replaced with relevant values, either from the data (Site) or generated (Date/Time stamp).
The auto-export program will be modified to add processing of "TTM-IF" configurations, after the standard message type checks. The program will call a new procedure here.
The procedure will check for messages in this order:
- TRP
- RES
- ORD
- ARR
- DEL/CAN
- OIT
Note: The sequence is very important for the process to work efficiently. Note also that OIT is after DEL/CAN, as TTM can then decide whether an order is closed before receiving the In Transit message (if batched together) and therefore control whether an ETA needs to be calculated for the subsequent stop.
Database packages will be added to seach for Loads, Jobs and Audit records where:
- The interface flag and/or Status are set to the appropriate value, dependant on the message type (defined below)
- Where the SITE_ID or JOB_GROUP of the record has an XF_CONFIG_ID of "TTM-IF"
When creating one of these files, the process will create the file locally in a temporary area, then re-name the file, when populated, to the destination directory and generated file name. Note: the name will only be generated when the file is fully built.
Once the file is delivered, the existing audit mechanism (EPOD_XF_AUDIT_HEADER/DETAIL) will be used to note that the file was sent. The built file will not be stored (this will be done by EPOD).
Failure to deliver the file will result in the error being retrieved and stored against the tables above.
Message Details
Type TRP
This message will be used for the following:
- Initial creation of Trip and Order information
- Updates of Trip information
- Moving Orders from one Trip to another Trip
The message will be sent by finding all Loads on EPOD_LOAD where the Interface flag is blank - the status is irrelevant.
All loads found will have an individual file created for them.
The process will:
- For Each Load Found:
- Start Transaction
- Retrieve all Job, Container and Product information for the Load.
- Build the Trip Header XML information for the Load (Format TBC)
- For each Job on the Load:
- Build the Order and Stop XML information for the Job. If the Interface flag is blank the full information will be build, otherwise only skeleton data will be built.
- Set the Job interface flag to "N"
- Set the Load Interface flag to "N"
- Build temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
Note: Order Detail XML data will send Containers with a quantity of 1, by default. If the container is a loose container, it will send the product information within instead.
Sample file:
<?xml version="1.0" encoding="UTF-8"?>
<OBS_XML>
<EVENT>
<EVENT_HEADER>
<EVENT_PROCESSED>N</EVENT_PROCESSED>
<EVENT_SOURCE_TYPE>EPOD</EVENT_SOURCE_TYPE>
<EVENT_SOURCE_NAME>EPL_SITE_ID</EVENT_SOURCE_NAME>
<EVENT_DATE>2012-12-20T01:42:11</EVENT_DATE> - EPL_LAST_CHANGED_DATE/TIME
<EVENT_TYPE>TRP</EVENT_TYPE>
<EVENT_ACTION>R</EVENT_ACTION>
</EVENT_HEADER>
<EVENT_DETAIL>
<TRIP_HEADER>
<TRIP_IDENTIFIER>T</TRIP_IDENTIFIER>
<TRIP_TRANSACTION_DATE>2012-12-20T01:37:55</TRIP_TRANSACTION_DATE> - NOW()
<TRIP_ID>EPL_LOAD_ID</TRIP_ID>
</TRIP_HEADER>
<TRIP_DETAIL>
<TRACKING>N</TRACKING>
<DRIVER>EPL_USER_ID</DRIVER>
<DRIVER_NAME>EPL_USER_NAME</DRIVER_NAME>
<TRACTOR>EPL_VEHICLE_REG</TRACTOR>
<COST_CENTRE>EXEL</COST_CENTRE>
<TRIP_STATUS>EN-ROUTE</TRIP_STATUS>
<TRIP_REF>M2480031</TRIP_REF>
<TRIP_TRAILER_ID>EPL_VEHICLE_ID</TRIP_TRAILER_ID>
<TRIP_TRAILER_TYPE>EPL_DESCRIPTION</TRIP_TRAILER_TYPE>
<TRIP_DISTANCE>0</TRIP_DISTANCE>
</TRIP_DETAIL>
<STOPS>
<STOP>
<STOP_HEADER>
<STOP_IDENTIFIER>S</STOP_IDENTIFIER>
<STOP_SEQ>1</STOP_SEQ> - Counts sequentially for each stop on the trip
</STOP_HEADER>
<STOP_DETAIL>
<STOP_REF>C</STOP_REF>
<STOP_TYPE>CL</STOP_TYPE>
<STOP_LOCATION_TYPE>2</STOP_LOCATION_TYPE>
<STOP_LOCATION_ID>EPL_CUSTOMER_ID</STOP_LOCATION_ID>
<STOP_LOCATION_NAME>EPL_CUSTOMER_NAME</STOP_LOCATION_NAME>
<STOP_ADDR_LINE1>EPL_ADDR_LINE_1</STOP_ADDR_LINE1>
<STOP_ADDR_LINE2>EPL_ADDR_LINE_2</STOP_ADDR_LINE2>
<STOP_ADDR_LINE3>EPL_ADDR_LINE_3</STOP_ADDR_LINE3>
<STOP_TOWN>EPL_ADDR_LINE_4</STOP_TOWN>
<STOP_COUNTY>EPL_ADDR_LINE_5</STOP_COUNTY>
<STOP_POSTCODE>EPL_POSTCODE</STOP_POSTCODE>
<STOP_CONTACT_NAME>EPL_CONTACT</STOP_CONTACT_NAME>
<STOP_CONTACT_PHONE>EPL_PHONE</STOP_CONTACT_PHONE>
<STOP_PLANNED_ARRIVAL_DATE>2012-12-19T20:30:00</STOP_PLANNED_ARRIVAL_DATE>
<STOP_PLANNED_DEPARTURE_DATE>2012-12-19T21:00:00</STOP_PLANNED_DEPARTURE_DATE>
</STOP_DETAIL>
<ORDERS>
<ORDER>...</ORDER> - as defined in the ORD message
</ORDERS>
</STOP>
</STOPS>
</EVENT_DETAIL>
</EVENT>
</OBS_XML>
The TRIP_HEADER and TRIP_DETAIL sections will be generated from the EPOD_LOAD DAL object, from a new method ToTTMXElement().
The method will also retrieve the jobs for the load into an EPOD_JOBS collection, with all heirarchical detail (CONTAINERS and PRODUCTS).
The STOPS and ORDERS sections will be generated from the EPOD_JOB DAL object, from a new method ToTTMXElement(strMsgType) (defined in a later section). The parameter to control whether the XML extract will create Stop-level information will be set to the message type TRP.
Note: the ORDERS section may be fully-populated or only contain the ORDER_HEADER section without any lower-level collection tags e.g. ORDER_HEADER_ADDRESSES, ORDER_DETAILS. This detailed information will only be generated if the EPL_XFER_FLAG against the job is blank. At any other value, only Header information will be built, as we have already informed TTM of the order's existence (i.e. on an initial TRP message).
Type RES
This message will be used for the following:
- Resequencing of Orders on Trips - Message type RES (based on TRP message).
The message will be sent by finding all EPL_MESSAGE_TYPE of "LOAD_RESEQUENCE" on EPOD_USER_AUDIT where the interface flag = "N".
Note: At this time, full resequencing is NOT supported, so this development is not required.
Warning: EITHER
All records found will have an individual file created for them.
OR
All records found will be sent in one file.
The process will:
- For Each Record Found:
- Start transaction
- Build the RES XML information for the record.
- Set the record interface flag to "Y"
- Build temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
RES message format:
Warning: No format provided for this message
Type ORD
This message will be used for the following:
- Updates of Order information
The message will be sent by finding all Jobs on EPOD_JOB where the Interface flag is blank - the status is irrelevant.
Warning: EITHER
All Jobs found will have an individual file created for them.
OR
All Jobs found will be sent in one file.
The process will:
- For Each Job Found:
- Start transaction
- Build the Order and Stop Full XML information for the Job.
- Set the Job interface flag to "N"
- Build temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
Note: Order Detail XML data will send Containers with a quantity of 1, by default. If the container is a loose container, it will send the product information within instead.
Sample file, identifying the field used
<?xml version="1.0" encoding="UTF-8"?>
<OBS_XML>
<EVENT>
<EVENT_HEADER>
<EVENT_PROCESSED>N</EVENT_
<EVENT_SOURCE_TYPE>EPOD</EVENT_SOURCE_TYPE>
<EVENT_SOURCE_NAME>EPL_SITE_ID</EVENT_SOURCE_NAME>
<EVENT_DATE>2012-12-20T11:41:23</EVENT_DATE> - The Date/Time the message was built
<EVENT_TYPE>ORD</EVENT_TYPE>
<EVENT_ACTION>R</EVENT_ACTION>
</EVENT_HEADER>
<EVENT_DETAIL> - This section will be hard-coded within the ORD message...
<TRIP_HEADER>
<TRIP_IDENTIFIER>O</TRIP_IDENTIFIER>
</TRIP_HEADER>
<STOPS>
<STOP>
<STOP_HEADER>
<STOP_IDENTIFIER>O</STOP_IDENTIFIER>
<STOP_SEQ>0</STOP_SEQ>
</STOP_HEADER> - ... up to here
<ORDERS>
<ORDER>
<ORDER_HEADER>
<ORDER_TRANSACTION_DATE>2012-12-20T00:00:00</ORDER_TRANSACTION_DATE> - Date job created
<WMS_WAREHOUSE>EPL_SITE_REF</WMS_WAREHOUSE>
<WMS_OWNER>EPL_JOB_GROUP_REF</WMS_OWNER>
<SO_REF>EPL_SO_NUMBER</SO_REF>
<TMS_REF>EPL_JOB_ID</TMS_REF>
<PO_REF>EPL_CUST_REF</PO_REF>
<BOOK_DATE>2012-12-24T10:00:00</BOOK_DATE> - Planned Start Date/Time
<ORDER_HEADER_ADDRESSES>
<ORDER_HEADER_ADDRESS>
<ADDRESS_TYPE>DEL</ADDRESS_TYPE>
<ADDRESS_ID>EPL_CUSTOMER_CODE</ADDRESS_ID>
<ADDRESS_NAME>EPL_NAME</ADDRESS_NAME>
<ADDRESS_LINE1>EPL_ADDR_LINE_1</ADDRESS_LINE1>
<ADDRESS_LINE2>EPL_ADDR_LINE_2</ADDRESS_LINE2>
<ADDRESS_TOWN>EPL_ADDR_LINE_3</ADDRESS_TOWN>
<ADDRESS_POSTCODE>EPL_POSTCODE</ADDRESS_POSTCODE>
</ORDER_HEADER_ADDRESS>
</ORDER_HEADER_ADDRESSES>
</ORDER_HEADER>
<ORDER_DETAILS>
<ORDER_DETAIL>
<DETAIL_TYPE>D</DETAIL_TYPE> - D for Container, S for Stock
<ITEM_IDENTIFIER>EPL_CONTAINER_ID</ITEM_IDENTIFIER>
<ITEM_DESCRIPTION>EPL_DESCRIPTION</ITEM_DESCRIPTION>
<ORDERED>1</ORDERED>
<TO_DELIVER>1</TO_DELIVER>
</ORDER_DETAIL>
<ORDER_DETAIL>
<DETAIL_TYPE>S</DETAIL_TYPE>
<ITEM_IDENTIFIER>EPL_PRODUCT_ID</ITEM_IDENTIFIER>
<ITEM_DESCRIPTION>EPL_DESCRIPTION</ITEM_DESCRIPTION>
<ORDERED>1</ORDERED> - ORDERED_QTY
<TO_DELIVER>1</TO_DELIVER> - PLANNED_QTY
</ORDER_DETAIL>
</ORDER_DETAILS>
</ORDER>
</ORDERS>
</STOP>
</STOPS>
</EVENT_DETAIL>
</EVENT>
</OBS_XML>
The ORDERS section will be generated from the EPOD_JOB DAL object, from a new method, ToTTMXElement(strMsgType). This will be added to EPOD_CONTAINER and EPOD_PRODUCT as well, to generate the ORDER_DETAIL section. The parameter will control whether the XML extract will create Stop-level information (required for the TRP message).
Type DEL/CAN
This message will be used for the following:
- Order Complete - Message type DEL
- Order Cancelled - Message type CAN
The message will be sent by finding all Jobs on EPOD_JOB where the Interface flag is "N" and the status is "C" or "X", sorted by status. All Jobs found will be sent in one file for DEL and one file for CAN.
The process will:
- Start transaction
- For Each Complete Job Found:
- Build the Order and Stop Full XML information for the Job.
- Set the Job interface flag to "Y"
- Build/Add to temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
- Start transaction
- For Each Cancel Job Found:
- Build the Order and Stop Full XML information for the Job.
- Set the Job interface flag to "Y"
- Build/Add to temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
Note: Order Detail XML data will send Containers with a quantity of 1, by default. If the container is a loose container, it will send the product information within instead.
DEL message format:
<?xml version="1.0" encoding="UTF-8"?>
<OBS_XML>
<EVENT>
<EVENT_HEADER>
<EVENT_PROCESSED>N</EVENT_PROCESSED>
<EVENT_SOURCE_TYPE>EPOD</EVENT_SOURCE_TYPE>
<EVENT_SOURCE_NAME>EPL_SITE_ID</EVENT_SOURCE_NAME>
<EVENT_DATE>2012-12-20T01:42:11</EVENT_DATE>
<EVENT_TYPE>DEL</EVENT_TYPE>
<EVENT_ACTION>C</EVENT_ACTION>
</EVENT_HEADER>
<EVENT_DETAIL>
<TRIP_HEADER>
<TRIP_IDENTIFIER>T</TRIP_IDENTIFIER>
<TRIP_TRANSACTION_DATE>2012-12-20T01:37:55</TRIP_TRANSACTION_DATE>
<TRIP_ID>EPL_LOAD_ID</TRIP_ID>
</TRIP_HEADER>
<TRIP_DETAIL>
<TRACKING>N</TRACKING>
<DRIVER>EPL_USER_ID</DRIVER>
<DRIVER_NAME>EPL_USER_NAME</DRIVER_NAME>
<TRACTOR>EPL_VEHICLE_ID</TRACTOR>
<COST_CENTRE>EXEL</COST_CENTRE>
<TRIP_STATUS>PLANNED</TRIP_STATUS>
<TRIP_REF>M2480031</TRIP_REF>
<TRIP_TRAILER_ID>EPL_VEHICLE_ID</TRIP_TRAILER_ID>
<TRIP_TRAILER_TYPE>EPL_DESCRIPTION</TRIP_TRAILER_TYPE>
<TRIP_DISTANCE>0</TRIP_DISTANCE>
</TRIP_DETAIL>
<STOPS>
<STOP>
<STOP_HEADER>
<STOP_IDENTIFIER>S</STOP_IDENTIFIER>
<STOP_SEQ>1</STOP_SEQ>
</STOP_HEADER>
<STOP_DETAIL>
<STOP_REF>C</STOP_REF>
<STOP_TYPE>CL</STOP_TYPE>
<STOP_LOCATION_TYPE>2</STOP_LOCATION_TYPE>
<STOP_LOCATION_ID>EPL_CUSTOMER_ID</STOP_LOCATION_ID>
<STOP_LOCATION_NAME>EPL_CUSTOMER_NAME</STOP_LOCATION_NAME>
<STOP_ADDR_LINE1>EPL_ADDR_LINE_1</STOP_ADDR_LINE1>
<STOP_ADDR_LINE2>EPL_ADDR_LINE_2</STOP_ADDR_LINE2>
<STOP_ADDR_LINE3>EPL_ADDR_LINE_3</STOP_ADDR_LINE3>
<STOP_TOWN>EPL_ADDR_LINE_4</STOP_TOWN>
<STOP_COUNTY>EPL_ADDR_LINE_5</STOP_COUNTY>
<STOP_POSTCODE>EPL_POSTCODE</STOP_POSTCODE>
<STOP_CONTACT_NAME>EPL_CONTACT</STOP_CONTACT_NAME>
<STOP_CONTACT_PHONE>EPL_PHONE</STOP_CONTACT_PHONE>
<STOP_PLANNED_ARRIVAL_DATE>2012-12-19T20:30:00</STOP_PLANNED_ARRIVAL_DATE>
<STOP_PLANNED_DEPARTURE_DATE>2012-12-19T21:00:00</STOP_PLANNED_DEPARTURE_DATE>
</STOP_DETAIL>
<ORDERS>
<ORDER>...</ORDER>
</ORDERS>
</STOP>
</STOPS>
</EVENT_DETAIL>
</EVENT>
</OBS_XML>
CAN message format: Same as DEL message
The STOPS and ORDERS section will be generated from the EPOD_JOB DAL object, from a new method, ToTTMXElement(strMsgType). This will be added to EPOD_CONTAINER and EPOD_PRODUCT as well, to generate the ORDER_DETAIL section. The parameter will control whether the XML extract will create Stop-level information (required for the TRP, DEL and CAN messages). If the Job is at status C or X (Cancelled or completed) and the message type is DEL or CAN, this will also generate an DELIVERED tag in the ORDER_DETAIL section, showing the Actual Delivered Qty of the container (1) or the Loose product (EPL_PRODUCT_QTY_ACTUAL)
Type OIT
This message will be used for the following:
- Operation In Transit - Message type OIT, including GPS information (based on existing ALC message)
The message will be sent by finding all EPL_MESSAGE_TYPE of "JOB_LOCK_REQUEST" on EPOD_USER_AUDIT where the interface flag = "N".
All records found will have an individual file created for them.
The process will:
- For Each Record Found:
- Start transaction
- Build the OIT XML information for the record.
- Set the record interface flag to "Y"
- Build temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
OIT message format:
<?xml version="1.0" encoding="UTF-8"?>
<OBS_XML>
<EVENT>
<EVENT_HEADER>
<EVENT_PROCESSED>N</EVENT_PROCESSED>
<EVENT_SOURCE_TYPE>EPOD</EVENT_SOURCE_TYPE>
<EVENT_SOURCE_NAME>EPL_SITE_ID</EVENT_SOURCE_NAME>
<EVENT_DATE>2012-12-20T01:42:11</EVENT_DATE>
<EVENT_TYPE>OIT</EVENT_TYPE>
<EVENT_ACTION>C</EVENT_ACTION>
</EVENT_HEADER>
<EVENT_DETAIL>
<TRIP_HEADER>
<TRIP_IDENTIFIER>T</TRIP_IDENTIFIER>
<TRIP_TRANSACTION_DATE>2012-12-20T01:37:55</TRIP_TRANSACTION_DATE> - Date/Time from audit record
<TRIP_ID>EPL_LOAD_ID</TRIP_ID>
</TRIP_HEADER>
<TRIP_DETAIL>
<TRACKING>Y</TRACKING>
<DRIVER>EPL_USER_NAME</DRIVER>
<TRACTOR>EPL_VEHICLE_ID</TRACTOR>
<TRACTOR_LAT>EPOD_USER_AUDIT.GPS_COORD</TRACTOR_LON>
<TRACTOR_LON>EPOD_USER_AUDIT.GPS_COORD</TRACTOR_LAT>
</TRIP_DETAIL>
<STOPS>
<STOP>
<STOP_HEADER>
<STOP_IDENTIFIER>S</STOP_IDENTIFIER>
<STOP_SEQ>1</STOP_SEQ>
</STOP_HEADER>
<STOP_DETAIL>
<STOP_LOCATION_ID>EPL_CUSTOMER_ID</STOP_LOCATION_ID>
</STOP_DETAIL>
<ORDERS>
<ORDER>...</ORDER>
</ORDERS>
</STOP>
</STOPS>
</EVENT_DETAIL>
</EVENT>
</OBS_XML>
Note: Order listed here is just the Order Header, minus the address information, as follows:
<ORDER>
<ORDER_HEADER>
<ORDER_TRANSACTION_DATE>2012-12-20T00:00:00</ORDER_TRANSACTION_DATE> - Date/Time from audit record
<WMS_WAREHOUSE>EPL_SITE_REF</WMS_WAREHOUSE>
<WMS_OWNER>EPL_JOB_GROUP_REF</WMS_OWNER>
<SO_REF>EPL_SO_NUMBER</SO_REF>
<TMS_REF>EPL_JOB_ID</TMS_REF>
<PO_REF>EPL_CUST_REF</PO_REF>
</ORDER_HEADER>
</ORDER>
Type ARR
This message will be used for the following:
- Arrival at stop
The message will be sent by finding all EPL_MESSAGE_TYPE of "JOB_ARRIVE_REQUEST" on EPOD_USER_AUDIT where the interface flag = "N".
Note: These messages should be created only from the Android system, when the Arrival button is pressed. This will require changes made to the ePOD server to process EJOB_ARRIVE_REQUEST messages. When they arrive, they should process like a job lock request except:
- Set ARRIVAL_DATE/TIME rather than status = "I"
All records found will have an individual file created for them.
The process will:
- For Each Record Found:
- Start transaction
- Build the ARR XML information for the record.
- Set the record interface flag to "Y"
- Build temporary file with XML information
- Rename temporary file to destination directory and filename
- Commit transaction
ARR message format:
As OIT but with an event type of ARR, and no Orders section.
Appendix A: TEST PLAN
| Test Script / Scenario Reference | EPOD-TTM Interface | Call Number(s): 304310 |
| Test Script / Scenario Description | description of what is to be achieved | PASS / ISSUES / FAIL |
| Menu Access | Where on the menus the item can be found | |
| Pre-requisites | The prerequisites of the test | Tested By: |
| Test Objective | The details of what each group of tests is to achieve | Date: |
| Step | Action | Result | Remarks | P/F |
| 1 | Area being tested in this cycle | |||
| Any notes or prerequisites for the tests following. | ||||
| 1.01 | The actions to follow | The expected result | ||
| 1.02 | The actions to follow | The expected result | ||
| 1.03 | The actions to follow | The expected result |
Appendix B: Quote & Document References
| Cost Details | |||
| Activity | No. of Days | Rate per Day (£) | Cost (£ Exc. VAT) |
| Requirements | 0.00 | 0 | £0.00 |
| Change Request Evaluation | 0.00 | 0 | £0.00 |
| Functional Specification | 0.00 | 0 | £0.00 |
| Technical Specification | 0.00 | 0 | £0.00 |
| Development | 0.00 | 0 | £0.00 |
| Testing and Release | 0.00 | 0 | £0.00 |
| Implementation | 0.00 | 0 | £0.00 |
| Project Management | First argument to "number_format" must be a number. | 0 | £First argument to "number_format" must be a number. |
| TOTAL | First argument to "number_format" must be a number. | £First argument to "number_format" must be a number. | |
| Estimate excludes training, release to live and go live support. |
B.1 References
| Ref No | Document Title & ID | Version | Date |
| 1 | Reference1 | 0.1 | 01/01/2011 |
B.2 Glossary
B.3 Authorised By
Phil Harding | OBS Project Manager | _____________________________ |
Graham Rothwell | OBS Consultant | _____________________________ |
