TapeTrack Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Customer TTSTATS File ======

A Customer TTSTATS file, normally named using the TapeTrack [[object:customer|Customer-ID]], contains the statistics extracted from the TapeTrack Journal for a selected billing period.

Example filename:

  US01.ttstats

The file is created by [[cli:tmss10logstatsextractdb|TMSS10LogStatsExtractDB]] and processed by [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]].

The TTSTATS file provides the operational quantities used to calculate billing items, including storage and movement activity.  It does not contain the complete billing configuration. Customer descriptions, package assignments, rates, rounding and other calculations are supplied separately by the Customer Description Map, Package Map and Billing Rules.

===== Purpose =====

The Customer TTSTATS file transfers customer activity from the TapeTrack Journal into the billing calculation process.  Each Customer-ID has its own ttstats file, containing statistics for all activity within the set date range. 




===== File Creation =====

The Customer TTSTATS file is created by [[cli:TMSS10LogStatsExtractDB]].  This utility reads the TapeTrack Journal database and creates an extract file for each Customer containing activity within the selected date range.

For example, an extraction containing the following Customers may create:

^ Customer-ID ^ TTSTATS File ^
| ''US01'' | ''US01.ttstats'' |
| ''US02'' | ''US02.ttstats'' |
| ''US03'' | ''US03.ttstats'' |


TTSTATS files should be generated from the Journal for the correct billing period. Reusing a file from another period may result in missing, duplicated or incorrect charges.


===== File Location =====

TTSTATS files can be stored in any directory accessible to the account running the billing process.  For ease of administration, it is recommended that each billing period has a separate input directory.

Example Windows location:

  C:\Program Files\TapeTrack\TapeTrack Framework Server\var\billing\2026-07\US01.ttstats

Example Linux location:

  /var/tapetrack/billing/2026-07/US01.ttstats

A billing directory may be arranged as:

<code>
billing
├── config
│   ├── customer_map.txt
│   ├── package_map.txt
│   ├── default.ttsdef
│   └── tapetrack.xslt
├── input
│   ├── US01.ttstats
│   └── US02.ttstats
└── output
    ├── Billing_US01.xml
    └── Billing_US02.xml
</code>

The location of the TTSTATS file is supplied to ''[[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]'' using the ''-i'' argument.



===== File Contents =====

A TTSTATS file is a TapeTrack statistics extract generated from Journal activity.

The file may contain statistical records relating to:

  * Storage quantities.
  * Onsite and offsite activity.
  * Volume movements.
  * Deliveries and collections.
  * Repository activity.
  * Other operational events recorded in the Journal.

The exact records included depend on:

  * The Customer being extracted.
  * The selected date range.
  * The Journal activity for that period.
  * The installed TapeTrack version.
  * The statistics processed by the Billing Rules.

<WRAP note>
A TTSTATS file contains activity statistics, not final invoice lines. The final descriptions, rates and totals are produced when the file is processed by ''TMSS10LogStatsProcess''.
</WRAP>




===== File Handling =====

TTSTATS files are generated processing files and should not normally be edited manually.

Manual changes can cause:

  * Activity to be omitted.
  * Quantities to be altered.
  * Charges to be duplicated.
  * Invalid statistics records.
  * A loss of traceability to the Journal.
  * Billing results that cannot be reproduced.

If the contents appear incorrect:

  - Confirm the extraction date range.
  - Review the Journal activity.
  - Correct the source data or extraction settings where appropriate.
  - Run ''TMSS10LogStatsExtractDB'' again.
  - Replace the incorrect extract with the newly generated file.
  - Reprocess the billing XML.

<WRAP important>
Do not correct a TTSTATS file by manually changing its statistics unless specifically instructed by TapeTrack Support. Regenerate the file from the authoritative Journal data whenever possible.
</WRAP>

===== Troubleshooting =====

==== TTSTATS File Is Missing ====

Check that:

  * ''TMSS10LogStatsExtractDB'' completed successfully.
  * The Customer had Journal activity during the selected date range.
  * The output directory exists.
  * The extraction account has permission to write to the output directory.
  * The expected Customer-ID was included in the extraction.
  * The file was not moved or archived after extraction.

==== TTSTATS File Is Empty ====

Confirm that:

  * The correct billing date range was selected.
  * Journal records exist for the Customer.
  * The correct Journal database was processed.
  * The Customer-ID is correct.
  * The Customer had billable activity during the period.

An empty file may be valid when the Customer had no relevant activity. It should be investigated before being excluded from billing.



==== Billing Quantities Are Incorrect ====

Check that:

  * The extraction date range is correct.
  * The Journal contains the expected activity.
  * The correct TTSTATS file was processed.
  * The Billing Rules select the intended statistics.
  * Rounding or minimum-quantity rules are being applied correctly.
  * The same TTSTATS file was not processed more than once.

The raw activity may be correct while the billed quantity differs because of a Billing Rule.

For example:

^ Actual TTSTATS Quantity ^ Billing Rule ^ Billed Quantity ^
| 11 | Round up to the next 10 | 20 |


==== Charges Are Duplicated ====

Confirm that:

  * The TTSTATS file was processed only once.
  * The billing XML was imported into QuickBooks only once.
  * The selected extraction date range does not overlap another billing period.
  * Duplicate Billing Rules are not matching the same statistics.
  * Previously processed files are moved to an archive directory.

===== Recommended Practices =====

  * Generate a new TTSTATS file for every billing period.
  * Do not manually edit generated TTSTATS files.
  * Restrict write access to authorized billing administrators.
  * Archive completed billing files as read-only records if required.

===== Security =====

A TTSTATS file does not normally contain passwords or authentication details. However, it may contain Customer activity and commercially sensitive operational statistics.

Access should therefore be restricted to:

  * TapeTrack administrators.
  * Authorized billing staff.
  * The service account running ''TMSS10LogStatsExtractDB''.
  * The service account running ''TMSS10LogStatsProcess''.

The file should not be publicly accessible or stored in an unsecured shared directory.

===== See Also =====

  * [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]
  * [[object:customer|Customer-ID]]
  * [[billing:customer_map|Customer Description Map]]
  * [[billing:package_map|Package Map]]
  * [[billing:billing_rules|Billing Rules]]
  * [[billing:stylesheet|TapeTrack XML Stylesheet]]
  * [[billing:billing_process|Billing Process]]
  * [[billing:billing_xml|Billing XML]]
  * [[billing:xmlquickbooks_mapping|XMLQuickBooks Mapping]]

{{tag>billing journal statistics ttstats customer configuration quickbooks}}