Provides a view with fields primarily oriented to the Cycle records in RMS. However, this view links the loaded cycle with its following empty cycle to show a complete round trip. A cycle is a record created by RMS that is derived from the sighting (CLM) records that are imported in RMS. RMS derives these records so that reports based on this type of information will open in a reasonable amount of time (i.e. a few seconds to a few minutes).
List of fields
BOLDateLd
Date the load bill of lading was created (format: mm/dd/yyyy). Source: Shipping Instruction
BOLDateMty
Date the empty bill of lading was created (format: mm/dd/yyyy). Source: Shipping Instruction
BOLNumLd
Bill of lading number assigned to the load shipment by the shipper. Source: Shipping Instruction
BOLNumMty
Bill of lading number assigned to the empty shipment by the shipper. Source: Shipping Instruction
CareOfLd
Company name listed as the care of party by the shipper for the load shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
CareOfMty
Company name listed as the care of party by the shipper for the empty shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
CommodityLd
Description of the commodity carried in the railcar. Source: Shipping Instruction unless it matches an alias of a proprietary Commodity - in that case, it will display the proprietary Commodity Name.
ConsigneeLd
Company name listed as the consignee party by the shipper for the load shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
ConsigneeMty
Company name listed as the consignee party by the shipper for the empty shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
ContractNumLd
Number identifying the contract between the freight payor and the rail carrier for the load shipment. Source: Shipping Instruction
ContractNumMty
Number identifying the contract between the freight payor and the rail carrier for the empty shipment. Source: Shipping Instruction
CPVSAPLd
If a railcar is constructively placed (CP) during a load trip cycle and then subsequently actually placed (AP), this is the number of days between the two dates. Source: Calculated by RMS: APDttm minus CPDttm. Format: 00.0
CPVSAPMty
If a railcar is constructively placed (CP) during an empty trip cycle and then subsequently actually placed (AP), this is the number of days between the two dates. Source: Calculated by RMS: APDttm minus CPDttm. Format: 00.0
DailyLeaseCost
Dollars per day required to lease a particular railcar.
DestLd
City / station where the shipment terminated for the load cycle. Source: Cycle or if a match is made on a Station Alias, Station.
DestMty
City / station where the shipment terminated for the empty cycle. Source: Cycle or if a match is made on a Station Alias, Station.
DestSPLCLd
SPLC (standard point location code - a 6 digit number identifying a station) for the load destination. Source: Station.
DestSPLCMty
SPLC (standard point location code - a 6 digit number identifying a station) for the empty destination. Source: Station.
HasBillingLd
True or False indicating whether the load cycle has a shipping instruction related / attached to it. Source: RMS
HasBillingMty
True or False indicating whether the empty cycle has a shipping instruction related / attached to it. Source: RMS
IsCompleteLd
True or False indicating whether the load cycle is complete (i.e. the RlseEndDate is not blank/null). Source: RMS
IsCompleteMty
True or False indicating whether the empty cycle is complete (i.e. the RlseEndDate is not blank/null). Source: RMS
IsTransitOnTimeLd
True of False indicating wheter the load cycle transit time is less than or equal to the Standard Transit (Days) that is entered for the matching stored Origin Destination (OD) Pair record.
IsTransitOnTimeMty
True of False indicating wheter the empty cycle transit time is less than or equal to the Standard Transit (Days) that is entered for the matching stored Origin Destination (OD) Pair record.
IsValidLd
True or False indicating whether the load cycle is valid. RMS considers a cycle valid if its origin and destination matches a stored Origin Desitnation (OD) Pair record in RMS. The location where the railcar is actually placed must also match the location where it is subsequently released.
IsValidLd
True or False indicating whether the empty cycle is valid. RMS considers a cycle valid if its origin and destination matches a stored Origin Desitnation (OD) Pair record in RMS. The location where the railcar is actually placed must also match the location where it is subsequently released.
LabelLd
A one character code indicating that the load cycle has been identifyed by a user as:
B - Bad Cannot Repair
S - Special Causes
G - Good (Use is not recommended)
Source: Cycle
LabelMty
A one character code indicating that the empty cycle has been identifyed by a user as:
B - Bad Cannot Repair
S - Special Causes
G - Good (Use is not recommended)
Source: Cycle
LoadTime
The number of days it takes for the railcar to be loaded. Source: Calculated by RMS: RTCycleEndDttm minus APDttmMty (this field is not available). Format: 00.0
MileageLd
Number of miles from the load origin to the load destination. Source: OD Pair. Format: 00.0
MileageMty
Number of miles from the empty origin to the empty destination. Source: OD Pair. Format: 00.0
NetWeightLd
Weight of the lading. Source: Shipping Instruction
OriginLd
City / station where the load cycle originated. Source: Cycle or if a match is made on a Station Alias, Station
OriginMty
City / station where the empty cycle originated. Source: Cycle or if a match is made on a Station Alias, Station
OriginSPLCLd
SPLC (standard point location code - a 6 digit number identifying a station) for the load origin. Source: Station.
OriginSPLCMty
SPLC (standard point location code - a 6 digit number identifying a station) for the empty origin. Source: Station.
PoolCurrent
Railcar sub-fleet / pool that the railcar belongs to currently (Provided for backward compatibility). Source: Railcar (Railcar Pool)
PoolLd
Railcar sub-fleet / pool that the railcar belonged to at the time of the load cycle. Source: Railcar Pool
PoolMty
Railcar sub-fleet / pool that the railcar belonged to at the time of the empty cycle. Source: Railcar Pool
Railcar
Initial and Number of the equipment used for the shipment (XXXX 123456); there is always one space between the initials and number with no trailing or leading spaces or zeros. Note: This is not a good field to use for sorting. If you wish to sort by the railcar initial and number, it is recommended to use the fields RailcarInitial and RailcarNumber. Source: Cycle
RailcarInitial
Initial of the equipment used for the shipment. Source: Cycle
RailcarNumber
Number of the equipment used for the shipment. Source: Cycle
RlseDateLd
Date the railcar was released to start the load cycle. Source: Cycle. Format: mm/dd/yyyy
RlseDttmLd
Date and time the railcar was released to start the load cycle. Source: Cycle Format: mm/dd/yyyy hh:mm.
RTADttmLd
Requested date and time of arrival for load shipment. Source: Shipping Instruction. Format: mm/dd/yyyy hh:mm
RTADttmMty
Requested date and time of arrival for empty shipment. Source: Shipping Instruction. Format: mm/dd/yyyy hh:mm
RTCycle
A combination of the SegmentLd and SegmentMty. Source: Calculated by RMS: OriginLd + ' to ' + DestLd OriginMty + ' to ' + DestMty .
Format: Anywhere, NS to Somewhere, NA Somewhere, NA to Anywhere, NA
RTCycleEndDate
The date that the round trip cycle ends. This is the second loaded release date. Source: Cycle. Format: mm/dd/yyyy
RTCycleEndDttm
The date and time that the round trip cycle ends. This is the second loaded release date and time. Source: Cycle. Format: mm/dd/yyyy hh:mm
RTCycleTime
Total number of days for the entire round trip. Source: Calculated by RMS. Format: 00.0
SegmentLd
A combination of the load origin and destination. Source: Calculated by RMS: Origin + ' to ' + Destination. Format: Anywhere, NS to Somewhere, NA
SegmentMty
A combination of the empty origin and destination. Source: Calculated by RMS: Origin + ' to ' + Destination. Format: Anywhere, NS to Somewhere, NA
ShipperLd
Company name listed as the Shipper party by the shipper for the load shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
ShipperMty
Company name listed as the Shipper party by the shipper for the empty shipment. Source: Shipping Instruction or if a match is made on a Party Alias, Party
STCCDescLd
A description related to the seven digit numeric code representing 38 commodity groupings for the load shipment. Source: RMS Commodities
STCCLd
A seven digit numeric code representing 38 commodity groupings for the load shipment. Source: Shipping Instruction
TransitTimeLd
Number of days of transit time while loaded. Source: Calculated by RMS: APDttmLd (not available) minus RlseDttmLd. Format: 00.0
TransitTimeMty
Number of days of transit time while empty. Source: Calculated by RMS: APDttmMty (not available) minus RlseDttmMty (not available). Format: 00.0
UnloadTime
The number of days it takes for the railcar to be unloaded. Source: Calculated by RMS: RlseDttmMty (not available) minus APDttmLd (not available). Format: 00.0
WaybillDateLd
Date the load waybill was created. Source: Shipping Instruction
WaybillDateMty
Date the empty waybill was created. Source: Shipping Instruction
WaybillNumLd
Waybill number assigned to the load shipment by the rail carrier. Source: Shipping Instruction
WaybillNumMty
Waybill number assigned to the empty shipment by the rail carrier. Source: Shipping Instruction