Patent ID: 7707078

Claim:
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, and storing the account codes.