tms supertrip guide - railcar management llc -...

TMS Supertrip Guide

Release 15.0

CopyrightCopyright 2007 Railcar Management Inc. All Rights Reserved. Reproduction in any form prohibited, without express permission.Printed in the United States of America.RMI - Delivered under license agreement.Copying and disclosure prohibited without express written permission from RMI.

RMI1819 Peachtree Road, Suite 303Atlanta, Georgia 30309 USAPhone: 404.355.6734Fax: 404.352-8814Internet address: www.railcarmgt.com

WarningAll information in this document, as well as the software to which it pertains, is proprietary material of RMI, and is subject to an RMI license and non-disclosure agreement. Neither the software nor the documentation may be reproduced in any manner without the prior written permission of RMI.Specifications are subject to change without notice.

About This ManualThe TMS Supertrip Guide is an instructional document designed to be used as a reference while using RailConnect, TMS, RMS, ShipperConnect, and IRCS-Connect applications, products of RMI.This version of the TMS SupertripGuide includes changes made to the system for TMS Release 15.0.

TrademarksTMS, RMS, ShipperConnect, and RailConnect are registered trademarks of RMI.

TMS Supertrip Guide

Table of Contents

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5What is Supertrip? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5How Does Supertrip Work? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Setting Up TMS for Supertrip . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Railroad Profile Maintenance Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Charge Master . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8RWC Codes and Supertrip . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Supertrip Records . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Viewing Records in Initial/Number Sequence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Viewing Records by Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16Viewing an Individual Supertrip Record . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

The Banner Box . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17How Supertrip Assigns The Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21First Screen Data Fields: Waybill Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22Second Screen Data Fields: Freight Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Third Data Fields Screen: Fleet Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Demurrage/Storage Detail Information Screen . . . . . . . . . . . . . . . . . . . . . . . . . . 31Car Hire Detail Information Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Station Information Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Customer Information Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38Charge Information Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39

Supertrip Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40Supertrip Base Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Customizing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46

Customizing Reports: Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Printing Supertrip Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

Supertrip Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56How To Run A Manual Supertrip Update . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59How and Why to Run Refresh . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Manually Adding Supertrip Records . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61Reviewing Unapplied ISS Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62Entering Estimated Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64

Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Trip Type Calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Using Car Movements to Define Traffic Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Unknown Customers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Supertrip Frequently Asked Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71

Revised 2/07 TMS Supertrip Guide 3

Table of Contents

Appendix - Sample Base Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81Alpha Shipper . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82Car Hire/Revenue Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83Day, Month, Year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84Demurrage/Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85Non-Revenue Traffic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86Notification . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87Revenue Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88Revenue Detail #2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89Revenue Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90Revenue Traffic Basic List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91Revenue Traffic Report #2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92Simple Destination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93Switch/Junction Settlement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94STCC, Station, By Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95Transit Time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96Transit Time with Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97Transit Time Worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98Two Period Averages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99Two Period Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100Unknown Customer Bridge/Delivered/Received . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101Unknown Customer 2020 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102Velocity Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103Velocity Report #2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104Velocity Report #3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10512 Month Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

4 TMS Supertrip Guide Revised 2/07

IntroductionWhat is Supertrip?

Introduction

What is Supertrip?Supertrip is a powerful TMS reporting tool that works by gathering important data about a complete railcar or intermodal trip into one record. Originally designed by a committee of TMS users, Supertrip provides a quick and easy tool that can be used to produce traffic analysis and trend reports. You can also use Supertrip to analyze time spent for various trip cycles, along with the associated revenues and car hire costs.

How Does Supertrip Work?Supertrip's main function is to gather together all the important information regarding a railcar's trip into one record. For example, as a car moves over your operation, TMS writes each move in the Car Movement History file. Each move is associated with a waybill, either loaded or empty, that is maintained in the TMS waybill file. The interline, switching, and demurrage revenue for the move reside in other TMS files. Car hire and reclaim information is stored in yet another area. Because data is stored in so many different locations, producing traffic and sales reports can be complicated.Supertrip solves this problem by pulling the most important information for each trip into one record. Each time the Supertrip update occurs (usually as a scheduled job that runs periodically throughout the day), TMS pulls all these records together into a single Trip record. These assembled records are an excellent source for quickly reviewing and reporting on the most important information about the trip.

NOTE: It is important to understand that Supertrip is a tool for reporting traffic trends and marketing reports. While Supertrip does contain revenue information, you should not use Supertrip to produce or balance financial statements.


Setting Up TMS for Supertrip Introduction

Setting Up TMS for Supertrip

IntroductionVarious switches and settings for Supertrip appear throughout TMS. These settings allow you customize how Supertrip functions on your operation.

NOTE: This information is also available in the TMS Users Manual and the TMS Administrators Manual.

Railroad Profile Maintenance ScreenThe Railroad Profile Maintenance screen contains basic setup information covering how TMS will be used on your railroad. Several switches that you can use to customize how Supertrip will be used appear on this screen.

To set or check the Railroad Profile Maintenance screen:1. Choose option 36 System Administrator from the TMS Main Menu.

2. Select option 1 Railroad Profile from the System Administrator menu.

3. Take option 8 Supertrip from the Railroad Profile menu. The Client Supertrip Setup screen appears (Figure 1).

RSCXE1R LIRC Client Supertrip Setup RMICDBA1 CHANGE TMS Version is: 12.20 Road Mark: LIRC Name LOUISVILLE & INDIANA RAILROAD 260 Number 434 ------------------------------------------------------------------------------ SUPERTRIP: Use Moves For Supertrip Traffic Type No Update Supertrip With ISS Waybill Data No Use currency conversion in Supertrip No F3=Exit

Figure 1


Setting Up TMS for SupertripRailroad Profile Maintenance Screen

4. Use the following fields to customize the way Supertrip functions on your operation:

5. Press Enter to save, then F3 to exit.

Use Moves For Supertrip Traffic Type

Enter Y in this field to have Supertrip use the actual movements of the car on your operation to determine traffic type. If you enter N in this field, Traffic Type will be determined by the waybill route.NOTE: When set to Y, the Use Moves for Supertrip Traffic Type field instructs Supertrip to determine if a move should be counted as received, forwarded, bridge, or local based on the actual move the car made on your railroad. The system default is to make this determination based on the waybill route. However, the waybill information is often incorrect for switching and/or junction settlement railroads. This results in Supertrip being unable to always correctly determine the traffic type represented by the move. RMI recommends that all railroads that do not settle freight based on ISS interline movement set this switch to Y.

Update Supertrip with ISS Waybill Data

If your railroad settles freight though the Interline Settlement Process (ISS), set this field to Y to have the Supertrip records updated with ISS revenue.

Use Currency Conversion in Supertrip

