| name | value |
|---|---|
| name | FactInternetSalesReason |
| data source view | AdventureWorksDW |
| case sensitive | False |
| display expression | |
| friendly name | FactInternetSalesReason |
| db schema name | dbo |
| db table name | FactInternetSalesReason |
| type | Table |
| name | nulls | caption | data type | ordinal | unique | auto increment | auto increment seed | auto increment step | datetime mode | max length | is logical | db column name | computed column expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SalesOrderNumber | False | SalesOrderNumber | String | 0 | False | 20 | |||||||
| SalesOrderLineNumber | False | SalesOrderLineNumber | Byte | 1 | False | ||||||||
| SalesReasonKey | False | SalesReasonKey | Int32 | 2 | False |
| parent column | child column | relation name | nested |
|---|---|---|---|
| FactInternetSales. | FactInternetSalesReason. | FK_FactInternetSalesReason_SalesOrderNumber_SalesOrderLineNumber | False |
| name | object type | level |
|---|---|---|
| AdventureWorksDW | DataSourceView | 1 |
| AmoAdventureWorks | Database | 2 |