Differences

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

--- billing:flow [2026/08/18 01:52] – 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 Overview Flow Chart
+===== TapeTrack Billing Overview Flow Chart =====
 {{billing_overview.png}}
-TapeTrack Billing Full Flow Chart
+^ 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 ^
+^ Component                                                    ^ Input                                                          ^ Output or Purpose                                                                                                                               ^
-| **TapeTrack Framework Server** | Tape movements, storage and operational activity | Records operational activity as entries in the Journal database. |
+| **TapeTrack Framework Server**                               | Tape movements, storage and operational activity               | Records operational activity as entries in the Journal database.                                                                                |
-| **Journal** | Activity recorded by the TapeTrack Framework Server | Stores the source records used to calculate movement, handling and storage charges. |
+| **[[billing:Journal]]**                                                  | Activity recorded by the TapeTrack Framework Server            | Stores the source records used to calculate movement, handling and storage charges.                                                             |
-| **TMSS10LogStatsExtractDB** | Journal database entries and the selected billing date range | Extracts the relevant journal records and creates a separate TTSTATS file for each customer. |
+| **[[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.                                                    |
-| **Customer-ID.ttstats** | Customer statistics extracted from the Journal | Supplies the activity types and quantities processed during billing. |
+| **[[billing:ttstats|Customer-ID.ttstats]]**                                      | Customer statistics extracted from the Journal                 | Supplies the activity types and quantities processed during billing.                                                                            |
-| **Customer Map** | TapeTrack Customer-ID | Maps the Customer-ID to the customer name or external accounting identity used in the billing output. |
+| **[[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.                                           |
-| **Package Map** | TapeTrack Customer-ID | Selects the billing package assigned to the customer. |
+| **[[billing:package_map|Package Map]]**                      | TapeTrack Customer-ID                                          | Selects the billing package assigned to the customer.                                                                                           |
-| **Billing Rules** ''default.ttsdef'' | Approved billing rates, calculations, rounding and conditions | Defines how TTSTATS quantities are converted into invoice items and charges. |
+| **[[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.                                                                    |
-| **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. |
+| **[[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 XML**                                              | Output from TMSS10LogStatsProcess                              | Contains the calculated invoice items awaiting review and submission to QuickBooks.                                                             |
-| **Stylesheet** ''tapetrack.xslt'' | Billing XML | Controls how the XML is displayed in the Desktop UI. It does not calculate or modify charges. |
+| **[[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. |
+| **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. |
+| **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. |
+| **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. |
+| **Invoice**                                                  | Customer, invoice items, quantities, rates and totals          | Provides the draft invoice that is reviewed, approved and issued to the customer.                                                               |
+{{tag> billing}}