If your railroad settles freight in both US and Canadian funds, enter a Y in this field to have TMS convert Canadian funds into US dollars. This conversion is done only within Supertrip itself and does not impact invoices issued in TMS.


Setting Up TMS for Supertrip Charge Master

Charge Master

TMS uses charge codes to generate billing for items such as switching settlements, junction settlements, and miscellaneous billing. These charges are included in Supertrip.

You may have an occasion, however, when you do not want revenue generated by a charge code to be included in Supertrip. For example, you may be using a charge code to keep track of cars moving over a joint facility for which you will not be producing an actual invoice in TMS. In cases such as this, you can take the steps described below to exclude TMS charges from Supertrip.

To exclude a charge code from Supertrip:1. Select option 23 Switch/Other Charges from the TMS Main Menu.

2. Select option 1 Charge Master. The Show Incidental Charge Master screen appears (Figure 2).

RSBPDFR GNRR Show Incidental Charge Master QPADEV0024 ------------------------------------------------------------------------------Find: Code Eff Date Exp Date Bill To Srvc Cd Rate Rate Code Ref G/L Account Number Cost Center Auth Type Authority Nbr Agency Item Nbr -------------------------------------------------------------- SHOW: *ALL Eff Exp Srvc Rate ? Code Date Date Bill To Code Rate Code Reference BARNHARDT 1/01/03 DFBARNHAR NC Z 200.0000 PC barnhardt stora BNSF106972 2/24/05 4/30/05 CSXT J 400.0000 PC steelscape inc BNSF110518 5/10/03 CSXT J 400.0000 PC STEEL BNSF111258 5/27/06 4/30/07 CSXT J 400.0000 PC met. arkansas BNSF111258 6/04/05 CSXT J 400.0000 PC met. arkansas BNSF111258 1/20/05 4/30/05 CSXT J 300.0000 PC met. arkansas BNSF305490 1/11/05 6/15/05 CSXT J 400.0000 PC deer park, tx BNSF57475 10/26/05 CSXT J 500.0000 PC mt.belvieu,tx g BNSF57523 9/30/05 11/17/05 CSXT J 300.0000 PC deer park, tx BNSF90038 11/18/05 10/31/06 CSXT J 300.0000 PC deer park, tx More...1=Select C=Copy P=Pending Charges R=RWC Usage F3=Exit F6=Print File X=Recalc Current Charges F9=Add New Charge F10=Show All/Active/Inactive

Figure 2


Setting Up TMS for SupertripCharge Master

3. Enter 1 next to the record you want to update and press Enter. The Edit Incidental Charge Master screen appears (Figure 3).

4. The Include in Supertrip field will automatically default to Y whenever you enter a new charge code. To prevent charges generated by this code from being included in Supertrip, remove the Y from this field.

5. Press Enter to save changes, then F3 to exit.

RSAME1R GNRR Edit Incidental Charge Master QPADEV0024 Charge Code: BNSF106972 Effective Date: 22405 Billing Station: 4766 Expiration Date: 43005 Reference: steelscape inc Service Code: J Service Group: S Inbound Jct Settlement Road: CSXT Customer: Charge Adjustment Code: Currency Type: Rate: 200.0000 Rate Code: PC Minimum Amount: 200.00 Sales Tax Code: Price Authority: Type PR Number . . 106972 Agency: BNSF Item Number: Include in Supertrip (Y/' '): Y Absorbed or Unabsorbed: Suppress Zero-Charges (Y/' '): Suppress Extract to Cash (Y/' '): G/L Number: Cost Center: Changed By: RMIUSER Date: 3/04/05 Time: 12:27 F3=Exit F6=Display RWC Usage F7=Display Pending Charges F11=Delete

Figure 3


Setting Up TMS for Supertrip RWC Codes and Supertrip

RWC Codes and SupertripRepetitive Waybill Codes (RWCs) let users rapidly and accurately enter billing in TMS. You can also use this powerful tool to generate charges, car hire exceptions, and blocking instructions.

You can also use RWCs to customize information written to Supertrip by defining the main customer (The Customer) and traffic type. In particular, switching and/or junction settlement carriers should use this feature.

To use RWCs to customize Supertrip information:1. Select option 21 Manage Waybills from the TMS Main Menu.2. Select option 2 Repetitive Waybill Codes -- RWC. The View Waybill RWC

screen appears (Figure 4).

RSI0DFR LIRC View Waybill RWC RMICDBA1 DISPLAY ------------------------------------------------------------------------------ RWC : LE TMC S/H Last Used Dest: ST Csg STCC Number Orig: ST Shp STCC ------------------------------------------------------------------- ACTIVE Opt RWC Type LE TMC Commodity Consignee Shipper AMEMPTYCARS INBND E R **EMPTY** KROOTSCRAP BLABEA-E ACTIV E R **EMPTY** BLACKBEAUTY AGENTLOUISV BLABEACART ACTIV L R COAL GAPOWER BLACKBEAUTY BLABEAINDY ACTIV L R COAL INDIANAPOWER BLACKBEAUTY CARGCANT ACTIV L R CORN CARGIL CARGIL CARGCHIC ACTIV L R CORN CARGIL CARGIL CARGJEFF ACTIV L R CORN CARGILL CARGIL CARGLOGCANT ACTIV L R CORN CARGIL CARGIL CARGLOGCHIC ACTIV L R CORN CARGIL CARGIL EID-LOU-NS HYDACID ACTIV E R HYDROCHLOR PVSCHEMIC EIDUPONT EXXONCHIEXXONHOU ACTIV L R PLASTIC EXXONCHEMIC EXXON FEAGTCARTOL ACTIV E R **EMPTY** CARGILL AGENTCHICAG More... A=Activate C=Copy D=Delete I=Inactivate P=Print U=Waybill Usage W=Waybill X=Block Usage F3=Exit F7=Alt View F9=Add F10=Active/Inactive

Figure 4


Setting Up TMS for SupertripRWC Codes and Supertrip

3. Enter 1 next to the RWC you want to review and/or edit. The Repetitive Waybill Code Page 1 screen appears (Figure 5).

4. Press F16. The Edit RWC Miscellaneous Info screen appears (Figure 6).

RSI1E3R GNRR REPETITIVE WAYBILL CODE Page 1 QPADEV0024 CHANGE ------------------------------------------------------------------------------RWC: BALLAST RWC Type I Inbound ------------------------------------------------------------------------------Transportation Method Code R L/E Status L Weight Code Car Type BOL / Code . . : Reference / Code STCC 1421930 BALLAST HAZMAT: Ldg Qty Unit (A/S) S PP/CC PP Sec7(S) . . . Weight Type . . Capacity Code Route Code Route: CSXT ELZBG GNRR S 1 Dest: Stn ELIZABETH St GA FSAC 62322 Csg GEORGIA NORTHEASTERN RR Orig: Stn KENNESAW St GA FSAC 49674 Shp VULMATERI Care Of F4=Route PageDn=Next Screen F8=STCC F10=Upd w/o Edit F14=Reference NumbersF15=Stops F16=Chrgs/Blckng F21=Price Auth F22=Partial Seed F24=Supplement

