总帐和应付帐款数据模型 [英] General ledger and accounts payable data model

问题描述

我正在寻找总分类帐和应付帐款的行业标准逻辑数据模型。

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

是否有任何可用的会计数据模型？

Are there any readily available accounting data models?

推荐答案

嗯，我在学习簿记时学到了数据模型。如果Google没有给你答案，那可能就是这样。

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.

最基本的分类帐是3个表：帐户，批次和事务。所有交易必须是批量的。有些人为借记和贷记提供了两个列，我总是做了一个列，借方和贷方都有相反的迹象。

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.

之后，点缀品尝：）

这篇关于总帐和应付帐款数据模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！