|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimChartOfAccount |
| Database Table Name | DimChartOfAccount |
| Schema | dbo |
| Friendly Name | DimChartOfAccount |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
GlAccountSK |
GlAccountSK |
System.Int32 | ||
 |
YearGlAccountNumberAK |
YearGlAccountNumberAK |
System.String(29) | ||
|
GlAccountNumber |
GlAccountNumber |
System.String(30) | ||
|
FiscalYear |
FiscalYear |
System.String(4) | ||
|
AccountStatusCode |
AccountStatusCode |
System.String(3) | ||
|
AccountStatus |
AccountStatus |
System.String(10) | ||
|
StartDate |
StartDate |
System.DateTime | ||
|
EndDate |
EndDate |
System.DateTime | ||
|
IsAccountBudgeted |
IsAccountBudgeted |
System.String(3) | ||
|
BudgetPoolNo |
BudgetPoolNo |
System.String(9) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
GLAccountSK |
FactPositionExpense |
Table |
False |
||
GLAccountSK |
FactPositionBudget |
Table |
False |
||
GLAccountSK |
FactCheckComponent |
Table |
False |
||
GlAccountSK |
FactGlTransactions |
Table |
False |
||
GlAccountSK |
FactGlSummaryBalances |
Table |
False |
||
GlAccountSK |
FactGlRollOverBalances |
Table |
False |
| Powered by BI Documenter |