Figure 5

RSH6PVR GNRR Edit RWC Miscellaneous Info QPADEV0024 ------------------------------------------------------------------------------ RWC ID: BALLAST Holds Exist: No ------------------------------------------------------------------------------ Type Description Charge Code Charge To Rate Qual NO CHARGES FOUND Switch Instructions Ignore Blocking Table Block To . . . . . Retain Existing Pending Charges Station/Track/Spot 4766 Left-at 4766 Switch To . . . . Special Instruction Code The Customer . . . Reverse Route Block To Product Group Code Demurrage Code . . Demurrage Flag (N=No Demurrage) Car Hire Flag . . Pay Up To: Time Mileage Reclaim Code . . . Switch/Haulage. . S Haulage: Road Type Priority Code . . Supertrip Traffic Company Materials Y EDI Send To Override Ignore 420 . Controlling Road PRODUCT: Quality % Dust Rating. On/Off Cust Spec To Be Weighed Weigh Party Activity Trace Request F3=Exit F14 Customs Info F16=Charges F18=Holds

Figure 6


Setting Up TMS for Supertrip RWC Codes and Supertrip

5. Use the following fields on the Edit RWC Miscellaneous Info screen to customize the information written to Supertrip:

6. Press Enter to save any changes, then F3 to exit.

Supertrip Traffic

Use this field to force a particular traffic type into Supertrip. The value in this field will replace the traffic type in the waybill or the traffic type otherwise calculated by Supertrip based on car movements. The following traffic types are valid:

O OperatingB Bridge E Empty F Forwarded L Local R Received.

For example, if your operation received a move from a switch carrier and delivered the car off-line to a line haul carrier, Supertrip might consider this a bridge moved based on the waybill information. You can use the RWC applied to the loaded move to force a Received or Forwarded traffic type into Supertrip instead.NOTE: This is a powerful option for roads that receive waybills of very poor quality or roads for which the connecting carrier has stripped information out for switching/haulage movements.

The Customer When Supertrip constructs a trip record, it attempts to determine who was the most important customer on a move. In some cases, however, the waybill quality is so poor that Supertrip has trouble determining who that customer should be. In particular, Supertrip often has trouble making this determination for switching and junction settlement carriers for which waybill data for received moves is stripped out by connecting carriers. To correct this problem you can use this RWC field to force a value for The Customer field. NOTE: RMI highly recommends that switching/junction settlement carriers use RWCs to set the value for The Customer.


Supertrip RecordsIntroduction

Supertrip Records

IntroductionAs cars move over your railroad, TMS records each event into Car Movement History. A TMS trip consists of movements, both loaded and empty, associated with a cycle across your railroad. Each movement has an associated waybill. Each trip may include additional information such as interline revenue, switching charges, demurrage charges, and car hire payables. For example, on most forwarded moves, your railroad will receive and place the car as an empty. You will then release the car as a load and deliver it off-line as a load. Supertrip brings together all of this information into a single trip record for the car. You can run reports based on this data or view the data to obtain a quick view of the important information for each trip.TMS provides three list-type screens that you can use to look at individual trip records created in Supertrip. Two are in initial/number sequence; the third is in sequence by The Customer.

Viewing Records in Initial/Number Sequence

To view Supertrip records in initial and number sequence:1. Choose option 11 Customer Service Menu from the TMS Main Menu.

2. Choose one of the following options:1 Revenue Trips by Equipment to see only revenue trips. Revenue can be either Switching/Other Charges or an interline proportion.

2 All Trips by Equipment to see all trips made on your railroad. This list screen shows trips both with and without revenue.


Supertrip Records Viewing Records in Initial/Number Sequence

When you choose either of these options, the Trips by Equipment screen appears (Figure 7):

NOTE: To move directly to a particular trip for a piece of equipment, type the initial and number in the header and press Enter.

Field Definitions

RSEKDFR LIRC Trips by Equipment RMIJWA Find Car: Traffic Type: Revenue Type: Car Kind: Date: TMC: Customer: ------------------------------------------------------------------------------ ? Car --Date-- Consignee Shipper STCC Commodity Trf Rev KD AA 4566 5/05/06 BASF CORP BASF CORP 2899903 ETHYLHEXY F H RR AAAB 125268 10/27/06 ACF INDUS ACCOORS 4905426 BUTYLENE, F H A6 AAAB 125268 3/03/06 ACF INDUS ACCOORS 4905426 BUTYLENE, F H A6 AAAC 125268 7/20/06 CARGIL CARGIL 0113210 CORN F I A6 AAAC 125268 4/07/06 E I DUPON CONAGRA 2821139 PLASTIC R S A6 AAMX 50142 3/23/06 ABB FORES PAUL HALE 2411410 PULPWOOD R S B2 AAR 5801 9/09/06 ADM PROCE ADM PROCE 4909215 MIXED LOA F I C AAR 5802 6/27/06 MGRMATERI CARGILL I 0113665 SHROCK GR F S A AAR 5825 6/16/06 SAFKLEOIL E I DUPON 2912110 BUTANE GA F I A4 AAR 5827 12/10/06 NEXFOR FR ALMACENAD 2045290 FLOUR EDB R S A4 AAR 5838 9/09/06 ADM ATLAN ADKINS CO 0113410 RICE,ROUG B H A4 ABC 1002 1/01/06 3585315 BEER COOL L I T ABOX 600 8/30/06 CLOTH WOR ADKINS CO 2352115 HATS OR C L I RR ABOX 600 9/05/06 ABB FORES ACSD HARP 4611110 AL FRT RT R S RR ABOX 800 6/19/06 CARGILL CARGIL 4929120 RADIOACTI B S A More... 1=Select I=Unapplied Revenue W=Loaded Waybill E=Empty Waybill F3=Exit

Figure 7

Car Railcar, trailer, or container initial and number.Date Date assigned by Supertrip as the start date for the trip.

Generally, this is the date the equipment was received in interchange. For local moves, this usually is the date the car was released loaded.

Consignee Consignee for the move.Shipper Shipper for the move.STCC STCC code of the commodity being transported.Commodity Commodity description.Trf Traffic type. The following are valid values:

F Forward (originated)B Bridge (overhead)R ReceivedL LocalE Empty O Operating (Locomotives)U Undefined.


Supertrip RecordsViewing Records in Initial/Number Sequence

Rev Revenue type. The following are valid values:I InterlineL LocalS Switch H HaulageN Non-revenue.

KD Type of equipment.


Supertrip Records Viewing Records by Customer

