SDM IT 7/9/2026 10:25:16 PM This integration of AI is something I have been dreaming of for the past years.
I am the single person handling the business' data management needs. On Teamdesk, I can construct a DB with an initial basic aim, put it into operation, gather feedback and new scope, then improve it. However, in making rapid changes I often skipped documenting the changes, let alone writing and rewriting the DB description and functional spec. I have been thinking how troublesome it would take a new developer to take over the databases. And I thought it would be best to have AI browse my database structure and write the description for the new developer.
Today I have see that my wish is fulfilled. I asked the AI assistant to write a functional specification of the database, I got the following:
"Detailed Functional Specification
Database: KAS & BANK
1. Purpose
The KAS & BANK database is configured to automate the handling of cash and bank accounting source data. Its purpose is to:
- maintain master data for bank accounts and cash books
- ingest bank statements and cash transaction imports
- parse and organize transaction details by source format
- compare source totals against calculated detail totals
- flag discrepancies for review
- control access per account/book and per user
- prepare and post validated data into Odoo
The database description explicitly states “Cash/Bank Data Accounting Automation” on Database properties. TeamDesk databases typically represent business processes through linked tables and role-specific interfaces, which is consistent with this design 1 2.
2. High-Level Functional Scope
The database supports two main operational domains:
2.1 Bank processing
Handled through:
BANK
Bank Statement
bank-specific detail tables:
_BCA
_MANDIRI
_BRI_CMS
_BRI_QLOLA
2.2 Cash-book processing
Handled through:
KAS
Kas_Bulan
Kas_Kegiatan
Kas_Kegiatan_Import
2.3 External accounting integration
Handled through:
- Odoo fields and URL formulas in BANK columns
- Odoo fields and URL formulas in Bank Statement columns
- Odoo-related support tables:
- Odoo Data
_Odoo_accounts
_Odoo_partners
_Odoo_products
_Odoo_statement_line
_Odoo_taxes
User_Odoo_accounts
...
"
Wow, this is just fantastic! I cannot write a better introduction than this.
Thank you for the great new feature, Teamdesk!
| 
