As suggested above, distributors, locations, and terminals may comprise a single flat layer, while merchants can have any number of nesting levels. [0043] To organize this structure in the database, each entity in this hierarchy can be uniquely specified by providing two data elements, such as the node ID and the node type.