Viewing Records by CustomerTMS provides an additional list screen that you can use to review Supertrip records in customer sequence. The Customer here is the customer that Supertrip has determined to be the one you will probably use in most traffic trend or sales analysis reports. For an explanation of how Supertrip determines The Customer, see How Supertrip Assigns The Customer on page 21. You can also use the RWC to force in a value into The Customer field.

To view Supertrip records by customer:1. Choose option 11 Customer Service Menu from the TMS Main Menu.

2. Choose option 3 Revenue Trips by Customer from the Customer Service menu. The Trips by Customer screen appears (Figure 8).

NOTE: To view records for a particular customer, type the customer ID in the header and press Enter.

RSEQDFR GNRR Trips by Customer QPADEV0024 Find Customer: Car: Traffic Type: Revenue Type: Date: Car Kind: TMC: ------------------------------------------------------------------------------ ? Customer Name Car --Date-- STCC Commodity Trf Rev KD ALLMET ELI ALL METAL NYC 628764 3/07/00 3312332 STEEL R S E ALLMET ELI ALL METAL SM 4010 4/14/01 3312332 STEEL R S A ALLMET ELI ALL METAL UTLX 630372 4/17/01 3312332 STEEL R S T AMERINTL GA AMERICAN IN TTZX 84391 6/04/02 2421184 LUMBER R S F ATLFORPRO XXX ATLANTIC FO CN 624288 7/30/00 2421184 LUMBER R S F BETH XXX BETHLEHEM CSXT 495034 10/18/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 495034 9/18/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 495669 8/02/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 495923 9/22/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 496011 10/07/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 496602 8/30/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 496722 9/18/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 496812 8/02/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 497667 9/08/02 3312332 STEEL F S E BETH XXX BETHLEHEM CSXT 497857 7/26/02 3312332 STEEL F S E More... 1=Select I=Unapplied Revenue W=Loaded Waybill E=Empty Waybill F3=Exit

Figure 8


Supertrip RecordsViewing an Individual Supertrip Record

Viewing an Individual Supertrip Record

To view an individual Supertrip record:1. Choose option 11 Customer Service Menu from the TMS Main Menu.

2. Choose either option 1, 2, or 3 from the Customer Service menu.

3. Type 1 by the record you want to view and press Enter.

NOTE: To move quickly to a particular car, type the initial and number at the top of the list screen and press Enter. If you want to look at records for a particular customer, type the customer code at the top of the screen and press Enter.

The Supertrip parent record consists of three screens. You can move between these screens using the PgDn and PgUp keys. The top portion of the first two screens contains a banner box that shows the most important movement information about the trip. The center portion of each screen shows detail information about the trip. You can also use the function keys at the bottom of each screen to review additional information about the trip. In addition, the Edit Demurrage/Storage screen (option F14=Dem/Stor from the third parent screen) contains basic demurrage and storage charge information for the trip.

The Banner BoxWhen you take any option to review a Supertrip record, the first screen that appears is the Supertrip Parent Record screen. The fields in the screens Banner Box show the key events for the trip (Figure 9).

RSACE3R GNRR Supertrip Parent Record QPADEV0024 Car: GATX 53392 Trip Complete: Y YES Overall Trip Complete: ----------------------------------------------------------------------------- | Move L/E -Date- Time Station Road/Track | Revenue Date: 70106 | | Beg ICHR L 70106 1245 4766 CSXT | Traffic Date: 70106 | | PACT L 70506 945 4766 NORC | Interchange Date: 70106 | | RMTY E 70706 600 4766 NORC | Traffic Type: R Received | | End ICHD E 70706 1431 4766 CSXT | Revenue Type: S SWITCH | | | The Customer: KEMIRA ELI | -----------------------------------------------------------------------------

Figure 9


Supertrip Records Viewing an Individual Supertrip Record

Field Definitions

In the left-hand side of the banner at the top of the screen, Supertrip displays the four most important moves (by type) that occurred during the trip. In addition, the event date and time, L/ E status, station, road, and track are shown for each move.

Car Railcar, trailer, or container initial and number.Trip Complete If Supertrip determines the trip is complete, this field shows

YES. A delivery off-line or a final placement on a local move will complete a trip. If the trip has not been completed, this field shows NO.

Overall Trip Complete

When a car returns back to your operation from an off-line trip, Supertrip will calculate the time the car spent off your railroad. This is particularly useful in measuring turn times for cars assigned to or owned by your operation. If this field shows YES, Supertrip has determined that the car returned to your railroad after this online trip was completed.

Begin Movement

Represents the movement with which Supertrip determined the trip began. For most railcar trips, this is the received interchange. For local moves, it is usually when the car was originally placed for loading. For trailers/containers, it is usually the in-gate movement. The Move column will tell you the type of record that began this trip.

Placed/Released Movement

For railcars, Supertrip will display the placement (PACT) and release (RLS) information in the second and third lines. For trailers and containers it shows ramp/deramp information. The Move column will tell you the type of record used.

End Movement Represents the movement with which Supertrip has determined the trip ended. For most railcar trips, this is the delivered interchange. For local moves, it is usually when the car was placed for final unloading. For trailers/containers, this may be the out-gate movement. The Move column will tell you the type of record that ended this trip. The last line will show the PCON move information if the car was constructively placed.

RCPL Date and time the car was released from constructive placement. This field will only appear if the car has been released from constructive placement.



The right-hand side of the banner at the top of the first and second screen displays additional critical information about the trip:

Revenue Date This field indicates the date on which the primary revenue for the move is realized. For interline moves, the Revenue Date is seeded into Supertrip when RMS records are applied to Supertrip. When interline estimated or actual revenue is applied in Trial Balance, Supertrip will use the Revenue Date generated by RMS. Until RMS actual or estimated revenue is first recorded in Supertrip, TMS uses events in the trip cycle to construct the Revenue Date. In this case, Supertrip uses the loaded delivery date on a forwarded trip if the RMS Revenue Date is not available. If neither the RMS Revenue Date nor the loaded delivery date on a forwarded trip are available, Supertrip uses the date of the first loaded move as the Revenue Date.

CAUTION: Until the trip is completed, the Revenue Date is subject to change as Supertrip receives additional information about a trip or its RMS revenue. As a result, you may get a different number of cars if you run this report from one day to the next. This is usually the result of information coming in from RMS as cars are rated.

Traffic Date This date signifies the first loaded move on all trips. Empty moves use the trip begin date. As with Revenue Date, the Traffic Date is subject to change until the trip is complete.

NOTE: Switching or junction settlement roads should not run reports by traffic date because most of these roads recognize revenue when forwarded cars are moved offline. The Traffic Date is set when the cars are released loaded.

Interchange Date

