|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimPurchaseOrder |
| Database Table Name | DimPurchaseOrder |
| Schema | dbo |
| Friendly Name | DimPurchaseOrder |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PurchaseOrderSK |
PurchaseOrderSK |
System.Int32 | ||
 |
PurchaseOrderAK |
PurchaseOrderAK |
System.String(12) | ||
|
FiscalYear |
FiscalYear |
System.String(4) | ||
|
PurchaseOrderNumber |
PurchaseOrderNumber |
System.String(8) | ||
|
PoStatusCode |
PoStatusCode |
System.String(4) | ||
|
PoStatus |
PoStatus |
System.String(30) | ||
|
ReceivingStatusCode |
ReceivingStatusCode |
System.String(3) | ||
|
ReceivingStatus |
ReceivingStatus |
System.String(30) | ||
|
PayStatusCode |
PayStatusCode |
System.String(3) | ||
|
PayStatus |
PayStatus |
System.String(30) | ||
|
PoTypeCode |
PoTypeCode |
System.String(4) | ||
|
PoType |
PoType |
System.String(30) | ||
|
BuyerId |
BuyerId |
System.String(3) | ||
|
Buyer |
Buyer |
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 |
PurchaseOrderSK |
FactPurchaseOrderAmounts |
Table |
False |
| Powered by BI Documenter |
