Differences

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

--- cookbook:billing [2017/08/03 01:13] – [The Extract Module] Gerard Nicol
+++ cookbook:billing [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 11: / Line 11: @@
 ===== The Extract Module =====
-The purpose of the Billing Extract module [[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] is to read through the TapeTrack history tables and create billing extract files that match the date range specified when the program is called.
+The purpose of the Billing Extract module [[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] is to read through the TapeTrack history tables and create billing extract files within the date range specified when the program is called.
-At the completion of the program you will have one ttstats file for each TapeTrack customer.
+At the completion of the program you will have one .ttstats (TapeTrack Statistics) file for each TapeTrack customer.
+===== The TTSTATS File =====
+Each record of the TTSTATS file starts with a control character, which is then followed by additional data.
+The first record will always be a ''C'' type record, which indicates the TapeTrack Customer the file has been created for.
+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)
+<code>
+C1009
+ILT  20170701000870000000
+SLT  100920170701000225000000
+HLT  100920170701000000000000
+SLT  FBTW20170701000015000000
+HLT  FBTW20170701000000000000
+MLT  OFFSLIBR20170702000002000003
+</code>
+===== The Billing Calculation Module =====
+The Billing Calculation Module [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]
+==== See Also ====
+[[cookbook:billing_process|Cookbook: The Billing Process]]
+<- ^ :cookbook:introduction|Cookbook ^ ->
+{{tag> cookbook billing}}