General ledger and accounts payable data model [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_Python百科

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

Improve this question

I am looking for industry standard logical data model of general ledger and accounts payable.

Are there any readily available accounting data models?

---

Hmmm, I learned the data model while I learned bookkeeping. If Google does not give you an answer, that might be the way to go.

The most basic ledger is 3 tables: Accounts, Batches, and Transactions. All transactions must be in a batch. Some people make two columns for debit and credit, I always did one column, with Debits and credits having opposite signs.

Payables is also very simple. At its heart is a table of vendors and a table of vouchers/invoices. Finally a table of checks generated. Unlike purchasing, payables does not require linking to inventory or any detail on the voucher, making it quite simple.

After that, embellish to taste :)

---

Core GL Transactional Tables:

• LEDGER
• JOURNAL_HEADER
• JOURNAL_LINE

The journals are validated before posting to the LEDGER table.

Core AP Tables:

• INVOICE
• CHECK
• VENDOR