Billing and Charge-back

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 billing extract files within the date range specified when the program is called.

At the completion of the program you will have one .ttstats (TapeTrack Statistics) file for each TapeTrack customer.

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)

C1009
ILT  20170701000870000000
SLT  100920170701000225000000
HLT  100920170701000000000000
SLT  FBTW20170701000015000000
HLT  FBTW20170701000000000000
MLT  OFFSLIBR20170702000002000003

The Billing Calculation Module TMSS10LogStatsProcess

Cookbook: The Billing Process