Systems and methods for creating a database for accounting purposes
    7.
    发明申请
    Systems and methods for creating a database for accounting purposes 审中-公开
    用于创建用于会计目的的数据库的系统和方法

    公开(公告)号:US20050278295A1

    公开(公告)日:2005-12-15

    申请号:US11137531

    申请日:2005-05-26

    IPC分类号: G06F7/00 G06Q40/00

    CPC分类号: G06Q40/02

    摘要: A database is created for accounting purposes, which can be used to prepare financial statements for the organizational units of an enterprise. According to one method, document data records are saved from posting documents to a document database. The document data records include a document header and a data part. The data part includes entries for at least two items each of which include a posting amount and an account assigned thereto. Totals may be calculated from one or more posting amounts of the document data records saved, for the accounts assigned thereto. Furthermore, the totals may be saved to totals entries of a totals table.

    摘要翻译: 创建数据库用于会计目的,可用于为企业的组织单位准备财务报表。 根据一种方法,将文档数据记录从发布文档保存到文档数据库。 文档数据记录包括文档头和数据部分。 数据部分包括至少两个项目的条目,每个项目包括发布量和分配给它的帐户。 总计可以从保存的文档数据记录的一个或多个过帐金额计算,分配给其账户。 此外,总计可以保存到总计表的总计条目。

    Provision of data for data warehousing applications
    9.
    发明授权
    Provision of data for data warehousing applications 有权
    为数据仓库应用程序提供数据

    公开(公告)号:US08315974B2

    公开(公告)日:2012-11-20

    申请号:US12355717

    申请日:2009-01-16

    IPC分类号: G06F17/30

    摘要: A computer network architecture for making procurement-related information that has been generated on a transaction level available to data warehousing techniques is described. The network includes a transaction processing layer with at least one accounting component with a general ledger data base for centrally storing information contained in accounted-related data sets, a data warehousing layer and an additional data sourcing layer. A duplicator receives the data sets that will be or have been stored in the general ledger data base and delivers duplicates of those data sets that fulfil a predefined criteria in a procurement context. A source data base stores the duplicated data sets on a data line level. An extractor of the data sourcing layer interfaces with the data warehousing layer and selectively moves data contained in data lines or sets of data lines from the source data base to the data warehousing layer.

    摘要翻译: 描述了用于在数据仓储技术可用的事务级别上生成采购相关信息的计算机网络架构。 网络包括具有至少一个具有总分类帐数据库的计费组件的事务处理层,用于集中存储包含在占用相关数据集中的信息,数据仓储层和附加数据采集层。 复制器接收将被存储在总帐数据库中并已经存储在总分类帐数据库中的数据集,并且在采购上下文中提供满足预定义标准的数据集的重复。 源数据库将重复的数据集存储在数据线级上。 数据采集​​层的提取器与数据仓库层接口,并且将包含在数据线或数据线组中的数据从源数据库选择性地移动到数据仓库层。