Designing Database that required Chart of Accounts
Posted on 2009-04-29
I am designing the app which required the Chart of Accounts (finance cost centre). I want to basically to have a flexibility for any business models.
So far I found that any business models (industry) can have:
1. Manufacturing Services:
XX - XXX - XXX - XXX - XXX - XXX - XXX
Company - Cost Centre - Account - Product - Product Line - Sub Account
2. Distribution (News)
XX - XXX - XX - XX - XXX
Division - Account - Region - Story - Distribution
XXX - XXXX - XX - XXXX - XX
Company - Accounts - Department - Projects - Project Type
My understanding that each XX can be considered as SEGMENTS.
1. I can have tables which containing 15 SEGEMENTS .... the assumption I won't the company has more than 15 SEGMENTS.
2. Or make it dynamically which is having ParentID/ID relationshi into a single SEGMENT table.
Some consideration ... in the transaction table I will record the full code of segment for instance AAA-123-XXX-123-70303. Also, considering for reporting, do the roll up report for instance for company/division/business units.
This is not accounting software though ... it's just a billing but require chart of account.