This date represents the loaded interchange date. For bridge moves, Supertrip uses the Trip Begin Date (Inbound Interchange) to populate this field.

NOTE: Switching, handling line, or junction settlement roads will usually run Supertrip reports based on either the Interchange Date or the Revenue Date.



Traffic Type Traffic type. The following are valid values:F Forward (originated)B Bridge (overhead)R ReceivedL LocalE Received and delivered empty at same stationO LocomotiveU Unidentified -- Supertrip cannot determine the

traffic type due to poor waybill or car movement information.

NOTE: Normally Supertrip assigns traffic type based on the waybill route. Switching and handling line railroads are often not included in the route on the waybill, so TMS cannot accurately identify traffic type. A switch is available in the Client Master to instruct Supertrip to determine traffic type based on car moves. RMI highly recommends that switching carriers set this switch to Y. Traffic Type can also be derived from an indicator in the RWC.

Revenue Type Primary type of revenue associated with the trip. The following are valid values:

I Interline -- Indicates the move has revenue in the Our Proportion field and was settled in ISS.

L Local waybill for on-line service.S Switch If the waybill has the Switch/Haulage flag

set to S, this field will be S.H Haulage If the waybill has the Switch/Haulage

flag set to H, this field will be H.N Non-revenue No switching, miscellaneous billing

or interline revenue is associated with the trip.O Omit from reporting Record was manually

flagged to be omitted from all reporting.

The Customer Customer assigned to the move for traffic reporting purposes. This field can be populated directly by Supertrip, or forced in by the user by using an RWC or by directly entering the field on the waybill.



How Supertrip Assigns The Customer When a trip is being constructed in Supertrip, TMS attempts to automatically determine who is the most important customer on a move using the following criteria:1. If The Customer field in the waybill is populated (usually through the application of

an RWC or manually entry by the user), Supertrip will use this field.

2. If The Customer is not completed in the waybill, Supertrip will look at the waybill customer fields listed below to determine The Customer:

NOTE: For received and bridge traffic, the customer codes must have been assigned using the Synonym Table (or manually updated by the user). Failure to keep the synonym table updated will result in no customer codes being assigned to the waybill.

3. If the first two steps fail to determine The Customer, Supertrip looks to the customer at which the car was placed.

4. The last step Supertrip takes is to look to the Block To field on the loaded waybill and use that value.

If the steps above have not determined who The Customer is, Supertrip will enter the value UNKNOWN CUS in the Supertrip record.

NOTE: RMI suggests writing and regularly running a report that lists all trips for which The Customer is equal to the code UNKNOWN CUS. You can then work the synonym table to fill in the missing synonym matches. Four base reports are provided in TMS to identify unknown customers.

NOTE: If you are using the flag in the Customer Master to use moves to determine The Customer, The Customer could change during the course of the trip. This occurs as Supertrip receives additional car movements and alters the traffic type based on placement records or deliveries off-line.

Traffic Type Supertrip Uses

Received Traffic Consignee or Care of Party

Forwarded Traffic Shipper

Bridge Traffic Shipper

Local Traffic Shipper



First Screen Data Fields: Waybill InformationThe remaining fields on the Supertrip Parent Record screen display the most important waybill fields for the trip (Figure 10).

Field Descriptions

RSACE3R GNRR Supertrip Parent Record QPADEV0024 Car: GATX 53392 Trip Complete: Y YES Overall Trip Complete: ----------------------------------------------------------------------------- | Move L/E -Date- Time Station Road/Track | Revenue Date: 70106 | | Beg ICHR L 70106 1245 4766 CSXT | Traffic Date: 70106 | | PACT L 70506 945 4766 NORC | Interchange Date: 70106 | | RMTY E 70706 600 4766 NORC | Traffic Type: R Received | | End ICHD E 70706 1431 4766 CSXT | Revenue Type: S SWITCH | | | The Customer: KEMIRA ELI | ----------------------------------------------------------------------------- Origin: Road CSXT Stn LIMA OH FSAC 74046 Dest: Road GNRR Stn ELIZABETH GA FSAC 62322 Shipper BASF BASFLIMA OH Consignee KEMIRA CHEMICALS KEMIRA ELI Freight Bill BASF CORP UNKNOWN FRT In Care Of The Customer KEMIRA CHEMICALS STCC 2899895 CHELATING Product Group: Priority: RWC: KEMLIMA Block To: KEMIRA ELI WB Nbr/Date: 989381 62606 PP/CC PP A/S S Kind T AAR T105 Multi Plan Route: CSXT ELZBG GNRR F2=Stations F5=Customers F6=Charges F7=Loaded WB F19=Empty WB F8=Moves

Figure 10

Origin: Road/Stn/ FSAC

Originating road, station, and FSAC.

Dest: Road/Stn/ FSAC

Destination road, station, and FSAC.

Shipper Shipper name and code for the move. If TMS cannot find a Shipper Code in the waybill, it will assign the code UNKNOWN SHP to this field.

Consignee Consignee name and code for the move. If TMS cannot find a Consignee Code in the waybill, it will assign the code UNKNOWN CON to this field.

Freight Bill Freight bill party name and code. If TMS cannot find a Freight Bill Party code in the waybill, it will assign the code UNKNOWN FB to the field.

In Care Of For intermodal, the name and code of the party to notify.For railcar, this is the customer to which the car is physically destined.

The Customer The customer name associated with The Customer.STCC Standard Transportation Commodity Code and description for

the commodity.

Product Group Product group name. Often used to differentiate products that have the same STCC.



Priority Priority code from the loaded movement. RWC Repetitive Waybill Code (Pattern) used to bill the move.Block to Last code assigned to the move for blocking purposes.W/B Nbr/Date Waybill number and date.PP/CC Payment method. The following are valid values:

PP PrepaidMX MixedCC Collect NR Non-revenue11 Rule 11NC No charge.

A/S Party responsible for routing the move. The following are valid values:

A Agent billing/carrier routingS Shipper billing/shipper routingR Rule 11 shipmentI Origin switching carrier.

Kind Equipment type used by your railroad to identify car types.AAR AAR car type registered in UMLER.Multi Indicates if this was a multi-car move. An L indicates the car

was a lead car in a multi-car waybill. A T indicates the car was a trailing car in a multi-car waybill.

Plan Service plan for the trailers or containers.Route Route of the move.



If you want to then

review the stations and mileposts associated with the move in greater detail

press F2.

view or modify the parent customer information and/or salesman for the move

press F5.

view details for all switch or miscellaneous charges for the trip

press F6.

view the loaded waybill used to create the Supertrip records

press F7.

view the empty waybill used to create the Supertrip records

press F19.

view all movement records for the trip press F8.



