Bill Counter Documentation

This document provides an overview of the bill counter mechanisms across modules within the system. The counters help track total bills, reference numbers, and module-specific transactions.

1. Global Bill Counter (Application Level)

Name: Bill Counter (Not Reference)
Description:
Tracks the total number of bills generated from the company. This represents the actual bill number, not a reference number.
Table Source:

select * from app.tbl_counter_bill_number

2. Front Office Module Bill Counters

2.A. Front Office Reference Number Counter

Description: Tracks the total reference counter specific to Front Office bills. Represents the count of reference numbers generated for FO bills.
Table Source:

select * from fo.tbl_counter_reference

2.B. Front Office External Bill Reference Number Counter

Description: Tracks external bill counters in the Front Office module.
- External (EXT) bill means: A VAT bill generated from POS that is later transferred to the Front Office. These bills are then cleared in FO using the EXT counter.
Table Source:

select * from fo.tbl_counter_extra_bill

3. Point of Sale (POS) Bill Counters

As the VAT bill number is centrally maintained in app.tbl_counter_bill_number, POS also maintains additional counters.

3.A. Reference Number for Outlet

Description: Tracks the total reference counters per outlet.
- A reference number is an outlet-wise unique bill count.
- Helps track bills specific to each POS outlet.
Table Source:

select * from pos.tbl_counter_outlet_reference_number where bill_counter_for = 'outlet_reference';

3.B. Outlet-wise Charge Transfer Bill Counter

Description: Tracks the count of charge transfer bills (not VAT bills) for each outlet.
- These represent transfers (e.g., to room or account) rather than VAT bills.
Table Source:

SELECT * FROM pos.tbl_counter_outlet_reference_number WHERE bill_counter_for = 'regular';