|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimGlCode |
| Database Table Name | DimGlCode |
| Schema | dbo |
| Friendly Name | DimGlCode |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
GlCodeSK |
GlCodeSK |
System.Int32 | ||
 |
GlCodeAK |
GlCodeAK |
System.String(9) | ||
|
Glc |
Glc |
System.String(5) | ||
|
Qual2 |
Qual2 |
System.String(4) | ||
|
GlClassCode |
GlClassCode |
System.String(3) | ||
|
GlClass |
GlClass |
System.String(30) | ||
|
GlGroup |
GlGroup |
System.String(10) | ||
|
GlCategoryCode |
GlCategoryCode |
System.String(3) | ||
|
GlCategory |
GlCategory |
System.String(30) | ||
|
GlSubCategoryCode |
GlSubCategoryCode |
System.String(3) | ||
|
GlSubCategory |
GlSubCategory |
System.String(30) | ||
|
GlcDescription |
GlcDescription |
System.String(30) | ||
|
GlCodeName |
GlCodeName |
System.String(50) | ||
|
GlCodeSubTotalCode |
GlCodeSubTotalCode |
System.String(5) | ||
|
GlCodeSubTotal |
GlCodeSubTotal |
System.String(30) | ||
|
HrClassification |
HrClassification |
System.String(10) | ||
|
HrTimeStatus |
HrTimeStatus |
System.String(30) | ||
|
AccountSign |
AccountSign |
System.Int16 | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
GlCategoryCodeDesc |
System.String(36) | GlCategoryCode + ' - ' + GlCategory |
||
|
GlSubCategoryDescription |
System.String(36) | GlSubCategoryCode + ' - ' + GlSubCategory |
||
|
GlcCodeDescription |
System.String(38) | Glc + ' - ' + GlcDescription |
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 |
GlCodeSK |
FactPositionExpense |
Table |
False |
||
GlCodeSK |
FactPositionBudget |
Table |
False |
||
GlCodeSK |
FactCheckComponent |
Table |
False |
||
GlCodeSK |
FactGlTransactions |
Table |
False |
||
GlCodeSK |
FactGlSummaryBalances |
Table |
False |
||
GlCodeSK |
FactGlRollOverBalances |
Table |
False |
| Powered by BI Documenter |
