Account Table

Identifies the accounts in the entity.

Table 15. The Account Table

Attribute

Data Type

Definition

AccountID

int

A key identifying a specific account in the entity.

AccountLabel

nvarchar

A string containing the name of the account.

NativeDataType

nvarchar

Indicates the data type stored in the account.

Valid Values:

  • N - number

  • S - string

AggregationRule

nvarchar

Stores the aggregation rule.

Valid Values:

  • N

    Non-account

  • B

    Balance

  • F

    Flow account

  • A

    Rate

  • D

    Discount rate

  • R - r

    Ratio

AccountParentID

int

For related accounts and subaccounts, this stores the key of the account to which this specific account aggregates.