Integration.TransactionType_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | TransactionType_Staging |
Transaction type staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Transaction Type Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Transaction_Type_Staging | Transaction Type Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59