|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactPurchaseOrderAmounts |
| Database Table Name | FactPurchaseOrderAmounts |
| Schema | dbo |
| Friendly Name | FactPurchaseOrderAmounts |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PurchaseOrderAmountSK |
PurchaseOrderAmountSK |
System.Int32 | ||
|
FiscalYearDateSK |
FiscalYearDateSK |
System.Int32 | ||
|
EntryDateSK |
EntryDateSK |
System.Int32 | ||
|
PayeeSK |
PayeeSK |
System.Int32 | ||
|
ZipCountySK |
ZipCountySK |
System.Int32 | ||
|
PurchaseOrderSK |
PurchaseOrderSK |
System.Int32 | ||
|
PurchaseOrderAmount |
PurchaseOrderAmount |
System.Decimal | ||
|
EncumberedBalance |
EncumberedBalance |
System.Decimal | ||
|
PaidAmount |
PaidAmount |
System.Decimal | ||
|
NumberOfItems |
NumberOfItems |
System.Int16 | ||
|
NumberOfChangeOrders |
NumberOfChangeOrders |
System.Int16 |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
ZipCountySK |
DimZipCounty |
Table |
False |
||
PayeeSK |
DimPayee |
Table |
False |
||
FiscalYearDateSK |
DimDate |
Table |
False |
||
EntryDateSK |
DimDate |
Table |
False |
||
PurchaseOrderSK |
DimPurchaseOrder |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
