×

Method and apparatus for mapping dimension-based accounting entries to allow segment-based reporting

  • US 7,707,078 B2
  • Filed: 03/26/2004
  • Issued: 04/27/2010
  • Est. Priority Date: 03/26/2004
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method comprising:

  • accessing a dimension-based accounting database that defines multiple dimensions;

    selecting a plurality of dimensions from the dimension-based accounting database for a segment-based account code structure;

    defining an order for the plurality of selected dimensions;

    defining the segment-based account code structure based on the order; and

    a processor constructing a plurality of account codes based on the segment-based account code structure and the dimension-based accounting database by;

    searching a table in the dimension-based accounting database comprising a separate dimension column for each dimension in the plurality of selected dimensions and at least one balance column for rows in the table that have a value in the at least one balance column;

    for each row that has a value in the at least one balance column, retrieving a dimension value from a respective dimension column in the table for each dimension in the plurality of selected dimensions;

    for each row that has a value in the at least one balance column, placing the values from the dimension columns in the order defined by the segment-based account code structure to construct an account code, andstoring the account codes.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×