TapeTrack has a powerful billing and charge-back engine.

The engine is comprised of:

1. A billing extract module.
2. A billing calculation module.
3. Third-party interfaces such as the TapeTrack Quickbooks Interface.

The purpose of the Billing Extract module TMSS10LogStatsExtractDB is to read through the TapeTrack history tables and create a billing extract file for each of the TapeTrack Customers that correspond to the requested date range.

C:\Windows\system32>TMSS10LogStatsExtractDB -R "M-1:m-1" -h "C:\Program Files\TapeTrack\TapeTrack Framework\Server\var\db" -o "c:\tmss\billing"
ZBT001N-19:06:40 TMSS10LogStatsExtractDB (c) GazillaByte 1998-2017
ZBT002N-19:06:40 Compiled Jun  5 2017 at 10:55:19
ZBT010I-19:06:40 this program will create an Extract file for each Customer from the Journal database
ZBT006N-19:06:40 Running Under Windows Server 2008 R2 (build 7601 6.01 Service Pack 1) on platform x64
ZBT000N-19:06:40 Host is Little Endian
ZBT000N-19:06:40 Host is ASCII
ZBT000N-19:06:40 Binary is 64 bit
ZBT000N-19:06:40 Current Working Directory is C:\Windows\system32
ZBT004N-19:06:40 Today is Wednesday, August 02, 2017
ZBT005N-19:06:40 Running on vt-tapetrack
ZBT006N-19:06:40 Process ID 42468
ZBT000N-19:06:40 Parsing and validating command arguments
ZBT000N-19:06:40 Explicit date range requested as: M-1:m-1
ZBT000N-19:06:40 Start date interpreted as: Saturday, July 01, 2017
ZBT000N-19:06:40 End date interpreted as: Monday, July 31, 2017
ZBT000N-19:06:40 Days apart: 31
ZBT000N-19:06:40 Checking for Environment Variable 'ESPDATERANGEOFFSETFILE'
ZBT002N-19:06:40 Program Options:
ZBT002N-19:06:40        (C) Customer Map File=
ZBT002N-19:06:40        (H) Bill for Daily HighWater=false
ZBT002N-19:06:40        (R) Date Range=M-1:m-1
ZBT002N-19:06:40        (c) Customer Filter=*
ZBT002N-19:06:40        (h) Database home directory=C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db
ZBT002N-19:06:40        (m) Bill for multiple locations in one day=false
ZBT002N-19:06:40        (o) Output directory=c:\tmss\billing
ZBT002N-19:06:40        (p) Seconds between progress markers=5
ZBT002N-19:06:40        (v) Verbose Output=false
ZBT000N-19:06:40 Arguments parsed and validated with 0 errors
ZBT000N-19:06:40 Opening Database Environment
ZBT000N-19:06:42 Database Environment Open Status: BDB0062 Successful return: 0
ZBT000N-19:06:42 Journal Database Database Open Status: BDB0062 Successful return: 0
ZBT000N-19:06:42 Journal Date Database Database Open Status: BDB0062 Successful return: 0
ZBT000I-19:06:42 Looking up record number for fast forward
ZBT000I-19:06:42 Looking for date/time: Saturday, July 01, 2017 - 02:00:01
ZBT000I-19:06:42 Record 18632561 found with date/time of Friday, October 11, 2013 - 13:50:25
ZBT000I-19:06:48 Progress Point: 2013-10-21 16:43:22 (11 days processed)
ZBT000I-19:06:54 Progress Point: 2013-11-04 09:45:52 (25 days processed)
ZBT000I-19:07:00 Progress Point: 2013-11-19 06:23:21 (40 days processed)