Introduction
The account dimension table stores data related to purchase and sales codes used by your financial management package.
common.dimAccount
| Column Name | Description | Type | Is Unique |
|---|---|---|---|
| AccountKey | The primary key for the Accounts Table | int | Yes |
| Code | Account Code | int | Yes |
| Name | Account Name | nvarchar(320) | Yes |
| Active | It tells whether the account active or not | bool | No |
| IsTimeRecorded | Can people book time against this account | bool | No |
| IsRandD | Is this account used for research and development | bool | No |
| AccountCategory | How this account is categorized | nvarchar(320) | No |
| AccountType | Expense/Income | nvarchar(320) | No |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article