TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace:
cookbook:billing_process

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
cookbook:billing_process [2019/07/31 23:32] – [Billing Process] Scott Cunliffecookbook:billing_process [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 10: Line 10:
 ===== Extracting Data ===== ===== Extracting Data =====
  
-[[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] reads through the TapeTrack history tables and creates billing extract files within the date range specified when the program is called.+[[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] reads through the TapeTrack history tables and creates 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 [[object:customer|Customer]]. At the completion of the program you will have one .ttstats (TapeTrack Statistics) file for each TapeTrack [[object:customer|Customer]].
Line 21: Line 21:
   * ''-h "%TMSS10DB%"'' is the database location   * ''-h "%TMSS10DB%"'' is the database location
  
-<sxh>+<code>
 TMSS10LogStatsExtractDB -R M-1:m-1 -h "%TMSS10DB%" TMSS10LogStatsExtractDB -R M-1:m-1 -h "%TMSS10DB%"
-</sxh>+</code>
  
 ==== Output ==== ==== Output ====
Line 31: Line 31:
 US01.ttstats US01.ttstats
  
-<sxh> +<code> 
- +CUS02 
-</sxh>+ILTO 20201029000221000000 
 +SLTO LIBR20201029000220000000 
 +HLTO LIBR20201029000000000000 
 +SLTO OFFS20201029000001000000 
 +HLTO OFFS20201029000000000000 
 +ILTO 20201030000221000001 
 +SLTO LIBR20201030000220000001 
 +HLTO LIBR20201030000000000001 
 +SLTO OFFS20201030000001000001 
 +HLTO OFFS20201030000000000001 
 +ILTO 00000000000221000002 
 +SLTO LIBR00000000000440000002 
 +HLTO LIBR00000000000000000002 
 +SLTO OFFS00000000000002000002 
 +HLTO OFFS00000000000000000002 
 +</code>
  
 ===== Processing Data ===== ===== Processing Data =====
Line 59: Line 74:
     * Immediate @ $10.00     * Immediate @ $10.00
  
-<sxh>+<code>
 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
 # #
Line 80: Line 95:
 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
  
-AddStorageChargeItem("*", "US01", "DLT", "OFFS", 0, 0, 00000, 00000, 0, "$CUSTOMER", "$CUSTOMER2 STORAGE_OFFSITE", "DLT Vaulting Charge", 4, false); +AddStorageChargeItem( 
-AddStorageChargeItem("*", "US01", "LTO", "OFFS", 0, 0, 00000, 00000, 0, "$CUSTOMER", "$CUSTOMER2 STORAGE_OFFSITE", "LTO Cartridge Vaulting Charge", 5 , false);+ "*",  
 + "US01",  
 + "DLT",  
 + "OFFS",  
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "$CUSTOMER2 STORAGE_OFFSITE",  
 + "DLT Vaulting Charge",  
 + 4,  
 + false 
 + ); 
 + 
 +AddStorageChargeItem( 
 + "*",  
 + "US01",  
 + "LTO",  
 + "OFFS",  
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "$CUSTOMER2 STORAGE_OFFSITE",  
 + "LTO Cartridge Vaulting Charge",  
 + 5,  
 + false 
 + );
  
   
Line 94: Line 140:
 # Round Up Factor, <-- Round up factor e.g. if 10 number will be rounded up to nearest 10 # Round Up Factor, <-- Round up factor e.g. if 10 number will be rounded up to nearest 10
 # Minumum Units, <-- Minimum units to bill  # Minumum Units, <-- Minimum units to bill
-# Threshold, <-- Theshold value, only totals over this value are billed +# Threshold, <-- Threshold value, only totals over this value are billed
 # Cap, <-- Cap Value  # Cap, <-- Cap Value
 # Model, <-- Model number  # Model, <-- Model number
Line 105: Line 151:
 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
  
-AddMovementChargeItem("*", "US01", "DLT", "LIBR", "OFFS", 0, 0, 00000, 00000, 0, "$CUSTOMER", "$CUSTOMER2 to Vault", "DLT Transport Charge", 10, false); +AddMovementChargeItem( 
-AddMovementChargeItem("*", "US01", "LTO", "LIBR", "OFFS", 0, 0, 00000, 00000, 0, "$CUSTOMER", "$CUSTOMER2 to Vault", "LTO Transport Charge", 10, false);+ "*",  
 + "US01",  
 + "DLT",  
 + "LIBR",  
 + "OFFS",  
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "$CUSTOMER2 to Vault",  
 + "DLT Transport Charge",  
 + 10,  
 + false 
 + );
  
-AddMovementChargeItem("*", "US01", "DLT", "OFFS", "LIBR", 0, 0, 00000, 00000, 0, "$CUSTOMER", "Vault to $CUSTOMER2", "DLT Transport Charge", 10, false); +AddMovementChargeItem( 
-AddMovementChargeItem("*", "US011", "LTO", "OFFS", "LIBR", 0, 0, 00000, 00000, 0, "$CUSTOMER", "Vault to $CUSTOMER2", "LTO Transport Charge", 10, false); + "*",  
 + "US01",  
 + "LTO",  
 + "LIBR",  
 + "OFFS", 
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "$CUSTOMER2 to Vault",  
 + "LTO Transport Charge",  
 + 10,  
 + false 
 + ); 
 + 
 +AddMovementChargeItem( 
 + "*",  
 + "US01",  
 + "DLT",  
 + "OFFS",  
 + "LIBR",  
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "Vault to $CUSTOMER2",  
 + "DLT Transport Charge",  
 + 10,  
 + false 
 + ); 
 + 
 +AddMovementChargeItem( 
 + "*",  
 + "US011",  
 + "LTO",  
 + "OFFS",  
 + "LIBR",  
 + 0,  
 + 0,  
 + 00000,  
 + 00000,  
 + 0,  
 + "$CUSTOMER",  
 + "Vault to $CUSTOMER2",  
 + "LTO Transport Charge",  
 + 10,  
 + false 
 + );
   
   
Line 132: Line 244:
 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
  
-AddJournalChargeItem("*", "US01", "00001", 0, 0, 0, 0, 0, "$CUSTOMER", "Delivery Charge", "Express Delivery", 400,  false); +AddJournalChargeItem( 
-AddJournalChargeItem("*", "US01", "00002", 0, 0, 0, 0, 0, "$CUSTOMER", "Delivery Charge", "Over Night Delivery", 600,  false); + "*",  
-AddJournalChargeItem("*", "US01", "00003", 0, 0, 0, 0, 0, "$CUSTOMER", "Delivery Charge", "Immediate Delivery", 1000,  false);+ "US01",  
 + "00001",   
 + 0,  
 + 0,  
 + 0,  
 + 0,  
 + 0,   
 + "$CUSTOMER",  
 + "Delivery Charge",  
 + "Express Delivery",  
 + 400,   
 + false 
 + ); 
 + 
 +AddJournalChargeItem( 
 + "*",  
 + "US01",  
 + "00002",   
 + 0,  
 + 0,  
 + 0,  
 + 0,  
 + 0,  
 + "$CUSTOMER",  
 + "Delivery Charge",  
 + "Over Night Delivery",  
 + 600,   
 + false 
 + );
  
-</sxh>+AddJournalChargeItem( 
 + "*",  
 + "US01",  
 + "00003",  
 + 0,  
 + 0,  
 + 0,  
 + 0,  
 + 0,  
 + "$CUSTOMER",  
 + "Delivery Charge",  
 + "Immediate Delivery",  
 + 1000,   
 + false 
 + );
  
  
 + 
 +</code>
  
  
  
 +{{tag> cookbook}}
  
  
cookbook/billing_process.1564615954.txt.gz · Last modified: 2025/01/21 22:07 (external edit)