TMS

From UG

Revision as of 23:16, 24 September 2013

Def

TMS - in general it is Transportation Management System.

In our case it is the Descartes TMS that we integrated with our CT2 system.

Load

mysql> describe tblLoad;
+-----------------------+--------------+------+-----+---------+----------------+
| Field                 | Type         | Null | Key | Default | Extra          |
+-----------------------+--------------+------+-----+---------+----------------+
| Id                    | int(10)      | NO   | PRI | NULL    | auto_increment |
| LoadNumber            | char(15)     | NO   | UNI | NULL    |                |
| DateOfReceipt         | date         | NO   |     | NULL    |                |
| TotalCharge           | double(15,3) | YES  |     | NULL    |                |
| TotalWeight           | double(15,3) | YES  |     | NULL    |                |
| BaseRate              | double(15,3) | YES  |     | NULL    |                |
| OtherCharges          | double(15,3) | YES  |     | NULL    |                |
| CarrierId             | int(10)      | YES  | MUL | NULL    |                |
| FreightTrendset       | double       | NO   |     | 0       |                |
| FuelTrendset          | double       | NO   |     | 0       |                |
| TransmittedToTrendset | bit(1)       | NO   |     | b'0'    |                |
| FTL                   | bit(1)       | NO   |     | b'0'    |                |
+-----------------------+--------------+------+-----+---------+----------------+
12 rows in set (0.09 sec)

Load Number

• UI: shows on Shipment details
• DB: LoadNumber

TMS Admin

Admin Requirements

Not to hard code specific CT2/TMS functionality, so as to allow management users the ability to set specifics. Full spec is under category: EDI to TMS

What can be managed here are the following:

• Automatic and manually forwarding the approved portal CT records to the TMS
  • Setup the CT2 & TMS server addresses for exchange
  • Users can un-check auto option and select dates from calendar

• Automatically accept updates sent to CT2 from the TMS
  • This can be managed in number of seconds
  • Option for FTP server to hold/store xml files received that have a future date is set and re-ck at a specif time - IE currently set to 12am

• Allowing management users to change/set the number of days, on the Shipment Import XML file, between the earliest pickup date and latest pickup date - IE currently set to 7days from the Approved On Date which = Earliest Pickup Date

Admin mock up

Below is outdated.

SOWs

SOW 1 Add Bill To Party parameter to Descartes TMS properties

Bill To Party

mantis: 4178

spec:

Add Bill To Party parameter to Descartes TMS properties (Admin).

Relationship is one to one: only one Bill To Party value is active at one time for Desc TMS.

Please note that this value is selected when E0 parameter is selected or changed in TMS Admin. System will present a list of Bill To Party values in the system associated with selected E0. User would have to select one.

See also Client_Company#SOW_3_Client_Company_to_Bill_To_link.

SOW 2 Trucker Events

mantis: 0004306

spec:

Trucker might send a series of messages through TMS for specific load.

Each message have these attributes:

• date/time
• Trucker - company from which message came
• message code
• message description

Probably need to create new entity "TMS Trucker Events" with fields above.

Trucker message codes is probably a separate DB table.

On CT Editor/viewer (including ASN Client app interface) I suggest to show this info as a table - all columns as defined above plus event# (use 1,2,3, ... as they come). Table is sorted by date.

Example of messages:

3001	 Appointment Delivery 
3002	 Awaiting Export
3003	 Broker Issue
3011	Damage - Rewrapped
3012	Delivered
3013	Delivery missed

There are 72 codes altogether.

There would also be some KPI reports defined related to this.

See also

These are the original Analysis / Requirements wiki for EDI to TMS proj Mantis: 2183 & the phase 2 are found here: 2539