|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimPayee |
| Database Table Name | DimPayee |
| Schema | dbo |
| Friendly Name | DimPayee |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PayeeSK |
PayeeSK |
System.Int32 | ||
 |
PayeeAK |
PayeeAK |
System.String(14) | ||
|
PayeeId |
PayeeId |
System.String(9) | ||
|
PayeeSequence |
PayeeSequence |
System.Int16 | ||
|
PayeeTypeCode |
PayeeTypeCode |
System.String(3) | ||
|
PayeeType |
PayeeType |
System.String(30) | ||
|
PayeeName |
PayeeName |
System.String(50) | ||
|
PayeeNameConsolidated |
PayeeNameConsolidated |
System.String(50) | ||
|
IsMinority |
IsMinority |
System.String(10) | ||
|
StateCode |
StateCode |
System.String(3) | ||
|
State |
State |
System.String(30) | ||
|
ZipCode |
ZipCode |
System.String(11) | ||
|
Country |
Country |
System.String(30) | ||
|
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 |
PayeeSK |
FactPurchaseOrderAmounts |
Table |
False |
||
PayeeSK |
FactPayableAmounts |
Table |
False |
| Powered by BI Documenter |
