|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimGlTransDetail |
| Database Table Name | DimGlTransDetail |
| Schema | dbo |
| Friendly Name | DimGlTransDetail |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
GlDetailSK |
GlDetailSK |
System.Int32 | ||
 |
GlDetailAK |
GlDetailAK |
System.String(18) | ||
|
GlCalendarPeriod |
GlCalendarPeriod |
System.String(6) | ||
|
JournalNumber |
JournalNumber |
System.Int32 | ||
|
LineNumber |
LineNumber |
System.Int32 | ||
|
JournalTypeCode |
JournalTypeCode |
System.String(3) | ||
|
JournalType |
JournalType |
System.String(30) | ||
|
JournalGrouping |
JournalGrouping |
System.String(30) | ||
|
BudgetTypeCode |
BudgetTypeCode |
System.String(8) | ||
|
BudgetType |
BudgetType |
System.String(50) | ||
|
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 |
GlDetailSK |
FactGlTransactions |
Table |
False |
| Powered by BI Documenter |