Second Screen Data Fields: Freight RevenueThe Supertrip Freight Revenue Screen summarizes interline, switching, and demurrage revenue for the trip. This information is pulled into Supertrip from the TMS or RMS systems that generated the invoices or interline settlements.Please note that Supertrip records will not always balance to financial statements. In addition, Supertrip was designed to analyze data for trips that may have spanned months. Charges are summarized in the trip record and are not kept as individual records.

To view the Supertrip Freight Revenue Screen:Press PgDn from the first screen of any individual record in Supertrip. The Supertrip Freight Revenue screen appears (Figure 11).

Field Descriptions

RSACE3R GNRR Supertrip Freight Revenue Screen QPADEV0024 Car: GATX 53392 Trip Complete: Y YES Overall Trip Complete: ----------------------------------------------------------------------------- | Move L/E -Date- Time Station Road/Track | Revenue Date: 70106 | | Beg ICHR L 70106 1245 4766 CSXT | Traffic Date: 70106 | | PACT L 70506 945 4766 NORC | Interchange Date: 70106 | | RMTY E 70706 600 4766 NORC | Traffic Type: R Received | | End ICHD E 70706 1431 4766 CSXT | Revenue Type: S SWITCH | | | The Customer: KEMIRA ELI | ----------------------------------------------------------------------------- The Customer: KEMIRA CHEMICALS Customer Traffic Group: ? The Station: 4766 Int Statn: 4766 Stn Traffic Group: ? Road: CSXTPrice Authority: C CONTRACT 82568,CSXT,CSXT Our Proportion: .00 Tot Freight: .00 Src: Switch Charges: 399.00 USD Other Charges: .00 Total Frt Rev: 399.00 USD Less Payable Charges: .00 Net Revenue: 399.00 USD Demurrage: Storage: Less Car Hire: Tot Net Revenue: 399.00 USD F2=Stations F5=Customers F6=Charges F7=Loaded WB F19=Empty WB F8=Moves

Figure 11

The Customer The customer name associated with The Customer.Customer Traffic Group

Traffic group associated with The Customer from the Customer Master. If The Customer has a online station assigned in the master, go to the Station Master for that station to find the Group Code.

The Station Station where the car was principally handled online. For received or forwarded moves, this is the station at which the car was placed (usually the station where The Customer is located). For local moves, it is the first placement or released station. For any other move it is the received interchange station.



Int Station Station at which the revenue move was interchanged. For forwarded moves, this is the station to which the car was delivered. For received moves, it is the received interchange station. For bridge moves, it is the received road. For local moves, this field is blank.

Stn Traffic Group

Traffic Group code representing the station at which the revenue was derived. For forwarded or terminating moves, this is the Traffic Group Code of the station at which the car was placed. Otherwise, it is the received station's traffic grouping code. For local moves, it is the Traffic Group of the first placement or release station.

Road Road at which the revenue move was interchanged. For forwarded moves, this is the delivered road. For received moves, it is the received road. For bridge moves, it is the received road. For local moves, this field contains the mark of the railroad running Supertrip.

Price Authority

The first field is a code that tells you if the authority is a C=Contract, T=Tariff, or P=Price Quote. The second field in this group provides the authority.

Our Proportion

Amount of interline freight due your road (from RMS). For local traffic billed in RMS, the total freight appears in this field.

Total Freight Total dollar amount of the interline freight bill for the move and currency under which the move was billed (from RMS).

Src Source from which Supertrip took Total Freight and Our Proportion. Possible values:

S Supertrip estimate (made after Supertrip determined that the interline move was not yet rated or estimated in Trial Balance)

T Actual (TB) W Waybill.

Switch Charges

Total dollar amount of the switch charges for the move. This field includes all charges billed with a Service Group of S or R.

Other Charges Total dollar amount of all charges with a Service Type of M which were billed for the move. This field includes all charges not billed as switching charges.

NOTE: Switch Charges and Other Charges are accumulated totals. Because these charges represent totals, the Supertrip parent record does not include the invoice number and/or date used for the actual invoicing process. Therefore, Supertrip reports will probably not balance to the actual switching/other charges invoicing. You should not use Supertrip to balance to financial reporting.



Total Frt Rev Accumulated total of Our Proportion, Switch Charges, and Other Charges.

Less Payable Charges

Total amount of payable charges associated with the trip, and the currency in which it is calculated.

Net Revenue Accumulated total of Other Charges, Switch Charges, and Our Proportion less Payable Charges

Demurrage Total amount of demurrage charges billed for the trip.Storage Total amount of storage charges billed for the trip.Less Car Hire Car hire paid less reclaim amount (Net Car Hire).Tot Net Revenue

Accumulated total of Other Charges, Switch Charges, Demurrage, Storage, and Our Proportion less Payable Charges and Car Hire.

If you want to then


press F2.


press F5.

view details for all switch or miscellaneous charges for the trip

press F6.

view the loaded waybill used to create the Supertrip records

press F7.

view the empty waybill used to create the Supertrip records

press F19.

view all movement records for the trip press F8.



Third Data Fields Screen: Fleet InformationIf the car was assigned to an online pool and set up in the System Fleet Master, that information is carried on the Supertrip Fleet screen. This allows you to write reports on the performance of a specific pool of cars.

To view the Supertrip Fleet screen:Press PgDn from the second Supertrip Freight Revenue screen. The Supertrip Fleet screen appears (Figure 12). Note that the banner at the top is altered slightly on this screen and provides a quick view of the length of time between trips for the move.

Banner Field Definitions

RSACE3R GNRR Supertrip Fleet QPADEV0024 Car: GATX 53392 Trip Complete: Y YES Overall Trip Complete: ----------------------------------------------------------------------------- | Move L/E -Date- Time Station Road/Track | Trip Time | Bad Order/Storage | Beg ICHR L 70106 1245 4766 CSXT | | | PACT L 70506 945 4766 NORC | 93 | B/O Ind: | RMTY E 70706 600 4766 NORC | 45 | B/O Hrs: | End ICHD E 70706 1431 4766 CSXT | 9 | Stg Ind: | | | Stg Hrs: ----------------------------------------------------------------------------- Fleet Information: Fleet: Owner Cde: P Private Lease Cost/Trip: Lessor: Lease Type: Monthly Lease Rate: Estimated Offline Rate: Offline Earnings: Hourly Rate: Mileage Rate: .7250 Conveying Flatcar: T Code Loaded: T Code Empty: Hitch Count: EDI Type: RR Total Weight on Rail: 263 Length: 5104 Pool Number: 0000000 Weight Gross: 250100 Net: 180800 Scaled: Bill of Lading: 2093023736 Haulage Road: F2=Statns F4=Car Hire F5=Customers F14=Dem/Stg F10=Refresh F20=Delete F21=ADMN

Figure 12

Trip Time Elapsed time between the current and previous movement event, measured in hours.

