Geek asks and answers

General Ledger and Accounts Payable Data Model

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

Are credential models available?

+2
source share
3 answers

Hmmm, I studied the data model while I was studying accounting. If Google doesn't give you an answer, maybe this will be the way to go.

The most basic book is 3 tables: accounts, parties and transactions. All transactions must be in a batch. Some people make two columns for debit and credit, I always made one column, with debits and loans with opposite signs.

. /-. , . , - , .

:)

+2

- , .

, tblInvoiceDetail AP Expense Journal tblTransactions ( tblGeneralLedger). , , . , AR- , .

, , /GL addtl ( ).

?

+1

Core GL:

  • LEDGER
  • JOURNAL_HEADER
  • JOURNAL_LINE

LEDGER.

AP:

0

More articles:


All Articles