|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactGlTransactions |
| Database Table Name | FactGlTransactions |
| Schema | dbo |
| Friendly Name | FactGlTransactions |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
GlTransactionsSK |
GlTransactionsSK |
System.Int32 | ||
|
DateSK |
DateSK |
System.Int32 | ||
|
PostedDateSK |
PostedDateSK |
System.Int32 | ||
|
GlDetailSK |
GlDetailSK |
System.Int32 | ||
|
OrgUnitSK |
OrgUnitSK |
System.Int32 | ||
|
GlCodeSK |
GlCodeSK |
System.Int32 | ||
|
GlAccountSK |
GlAccountSK |
System.Int32 | ||
|
JournalAmount |
JournalAmount |
System.Decimal | ||
|
BudgetAmount |
BudgetAmount |
System.Decimal | ||
|
CommitmentAmount |
CommitmentAmount |
System.Decimal | ||
|
EncumbranceAmount |
EncumbranceAmount |
System.Decimal | ||
|
ActualsAmount |
ActualsAmount |
System.Decimal | ||
|
BudgetAmountDebit |
BudgetAmountDebit |
System.Decimal | ||
|
BudgetAmountCredit |
BudgetAmountCredit |
System.Decimal | ||
|
ActualsAmountDebit |
ActualsAmountDebit |
System.Decimal | ||
|
ActualsAmountCredit |
ActualsAmountCredit |
System.Decimal | ||
|
CommitmentAmountDebit |
CommitmentAmountDebit |
System.Decimal | ||
|
CommitmentAmountCredit |
CommitmentAmountCredit |
System.Decimal | ||
|
EncumbranceAmountDebit |
EncumbranceAmountDebit |
System.Decimal | ||
|
EncumbranceAmountCredit |
EncumbranceAmountCredit |
System.Decimal | ||
|
JournalAmountDebit |
JournalAmountDebit |
System.Decimal | ||
|
JournalAmountCredit |
JournalAmountCredit |
System.Decimal |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
GlDetailSK |
DimGlTransDetail |
Table |
False |
||
GlCodeSK |
DimGlCode |
Table |
False |
||
OrgUnitSK |
DimOrgUnit |
Table |
False |
||
GlAccountSK |
DimChartOfAccount |
Table |
False |
||
PostedDateSK |
DimDate |
Table |
False |
||
DateSK |
DimDate |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
