CN_GRP_Elim Table

Each row in this table describes the elimination groups defined in the parent attributes for the given entity scenario. These groups define a set of accounts that are not rolled up to the parent, such as intercompany accounts that should not be reported at the parent level.

For children, account groups to eliminate are created in the Child entities .For example, if v1000 is in Child A,B, and C, is included in an Account Group called "Eliminations" in only in children A and B, and selected in the Parent Attributes as an eliminations group based on child, then v1000 from Children A and B will eliminate, but Child C will consolidate. For parents, parent elimination account group(s) are created at the Parent and selected in Parent Attributes. Any accounts in these groups will be automatically zeroed out at the parent.

Table 22. The CN_GRP_Elim Table

Name

Type

Null

Key Description
IDIntegerNPK 
name nvarchar(255)NName of the group to eliminate
parent_attr_idIntegerNFKForeign key to the owning CN_ATTR_PARENT row