B/O Ind Flag that shows whether the car was in bad order during the trip. The following values are possible: L Car was in bad order while loadedE Car was in bad order while emptyB Car was in bad order while both empty and loadedblank Car was not in bad order.

B/O Hrs Number of hours the car has been in bad order during the trip.STG Ind Flag that shows whether the car was in storage during the

trip. The following values are possible: L Car was in storage while loadedE Car was in storeage while emptyB Car was in storeage while both empty and loadedblank Car was not in storage.

Stg Hrs Number of hours the car has been in storage during the trip.



Field Definitions

Fleet Name First ten positions of the fleet name for this car as assigned to it in the Fleet Master.

Owner Code Indicates whether the car is in one of the following categories: C System Private F Foreign P Private S System

Lease Cost per Trip

Cost of leasing a car for the trip. Derived by using the monthly lease rate as maintained in the fleet master and calculating the total time of the trip, both on-line and off-line.

Lessor Company from which your railroad is leasing the car as set up in the Fleet Master.

Lease Type Type of lease as set up in the Fleet Master.Monthly Lease Rate

Dollar amount your railroad pays to lease the car as set up in the Fleet Master.

Estimated Offline Rate

Estimated hourly rate per diem cars owned or leased by your railroad earn while off-line. Populated from the Fleet Master, this field provides a means of estimating car earnings for offline trips.

Offline Earnings

Estimated earnings for cars owned or leased by your railroad while offline. Value is derived by multiplying off-line hours for a trip by the estimated off-line rate.

Hourly Rate Hourly car hire rate for the car. This rate represents either the CHARM negotiated rate or the default rate.

Mileage Rate Loaded mileage rate for the car.Conveying Flatcar

For trailers and containers, this is the flatcar that last carried the unit.

T Code Loaded

Transportation Code for car during loaded waybill cycle.

T Code Empty Transportation Code for car during empty waybill cycle.Hitch Count Number of available hitches for an intermodal flatcar.EDI Type Equipment car type description transmitted in EDI.Total Weight on Rail

Three-position numeric representing the total allowable weight of the car taken from the EIF.

Length Three position numeric value representing the outside length over drawbar of the car. This value is rounded up in feet.

Pool Number Seven position AAR Pool Assignment Code.



Gross Weight Waybill gross weight.Net Weight Net weight of the product being transported.Scaled Weight Latest scaled weight from the loaded waybill.Bill of Lading Bill of lading from the cars loaded waybillHaulage Road If your road handled the move in haulage service, this field

shows the road you performed the service for.

If you want to then


press F2.

view car hire details associated with this trip press F4.


press F5.

review basic information about demurrage and storage charges accumulated by the equipment during the trip

press F14.

refresh the Supertrip record press F10.

delete the record press F20.NOTE: You can only delete manually entered records using this option.

review information about how TMS constructed the Supertrip record

NOTE: This option is useful when working with RMI Customer Support in diagnosing problems.

press F21.



Demurrage/Storage Detail Information ScreenThe Edit Demurrage/Storage screen shows basic information about demurrage and storage charges accumulated by the equipment during the trip.

To view the demurrage/storage information:Press F14=Dem/Stg from the third Supertrip record screen, Supertrip Fleet. The Edit Demurrage/Storage screen appears (Figure 14).

Field Descriptions

RSE6E1R GNRR Edit Demurrage/Storage QPADEV0024 Car: GATX 53392 Trip Complete: Y ------------------------------------------------------------------------------Demurrage: Type: Code: Amount: Bill To: Average: Credits: Debits: Non-Canc Debits: Storage: Code: Amount: Bill To: Storage Hours: Load/Empty Store Flag: Hrs: Online: 147 Offline: Total Online/Offline: PCON/PACT to RLS: 45 Storage Hours: Railroad Control: 102 WB Date to Inbnd: 121 Railroad Control Under Revenue: 93 Bad Order Hours: Ind: Railroad Control less Bad Order: 102 PFPS Date/Time: RLS to PFPS: 9 PFPS to Trip End: Miles: Loaded: Empty: Hump Count: Train Loaded: Train Empty: Times Weighed Loaded: Times Weighed Empty: F3=Exit

Figure 13

Demurrage: Type/ Code/Amount

Indicates the type of demurrage plan in place, along with the demurrage code and amount.

Demurrage Bill To

Main party to which demurrage was billed for the trip. This value is taken from the Customer field in the demurrage/storage file.

Average: Credits/ Debits/Non-Canc Debits

Credits, debits, and non-cancellable debits from average demurrage.

Storage Code Charge code used to invoice storage. If more than one storage charge codes exists for a cycle, the first will be used.

Storage Amount

Total amount of storage charges billed for the trip.

Storage Bill To Main party to which storage was billed for the trip. If more than one storage parties exist in the cycle, the first will be used.

Storage Hours Number of hours car was in storage during trip.



Load/Empty Store Flag

E appears if the car was in storage during the empty cycle; L appears if in storage during the loaded cycle.

Hours Online Total time the car spent online for the trip. Hours Offline Total time the car spent offline for the trip. This field is only

populated if the car has returned to your railroad in a trip subsequent to the one you are viewing. When this occurs, the Overall Trip Complete flag is set to Y and the Hours Overall time is calculated. This provides a way to determine the entire time that elapses from when system-owned or leased cars move from the origin point on your line until they return back to your line from an offline trip.

Hours Online/Offline

Total time the car spent on the trip, both online and offline.

PCON/PACT to RLS

Total number of hours the car was at the customers facility or in the customers account. This calculation is performed by taking the difference between the earlier of either the PCON or PACT move and the time the car was released.

Railroad Control

Total number of hours the car was online less the time it was in the customer's facility less storage hours.

WB Date to Inbound

For received moves, this value is the number of hours between when the car was waybilled and when it was interchanged online. This calculation is useful for measuring the time it takes for a car to be delivered to your road from the time it was billed offline.

Railroad Control under Revenue

Total number of hours the car was under railroad control while moving the revenue load.

Bad Order Hours

Total number of hours the car was in bad order status. This calculation is performed by taking the difference between the time the into bad order movement (BLGT or BHVY) was recorded and the time the out of bad order movement (BFRM) was recorded.

Bad Order Ind E appears if the car was in bad order during the empty cycle; L appears if in bad order status during the loaded cycle.

Railroad Control Less Bad Order

Total number of hours the car was online less the time in the customer's facility less storage hours and bad order.

PFPS Date/Time

Date and time the car was pulled.

RLS to PFPS Number of hours the car was at the customer facility from the time it was released until it was pulled.



PFPS to Trip End

Number of hours from when the car was pulled until it either moved offline or was placed at the next facility.

Miles Loaded Total on-line loaded miles for the trip. Mileage is calculated by movements entered in TMS. For TMS to properly calculate mileage, you must set up your stations in the Mileage Table. See the Chapter 2, Master Files, in the TMS Users Manual for instructions on updating this table.

