Ticket report templates contain a ReportDefinition page and a ReportSheet page, that together describe the reports you can produce. CygNet provides a sample report template file TicketTemplate.xlsx for reference. It is stored in the CygNet\Services\FMS\ReportTemplates\Samples folder on your host server.
The ReportDefinition sheet includes the following parameters to describe the type of report to build.
The ReportSheet sheet includes the following sections and corresponding tokens to describe the specific format of the report to build. Valid tokens will be replaced by the values they represent. You may also include additional information you wish to see in the report.
You can enter additional (non-token) elements such as logos, labels, or text into reports. Elements that are not valid token values will be displayed as entered.
Note: This means that tokens with typographical errors, therefore not "valid" tokens, will also be displayed as entered.
Example
[DeviceType] is a valid token. If you use [Type] (not a valid token) instead of [DeviceType], the value will be displayed as "[Type]" instead of displaying the device type value desired, since [Type] is not a valid token.
|
[Type] |
The ReportDefinition uses parameters to describe the type of report for the service to build. The following parameters determine the described characteristics of your report.
Report parameters, which appear between #ReportParameters# and #End#, can be defined by the following values.
| Parameter | Description | Value |
|---|---|---|
|
ReportName |
The value defined in this cell will be used for the report name, as it will appear in drop-down menus in FMS Explorer and CygNet Explorer. See Using the Reports Control and Scheduling FMS Command Tasks in the MSS for more information. |
Enter a value to be used for the report name. Example Ticket |
|
CommandName |
The value defined in this cell will be used by the service to determine which specific report command type to execute. See FMSClient Methods in the Scripting section for more information. |
Enter a value to specify the report command name. Example TR Note: Maximum of 7 characters; letters or numbers only, no spaces. |
Worksheet parameters, which appear between #Worksheet# and #End#, can be defined by the following values.
| Parameter | Description | Value |
|---|---|---|
|
ReportType |
The value defined in this cell will be used to represent the standard FMS report type you are configuring. |
Enter a value to be used to indicate the type of the report. Example Ticket |
|
NullToken |
The value defined in this cell will be used to represent null values in your report. |
Enter a value to be used to indicate a "null value" cell in the report. Example - |
|
PageBreakAfterRecord |
The value defined in this cell will be used to specify whether or not to use page breaks in your report. If used, will force a page break after each record. |
Enter a value to indicate whether or not to insert page breaks after each record. Options are Yes or No. Default value is Yes. |
|
PageBreakAfterNode |
The value defined in this cell will be used to specify whether or not to use page breaks in your report. If used, will force a page break after each Node. |
Enter a value to indicate whether or not to insert page breaks after each Node. Options are Yes or No. Default value is Yes. |
|
The value defined in this cell will be used in your report to represent the value for the Group name or Group description fields when either of the following is true.
|
Enter a value to be used to indicate the Group name or Group description when the command was not run against a single group Node. Example [Invalid Group] |
|
|
NodeSortOrder |
The value defined in this cell will be used to specify the order in which to display Node results in the report. |
Enter one of the following options.
Default value is Name ascending. This parameter is optional. |
|
RptStDate |
Note: If you use this parameter in your report template, the RptStDate parameter will no longer appear for configuration in FMS Explorer or CygNet Explorer. See Ticket Report Definitions (FMS Explorer) or Reports: Ticket (CygNet Explorer) for more information. |
If used, enter a valid start date value for the report. RptStDate and RptEndDate must be the same configuration parameter type. Notes: The report will display data in Device time (D), although the report command parameters are configured relative to Contract time (C). The report will only include records that exist entirely within the specified date range. See Selecting Date and Time for more information. This parameter is optional. |
|
RptEndDate |
Note: If you use this parameter in your report template, the RptEndDate parameter will no longer appear for configuration in FMS Explorer or CygNet Explorer. See Ticket Report Definitions (FMS Explorer) or Reports: Ticket (CygNet Explorer) for more information. |
If used, enter a valid end date value for the report. RptStDate and RptEndDate must be the same configuration parameter type. Notes: The report will display data in Device time (D), although the report command parameters are configured relative to Contract time (C). The report will only include records that exist entirely within the specified date range. See Selecting Date and Time for more information. This parameter is optional. |
|
RptUnitSet |
Note: If you use this parameter in your report template, the RptUnitSet parameter will no longer appear for configuration in FMS Explorer or CygNet Explorer. See Ticket Report Definitions (FMS Explorer) or Reports: Ticket (CygNet Explorer) for more information. |
If used, enter a valid unit set value for the report. Valid unit set values defined in the service can be viewed through the Admin menu in FMS Explorer. See Configuring Unit Set Definitions for more information. This parameter is optional. |
The ReportSheet uses tokens to describe the format and content of the report you want to run. The following tokens will retrieve the corresponding values for display in your report.
Note: Enter report tokens carefully, as the tokens are case sensitive. Typographical errors (therefore not "valid" tokens) will be handled as "additional values" and displayed as entered; the non-token value will appear in your report instead of the actual value(s) the correctly entered token would have retrieved. See Displaying Additional (Non-Token) Values above for more information.
Ticket report headers, which appear above #EndReportHdr#, can be described by the following tokens.
| Token | Description |
|---|---|
| [BeginDateTime] | Start date, in Contract day (C), of the requested time range for the report |
| [EndDateTime] | End date, in Contract day (C), of the requested time range for the report |
| [CmdGroupName] | Name of the group Node against which the command was run, if applicable See also NoCmdGroupToken parameter. |
| [CmdGroupDesc] | Description of the group Node against which the command was run, if applicable See also NoCmdGroupToken parameter. |
| [GeneratedDateTime] | Time the report was generated, in Local time (L) |
| [TotalDeviceCount] | Total number of devices in the report |
Ticket report subreport headers, which appear between #SubSection# SubReportHeader and #End#, can be described by the following tokens.
| Token | Description |
|---|---|
| General Tokens | |
| [=] | When used as the first three characters, turns the cell into a formula |
| [RowNumber] | Row number |
| [CurrentDeviceCount] | Index of the device being displayed |
| [TotalDeviceCount] | Total number of devices in the report |
| [NodeContractHour] | Contract hour of the Node |
| [NodeDesc] | Node description |
| [NodeId] | Node ID |
| [NodeInstallDateTime] | Install date/time for the Node, in Device time (D) |
| [NodeName] | Node name |
| [NodePollingFacilityId] | Polling facility ID of the Node |
| [NodePollingFacilityTag] | Polling facility tag of the Node |
| [NodePollingSiteService] | Polling Site.Service of the Node |
| [NodeSecurityApp] | Security application of the Node |
| [NodeSortPriority] | Sort priority of the Node |
| [NodeTimezone] | Time zone configured for the Node |
| [NodeTimezoneUsingDst] | Daylight saving time status of the Node |
| [NodeType] | Node type |
| [PollingFac_Attr0] -
[PollingFac_Attr29] |
Polling facility indexed text attributes 0 through 29 (each a separate token) |
| [PollingFac_Category] | Polling facility category |
| [PollingFac_Desc] | Polling facility description |
| [PollingFac_Info0] | Polling facility info attribute 0
Default attribute name is Facility Location |
| [PollingFac_Info1] | Polling facility info attribute 1
Default attribute name is Facility Contact |
| [PollingFac_IsActive] | Polling facility active flag |
| [PollingFac_Table0] - [PollingFac_Table29] |
Polling facility indexed table attributes 0 through 29 (each a separate token) |
| [PollingFac_Type] | Polling facility type |
| [PollingFac_YesNo0] - [PollingFac_YesNo19] |
Polling facility indexed Yes/No attributes 0 through 19 (each a separate token) |
Ticket report data table parameters, which appear between #SubSection# DataTable and #End#, can be described by the following tokens.
| Token | Description |
|---|---|
| General Tokens | |
| [=] | When used as the first three characters, turns the cell into a formula |
| [RowNumber] | Row number |
| [NodeContractHour] | Contract hour of the Node |
| [NodeDesc] | Node description |
| [NodeId] | Node ID |
| [NodeInstallDateTime] | Install date/time for the Node, in Device time (D) |
| [NodeName] | Node name |
| [NodePollingFacilityId] | Polling facility ID of the Node |
| [NodePollingFacilityTag] | Polling facility tag of the Node |
| [NodePollingSiteService] | Polling Site.Service of the Node |
| [NodeSecurityApp] | Security application of the Node |
| [NodeSortPriority] | Sort priority of the Node |
| [NodeTimezone] | Time zone configured for the Node |
| [NodeTimezoneUsingDst] | Daylight saving time status of the Node |
| [NodeType] | Node type |
| [PollingFac_Attr0] - [PollingFac_Attr29] |
Polling facility indexed text attributes 0 through 29 (each a separate token) |
| [PollingFac_Category] | Polling facility category |
| [PollingFac_Desc] | Polling facility description |
| [PollingFac_Info0] | Polling facility info attribute 0 Default attribute name is Facility Location |
| [PollingFac_Info1] | Polling facility info attribute 1 Default attribute name is Facility Contact |
| [PollingFac_IsActive] | Polling facility active flag |
| [PollingFac_Table0] - [PollingFac_Table29] |
Polling facility indexed table attributes 0 through 29 (each a separate token) |
| [PollingFac_Type] | Polling facility type |
| [PollingFac_YesNo0] - [PollingFac_YesNo19] |
Polling facility indexed Yes/No attributes 0 through 19 (each a separate token) |
| Shared Ticket Tokens | |
|
Ticket |
|
| [DataSource] | Source of the data |
| [TicketTimestamp] | Ticket timestamp |
| [TicketName] | Ticket name |
| [DeviceNumber] | Device number |
| [DeviceType] | Device type |
| [TicketBeginDateTime] | Begin date/time of the ticket |
| [TicketEndDateTime] | End date/time of the ticket |
| [Origin] | Origin |
| [Destination] | Destination |
| [Transporter] | Transporter |
| [TransportMethod] | Transport method |
| [CustomerName] | Customer name |
| [IsOdorized] | Indicates if the ticket is odorized or not |
| [OdorizedDensity] | Odorized density |
| [OdorizedVolume] | Odorized volume |
| [Viscosity] | Viscosity |
| [RVP] | Reid vapor pressure |
| [VehicleId] | Vehicle ID |
| [ManifestId] | Manifest ID |
| [DriverId] | Driver ID |
| [Shipper] | Shipper |
| [FirstTrailerNumber] | Number of the first trailer |
| [SecondTrailerNumber] | Number of the second trailer |
|
Quality |
|
| [IsentropicExponent] | Isentropic exponent |
| [Methane] | Methane (C1) |
| [Ethane] | Ethane (C2) |
| [Propane] | Propane (C3) |
| [IsoButane] | IsoButane (isoC4) |
| [n-Butane] | n-Butane (C4) |
| [IsoPentane] | IsoPentane (isoC5) |
| [n-Pentane] | n-Pentane (C5) |
| [Neopentane] | Neopentane (neoC5) |
| [n-Hexane] | n-Hexane (C6) |
| [n-Heptane] | n-Heptane (C7) |
| [n-Octane] | n-Octane (C8) |
| [n-Nonane] | n-Nonane (C9) |
| [n-Decane] | n-Decane (C10) |
| [Butylenes] | Butylenes |
| [Ethylene] | Ethylene |
| [Propylene] | Propylene |
| [Nitrogen] | Nitrogen (N2) |
| [CarbonDioxide] | Carbon dioxide (CO2) |
| [HydrogenSulfide] | Hydrogen sulfide (H2S) |
|
Custom |
|
| [CustomString1] | Custom-defined FMS ticket items See FMS Ticket Items for more information. |
| [CustomString2] | |
| [CustomString3] | |
| [CustomString4] | |
| [CustomString5] | |
| [CustomString6] | |
| [CustomString7] | |
| [CustomString8] | |
| [CustomString9] | |
| [CustomFloat1] | Custom-defined FMS numerical ticket items See FMS Ticket Items for more information. |
| [CustomFloat2] | |
| [CustomFloat3] | |
| [CustomFloat4] | |
| [CustomFloat5] | |
| [CustomFloat6] | |
| [CustomFloat7] | |
| [CustomFloat8] | |
| [CustomFloat9] | |
| Metered Ticket Tokens | |
|
Meter Configuration |
|
| [MeterType] | Meter type |
| [MeterCalcMethod] | Calculation standard |
| [MeterFactor] | Meter factor |
| [MeterKFactorMass] | K factor - Mass |
| [MeterKFactorVolume] | K factor - Volume |
| [MeterCPL] | Pressure correction factor |
| [MeterCTL] | Temperature correction factor |
| [MeterCTPL] | Temperature and Pressure correction factor |
| [MeterSWCorrectionFactor] | Sediment and Water correction factor |
| [MeterCCF] | Combined correction factor |
| [MeterEVP] | Equilibrium Vapor Pressure |
| [MeterAtmosphericPressure] | Atmospheric pressure |
| [MeterPipeDiameter] | Pipe diameter |
| [MeterPipeLength] | Pipe length |
| [MeterPipeMaterial] | Pipe material |
| [MeterPipeRefTemperature] | Pipe reference temperature |
| [MeterPlateDiameter] | Plate diameter |
| [MeterPlateMaterial] | Plate material |
| [MeterPlateRefTemperature] | Plate reference temperature |
| [MeterSpTapLocation] | Static pressure tap location |
| [MeterSpType] | Static pressure type |
| [MeterTapType] | Tap type |
|
Metered Data |
|
| [MeteredDensity] | Density |
| [MeteredDensityFlowing] | Flowing density |
| [MeteredDensityPressure] | Density pressure |
| [MeteredDensityTemperature] | Density temperature |
| [MeteredDensityMeterFactor] | Density meter factor |
| [MeteredPressureCompensated] | Compensated pressure |
| [MeteredTemperatureCompensated] | Compensated temperature |
| [MeteredTotalizerDigits] | Totalizer digits |
| [MeteredUncorrectedDensity] | Uncorrected density |
| [MeteredPulses] | Pulse count |
| [MeteredPulsesBegin] | Pulse count at the beginning of the ticket |
| [MeteredPulsesEnd] | Pulse count at the end of the ticket |
| [MeteredMass] | Mass |
| [MeteredMassBegin] | Mass at the beginning of the ticket |
| [MeteredMassEnd] | Mass at the end of the ticket |
| [MeteredIV] | Indicated Volume |
| [MeteredIVBegin] | Indicated Volume at the beginning of the ticket |
| [MeteredIVEnd] | Indicated Volume at the end of the ticket |
| [MeteredGSV] | Gross Standard Volume |
| [MeteredGSVBegin] | Gross Standard Volume at the beginning of the ticket |
| [MeteredGSVEnd] | Gross Standard Volume at the end of the ticket |
| [MeteredGV] | Gross Volume |
| [MeteredGVBegin] | Gross Volume at the beginning of the ticket |
| [MeteredGVEnd] | Gross Volume at the end of the ticket |
| [MeteredNSV] | Net Standard Volume |
| [MeteredNSVBegin] | Net Standard Volume at the beginning of the ticket |
| [MeteredNSVEnd] | Net Standard Volume at the end of the ticket |
| [MeteredSWPercent] | Sediment and Water percentage |
| [MeteredSWVolume] | Sediment and Water volume |
| [MeteredSWVolume_Begin] | Sediment and Water volume at the beginning of the ticket |
| [MeteredSWVolume_End] | Sediment and Water volume at the end of the ticket |
| [MeteredTemperature] | Meter Temperature |
| [MeteredPressure] | Meter Pressure |
| Scale Ticket Tokens | |
| [ScaleGrossWeight] | Gross weight |
| [ScaleNetWeight] | Net weight |
| [ScaleTareWeight] | Tare weight |
| [ScaleInName] | Name in |
| [ScaleOutName] | Name out |
| [ScaleDensity] | Density |
| [ScaleDensityTemperature] | Density temperature |
| [ScaleGSV] | Gross standard volume |
| [ScaleNSV] | Net standard volume |
| [ScaleSWPercent] | Sediment and Water percentage |
| Tank Ticket Tokens | |
|
Tank - Configuration |
|
| [TankType] | Tank type |
| [TankIsInsulated] | Is insulated |
| [TankShellMaterial] | Shell material |
| [TankCustodyTransferMethod] | Custody transfer method |
| [TankCalcType] | Calculation standard |
| [TankLevelType] | Level type |
|
Tank - Opening |
|
| [TankOpeningLiquidLevel] | Liquid level - opening |
| [TankOpeningWaterLevel] | Water level - opening |
| [TankOpeningVesselForwardDraft] | Vessel forward draft - opening |
| [TankOpeningVesselAfterDraft] | Vessel after draft - opening |
| [TankOpeningVesselTrim] | Vessel trim - opening |
| [TankOpeningVesselList] | Vessel list - opening |
| [TankOpeningLiquidTemperature] | Liquid temperature - opening |
| [TankOpeningAmbientTemperature] | Ambient temperature - opening |
| [TankOpeningShellTemperature] | Shell temperature - opening |
| [TankOpeningShellTempCorrection] | Shell temperature correction - opening |
| [TankOpeningMass] | Mass - opening |
| [TankOpeningPressure] | Pressure - opening |
| [TankOpeningDensity] | Density - opening |
| [TankOpeningDensityPressure] | Density pressure - opening |
| [TankOpeningDensityTemperature] | Density temperature - opening |
| [TankOpeningTOV] | Total observed volume - opening |
| [TankOpeningGOV] | Gross observed volume - opening |
| [TankOpeningGSV] | Gross standard volume - opening |
| [TankOpeningLiquidTemperatureCorrection] | Liquid temperature correction - opening |
| [TankOpeningFreeWater] | Free water - opening |
| [TankOpeningSWPercent] | Sediment and Water percent - opening |
| [TankOpeningSWCorrectionFactor] | Sediment and Water correction factor - opening |
| [TankOpeningSWVolume] | Sediment and Water volume - opening |
| [TankOpeningNSV] | Net standard volume - opening |
| [TankOpeningWCF] | Weight conversion factor - opening |
| [TankOpeningNSW] | Net standard weight - opening |
|
Tank - Closing |
|
| [TankClosingLiquidLevel] | Liquid level - closing |
| [TankClosingWaterLevel] | Water level - closing |
| [TankClosingVesselForwardDraft] | Vessel forward draft - closing |
| [TankClosingVesselAfterDraft] | Vessel after draft - closing |
| [TankClosingVesselTrim] | Vessel trim - closing |
| [TankClosingVesselList] | Vessel list - closing |
| [TankClosingLiquidTemperature] | Liquid temperature - closing |
| [TankClosingAmbientTemperature] | Ambient temperature - closing |
| [TankClosingShellTemperature] | Shell temperature - closing |
| [TankClosingShellTempCorrection] | Shell temperature correction - closing |
| [TankClosingMass] | Mass - closing |
| [TankClosingPressure] | Pressure - closing |
| [TankClosingDensity] | Density - closing |
| [TankClosingDensityPressure] | Density pressure - closing |
| [TankClosingDensityTemperature] | Density temperature - closing |
| [TankClosingTOV] | Total observed volume - closing |
| [TankClosingGOV] | Gross observed volume - closing |
| [TankClosingGSV] | Gross standard volume - closing |
| [TankClosingLiquidTemperatureCorrection] | Liquid temperature correction - closing |
| [TankClosingFreeWater] | Free water - closing |
| [TankClosingSWPercent] | Sediment and Water percent - closing |
| [TankClosingSWCorrectionFactor] | Sediment and Water correction factor - closing |
| [TankClosingSWVolume] | Sediment and Water volume - closing |
| [TankClosingNSV] | Net standard volume - closing |
| [TankClosingWCF] | Weight conversion factor - closing |
| [TankClosingNSW] | Net standard weight - closing |
|
Tank - Transferred |
|
| [TankTransferredTOV] | Total observed volume - transferred |
| [TankTransferredGOV] | Gross observed volume - transferred |
| [TankTransferredGSV] | Gross standard volume - transferred |
| [TankTransferredSWPercent] | Sediment and Water percent - transferred |
| [TankTransferredSWCorrectionFactor] | Sediment and Water correction factor - transferred |
| [TankTransferredSWVolume] | Sediment and Water volume - transferred |
| [TankTransferredNSV] | Net standard volume - transferred |
| [TankTransferredWCF] | Weight conversion factor - transferred |
| [TankTransferredNSW] | Net standard weight- transferred |
| [TankTransferredMass] | Mass - transferred |
| Unit Tokens - Shared | |
| [OdorizedDensity_Units] | Units used for odorized density |
| [OdorizedVolume_Units] | Units used for odorized volume |
| [Viscosity_Units] | Units used for viscosity |
| [RVP_Units] | Units used for Reid vapor pressure |
| [Methane_Units] | Units used for Methane |
| [Ethane_Units] | Units used for Ethane |
| [Propane_Units] | Units used for Propane |
| [IsoButane_Units] | Units used for IsoButane |
| [n-Butane_Units] | Units used for n-Butane |
| [IsoPentane_Units] | Units used for IsoPentane |
| [n-Pentane_Units] | Units used for n-Pentane |
| [Neopentane_Units] | Units used for Neopentane |
| [n-Hexane_Units] | Units used for n-Hexane |
| [n-Heptane_Units] | Units used for n-Heptane |
| [n-Octane_Units] | Units used for n-Octane |
| [n-Nonane_Units] | Units used for n-Nonane |
| [n-Decane_Units] | Units used for n-Decane |
| [Butylenes_Units] | Units used for Butylenes |
| [Ethylene_Units] | Units used for Ethylene |
| [Propylene_Units] | Units used for Propylene |
| [Nitrogen_Units] | Units used for Nitrogen |
| [CarbonDioxide_Units] | Units used for Carbon dioxide |
| [HydrogenSulfide_Units] | Units used for Hydrogen sulfide |
| Unit Tokens - Metered | |
| [MeterKFactorMass_Units] | Units used for K factor - Mass |
| [MeterKFactorVolume_Units] | Units used for K factor - Volume |
| [MeterEVP_Units] | Units used for equilibrium vapor pressure |
| [MeterAtmosphericPressure_Units] | Units used for atmospheric pressure |
| [MeterPipeDiameter_Units] | Units used for pipe diameter |
| [MeterPipeRefTemperature_Units] | Units used for pipe reference temperature |
| [MeterPipeLength_Units] | Units used for pipe length |
| [MeterPlateDiameter_Units] | Units used for plate diameter |
| [MeterPlateRefTemperature_Units] | Units used for plate reference temperature |
| [MeteredDensity_Units] | Units used for Ticket density |
| [MeteredDensityFlowing_Units] | Units used for Ticket flowing density |
| [MeteredDensityPressure_Units] | Units used for Ticket density pressure |
| [MeteredDensityTemperature_Units] | Units used for Ticket density temperature |
| [MeteredUncorrectedDensity_Units] | Units used for Uncorrected density |
| [MeteredMass_Units] | Units used for Mass |
| [MeteredMassBegin_Units] | Units used for Mass at the beginning of the ticket |
| [MeteredMassEnd_Units] | Units used for Mass at the end of the ticket |
| [MeteredIV_Units] | Units used for Indicated Volume |
| [MeteredIVBegin_Units] | Units used for Indicated Volume at the beginning of the ticket |
| [MeteredIVEnd_Units] | Units used for Indicated Volume at the end of the ticket |
| [MeteredGSV_Units] | Units used for Gross Standard Volume |
| [MeteredGSVBegin_Units] | Units used for Gross Standard Volume at the beginning of the ticket |
| [MeteredGSVEnd_Units] | Units used for Gross Standard Volume at the end of the ticket |
| [MeteredGV_Units] | Units used for Gross Volume |
| [MeteredGVBegin_Units] | Units used for Gross Volume at the beginning of the ticket |
| [MeteredGVEnd_Units] | Units used for Gross Volume at the end of the ticket |
| [MeteredNSV_Units] | Units used for Net Standard Volume |
| [MeteredNSVBegin_Units] | Units used for Net Standard Volume at the beginning of the ticket |
| [MeteredNSVEnd_Units] | Units used for Net Standard Volume at the end of the ticket |
| [MeteredSWPercent_Units] | Units used for Sediment and Water percentage |
| [MeteredSWVolume_Units] | Units used for Sediment and Water volume |
| [MeteredSWVolume_Begin_Units] | Units used for Sediment and Water volume at the beginning of the ticket |
| [MeteredSWVolume_End_Units] | Units used for Sediment and Water volume at the end of the ticket |
| [MeteredTemperature_Units] | Units used for Meter temperature |
| [MeteredPressure_Units] | Units used for Meter pressure |
| Unit Tokens - Scale | |
| [ScaleGrossWeight_Units] | Units used for Gross weight |
| [ScaleNetWeight_Units] | Units used for Net weight |
| [ScaleTareWeight_Units] | Units used for Tare weight |
| [ScaleDensity_Units] | Units used for Ticket density |
| [ScaleDensityTemperature_Units] | Units used for Ticket density temperature |
| [ScaleGSV_Units] | Units used for Gross standard volume |
| [ScaleNSV_Units] | Units used for Net standard volume |
| [ScaleSWPercent_Units] | Units used for Sediment and Water percentage |
| Unit Tokens - Tank | |
| [TankOpeningLiquidLevel_Units] | Units used for Liquid level - opening |
| [TankOpeningWaterLevel_Units] | Units used for Water level - opening |
| [TankOpeningVesselForwardDraft_Units] | Units used for Vessel forward draft - opening |
| [TankOpeningVesselAfterDraft_Units] | Units used for Vessel after draft - opening |
| [TankOpeningLiquidTemperature_Units] | Units used for Liquid temperature - opening |
| [TankOpeningAmbientTemperature_Units] | Units used for Ambient temperature - opening |
| [TankOpeningShellTemperature_Units] | Units used for Shell temperature - opening |
| [TankOpeningPressure_Units] | Units used for Pressure - opening |
| [TankOpeningDensity_Units] | Units used for Density - opening |
| [TankOpeningDensityTemperature_Units] | Units used for Density temperature - opening |
| [TankOpeningDensityPressure_Units] | Units used for Density pressure - opening |
| [TankOpeningTOV_Units] | Units used for Total observed volume - opening |
| [TankOpeningGOV_Units] | Units used for Gross observed volume - opening |
| [TankOpeningGSV_Units] | Units used for Gross standard volume - opening |
| [TankOpeningFreeWater_Units] | Units used for Free water - opening |
| [TankOpeningSWPercent_Units] | Units used for Sediment and Water percent - opening |
| [TankOpeningSWVolume_Units] | Units used for Sediment and Water volume - opening |
| [TankOpeningNSV_Units] | Units used for Net standard volume - opening |
| [TankOpeningNSW_Units] | Units used for Net standard weight - opening |
| [TankOpeningShellTempCorrection_Units] | Units used for Shell temperature correction - opening |
| [TankOpeningMass_Units] | Units used for Mass - opening |
| [TankClosingLiquidLevel_Units] | Units used for Liquid level - closing |
| [TankClosingWaterLevel_Units] | Units used for Water level - closing |
| [TankClosingVesselForwardDraft_Units] | Units used for Vessel forward draft - closing |
| [TankClosingVesselAfterDraft_Units] | Units used for Vessel after draft - closing |
| [TankClosingLiquidTemperature_Units] | Units used for Liquid temperature - closing |
| [TankClosingAmbientTemperature_Units] | Units used for Ambient temperature - closing |
| [TankClosingShellTemperature_Units] | Units used for Shell temperature - closing |
| [TankClosingPressure_Units] | Units used for Pressure - closing |
| [TankClosingDensity_Units] | Units used for Density - closing |
| [TankClosingDensityTemperature_Units] | Units used for Density temperature - closing |
| [TankClosingDensityPressure_Units] | Units used for Density pressure - closing |
| [TankClosingTOV_Units] | Units used for Total observed volume - closing |
| [TankClosingGOV_Units] | Units used for Gross observed volume - closing |
| [TankClosingGSV_Units] | Units used for Gross standard volume - closing |
| [TankClosingFreeWater_Units] | Units used for Free water - closing |
| [TankClosingSWPercent_Units] | Units used for Sediment and Water percent - closing |
| [TankClosingSWVolume_Units] | Units used for Sediment and Water volume - closing |
| [TankClosingNSV_Units] | Units used for Net standard volume - closing |
| [TankClosingNSW_Units] | Units used for Net standard weight - closing |
| [TankClosingMass_Units] | Units used for Mass - closing |
| [TankTransferredTOV_Units] | Units used for Total observed volume - transferred |
| [TankTransferredGOV_Units] | Units used for Gross observed volume - transferred |
| [TankTransferredGSV_Units] | Units used for Gross standard volume - transferred |
| [TankTransferredSWPercent_Units] | Units used for Sediment and Water percent - transferred |
| [TankTransferredSWVolume_Units] | Units used for Sediment and Water volume - transferred |
| [TankTransferredNSV_Units] | Units used for Net standard volume - transferred |
| [TankTransferredNSW_Units] | Units used for Net standard weight- transferred |
| [TankTransferredMass_Units] | Units used for Mass - transferred |
Ticket report subreport footers, which appear between #SubSection# SubReportFooter and #End#, can be described by the following tokens.
| Token | Description |
|---|---|
| [=] | When used as the first three characters, turns the cell into a formula |
| [RowNumber] | The current row number |
| [CurrentDeviceCount] | The index of the device being displayed |
| [TotalDeviceCount] | The total number of devices in the report |
| [NodeContractHour] | The contract hour of the Node |
| [NodeDesc] | The Node description |
| [NodeId] | The Node ID |
| [NodeInstallDateTime] | The install date/time for the Node, in Device time (D) |
| [NodeName] | The Node name |
| [NodePollingFacilityId] | The polling facility ID of the Node |
| [NodePollingFacilityTag] | The polling facility tag of the Node |
| [NodePollingSiteService] | The polling Site.Service of the Node |
| [NodeSecurityApp] | The security application of the Node |
| [NodeSortPriority] | The sort priority of the Node |
| [NodeTimezone] | The time zone configured for the Node |
| [NodeTimezoneUsingDst] | The daylight saving time status of the Node |
| [NodeType] | The Node type |
| [PollingFac_Attr0] - [PollingFac_Attr29] |
The polling facility indexed text attributes 0 through 29 (each a separate token) |
| [PollingFac_Category] | The polling facility category |
| [PollingFac_Desc] | The polling facility description |
| [PollingFac_Info0] | The polling facility info attribute 0 Default attribute name is Facility Location |
| [PollingFac_Info1] | The polling facility info attribute 1 Default attribute name is Facility Contact |
| [PollingFac_IsActive] | The polling facility active flag |
| [PollingFac_Table0] - [PollingFac_Table29] |
The polling facility indexed table attributes 0 through 29 (each a separate token) |
| [PollingFac_Type] | The polling facility type |
| [PollingFac_YesNo0] - [PollingFac_YesNo19] |
The polling facility indexed Yes/No attributes 0 through 19 (each a separate token) |
Ticket report footers, which appear between #SubSection# ReportFooter and #End#, can be described by the text you enter. Type the desired text into the cell, and format it as desired.
|
|
|
