PuranOS Schema Catalog

tally_accounting

India accounting integration — Tally Prime company-period entries, P&L, vouchers, ledger snapshots. 17 tables, introspected live from the deployed database. Lifecycle: Operations.

Full-resolution SVG

Download DBML

Entity-relationship diagram

Overview below — open the full-resolution SVG to pan and zoom, or paste the DBML source into dbdiagram.io for an interactive view.

Table schemas

Each table has a JSON Schema (2020-12) with a canonical $id, generated by live introspection.

tally_actuals_export 14 cols

PK: actuals_export_id · 2 FKs

tally_company 11 cols

PK: company_id

tally_company_period 12 cols

PK: company_period_id · 1 FK

tally_group 14 cols

PK: group_id · 2 FKs

tally_ingestion_batch 10 cols

PK: ingestion_batch_id · 1 FK

tally_ledger 27 cols

PK: ledger_id · 2 FKs

tally_report_line 15 cols

PK: report_line_id · 4 FKs

tally_report_snapshot 12 cols

PK: report_snapshot_id · 2 FKs

tally_stock_item 17 cols

PK: stock_item_id · 1 FK

tally_voucher 39 cols

PK: voucher_id · 4 FKs

tally_voucher_line 28 cols

PK: voucher_line_id · 3 FKs

tally_voucher_line_bank_allocation 10 cols

PK: bank_allocation_id · 1 FK

tally_voucher_line_batch_allocation 12 cols

PK: batch_allocation_id · 1 FK

tally_voucher_line_bill_allocation 8 cols

PK: bill_allocation_id · 1 FK

tally_voucher_line_cost_centre_allocation 8 cols

PK: cost_centre_allocation_id · 1 FK

tally_voucher_line_rate_detail 8 cols

PK: rate_detail_id · 1 FK

tally_voucher_type 9 cols

PK: voucher_type_id · 1 FK

← Back to the schema catalog