|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimPayable |
| Database Table Name | DimPayable |
| Schema | dbo |
| Friendly Name | DimPayable |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PayableSK |
PayableSK |
System.Int32 | ||
 |
PayableAK |
PayableAK |
System.String(12) | ||
|
FiscalYear |
FiscalYear |
System.String(4) | ||
|
PayableNumber |
PayableNumber |
System.String(8) | ||
|
OriginCode |
OriginCode |
System.String(4) | ||
|
Origin |
Origin |
System.String(30) | ||
|
ReferenceTypeCode |
ReferenceTypeCode |
System.String(4) | ||
|
ReferenceType |
ReferenceType |
System.String(30) | ||
|
ReferenceNumber |
ReferenceNumber |
System.String(20) | ||
|
PaymentTypeCode |
PaymentTypeCode |
System.String(3) | ||
|
PaymentType |
PaymentType |
System.String(30) | ||
|
PaymentTypeNumber |
PaymentTypeNumber |
System.String(15) | ||
|
PayableStatusCode |
PayableStatusCode |
System.String(3) | ||
|
PayableStatus |
PayableStatus |
System.String(30) | ||
|
PayableDate |
PayableDate |
System.DateTime | ||
|
PaymentDate |
PaymentDate |
System.DateTime | ||
|
PaymentXrefNbr |
PaymentXrefNbr |
System.String(12) | ||
|
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 |
PayableSK |
FactPayableAmounts |
Table |
False |
| Powered by BI Documenter |
