Differences

This shows you the differences between two versions of the page.

--- billing:ttstats [2026/08/18 03:33] – [File Creation] Scott Cunliffe
+++ billing:ttstats [2026/08/19 02:00] (current) – Scott Cunliffe
@@ Line 16: / Line 16: @@
-===== File Extraction =====
-[[cli:TMSS10LogStatsExtractDB]] creates an extract file for each Customer from the Journal database.  The extraction should specify the required billing date range.
-For example, an extraction containing activity for three Customers may create:
-^ Customer-ID ^ Extract File ^
-| ''US01'' | ''US01.ttstats'' |
-| ''US02'' | ''US02.ttstats'' |
-| ''US03'' | ''US03.ttstats'' |
-Each ''.ttstats'' file contains the statistics extracted for its Customer.  The resulting files are processed using [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]].
@@ Line 100: / Line 86: @@
   * The installed TapeTrack version.
   * The statistics processed by the Billing Rules.
+Record Types are:
+  * ''C'' : TapeTrack Customer-ID
+  * ''I'' : Inventory Total of Media-ID
+  * ''S'' : Storage Total - Number of Media in that Repository
+  * ''H'' : High Water Mark
+  * ''M'' : Volume Movement to the Repository ( to Repository-ID:from Repository-ID)
+<file text US01.ttstats>
+CUS01
+ILTO 20260816000446000015
+SLTO LIBR20260816000425000015
+HLTO LIBR20260816000000000015
+MLTO OFFSLIBR20260816000003000010
+SLTO OFFS20260816000018000015
+HLTO OFFS20260816000277000015
+SLTO SCRA20260816000003000015
+HLTO SCRA20260816000000000015
+MLTO LIBRSCRA20260816000000000010
+ILTO 20260817000446000016
+SLTO LIBR20260817000425000016
+HLTO LIBR20260817000000000016
+MLTO OFFSLIBR20260817000000000011
+SLTO OFFS20260817000018000016
+HLTO OFFS20260817000277000016
+SLTO SCRA20260817000003000016
+HLTO SCRA20260817000000000016
+MLTO LIBRSCRA20260817000000000011
+ILTO 00000000000446000017
+SLTO LIBR00000000007300000017
+HLTO LIBR00000000000000000017
+MLTO OFFSLIBR00000000000016000012
+SLTO OFFS00000000000236000017
+HLTO OFFS00000000000277000017
+SLTO SCRA00000000000046000017
+HLTO SCRA00000000000000000017
+MLTO LIBRSCRA00000000000001000012
+</file>
+Breakdown of record data: **ILTO 20260816000446000015**
+**I** Inventory **LTO** Media type  **20260816**  Date YYYYMMDD **000446** Inventory **000015** Inventory record count
+Breakdown of record data: **MLTO LIBRSCRA20260816000003000010**
+**M** Movement **LTO** Media type **LIBR** To repository **OFFS** From repository **** Date **000003** Movement count **000010** Movement record count
 <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''.
+A TTSTATS file contains activity statistics, not final invoice lines. The final descriptions, rates and totals are produced when the file is processed by [[cli:TMSS10LogStatsProcess]].
 </WRAP>
@@ Line 126: / Line 159: @@
   - Review the Journal activity.
   - Correct the source data or extraction settings where appropriate.
-  - Run ''TMSS10LogStatsExtractDB'' again.
+  - Run [[cli:TMSS10LogStatsExtractDB]] again.
   - Replace the incorrect extract with the newly generated file.
   - Reprocess the billing XML.
@@ Line 140: / Line 173: @@
 Check that:
-  * ''TMSS10LogStatsExtractDB'' completed successfully.
+  * [[cli:TMSS10LogStatsExtractDB]] completed successfully.
   * The Customer had Journal activity during the selected date range.
   * The output directory exists.
@@ Line 205: / Line 238: @@
   * TapeTrack administrators.
   * Authorized billing staff.
-  * The service account running ''TMSS10LogStatsExtractDB''.
+  * The service account running [[cli:TMSS10LogStatsExtractDB]].
-  * The service account running ''TMSS10LogStatsProcess''.
+  * The service account running [[cli:TMSS10LogStatsProcess]].
 The file should not be publicly accessible or stored in an unsecured shared directory.