Bill Counter Documentation for "BillCounter": "1"

---

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';

---