Differences

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

--- billing:flow [2026/08/18 01:30] – created Scott Cunliffe
+++ billing:flow [2026/08/18 03:49] (current) – [TapeTrack Billing Full Flow Chart] Scott Cunliffe
@@ Line 1: / Line 1: @@
 ====== Billing Component Flow Chart ======
-TapeTrack Billing End To End Flow Chart
+===== TapeTrack Billing Overview Flow Chart =====
 {{billing_overview.png}}
+^ Stage ^ Component ^ Input ^ Process ^ Output ^
+| **Framework Server** | TapeTrack Framework Server and Journal | Tape movements, storage and other operational activity | Records operational activity as Journal database entries. | Journal records available for extraction. |
+| **Extract** | ''TMSS10LogStatsExtractDB'' | Journal records and the selected billing date range | Extracts relevant Journal activity and separates the statistics by customer. | Customer-specific ''Customer-ID.ttstats'' files. |
+| **Process** | ''TMSS10LogStatsProcess'' | TTSTATS files, Customer Map, Package Map and Billing Rules | Identifies the customer, selects the billing package, applies the approved rates and calculates the charges. | Billing XML containing invoice items, quantities, rates and totals. |
+| **QuickBooks Invoicing** | Desktop UI, XMLQuickBooks Mapping and QuickBooks Desktop | Approved Billing XML | Maps TapeTrack customers and items to QuickBooks records and submits the invoice request. | Draft QuickBooks customer invoice ready for review and issue. |
+===== TapeTrack Billing Full Flow Chart =====
+{{billing_flow_full.png}}
+^ Component                                                    ^ Input                                                          ^ Output or Purpose                                                                                                                               ^
+| **TapeTrack Framework Server**                               | Tape movements, storage and operational activity               | Records operational activity as entries in the Journal database.                                                                                |
+| **[[billing:Journal]]**                                                  | Activity recorded by the TapeTrack Framework Server            | Stores the source records used to calculate movement, handling and storage charges.                                                             |
+| **[[cli:tmss10logstatsextractdb|TMSS10LogStatsExtractDB]]**  | Journal database entries and the selected billing date range   | Extracts the relevant journal records and creates a separate TTSTATS file for each customer.                                                    |
+| **[[billing:ttstats|Customer-ID.ttstats]]**                                      | Customer statistics extracted from the Journal                 | Supplies the activity types and quantities processed during billing.                                                                            |
+| **[[billing:customer_map|Customer Map]]**                    | TapeTrack Customer-ID                                          | Maps the Customer-ID to the customer name or external accounting identity used in the billing output.                                           |
+| **[[billing:package_map|Package Map]]**                      | TapeTrack Customer-ID                                          | Selects the billing package assigned to the customer.                                                                                           |
+| **[[billing:billing_rules|Billing Rules]]** ''default.ttsdef''                         | Approved billing rates, calculations, rounding and conditions  | Defines how TTSTATS quantities are converted into invoice items and charges.                                                                    |
+| **[[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]**      | TTSTATS file, Customer Map, Package Map and Billing Rules      | Applies the billing configuration and generates invoice-item XML containing customers, item codes, descriptions, quantities, rates and totals.  |
+| **Billing XML**                                              | Output from TMSS10LogStatsProcess                              | Contains the calculated invoice items awaiting review and submission to QuickBooks.                                                             |
+| **[[billing:stylesheet|Stylesheet ''tapetrack.xslt]]''**     | Billing XML                                                    | Controls how the XML is displayed in the Desktop UI. It does not calculate or modify charges.                                                   |
+| **Desktop UI**                                               | Billing XML and Stylesheet                                     | Displays the calculated billing information for review and submits approved invoice requests.                                                   |
+| **XMLQuickBooks Mapping**                                    | Approved Billing XML                                           | Maps TapeTrack customer and item values to the corresponding QuickBooks customer and item records.                                              |
+| **QuickBooks Desktop**                                       | Mapped invoice request from the Desktop UI                     | Creates the customer invoice in QuickBooks.                                                                                                     |
+| **Invoice**                                                  | Customer, invoice items, quantities, rates and totals          | Provides the draft invoice that is reviewed, approved and issued to the customer.                                                               |
+{{tag> billing}}