Miles Empty Total on-line empty miles the car spent online for the trip. Hump Count Total number of times the car was humped in the trip, as

identified by the move type HUMP within car movement history.

Times Weighed Loaded

Number of times the car was weighed loaded during the trip.

Times Weighed Empty

Number of times the car was weighed empty during the trip.



Car Hire Detail Information ScreenAs trips are completed in TMS, Supertrip estimates the railroads car hire obligation. This enables the user to obtain an estimate of the car hire cost for a particular movement. When the actual car hire is calculated (usually several weeks after the trip completes), the estimated amount is replaced by the amount actually reported to the industry.The car hire estimate is calculated based on the following assumptions:

If a car hire hourly rate is present, that rate is multiplied by the hours on-line to provide the hourly car hire amount.

If a car has a loaded mileage rate, that rate is multiplied by the loaded mileage rate to obtain the loaded mileage amount. (Supertrip does not estimate empty mileage).

If a car is subject to a Rule 22 reclaim, RMI will estimate the reclaim by using the time between the receipt and placement.

If a car is subject to a Rule 5 reclaim, RMI will estimate the reclaim at 120 hours (TOL maximum).

You should keep in mind that if Supertrip shows the car hire as estimated, the actual car hire amounts to be paid can vary greatly depending on factors such as LCS transmissions, special reclaims, and special car hire arrangements.

To view car hire information:Press F4 from the Supertrip Fleet screen. The Display Supertrip Car Hire Records screen appears (Figure 14).

RSFWDFR GNRR Display Supertrip Car Hire Records QPADEV0017 Car: CSXT 254125 Trip Complete: Y Car Hire Flag: A Actual Owner: CSXT ------------------------------------------------------------------------------ Car Hire: Hours 99 $ 24.75 Car Hire Exception Flag: 24.75 Miles Loaded $ Empty $ Reclaim: Hours $ Miles $ Code Net Car Hire: $ 24.75 Allowed Acct PD Service Hours Miles Reclaim Reclaim ? Date Cd Cd Date Amount Amount Hrs Amount Mls Amount L/E 10/2006 01 31 10/2006 19.00 .00 .00 .00 L 10/2006 01 31 10/2006 5.75 .00 .00 .00 E Bottom 1=Select F3=Exit F9=Add

Figure 14



Field Descriptions

Car Hire Flag Show status of information. The following are valid options:E EstimatedA Actual.

Owner Reporting mark of the car owner. For example, cars marked SOU are owned by NS.

Car Hire Hours/$

Total car hire hours paid for trip and car hire hourly amount for trip.

Car Hire Exception Flag

Car hire flag carried in the waybill. The following are valid values:

H HaulageN Suppress car hireU Pay up to rate

Miles Loaded/ $

Car hire loaded miles and amount paid for loaded miles.

Miles Empty/$ Car hire empty miles and amount paid for empty miles.Reclaim: Hours/$

Car hire hours recovered under reclaim and amount.

Reclaim: Miles/$

Car hire miles recovered under reclaim and amount.

Reclaim Code Code in the waybill that indicates reclaim type.Net Car Hire Car hire paid less reclaim amount.

NOTE: The actual car hire figures in Supertrip may not always exactly match the miles and time Supertrip calculated for the trip. Factors such as voluntary adjustments and car hire relief may result in differences between car hire hours and mileage and operational time and mileage. In particular, cars that go through multiple load/empty cycle changes while online may have different car hire time/mileage and operational time/mileage.

The following column fields show the detail records summarized in the preceding fields. These detail records show only complete for actual car hire data. They do not include estimates.

Allowed Date Month car hire was paid.Acct Cd Describes car hire payment.PD Cd Payment code.Service Date Date the equipment earned car hire (usually the month and

year the car was in inventory on your road).



Hours Amount Car hire hours for trip.Miles Amount Miles for trip.Reclaim Hrs Amount

Hours allowed for reclaim.

Reclaim Mls Amount

Amount allowed for mileage reclaim.

L/E Loaded (L) or empty (E) status of car for the trip cycle.

If you want to then

select a record to work with in greater detail

type 1 next to the record and press Enter.

add a new Car Hire detail record press F9.

exit the screen press F3.



Station Information ScreenYou can review information about the stations and mileposts associated with a trip on the Station Information screen.

To view station information:Press F2 from any Supertrip data screen. The Edit Station Information screen appears (Figure 15).

Each movement that makes up the trip is listed, along with its associated Date, Time, Station, and Milepost. The screen also shows whether the car was empty or loaded at the time of the move. You can add or edit the value in the Traffic Group field.

RSBZE1R GNRR Edit Station Information QPADEV001W Car: GATX 53392 Trip Complete: Y YES Move L/E --Date-- Time Station Milepost Traffic Group Beg ICHR L 7/01/06 12:45 4766 4766 ? PACT L 7/05/06 9:45 4766 4766 ? RMTY E 7/07/06 6:00 4766 4766 ? End ICHD E 7/07/06 14:31 4766 4766 ? F3=Exit

Figure 15



Customer Information ScreenYou can review or modify information about the parent customer on the customer information screen.

To view customer information:Press F5 from any Supertrip data screen. The Edit Patron Information screen appears (Figure 16).

The screen lists the values for the various customer types: The Customer, Consignee, Shipper, Freight Bill Party, In Care Of Party, and Notify Party. If the information is available in TMS, the screen also lists the parent customer and the account representative for each.

RSB1E1R GNRR Edit Patron Information QPADEV001W Car: GATX 53392 Trip Complete: Y YES Code Parent Account Representative The Customer: KEMIRA ELI ________ ___ ___________________ Consignee: KEMIRA ELI ________ ___ ___________________ Shipper: BASFLIMA OH ________ ___ ___________________ Freight Bill Party: UNKNOWN FRT ________ ___ In Care Of Party: Notify Party: F3=Exit

Figure 16



Charge Information ScreenYou can review all switch and miscellaneous charges associated with the trip on the charge information screen.

To view customer information:Press F6 from either of the first two Supertrip data screens. The Display Supertrip Charges screen appears (Figure 17).

The screen lists the details for each charge associated with the trip, including the Service Type, which indicates the type of charge and Service Group, which indicates whether the charge is switching (S) or miscellaneous (M).

RSEMDFR GNRR Display Supertrip Charges QPADEV001W Car: GATX 53392 ---Charge---- Charge Service Ccy Date Time Code Typ Grp Amount Road Customer Station Cde LE 7/01/06 1245 CSXT82568 J S 399.00 CSXT 4766 USD L Bottom F3=Exit

Figure 17


Supertrip Report

tms supertrip guide - railcar management llc -...

Documents