Dimension.Transaction Type
Documentation | WideWorldImportersDW |
Schema | Dimension |
Name | Transaction Type |
Modules | Movement, Transaction |
TransactionType dimension
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Transaction Type Key | int | Default: NEXT VALUE FOR [Sequences].[TransactionTypeKey] | DW key for the transaction type dimension | ||||
DW key for the transaction type dimension Default: NEXT VALUE FOR [Sequences].[TransactionTypeKey] |
||||||||
2 | WWI Transaction Type ID | int | Numeric ID used for reference to a transaction type within the WWI database | |||||
Numeric ID used for reference to a transaction type within the WWI database |
||||||||
3 | Transaction Type | nvarchar(50) | Full name of the transaction type | |||||
Full name of the transaction type |
||||||||
4 | Valid From | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
5 | Valid To | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
||||||||
6 | Lineage Key | int | Lineage Key for the data load for this row | |||||
Lineage Key for the data load for this row |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Fact.Movement | Dimension.Transaction Type | Fact.Movement.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key | FK_Fact_Movement_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key |
|
Fact.Movement.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key Name: FK_Fact_Movement_Transaction_Type_Key_Dimension_Transaction TypeForeign key constraint referencing Transaction Type.Transaction Type Key |
||||
Fact.Transaction | Dimension.Transaction Type | Fact.Transaction.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key | FK_Fact_Transaction_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key |
|
Fact.Transaction.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key Name: FK_Fact_Transaction_Transaction_Type_Key_Dimension_Transaction TypeForeign key constraint referencing Transaction Type.Transaction Type Key |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Dimension_Transaction_Type | Transaction Type Key | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. |
Used by
Name |
---|
Dimension.Transaction Type
|
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59